Table Sorting

[colsmith999]

I have a table showing 11 teams in a league.

the top three teams all have 100+ points while the other 8 teams have 90 or less.

When I use sort to organise the team positions in the league i select sort by column 5 (the team points total)
in descending order
and with no header

but when i select sort the top three teams with the 100+ totals are p[laced in the bottom 3 while the other teams are sorted at the top of the table.

is this a bug or have i sorted incorrectly?

[Pablo]

To be able to help you, I need a DEMO project (.wbs file) so I can see all your settings.
Also, please include a description how to reproduce this problem.

I do not need the complete project because that will only take more time to figure out what you have done.
Basically, I just need a small project with one page and object(s) that are relevant to your question.

For further details about how to share a project file, please see this FAQ:
viewtopic.php?f=10&t=82134

[colsmith999]

Hi Pablo,
Thanks for getting back in touch.

I have uploaded a demo project showing just the page with tables that wont sort as I expected to my google drive.
I have re-titled the demo to "Malton Bowls Club V19 (Demo).wbs" and granted access to the file for anyone with the link

Here is the link - https://drive.google.com/file/d/1Y_yXgB ... drive_link

I am selecting the following parameters when sorting
1) Sort by Column
2) Column 5
3) Descending
4) No Header Row

I have found that once the total points of each team passes 100pts the sorting feature creates a quirky result by placing any team with 100+ pts at the bottom of the tables.

To Be clear the tables listing the teams are separate from the title tables above them and so I have scrolled them down by a few pixels to show they are just a basic table listing only the teams.

Looking forward to your reply

Regards

Colin Smith

[Pablo]

Table sorting was designed for strings not for numbers, so the length of the text affects the order.
If you make all numbers the same length (for example, by temporary placing a zero in front of them) then it may work as expected.

I will investigate if I can add support for numbers in the future.

[colsmith999]

Thanks Pablo

The zero in front solved the problem as a temporary workaround

Still impressed with the program even after all these years (I think the first version I purchased was V14)