<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 - EDITING Support “Best” rotation for bar chart category axis"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142328">142328</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING Support “Best” rotation for bar chart category axis
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</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>enhancement
</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, 90486
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=172084" name="attach_172084" title="Example file from Excel">attachment 172084</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=172084&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
Attached XLSX file demonstrates that MSO by default uses a “Best” rotation for
horizontal category axes of charts (Bar, Line, Point, Area).
On the UI it is shown as “Horizontal” text rotation, with undefined rotation
angle. This is misleading a bit, since the actual text rotation will be
determined based on the actual text length of the axis labels:
- with short labels/wide chart it’s gonna be horizontal
- with medium length labels it’s gonna be -45 degrees (in Word terms)
- with long labels it’s gonna be 270 degrees (in Word terms)
LO can display the text in the first two cases (when the labels overlap
property is turned off manually, needed right now because of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Fileopen DOCX: Text Orientation of X-Axis 0 instead of 45 degrees"
href="show_bug.cgi?id=140623">bug #140623</a>) but
it would be nice to be able to better mimic the vertical rotation of long
labels; possibly with an explicit UI option (to be filed later).
Steps to reproduce:
1. Open attached file
2. For the first chart, open the X axis properties
Actual results:
The X axis text is not rotated to 270 degrees, but to -45 even if the Overlap
property is manually turned off.
The Text Orientation dial indicates 0 degrees orientation, which is false: that
would mean the labels are horizontal.
Ideally, there would be an “Automatic” checkbox (or radio button paired with
“Vertically stacked” option) that disables this dial and sets rotation based on
actual text length + font size + available space. This could be a topic for
another report.
Expected results:
The X axis text should be rotated to 270 degrees.</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>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Chart bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=90486">Bug 90486</a>] [META] Chart bugs and enhancements
</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>