import "core-js/modules/es.regexp.exec"; import "core-js/modules/es.string.match"; import "core-js/modules/es.string.replace"; /** * Check if provided expression is valid formula expression. * * @param {*} expression Expression to check. * @returns {Boolean} */ export function isFormulaExpression(expression) { return typeof expression === 'string' && expression.length >= 2 && expression.charAt(0) === '='; } /** * Check if provided formula expression is escaped. * * @param {*} expression Expression to check. * @returns {Boolean} */ export function isFormulaExpressionEscaped(expression) { return typeof expression === 'string' && expression.charAt(0) === '\'' && expression.charAt(1) === '='; } /** * Replace escaped formula expression into valid string. * * @param {String} expression Expression to process. * @returns {String} */ export function unescapeFormulaExpression(expression) { return isFormulaExpressionEscaped(expression) ? expression.substr(1) : expression; } /** * Upper case formula expression. * * @param {String} expression Formula expression. * @returns {String} */ export function toUpperCaseFormula(expression) { var PATTERN = /(\\"|"(?:\\"|[^"])*"|(\+))|(\\'|'(?:\\'|[^'])*'|(\+))/g; var strings = expression.match(PATTERN) || []; var index = -1; return expression.toUpperCase().replace(PATTERN, function () { index += 1; return strings[index]; }); } /** * Cell coordinates function factory. * * @param {String} axis An axis name (`row` or `column`) which default index will be applied to. * @param {Number} defaultIndex Default index. * @returns {Function} */ export function cellCoordFactory(axis, defaultIndex) { return function (cell) { return { row: axis === 'row' ? defaultIndex : cell.row, column: axis === 'column' ? defaultIndex : cell.column }; }; }