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

Dan Browning interchange-users@icdevgroup.org
Thu Sep 5 16:39:01 2002


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.

/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
Do you realize how many holes there could be if people would just take
the time to take the dirt out of them?