1. Home
  2. Forum
  3. WinForms
  4. Multi grid formulas

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.

1 Reply
RA Rajagopal Syncfusion Team September 6, 2007 11:06 PM UTC

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

Loader.
Up arrow icon