In Tools > Options > Calc > General there is the check "Update references when sorting range of cells". Click in Help shows all kind of info; not for this feature. Feature introduced in 4.4. Still missing in Version: 6.0.0.0.alpha0+ Build ID: 616f21db9e50a77b0c02dfb123f871a742f46216 CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-10-16_22:37:26 Locale: nl-NL (nl_NL.UTF-8); Calc: group
Cor: do you still plan to work on this one or can we unassign this tracker and make it available?
background info : https://forum.openoffice.org/en/forum/viewtopic.php?p=340154&sid=50fd23aae2a37ddd28574d4a980d0042#p340154 https://ask.libreoffice.org/t/sorting-a-range-that-is-referenced-elsewhere/17631/7 https://ask.libreoffice.org/t/how-to-protect-the-results-of-a-formula-so-it-survives-later-sorting-libreoffice-calc/79093/6
https://ask.libreoffice.org/t/option-update-references-when-sorting-range-of-cells/103334
(In reply to Julien Nabet from comment #1) > Cor: do you still plan to work on this one or can we unassign this tracker > and make it available? Hi Julian, Thanks for asking. I'm gradually returning here - all will take some time. If someone else jumps in: all fine.