https://bugs.documentfoundation.org/show_bug.cgi?id=150027
Bug ID: 150027
Summary: Turn on "Range contains column labels" by default
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I very rarely sort ranges without column labels.
Having "Range contains column labels" activated by default would improve my
workflow a lot, and I'm sure others' as well.
I believe sort options (at least this one) should be remembered forever, across
sheets, documents and restarts. Perhaps they should even be moved or copied to
a new section "Tools -> Options -> LibreOffice Calc -> Sort" or somesuch.
Steps to Reproduce:
1. Open a TSV file with a header row, and numeric data afterwards.
2. Click the title of the column you want to sort.
3. Click the "Sort Ascending" button.
When I have a new document with many sheets pasted in, I have to enable it for
each sheet I want to sort.
Actual Results:
Headers are treated as data (and an alphabetic header is treated as the maximum
value and sorted to the end of a numeric range).
Expected Results:
Functionality-wise I personally have no preference among the following 4
implementation options, but I suspect option A will be easier to implement (and
therefore faster to release, and therefore I prefer it):
Option A: Set "Range contains column labels" on by default.
Option B: Ensure the user's "Range contains column labels" will be remembered
forever, across sheets, documents and restarts, time, space, and multiverses.
Option C: Ensure all sort options will be remembered forever, across sheets,
documents and restarts, time, space, and multiverses.
Option D: Move the sort option to a new Preferences section and remember them
permanently ("Tools -> Options -> LibreOffice Calc -> Sort" or somesuch).
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.2.7.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 20; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-GB (en_US.utf8); UI: en-US
7.2.7-3
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
