[dev] Re: spreadsheet with database instead of file

2010-11-06 Thread Andreas Säger

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



[dev] spreadsheet with database instead of file

2010-11-06 Thread Fons, Michael
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