Bug 122937 - The SOMME function not working
Summary: The SOMME function not working
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.2 release
Hardware: ARM Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-24 16:12 UTC by Guy Menard
Modified: 2019-01-25 06:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
error of the SOMME function (56.17 KB, image/jpeg)
2019-01-24 16:12 UTC, Guy Menard 		Details
error of the SOMME function (9.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-24 20:31 UTC, Guy Menard 		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 Guy Menard 2019-01-24 16:12:57 UTC 
Created attachment 148604 [details]
error of the SOMME function

I want the total of a column but it is always 0, see attached file
Comment 1 raal 2019-01-24 16:55:28 UTC 
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 2 Guy Menard 2019-01-24 20:31:20 UTC 
Created attachment 148610 [details]
error of the SOMME function

please find a file with the bug
Comment 3 Regina Henschel 2019-01-24 21:07:10 UTC 
The cells, which you want to sum, do not contain numbers but text. Text, which looks like a number, is not automatically converted to number. You need to make sure yourself, that the content is really numbers.
Comment 4 Guy Menard 2019-01-24 21:19:31 UTC 
I am very sorry but the cells are NUMBERS 

I clicked on the top menu on FORMAT and chose NUMBER WITH 1 decimal

Be aware that I have the french version of Calc

For unknown Reason, the version on my other computer ( Windows 7 ) is working properly

It is only the version 6.1.3.2 on my Windows 10 that is not working properly

Thank you
Comment 5 Guy Menard 2019-01-24 21:20:15 UTC Comment hidden (obsolete)
Comment 6 Regina Henschel 2019-01-24 21:42:28 UTC 
Please use menu View > Value Highlighting. Numbers are blue, formulas are green and text is black.
Or write the formula =IsText(C3) into a free cell. It results in 'true'.

Changing the format of cell from text to number format after the cell has text content, does not convert the type of the cell content to number.
Comment 7 Guy Menard 2019-01-25 00:45:46 UTC 
I found the reason for the bug: here in Canada we use the DOT instead of the comma for decimals. If I use the comma, the SUM is correct. Is there a way to force Calc to use the DOT ? My operating system is using the DOT for decimals. Otherwise I will use the comma. Thank you
Comment 8 raal 2019-01-25 06:31:09 UTC 
Please do not reopen this bug, it's closed and not a bug. For questions we have AskBot: http://ask.libreoffice.org/

You can change locale settings in Tools - Options - Language - Language