Summary: | XSSFSheet.setColumnHidden bleeds into adjacent columns having the same width. | ||
---|---|---|---|
Product: | POI | Reporter: | David Agnew <prescindor> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | P2 | ||
Version: | unspecified | ||
Target Milestone: | --- | ||
Hardware: | Macintosh | ||
OS: | Mac OS X 10.4 | ||
Attachments: | Small test case to demonstrate the column-hiding bug. |
Created attachment 24231 [details] Small test case to demonstrate the column-hiding bug. I tried to use XSSFSheet's setColumnHidden method to hide columns for future accounting periods on a financial worksheet. However, all of the data columns in the resulting worksheet were hidden, not just the ones for future periods. Noticing that the hidden columns all had the same width and speculating that the bug might be related to data sharing, I tried tweaking the columns to all have slightly different widths. That fixed the problem. Affects both Excel Mac 2008 and Excel 2007 on Windows.