poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51037] setDefaultColumnStyle() in XSSFSheet not working
Date Thu, 07 Apr 2011 14:35:01 GMT

M8R-3mye921@thisisnotmyrealemail.com changed:

           What    |Removed                     |Added
             Status|NEEDINFO                    |NEW

--- Comment #2 from M8R-3mye921@thisisnotmyrealemail.com 2011-04-07 10:34:59 EDT ---
If I look at "sheet1.xml", the Excel-generated file has
    <dimension ref="B1:E1"/>

where the POI-generated file had
    <dimension ref="B1"/>

and Excel has
    <col min="2" max="2" width="9.140625" style="1"/>
    <col min="5" max="5" width="9.140625" style="1"/>

where POI has
    <col min="2" max="2" style="1" width="9.140625" collapsed="false"/>
    <col min="5" max="5" style="0"/>

"styles.xml" is not substantially different; the custom style is stored as
    <cellStyle name="PurpleStyle" xfId="1"/>

In both cases, column B (2) was the column which already had the style. Column
E (5) was the one which I copied the style to in Excel or POI respectively.

So it looks like POI is creating a column entry in the worksheet file, but not
storing the style.

Hope that helps.

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message