[api-dev] Re: Custom types drives me nuts – this can't be happening… can it?

2011-08-17 Thread Andrew Douglas Pitonyak
Oh my goodness! It is always something small that wastes hours of time. On 08/15/2011 08:48 AM, Johnny Rosenberg wrote: Okej, forget this, I solved it. Immediately after I sent this I found the problem! All I needed to do to find it out was probably to write about it somewhere… I found the

[api-dev] Re: Global variables – OpenOffice.org Basic

2011-08-14 Thread Andrew Douglas Pitonyak
On 08/14/2011 01:45 AM, Johnny Rosenberg wrote: 011/8/14 Andrew Douglas Pitonyakand...@pitonyak.org: Let me start by saying that this works just fine using OOo for all cases without resorting to Global. Do you have Option Compatible set anywhere? No, isn't that for compatibility with Visual

[api-dev] Re: How can I read my code in a module in the Basic IDE with Basic code?

2011-08-14 Thread Andrew Douglas Pitonyak
I believe that AndrewBase.odt has an example that writes code to a module and then calls it. I also believe that it demonstrates how to walk controls and similar. On 08/14/2011 02:11 AM, Johnny Rosenberg wrote: My workaround at the moment, is to first save my code to a file and then loading

[api-dev] Re: Global variables – OpenOffice.org Basic

2011-08-13 Thread Andrew Douglas Pitonyak
Let me start by saying that this works just fine using OOo for all cases without resorting to Global. Do you have Option Compatible set anywhere? On 08/08/2011 11:42 AM, Johnny Rosenberg wrote: I am testing some functions at the moment (I wrote them a few years ago and now I'm trying to

[api-dev] Re: Getting information from some site via Basic IDE – possible? How?

2011-07-18 Thread Andrew Douglas Pitonyak
Wow Johnny, you sure do get around :-) On 07/16/2011 11:34 AM, Johnny Rosenberg wrote: Is it possible with the OpenOffice.org BASIC IDE to access a web site, login, copy some text to the clipboard, and then logout? Any hints? I have seen examples using Calc using tricks similar to these:

[api-dev] Re: Proper way to find an existing number format style.

2011-05-31 Thread Andrew Douglas Pitonyak
On 05/31/2011 05:37 AM, Niklas Nebel wrote: On 31.05.2011 07:34, Andrew Douglas Pitonyak wrote: Tested on 3.3.0 en-US using the 64-bit Linux version on Fedora 15. I use the following macro to find an existing number format, and I create it if it does not exist. The problem

[api-dev] Proper way to find an existing number format style.

2011-05-30 Thread Andrew Douglas Pitonyak
(Peter, please test these, but my primary question is directed at the dev mailing list.) Tested on 3.3.0 en-US using the 64-bit Linux version on Fedora 15. I use the following macro to find an existing number format, and I create it if it does not exist. The problem is that

[api-dev] Is LineEndName locale dependent?

2011-05-23 Thread Andrew Douglas Pitonyak
I use English USA locale. Consider the following Calc macro that sets line starts and line ends based on the name (which I assume is the correct way to do this). Will this work in other languages such as German, French, Russian, Polish, Chinese? Sub InsertLineInCalcDocument Dim oLine

[api-dev] Re: Get list of printers

2011-04-08 Thread Andrew Douglas Pitonyak
Excellent! I documented, so it will be in my latest OOME document when I push it out Not nearly sufficient, however. On 04/08/2011 08:53 AM, Bernard Marcelly wrote: I have created Issue http://openoffice.org/bugzilla/show_bug.cgi?id=117769 to request the IDL documentation. Bernard

[api-dev] Re: Get list of printers

2011-04-07 Thread Andrew Douglas Pitonyak
On 04/07/2011 12:08 PM, Niklas Nebel wrote: On 07.04.2011 15:48, Andrew Douglas Pitonyak wrote: I had hoped it would be as easy as CreateUnoService(com.sun.star.awt.PrinterServer) Unfortunately, the returned object is not usable. Usable is a relative term. You can always do something like

[api-dev] Re: Load document into a named frame

