Switch Culture Settings caused Formula to fail

Switch Culture Settings caused Formula to fail

Posted by: zhoubing.yang on 1 July 2022, 1:52 pm EST

• 

  zhoubing.yang

  • Post Options:
  • Link
    Copy

  Posted 1 July 2022, 1:52 pm EST

  I have a function to allow users to switch in between different cultures, when I switched to a culture setting where listSeperator and numberDecimalSeperator are both comma, I will notice “Invalid Formula” error from console and I am not able to enter multiple arguments within Formula separated by comma.

  
  const name = 'lang-1'
  const culture = new GC.Spread.Common.CultureInfo();
  culture.NumberFormat.listSeparator = ','
  culture.NumberFormat.numberDecimalSeparator = ','
  GC.Spread.Common.CultureManager.addCultureInfo(name, culture);
  GC.Spread.Common.CultureManager.culture(name);
  
  

  Is there a way to use comma as numberDecimalSeperator without clashing the Formula?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 4 July 2022, 2:28 am EST

  HI,

  We are sorry but we can not have the same character for decimalSepearte and list separator. We are sorry for the inconvenience.

  Regards,
  
  Avinash