[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

Steve Edmonds  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---
 Ever confirmed|0   |1
   Severity|normal  |enhancement

--- Comment #9 from Steve Edmonds  ---
I think an enhancement would resolve the confusion that led me to think this
was a bug.

The import dialogue under "Separator Options" states "Text delimiter".

I don't think this is accurate, or at lease clear. 
The text on an imported row is delimited by the Tab, Comma, Semicolon, Space,
Other into columns in the sheet.

The Text delimiter character is in fact an encapsulation character. What is
encapsulated between these characters (Text delimiter) is a block of text that
is not to be broken up if it contains a delimiter. It is still imported as
format "Number-General".

I would suggest an enhancement of re-naming this "Text encapsulation" or
"String definition" or similar clarifying term.

This would also remove confusion with "Merge delimiters", which doesn't merge
"Text delimiters" but I assume merges Separators.

-- 
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

[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||todven...@suomi24.fi
 Resolution|--- |NOTABUG

--- Comment #8 from Buovjaga  ---
Ok, let's close.

-- 
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

[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

--- Comment #7 from Steve Edmonds  ---
Now I think I have an import working.
If I put " in text delimiter it imports OK in LO 5.3.5.2 opensuse

-- 
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

[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

--- Comment #6 from Steve Edmonds  ---
Now I try the same file on another machine, same OS, LO 5.3.5.2, and it works
fine. Windows 1252/Latin 1, English

-- 
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

[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

--- Comment #5 from Steve Edmonds  ---
This seems to work OK on 5.4.2.2 Mac

-- 
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

[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

--- Comment #4 from Steve Edmonds  ---
On further investigation it seems on actual import the columns are splitting on
delimiters within quoted text, regardless of the setting of "Quoted field as
text".

-- 
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

[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

--- Comment #3 from Steve Edmonds  ---
Created attachment 137387
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137387=edit
Simpler test file

-- 
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

[Libreoffice-bugs] [Bug 113536] CSV import incorrectly handles Quoted field as text that contains delimiters

[bugzilla-daemon]

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

Steve Edmonds  changed:

   What|Removed |Added

Summary|CSV import incorrectly  |CSV import incorrectly
   |handles Quoted field as |handles Quoted field as
   |text setting|text that contains
   ||delimiters

-- 
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