[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

--- Comment #10 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Created attachment 154341
  --> https://bugs.documentfoundation.org/attachment.cgi?id=154341&action=edit
Sample for test how numbers as text behave.

There are some set ups in Menu/Tools/Options/LibreOffice calc/Formula, about
how to numbers as text behave, with the attached file I think easy to see.
Calc only takes numbers as text as number with direct references, no with
ranges references.

What's clear this is not a sort bug, sorting a range with numbers and texts,
numbers goes before.

Difficult to believe AutoInput changes cell's format, specially converting a
number in text.
Maybe the reason could be the expand format options in
Menu/Tools/Options/LibreOffice calc/General - Expand ....

If you find a way where a number cell format it's converted to text cell format
automatically, please fill a new bug report with the necessary steps to
reproduce the problem.

-- 
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/20190921/4cf89ea4/attachment-0001.html>