https://bz.apache.org/ooo/show_bug.cgi?id=114293
--- Comment #4 from [email protected] --- Unbelievably it works on Excel 2007: COLUMNS(COLUMN(A1:B1)) = 2, yet TYPE(COLUMN(A1:B1)) = 1 and using COLUMN(A1:B1) in DSUM()'s parameter 2 takes the first value, ie. 1, no matter where the formula is placed. Not sure what Excel does; selecting 2 horizontally adjacent cells and typing =COLUMN(A1:B1) Ctrl+Shift+Enter gives 1 and 2, typing =TYPE(COLUMN(A1:B1)) pressing Ctrl+Shift+Enter gives 64 and 64, so what, does it automatically convert array formulas to scalars when going into 1 cell instead of several? -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
