Bug 167997 - FEATURE REQUEST: Option to permanently enable natural sorting in LibreOffice Calc
Summary: FEATURE REQUEST: Option to permanently enable natural sorting in LibreOffice ...
Status: RESOLVED DUPLICATE of bug 161948
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.7.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Sorting
  Show dependency treegraph
 
Reported: 2025-08-18 08:10 UTC by aklassentp
Modified: 2025-08-18 14:19 UTC (History)
4 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 aklassentp 2025-08-18 08:10:40 UTC
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
Comment 1 V Stuart Foote 2025-08-18 13:13:22 UTC
Think implementing this would depend on first resolving see also bug 161948
Comment 2 m_a_riosv 2025-08-18 14:19:34 UTC

*** This bug has been marked as a duplicate of bug 161948 ***