[Libreoffice-bugs] [Bug 136892] Symbol ' inserted before number when changing language in number formating screen

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug. When you are opening a CSV, you may fine-tune how the
characters there should be treated; which locale to use to decide if cells
contain numbers or texts. If your CSV had numbers using dots as decimal
separators, you should either chose respective language in the CSV import
dialog, or set column types explicitly.

If you had imported your CSV using wrong settings, and your data could not be
converted to numbers because of those wrong settings, the data is of course
textual. From now on, it will stay textual, no matter how you reformat your
cells, unless you re-enter the data (e.g., convert it using Data->Text to
Columns).

When you change the language of the cells that already contain text into en-US,
those cells that contain text that *looks* like numbers in that language gets a
hint - the leading apostrophe - to show you that the cell has *text* that would
otherwise be handled as number, if you re-enter it into this cell.

This is works as expected.

-- 
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/20200919/9813c396/attachment.htm>