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

I have never done this but since it seems your data might fit within a
spreadsheet perhaps you can use the features in View > Tool bars > Form
Controls, Design, Navigation to create an input sheet / form.  Then another
sheet(s) for "output" via Data > Filters or Pivot Tables.  You might also
be able to use the spreadsheet protection features to keep the "design"
locked down.  I would guess this would be OK for 10,000 or fewer records,
could work with up to 100,000 records, but would run into spreadsheet
"practical limits" (performance, stability) beyond that ... in which case
you really would need a database!

On Wed, Jun 29, 2016 at 10:35 AM, Alexander Thurgood <
alex.thurgood@gmail.com> wrote:

> 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

-- 
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