We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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

Administrator 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.
Live Chat Icon For mobile
Up arrow icon