In bar chart when all data are negative (minus values) it's better to place X axis labels above this (labels outside the plotting area). But Writer can't write this setting in XML chart when saving to DOCX. This result of return of the axis labels back to plotting area (below the X axis) after reloading the document. 1) Data: A1: A A2: -10 2) Make bar chart 3) Set labels outside (A category) 4) Select X Axis -> Format Axis -> Positioning -> Labels -> Place labels: Near axis (other side) 5) Paste chart to Writer 6) Save as DOCX 7) Reload Result: X Axis latels are inside ploting area (under the X axis). Expected: Labels above X axis. Writer can't save 'high' and puts 'nextTo'd parameter in: <c:chart> <c:plotArea> <c:catAx> <c:tickLblPos val="nextTo"/>
Created attachment 202187 [details] DOCX chart label position above X axis is not saved Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded
Created attachment 202188 [details] Example spreadsheet
Created attachment 202189 [details] Resulting DOCX
Created attachment 202190 [details] *.DOCX/word/charts/chart1.xml Word and Writer comparison (Visual Studio) Comparison of DOCX documents saved by Word and Writer. LEFT chart from Excel pasted to Word RIGHT chart form Calc pasted to Writer
Created attachment 202191 [details] WinMerge: search 'high' in chart1.xml
Created attachment 202192 [details] WinMerge: search 'nextTo' in chart1.xml LEFT docx saved in Word RIGHT docx saved in Writer