Posted: Mon May 28, 2007 12:18 pm Post subject: sort and random?
Am trying to use the sort command with numbers that were generated by the random function and can't get it to work. I can sort "regular" numbers (not generated by random function). How can I get this combination to work?
Are the random numbers generated anew on each spreadsheet update? (when you change something it gives you new numbers).
If so, I can understand why Calc cannot sort a value that changes when you are working on it. You could try to select the column, than copy and paste as values. That will stop them from updating next time, but they should already be random.
Best wishes,
Oscar _________________ "What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum