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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:





80011 Mar 6,2009 10:30 AM Mar 9,2009 07:10 AM Windows Forms 1
Tags: Calculate
Administrator [Syncfusion]
Asked On March 6, 2009 10:30 AM


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,

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

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)

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.



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.

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.