size of cell comments
JohnCombine
I have noticed an upper limit on the length of a string that can be
written in a cell comment.
If a string longer than 8219 characters is written using
$worksheet->write_comment(), then the file becomes corrupt, and excel
must 'fix' it to load (stripping out all formats and comments, showing
raw data only). Excel itself can handle longer comments.
This only became an issue for me when I upgraded from v0.43 to v2.17 of
Spreadsheet::WriteExcel. v0.43 can write those long comments just
fine, but v2.17 creates a corrupt file.
This upper limit is not documented anywhere that I can find. Is there
any additional information you can think of about this issue?
Thank you
jmcnamara
> John:
> I have noticed an upper limit on the length of a string that can be
> written in a cell comment.
>
> If a string longer than 8219 characters is written using
Hi John,
A bug I'm afraid.
I'll try fix it for the next release.
John.
--
jmcnamara
Can you try the following fix and let me know how it works out:
http://homepage.eircom.net/~jmcnamara/perl/prerel/Spreadsheet-WriteExcel-2.17.4.tar.gz
John.
--
JohnCombine
My example, with about 9000 latin1 characters printed fine, and the
resultant file is uncorrupted.
Are there new limits to size of the comment field with this new
version?
And, is my assumption correct that this limit is halved when writing
utf8 characters?
jmcnamara
> The worked as expected.
>
> My example, with about 9000 latin1 characters printed fine, and the
> resultant file is uncorrupted.
>
> Are there new limits to size of the comment field with this new
> version?
Hi,
Thanks for testing it.
The string limit should be 32k characters although I haven't checked
that yet.
> And, is my assumption correct that this limit is halved when writing
> utf8 characters?
The limit is in characters, not bytes, so the limit is the same for
ASCII or UTF-8.
John.
--