Category / Section
How to change the formula argument separator in the Spreadsheet based on the cultures
1 min read
Description
This knowledge base explains the way to change the formula argument separator in the Spreadsheet based on the cultures.
Solution
It can be achieved by using “load” client-side event.
HTML
<div id="Spreadsheet"></div>
JS
$("#Spreadsheet").ejSpreadsheet({
load: "onLoad"
});
RAZOR
@(Html.EJ().Spreadsheet<object>("Spreadsheet")
.ClientSideEvents(events => events.Load("onLoad"))
)
ASPX
<ej:spreadsheet id="Spreadsheet" runat="server"> <ClientSideEvents Load="onLoad" /> </ej:spreadsheet>
function onLoad(args) {
var calcEngine = this.getCalcEngine();
//To change the formula argument separator
calcEngine.setParseArgumentSeparator(";");
}
You can refer the below documentation link,
https://help.syncfusion.com/api/js/ejspreadsheet#events:load
