https://bugs.documentfoundation.org/show_bug.cgi?id=167997
Bug ID: 167997
Summary: FEATURE REQUEST: Option to permanently enable natural
sorting in LibreOffice Calc
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Currently, natural sorting in LibreOffice Calc must be manually enabled each
time a sort operation is performed. This can be inconvenient for users who
frequently work with alphanumeric data – for example, filenames like “Image1”,
“Image2”, “Image10”, which are incorrectly ordered with standard sorting.
I propose adding a global setting or a document-level option that allows
natural sorting to be enabled by default. Alternatively, it would be helpful to
have the ability to store this preference per column or per sheet, so users
don’t have to re-enable it every time.
Steps to Reproduce:
1. Open a LibreOffice Calc spreadsheet.
2. Enter alphanumeric values in a column, e.g.: Image1, Image2, Image10,
Image11, Image3
3. Select the column and go to Data → Sort…
4. Sort the column without enabling the “Natural Sort” option.
Actual Results:
The values are sorted lexicographically:
Image1, Image10, Image11, Image2, Image3
This does not reflect the intuitive human order.
Expected Results:
The values should be sorted naturally by default (or based on a saved
preference):
Image1, Image2, Image3, Image10, Image11
This reflects the expected alphanumeric order.
Reproducible: Always
User Profile Reset: No
Additional Info:
nothing
--
You are receiving this mail because:
You are the assignee for the bug.
