The trouble is, Andreas, that I don't think we are allowed to let our end users have a saved document at all on their disk, due to security constraints. With this solution you describe I cannot tell if there will be a saved copy of this data on their local machine drive or not. I want a spreadsheet that will save all entries of the spreadsheet against the database.
Can you tell me if the solution you describe would do this? If not, then *that* is why I was looking to extend or alter the source of OpenOffice spreadsheet. The following statement you made makes me wonder ..."What you can NOT do: Write arbitrary data into spreadsheet cells and expect them to appear somewhere in the database. " If so, then I guess I have some more research. Your statement: "Only forms with form controls are designed to work with row sets. " ...made me wonder if the embedded writer forms could be used in some manner to this end...but I do not think so. The reason I do not think so is that the people who wish to use these spreadsheets *love* the spreadsheet UI for the work they do. Putting them in a form environment does not seem to fit the bill. Thanks for all your trouble, Andreas. Michael Fons On Sun, Nov 7, 2010 at 7:03 PM, Andreas Säger <ville...@t-online.de> wrote: > Am 07.11.2010 23:14, Fons, Michael wrote: > >> Thanks, Andreas Saeger, for your speedy reply! >> >> Where can I read more about "attaching input forms to sheets?" >> >> Again I appreciate your advice. >> >> On Sat, Nov 6, 2010 at 6:39 PM, Andreas Säger<ville...@t-online.de> >> wrote: >> >> Am 06.11.2010 23:22, Fons, Michael wrote: >>> >>> Hi. >>>> >>>> I am new here. For security issues, my boss would like me to alter some >>>> open source spreadsheet program, such that if a user of this modified >>>> spreadsheet program were to create and save a spreadsheet, it would save >>>> its >>>> contents to some database tables instead of a file. We would want to >>>> dictate what information got saved to the database, in what format, to >>>> what >>>> tables, etc. Basically the end-user wants the same spreadsheet >>>> front-end >>>> they are used to, but we need to change where it saves. >>>> >>>> Is there such an extension of OpenOffice already? >>>> >>>> If not then how do I find out what sections of the OpenOffice source >>>> apply >>>> to the spreadsheet package within OpenOffice? >>>> >>>> Thank you for your time. I am in the process of reading *OpenOffice.org >>>> Building Guide* >>>> >>>> Michael Fons >>>> 720-837-7830 >>>> >>>> >>>> You do not need any extension. You can attach input forms to sheets, >>> bind >>> them to a database and pull data from the database back into the >>> spreadsheet. To some extent this works without a single line of macro >>> code. >>> What you can NOT do: Write arbitrary data into spreadsheet cells and >>> expect >>> them to appear somewhere in the database. Only forms with form controls >>> are >>> designed to work with row sets. Spreadsheets have no row sets. >>> >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.org >>> For additional commands, e-mail: dev-h...@openoffice.org >>> >>> >>> >> > File>New>Database... > [X]Connect to existing db > Establish a connection to your db and add forms (embedded Writer documents) > Forms can be added to any stand-alone document as well: > View>Toolbars>Form Design > Button #5 shows the forms hierarchy where you can add forms and subforms > with form controls (View>Toolbars>Form Controls]. > This works with many databases you have a driver for and with all ODF > documents. > [Database] <-> [Server] <-> [Client,J/ODBC] <-> [Base document] <-> [Office > document] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@openoffice.org > For additional commands, e-mail: dev-h...@openoffice.org > >
