OpenOffice Calc Sorting Columns won’t work

Asked By 220 points N/A Posted on -
qa-featured

OpenOffice Calc Sorting Columns won’t work

Hello,

I am working with my task in ODesk and collecting names from Facebook. I put those names on the first column (A) at random. I want it presentable when submitting to my employer so I decided to sort the names from A to Z. So I highlighted the first column which is the Column A and after clicking the sort button on the toolbar I notice that the first record doesn’t move to its correct location.

The name starts with the letter M, and that should be moved about on the middle of the list. I repeat the action but still don’t work. I created new worksheet but still problem occurs. Did I do wrong in sorting records? Please help.

SHARE
Answered By 0 points N/A #125993

OpenOffice Calc Sorting Columns won’t work

qa-featured

 

At default when you are sorting records in a worksheet form, you are expected to have the heading because you are entering records in a table form. OpenOffice.Org did this settings or scenario. So if you are sorting list which is encoded in just one column, you need to have the heading title maybe on the first row of the list. Item on the first row will be treated as the header that is why in your sorting action the first was not moved on the right place or it is not included on the sorting order. Doing this needs you also a correct procedure or action. If you have encoded the header on the second row (A2), you must select only from the second row down to the last row of your records. Because even if the first row is empty and you include it in your selection to sort the record, the first row will be treated as the header row and the header you have input in the second row will be treated as the data.

Login/Register to Answer

Related Questions