sub Teste
mysheet = thiscomponent.currentcontroller.getactivesheet()

cella1 = mysheet.getcellrangebyname(“a1”)

cellA1.setstring(“Hello world”)
msgbox(“Process completed”)

end sub

i would like to know the function for detecting if the cell have data if so go to next line. thanks in advance.

#HelpMeSensei

Thnk you Mr. Giri,
I thought libreoffice macro language is VB only
Thnks for clarification that This is not VB but Its slimier to VB 🙂

Yes.

So these two language is fine to write macro in libreoffice right?

You can use these languages to write macros in LibreOffice: Basic (similar to VB), Python

Hey ca you pls tell us that which language are use for Libreoffice macro , Is it VB script or any other language
pls specify

Is this your entire macro? And at which line you are getting error?

and the code:

sub idVzacasno
dim document as object
dim scv as object
dim macro as object
document = ThisComponent.CurrentController.Frame
svc = createUnoService(“com.sun.star.sheet.FunctionAccess”)
makro(“INSERT INTO zacasna(id) SELECT id_Reverz FROM Reverz;”)

end sub

If someone has any idea what i am doing wrong please help.

Amazing, i can save a lot of time and a lot of space with this 🙂
I am also rewriting the whole macro because using the arrays i can use a smarter way to obtain things done 😉
Thank you very much

You can use img_arr(6) to refer any individual items inside an array.

This is great!

then i could just write this

Dim img_arr(49)

for i=1 to 49

img_arr(i) = Foglio3.getCellbyPosition(12,i+1).String

next

and the job is done, to call a position on an array should i use

img_arr(6) or img_arr6 ?

You should use array. Instead of declaring 49 variables, declare an array of size 49. Then you can refer them via subscript. Like this:

Dim my_arr(49)

for i=1 to 49

my_arr(i) = “anything you want ” & i

next

after this execution, your array should contain value like this::

my_arr(1) = anything you want 1

my_arr(2) = anything you want 2

my_arr(3) = anything you want 3

…

my_arr(49) = anything you want 49

Array concept: https://msdn.microsoft.com/en-us/library/wak0wfyt.aspx

Well basically i need to state a lot of variables to be able to call them later where needed

FineURL1 = Foglio3.getCellbyPosition(12,2).String
FineURL2 = Foglio3.getCellbyPosition(12,3).String
FineURL3 = Foglio3.getCellbyPosition(12,4).String
…….
FineURL47 = Foglio3.getCellbyPosition(12,48).String
FineURL48 = Foglio3.getCellbyPosition(12,49).String
FineURL49 = Foglio3.getCellbyPosition(12,50).String

my macro is very long just because i have a lot of variable to state, i know there could a shorter way but i still need to think about it xD

Yes it is possible but that depends what you want to achieve. Say you are creating multiple images at runtime with dynamic file name as you said – image1, image2 etc. Then you can do something like this:

Dim i, c

for i=1 to 10

next

Can i state something to change the number in the variable name as the result of another variable?

There may be some books, but I didn’t find any. If you want to learn, follow the tutorials in this site/search Google/forums etc.

Thank you, friend.

João Alberto Garcia – There are many ways to do that. Say, you want to copy cell contents B1 to A1. You can try this:

Value should be used for numbers, String should be used for string. So you need to put a check on what type of value the cell contains. Have a look here: http://www.debugpoint.com/2014/09/libreoffice-workbook-worksheet-and-cell-processing-using-macro/