https://bugs.documentfoundation.org/show_bug.cgi?id=151750
Bug ID: 151750
Summary: SUMs wrong in Calc
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 183257
--> https://bugs.documentfoundation.org/attachment.cgi?id=183257&action=edit
Calc spreadsheet with wrong SUMs.
Two problems:
First:
I have German as the default language for Calc.
When I SUM a column of numbers with a comma as the decimal marker it produces
what seems to be a random number.
When I convert the numbers to English (UK), and replace the commas with a full
point, the SUM Calc produces is the same as those Google Sheets produces. But
not always - See Column 1 and 2
Electricity Gas
20.2 28.2 20.2 28.2
11.5 9.6 11.5 9.6
17.6 14.7 17.6 14.7
0.0 0.0 0.0 0.0
9.3 8.0 9.3 8.0
0.0 0.0 0.0 0.0
4.7 5.0 4.7 5.0
13.6 11.3 13.6 11.3
2.7 2.7 2.7 2.7
2.1 2.2 2.1 2.2
5.1 4.6 5.1 4.6
10.8 11.1 10.8 11.1
0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0
1.0 0.0 1.0 0.0
1.6 1.5 1.6 1.5
1.0 13.0 100.2 98.9
Second:
When I have copied and pasted columns of numbers from, say a CSV file, into
CALC, CALC sometimes leaves off the Zero from a number like 10 or 60 or 890.
Why would it drop the last zero at all, but not a 1 to 9 number?
Many thanks for your help.
Ian
PS I'm using Libre Office ver 7.3.1.3 (x64) on a Windows 10 Build 19043
machine.
--
You are receiving this mail because:
You are the assignee for the bug.
