Code example for HyperlinkCellClick

[Carlos]

Good Morning:

Could you show me an example to use the HyperlinkCellClick event on VB.net for the PivotGrid control?

Thanks in advance. Carlos

[Arulraj A]

Hi Carlos, 

Thanks for using Syncfusion product. 

You can achieve your requirement by setting the cell type as HyperlinkCell. HyperlinkCellClick event raised when the hyperlink cell gets clicked in the pivot grid control. This event receives an argument HyperlinkCellClickEventArgs, that contains the information about the hyperlink cell which is clicked. 

Form1.vb 

        Public Sub New() 

            InitializeComponent() 

            InitializePivotGrid() 

            AddHandler Me.pivotGridControl1.TableModel.QueryCellInfo, AddressOf TableModel_QueryCellInfo 

            AddHandler Me.pivotGridControl1.TableControl.HyperlinkCellClick, AddressOf TableControl_HyperlinkCellClick 

        End Sub 

        Private Sub TableModel_QueryCellInfo(ByVal sender As Object, ByVal e As Syncfusion.Windows.Forms.Grid.GridQueryCellInfoEventArgs) 

            If e.RowIndex > Me.pivotGridControl1.PivotColumns.Count + (If(Me.pivotGridControl1.PivotCalculations.Count > 1, 1, 0)) AndAlso e.ColIndex > Me.pivotGridControl1.PivotRows.Count AndAlso e.Style.CellValue IsNot Nothing Then 

                e.Style.CellType = If(Me.checkBox1.Checked, "HyperlinkCell", "TextBox") 

                e.Style.Tag = Nothing 

            End If 

        End Sub 

        Private Sub TableControl_HyperlinkCellClick(ByVal sender As Object, ByVal e As Syncfusion.Windows.Forms.PivotAnalysis.HyperlinkCellClickEventArgs) 

            If Me.checkBox1.Checked Then 

                Dim cellInfo As PivotCellInfo = Me.pivotGridControl1.PivotEngine(e.PivotCellInfo.RowIndex - 1, e.PivotCellInfo.ColumnIndex - 1) 

                Dim styeInfo As GridStyleInfo = Me.pivotGridControl1.TableModel(e.PivotCellInfo.RowIndex, e.PivotCellInfo.ColumnIndex) 

                Dim row As String = "Row index " & e.PivotCellInfo.RowIndex 

                Dim column As String = "Column index " & e.PivotCellInfo.ColumnIndex 

                Dim cellValue As String = "Cell value " & cellInfo.FormattedText 

                MessageBox.Show(row & vbCrLf & column & vbCrLf & cellValue) 

            End If 

        End Sub 

Sample link : http://www.syncfusion.com/downloads/support/forum/143334/ze/HyperlinkDemo-1477331104  

Please refer our UG documentation from the following link: 

https://help.syncfusion.com/windowsforms/pivotgrid/hyperlink-cells  

Please let us know if you need any further assistance. 

Regards, 

Arulraj A 

[Carlos]

Thanks Arulraj for the code example but unfortunately it does not work. When you click on a cell with a hyperlink, open the Internet Explorer and TableControl_HyperlinkCellClick event is not raised.

Regards,

Carlos

[Arulraj A]

Hi Carlos,    

 

Sorry for the inconvenience caused. 

 

We have merged the reported issue “Browser windows opens while clicking the hyperlink cells” in your reported version 16.1.0.37 

  

Please find the patch file from the following location:    

    

V16.1.0.37  

Recommended approach – exe will perform automatic configuration         

Please find the patch setup here:                               

http://syncfusion.com/Installs/support/patch/16.1.0.37/771045/F143334/SyncfusionPatch_16.1.0.37_771045_3182019074150378_F143334.exe 

     

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment                          

Please find the patch assemblies alone from:          

http://syncfusion.com/Installs/support/patch/16.1.0.37/771045/F143334/SyncfusionPatch_16.1.0.37_771045_3182019074150378_F143334.zip 

     

Please find the Nugets from the below location:         

http://syncfusion.com/Installs/support/patch/16.1.0.37/771045/F143334/SyncfusionNuget_16.1.0.37_771045_3182019074150378_F143334.zip 

      

         

NOTE: 
You can change how you receive bug fixes by navigating to the following link and updating your preferences.
https://www.syncfusion.com/support/directtrac/patches      

       

Disclaimer:                        

Please note that we have created this patch for the version 16.1.0.37 specifically to resolve the issues reported in this forum #143334. If you have received other patches for the same version for other products, please apply all patches in the order received. 

Regards, 

Arulraj A