Download it now!
Bug 69207 - Text delimiter not used in preview until changed (CSV import OK)
Summary: Text delimiter not used in preview until changed (CSV import OK)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: low trivial
Assignee: Not Assigned
Depends on:
Blocks: CSV-Dialog
  Show dependency treegraph
Reported: 2013-09-11 07:45 UTC by Dotan Cohen
Modified: 2019-08-19 22:39 UTC (History)
0 users

See Also:
Crash report or crash signature:

Test document (38 bytes, text/csv)
2013-09-11 07:47 UTC, Dotan Cohen

Note You need to log in before you can comment on or make changes to this bug.
Description Dotan Cohen 2013-09-11 07:45:53 UTC
When opening a CSV document with single-quote text delimiter, the Text Import dialogue's preview is only updated when changing the text delimiter option.

Steps to reproduce:
1) Open a CSV file with a single-quote text delimiter.
2) In the Text Import dialogue, change the configured text delimiter to '
3) Click OK
4) When the document opens, close it.
5) Reopen the document.

What happens:
The text delimiter is properly configured as ', but the preview shows the ' characters in the text.

Further steps:
6) Change the text delimiter to double quote.
7) Change the text delimiter back to single quote.

What happens:
Now the preview is shown correctly without the quote characters in the text.

Notice that this bug only affects the preview. Pressing OK opens the document properly.
Comment 1 Dotan Cohen 2013-09-11 07:47:57 UTC
Created attachment 85606 [details]
Test document

This is a test document which demonstrates the bug.
Comment 2 A (Andy) 2013-12-28 21:29:37 UTC
reproducible with LO (Win8)
Comment 3 QA Administrators 2015-04-19 03:23:37 UTC Comment hidden (obsolete)
Comment 4 Dotan Cohen 2015-04-19 10:36:57 UTC
This bug is still present in LibreOffice 4.3.
Comment 5 Dominik Seitz 2016-09-06 09:04:44 UTC
reproducible with (Win7 x64)
Comment 6 Xisco Faulí 2017-09-29 08:53:53 UTC Comment hidden (obsolete)
Comment 7 Timur 2019-04-22 09:27:43 UTC
Repro 6.3+. I change to Trivial.