Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
MIME-Version: 1.0
References: 
 <CAM=6N-F7ny+Z18fV1UkkJcEUL2A6P97ocXOPgXeaQsRzE63Dqw@mail.gmail.com>
 <CAM=6N-Fdd+qMhKdrbZVU=YMjvFmpCMepobc8_45WGkR62d5BMQ@mail.gmail.com>
In-Reply-To: 
 <CAM=6N-Fdd+qMhKdrbZVU=YMjvFmpCMepobc8_45WGkR62d5BMQ@mail.gmail.com>
From: =?UTF-8?Q?Adri=C3=A1n_Schwartzkopf?= <schwartzkopf.adrian@gmail.com>
Date: Tue, 29 Mar 2016 13:08:12 +0000
Message-ID: 
 <CAM=6N-EUn16QawBjH1FP_HnqHbDmuO5ZXQNFMAJOGKOkb1tBRQ@mail.gmail.com>
Subject: Re: Apache POI 3.14 Exception - The maximum column width for an
 individual cell is 255 characters.
To: user@poi.apache.org
Content-Type: multipart/alternative; boundary=001a1136fcbc4e5a35052f2fb93d

--001a1136fcbc4e5a35052f2fb93d
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello,

I already found an answer in the Documentation:

https://support.office.com/en-us/article/Excel-specifications-and-limits-16=
c69c74-3d6a-4aaf-ba35-e6eb276e8eaa

and

*https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.htm=
l#setColumnWidth(int,%20int)
<https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.htm=
l#setColumnWidth(int,%20int)>*

Thank you and have a nice day.

Br,
Adrian


Adri=C3=A1n Schwartzkopf <schwartzkopf.adrian@gmail.com> ezt =C3=ADrta (id=
=C5=91pont:
2016. m=C3=A1rc. 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.ja=
va:274)*
>
>
>
> As I understand there was a Bug by the HssfSheet regarding this in the ol=
der versions of POI, but it should be fixed: http://apache-poi.1045710.n5.n=
abble.com/autoSizeColumn-setColumnWidth-passed-255-td4759807.html
>
>
> Have you an idea how can I fix this?
>
>
> Thank you.
>
>
> Br,
>
> Adrian
>
>
>
>

--001a1136fcbc4e5a35052f2fb93d--