Hoist Worksheet Sorting

[Wesley Burrows]

I'm almost certain this is a stupid question but for the life of me I can't figure out why when sorting ascending negative values (X on a motor X,Y sheet).   Why I get this:  

 

Logic would dictate that -45 is less than -15.   it seems like it should sort as,    -45, -15, 15, 45.    What am I missing?  (This was generated with Spotlight > Reports > Create Hoist Worksheet. 

 

[JBenghiat]

This is an issue in 2018 — Vectorworks isn't always recognizing data as numeric if the cell began as a text field.  You can see that the text is left justified, which is incorrect for numeric values.  You can try reformatting the row and recalculating.