Apache OpenOffice (AOO) Bugzilla – Issue 100640
Tilde operator does not work with COLUMNS function (gives Err:504)
Last modified: 2013-01-29 21:45:02 UTC
COLUMNS((B3~G3~I3)) = Err:504 I expect this result to be 3.
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.