[Libreoffice-bugs] [Bug 136864] If columns has a formula in them, and cell is copied or cut to another cell, sort follows (rightly) the copied or cut cell, therefore sort, sorts wrongly.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Sep 17 23:34:23 UTC 2020


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

--- Comment #1 from Mark Mclean <mclean8414 at gmail.com> ---
Created attachment 165644
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165644&action=edit
All sheets locked, no password needed to unlock.

Notes on sheet, all you need to do is click sort buttons. Then move a cell down
and sort again, you will notice numbers begin to go astray. Many hidden columns
where the formulas are at, they look to where pasted cell went to, causing sort
to give wrong results.

-- 
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/20200917/4917e314/attachment.htm>


More information about the Libreoffice-bugs mailing list