Re: [api-dev] API support for prototyping grammar checker API

2005-01-17 Thread Andrew Douglas Pitonyak
My Comments at the bottom :-) Jorge Marques Pelizzoni wrote: The grammar checker already exists and implements "auto" checking in two text processors to no significant performance loss. If this can not be reproduced in OOo, that will be solely OOo's fault. Cheers, Jorge. Quoting Christian Junker <[

Re: [api-dev] OOo Basic Specification

2005-01-21 Thread Andrew Douglas Pitonyak
Curtis Clauson wrote: Is there a complete specification for the OOo Basic language? There are so many historic flavors of Basic that it is difficult to tell what is supported in OOo. I'm not looking for incomplete guides like Mr. Pitonyak's Useful Macro Infomation, but a complete language specif

Re: [api-dev] Re: OOo Basic Specification

2005-01-21 Thread Andrew Douglas Pitonyak
Curtis Clauson wrote: Unfortunately, the Sun Basic book focuses on how to use Basic to access the OOo API, and does not fully specify the OOo Basic language. It is actually less comprehensive than the current OOo docs, which is as it should be. Agreed. Although I appreciate your efforts, I cann

Re: [api-dev] Re: OOo Basic Specification

2005-01-21 Thread Andrew Douglas Pitonyak
Curtis Clauson wrote: Jürgen Schmidt wrote: Hi Curtis, no, there is no specification available. Only the existing online help and the docu in the DevGuide. When you find bugs in both kind of documentation, you can easy help us by submitting an issue for the problem. The Community will owe it t

Re: [api-dev] long way to OOo 2.0?

2005-01-28 Thread Andrew Douglas Pitonyak
Robin Nalson wrote: I am just a newbie, currently making preliminary experiments with the version from the site (1.1.4). But I keep hearing about OOo 2.0 and it seems a long way to go. Some doubts: i) Should I expect it to be backwards compatible with the API and stuff from version 1.1.4? Yes,

Re: [api-dev] TextCursor at ViewCursor

2005-01-29 Thread Andrew Douglas Pitonyak
Laurent Godard wrote: Hi, In a text document, how can i get a XTextCursor at the current position of the ViewCursor? viewCursor = document.getCurrentController().getViewCursor() textCursor = document.Text.createTextCursor() //TextCursors include the TextRange service viewCursorRange = viewCursor.

Re: [api-dev] TextCursor at ViewCursor

2005-01-29 Thread Andrew Douglas Pitonyak
Laurent Godard wrote: Hi Andrew, Could you explain how there can be more that one Text object in a writer document ? Thanks in advance laurent If the text cursor is inside of a text table, for example. The text object for the text table cells will not be the same as the documents text object

Re: [api-dev] Python in 1.9.74

2005-01-29 Thread Andrew Douglas Pitonyak
Ian Laurenson wrote: I have put together a uno package that contains a Python component. The component uses the os module. The package installs and runs fine 1.1.4. In 1.9.74 (for Linux - Mandrake 10.1) I get the following error message when installing the package via: Tools > Package Manager... >

[api-dev] How to create a database in OOo 2.0?

2005-01-29 Thread Andrew Douglas Pitonyak
I am so close, I can smell it, but it does not work. Any comments on the steps that I am missing... I think that I need to set default keys and that sort of thing... The following macro tries to create a databsae document... Sub NewDB Dim sDBUrl As String 'URL of a New Database document.

Re: [api-dev] How to create a database in OOo 2.0?

2005-02-01 Thread Andrew Douglas Pitonyak
Frank Schönheit wrote: Hello Andrew, I am so close, I can smell it, but it does not work. Any comments on the steps that I am missing... I think that I need to set default keys and that sort of thing... The following macro tries to create a databsae document... Which part of your macro i

Re: [api-dev] insert a bunch of paragraphs into main text via API

2005-02-03 Thread Andrew Douglas Pitonyak
Marc Santhoff wrote: Hi, I'm stuck with text portions again: The task is to insert a TextRange consisting of one or more paragraphs with complex char and paragraph formatting into a given text. How is this expected to be done? I read any type of docs, but found no direct method of doing so. I can i

Re: [api-dev] insert a bunch of paragraphs into main text via API

2005-02-08 Thread Andrew Douglas Pitonyak
Marc Santhoff wrote: Am So, den 06.02.2005 schrieb Bernard Marcelly um 15:22: Le 2005-02-03 23:44, Marc Santhoff a écrit : Hi, I'm stuck with text portions again: The task is to insert a TextRange consisting of one or more paragraphs with complex char and paragraph formatting into a given

Re: [api-dev] TextFrame hidden attribute

