https://bugs.documentfoundation.org/show_bug.cgi?id=174453
Bug ID: 174453
Summary: Calc: SUM() silently ignores text-formatted numeric
values without warning
Product: LibreOffice
Version: 26.8.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a cell contains a value that looks like a number (e.g. 1,88) but is stored
as text, the SUM() function silently ignores it.
This can produce an incorrect total without any warning or indication of an
error.
For example:
E3: 1,88 (stored as text)
E4–E9: 3,39, 4,10, 8,24, 5,86, 4,55, 2,40
Formula: =SUM(E3:E9)
Expected result: 30,42
Actual result: 28,54
Re-entering E3 as =1+0,88 immediately fixes the problem.
Suggested improvement: Display a warning when SUM() encounters text values that
look like numbers within the selected range, or provide an option to enable
such warnings.
Steps to Reproduce:
1.Open LibreOffice Calc.
Enter the following values into cells E3:E9:
E3: 1,88 (stored as text)
E4: 3,39
E5: 4,10
E6: 8,24
E7: 5,86
E8: 4,55
E9: 2,40
Enter the formula =SUM(E3:E9) into another cell.
Actual Results:
28,54
Expected Results:
30,42
LibreOffice Calc should have displayed a warning that one or more cells in the
SUM() range contained text instead of numeric values.
Alternatively, Calc should provide an option to warn users whenever SUM()
silently ignores text values that look like numbers.
The current behaviour can lead to incorrect calculation results without the
user noticing the problem.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 26.8.2.2 (X86_64)
Build ID: 9dea406ab7695df6325b11b0e19fdca8db4b7276
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: fi-FI (fi_FI); UI: fi-FI
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.