OpenOffice Calc Sorting Columns won’t work

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.