2005-02-10 Thread Andrew Douglas Pitonyak
A text section can have IsVisible set to false Not certain about text frames Curtis Clauson wrote: I have some RTF files that have text frames and open fine in MSWord. In OOo, the text frames are not shown and are listed in the Navigator as "Hidden". I cannot find a reference to any kind o

[api-dev] How to open a database form

2005-02-11 Thread Andrew Douglas Pitonyak
Using the latest development build. OK, perhaps not the latest (every copy of 77 has had a bad CAB file for the windows environment tried from three mirrors. Maybe I require a different zip program) ... How can I load a Base document, choose a form, and then cause one of the forms to be op

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

2005-02-11 Thread Andrew Douglas Pitonyak
Thanks Frank. It had not occured to me to tyr to load the form as a component. Awesome! Frank Schönheit - Sun Microsystems, Inc. wrote: Hi Andrew, How can I load a Base document, com.sun.star.sdb.DatabaseContext.loadComponentFromURL( ... ) choose a form, and then cause one of the f

[api-dev] Testing the state of CompatibilityMode

2005-02-13 Thread Andrew Douglas Pitonyak
In Basic, I can turn compatibility mode on and off for each specifi module. I can also use the CompatibilityMode method to specifically turn compatibility mode on and off in a piece of code. Is there any way to check the state of compatibility mode? Some routines return the current state when

Re: [api-dev] Re: Testing the state of CompatibilityMode

2005-02-13 Thread Andrew Douglas Pitonyak
Curtis Clauson wrote: Andrew Douglas Pitonyak wrote: In Basic, I can turn compatibility mode on and off for each specifi module. I can also use the CompatibilityMode method to specifically turn compatibility mode on and off in a piece of code. Is there any way to check the state of

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

2005-02-15 Thread Andrew Douglas Pitonyak
Ian Laurenson wrote: On Wed, 2005-02-16 at 14:28, Ian Laurenson wrote: On 2005-02-12, "Frank Schönheit - Sun Microsystems, Inc." wrote: Andrew Pitonyak wrote: How can I load a Base document, com.sun.star.sdb.DatabaseContext.loadComponentFromURL( ... ) [remainder snip

Re: [api-dev] Format for information file about templates and addons

2005-02-25 Thread Andrew Douglas Pitonyak
Christian Junker wrote: Hi Paolo, I disagree with your point 2.). Usually you should not focus on GUI aspects and how something should look, before you haven't accomplished full functionality. That is the "bottom-up-way" of program design and normally GUIs are often simpler to do, especially wit

Re: [api-dev] CDbl function

2005-03-07 Thread Andrew Douglas Pitonyak
Sevastian `seva` Foglia wrote: I found where problem is: environment variable LANG on linux. If LANG is [EMAIL PROTECTED] this macro Sub Main Dim sVal as String sVal = "0,30" print CDbl(sVal) End Sub return 0 If LANG is not set macro return correct value 0,3 Perhaps you should add this

Re: [api-dev] Search text and insert page break

2005-03-11 Thread Andrew Douglas Pitonyak
Hi Cristian, I do all of my examples in Basic Sorry! Cristian Fonti wrote: Hi to all, I'm a newbie in Api Open Office programmation with Java. I have a writer document, and i want to search a "particular string", when i found it, i want to insert a PAGE BREAK. On my web site, I recently posted

Re: [api-dev] Problem with insertDocumentFromURL

2005-03-14 Thread Andrew Douglas Pitonyak
Cristian Fonti wrote: Hi to all, i have a problem using the method insertDocumentFromURL: when i use it to insert some formatted text (font size, font color,etc...) from another document, in the destination file appear at the top of the document 2-3 blank row... the code snipplets is: xTextDoc

Re: [api-dev] Problem with insertDocumentFromURL

2005-03-15 Thread Andrew Douglas Pitonyak
Cristian Fonti wrote: Andrew Douglas Pitonyak ha scritto: Cristian Fonti wrote: Hi to all, i have a problem using the method insertDocumentFromURL: when i use it to insert some formatted text (font size, font color,etc...) from another document, in the destination file appear at the top of

Re: [api-dev] Writer: position of elements on the page

2005-03-17 Thread Andrew Douglas Pitonyak
Michael Hoennig wrote: I was wondering if there is a way of getting the position of elements (graphics objects, embedded objects, drawing elements, frames) in a Writer document relative to the page? All these are Shapes, but getPosition() is not implemented, most likely because it is not known on t

Re: [api-dev] Setting the title of a document

2005-03-27 Thread Andrew Douglas Pitonyak
Do you mean this? ThisComponent.getDocumentInfo().Title = "New Title" Henri Sivonen wrote: How can I get and set the title of a document (the one available through document properties and meta.xml) through the Java API? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw

