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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Multi grid formulas

Thread ID:

Created:

Updated:

Platform:

Replies:

67970 Sep 5,2007 04:24 PM UTC Sep 6,2007 11:06 PM UTC WinForms 1
loading
Tags: GridControl
.
Asked On September 5, 2007 04:24 PM UTC

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.

Rajagopal [Syncfusion]
Replied On 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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;