I configured a new machine with Ubuntu 14.04 months ago. I have been gifted with LibreOffice 4.2.7.2. I was using Ubuntu 12.04 before that, and had LibreOffice 4.1.something. Before that I was using OpenOffice, before that Excell, before that Easy-as-123. All of them update references consistently. I have never noticed an inconsistency in them in about 25+ years of using spreadsheets.
With 4.2.7.2 I immediately noticed that I was unable to sort all 2582 rows of my spreadsheet at once -- it simply crashed. (a different bug) I have been working with 4.2.7.2 now for MONTHS and only today did I find that it does not sort references properly. You cannot imagine my disappointment. You cannot imagine the time it is going to require to unmangle this spreadsheet if that is at all possible. It represents 8 years of my work. Luke (lukebenes) wrote on 2014-11-06: >Why are we breaking old spreadsheets and interoperability for a few users that >don't know how to use absolute references? Absolutely. Nothing else needs to be said. If the people who want a different type of reording the contents of rows of a spreadsheet want it to do something non-sensical, then, add a new and completely different function called MANGLE and leave SORT alone to work has it has for decades. Sort should work exactly and only like one resorted the sheet by hand by cutting and pasting entire rows. Anything else just violates the entire concept that rows are records and must stay together. If your rows do not represent records that must stay together and you want a result that cannot be achieved by cutting and pasting entire rows then you want to do something other than SORT. This comment represents only a tiny fraction of the time I will spend correcting the months of mangling caused by this stupidity. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1389858 Title: Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort Status in “libreoffice” package in Ubuntu: Triaged Bug description: Update to LibreOffice 4.2.7 is causing incorrect sort behaviour in Calc. As initially reported here: http://www.reddit.com/r/Ubuntu/comments/2le7qu/libreoffice_calc_update_a_few_hours_ago_is_buggy/ Attached is sample Calc document. To reproduce, highlight B6 to E14, select Sort and sort by Column D, see that column E didn't get sorted. ProblemType: Bug DistroRelease: Ubuntu 14.10 Package: libreoffice (not installed) ProcVersionSignature: Ubuntu 3.16.0-24.32-generic 3.16.4 Uname: Linux 3.16.0-24-generic x86_64 ApportVersion: 2.14.7-0ubuntu8 Architecture: amd64 CurrentDesktop: Unity Date: Wed Nov 5 15:49:03 2014 InstallationDate: Installed on 2013-11-26 (344 days ago) InstallationMedia: Ubuntu 13.10 "Saucy Salamander" - Release amd64 (20131016.1) SourcePackage: libreoffice UpgradeStatus: Upgraded to utopic on 2014-10-08 (27 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1389858/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
