<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 - Negative Date shows as ### when opening xlsx file"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116591">116591</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Negative Date shows as ### when opening xlsx file
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>martin.troiber@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When opening a .xlsx file the cells (Format: [H]:MM) that contain the formula
"=CELL1-CELL2" sometimes show "###" when the result is negative. When opening
the file and saving to .xls or .ods the newly created file does not come with
the same error. However saving the working file as .xlsx brings back the
problem.
Steps to Reproduce:
1.Open a certain .xlsx file. For privacy reasons only available upon request.
2.Have a look at the cells "Vormonat" and "Akt. Stand" from sheet "November17"
to "März18".
3.
Actual Results:
Some cells (Format: [H]:MM) that contain the formula "=CELL1-CELL2" show "###"
when the result is negative.
Expected Results:
The cells (Format: [H]:MM) that contain the formula "=CELL1-CELL2" show "###"
should have shown the result even when the result is negative.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 5.4.6.2 (x64)
Build-ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
CPU-Threads: 4; BS: Windows 6.19; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc: group
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101
Firefox/59.0</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>