Custom formulas not updating

[Denis]

Hi, I have the requirement to have some formula cells directly reference other formula cells which contain some string value (which is the product of a custom function that I use). For example I need the value that is stored in cell A3 "XYZ" to be displayed in B4 and C5. I would like to be able to put the Excel functionality equivalent in B4 and C5 which would be =A3. This obviously doesn’t work in the current grid, so I have added a custom function which retrieves the referenced cell''s FormattedText. B4 and C5 do not update when A3 is changed however (unlike all of the native formulas which automatically update themselves). Is there a way to give my custom formula this same behaviour? Will you be adding string support to the formula engine? eg. ="The cost is: " & B4 & " thousand dollars" Please see the example for more info... example_5114.zip

[Administrator]

If you call the GetValueFromArgs method, it will allow the grid to properly track the dependent cells.

Public Function Evaluate_Str(ByVal args As String) As String
        Dim c As Integer
        Dim r As Integer
        Try
            ReturnGridRefFromString(args, c, r)
            Dim cellModel As GridFormulaCellModel
            cellModel = Me.grd.CellModels("FormulaCell")
            cellModel.Engine.GetValueFromArg(args)
            Return grd(r, c).FormattedText
        Catch ex As System.Exception
            Return "!! ERROR !!"
        End Try
    End Function