Brilliant!
I bet that in my actual code, i am writing too simple and long 😀
But it’s my first project ever, even if long, at least it should work

Thank you, really

Something like this:

Dim i

For i=0 to 9
cmbBox1.addItem(Sheet4.getCellbyPosition(0,i).String,i+1)
Next

What do you mean loop? i just wrote this and it works:

cmbBox1.addItem(Sheet4.getCellbyPosition(0,0).String,1)
cmbBox1.addItem(Sheet4.getCellbyPosition(0,1).String,2)
cmbBox1.addItem(Sheet4.getCellbyPosition(0,2).String,3)
cmbBox1.addItem(Sheet4.getCellbyPosition(0,3).String,4)
cmbBox1.addItem(Sheet4.getCellbyPosition(0,4).String,5)
cmbBox1.addItem(Sheet4.getCellbyPosition(0,5).String,6)

………until 10

is there another faster way? XD

You can either use Range or individual cells – but for both, you have to run a loop for each item. Getting the data from Range would be bit complicated because Range processing in LibreOffice is complex. I would recommend to run a loop for each item and put it in combobox.

In case you are wondering, you can get the range values using below. Range returns a 2D array with format my_data(row,col)

my_range = ThisComponent.Sheets(0).getCellRangebyName(“A1:A10”)
my_data = my_range.getDataArray()

Thanks for the quick reply, now it works perfectly 🙂
What i’m trying to do is for example, list each cell in A1:A10 from sheet3 as an option in the combo box.
Should i use a range or specify every cell?

You are very very close.

If your cell at position 0.0 contains character, use this:
cmbBox1.addItem(oCell.String,1)

If your cell at position 0.0 contains numeric, use this:
cmbBox1.addItem(oCell.Value,1)

You need to specify LO the contents, not the entire cell.

For more details on Cell contents type, read here:
http://www.debugpoint.com/2015/02/deleting-all-types-of-contents-from-calc-range-using-macro/

PS. thanks for the guides, very useful 🙂

You are welcome!

Thank you ! you helped me a lot, i just cant seem to be able to find a properly written example, and belive me i tried searching a lot, i think i actually found this function but example was written porly and i probably messed up and tought it wasnt right.
Thanks aggain

To select any item inside a ListBox by using “index” – use “selectItemPos” method. See below.

lstBox1.selectItemPos( 0, True )

0 = the first entry would be selected, you can count as per your need starting from 0 as first.
True = it would be selected

Ok i have found one solution :
ListBox1.selectItem(“value not index”,True) i have no idea what does the bollean value do but would still like to know how to select by index.