Re: [libreoffice-users] Help with LO Forms
-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 databases. If, however, a Calc spreadsheet is used, no editing of the table data will be possible. - - Could be the translation from German to English isn't clear enough, but I haven't written anywhere in German Base-Handbuch you could use a spreadsheet for data-input in Base or by a form in Writer. > > Everyone else wants me to use Base but I'm NOT interested in this > at all as I battled with it for 7 years and could never get a > stable set-up. It crashed frequently and usually took all the data > with it or 'gabbled' the data - so you spend more time with back > ups and patching damaged data records. I can not let the end user > have such an unstable program to work with. I hoped the Calc/Writer > Form would prove more reliable. I have created many databases, also with the internal HSQLDB. While creating reports I got some troubles, but the users seem to have no troubles for a long time with these databases. For professional use I would prefer an external database like MySQL, connected with Base. You could use an external database also. If a spreadsheet will save the data you need, a dBase-file will do this also. Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIcBAEBAgAGBQJYp/xAAAoJELDKYwaoS9AIf2gQAJee+AvureGqHCUTuf3dSimV JihXMdpl5JIAR1AGZpxr2WY9M1BbUdK7CvrqLVDdeT73U31McDvS7xwJx10AVomb TOoVcP3w/WWrb3TgyLB/jARtl9u4H6PCwilYN/UgiDN4xi/0cs9hvfiffdyoaDBl B75CL4eFE1xR6HlHmpwiUUXgmKy+6yCUjFRldwYemyky9M80QZrHglBCbBopUDmF FKVSdvuNvMzvk3rcy5NlnEcpsY8CNI3L4HKV/vqZStFuwhjME2JuEcm7LUx0ZYP0 WGoWRP5pFGRifEKx3Wu6ZFZkKorBWkYaryfPLs+y4Gzi1k7n5QJnEjoUFn88IFXC /8yK6lshY8pGvlyg4N4rqEKonpZLmgLZ09PSvFPbvNHxAzkL81LgtWnRwfZ2g9T/ 8KlGls1piGD6EKRblQjTEIILNhbWZ/oA0pGjKM+RzOwWsbfweTghdgGZYM4kFr9V Kh73XiqT6wlKJb13HO5OnBfm97k4zb64NZvt7ejeVhbK5YaYeciBGCIYOiTrV6cA CW9TK5avKghaEI2mqA3mib+kqkU3kiOhMVtPeY8ezRl3HMf7I8Jf3/4ra/G55vWY 3Whp0PUdSeo+A1sac2UBza9RzDUqFE3HFGiNe3ij5otP/eKanUPZ/aBWp5603BX5 Jg8o6TU3A5e0h7aYXw8W =OzvV -END PGP SIGNATURE- -- 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
Re: [libreoffice-users] Help with LO Forms
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 this (But the Handbook says it can!!??) Everyone else wants me to use Base but I'm NOT interested in this at all as I battled with it for 7 years and could never get a stable set-up. It crashed frequently and usually took all the data with it or 'gabbled' the data - so you spend more time with back ups and patching damaged data records. I can not let the end user have such an unstable program to work with. I hoped the Calc/Writer Form would prove more reliable. So if this can not work I'll have to move to Kexi which is rock solid, With best regards IanW Pretoria RSA -- 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
Re: [libreoffice-users] Help with LO Forms
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* text or*spreadsheet file, the file must have a first row of header information. The second row of the file is the first valid data row. The format of every field in the second row determines the format for the entire column. Any format information from a spreadsheet file gets lost when importing to Base.* For example, to ensure the first column has a text format, you must make sure that the first field of the first valid data row contains text. If a field in the first valid data row contains a number, the whole column is set to number format, and only numbers, no text, will be shown in that column. *Open a Base file of the database type that you want.* Either create a new Base file using the Database Wizard, or open any existing Base file that is not read-only. *Open the Calc file that contains the data to be imported to Base*. You can open a *.dbf dBASE file or many other file types. *Select the data to be copied to Base*. You can enter a range reference like A1:X500 in the Name Box if you don't want to scroll. If you copy a dBASE sheet, include the top row that contains the header data. *Choose Edit - Copy*. *In the Base window, click Tables to view the tables.** **In the Base window, choose Edit - Paste.* *You see the Copy Table dialog. Most databases need a primary key, so you may want to check the Create primary key box.** * On Windows systems, you can also use drag-and-drop instead of Copy and Paste. Also, for registered databases, you can open the datasource browser (press F4) instead of opening the Base window. On 2/16/2017 12:00 PM, Paul D. Mirowsky wrote: 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 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. Tables of a spreadsheet aren't editable in Base, You could only search througt that data, filter them but can't change them. Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIcBAEBAgAGBQJYpdizAAoJELDKYwaoS9AIRwMP/0OTzyPPWqhhDGIMN14MSDCo XdxFFXAfmA3SN8RjYLSRHKFqs3ldPO/Qv27Ui2B5+87638r7ZpQ93NpysS8u7Kmx vmkAbADxUqJoe+6T1Cx10D20yhp5pVimLTYEJZlqrAEK/KkwIRef8hnalhKNNLOa rrGWuXNaKug5R8EUjChkgdA8lOUNhLiZ59IjSmDsU6mULU6zildQqVxzfd5Am2TO EaNXrIseTe7v3v93oDnQK1GrN9bPldMp112PxYySB0Qgpqh26S7Qus0QLp4K4EED 4soMG1A2L1FQXTpNdHO856WUaN8qnXPxdJ0mNBT9AeiK330XtHuEvczQ7sFwfVv4 B4yebHHPWXVuKPQbzCiZ7A1IrJdjmn1UW+ejTemLy4P4j3APEHObGxnC8c8ZfGvv AqK63Ji59lZDQxBJEOnT3Woskk6kNuGOQWIjYwfDn0rtAqvt7Z3rq09VYLAEuO4G Eg69LLYSC/h9aoUPdURC5w+/qXBTbw0jK+GC+NtX8UaGKpxwtj6S1HBRZ2aRioeV oAdNFQEKRumtkoSAzPQbzHoAWd5Z+ZwoYcIo1j23v1p/QP1nEGwPks01LJiK7aO0 adAVjtn9k5oH4d4gtiJfAzk0pT2KaV/qlUoIgV0Im4lbAIgQrSUo8jdSDk/obZ0Y spqFaDe4xoQWOv26EuFf =EjGI -END PGP SIGNATURE- -- 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
Re: [libreoffice-users] Help with LO Forms
-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 into Base or something else (Firebird ...). So Ian has first to export the data- and I don't know if he doesn't need the contact to Calc for the data any more. > > > On 2/16/2017 11:52 AM, Robert Großkopf wrote: 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. > Tables of a spreadsheet aren't editable in Base, You could only > search througt that data, filter them but can't change them. > Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIcBAEBAgAGBQJYpd3WAAoJELDKYwaoS9AI9AIP/AygaL/668nXqJj/Oh74wlt+ J/5d9G106GcZODoWMxpP0HWhtvM1H0r29zEl1K666s4f2iXYWOoETpnVFzKSk0a6 UoLwe7cHkHtJxrderqja1I8mPTr/R8hoEvFz4MVgLgLyF5DT5DJk21pFBA0qUOmY p/ARVjDnuIxBOZ51OMKB3SkJOHA3Jnpl2UkeUXcOdbxNkcr1EaaNQztfgtc5EqR5 Ec6a2Nic39iMApJa2e0gl4SiLnS+CbAchmNTfws0uvyWJ1K1tzVUWW9jZbvIUmBS SHdPF3r4UvNC7pFdzRzWVtyneh2idh7nRa+BIMyTClBClr188S6i0bLpjlijqL/c NNgC72KmqroFZpcNmas+3Sb84jZ9UQS4jYxJwsVY+1NxtLlW43elE2OYDqSPdQil a7sQWzHQ9A2qpecTBIM2IEpZ7gP66IgF+RbK4H+B2WeJnerK8Ijhm9aY8CB11zCn 24HQlOUmNhX+OV7HybHlCZEBpmt4Qlg1oDM1KQ7neXIgfq/AcX827OQ2g0n3G1lR eyNcFU5PMypDcCdPkX29CzzEHTRtcK7kkrzwrrWj1JVYLoKTr3ZipEqYG0jjlw5O q8mXDFZpStDIMc4vMIf1ZzjdU93HrUc8bIfppr+oSMoa0kzeUKniyQdiW5ZVpRkK jI0QvxU42K3cNxSPxjm7 =PlEm -END PGP SIGNATURE- -- 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
Re: [libreoffice-users] Help with LO Forms
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 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. Tables of a spreadsheet aren't editable in Base, You could only search througt that data, filter them but can't change them. Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIcBAEBAgAGBQJYpdizAAoJELDKYwaoS9AIRwMP/0OTzyPPWqhhDGIMN14MSDCo XdxFFXAfmA3SN8RjYLSRHKFqs3ldPO/Qv27Ui2B5+87638r7ZpQ93NpysS8u7Kmx vmkAbADxUqJoe+6T1Cx10D20yhp5pVimLTYEJZlqrAEK/KkwIRef8hnalhKNNLOa rrGWuXNaKug5R8EUjChkgdA8lOUNhLiZ59IjSmDsU6mULU6zildQqVxzfd5Am2TO EaNXrIseTe7v3v93oDnQK1GrN9bPldMp112PxYySB0Qgpqh26S7Qus0QLp4K4EED 4soMG1A2L1FQXTpNdHO856WUaN8qnXPxdJ0mNBT9AeiK330XtHuEvczQ7sFwfVv4 B4yebHHPWXVuKPQbzCiZ7A1IrJdjmn1UW+ejTemLy4P4j3APEHObGxnC8c8ZfGvv AqK63Ji59lZDQxBJEOnT3Woskk6kNuGOQWIjYwfDn0rtAqvt7Z3rq09VYLAEuO4G Eg69LLYSC/h9aoUPdURC5w+/qXBTbw0jK+GC+NtX8UaGKpxwtj6S1HBRZ2aRioeV oAdNFQEKRumtkoSAzPQbzHoAWd5Z+ZwoYcIo1j23v1p/QP1nEGwPks01LJiK7aO0 adAVjtn9k5oH4d4gtiJfAzk0pT2KaV/qlUoIgV0Im4lbAIgQrSUo8jdSDk/obZ0Y spqFaDe4xoQWOv26EuFf =EjGI -END PGP SIGNATURE- -- 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
Re: [libreoffice-users] Help with LO Forms
-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. Tables of a spreadsheet aren't editable in Base, You could only search througt that data, filter them but can't change them. Regards Robert - -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -BEGIN PGP SIGNATURE- Version: GnuPG v2 iQIcBAEBAgAGBQJYpdizAAoJELDKYwaoS9AIRwMP/0OTzyPPWqhhDGIMN14MSDCo XdxFFXAfmA3SN8RjYLSRHKFqs3ldPO/Qv27Ui2B5+87638r7ZpQ93NpysS8u7Kmx vmkAbADxUqJoe+6T1Cx10D20yhp5pVimLTYEJZlqrAEK/KkwIRef8hnalhKNNLOa rrGWuXNaKug5R8EUjChkgdA8lOUNhLiZ59IjSmDsU6mULU6zildQqVxzfd5Am2TO EaNXrIseTe7v3v93oDnQK1GrN9bPldMp112PxYySB0Qgpqh26S7Qus0QLp4K4EED 4soMG1A2L1FQXTpNdHO856WUaN8qnXPxdJ0mNBT9AeiK330XtHuEvczQ7sFwfVv4 B4yebHHPWXVuKPQbzCiZ7A1IrJdjmn1UW+ejTemLy4P4j3APEHObGxnC8c8ZfGvv AqK63Ji59lZDQxBJEOnT3Woskk6kNuGOQWIjYwfDn0rtAqvt7Z3rq09VYLAEuO4G Eg69LLYSC/h9aoUPdURC5w+/qXBTbw0jK+GC+NtX8UaGKpxwtj6S1HBRZ2aRioeV oAdNFQEKRumtkoSAzPQbzHoAWd5Z+ZwoYcIo1j23v1p/QP1nEGwPks01LJiK7aO0 adAVjtn9k5oH4d4gtiJfAzk0pT2KaV/qlUoIgV0Im4lbAIgQrSUo8jdSDk/obZ0Y spqFaDe4xoQWOv26EuFf =EjGI -END PGP SIGNATURE- -- 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