https://bugs.documentfoundation.org/show_bug.cgi?id=98966
Bug ID: 98966
Summary: SUM function error when both column references are
absolute and both row references are relative
Product: LibreOffice
Version: unspecified
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/49.0.2623.87 Safari/537.36
Build Identifier: Version: 5.1.0.3
5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
The SUM function returns "0" instead of a correct sum for the following
combination of absolute and relative references (see example below):
=SUM($C201:$G201)
Other combinations of absolute and relative references operate correctly.
Reproducible: Always
Steps to Reproduce:
1.Enter the SUM function in the formula window.
2.Set cell references as shown in the example above
3.
Actual Results:
Sum of 1,1,3 4 4 -> 0 when cell references are as show in example.
Sum of 1,1,3 4 4 -> 13 for all other cell reference combinations.
Expected Results:
Sum of 1,1,3 4 4 -> 13 when cell references are as show in example.
Sum of 1,1,3 4 4 -> 13 for all other cell reference combinations.
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows XP
OS is 64bit: no
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
