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
