[Libreoffice-bugs] [Bug 121880] Set semicolon ; as default Field Delimiter for CSV instead of comma , (avoid confusion for French and other)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Nov 20 07:37:05 UTC 2020


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

--- Comment #10 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Mike Kaganski from comment #9)
> if our import doesn't automatically mask all occurrences of separator symbol

A thinko; should had been "if our *export* doesn't automatically mask ..."

Just tested with my Russian locale that also uses comma as decimal separator:
on export, it automatically encloses all numbers with commas into double
quotes, as RFC 4180 section 2.6 prescribes.

So cells like

> |  A   |  B   |
> | 3.14 | 5.67 |

become in CSV:

> "3,14","5,67"

... as expected, and are parsed fine. So I can't reproduce the problem
described in the issue, using Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

-- 
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/20201120/9dac50d2/attachment.htm>


More information about the Libreoffice-bugs mailing list