<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Firebird: empty columns gone with query"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116890">116890</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Firebird: empty columns gone with query
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>gerhard.schaber@gmx.at
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=141215" name="attach_141215" title="Sample database">attachment 141215</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=141215&action=edit" title="Sample database">[details]</a></span>
Sample database
- Open the attached test file.
- Run the included macro ExportDataExcelvorlage.
- It is supposed to create an Excel file with the same number of columns as the
query "MitgliederVerbandExcelvorlage", but it removes most of the empty
columns, and instead adds one named "CONSTANT". oPrepStatement.Columns only
returns 10 columns.
It would be good to have at least a workaround for this.
By the way, the same code works perfectly with HSQLDB.</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>