Bug 105805 - SUM wrong result in some cases.
Summary: SUM wrong result in some cases.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.0.2 rc
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-02-06 18:07 UTC by Raf Bakker
Modified: 2017-02-06 19:32 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Shows error calcolating the sum (114.56 KB, image/png)
2017-02-06 18:07 UTC, Raf Bakker 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Raf Bakker 2017-02-06 18:07:36 UTC 
Created attachment 130956 [details]
Shows error calcolating the sum

C4; C7 contains 1,3,5,7
=SOMMA(C4;C7)returns 8.
Attachment: Screen capture calc window.
Can repeat bug, but it has happened after i inserted the new column C.
Versione Calc: 5.3.0.3 Portable
On Microsoft Windows [Versione 10.0.14393]
Comment 1 Jacques Guilleron 2017-02-06 19:32:58 UTC 
Hi Raf,

Written this way, SUM(C4;C7) adds C4 and C7.
What you expect has to be written SUM(C4:C7) to add the values from C4 to C7.

Jacques