HI Balázs
Thank you for the clarification.
From an interoperability POV, the behavior is supposed to be known.
I think it deserves some notes for internationalization of the sort
function.
(may be I'm overstating)
Cheers
Olivier
On 3/27/24 05:29, Balázs Varga wrote:
Hi Olivier,
>> MS d
Hi Olivier,
>> MS does not specify the behavior when data to sort is a mix of numbers
and text in their user support pages.
Yes, I also didn't find any official documentation which is directly
related to how those functions handle the mix data.
But after a lot of testing I realized that in Excel
hi...
I'm testing Calc's SORT function recently merged.
MS does not specify the behavior when data to sort is a mix of numbers
and text in their user support pages.
When text is present in the array to sort, text appears to be higher
than the highest numerical value (sort descending) or lowe
