[Libreoffice-bugs] [Bug 118108] New: Charts in an XLSX are not linked to their data properly

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118108
           Summary: Charts in an XLSX are not linked to their data
                    properly
           Product: LibreOffice
           Version: 6.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 142649
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142649&action=edit
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: 6.0.5.1 (x64)
Build ID: 0588a1cb9a40c4a6a029e1d442a2b9767d612751
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: ru-RU (ru_RU); Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180611/bdb92c63/attachment.html>