<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 with complex axis labels opens incorrectly if “Range for Name” value is fixed text"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142346">142346</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Chart with complex axis labels opens incorrectly if “Range for Name” value is fixed text
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.6.0.4 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, regression
</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=172119" name="attach_172119" title="Example file from Excel">attachment 172119</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=172119&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
Attached user made document contains two similar line charts with complex axis
labels.
The main difference between them is that the top ones data series have their
name defined as a static string “Nth quarter” while the bottom ones data series
have their name defined as a cell reference.
The top ones axis label is completely garbled with the last year number and all
quarter numbers visible in a single vertical “cell” of the complex axis label.
The bottom one looks fine with the same data.
Changing the “Range for Name” values from the static string to a cell reference
fixes the display of the top chart.
Steps to reproduce:
1. Open attached document
Actual results:
Top charts X-axis label is unreadable.
Expected results:
Top charts X-axis label should look like the bottom ones with year numbers and
quarter numbers.
LibreOffice details:
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 91330c503b7eb91d777978018b66890af87cf8f5
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Also in: 7.0, 6.0, 5.0, 4.0, 3.6
But not yet in 3.5.</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>