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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

FormulaTag.Text sometimes returning a blank value

Thread ID:

Created:

Platform:

Replies:

26544 Mar 24,2005 07:13 PM UTC WinForms 0
loading
Tags: GridControl
John Creviston
Asked On March 24, 2005 07:13 PM UTC

I have found that when programitically getting the calculated value out of some formula cells, grid(row, col).FormulaTag.Text returns a blank value. But if I get FormattedText first then get FormulaTag.Text it returns the calculated value. We recently upgraded an application we have been using in production for 10 months from 2.1.0.9 to 3.0.1.0 and this did not happen before upgrading. Other Info: After first filling the grid with formulas and data, we call functions to activate all formulas immediately using: Dim engine As GridFormulaEngine engine = CType(grdMain.CellModels("FormulaCell"), GridFormulaCellModel).Engine engine.UsesVirtualDataSource = True engine.RecalculateRange(GridRangeInfo.Table, True) Maybe this will be helpful to anyone else running into this problem. John

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

;