[libreoffice-users] Re: LO Base - Dropdown boxes

Le 26/06/2016 à 16:20, Ian Whitfield a écrit :

Hi Ian,


We need more info.

> I'm trying to use LO Base - linked to a Spreadsheet and so far all is
> going well.


How is it linked ? What exactly do you mean by linked to a spreadsheet ?



> However I don't seem to be able to get Dropdown Boxes to work. On my
> 'User Form' they are greyed out and do not react when clicked. I have
> set them to be Dropdown, entered the list of options and set the display
> line number.

If your spreadsheet is the datasource, and the properties of your form
are read/write/add (data) then any form you make stored within an ODB is
dependent on being able to make modifications to the underlying Calc
sheet. As Calc sheets are read-only when attached to ODB files as
datasources, it would not be surprising that you could not set the value
via a dropdown menu, because doing so would attempt to write the chosen
value into the cell of the sheet.

A read-only setting on the form's properties might bring back the
dropdown menus (haven't tried so don't know), but don't expect them to
write anything to the spreadsheet.


Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted