https://bugs.documentfoundation.org/show_bug.cgi?id=156571
Bug ID: 156571
Summary: Perculiar addition error resulting in erronious
additional decimal (specifically x.xx99999999999)
Product: LibreOffice
Version: 6.2.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: xyh...@hotmail.com
Description:
A simple table of bank transactions extracted from CSV data (i.e. no formulae,
or other hidden data - simply alphanumeric fields) was being used, and values
checked by a simple sum ([J90]=J89+E90) comparing against the precomputed
values in the table.
At row 158 the sum becomes an extended decimal value, whereas prior to this row
the numbers are correctly confined to 2 decimal places. However, the sum
displayed at the bottom of the spreadsheet window shows erronious valuse with
recurring decimal digits earlier in the table at row 128.
The data has been checked thoroughly and all values within the CSV are only 2
decimal places.
The addition error occurs in the inner workings of LibreOffice Calc somewhere.
The table and the imported data are 100% correct. The cell calculation formula
appears to be simple, but there is evidently something else going on, other
than simple addition.
The error shows in the table as -9.0955021292416E-14 at line 158, however the
sum appears to acquire the error earlier in the sequence at line 128, where the
value is XX.XX99999999999.
A small experiment setting the displayed digits in cell format causes the error
to disappear (irrispective of the number of decimal places selected) -
reverting the cell format to general causes the error to reappear.
Steps to Reproduce:
1. Open CSV
2. create sum in column at edge of data (column J)
3. find row with value with more than 2 decimal places.
Actual Results:
Rows after 128 can be seen to have recurring or additional decimal digits.
Expected Results:
all values computed should match the 2 decimal place values otherwise present
in the original data.
Reproducible: Always
User Profile Reset: No
Additional Info:
Data on the table cannot be shared due to data protection concerns. However,
the data is not special in any way - comprises of just text and numbers.
--
You are receiving this mail because:
You are the assignee for the bug.
