单元格

SpreadJS允许完整的电子表格自定义,直至单元格级别,而不仅限于行和列。 功能包括多种单元格类型和下拉列表,单元格样式和状态,字体,格式,方向,填充,合并,填充,边框,验证,条件格式,注释等。 探索此“单元格”部分中的所有功能。

例如, 你可以通过指定行索引和列索引来获取一个单元格的实例对象。 你也可以获取一片表单区域中的所有单元格的集合。 如果你想获取一个单元格的位置, 宽度以及高度, 可以调用 getCellRect 方法。这个方法将返回单元格所在矩形区域。 表单提供 referenceStyle 属性。它是一个 ReferenceStyle 枚举, 包含两个枚举值: a1 r1c1 此属性设置单元格公式的引用样式, 并且他的默认值值是 ReferenceStyle.a1, 展现方式与 Excel 相同。使用以下代码来改变设置: 表单提供 allowCellOverflow 属性。 它的默认值是 true, 在默认状态下, 单元格的数据呈现将会根据其内容调整并覆盖此单元格以后的空单元格。使用以下代码来改变属性的值:
window.onload = function() { var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss')); var spreadNS = GC.Spread.Sheets; var sheet = spread.getSheet(0); sheet.suspendPaint(); sheet.defaults.colWidth = 120; sheet.setColumnWidth(1, 200); sheet.setValue(0, 0, 12); sheet.setValue(1, 0, 13); sheet.setValue(2, 0, 14); sheet.setValue(3, 0, 15); sheet.setValue(5, 0, 'ReferenceStyle'); sheet.setValue(6, 0, 'A1'); sheet.setValue(5, 1, 'Formula:'); sheet.setFormula(6, 1, '=FORMULATEXT(C7)'); sheet.setValue(5, 2, 'Result:'); sheet.setFormula(6, 2, 'SUM(A4:A8)'); sheet.setValue(9, 0, 'textAlignment'); sheet.setValue(10, 0, 'right'); sheet.setValue(11, 0, 'center'); sheet.setValue(12, 0, 'left'); sheet.getCell(10, 2).value('The cell overflow to right cell').hAlign(3); sheet.getCell(11, 2).value('The cell overflow to left and right cell').hAlign(1); sheet.getCell(12, 2).value('The cell overflow to left cell').hAlign(2); sheet.resumePaint(); document.getElementById('referenceStyle').addEventListener('change', function() { var referenceStyleValue = this.value; var referenceStyle = spreadNS.ReferenceStyle[referenceStyleValue]; spread.options.referenceStyle = referenceStyle; spread.getActiveSheet().recalcAll(); sheet.getCell(6, 0).value(referenceStyleValue.toLocaleLowerCase() === 'a1' ? 'A1' : 'R1C1'); }); document.getElementById('chkAllowCellOverFlow').addEventListener('click', function() { var sheet = spread.getActiveSheet(); if (sheet) { sheet.options.allowCellOverflow = this.checked; } }); };
<!doctype html> <html style="height:100%;font-size:14px;"> <head> <meta name="spreadjs culture" content="zh-cn" /> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link rel="stylesheet" type="text/css" href="$DEMOROOT$/zh/purejs/node_modules/@grapecity/spread-sheets/styles/gc.spread.sheets.excel2013white.css"> <script src="$DEMOROOT$/zh/purejs/node_modules/@grapecity/spread-sheets/dist/gc.spread.sheets.all.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/zh/purejs/node_modules/@grapecity/spread-sheets-resources-zh/dist/gc.spread.sheets.resources.zh.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/spread/source/js/license.js" type="text/javascript"></script> <script src="app.js" type="text/javascript"></script> <link rel="stylesheet" type="text/css" href="styles.css"> </head> <body> <div class="sample-tutorial"> <div id="ss" class="sample-spreadsheets"></div> <div class="options-container"> <div class="position"> <P>The reference style is defined as 'A1' and 'R1C1', the rows and the columns on the worksheet are numbered.</P> <P>If you change the reference style, the formula's reference will change too.</P> <label for="referenceStyle">ReferenceStyle:</label> <select id="referenceStyle" style="margin: 0 20px 0 6px"> <option value="a1">A1</option> <option value="r1c1">R1C1</option> </select> </div> <div style="padding-top: 16px"> <input type="checkbox" id="chkAllowCellOverFlow" checked="checked"/> <label for="chkAllowCellOverFlow">AllowCellOverFlow</label> </div> </div> </div> </body> </html>
.sample-tutorial { position: relative; height: 100%; overflow: hidden; } .sample-spreadsheets { width: calc(100% - 280px); height: 100%; overflow: hidden; float: left; } .options-container { float: right; width: 280px; padding: 12px; height: 100%; box-sizing: border-box; background: #fbfbfb; overflow: auto; } .option-row { font-size: 14px; padding: 5px; margin-top: 10px; } label { margin-bottom: 6px; } input { padding: 4px 6px; } input[type=button] { margin-top: 6px; display: block; } body { position: absolute; top: 0; bottom: 0; left: 0; right: 0; }