Ask Your Question

listbox reseting/valuelist

asked 2016-06-07 12:48:35 +0200

cmpd gravatar image

updated 2016-06-08 11:26:48 +0200

Hello, my valuelist works a few times and then it stops working. First, it does not show any data in the database, when I do select something it writes always the first value into the database. Any idea?

Edit: no base writes always 0 into the database.

OS: Linux Mint 17.2, LibreOffice 5.x

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2016-06-07 16:26:30 +0200

Ratslinger gravatar image

updated 2016-06-08 17:10:04 +0200

First, when posting, it is usually helpful if you include what operating system you are using and which version of LO.

Having used the listbox since v4.4.x I haven't seen any problems.

image description

On the properties of the listbox Data tab, make sure List content is blank. The Valuelist entries are placed under the General tab as shown. If you wish to have a Default selection, after you enter the entries, select the ellipsis "..." next to Default selection and make your choice from the dialog box. The only other thing is to make sure you have the correct Data field in the Data tab.

The entries may be entered as shown or use the dropdown arrow, enter your item (without " or ; ) and then to enter another item hold 'Shift' and press 'Enter' to go to the next line. Continue until all entries are done.


edit flag offensive delete link more


Yes, this way it works. But not if you want to show a different content, e.g. A= Example 1 B= Example 2

Users cannot work with just numbers (1,2,3). They need an explanation what (1,2,3) is. Thanks.

cmpd gravatar imagecmpd ( 2016-06-08 11:25:36 +0200 )edit

Not understanding your comment. I changed the image in the answer to show you can pretty much list what you want. I also included the Table result using the Valuelist.

Ratslinger gravatar imageRatslinger ( 2016-06-08 15:27:59 +0200 )edit

I have now included a sample DB in the original answer. Created on Mint 17.3 (Rosa) using LO v5.1.3.2 Please note there are many differences between v5.0.x and v5.1.x

Ratslinger gravatar imageRatslinger ( 2016-06-08 17:13:15 +0200 )edit

answered 2016-06-09 09:11:39 +0200

pierre-yves samyn gravatar image


@Ratslinger - I understand differently the 1st comment of @cmpd

It is possible to display list entries different that is stored.

  • The entries displayed must be entered on the General tab▸List entries
  • The stored values must be entered on the Data tab▸List content

See ValueListSample.odb


edit flag offensive delete link more


@pierre-yves samyn you may be correct. However I did have a previous sample displayed showing the list with just A, B, C, D... in the list which is what possibly prompted the comment. I then changed it to display some other options. Aside from that, your sample provides another aspect for consideration. Much appreciated.

Ratslinger gravatar imageRatslinger ( 2016-06-09 15:25:56 +0200 )edit

answered 2016-06-07 13:09:50 +0200

cmpd gravatar image

Seems to be a bug. Sometimes it works, sometimes it does not. No idea.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-07 12:48:35 +0200

Seen: 414 times

Last updated: Jun 09 '16