Issue 19765 - MOD function apparant bug (array calculation)
Summary: MOD function apparant bug (array calculation)
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
Depends on:
Blocks: 20494
  Show dependency tree
Reported: 2003-09-18 16:33 UTC by Unknown
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-09-18 16:33:32 UTC
A MOD formula containing a COLUMN function with a range specifed does not 
evaluate to a number, instead returning Err:504 

For example:


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.
Comment 1 frank 2003-09-19 08:50:47 UTC
Hi Niklas,

I don't know how this can be used but it will not work. So this is yours.

Comment 2 niklas.nebel 2003-09-19 15:56:30 UTC
COLUMN returns an array here. So it's related to the array formula
stuff that Eike is currently doing.
Comment 3 ooo 2003-09-22 11:05:20 UTC
Comment 4 ooo 2003-09-22 11:14:44 UTC
Accepted I said..
Comment 5 ooo 2003-11-06 21:09:22 UTC
Fixed on branch cws_srx645_cac.
Comment 6 ooo 2003-11-07 18:17:31 UTC
Reassign to QA.
Comment 7 frank 2003-11-13 11:54:32 UTC
Comment 8 frank 2003-11-13 11:55:09 UTC
reset to fixed
Comment 9 frank 2003-11-13 11:55:30 UTC
now verified
Comment 10 frank 2003-11-13 12:01:00 UTC
in cws cac on Linux, Solaris and Windows
Comment 11 frank 2004-03-16 14:20:34 UTC
Found fixed in src680m30 on Solaris, Linux and Windows