[Libreoffice-bugs] [Bug 138537] Import CSV sometimes change delimeted char-values to numbers

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Frank B. from comment #9)
> (then there is an error in Excel ;-)
> Excel imports this parts as numbers, too - but it leaves the . between it...
> so that it looks like an IP, but it is a number, too

Well, I'd not call it a bug in Excel: it simply does more work, and attempts to
create a number formatting that would represent the converted number as it was
represented in CSV. So seeing that a value string had thousand separators, it
applies a number format with thousand separators to the cell after the
import... :-) That is likely to result in very inconsistently formatted cells
throughout the file, but OTOH it keeps visual representation ... both ways have
upsides and downsides.

-- 
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/20201201/df3c474b/attachment-0001.htm>