https://bugs.documentfoundation.org/show_bug.cgi?id=167442

Olivier Hallot <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|[email protected] |olivier.hallot@libreoffice.
                   |desktop.org                 |org
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #3 from Olivier Hallot <[email protected]> ---
This text is going to the Help first and later to the book.

-------8<------
Sorting a block of cells in LibreOffice Calc

A block of cells is a rectangular range of cells surrounded by empty cells.

LibreOffice 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, LibreOffice Calc prompts to extend
the sorting to the adjacent columns.
-------8<------

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to