Skip to Content

Excel column width truncating to 256 characters

Hi,

I'm trying to create an excel spreadheet using FM XXL_FULL_API. One of the fields in my table is long text that can be up to 1000 characters long. The spreadsheet creates OK but the long text is truncated at 256 charcaters. There are some old posts around that say this is a restriction in Excel 2003 but I don't think this applies anymore. I'm using 2007 and you can certainly type more than 256 characters in a cell. Does anybody know how I can overcome this truncation when using XXL_FULL_API ?

Many thanks

Rous....

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2011 at 05:48 PM

    I'd recommend setting a breakpoint in function module XXL_FULL_API and watching what it does. Even though it appears that the 256 limitation is removed, there are still places in the code where 256 column width appears to be enforced. This might apply in your situation.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.