Handling text in Excel SORT/SORTBY functions recently merged

[Olivier Hallot]

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 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 the SORT/SORTBY is 
> sorting/working the same as the basic UI Sort works in Excel.
> So I based on that during the implementation. Also our UI Sorting works 
> the same as Excel UI Sorting, so that was the best way to
> follow that. :) But everything else was implemented based on the 
> Official documentations.
> 
> Also we couldn't file the Oasis proposal yet, since we couldn't log in 
> for a while to the Oasis page. But I already wrote the draft,
> which can be uploaded. Just attached to the mail.
> 
> Best,
> Balázs
> 
> 
> Olivier Hallot <olivier.hallot at libreoffice.org 
> <mailto:olivier.hallot at libreoffice.org>> ezt írta (időpont: 2024. márc. 
> 26., K, 20:59):
> 
>     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 <https://www.libreoffice.org>
>     Respects your privacy, and gives you back control over your data
>     http://tdf.io/joinus <http://tdf.io/joinus>
> 

-- 
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/20240327/c6dcacbb/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/20240327/c6dcacbb/attachment.sig>