[ic] XLS multi-table EXPORT 255 char limit issue.

Reid Sutherland interchange-users@icdevgroup.org
Fri Sep 6 08:59:03 2002


Dan Browning wrote:
> At 04:25 PM 9/5/2002 -0400, you wrote:
> 
>> Hi,
>>
>> When I use the multi-table export to XLS feature in IC, any comment 
>> field over 255 chars gets truncated and replaced with high-ASCII 
>> chars.  Now I read a thread about this issue, but it didn't explain 
>> much about a fix.  I've check my version of Spreadsheet::WriteExcel 
>> and it does support Excel 97+.  I've also tried messing with some of 
>> the default values of 255 and moving them to higher numbers, but 
>> nothing seems to resolve it.
>>
>> Any ideas?
>>
>> -reid
> 
> 
> In the export is an option "Max String Length 255" which you can change 
> to 16384.


Sorry, I didn't mention that I did do this already.

-reid