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
 Worksheet Names?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

C.Walter

Germany
Posts

Posted - 03/12/2007 :  05:34:59 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version : 7.5
Operating System: WinXp SP2

I tried to find anything related to this "problem" but i was not succesfull (not in this forum and not in google).
The problem is:

What actually are the requirements for names in Origins Worksheets? It seems to differ from time to time and that is really annoying. Sometimes I can get 10 characters to work, but sometimes I´m only allowed to use 7 and thats way to less. Whats the hidden parameter which defines that? Sometimes it even happens that when I change a name, a window that say "name not allowed, choose another one" pops up and if I reenter the same name I wrote before, it suddenly works.

And some other questions:

1. Why am I not allowed to start a worksheet name with a number?
2. Why is it not allowed to have some _ within the worksheet names?

Thanks for all help.

Regards,

Christian Walter

Mike Buess

USA
3037 Posts

Posted - 03/12/2007 :  08:13:20 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Christian,

The maximum length of a worksheet name is determined by two factors: (1) It can never contain more than 13 characters and (2) the sum of the number of characters in the worksheet and column names cannot exceed 23. The latter restriction is actually on the length of a dataset name, wksName_colName.

http://www.originlab.com/www/support/resultstech.aspx?ID=1103&language=English#OBJ

1. Not sure, but that's been the case since I started using Origin (3.0).
2. The dataset name of a column is wksName_colName so allowing '_' in worksheet or column name would lead to (LabTalk) programming errors.

Mike Buess
Origin WebRing Member
Go to Top of Page

C.Walter

Germany
Posts

Posted - 03/19/2007 :  06:55:17 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
thx for the help, this seems to solve some of my problems.

But one question remains. If "_" arent allowed because of some programming errors, why am I not allowed to use "-" oder "." ore some other sign to optically divide two words from each other?
Because this makes working with different Worksheets quite hard(e.g. data for the same sample from different dates etc.).
Or is there another way to achieve that?
Go to Top of Page

Mike Buess

USA
3037 Posts

Posted - 03/19/2007 :  08:00:18 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Christian,

quote:
But one question remains. If "_" arent allowed because of some programming errors, why am I not allowed to use "-" oder "." ore some other sign to optically divide two words from each other?
Special characters are not allowed in any window or column name. I use the window/column label as a description or "long name".

Mike Buess
Origin WebRing Member
Go to Top of Page

C.Walter

Germany
Posts

Posted - 03/19/2007 :  10:13:31 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
well, in graphs it is allowed. And that is why it seems a bit strange to me that worksheet names are not allowed to use special characters.
But ok, I will try it with the Labels then..
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