| Summary: | : Combo box hides the label and shows the value, and fails if using a calculated field for label | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Yajo <yajo.sk8> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | robert, sasha.libreoffice |
| Priority: | medium | ||
| Version: | 3.5.0 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Database example with 2 forms showing both bugs
Corrected fields from combobox to listfields |
||
Thanks for bugreport reproduced in 3.5.3 on Fedora 64 bit in 3.3.4 on Fedora forms not working correctly, impossible to verify in 3.5.2 on Windows 7 not working because JRE not installed (on my comp) Created attachment 63984 [details]
Corrected fields from combobox to listfields
You have choosen the wrong field for it. A combobox shows the values of the table of the form. You could change these Values. You can't put a text into a numberfield.
You look for a listfield. There you could choose the names and put the primary-keys of the names into the table of the form.
Open the forms and you don't see any bug. Open the forms for editing and have a look at the fields with a click of the right mouse-key. Choose column → data. You could see the SQL-code and then the number of the bounded field (1). Numbers of the filed begin with 0, so the second field in the SQL-code is the field that is saved in the datafield "zone". The first field is shown to the user of the form.
|
Created attachment 58054 [details] Database example with 2 forms showing both bugs Problem description: It's a combination of 2 related problems. A. Selecting a field from a combo box changes to display the value column instead of the human-readable label (the one that the user clicks). B. Additionally, if the label is calculated (instead of just a plain field), whatever you select the value will be always zero. Steps to reproduce: A.1. Open attached file A.2. Open the form called "addresses-bad" A.3. Add a new record picking something from the "zone" combo box. B.1. Open attached file B.2. Open the form called "addresses-worse" B.3. Add a new record picking something from the "zone" combo box. Current behavior: A. After adding the record, the text "City X" changes to a number (its ID). B. After adding the record, the text "City X" changes to 0. Expected behavior: A. The combo box field shows the label, not the value. B. Like A but also the value should be correct. Platform (if different from the browser): Tested under Linux and Windows LibreOffice Base. Browser: Mozilla/5.0 (Windows NT 5.2; rv:10.0.2) Gecko/20100101 Firefox/10.0.2