https://bugs.documentfoundation.org/show_bug.cgi?id=137716
--- Comment #13 from Regina Henschel <[email protected]> --- (In reply to Hossein from comment #12) [..] > The question then becomes, what should be the behavior to select the correct > sorting behavior. > > Currently, it is based on locale. Yes. If the locale is not set in the current ScSortParam, then the locale from ScGlobal is used. That would be your case 1. [..] > > Therefore, I argue that text language is better for sorting. This approach > has its own limitations, for example if you mix multiple languages in a > column. AFAIK, the language settings in the cell style are not used, neither the language of the text nor the locale in the number format. I guess it would take a lot of effort to change that. Affected are AutoFilter, PivotTable, SORT and SORTBY functions, and DataProvider, for example. The functions have the additional problem, that their parameter need not be a cell range, but might be the output of a function as well. If the sort dialog is not suitable, you can use a macro for sorting and therein evaluate the language settings in the cell styles. I have collected a lot about sorting in https://wiki.documentfoundation.org/Faq/Calc/Sorting_in_Calc https://wiki.documentfoundation.org/Macros/BasicMacrosSortingInCalc However, that is not finished yet and not reviewed. -- You are receiving this mail because: You are the assignee for the bug.
