poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javen O'Neal" <javenon...@gmail.com>
Subject Re: Apache POI 3.14 Exception - The maximum column width for an individual cell is 255 characters.
Date Tue, 29 Mar 2016 14:56:21 GMT
As Adrián mentioned, 255 characters is an Excel format limitation that POI
adheres to.

Did you get this exception from calling setCellWidth or autoSizeColumn? The
former should raise an exception, but the latter should probably quietly
clip the auto-sized column width to 255 characters if best fit width is
wider.

Please open a bug at bz.apache.org/bugzilla iff autoSizeColumn throws an
illegal value error if best-fit-width exceeds 255 characters.
On Mar 29, 2016 6:08 AM, "Adrián Schwartzkopf" <
schwartzkopf.adrian@gmail.com> wrote:

> Hello,
>
> I already found an answer in the Documentation:
>
>
> https://support.office.com/en-us/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa
>
> and
>
> *
> https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html#setColumnWidth(int,%20int)
> <
> https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html#setColumnWidth(int,%20int)
> >*
>
> Thank you and have a nice day.
>
> Br,
> Adrian
>
>
> Adrián Schwartzkopf <schwartzkopf.adrian@gmail.com> ezt írta (időpont:
> 2016. márc. 29., K, 15:29):
>
> >
> > Hello,
> >
> > I actually use Apache POI 3.14  to generate an *SXSSFWorkbook* with
> > *SXSSFSheet*.
> > I use the sheet.*trackAllColumnsForAutoSizing();* option and the
> > *workbook.write(out);* method to write the XLS to an outpustream, but I
> > become the following Exception:
> >
> >
> > *Caused by: java.lang.IllegalArgumentException: The maximum column width
> for an individual cell is 255 characters.
> >       at
> org.apache.poi.xssf.usermodel.XSSFSheet.setColumnWidth(XSSFSheet.java:2386)
> >       at
> org.apache.poi.xssf.streaming.SXSSFSheet.setColumnWidth(SXSSFSheet.java:274)*
> >
> >
> >
> > As I understand there was a Bug by the HssfSheet regarding this in the
> older versions of POI, but it should be fixed:
> http://apache-poi.1045710.n5.nabble.com/autoSizeColumn-setColumnWidth-passed-255-td4759807.html
> >
> >
> > Have you an idea how can I fix this?
> >
> >
> > Thank you.
> >
> >
> > Br,
> >
> > Adrian
> >
> >
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message