Download it now!
Bug 120640 - Values not appearing in base listbox with value list
Summary: Values not appearing in base listbox with value list
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
Reported: 2018-10-16 10:41 UTC by Robert Simpson
Modified: 2019-02-20 09:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Example of bug in database (11.20 KB, application/vnd.oasis.opendocument.database)
2018-10-16 10:44 UTC, Robert Simpson
Valuefields are not displayed in field "S" of form (18.10 KB, application/vnd.sun.xml.base)
2019-02-20 09:48 UTC, saxofon

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Simpson 2018-10-16 10:41:16 UTC
In Base with the firefox engine, when a listbox governed by a value-list links to a fixed width field (CHAR), the existing value is not not displayed in the form.
When the field is variable width (VARCHAR), values display correctly, and when the list is governed by sql statement, the values are displayed correctly.

Steps to Reproduce:
1.Create new database with 1 table with 2 fields, CHAR and VARCHAR
2.Create form displaying fields in listboxes with Type 'Valuelist', and specifying list in 'List entries'

Actual Results:
VARCHAR field displays correctly, CHAR field does not
(Fields are, however, updated).
(Type 'sql' lists governed by 'List contents' display correctly.)

Expected Results:
List values should always display.

Reproducible: Always

User Profile Reset: No

Additional Info:
Example data base attached at
Comment 1 Robert Simpson 2018-10-16 10:44:42 UTC
Created attachment 145750 [details]
Example of bug in database
Comment 2 raal 2018-10-16 16:42:43 UTC
Confirm. Version:
Build ID: 49c87270f7176312806d1759967c247a312f0acf
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2;
Comment 3 saxofon 2019-02-20 09:48:56 UTC
Created attachment 149437 [details]
Valuefields are not displayed in field "S" of form

Similar problem with boolean fields and valuelists. Example attached: the field "S" is only displayed when it has focus.