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

--- Comment #7 from Johannes <[email protected]> ---
I tested again with

Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

I created a new spreadsheet document with the same values in the first tab
(copied by means of "copy & paste"), then I defined a diagram similiar to my
first test.
Everything looked fine and I stored the document and made a copy of it.

When I reopened the document additional empty lines were added to the labels
for both axes, but not to the title of the diagram. I saved the document again
without changing anything.

Afterwards I opened the ODS file saved after its creation and the current ODS
file with 7-zip. I then opened the "Object 1\content.xml" (holds the definition
of the diagram) with a text editor and checked for differences between the
initial and the final state.

The XML statements for the chart title are identical:

    <chart:title svg:x="6.692cm" svg:y="0.316cm" chart:style-name="ch2">
     <text:p>Diagramm 1</text:p>
    </chart:title>

But the XML statements for both axes titels are different, first the initial
XML statements:

      <chart:title svg:x="8.059cm" svg:y="8.019cm" chart:style-name="ch2">
       <text:p>
        <text:span text:style-name="T1">Label</text:span></text:p>
      </chart:title>

      <chart:title svg:x="0.451cm" svg:y="5.038cm" chart:style-name="ch5">
       <text:p>
        <text:span text:style-name="T1">Werte</text:span></text:p>
      </chart:title>

And then the XML statements in the final document:

      <chart:title svg:x="7.89cm" svg:y="7.319cm" chart:style-name="ch2">
       <text:p>

        <text:span text:style-name="T1">Label</text:span></text:p>
      </chart:title>

      <chart:title svg:x="0.451cm" svg:y="5.207cm" chart:style-name="ch5">
       <text:p>

        <text:span text:style-name="T1">Werte</text:span></text:p>
      </chart:title>

Note that there is an empty line (in fact it holds a number of white spaces)
between the "<text:p>" statements and the "<text:span ...>" statement, and I
strongly assume that these white spaces finally cause the modifications of the
labels for both axes.

It looks as if LibreOffice adds these white spaces and the newline to the
labels when it reads the ODS document if the following XML statement sequence
is found:

    <text:p>
      <text:span text:style-name=...>...</text:span></text:p>

But a XML statement like "<text:p>Diagramm 1</text:p>" is not modified.

When I reformat the diagram title e.g. with another font, also this title will
be embedded into "<text:span ...>" and "</text:span>", and then white spaces
and a newline will be added to the diagram title too when the document is
opened for the next time.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to