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 <[email protected]> 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 >
SORT_ODF_DRAFT(1).odt
Description: application/vnd.oasis.opendocument.text
SORTBY_ODF_DRAFT(1).odt
Description: application/vnd.oasis.opendocument.text
