https://bugs.documentfoundation.org/show_bug.cgi?id=127651
--- Comment #10 from m.a.riosv <miguelange...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
