Re: [api-dev] Excel's Offset substitute?

2008-03-01 Thread Mathias Röllig
Hello Dmitry! Am 26.02.2008 17:45 schrieb Dmitry Teslenko: Hello! Some time ago I've needed to implement Excel-like Offset function and I've got this: Private Function __CompatOffset(ByRef objSource As Object, _ intRow As Integer, intColumn As Integer) As Object Dim intSheet As

Re: [api-dev] SystemShellExecute.execute(document) opens always Firefox in Linux

2008-02-29 Thread Mathias Röllig
Hello Tobias! Am 28.02.2008 17:50 schrieb Tobias Krais: I want to use the SystemShellExecute.execute method to open Documents that OOo can not open. Giving the file location as the parameter aCommand opens the document with the default application in Windows. In Linux my Firefox is opened,

[api-dev] any workaround for issue 84718?

2008-02-27 Thread Mathias Röllig
Hello! I created a form document for a costumer so one can dial a phone number from this form. The macrocode for this uses SystemShellExecute. It worked fine until OOo 2.1. Now it doesn't work but the costumer want to use it. The target of this issue is set to OOo 3.0. But is there a usable

Re: [api-dev] Sort problem

2008-01-05 Thread Mathias Röllig
Hello Hubert! Am 01.01.2008 22:12 schrieb Rudolf Huber: the example works perfectly. Thanks. Thanks for your response. Hope, you can now do what you want. I wish your entire group a very Happy New Year 2008. Ebenfalls ein gesundes neues Jahr! Greetings Mathias -- ·-· cut here

Re: [api-dev] Problems with insertDocument

2007-11-25 Thread Mathias Röllig
Hello Thomas! Am 23.11.2007 17:13 schrieb Thomas Krumbein: Now, I am using insertDocumentFromURL() to insert Doc2 in my MasterDocument. It works fine - but afterwards the Paragraph-style Standard of my MasterDoc is changes and charFont is now Times New Roman Therefor the hole formating

Re: [api-dev] Problems with insertDocument (addition)

2007-11-25 Thread Mathias Röllig
Hello Thomas! Am 23.11.2007 17:13 schrieb Thomas Krumbein: I do have some strange problems using insertDocument. Maybe someone can give me some advise? Situation: I do have two writer Documents (lets call them MasterDoc and Doc2). In all documents my Standard charFont ist Arial, the

Re: [api-dev] How to change the default page style

2007-10-26 Thread Mathias Röllig
Am 25.10.2007 20:48 schrieb Ool: If this behavior regards to all document types (text, sheet, graphic), it seems there is a problem with the printer driver. (Or this is a language depending feature that i don't know.) Could be. I have an American release of Windows XP running here. All the

Re: [api-dev] dialog opens behind the document

2007-10-26 Thread Mathias Röllig
Am 26.10.2007 09:19 schrieb Mathias Bauer: Could you please send me the ods file? I would like to have a closer look. You have mail. greetings Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-·

Re: [api-dev] Refreshing document structure and state using refresh() and reformat()

2007-10-26 Thread Mathias Röllig
Am 04.10.2007 23:28 schrieb ashok _: I have a writer document. In this document I am moving TextSection objects using the API. section1 section1.1 section1.2 section2 section2.1 section3 section4 If I move section3 before section2 - and I view the section structure using

Re: [api-dev] How to change the default page style

2007-10-26 Thread Mathias Röllig
Am 26.10.2007 14:10 schrieb Ool: If this is a locale problem so go to Tools - Options - Language Settings - Language and change the Locale Setting to English (UK). Yes! That worked. Thanks a bundle! Now i tried it by myself. I don't know when this behavior was changed. So now the initial

Re: [api-dev] How to change the default page style

2007-10-26 Thread Mathias Röllig
Am 26.10.2007 21:34 schrieb Ool: Actually I very much prefer an English user interface. That way when I ask for international online support I don't have to rake my brain what the English label for something like the Extras pull-down menu is. (Or what Tools would be in German...) I have to

Re: [api-dev] How to change the default page style

2007-10-25 Thread Mathias Röllig
Am 25.10.2007 00:35 schrieb Ool: I have the settings of all my printers set to A4 and still all the new documents OpenOffice creates are letter-sized until I change them manually-every single one. Change the paper format in the properties of the default printer (driver) of the system, so

Re: [api-dev] dialog opens behind the document

2007-10-25 Thread Mathias Röllig
Hello Mathias! I have a calc template with macros and a dialog in it. The main macro is bound to the event create document of the template. The macro loads the dialog. If i double click the template file (linux, ubuntu) and a other OOo-window is open, the dialog starts behind the new

Re: [api-dev] How to change the default page style

2007-10-16 Thread Mathias Röllig
Hello Reinhold! Am 05.10.2007 11:26 schrieb Reinhold Merk: is it possible to change the default page style, more precisely the paper format from A4 to another value (in that way that OO starts every time with this value and the user needs not to change it manually)? I've searched in the

Re: [api-dev] Moving CoceSnippets into the Wiki?

2007-08-20 Thread Mathias Röllig
Am 19.08.2007 21:41 schrieb Frank Schönheit - Sun Microsystems Germany: Alternatively (and perhaps better and less expensive in terms of work to be invested), we should think about lowering the hurdles for contribution with the existing snippet creator. What about some semi-automated way to

Re: [api-dev] mysterious StarBasic problem

2007-06-15 Thread Mathias Röllig
Hello Noelson! It seems a typo, change to: Select Case iNum Thanks for the correction. But it is only a mistake in my email. Otherwise the macro would never run ... So here is the description with the correct statement: In a basic macro i use a simple Select Case statement: Option Explicit

Re: [api-dev] Waiting for a document load and for a form load

2007-05-31 Thread Mathias Röllig
Am 29.05.2007 18:56 schrieb Mathias Bauer: Do Until oForm.isLoaded Wait( 100 ) Loop This has the drawback that it is busy waiting, costs CPU time and can create reentrance problems. But in case there's no listener that allows to wait in passive state (don't know that, sorry) it's indeed

