Articles in this section
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:Format the cell values of Gantt columns.

 

A Sample to format the cell values of Gantt columns is available in the following link,

Sample

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied