<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILESAVE XLSX Bar Chart minor axis spacing appears differently than the Microsoft Office minor axis spacing"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114168">114168</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Bar Chart minor axis spacing appears differently than the Microsoft Office minor axis spacing
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=138115" name="attach_138115" title="Example file made with Excel 2013">attachment 138115</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138115&action=edit" title="Example file made with Excel 2013">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>