Stack Overflow
Stack Overflow

Questions tagged [openoffice-basic]

OpenOffice.org Basic is a programming language which is based on StarOffice Basic and bears similarity to Microsoft VBA.

Resources:

109 questions
1
vote
1 answer

Libreoffice How to convert Cell.CellAddress.Row (is a number already) to an interger?

I would like to create a String for a CellRange and for that I have a RowNumber, but struggle to append it to a String The 1st two lines of code are only for clarification, that you know which datatype Cell has CellRange =…
Tobi S
  • 145
  • 8
1
vote
1 answer

How to copy data into cells, make a table and add more data to it

UI looks like: Account:Wessex bank plc Income: 200€ Costs: Date: 28.02.2021 Output should be a list below in the cells: Date: | Account: | Income: | Costs: | 28.02.2021 | Wessex Bank plc | 200€ | 28.02.2021 | Food | - | 175€ | Hint: I would like to…
Tobi S
  • 145
  • 8
1
vote
1 answer

Autocompletion when programming for openoffice

This may be a stupid question but is there any way to get autocompletion when programming macros in StarBasic? I know there's a plugin for eclipse if you want to program in java but I haven't been able to find any editor at all that supports BASIC…
Johan Wikström
  • 4,033
  • 4
  • 28
  • 31
1
vote
1 answer

OpenOffice calc, can macros update cell content automatically?

I have used a macro I found on a forum online. It detects the background colour of a indicated cell and returns a numerical value of that background colour. The problem is that it does it only once. When I change the background colour of the…
Rasmus Valentin Haara
  • 11
  • 1
1
vote
1 answer

Is web automation with Openoffice BASIC even possible?

I'm trying to do some simple webscraping in OpenOffice (I usually work in Excel but I'm trying to port something over for a coworker that doesn't have Excel). However, when I try to run something very similar to this, it keeps giving me this BASIC…
Hayden Moss
  • 98
  • 7
1
vote
0 answers

grouping a column of categorical variable into a set of unique values

Following this question, I want to know how I can specify a column/row of a specific sheet including a categorical variable, in Open/LibreOffice BASIC script/macro and get the unique list (i.e., set) of the values. For example, consider the below…
Foad S. Farimani
  • 12,396
  • 15
  • 78
  • 193
1
vote
0 answers

two-way ANCOVA: Analysis of Covariance in LibreOffice Calc

Following this feature request, I want to know if/how I can have a macro to provide a simple GUI to do two-way ANCOVA (Analysis of Covariance) in Open/LibreOffice Calc. There is already an ANOVA tool in Calc, which does not comply with my…
Foad S. Farimani
  • 12,396
  • 15
  • 78
  • 193
1
vote
1 answer

Hide checkbox in OO BASIC

Hi How I can hide check box in Open Office BASIC? I tried use: chckbox.visible=false but it doesn`t work. thank you
tomasBULL
  • 563
  • 5
  • 10
1
vote
2 answers

Open Office Basic cell.length

I have to check cells and when it is empty show MsgBox or something. So I`m looking for IsNull function or cell.length. Has BASIC some kind of this functions?
tomasBULL
  • 563
  • 5
  • 10
1
vote
2 answers

OpenOffice BASIC IsNumber

I have to migrate document from MS Excel to Open Office with macros. Everything works fine except this function If Application.WorksheetFunction.IsNumber(Cells(12, 5)) = False Then MsgBox "Nesprávne zadané číslo účtu alebo kód banky!",…
tomasBULL
  • 563
  • 5
  • 10
1
vote
1 answer

Row number column in OpenOffice calc

I have a ods file containing two columns and 3700 rows. I need to add a column to this file where the column will automatically show the row number, In the way that I get the pdf output, the content of each row is as follows: 1 | first row first…
KavehRS
  • 11
  • 1
  • 3
1
vote
1 answer

LibreOffice CallFunction Object Not Set

Building a function to evaluate a string and return the results. However, svc and svc2 through an error, "Object Not Set". Though, when I run the code, the print statements clearly show that the objects are not null or nothing as they return…
E Net Arch
  • 458
  • 5
  • 13
1
vote
1 answer

Charts - OOo basic: how to display percentages in a PieChart

I am writing a macro to generate pie chart in OpenOffice Basic and I want to display the percentage of the different parts on the graph. For example, I want a result as in the following…
Xavier
  • 25
  • 4
1
vote
1 answer

OOo Basic: PieChart, how to change the colour of the graph

I am writing a macro to generate pie chart in OpenOffice Basic but I can't find the method to change the colour of the different part of the pie. We can take as example the macro of this subject: OpenOffice Calc macro to add pie chart That is, my…
Xavier
  • 25
  • 4
1
vote
0 answers

Office Writer / MS Word macro: select all words / characters that are underlined

I want to automatically select all Text in a document that has a certain formatting property (i.e. every character that is underlined). Is there way to achieve this? In the documentation I've found the SearchStyles property that comes most close to…
ascripter
  • 5,665
  • 12
  • 45
  • 68
1 2
3
4 5 6 7 8