https://bugs.documentfoundation.org/show_bug.cgi?id=133260
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
Status|UNCONFIRMED |NEEDINFO
Ever confirmed|0 |1
--- Comment #4 from Eike Rathke <[email protected]> ---
Can we please have an original Excel sample file attached, not a WPS generated
one, to see what Excel actually stores for this case? Thanks.
And yes, one has to modify a formula expression before a change is detected,
otherwise the formula cell is not re-entered, appending and removing a blank is
already enough. This is independent of whether a function would force array
mode or not.
Btw, can someone please check if Excel forces array mode whenever an inline
array is present as argument where the parameter expects a scalar value (like
SUMIFS() 3rd parameter)? For example
=SUM(ABS({-2,-4}))
does that yield 2 or 6?
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
