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