[Libreoffice-bugs] [Bug 107617] New: Loaded Spreadsheet is not embedded/linked spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107617
           Summary: Loaded Spreadsheet is not embedded/linked spreadsheet
           Product: LibreOffice
           Version: 5.3.1.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: antonin.perrotaudet at yahoo.com

Created attachment 133060
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133060&action=edit
pptx with graph and linked embeded xlsx

It is not possible to edit an embedded spreadsheet linked by a graph when using
the data table widget because the data displayed by this widget is not the data
from the embedded spreadsheet.


When embedding a spreadheet in a power point document, and using it in a graph
(using data reference, ie <c:externalData r:id="rId101"> if rId101 points to a
valid embedded xlsx document), the data displayed in the "data_table" is not
the data from the spreadsheet, but the data from graph "<c:numCache>" and
"<c:strCache>" elements.

I joined a document as an example : the embedded spreadsheet has for value
"Category 1 / Series 1" -> 10 and NOT 4.3


Tested on power point 2010 : power point does read the embedded xlsx document
when editing graph data, and updates the graph accordingly.

-- 
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/20170504/4e1939da/attachment-0001.html>