daysbas.blogg.se - How to alphabetize in openoffice writer

The default is to sort by columns unless the selected cells are in a single column. Select the box, then choose from the drop-down list one of the sort orders defined in Tools > Options > Calc > Sort Lists. If a range contains cells that already have content, then the sort fails. If a range is specified that does not have the necessary number of cells, then cells are added. Sets a spreadsheet address to which to copy the sort results. If formatting is used to distinguish different types of cells, then use this option. If two entries are otherwise identical, one with an upper case letter is placed before one with a lower case letter in the same position if the sort is descending if the sort is ascending, then the entry with an upper case letter is placed after one with a lower case letter in the same position.ĭoes not include the column heading in the sort.Ī cell's formatting is moved with its contents. On the Options tab of the Sort dialog, you can choose the following options: Now, hit OK.Choosing the criteria and order of sorting

Select cell A1, select Menu Data -> Sort select first year, then month don't hit OK yet (otherwise the months would get sorted alphabetically), but select Options -> Custom sort order select the months sort order.In the following dialogue, select Space as delimiter, then hit OK.Select column A, select Menu Data -> Text to Columns.Insert a new column next to col A for the year values: select column B, select Menu Insert -> Columns.When sorting, OpenOffice / LibreOffice recognizes the dates and sorts by month/date. The displayed cell content will stay "September 2011" because of the custom cell format using the code MMMM YYYY. Select cell A1, apply sorting using Menu Data -> Sort by column A ("month").Īs result, OpenOffice / LibreOffice transforms the values of column A into dates (for example, instead of September 2011).

In field Search for, enter a single dot, and in field Replace with an ampersand ( &) hit More Options, tick Regular Expression.

With the cells still selected, select Menu Edit -> Find & Replace.

> Numbers Įnter the following format code in the Format Code field: MMMM YYYY In Open Office, sort option is used to arrange the selected set of data in ascending or descending order.

Select the cells holding the month/year values.

You could split the text values into two columns (month and year separately) and sort first for year, then for month (see Solution 2 below).

You could transform the values of column A as dates so OpenOffice / LibreOffice can sort them accordingly (see Solution 1 below).