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

Reply via email to