https://issues.apache.org/bugzilla/show_bug.cgi?id=50884

--- Comment #2 from [email protected] 2011-03-21 09:56:41 EDT ---
(In reply to comment #1)
> Can you try creating a simple file with the same freeze pane settings in 
> Excel?
> Then, unzip both the POI and Excel version (.xlsx is a zip of xml files), and
> try to spot what was done differently for the freeze panes, page settings etc
> for them?

I have down what you havesuggested and I think I ahve found the problem.

Excel-generated file:

<pane xSplit="2" ySplit="1" state="frozen" topLeftCell="C2"
activePane="bottomRight"/>

POI-generated file:

<pane xSplit="2.0" ySplit="1.0" state="frozen" topLeftCell="B3"
activePane="bottomRight"/>

The top left cell is wrong. I have substituted 'B3' with 'C2' and zipped the
files again creating a new xlsx file and it works.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to