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.
|
This KB illustrates that how to remove currency symbol in PivotGrid value cell. Solution:You can remove the currency symbol besides each value in the value cell of the PivotGrid using the following code example. JavaScript$(function () {
$("#PivotGrid").ejPivotGrid({
url: "../wcf/OLAPService.svc", afterServiceInvoke: "OnChangeCellText"
});
});
function OnChangeCellText(args) {
var JsonData = this.getJSONRecords();
for (i = 0; i < JsonData.length;i++)
JsonData[i].Value = JsonData[i].Value.replace("$", "");
this.setJSONRecords(JSON.stringify(JsonData));
}
ASP<ej:PivotGrid ID="PivotGrid1" runat="server" Url="../wcf/PivotGridtService.svc">
<ClientSideEvents AfterServiceInvoke="OnChangeCellText"/> </ej:PivotGrid>
<script type="text/javascript">
function OnChangeCellText(args) {
var JsonData = this.getJSONRecords();
for (i = 0; i < JsonData.length;i++)
JsonData[i].Value = JsonData[i].Value.replace("$", "");
this.setJSONRecords(JSON.stringify(JsonData));
}
<script/>
MVC@Html.EJ().Pivot().PivotGrid("PivotGrid1").Url(Url.Content("~/wcf/PivotGridService.svc")).ClientSideEvents(clientSideEvent => clientSideEvent.AfterServiceInvoke("OnChangeCellText"))
<script type="text/javascript">
function OnChangeCellText(args) {
var JsonData = this.getJSONRecords();
for (i = 0; i < JsonData.length;i++)
JsonData[i].Value = JsonData[i].Value.replace("$", "");
this.setJSONRecords(JSON.stringify(JsonData));
}
<script/>
|
This page will automatically be redirected to the sign-in page in 10 seconds.
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.