Re: [api-dev] Re: Hi,i need help with api open office,and i see that you know a lot, help me please.

2005-04-11 Thread Andrew Douglas Pitonyak
Darragh Sherwin wrote: Hi Albert, Please use the mailing list in future, you will get a quicker and better response. Unfortunately, it has been a while since I looked at this code, I don't think it will work. The problem is that each paragraph contains so much formatting attributes, etc that wou

Re: [api-dev] Page Number

2005-04-13 Thread Andrew Douglas Pitonyak
Cristian Fonti wrote: Hi to all, i want to insert a page number in a Writer document with Java Api. All is ok when the page number start from 1, but how can i do if i want that the page number start from a variable value??? This is my code to insert a Page Number from 1: Object pn=mxDoc

Re: [api-dev] Page size and Page format

2005-04-13 Thread Andrew Douglas Pitonyak
Cristian Fonti wrote: Hi to all, what is the property in Java Api to set the Page size(A4,A3...) and the Page Format (Landscape,Portrait)/Allignment in a Writer Document??? I use this code: XStyleFamiliesSupplier StyleFam = (XStyleFamiliesSupplier) UnoRunti

Re: [api-dev] hidden/show OpenOffice

2005-04-15 Thread Andrew Douglas Pitonyak
You might want to consider simply locking the controllers... :-) The XWindow interface should support the SetVisible(boolean) method. The problem is that if a document is loaded hidden, there are some things that are apparently NOT initialized so setting the document visible after loading might

[api-dev] Re: [users] 1.9.95 script calling Calc built-in functions

2005-04-25 Thread Andrew Douglas Pitonyak
The returned object is typically a global object, so if you dispose it, then you can not get a new one until you restart OpenOffice.org. I found this while playing with some database stuff. Jahn, Ray (R.) wrote: Thanks for the advice provided by Kohei. I found useful content in both the Develop

Re: [api-dev] OOoBasic or Python?

2005-04-26 Thread Andrew Douglas Pitonyak
[EMAIL PROTECTED] wrote: Hi all, If a city council wants to migrate to OOo 2.0, and they have to convert VB macros, would it be advisable to reimplement them in Python or would it be easier to convert them to OOoBasic? And if they want to start writing and testing with OOo 1.1, how big are the diff

[api-dev] Re: [users] 1.9.95 script calling Calc built-in functions

2005-04-27 Thread Andrew Douglas Pitonyak
Jahn, Ray (R.) wrote: Thanks to the explanation by Andrew Douglas Pitonyak and Mathias Bauer. Scope: global vs. local vs. any other Are all objects returned by CreateUnoService() global objects and therefore not to be disposed of by users? If the answer is dependent on the exact service requested

Re: [api-dev] Problems with Page Style

2005-04-28 Thread Andrew Douglas Pitonyak
No comment on use in Java, but Cristian Fonti wrote: Hi to all, i have a problem with the Api: I generate a new Writer document, with a Java procedure, with import others documents with the method insertDocumentUrl. Now, i would to use different styles for the header of right and left pages

Re: [api-dev] new text document from selction by API

2005-05-02 Thread Andrew Douglas Pitonyak
Marc Santhoff wrote: Hi, I need to make a new writer doc from another wroter docs selection. In this case the clipboard cannot be used because the target doc has to stay hidden (no dispatch with hidden docs). How can this be done? TIA, Marc Tricky! You might try something like save the document

Re: [api-dev] Re: newbie drawing question

2005-05-11 Thread Andrew Douglas Pitonyak
Yes, if you want to draw a line, you create a line object and then add it to the document. The Draw and Impress chapters of my book are available as a free download, and it contains numerous examples of shapes and lines and such. Jürgen Schmidt wrote: Hi Senthil, no your understanding is wrong,

Re: [api-dev] Macro to delete a Calc named range

2005-05-28 Thread Andrew Douglas Pitonyak
Ennio-Sr wrote: Hi all, I'm wondering whether it is possible to delete/create named ranges by a macro. My attempts were unsuccessfull in either cases: when I record all the relative steps to perform that action no warning appears; however, the final recorded macro doesn't do what expected. Can

Re: [api-dev] Macro to delete a Calc named range

2005-05-31 Thread Andrew Douglas Pitonyak
; but they do work now (may be I was too tired ;) ) * Andrew Douglas Pitonyak <[EMAIL PROTECTED]> [280505, 18:56]: Ennio-Sr wrote: Hi all, I'm wondering whether it is possible to delete/create named ranges by a macro. [skip] Is this enough to get you started?

Re: [api-dev] How to insert and remove annotation?

