https://bugs.documentfoundation.org/show_bug.cgi?id=167173
Bug ID: 167173
Summary: When rectangular block is broken, relying on Calc to
find the sort area itself leads to unexpected result
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In the attached *.ods file, cells in column C contain a header (= seqpre) and
the digits 1, 2, and 3. I need Calc to sort column C in ascending order.
When starting the sort dialog, I have some single cell focused in the area,
i.e., I don’t select my data manually – neither A1:CC1883, nor whole columns
A:C; I rely on Calc to find the area itself, even though my cells A1882 and
A1883 are empty, so the rectangular block is broken.
The result is that column C sorts correctly except for the last 2 cells (C:1882
and C:1883). Apparently empty cells in the first column are OK if they occur in
the middle but not if they occur in the end, even though the other columns
allow to deduce the correct rectangle.
Sort Criteria:
Sort Key 1:
Column [seqpre] (ascending)
Sort Key 2:
- undefined -
Sort Options:
Headers: Range contains column labels YES
Direction: Top to bottom (sort rows) YES
Options:
Case sensitive ON
Enable natural sort ON
--
You are receiving this mail because:
You are the assignee for the bug.
