[Libreoffice-bugs] [Bug 131442] Sorting breaks array formula

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131442

--- Comment #5 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Eike Rathke from comment #4)
> The same buggy effect can be triggered with other array formulas such as
> ={6;4;2;5;3} and then sorted at least already in LO 5.3.7.
> 
> IMHO allowing to sort such an array formula is already wrong.

Definitely; and in fact, I chose RAND as the easiest formula allowing me to
show the behaviour; I didn't think about ={6;4;2;5;3}.

And MS Excel disallows that sorting (with usual "you can't change part of array
formula").

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200328/6214e8c0/attachment.htm>