Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

broke xlsx file when InsertRow #421

Closed
dmp73 opened this issue Jun 7, 2019 · 2 comments
Closed

broke xlsx file when InsertRow #421

dmp73 opened this issue Jun 7, 2019 · 2 comments
Labels
enhancement New feature or request

Comments

@dmp73
Copy link

dmp73 commented Jun 7, 2019

Excelize broke xlsx file when InsertRow and sheet contain some summarized cells.
For example

 A

1 1
2 2
3 3
4 4
5 5
6 15

Sum in cell A6.
xlsx.InsertRow("Sheet1", 2) and as result file is broken.

@xuri
Copy link
Member

xuri commented Jun 7, 2019

HI @dmp73, thanks for your issue. Use this method with caution, which will affect changes in references such as formulas, charts, and so on. If there is any referenced value of the worksheet, it will cause a file error when you open it. The excelize only partially updates these references currently. I will add formula adjust support for this function later.

@xuri xuri added the enhancement New feature or request label Jun 7, 2019
xuri added a commit that referenced this issue Jun 7, 2019
@xuri
Copy link
Member

xuri commented Jun 7, 2019

Hi @dmp73, I have fixed it. Please try to upgrade the library with the master branch code.

@xuri xuri closed this as completed Jun 7, 2019
nullfy pushed a commit to nullfy/excelize that referenced this issue Oct 23, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants