Formula cell within virtual grid stuck in infinite loop

[Andy Mei]

Hi,

I have a virtual grid setup and one of the cell is set as formula style (just sum of another column). I have noticed that once formula cell is set, GridQueryCellInfo is constantly called. Any idea what's the cause of this?

I have submitted a sample project that demostrated this problem.

TIA!

Andy



virtualgridformulacell_3f67ae4d.zip

[Ranjeet Kumar]

Hi Andy,

Thanks for your interest in Syncfusion Products.

Syncfusion Virtual Grid works differently as compared to normal GridControl.
Your concern about its working when any cell type is set to "FormulaCell" is not an issue rather it is the inherent behavior of the VirtualGrid.
QueryCellInfo event is raised for each and every cell in the grid.

To work with virtual grid we mainly focus on these handlers :

QueryCellInfo : This helps to get data into the virtual grid from the data source as well as also helps conditionally formating the record. This handler helps to set individual cell properties.
QueryColCount : This returns columns count on demand.
QueryRowCount : This returns rows count on demand.

In addition to above information , you may go through the following links to have better understanding of the VirtualGrid Working :
Essential Studio Samples :

1. Grid Samples -> Virtual Grid -> Virtual Grid Tutorial
2. Grid Samples -> Virtual Grid -> Virtual Grid Demo
3. Grid Samples -> Virtual Grid -> Grid Population Demo


Regards,
Ranjeet.

[Andy Mei]

Hi Ranjeet,

Thanks for your reply. I have virtual grid running in my application. However, when I try to configure a cell as 'FormulaCell', QueryCellInfo is constantly fire and my application is trapped in an infinite loop. If I remove 'FormulaCell', QueryCellInfo is only fired once for every cell on the my grid.

If you run my the sample project i have attached, run it with both 'FormulaCell' enable and disable should demonstrate the problem.

Andy

[Lingaraj S]

Hi,

Thank you for the update.

You have posted similar kind of issue in incident 63406. Please follow up with the incident(#63406). So I go ahead and mark this incident as closed.

Regards,
Lingaraj S.