Bug 47804

Summary: XSSFSheet.setColumnHidden bleeds into adjacent columns having the same width.
Product: POI Reporter: David Agnew <prescindor>
Component: XSSFAssignee: POI Developers List <dev>
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.

Description David Agnew 2009-09-08 13:02:23 UTC
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.
Comment 1 Yegor Kozlov 2009-10-04 03:10:52 UTC
setColumnHidden didn't work for columns included a column span. 

The fix was committed in r821497