https://bugs.documentfoundation.org/show_bug.cgi?id=105683
Bug ID: 105683
Summary: DSUM function SearchCriteria parameter should allow
references to cells
Product: LibreOffice
Version: 5.3.0.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Consider the following spreadsheet with 2 columns and 6 rows:
symbol price
a 10
b 20
a 30
=DSUM ( A1:B4, "price", {"symbol";"a"} )
=DSUM ( A1:B4, "price", {"symbol";A2} )
The SearchCriteria of the first DSUM is hard coded to the value "a", and the
expression evaluates correctly to 40.
The SearchCriteria of the second DSUM refers to the cell A2. The value of A2
is "a". However, this expression causes an error: "Err:512".
It would be nice if Calc could correctly evaluate the second DSUM expression.
Aside: The second DSUM expression does evaluate correctly inside a GoogleDocs
Spreadsheet.
Steps to Reproduce:
Recreate the example spreadsheet in the description.
Actual Results:
Err:512
Expected Results:
40
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Ubuntu Chromium/53.0.2785.143 Chrome/53.0.2785.143 Safari/537.36
--
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