2005-05-31 Thread Andrew Douglas Pitonyak
Liao Yu wrote: >Hi, >We can hide and show annotations in a text document via OOo >API, but how can we insert or remove one with API? > >Regards, > > >Yu > > An annotation is just a text field, you can remove it as any other text field. -- Andrew Pitonyak My Macro Document: http://www.pitonyak

Re: [api-dev] Sequence of Texttables

2005-06-14 Thread Andrew Douglas Pitonyak
Martin Thoma wrote: Hello! I have a text-document which contains some tables: Table1 (Named "MyTable") Table2 (Named "My 2nd Table") I copy+paste (executeDispatch) Table1 some times into the document: Table1 (Named "MyTable") NewTable (Named "Table 4") NewTable (Named "Table 5") NewTable (Name

Re: [api-dev] Calc Outline and cell address

2005-06-26 Thread Andrew Douglas Pitonyak
I also was unable to find anything, and I did search and inspect... Laurent Godard wrote: Hi all, i play with calc Outline and experiences some troubles 1- on a sheet, using showDetail and hideDetail hideDetail works even if only the adresse one cell of the range is used as argument showDet

Re: [api-dev] Re: newbie drawing question

2005-07-27 Thread Andrew Douglas Pitonyak
d the page, or found the page and removed it. REM Create a new page, set the name, and return the page. oPages.insertNewByIndex(oPages.getCount()) oPage = oPages.getByIndex(oPages.getCount()-1) oPage.setName(sName) createDrawPage = oPage End Function /// Thanks

Re: [api-dev] Browsing the source code

2005-07-27 Thread Andrew Douglas Pitonyak
I typically download the source code and then I use a text search on the whole thing. Of course, the whole thing is more than 1GB I think, so on my computer, this can take a long time. Especially since sometimes I search for the wrong thing :-( Senthilkumar Mehalingam wrote: Hi All, I want

Re: [api-dev] Populating a Calc document via DDE

2005-07-27 Thread Andrew Douglas Pitonyak
Davide Dozza wrote: Hi all, We've a SAS application which populates an Excel document using DDE. We need to translate such procedure in order to populate a Calc document in the same way. The question is: how much is DDE standard enough in order to reuse the code? Davide The DDE is proba

Re: [api-dev] Browsing the source code

2005-08-01 Thread Andrew Douglas Pitonyak
e unzipped version had 116 cpp source files. Are the functions implemented in some other files having a different extension or am I making a mistake. I would appreciate any help. Sincerely Senthil From: Andrew Douglas Pitonyak <[EMAIL PROTECTED]> Reply-To: dev@api.openoffice.org To: dev@ap

Re: [api-dev] Insert embedded graphic by breaking the image link

2005-08-04 Thread Andrew Douglas Pitonyak
Please report your findings. I cover this topic in my free macro document and I can add that information into the document. MuiFull Tam wrote: HI Stephan, I tried with your solution and it worked perfectly. :) Thanks for taking time! I will try also the solution from Christian and compare w

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

2005-08-13 Thread Andrew Douglas Pitonyak
Mathias Röllig wrote: 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

Re: [api-dev] Active cell from selection

2005-08-13 Thread Andrew Douglas Pitonyak
Jayant Balraj Madavi wrote: Hi, I create a Range from Selection. how do I find the active cell ?? uno::Reference< frame::XModel > xModel( m_xDesktop->getCurrentComponent(), uno::UNO_QUERY );

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

2005-08-14 Thread Andrew Douglas Pitonyak
Marc Santhoff wrote: Am Samstag, den 13.08.2005, 17:21 -0400 schrieb Andrew Douglas Pitonyak: Mathias Röllig wrote: [...] I think you need http://api.openoffice.org/docs/common/ref/com/sun/star/text/PrintSettings.html#PrintProspect greetings Mathias What is

Re: [api-dev] OOoBasic : Open a new base document

2005-10-10 Thread Andrew Douglas Pitonyak
Laurent Godard wrote: Hi paolo just randomly tried with "private:factory/sdatabase" and... it works!! :-) (OOo 1.9.128) thanks i've tried during my long train trip and found this but not randomly :) randomly, i tried sbase and not sdatabase btw, the info is stored in /share/registry/modul

[api-dev] Removing focus from a control

2008-10-27 Thread Andrew Douglas Pitonyak
I was recently asked how to solve a "simple" problem. A checkbox in a Calc document calls a macro when it is "clicked". I want the macro to select a cell such that the cell is in input mode. Ignoring the checkbox, I can use code similar to the following: Sub CellSelectOne Dim oCell Dim oShee

Re: [api-dev] Removing focus from a control

2008-10-28 Thread Andrew Douglas Pitonyak
). Just add this instruction at end of your macro: oFrame.ContainerWindow.setFocus By the way, I did not know the .uno:SetInputMode trick ! __ Bernard Message de Andrew Douglas Pitonyak date 2008-10-28 04:36 : I was recently asked how to solve a "simple" problem. A checkbox

