Perhaps not directly related, but, it may be instructive to see what was done to save an open document to a database and then to open a document directly from a database.
Initially, I think that there was no problem writing directly to a database, but there was a bug that prevented reading a Write document directly from the database without saving first. Somehow, I think that this bug is fixed... Unfortunately, I do not have access to my usual materials to search for solutions (and will not likely have access until sometime next week) so I cannot easily provide an example. On Thu, 11 Nov 2010 09:49:01 -0500, "Fons, Michael" <michael.f...@aderas.com> wrote: > 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 >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
