https://bugs.documentfoundation.org/show_bug.cgi?id=167742
Bug ID: 167742
Summary: Calc calculates the sum incorrectly
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Happens when opening the Calc and start filling a new table. B1=0,01 F2=0
F3=F2+$B$1 F4=F3+$B$1 ... F102=F101+$B$1
Cells F77 to F101 counts incorrect. It does not be visible if column F content
is not fitted to width.
Steps to Reproduce:
1. Start the Calc
2. type 0,01 on cell B1
3. type =0 on cell F2
4. type =F2+$B$1 on cell F3
5. drag to copy from cell F3 to cell F102
6. double-click the edge of column F to fit the content into the column
7. Cells from F77 to F101 will be summed incorrectly
8. Cell F77 visible decimals must be added manually to see error
Actual Results:
for example cell F78 contains 0,760000000000001
Expected Results:
0,76
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render:
Skia/Vulkan; VCL: win
Locale: fi-FI (fi_FI); UI: fi-FI
Calc: CL threaded
1.If try to make a new table (table2) and repeat calculation, will not recur
2.If table is saved, Calc is closed and opened again, will not recur
3.If Calc is closed and opened again and a new table is edited (table1), it
will occur again
--
You are receiving this mail because:
You are the assignee for the bug.
