cross sheet formula reference

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

1 Reply

AD Administrator Syncfusion Team January 5, 2005 07:33 AM UTC

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.

Loader.
Up arrow icon