Formula Cell

[Tom Russell]

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

[Administrator]

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

[Tom Russell]

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

[Administrator]

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