Some may arrive here and be confused about that to do, given comments #22 and #25. How do I end any possibility of corrupting my spreadsheet with LibreOffice? This is how I ended the on-going damage to a years-old spreadsheets. I opened a terminal and pasted this:
sudo apt-get remove --purge libreoffice* libexttextcat-data* && sudo apt-get autoremove I got that from a A00 page describing how to remove LibreOffice and install AOO. I was sorely tempted to just keep following their instructions. But I decided that an old version of LibreOffice untouched by this enhancement stupidity would be adequate. I found a link to LibreOffice 4.1.6.2 navigated to x86-64 as my desired version and downloaded it with firefox, landing in my Downloads directory: http://downloadarchive.documentfoundation.org/libreoffice/old/4.1.6.2/deb/ I then went to my Downloads directory: cd ~/Downloads tar -zxf LibreOffice_4.1.6.2_Linux_x86-64_deb.tar.gz cd LibreOffice_4.1.6.2_Linux_x86-64_deb/DEBS sudo dpkg -i *.deb I left that in my downloads directory in case anyone can give me a compelling case to try another version and risk years of work on it. If it does not work, I can repeat: sudo apt-get remove --purge libreoffice* libexttextcat-data* && sudo apt-get autoremove cd ~/Downloads/LibreOffice_4.1.6.2_Linux_x86-64_deb/DEBS sudo dpkg -i *.deb And get back to something I am sure works for me. 4.1.6.2 behaves in a way consistent with other spreadsheet programs. Other versions might work for you. I have appreciated that a Google search has solved all my Ubuntu problems in the past when I discover recipe pages with copy and paste command lines. I hope mine work for you. My version immediately asks me if I want to upgrade NO THANKYOU When no one has reported a mangled spreadsheet for months, then I will consider it. -- 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

