The sheet's frozen rows and columns prevent rows and columns from scrolling in the sheet's viewport area using a frozen line divider. The frozen lines also divide the viewport into several row and column viewports.
You can set at most four different frozen lines in a sheet. Doing so will divide the current viewport into three row viewports and three column viewports. The following code creates four frozen lines in a sheet:
For frozen row and column, spreadJS provides a param to control the frozenRows display from top row, instead of display from row 0 by default, and the frozenColumns display from left column, instead of display from column 0 by default.
For frozen trailing row and column, spreadJS provides a param to control whether the frozenTrailingRows always at the bottom of viewport and whether the frozenTrailingColumns always at the right of viewport. When the param stickToEdge is false, the trailing rows will scroll following viewport unless the data rows have part rows display incompletely. Otherwise by default, the trailing rows always prevent rows from scrolling in the viewport area and it will always at the bottom of viewport. Same to trailing columns. The usage as shown in the following code:
You can customize the frozenLine's color, as shown in the following code:
SpreadJS provides methods for you to get the information for each viewport, such as the width, height, topRow, and so on.
Supposing you have set a frozen row line and a frozen column line in a sheet. The original viewport has been divided into three row viewports, and the viewport indexes are 0, 1, and 2. You could then use the following code to get the information for the second viewport:
import * as React from 'react';
import { createRoot } from 'react-dom/client';
import './styles.css';
import { AppFunc } from './app-func';
import { App } from './app-class';
// 1. Functional Component sample
createRoot(document.getElementById('app')).render(<AppFunc />);
// 2. Class Component sample
// createRoot(document.getElementById('app')).render(<App />);
import * as React from 'react';
import { SpreadSheets, Worksheet } from '@mescius/spread-sheets-react';
import { getData } from './data';
import './styles.css';
const useState = React.useState;
export function AppFunc() {
const [spread, setSpread] = useState(null);
const [state, setState] = useState({
rowCount: 4,
topRow: 0,
columnCount: 3,
leftColumn: 0,
trailingRowCount: 1,
rowStickToEdge: false,
trailingColumnCount: 0,
columnStickToEdge: true
});
const initSpread = (spread) => {
setSpread(spread);
spread.suspendPaint();
spread.fromJSON(getData()[0]);
let sheet = spread.getSheet(0);
sheet.setRowCount(100);
sheet.frozenRowCount(4);
sheet.frozenColumnCount(3);
sheet.frozenTrailingRowCount(1, false);
sheet.frozenTrailingColumnCount(1, false);
sheet.options.gridline.showHorizontalGridline = false;
sheet.options.gridline.showVerticalGridline = false;
sheet.options.frozenlineColor = 'rgb(247, 167, 17)';
spread.resumePaint();
}
const setRowCount = (value) => {
setState(state => ({ ...state, ...{ rowCount: value } }));
}
const setTopRow = (value) => {
setState(state => ({ ...state, ...{ topRow: value } }));
}
const setColumnCount = (value) => {
setState(state => ({ ...state, ...{ columnCount: value } }));
}
const setLeftColumn = (value) => {
setState(state => ({ ...state, ...{ leftColumn: value } }));
}
const setTrailingRowCount = (value) => {
setState(state => ({ ...state, ...{ trailingRowCount: value } }));
}
const setTrailingColumnCount = (value) => {
setState(state => ({ ...state, ...{ trailingColumnCount: value } }));
}
const setRowStickToEdge = (value) => {
setState(state => ({ ...state, ...{ rowStickToEdge: value } }));
}
const setColumnStickToEdge = (value) => {
setState(state => ({ ...state, ...{ columnStickToEdge: value } }));
}
const setFrozenLine = () => {
const sheet = spread.getActiveSheet();
const { rowCount, columnCount, topRow, leftColumn, trailingRowCount, rowStickToEdge, trailingColumnCount, columnStickToEdge } = state;
if (rowCount) {
sheet.frozenRowCount(parseInt(rowCount), parseInt(topRow));
}
if (trailingRowCount) {
sheet.frozenTrailingRowCount(parseInt(trailingRowCount), rowStickToEdge);
}
if (columnCount) {
sheet.frozenColumnCount(parseInt(columnCount), parseInt(leftColumn));
}
if (trailingColumnCount) {
sheet.frozenTrailingColumnCount(parseInt(trailingColumnCount), columnStickToEdge);
}
}
return (
<div class="sample-tutorial">
<div class="sample-spreadsheets">
<SpreadSheets workbookInitialized={spread => initSpread(spread)}>
<Worksheet>
</Worksheet>
</SpreadSheets>
</div>
<Panel
setting={state}
setRowCount={(value) => setRowCount(value)}
setTopRow={(value) => setTopRow(value)}
setColumnCount={(value) => setColumnCount(value)}
setLeftColumn={(value) => setLeftColumn(value)}
setTrailingRowCount={(value) => setTrailingRowCount(value)}
setTrailingColumnCount={(value) => setTrailingColumnCount(value)}
setRowStickToEdge={(value) => setRowStickToEdge(value)}
setColumnStickToEdge={(value) => setColumnStickToEdge(value)}
setFrozenLine={() => setFrozenLine()}
></Panel>
</div>
);
}
function TextInput(props) {
const [value, setValue] = useState(props.value);
return (
<input type="text" id={props.id} value={value} onChange={(e) => {
setValue(e.target.value);
props.onChange(e)
}} />
);
}
function Panel (props) {
return (
<div class="options-container">
<div className="option-row">
<label class="option-label" htmlFor="rowCount">FrozenRowCount</label>
<TextInput id="rowCount" value={props.setting.rowCount} onChange={(e) => {
props.setRowCount(e.target.value);
}}></TextInput>
<label class="option-label" for="topRow">FrozenTopRow:</label>
<TextInput id="topRow" value={props.setting.topRow} onChange={(e) => {
props.setTopRow(e.target.value);
}}></TextInput>
</div>
<div className="option-row">
<label class="option-label" htmlFor="columnCount">FrozenColumnCount</label>
<TextInput id="columnCount" value={props.setting.columnCount} onChange={(e) => {
props.setColumnCount(e.target.value);
}}></TextInput>
<label class="option-label" for="leftColumn">FrozenLeftColumn:</label>
<TextInput id="leftColumn" value={props.setting.leftColumn} onChange={(e) => {
props.setLeftColumn(e.target.value);
}}></TextInput>
</div>
<div className="option-row">
<label class="option-label" htmlFor="trailingRowCount">TrailingFrozenRowCount</label>
<TextInput id="trailingRowCount" value={props.setting.trailingRowCount} onChange={(e) => {
props.setTrailingRowCount(e.target.value);
}}></TextInput>
<div>
<input type="checkbox" id="rowStickToEdge" checked={props.setting.rowStickToEdge}
onChange={(e) => { props.setRowStickToEdge(e.target.checked); }} />
<label for="rowStickToEdge">Stick to Edge</label>
</div>
</div>
<div className="option-row">
<label class="option-label" htmlFor="trailingColumnCount">TrailingFrozenColumnCount</label>
<TextInput id="trailingColumnCount" value={props.setting.trailingColumnCount} onChange={(e) => {
props.setTrailingColumnCount(e.target.value);
}}></TextInput>
<div>
<input type="checkbox" id="columnStickToEdge" checked={props.setting.columnStickToEdge}
onChange={(e) => { props.setColumnStickToEdge(e.target.checked); }} />
<label for="columnStickToEdge">Stick to Edge</label>
</div>
</div>
<div className="option-row">
<input type="button" value="Set" onClick={() => {
props.setFrozenLine();
}} />
</div>
</div>
);
}
import * as React from 'react';
import {SpreadSheets, Worksheet} from '@mescius/spread-sheets-react';
import { getData } from './data';
import './styles.css';
const Component = React.Component, useState = React.useState;
export class App extends Component {
constructor(props) {
super(props);
this.spread = null;
this.state = {
rowCount: 4,
topRow: 0,
columnCount: 3,
leftColumn: 0,
trailingRowCount: 1,
rowStickToEdge: false,
trailingColumnCount: 0,
columnStickToEdge: true
};
}
render() {
return (
<div class="sample-tutorial">
<div class="sample-spreadsheets">
<SpreadSheets workbookInitialized={spread => this.initSpread(spread)}>
<Worksheet>
</Worksheet>
</SpreadSheets>
</div>
<Panel
setting={this.state}
setRowCount={(value) => this.setRowCount(value)}
setTopRow={(value) => this.setTopRow(value)}
setColumnCount={(value) => this.setColumnCount(value)}
setLeftColumn={(value) => this.setLeftColumn(value)}
setTrailingRowCount={(value) => this.setTrailingRowCount(value)}
setTrailingColumnCount={(value) => this.setTrailingColumnCount(value)}
setRowStickToEdge={(value) => this.setRowStickToEdge(value)}
setColumnStickToEdge={(value) => this.setColumnStickToEdge(value)}
setFrozenLine={() => this.setFrozenLine()}
></Panel>
</div>
);
}
initSpread(spread) {
this.spread = spread;
spread.suspendPaint();
spread.fromJSON(getData()[0]);
let sheet = spread.getSheet(0);
sheet.setRowCount(100);
sheet.frozenRowCount(4);
sheet.frozenColumnCount(3);
sheet.frozenTrailingRowCount(1, false);
sheet.frozenTrailingColumnCount(1, false);
sheet.options.gridline.showHorizontalGridline = false;
sheet.options.gridline.showVerticalGridline = false;
sheet.options.frozenlineColor = 'rgb(247, 167, 17)';
spread.resumePaint();
}
setRowCount(value) {
this.setState({ rowCount: value });
}
setTopRow(value) {
this.setState({ topRow: value });
}
setColumnCount(value) {
this.setState({ columnCount: value });
}
setLeftColumn(value) {
this.setState({ leftColumn: value });
}
setTrailingRowCount(value) {
this.setState({ trailingRowCount: value });
}
setTrailingColumnCount(value) {
this.setState({ trailingColumnCount: value });
}
setRowStickToEdge(value) {
this.setState({ rowStickToEdge: value });
}
setColumnStickToEdge(value) {
this.setState({ columnStickToEdge: value });
}
setFrozenLine() {
let spread = this.spread, sheet = spread.getActiveSheet();
let { rowCount, columnCount, topRow, leftColumn, trailingRowCount, rowStickToEdge, trailingColumnCount, columnStickToEdge } = this.state;
if (rowCount) {
sheet.frozenRowCount(parseInt(rowCount), parseInt(topRow));
}
if (trailingRowCount) {
sheet.frozenTrailingRowCount(parseInt(trailingRowCount), rowStickToEdge);
}
if (columnCount) {
sheet.frozenColumnCount(parseInt(columnCount), parseInt(leftColumn));
}
if (trailingColumnCount) {
sheet.frozenTrailingColumnCount(parseInt(trailingColumnCount), columnStickToEdge);
}
}
}
function TextInput(props) {
const [value, setValue] = useState(props.value);
return (
<input type="text" id={props.id} value={value} onChange={(e) => {
setValue(e.target.value);
props.onChange(e)
}}/>
);
}
class Panel extends Component {
constructor(props) {
super(props);
}
render() {
return (
<div class="options-container">
<div className="option-row">
<label class="option-label" htmlFor="rowCount">FrozenRowCount</label>
<TextInput id="rowCount" value={this.props.setting.rowCount} onChange={(e) => {
this.props.setRowCount(e.target.value);
}}></TextInput>
<label class="option-label" for="topRow">FrozenTopRow:</label>
<TextInput id="topRow" value={this.props.setting.topRow} onChange={(e) => {
this.props.setTopRow(e.target.value);
}}></TextInput>
</div>
<div className="option-row">
<label class="option-label" htmlFor="columnCount">FrozenColumnCount</label>
<TextInput id="columnCount" value={this.props.setting.columnCount} onChange={(e) => {
this.props.setColumnCount(e.target.value);
}}></TextInput>
<label class="option-label" for="leftColumn">FrozenLeftColumn:</label>
<TextInput id="leftColumn" value={this.props.setting.leftColumn} onChange={(e) => {
this.props.setLeftColumn(e.target.value);
}}></TextInput>
</div>
<div className="option-row">
<label class="option-label" htmlFor="trailingRowCount">TrailingFrozenRowCount</label>
<TextInput id="trailingRowCount" value={this.props.setting.trailingRowCount} onChange={(e) => {
this.props.setTrailingRowCount(e.target.value);
}}></TextInput>
<div>
<input type="checkbox" id="rowStickToEdge" checked={this.props.setting.rowStickToEdge}
onChange={ (e) => { this.props.setRowStickToEdge(e.target.checked); } } />
<label for="rowStickToEdge">Stick to Edge</label>
</div>
</div>
<div className="option-row">
<label class="option-label" htmlFor="trailingColumnCount">TrailingFrozenColumnCount</label>
<TextInput id="trailingColumnCount" value={this.props.setting.trailingColumnCount} onChange={(e) => {
this.props.setTrailingColumnCount(e.target.value);
}}></TextInput>
<div>
<input type="checkbox" id="columnStickToEdge" checked={this.props.setting.columnStickToEdge}
onChange={ (e) => { this.props.setColumnStickToEdge(e.target.checked); } } />
<label for="columnStickToEdge">Stick to Edge</label>
</div>
</div>
<div className="option-row">
<input type="button" value="Set" onClick={() => {
this.props.setFrozenLine();
}}/>
</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$/en/react/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css">
<script src="$DEMOROOT$/spread/source/data/data.js" type="text/javascript"></script>
<!-- SystemJS -->
<script src="$DEMOROOT$/en/react/node_modules/systemjs/dist/system.src.js"></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: 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;
}
.option-label {
display: block;
margin-bottom: 6px;
}
input {
padding: 4px 6px;
}
input[type=button] {
margin-top: 6px;
display: block;
width:200px;
}
input[type="text"] {
width: 200px;
box-sizing: border-box;
}
body {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
}
#app {
height: 100%;
}
export function getData(){
var data = [{
"version": "14.0.5",
"sheetCount": 1,
"tabStripRatio": 0.6,
"customList": [],
"activeSheetIndex": 0,
"sheets": {
"Sheet1": {
"name": "Sheet1",
"isSelected": true,
"rowCount": 33,
"columnCount": 11,
"activeRow": 5,
"activeCol": 3,
"theme": {
"name": "Office",
"themeColor": {
"name": "Office",
"background1": {
"a": 255,
"r": 255,
"g": 255,
"b": 255
},
"background2": {
"a": 255,
"r": 231,
"g": 230,
"b": 230
},
"text1": {
"a": 255,
"r": 0,
"g": 0,
"b": 0
},
"text2": {
"a": 255,
"r": 68,
"g": 84,
"b": 106
},
"accent1": {
"a": 255,
"r": 68,
"g": 114,
"b": 196
},
"accent2": {
"a": 255,
"r": 237,
"g": 125,
"b": 49
},
"accent3": {
"a": 255,
"r": 165,
"g": 165,
"b": 165
},
"accent4": {
"a": 255,
"r": 255,
"g": 192,
"b": 0
},
"accent5": {
"a": 255,
"r": 91,
"g": 155,
"b": 213
},
"accent6": {
"a": 255,
"r": 112,
"g": 173,
"b": 71
},
"hyperlink": {
"a": 255,
"r": 5,
"g": 99,
"b": 193
},
"followedHyperlink": {
"a": 255,
"r": 149,
"g": 79,
"b": 114
}
},
"headingFont": "Calibri Light",
"bodyFont": "Calibri"
},
"data": {
"dataTable": {
"2": {
"2": {
"value": "Weather Card",
"style": "__builtInStyle17"
},
"3": {
"style": "__builtInStyle17"
},
"4": {
"style": "__builtInStyle17"
},
"5": {
"style": "__builtInStyle17"
},
"6": {
"style": "__builtInStyle17"
},
"7": {
"style": "__builtInStyle17"
},
"8": {
"style": "__builtInStyle17"
},
"9": {
"style": "__builtInStyle17"
},
"10": {
"style": "__builtInStyle17"
}
},
"3": {
"2": {
"value": "Date",
"style": "__builtInStyle5"
},
"3": {
"value": "Max Temperature (F)",
"style": "__builtInStyle10"
},
"4": {
"value": "Min Temperature (F)",
"style": "__builtInStyle2"
},
"5": {
"value": "Precipitation",
"style": "__builtInStyle2"
},
"6": {
"value": "Cloud Cover",
"style": "__builtInStyle2"
},
"7": {
"value": "Visiblity (miles)",
"style": "__builtInStyle2"
},
"8": {
"value": "Wind (mph)",
"style": "__builtInStyle2"
},
"9": {
"value": "Humidity",
"style": "__builtInStyle2"
},
"10": {
"value": "Forecast",
"style": "__builtInStyle2"
}
},
"4": {
"2": {
"value": "/OADate(44228)/",
"style": "__builtInStyle6"
},
"3": {
"value": 19,
"style": "__builtInStyle12"
},
"4": {
"value": 19,
"style": "__builtInStyle12"
},
"5": {
"value": 0.8,
"style": "__builtInStyle14"
},
"6": {
"value": 1,
"style": "__builtInStyle16"
},
"7": {
"value": 10,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.76,
"style": "__builtInStyle14"
},
"10": {
"value": "Rainy",
"style": "__builtInStyle3"
}
},
"5": {
"2": {
"value": "/OADate(44229)/",
"style": "__builtInStyle6"
},
"3": {
"value": 23,
"style": "__builtInStyle12"
},
"4": {
"value": 15,
"style": "__builtInStyle12"
},
"5": {
"value": 0.2,
"style": "__builtInStyle14"
},
"6": {
"value": 0.98,
"style": "__builtInStyle16"
},
"7": {
"value": 13,
"style": "__builtInStyle8"
},
"8": {
"value": 19,
"style": "__builtInStyle8"
},
"9": {
"value": 0.62,
"style": "__builtInStyle14"
},
"10": {
"value": "Mostly Cloudy",
"style": "__builtInStyle3"
}
},
"6": {
"2": {
"value": "/OADate(44230)/",
"style": "__builtInStyle6"
},
"3": {
"value": 24,
"style": "__builtInStyle12"
},
"4": {
"value": 14,
"style": "__builtInStyle12"
},
"5": {
"value": 0.9,
"style": "__builtInStyle14"
},
"6": {
"value": 0.99,
"style": "__builtInStyle16"
},
"7": {
"value": 12,
"style": "__builtInStyle8"
},
"8": {
"value": 14,
"style": "__builtInStyle8"
},
"9": {
"value": 0.77,
"style": "__builtInStyle14"
},
"10": {
"value": "Thunderstorm",
"style": "__builtInStyle3"
}
},
"7": {
"2": {
"value": "/OADate(44231)/",
"style": "__builtInStyle6"
},
"3": {
"value": 24,
"style": "__builtInStyle12"
},
"4": {
"value": 14,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.74,
"style": "__builtInStyle16"
},
"7": {
"value": 14,
"style": "__builtInStyle8"
},
"8": {
"value": 26,
"style": "__builtInStyle8"
},
"9": {
"value": 0.56,
"style": "__builtInStyle14"
},
"10": {
"value": "Partly Cloudy",
"style": "__builtInStyle3"
}
},
"8": {
"2": {
"value": "/OADate(44232)/",
"style": "__builtInStyle6"
},
"3": {
"value": 27,
"style": "__builtInStyle12"
},
"4": {
"value": 17,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.82,
"style": "__builtInStyle16"
},
"7": {
"value": 12,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.57,
"style": "__builtInStyle14"
},
"10": {
"value": "Partly Cloudy",
"style": "__builtInStyle3"
}
},
"9": {
"2": {
"value": "/OADate(44233)/",
"style": "__builtInStyle6"
},
"3": {
"value": 27,
"style": "__builtInStyle12"
},
"4": {
"value": 19,
"style": "__builtInStyle12"
},
"5": {
"value": 0.2,
"style": "__builtInStyle14"
},
"6": {
"value": 0.88,
"style": "__builtInStyle16"
},
"7": {
"value": 9,
"style": "__builtInStyle8"
},
"8": {
"value": 16,
"style": "__builtInStyle8"
},
"9": {
"value": 0.71,
"style": "__builtInStyle14"
},
"10": {
"value": "Cloudy",
"style": "__builtInStyle3"
}
},
"10": {
"2": {
"value": "/OADate(44234)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 18,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.82,
"style": "__builtInStyle16"
},
"7": {
"value": 12,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.57,
"style": "__builtInStyle14"
},
"10": {
"value": "Most Sunny",
"style": "__builtInStyle3"
}
},
"11": {
"2": {
"value": "/OADate(44235)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 17,
"style": "__builtInStyle12"
},
"5": {
"value": 0,
"style": "__builtInStyle14"
},
"6": {
"value": 0.01,
"style": "__builtInStyle16"
},
"7": {
"value": 18,
"style": "__builtInStyle8"
},
"8": {
"value": 19,
"style": "__builtInStyle8"
},
"9": {
"value": 0.53,
"style": "__builtInStyle14"
},
"10": {
"value": "Most Sunny",
"style": "__builtInStyle3"
}
},
"12": {
"2": {
"value": "/OADate(44236)/",
"style": "__builtInStyle6"
},
"3": {
"value": 29,
"style": "__builtInStyle12"
},
"4": {
"value": 21,
"style": "__builtInStyle12"
},
"5": {
"value": 0,
"style": "__builtInStyle14"
},
"6": {
"value": 0.01,
"style": "__builtInStyle16"
},
"7": {
"value": 19,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.59,
"style": "__builtInStyle14"
},
"10": {
"value": "Sunny",
"style": "__builtInStyle3"
}
},
"13": {
"2": {
"value": "/OADate(44237)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 17,
"style": "__builtInStyle12"
},
"5": {
"value": 0,
"style": "__builtInStyle14"
},
"6": {
"value": 0.01,
"style": "__builtInStyle16"
},
"7": {
"value": 18,
"style": "__builtInStyle8"
},
"8": {
"value": 19,
"style": "__builtInStyle8"
},
"9": {
"value": 0.53,
"style": "__builtInStyle14"
},
"10": {
"value": "Most Sunny",
"style": "__builtInStyle3"
}
},
"14": {
"2": {
"value": "/OADate(44238)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 19,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.63,
"style": "__builtInStyle16"
},
"7": {
"value": 13,
"style": "__builtInStyle8"
},
"8": {
"value": 15,
"style": "__builtInStyle8"
},
"9": {
"value": 0.6,
"style": "__builtInStyle14"
},
"10": {
"value": "Cloudy",
"style": "__builtInStyle3"
}
},
"15": {
"2": {
"value": "/OADate(44239)/",
"style": "__builtInStyle6"
},
"3": {
"value": 24,
"style": "__builtInStyle12"
},
"4": {
"value": 18,
"style": "__builtInStyle12"
},
"5": {
"value": 0.4,
"style": "__builtInStyle14"
},
"6": {
"value": 0.79,
"style": "__builtInStyle16"
},
"7": {
"value": 15,
"style": "__builtInStyle8"
},
"8": {
"value": 17,
"style": "__builtInStyle8"
},
"9": {
"value": 0.66,
"style": "__builtInStyle14"
},
"10": {
"value": "Partly Cloudy",
"style": "__builtInStyle3"
}
},
"16": {
"2": {
"value": "/OADate(44240)/",
"style": "__builtInStyle6"
},
"3": {
"value": 25,
"style": "__builtInStyle12"
},
"4": {
"value": 16,
"style": "__builtInStyle12"
},
"5": {
"value": 0.7,
"style": "__builtInStyle14"
},
"6": {
"value": 0.99,
"style": "__builtInStyle16"
},
"7": {
"value": 13,
"style": "__builtInStyle8"
},
"8": {
"value": 14,
"style": "__builtInStyle8"
},
"9": {
"value": 0.72,
"style": "__builtInStyle14"
},
"10": {
"value": "Rainy",
"style": "__builtInStyle3"
}
},
"17": {
"2": {
"value": "/OADate(44241)/",
"style": "__builtInStyle6"
},
"3": {
"value": 27,
"style": "__builtInStyle12"
},
"4": {
"value": 17,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.93,
"style": "__builtInStyle16"
},
"7": {
"value": 12,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.57,
"style": "__builtInStyle14"
},
"10": {
"value": "Partly Cloudy",
"style": "__builtInStyle3"
}
},
"18": {
"2": {
"value": "/OADate(44242)/",
"style": "__builtInStyle6"
},
"3": {
"value": 27,
"style": "__builtInStyle12"
},
"4": {
"value": 19,
"style": "__builtInStyle12"
},
"5": {
"value": 0.2,
"style": "__builtInStyle14"
},
"6": {
"value": 0.69,
"style": "__builtInStyle16"
},
"7": {
"value": 14,
"style": "__builtInStyle8"
},
"8": {
"value": 16,
"style": "__builtInStyle8"
},
"9": {
"value": 0.71,
"style": "__builtInStyle14"
},
"10": {
"value": "Cloudy",
"style": "__builtInStyle3"
}
},
"19": {
"2": {
"value": "/OADate(44243)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 18,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.04,
"style": "__builtInStyle16"
},
"7": {
"value": 20,
"style": "__builtInStyle8"
},
"8": {
"value": 18,
"style": "__builtInStyle8"
},
"9": {
"value": 0.6,
"style": "__builtInStyle14"
},
"10": {
"value": "Most Sunny",
"style": "__builtInStyle3"
}
},
"20": {
"2": {
"value": "/OADate(44244)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 17,
"style": "__builtInStyle12"
},
"5": {
"value": 0,
"style": "__builtInStyle14"
},
"6": {
"value": 0.05,
"style": "__builtInStyle16"
},
"7": {
"value": 20,
"style": "__builtInStyle8"
},
"8": {
"value": 19,
"style": "__builtInStyle8"
},
"9": {
"value": 0.53,
"style": "__builtInStyle14"
},
"10": {
"value": "Most Sunny",
"style": "__builtInStyle3"
}
},
"21": {
"2": {
"value": "/OADate(44245)/",
"style": "__builtInStyle6"
},
"3": {
"value": 29,
"style": "__builtInStyle12"
},
"4": {
"value": 21,
"style": "__builtInStyle12"
},
"5": {
"value": 0,
"style": "__builtInStyle14"
},
"6": {
"value": 0,
"style": "__builtInStyle16"
},
"7": {
"value": 21,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.59,
"style": "__builtInStyle14"
},
"10": {
"value": "Sunny",
"style": "__builtInStyle3"
}
},
"22": {
"2": {
"value": "/OADate(44246)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 19,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.56,
"style": "__builtInStyle16"
},
"7": {
"value": 10,
"style": "__builtInStyle8"
},
"8": {
"value": 15,
"style": "__builtInStyle8"
},
"9": {
"value": 0.6,
"style": "__builtInStyle14"
},
"10": {
"value": "Cloudy",
"style": "__builtInStyle3"
}
},
"23": {
"2": {
"value": "/OADate(44247)/",
"style": "__builtInStyle6"
},
"3": {
"value": 24,
"style": "__builtInStyle12"
},
"4": {
"value": 18,
"style": "__builtInStyle12"
},
"5": {
"value": 0.4,
"style": "__builtInStyle14"
},
"6": {
"value": 0.78,
"style": "__builtInStyle16"
},
"7": {
"value": 12,
"style": "__builtInStyle8"
},
"8": {
"value": 17,
"style": "__builtInStyle8"
},
"9": {
"value": 0.66,
"style": "__builtInStyle14"
},
"10": {
"value": "Partly Cloudy",
"style": "__builtInStyle3"
}
},
"24": {
"2": {
"value": "/OADate(44248)/",
"style": "__builtInStyle6"
},
"3": {
"value": 25,
"style": "__builtInStyle12"
},
"4": {
"value": 16,
"style": "__builtInStyle12"
},
"5": {
"value": 0.7,
"style": "__builtInStyle14"
},
"6": {
"value": 0.99,
"style": "__builtInStyle16"
},
"7": {
"value": 13,
"style": "__builtInStyle8"
},
"8": {
"value": 14,
"style": "__builtInStyle8"
},
"9": {
"value": 0.72,
"style": "__builtInStyle14"
},
"10": {
"value": "Rainy",
"style": "__builtInStyle3"
}
},
"25": {
"2": {
"value": "/OADate(44249)/",
"style": "__builtInStyle6"
},
"3": {
"value": 27,
"style": "__builtInStyle12"
},
"4": {
"value": 17,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.93,
"style": "__builtInStyle16"
},
"7": {
"value": 12,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.57,
"style": "__builtInStyle14"
},
"10": {
"value": "Partly Cloudy",
"style": "__builtInStyle3"
}
},
"26": {
"2": {
"value": "/OADate(44250)/",
"style": "__builtInStyle6"
},
"3": {
"value": 27,
"style": "__builtInStyle12"
},
"4": {
"value": 19,
"style": "__builtInStyle12"
},
"5": {
"value": 0.2,
"style": "__builtInStyle14"
},
"6": {
"value": 0.69,
"style": "__builtInStyle16"
},
"7": {
"value": 14,
"style": "__builtInStyle8"
},
"8": {
"value": 16,
"style": "__builtInStyle8"
},
"9": {
"value": 0.71,
"style": "__builtInStyle14"
},
"10": {
"value": "Cloudy",
"style": "__builtInStyle3"
}
},
"27": {
"2": {
"value": "/OADate(44251)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 18,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.04,
"style": "__builtInStyle16"
},
"7": {
"value": 20,
"style": "__builtInStyle8"
},
"8": {
"value": 18,
"style": "__builtInStyle8"
},
"9": {
"value": 0.6,
"style": "__builtInStyle14"
},
"10": {
"value": "Most Sunny",
"style": "__builtInStyle3"
}
},
"28": {
"2": {
"value": "/OADate(44252)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 17,
"style": "__builtInStyle12"
},
"5": {
"value": 0,
"style": "__builtInStyle14"
},
"6": {
"value": 0.05,
"style": "__builtInStyle16"
},
"7": {
"value": 20,
"style": "__builtInStyle8"
},
"8": {
"value": 19,
"style": "__builtInStyle8"
},
"9": {
"value": 0.53,
"style": "__builtInStyle14"
},
"10": {
"value": "Most Sunny",
"style": "__builtInStyle3"
}
},
"29": {
"2": {
"value": "/OADate(44253)/",
"style": "__builtInStyle6"
},
"3": {
"value": 29,
"style": "__builtInStyle12"
},
"4": {
"value": 21,
"style": "__builtInStyle12"
},
"5": {
"value": 0,
"style": "__builtInStyle14"
},
"6": {
"value": 0,
"style": "__builtInStyle16"
},
"7": {
"value": 21,
"style": "__builtInStyle8"
},
"8": {
"value": 11,
"style": "__builtInStyle8"
},
"9": {
"value": 0.59,
"style": "__builtInStyle14"
},
"10": {
"value": "Sunny",
"style": "__builtInStyle3"
}
},
"30": {
"2": {
"value": "/OADate(44254)/",
"style": "__builtInStyle6"
},
"3": {
"value": 28,
"style": "__builtInStyle12"
},
"4": {
"value": 19,
"style": "__builtInStyle12"
},
"5": {
"value": 0.1,
"style": "__builtInStyle14"
},
"6": {
"value": 0.56,
"style": "__builtInStyle16"
},
"7": {
"value": 10,
"style": "__builtInStyle8"
},
"8": {
"value": 15,
"style": "__builtInStyle8"
},
"9": {
"value": 0.6,
"style": "__builtInStyle14"
},
"10": {
"value": "Cloudy",
"style": "__builtInStyle3"
}
},
"31": {
"2": {
"value": "/OADate(44255)/",
"style": "__builtInStyle6"
},
"3": {
"value": 24,
"style": "__builtInStyle12"
},
"4": {
"value": 18,
"style": "__builtInStyle12"
},
"5": {
"value": 0.4,
"style": "__builtInStyle14"
},
"6": {
"value": 0.78,
"style": "__builtInStyle16"
},
"7": {
"value": 12,
"style": "__builtInStyle8"
},
"8": {
"value": 17,
"style": "__builtInStyle8"
},
"9": {
"value": 0.66,
"style": "__builtInStyle14"
},
"10": {
"value": "Partly Cloudy",
"style": "__builtInStyle3"
}
},
"32": {
"2": {
"value": "Average",
"style": "__builtInStyle5"
},
"3": {
"value": 26.4642857142857,
"style": "__builtInStyle13",
"formula": "AVERAGE(D5:D32)"
},
"4": {
"value": 17.7857142857143,
"style": "__builtInStyle13",
"formula": "AVERAGE(E5:E32)"
},
"5": {
"value": 0.217857142857143,
"style": "__builtInStyle15",
"formula": "AVERAGE(F5:F32)"
},
"6": {
"value": 0.562857142857143,
"style": "__builtInStyle15",
"formula": "AVERAGE(G5:G32)"
},
"7": {
"value": 14.6071428571429,
"style": "__builtInStyle9",
"formula": "AVERAGE(H5:H32)"
},
"8": {
"value": 15.3928571428571,
"style": "__builtInStyle9",
"formula": "AVERAGE(I5:I32)"
},
"9": {
"value": 0.6225,
"style": "__builtInStyle15",
"formula": "AVERAGE(J5:J32)"
},
"10": {
"style": "__builtInStyle4"
}
}
},
"columnDataArray": [null, null, {
"style": "__builtInStyle7"
}, {
"style": "__builtInStyle11"
}],
"defaultDataNode": {
"style": {
"backColor": null,
"foreColor": "Text 1 0",
"vAlign": 2,
"font": "normal normal 16px Calibri",
"themeFont": "Body",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": false,
"diagonalDown": null,
"diagonalUp": null
}
}
},
"rowHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"colHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"rows": [null, null, {
"size": 35
}, {
"size": 21
}, {
"size": 21
}, {
"size": 26
}, {
"size": 23
}, {
"size": 21
}, {
"size": 22
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 17
}, {
"size": 21
}, {
"size": 22
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}, {
"size": 21
}],
"columns": [null, null, {
"size": 132
}, {
"size": 133
}, {
"size": 126
}, {
"size": 122
}, {
"size": 111
}, {
"size": 126
}, {
"size": 141
}, {
"size": 116
}, {
"size": 184
}],
"leftCellIndex": 0,
"topCellIndex": 0,
"spans": [{
"row": 2,
"rowCount": 1,
"col": 2,
"colCount": 9
}],
"selections": {
"0": {
"row": 5,
"rowCount": 1,
"col": 3,
"colCount": 1
},
"length": 1
},
"defaults": {
"colHeaderRowHeight": 20,
"colWidth": 20,
"rowHeaderColWidth": 40,
"rowHeight": 20.8,
"_isExcelDefaultColumnWidth": true
},
"rowOutlines": {
"items": []
},
"columnOutlines": {
"items": []
},
"cellStates": {},
"outlineColumnOptions": {},
"autoMergeRangeInfos": [],
"index": 0
}
},
"namedStyles": [{
"backColor": "Accent 1 80",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "20% - Accent1"
}, {
"backColor": "Accent 2 80",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "20% - Accent2"
}, {
"backColor": "Accent 3 80",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "20% - Accent3"
}, {
"backColor": "Accent 4 80",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "20% - Accent4"
}, {
"backColor": "Accent 5 80",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "20% - Accent5"
}, {
"backColor": "Accent 6 80",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "20% - Accent6"
}, {
"backColor": "Accent 1 60",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "40% - Accent1"
}, {
"backColor": "Accent 2 60",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "40% - Accent2"
}, {
"backColor": "Accent 3 60",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "40% - Accent3"
}, {
"backColor": "Accent 4 60",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "40% - Accent4"
}, {
"backColor": "Accent 5 60",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "40% - Accent5"
}, {
"backColor": "Accent 6 60",
"foreColor": "Text 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "40% - Accent6"
}, {
"backColor": "Accent 1 40",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "60% - Accent1"
}, {
"backColor": "Accent 2 40",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "60% - Accent2"
}, {
"backColor": "Accent 3 40",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "60% - Accent3"
}, {
"backColor": "Accent 4 40",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "60% - Accent4"
}, {
"backColor": "Accent 5 40",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "60% - Accent5"
}, {
"backColor": "Accent 6 40",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "60% - Accent6"
}, {
"backColor": "Accent 1 0",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Accent1"
}, {
"backColor": "Accent 2 0",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Accent2"
}, {
"backColor": "Accent 3 0",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Accent3"
}, {
"backColor": "Accent 4 0",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Accent4"
}, {
"backColor": "Accent 5 0",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Accent5"
}, {
"backColor": "Accent 6 0",
"foreColor": "Background 1 0",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Accent6"
}, {
"backColor": "#ffc7ce",
"foreColor": "#9c0006",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Bad"
}, {
"backColor": "#f2f2f2",
"foreColor": "#fa7d00",
"font": "normal bold 14.7px Calibri",
"themeFont": "Body",
"borderLeft": {
"color": "#7f7f7f",
"style": 1
},
"borderTop": {
"color": "#7f7f7f",
"style": 1
},
"borderRight": {
"color": "#7f7f7f",
"style": 1
},
"borderBottom": {
"color": "#7f7f7f",
"style": 1
},
"name": "Calculation",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "#a5a5a5",
"foreColor": "Background 1 0",
"font": "normal bold 14.7px Calibri",
"themeFont": "Body",
"borderLeft": {
"color": "#3f3f3f",
"style": 6
},
"borderTop": {
"color": "#3f3f3f",
"style": 6
},
"borderRight": {
"color": "#3f3f3f",
"style": 6
},
"borderBottom": {
"color": "#3f3f3f",
"style": 6
},
"name": "Check Cell",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"formatter": "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)",
"name": "Comma"
}, {
"backColor": null,
"formatter": "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)",
"name": "Comma [0]"
}, {
"backColor": null,
"formatter": "_(\"$\"* #,##0.00_);_(\"$\"* (#,##0.00);_(\"$\"* \"-\"??_);_(@_)",
"name": "Currency"
}, {
"backColor": null,
"formatter": "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)",
"name": "Currency [0]"
}, {
"backColor": null,
"foreColor": "#7f7f7f",
"font": "italic normal 14.7px Calibri",
"themeFont": "Body",
"name": "Explanatory Text"
}, {
"backColor": "#c6efce",
"foreColor": "#006100",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Good"
}, {
"backColor": null,
"foreColor": "Text 2 0",
"font": "normal bold 20px Calibri",
"themeFont": "Body",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": {
"color": "Accent 1 0",
"style": 5
},
"name": "Heading 1",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "Text 2 0",
"font": "normal bold 17.3px Calibri",
"themeFont": "Body",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": {
"color": "Accent 1 50",
"style": 5
},
"name": "Heading 2",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "Text 2 0",
"font": "normal bold 14.7px Calibri",
"themeFont": "Body",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": {
"color": "Accent 1 40",
"style": 2
},
"name": "Heading 3",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "Text 2 0",
"font": "normal bold 14.7px Calibri",
"themeFont": "Body",
"name": "Heading 4"
}, {
"backColor": "#ffcc99",
"foreColor": "#3f3f76",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"borderLeft": {
"color": "#7f7f7f",
"style": 1
},
"borderTop": {
"color": "#7f7f7f",
"style": 1
},
"borderRight": {
"color": "#7f7f7f",
"style": 1
},
"borderBottom": {
"color": "#7f7f7f",
"style": 1
},
"name": "Input",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "#fa7d00",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": {
"color": "#ff8001",
"style": 6
},
"name": "Linked Cell",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "#ffeb9c",
"foreColor": "#9c6500",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Neutral"
}, {
"backColor": null,
"foreColor": "Text 1 0",
"hAlign": 3,
"vAlign": 2,
"font": "normal normal 16px Calibri",
"themeFont": "Body",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": false,
"name": "Normal",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "#ffffcc",
"borderLeft": {
"color": "#b2b2b2",
"style": 1
},
"borderTop": {
"color": "#b2b2b2",
"style": 1
},
"borderRight": {
"color": "#b2b2b2",
"style": 1
},
"borderBottom": {
"color": "#b2b2b2",
"style": 1
},
"name": "Note",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "#f2f2f2",
"foreColor": "#3f3f3f",
"font": "normal bold 14.7px Calibri",
"themeFont": "Body",
"borderLeft": {
"color": "#3f3f3f",
"style": 1
},
"borderTop": {
"color": "#3f3f3f",
"style": 1
},
"borderRight": {
"color": "#3f3f3f",
"style": 1
},
"borderBottom": {
"color": "#3f3f3f",
"style": 1
},
"name": "Output",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"formatter": "0%",
"name": "Percent"
}, {
"backColor": null,
"foreColor": "Text 2 0",
"font": "normal bold 24px Calibri Light",
"themeFont": "Headings",
"name": "Title"
}, {
"backColor": null,
"foreColor": "Text 1 0",
"font": "normal bold 14.7px Calibri",
"themeFont": "Body",
"borderLeft": null,
"borderTop": {
"color": "Accent 1 0",
"style": 1
},
"borderRight": null,
"borderBottom": {
"color": "Accent 1 0",
"style": 6
},
"name": "Total",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "#ff0000",
"font": "normal normal 14.7px Calibri",
"themeFont": "Body",
"name": "Warning Text"
}, {
"backColor": null,
"foreColor": "Text 1 0",
"hAlign": 3,
"vAlign": 2,
"font": "normal normal 16px Calibri",
"themeFont": "Body",
"formatter": "General",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": false,
"name": "__builtInStyle1",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -15",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal bold 12px Calibri Light",
"formatter": "General",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle2",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -5",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal normal 12px Calibri",
"formatter": "General",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle3",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -15",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal normal 12px Calibri",
"formatter": "General",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle4",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -15",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal bold 12px Calibri",
"formatter": "yyyy\\-mm\\-dd;@",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle5",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -5",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal normal 12px Calibri",
"formatter": "yyyy\\-mm\\-dd;@",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle6",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "Text 1 0",
"hAlign": 3,
"vAlign": 2,
"font": "normal normal 16px Calibri",
"themeFont": "Body",
"formatter": "yyyy\\-mm\\-dd;@",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": false,
"name": "__builtInStyle7",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal normal 12px Calibri",
"formatter": "0",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle8",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -15",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal bold 12px Calibri",
"formatter": "0",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle9",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -15",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal bold 12px Calibri Light",
"formatter": "0",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle10",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "Text 1 0",
"hAlign": 3,
"vAlign": 2,
"font": "normal normal 16px Calibri",
"themeFont": "Body",
"formatter": "0",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": false,
"name": "__builtInStyle11",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal normal 12px Calibri",
"formatter": "0\\ \\F",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle12",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -15",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal bold 12px Calibri",
"formatter": "0\\ \\F",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle13",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal normal 12px Calibri",
"formatter": "0\\ %",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle14",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "Background 1 -15",
"foreColor": "#000000",
"hAlign": 1,
"vAlign": 1,
"font": "normal bold 12px Calibri",
"formatter": "0\\ %",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle15",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": null,
"foreColor": "Text 1 0",
"hAlign": 1,
"vAlign": 1,
"font": "normal normal 12px Calibri",
"themeFont": "Body",
"formatter": "0\\ %",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": false,
"name": "__builtInStyle16",
"diagonalDown": null,
"diagonalUp": null
}, {
"backColor": "#82bc00",
"foreColor": "#ffffff",
"hAlign": 1,
"vAlign": 1,
"font": "normal bold 21.3px Calibri",
"formatter": "General",
"borderLeft": null,
"borderTop": null,
"borderRight": null,
"borderBottom": null,
"locked": true,
"textIndent": 0,
"wordWrap": true,
"name": "__builtInStyle17",
"diagonalDown": null,
"diagonalUp": null
}]
}];
return data;
}
(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-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/cjs/react.production.js',
'react-dom': 'npm:react-dom/cjs/react-dom.production.js',
'react-dom/client': 'npm:react-dom/cjs/react-dom-client.production.js',
'scheduler': 'npm:scheduler/cjs/scheduler.production.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);
