<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 - LibreOffice 5.4.2.2 Calc Math Error. Attaching Demonstration Spreadsheet."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114682">114682</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOffice 5.4.2.2 Calc Math Error. Attaching Demonstration Spreadsheet.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>joeconner2007@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=138634" name="attach_138634" title="Misbehaving Calc Demo Spreadsheet">attachment 138634</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138634&action=edit" title="Misbehaving Calc Demo Spreadsheet">[details]</a></span>
Misbehaving Calc Demo Spreadsheet
Calc misbehaves. Attached is a spreadsheet. This error can be demonstrated two
different ways.
1. Open the spreadsheet. Navigate to the DEC 2017 sheet if necessary. Note the
value in cell D27 is $733.81. Add a sheet by pressing the big plus sign just to
the left of the MAY 2017 sheet. Now look again at cell D27 on the DEC 2017
sheet. It now reads $1133.91. Now close the spreadsheet without saving.
2. Reopen the spreadsheet. Navigate to the Dec 2017 sheet if necessary. Note
the value of cell D2 is $-26.91. Now copy cell D2 with CTRL-C. Note that still
reads $-26.92. Now paste with CTRL-V. Now once again you have input no changed
values but the amount in cell D27 now reads $1133.91.
This phenomena did not happen until I upgraded to LibreOffice 5.4.2.2.
My computer is Gigabyte motherboard with Intel i7 and 16 gigabyte RAM running
Ubuntu 17.10 64bit.</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>