Developer Forum

Hi everyone,

I have an Windows Application in VB.Net and I need the Pivot Table (OW
11) events Click and DblClick but these events are completelly ignore
by the application, I click or double click in anywhere in the Pivo
Table and nothing happens. What I have to do to fix this problem?

Thanks

if you are using vbscript it works automatically, if you are using
javascript you need special syntax - i forget that off the top of my head

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

None of these options, my application is a Windows Application, not
Web Application. I am using VB.Net

in that case, the event is tied to the object in the property pages. for vb,
you need the with event keyword which is automatically applied.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

It is declared with WITH EVENTS keywords, I can see the event on th
Events combobox but It is ignored by the application. Th
SelectionChange event works but not the Click or DblClick events

what happens when you display a message box in the double click event
handler?
MessageBox.Show("Fired") for instance

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

In DblClick event nothing happens and in DoubleClick event an error, a
error "The DoubleClick event is not valid in this ActiveX Control".


my code:

Code
-------------------

Private Sub owcPivotTable_DblClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles owcPivotTable.DblClick
MessageBox.Show("Dbl Click")
End Sub

Private Sub owcPivotTable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles owcPivotTable.ClickEvent
MessageBox.Show("Click")
End Sub

Private Sub owcPivotTable_DoubleClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles owcPivotTable.DoubleClick
MessageBox.Show("Double Click")
End Sub

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


What should I have to do?

Thanks again and congratulations for your book,

Igor R. Alcantar

Any idea? If you have a sample in VB.Net It will help a lot.

Thanks

Is there a workaround to fix this issue and catch an Click event on a
PivotTable?

Igor R. Alcantara

Initially I was using OWC 9 and I could fire the mousedown event like this:

Private Sub AxChartSpace1_MouseDown(ByVal sender As Object, ByVal downEvent
As AxOWC.IWebChartEvents_MouseDownEvent) Handles AxChartSpace1.MouseDownEvent

But after I switch to OWC10, I had problems firing the same event using the
following:

Private Sub AxChartSpace1_MouseDown(ByVal sender As Object, ByVal e As
AxOWC10.IChartEvents_MouseDownEvent) Handles AxChartSpace1.MouseDownEvent

I'm able to plot and display all the graphs I want without any problems
using the OWC10 chart, and the results are the same as per the older version
using OWC9. The only difference is that i can't fire my mousedown event
anymore, it seems to be ignored...

Can anyone provide a sample code on how to fire a mouse event in OWC10 chart?

Thanks a lot folks!!

Regards,
Lance

Events are broken in the OWC10 version. It's a long story. There is a fix
for it posted on the MSDN website. Have a google for it. I dont. off the top
of my head, remember the url.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------





this:
downEvent
AxChartSpace1.MouseDownEvent
the
version
chart?

I've found the fix at the following website, thanks alot!!
http://www.yqcomputer.com/

Cheers,
Lance