Apache OpenOffice (AOO) Bugzilla – Issue 19765
MOD function apparant bug (array calculation)
Last modified: 2013-08-07 15:15:02 UTC
A MOD formula containing a COLUMN function with a range specifed does not evaluate to a number, instead returning Err:504 For example: MOD(COLUMN(C13:N13);2) Should return either a 1 or a 0 Using MOD(COLUMN(C13);2) i.e. no range specified in the column function works as expected, but is not suitable for use in array functions / summing alternate columns in a sheet.
Hi Niklas, I don't know how this can be used but it will not work. So this is yours. Frank
COLUMN returns an array here. So it's related to the array formula stuff that Eike is currently doing.
Accepted.
Accepted I said..
Fixed on branch cws_srx645_cac.
Reassign to QA.
reassigned
reset to fixed
now verified
in cws cac on Linux, Solaris and Windows
Found fixed in src680m30 on Solaris, Linux and Windows