https://bugs.freedesktop.org/show_bug.cgi?id=74075

--- Comment #8 from Kohei Yoshida <[email protected]> ---
So, when the last parameter is 1 or omitted, the search range is supposed to be
sorted in ascending order. Now, the search range in this test document contains
both text and numeric values.  Here is what ODF says about this.

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018430_715980110

"If the types are mixed, Numbers are sorted before Text, and Text before
Logicals"

In this test document, the numbers appear after the text values.  Not sure
whether the ODF is incorrect, Excel does sort texts and numbers differently, or
.....

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to