2011-03-12 Thread Andrew Douglas Pitonyak
Thanks. so that has not worked since 1.1. On 03/12/2011 05:23 AM, Oliver Brinzing wrote: Hi Andrew, i just tried your code with oo 1.1.5 and failed - vDoc is null after the second loadComponentFromURL ... so it seems not to work in oo 1.1.5 too ... Regards Oliver -- Andrew Pitonyak

[api-dev] Load document into a named frame

2011-03-11 Thread Andrew Douglas Pitonyak
Should I be able to load a document into a named frame? I last wrote about this with OOo version 1.1 Clearly the behavior has changed, and this no longer seems to work. Consider the following macro that used to work (but no longer does). Sub UseAnExistingFrame Dim noArgs() 'An empty array

Re: [api-dev] problem of determining the location in the document

2011-01-28 Thread Andrew Douglas Pitonyak
On 01/28/2011 12:09 PM, Zbigniew Szot wrote: Hi again If i apply my use case (TextSection nested in textTable) to Your snippet. The TextTable property will not be set (will be null) and the textsection property will be set to nested text section. So its dead loop exacly as in my example.

Re: [api-dev] problem of determining the location in the document

2011-01-26 Thread Andrew Douglas Pitonyak
On 01/26/2011 01:53 PM, Zbigniew Szot wrote: Thank you for taking interest in my problem. TextViewCursor/Position is Controller based solution. I would like to stick to model based one. But you brought me an idea, which now seems obvious. I can query XText about supported services. This

Re: [api-dev] OpenOffice 3.2.1 not printing on Windows Servers through the API

2010-12-18 Thread Andrew Douglas Pitonyak
I really do not understand this. Let me restate the part the confuses me: (1) I can print using a macro with no problem. (2) I cannot print using the API When you use a macro, you use the API; or did I miss something? On 12/18/2010 12:05 PM, Herter, Scott wrote: We have encountered a

[api-dev] list of supported Dispatch commands

2010-12-08 Thread Andrew Douglas Pitonyak
I last documented the dispatch commands (meaning I enumerated them) based off of these very outdated links: http://framework.openoffice.org/servlets/ProjectDocumentList http://api.openoffice.org/servlets/ProjectDownloadList

Re: [api-dev] Examining a directory with OpenOffice.org Basic

2010-12-02 Thread Andrew Douglas Pitonyak
On 12/02/2010 11:10 AM, Johnny Rosenberg wrote: Den 2010-12-02 03:26:53 skrev Andrew Douglas Pitonyak and...@pitonyak.org: There should be an example in this: http://www.pitonyak.org/OOME_3_0.odt http://www.pitonyak.org/AndrewMacro.pdf I searched this one (maybe too quickly) but I

Re: [api-dev] Examining a directory with OpenOffice.org Basic

2010-12-01 Thread Andrew Douglas Pitonyak
There should be an example in this: http://www.pitonyak.org/OOME_3_0.odt http://www.pitonyak.org/AndrewMacro.pdf On 12/01/2010 08:31 AM, Johnny Rosenberg wrote: If I know the name of a directory, let's say ~/MyImages, how can I easily read the names of all the files in that directory? Let's

Re: [api-dev] Attempt for an UNO Undo API

2010-10-26 Thread Andrew Douglas Pitonyak
Although I am ignorant in much of this, I do have some random thoughts. Mathias Bauer mentioned allowing the container to control changes for some items (such as he did with notes2), but that this may be a problem with larger objects such as graphics objects and even OLE objects. On the

Re: [api-dev] Search with attributes erases text

2010-09-21 Thread Andrew Douglas Pitonyak
OK, I guess it is a bug http://qa.openoffice.org/issues/show_bug.cgi?id=114662 On 09/15/2010 11:49 AM, Andrew Douglas Pitonyak wrote: Consider this small program, looks innocent... Find something that matches an attribute (no replacing). Sub SearchTest(oProps()) Dim oFind Dim

[api-dev] Search with attributes erases text

2010-09-15 Thread Andrew Douglas Pitonyak
Consider this small program, looks innocent... Find something that matches an attribute (no replacing). Sub SearchTest(oProps()) Dim oFind Dim oFound Dim oDoc oDoc = ThisComponent oFind = oDoc.createSearchDescriptor() With oFind .SearchString = .*

