Created attachment 99028 [details]
file were partial sorting causes problems
LibreOffice Version: 220.127.116.11 Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8 on Russian Windows XP Professional SP3 (32bit)
If we try to open Example_34.ods file in LibreOffice, select cells A4:E38 and make Sort Ascending and after that immediately Undo: Sort (or Ctrl+Z) that we'll see that some cells (from cell F25 to F39) have a value other than the original (cell F25 had value 1677,13 after such operations became 1669,87; cell F27 had value 527,64 after such operations became 525,86 and so on). If we select full rows (A4:AMJ38), than after Undo all is fine.
In LibreOffice Version 18.104.22.168 there was no such problem with partial sorting.
Hi Timon, thanks for reporting.
All you need to do is a hard recalc [Shift+Ctrl+F9].
Maybe cells are not marked after undo, and is needed a hard recalc.
But I can agree it's a bug.
Not reproduced in LO 22.214.171.124 under Ubuntu 12.04 x86.
Perhaps it's been fixed somewhere between 4.2.5-4.2.6
In LibreOffice Version: 126.96.36.199 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0 problem was also fixed.
In LibreOffice Version: 188.8.131.52 Build ID: 958349dc3b25111dbca392fbc281a05559ef6848 problem is back again!
Cells are different (cell F5 had value 60,11 after such operations became 153,33; cell F8 had value 42,30 after such operations became 12,23; cell F13 had value 131,78 after such operations became 33,16 and and as a result the total amount in F39 is also incorrect).
Hard recalc [Shift+Ctrl+F9] helps to solve problem, but that bug should be fixed.
The last fix for bug 80846 solved the problem here. See https://bugs.freedesktop.org/show_bug.cgi?id=80846#c58
I mark this bug report as a duplicate of bug 80846. Backport of the fix to 4.3 is on the way.
Best regards. JBF
*** This bug has been marked as a duplicate of bug 80846 ***