Bug 168939 - Help page for Calc sort options does not explain boundary row exclusion logic
Summary: Help page for Calc sort options does not explain boundary row exclusion logic
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
26.2.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-10-18 07:39 UTC by Eyal Rozenberg
Modified: 2025-10-18 19:18 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2025-10-18 07:39:06 UTC
This bug regards:

/en-US/text/scalc/01/12030200.html?System=UNIX&DbPAR=CALC&HID=modules/scalc/ui/sortoptionspage/

and the Data > Sort... options tab.

So, sorting can ignore / does ignore "boundary rows", and the page explains that those are empty row at the start or end of the sorted range. But - sorting does include empty rows that are  not on the "boundary", i.e. empty rows preceded and succeeded, possibly at a distance, by non-empty/non-excluded rows. For example, if we sort this range:

 |    A
-+---------
1|  hello
2| (empty)
3| (empty)
4| (empty)
5|  world
6| (empty)
7| (empty)

then row 6,7 are discarded, while rows 1 through 5 are included in the sort.

This is sort-of clear from the existing documentation. However - what happens if  we choose to include "boundary rows with comments", or "with images" - and add a comment to row 7 in this example? 

Option 1: Row 7 is now considered non-boundary, and thus row 6 is also a non-boundary empty row; the sort range is 1 through 7.

Option 2: Since row 6 is already a boundary row - the desire to include row 7 is not "strong" enough, and both rows 6 and 7 are excluded from the sort.

Whether you would expect option 1 or option 2 to be the case - it is not made clear what would actually happen, in the documentation. It just says:

> ### Include boundary column(s)/row(s) containing only comments
> 
> Range boundary columns (for sorting rows) or boundary rows (for sorting 
> columns) of a sorting range are not sorted by default if they are empty. Check 
> this option if boundary columns or boundary rows containing comments are also 
> to be sorted.

which does not distinguish between the two possibilities.
Comment 1 Regina Henschel 2025-10-18 15:02:24 UTC
The problem seems to be, that the dialog shows the wrong label, see bug 168905.
Comment 2 Eyal Rozenberg 2025-10-18 19:18:49 UTC
So, it seems there's a strong disconnect between the actual functionality and the label and documentation. Let's mark this as INVALID for now and discuss this in the bug you opened.