[Libreoffice-bugs] [Bug 130722] New: Can't use "Multiple Operations" with a DSUM function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130722

            Bug ID: 130722
           Summary: Can't use "Multiple Operations" with a DSUM function
           Product: LibreOffice
           Version: 6.3.3.2 release
          Hardware: Other
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: danchall at gmail.com

Description:
I have a valid call to DSUM. It works when I have a simple data table and a
simple criteria table, searching for one value in one field. Then I tried to
populate the value I'm searching for using Multiple Operations, and I get a 504
error. the variable is a text cell in the first row of the criteria table.  If
I use a simple formula (LEFT() ) then the table is populated correctly. But if
the formula is a call to DSUM, with the variable being the text value in the
first row of the criteria table, I get 504 errors. 

I haven't seen any reason this wouldn't work. I no longer have access to Excel
but this is something I often did in Excel years ago. 

Steps to Reproduce:
1.Create simple data table
2.create simple criteria table
3.write formula using DSUM with the criteria being a match for a simple string
in one field. Notice that the formula evaluates correctly
4. create a multiple operations table for one variable, three formulas. The
first formula is LEFT(X,2) where X is the string in the first row of the
criteria. The second formula is DSUM(DATATABLE, 3,CRITERIA). I expect to see
the sum of column 3 for matching rows.  The third formula uses column 2. The
fourth formula uses RIGHT(X,3)

Actual Results:
The LEFT and RIGHT formulas evaluate correctly but the DSUM formulas do not. I
get 504 errors for all the DSUM calls

Expected Results:
I expect to see the DSUM call computed correctly for each value in my table
plugged into the second row of the criteria field. When the populated value is
the sample constant plugged into the first row of the criteria table, I expect
to see the DSUM evaluation identical to when the formula is calculated
normally, not in a table.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
I'll post a simple spreadsheet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200217/bce5921f/attachment.htm>