[Libreoffice-bugs] [Bug 123055] New: CSV mail merge database with quoted values: First header line value keeps quotes

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123055
           Summary: CSV mail merge database with quoted values: First
                    header line value keeps quotes
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dominik.hoelzl at fabasoft.at

Created attachment 148755
  --> https://bugs.documentfoundation.org/attachment.cgi?id=148755&action=edit
CSV Datasource file and screenshot

Steps to reproduce:

* Create new OpenDocument Text document
* Open the document with LibreOffice Writer
* View data sources (View -> Data Sources)
* Clean up data sources as necessary
  (Context Menu -> Registered databases ... -> Delete -> Yes -> OK)
* Attach data source
  * Open Fields dialog (Insert -> Field -> More Fields ...)
  * Select Mail merge fields (Database -> Mail merge fields)
  * Add database (Add database file -> Browse...)
  * Select the attached CSV file (Database.csv)
  * Adjust row format:
    Field separator: ;
    Text separator: "
    Decimal separator: ,
    Thousands separator: .
    Ensure "Text contains headers" is selected
    Character set: Unicode (UTF-8)
  * Click OK
  * Expand the added database "Datasource"
  * Expand the table "Datasource"

The first field, EMail, is shown as "EMail" (with quotes) whereas
FieldNameAndAddress, Surname and all other following fields correctly do not
contain the quotes.
The "bad" field "EMail" seems to be working when using as mail merge field, but
is now incompatible with documents created with an older version of LibreOffice
(I have not checked since which version the break occurs), as the quotes were
not present before.

The problem does not occur if all quotes in the header line in the CSV file are
removed.

-- 
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/20190130/0e4b8a68/attachment.html>