Re: [libreoffice-users] Help with LO Forms

2017-02-17 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ian, > > But I'm confused. The Handbook says Calc can be used as the > datasource for a Form in Writer. Don't know which Handbook you mean. The Handbook Base says: - - Calc or Excel spreadsheets can also be used as the table source for

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread Ian Whitfield
Thanks Guys - Appreciated!! 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

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread Paul D. Mirowsky
Sorry, I wasn't being clear. On the webpage at: https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base you will find: *Importing data to Base* *You can import* text files, *spreadsheet files*, and your system address book in read-only mode only. *When you import from a*

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Paul, Am 16.02.2017 um 18:00 schrieb Paul D. Mirowsky: > See > https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Ba se > > to do this. This won't help. The Calc-file is the content of the database. Data haven't been exported

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread Paul D. Mirowsky
See https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base to do this. On 2/16/2017 11:52 AM, Robert Großkopf wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ian, I have a Spreadsheet of Data and I have prepared a Form in Writer to display and edit this

Re: [libreoffice-users] Help with LO Forms

2017-02-16 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ian, > > I have a Spreadsheet of Data and I have prepared a Form in Writer > to display and edit this information. This won't work. You can't use a a table in Calc as a database and edit this data in a form of the database or in a form of wirter.

[libreoffice-users] Help with LO Forms

2017-02-16 Thread Ian Whitfield
*Hi All* I need some help with Forms for LO. I have a Spreadsheet of Data and I have prepared a Form in Writer to display and edit this information. As per "Getting Started with LO", Chapter 15 I select - New - Database, Connect to existing DB, select the Spreadsheet and Register it I then go