← Back to team overview

desktop-packages team mailing list archive

[Bug 1389858] Re: Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort

 

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


References