CHAR excel function

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.

2 Replies

AD Administrator Syncfusion Team December 29, 2005 01:07 PM UTC

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.


BJ Brian J. Burnett December 29, 2005 02:27 PM UTC

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.

Loader.
Up arrow icon