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
 Text size limitation in worksheet cells
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

elelab

USA
8 Posts

Posted - 03/20/2003 :  11:29:00 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
This may be a bit off-the-wall, but any help is appreciated. Text imported into a worksheet seems to be truncated to 24 characters in each cell, and I'd like to increase that limit by a byte or two. I've tried setting the column display width to 32 and the column type to "Text", but still run into the 24 character truncation. Any ideas? (Origin is an order of magnitude or two faster than Microsoft Word at sorting and reordering columns of text. In fact, if the number of rows (or paragraphs) gets up around 15,000 or so, Word can't handle a sort, whereas Origin just blasts right through it.)

Thanks.

Lorraine

USA
66 Posts

Posted - 03/20/2003 :  2:32:06 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello!

I tried to reproduce this problem using Origin 7 (our latest version) but am unable to as I can import ASCII files with columns containing up to 52 characters (so far, have not yet found the maximum).

What version of Origin are you using?

Lorraine
OriginLab Technical Support
Go to Top of Page

Lorraine

USA
66 Posts

Posted - 03/20/2003 :  3:12:19 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Is your ASCII file delimited or fixed width?

Lorraine
OriginLab Technical Support
Go to Top of Page

Lorraine

USA
66 Posts

Posted - 03/20/2003 :  3:23:33 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
OK with further investigation, we found this is a bug with fixed width. Will incorporate fix into Origin 7 SR4.

Thank you for bringing this to our attention.

Lorraine
OriginLab Technical Support
Go to Top of Page

elelab

USA
8 Posts

Posted - 04/01/2003 :  11:31:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Lorraine,

Thanks for your prompt attention to my query. I was out of town so I didn't see your reply until today. I also found that if I leave the column as "Text and numeric" rather than setting it to "Text", which seemed to be appropriate initially, then I can import >70 characters into each column, which is quite enough for my task.
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