desktop-packages team mailing list archive

[Matt Malone <m_j_malone@xxxxxxxxxxx>]

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