| Summary: | Auto SUM feature with negative values | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Damon <area51pilot> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | major | CC: | area51pilot, miguelangelrv |
| Priority: | medium | ||
| Version: | 5.0.0.5 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Sample screnshot
Test File |
||
|
Description
Damon
2015-08-13 19:39:38 UTC
Created attachment 117901 [details]
Sample screnshot
Hi @Damon, thanks for reporting. Please could you attach a sample file instead an image. Remember delete any private information. *** Bug 93413 has been marked as a duplicate of this bug. *** Created attachment 117909 [details]
Test File
Try to auto-generate =SUM(C2:C12) total for cell C13.
The cells which you want sum have text not values. They are also formatted as text @. Is possible to convert into numbers, select the data, then Menu/Data/Text to columns, click on the column head and select type as US English. Calc is very strict in accept text as number in formulas, and only try to convert text to values in direct references, but none in a range as used in a SUM() function. In this case sigma doesn't work because there are not values to sum. Doing the conversion s mentioned it works as expected. Resolved as not bug, please if you are not agree reopen it. Thank you for bringing that to my attention. I did notice when I manually entered the same negative values, it worked. I must have overlooked the cell format when the data was imported. |