Bug 99629 - FILESAVE: Chart changes in XLSX format when read by Excel
Summary: FILESAVE: Chart changes in XLSX format when read by Excel
Status: RESOLVED DUPLICATE of bug 96662
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.1.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, filter:xlsx, regression
Depends on:
Blocks:
 
Reported: 2016-05-02 12:23 UTC by Lars Jødal
Modified: 2016-09-17 11:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample Calc spreadsheet with chart saved as xlsx file (7.23 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-05-02 12:23 UTC, Lars Jødal
Details
PDF file with screen shots of chart (53.95 KB, application/pdf)
2016-05-02 12:30 UTC, Lars Jødal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Lars Jødal 2016-05-02 12:23:07 UTC
Created attachment 124787 [details]
Sample Calc spreadsheet with chart saved as xlsx file

Due to collaborators not working with LO, I have to save a Calc file as XLSX file. However, the charts often have problems when opened in Excel.

Attached is a spreadsheet saved from Calc in XLSX format, containing two columns of data and a column chart of these data. When opened in Calc, it looks correct, but the first and last column in the chart is almost gone when the file is opened in Excel (2016 version).

I know that Microsoft are infamous for not documenting their file formats very well, making other software packages having problems using their formats. Still, I have the hope that LO Calc should be able to save an XLSX file where charts looks correct when opened in Excel. Is this an impossible hope?

Best regards,
Lars J

Using LibreOffice version 5.1.2.2 on Windows 10
Comment 1 Lars Jødal 2016-05-02 12:30:40 UTC
Created attachment 124788 [details]
PDF file with screen shots of chart

... and here is a pdf file with screen shots of the chart in Calc (correct) and when loaded in Excel (something wrong).

PS: Is there a way to attach two files to the same bug report? (Instead of making this comment just to add a second file.)
Comment 2 raal 2016-05-05 05:55:13 UTC


 89b52d6f15a2c1b648a2db2ceae201320e3d4d55 is the first bad commit
commit 89b52d6f15a2c1b648a2db2ceae201320e3d4d55
Author: Norbert Thiebaud <nthiebaud@gmail.com>
Date:   Sat Sep 12 12:41:46 2015 -0700

    source f19402658dce6944e82a9058a6888e488b37b336

    source f19402658dce6944e82a9058a6888e488b37b336
    source cc2c9d514d3095d561da7c8fc94e8a09fa2f1a2f
    source f9674ddf81f9600a74edcf59324ad99624be1348
    source 6d8b9aab3cea5b88b3cb56d9343500d45be8b124
    source 1806882317af1162edce5c2389c9c5eeb18455ac
    source 39975c477a38be613e9e162acb6de241999f0ae1
    source 76eff026062c2bb755256cf9b335711d5421d27f
    source b02f1c58e7bb8b6c9381107431557d3f39794fe0
    source 78095389594972409f93a3ea8ab807863f8e3ec2
    source ac882c305da2c5d9c30756da8ac2976f9047622d
    source fa4871b7436c159c9d206d910f899d8af3044d72
    source 5a52fefc192dde9fc47badca526089f8d63c5ee6
    source f5a86c394c872e59cc0c7c793a5270d661c16561
    source 7b8e8e5d809bf2e172a4af1654415055654e30c8
    source 9e2628503db9641b722e3dd373845fd9b435a938
    source 40bc832ff31ae37784fd53c2b37689074f4cbeac
    source 24baf6c30e89244465f0b33d6b40b0773f932f95
    source 2466aa27429b2ffcc45f108284396d7527470e78
    source 9ea0390f17d5183471a27cf7666b45abf3f1e8a0
    source 71d8cfc13a7269230fc39c895c5a24350ab07357
    source 99d13c792637a4362c50b30bdc57ebbc6f3b7e4a
    source 9c162ddbea1507193b83fea2e2310f9eda5cfdb9
    source 4db28b21499b866c44a6727118a9a94bf2f590ef
    source 5066199663e40aad46e769ca3372f5f0b9915789
    source 4a8883e82720a364fc3e9a37631f02b957577d2a
    source da260fbb18ee9debd776468a8b8c4437dee420bd
    source 694419d813c14f6135aa4463d77f72c3a24a5cc5
    source c70d012935659606591ad50346c252bb234994ea
    source d0ebf4043a53918e176c75e5afa92d98c3ace32c
    source 2182220582fc0fc69bd806c08ad92f6219b05472
    source ecfcd036603e39940c2a11a81b3fccf0bbddc152
    source 9fb1ad5abe72a4df5537d2efe9b3296d24029d11
    source e763446ae53c3ea7907b6ffdc0be74a83af13db5
    source 86283974755da47aec47779c18ccddd794d5fc4f
    source 0c6da7fb3eb951fcd0c8fb31dbff1562f75289e9
    source a2d3089b5824d70917aaf7f1be7895db0f1c837e
    source 32b7619ced25de5f215b7f31902dc1cf0537df98
    source 4f4a668e04bdd68655a0f574027f486cea953857
Comment 3 Markus Mohrhard 2016-05-09 11:47:22 UTC
Regression from 694419d813c14f6135aa4463d77f72c3a24a5cc5 and therefore most likely a duplicate of Bug 96662.
Comment 4 Markus Mohrhard 2016-09-17 11:23:43 UTC

*** This bug has been marked as a duplicate of bug 96662 ***