Created attachment 148567 [details] Open the form - second listbox will show numbers (foreignkeys) instead of text Detected a funny bug while making screenshots for Base-Handbook. Open the attached database. Open the form "Loan_example_02" (not for editing, for show data). There are tablecontrols, each with two listboxes, which will follow each other directly. Second listbox will only show the foreignkey, not the value - but the code for the listbox with the same name is the same in every tablecontrol. Open the form for editing, not for input data. Switch designmode off. All data will be shown. All data will also be shown when setting a field between the listboxes. Seems the bug doesen't appear every time. Have opened the form once and couldnt reproduce, but then it appears again. All tested with LO 6.1.4.2 on OpenSUSE 15 64bit rpm Linux.
No repro for me with Version: 6.1.4.2 Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3 Threads CPU : 8; OS : Mac OS X 10.14.2; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group threaded If I just open the form for visualizing the data, I see text entries for each row in all of the dropdown listboxes.
Created attachment 148593 [details] Screenshot of form on macOS Mojave
Created attachment 148598 [details] Shows the wrong content of second listboxes Problem seems to be the bug isn't reproducable every time. I have got the problem directly after opening the form. When I press "Print" for the screenshot the listboxes filled with the right text. I started the database again, had the bug, tried to make a screenshot of it with GIMP - the bug has been gone when arriving the window next time. Sometimes only pressing a key or pressing a mousebutton will fix the behaviour. But the third screenshot shows what I have seen when the bug appears: Second listboxes all show the foreignkey, not the text-content.
Hi Robert, Yes, I have managed to reproduce it ith Version: 6.1.4.2 Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3 Threads CPU : 8; OS : Mac OS X 10.14.2; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group threade on my MacbookPro. Indeed, it seems that a forced screen refresh, e.g by context switching to focus on another window and then back to the form window, causes the correct data to be displayed, but on first opening of the form I did indeed see only the key values in the grid control instead of the corresponding referred to values. CONFIRMING, and this is a regression.
(In reply to Robert Großkopf from comment #3) > Created attachment 148598 [details] > Shows the wrong content of second listboxes I can't confirm with 6.4.4 on Linux. To clarify for testers: the bad result is that you see integers in the second columns of the topmost tablecontrols. If Alex or Robert can still repro, would be cool to get a bibisect.
Have tested it again with different versions. Buggy behavior doesn't appear every time I open the form. I reproduced the behavior sometimes with LO-versions up to LO 6.2.6, but can't reproduce it with newer version here. Have changed the system since the last test, now OpenSUSE 15.1 64bit rpm Linux. Let's put this one as WORKSFORME.