formatSettings: [{ name: 'Sold', format: 'dd/MM/yyyy-hh:mm', type: 'date' }],
aggregateCellInfo(args) {
if (args.columnCellType == 'grandTotal') {
args.value = '';
for (var i = 0; i < args.cellSets.length; i++) {
if (typeof (args.cellSets[i][args.fieldName]) == "number") {
args.value = args.value + args.cellSets[i][args.fieldName];
}
}
} else if (args.cellSets[0]) {
args.value = args.cellSets[0][args.fieldName];
}
}
|
dataBound(args): void {
this.pivotGridObj.grid.beforeExcelExport = function (args) {
var data = (args as any).gridObject.dataSource;
for (var i = 0; i < data.length; i++) {
for (var j = 0; j < Object.keys(data[i]).length; j++) {
if (data[i][j].axis == 'value') {
data[i][j].value = data[i][j].formattedText;
}
}
}
}
} |