Running a macro when value of cell changes

[DUNDUMON]

Whats the equivalent API for

Private Sub Worksheet_Change(ByVal Target As Range) in Open Office.

[RoryOF]

Try
[Solved] [Calc] Listeners for cell modification events

[einstein]

It would be to see a specific case.
Here a possible example (without using "listeners").
For range A2:A30

Code: Select all

Sub Worksheet_Change
   rAdd = ThisComponent.getCurrentSelection.rangeAddress
   If rAdd.startColumn = 0 Then
   If rAdd.startRow < 30 And rAdd.endRow > 0 Then
      MsgBox "Your Macro"
   End If
   End If
End Sub

Set it to the event of the sheet (Right click on the spreadsheet tab <> Sheet Events <> Content Changed ...)

[karolus]

Here is an example you should prefer for use on Sheet-Event →→ Content changed

Code: Select all

Sub Content_change( changed_cell )
    sheet = changed_cell.Spreadsheet
    observed_range = sheet.getCellRangeByName("A2:A30")
    if observed_range.queryIntersection( changed_cell.RangeAddress ).Count >0 then '# inside range of Interest#'
         msgbox( changed_cell.AbsoluteName)
    end if
end Sub