Issue 100640

Summary: Tilde operator does not work with COLUMNS function (gives Err:504)
Product: Calc Reporter: spamrefuse <spamrefuse>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rb.henschel
Version: OOo 3.0.1Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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.