cross sheet formula reference

[Tito Toro]

Is it possible to reference cells from another grid on a seperate form?

For instance

Form 1 contains a grid called grid1
Form 2 contains a grid called grid2
in the same mdi application
In other words can I reference cell a1 in grid1 from cell a1 in grid2
=grid1!a1

Thanks

[Administrator]

Yes. You use the RegisterGridAsSheet method to set this up. Take a look at the Syncfusion\Essential Suite\3.0.1.0\Windows\Grid.Windows\Samples\Quick Start\NamedRangesForFormulas sample.

The \Syncfusion\Essential Suite\3.0.1.0\Windows\Grid.Windows\Samples\In Depth\RetirementSimulation sample also uses this method to set up cross sheet references.