Re: [dev] Re: spreadsheet with database instead of file
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" 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 > 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" >> 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 >> > 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 >> >>> 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 >> >
Re: [dev] Re: spreadsheet with database instead of file
Sorry: I am still learning my way around. I did not know that Writer is the word processing package in OO. I see more what you are talking about now. I appreciate knowing that this functionality exists; and as you said, this may be instructive, Andrew. On Thu, Nov 11, 2010 at 3:48 PM, Fons, Michael wrote: > Andrew, > > If you could, would you please show me where I can read more about this > functionality of which you speak? We are doing research and if I could read > more about this functionality it would probably do as much for me as seeing > an example...although I still would love to see your example. > > I appreciate you calling my attention to this functionality! > > Michael F. > > > On Thu, Nov 11, 2010 at 12:03 PM, Andrew Pitonyak 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" >> 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 >> > 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 >> >>> 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.o
Re: [dev] Re: spreadsheet with database instead of file
Andrew, If you could, would you please show me where I can read more about this functionality of which you speak? We are doing research and if I could read more about this functionality it would probably do as much for me as seeing an example...although I still would love to see your example. I appreciate you calling my attention to this functionality! Michael F. On Thu, Nov 11, 2010 at 12:03 PM, Andrew Pitonyak 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" > 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 > > 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 > >>> 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 Con
Re: [dev] Re: spreadsheet with database instead of file
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 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" > 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 > > 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 > >>> 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] > >> > >> > >> > >> ---
Re: [dev] Re: spreadsheet with database instead of file
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" 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 > 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 >>> 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
Re: [dev] Re: spreadsheet with database instead of file
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 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 >> 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 > >
[dev] Re: spreadsheet with database instead of file
See also: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=35635&p=163397#p163397 - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: spreadsheet with database instead of file
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 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
Re: [dev] Re: spreadsheet with database instead of file
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 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 > >
[dev] Re: spreadsheet with database instead of file
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
