import 'bootstrap.css';
import '@mescius/wijmo.styles/wijmo.css';
import ReactDOM from 'react-dom/client';
import React, { useRef, useState } from 'react';
import useEvent from 'react-use-event-hook';
import * as wijmo from '@mescius/wijmo';
import * as wjInput from '@mescius/wijmo.react.input';
import * as wjGridSheet from '@mescius/wijmo.react.grid.sheet';
import './app.css';
const fonts = [
{ name: 'Arial', value: 'Arial, Helvetica, sans-serif' },
{ name: 'Arial Black', value: '"Arial Black", Gadget, sans-serif' },
{ name: 'Comic Sans MS', value: '"Comic Sans MS", cursive, sans-serif' },
{ name: 'Courier New', value: '"Courier New", Courier, monospace' },
{ name: 'Georgia', value: 'Georgia, serif' },
{ name: 'Impact', value: 'Impact, Charcoal, sans-serif' },
{ name: 'Lucida Console', value: '"Lucida Console", Monaco, monospace' },
{ name: 'Lucida Sans Unicode', value: '"Lucida Sans Unicode", "Lucida Grande", sans-serif' },
{ name: 'Palatino Linotype', value: '"Palatino Linotype", "Book Antiqua", Palatino, serif' },
{ name: 'Tahoma', value: 'Tahoma, Geneva, sans-serif' },
{ name: 'Segoe UI', value: '"Segoe UI", "Roboto", sans-serif' },
{ name: 'Times New Roman', value: '"Times New Roman", Times, serif' },
{ name: 'Trebuchet MS', value: '"Trebuchet MS", Helvetica, sans-serif' },
{ name: 'Verdana', value: 'Verdana, Geneva, sans-serif' }
];
const fontSizeList = [
{ name: '8', value: '8px' },
{ name: '9', value: '9px' },
{ name: '10', value: '10px' },
{ name: '11', value: '11px' },
{ name: '12', value: '12px' },
{ name: '14', value: '14px' },
{ name: '16', value: '16px' },
{ name: '18', value: '18px' },
{ name: '20', value: '20px' },
{ name: '22', value: '22px' },
{ name: '24', value: '24px' }
];
function App() {
const [format, setFormat] = useState('0');
const [fontIdx, setFontIdx] = useState(0);
const [fontSizeIdx, setFontSizeIdx] = useState(5);
const [isBold, setIsBold] = useState(false);
const [isItalic, setIsItalic] = useState(false);
const [isUnderline, setIsUnderline] = useState(false);
const [textAlign, setTextAlign] = useState('left');
const applyFillColorRef = useRef(false);
const updatingSelectionRef = useRef(false);
const flexRef = useRef(null);
const colorPickerRef = useRef(null);
const initializeFlexSheet = useEvent((sender) => {
flexRef.current = sender;
sender.deferUpdate(() => {
for (let sheetIdx = 0; sheetIdx < sender.sheets.length; sheetIdx++) {
sender.selectedSheetIndex = sheetIdx;
let sheetName = sender.selectedSheet.name;
//
for (let colIdx = 0; colIdx < sender.columns.length; colIdx++) {
for (let rowIdx = 0; rowIdx < sender.rows.length; rowIdx++) {
if (sheetName === 'Number') {
sender.setCellData(rowIdx, colIdx, colIdx + rowIdx);
}
else {
let date = new Date(2015, colIdx, rowIdx + 1);
sender.setCellData(rowIdx, colIdx, date);
}
}
}
}
//
sender.selectedSheetIndex = 0;
setTimeout(() => updateSelection(sender, sender.selection), 100);
});
//
sender.selectionChanged.addHandler((sender, args) => {
updateSelection(sender, args.range);
});
});
const fontChanged = useEvent((sender) => {
var _a;
if (sender.selectedItem && !updatingSelectionRef.current) {
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ fontFamily: sender.selectedItem.value });
}
});
const fontSizeChanged = useEvent((sender) => {
var _a;
if (sender.selectedItem && !updatingSelectionRef.current) {
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ fontSize: sender.selectedItem.value });
}
});
const colorPickerInit = useEvent((sender) => {
// if the browser is firefox, we should bind the blur event. (TFS #124387)
// if the browser is IE, we should bind the focusout event. (TFS #124500)
let blurEvt = /firefox/i.test(window.navigator.userAgent) ? 'blur' : 'focusout';
// Hide the color picker control when it lost the focus.
sender.hostElement.addEventListener(blurEvt, () => {
setTimeout(() => {
if (!sender.containsFocus()) {
updatingSelectionRef.current = false;
sender.hostElement.style.display = 'none';
}
}, 0);
});
//
// Initialize the value changed event handler for the color picker control.
sender.valueChanged.addHandler(() => {
var _a, _b;
if (applyFillColorRef.current) {
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ backgroundColor: sender.value });
}
else {
(_b = flexRef.current) === null || _b === void 0 ? void 0 : _b.applyCellsStyle({ color: sender.value });
}
});
//
colorPickerRef.current = sender;
});
const formatChanged = useEvent((sender) => {
var _a;
if (sender.selectedValue) {
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ format: sender.selectedValue });
setFormat(sender.selectedValue);
}
});
// apply the text alignment for the selected cells
const applyCellTextAlign = (value) => {
var _a;
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ textAlign: value });
setTextAlign(value);
};
// apply the bold font weight for the selected cells
const applyBoldStyle = () => {
var _a;
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ fontWeight: isBold ? 'none' : 'bold' });
setIsBold(!isBold);
};
// apply the underline text decoration for the selected cells
const applyUnderlineStyle = () => {
var _a;
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ textDecoration: isUnderline ? 'none' : 'underline' });
setIsUnderline(!isUnderline);
};
// apply the italic font style for the selected cells
const applyItalicStyle = () => {
var _a;
(_a = flexRef.current) === null || _a === void 0 ? void 0 : _a.applyCellsStyle({ fontStyle: isItalic ? 'none' : 'italic' });
setIsItalic(!isItalic);
};
// show the color picker control.
const showColorPicker = (e, isFillColor) => {
var _a;
let offset = cumulativeOffset(e.target);
//
let he = (_a = colorPickerRef.current) === null || _a === void 0 ? void 0 : _a.hostElement;
if (he) {
he.style.display = 'inline';
he.style.left = offset.left + 'px';
he.style.top = offset.top - he.clientHeight - 5 + 'px';
he.focus();
}
//
applyFillColorRef.current = isFillColor;
};
// Update the selection object of the scope.
const updateSelection = (fs, sel) => {
let rCnt = fs.rows.length, cCnt = fs.columns.length, fontIdx = 0, fontSizeIdx = 5;
//
updatingSelectionRef.current = true;
//
if (sel.row > -1 && sel.col > -1 && rCnt > 0 && cCnt > 0 && sel.col < cCnt && sel.col2 < cCnt && sel.row < rCnt && sel.row2 < rCnt) {
let cellContent = fs.getCellData(sel.row, sel.col, false), cellStyle = fs.selectedSheet.getCellStyle(sel.row, sel.col), cellFormat = '';
if (cellStyle) {
if (cellStyle.fontFamily) {
fontIdx = checkFontfamily(cellStyle.fontFamily);
}
if (cellStyle.fontSize) {
fontSizeIdx = checkFontSize(cellStyle.fontSize);
}
if (cellStyle.format) {
cellFormat = cellStyle.format;
}
}
let format = '';
if (!!cellFormat) {
format = cellFormat;
}
else {
if (wijmo.isInt(cellContent)) {
format = '0';
}
else if (wijmo.isNumber(cellContent)) {
format = 'n2';
}
else if (wijmo.isDate(cellContent)) {
format = 'd';
}
}
//
let state = fs.getSelectionFormatState();
setFormat(format);
setFontIdx(fontIdx);
setFontSizeIdx(fontSizeIdx);
}
//
updatingSelectionRef.current = false;
};
// check font family for the font name combobox of the ribbon.
const checkFontfamily = (value) => {
if (!value) {
return 0;
}
for (let fontIndex = 0; fontIndex < fonts.length; fontIndex++) {
let font = fonts[fontIndex];
if (font.name === value || font.value === value) {
return fontIndex;
}
}
//
return 0;
};
// check font size for the font size combobox of the ribbon.
const checkFontSize = (value) => {
let sizeList = fontSizeList;
//
if (value == null) {
return 5;
}
//
for (let index = 0; index < sizeList.length; index++) {
let size = sizeList[index];
if (size.value === value || size.name === value) {
return index;
}
}
//
return 5;
};
// Get the absolute position of the dom element.
const cumulativeOffset = (element) => {
let top = 0, left = 0, scrollTop = 0, scrollLeft = 0;
//
do {
top += element.offsetTop || 0;
left += element.offsetLeft || 0;
scrollTop += element.scrollTop || 0;
scrollLeft += element.scrollLeft || 0;
element = element.offsetParent;
} while (element && !(element instanceof HTMLBodyElement));
//
scrollTop += document.body.scrollTop || document.documentElement.scrollTop;
scrollLeft += document.body.scrollLeft || document.documentElement.scrollLeft;
//
return {
top: top - scrollTop,
left: left - scrollLeft
};
};
return (<div className="container-fluid">
<wjGridSheet.FlexSheet initialized={initializeFlexSheet}>
<wjGridSheet.Sheet name="Number" rowCount={20} columnCount={8}/>
<wjGridSheet.Sheet name="Date" rowCount={20} columnCount={8}/>
</wjGridSheet.FlexSheet>
<wjInput.ColorPicker style={{ display: "none", position: "fixed", zIndex: 100 }} initialized={colorPickerInit}>
</wjInput.ColorPicker>
<div className="well well-lg">
<wjInput.Menu header='Format' value={format} itemClicked={formatChanged}>
<wjInput.MenuItem value="0">Decimal Format</wjInput.MenuItem>
<wjInput.MenuItem value="n2">Number Format</wjInput.MenuItem>
<wjInput.MenuItem value="p">Percentage Format</wjInput.MenuItem>
<wjInput.MenuItem value="c2">Currency Format</wjInput.MenuItem>
<wjInput.MenuSeparator></wjInput.MenuSeparator>
<wjInput.MenuItem value="d">Short Date</wjInput.MenuItem>
<wjInput.MenuItem value="D">Long Date</wjInput.MenuItem>
<wjInput.MenuItem value="f">Full Date/TIme (short time)</wjInput.MenuItem>
<wjInput.MenuItem value="F">Full Date/TIme (long time)</wjInput.MenuItem>
</wjInput.Menu>
<div>Font:
<wjInput.ComboBox style={{ width: "120px" }} itemsSource={fonts} selectedIndex={fontIdx} displayMemberPath="name" selectedValuePath="value" isEditable={false} selectedIndexChanged={fontChanged}>
</wjInput.ComboBox>
<wjInput.ComboBox style={{ width: "80px" }} itemsSource={fontSizeList} selectedIndex={fontSizeIdx} displayMemberPath="name" selectedValuePath="value" isEditable={false} selectedIndexChanged={fontSizeChanged}>
</wjInput.ComboBox>
<div className="btn-group">
<button type="button" className={`btn btn-default ${isBold ? 'active' : ''}`} onClick={applyBoldStyle}>
Bold</button>
<button type="button" className={`btn btn-default ${isItalic ? 'active' : ''}`} onClick={applyItalicStyle}>
Italic</button>
<button type="button" className={`btn btn-default ${isUnderline ? 'active' : ''}`} onClick={applyUnderlineStyle}>
Underline</button>
</div>
</div>
<div>Color:
<div className="btn-group">
<button type="button" className="btn btn-default" onClick={(e) => showColorPicker(e, false)}>
Fore Color</button>
<button type="button" className="btn btn-default" onClick={(e) => showColorPicker(e, true)}>
Fill Color</button>
</div>Alignment:
<div className="btn-group">
<button type="button" className={`btn btn-default ${textAlign == 'left' ? 'active' : ''}`} onClick={() => applyCellTextAlign("left")}>
Left</button>
<button type="button" className={`btn btn-default ${textAlign == 'center' ? 'active' : ''}`} onClick={() => applyCellTextAlign("center")}>
Center</button>
<button type="button" className={`btn btn-default ${textAlign == 'right' ? 'active' : ''}`} onClick={() => applyCellTextAlign("right")}>
Right</button>
</div>
</div>
</div>
</div>);
}
const container = document.getElementById('app');
if (container) {
const root = ReactDOM.createRoot(container);
root.render(<App />);
}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>MESCIUS Wijmo Wijmo FlexSheet Formatting Cells</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- SystemJS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.40/system.src.js" integrity="sha512-G6mEj6h18+m3MvzdviSDfPle/TfH0//cXcB33AKlNR/Rha0yQsKefDZKRTkIZos97HEGq2JMV1RT5ybMoQ3WsQ==" crossorigin="anonymous"></script>
<script src="systemjs.config.js"></script>
<script>
System.import('./src/app');
</script>
</head>
<body>
<div id="app"></div>
</body>
</html>
.container-fluid .wj-flexsheet {
height: 400px;
margin: 6px 0;
}
(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: {
'jszip': 'npm:jszip/dist/jszip.js',
'@mescius/wijmo': 'npm:@mescius/wijmo/index.js',
'@mescius/wijmo.input': 'npm:@mescius/wijmo.input/index.js',
'@mescius/wijmo.styles': 'npm:@mescius/wijmo.styles',
'@mescius/wijmo.cultures': 'npm:@mescius/wijmo.cultures',
'@mescius/wijmo.chart': 'npm:@mescius/wijmo.chart/index.js',
'@mescius/wijmo.chart.analytics': 'npm:@mescius/wijmo.chart.analytics/index.js',
'@mescius/wijmo.chart.animation': 'npm:@mescius/wijmo.chart.animation/index.js',
'@mescius/wijmo.chart.annotation': 'npm:@mescius/wijmo.chart.annotation/index.js',
'@mescius/wijmo.chart.finance': 'npm:@mescius/wijmo.chart.finance/index.js',
'@mescius/wijmo.chart.finance.analytics': 'npm:@mescius/wijmo.chart.finance.analytics/index.js',
'@mescius/wijmo.chart.hierarchical': 'npm:@mescius/wijmo.chart.hierarchical/index.js',
'@mescius/wijmo.chart.interaction': 'npm:@mescius/wijmo.chart.interaction/index.js',
'@mescius/wijmo.chart.radar': 'npm:@mescius/wijmo.chart.radar/index.js',
'@mescius/wijmo.chart.render': 'npm:@mescius/wijmo.chart.render/index.js',
'@mescius/wijmo.chart.webgl': 'npm:@mescius/wijmo.chart.webgl/index.js',
'@mescius/wijmo.chart.map': 'npm:@mescius/wijmo.chart.map/index.js',
'@mescius/wijmo.gauge': 'npm:@mescius/wijmo.gauge/index.js',
'@mescius/wijmo.grid': 'npm:@mescius/wijmo.grid/index.js',
'@mescius/wijmo.grid.detail': 'npm:@mescius/wijmo.grid.detail/index.js',
'@mescius/wijmo.grid.filter': 'npm:@mescius/wijmo.grid.filter/index.js',
'@mescius/wijmo.grid.search': 'npm:@mescius/wijmo.grid.search/index.js',
'@mescius/wijmo.grid.grouppanel': 'npm:@mescius/wijmo.grid.grouppanel/index.js',
'@mescius/wijmo.grid.multirow': 'npm:@mescius/wijmo.grid.multirow/index.js',
'@mescius/wijmo.grid.transposed': 'npm:@mescius/wijmo.grid.transposed/index.js',
'@mescius/wijmo.grid.transposedmultirow': 'npm:@mescius/wijmo.grid.transposedmultirow/index.js',
'@mescius/wijmo.grid.pdf': 'npm:@mescius/wijmo.grid.pdf/index.js',
'@mescius/wijmo.grid.sheet': 'npm:@mescius/wijmo.grid.sheet/index.js',
'@mescius/wijmo.grid.xlsx': 'npm:@mescius/wijmo.grid.xlsx/index.js',
'@mescius/wijmo.grid.selector': 'npm:@mescius/wijmo.grid.selector/index.js',
'@mescius/wijmo.grid.cellmaker': 'npm:@mescius/wijmo.grid.cellmaker/index.js',
'@mescius/wijmo.grid.immutable': 'npm:@mescius/wijmo.grid.immutable/index.js',
'@mescius/wijmo.touch': 'npm:@mescius/wijmo.touch/index.js',
'@mescius/wijmo.cloud': 'npm:@mescius/wijmo.cloud/index.js',
'@mescius/wijmo.nav': 'npm:@mescius/wijmo.nav/index.js',
'@mescius/wijmo.odata': 'npm:@mescius/wijmo.odata/index.js',
'@mescius/wijmo.olap': 'npm:@mescius/wijmo.olap/index.js',
'@mescius/wijmo.rest': 'npm:@mescius/wijmo.rest/index.js',
'@mescius/wijmo.pdf': 'npm:@mescius/wijmo.pdf/index.js',
'@mescius/wijmo.pdf.security': 'npm:@mescius/wijmo.pdf.security/index.js',
'@mescius/wijmo.viewer': 'npm:@mescius/wijmo.viewer/index.js',
'@mescius/wijmo.xlsx': 'npm:@mescius/wijmo.xlsx/index.js',
'@mescius/wijmo.undo': 'npm:@mescius/wijmo.undo/index.js',
'@mescius/wijmo.interop.grid': 'npm:@mescius/wijmo.interop.grid/index.js',
'@mescius/wijmo.barcode': 'npm:@mescius/wijmo.barcode/index.js',
'@mescius/wijmo.barcode.common': 'npm:@mescius/wijmo.barcode.common/index.js',
'@mescius/wijmo.barcode.composite': 'npm:@mescius/wijmo.barcode.composite/index.js',
'@mescius/wijmo.barcode.specialized': 'npm:@mescius/wijmo.barcode.specialized/index.js',
"@mescius/wijmo.react.chart.analytics": "npm:@mescius/wijmo.react.chart.analytics/index.js",
"@mescius/wijmo.react.chart.animation": "npm:@mescius/wijmo.react.chart.animation/index.js",
"@mescius/wijmo.react.chart.annotation": "npm:@mescius/wijmo.react.chart.annotation/index.js",
"@mescius/wijmo.react.chart.finance.analytics": "npm:@mescius/wijmo.react.chart.finance.analytics/index.js",
"@mescius/wijmo.react.chart.finance": "npm:@mescius/wijmo.react.chart.finance/index.js",
"@mescius/wijmo.react.chart.hierarchical": "npm:@mescius/wijmo.react.chart.hierarchical/index.js",
"@mescius/wijmo.react.chart.interaction": "npm:@mescius/wijmo.react.chart.interaction/index.js",
"@mescius/wijmo.react.chart.radar": "npm:@mescius/wijmo.react.chart.radar/index.js",
"@mescius/wijmo.react.chart": "npm:@mescius/wijmo.react.chart/index.js",
"@mescius/wijmo.react.core": "npm:@mescius/wijmo.react.core/index.js",
'@mescius/wijmo.react.chart.map': 'npm:@mescius/wijmo.react.chart.map/index.js',
"@mescius/wijmo.react.gauge": "npm:@mescius/wijmo.react.gauge/index.js",
"@mescius/wijmo.react.grid.detail": "npm:@mescius/wijmo.react.grid.detail/index.js",
"@mescius/wijmo.react.grid.filter": "npm:@mescius/wijmo.react.grid.filter/index.js",
"@mescius/wijmo.react.grid.grouppanel": "npm:@mescius/wijmo.react.grid.grouppanel/index.js",
'@mescius/wijmo.react.grid.search': 'npm:@mescius/wijmo.react.grid.search/index.js',
"@mescius/wijmo.react.grid.multirow": "npm:@mescius/wijmo.react.grid.multirow/index.js",
"@mescius/wijmo.react.grid.sheet": "npm:@mescius/wijmo.react.grid.sheet/index.js",
'@mescius/wijmo.react.grid.transposed': 'npm:@mescius/wijmo.react.grid.transposed/index.js',
'@mescius/wijmo.react.grid.transposedmultirow': 'npm:@mescius/wijmo.react.grid.transposedmultirow/index.js',
'@mescius/wijmo.react.grid.immutable': 'npm:@mescius/wijmo.react.grid.immutable/index.js',
"@mescius/wijmo.react.grid": "npm:@mescius/wijmo.react.grid/index.js",
"@mescius/wijmo.react.input": "npm:@mescius/wijmo.react.input/index.js",
"@mescius/wijmo.react.olap": "npm:@mescius/wijmo.react.olap/index.js",
"@mescius/wijmo.react.viewer": "npm:@mescius/wijmo.react.viewer/index.js",
"@mescius/wijmo.react.nav": "npm:@mescius/wijmo.react.nav/index.js",
"@mescius/wijmo.react.base": "npm:@mescius/wijmo.react.base/index.js",
'@mescius/wijmo.react.barcode.common': 'npm:@mescius/wijmo.react.barcode.common/index.js',
'@mescius/wijmo.react.barcode.composite': 'npm:@mescius/wijmo.react.barcode.composite/index.js',
'@mescius/wijmo.react.barcode.specialized': 'npm:@mescius/wijmo.react.barcode.specialized/index.js',
'jszip': 'npm:jszip/dist/jszip.js',
'react': 'npm:react/umd/react.production.min.js',
'react-dom': 'npm:react-dom/umd/react-dom.production.min.js',
'react-dom/client': 'npm:react-dom/umd/react-dom.production.min.js',
'redux': 'npm:redux/dist/redux.min.js',
'react-redux': 'npm:react-redux/dist/react-redux.min.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',
"react-use-event-hook": "npm:react-use-event-hook/dist/esm/useEvent.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);
