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
0
votes
1 answer
Reset button in Openoffice base
i want to add a reset button in my form. So txtstadiumName has to be empty after clicking on the button. It sounds simple but im struggling to find this.
I know i have to use openoffice basic for this and use a macro.
This is what i…
petie
- 77
- 3
- 13
0
votes
1 answer
Macro to Select/Highlight a cell in a table in OpenOffice and clones
I am writing a Basic macro in NeoOffice (a mac OO clone) and I want to highlight/select the cell in the table the cursor is in at the time the macro runs.
Google gave me the following related snipset, and it does color the cell, but I want to…
Dude named Ben
- 507
- 3
- 16
0
votes
1 answer
Form controls hidden in Libre Office basic macro designer - but shown in testmode
I have imported an original VBA form (the design) into Libre Office (Version 4.4.2.2) .
However, some form controls are hidden in the designer mode, but are clearly there in the preview/test mode.
Does anyone know, how I can edit the "hidden"…
Christoph S
- 697
- 1
- 6
- 29
0
votes
1 answer
How to get name & label of UnoCheckBoxControl?
I'd like to get the name and the label of some controls included in a dialog in LibreOffice Basic.
I can call getImplementationName() on my example controls.
I get these : stardiv.Toolkit.UnoEditControl, stardiv.Toolkit.UnoCheckBoxControl,…
Samuel
- 594
- 1
- 6
- 22
0
votes
3 answers
Getting document path in Basic in LibreOffice macro
I know that this question has already been answered but the given solution doesn't work for me. The given solution is:
Dim oDoc As Object
Dim Path$
oDoc = ThisComponent
Path$ = oDoc.getURL()
Actually this returns an empty string ("") for me. Is…
dom_beau
- 2,437
- 3
- 30
- 59
0
votes
1 answer
Create an If Blank paste macro in open office Calc
I am trying to create a macro in open office however i cant find away to perform this. I want to copy a specific cell and the past a blank sell on a given column.
Basically its something like this
Copy "B2"
If "A1" blank paste
if false
move 1 cell…
user3513345
- 1
- 2
0
votes
1 answer
how to: find matching names in different columns in an OpenOffice Calc spreadsheet?
I have a spreadsheet that has 5 columns, each column holds a full name (First Middle Last) in each cell.
How can I produce a report showing which names are shared between which columns, for example,
Report:
John Brown is in columns A,D,E
James…
The Newbie Qs
- 483
- 8
- 22
0
votes
1 answer
How to get an XML element text in a LibreOffice Basic macro?
I have a LibreOffice Basic macros to write/ read XML files. I have ported them from VBA. So far everything seems to be working except for retrieving the text from XML elements. Here is the (simplified) Sub that creates an XML object, writes it to…
Davit Sargsyan
- 1,264
- 1
- 18
- 26
0
votes
0 answers
Parse data from one CSV file to another
I'm trying to run this Macro but since my CSV file is really long and I don't want to count the column numbers, is there a way to reference the column by the letters such as "DZ"? The code works fine but I just need to reference these deep columns…
BoneBreaker
- 9
- 4
0
votes
1 answer
How can I find a text in a spreadsheet using OObasic?
On OpenOffice documentation [1], I found a replace example. But I didn't find a search example.
Dim Doc As Object
Dim Sheet As Object
Dim ReplaceDescriptor As Object
Dim I As Integer
Doc = ThisComponent
Sheet = Doc.Sheets(0)
ReplaceDescriptor =…
Josir
- 1,282
- 22
- 35
0
votes
1 answer
OpenOffice Draw macro to find replace text
I'm looking to find replace text within multiple PDF documents using Draw. Thus far I've managed to open the PDF however
mydoc.createReplaceDescription
appears not to be a valid property / method on a Draw doc. Although oddly this is used in…
Jizzle
- 214
- 1
- 9
0
votes
0 answers
Problems working with COM object in Open Office Basic
I am considering to switch from Excel to Open Office (actually to Lotus Symphony).
I have many Excel files with VBA macros that connect to CAD, CAM and other applications, and to my own COM objects.
The function GetObject doesn't exist in Open…
stenci
- 8,290
- 14
- 64
- 104
0
votes
1 answer
How to get current value show in listbox in a cell for an Open Office Macro?
I am trying to yank the value from a listbox which is in a cell. Whenever I query the value however, it returns the first entry in the listbox, regardless of the current selection showing in the cell.
How do I access the current value displayed in…
CaffeineZombie
- 184
- 9
0
votes
1 answer
OpenOffice.org/LibreOffice Calc macro: is a cell's content currently overflowing?
I have a bunch of cells whose font size I'd like to tweak if their content is overflowing, until it all fits. I'd like to write a macro to do this, unless there's a conditional formatting or other formulaic way of doing it. Is there a property…
Kev
- 15,899
- 15
- 79
- 112
-1
votes
1 answer
Matching a row where two cols have multiple, repetitive values
I'm trying to match two cells in an area that has two columns, each with multiple repetitive values, and simply return something that indicates there is a match row.
I'm doing this in LibreOffice Calc, but I'd like to be able to share it in an Excel…
RainMan Jim
- 1
- 3