poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45761] New: Excel "very hidden" sheets listed as visible
Date Mon, 08 Sep 2008 10:14:36 GMT

           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: dev@poi.apache.org
        ReportedBy: robin108@gmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message