http://user.services.openoffice.org/en/forum/viewtopic.php?f=44&t=3801 http://www.oooforum.org/forum/viewtopic.phtml?t=6807 http://www.oooforum.org/forum/viewtopic.phtml?t=7011
On Thu, 11 Nov 2010 15:22:24 -0500, "Fons, Michael" <[email protected]> wrote: > I would very much like to see this, Andrew, next week when we if you get a > chance! > > On Thu, Nov 11, 2010 at 12:03 PM, Andrew Pitonyak > <[email protected]>wrote: > >> 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" >> <[email protected]> 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 <[email protected]> >> > 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<[email protected]> >> >>> 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: [email protected] >> >>>> For additional commands, e-mail: [email protected] >> >>>> >> >>>> >> >>>> >> >>> >> >> 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: [email protected] >> >> For additional commands, e-mail: [email protected] >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
