WG: hat is the maximum text length a cell can hold?

["KHZ (SAW)" <ka...@sawag.com>]

Hi Sathiyan.

For putting your question the BiffViewer output had to be removed.

I'ld guess that there's no extra limitation from POI.

Look for "Excel limitations" in e.g. google.

There is
	Philipp von Wartburg [philipp.von.wartburg@bluewin.ch]
who was written down several limitations.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Sathiyan Seran [mailto:sathiyan@gmail.com] 
Gesendet: Mittwoch, 29. September 2004 16:54
An: acoliver@apache.org; karl-heinz.zengerle@sawag.com
Betreff: hat is the maximum text length a cell can hold?

Hi,

Sorry for sending this to personal email address. When I send email to
Poi
user list it was not going through.

Is there is any maximum text length a Cell can hold?
In my application, I set cell value to string which is more then 8000
characters.
When I open the file, below warning message is displayed in excel:-
--------------------------------------------------------------------
Errors were detected in file 'xxx.xls', but Microsoft Excel was able
to open the file making repairs listed below. Save the file to make
these repairs permanent.

The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted.
---------------------------------------------------------------------

When I ran BiffViewer on that xls file I see [SST] list, where my big
text is displayed and in that text "?" is added after 7596 character.

I am not able to reproduce this in problem in standalone program.

If this big text is not added to Excel file every this fine.

Note :
Using POI 2.0 Final
Setting cell encoding to ENCODING_COMPRESSED_UNICODE.

Attached BiffViewer dump.

Thanks,
-Sathiyan



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org