Formula Cell

I have a grid named fg3 and I have set a column to formulas and perform my formula with no issue, however when trying to obtain the end result of my formuals calculation, all I get when accessing the text or cellvalue of the cell is the actual formual I placed in that cell. How do I get the result?

Here''s what I have

Dim style As GridStyleInfo = fg3.ColStyles(5)
style.CellType = "FormulaCell"
fg3(5, 5).Text = "=SLOPE(AL" & startrow & ":AL" & stoprow & ",A" & startrow & ":A" & stoprow & ")"
fg3.CurrentCell.MoveTo(5, 2)
Dim cellText As String = fg3(5, 5).Text


So "CellText" isnt the re4esult but just what I put in that cell for a formula.

Thanks,

Tom

3 Replies

AD Administrator Syncfusion Team July 27, 2006 01:10 PM UTC

Hi Tom,

You can use the FormattedText property to obtain the result in a formula cell. Here is a code snippet

Dim Result As String = fg3(5, 5).FormattedText

Let me know if this helps.
Best Regards,
Haneef


TR Tom Russell July 27, 2006 02:44 PM UTC


That worked. Thanks.

Another issue now is the formula I am using is different than what you would get in Excel using the same data and same ranges. This kinda throws my whole app off.

Any known issues there?

Thanks,

Tom
>Hi Tom,

You can use the FormattedText property to obtain the result in a formula cell. Here is a code snippet

Dim Result As String = fg3(5, 5).FormattedText

Let me know if this helps.
Best Regards,
Haneef


AD Administrator Syncfusion Team July 28, 2006 12:13 PM UTC

Hi Tom,

Thanks for your update. I am afraid that i was not able to reproduce this issue here. If you could send us a sample and some more details on your issue, it will be helpful for us to debug and get it fixed at the earliest.

Thanks for your patience.
Best Regards,
Haneef

Loader.
Up arrow icon