<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 - FILEOPEN XLSX Chart axis labels are rotated in multiple categories and partial secondary data series"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144794">144794</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Chart axis labels are rotated in multiple categories and partial secondary data series
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.3 release
</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>Keywords</th>
<td>bibisectRequest, filter:xlsx, implementationError
</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>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org, varga.balazs3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>75057
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=175353" name="attach_175353" title="Example file from Excel">attachment 175353</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=175353&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
Attached example file was made in Excel and contains charts with multiple
categories.
The charts on the right have an automatic label rotation, which means the roman
quarter labels and the years are horizontal in Excel.
In Calc however if the data range is only partially covering the primary
category with secondary data points, i.e. there is only one secondary data
point for the last “2009” item in the data range, the labels are rotated.
This does not happen if the data range fully covers the primary data point,
even if there are no actual values filled in.
Steps to reproduce:
1. Open attached document in Excel and Calc
Actual results:
The quarter labels are rotated 270 degrees on the “Axis rotation: empty” titled
charts: a combined bar+line chart on top and a bar chart at the bottom.
This does not happen for the right side charts that differ only in the size of
the data range.
Expected results:
The quarter labels of the secondary data series are not rotated in any case.
LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: b60b6bfaafa1315e07108dba50f016975b619c59
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Also in 7.0, 6.0 - 5.4 (although these rotated the years too), 5.3 and before
did not show the secondary labels at all for these charts.</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] OOXML Chart object issues"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=75057">Bug 75057</a>] [META] OOXML Chart object issues
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>