https://bugs.documentfoundation.org/show_bug.cgi?id=154911
Bug ID: 154911
Summary: Natural sort columns in pivot table
Product: LibreOffice
Version: 7.4.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 186791
--> https://bugs.documentfoundation.org/attachment.cgi?id=186791&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
