https://bugs.documentfoundation.org/show_bug.cgi?id=148679
Bug ID: 148679
Summary: Database range (and its column labels / totals
settings) is not considered when expanding the range
for sorting
Product: LibreOffice
Version: unspecified
Hardware: All
URL: https://ask.libreoffice.org/t/how-do-i-sort-rows-witho
ut-including-first-row/76597/
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
1. In a spreadsheet, create a rectangular data block with all cells having only
text (no numbers).
2. Define a database range for this block (select it, Data->Define Range), and
for the newly created range, make sure that "Contains column labels" is checked
under Options.
3. Unselect the range; click on any cell inside the range, and click on Sort
Ascending or Sort Descending toolbar buttons.
The range gest automatically selected including all adjacent non-empty cells;
and it is sorted as a whole, including the first row, despite the data range
for this selection defined the first row to be labels.
1. When the selected area is the same as some database range, sorting must not
sort first row when it's defined as column labels;
2. When the selected area is the same as some database range, sorting must not
sort last row when it's defined as totals;
3. When expanding selection, database range in the place of selection should be
considered (in case when e.g. database range is smaller/larger than contiguous
block).
--
You are receiving this mail because:
You are the assignee for the bug.
