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

REGD---Formula

Thread ID:

Created:

Updated:

Platform:

Replies:

25830 Mar 8,2005 02:55 PM UTC Mar 8,2005 05:12 PM UTC WinForms 1
loading
Tags: GridControl
manohar
Asked On March 8, 2005 02:55 PM UTC

Hi Clay, In the formula cell , we have to implement function like sum(1:2) which is equivalent to sum(CurrentCol1:CurrentCol2).I have changed the code in ComputeSum function in the formula engine, but have some problems getting the CurrentCol index. Currently I am using following piece of code this.grid.currentcell.colindex(this gives an incorrect value if focus is moved to a different column).Please suggest an alternative method to get the correct column index. Thanks in advance, Regards, Manohar B.

Administrator [Syncfusion]
Replied On March 8, 2005 05:12 PM UTC

A formula may need to be evaluated more times than when it happens to be in the CurrentCell. For example, when the grid is displayed for any reason, all the cells are drawn (and formulas might be computed at this point), but the CurrentCell is not moved to every cell being drawn. If you want to write column type formulas, then there is a supported notation of using Row 0 to represent the current row in the 3.0 code base. So, writing a formula like = A0 + B0 will sum up the A column value and B column value from what ever row this formula appears in. When the formula engine sees the reference to row zero, it resolves it to the row holding the formula. Take a look at the \Syncfusion\Essential Suite\3.0.1.0\Windows\Grid.Windows\Samples\Quick Start\GridControlSort for a sample use case.

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

;