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.

Reply via email to