Michael Hinz How can i change column and cell attributes(change color and make it invisible) /* get the desktop (an Xdesktop object) */ oDesktop = UNO.createDesktop() xComponentLoader = oDesktop~{%see com.sun.star.frame.XDesktop%XDesktop}~{%see com.sun.star.frame.XComponentLoader%XComponentLoader} --get componentLoader interface /* open a blank calc file */ url = "private:factory/scalc" xCalcComponent = xComponentLoader~loadComponentFromURL(url, "_blank", 0, .UNO~noProps) /* get first sheet in spreadsheet */ xDocument = xCalcComponent~{%see com.sun.star.sheet.XSpreadsheetDocument%XSpreadSheetDocument} xSheet = xDocument~getSheets~{%see com.sun.star.container.XIndexAccess%XIndexAccess}~getByIndex(0)~{%see com.sun.star.sheet.XSpreadsheet%XSpreadSheet} /* insert value into cells */ CALL UNO.setCell xSheet, 0, 4, "This row will be deleted!" /* get rows and columns */ xColumnRowRange = xSheet~{%see com.sun.star.table.XColumnRowRange%xColumnRowRange}~getColumns() xColumn = xColumnRowRange~getByIndex(3) xColumnRowRange = xSheet~{%see com.sun.star.table.XColumnRowRange%xColumnRowRange}~getRows() xRow = xColumnRowRange~getByIndex(4) CALL syssleep 3 /* set properties of columns and rows */ xColumn~{%see com.sun.star.beans.XPropertySet%xPropertySet}~setPropertyValue("CellBackColor", box("int", "006666"x ~c2d)) CALL syssleep 4 xRow~{%see com.sun.star.beans.XPropertySet%xPropertySet}~setPropertyValue("IsVisible", Boolean (false)) ::requires UNO.cls -- get UNO support