https://bugs.documentfoundation.org/show_bug.cgi?id=171183
--- Comment #3 from ady <[email protected]> --- (In reply to Regina Henschel from comment #0) > LibreOffice erroneously forces an array context: > =TYPE({"A";999;"B"}) > =TYPE(MUNIT(2)) I understand that '=TYPE({"A";999;"B"})' should produce one unique value of 64 (not an array of 3 cells with 64 in each of them). I can reproduce the incorrect array of 64's. The same goes for '=TYPE(MUNIT(2))', where the result should be one cell with 64, not an array of cells with each cell containing the result of 64. The reason is that the argument is an array, but the '=TYPE(...' formula is not introduced as an array. This is a bug in the TYPE() function. I just want to point out, just in case, that in attachment 205983, cells B31 and B36 are a _contrast_ to what TYPE() is doing as of LO 26.2: SUM() and COUNTA(), both being introduced as _non-array_ formulas, take the array argument and the return is not an array (as expected IIANM), but TYPE() returns an array result (based on the array argument) when the formula is not an array (which is a bug for the TYPE() function). IOW, TYPE() is (incorrectly) propagating the array argument into an array result, when the formula itself is not introduced as an array. If the TYPE() formula were to be introduced as an array, that would be a different situation. I hope I got that correctly. -- You are receiving this mail because: You are the assignee for the bug.
