Your search did not match any results.
Data Grid

Column Customization

Documentation
The DataGrid widget includes a comprehensive set of appearance and behavior customization options for individual grid columns. In this example, column selection, reordering, resizing and fixed columns are enabled and the following custom settings have been applied: custom alignment has been set for the Position column; a calculated value is displayed for the Employee column. The Employee column is also anchored to the grid’s left edge, so it is always displayed in the grid regardless of horizontal scrolling. You can disable the fixed column or fix a different column within the grid container using the column header’s context menu.
Copy to Codepen
Apply
Reset
$(function(){ $("#gridContainer").dxDataGrid({ dataSource: orders, allowColumnReordering: true, allowColumnResizing: true, columnAutoWidth: true, columnChooser: { enabled: true }, columnFixing: { enabled: true }, columns: [{ caption: "Employee", width: 230, fixed: true, calculateCellValue: function(data) { return [data.Title, data.FirstName, data.LastName] .join(" "); } }, { dataField: "BirthDate", dataType: "date" }, { dataField: "HireDate", dataType: "date" }, { dataField: "Position", alignment: "right", }, { dataField: "Address", width: 230, }, "City", "State", { dataField: "Zipcode", visible: false }, "HomePhone", "MobilePhone", "Skype", "Email"] }); });
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <script src="js/jquery-3.1.0.min.js"></script> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/16.2.5/css/dx.spa.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/16.2.5/css/dx.common.css" /> <link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/16.2.5/css/dx.light.css" /> <script src="https://cdn3.devexpress.com/jslib/16.2.5/js/dx.all.js"></script> <script src="data.js"></script> <link rel="stylesheet" type ="text/css" href ="styles.css" /> <script src="index.js"></script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="gridContainer"></div> </div> </body> </html>
#gridContainer { height: 440px; width: 100%; }
var orders = [{ "ID": 1, "FirstName": "John", "LastName": "Heart", "Position": "CEO", "BirthDate": "1964-03-16T00:00:00", "HireDate": "1995-01-15T00:00:00", "Title": "Mr.", "Address": "17985 Pacific Coast Hwy", "City": "Los Angeles", "State": "California", "Zipcode": 90013, "Email": "jheart@dx-email.com", "Skype": "jheartDXskype", "HomePhone": "(213) 555-9208", "DepartmentID": 6, "MobilePhone": "(213) 555-9392" }, { "ID": 2, "FirstName": "Samantha", "LastName": "Bright", "Position": "COO", "BirthDate": "1966-05-02T00:00:00", "HireDate": "2004-05-24T00:00:00", "Title": "Dr.", "Address": "5801 Wilshire Blvd.", "City": "Los Angeles", "State": "California", "Zipcode": 90036, "Email": "samanthab@dx-email.com", "Skype": "samanthabDXskype", "HomePhone": "(213) 555-0288", "DepartmentID": 6, "MobilePhone": "(213) 555-2858" }, { "ID": 3, "FirstName": "Arthur", "LastName": "Miller", "Position": "CTO", "BirthDate": "1972-07-11T00:00:00", "HireDate": "2007-12-18T00:00:00", "Title": "Mr.", "Address": "3800 Homer St.", "City": "San Diego", "State": "California", "Zipcode": 90031, "Email": "arthurm@dx-email.com", "Skype": "arthurmDXskype", "HomePhone": "(310) 555-6542", "DepartmentID": 6, "MobilePhone": "(310) 555-8583" }, { "ID": 4, "FirstName": "Robert", "LastName": "Reagan", "Position": "CMO", "BirthDate": "1974-09-07T00:00:00", "HireDate": "2002-11-08T00:00:00", "Title": "Mr.", "Address": "4 Westmoreland Pl.", "City": "Bentonville", "State": "Arkansas", "Zipcode": 91103, "Email": "robertr@dx-email.com", "Skype": "robertrDXskype", "HomePhone": "(818) 555-2438", "DepartmentID": 6, "MobilePhone": "(818) 555-2387" }, { "ID": 5, "FirstName": "Greta", "LastName": "Sims", "Position": "HR Manager", "BirthDate": "1977-11-22T00:00:00", "HireDate": "1998-04-23T00:00:00", "Title": "Ms.", "Address": "1700 S Grandview Dr.", "State": "Georgia", "City": "Atlanta", "Zipcode": 91803, "Email": "gretas@dx-email.com", "Skype": "gretasDXskype", "HomePhone": "(818) 555-0976", "DepartmentID": 5, "MobilePhone": "(818) 555-6546" }, { "ID": 6, "FirstName": "Brett", "LastName": "Wade", "Position": "IT Manager", "BirthDate": "1968-12-01T00:00:00", "HireDate": "2009-03-06T00:00:00", "Title": "Mr.", "Address": "1120 Old Mill Rd.", "State": "Idaho", "City": "Boise", "Zipcode": 91108, "Email": "brettw@dx-email.com", "Skype": "brettwDXskype", "HomePhone": "(626) 555-5985", "DepartmentID": 7, "MobilePhone": "(626) 555-0358" }, { "ID": 7, "FirstName": "Sandra", "LastName": "Johnson", "Position": "Controller", "BirthDate": "1974-11-15T00:00:00", "HireDate": "2005-05-11T00:00:00", "Title": "Mrs.", "Address": "4600 N Virginia Rd.", "State": "Utah", "City": "Beaver", "Zipcode": 90807, "Email": "sandraj@dx-email.com", "Skype": "sandrajDXskype", "HomePhone": "(562) 555-8272", "DepartmentID": 5, "MobilePhone": "(562) 555-2082" }, { "ID": 8, "FirstName": "Edward", "LastName": "Holmes", "Position": "Sales Manager", "BirthDate": "1973-07-14T00:00:00", "HireDate": "2005-06-19T00:00:00", "Title": "Dr.", "Address": "351 S Hill St.", "State": "Missouri", "City": "St. Louis", "Zipcode": 90265, "Email": "edwardh@dx-email.com", "Skype": "edwardhDXskype", "HomePhone": "(310) 555-6098", "DepartmentID": 1, "MobilePhone": "(310) 555-1288" }, { "ID": 9, "FirstName": "Barbara", "LastName": "Banks", "Position": "Support Manager", "BirthDate": "1979-04-14T00:00:00", "HireDate": "2002-08-07T00:00:00", "Title": "Mrs.", "Address": "7962 Lost Mountain", "State": "Arkansas", "City": "Little Rock", "Zipcode": 90272, "Email": "barbarab@dx-email.com", "Skype": "barbarabDXskype", "HomePhone": "(310) 555-9792", "DepartmentID": 2, "MobilePhone": "(310) 555-3355" }, { "ID": 10, "FirstName": "Kevin", "LastName": "Carter", "Position": "Shipping Manager", "BirthDate": "1978-01-09T00:00:00", "HireDate": "2009-08-11T00:00:00", "Title": "Mr.", "Address": "424 N Main St.", "State": "California", "City": "San Diego", "Zipcode": 90012, "Email": "kevinc@dx-email.com", "Skype": "kevincDXskype", "HomePhone": "(213) 555-8038", "DepartmentID": 3, "MobilePhone": "(213) 555-2840" }];