Summary: | Cell Value - String 32,767 Character Limit | ||
---|---|---|---|
Product: | POI | Reporter: | smashew <mhager> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | minor | ||
Priority: | P2 | ||
Version: | 3.10-FINAL | ||
Target Milestone: | --- | ||
Hardware: | Macintosh | ||
OS: | All |
Description
smashew
2014-05-30 04:09:56 UTC
In HSSFCell, we have the following logic: throw new IllegalArgumentException("The maximum length of cell contents (text) is 32,767 characters"); I'd suggest we just apply the same in XSSF too, if you could do a patch and a unit test that'd be great! Nick, Thank you very much for the reply. I will create a patch this weekend after I get done with my work. :o) Great work team, doing a lot of work over at Apache Streams (Incubating) and this will make a great addition. If you spot any issues with the docs, or areas where extra examples would be helpful, whilst doing your Streams work we'd be delighted to have updates :) Hi, I've run into the same problem while working with apache POI 3.9-20121203. One thing that I'd like to note here is that apache poi doesn't have any problems reading back the content of the cell and the conent is exactly what is stored before. The file though is unusable by Microsoft Excel and what I've observed is that once we decide to let Excel recover the contents then the cell contents are truncated. |