Setting OWC10 Spreadsheet as DataSource for OWC10 Chart

N

Nikita Chu

Environment in use: VS.NET(2003) and OWC10.
I'd like to draw a chart with a data from the spreadsheet component in my
Windows applecation (VB.NET)
I'm getting this run-time error "Invalid Cast" at the '.DataSource=.. ' line
(see the code bellow).

With ChartSpace1
.Clear()
.Refresh()
.DataSource = axSpreadSheet1.object
End With

Since the type for DataSource property value is msdatasrc.DataSource, I've
also tried to convert as : CType(axSpreadSheet1, msdatasrc.DataSource). No
result.
Search in MSDN doesn't help.
I also saw a couple of similar posts without replies on the Web.
Please, any suggestions?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OWC10 Chart binding with OWC10 Spreadsheet not working 2
Chart Data Source from Spreadsheet in C# 4
Problem on setting SpreadSheet object as the DataSource of ChartSpace. 1
Events dont work when datasource is axspreadsheet 2
Chart load from Pivot Table, MDX query source 0
how to plot in VB.net with web component? 0
Inserting OWC10 Chart into Excel Spreadsheet 2
Help Binding Spreadsheet to PivotTable control 1

Top