Re: [api-dev] Calc with two tables

2008-12-04 Thread Andrew Douglas Pitonyak
Rudolf Huber wrote: Hallo, the following sequence leads to an "indexoutofboundexception". In the beginning I have the opening statements: Dim Desktop As Object Dim Platzhalter() Dim Url As String Dim oTabellenDokument As Object Rem the entire Document

Re: [api-dev] Calc with two tables

2008-12-07 Thread Andrew Douglas Pitonyak
? I am not sure what you are saying. Are you implying that you are not referencing the correct document? Regards, Rudi - Original Message - From: "Andrew Douglas Pitonyak" <[EMAIL PROTECTED]> To: Sent: Thursday, December 04, 2008 2:25 PM Subject: Re: [api-dev] Calc

Re: [api-dev] Calc with two tables

2008-12-12 Thread Andrew Douglas Pitonyak
dexception.. I really appreciate your help. Regards, Rudi - Original Message - From: "Andrew Douglas Pitonyak" To: Sent: Sunday, December 07, 2008 7:36 PM Subject: Re: [api-dev] Calc with two tables Rudolf Huber wrote: Hallo Andrew, thanks for the prompt answer. Instead of

Re: [api-dev] Calc with two tables

2008-12-14 Thread Andrew Douglas Pitonyak
erefore, it takes a while until I get the point. I really appreciate help in this matter. Have I nice week. Thank you again. Rudi - Original Message - From: "Andrew Douglas Pitonyak" To: Sent: Saturday, December 13, 2008 2:48 AM Subject: Re: [api-dev] Calc with two tables

Re: [api-dev] maximum size of data base

2008-12-15 Thread Andrew Douglas Pitonyak
Asha Balu wrote: (1) as against maximum of 02 GB of (.mdb file even the latest access 2007) data base , what is maximum size of .sdp file open office database I do not remember off hand (2) which is best front end free ware for our data base ( because i would like to learn the same)

Re: [api-dev] How to pass a connection to a Subform

2008-12-27 Thread Andrew Douglas Pitonyak
I have been trying to follow what you are doing and I am not sure that I really understand. Usually, I have a base document that contains forms. The base document references a datasource (database) of some sort. I then have my forms reference that same database. For example: sub subDisplayFo

Re: [api-dev] new member

2008-12-28 Thread Andrew Douglas Pitonyak
Jeff Rosenberg wrote: Can I create a word document to type cover letters to send to prospective employers? Can I also create a program to download or cut & paste an existing resume to send to employers with your program? If not could you direct me to a program that I can either install or bu

[api-dev] Setting Cell Annotation text attributes

2009-01-16 Thread Andrew Douglas Pitonyak
I would also like to be able to set the font for text in a CellAnnotation (note). Using the GUI, I can select text in an annotation and set the font. When I look at the Wiki, it specifically says that I can not do this: http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsh

Re: [api-dev] Setting Cell Annotation text attributes

2009-01-17 Thread Andrew Douglas Pitonyak
Bernard Marcelly wrote: Message de Andrew Douglas Pitonyak date 2009-01-17 04:27 : I would also like to be able to set the font for text in a CellAnnotation (note). Using the GUI, I can select text in an annotation and set the font. When I look at the Wiki, it specifically says that I can

Re: [api-dev] RE: UNO Java: adding a motion path Animation to an XShape in Impress

2009-01-17 Thread Andrew Douglas Pitonyak
John, I do not remember seeing any replies on list (since you ask). People did see the question, however. I took a quick look at all of my documentation that I have produced. I thought that I had done this once just to test it. Seems that I did not. the point is that I spent ten minutes loo

[api-dev] Where should I fix Wiki errors?

2009-01-20 Thread Andrew Douglas Pitonyak
Clayton, I am using a BCC to copy you directly, because I think that I really need to ask you about this. I am sending directly to the api list as a backup. I do not want to complain too loudly, since I really like these Wiki pages, but... I have seen errors in the documentation regarding th

Re: [api-dev] Where should I fix Wiki errors?

2009-01-21 Thread Andrew Douglas Pitonyak
Clayton wrote: Juergen Schmidt wrote: Hi Andrew, we all know you as Basic expert, if you identify this kind of problems feel free to change it in the wiki directly. That is the main advantage of the wiki. You can change things on the fly. And of course it was main reason to shift to the wiki

Re: [api-dev] Java: insert DOC into a new Impress document?

2009-01-22 Thread Andrew Douglas Pitonyak
Can you do this from the GUI? I tried and failed. My point is just that if you can not do this from the GUI, then you probably can not do this using the API (not always true, but...) Albert Law wrote: Hi, I was wondering how to insert a DOC file into a new Impress document. I'm at the point

