Re: Handling text in Excel SORT/SORTBY functions recently merged

Olivier Hallot <olivier.hallot@xxxxxxxxxxxxxxx> · Wed, 27 Mar 2024 15:44:11 -0300

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@xxxxxxxxxxxxxxx 
<mailto:olivier.hallot@xxxxxxxxxxxxxxx>> 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
Attachment:
OpenPGP_0x59F8BA50F9918DE6.asc

Description: OpenPGP public key
Attachment:
OpenPGP_signature.asc

Description: OpenPGP digital signature