Bug 45761 - Excel "very hidden" sheets listed as visible
Summary: Excel "very hidden" sheets listed as visible
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: All All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2008-09-08 03:14 UTC by Robin Galloway-Lunn
Modified: 2008-09-08 10:43 UTC (History)
0 users

1 sheet visible, 1 sheet hidden, 1 sheet very hidden. (15.50 KB, application/octet-stream)
2008-09-08 05:18 UTC, Robin Galloway-Lunn

Note You need to log in before you can comment on or make changes to this bug.
Description Robin Galloway-Lunn 2008-09-08 03:14:35 UTC
HSSFWorkbook.isSheetHidden(int sheetNum) incorrectly returns false for "very hidden" worksheets.

Sheets have 3 visibility states: Visible, Hidden and "Very Hidden".  Very hidden sheets will not even show up in the menu item Format/Sheet/Unhide.  To use this setting on a workbook for verify the bug:

1. open any workbook
2. press <Alt-F11> to enter the VBA editor
3. click on the sheet in the upper left hand "Project" pane.
4. click on the "Visible" property in the "Properties" pane.
5. set the property to "2 - xlSheetVeryHidden"
6. save the workbook and close excel.
Comment 1 Nick Burch 2008-09-08 04:34:35 UTC
Any chance you could upload a file with three sheets, one visible, one hidden and one very hidden? That'd make it easy for someone to compare the flags set on the different sheets, and figure out how much work would be needed to correctly flag these very hidden sheets.
Comment 2 Robin Galloway-Lunn 2008-09-08 05:18:25 UTC
Created attachment 22540 [details]
1 sheet visible, 1 sheet hidden, 1 sheet very hidden.

Excel 2003 example workbook containing an example of a visible, hidden and very hidden sheet.
Comment 3 Robin Galloway-Lunn 2008-09-08 05:19:40 UTC
Thanks for looking into this.  Please see attachment for the example you requested.

Comment 4 Nick Burch 2008-09-08 10:43:49 UTC
svn now has support for checking if sheets are very hidden, and for setting them to be not hidden, hidden or very hidden.