| Summary: | The SOMME function not working | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Guy Menard <dranemg> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | raal, rb.henschel |
| Priority: | medium | ||
| Version: | 6.1.3.2 release | ||
| Hardware: | ARM | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
error of the SOMME function
error of the SOMME function |
||
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 Created attachment 148610 [details]
error of the SOMME function
please find a file with the bug
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. 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 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 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. 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 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 |
Created attachment 148604 [details] error of the SOMME function I want the total of a column but it is always 0, see attached file