Category / Section
How to format the cell values in Gantt?
2 mins read
We can add custom columns in jQuery Gantt by using “load” event, which is triggered during load time of Gantt control. We can also customize the column with different formats like Currency, Date, Numeric and Percentage by using “format” property of column in “load” event. The below code example explains about how to format the columns in Gantt.
<div id="GanttContainer" style="height:450px;width:100%"></div> <script type="text/javascript"> $(function () { $("#GanttContainer").ejGantt({ // load: function (args) { var column = this.getColumns(), customcolumn1 = {}, customcolumn2={}, customcolumn3 = {}; customcolumn1["field"] = "Number"; customcolumn1["mappingName"] = "Number"; customcolumn1["headerText"] = "Number"; customcolumn1["editType"] = "numericedit"; customcolumn1["format"] = "{0:n2}"; customcolumn1["editParams"] = { decimalPlaces: 2, incrementStep: 0.01 }; column.splice(2, 0, customcolumn1); customcolumn2["field"] = "Currency"; customcolumn2["mappingName"] = "Currency"; customcolumn2["headerText"] = "Currency"; customcolumn2["editType"] = "numericedit"; customcolumn2["format"] = "{0:c2}"; customcolumn2["editParams"] = { decimalPlaces: 2, incrementStep: 0.01 }; column.splice(3, 0, customcolumn2); customcolumn3["field"] = "Percentage"; customcolumn3["mappingName"] = "Percentage"; customcolumn3["headerText"] = "Percentage"; customcolumn3["editType"] = "numericedit"; customcolumn3["format"] = "{0:p0}"; customcolumn3["editParams"] = { decimalPlaces: 2, incrementStep: 0.01 }; column.splice(4, 0, customcolumn3); }, }) }); </script>
Screenshot:
A Sample to format the cell values of Gantt columns is available in the following link,