| Summary: | : sum function omits one value from list, add two values includes it | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Mark Fielden <mark> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | ilmari.lauhakangas, miguelangelrv |
| Priority: | medium | ||
| Version: | 6.4.2.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | zip file containing .ods and .odt files referred to, plus image | ||
Range doesn't take in account text numbers, 25.00 is a text number, to me with comma separator the rest of the number are numbers. It is not a bug, LibreOffice it's strict about text number conversion, some options in Menu/Tools/Options/LibreOffe calc/Formula. Please take a look https://bugs.documentfoundation.org/show_bug.cgi?id=133588 To me it is a bug. The problem is inconsistent operation. a) all the numbers were entered into the text document in the same way b) the SUM function omitted one of the values without reporting an error c) the add function accumulated all the values correctly d) if the user hadn't thought the SUM total wrong, he could have made a bad decision To me it is a bug. The problem is inconsistent operation. a) all the numbers were entered into the text document in the same way b) the SUM function omitted one of the values without reporting an error c) the add function accumulated all the values correctly d) if the user hadn't thought the SUM total wrong, he could have made a bad decision (In reply to Mark Fielden from comment #3) > To me it is a bug. > The problem is inconsistent operation. > a) all the numbers were entered into the text document in the same way Maybe รง > b) the SUM function omitted one of the values without reporting an error Because at least for me it is a text with dot as decimal separator. What kind of error should be reported? > c) the add function accumulated all the values correctly Because only with direct references calc tries to convert numeric text in values when there are no ambiguity. > d) if the user hadn't thought the SUM total wrong, he could have made a bad > decision Like any other stuff users needs to know how to use the tools, and at the contrary that it is a way to avoid a number being taking in account. Use the right arrow on the paste button or go through paste special and paste as non formatted selecting the proper options to get the right values pasted. Closing as notabug |
Created attachment 161873 [details] zip file containing .ods and .odt files referred to, plus image I copied a list of five numerical values from a table in a .odt file. The .odt file itself had been converted from a .docx file a few iterations ago. Used =SUM(E29:E34) to add up the column. The calculated total seemed too small. Added the cumulative column to check it. values cumulative 15.14 15.14 19.42 34.56 34.56 15.2 49.76 25.25 75.01 25.00 100.01 75.01 Both files attached. Also attached an image in case you can't reproduce the problem.