<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 - When moving to insert a new record, unbound controls should not get cleared"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108547">108547</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>When moving to insert a new record, unbound controls should not get cleared
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.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>BridgeportContractor@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134042" name="attach_134042" title="Example database to demonstrate the issue">attachment 134042</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134042&action=edit" title="Example database to demonstrate the issue">[details]</a></span>
Example database to demonstrate the issue
Only bound fields should get cleared.
How to demonstrate:
1) Open the attached simple database, then open Form1 in Edit mode.
Notice that the list box is not bound to any field in the underlying table.
(Right click on the List Box control (the first control) and select Control...,
then select the Data tab, and verify that the Data field... is empty.)
2) Now switch out of design mode so you can watch this List Box's behavior.
Select any value in the List Box (either 1 or 2 in this example).
Currently there are only 2 records in the underlying table. So first move the
record pointer forward one step from ID=0 to ID=1 (using the right arrow in the
record navigator), and notice that the List Box value is not affected.
Also move the record pointer backwards from ID=1 to ID=0, and notice the List
Box value is again not affected.
But now move to a new record, either by moving forwards past ID=1, or by
clicking the new record navigator button.
Now even though the List Box is not bound to a record field, it gets cleared.
Now it would make sense if it got cleared if it was bound to a field, but it is
not bound. I don't think the List Box should get cleared.
___________________________________________
Sometimes it's very useful to have some controls on the screen that are not
bound to the underlying record and can be static or independent of the
underlying record data.
One example of such use would be a pull down to select or filter records using
macros. I use both of these. But the trouble is that when using the pull down
to filter the underlying records, the filter selector gets wiped out when
moving to a new record.
Why do I use a pull down to filter rather than a sub-form? Because in my
accounting form I want to be able to select a particular account, or all
accounts, and I don't think using sub-forms does this as well.
_____________
Tested both on HSQLDB 1.8 & MariaDB via MySQL/JDBC connection.
Linux</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>