Hi Peter, On Sun, Jul 17, 2005 at 10:41:21 +0200, Peter Flicker wrote:
> This I can do by using the RNDBETWEEN function. I then need to manipulate > the data obtained as a result, but if I use SORT on the data, it seems to try > and sort the undelying function in the cell and not the data. Your problem apparently is that the formulas get recalculated and thus produce a different result after being sorted. Copy the cell range to the clipboard and then use Edit.PasteSpecial, uncheck PasteAll and check only Numbers before pasting. Use Data.Sort on the pasted data. Eike P.S.: Please consider to subscribe to the mailing lists you're posting to. By doing so you won't miss replies that are directed to the list only. Please reply only to the list, not to my personal account. Thanks. -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
