I'm trying to evaluate if the Formula support in the Syncfusion grids would work for us...
I have a couple of I think fairly simple questions :)
1) If I make a cell a FormulaCell type, can I get both the value and the formula (as a string) from the cell somehow?
2) If I saved that formula, could I/how would I use it again in other Syncfusion products like reporting?
The idea is we have a product that does a lot of financial calculations. At the moment, the design is a bit cumbersome because it takes lots of values, writes them to the db, does calculations, writes those to the db, and so on. I'm trying to move to a position where we no longer store all the results of calculations, but rather the formulas, so we can recalculate at will. However this would also mean we would need to be able to recalculate the formulas on other outputs, like reports/dashboards etc.
PMPiruthiviraj Malaimelraj Syncfusion Team March 1, 2017 01:59 PM UTC
Thanks for your interest in Syncfusion products.
If I make a cell a FormulaCell type, can I get both the value and the formula (as a string) from the cell somehow?
The formula text and the result value can be get by using GridStyleInfo.CellValue and GridStyleInfo.FormattedText respectively. In the attached sample, the formula and the values are stored in a list. Please refer to the attached sample,