Multi grid formulas

[.]

Hi,

I need to define a formula that spans multiple grids. For example, something like

G2:C1=G2:B1+G1:A1

where G2:C1 is cell C1 in grid 2 and G1:A1 is cell A1 in grid 1.

If this is possible, can you please provide a sample or direct me to one.

Thanks and regards,

Scoulers.

[Rajagopal]

Hi Scoulers,

Thanks for your interest in Syncfusion Products.

Yes. You need to use the RegisterGridAsSheet() static method of the GridFormulaEngine to set this up when you have multiple grids. Please refer to the following sample in the shipped browser samples for more details.

\\Syncfusion\EssentialStudio\5.1.x.x\Windows\Grid.Windows\Samples\2.0\FormulaSupport\NamedRangesForFormulas
\\Syncfusion\EssentialStudio\5.1.x.x\Windows\Grid.Windows\Samples\2.0\FormulaSupport\RetirementSimulation

Let me know if you have any other questions.

Regards,
Rajagopal