Worksheet column sorting levels

[Ross McLee]

Hi,

Is there an easy way to change the "sort order - order" in a worksheet?

In Excel ,Microsoft refers to sort order "levels" which can be moved up and down (e.g. sort by Column A first, then by column B and then by column C) You have a relatively friendly dialogue box where you can move those levels up and down. I can see the little numbers within the worksheet column header icons that show the order levels, so I can see the order in which they are applied, but the only way I can change the 'levels' is to remove all the sorting completely and start again.

 

I looked here - but nothing mentioned - notably bullet option 5 doesn't work (perhaps this is an older feature now removed (I'm using 2021)

https://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Database_Row_Sort_and_Summary_Functions.htm

 

I know there are movements afoot to update worksheets significantly for the next release - so here's hoping 🙂

R

 

[Pat Stanford]

The help page you linked was from VW2016.  Worksheets changed a lot in either 2017 or 2018, so it is out of date.

 

Unfortunately, there is no easy way to change the sort order. Only option is to remove and reapply the sorts in the desired order.

[michaelk]

Except by scripting it 😃

 

Try these.  Make any cell in a database column active.  Run the script that sounds like it will do what you want.  It will sort up, sort down, summarize, sum values, or remove any or all of the above.

 

(I too miss the old way of quickly moving "badges" between columns to reorder sorts.  But I have to admit the new way is WAY WAY WAY more discoverable.  Nobody could figure out the old way on their own.  These scripts are almost as good as the old way.)

 

 

Worksheet Sort Scripts.vwx

[Sam Jones]

45 minutes ago, michaelk said:

These scripts are almost as good as the old way.)

 

Cool.  I'm looking forward to checking them out.