We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

CHAR excel function

Thread ID:





39128 Dec 28,2005 06:47 AM Dec 29,2005 09:27 AM Windows Forms 2
Tags: Calculate
Brian J. Burnett
Asked On December 28, 2005 06:47 AM

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 [Syncfusion]
Replied On December 29, 2005 08:07 AM

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
Replied On December 29, 2005 09:27 AM

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.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.