« Charting: Creating a Gantt chart | Main | Paste Special III: Merging rows »
October 06, 2005
Random sort
Unlike Excel, OOo Calc does not have random sort feature. It is straightforward to work around this.Consider the table below - we wish to randomly sort the rows.
Step 1: Add a random number for each row in a seperate column as shown below.
Step 2: Select all columns and invoke the sort dialog as shown below...
We will be sorting our original two columns based on the column of random numbers...
The final result. You can delete the column of random numbers - they have served their purpose.
Posted by Dave at October 6, 2005 09:22 PM