Openoffice-sorting data in columns ?

C_Mababejive

Hi all..

Using open office calc..

I have a column of dates in column A rows 1 to 100.

In the column B i have numerical data which aligns with its corresponding date in column A.

Unfortunately when i input the dates in coulmn A ,they were not in calendar order.

What i need to do is sort the date column A into date order from oldest date in A1 to oldest but i also need to keep the corresponding data in column B in alignment with its date after sorting..

Any clues welcome

[Deleted User]

Hi,

highlight the cells you want to sort, then use the a-z or z-a button to sort, if you get it wrong, use the undo button.

cookie365

Seriously?

Openoffice doesn't keep adjacent columns in sync when you sort unless you select them first?

Can it really be that rubbish?

bluesnake

cookie365 wrote: »

Seriously?

Openoffice doesn't keep adjacent columns in sync when you sort unless you select them first?

Can it really be that rubbish?

Neither did office a few versions back and am surprised if it does it now, as it is sometimes useful to sort one column without sorting the others.

in Excel, was always told to select the top left most area, the blank square that intersects the rows and the columns before touching the sort feature

tronator

cookie365 wrote: »

Seriously?

Openoffice doesn't keep adjacent columns in sync when you sort unless you select them first?

Can it really be that rubbish?

According to this website, Excel (and any other sane program) does it the same way.

cookie365

If you've laid out your table correctly - no blank columns or rows - then in Excel you just need to click a single cell in the column you want to sort by, and all the rows will stay unbroken.

tronator

cookie365 wrote: »

If you've laid out your table correctly - no blank columns or rows - then in Excel you just need to click a single cell in the column you want to sort by, and all the rows will stay unbroken.

Who is to tell me whether my table is laid out correctly? If I want empty rows, then there will be empty rows.

And what if I really only want to sort column A, but leave the others untouched? How do you do that?

cookie365

tronator wrote: »

Who is to tell me whether my table is laid out correctly? If I want empty rows, then there will be empty rows.

And what if I really only want to sort column A, but leave the others untouched? How do you do that?

Select column A before you click sort.