[api-dev] Finding Formula objects in a Write document

2009-02-03 Thread Andrew Douglas Pitonyak
How can I find a Formula object in a paragraph? I can enumerate the embedded objects in the document as follows: Sub LookAtEmbeddedObjects Dim oDoc Dim oEmbed Dim oObj Dim i As Integer Dim s As String oDoc = ThisComponent oEmbed = oDoc.getEmbeddedObjects() s = "" For i = 0 To oEmbed.ge

Re: [api-dev] Finding Formula objects in a Write document

2009-02-03 Thread Andrew Douglas Pitonyak
Bernard Marcelly wrote: Message de Andrew Douglas Pitonyak date 2009-02-03 16:50 : How can I find a Formula object in a paragraph? I used a simple enumeration of the text object, and I even found the text section containing the formula. I only know this, however, because I used a very

[api-dev] How to make a Python macro visible to OOo?

2009-02-06 Thread Andrew Douglas Pitonyak
It is possible to write a macro in Python. Use Tools -> Macros -> Organize Macros -> Python to view the Python macros included with OOo. I am told that this worked fine in OOo 2.4, but when I tried this in OOo 3.0, I could not figure out how to make this work apart from directly placing the

Re: [api-dev] How to make a Python macro visible to OOo?

2009-02-07 Thread Andrew Douglas Pitonyak
Oliver Brinzing wrote: Hi Andrew, Use Tools -> Macros -> Organize Macros -> Python to view the Python macros included with OOo. i t should be possible to deploy scrips via extension.mechanism i have written a java script dispatcher for form controls, for example a method "doSomethi

Re: [api-dev] I need basic examples of StarBasic macros for Ubuntu database programming with FORMS

2009-02-20 Thread Andrew Douglas Pitonyak
Find and download AndrewBase.odt Peter Belmont wrote: I need basic examples of StarBasic macros for Ubuntu database programming with FORMS PLEASE CC any responses to me. Thanks. Examples of basic code that would be welcome: [1] counting the CONTROLs on the form (on EVENT from one of them) [

Re: [api-dev] Regresion in User Defined DocumentInfo

2009-03-16 Thread Andrew Douglas Pitonyak
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, now i have to use oDocuInfo.GetpropertieValue(" PMG_StylesVakjes") Changing this few lines is not the problem, but The code is around in Thousands of documents :-) should i start changing my code or can this be fixed ?

Re: [api-dev] Impress text shape/frame

2009-05-27 Thread Andrew Douglas Pitonyak
I don't think that you can use a text cursor in an Impress document. Serguei Vdovine wrote: Hello, I failed to change the text content of a selected text shape(shaded box around text and cursor) on a Impress 3.0 slide with Sub testGetSelect oDoc = ThisComponent() oDocCtrl = oDoc.getCurrentCon

Re: [api-dev] Unfortunate document event name - how to fix it?

2009-05-29 Thread Andrew Douglas Pitonyak
Mathias Bauer wrote: (*) I hope that I could make clear that the reason for my event name change is not "elegance", I really consider the current name confusing. But as I accept the backward compatibility burden, this point now is moot anyway. I have chatted with numerous people that incorre

[api-dev] How to find the "Default" paragraph style

2009-06-11 Thread Andrew Douglas Pitonyak
I want to know the name of the "Default" paragraph style. I would also like to find the "Default" paragraph style. I am using "en" language in the USA. Consider code such as the following: oStyles = oDoc.StyleFamilies.getByName("ParagraphStyles") sss = "Default" sss = "Standard" If oStyles

Re: [api-dev] How to find the "Default" paragraph style

2009-06-13 Thread Andrew Douglas Pitonyak
Thanks Bernard... I will change my code to use the "display" name rather than the internal name. Bernard Marcelly wrote: Hi Andrew, A style has an internal name and a localized display name. A custom style has the same internal name and display name. -- Andrew Pitonyak My Macro Document: h

[api-dev] Focus window to the view cursor

2009-07-01 Thread Andrew Douglas Pitonyak
I move the view cursor in a Write document and then the cursor is no longer visible. What is the trick to move the view so that I can see the view cursor. If I manually press a key to move the cursor, then the view changes so that I can see the cursor. I just cannot remember how to do this f

Re: [api-dev] Focus window to the view cursor

2009-07-03 Thread Andrew Douglas Pitonyak
Interesting, thanks for the reply... That had not occurred to me On 07/02/2009 02:20 AM, Christoph Jopp wrote: Hi Andrew, tried to reproduce this behaviour and found following: When I started the macro from within the macro-editor it's just as you said. When I started from within the writer doc

[api-dev] setData on a chart

