https://bugs.documentfoundation.org/show_bug.cgi?id=38014
--- Comment #25 from Eike Rathke <[email protected]> --- Adding content of comment https://bugs.documentfoundation.org/show_bug.cgi?id=158895#c3 so it doesn't get lost: A formula expression not being compiled anew if not modified is on purpose as it usually is unnecessary and only forces recalculation, also of all dependencies. However, if it previously was not an array formula but now is closed with Shift+Ctrl+Enter instead of Enter that should be differentiated and the expression be compiled as array formula. Note that the opposite, formula was array but now is closed with plain Enter, should _not_ be recompiled to not destroy the array mode context. I don't recall why a case such as {=SUM(IFERROR(B6:B125,""))} entered (that creates a text cell) and being edited removes the {} and treats content as normal formula. Probably there was a feature request to do so.. -- You are receiving this mail because: You are the assignee for the bug.
