Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: unknown (athena.apache.org: error in processing during lookup of
 mevans@alphatheory.com)
From: Matthew Evans <mevans@alphatheory.com>
To: "user@poi.apache.org" <user@poi.apache.org>
Subject: Cell Formatting in Excel 2013?
Thread-Topic: Cell Formatting in Excel 2013?
Thread-Index: Ac5tyeKhpmVKBNIHSJqcLdi6gvrFYg==
Date: Thu, 20 Jun 2013 15:32:19 +0000
Message-ID: 
 <985c7eb401d447e7bd31e05495f3fe27@BLUPR06MB036.namprd06.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_985c7eb401d447e7bd31e05495f3fe27BLUPR06MB036namprd06pro_"
MIME-Version: 1.0

--_000_985c7eb401d447e7bd31e05495f3fe27BLUPR06MB036namprd06pro_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello Everyone,

We use a combination of Apache POI and DynamicJasper to generate Excel expo=
rts from our application. Our code works perfectly all the way to Excel 201=
0, but in Excel 2013 our cell style formatting stops being applied at Colum=
n E Row 36.

Here are a couple of screenshots of what I am referring to:

In this screenshot, you can see that the cell styles are being applied prop=
erly at E35:
https://dl.dropboxusercontent.com/u/1540472/Proper%20Cell%20Formatting.png

In this screenshot, you can see that at E36, our custom format is no longer=
 being applied, and is no longer applied for the rest of the sheet:
https://dl.dropboxusercontent.com/u/1540472/Improper%20Cell%20Formatting.pn=
g

In this screenshot, you can see that if I manually change the cell format, =
the cell data is displayed properly:
https://dl.dropboxusercontent.com/u/1540472/Manually%20Changed.png

This doesn't happen in Excel 2010 or earlier. We've tried upgrading to the =
latest versions of Apache POI and DynamicJasper and the behavior doesn't ch=
ange. Can anyone help point us in the right direction as to why this may be=
 happening? Please don't hesitate to ask for any other information needed t=
o help us resolve this issue.

Thanks,

Matt

--_000_985c7eb401d447e7bd31e05495f3fe27BLUPR06MB036namprd06pro_--