OutlineMode

This sample demonstrates the PivotGrid's new outlineMode property. In outline mode, the PivotGrid renders row fields in an outline format that is more compact and reduces the amount of white space shown on the screen. Outline mode is recommended for views with a large number of row fields.

Learn about OLAP | PivotGrid API Reference

import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './styles.css'; import '@grapecity/wijmo.touch'; // support drag/drop on touch devices import { PivotEngine, PivotPanel, PivotGrid } from '@grapecity/wijmo.olap'; import { CellRange } from '@grapecity/wijmo.grid'; import { toggleClass, saveFile } from '@grapecity/wijmo'; import { getData } from './data'; document.readyState === 'complete' ? init() : window.onload = init; function init() { // create the olap components let theEngine = new PivotEngine({ itemsSource: getData(1000), showRowTotals: 'Subtotals', showColumnTotals: 'None', totalsBeforeData: true, rowFields: ['Country', 'Product', 'Color'], valueFields: ['Sales', 'Expenses', 'Downloads'] }); let thePanel = new PivotPanel('#thePanel', { engine: theEngine, }); let theGrid = new PivotGrid('#theGrid', { itemsSource: theEngine, outlineMode: true }); // customize the olap components document.getElementById('outline').addEventListener('click', e => { theGrid.outlineMode = e.target.checked; if (theGrid.outlineMode) { let before = document.getElementById('before'); theEngine.totalsBeforeData = before.checked = true; } else { let before = document.getElementById('style'); before.checked = false; toggleClass(theGrid.hostElement, 'outline', false); } }); document.getElementById('style').addEventListener('click', e => { let customStyle = e.target.checked; toggleClass(theGrid.hostElement, 'outline', customStyle); }); document.getElementById('before').addEventListener('click', e => { theEngine.totalsBeforeData = e.target.checked; }); document.getElementById('headers').addEventListener('click', e => { theGrid.showRowFieldHeaders = e.target.checked; }); // export to CSV document.getElementById('csv').addEventListener('click', e => { let rng = new CellRange(0, 0, theGrid.rows.length - 1, theGrid.columns.length - 1), csv = theGrid.getClipString(rng, true, true, true); saveFile(csv, 'FlexGrid.csv'); }); }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>MESCIUS Wijmo OLAP Pivot Grid OutlineMode</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> outlineMode <input id="outline" type="checkbox" checked> </label><br /> <label> custom style <input id="style" type="checkbox" checked> </label><br /> <label> totalsBeforeData <input id="before" type="checkbox" checked> </label><br /> <label> showRowFieldHeaders <input id="headers" type="checkbox" checked> </label><br /> <div class="row"> <div class="col-sm-5"> <div id="thePanel"></div> </div> <div class="col-sm-7"> <div id="theGrid" class="outline"></div> <button id="csv" class="btn btn-primary">Export to CSV</button> </div> </div> </div> </body> </html>
// // get the raw data export function getData(count) { let countries = ['Germany', 'Italy', 'Japan', 'UK', 'US'], products = ['Widgets', 'Gadgets', 'Doohickeys'], colors = ['Red', 'Green', 'Blue', 'Yellow', 'Purple', 'White', 'Black', 'Magenta'], data = []; // for (let i = 0; i < count; i++) { let trend = (i % countries.length + 1) * (i % products.length + 1); data.push({ country: randomItem(countries), product: randomItem(products), color: randomItem(colors), active: i % 5 == 0, due: new Date(), sales: Math.random() * 10000 * trend, expenses: Math.random() * 5000 * trend, downloads: Math.random() * 100000 * trend }); } // return data; } // // get a random item from an array function randomItem(arr) { return arr[Math.floor(Math.random() * arr.length)]; }
.wj-pivotgrid { max-height: 400px; box-shadow: 0 10px 20px rgba(0,0,0,0.19), 0 6px 6px rgba(0,0,0,0.23); } .outline.wj-pivotgrid .wj-cell:not(.wj-state-selected) { border-right: none; border-bottom: none; background: #fff; color: #000; } body { margin-bottom: 24pt; }
(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.chart.map': 'npm:@grapecity/wijmo.chart.map/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.rest': 'npm:@grapecity/wijmo.rest/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);