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
Think implementing this would depend on first resolving see also bug 161948
*** This bug has been marked as a duplicate of bug 161948 ***