[Libreoffice-bugs] [Bug 127651] LibreOffice calc fails to properly perform a simple sort

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127651

Ted Waugh <tedwaugh at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
     Ever confirmed|1                           |0
         Resolution|NOTABUG                     |---

--- Comment #5 from Ted Waugh <tedwaugh at gmail.com> ---
I agree that the sorting IF the numbers are formatted as text, not numbers.

However, the result of the sort is correct if the sort function only works on
text not numbers.

Why would the sort change the format from a number to text? If it is making
that change then why only two numbers and not all of them?

I agree that 2001 and 2005 sort correctly IF they are numbers and not text but
the  entire column was entered as numbers. Why should these two numbers not be
converted to text or why should any numbers be converted from text to numbers?

I still believe there is a bug there but don't know how to fix it unless I
never sort on a numbered field. (I can't imagine what the conversion to text
from a number would do to calculations.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190920/5c04f3e9/attachment.html>