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

            Bug ID: 174449
           Summary: Writer: Chart data series disappear after saving ODT
                    when Y error bars use cell ranges from a Writer table
           Product: LibreOffice
           Version: 26.8.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 209662
  --> https://bugs.documentfoundation.org/attachment.cgi?id=209662&action=edit
Two example odt files, one without error bars (working) and the same document
with insertet error bars (diagram is broken)

When creating a chart in LibreOffice Writer using data from a Writer table,
adding Y error bars with cell references causes the chart to become corrupted
when the document is saved in ODT format.

The chart works correctly as long as no error bars are used or the error bars
are configured with constant values.

However, as soon as the error bars are configured to obtain their values from
cell ranges in the Writer table, saving the document causes the chart data to
be lost.

After closing and reopening the document, the chart is completely empty. All
data series have disappeared from the chart's data range configuration.

The problem has been reproduced with multiple office suites and versions.

Steps to Reproduce

Create a Writer document containing a table with X values, Y values and
individual uncertainty values for each measurement point.

Insert a chart using the existing Writer table as its data source.

Configure the chart with data series referencing cells in the Writer table
(e.g. Tabelle8.A2:A10 for X values and Tabelle8.I2:I10 for Y values).

Save the document in ODT format, close it and reopen it. The chart remains
intact.

Edit the chart and select a data series.

Choose Insert → Y Error Bars.

Select Cell Range and enter a valid range containing the individual error
values (e.g. Tabelle8.C2:C10).

Confirm the settings and save the document.

Close LibreOffice and reopen the document.

Actual Results

The chart is completely empty after reopening the document.

The chart object itself still exists in the document.

Opening Data Ranges → Data Series shows that all previously configured data
series have disappeared.

The chart can no longer display its original data.

Recreating the data series is necessary to restore the chart.

Expected Results

The chart should retain all data series, including their references to the
Writer table.

Y error bars should correctly display the individual uncertainty values
obtained from the specified cell ranges.

Saving and reopening the document should not modify or delete the chart
configuration.

Additional Technical Findings

An examination of the affected ODT document (which is a ZIP archive containing
XML files) revealed that the embedded chart XML is truncated.

Specifically:

The affected chart is stored in Object 2/content.xml.

The XML file is exactly 4,096 bytes long.

The file ends abruptly in the middle of an XML element.

The XML structure is incomplete and cannot be parsed as a valid XML document.

Another chart in the same document (Object 1/content.xml) remains intact.

This strongly suggests that the chart serialization process fails while writing
the XML data when cell-range-based error bars are present.

Tests Performed

Configuration

Result

Chart without error bars

Works correctly

Chart with constant-value error bars

Works correctly

Chart with cell-range-based error bars

Chart becomes corrupted

LibreOffice 26.8.2.2

Bug reproduced

LibreOffice 26.2

Bug reproduced

Apache OpenOffice (current installed version)

Bug reproduced

The problem therefore does not appear to be specific to LibreOffice 26.8.

Impact

This issue makes it impossible to reliably use charts with cell-range-based
measurement uncertainties directly in Writer documents.

This is particularly problematic for scientific and technical reports where
every measurement point has an individual uncertainty value.

Using constant error bar values is not an acceptable workaround because
measurement uncertainties vary between measurement points.

Possibly Related Bug

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

This previously reported issue appears to describe a similar chart corruption
problem. Whether the underlying cause is identical has not yet been confirmed.

Additional Information

The affected document uses the native ODT format and a regular Writer table as
its data source.

The problem occurs with chart data series that otherwise work correctly. The
triggering condition is specifically the use of cell ranges as the source for Y
error bar values.

The chart XML corruption suggests a problem during document serialization
rather than a simple chart rendering issue.

A reproducible test document can be provided for further investigation.

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

Reply via email to