Excel Like Behaviour in GridDataBoundGrid

[Anand]

Hi,
I have enabled the ControllerOptions.ExcelLikeBehaviour property for the databoungrid but still I am not getting the expected behaviour. I am desiging the grid at runtime as the no of columns are dynamic. Before adding the column I disable the QueryCellInfo event and after adding the columns I enable that event.Could you please help me. Many Thanks.

[Rajagopal]

Hi Anand,

Thanks for your interest in Syncfusion Products.

We dont have any property like ControllerOptions.ExcelLikeBehaviour, but there is an option in the GridControllerOptions enum called ExcelLikeSelection, to enable the excel selection behavior. If you are looking for excel like behvior, set the below property settings in grid.

gridDataBoundGrid1.ExcelLikeSelectionFrame = true;
gridDataBoundGrid1.ExcelLikeCurrentCell = true;

For more information, refer the shipped sample "ExcelSelectionMarker" in the browser samples
version 5.1
\\Syncfusion\EssentialStudio\5.1\Windows\Grid.Windows\Samples\2.0\ExcelLikeFeatures\ExcelSelectionMarker
version 4.x
C:\Program Files\Syncfusion\Essential Studio\4.x\Windows\Grid.Windows\Samples\ExcelLikeFeatures\ExcelSelectionMarker

I am not sure about your requirements, can you please provide more information on your requirements?

Have a nice time.
Regards,
Rajagopal