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.