ProductSheet

This sample uses a TransposedGrid control to display products on the grid columns, and their properties on the grid rows.

Transposed layouts are especitally useful when there are few data items, and each items has many properties.

Learn about FlexGrid | TransposedGrid API Reference

import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './styles.css'; import { FlexGrid } from '@grapecity/wijmo.grid'; import { TransposedGrid } from '@grapecity/wijmo.grid.transposed'; import { ObservableArray } from '@grapecity/wijmo'; import { getData, getDataColumns } from './data'; document.readyState === 'complete' ? init() : window.onload = init; function init() { // data source shared by both grids let data = new ObservableArray(getData()); // default grid new FlexGrid('#theGrid', { alternatingRowStep: 0, showSelectedHeaders: 'Row', headersVisibility: 'Row', isReadOnly: true, copyHeaders: 'Row', selectionMode: 'CellRange', formatItem: formatItem, autoGenerateColumns: false, columns: getDataColumns(), itemsSource: data }); // transposed grid new TransposedGrid('#theTransposedGrid', { alternatingRowStep: 0, showSelectedHeaders: 'Row', headersVisibility: 'Row', isReadOnly: true, copyHeaders: 'Row', selectionMode: 'CellRange', formatItem: formatItem, // customize transposed product grid row/column sizes loadedRows: (s) => { s.columns.defaultSize = 200; setTimeout(() => { s.autoSizeColumn(0, true, 10); // auto-size row headers s.autoSizeRows(); // auto-size data rows s.rows[0].height = 180; // make product images large }); }, autoGenerateRows: false, rows: getDataColumns(), itemsSource: data }); function formatItem(s, e) { if (e.panel == s.cells) { // get binding from row if possible, then from column let binding = s.rows[e.row].binding || s.columns[e.col].binding; switch (binding) { // product image case 'img': e.cell.innerHTML = '<img src="{img}" draggable="false"/>'.replace('{img}', e.cell.textContent); break; // stars for rating case 'rating': let rating = s.getCellData(e.row, e.col, false), html = new Array(Math.floor(rating) + 1).join('&#x2605;'); if (rating > Math.floor(rating)) { html += '&#9734;'; // white star (half star doesn't work...) } e.cell.innerHTML = '<span class="rating">' + html + '</span>'; break; } } } }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>MESCIUS Wijmo TransposedGrid</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"> <h2> Default Grid </h2> <p> Products are rendered as rows. </p> <div id="theGrid" class="product-grid"></div> <h2> Transposed Grid </h2> <p> Products are rendered as columns. </p> <div id="theTransposedGrid" class="product-grid"></div> </div> </body> </html>
export function getData() { return [ { name: 'SAMSUNG 65-INCH Q9FN QLED TV', rating: 4, price: 2539.99, size: 65, type: 'LCD with Quantum Dots', refresh: 120, hdmi: 4.5, img: 'https://cdn.mescius.com/wijmo/images/1.png' }, { name: 'TCL 6 SERIES 65-INCH ROKU TV', rating: 4, price: 999.99, size: 65, type: 'LCD', refresh: 60, hdmi: 3, img: 'https://cdn.mescius.com/wijmo/images/2.png' }, { name: 'LG 55-INCH C7 OLED (OLED55C7P)', rating: 4.5, price: 679.99, size: 55, type: 'OLED', refresh: 120, hdmi: 4, img: 'https://cdn.mescius.com/wijmo/images/3.png' }, { name: 'VIZIO P-SERIES 65-INCH P65-F1', rating: 4, price: 1124.67, size: 65, type: 'LCD', refresh: 120, hdmi: 5, img: 'https://cdn.mescius.com/wijmo/images/4.png' }, { name: 'TCL 43S517 ROKU SMART 4K TV', rating: 3.5, price: 319.99, size: 43, type: 'LCD', refresh: 60, hdmi: 3, img: 'https://cdn.mescius.com/wijmo/images/1.png' }, { name: 'SAMSUNG 65-INCH Q6F QLED TV', rating: 3, price: 1597.99, size: 65, type: 'LCD with Quantum Dot', refresh: 120, hdmi: 4, img: 'https://cdn.mescius.com/wijmo/images/2.png' } ]; } export function getDataColumns() { return [ { binding: 'img', header: ' ', align: 'center' }, { binding: 'name', header: 'Model', align: 'center', wordWrap: true }, { binding: 'rating', header: 'Rating', align: 'center', format: 'n1' }, { binding: 'price', header: 'Price', format: 'c2', align: 'center' }, { binding: 'size', header: 'Screen Size (")', align: 'center' }, { binding: 'type', header: 'Screen Type', align: 'center' }, { binding: 'refresh', header: 'Refresh Rate (Hz)', align: 'center' }, { binding: 'hdmi', header: 'HMI ports', format: 'n0', align: 'center' } ]; }
.product-grid { max-height: 2000px; } .product-grid .wj-rowheaders .wj-cell { text-transform: uppercase; font-size: 80%; } .product-grid .wj-cell { padding: 12px; border-bottom: none; } .product-grid .wj-cell span.rating { font-size: 200%; color: #e7711b; } .product-grid img { height: 100%; }
(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);