Created attachment 106528 [details]
Base demonstration document containing Form1 described in report
1. Open sample Form1, which internally has one MainForm bound to data source and text box control that is not bound to any data field (and so is unbounded).
2. Click on the text box and type something.
3. Use record selectors to advance row cursor to additional records in recordset.
4. Unbound text box correctly retains what is typed until ...
UNEXPECTED RESULT: Unbound textbox is reset when row cursor enters insert row. The text you typed disappears when it entered.
EXPECTED RESULT: Unbound textbox should not be reset, should continue to say the same thing, display of data should be consistent and unaffected by entering insert row.
Unbound fields are useful for displaying reference information, but this bug means that they cannot be used for that purpose.
Workaround is to create second entire form in Form1 that is unbounded, but that also implicates another set of issues that will be subject of second bug report.
@Doug : just a quick question : does your form have any controls other than the unbound textbox ? I don't see any when I open the form in my master build.
The problem does not occur for me when the form contains at least one data bound control.
Surely, you are not suggesting that it should be possible to have a form through which one can navigate via the record toolbar, and yet not be able to visualise the data or even enter any new data ? What possible use case would envisage that ?
Even if I just try to reproduce your description, without any bound controls, the content of the unbound text box does not disappear on moving record cursor of the record navigation bar to new record.
Build ID: d807cba9ee60cb1404b54addf9cd3e54de89f331
Nor can I reproduce the problem on LO 4322 production release.
Which version were you using ?
What is wrong?
The textbox isn't bounded to a datafield but is content of a form. The form clears all controls when moving to a new row. The form clears not only the controls, which are bounded to a field of a table or query.
If you wish to have a unbounded textbox, open the form-navigator, click on Forms → New → Form and create a form, which isn't bounded to any data and isn't a SubForm of the MainForm.
You could set this form with
Navigation Bar → No
Cycle → Active Record
but it mustn't be done ...
Move the control "Text Box 1" into this form and the content would never been changed by anything you do in the MainForm with content, which is bounded to a table.
Robert @5: Using that workaroud, but it has implications for the record count in the navigation bar. When you switch between fields, where the fields are on different forms with different recordsets, the record count bar would display unexpected/undesired results, showing record count of 1 on one field, and different count on another field. That is technically correct, but would not be intuitive to typical user. Requires further workaround of concealing navigation bar for unbounded form, but this is not ideal and I believe opened potential for more inconsistencies.
Would be better for this purpose if unbounded fields were not cleared in new record row.
Alex @3: Issue first encountered on Fresh LO for Windows in September. Reconfirmed just now with the attachment above on LO 220.127.116.11.0+ Build ID: 430m0(Build:2) for OpenSuse 13.2. As noted by Robert @5, issue is an LO Base functionality. Open form, enter text, and then browse to new record row, text just entered will disappear.
(In reply to Doug from comment #6)
> Robert @5: Using that workaroud, but it has implications for the record
> count in the navigation bar.
My solution in most forms: I 'm not using the navigationbar at the bottom of the window. I'm using the navigationbar as control of a form. I'm using not only subforms, also forms beneath other forms ...
> Alex @3: Issue first encountered on Fresh LO for Windows in September.
> Reconfirmed just now with the attachment above on LO 18.104.22.168.0+ Build ID:
> 430m0(Build:2) for OpenSuse 13.2. As noted by Robert @5, issue is an LO
> Base functionality. Open form, enter text, and then browse to new record
> row, text just entered will disappear.
Couldn't confirm it first encountered in any LO-version. It is the same behavior here with LO 3.3.0 beta1. Have tested it also with 3.3.4 ...
My System: OpenSUSE 12.3 64bit rpm Linux.
I will set
- Version to Inherited from OOo (because it never works in another way)
- Importance to Enhancement (at this moment it the normal behavior isn't what you wanted to have, but for other people they won't expect it in another way)
- Status to New (because I could confirm the behavior the text in the unbounded textbox would be refresh when reching new record).
Adding self to CC if not already on