@Manuel Iglesias Alonso Please refer to: http://www.dummies.com/how-to/content/looking-up-data-in-excel-2007-with-hlookup-and-vlo.navId-323123.html
Your attached document is designed wrong. This is a classic mistake made by people who don't understand how spreadsheets function. If you sort it with Google Sheets, Excel, Open Office Calc, LO Calc 4.2.8, Gnumeric, or WPS sheets they will all produce the same, correct results. Why? You used references when you should be using a table lookup function. If we change the default sorting behavior to fix your broken spreadsheet, all spreadsheets through out the history of spreadsheets software would be incompatible with Libreoffice's sorting routine. You can have your broken sorting behavior by changing the option UpdateRef=TRUE. But be warned: your spreadsheet will NOT sort correctly on any other spreadsheet software, include libreoffice with default settings. A much better solution is to design your spreadsheets correctly by using a lookup function. -- 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 Productivity Suite: Unknown Status in libreoffice package in Ubuntu: Fix Released Status in libreoffice source package in Trusty: Fix Released 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/df-libreoffice/+bug/1389858/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp