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

If same field of colums or rows is used for data, "Pivot table content error" is displayed when excel file is opened. #1203

Closed
sis6789 opened this issue Apr 19, 2022 · 2 comments
Closed

If same field of colums or rows is used for data, "Pivot table content error" is displayed when excel file is opened. #1203

sis6789 opened this issue Apr 19, 2022 · 2 comments
Labels
confirmed This issue can be reproduced
Projects
v2.6.1

Comments

@sis6789
Copy link

sis6789 commented Apr 19, 2022

Description

If same field of colums or rows for data, "Pivot table content error" is displayed when excel file is opened.

Steps to reproduce the issue:

  1. run follwoing code. I have changed line 36 from your pivot example.
  2. open the generated excel file.
  3. excel complains content error and prompts recovery of excel file.

Describe the results you received:
Pivot table content error and recovery prompt.

Describe the results you expected:
Normal open of generated excel fie without complain.

Output of go version:

go version go1.18 windows/amd64

Excelize version or commit ID:

github.com/xuri/excelize/v2 v2.6.0

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Windows11, Excel 2203(build 15028.20204)
@sis6789
Copy link
Author

sis6789 commented Apr 19, 2022

main.txt

@sis6789 sis6789 changed the title If same field of colums or rows for data, "Pivot table content error" is dis[layed when excel file is opened. If same field of colums or rows is udef for data, "Pivot table content error" is dis[layed when excel file is opened. Apr 19, 2022
@sis6789 sis6789 changed the title If same field of colums or rows is udef for data, "Pivot table content error" is dis[layed when excel file is opened. If same field of colums or rows is udef for data, "Pivot table content error" is displayed when excel file is opened. Apr 19, 2022
@sis6789 sis6789 changed the title If same field of colums or rows is udef for data, "Pivot table content error" is displayed when excel file is opened. If same field of colums or rows is used for data, "Pivot table content error" is displayed when excel file is opened. Apr 19, 2022
@xuri xuri added confirmed This issue can be reproduced in progress Working in progress labels Apr 19, 2022
@xuri xuri closed this as completed in c2be30c Apr 19, 2022
@xuri
Copy link
Member

xuri commented Apr 19, 2022

Thanks for your issue. I have fixed it. Please upgrade to the master branch code, and this patch will be released in the next version.

@xuri xuri removed the in progress Working in progress label Apr 19, 2022
@covv covv mentioned this issue May 31, 2022
Closed
@xuri xuri added this to Bugfix in v2.6.1 Jul 7, 2022
xuri added a commit to carbin-gun/excelize that referenced this issue Oct 9, 2022
@xuri
This closes qax-os#1203, supporting same field used for pivot table d…
3b14d7f 
…ata and rows/cols
xuri added a commit to JDavidVR/excelize that referenced this issue Jul 11, 2023
@xuri
This closes qax-os#1203, supporting same field used for pivot table d…
103bc6d 
…ata and rows/cols
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
@xuri
This closes qax-os#1203, supporting same field used for pivot table d…
871daf0 
…ata and rows/cols
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
confirmed This issue can be reproduced
Projects
No open projects
v2.6.1
Bugfix
Milestone
No milestone
Development

No branches or pull requests
2 participants
@xuri @sis6789