August 25, 2008, 10:09 AM
DgraffSending a report to EXL2k large field being truncated
I have a field that is defined as A3968. When I create my report in EXCEL the field is truncated and can not be printed in its entireity. My guess is I only need about 2000 characters of the 3968 but it seems to be truncating somewhere around 1200 depending on spaces and how the data was entered. Any sugestions?
Thanks
August 25, 2008, 10:25 AM
susannahDuane,
split it into 3 fields;
but first, how many characters can your version of excel hold in a given cell? Have you tested that, so that you know exactly where the problem lies?
-s
August 25, 2008, 11:12 AM
<JG>Microsoft Excel 7.0 (95)
-----------------------------------------
· Maximum Sheet Size: 16,384 rows by 256 columns
· Column Width: 0 to 255 characters
· Maximum length of cell contents (text): 255 chacters
Microsoft Excel 8.0 (97)
--------------------------------------------
· Maximum Sheet Size: 65,536 rows by 256 columns
· Column Width: 0 to 255 characters
· Maximum length of cell contents (text): 32,000 characters
Microsoft Excel 2000
--------------------------------------------
· Worksheet size: 65,536 rows by 256 columns
· Column Width: 255 characters
· Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Microsoft Excel 2007
--------------------------------------------
· Worksheet size: 1M rows by 16k columns
· Column Width: 32,767 characters
· Length of cell contents (text): 32,767 characters.