https://bugs.documentfoundation.org/show_bug.cgi?id=167821
Piotr Osada <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Whiteboard| QA:needsComment | --- Comment #7 from Piotr Osada <[email protected]> --- QA:needsComment Additional findings / clarification ODS works as expected. The issue seems to be DOCX (OOXML chart) export mapping: when saving as DOCX, LibreOffice writes in *.DOCX\word\charts\chart1.xml <c:tickLblPos val="nextTo"/> for the category axis, while MS Word/Excel write <c:tickLblPos val="high"/> for the same “Near axis (other side)” placement. After reopening the DOCX in LO, labels are restored according to the exported OOXML (nextTo), which places them inside/overlapping the plotting area. This is likely in the OOXML export filter (see [1,5]): the ODF attribute axis-label-position="near-axis-other-side" from *.ODS\Object1\content.xml should map to tickLblPos=high — at least for this case where axis-position="0" and all data values are negative. ----------TL;DR---------- ODS\Object1\content.xml -----> axis-label-position="near-axis-other-side" [3] LO: DOCX\word\charts\chart1.xml -> c:tickLblPos val="nextTo" [2] MSO: DOCX\word\charts\chart1.xml -> c:tickLblPos val="high" [2] LO exports: "nextTo" <-- which is actual [2] MSO export: "high" <-- which is expected [2,4] ------------------------- [1] https://opengrok.libreoffice.org/xref/core/oox/source/export/chartexport.cxx [2] As can be seen in attachment 202190 that compares file: word/charts/chart1.xml Word vs Writer [3] Example spreadsheet from the attachment 202188 (tdf#167821 Label.ods). [4] https://c-rex.net/samples/ooxml/e1/part4/OOXML_P4_DOCX_ST_TickLblPos_topic_ID0EEA2RB.html [5] https://opengrok.libreoffice.org/xref/core/oox/source/export/chartexport.cxx?r=1fa4d0e6c95bddecbcc63bc6622187a8be2ee48d#4399 -- You are receiving this mail because: You are the assignee for the bug.
