Description: Before sorting by date column: Date Sales Per Day Sales Accumulated 10/01/16 $100.00 $100.00 10/03/16 $100.00 $200.00 10/20/16 $100.00 $300.00 10/02/16 $100.00 $400.00 After sorting by date column: Date Sales Per Day Sales Accumulated 10/01/16 $100.00 $100.00 10/02/16 $100.00 $400.00 10/03/16 $100.00 $200.00 10/20/16 $100.00 $300.00 <---different total!!! Obviously we should end at $400 on the bottom right. The formula (of third column) was only to add the cell above to the cell on the left. I will attempt to attach the files. Steps to Reproduce: 1. see description Actual Results: Wrong final total due to sorting by date! Not obvious to user! Expected Results: Accurate final totals preserved in sorting! Reproducible: Always User Profile Reset: Adjust the formulas in sorting to point to new cells. For example the $400-showing cell (C3) after sort should have had new formula C2+B3, but had formula C5+B3 Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:45.0) Gecko/20100101 Firefox/45.0
Created attachment 128333 [details] After the sort by date
Created attachment 128334 [details] Before sorting by date
Created attachment 128335 [details] Spreadsheet Used
There is an option in: Menu/Tools/Options/LibreOffice calc/General - Update references when sorting range of cells. that looks you have enable, with it I can reproduce your issue, disable it and sort it's fine. Resolved as not a bug, please if you are not agree, reopen it.
No I do not see the option you describe in my menu. I will attach a screenshot.
Created attachment 128337 [details] Screenshot of options menu
Please update your version, I remember there was a long discussion when it was enable by default, solution was make available an option for that. The option is available at least since version 4.4 On your version I think you can change it on: Menu/Tools/Options/LibreOffice/Advanced - Expert configuration. Change the key: /org.openoffice.Office.Calc/Input - UpdateReferenceOnSort to false.
Created attachment 128350 [details] Screenshot of Expert Window
Thank you for your helpfulness! Unfortunately I can't upgrade because I'm using an OS called Tails which (is great but) has this version embedded and is hard to change. But I'll try to ask them to upgrade. As for finding your option in the list, I didn't see it in my Expert menu (attached). But you don't owe me support. So since you've already fixed it in a later version, please feel free to change status to RESOLVED.
Ok, last you can try it's edit directly that key on the registrymodifications.xcu file, what you can find on the profile. https://wiki.documentfoundation.org/UserProfile#Location_based_on_Tools.C2.A0.E2.96.B8_Options.C2.A0.E2.96.B8_LibreOffice.C2.A0.E2.96.B8_Paths