[libreoffice-users] Re: Help with LO Forms
Le 17/02/2017 à 00:46, Ian Whitfield a écrit : Hi Ian, > But I'm confused. The Handbook says Calc can be used as the datasource > for a Form in Writer. > But even Alexander's method still gives me no option to select the > Registered Spreadsheet (The options box remains empty)!! > > The other replies tell me Calc can _NOT_ do this (But the Handbook says > it can!!??) > I believe Robert is correct. Spreadsheets that are accessed directly as datasources are read only (they always have been, AFAIK, ever since the early StarOffice days). In other words, even if you manage to bind that datasource to a form, you can only ever read from it (and not enter new data). It was my (mis)understanding that you had used a Calc spreadsheet to convert your spreadsheet data to a Base ODB file (using the hsqldb or some other db engine). The aim of my reply was to show you how one can define the data source for a form. An alternative would be to craft a spreadsheet so that it looks like a database form, e.g. by using coloured cells, dropdown lists, etc, but this would be a poor man's alternative. Alex -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: Help with LO Forms
Le 16/02/2017 à 12:26, Ian Whitfield a écrit : Hi Ian, > What am I missing or doing wrong.?? > Sounds like you haven't bound your Writer form to the datasource. You don't say whether you created your form from within an ODB database file or whether you are creating your form as a standalone Writer document that needs to be bound to the datasource. I am assuming the latter from what you have described. In your open Writer document, click on Display - Toolbars - Form Controls. Then click on the Design Mode button to activate Form Design mode (bottom icon on right of the 2-column toolbar). You should now see a new toolbar displayed at the bottom of your Writer window. This toolbar contains a certain number of tools. Click on the Form Navigator button - a window should appear with an entry in in called Form. Right-mouse-button click on this entry to call up the context menu. Click on New - Form. A further Form entry is added to the window, underneath the first Form entry. Now, right-mouse-button click on this second Form entry and choose Properties from the context menu. You should now see 3 tabs in the dialog. You need the Data tab (click on it to select it). In the DataSource field, you should be able to list and select with the mouse the already declared datasources. If you can't see it in the list, then clicking on the ellipsis button will take you to FileManager dialog where you can select the ODB containing your datasource. Tailor the other properties of the form to suit your needs. Close the dialog and save your form. Alex -- To unsubscribe e-mail to: users+unsubscr...@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