Handling text in Excel SORT/SORTBY functions recently merged

[Balázs Varga]

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> 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
> Respects your privacy, and gives you back control over your data
> http://tdf.io/joinus
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240327/ca945226/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SORT_ODF_DRAFT(1).odt
Type: application/vnd.oasis.opendocument.text
Size: 49145 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240327/ca945226/attachment.odt>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SORTBY_ODF_DRAFT(1).odt
Type: application/vnd.oasis.opendocument.text
Size: 44038 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240327/ca945226/attachment-0001.odt>