Huge News!Announcing our $40M Series B led by Abstract Ventures.Learn More
Socket
Sign inDemoInstall
Socket

@syncfusion/ej2-spreadsheet

Package Overview
Dependencies
Maintainers
3
Versions
267
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

@syncfusion/ej2-spreadsheet - npm Package Compare versions

Comparing version 18.4.42 to 18.4.43

12

CHANGELOG.md

@@ -9,2 +9,14 @@ # Changelog

`#F161227` - Prevented deleting range which contains lock cells.
`#F162534` - Issue on editing a cell that depend on other cell after addition of date using Plus (+) operator issue fixed.
`#313009` - Delete rows and columns using `delete` method issues resolved.
`#313000` - The `insertSheet` method will now prevent the sheet with duplicate name from inserting.
`#I312853` - Provided the actionBegin and actionComplete event for sheet rename action in spreadsheet
## 18.4.42 (2021-02-09)
### Spreadsheet
#### Bug Fixes
- External paste for cell style is not working properly when spreadsheet has common style issue has been fixed.

@@ -11,0 +23,0 @@ - Ribbon items are not updated during external paste issue has been fixed.

2

dist/global/index.d.ts
/*!
* filename: index.d.ts
* version : 18.4.42
* version : 18.4.43
* Copyright Syncfusion Inc. 2001 - 2020. All rights reserved.

@@ -5,0 +5,0 @@ * Use of this code is subject to the terms of our license.

{
"_from": "@syncfusion/ej2-spreadsheet@*",
"_id": "@syncfusion/ej2-spreadsheet@18.4.41",
"_id": "@syncfusion/ej2-spreadsheet@18.4.42",
"_inBundle": false,
"_integrity": "sha512-NeodtfxcEQqd/08LYH7DE+3k3L9vMBwc0BXFJq3YUqBfjhEC3ZKq6aVUwb+Rw3gQPOQ7djyZVUWIiTLHT3tKbg==",
"_integrity": "sha512-lrHo6rxgix/XWy8Z0eSKa06cv6o1rVy/qYTvqqIiSh4Euazp2/22KFqo86r6+6Adf56hLlVMYyRgLpYbrKqFSg==",
"_location": "/@syncfusion/ej2-spreadsheet",

@@ -26,4 +26,4 @@ "_phantomChildren": {},

],
"_resolved": "http://nexus.syncfusion.com/repository/ej2-hotfix/@syncfusion/ej2-spreadsheet/-/ej2-spreadsheet-18.4.41.tgz",
"_shasum": "f5de812340f4e486dac7ed19454f64e48bb1b43d",
"_resolved": "http://nexus.syncfusion.com/repository/ej2-hotfix/@syncfusion/ej2-spreadsheet/-/ej2-spreadsheet-18.4.42.tgz",
"_shasum": "3a3287641ecc5ebe9639f9fb72c86dc7c797fb89",
"_spec": "@syncfusion/ej2-spreadsheet@*",

@@ -36,6 +36,6 @@ "_where": "/jenkins/workspace/automation_release_18.4.0.1-WOJ6QVY6EU5ONBWOYGQFKS2VU2UW7E67MOXUPKCE5AX7QQX7M5JQ/packages/included",

"dependencies": {
"@syncfusion/ej2-base": "~18.4.42",
"@syncfusion/ej2-charts": "~18.4.42",
"@syncfusion/ej2-dropdowns": "~18.4.42",
"@syncfusion/ej2-grids": "~18.4.42",
"@syncfusion/ej2-base": "~18.4.43",
"@syncfusion/ej2-charts": "~18.4.43",
"@syncfusion/ej2-dropdowns": "~18.4.43",
"@syncfusion/ej2-grids": "~18.4.43",
"@syncfusion/ej2-navigations": "~18.4.42"

@@ -67,4 +67,4 @@ },

"typings": "index.d.ts",
"version": "18.4.42",
"version": "18.4.43",
"sideEffects": true
}

@@ -31,2 +31,4 @@ import { INotifyPropertyChanged, EmitType, ModuleDeclaration, Base } from '@syncfusion/ej2-base';

/** @hidden */
spreadSheetUsedRange: number[];
/** @hidden */
tic: string;

