Issue 100640 - Tilde operator does not work with COLUMNS function (gives Err:504)
Summary: Tilde operator does not work with COLUMNS function (gives Err:504)
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.0.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-03-29 12:34 UTC by spamrefuse
Modified: 2013-01-29 21:45 UTC (History)
2 users (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 spamrefuse 2009-03-29 12:34:45 UTC
COLUMNS((B3~G3~I3)) = Err:504

I expect this result to be 3.
Comment 1 Regina Henschel 2009-03-29 14:18:56 UTC
I use DEV300m44. I see the same problem in ROWS, ROW, COLUMN. The reference
connection operator ~ works as expected in SUM, PRODUCT or AREAs for example.
But I do not know, whether the spec allows a parameter of type ReferenceList for
the COLUMNS function. It mentions only Reference or Array.