Bug 168940 - Option to disable the discard of empty heading & trailing rows of a sort range
Summary: Option to disable the discard of empty heading & trailing rows of a sort range
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (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: Sorting
  Show dependency tree / graph
 
Reported: 2025-10-18 08:42 UTC by Eyal Rozenberg
Modified: 2025-10-19 21:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2025-10-18 08:42:58 UTC 
When sorting a range of rows (or columns), Calc ignores empty cells at the beginning and the end of the range - as though the range were smaller. There is some fine-tuning of this behavior - controlling whether or not cells with comments or images are considered empty - but we _cannot_  just forego it altogether. We should be able to do so, telling Calc not to second-guess our choice of range, and just "do what it was told".
Comment 1 Regina Henschel 2025-10-18 13:12:37 UTC 
There are two ways to sort: using the "Sort Ascending" / "Sort Descending" commands or using the "Sort" dialog. If I select a cell range that contains empty rows, they are sorted with the "Sort" dialog (mode sorting rows). Notice, that empty cell always placed after cells with content for to be compatible with Excel.

If you use the commands, then auto-detection of used content area is purpose. If you do not want auto-detection, then use the "Sort" dialog.
Comment 2 Eyal Rozenberg 2025-10-19 21:10:36 UTC 
Considering what I've figured out after reading bug 168905, I'm going to resolve this as INVALID for now.