[Libreoffice-bugs] [Bug 98168] Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)

Fri Jul 21 14:19:38 UTC 2017

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

Timur <gtimur at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|medium                      |low
            Version|5.0.4.2 release             |Inherited From OOo
            Summary|Cannot update all fields in |Cannot use XLSX (with
                   |mail merge                  |validation errors) as
                   |                            |address list in Mail Merge
                   |                            |Wizard - error in Comment 6
                   |                            |(workaround: add as
                   |                            |external data source)

--- Comment #8 from Timur <gtimur at gmail.com> ---
Attachment 122970 shows a number of validation errors when checked with OpenXML
Productivity Tool. On the other hand, LO opens it and there's a way to use it. 

Conclusion from here and from what I tested with master 6.0+: we cannot use
this XLSX as address list in Mail Merge Wizard. Connecting to data source
fails. Looks inherited from OO.
If we try to use that unconnected address list then as Data Source, we get: 
    "SQL Status: HY000
    The driver class '' could not be loaded."
There's workaround: add it as external data source.

Title "Cannot update all fields in mail merge" is not clear so I change to
"Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard
(workaround:  add as external data source)".

-- 
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/20170721/8e0bfc69/attachment.html>