https://bugs.freedesktop.org/show_bug.cgi?id=57561
Priority: medium
Bug ID: 57561
Assignee: [email protected]
Summary: Sort: Guess if "Range contains column headings"
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: NEW
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
When selecting a range of data and sorting, it would be nice if Calc could
guess the appropriate value for the "Range contains column headings" check box
(a feature which Excel has had for years).
Criteria for identifying potential column headings could be:
- Content type (e.g. A1 contains text, A2 and further down contain numbers)
- Formatting (font attributes, cell background, border) of first row differs
from subsequent rows
- Freeze Panes is active (the frozen cells are likely to be header cells)
- Previous selections (this seems to happen already at least in some cases)
Further extensions:
- When the range has column headings, use their text instead of "Column A" etc.
(right now, this already happens but the sort criteria are not updated when
checking "Range contains column headings")
- Handle multiple heading rows (which is not too uncommon a situation)
See also #54929, which might need this "header row recognition" as well
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
