Search found 1558 matches

by Charlie Young
Mon Apr 13, 2015 12:27 pm
Forum: Macros and UNO API
Topic: [Solved] Raster charts
Replies: 5
Views: 2884

Re: Raster charts

I don't think there is any attribute corresponding to "stroke width," if I understand what you mean by that. You might try a filled polygon. Drawing a thick line should be pretty easy just by drawing lines or shapes one pixel apart. Since you're working in Python, I will add that I have a ...
by Charlie Young
Sun Apr 12, 2015 2:37 pm
Forum: Macros and UNO API
Topic: [Solved] Raster charts
Replies: 5
Views: 2884

Re: Raster charts

This sounds like an interesting project, and i think I have some code examples that can help with it, but it might be a bit sketchy, so feel free to ask for clarification. I have some XGraphics examples In Basic, Python, and c++, I'm going to start with the Basic This is part of a routine to plot a ...
by Charlie Young
Tue Apr 07, 2015 11:50 am
Forum: Macros and UNO API
Topic: [Solved] Can't Create Headers C++, cppumaker problems
Replies: 2
Views: 1712

Re: Can't Create Headers C++, cppumaker problems

I think I misunderstood what you were after. Yes there would be an XAddin.idl in the indicated location, but it is not normally called for to run idlc on it to create any headers -- idlc will be run on your own project idl files, which of course you will write yourself. To create the headers, use cp...
by Charlie Young
Mon Apr 06, 2015 11:46 pm
Forum: Macros and UNO API
Topic: Access HTML data
Replies: 4
Views: 1394

Re: ACCESS HTML DATA

