Cross Sheet References

[Ben Fraser]

Hello,

I want to be able to do things like:

=Cost!A5
=SUM(Cost!A1:A4)
=SUM(Cost!A1:Cost!A4)

Where Cost is the name of a TabBarPage held in a TabBarSplitterControl in my GridControl and the formula is in a cell on another tab.

I have noticed that I can do:

=tabBarPage1!A5

by default (the name always has to be tabBarPage1, tabBarPage2 etc) but this always returns a result of 0 whatever is in the refernced cell. I get a 'Bad Index' error whenever I put my own tabpage names in.

Does syncfusion have support for this? How do I get at it?

Thanks,
Ben

[Administrator]

You use the static GridFormulaEngine.RegisterGridAsSheet method to enable cross sheet references in Essential Grid. Take a look at this sample (there are others as well that you can see if you serach for RegisterGridAsSheet in the samples folder).

...\Syncfusion\EssentialStudio\5.1.1.0\Windows\Grid.Windows\Samples\2.0\FormulaSupport\CrossSheetReference