Bug Hunting Session
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)
Version:
(earliest affected)
6.1.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
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:


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

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
Description:
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'
3.

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 https://ask.libreoffice.org/en/question/168876/values-not-appearing-in-base-listbox/
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: 6.2.0.0.alpha0+
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.