Bug 107617 - FILEOPEN PPTX Chart linked to embedded XLSX spreadsheet shows incorrect values
Summary: FILEOPEN PPTX Chart linked to embedded XLSX spreadsheet shows incorrect values
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Impress (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:pptx
Depends on:
Blocks: PPTX
  Show dependency treegraph
 
Reported: 2017-05-04 09:29 UTC by antonin.perrotaudet
Modified: 2019-03-27 17:49 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
pptx with graph and linked embeded xlsx (51.06 KB, application/vnd.openxmlformats-officedocument.presentationml.presentation)
2017-05-04 09:29 UTC, antonin.perrotaudet
Details

Note You need to log in before you can comment on or make changes to this bug.
Description antonin.perrotaudet 2017-05-04 09:29:11 UTC
Created attachment 133060 [details]
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.
Comment 1 Buovjaga 2017-05-07 12:01:32 UTC
Confirmed.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha1+
Build ID: 6e4cba99bb35e6697b94309eedd1a08ebea2dc68
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on May 5th 2016

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 2 QA Administrators 2018-10-22 02:49:50 UTC Comment hidden (obsolete)
Comment 3 Babak Razmjoo 2019-03-27 13:39:00 UTC
I may be wrong, but LibreOffice is not supposed to perfectly be able edit MS office files. You can Use Open Document Formats instead. This is the whole point of LibreOffice being free software
Comment 4 Buovjaga 2019-03-27 17:49:53 UTC
(In reply to Babak Razmjoo from comment #3)
> I may be wrong, but LibreOffice is not supposed to perfectly be able edit MS
> office files. You can Use Open Document Formats instead. This is the whole
> point of LibreOffice being free software

We certainly do our best, so you are wrong :)

I still confirm the problem. Category 1 / Series 1 is 10 in the xlsx, but 4.3 in the chart.

Arch Linux 64-bit
Version: 6.3.0.0.alpha0+
Build ID: 66b21521a95f7b2053aa99a23e0a4c34438af6c7
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 22 March 2019