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

How to implement SUM(ABOVE), SUM(LEFT), SUM(RIGHT), SUM(BELOW) with Syncfusion Calculate

Thread ID:

Created:

Updated:

Platform:

Replies:

80011 Mar 6,2009 03:30 PM UTC Mar 9,2009 11:10 AM UTC WinForms 1
loading
Tags: Calculate
Administrator [Syncfusion]
Asked On March 6, 2009 03:30 PM UTC

Hi,

I investigated and found out Microsoft Word supports formulas in a table such as: SUM(ABOVE), SUM(LEFT), SUM(RIGHT), SUM(BELOW). That is useful, since we don't need to care about the exact column or row in a table. The question is how we can achieve those functions with Syncfusion?

Thanks & regards,
Winter


Rajadurai C [Syncfusion]
Replied On March 9, 2009 11:10 AM UTC

Hi Winter,

Thanks for your interest in Syncfusion products.

In CalcEngine, there is support to add custom function to library. It is a two step process.
1) Add formula to the CalcEngine library

public string MyLibraryFormula(string args)
{
//code
}

This returns computed value as string.

2) Add formula to the formula library
- Call the AddFunction method of engine and add formula name to the library.

this.calcQuick.Engine.AddFunction("MYFUNCTION", new CalcEngine.LibraryFunction(ComputeMYFUNCTION));


Please refer to the following minimal sample that uses custom function with engine of CalcQuick object.
http://files.syncfusion.com/support/samples/Grid.Windows/7.1.0.30/F80011/F80011.zip

Regards,
Rajadurai


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

;