<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 Line chart has gaps instead of 0.0 values if the cell content is a string"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123834">123834</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Line chart has gaps instead of 0.0 values if the cell content is a string
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<pre>Description:
If there is a cell with a string value (for example asdf1 or 2text_), in a line
chart it appears as a gap in LibreOffice, but in MSO it appears as 0 value.
Steps to Reproduce:
1. Fill a column with some data (for example: 1, string1, empty cell,
2string, 3)
2. Select the area of the data sequence
3. Click on Insert menu and select chart
4. Chose line in the chart type selection, then select points and lines or
lines only
5. Click on finish
6. Open the file in Calc and Excel and compare them
Actual Results:
In Calc, there are no lines between 1, string1 and 2string, 3 values, but there
will be in Excel.
Expected Results:
If a cell has string value, it should be interpreted as 0 value in a line
chart, in this example there should be lines between values 1, string1 and
2string, 3.
Reproducible: Always
User Profile Reset: No
Additional Info:</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>