https://bugs.documentfoundation.org/show_bug.cgi?id=159325
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 Summary|Excel File with hidden |Allow changing workbook |diagram breaks rendering |property showObjects (from | |none to all, so objects are | |not hidden) CC| |ilmari.lauhakangas@libreoff | |ice.org --- Comment #7 from Buovjaga <[email protected]> --- Mystery solved: 1. Unzip the .xlsx file 2. Edit file xl/workbook.xml in a text editor 3. Notice this element: <workbookPr showObjects="none" defaultThemeVersion="166925"/> The showObjects="none" is a non-default value, which apparently hides the objects (even though the chart *is* visible when opened in office.com). The attribute is optional, so it can be removed or the value changed to "all". Zipping up the files again (and changing extension to .xlsx) and opening in LibreOffice gives us a visible chart. I read about the property in this API doc: https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.workbookproperties?view=openxml-2.8.1 Looking at LibreOffice source $ git grep -n showObjects oox/source/token/tokens.txt:4711:showObjects sc/source/filter/excel/excdoc.cxx:230: Add( new XclExpBoolRecord(0x008D, false, XML_showObjects ) ); // HIDEOBJ sc/source/filter/excel/excdoc.cxx:343: Add( new XclExpBoolRecord(0x008D, false, XML_showObjects ) ); // HIDEOBJ sc/source/filter/excel/xerecord.cxx:177: // HACK: HIDEOBJ (excdoc.cxx) should be its own object to handle XML_showObjects sc/source/filter/excel/xerecord.cxx:178: mnAttribute, mnAttribute == XML_showObjects ? "all" : ToPsz( mbValue )); sc/source/filter/oox/workbooksettings.cxx:126: maBookSettings.mnShowObjectMode = rAttribs.getToken( XML_showObjects, XML_all ); Picking one of the files and looking at log: git log -S"HIDEOBJ" sc/source/filter/excel/excdoc.cxx I see a very old commit commit 43bafd9dd74489bac28edb5bbdb8a7d0b2442cc5 Author: Release Engineers <[email protected]> Date: Wed Jul 1 08:58:41 2009 +0000 So this has been handled for a long time. I guess the question is if we want GUI access to change this workbook property. Let's discuss it. -- You are receiving this mail because: You are the assignee for the bug.
