Hi Olivier,
>>
MS does not specify the behavior when data to sort is a mix of numbers
and text in their user support pages.
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> 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
Attachment:
SORT_ODF_DRAFT(1).odt
Description: application/vnd.oasis.opendocument.text
Attachment:
SORTBY_ODF_DRAFT(1).odt
Description: application/vnd.oasis.opendocument.text
