You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/09/08 12:14:36 UTC

DO NOT REPLY [Bug 45761] New: Excel "very hidden" sheets listed as visible

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: 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

DO NOT REPLY [Bug 45761] Excel "very hidden" sheets listed as visible

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45761


Robin Galloway-Lunn <ro...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |ASSIGNED




--- Comment #3 from Robin Galloway-Lunn <ro...@gmail.com>  2008-09-08 05:19:40 PST ---
Thanks for looking into this.  Please see attachment for the example you
requested.

-RGL


-- 
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

DO NOT REPLY [Bug 45761] Excel "very hidden" sheets listed as visible

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45761





--- Comment #2 from Robin Galloway-Lunn <ro...@gmail.com>  2008-09-08 05:18:25 PST ---
Created an attachment (id=22540)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=22540)
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.


-- 
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

DO NOT REPLY [Bug 45761] Excel "very hidden" sheets listed as visible

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45761


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |RESOLVED
         Resolution|                            |FIXED




--- Comment #4 from Nick Burch <ni...@torchbox.com>  2008-09-08 10:43:49 PST ---
svn now has support for checking if sheets are very hidden, and for setting
them to be not hidden, hidden or very hidden.


-- 
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

DO NOT REPLY [Bug 45761] Excel "very hidden" sheets listed as visible

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45761


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO




--- Comment #1 from Nick Burch <ni...@torchbox.com>  2008-09-08 04:34:35 PST ---
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.


-- 
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