Bug 41220 - The order of data series breaks when saving as .xlsx
Summary: The order of data series breaks when saving as .xlsx
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-26 03:59 UTC by Tom Mortensen
Modified: 2012-08-31 10:06 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Three data series in an area chart (13.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-26 03:59 UTC, Tom Mortensen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tom Mortensen 2011-09-26 03:59:10 UTC
Created attachment 51617 [details]
Three data series in an area chart

When a spreadsheet contains an area chart (normal) with multiple data series, the order of data series may change when saving as .xlsx. This affects the order in which the data series are displayed in the chart.

Steps to reproduce:
1. Open the attached .ods
2. Notice how the yellow graph (Column C) is furthest to the back, the orange (Column B) is in the middle and the blue (Column A) is in front.
3. Save it as .xlsx.
4. Re-open it.
5. Notice how the yellow graph (column C) is now in front, covering the two other graphs.
6. Double click the chart, right click it and select "Data Ranges...".
7. Select the tab "Data Series"
8. Any change to how the data series are now ordered will be reverted upon reopening the .xlsx file.
Comment 1 Björn Michaelsen 2011-12-23 12:36:47 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 2 Florian Reisinger 2012-08-14 14:03:07 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 3 Florian Reisinger 2012-08-14 14:04:02 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 4 Florian Reisinger 2012-08-14 14:08:35 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 5 Florian Reisinger 2012-08-14 14:10:37 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian