Bug 47804 - XSSFSheet.setColumnHidden bleeds into adjacent columns having the same width.
Summary: XSSFSheet.setColumnHidden bleeds into adjacent columns having the same width.
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: Macintosh Mac OS X 10.4
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-08 13:02 UTC by David Agnew
Modified: 2009-10-04 03:10 UTC (History)
0 users


Attachments
Small test case to demonstrate the column-hiding bug. (44.48 KB, application/zip)
2009-09-08 13:02 UTC, David Agnew 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this 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

Yegor