Created attachment 105399 [details]
sample of bug
Open attached file "calcsort.ods".
Sort column A,B,C,D by column A.
Cell A, B, D are sorted. But cell C is not.
Ctrl - Z
Result of the formula is broken.
Look at "calc_sort_explain.pdf".
Created attachment 105400 [details]
This issue occurs with LibO Calc 4.3.1, not with 4.3.0. It seems as a regression bug with 4.3.1.
In my case:
- After sorting, column C (contains sum() formula function) changes nothing
- However, after undo (ctrl-Z), all column except C undo sorting, and column C sorted at this time
Now I tried nightly (Build ID: 1babe37e4871b47e37bef35378a5cf622948aeca) and it works fine for me.
- Sort by column A: every columns includes C sorted well
- Ctrl-Z undo every columns includes C as a starting order
I can confirm Naruhiko, not reproduced in latest daily:
Build ID: 266a9536b5abf4c36fed1785ae657da923bbbb8d
TinderBox: Linux-rpm_deb-x86@45-TDF, Branch:libreoffice-4-3, Time: 2014-08-29_03:57:12
Anyway it seems to be a duplicate of Bug 45146 or Bug 81309. Please change the status as duplicate if you think so.
In fact this bug is a duplicate of bug 79441 which is fixed in version 188.8.131.52 :
Best regards. JBF
*** This bug has been marked as a duplicate of bug 79441 ***