[Libreoffice-bugs] [Bug 114163] New: FILESAVE XLSX stacked bar chart legend reversed after open the file in Calc

[b***@bugs.documentfoundation.org]

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

Bug ID: 114163
Summary: FILESAVE XLSX stacked bar chart legend reversed after
open the file in Calc
Product: LibreOffice
Version: 6.1.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@ubuntu.com

Created attachment 138108
--> https://bugs.documentfoundation.org/attachment.cgi?id=138108&action=edit
Example file made with Excel 2013

FILESAVE XLSX stacked bar chart legend reversed after open the file in Calc
If we create stacked bar chart with Microsoft Excel, and we add legend to the
chart and open the file with LibreOffice Calc, the order of legend is reversed.

Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel.
2. Add values to a few cells as in the attached file (There should be at least
two data series).
3. Select the cell range that contains the data.
4. Create a simple Stacked Bar chart in Microsoft Excel.
5. Add the legend to the chart.
5. Open the file in LibreOffice Calc and compare the legends.

Actual results:
Stacked Bar chart legend reversed after open the file.

Expected results:
Stacked Bar chart legend should not be reversed after opening the file.

[b***@bugs.documentfoundation.org]

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

Jacques Guilleron <***@aol.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Keywords| |filter:docx
Status|UNCONFIRMED |NEW
CC| |***@aol.com
Ever confirmed|0 |1

--- Comment #1 from Jacques Guilleron <***@aol.com> ---
Hi Gabor,

Reproduced with
LO 6.0.0.0.beta1 Build ID: 97471ab4eb4db4c487195658631696bb3238656c
Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut;
Locale : en-US (fr_FR); Calc: CL

[b***@bugs.documentfoundation.org]

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

--- Comment #2 from Bartosz <***@poczta.onet.pl> ---
I'm not able to reproduce it with LibreOffice 5.4.

Could you please attach screenshot with comparison?

[b***@bugs.documentfoundation.org]

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

Bartosz <***@poczta.onet.pl> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|FILESAVE XLSX stacked bar |FILEOPEN XLSX stacked bar
|chart legend reversed after |chart legend reversed after
|open the file in Calc |open the file in Calc

[b***@bugs.documentfoundation.org]

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
Keywords|filter:docx |filter:xlsx
Blocks| |108897, 108543

--- Comment #3 from Aron Budea <***@caesar.elte.hu> ---
Possibly related to bug 53301?


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108543
[Bug 108543] [META] Chart legend bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=53
| |301

[b***@bugs.documentfoundation.org]

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

--- Comment #4 from Gabor Kelemen <***@ubuntu.com> ---
Created attachment 144857
--> https://bugs.documentfoundation.org/attachment.cgi?id=144857&action=edit
The example file saved by Calc 6.1

So Excel writes this property to the Chart1.xml:
<c:order val="0"/>
Calc seems to ignore this, and writes this:
<c:order val="1"/>

Which in turn is ignored by Excel and shows the legend in the original order.

[b***@bugs.documentfoundation.org]

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

Balázs Varga <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Assignee|libreoffice-***@lists.free |***@gmail.com
|desktop.org |
Status|NEW |ASSIGNED

[b***@bugs.documentfoundation.org]

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

Balázs Varga <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Assignee|***@gmail.com |libreoffice-***@lists.free
| |desktop.org
Status|ASSIGNED |NEW

[b***@bugs.documentfoundation.org]

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

--- Comment #6 from Bartosz <***@poczta.onet.pl> ---
After deep anaylysis it seems that this is generic issue with LibreOffice
Charts, not related to XLSX import.

Steps to reproduce:
1. Open LibreOffice
2. Create some data with axis labels
3. Select data range
4. Click "Insert -> Chart"
5. Switch for different chart types (eg. Column, Bar...), and variants (eg.
Normal, Stacked, Percent Stacked) , and observe the legend order.



Actual results:
Stacked Bar, Percent Stacked Bar, Stacked Column, Percent Stacked Column,
Stacked Area, Percent Stacked Area, Points and Lines chart legends reversed.

Expected results:
Stacked Bar, Percent Stacked Bar, Stacked Column, Percent Stacked Column,
Stacked Area, Percent Stacked Area, Points and Lines chart legends NOT
reversed.

[b***@bugs.documentfoundation.org]

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

Bartosz <***@poczta.onet.pl> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|FILEOPEN XLSX stacked bar |Stacked and percent stacked
|chart legend reversed after |chart legends have reversed
|open the file in Calc |order

[b***@bugs.documentfoundation.org]

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

Bartosz <***@poczta.onet.pl> changed:

What |Removed |Added
----------------------------------------------------------------------------
Keywords|filter:xlsx |

[b***@bugs.documentfoundation.org]

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

Bartosz <***@poczta.onet.pl> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks|108897 |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker

[b***@bugs.documentfoundation.org]

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

--- Comment #7 from Balázs Varga <***@gmail.com> ---
This is the code pointer:
https://opengrok.libreoffice.org/xref/core/chart2/source/view/charttypes/VSeriesPlotter.cxx#2223

And I think we should respect the direction of axis: But unfortunately we did
not know the axis on this level.
https://opengrok.libreoffice.org/xref/core/chart2/source/view/charttypes/VSeriesPlotter.cxx#2225

Or the chart types, for example the legends should reversed in case of BAR
charts.
But unfortunately, on this level there is no difference between
CHART2_SERVICE_NAME_CHARTTYPE_BAR and CHART2_SERVICE_NAME_CHARTTYPE_COLUMN
chart types. But if we know the axis on this level we could use the
isSwapXAndY() for handling this.

[b***@bugs.documentfoundation.org]

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

Balázs Varga <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Assignee|libreoffice-***@lists.free |***@gmail.com
|desktop.org |

[b***@bugs.documentfoundation.org]

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

Balázs Varga <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Assignee|***@gmail.com |libreoffice-***@lists.free
| |desktop.org

[b***@bugs.documentfoundation.org]

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

Balázs Varga <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |VERIFIED

[b***@bugs.documentfoundation.org]

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

Commit Notification <libreoffice-***@lists.freedesktop.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Whiteboard|target:6.3.0 |target:6.3.0 target:6.2.0.1

[b***@bugs.documentfoundation.org]

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

--- Comment #14 from Commit Notification <libreoffice-***@lists.freedesktop.org> ---
Balazs Varga committed a patch related to this issue.
It has been pushed to "libreoffice-6-2":

https://git.libreoffice.org/core/+/ee2434656f24ccb31246b1347d46b72710faf076%5E%21

tdf#114163 Chart: fix order of legend names

It will be available in 6.2.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.