모서리 폴드

SpreadJS는 셀의 모서리 폴드를 만들도록 스타일에서 일부 데이터 설정을 지원합니다.

다음 방법으로 셀의 모서리 폴드를 설정할 수 있습니다. 아래 설정에서 상세한 정보를 찾아볼 수 있습니다. position: leftTop leftBottom rightTop rightBottom 기본값: size: 6 position: GC.Spread.Sheets.CornerPosition.leftTop color: #FF3D00
import * as React from 'react'; import * as ReactDOM from 'react-dom'; import './styles.css'; import { AppFunc } from './app-func'; // import { App } from './app-class'; // 1. Functional Component sample ReactDOM.render(<AppFunc />, document.getElementById('app')); // 2. Class Component sample // ReactDOM.render(<App />, document.getElementById('app'));
import * as React from 'react'; import GC from '@mescius/spread-sheets'; import { SpreadSheets } from '@mescius/spread-sheets-react'; import '@mescius/spread-sheets-resources-ko'; GC.Spread.Common.CultureManager.culture("ko-kr"); let spread = null; export function AppFunc() { const [cornerFolderOption, setCornerFolderOption] = React.useState({ size: 6, color: "red", leftTop: false, leftBottom: false, rightTop: false, rightBottom: false, }); const handleInputClick = (event) => { const target = event.target; const value = target.checked; const name = target.name; setCornerFolderOption({ ...cornerFolderOption, [name]: value }); } const handleInputChange = (event) => { const target = event.target; const value = target.value; const name = target.name; setCornerFolderOption({ ...cornerFolderOption, [name]: value }); } const initSpread = (currSpread) => { spread = currSpread; let sheet = spread.getSheet(0); initSpreadData(sheet); initSheet(sheet); bindEvents(spread); } const initSheet = (sheet) => { let style = sheet.getStyle(18, 4); style.decoration = { cornerFold: { size: 8, position: 1, color: "red" } } sheet.setStyle(18, 4, style); style = sheet.getStyle(18, 6); style.decoration = { cornerFold: { size: 10, position: 2, color: "green" } } sheet.setStyle(18, 6, style); style = sheet.getStyle(6, 10); style.decoration = { cornerFold: { size: 15, position: 4, color: "blue" } } sheet.setStyle(6, 10, style); style = sheet.getStyle(12, 10); style.decoration = { cornerFold: { size: 20, position: 8, color: "black" } } sheet.setStyle(12, 10, style); style = sheet.getStyle(18, 10); style.decoration = { cornerFold: { size: 8, position: 15, color: "black" } } sheet.setStyle(18, 10, style); } const initSpreadData = (sheet) => { let spreadNS = GC.Spread.Sheets; sheet.addSpan(1, 1, 1, 3); sheet.setValue(1, 1, 'Store'); sheet.addSpan(1, 4, 1, 7); sheet.setValue(1, 4, 'Goods'); sheet.addSpan(2, 1, 1, 2); sheet.setValue(2, 1, 'Area'); sheet.addSpan(2, 3, 2, 1); sheet.setValue(2, 3, 'ID'); sheet.addSpan(2, 4, 1, 2); sheet.setValue(2, 4, 'Fruits'); sheet.addSpan(2, 6, 1, 2); sheet.setValue(2, 6, 'Vegetables'); sheet.addSpan(2, 8, 1, 2); sheet.setValue(2, 8, 'Foods'); sheet.addSpan(2, 10, 2, 1); sheet.setValue(2, 10, 'Total'); sheet.setValue(3, 1, 'State'); sheet.setValue(3, 2, 'City'); sheet.setValue(3, 4, 'Grape'); sheet.setValue(3, 5, 'Apple'); sheet.setValue(3, 6, 'Potato'); sheet.setValue(3, 7, 'Tomato'); sheet.setValue(3, 8, 'SandWich'); sheet.setValue(3, 9, 'Hamburger'); sheet.addSpan(4, 1, 7, 1); sheet.addSpan(4, 2, 3, 1); sheet.addSpan(7, 2, 3, 1); sheet.addSpan(10, 2, 1, 2); sheet.setValue(10, 2, 'Sub Total:'); sheet.addSpan(11, 1, 7, 1); sheet.addSpan(11, 2, 3, 1); sheet.addSpan(14, 2, 3, 1); sheet.addSpan(17, 2, 1, 2); sheet.setValue(17, 2, 'Sub Total:'); sheet.addSpan(18, 1, 1, 3); sheet.setValue(18, 1, 'Total:'); sheet.setValue(4, 1, 'NC'); sheet.setValue(4, 2, 'Raleigh'); sheet.setValue(7, 2, 'Charlotte'); sheet.setValue(4, 3, '001'); sheet.setValue(5, 3, '002'); sheet.setValue(6, 3, '003'); sheet.setValue(7, 3, '004'); sheet.setValue(8, 3, '005'); sheet.setValue(9, 3, '006'); sheet.setValue(11, 1, 'PA'); sheet.setValue(11, 2, 'Philadelphia'); sheet.setValue(14, 2, 'Pittsburgh'); sheet.setValue(11, 3, '007'); sheet.setValue(12, 3, '008'); sheet.setValue(13, 3, '009'); sheet.setValue(14, 3, '010'); sheet.setValue(15, 3, '011'); sheet.setValue(16, 3, '012'); sheet.setFormula(10, 4, '=SUM(E5:E10)'); sheet.setFormula(10, 5, '=SUM(F5:F10)'); sheet.setFormula(10, 6, '=SUM(G5:G10)'); sheet.setFormula(10, 7, '=SUM(H5:H10)'); sheet.setFormula(10, 8, '=SUM(I5:I10)'); sheet.setFormula(10, 9, '=SUM(J5:J10)'); sheet.setFormula(17, 4, '=SUM(E12:E17)'); sheet.setFormula(17, 5, '=SUM(F12:F17)'); sheet.setFormula(17, 6, '=SUM(G12:G17)'); sheet.setFormula(17, 7, '=SUM(H12:H17)'); sheet.setFormula(17, 8, '=SUM(I12:I17)'); sheet.setFormula(17, 9, '=SUM(J12:J17)'); for (let i = 0; i < 14; i++) { sheet.setFormula(4 + i, 10, '=SUM(E' + (5 + i).toString() + ':J' + (5 + i).toString() + ')'); } sheet.setFormula(18, 4, '=E11+E18'); sheet.setFormula(18, 5, '=F11+F18'); sheet.setFormula(18, 6, '=G11+G18'); sheet.setFormula(18, 7, '=H11+H18'); sheet.setFormula(18, 8, '=I11+I18'); sheet.setFormula(18, 9, '=J11+J18'); sheet.setFormula(18, 10, '=K11+K18'); sheet.getRange(1, 1, 3, 10).backColor('#D9D9FF'); sheet.getRange(4, 1, 15, 3).backColor('#D9FFD9'); sheet.getRange(1, 1, 3, 10).hAlign(spreadNS.HorizontalAlign.center); sheet.getRange(1, 1, 18, 10).setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.thin), { all: true }); sheet.getRange(4, 4, 3, 6).setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); sheet.getRange(7, 4, 3, 6).setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); sheet .getRange(11, 4, 3, 6) .setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); sheet .getRange(14, 4, 3, 6) .setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); fillSampleData(sheet, new spreadNS.Range(4, 4, 6, 6)); fillSampleData(sheet, new spreadNS.Range(11, 4, 6, 6)); } const fillSampleData = (sheet, range) => { for (let i = 0; i < range.rowCount; i++) { for (let j = 0; j < range.colCount; j++) { sheet.setValue(range.row + i, range.col + j, Math.ceil(Math.random() * 300)); } } } const bindEvents = (spread) => { let sheet = spread.getSheet(0); spread.bind(GC.Spread.Sheets.Events.SelectionChanged, function () { reset(sheet); sheet.repaint(); }); } const reset = ()=> { let sheet = spread.getActiveSheet(); let activeRow = sheet.getActiveRowIndex(); let activeCol = sheet.getActiveColumnIndex(); let style = sheet.getStyle(activeRow, activeCol); let state = { ...cornerFolderOption }; state.leftTop = false; state.rightTop = false; state.leftBottom = false; state.rightBottom = false; if (style && style.decoration && style.decoration.cornerFold) { let cornerFold = style.decoration.cornerFold; state.size = +cornerFold.size; state.color = cornerFold.color; if (cornerFold.position & 1) { state.leftTop = true; } if (cornerFold.position & 2) { state.rightTop = true; } if (cornerFold.position & 4) { state.leftBottom = true; } if (cornerFold.position & 8) { state.rightBottom = true; } } else { state.size = 6; state.color = ''; } setCornerFolderOption(state); } const set = () => { let sheet = spread.getActiveSheet(); let activeRow = sheet.getActiveRowIndex(); let activeCol = sheet.getActiveColumnIndex(); let style = sheet.getStyle(activeRow, activeCol); let state = { ...cornerFolderOption }; if (!style) { style = new GC.Spread.Sheets.Style(); } let position = 0; if (state.leftTop) { position = position | 1; } if (state.rightTop) { position = position | 2; } if (state.leftBottom) { position = position | 4; } if (state.rightBottom) { position = position | 8; } style.decoration = { cornerFold: { size: state.size, position: position, color: state.color } } sheet.setStyle(activeRow, activeCol, style); } return ( <div class="sample-tutorial"> <div class="sample-spreadsheets"> <SpreadSheets workbookInitialized={initSpread} /> </div> <div class="options-container"> <p>Try selecting a cell, change the following options and hit the "reset" button.</p> <div class="corner-pro"> <label for="size-corner">corner size:</label><input type="number" id="size-corner" name={'size'} class="corner-input" placeholder="corner-size" value={cornerFolderOption.size} onChange={handleInputChange}/> </div> <div class="corner-pro"> <label for="color-corner">corner color:</label><input type="text" id="color-corner" name={'color'} class="corner-input" placeholder="corner-color" value={cornerFolderOption.color} onChange={handleInputChange}/> </div> <div class="corner-pro"> <label for="position-corner">leftTop position:</label><input type="checkbox" name={'leftTop'} class="corner-input" id="leftTop" checked={cornerFolderOption.leftTop} onChange={handleInputClick}/> </div> <div class="corner-pro"> <label for="position-corner">rightTop position:</label><input type="checkbox" name={'rightTop'} class="corner-input" id="rightTop" checked={cornerFolderOption.rightTop} onChange={handleInputClick}/> </div> <div class="corner-pro"> <label for="position-corner">leftBottom position:</label><input type="checkbox" name={'leftBottom'} class="corner-input" id="leftBottom" checked={cornerFolderOption.leftBottom} onChange={handleInputClick}/> </div> <div class="corner-pro"> <label for="position-corner">rightBottom position:</label><input type="checkbox" name={'rightBottom'} class="corner-input" id="rightBottom" checked={cornerFolderOption.rightBottom} onChange={handleInputClick}/> </div> <div class="corner-pro"> <button id="set-corner" class="corner-btn" onClick={set}>set</button> <button id="reset-corner" class="corner-btn" onClick={reset}>reset</button> </div> </div> </div> ); }
import * as React from 'react'; import GC from '@mescius/spread-sheets'; import { SpreadSheets } from '@mescius/spread-sheets-react'; import '@mescius/spread-sheets-resources-ko'; GC.Spread.Common.CultureManager.culture("ko-kr"); const Component = React.Component; export class App extends Component { constructor(props) { super(props); this.spread = null; this.state = { size: 6, color: "red", leftTop: false, leftBottom: false, rightTop: false, rightBottom: false, } } handleInputClick = (event) => { const target = event.target; const value = target.checked; const name = target.name; this.setState({ [name]: value }); } handleInputChange = (event) => { const target = event.target; const value = target.value; const name = target.name; this.setState({ [name]: value }); } initSpread = (spread) => { this.spread = spread; let sheet = spread.getSheet(0); this.initSpreadData(sheet); this.initSheet(sheet); this.bindEvents(spread); } initSheet = (sheet) => { let style = sheet.getStyle(18, 4); style.decoration = { cornerFold: { size: 8, position: 1, color: "red" } } sheet.setStyle(18, 4, style); style = sheet.getStyle(18, 6); style.decoration = { cornerFold: { size: 10, position: 2, color: "green" } } sheet.setStyle(18, 6, style); style = sheet.getStyle(6, 10); style.decoration = { cornerFold: { size: 15, position: 4, color: "blue" } } sheet.setStyle(6, 10, style); style = sheet.getStyle(12, 10); style.decoration = { cornerFold: { size: 20, position: 8, color: "black" } } sheet.setStyle(12, 10, style); style = sheet.getStyle(18, 10); style.decoration = { cornerFold: { size: 8, position: 15, color: "black" } } sheet.setStyle(18, 10, style); } initSpreadData = (sheet) => { let spreadNS = GC.Spread.Sheets; sheet.addSpan(1, 1, 1, 3); sheet.setValue(1, 1, 'Store'); sheet.addSpan(1, 4, 1, 7); sheet.setValue(1, 4, 'Goods'); sheet.addSpan(2, 1, 1, 2); sheet.setValue(2, 1, 'Area'); sheet.addSpan(2, 3, 2, 1); sheet.setValue(2, 3, 'ID'); sheet.addSpan(2, 4, 1, 2); sheet.setValue(2, 4, 'Fruits'); sheet.addSpan(2, 6, 1, 2); sheet.setValue(2, 6, 'Vegetables'); sheet.addSpan(2, 8, 1, 2); sheet.setValue(2, 8, 'Foods'); sheet.addSpan(2, 10, 2, 1); sheet.setValue(2, 10, 'Total'); sheet.setValue(3, 1, 'State'); sheet.setValue(3, 2, 'City'); sheet.setValue(3, 4, 'Grape'); sheet.setValue(3, 5, 'Apple'); sheet.setValue(3, 6, 'Potato'); sheet.setValue(3, 7, 'Tomato'); sheet.setValue(3, 8, 'SandWich'); sheet.setValue(3, 9, 'Hamburger'); sheet.addSpan(4, 1, 7, 1); sheet.addSpan(4, 2, 3, 1); sheet.addSpan(7, 2, 3, 1); sheet.addSpan(10, 2, 1, 2); sheet.setValue(10, 2, 'Sub Total:'); sheet.addSpan(11, 1, 7, 1); sheet.addSpan(11, 2, 3, 1); sheet.addSpan(14, 2, 3, 1); sheet.addSpan(17, 2, 1, 2); sheet.setValue(17, 2, 'Sub Total:'); sheet.addSpan(18, 1, 1, 3); sheet.setValue(18, 1, 'Total:'); sheet.setValue(4, 1, 'NC'); sheet.setValue(4, 2, 'Raleigh'); sheet.setValue(7, 2, 'Charlotte'); sheet.setValue(4, 3, '001'); sheet.setValue(5, 3, '002'); sheet.setValue(6, 3, '003'); sheet.setValue(7, 3, '004'); sheet.setValue(8, 3, '005'); sheet.setValue(9, 3, '006'); sheet.setValue(11, 1, 'PA'); sheet.setValue(11, 2, 'Philadelphia'); sheet.setValue(14, 2, 'Pittsburgh'); sheet.setValue(11, 3, '007'); sheet.setValue(12, 3, '008'); sheet.setValue(13, 3, '009'); sheet.setValue(14, 3, '010'); sheet.setValue(15, 3, '011'); sheet.setValue(16, 3, '012'); sheet.setFormula(10, 4, '=SUM(E5:E10)'); sheet.setFormula(10, 5, '=SUM(F5:F10)'); sheet.setFormula(10, 6, '=SUM(G5:G10)'); sheet.setFormula(10, 7, '=SUM(H5:H10)'); sheet.setFormula(10, 8, '=SUM(I5:I10)'); sheet.setFormula(10, 9, '=SUM(J5:J10)'); sheet.setFormula(17, 4, '=SUM(E12:E17)'); sheet.setFormula(17, 5, '=SUM(F12:F17)'); sheet.setFormula(17, 6, '=SUM(G12:G17)'); sheet.setFormula(17, 7, '=SUM(H12:H17)'); sheet.setFormula(17, 8, '=SUM(I12:I17)'); sheet.setFormula(17, 9, '=SUM(J12:J17)'); for (let i = 0; i < 14; i++) { sheet.setFormula(4 + i, 10, '=SUM(E' + (5 + i).toString() + ':J' + (5 + i).toString() + ')'); } sheet.setFormula(18, 4, '=E11+E18'); sheet.setFormula(18, 5, '=F11+F18'); sheet.setFormula(18, 6, '=G11+G18'); sheet.setFormula(18, 7, '=H11+H18'); sheet.setFormula(18, 8, '=I11+I18'); sheet.setFormula(18, 9, '=J11+J18'); sheet.setFormula(18, 10, '=K11+K18'); sheet.getRange(1, 1, 3, 10).backColor('#D9D9FF'); sheet.getRange(4, 1, 15, 3).backColor('#D9FFD9'); sheet.getRange(1, 1, 3, 10).hAlign(spreadNS.HorizontalAlign.center); sheet.getRange(1, 1, 18, 10).setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.thin), { all: true }); sheet.getRange(4, 4, 3, 6).setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); sheet.getRange(7, 4, 3, 6).setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); sheet .getRange(11, 4, 3, 6) .setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); sheet .getRange(14, 4, 3, 6) .setBorder(new spreadNS.LineBorder('Black', spreadNS.LineStyle.dotted), { inside: true }); this.fillSampleData(sheet, new spreadNS.Range(4, 4, 6, 6)); this.fillSampleData(sheet, new spreadNS.Range(11, 4, 6, 6)); } fillSampleData = (sheet, range) => { for (let i = 0; i < range.rowCount; i++) { for (let j = 0; j < range.colCount; j++) { sheet.setValue(range.row + i, range.col + j, Math.ceil(Math.random() * 300)); } } } bindEvents = (spread) => { let sheet = spread.getSheet(0), self = this; spread.bind(GC.Spread.Sheets.Events.SelectionChanged, function () { self.reset(sheet); sheet.repaint(); }); } reset = ()=> { let sheet = this.spread.getActiveSheet(); let activeRow = sheet.getActiveRowIndex(); let activeCol = sheet.getActiveColumnIndex(); let style = sheet.getStyle(activeRow, activeCol); let state = this.state; state.leftTop = false; state.rightTop = false; state.leftBottom = false; state.rightBottom = false; if (style && style.decoration && style.decoration.cornerFold) { let cornerFold = style.decoration.cornerFold; state.size = +cornerFold.size; state.color = cornerFold.color; if (cornerFold.position & 1) { state.leftTop = true; } if (cornerFold.position & 2) { state.rightTop = true; } if (cornerFold.position & 4) { state.leftBottom = true; } if (cornerFold.position & 8) { state.rightBottom = true; } } else { state.size = 6; state.color = ''; } this.setState(state); } set = () => { let sheet = this.spread.getActiveSheet(); let activeRow = sheet.getActiveRowIndex(); let activeCol = sheet.getActiveColumnIndex(); let style = sheet.getStyle(activeRow, activeCol); let state = this.state; if (!style) { style = new GC.Spread.Sheets.Style(); } let position = 0; if (state.leftTop) { position = position | 1; } if (state.rightTop) { position = position | 2; } if (state.leftBottom) { position = position | 4; } if (state.rightBottom) { position = position | 8; } style.decoration = { cornerFold: { size: state.size, position: position, color: state.color } } sheet.setStyle(activeRow, activeCol, style); } render() { return ( <div class="sample-tutorial"> <div class="sample-spreadsheets"> <SpreadSheets workbookInitialized={this.initSpread} /> </div> <div class="options-container"> <p>Try selecting a cell, change the following options and hit the "reset" button.</p> <div class="corner-pro"> <label for="size-corner">corner size:</label><input type="number" id="size-corner" name={'size'} class="corner-input" placeholder="corner-size" value={this.state.size} onChange={this.handleInputChange}/> </div> <div class="corner-pro"> <label for="color-corner">corner color:</label><input type="text" id="color-corner" name={'color'} class="corner-input" placeholder="corner-color" value={this.state.color} onChange={this.handleInputChange}/> </div> <div class="corner-pro"> <label for="position-corner">leftTop position:</label><input type="checkbox" name={'leftTop'} class="corner-input" id="leftTop" checked={this.state.leftTop} onChange={this.handleInputClick}/> </div> <div class="corner-pro"> <label for="position-corner">rightTop position:</label><input type="checkbox" name={'rightTop'} class="corner-input" id="rightTop" checked={this.state.rightTop} onChange={this.handleInputClick}/> </div> <div class="corner-pro"> <label for="position-corner">leftBottom position:</label><input type="checkbox" name={'leftBottom'} class="corner-input" id="leftBottom" checked={this.state.leftBottom} onChange={this.handleInputClick}/> </div> <div class="corner-pro"> <label for="position-corner">rightBottom position:</label><input type="checkbox" name={'rightBottom'} class="corner-input" id="rightBottom" checked={this.state.rightBottom} onChange={this.handleInputClick}/> </div> <div class="corner-pro"> <button id="set-corner" class="corner-btn" onClick={this.set}>set</button> <button id="reset-corner" class="corner-btn" onClick={this.reset}>reset</button> </div> </div> </div> ) } }
<!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$/ko/react/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css"> <!-- SystemJS --> <script src="$DEMOROOT$/ko/react/node_modules/systemjs/dist/system.src.js"></script> <script src="systemjs.config.js"></script> <script> System.import('$DEMOROOT$/ko/lib/react/license.js').then(function () { System.import('./src/app'); }); </script> </head> <body> <div id="app" style="height: 100%;"></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; } body { position: absolute; top: 0; bottom: 0; left: 0; right: 0; } label { display: inline-block; width: 135px; } .corner-pro { width: 100%; height: 30px; font-size: 13px; } #size-corner, #color-corner { display: inline-block; width: 100px; } .corner-btn { display: inline-block; width: 100px; height: 30px; margin-left: 20px; }
(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: { '@mescius/spread-sheets': 'npm:@mescius/spread-sheets/index.js', '@mescius/spread-sheets-resources-ko': 'npm:@mescius/spread-sheets-resources-ko/index.js', '@mescius/spread-sheets-react': 'npm:@mescius/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);