[Solved] Sorting Chess Double Round Robin tournament results

[cool_thing76]

Hi, I'm organizing a chess tournament where all plays all twice (Double Round Robin) in an OpenOffice Calc sheet as seen below. I would like to sort the table by the Points column however this will mess up the whole table. Not sure how to do it.

[Villeroy]

Data>Sort...
Tab: Options
Copy sort result to: <other place>

[John_Ha]

As a new poster you will find much useful information in the Calc Manual - sorting is covered in Chapter 2. When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.

[cool_thing76]

Using the sorts the Data>Sort... method work for that column only. But the rest of the tables results will be wrong. I'm trying to do a cross table like the one below and update it with results periodically.
https://en.wikipedia.org/wiki/AVRO_1938 ... tournament

Thanks

[John_Ha]

Read the manual I pointed you to - it tells you exactly how to do it.

1. Highlight B3 to AQ19
2. Data > Sort ...
3. Sort criteria > Column E. Options > do not tick Range contains labels.

[cool_thing76]

Thanks John. This works. The manual and the context help explains sorting without details of the proper selection. But you made it clear. Thanks again.

[John_Ha]

The manual says

Highlight the cells to be sorted, then select Data > Sort to open the Sort dialog ...