Bug 118108 - Charts in an XLSX are not linked to their data properly
Summary: Charts in an XLSX are not linked to their data properly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
Reported: 2018-06-11 08:10 UTC by Mike Kaganski
Modified: 2021-07-27 09:27 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:

A problematic sample (51.53 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-06-11 08:10 UTC, Mike Kaganski

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2018-06-11 08:10:35 UTC
Created attachment 142649 [details]
A problematic sample

The problem is initially described at https://ask.libreoffice.org/en/question/157488.

In the attached file, the charts at sheet "Page1" have their data ranges on the other pages of this spreadsheet: e.g., a complex definition with ='15287024548174887.xlsx'!Age for X names, and ='15287024548174887.xlsx'!Reject, ='15287024548174887.xlsx'!Decay_but_Serviceable, and ='15287024548174887.xlsx'!No_Decay for series (for the bottom histogram).

When imported to LibreOffice, all the charts get the own data table, thus unlinked from the sheets data. So, changing data e.g. at inputs.E2 (to 3000, to make the first bar the highest) doesn't modify the histogram.

Tested with: Version: (x64)
Build ID: 0588a1cb9a40c4a6a029e1d442a2b9767d612751
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: ru-RU (ru_RU); Calc: CL
Comment 1 raal 2018-06-17 18:54:20 UTC
Confirm with Version:
Build ID: 59935c314945cdc365878a898317bfaa366fc36e
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
and Version:

Data table correctly linked in excel2010.

Chart broken in 4.1.