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 modified ClosedXML file opens in Excel with an error. #1195

Closed
1 task done
b0bi79 opened this issue Apr 30, 2019 · 0 comments · Fixed by #1196
Closed
1 task done

The modified ClosedXML file opens in Excel with an error. #1195

b0bi79 opened this issue Apr 30, 2019 · 0 comments · Fixed by #1196
Labels
bug
Milestone
v0.95

Comments

@b0bi79
Copy link
Member

b0bi79 commented Apr 30, 2019 •
edited
Loading

Do you want to request a feature or report a bug?

  • Bug

Version of ClosedXML

e.g. 0.95.0-beta1

Did this work in previous versions of our tool? Which versions?

No

Reproducibility

I created in MS Excel a file containing two Pivot on different sheets, the data source for which is a table with data. Then I opened this file in ClosedXML and changed the data in the data table and saved the file. When opening the received file, MS Excel displays an error:
Deleted component: Component /xl/pivotTables/pivotTable1.xml. (Summary Table View)
Deleted Records: PivotTable Report from Part /xl/workbook.xml (Book)

Code to reproduce problem:
see referenced PR

Failure xlsx-file
b0bi79 added a commit to b0bi79/ClosedXML that referenced this issue Apr 30, 2019
@b0bi79
Fix error by two pivot with one source ClosedXML#1195
23bad73
igitur pushed a commit to b0bi79/ClosedXML that referenced this issue Jun 10, 2019
@b0bi79 @igitur
Fix error by two pivot with one source ClosedXML#1195
b120c46
@b0bi79 b0bi79 mentioned this issue Jun 10, 2019
Merged
@igitur igitur added the bug label Jun 10, 2019
@igitur igitur added this to the v0.95 milestone Jun 10, 2019
igitur pushed a commit that referenced this issue Jun 12, 2019
@b0bi79 @igitur
Fix error by two pivot with one source #1195 (#1196)
85916ea 
Fix errors regarding multiple pivot tables with single pivot table cache
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
v0.95
Development

Successfully merging a pull request may close this issue.

Fix error by two pivot with one source #1195 b0bi79/ClosedXML
2 participants
@igitur @b0bi79