[Libreoffice-bugs] [Bug 114141] New: FILESAVE XLSX 0 Y value data series are not supported by Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114141
           Summary: FILESAVE XLSX 0 Y value data series are not supported
                    by Calc
           Product: LibreOffice
           Version: 6.1.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

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

It is possible to create 3D Column charts with ‘0’ Y value (in that case, the
shape of the data series is a square) in Microsoft Excel 2013, but these are
not fully supported by Calc: Calc only shows the value of the data (these data
labels move down under the X axis) but the data series of ‘0’ Y values (the
“square”) are disappeared.

Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel 2013.
2. Add two values (0% and 10%) to two cells in a column.
3. Select the cell range that contains the data.
4. Create a simple 3D Column chart with these (0% and 10%) data series.
5. Modify the X category axis labels to show the data series values (0% and
10%).
5. Save the file as XLSX.
6. Open the file in LibreOffice Calc and compare it with Excel.

Actual results:
The chart in Calc doesn’t show the data series of ‘0’ Y values (the “square”)
and these labels move down a little bit under the X axis.

Expected results:
The chart should display the zero values of data series at 3D charts.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171129/cf60972a/attachment-0001.html>