Which Event of the desktop grid gets fired when we use importdatatable function

Aspose.Cells Product Family
1

Hi

I am using importdatatable function in desktop grid, could you please tell me which Event of the grid gets fired at that time as I want to lock some rows/cells depending on the data of my datatable.

Also, can we directly lock the rows or we will have to lock it cell by cell?

Please reply as soon as possible.

2

Hi,

Well, GridDesktop's CellDataChanged event gets fired when you import datatable to the grid.

Also, can we directly lock the rows or we will have to lock it cell by cell?

Well, you have to lock cell by cell, I think you may try to utilize loop(s) to handle it easily.

Thank you.

3

Hi

Also, Can NOT we lock a column directly?? I tried following and it did not work:

Dim style As Aspose.Grid.Desktop.Style
style = grdDataEntry.Worksheets(0).Columns(0).GetStyle()
style.CellLocked = True
grdDataEntry.Worksheets(0).Columns(0).SetStyle(style)

If desktop grid does not have this feature, kindly implement it as soon as possible.

4

Hi,

Well, the feature (lock a complete row/column) is not available yet, hopefully we can support it in the next week for your requirement.

Thank you.