https://bugs.documentfoundation.org/show_bug.cgi?id=153055
Bug ID: 153055
Summary: [FILESAVE] Wrong parsening of CSV file
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: eduardomozart...@gmail.com
Description:
Hello LibreOffice team!
I'd imported a CSV file to LibreOffice with the following line:
"MSSQL 2017 - Qualitor - Usuário ""qualitor""","R
Networks",Teampass,,qualitor,Qualitor!@#,"Usu?rio interno da inst?ncia
\"MSSQLSERVER\" do MSSQL 2017 (server02), utilizado para conex?o da aplica??o
Qualitor Web ao banco de dados do Qualitor. Para autentica??o ao banco de dados
do Qualitor, ? necess?rio usar os usu?rios de dom?nio \"eduardo.mozart\",
\"roberto.oliveira\" ou \"Administrator\"."
Steps to Reproduce:
1. I opened it with LibreOffice only with the "Separated by" 'Comma' selected.
It loads and shows up into the right columns as expected.
2. I select all cells and change the cell formating to "Text".
3. Go to File > Save as.
4. Selected "Text CSV" and enabled the checkbox to customize the CSV filter and
I had setup the following settings:
Field delimiter: ;
Text delimiter: "
Quote all text cells: checked
Actual Results:
When exporting, the quotes next to "eduardo.mozart" was broken. It seems that
the CSV filter didn't found the opening quote to filter it as expected and the
following output was generated:
"MSSQL 2017 - Qualitor - Usu?rio ""qualitor""";"R
Networks";"Teampass";;"qualitor";"Qualitor!@#";"Usu?rio interno da inst?ncia
\""MSSQLSERVER\"" do MSSQL 2017 (server02), utilizado para conex?o da aplica??o
Qualitor Web ao banco de dados do Qualitor. Para autentica??o ao banco de dados
do Qualitor, ? necess?rio usar os usu?rios de dom?nio \""eduardo.mozart\";"
\""roberto.oliveira\"" ou \""Administrator\"".""";
Please notice that there's a missing quote next to "eduardo.mozart" and it
added a ";" at the wrong position, breaking the CSV file and make it impossible
for our application to import it because the number of columns was wrong.
Expected Results:
I had to manually fix the file by appending one more quote and replacing the
";" character to ",":
"MSSQL 2017 - Qualitor - Usu?rio ""qualitor""";"R
Networks";"Teampass";;"qualitor";"Qualitor!@#";"Usu?rio interno da inst?ncia
\""MSSQLSERVER\"" do MSSQL 2017 (server02), utilizado para conex?o da aplica??o
Qualitor Web ao banco de dados do Qualitor. Para autentica??o ao banco de dados
do Qualitor, ? necess?rio usar os usu?rios de dom?nio \""eduardo.mozart\"",
\""roberto.oliveira\"" ou \""Administrator\"".""";
Reproducible: Always
User Profile Reset: No
Additional Info:
I'm not sure if it's a bug, but my original file had 7 columns. When exporting
it to CSV using LibreOffice, it added an extra ";" at the end of the line,
effectively creating an extra column (the output from LibreOffice created a 8
columns CSV file). I had to remove this extra column (";" from the end of each
line) manually after export because our application supports only CSV file
lines with 7 columns.
--
You are receiving this mail because:
You are the assignee for the bug.
