https://bugs.documentfoundation.org/show_bug.cgi?id=161948
--- Comment #5 from Regina Henschel <[email protected]> --- The struct ScSortParam has the members bNaturalSort and aCollatorAlgorithm. The latter is e.g. used in German locale for sort algorithm 'Telefonbuch'. With a German local I see table:algorithm="alphanumeric" or table:algorithm="phonebook" in the ODF file source. As ODF has only this one attribute for the algorithm, we need to encode the bNaturalSort attribute into this string. We could use a ";" (or a "+" or a "|") sign as delimiter. So we could get table:algorithm="alphanumeric;naturalsort" or table:algorithm="alphanumeric" or table:algorithm="naturalsort". The export is in /core/sc/source/filter/xml/XMLExportDatabaseRanges.cxx The import would need to separate the tokens and extend ScXMLSortContext for the bNaturalSort property. The import is in core/sc/source/filter/xml/xmlsorti.cxx. I'm not sure whether we have "Natural Sort" already in the API. -- You are receiving this mail because: You are the assignee for the bug.
