Issue 53275

Summary:

Listbox values being deleted in form when listbox properties not set to "value list"

Product:

Base

Reporter:

helgekraak <helge.kraak>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

UNCONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues

Version:

680m122

Target Milestone:

---

Hardware:

All

OS:

Windows 2000

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Form document	none

Description helgekraak 2005-08-13 15:49:53 UTC

When you have a list box in a form and you enter the list entries manually while
the list entry type is set to SQL (without any SQL sequence typed in) you lose
the manually entered list entries after leaving the form edit mode and reopening
the form edit mode. This behaviour doesn't happen when you set the option "Value
list" instead of "SQL". Although this behaviour is contrary to the behaviour of
combo boxes (there you don't have the "value list" option and you can leave the
SQL option without anything happening as long as you don't type in a SQL
procedure) this wouldn't be such a big issue, but what irritates is that beside
the loss of the manually entered list box entries after leaving the form edit
mode the second time, you don't see the database column entries of this list box
field anymore when browsing between the datasets (I use HSQLDB attached to the
form via SQL in the form options). This seems to me to be a bug.

Best regards
Helge Kraak

Comment 1 christoph.lukasiak 2005-09-12 12:31:39 UTC

sad but true - but rather an enhancement, so send further to
requirements@openoffice.org

Comment 2 helgekraak 2007-09-18 11:34:21 UTC

Created attachment 48302 [details]
Form document

Comment 3 helgekraak 2007-09-18 12:28:10 UTC

Sorry, please ignore attachment. Was not meant for this issue.