Sort Descending
Sorts the data of the selected field or cell range in descending order. Text fields are sorted alphabetically, number fields are sorted by number.
Data of the currently selected field are always sorted. A field is always selected as soon as you place the cursor in the field. To sort within tables, you can also click the corresponding column header.
To sort more than one data field, choose Data - Sort, then choose the Sort Criteria tab, where you can combine several sort criteria.
Sorting a block of cells in Cool Office Suite Calc
A block of cells is a rectangular range of cells surrounded by empty cells.
Cool Office Suite Calc automatically identifies a block of cells for sorting. Place the cursor within the block, and the sorting will take place accordingly.
If all the cells in the first row of a block are text cells, this row is assumed to be the header. The sorting will then be performed from the second row to the last row of the block, except if all the block cells are text cells.
However, if any cell in the first row contains a numerical value, or all the block cells are text cells, the first row will not be considered a header, and sorting will be applied to the entire block.
The sorting is applied to the selected column or the first column of the block.
If the selected column is inside the block, Cool Office Suite Calc prompts to extend the sorting to the adjacent columns.
Tutorial content adapted from the LibreOffice Help documentation, © The Document Foundation, licensed under the Mozilla Public License v2.0. "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners.
Copyright © 2021 Software Union All rights reserved. Privacy Policy Contact Us