https://bugs.documentfoundation.org/show_bug.cgi?id=104888
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #4 from Eike Rathke <[email protected]> --- The tested scenario with MMULT() is slightly different from the original request though, because MMULT() delivers a matrix that now (since 7.4, see https://wiki.documentfoundation.org/ReleaseNotes/7.4#Calc "Automatic cell matrix expansion"...) is automatically recognized to be spread as array/matrix formula, so forgetting to use Shift+Ctrl+Enter does not have any effect with MMULT(). To reproduce the original request use A1: -1 A2: -2 B1: =ABS(A1:A2) and close B1 only with Enter, result will be 1 because of the intersection of B1 with A1:A2. On B1 press F2, hit Shift+Ctrl+Enter and it stays the same. It should change to an array/matrix formula delivering {1;2}. -- You are receiving this mail because: You are the assignee for the bug.