You can easily access html data with any serious programming language you want. But not with StarBasic. Thanks for the quick response. Could you give me a light on what programming language to use? I need to send parameters to an HTML page and use the values returned in a database. You can (sometim...
by Charlie Young
Mon Apr 06, 2015 6:55 pm
Forum: Macros and UNO API
Topic: [Solved] Can't Create Headers C++, idlc problems
Replies: 3
Views: 1711

Re: Can't Create Headers C++, idlc problems

You might look at the issue raised by RoryOF, but i'll just outline my usual approach to using IDLC here. First off, where is your XAddin.idl? sdk\bin seems to be a peculiar place for it. With the OpenOffice sdk, I open a window to sdk\bin, where idlc.exe is, and do idlc -C -I..\idl c:\wherever\some...
by Charlie Young
Fri Apr 03, 2015 1:41 am
Forum: Macros and UNO API
Topic: [Solved - sort of] Environ("HOSTNAME") returns ""
Replies: 17
Views: 4114

Re: [Solved - sort of]Environ("HOSTNAME") returns ""

On Windows, i can get just the value part of the variable with ECHO %varname%, but I will have to appeal to those more familiar with the Mac command environment to come up with further suggestions. Maybe some kind of batch file which could run from Shell?
by Charlie Young
Fri Apr 03, 2015 1:16 am
Forum: Macros and UNO API
Topic: [Solved - sort of] Environ("HOSTNAME") returns ""
Replies: 17
Views: 4114

Re: [Solved - sort of]Environ("HOSTNAME") returns ""

I was afraid it wouldn't work as such. My poorly informed guess is that both ooBasic Environ and the Python os are based on some c/c++ library function, and the problem with the Mac lies there. I'm stuck on Windows here, and to peek at an environment variable from the command line, one uses the anci...
by Charlie Young
Fri Apr 03, 2015 12:46 am
Forum: Macros and UNO API
Topic: [Solved - sort of] Environ("HOSTNAME") returns ""
Replies: 17
Views: 4114

Re: [Solved - sort of]Environ("HOSTNAME") returns ""

Did you include the code for getMasterScriptProvider? It's in the code box of my post, below the code for Main. I looked at your post about Shell, but I can't think of any way other than by using io redirection to send the output from echo $HOSTNAME to a file. I presume that is possible on a Mac tho...
by Charlie Young
Thu Apr 02, 2015 10:06 pm
Forum: Macros and UNO API
Topic: [Solved - sort of] Environ("HOSTNAME") returns ""
Replies: 17
Views: 4114

Re: [Solved - sort of]Environ("HOSTNAME") returns ""

hal9k wrote:Thanks! I'll give it a try. Will it work on systems that don't have Python?
If you have OpenOffice, you have Python.
by Charlie Young
Thu Apr 02, 2015 8:00 pm
Forum: Macros and UNO API
Topic: [Solved - sort of] Environ("HOSTNAME") returns ""
Replies: 17
Views: 4114

Re: [Solved - sort of]Environ("HOSTNAME") returns ""

You might try a fairly simple Python thing import os def getEnviron(eString): ev = os.environ return ev[eString] if eString in ev else "String not found." g_exportedScripts = getEnviron, Save that in user\scripts\python as Environ.py (create the python folder first if you don't already hav...
by Charlie Young
Wed Mar 25, 2015 11:21 pm
Forum: Impress
Topic: Run Pyhon script when Changing Slide
Replies: 1
Views: 832

Re: Run Pyhon script when Changing Slide

Regardless of language used, this is just a matter of implementing a SlideShowListener. We were recently discussing this in Basic here. I will be happy to help translate this to Python.
by Charlie Young
Wed Mar 25, 2015 2:56 pm
Forum: Calc
Topic: [Solved] XY scatter chart - "Data Ranges" option now missing
Replies: 11
Views: 2332

Re: XY scatter chart - "Data Ranges" option now missing

dculp wrote:Unfortunately its much too late to Undo (too many other changes already made).
My data cells are in a separate sheet from the chart. How can I drag these cells onto the chart?
It's a little tricky, but you can drag the range down over the sheet tabs and get to the destination sheet.
 Edit: Slow 
by Charlie Young
Tue Mar 24, 2015 5:39 pm
Forum: External Programs
Topic: Openoffice ole object Free
Replies: 3
Views: 3638

Re: Openoffice ole object Free

I'm not sure how this stuff works in Delphi, but you might try something like OpenOffice.dispose, or however one executes a method. I also assume the variable names are case sensitive, and your example is inconsistent in that regard.
by Charlie Young
Sat Mar 21, 2015 9:28 pm
Forum: Calc
Topic: [Solved] INDEX MATCH Puzzle
Replies: 9
Views: 1122

Re: INDEX MATCH Puzzle

There is another problem, probably introduced inadvertently while preparing the spreadsheet for posting. The conditional formatting in column E asks if the cell value is equal to $#REF!.$C$3, which I guess would be caused by deleting a sheet. I did remove material not directly relevant to the issue...
by Charlie Young
Sat Mar 21, 2015 6:58 pm
Forum: Calc
Topic: [Solved] INDEX MATCH Puzzle
Replies: 9
Views: 1122

Re: INDEX MATCH Puzzle

There is another problem, probably introduced inadvertently while preparing the spreadsheet for posting. The conditional formatting in column E asks if the cell value is equal to $#REF!.$C$3, which I guess would be caused by deleting a sheet.
by Charlie Young
Sat Mar 21, 2015 6:06 pm
Forum: Calc
Topic: [Solved] INDEX MATCH Puzzle
Replies: 9
Views: 1122

Re: INDEX MATCH Puzzle

I haven't fully comprehended the issues yet, but the immediate problem seems to be that E8 is text and the E3:E7 are numbers. The #N/A goes away if i change G5 to

Code: Select all

=INDEX(E3:E53;MATCH(B2+1;E3:E7;-1))-B2
by Charlie Young
Thu Mar 19, 2015 1:57 am
Forum: Macros and UNO API
Topic: [Solved] Variable Scope
Replies: 4
Views: 847

Re: Variable Scope

I think I found the issue. While I was building an example to post as a reply, I noticed that sometimes it worked and sometimes it didn't. It appears that the value of the variables defined in the header are lost if ANY changes are made in that module. Thanks for your help! Hmm... I thought the HAL...
by Charlie Young
Thu Mar 19, 2015 1:48 am
Forum: Macros and UNO API
Topic: [Solved] Variable Scope
Replies: 4
Views: 847

Re: Variable Scope

This works for me as expected

Code: Select all

REM  *****  BASIC  *****

Global x As String

Sub Main
	x = "Hello"
	Msg
End Sub

Sub Msg
	MsgBox(x)
End Sub
by Charlie Young
Thu Mar 19, 2015 1:24 am
Forum: Macros and UNO API
Topic: [Solved] Variable Scope
Replies: 4
Views: 847

Re: Variable Scope

It should be possible by declaring a variable as Global outside a subroutine or function at the top of the module, but don't redeclare a variable with the same name within a routine where you wish to reference a Global. If this doesn't clarify the issue, could you post an example that is failing?
by Charlie Young
Tue Mar 17, 2015 10:50 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

There were a few more problems with the variables, and also, in the Open statement, it makes no sense to use Mode Output and Access Read Write, just skip the access and do Open sFileName For Output As #n You can open it for Input later if you want to read the value. See if the attached work better w...
by Charlie Young
Tue Mar 17, 2015 8:10 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

Have you looked after changing slides? I hadn't thought of it before, but if you want to write slide number 0 to the file initially, you'll need to do it in addListener, you could do it right after addSlideShowListener. Maybe you could supply a copy of your document, with personal and confidential s...
by Charlie Young
Tue Mar 17, 2015 7:23 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

maxt wrote:...but also writing to file works.. I don't see any made in the folder
I'm not sure what this is saying. If it works, it should create a file - in the folder specified.
by Charlie Young
Tue Mar 17, 2015 3:29 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

Well, wouldn't this be a rather trivial bug? I was under the impression that the message box was just to check if the listener was working, which could also be done by other means, say by writing a file, then checking for the file and its contents. Maybe I'm mistaken, but it would seem undesirable t...
by Charlie Young
Tue Mar 17, 2015 1:19 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

Run the slide show by running the Main sub.
by Charlie Young
Tue Mar 17, 2015 12:43 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

It will only appear after a slide change.

If that isn't it, I've got to wonder if this is a problem with LibreOffice vs. OpenOffice. I could post a document that works for me, and you and others could test it.
by Charlie Young
Tue Mar 17, 2015 1:15 am
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

Apparently "print" won't write anything over a running slide show, but it looks like MsgBox("hello") will.
by Charlie Young
Mon Mar 16, 2015 8:18 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

I'm not sure if this is the whole problem, but when implementing a listener it is necessary to include all its methods even if some aren't actually used Sub EV_paused(oEv) End Sub Sub EV_resumed(oEv) End Sub Sub EV_slideTransitionStarted(oEv) Dim Slide As Integer Slide = oController.getCurrentSlideI...
by Charlie Young
Mon Mar 16, 2015 7:19 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

It would seem to make perfect sense, if you just want to write the slide number to a file, just do so whenever you get the slide number, which I get in the slideTransitionStarted routine of the listener. Again, the path is tailored to my system. Sub EV_slideTransitionStarted(oEv) Dim Slide As Intege...
by Charlie Young
Mon Mar 16, 2015 3:56 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

Are you using the Wait statement? Note that Villeroy's Wait 100 only waits for a tenth of a second, so you might need a longer one.
by Charlie Young
Mon Mar 16, 2015 1:15 pm
Forum: Macros and UNO API
Topic: Macro for number of the current Impress slide
Replies: 31
Views: 9790

Re: Macro for number of the current Impress slide

Sub main oListener = createUnoListener("EV_","com.sun.star.presentation.XSlideShowListener") oPresentation.Start() oController = oPresentation.Controller wait 100 ' <--- oPresentation.Controller needs some time oController.addSlideShowListener(oListener) End Sub I get: "BAS...