[Libreoffice-bugs] [Bug 108691] Hidden shape in imported XLSX shown in Print window and printed

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108691

--- Comment #4 from Aron Budea <baron at caesar.elte.hu> ---
The situation is more complicated, there are two related elements in OOXML that
affect whether the drawing object is there or not:
- attribute "hidden" of element "cNvPr" [1] that controls whether the drawing
object is displayed,
- attribute "fPrintsWithSheet" of element "clientData" [2] that controls
whether the drawing object is printed.

A hidden drawing object is not printed (at least not shown in the preview), but
there's no mention of that in the specification.
The relevant properties for binary formats can be found in MS-ODRAW, under
2.3.4.44 Group Shape Boolean Properties (fUsefHidden, fUsefPrint, fHidden,
fPrint).

In LibreOffice, as noted in [3], <drawooo:display> holds this setting, which is
not part of the standard, but is similar to ODF's <draw:display> [4] for
layers. As far as I could see there's no option on the UI where it can be set
for shapes.

Relevant pieces of the import code:
- OOXML: shape is created here based on the imported data
  http://opengrok.libreoffice.org/xref/core/oox/source/drawingml/shape.cxx#615
- OOXML: client data is imported here
 
http://opengrok.libreoffice.org/xref/core/sc/source/filter/oox/drawingbase.cxx#118
- binary format: similar properties are read and passed further
 
http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xiescher.cxx#3527

In OOXML's case the question is, where should the two attributes with different
origins be processed together?


[1]
https://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.spreadsheet.nonvisualdrawingproperties(v=office.15).aspx
[2]
https://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.spreadsheet.clientdata.aspx
[3] https://issues.oasis-open.org/browse/OFFICE-2125
[4]
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#attribute-draw_display

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170627/29ed87af/attachment.html>