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.

Sign up for GitHub

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

Jump to bottom

The document is broken and needs to be restored when opened #774

Closed
ceearrashee opened this issue Feb 1, 2021 · 7 comments
Closed

The document is broken and needs to be restored when opened #774

ceearrashee opened this issue Feb 1, 2021 · 7 comments

Comments

@ceearrashee
Copy link

Description
Hello again!

Some times ago, I wrote about the pre-configured Excel document as a template. In this template added Tab General with difference pivots tables and diagrams. And I have the same bug as a previous. Thank you!

Steps to reproduce the issue:

  1. Open this document and restore using MS Excel and save.
  2. Use your package to add any data to sheet "Answers" and save the document.
  3. Reopen document in MS Excel.

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Windows 10 20H2, Microsoft Excel™ 2019

Attached document
survey-results.xlsx
@xuri
Copy link
Member

xuri commented Feb 1, 2021

Thanks for your feedback, could you provide the original template xlsx file (before you open it by Excelize)?

@ceearrashee
Copy link
Author

Thanks for the promptness, I attach the original template.

Gallup Q12.xlsx

@ceearrashee
Copy link
Author

Today my colleagues simply modified template.

It may also be useful.
Template.xlsx
Genereated-result.xlsx

@xuri
Copy link
Member

xuri commented Feb 1, 2021

I have added some data to the worksheet "Answers", save the document and it works well, maybe it's related to a data value, could you provide more detailed info or exactly minim step to reproduce this issue?

@ceearrashee
Copy link
Author

ceearrashee commented Feb 1, 2021 •
edited
Loading

Okay, I'm implementing a data generation mini app, but this will take some time.

@ceearrashee
Copy link
Author

I've attached mini-app there data generation broke the document.

exelize-bug.zip

@xuri xuri added the in progress Working in progress label Feb 2, 2021
@xuri xuri closed this as completed in 1f329e8 Feb 2, 2021
@xuri
Copy link
Member

xuri commented Feb 2, 2021

I have fixed it, please try to use the master branch code, and this patch will be released in the next version.

@xuri xuri removed the in progress Working in progress label Feb 2, 2021
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
@xuri
This closes qax-os#774, closes qax-os#775 and closes qax-os#776
c036054 
- correct adjust calculation chain in duplicate rows
- correct adjust defined name in the workbook when delete worksheet
- use absolute reference in the auto filters defined name to make it compatible with OpenOffice
- API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format
- Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@xuri @ceearrashee