The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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.
ADAdministrator 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
TRTom RussellJuly 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
ADAdministrator 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.