<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - *.csv database: changing character set needs a disconnect"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117813">bug 117813</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;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>drewjensen.inbox@gmail.com
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Severity</td>
<td>minor
</td>
<td>enhancement
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - *.csv database: changing character set needs a disconnect"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117813#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - *.csv database: changing character set needs a disconnect"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117813">bug 117813</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>It still remains though that if you want to see a change in the beamer grid
after changing the character set configuration for an ODB datassource the only
way is to disconnect and then reconnect by clicking on the Tables or Queries
entry in the Database tree view.
The same is true for the Base UI. After the connection is created a change to
that configuration property will not affect the open connection. The refresh
table operation will not update the connection object for this property either.
The only option to see the change in a table grid is to drop and recreate the
default connection with a macro or the easier, close and reopen the file.
In the beamer there are separate connection objects created it appears for
viewing data in the beamer grid versus dragging (inserting) data into the sheet
and that would explain why the change is picked up there.
Since a .CSV File datasource type lists all .csv files in a directory as tables
it might be easy to see how a disconnect_reconnect feature would be useful
feature.
Perhaps not just with a UI exposure at the Beamer but in the Base UI also.
Setting the enhancement requests and status to new</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>