For spreadsheet cell ranges which register for XChartDataChangeEventListener events, when the event is triggered, the event object provided does not have any values for properties: Type, StartColumn, EndColumn, StartRow and EndRow.

To reproduce: Open a new empty spreadsheet.  Create a new macro and paste in the following code.  Run the RegisterChartDataChangeEvent() macro, then change the contents of any cell on Sheet1 in the range B1 to B9.

What happens:  The event is triggered but all the event properties are zero.  This code registers an event for both the spreadsheet and a cell range so the MsgBox appears twice.

Expected behaviour:  Event properties should contain the column and row indexes of the cell which changed.  Also, the Type property should probably contain one of the ChartDataChangeType values.

This has been tested and reproduced on OO 3.2.1 under Linux and OO 3.3 under Windows.

Documentation link:
http://api.openoffice.org/docs/common/ref/com/sun/star/chart/ChartDataChangeEvent.html

--------------------------
option explicit

private sub RegisterChartDataChangeEvent
	dim oSheet    as object
	dim oListener as object
	dim oRange    as object
	dim s         as string

	s         = "com.sun.star.chart.XChartDataChangeEventListener"
	oSheet    = ThisComponent.Sheets.getByIndex(0)
	oRange    = oSheet.getCellRangeByName( "B1:B9")
	oListener = CreateUnoListener("Listener_", s)
	oSheet.addChartDataChangeEventListener(oListener)
	oRange.addChartDataChangeEventListener(oListener)
end sub

private sub Listener_chartDataChanged(oEvent as object)
	dim s as string
	'GlobalScope.BasicLibraries.LoadLibrary("XrayTool")
	'Xray oEvent
	s = "Source:" & oEvent.Source.AbsoluteName
	s = s & "  Event:" & oEvent.Type
	s = s & "  " & oEvent.StartColumn & "," & oEvent.EndColumn
	s = s & "  " & oEvent.StartRow    & "," & oEvent.EndRow
	MsgBox(s)
end sub
--------------------------