ReoGrid Forum

Fast and powerful .NET Spreadsheet Component

You are not logged in.

Announcement

This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.

https://github.com/unvell/ReoGrid/issues

#1 2016-01-29 18:53:42

deaspo
Member
Registered: 2016-01-29
Posts: 11

AddHandler for the events

Hi Jing,

Currently am using version 0.9.0.0 but I am facing this problem that the events like cellDatachanged, AfterCellEdit e.t.c don't seem to be triggered when I manipulate the grid. Am using AddHandler to add this events but nothing seems to be triggered. But I have noticed when using version 0.8.5, these events get triggered. What am I doing wrong, because am defining the AddHandler on form load? In addition am using vb.net

Thanks

Offline

#2 2016-01-29 18:58:16

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: AddHandler for the events

Can you please provide some example code?

If your workbook is loaded from any Excel file, make sure you add events after that loading. Since when a workbook loaded from Excel, all the worksheets will be reset, including its event handlers.

Offline

#3 2016-01-29 19:23:47

deaspo
Member
Registered: 2016-01-29
Posts: 11

Re: AddHandler for the events

First I defined grdData from ReogridControl, then on form load I assigned an instance of the current worksheet to the grdCurrSheet.

 Public WithEvents grdCurrSheet As unvell.ReoGrid.Worksheet 
 Private Sub frmEditor_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        grdCurrSheet = grdData.CurrentWorksheet
        frmMain.clsGrids.SetData(grdData)
        grdData.Visible = False
        autoTranslate(Me)
    End Sub 
     Private Sub grdCurrSheet_AfterCellEdit(sender As Object, e As CellAfterEditEventArgs) Handles grdCurrSheet.AfterCellEdit
        MessageBox.Show(e.NewData)
    End Sub 

What am I doing wrong?

Offline

#4 2016-01-29 19:49:49

deaspo
Member
Registered: 2016-01-29
Posts: 11

Re: AddHandler for the events

Hi Jing,

I think I have discovered what is causing the problem. I have been loading an excel file and that''s why. How do I add events after loading data from excel?

Offline

#5 2016-01-30 00:37:23

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: AddHandler for the events

Where the code to load Excel file?

To make sure event handlers work, the flow should like this:

  1. use workbook.Load to load from Excel file

  2. dim currentWorksheet = workbook.CurrentWorksheet

  3. add event handlers for currentWorksheet

Last edited by Jingwood (2016-01-30 00:39:14)

Offline

#6 2016-02-01 07:19:28

deaspo
Member
Registered: 2016-01-29
Posts: 11

Re: AddHandler for the events

Thanks, I got it to work.

Offline

Board footer

Powered by FluxBB