[Libreoffice-bugs] [Bug 114168] New: FILESAVE XLSX Bar Chart minor axis spacing appears differently than the Microsoft Office minor axis spacing

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114168
           Summary: FILESAVE XLSX Bar Chart minor axis spacing appears
                    differently than the Microsoft Office minor axis
                    spacing
           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 138115
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138115&action=edit
Example file made with Excel 2013

We create a simple Bar chart in Microsoft Office Excel and we set the minor
scale to show outside on the axis. In Microsoft Office Excel we can set the
unit of the minor scale, so the spacing will be displayed by the unit of minor
scale. In LibreOffice we cannot set the unit of minor scale, but we can set the
minor interval count. This two different setting option the reason for the two
different appearance.

Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel.
2. Add values to a few cells.
3. Select the cell range that contains the data.
4. Create a simple Bar chart in Microsoft Excel.
5. Click on the Y axis to setting the spacing.
5. Set the minor interval unit (if the main scale “1000” you should set “200”
for the minor scale: in this case, it divides the main scale into five parts)
and the minor scale to show outside on the axis.
6. Save it as XLSX and close the file. 
7. Open the file in LibreOffice Calc and compare the Y axis scales.

Actual results:
As you can see in LibreOffice Calc the main scale was divides into two parts.
In the Y Axis scale option you can see that Minor interval count is “2”.

Expected results:
The minor interval count should be the same in Microsoft Office Excel and
LibreOffice Calc.

-- 
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/20171130/bb23efa6/attachment.html>