-
Thanks, jon. I've now displayed format.reverse_sort as well, and there is now no conflict between the sorting displayed on the screen and the sorting reported by the script.
-
My earlier problems arose when the first column was to be sorted reverse. Following leo's remarks, the procedure seems to be:
- If the first sort column is to be forward, add the switch SortReverse=Off.
- If the first sort column is to be reverse, change the sign in front of each column and add the switch SortReverse=On.
- A further principle with double inverted commas seems to be that when there are spaces, one set should enclose the whole list of columns, rather than putting each column in its own inverted commas.
But there are still problems. For example, I have four columns headed 'Filter000', 'Filter 001', 'Filter 002' and 'Filter 003'. Whatever the initial state of the sorting (and independent of inverted commas):
Set Sortby=scp:ADSFiltersAndTags/Filter001,scp:ADSFiltersAndTags/Filter002 SortReverse=Off
sorts first on Filter000 instead of on Filter 001, and second on Filter 002.
Set Sortby=scp:ADSFiltersAndTags/Filter001,scp:ADSFiltersAndTags/Filter002,scp:ADSFiltersAndTags/Filter003 SortReverse=Off
sorts second on Filter000, and third on Filter 003, with no visible column marked as the first sort. I suspect that the first sort is on a script column from another addin, similar to the problem reported the post below.
I tried columns from the addon EmlEmailColumns and got similar results. This all looks like the same problem that I reported earlier of script columns becoming confused with each other — see Can the script addin system become corrupt?