[Issue 114293] DSUM error 504 due to second parameter (field number)

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=114293

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damjan@apache.org

--- Comment #3 from damjan@apache.org ---
TYPE(COLUMN(A1:B1)) = 64, an array formula.
TYPE(COLUMN(A1:B1) + 1) = 64, an array formula.
TYPE(N(COLUMN(A1:B1))) = 1, a number.
TYPE(another cell with precalculated value) = 8, a scalar formula (had you
pressed Shift + Ctrl + Enter instead of just Enter when calculating that cell,
it would be 64 for array formula).

You are expecting {1, 2} to be used to choose 1 column. How could that ever
work? According to ODFF, DCOUNT() expects a string for the column name, or an
integer counting left to right starting at 1. Array formulas are undefined.
Maybe an implicit conversion using an implied intersection could make sense,
but your formula isn't in columns A or B, and that doesn't work even if you put
it there (is that a bug?).

What does Excel do?

This should probably be RESOLVED NOT_AN_ISSUE.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.