@@ -344,3 +346,3 @@ /** @hidden */

*/
valueChanged(grid: string, changeArgs: ValueChangedArgs, isCalculate?: boolean): void;
valueChanged(grid: string, changeArgs: ValueChangedArgs, isCalculate?: boolean, usedRangeCol?: number[]): void;
/** @hidden */

@@ -347,0 +349,0 @@ getComputedValue(): Map<string, string | number>;

@@ -203,2 +203,4 @@ import { detach, EventHandler, Browser, extend, isNullOrUndefined } from '@syncfusion/ej2-base';

if (pictureElem.classList.contains('e-datavisualization-chart')) {
this.copiedShapeInfo.chartInfo.top = null;
this.copiedShapeInfo.chartInfo.left = null;
this.parent.notify(setChart, {

@@ -205,0 +207,0 @@ chart: [this.copiedShapeInfo.chartInfo], isInitCell: true, isUndoRedo: true, isPaste: true,

@@ -268,3 +268,3 @@ import { EventHandler, Browser, closest, isUndefined, isNullOrUndefined, select } from '@syncfusion/ej2-base';

if (keyCode === this.keyCodes.DELETE) {
var islockcell = this.isLockCellDelete(e);
var islockcell = sheet.isProtected && this.isLockCellDelete();
if (!islockcell) {

@@ -295,16 +295,16 @@ this.editingHandler('delete');

};
Edit.prototype.isLockCellDelete = function (e) {
Edit.prototype.isLockCellDelete = function () {
var sheet = this.parent.getActiveSheet();
var count = 0;
var address = getRangeIndexes(sheet.selectedRange);
for (var row = address[2]; row <= address[0]; row++) {
for (var col = address[3]; col <= address[1]; col++) {
var hasLockCell;
var address = getSwapRange(getRangeIndexes(sheet.selectedRange));
for (var row = address[0]; row <= address[2]; row++) {
for (var col = address[1]; col <= address[3]; col++) {
var cell = getCell(row, col, sheet);
if (isLocked(cell, getColumn(sheet, col))) {
e.preventDefault();
count++;
hasLockCell = true;
break;
}
}
}
return count > 0;
return hasLockCell;
};

@@ -519,3 +519,3 @@ Edit.prototype.renderEditor = function () {

if (isFormula && this.editCellData.value === this.editorElem.textContent && this.editorElem.textContent.indexOf('(') !==
this.editorElem.textContent.length - 1) {
this.editorElem.textContent.length - 1 && !this.isCellEdit) {
if (this.editCellData.sheetIndex === sheet.id - 1) {

@@ -522,0 +522,0 @@ var curPos = window.getSelection().focusOffset;

@@ -615,4 +615,5 @@ import { getSheetIndex, isHiddenRow, getCell, setCell } from '../../workbook/base/index';

var id = argsOpt.option.id + '_overlay';
var sheetIndex = (argsOpt.option.range && argsOpt.option.range.indexOf('!') > 0) ?
getSheetIndex(this.parent, argsOpt.option.range.split('!')[0]) : this.parent.activeSheetIndex;
var sheetIndex = argsOpt.isPaste ? this.parent.getActiveSheet().index :
(argsOpt.option.range && argsOpt.option.range.indexOf('!') > 0) ?
getSheetIndex(this.parent, argsOpt.option.range.split('!')[0]) : this.parent.activeSheetIndex;
var overlayObj = this.parent.serviceLocator.getService(overlay);

@@ -619,0 +620,0 @@ var eleRange = !isNullOrUndefined(argsOpt.isInitCell) && argsOpt.isInitCell ? argsOpt.range : range;

@@ -277,2 +277,9 @@ import { Tab } from '@syncfusion/ej2-navigations';

var value = target.querySelector('.e-tab-text').textContent;
var args = {
eventArgs: {
name: value, index: this.parent.getActiveSheet().id
},
action: 'renameSheet', cancel: false
};
this.parent.trigger('actionBegin', args);
var input = this.parent.createElement('input', {

@@ -279,0 +286,0 @@ id: this.parent.element.id + '_rename_input',

@@ -123,13 +123,11 @@ import { initialLoad, ribbon, formulaBar, beforeVirtualContentLoaded, setAriaOptions, getSiblingsHeight } from '../common/index';

this.parent.getData(sheetName + "!" + address).then(function (values) {
if (args.refresh === 'All') {
if (sheetsLen < _this.parent.sheets.length) {
return;
if (sheetsLen < _this.parent.sheets.length) {
return;
}
var sheetIdx = _this.parent.sheets.indexOf(sheet);
if (sheetIdx === -1 || sheetIdx !== _this.parent.activeSheetIndex) {
if (sheetIdx > -1) {
_this.checkTopLeftCell();
}
var sheetIdx = _this.parent.sheets.indexOf(sheet);
if (sheetIdx === -1 || sheetIdx !== _this.parent.activeSheetIndex) {
if (sheetIdx > -1) {
_this.checkTopLeftCell();
}
return;
}
return;
}

@@ -136,0 +134,0 @@ var indexes = [args.rowIndex, args.colIndex].concat(getCellIndexes(address.split(':')[1]));

@@ -47,3 +47,5 @@ import { getCell, setCell } from '../base/index';

}
this.parent.notify(updateUsedRange, { index: args.model.usedRange.rowIndex, update: 'row' });
if (args.model !== this.parent.getActiveSheet()) {
this.parent.notify(updateUsedRange, { index: args.model.usedRange.rowIndex, update: 'row' });
}
var curIdx = args.end + 1;

@@ -72,3 +74,3 @@ var cell = void 0;

}
if (args.model.rows[curIdx].cells && args.model.rows[curIdx].cells[i] &&
if (args.model.rows[curIdx] && args.model.rows[curIdx].cells && args.model.rows[curIdx].cells[i] &&
args.model.rows[curIdx].cells[i].rowSpan !== undefined &&

@@ -123,3 +125,5 @@ args.model.rows[curIdx].cells[i].rowSpan < 0 && args.model.rows[curIdx].cells[i].colSpan === undefined) {

//this.setDeleteInfo(args.start, args.end, 'fldLen', 'Column');
this.parent.notify(updateUsedRange, { index: args.model.usedRange.colIndex, update: 'col' });
if (args.model !== this.parent.getActiveSheet()) {
this.parent.notify(updateUsedRange, { index: args.model.usedRange.colIndex, update: 'col' });
}
deletedCells = [];

@@ -221,2 +225,5 @@ var curIdx = args.end + 1;

this.parent.notify(workbookFormulaOperation, eventArgs);
if (args.modelType !== 'Sheet' && args.model !== this.parent.getActiveSheet()) {
return;
}
this.parent.notify(deleteAction, {

@@ -223,0 +230,0 @@ startIndex: args.start, endIndex: args.end, modelType: args.modelType,

@@ -102,7 +102,2 @@ import { getCell, getSheet } from '../base/index';

};
this.parent.notify(workbookFormulaOperation, eventArgs);
if (isFormula) {
cell.formula = eventArgs.value;
value = cell.value;
}
if (getTypeFromFormat(cell.format) !== 'Text') {

@@ -121,2 +116,7 @@ var dateEventArgs = {

}
this.parent.notify(workbookFormulaOperation, eventArgs);
if (isFormula) {
cell.formula = eventArgs.value;
value = cell.value;
}
}

@@ -123,0 +123,0 @@ else {

@@ -15,5 +15,9 @@ import { insert, insertModel, workbookFormulaOperation, } from '../../workbook/common/index';

}
// tslint:disable-next-line
WorkbookInsert.prototype.insertModel = function (args) {
var _this = this;
var _a, _b, _c;
if (!args.model) {
return;
}
var index;

@@ -50,9 +54,14 @@ var model = [];

}
if (isModel && args.model.usedRange.rowIndex > -1 && index > args.model.usedRange.rowIndex) {
for (var i = args.model.usedRange.rowIndex; i < index - 1; i++) {
model.splice(0, 0, {});
}
}
(_a = args.model.rows).splice.apply(_a, [index, 0].concat(model));
//this.setInsertInfo(args.model, index, model.length, 'count');
if (index > args.model.usedRange.rowIndex) {
this.parent.setUsedRange(index + (model.length - 1), args.model.usedRange.colIndex);
this.parent.setUsedRange(index + (model.length - 1), args.model.usedRange.colIndex, args.model);
}
else {
this.parent.setUsedRange(args.model.usedRange.rowIndex + model.length, args.model.usedRange.colIndex);
this.parent.setUsedRange(args.model.usedRange.rowIndex + model.length, args.model.usedRange.colIndex, args.model);
}

@@ -79,6 +88,6 @@ var curIdx = index + model.length;

if (index > args.model.usedRange.colIndex) {
this.parent.setUsedRange(args.model.usedRange.rowIndex, index + (model.length - 1));
this.parent.setUsedRange(args.model.usedRange.rowIndex, index + (model.length - 1), args.model);
}
else {
this.parent.setUsedRange(args.model.usedRange.rowIndex, args.model.usedRange.colIndex + model.length);
this.parent.setUsedRange(args.model.usedRange.rowIndex, args.model.usedRange.colIndex + model.length, args.model);
}

@@ -123,2 +132,17 @@ if (!args.model.rows) {

}
var sheetModel = model;
for (var i = 0; i < sheetModel.length; i++) {
if (sheetModel[i].name) {
for (var j = 0; j < this.parent.sheets.length; j++) {
if (sheetModel[i].name === this.parent.sheets[j].name) {
sheetModel.splice(i, 1);
i--;
break;
}
}
}
}
if (!sheetModel.length) {
return;
}
delete model[0].index;

@@ -153,5 +177,8 @@ this.parent.createSheet(index, model);

};
if (args.modelType === 'Column' || args.modelType === 'Row') {
if (args.modelType !== 'Sheet') {
this.parent.notify(workbookFormulaOperation, insertArgs);
this.parent.notify(workbookFormulaOperation, eventArgs);
if (args.model !== this.parent.getActiveSheet()) {
return;
}
}

@@ -158,0 +185,0 @@ this.parent.notify(insert, {

@@ -454,5 +454,7 @@ import { Component, INotifyPropertyChanged, EmitType } from '@syncfusion/ej2-base';

* @param {number} endRow? - Specifies the end row index.
* @param {number | string} sheet? - Specifies the sheet name or index in which the insert operation will perform. By default,
* active sheet will be considered.
* @returns void
*/
insertRow(startRow?: number | RowModel[], endRow?: number): void;
insertRow(startRow?: number | RowModel[], endRow?: number, sheet?: number | string): void;
/**

@@ -463,5 +465,7 @@ * Used to insert columns in to the spreadsheet.

* @param {number} endColumn? - Specifies the end column index.
* @param {number | string} sheet? - Specifies the sheet name or index in which the insert operation will perform. By default,
* active sheet will be considered.
* @returns void
*/
insertColumn(startColumn?: number | ColumnModel[], endColumn?: number): void;
insertColumn(startColumn?: number | ColumnModel[], endColumn?: number, sheet?: number | string): void;
/**

@@ -478,3 +482,3 @@ * Used to insert sheets in to the spreadsheet.

* {% codeBlock src='spreadsheet/delete/index.md' %}{% endcodeBlock %}
* @param {number | RowModel[]} startIndex? - Specifies the start sheet / row / column index.
* @param {number} startIndex? - Specifies the start sheet / row / column index.
* @param {number} endIndex? - Specifies the end sheet / row / column index.

@@ -485,5 +489,8 @@ * @param {ModelType} model? - Specifies the delete model type. By default, the model is considered as `Sheet`. The possible values are,

* - Sheet: To delete sheets.
* @param {number | string} sheet? - Specifies the sheet name or index in which the delete operation will perform. By default,
* active sheet will be considered. It is applicable only for model type Row and Column.
* @returns void
*/
delete(startIndex?: number, endIndex?: number, model?: ModelType): void;
delete(startIndex?: number, endIndex?: number, model?: ModelType, sheet?: number | string): void;
private getSheetModel;
/**

@@ -515,3 +522,3 @@ * Used to merge the range of cells.

*/
setUsedRange(rowIdx: number, colIdx: number): void;
setUsedRange(rowIdx: number, colIdx: number, sheet?: SheetModel): void;
/**

@@ -518,0 +525,0 @@ * Gets the range of data as JSON from the specified address.

@@ -285,6 +285,9 @@ var __extends = (this && this.__extends) || (function () {

* @param {number} endRow? - Specifies the end row index.
* @param {number | string} sheet? - Specifies the sheet name or index in which the insert operation will perform. By default,
* active sheet will be considered.
* @returns void
*/
Workbook.prototype.insertRow = function (startRow, endRow) {
this.notify(insertModel, { model: this.getActiveSheet(), start: startRow, end: endRow, modelType: 'Row' });
Workbook.prototype.insertRow = function (startRow, endRow, sheet) {
this.notify(insertModel, { model: this.getSheetModel(sheet), start: startRow, end: endRow,
modelType: 'Row' });
};

@@ -296,9 +299,9 @@ /**

* @param {number} endColumn? - Specifies the end column index.
* @param {number | string} sheet? - Specifies the sheet name or index in which the insert operation will perform. By default,
* active sheet will be considered.
* @returns void
*/
Workbook.prototype.insertColumn = function (startColumn, endColumn) {
this.notify(insertModel, {
model: this.getActiveSheet(), start: startColumn, end: endColumn,
modelType: 'Column'
});
Workbook.prototype.insertColumn = function (startColumn, endColumn, sheet) {
this.notify(insertModel, { model: this.getSheetModel(sheet), start: startColumn, end: endColumn,
modelType: 'Column' });
};

@@ -318,3 +321,3 @@ /**

* {% codeBlock src='spreadsheet/delete/index.md' %}{% endcodeBlock %}
* @param {number | RowModel[]} startIndex? - Specifies the start sheet / row / column index.
* @param {number} startIndex? - Specifies the start sheet / row / column index.
* @param {number} endIndex? - Specifies the end sheet / row / column index.

@@ -325,11 +328,34 @@ * @param {ModelType} model? - Specifies the delete model type. By default, the model is considered as `Sheet`. The possible values are,

* - Sheet: To delete sheets.
* @param {number | string} sheet? - Specifies the sheet name or index in which the delete operation will perform. By default,
* active sheet will be considered. It is applicable only for model type Row and Column.
* @returns void
*/
Workbook.prototype.delete = function (startIndex, endIndex, model) {
Workbook.prototype.delete = function (startIndex, endIndex, model, sheet) {
startIndex = startIndex || 0;
var sheetModel;
if (!model || model === 'Sheet') {
sheetModel = this;
}
else {
sheetModel = this.getSheetModel(sheet);
if (!sheetModel) {
return;
}
}
this.notify(deleteModel, {
model: !model || model === 'Sheet' ? this : this.getActiveSheet(), start: startIndex,
end: isNullOrUndefined(endIndex) ? startIndex : endIndex, modelType: model || 'Sheet'
model: sheetModel, start: startIndex, end: isNullOrUndefined(endIndex) ? startIndex : endIndex, modelType: model || 'Sheet'
});
};
Workbook.prototype.getSheetModel = function (sheet) {
if (isNullOrUndefined(sheet)) {
return this.getActiveSheet();
}
else {
var index = typeof sheet === 'string' ? getSheetIndex(this, sheet) : sheet;
if (isNullOrUndefined(index) || index >= this.sheets.length) {
return null;
}
return this.sheets[index];
}
};
/**

@@ -400,11 +426,15 @@ * Used to merge the range of cells.

*/
Workbook.prototype.setUsedRange = function (rowIdx, colIdx) {
var sheet = this.getActiveSheet();
Workbook.prototype.setUsedRange = function (rowIdx, colIdx, sheet) {
if (sheet === void 0) { sheet = this.getActiveSheet(); }
if (rowIdx > sheet.usedRange.rowIndex) {
sheet.usedRange.rowIndex = rowIdx;
this.notify(updateUsedRange, { index: rowIdx, update: 'row' });
if (sheet === this.getActiveSheet()) {
this.notify(updateUsedRange, { index: rowIdx, update: 'row' });
}
}
if (colIdx > sheet.usedRange.colIndex) {
sheet.usedRange.colIndex = colIdx;
this.notify(updateUsedRange, { index: colIdx, update: 'col' });
if (sheet === this.getActiveSheet()) {
this.notify(updateUsedRange, { index: colIdx, update: 'col' });
}
}

@@ -411,0 +441,0 @@ };

@@ -69,3 +69,3 @@ import { getRangeIndexes, inRange } from '../common/index';

option: chart[i], chartCount: this.parent.chartCount, isInitCell: args.isInitCell, isUndoRedo: args.isUndoRedo,
dataSheetIdx: args.dataSheetIdx, range: args.range
dataSheetIdx: args.dataSheetIdx, range: args.range, isPaste: args.isPaste
});

@@ -72,0 +72,0 @@ this.parent.chartColl.push(chart[i]);

@@ -370,3 +370,4 @@ /* tslint:disable-next-line:max-line-length */

var cellArgs = new ValueChangedArgs(rowIdx + 1, colIdx + 1, value);
this.calculateInstance.valueChanged(sheetName, cellArgs, true);
var usedRangeCol = [this.parent.getActiveSheet().usedRange.rowIndex, this.parent.getActiveSheet().usedRange.colIndex];
this.calculateInstance.valueChanged(sheetName, cellArgs, true, usedRangeCol);
var referenceCollection = this.calculateInstance.randCollection;

@@ -373,0 +374,0 @@ if (this.calculateInstance.isRandomVal === true) {

@@ -59,8 +59,17 @@ /**

var result = reader.result.toString();
if (result.indexOf('data:text/plain;base64,') > -1 || result.indexOf('data:text/html;base64,') > -1) {
if (result.indexOf('data:text/plain;base64,') > -1 || result.indexOf('data:text/html;base64,') > -1 ||
result.indexOf('data:application/json;base64,') > -1) {
var str = void 0;
result = result.replace('data:text/plain;base64,', '');
result = result.replace('data:text/html;base64,', '');
var str = atob(result).split(/(\r\n|\n|\r)/gm);
if (result.indexOf('data:application/json;base64,') > -1) {
result = result.replace('data:application/json;base64,', '');
str = atob(result).split('.');
}
else {
str = atob(result).split(/(\r\n|\n|\r)/gm);
}
if (str.length) {
postMessage({ dialog: str[0] });
var text = str[0].length > 1 && str[0][0] === '"' ? str[0].split('"')[1] + '.' : str[0];
postMessage({ dialog: text });
}

@@ -67,0 +76,0 @@ }

Sorry, the diff of this file is too big to display

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is too big to display

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is too big to display

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is too big to display

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is too big to display

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is not supported yet

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc