Apache OpenOffice (AOO) Bugzilla – Issue 117975
XLSX: Calc is showing hidden sheet
Last modified: 2013-01-29 21:53:40 UTC
Created attachment 76478 [details] first sheet hidden issue Sheet 1 named "TODO-POI" in attached spreadsheet is set as hidden in Excel. When opening the spreadsheet in Calc (using openoffice 3.3), calc unable to recognize the sheet as hidden. Note: This behavior is observed only if the first sheet is set as hidden.
I can see the hidden sheet, too however, this issue is no P1
I am working on it.
Created attachment 79550 [details] patch for hidden sheet in xlsx When loading xlsx, it's supposed to set sheet hidden if necessary. However, in ScDocFunc::SetTableVisible, it misses ooxml case when trying to skip setting hidden property. That's why I add a flag to indicate ooxml. Below code is to ensure when there is only 1 sheet, and it's hidden, Aoo will still show it. if ( !bVisible && !pDoc->IsImportingXML() // #i57869# allow hiding in any order for loading && !pDoc->IsImportingMSXML()) { sal_uInt16 nVisCount = 0; SCTAB nCount = pDoc->GetTableCount(); for (SCTAB i=0; i<nCount; i++) if (pDoc->IsVisible(i)) ++nVisCount; if (nVisCount <= 1) { if (!bApi) rDocShell.ErrorMessage(STR_PROTECTIONERR); return sal_False; } }