Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
Date: Wed, 09 May 2012 19:04:59 -0400
From: Aram Mirzadeh <awm@mbcli.com>
Subject: Re: [Bug 53209] Too many styles corrupts the excel
In-reply-to: <bug-53209-47293-RkoIhno0Sr@https.issues.apache.org/bugzilla/>
To: POI Developers List <dev@poi.apache.org>
Cc: bugzilla@apache.org
Message-id: <4FAAF81B.4010305@mbcli.com>
MIME-version: 1.0
Content-type: text/plain; charset=UTF-8; format=flowed
Content-transfer-encoding: 7BIT
References: <bug-53209-47293@https.issues.apache.org/bugzilla/>
 <bug-53209-47293-RkoIhno0Sr@https.issues.apache.org/bugzilla/>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428
 Thunderbird/12.0.1


Hi,

But does that number apply to the "number" of styles defined, or the 
number of times the style is applied?

The code only defines about a dozen styles.  I simply just applied the 
same style to all cells.

Aram

On 5/9/2012 5:35 PM, bugzilla@apache.org wrote:
> https://issues.apache.org/bugzilla/show_bug.cgi?id=53209
>
> Nick Burch<nick.burch@alfresco.com>  changed:
>
>             What    |Removed                     |Added
> ----------------------------------------------------------------------------
>               Status|NEW                         |NEEDINFO
>                   OS|                            |All
>
> --- Comment #2 from Nick Burch<nick.burch@alfresco.com>  ---
> In HSSF, we have a maximum number of styles, and throw an exception if someone
> tries to add more than that
>
>      /**
>       * The maximum number of cell styles in a .xls workbook.
>       * The 'official' limit is 4,000, but POI allows a slightly larger number.
>       * This extra delta takes into account built-in styles that are
> automatically
>       * created for new workbooks
>       *
>       * See
> http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
>       */
>      private static final int MAX_STYLES = 4030;
>
> The .xlsx file format also has a maximum number of styles, but it doesn't look
> like we enforce that in the same way. From a quick check, neither
> XSSFWorkbook.createCellStyle() nor StylesTable appears to have the check
>
> The fix is probably for someone to dig out the official maximum number of
> styles in a .xlsx file, from the file format docs, then implement a similar
> check in xssf
>


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org