search

handsontable / handsontable

JavaScript data grid with a spreadsheet look & feel. Works with React, Angular, and Vue. Supported by the Handsontable team ⚡
https://handsontable.com
Other
19.15k stars 2.94k forks source link

[Bug]: A bug caused by sheetRename #10928

Open yanyinqing opened 4 weeks ago

yanyinqing commented 4 weeks ago

Describe the bug

If I want to update the sheetName of a sheet, but the data of other sheets will be disordered, the example is as follows.The third picture is just running, and the fourth chapter is after clicking rename button. First, the formula of my second sheet is not calculated, and secondly, the third cell that is obviously empty inherits the third cell of the first sheet.

Video/Screenshots

image image image image image

Provide a link to the demo with the bug reproduction

No response

Handsontable version

14.3.0

Framework version

vue2.7.0

Your environment

edge MacOS

adrianszymanski89 commented 4 weeks ago

Hi @yanyinqing

We recently fixed a bug related to this. Can you please try this approach?

First, obtain the sheet id this way:

let id = hyperformulaInstance.getSheetId('Sheet1')

Then, rename it like this:

hyperformulaInstance.renameSheet(id, 'Lorem Ipsum')