CHAR excel function

[Brian J. Burnett]

Could you implement the excel CHAR function as the method you provide for extending the funtions available does not work as CHAR is also a VB function and therefore a reserved word.

[Administrator]

Hi Brian,
I have entered this as a FeatureRequest. You can track this online here:
http://www.syncfusion.com/support/features/calculate/Default.aspx?ToDo=view&questId=647
Best Regards,
Jeba.

[Brian J. Burnett]

I''ve found a workaround.

Apparently by enclosing the name of the function in square brackets it overrides any reserved words.

So Char can be implemented in VB as...

Public Function [CHAR](ByVal args As String) As String
Dim nChar As Integer
Try
nChar = Integer.Parse(args)
Return Chr(nChar)
Catch ex As Exception
Return "Not a valid Ascii Decimal Equivalent number"
End Try
End Function

>Hi Brian,
>I have entered this as a FeatureRequest. You can track this online here:
>http://www.syncfusion.com/support/features/calculate/Default.aspx?ToDo=view&questId=647
>Best Regards,
>Jeba.