We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to change "Total" string to other language?

Platform: JavaScript |
Control: ejPivotGrid |
Published Date: February 17, 2015 |
Last Revised Date: June 18, 2019

This KB illustrates that how to change "Total" string to other language.

Solution:

You can change the Total string to any desired language with respective to JS, ASP and MVC platforms by using the following code example.

JS

$(function () {
$("#PivotGrid1").ejPivotGrid({
url: "../wcf/OLAPService.svc", afterServiceInvoke: "OnChangeHeaderText"
});
});
function OnChangeTotalString(args) {
        var JsonData = this.getJSONRecords();
        for(i = 0; i < JsonData.length; i++)
        {
            if (JsonData[i].Value == "Total")
            JsonData[i].Value = "Enter valid string (in different language)";
        }        
        this.setJSONRecords(JSON.stringify(JsonData));
    }

 

MVC

@Html.EJ().Pivot().PivotGrid("PivotGrid1").Url(Url.Content("~/wcf/OLAPService.svc")).ClientSideEvents(clientSideEvent => clientSideEvent.AfterServiceInvoke("OnChangeTotalString"))
<script>
    function OnChangeTotalString(args) {
        var JsonData = this.getJSONRecords();
        for(i = 0; i < JsonData.length; i++)
        {
            if (JsonData[i].Value == "Total")
            JsonData[i].Value = "Enter valid string (in different language)";
        }        
        this.setJSONRecords(JSON.stringify(JsonData));
    }
</script>

 

ASP

<ej:PivotGrid ID="PivotGrid1" runat="server" Url="../wcf/PivotGridtService.svc">
<ClientSideEvents  AfterServiceInvoke="OnChangeTotalString"/>
</ej:PivotGrid>
<script>
    function OnChangeTotalString(args) {
        var JsonData = this.getJSONRecords();
        for(i = 0; i < JsonData.length; i++)
        {
            if (JsonData[i].Value == "Total")
            JsonData[i].Value = "Enter valid string (in different language)";
        }        
        this.setJSONRecords(JSON.stringify(JsonData));
    }
</script>

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon