Libre office basic 참고코드

Sub Main
mysheet = ThisComponent.CurrentController.getActiveSheet()
cellA1 = mySheet.getCellrangeByName("A1")
cellA2 = mySheet.getCellrangeByName("AV1")

If cellA1.Value = "1" Then
    cellA2.setString("It is 1  !!!!!")
Else
    cellA2.setString("It is not 1 !!!")
EndIf

End Sub

 

-------------------------------------------------------------------------------------

 

Sub Main
mysheet = ThisComponent.CurrentController.getActiveSheet()
For i = 0 To 45
    For j = 0 To 904

 

        cellA1 = mySheet.getCellByPosition(i,j)

        If cellA1.String = "#" Then
            cellA1.CellBackColor  = RGB(0,255,0)
        Else 
       
        EndIf
    Next
Next
End Sub