2009-07-29 Thread Andrew Douglas Pitonyak
I received a request on how to set the data on a chart. Calling setData causes OOo to crash, and it used to work. This appears to be a regression problem, because the macro used to work. First, the original question as posed to me: On 07/28/2009 11:11 AM, BD RJ wrote: In OpenOffice.org Basic

[api-dev] Insert a cross reference to a heading

2009-09-01 Thread Andrew Douglas Pitonyak
How can I use a macro to insert a cross reference to a specific header? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/i

Re: [api-dev] "Get last used column/row" in a spreadsheet (Macro)

2009-09-02 Thread Andrew Douglas Pitonyak
Nice tip... I will change this in my document... I have no idea why this is written as it is, but many of the snippets were created years ago with OOo 1.x, so, the issue may be that the author of that particular macro (probably me) was not properly efficient, or, that OOo did not support the m

Re: [api-dev] Insert a cross reference to a heading

2009-09-04 Thread Andrew Douglas Pitonyak
On 09/01/2009 05:06 PM, Andrew Douglas Pitonyak wrote: How can I use a macro to insert a cross reference to a specific header? Based on the lack of response, I assume that it is not known or not possible. If anyone cares, I added a new section to my document with an investigation, on this

Re: [api-dev] Progress on exporting the Dev Guide to ODT and PDF

2009-09-04 Thread Andrew Douglas Pitonyak
On 08/21/2009 10:12 AM, Clayton wrote: I am also combining the chapters into one single document. So far, Chapters 1 to 6 are in one doc, and can also be downloaded from the page linked above. Maybe one suggestion ("very nice to have"): would it be possible to apply syntax coloring/hig

Re: [api-dev] Declare fields in a structure

2009-09-04 Thread Andrew Douglas Pitonyak
On 08/22/2009 04:31 PM, sphiller wrote: I'm starting to convert a large VBA project into OOBasic, and it mostly looks straightforward; however, i've hit a stumbling block because I have a number of structures declared with arrays in them, and the OO compiler says I can't have arrays inside of str

Re: [api-dev] Progress on exporting the Dev Guide to ODT and PDF

2009-09-06 Thread Andrew Douglas Pitonyak
On 09/05/2009 09:04 AM, Clayton wrote: Maybe one suggestion ("very nice to have"): would it be possible to apply syntax coloring/highlighting to the example code? It would make it so much easier for readers to orientate themselves in the code examples. Something like applying the [g]vim syntax hi

Re: [api-dev] "Get last used column/row" in a spreadsheet (Macro)

2009-09-07 Thread Andrew Douglas Pitonyak
CStr((lTick2 - lTick1) / nMaxIt) & _ " ticks per iteration" & CHR$(10) MsgBox s, 0, "Run Time" End Sub On 09/07/2009 06:40 AM, Steffen Grund wrote: I was just wondering: createCursor() creates a cursor containing the whole sheet, which could be slow w

Re: [api-dev] Progress on exporting the Dev Guide to ODT and PDF

2009-09-10 Thread Andrew Douglas Pitonyak
On 09/09/2009 07:36 AM, Ariel Constenla-Haile wrote: Hello Andrew, On Sunday 06 September 2009, 14:40, Andrew Douglas Pitonyak wrote: Exporting the existing syntax highlighting from the Wiki is beyond the current capabilities of the Book (Collection) extension. If anyone has any ideas on

Re: [api-dev] OOo BASIC - Somewhat tricky arrays…

2009-10-03 Thread Andrew Douglas Pitonyak
You are correct, array assignment sets the new array to reference the old array. This is also the case with many of the UNO components. You will find to your dismay, that there are a few structures that do not assign this way. I do not remember many examples off hand, but things such as table b

[api-dev] Re: [dev] Long file names

2009-10-03 Thread Andrew Douglas Pitonyak
On 09/30/2009 11:38 PM, Wei Min Teo wrote: > > > Hi all, > > It seems that openoffice has a maximum path name of 260 chars? > > However, I think the maximum path name for windows is 32,767 and file name is > 260 in unicode. > > > > Is it possible to pass in to the loadComponentFromUrl functi

Re: [api-dev] OpenOffice.org Basic - Sear ch and Replace in code…

2009-10-27 Thread Andrew Douglas Pitonyak
You should post your code... On 10/24/2009 06:05 AM, Johnny Rosenberg wrote: I am coding something in OpenOffice.org Calc using the built in Basic language thing. Now, when I produced about 50 KiB of code I found that I was not very consistent in how to type things. For example, sometimes I type

Re: [api-dev] OpenOffice.org Basic - Sear ch and Replace in code…

