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:





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


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 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)

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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