OpenOffice.org Basic is a programming language which is based on StarOffice Basic and bears similarity to Microsoft VBA.
Resources:
Questions tagged [openoffice-basic]
109 questions
1
vote
1 answer
Changing programmatically print area in OpenOffice Calc
I'm creating a Calc document on the fly with vb6. I need to repeat 1 row and 1 column in every page when i print it.
This is the code:
Dim mPrintOptions(2) As Object
Dim OO_Dispatcher As Object
Set OO_Dispatcher =…
Gonzalo
- 185
- 1
- 12
1
vote
2 answers
Libre Office custom Dialog Table
I am creating a custom Dialog where the user is supposed to select one of multiple possible entries. I use a List Box to list the possible entries to be selected from.
There are multiple variables for each row, therefore I would like to use a table…
thomas
- 43
- 1
- 6
1
vote
1 answer
How do I calculate the md5 checksum of a string in starbasic macro (openoffice macro)?
I am trying to make an OpenOfficeWriter StarBasic-Macro Program, that turns wiki source code to Open office Writer. I need a starbasic macro, that generates the MD5 checksum. There is a MD5Thumbprint in the Documentation for OpenOffice, so I…
george
- 13
- 3
1
vote
1 answer
oooBasic : how to assign a key to a macro, programmatically?
I would like to assign, programmatically, a macro to a function key (instead of changing manually this assignation).
How could I do this ?
Jerry
- 1,141
- 1
- 13
- 18
1
vote
1 answer
openoffice-writer check viewcursor in table
I have a table with the Property: Name = 'Images'.
I want to write a check if my ViewCursor is present in this table or not.
You can get the location of the ViewCursor with this code:
vViewCursor =…
476rick
- 2,764
- 4
- 29
- 49
1
vote
0 answers
Open office convert hmtl to pdf with border
i have the following html
and convert it to pdf with the open office lib
…
test1
test2
wutzebaer
- 14,365
- 19
- 99
- 170
1
vote
1 answer
How to port Excel VBA to OpenOffice basic?
How to port Excel VBA macro to OpenOffice basic macro?
Here is macro for refresh in every 5 seconds.
Private Sub Workbook_Open()
' Written in ThisWorkbook
Call RefreshTime
End Sub
Sub RefreshTime()
' Written in a module
Application.ScreenUpdating =…
keylargo
- 11
- 4
1
vote
1 answer
Is it possible to detect when a cell becomes the active cell?
In Calc, I'd like to trigger an event when a specific cell becomes the active cell. I see no way to do that.
Here's the situation:
After entering a payment in a specific cell (say A5) and hitting enter, I'd like to programatically put the current…
Bill Gradwohl
- 385
- 4
- 18
1
vote
1 answer
Scroll bar in LibreOffice dialog
I am trying to make an image picker component in LibreOffice.
I have a dialog that is dynamically filled with images. When the user clicks on one images, it should be selected and the dialog should be closed.
The problem is that the number of images…
Beemen
- 88
- 7
1
vote
1 answer
how to move images in openoffice.org BASIC or LibreOfffice.org
After moving pictures in VBA using Shape.IncrementLeft and Shape.IncrementTop I would like to move pictures in openoffice.org BASIC code.
After searching internet with these keywords "move picture" and "openoffice.org" or "open BASIC" or "OOo…
user3374877
- 11
- 4
1
vote
1 answer
How do I remove all comments from the active writer document
I am trying to write a macro on my OpenOffice Writer to remove all comments from the active word document, so far the code I have actually researched and cobbled together can be found below.
Sub RemoveAllComments()
Dim i as Integer
For i =…
user965480
- 11
- 2
1
vote
1 answer
How to run an sql query on an OpenOffice/LibreOffice spreadsheet from command line?
Well,
The title pretty much says it all. I have a set of ODS spreadsheets and I want to run some SQL queries over these spreadsheets and save the result on CSV files.
I know I can do that from the GUI, but I need to be able to do it from a batch…
Jeff
- 953
- 2
- 11
- 21
1
vote
1 answer
Remove newline while writing to text
This simple macro will write the text "ABC" to the file temp.txt under E: drive. However if we open the text file, notice that there is a new line char after C. How can we get rid of this, so that it will end after C
Code:
Sub ExamplePrint
i =…
Suresh
- 1,081
- 4
- 21
- 44
0
votes
1 answer
why can I access text properties through cursor object in OpenOffice?
I'm developing a simple script in OpenOffice Basic for Writer. I have a code like this:
vText = ThisComponent.Text
vc = ThisComponent.CurrentController.getViewCursor()
c = vText.createTextCursorByRange(vc.getstart())
baseM =…
agsamek
- 8,734
- 11
- 36
- 43
0
votes
1 answer
How to insert data to Open Office Base using Visual Basic?
I have a problem in inserting data from a sheet into database. Some people say that this can be done using (UNO) RowSet, but i find minimal example for this. Could anyone give my a sampe of this?
Open for other ways, as long it use UNO
indrap
- 760
- 2
- 10
- 18