https://bugs.documentfoundation.org/show_bug.cgi?id=114181
Bug ID: 114181
Summary: FILESAVE XLSX combined chart (Column and Line) X
category axis crosses the Y axis at the wrong place
and the Y axis major grid disappears.
Product: LibreOffice
Version: 6.1.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kelem...@ubuntu.com
Created attachment 138146
--> https://bugs.documentfoundation.org/attachment.cgi?id=138146&action=edit
Example file made with Excel 2013
If we create a combined chart (Column and Line) in Microsoft Excel and we set
the column chart as the secondary Y axis, the X category axis will be
positioned by the primary Y axis (Line chart). That means the X axis will cross
the primary Y axis (Line chart) at the zero value. But if we open the file in
LibreOffice Calc, the X axis will cross the secondary Y axis (Column chart) at
the zero value.
Another problem in this file that the Y axis major grid disappears when we open
it with LibreOffice Calc.
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, one for the column chart and one for the line chart)
3. Select the cell range that contains the data.
4. Create a simple Combined chart with a Line chart and a Column chart type.
5. Set the Column chart as the secondary Y axis.
6. Save the file and Open the file in LibreOffice Calc and compare it.
Actual results:
The Y axis major grid disappears. The X category axis will be positioned by the
secondary Y axis (Column chart). That means the X axis will cross the secondary
Y axis (Column chart) at the zero value.
Expected results:
The Y axis major grid should not disappear. The X category axis should be
positioned by the primary Y axis (Line chart).
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
