Created attachment 186791 [details]
sample spread sheet with simple pivot table to demonstrate issue of non-natural sorting

Imagine working with counting of electrical components. I find Calc pivot table being a near perfect feature for being able to spot errors. The components are labeled a letter followed by a number, that be C1, C2, . . C50. There are probably other similar use cases.
See attached sample spread sheet.

The issue arrive when counting, and when it turns out the ID are sorted as plain text (e.g. C10 - C19 comes before C2). This has in some cases lead me to believe there is a component missing, when in fact I was not aware of the sort order.

There is a (kind of) workaround, to simply pad the numbers with zeroes (C01 instead of C1). But then it also interrupt with the workflow because every number that I read manually use least possible number of numbers (i.e. no extra zeroes), leading to me tending to increase the typing errors, which in turn cause me to do work over again more often.
This also create issues when I later on want to search for "C1" in main table, when I don't remember that an extra zero is needed.

This is why I'd like to see Libre Office Calc being able to use natural sort in columns of pivot tables, and why manually adding extra zeroes is not a good solution.