The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Dissapearing worksheets		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Sprockets

USA
Posts
Posted - 07/30/2007 :  9:08:31 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 6.0
Operating System: Win XP SP2

Often when opening up a previously made worksheet in an origin project the worksheet appears blank. There is one blank row of cells on the far left and nothing else. Sometimes I can see the data again by refreshing the window, or closing and reopening the project. Sometimes nothing I do can make the data visible. I've tried duplicating the worksheet, exporting it, doesn't work.
The data is still there, I can see it listed in the Project Explorer and all the graphs that are based on that worksheet are still there and unchanged.
Any suggestions??

Mike Buess

USA
3037 Posts
Posted - 07/30/2007 :  10:26:35 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Wow, never heard of that happening. Try entering the following command in the script window...

doc -e W {x1=0; y1=0};

Mike Buess
Origin WebRing Member
Go to Top of Page

Sprockets

USA
Posts
Posted - 07/30/2007 :  10:40:41 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks for your suggestion, but that didn't help.

I think it may have to do with the Column Width. Often when the Worksheet decides to appear again the first column will have a huge column width > 1000. So I just change it back to 10 or so. But at this point I can't even find a column to click on the open the Columns property window to change the Width.

Is there a command to change the Column Width of all columns I could try?
Go to Top of Page

Mike Buess

USA
3037 Posts
Posted - 07/31/2007 :  08:52:14 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Often when the Worksheet decides to appear again the first column will have a huge column width > 1000.
That's even stranger. Try this...

doc -e W {loop(i,1,wks.ncols) {wks.col$(i).width=10}};

Mike Buess
Origin WebRing Member
Go to Top of Page

Sprockets

USA
Posts
Posted - 07/31/2007 :  1:21:47 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hey, that worked! Thank you!!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000