@Manuel Iglesias Alonso Both LO 4.1.6.2 and Excel 2013 will change B7=Customer1 after sorting. The issue is with your spreadsheet NOT with Calc’s sorting function. I have attached an example of how to correctly design a sortable spreadsheet to meet your desired goals. By using a lookup function, this spreadsheet will work in all spreadsheet software with default settings.
Please consider using other resources such as forums and Ask LO/Ask Ubuntu instead of issue trackers for help. Posting bug reports for software your unfamiliar with just adds noise to the development process. ** Attachment added: "Test2 with a lookup function instead of reference" https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1389858/+attachment/4280641/+files/Test2Correct.xls -- 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: Fix Released 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