[api-dev] OOo users at Linux Fest in Columbus Ohio

2010-08-24 Thread Andrew Douglas Pitonyak
OK, so who is attending Linux Fest in Columbus Ohio this year? http://ohiolinux.org/ September 10 - 12 I, Andrew Pitonyak will be there. Drew Jensen (the Base GURU) will be there Jason Corfy (OOo Forum Moderator) will be there Seems like an opportunity for us OOo folks to get together

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

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 Pitonyakand...@pitonyak.org: 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

[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, _ w, ww,

[api-dev] Please verify wrong behavior with CDateFromISO

2010-06-19 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

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] 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=101554postdays=0postorder=ascstart=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

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

[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?

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

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 Jensenj...@biochemfusion.com: 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

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

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

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

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

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

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

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

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

[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:

[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

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

[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

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. snip -- Andrew Pitonyak My Macro

[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

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

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 =

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

[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

[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

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

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

[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:

Re: [api-dev] Calc with two tables

2008-12-14 Thread Andrew Douglas Pitonyak
. Thank you again. Rudi - Original Message - From: Andrew Douglas Pitonyak and...@pitonyak.org To: dev@api.openoffice.org Sent: Saturday, December 13, 2008 2:48 AM Subject: Re: [api-dev] Calc with two tables Rudolf Huber wrote: Halle Andrew, again thank you for your answer. I got

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

2008-10-28 Thread Andrew Douglas Pitonyak
of). 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 in a Calc document

[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 oSheet

Re: [api-dev] Staroffice basic library question

2008-08-02 Thread Andrew Douglas Pitonyak
Frank Schönheit - Sun Microsystems Germany wrote: Hi Craig, I have several spreadsheet documents that need to access a common set of staroffice basic macro routines that cannot be in a user application specific location (i.e. they cannot be in a user specific 'My Macros' library) I

Re: [api-dev] FilePicker File Name Questions

2008-07-17 Thread Andrew Douglas Pitonyak
I was toying with adding an extension on to the exported macro save file but hadn't looked into using filters yet, so this is a help! You should take a look at AndrewBase.odt. I have a very similar example there, where you pass in a boolean to tell it to use save or open. Also, it

Re: [api-dev] Keypresses and Macros and Dialogs

2008-07-17 Thread Andrew Douglas Pitonyak
Cor Nouws wrote: Hi Hal, Hal Vaughan wrote (17-7-2008 21:15) I've got a couple more questions and both are regarding keypresses. 1) Is there any way that a macro can wait on a keypress without using a prompt or anything like that? For example, the macro may active when F4 is pressed,

Re: [api-dev] Selecting, Reading, and Entering Text

2008-07-16 Thread Andrew Douglas Pitonyak
I do not have time to test this, so... Hal Vaughan wrote: I recorded a macro to select text, copy it to the keyboard, then to enter a new character. In the long run, I'm going to want a macro that selects the character before the cursor, then reads in that character so I can use it to

Re: [api-dev] Pause the script for user's input in .odt

2008-07-11 Thread Andrew Douglas Pitonyak
What type of data file do you want to open? What kind of data do you want to read? How do you know where to put the data? sergio wrote: I have a script in StarBasic that find some data, then open a file and should wait for the user's input (move the cursor to the desired destination of the

Re: [api-dev] Pause the script for user's input in .odt

2008-07-11 Thread Andrew Douglas Pitonyak
sergio wrote: sergio ha scritto: Thanks for your answer. Your welcome, but it looks like you solved this on your own. Bravo! -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info:

Re: [api-dev] Macro Questions

2008-07-05 Thread Andrew Douglas Pitonyak
Hal Vaughan wrote: On Wednesday 02 July 2008, Andrew Douglas Pitonyak wrote: I wondered if it was the same Hal :-) Yes. Originally my plans were to do an application completely in OOBasic, but that never worked out because I needed some functions that weren't available

Re: [api-dev] Macro Questions

2008-07-05 Thread Andrew Douglas Pitonyak
Hal Vaughan wrote: On Saturday 05 July 2008, Andrew Douglas Pitonyak wrote: Hal Vaughan wrote: ... You enter some specific text. Press a key like Ctrl+F3 Based on the text that is present, new text and/or formatting is applied I need to search around OOo a bit to figure it out

Re: [api-dev] Macro Questions

2008-07-01 Thread Andrew Douglas Pitonyak
I wondered if it was the same Hal :-) Hal Vaughan wrote: I've been otherwise occupied so I haven't had time to read the answers closely on this (I had time, sent my second post and literally within hours had to jump and start putting out some fires with some of my software), but I'm not

[api-dev] What is the BASIC command Me?

2008-06-24 Thread Andrew Douglas Pitonyak
How can I call the Me command in Basic? The command is defined as follows: // #115824 RTLFUNC(Me) { (void)pBasic; (void)bWrite; SbModule* pActiveModule = pINST-GetActiveModule(); SbClassModuleObject* pClassModuleObject = PTR_CAST(SbClassModuleObject,pActiveModule);

[api-dev] Find defined routines, functions, and constants

2008-06-24 Thread Andrew Douglas Pitonyak
I would like to document the current methods, functions, constants, and similar in OOo for version 3.0, but I am not certain where everything is defined. For example: - I looked in basic/source/runtime It looks like RTL is defined in stdobj.cxx and implemented in methods.cxx, but I can not

Re: [api-dev] Accepting and rejecting redlines

2008-06-18 Thread Andrew Douglas Pitonyak
No answers here, to this question asked a few times over the years, and also on the forums: How to use a macro to accept or reject individual changes (redlines). I opted to document as much as I could. I demonstrate here how to enumerate redlines, and a cheat method to delete them, but not

Re: [api-dev] Bugs in 3.0 Beta holding up documentation

2008-06-15 Thread Andrew Douglas Pitonyak
Thanks, I will download the latest. I was using m18 I was having trouble finding the link. Ariel Constenla-Haile wrote: Hi Andrew, Andrew Douglas Pitonyak escribió: I am attempting to update documentation for 3.0, and I was dealing with macros in Calc documents. I noticed that I can

[api-dev] Bugs in 3.0 Beta holding up documentation

2008-06-14 Thread Andrew Douglas Pitonyak
I am attempting to update documentation for 3.0, and I was dealing with macros in Calc documents. I noticed that I can not call a macro as a Calc function. I think that the problem is related to an existing bug report... http://www.openoffice.org/issues/show_bug.cgi?id=89527 Will there be

[api-dev] Accepting and rejecting redlines

2008-06-13 Thread Andrew Douglas Pitonyak
Aroslav Resovsky, I am posting this to the dev mailing list since I have never seen an answer to this question, but I have seen it asked a couple of times on the dev mailing list. What is the accepted method for accepting or rejecting a change? I know that I can accept all of the changes

Re: [api-dev] Set Ranges in an XY Chart

2008-06-06 Thread Andrew Douglas Pitonyak
Thanks, I will try this Daniel Rentz wrote: Andrew Douglas Pitonyak schrieb: How can I create an XY chart from a macro where each Y data value has its own X data value. I know how to do this by hand because I can individually specify these using the GUI. I can not, do this using a macro

Re: [api-dev] Changes to the navigation box on the Dev Guide (and other books)

2008-05-29 Thread Andrew Douglas Pitonyak
ccornell - OpenOffice.org wrote: A community member (Nashev) has made some changes to the MasterTOC template used to create the book navigation box on the right side of the Developer's Guide (and other books that use this same template). Changes made are: - Next Page and Previous Page links

Re: [api-dev] Wait Cursor

2008-05-27 Thread Andrew Douglas Pitonyak
last I checked, this is what I found (in OOo version 1.3) Mathias Bauer, whom we all love, responded. You can not set the mouse pointer of a document window via UNO-API. VCL manages the mouse pointer based on the window, not the top window. Any VCL window can have its own mouse pointer set.

Re: [api-dev] Java in Windows and OOo uses different Paper Tray names

2008-05-20 Thread Andrew Douglas Pitonyak
Tobias Krais wrote: Hi Andrew, I thought that the tray names were set in the PPD file (for post script printers anyway). For example, read page 101 of this document http://partners.adobe.com/public/developer/en/ps/5003.PPD_Spec_v4.3.pdf This means OOo seems to read it from the ppd.

Re: [api-dev] Java in Windows and OOo uses different Paper Tray names

2008-05-19 Thread Andrew Douglas Pitonyak
Tobias Krais wrote: Hi together, at the moment I encounter a serious problem on Windows OS. I wrote a little OOo dialogue allowing the user to print a document on a certain tray of a printer. Now my Problem: for OOo does not offer an API to get printer tray names, I use the API of Java. It

Re: [api-dev] merge table columns example

2008-05-14 Thread Andrew Douglas Pitonyak
I believe that a text table has different support than a Calc document I only show how to merge and split text table cells in my book (and not in my free macro document). Have you looked at the developer's guide? Nicole Scholz wrote: Hi! I found some examples of merging columns in scalc and

Re: [api-dev] Performance issues regarding VB6 and OpenOffice.org

2008-04-01 Thread Andrew Douglas Pitonyak
I noticed that with a large mail merge, the time was growing very very very long... Boris Ratak wrote: Hi, I'm working on a VB6 application that creates documents using OpenOffice.org (2.2.1 and 2.3.1, Windows XP and 98). I'm noticing performances issues with OpenOffice that didn't occur

Re: [api-dev] Macros: argument is not optional

2008-02-12 Thread Andrew Douglas Pitonyak
Download AndrewMacro.odt and take a look at chapter 9 Formatting macros -- 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:

Re: [api-dev] Code-Highlighting in Basic IDE

2007-11-06 Thread Andrew Douglas Pitonyak
I have a new copy of the formatter now. I made some changes: 1. I format Java, C++, and StarBasic. 2. If the character styles do not exist, I create them. 3. Pass in character style names in an array of strings rather than hard coding them. 4. Added a document dedicated to the code

Re: [api-dev] Code-Highlighting in Basic IDE

2007-11-05 Thread Andrew Douglas Pitonyak
Laurent Godard wrote: Hi @ariel: If you can provide this code to me, I can save a lot of time. After going through the code yesterday this was also my idea: creating the styles if the are not existing - or import them from a masterdocument. But if you have code to create them - fine, that

Re: [api-dev] Code-Highlighting in Basic IDE

2007-10-30 Thread Andrew Douglas Pitonyak
Thomas Krumbein wrote: Hi Ariel, hi Malte, thank you for the information. Ariel Constenla-Haile schrieb: [..] See Andrew Pitonyak's Macro Document at http://www.pitonyak.org/AndrewMacro.odt chap. 9 Formatting macros containg macros to format Basic code just like the IDE does. OK,

Re: [api-dev] list of propertyName's

2007-10-27 Thread Andrew Douglas Pitonyak
Atte André Jensen wrote: Hi My cursor is over some text. I'd like to read the propertyes of the selection as with (in php): $propertyValue = $cursor-getPropertyValue('CharWeight'); Where can I see a list of possible propertyName's similar to CharWeight? You can inspect the object with

Re: [api-dev] Styling cells in a spreadsheet in Basic

2007-10-24 Thread Andrew Douglas Pitonyak
I think that you set borders either using a Style (just a guess, never have done it, but it would imply that the style itself specifies the border), or by manipulating a cell (or probably a cell range, I am guess rather than grabbing a copy of my book). I know that I do cover this in my book,

Re: [api-dev] Getting printers via Basic or Java

2007-09-12 Thread Andrew Douglas Pitonyak
Download my free macro document and search for Listing the supported printers This is for Basic. Tobias Krais wrote: Hi togehter, I have to write a little uno package managing printer options. Up to OO 2.0, it was not possible to get the available printers via OO Basic. Can you tell me

Re: [api-dev] Print Listeners in OOo 2.0.2 (Urgent!)

2007-09-12 Thread Andrew Douglas Pitonyak
Have you seen the solution in my macro document? This might only work if the GUI is present (ie, not in headless mode). Tobias Krais wrote: Hi Hal, Code would be a big help so I could compare what we've got. I'll be glad to send you what I have. Right now I'm working with a wrapper

Re: [api-dev] AWT TREE: OOoBasic version of the ScriptSelector example

2007-09-07 Thread Andrew Douglas Pitonyak
Ariel Constenla-Haile wrote: PS 2: though my English is very me-Tarzan-you-Jane, No, your English is much better than that. isn't it wrong Childs as plural of Child, instead of Children? Children is the correct plural for Child. The Java API uses Children for the plural ( z.B.

Re: [api-dev] Open Office VBA porting? or leave as it is?

2007-07-31 Thread Andrew Douglas Pitonyak
for your answers! I'm now looking into porting the existing vba-code to StarBasic and trying to get java working for future developments. thanks a lot simon On 30.07.2007, at 22:39, Andrew Douglas Pitonyak wrote: Simon B. Margulies wrote: Hi all, I'm still evaluating open office

Re: [api-dev] how to do custom formula functions embedded in the document?

2007-07-31 Thread Andrew Douglas Pitonyak
Ionel Maries Cristian wrote: I belive some form of macro would be suitable for this job. The function has to fetch some xml from a remote url, the xml has to be parsed and the parameters for the url are sent as post data (as xml) I've failed to find apis for doing url fetching in basic. Python

Re: [api-dev] Open Office VBA porting? or leave as it is?

2007-07-30 Thread Andrew Douglas Pitonyak
Simon B. Margulies wrote: Hi all, I'm still evaluating open office as the new solution for my parents tax software, which has been built in excel with some vba scripts. ... What do you think? Are there any developers using VBA in Open Office? Is VBA supported in openoffice for windows AND os

Re: [api-dev] Vá: Insert a Draw docum ent into a gallery

2007-07-25 Thread Andrew Douglas Pitonyak
: Andrew Douglas Pitonyak [EMAIL PROTECTED] 07/18/07 1:59 du. Worst case: I will see if I can read the SVG and then export it as a different graphic type and then add that to the gallery. If we can run a different command line to convert all SVG files to something else, however

Re: [api-dev] Insert a Draw document into a gallery

2007-07-20 Thread Andrew Douglas Pitonyak
It is possible to add a Draw document to a gallery? I tried oTheme.insertDrawingByIndex(oDoc, 0), which looks like it should work based on the API, but it does not work. http://www.pitonyak.org/OOoGalleryImport.odt I traced things to this code in svx/source/unogallery/unogaltheme.cxx

Re: [api-dev] Vá: Insert a Draw docum ent into a gallery

2007-07-18 Thread Andrew Douglas Pitonyak
import odg files. The UI of gallery does not support to add odg and sxd files (interesting? - the gallery supports many formats but not the default OpenOffice.org formats)... Are there any way to import odg files via API? Best regards, KAMI Andrew Douglas Pitonyak [EMAIL PROTECTED] 07/18/07 5:57

[api-dev] Insert a Draw document into a gallery

2007-07-17 Thread Andrew Douglas Pitonyak
OOo has very little clipart. I was asked to write a macro that will create OOo clipart galleries from existing folders of clipart. I figured out how to insert links from a URL oTheme.insertURLByIndex(sURL, 0) I figured out how to insert the object as a graphic Dim oProvider

Re: [api-dev] Should a key event listener be called for the Ctrl key?

2007-07-10 Thread Andrew Douglas Pitonyak
. Over-all, however, XRay is certainly a better object inspector. You should be able to install and use it with no problem. I consider it highly recommended. Zitat von Andrew Douglas Pitonyak [EMAIL PROTECTED]: My opinion is that this is a bug! I can ask on the dev mail list! Christoph Lupp

Re: [api-dev] Re: [gsl-dev] Re: [api-dev] Should a key event listener be called for the Ctrl key?

2007-07-10 Thread Andrew Douglas Pitonyak
Thanks for that excellent reply! (Philipp, I copied you on BCC to make certain you would receive my thanks even if you do not monitor the list). Philipp Lohmann wrote: Hi, Modifiers alone do not per se generate a key event in vcl for years but a specialized KeyModChange (modifier changed)

  1   2   >