Hi Steffen, thanks for that idea, but that would only be of use for predefined cases. The AddIn offers a lot of functions to query values and structural informations from a multi dimension database (a MOLAP server). Users should be able to create simple queries or even complex cockpit applications to visualize business developments over time or split into several areas or similar things. An example of such a cockpit could be found here: http://palooca.sourceforge.net/img/screen01_big.jpg
Each value you see there comes (either direct or indirect through some further calculations) from the database server. But a user (for example from the controlling department of a company) may wish to present such a sheet in a meeting where he doesn't have a connection to the server. So my idea was to take the whole document as it is, but remove all references to the server functions (by replacing them with the value they currently have) and also taking out each combo/listbox etc. The replacement isn't a problem, since that can be done through a "simple" loop through each cell of each sheet, respectively through each form element from the XDrawPagesSupplier. Since the full document may be unsaved or has unsaved changes I wanted to copy the whole document on runtime (i.e. without saving it to disk first) so I'm looking for some kind of interface which allows me to "duplicate" the document as OOo Calc currently "sees" it. I hope that made my intentions a bit clearer now :-) Thanks, Andreas. Am Fri, 15 Aug 2008 12:15:53 +0200 schrieb Steffen Grund <[EMAIL PROTECTED]>: > Hi Andreas, > > would a solution be that you create a template sheet and install that > with your AddIn and then just fill in the values using the API? You > could prepare everything except of the actual values in the template, > and so you do not have to be concerned with styles and formatting. > > I think this idea is quite obvious, so am I missing something? > Anyway, see > http://wiki.services.openoffice.org/wiki/Non-code_extensions on how > to add templates to your AddIn. > > > Regards, Steffen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
