Excel column width truncating to 256 characters

[Former Member]

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....

[Former Member]

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....

[Former Member]

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.

[Former Member]

Yes I think this is the case. Ultimately the data field in my interenal table is moved to a field called contentsitem-value which is defined as type soi_generic_item-value which is defined in type-pool soi as have 256 characters.....That's why it's truncating. So I suppose my question really is has anybody else come across this problem with XXL_FULL_API truncating Excell cells to 256 characters and if so how did they get round it.

Thanks

Rous

[Former Member]

This you can overcome by creating/generating the excel on your own using the xml instead of depending on XXL_FULL_API