-----Original Message----- >From: Keith Bainbridge <[EMAIL PROTECTED]> >Sent: Aug 8, 2006 6:43 AM >To: [email protected] >Cc: [EMAIL PROTECTED] >Subject: Re: [users] Sorting data on spreadsheet > >G'day "Bruce > >Have you entered the data as numbers - not plain text?? > > >On Tue, 8 Aug 2006 15:06:48 +1200 (New Zealand Standard Time) >"Bruce & Frances Ardern" <[EMAIL PROTECTED]> wrote: > >> I have a spread sheet with data in columns A to M (except for J) and rows 6 >> to 25. I want to sort on columns K then L then M (in one sort) shifting the >> data in columns A to I with the original numbers in K to L >> >> I have used Excel to do this before without any problems but can't get Calc >> to do it. I have been highlighting the area A6 to M25 and then going Data, >> Sort, and in the dialogue box selecting the columns in sort order and >> whether Ascending or Descending. After I hit OK no matter what I change the >> Ascending or Descending to in the different columns there is no change to >> the order of data. >> >> Can anyone pinpoint what I am doing wrong here. Running Oo 2.0.3 on Win XP >> >> Also the spreadsheet was created using Oo 1.4 and now keeps crashing using >> Oo2.03 >> Keith and Bruce:
It should not matter if the numbers are plain text or integers (numbers). The sort should run. What concerns me is that this is not the first report of a spreadsheet crashing OpenOffice.org to the desktop. I worked on one issue and could not get it to repeat, but I am using Mac OS X and not the Windows version. Also, which Native Language version are you using? Bruce: Could you please open an issue on the OpenOffice.org IssueZilla and attach the spreadsheet if it does not contain personal data. If the spreadsheet contains personal data, please send it to me: [EMAIL PROTECTED] so that I can attempt to recreate the crash. Thank you. James M. Mac OS X QA Test Lead, American English --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
