[Libreoffice-bugs] [Bug 144842] New: LibreOffice Calc FILEOPEN Import csv 'Format quoted field as text' does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144842
           Summary: LibreOffice Calc FILEOPEN Import csv 'Format quoted
                    field as text' does not work
           Product: LibreOffice
           Version: 7.1.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: itismike at gmail.com

Description:
Importing a space-separated CSV which includes quoted text in fields results in
extra columns being created rather than merging them. e.g.:

group="SSLVPN Users" dst_host="N/A" reason="Lost the connection" duration=15
sentbyte=0 rcvdbyte=0 msg="SSL tunnel shutdown"



Steps to Reproduce:
1. Attempt to import space-separated CSV with quoted text in fields
2. Under Separator Options select Separated by: Space and Merge delimiters and
enter a double-quote (") in the String Delimiter field.
3. Under Other Options, select Format quoted field as text and click Ok

Actual Results:
Fields are separated into multiple columns:

logdesc="SSL    VPN     tunnel  up"     action="tunnel-up"
logdesc="SSL    VPN     tunnel  up"     action="tunnel-up"
logdesc="SSL    VPN     tunnel  down"   action="tunnel-down"


Expected Results:
Fields should be merged:

logdesc="SSL VPN tunnel up"     action="tunnel-up"
logdesc="SSL VPN tunnel up"     action="tunnel-up"
logdesc="SSL VPN tunnel down"   action="tunnel-down"



Reproducible: Always


User Profile Reset: No



Additional Info:
Possibly related to bug #53325

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210930/4ed6f2ef/attachment.htm>