1040 Tax Form

The following sample shows how you can use SpreadJS spreadsheet to easily create complex interactive data entry and input forms for your JavaScript applications, such as the US Form 1040 Individual Income Tax Return. Typical forms could be from the medical, legal, insurance, education, or financial industries.

The example highlights the locking of cells to prevent editing, vertical text alignment, as well as loading a predefined template using fromJSON.
import * as React from 'react'; import * as ReactDOM from 'react-dom'; import GC from '@grapecity/spread-sheets'; import { SpreadSheets, Worksheet } from '@grapecity/spread-sheets-react'; import './styles.css'; const Component = React.Component; function _getElementById(id) { return document.getElementById(id); } class App extends Component { constructor(props) { super(props); } render() { return <div class="sample-tutorial"> <div class="sample-spreadsheets"> <SpreadSheets workbookInitialized={spread=>this.initSpread(spread)}> <Worksheet> </Worksheet> </SpreadSheets> </div> </div>; } initSpread(spread) { var sd = data; if (sd.length > 0) { if (!spread) { return; } spread.suspendPaint(); spread.fromJSON(sd[0]); spread.options.tabStripVisible = false; var sheet = spread.getSheet(0); sheet.options.isProtected = true; sheet.options.gridline = { showHorizontalGridline: false, showVerticalGridline: false }; sheet.getRange(-1, 0, -1, sheet.getColumnCount(GC.Spread.Sheets.SheetArea.rowHeader), GC.Spread.Sheets.SheetArea.rowHeader).visible(false); sheet.getRange(0, -1, sheet.getRowCount(GC.Spread.Sheets.SheetArea.colHeader), -1, GC.Spread.Sheets.SheetArea.colHeader).visible(false); var style = sheet.getStyle(1, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(1, 1, style); } style = sheet.getStyle(3, 3, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(3, 3, style); } style = sheet.getStyle(7, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(7, 1, style); } style = sheet.getStyle(5, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(5, 1, style); } style = sheet.getStyle(9, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(9, 1, style); } style = sheet.getStyle(15, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(15, 1, style); sheet.setStyle(21, 1, style); } style = sheet.getStyle(31, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(31, 1, style); } style = sheet.getStyle(37, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(37, 1, style); } style = sheet.getStyle(41, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(41, 1, style); } style = sheet.getStyle(46, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(46, 1, style); } style = sheet.getStyle(17, 22, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(17, 22, style); } style = sheet.getStyle(19, 12, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(19, 12, style); sheet.setStyle(19, 16, style); sheet.setStyle(19, 18, style); } style = sheet.getStyle(8, 21, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(8, 21, style); } style = sheet.getStyle(10, 21, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.wordWrap = true; sheet.setStyle(10, 21, style); } style = sheet.getStyle(13, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.font = "normal bold 14px Calibri"; sheet.setStyle(13, 1, style); sheet.setStyle(17, 1, style); sheet.setStyle(28, 1, style); } style = sheet.getStyle(46, 1, GC.Spread.Sheets.SheetArea.viewport); if (style) { style.font = "normal bold 14px Calibri"; style.wordWrap = true; sheet.setStyle(46, 1, style); } spread.resumePaint(); } } } ReactDOM.render(<App />, _getElementById('app'));
<!doctype html> <html style="height:100%;font-size:14px;"> <head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/react/node_modules/@grapecity/spread-sheets/styles/gc.spread.sheets.excel2013white.css"> <!-- SystemJS --> <script src="$DEMOROOT$/en/react/node_modules/systemjs/dist/system.src.js"></script> <script src="$DEMOROOT$/spread/source/data/taxform.js" type="text/javascript"></script> <script src="systemjs.config.js"></script> <script> System.import('$DEMOROOT$/en/lib/react/license.js').then(function () { System.import('./src/app'); }); </script> </head> <body> <div id="app"></div> </body> </html>
.sample-tutorial { position: relative; height: 100%; overflow: hidden; } .sample-spreadsheets { width: 100%; height: 100%; overflow: hidden; float: left; } body { position: absolute; top: 0; bottom: 0; left: 0; right: 0; } #app { height: 100%; }
(function (global) { System.config({ transpiler: 'plugin-babel', babelOptions: { es2015: true, react: true }, meta: { '*.css': { loader: 'css' } }, paths: { // paths serve as alias 'npm:': 'node_modules/' }, // map tells the System loader where to look for things map: { '@grapecity/spread-sheets': 'npm:@grapecity/spread-sheets/index.js', '@grapecity/spread-sheets-react': 'npm:@grapecity/spread-sheets-react/index.js', '@grapecity/jsob-test-dependency-package/react-components': 'npm:@grapecity/jsob-test-dependency-package/react-components/index.js', 'react': 'npm:react/umd/react.production.min.js', 'react-dom': 'npm:react-dom/umd/react-dom.production.min.js', '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: 'jsx' }, "node_modules": { defaultExtension: 'js' }, } }); })(this);