You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by fanfy <el...@everlight.ro> on 2014/04/08 20:19:08 UTC
xls maximum number of comments
Hello,
I'm using poi (HSSF) to generate/alter some excel files and in this process
I want to tag some cells with comments. It seems that the maximum number of
comments is 1023? As a simple testcase I tried to create cell comments in a
loop for the first column. Before saving the workbook cell.getCellComment()
return my comments for all the rows. But after saving/reloading to/from disk
not all the comments exist (for example if I generate comments from row 1 to
1030 after loading the saved file I have comments starting from row 6 to
1029). It's like only the last 1023 comments are actually saved.
Can anyone help me with an answer? Is there a limitation?
Thank you.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/xls-maximum-number-of-comments-tp5715408.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: xls maximum number of comments
Posted by fanfy <el...@everlight.ro>.
I just reported a bug:
https://issues.apache.org/bugzilla/show_bug.cgi?id=56380
Thank you
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/xls-maximum-number-of-comments-tp5715408p5715423.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: xls maximum number of comments
Posted by Dominik Stadler <do...@gmx.at>.
Yes, it sounds like a bug,
Can you enter an entry for this at
https://issues.apache.org/bugzilla/buglist.cgi?product=POI, preferably
with a self-contained unit test which creates too many comments,
stores and re-reads the file and fails when the comments are not there
the same way as before.
Thanks... Dominik.
On Wed, Apr 9, 2014 at 8:55 AM, fanfy <el...@everlight.ro> wrote:
> This is not an excel limitation. I can insert comments using libreoffice
> without a problem. Something happens when saving the file with poi. Only the
> last 1023 comments are saved, all others are deleted.
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/xls-maximum-number-of-comments-tp5715408p5715410.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: xls maximum number of comments
Posted by fanfy <el...@everlight.ro>.
This is not an excel limitation. I can insert comments using libreoffice
without a problem. Something happens when saving the file with poi. Only the
last 1023 comments are saved, all others are deleted.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/xls-maximum-number-of-comments-tp5715408p5715410.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org