<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 Rotation in 3D Column chart labels in Excel made XLSX files is wrong when opened in LibreOffice."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114285">114285</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Rotation in 3D Column chart labels in Excel made XLSX files is wrong when opened in LibreOffice.
</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=138248" name="attach_138248" title="Example file made with Excel 2013">attachment 138248</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138248&action=edit" title="Example file made with Excel 2013">[details]</a></span>
Example file made with Excel 2013
If we create a 3D Column chart in Microsoft Excel 2013/2016 the default setting
of label rotation will be horizontal. Even if the labels are too long to fit,
the Microsoft Excel automatically rotate the labels in the most optimal way
(vertical or -45°). When we open the spreadsheet in LibreOffice the X category
axis label will be vertical (which is the same as the MSO Excel default
rotation setting), even if it doesn’t fit.
Steps to reproduce:
1. Create a new spreadsheet in Excel 2013.
2. Create a simple 3D Column chart.
3. The X category Axis labels should be properly long strings, so the MSO Excel
will rotate the labels automatically. Or you can resize the chart area and the
MSO Excel will automatically rotate the labels.
4. Click right on the diagram, and select the 3-D rotation.
5. Remove the mark from the “Right Angle Axis”.
5. Save the file and close Excel.
6. Open the same file with LibreOffice Calc.
Actual results:
The chart label isn't rotated anymore, because the default rotation setting is
horizontal and the “Right Angle Axis” option was not checked.
Expected results:
The chart label should stay rotated.
***************************************
In LibreOfficeDev Calc
Version: 6.0.0.0.beta1+
Build ID: 29228e83df009cf76ac819ed024527be1092f065
CPU threads: 4; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2017-12-04_23:15:34
Locale: hu-HU (hu_HU); Calc: group threaded
7. Open the original file with LibreOfficeDev Calc save as the file in xlsx.
8. Reload the spreadsheet.
Actual results:
The X axis label is disappeared.
Expected results:
The x axis label should not be disappeared.</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>