I note that item 139460 refers to a bug in the Linux release but the facility just doesn't seem to be available in Windows You will observe from the default custom sorts released with Win versions that Sun, Mon, Tue, Wed, Thu, Fri & Sat have been pre-defined for obvious reasons. It seems illogical to exclude both the pre-defined and user-defined custom sorts from the available autofilter criteria.
Created attachment 174553 [details] Screenshot You mean this breakdown of dates?
Created attachment 174554 [details] Screen dump No, I mean these dates - created in the specially defined sort filters which a user is unable to select in the autofilter. Nobody is really interested in sorting Days or Months or any other special sort order when they feature as the only entries in an autofilter array as anything but the defined order BUT, if they are then they can simply sort ascending. I do accept that if the dates are stored as internal date numbers then they would sort in order month order but that doesn't get all of January of any year preceding all of February for any year when the data is spanning a number of years.
If there were a simple check box "use a user-defined sort list" and the ability to select the target with the ascending, descending, top ten, etc., acting upon the chosen criteria then that would be awesome.
There is a "sort of" workaround which requires a month number to be assigned to an adjacent cell where Jan = 1, Feb = 2, etc., and then sort/filter on that column but 10,000 extra function cells is quite tedious when the custom sort filters have already been created.
Custom sort order works for me on Linux. The question goes to QA whether this a Windows related bug.
(In reply to Heiko Tietze from comment #5) > Custom sort order works for me on Linux. The question goes to QA whether > this a Windows related bug. How in Linux do you indicate to the custom sort panel that you need it to utilise one of the custom sort lists - all I see in your image is sort on a date column. There's nothing there to even indicate the presence of any user-defined sort lists. Perhaps you could try creating a sort list of names based on your childrens' ages so you could also sort according to that without having to store their dob. Try a user sort list of:- James Sara Thomas Matthew Hannah and then use the filter sort, it will undoubtedly give:- Hannah James Matthew Sara Thomas Because even in your screen image, there's no way to tell LO "use my sort list". Also for consideration, if using the sort list and an item isn't contained in that list - How would it be sorted? Ignore it? Sort A-Z or Z-A before or after the sort list entries? Sort A-Z or Z-A within the appropriate empty spaces of the "valid" sort entries?
After clarification of the issue I do: * A1..A4: Jan, Mar, Feb etc. * Data > Sort: Options > Custom Sort Order = Jan,Feb... I thought this is not working on Windows. (In reply to Colin from comment #0) > I note that item 139460 refers to a bug in the Linux release but the > facility just doesn't seem to be available in Windows
(In reply to Heiko Tietze from comment #7) > After clarification of the issue I do: > > * A1..A4: Jan, Mar, Feb etc. > * Data > Sort: Options > Custom Sort Order = Jan,Feb... > > I thought this is not working on Windows. > > (In reply to Colin from comment #0) > > I note that item 139460 refers to a bug in the Linux release but the > > facility just doesn't seem to be available in Windows Aha, approaching the issue from two different directions. I can confirm that Data>Sort does indeed permit calling a custom sort list in Windows - in all honesty, I wasn't aware of this route. I can also confirm that you get some really interesting results if you pick the wrong custom sort list🤦♂️ I filled Jan - Dec and then used the "day" custom sort list. Should I report this as a bug or just an overambitious user? Apr Aug Dec Feb Jan Jul Jun Mar May Nov Oct Sep This obviously relates to my earlier question concerning the procedure if the data contains items not included in the custom list. My original issue was that the facility was not available in the "autofilter" drop-down panel above any column. I imagine more users are reliant upon the facilities they see attached to this array process. Today was a good day - I learned two things😎
(In reply to Colin from comment #8) > (In reply to Heiko Tietze from comment #7) > > I can confirm that Data>Sort does indeed permit calling a custom sort list > in Windows - in all honesty, I wasn't aware of this route. > > I can also confirm that you get some really interesting results if you pick > the wrong custom sort list🤦♂️ > > I filled Jan - Dec and then used the "day" custom sort list. Should I report > this as a bug or just an overambitious user? Further analysis identifies that if any days are featured in the selection array (avoiding the autofilter controls), they do indeed sort according to the custom sort list, with any non-matching elements simply being sorted according to the defined A-Z or Z-A criteria, placed appropriately to the defined "day sort" result.
Wouldn't clutter the autofilter further with custom lists. And actually this sorting is not a filter, so unrelated anyway. And ultimately not a bug :-).
(In reply to Heiko Tietze from comment #10) > Wouldn't clutter the autofilter further with custom lists. And actually this > sorting is not a filter, so unrelated anyway. And ultimately not a bug :-). It was never reported as a bug but as an enhancement suggestion. However, I agree that the Data>Sort & Tool Button Sort both perform the desired function. Great care needs to be exercised in the array selection because I imagine selecting only half the columns of an autofiltered array with cell references into and out from the sort filter array and then sorting on a custom list has great potential for.................