How to Use a Comma as a Decimal Separator in Formula?

18 Apr 20231 minute to read

Local settings may require the use of a different decimal separator than the period character that Essential Calculate uses by default. For example, many Local settings use a comma as the decimal separator.

To manage this problem, Essential Calculate exposes two static (Shared in VB.NET) members, which, you can set to specify the character that is recognized as the decimal separator and the character that is recognized as the list separator. The default values of these members are a period and a comma,respectively. You can set these static members at any point in your code before you use any Essential Calculate objects.

Regarding Decimal separator, please refer here

  • C#
    • public string Form_Load(object sender, EventArgs e)

{ 



    // Comma

    CalcEngine.ParseDecimalSeparator = ','; 



    // Semicolon
    CalcEngine.ParseArgumentSeparator = ';'; 



    //.... More code

}
  • VBNET
    • Public Sub Form_Load(sender as object, e As EventArgs)



     // Comma

     CalcEngine.ParseDecimalSeparator = "," 



     // Semicolon
     CalcEngine.ParseArgumentSeparator = ";" 



     '..... More code 

End Function