https://bugs.documentfoundation.org/show_bug.cgi?id=103043
Bug ID: 103043
Summary: Importing from CSV a decimal separator as the sole
content of an import field is imported as numeric 0 if
the column is 'Standard'..
Product: LibreOffice
Version: 5.2.2.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: j...@psilosoph.de
Created attachment 127845
--> https://bugs.documentfoundation.org/attachment.cgi?id=127845&action=edit
Demo of the results described in the report
Importing from a csv (plain text file) there may occur fields containing a
decimal mark (of the respective locale) and nothing else.
In a column of 'Standard' type this results in a numeric 0 in the target cell.
I tested with 5.2.2.2 rc with the dot in English locale and with the comma in
German locale to the same result. To use a text delimiter was no rtemedy nor
was preparing the cells of the sheet with format code "@" ('Text').
This is a regression! V5.1.4 did not show the bug.
Steps to reproduce:
1. Create a virgin spreadseet document.
2. Make sure to know your decimal separator.
3. Copy the text lines (at least first 2) from the bottom of this post.
4. Go to your sheet and choose 'Paste special...' > 'Unformatted text'
5. Set the semicolon as the only separator. No 'Text delimiter'.
6. OK
7. Verify that the respective cells got the content 0 (numeric).
8. Change your import settings now to " as text delimiter and repeat tests.
9. Verify no change.
There are a few additional statements in the attached example.
My;first;test;.;is;this;.
For;comma;locales;,;however;we have;also a;test;.
My;first;test;".";is;this;"."
For;comma;locales;",";however;we have;also a;test;"."
"My";"first";"test";".";"is";"this";"."
"For";"comma";"locales";",";"however";"we have";"also a";"test";"."
--
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