1. Feedback
  2. JavaScript
  3. 42871

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

4
Votes

Provide globalization support for calculate module in spreadsheet

Provide globalization support for calculate module in spreadsheet. Consider formula separator, argument separator and decimal separator for other cultures. Also, ensure both in UI level and import/export.


In the below sample, component rendered with French culture. Here “,” comma is the decimal separator for French culture.

While using the French culture formatted value on the formula calculation, #VALUE error throws. Currently English culture based value alone accepted by the formula for calculation. 

For more details, please refer the sample and screenshots below.

Sample Link: https://stackblitz.com/edit/react-r6kh4g-ncgcg8?file=data.js,index.js


Empty


Actual Result: #Value!

Expected value : Calculates the correct formula value