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