Created attachment 115398 [details]
Name-management dialog showing unsorted names list
Build ID: 184.108.40.206 Arch Linux build-1
I am working on a (largish: ~400k) spreadsheet with 6 tabs with more than 120 named ranges (added organically as the spreadsheet grew), most of them only in the scope of a single sheet.
When defining more named ranges, new names seem to be placed more or less randomly in the list, with no way to sort them differently. This makes it quite hard to re-locate them when needed.
See attachment for a screenshot of the issue Unfortunately I can't share the document as it contains private information.
It would be good if they were sorted by name or, better, if the list could use custom-column sort.
Valid enhancement, setting to NEW
Olivier: I've made column header clickable, so now clicking on it sorts the items by given column alphabetically, 1st time ascending, 2nd time descending ... I thought this was what you meant by custom column sort. Lemme know if this is acceptable
Yes, it does sound like what I was thinking of. Is the code somewhere I can test it to confirm?
Katarina Behrens committed a patch related to this issue.
It has been pushed to "master":
tdf#91126: Enable click-on-column-header sorting
It will be available in 5.0.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
There goes the code :)
Hi, sorry for the delay in answering.
I just got 220.127.116.11 Arch Linux build-1 installed, and the sorting indeed works nicely.
I'll need to play a bit more to check whether names jump around, but I doubt they will.
Yup, the entries don't jump around anymore. It's much easier to manage. Thanks!