https://bugs.documentfoundation.org/show_bug.cgi?id=160775
Bug ID: 160775
Summary: Incorrect Calculation Result in SUM Function with
Mixed Data Types
Product: LibreOffice
Version: 3.3.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When using the SUM function in LibreOffice Calc to calculate the sum of a range
containing mixed data types (numeric and non-numeric), the calculation result
is incorrect.
Steps to Reproduce:
1. Open a new Calc spreadsheet.
2. In cell A1, enter the value "10".
3. In cell A2, enter the value "5".
4. In cell A3, enter the text "Test".
5. In cell A4, enter the formula "=SUM(A1:A3)".
6. Press Enter to calculate the sum.
Actual Results:
The actual result is an error, or in some cases, the result may be the
concatenation of numeric and non-numeric values, such as "105Test".
Expected Results:
The expected result is 15, as the SUM function should ignore non-numeric values
and only sum the numeric values in the range A1:A3.
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
It affects users who rely on the SUM function to calculate the sum of ranges
containing mixed data types.
- The issue persists even after recalculating the spreadsheet or restarting the
application.
--
You are receiving this mail because:
You are the assignee for the bug.
