Custom Column Headers

By default, the MultiRow control uses the same layoutDefinition for column headers and for the cell data.

You may use the headerLayoutDefinition property to customize the layout of the column headers.

Learn about MultiRow | MultiRow API Reference

import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './styles.css'; import { MultiRow } from '@grapecity/wijmo.grid.multirow'; import { getData, getLayoutDefinition, getHeaderLayoutDefinition } from './data'; document.readyState === 'complete' ? init() : window.onload = init; function init() { // create the MultiRow let theMultiRow = new MultiRow('#theMultiRow', { layoutDefinition: getLayoutDefinition(), headerLayoutDefinition: getHeaderLayoutDefinition(), itemsSource: getData() }); // toggle custom header layout document.getElementById('cbCustomHeaders').addEventListener('click', function (e) { theMultiRow.headerLayoutDefinition = e.target.checked ? getHeaderLayoutDefinition() : null; }); }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>GrapeCity Wijmo MultiRow Custom Column Headers</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- SystemJS --> <script src="node_modules/systemjs/dist/system.src.js"></script> <script src="systemjs.config.js"></script> <script> System.import('./src/app'); </script> </head> <body> <div class="container-fluid"> <label> Custom Headers: <input type="checkbox" checked id="cbCustomHeaders"> </label> <div id="theMultiRow"></div> </div> </body> </html>
// data export function getData() { var data = []; var products = 'Widgets,Gadgets,Sprockets'.split(','); var year = new Date().getFullYear() - 1; for (let i = 0; i < 100; i++) { let item = { id: i, product: products[i % products.length] }; for (let yr = year; yr <= year + 1; yr++) { let total = 0; for (let q = 1; q <= 4; q++) { let key = yr + ' Q' + q; let value = Math.round(Math.random() * 50); item[key] = value; total += value; } item[yr + ' Total'] = total; } data.push(item); } return data; } // data layout definition export function getLayoutDefinition() { let yr = new Date().getFullYear(); return [ { header: 'Product', cells: [ { binding: 'product', header: 'Product' } ] }, { colspan: 5, header: (yr - 1).toString(), align: 'center', cells: [ { binding: (yr - 1) + ' Q1', header: 'Q1' }, { binding: (yr - 1) + ' Q2', header: 'Q2' }, { binding: (yr - 1) + ' Q3', header: 'Q3' }, { binding: (yr - 1) + ' Q4', header: 'Q4' }, { binding: (yr - 1) + ' Total', header: 'Total', cssClass: 'yearly-total' } ] }, { colspan: 5, header: yr.toString(), align: 'center', cells: [ { binding: yr + ' Q1', header: 'Q1' }, { binding: yr + ' Q2', header: 'Q2' }, { binding: yr + ' Q3', header: 'Q3' }, { binding: yr + ' Q4', header: 'Q4' }, { binding: yr + ' Total', header: 'Total', cssClass: 'yearly-total' } ] } ]; } // header layout definition export function getHeaderLayoutDefinition() { let yr = new Date().getFullYear(); return [ { header: 'Product', cells: [ { binding: 'product', header: 'Product' } ] }, { cells: [ { header: (yr - 1).toString(), align: 'center', colspan: 5 }, { binding: (yr - 1) + ' Q1', header: 'Q1' }, { binding: (yr - 1) + ' Q2', header: 'Q2' }, { binding: (yr - 1) + ' Q3', header: 'Q3' }, { binding: (yr - 1) + ' Q4', header: 'Q4' }, { binding: (yr - 1) + ' Total', header: 'Total' } ] }, { cells: [ { header: yr.toString(), align: 'center', colspan: 5 }, { binding: yr + ' Q1', header: 'Q1' }, { binding: yr + ' Q2', header: 'Q2' }, { binding: yr + ' Q3', header: 'Q3' }, { binding: yr + ' Q4', header: 'Q4' }, { binding: yr + ' Total', header: 'Total' } ] } ]; }
.wj-multirow { height: 400px; margin: 6px 0; }
(function (global) { System.config({ transpiler: 'plugin-babel', babelOptions: { es2015: true }, meta: { '*.css': { loader: 'css' } }, paths: { // paths serve as alias 'npm:': 'node_modules/' }, // map tells the System loader where to look for things map: { 'jszip': 'npm:jszip/dist/jszip.js', '@grapecity/wijmo': 'npm:@grapecity/wijmo/index.js', '@grapecity/wijmo.input': 'npm:@grapecity/wijmo.input/index.js', '@grapecity/wijmo.styles': 'npm:@grapecity/wijmo.styles', '@grapecity/wijmo.cultures': 'npm:@grapecity/wijmo.cultures', '@grapecity/wijmo.chart': 'npm:@grapecity/wijmo.chart/index.js', '@grapecity/wijmo.chart.analytics': 'npm:@grapecity/wijmo.chart.analytics/index.js', '@grapecity/wijmo.chart.animation': 'npm:@grapecity/wijmo.chart.animation/index.js', '@grapecity/wijmo.chart.annotation': 'npm:@grapecity/wijmo.chart.annotation/index.js', '@grapecity/wijmo.chart.finance': 'npm:@grapecity/wijmo.chart.finance/index.js', '@grapecity/wijmo.chart.finance.analytics': 'npm:@grapecity/wijmo.chart.finance.analytics/index.js', '@grapecity/wijmo.chart.hierarchical': 'npm:@grapecity/wijmo.chart.hierarchical/index.js', '@grapecity/wijmo.chart.interaction': 'npm:@grapecity/wijmo.chart.interaction/index.js', '@grapecity/wijmo.chart.radar': 'npm:@grapecity/wijmo.chart.radar/index.js', '@grapecity/wijmo.chart.render': 'npm:@grapecity/wijmo.chart.render/index.js', '@grapecity/wijmo.chart.webgl': 'npm:@grapecity/wijmo.chart.webgl/index.js', '@grapecity/wijmo.gauge': 'npm:@grapecity/wijmo.gauge/index.js', '@grapecity/wijmo.grid': 'npm:@grapecity/wijmo.grid/index.js', '@grapecity/wijmo.grid.detail': 'npm:@grapecity/wijmo.grid.detail/index.js', '@grapecity/wijmo.grid.filter': 'npm:@grapecity/wijmo.grid.filter/index.js', '@grapecity/wijmo.grid.search': 'npm:@grapecity/wijmo.grid.search/index.js', '@grapecity/wijmo.grid.grouppanel': 'npm:@grapecity/wijmo.grid.grouppanel/index.js', '@grapecity/wijmo.grid.multirow': 'npm:@grapecity/wijmo.grid.multirow/index.js', '@grapecity/wijmo.grid.transposed': 'npm:@grapecity/wijmo.grid.transposed/index.js', '@grapecity/wijmo.grid.transposedmultirow': 'npm:@grapecity/wijmo.grid.transposedmultirow/index.js', '@grapecity/wijmo.grid.pdf': 'npm:@grapecity/wijmo.grid.pdf/index.js', '@grapecity/wijmo.grid.sheet': 'npm:@grapecity/wijmo.grid.sheet/index.js', '@grapecity/wijmo.grid.xlsx': 'npm:@grapecity/wijmo.grid.xlsx/index.js', '@grapecity/wijmo.grid.selector': 'npm:@grapecity/wijmo.grid.selector/index.js', '@grapecity/wijmo.grid.cellmaker': 'npm:@grapecity/wijmo.grid.cellmaker/index.js', '@grapecity/wijmo.nav': 'npm:@grapecity/wijmo.nav/index.js', '@grapecity/wijmo.odata': 'npm:@grapecity/wijmo.odata/index.js', '@grapecity/wijmo.olap': 'npm:@grapecity/wijmo.olap/index.js', '@grapecity/wijmo.pdf': 'npm:@grapecity/wijmo.pdf/index.js', '@grapecity/wijmo.pdf.security': 'npm:@grapecity/wijmo.pdf.security/index.js', '@grapecity/wijmo.viewer': 'npm:@grapecity/wijmo.viewer/index.js', '@grapecity/wijmo.xlsx': 'npm:@grapecity/wijmo.xlsx/index.js', '@grapecity/wijmo.undo': 'npm:@grapecity/wijmo.undo/index.js', '@grapecity/wijmo.interop.grid': 'npm:@grapecity/wijmo.interop.grid/index.js', '@grapecity/wijmo.touch': 'npm:@grapecity/wijmo.touch/index.js', '@grapecity/wijmo.cloud': 'npm:@grapecity/wijmo.cloud/index.js', '@grapecity/wijmo.barcode': 'npm:@grapecity/wijmo.barcode/index.js', '@grapecity/wijmo.barcode.common': 'npm:@grapecity/wijmo.barcode.common/index.js', '@grapecity/wijmo.barcode.composite': 'npm:@grapecity/wijmo.barcode.composite/index.js', '@grapecity/wijmo.barcode.specialized': 'npm:@grapecity/wijmo.barcode.specialized/index.js', 'jszip': 'npm:jszip/dist/jszip.js', 'bootstrap.css': 'npm:bootstrap/dist/css/bootstrap.min.css', 'css': 'npm:systemjs-plugin-css/css.js', 'plugin-babel': 'npm:systemjs-plugin-babel/plugin-babel.js', 'systemjs-babel-build':'npm:systemjs-plugin-babel/systemjs-babel-browser.js' }, // packages tells the System loader how to load when no filename and/or no extension packages: { src: { defaultExtension: 'js' }, "node_modules": { defaultExtension: 'js' }, } }); })(this);