2009-11-11 Thread Andrew Douglas Pitonyak
On 10/28/2009 12:32 PM, Johnny Rosenberg wrote: 2009/10/28 Jan Holst Jensen: Andrew Douglas Pitonyak wrote: You should post your code... On 10/24/2009 06:05 AM, Johnny Rosenberg wrote: One example: Search for: ([a-zA-Z0-9\(\)])([\+|\-|\*|\/])([a-zA-Z0-9\(\)]) Replace with

Re: [api-dev] Sharing macros with people…

2010-01-11 Thread Andrew Douglas Pitonyak
Mr. Rosenberg, Sorry for the late reply, but I have been very busy. Have you seen the Extension Compiler by Bernard Marcelly? I used this to create my "code colorizer", that is able to colorize things such as Java, C++, C#, Java, Perl, and XML http://extensions.services.openoffice.org/projec

[api-dev] Sending email to multiple recipients

2010-04-19 Thread Andrew Douglas Pitonyak
When I looked at the service definitions, I thought that I should be able to send an email message to multiple people at one time. The setCCRecipient, for example, accepts a list of email addresses. Only the first address is used. I tested on Linux using Thunderbird. Does this seem correct?

[api-dev] DEV300m78 Breaks enableasync property

2010-05-30 Thread Andrew Douglas Pitonyak
The following line of code has worked for some time, including the current production build. I have not checked it against the latest release candidate: oConfigProvider = GetProcessServiceManager().createInstanceWithArguments(_ "com.sun.star.configuration.Configurat

Re: [api-dev] DEV300m78 Breaks enableasync property

2010-05-31 Thread Andrew Douglas Pitonyak
On 05/31/2010 03:22 AM, Stephan Bergmann wrote: On 05/30/10 19:04, Andrew Douglas Pitonyak wrote: The following line of code has worked for some time, including the current production build. I have not checked it against the latest release candidate: oConfigProvider

[api-dev] com.sun.star.util.TextSearch does not support documented options.

2010-06-15 Thread Andrew Douglas Pitonyak
http://qa.openoffice.org/issues/show_bug.cgi?id=112431 http://www.oooforum.org/forum/viewtopic.phtml?t=101554&postdays=0&postorder=asc&start=0 To use the com.sun.star.util.TextSearch service for a case-insensitive search, the search options state that ALL_IGNORE_CASE is deprecated and that Trans

[api-dev] Please verify wrong behavior with CDateFromISO

2010-06-18 Thread Andrew Douglas Pitonyak
I verified strange behavior with CDateFromISO years ago. I am testing again, and I am trying to figure out if the problem is related to 64-bits (my version) as opposed to a 32-bit version. What is the output from the following two commands? I understand the strange value in the second line,

Re: [api-dev] Please verify wrong behavior with CDateFromISO

2010-06-19 Thread Andrew Douglas Pitonyak
On 06/19/2010 02:35 AM, Andrew Douglas Pitonyak wrote: I verified strange behavior with CDateFromISO years ago. I am testing again, and I am trying to figure out if the problem is related to 64-bits (my version) as opposed to a 32-bit version. What is the output from the following two

[api-dev] Please verify bug in StarBasic Format command

2010-06-25 Thread Andrew Douglas Pitonyak
I see errors in the 64-bit Linux release with this simple macro Sub strangeFormats Dim i% Dim d As Date d = now() Dim s$ Dim formats formats = Array("q", "y", "yy", "", _ "m", "mm", "mmm", "", _ "d", "dd", "ddd", "", "d", "dd",

Re: [api-dev] Please verify bug in StarBasic Format command

2010-06-26 Thread Andrew Douglas Pitonyak
On 06/26/2010 03:37 AM, Johnny Rosenberg wrote: 2010/6/26 Andrew Douglas Pitonyak: "d// h:nn:ss" => nn produces the expected output from ddd, namely the three letter day name. Same happens for me, except that day name is two letters (in Swedish):

Re: [api-dev] Some remarks about cursors

2010-07-07 Thread Andrew Douglas Pitonyak
Although I cannot speak authoritatively, I added my opinion in the text: On 07/07/2010 09:53 AM, Patrick Bernard wrote: Hi OOo (version 3.2.1 on Ubuntu 9.10 64 bit) behaves in a strange way. Here are a few examples. 1) The String property of the view cursor doesn't seem to work when text is s

Re: [api-dev] Searching for a Document Property - Writer

2010-08-08 Thread Andrew Douglas Pitonyak
On 08/08/2010 08:52 AM, Thomas Krumbein wrote: Hey Bernard, Bernard Marcelly schrieb: Message de Thomas Krumbein date 2010-08-04 11:24 : Hey, By one of my customer we have a problem during migration to OOo 3.2.1: The page-layout is different and this is dramaticly because the page break in

  1   2   3   >