<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=98168">bug 98168</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Priority</td>
<td>medium
</td>
<td>low
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>5.0.4.2 release
</td>
<td>Inherited From OOo
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Cannot update all fields in mail merge
</td>
<td>Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=98168#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=98168">bug 98168</a>
from <span class="vcard"><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> <span class="fn">Timur</span></a>
</span></b>
<pre><span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=122970" name="attach_122970" title="spreadsheet (xlsx)">Attachment 122970</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=122970&action=edit" title="spreadsheet (xlsx)">[details]</a></span> 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)".</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>