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:
OpenPGP_0x59F8BA50F9918DE6.asc
Description: OpenPGP public key
Attachment:
OpenPGP_signature.asc
Description: OpenPGP digital signature
