@Björn Michaelsen > The 4.2.7-0ubuntu1 package should now satisfy the fdo#81633
Please try the attached test file along with the attached test cases in 81633 such as test_offset.ods and Calc bug.ods. None of these work with Ubuntu's Calc 4.2.7.2, but worked just fine under 4.2.6. > Apparently these two reddit users are not aware that they have exactly opposing opinions on the expected behaviour. As Manuel pointed out, what people want is the old sorting behavior back. They're probably using the wrong terminology because this change is confusing and requires toggling a secret option (update refs) that is not well documented. While 4.2.6 may not have been perfect, as least it mostly followed the industry conventions of updating relative references, while never updating Absolute references. It did this automatically, without the need to toggle any settings that require a restart. Take a look at the use cases in FDO# 85490 to see how many spreadsheets sorted fine in 4.2.6 and Excel but with 4.2.7 there is no clear UpdateRefs setting that always works. To be clear, with 4.2.7 there is no way to return to the old style sorting routine. Some spreadsheets that worked fine in Excel and 4.26 require UpdateRefs=True, while others require it to be false. Others are broken with either UpdateRefs setting because of bugs introduced in this new sorting routine. Is it any wonder users are confused? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1389858 Title: Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1389858/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
