https://issues.apache.org/bugzilla/show_bug.cgi?id=45761
Summary: Excel "very hidden" sheets listed as visible
Product: POI
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
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.
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
