@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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1389858 Title: Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1389858/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
