<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 Date axis tries to display empty items in range with month resolution"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134118">134118</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Date axis tries to display empty items in range with month resolution
</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>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>balazs.varga991@gmail.com, nemeth@numbertext.org, tundeth@gmail.com
</td>
</tr>
<tr>
<th>Blocks</th>
<td>75057
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=162178" name="attach_162178" title="Example file from Excel">attachment 162178</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=162178&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
Attached document contains some XLSX charts (column, bar, line and area are all
affected) that have their data range defined with several empty lines and the
displayed category is dates from multiple months. Also the range contains 10
empty rows after these.
This results in a date type X axis with month resolution.
When opened in Calc the chart tries to display even the empty rows and fails
miserably.
This only happens with month resolution, day and year are fine since in that
case Calc ignores the empty rows and displays the charts just like Excel (which
also ignores the empty rows)
Changing the data range to only the part with actual data corrects the charts
appearance.
Steps to reproduce:
1. Open attached file
Actual results:
The charts with the month date axis scale appear unreadable.
Expected results:
Only the data points with actual data are drawn on the chart, like in the case
of day and year resolution.
LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 33a720ab802491f15b247e09755cd36205b6f435
CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés:
alapértelmezett; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL
Also happens in
Verzió: 6.0.0.3
Build az.: 64a0f66915f38c6217de274f0aa8e15618924765
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett;
Területi beállítások: hu-HU (hu_HU); Calc: CL
Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale: hu-HU (hu_HU)
Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)</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>