Desktop Grid Queries - Hide Column- Add Menu- Drag a cell

Aspose.Cells Product Family
1

Hi

I am using Desktop grid 2.0. Could you please answer following queries.

1. How to hide/show columns from front end? I mean is there a way with which user could select a menu and mark a column hidden?
2. Can we add/remove menus from context menu.
3. Can I drag a cell downward to get its values in the following cells as we do in Excel?

Please reply as soon as possible.

2

Hi,

Thanks for your inquiries.

1. How to hide/show columns from front end? I mean is there a way with which user could select a menu and mark a column hidden?

Well, you may try the following codes to hide/unhide a column.

[C#]

//to hide the first column.

GridDesktop1.Worksheets(0).Columns[0].Hidden = true;

//to unhide the first column.

GridDesktop1.Worksheets(0).Columns[0].Hidden = false;

[VB]

'to hide the first column.

Me.GridDesktop.Worksheets(0).Columns.Item(0).Hidden = True

'to unhide the first column.

Me.GridDesktop.Worksheets(0).Columns.Item(0).Hidden = False


2. Can we add/remove menus from context menu.

Sorry! the feature is not available, we will support it in future versions.


3. Can I drag a cell downward to get its values in the following cells as we do in Excel?

Sorry! the feature is not available, we will support in our upcoming versions.

Thank you.