Events dont work when datasource is axspreadsheet

M

mariacp

Hello!!

I'm trying to draw a custom chart.

First of all, I entered the data "manually":

aCats = New Object() {"A", "B", "C"}
aVals = New Object() {100, 120, 30}

oSer.SetData(OWC11.ChartDimensionsEnum.chDimSeriesNames, -1
"MySeries")
oSer.SetData(OWC11.ChartDimensionsEnum.chDimCategories, 0
aCats)
oSer.SetData(OWC11.ChartDimensionsEnum.chDimValues, 0, aVals)

All the events (afterrender, beforerender, afterfinalrender...) worke
ok.

If I change the data source to an spreadsheet owc:

Me.AxChartSpace1.DataSource = CType(Me.AxSpreadsheet1.GetOcx()
msdatasrc.DataSource)

oSer.SetData(OWC11.ChartDimensionsEnum.chDimSeriesNames, -1
"MySeries")
oSer.SetData(OWC11.ChartDimensionsEnum.chDimCategories, 0
"A1:A26")
oSer.SetData(OWC11.ChartDimensionsEnum.chDimValues, 0
"B1:B26")

Those events don't get called anymore.
Anyone can tell me why?

Thanks a lot.
MARI
 
T

TimS

Hello Maria, I am not certain that this will help you but it can't hurt.
From my understanding the OWC11 spreadsheet control does not respond to
events unless you rewrite the wrapper to allow this functionality. Here is
the URL for a knowledge base article that I used to do exactly that. I too
needed the OWC11 spreadsheet control to be able to respond to end-user events
such as mouse clicks, etc.
http://support.microsoft.com/kb/823982

I hope this helps!

Tim
 
M

mariacp

I already did that, so I could get events in the first case (gettin
categories and values from an array). What I dont understand is wh
events dont get called when the datasource is the axspreadsheet.

Thanks a lot for your replay Tim.
Maria
 
Top