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: libreoffice-bugs@lists.freedesktop.org Reporter: tikirah...@rartg.com 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.