Summary: | error importing CSV containing ;""some text""; | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | ced |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | CLOSED NOTOURBUG | ||
Severity: | normal | CC: | aron.budea, ced, erack, himajin100000, jalojo, xiscofauli |
Priority: | medium | Keywords: | bibisected |
Version: | 3.6.0.4 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109236 | ||
Attachments: | file CSV not correctly imported |
Description
ced
2018-04-10 12:25:09 UTC
Created attachment 141260 [details]
file CSV not correctly imported
Hi ced, Works fine if you add a third " after what you consider as text. True? ciao Jacques yes, with abc;""abc""";abc; works fine if you try to import abc;''abc'';abc; 2 single apex, with ' as delimiter and copy cells from Calc to notepad you get abc "'abc';abc; " look like if it finds 2 delimiters it surrounds all subsequent text with " grazie per il fantastico lavoro che state facendo Emanuele In new versione 6.0.6.2 the bug is still present adddig by hand a third " after what you consider as text is not a solution. I can reproduce it in Version: 6.2.0.0.alpha0+ Build ID: 2da435922f9c1fcf52eb0c1eb3d6f73581e9f793 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: threaded and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) but not in LibreOffice 3.5.0 Build ID: d6cde0 The expected behaviour should be: abcd abcd abcd abcd abcd abcd"" abcd abcd abcd abcd abcd abcd I tried only on windows platform 32/64 bit in Calc 5.X and actualy on Versione: 6.0.6.2 Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77 Thread CPU: 4; SO: Windows 10.0; Resa interfaccia: GL; Versione locale: it-IT (it_IT); Calc: group the bug is reproducible always. file .csv abc;""abc"";abc Actual Results: abc "abc";abc Expected Results: abc "abc" abc Bibisected to the following range using repo bibisect-43all: https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=1856186951a70a0bcac4e0c3632ca4afe68c05e3..d31997559adac6f03d932cb6c5819149c38c1398 Could be the following commit: https://cgit.freedesktop.org/libreoffice/core/commit/?id=7928b651965f747b02593d2a9fc73fac7c86dbf5 author Eike Rathke <erack@redhat.com> 2012-04-14 18:57:31 +0200 committer Eike Rathke <erack@redhat.com> 2012-04-14 18:57:31 +0200 resolved fdo#48621 better handling of broken CSV files abcd;""abcd"";abcd is malformed CSV if " is used as quote character (so-called String delimiter in the import dialog). Proper CSV data for the expected abcd "abcd" abcd case would be abcd;"""abcd""";abcd See also https://tools.ietf.org/html/rfc4180 and http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm This is also not a regression, the old import (abcd"") was just a different but equally not expected result. Fix the generator instead that writes this broken CSV data. |