Search found 1558 matches
- 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 ...
- 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 ...
- 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...
- 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...
- 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...
- 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?
- 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...
- 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...
- 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 ""
If you have OpenOffice, you have Python.hal9k wrote:Thanks! I'll give it a try. Will it work on systems that don't have Python?
- 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...
- 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.
- 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
It's a little tricky, but you can drag the range down over the sheet tabs and get to the destination sheet.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?
Edit: Slow |
- 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.
- 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...
- 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.
- 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
- 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...
- 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
- 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?
- 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...
- 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...
- 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
I'm not sure what this is saying. If it works, it should create a file - in the folder specified.maxt wrote:...but also writing to file works.. I don't see any made in the folder
- 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...
- 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.
- 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.
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.
- 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.
- 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...
- 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...
- 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.
- 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...