Handling text in Excel SORT/SORTBY functions recently merged

[Olivier Hallot]

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 lower than the 
lowest numerical value (sort ascending)

In either case, text is not treated as zero or blank as many other Calc 
functions. To me this is a point of attention (documentation-wise).

Anybody can point me where to confirm the way Excel treat text for SORT 
(and SORTBY) functions?.

Thank you
-- 
Olivier Hallot
LibreOffice Documentation Coordinator
Rio de Janeiro - Brasil - Local Time: UTC-03:00
LibreOffice – free and open source office suite: https://www.libreoffice.org
Respects your privacy, and gives you back control over your data
http://tdf.io/joinus
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0x59F8BA50F9918DE6.asc
Type: application/pgp-keys
Size: 14940 bytes
Desc: OpenPGP public key
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240326/e4cf3b0b/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature.asc
Type: application/pgp-signature
Size: 236 bytes
Desc: OpenPGP digital signature
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240326/e4cf3b0b/attachment.sig>