<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Can't use "Multiple Operations" with a DSUM function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130722">130722</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Can't use "Multiple Operations" with a DSUM function
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>Other
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>danchall@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>