<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 combined chart (Column and Line) X category axis crosses the Y axis at the wrong place and the Y axis major grid disappears."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114181">114181</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>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.
</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=138146" name="attach_138146" title="Example file made with Excel 2013">attachment 138146</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138146&action=edit" title="Example file made with Excel 2013">[details]</a></span>
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).</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>