oDrawPages = ThisComponent.getDrawPages()
oObj1 = oDrawPages.getByIndex(0)
oObj2 = oObj1.getByIndex(0)
oControl = oObj2.getControl()
oSheet = ThisComponent.Sheets.getByIndex(0)
oCellrange = oSheet.getCellRangeByName("I2:M2")
DatArr = oCellrange.DataArray
oControl.StringItemList = DatArr(0)
[color=#FF0000]oItemRng[/color] = oSheet_Prod.getCellRangeByName("B2:B1000")
arg1 = Array([color=#FF0000]oProdRng[/color])
oItemIdRng = oSheet_Prod.getCellRangeByName("A2:A1000")
arg2 = Array(oProdIdRng)
vtmp1 = svc.callFunction("MATCH",vproduct_name,arg1,0)
vproduct_id = svc.callFunction("INDEX",arg2,vtmp1)
oMyCombo= oDialog1.getControl("ComboBox1")
oCellRange = oSheet_tst.getCellRangeByName("A2:C8")
s = createUnoService("com.sun.star.sheet.FunctionAccess")
data = s.callFunction("TRANSPOSE", array(oCellRange))
oDialog1.getControl("ComboBox1").addItems(data(0), 0)
oMyCombo.DropDownLineCount = ubound(data(0)) +1
data = s.callFunction("TRANSPOSE", array(oCellRange))
dataArray = s.callFunction("TRANSPOSE", array(oCellRange.DataArray))
tmanikanda wrote:But i need to get the items only which is not yet active, can i do this?
oCellRange.getCellByPosition(1, indirection(itempos)).String = "Y"
getselecteditem is working where i am selecting only one item from the listbox, but getselecteditems is not working where i am selecting multiple items. Any idea on this
I am getting error 'Property or Method not found: Selectedvalues' in your sheet Listbox.ods when selecting any values in listbox_2
Apache OpenOffice 4.1.3 , Windows 10
Users browsing this forum: No registered users and 7 guests