Re: [api-dev] Waiting for a document load and for a form load

2007-05-29 Thread Mathias Röllig
Hello Mathias! Do Until oForm.isLoaded Wait( 100 ) Loop This has the drawback that it is busy waiting, costs CPU time and can create reentrance problems. But in case there's no listener that allows to wait in passive state (don't know that, sorry) it's indeed the only chance. I can add

Re: [api-dev] Waiting for a document load and for a form load

2007-05-16 Thread Mathias Röllig
Hi Frank! Am 16.05.2007 12:03 schrieb Frank Schönheit - Sun Microsystems Germany: oForm.moveToInsertRow() oControl = oForm.getByName( mySubform ).getByName( myControl ) Wait( 3000 ) oControl.setString( myString ) I tried also oForm.getByName( mySubform ).reload() Do Until oForm.getByName(

Re: [api-dev] Waiting for a document load and for a form load

2007-05-15 Thread Mathias Röllig
Hi Mathias! Thanks for your quick response! oDoc = StarDesktop.loadComponentFromURL( myDoc, _blank, 0, props() ) '***(1)*** waiting for document load oForm = oDoc.DrawPage.Forms.getByName( myForm ) oForm.moveToInsertRow() oControl = oForm..getByName( mySubForm ).getByName( myControl ) '***(2)***

Re: [api-dev] Waiting for a document load and for a form load

2007-05-15 Thread Mathias Röllig
(2) How can i test that the form is fully loaded? No idea, sorry. What does that mean? Try to create an UNO-Listener, http://api.openoffice.org/docs/common/ref/com/sun/star/form/XLoadListener.html I tried this, but it doesn't work if i do nothing wrong. But if Mathias is right, that the

Re: [api-dev] Waiting for a document load and for a form load

2007-05-15 Thread Mathias Röllig
Am 15.05.2007 16:13 schrieb Mathias Röllig: It is a writer document with a database form on it. The database form is connected to a database. So it is possible that the makro not need to wait for the document but that the database connection is established(?). With the knowledge

Re: [api-dev] Making fields read-only

2007-05-10 Thread Mathias Röllig
Hello Jakob! Am 09.05.2007 14:55 schrieb Jakob Lechner: In my case the content of the fields is provided by a C++ addon. If certain values are displayed the user shall be allowed to modify the field content, if some other values are displayed the user shouldn't be allowed to change the

Re: [api-dev] Making fields read-only

2007-05-08 Thread Mathias Röllig
Am 08.05.2007 08:33 schrieb Mathias Bauer: Here's my question: I want some of the inserted fields to be read-only but I haven't found a property in the field API yet. Any ideas? I'm afraid that this isn't available. Sounds like a useful enhancement. Sure? Perhaps, if the field can be

Re: [api-dev] Making fields read-only

2007-05-07 Thread Mathias Röllig
Am 02.05.2007 09:35 schrieb Jakob Lechner: I posted this question already at the extensions mailing list but I haven't received an answer yet. May be someone here knows an answer. Here's my question: I want some of the inserted fields to be read-only but I haven't found a property in the

Re: [api-dev] Replaceing selected text with Basic Macro

2007-04-17 Thread Mathias Röllig
Am 17.04.2007 11:45 schrieb Johnny Andersson: Is this what always happens or did I do something wrong? I think no (twice). I filed a issue: http://api.openoffice.org/issues/show_bug.cgi?id=76449 Greetings MRoe -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-8·-·

Re: [api-dev] How copy a sheet to another calc document?

2007-03-11 Thread Mathias Röllig
Am 11.03.2007 03:52 schrieb TerryJ: Have a look at this post: http://www.oooforum.org/forum/viewtopic.phtml?p=189530#189530 which refers to this post showing how to create a link: http://www.oooforum.org/forum/viewtopic.phtml?p=66195#66195 This post (at the end of the thread containing

[api-dev] How copy a sheet to another calc document?

2007-03-09 Thread Mathias Röllig
Hello! I want copy a sheet from a document to another document by using a basic script that is embedded in the first document. After searching in the mailinglists I have found http://api.openoffice.org/servlets/ReadMsg?listName=devmsgNo=6847 where Stephan (3,5 years ago) described a solution

Re: [api-dev] How copy a sheet to another calc document?

2007-03-09 Thread Mathias Röllig
Am 09.03.2007 16:46 schrieb Mathias Röllig: Hello! I want copy a sheet from a document to another document by using a basic script that is embedded in the first document. After searching in the mailinglists I have found http://api.openoffice.org/servlets/ReadMsg?listName=devmsgNo=6847

Re: [api-dev] getting the actual text of a formatted field

2006-12-08 Thread Mathias Röllig
Hello Berend and Frank! Am 05.12.2006 12:45 schrieb Frank Schönheit - Sun Microsystems Germany: this is a bug that I could reproduce. The property Text or its method pendant getText() of the control should return the displayed text. I submitted

[api-dev] getting the actual text of a formatted field

2006-12-03 Thread Mathias Röllig
Hello! I want to create a letter via basic macro. The macro reads the initial data for the letter from a form - the form controls are not linked to a database. For the date i want to use a date control, but there isn't a formatting like 'd. '. So i use a formatted field with this

Re: [api-dev] printing current sheet

2006-11-15 Thread Mathias Röllig
Hello Marc! Am 14.11.2006 00:09 schrieb Marc Santhoff: So the question is: how can i figure out, which print page number has the actual sheet? Or, how can i figure out, on which print page(s) will a special print area reside? As a workaround you can: - use the PrintAreas of the calc doc:

Re: [api-dev] printing current sheet

2006-11-13 Thread Mathias Röllig
Hello Tobias! Thank you for your answer. Am 13.11.2006 13:14 schrieb Tobias Krais: In a calc document i want to place a button with that the user can print the actual sheet or rather the defined (and named) print area at the sheet. But i can't find the right print options to do that. please

Re: [api-dev] printing current sheet

2006-11-13 Thread Mathias Röllig
Hello Marc! Am 14.11.2006 00:09 schrieb Marc Santhoff: So the question is: how can i figure out, which print page number has the actual sheet? Or, how can i figure out, on which print page(s) will a special print area reside? You can't, OO.o does not allow to do so. This should be worth an

Re: [api-dev] [CPHennessy] [users] Print order '4; 1; 2; 3'?

2005-08-10 Thread Mathias Röllig
Am 10.08.2005 09:47 schrieb Turbo Fredriksson: I don't know, why you would specifify the pageorder. If you print pages 1-8 with the 'brochure' option, you will get a 'book' with 8 pages in the right order. Also pages 9-16, 17-32 aso. Oki, so which variable do i set for this? I can set the

Re: [api-dev] How to open a database form

2005-02-16 Thread Mathias Röllig
Hi Frank, Am 16.02.2005 13:53 schrieb Frank Schönheit - Sun Microsystems, Inc.: Is there a way to link writer documents (form document) to a database? I can't see it ... No, the Links (or Verknüpfungen in your version) are not available anymore. The idea is that you now store your text