DescriptionThis knowledge base explains the way to change the formula argument separator in the Spreadsheet based on the cultures. SolutionIt 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
|
This page will automatically be redirected to the sign-in page in 10 seconds.