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

Can't copy sheet's chart when using sheet copy function #1319

Closed
NewBeeCxd opened this issue Apr 25, 2024 · 1 comment
Closed

Can't copy sheet's chart when using sheet copy function #1319

NewBeeCxd opened this issue Apr 25, 2024 · 1 comment
Labels
bug duplicate

Comments

@NewBeeCxd
Copy link

NewBeeCxd commented Apr 25, 2024 •
edited
Loading

NPOI Version

2.7.0.0 for .net

File Type

  • XLSX

Upload the Excel File

[
test.zip
](url)

Reproduce Steps

Issue Description

Here are issues when copy the sheet which has charts.

  • Using IWorkbook.CloneSheet(sheet_index)
  1. Open Workbook which has sheet , it has some charts.
  2. Call IWorkbook.CloneSheet(sheet_index) function.
  3. Save and close.
  4. Open in excel, show message file is broken. excel try to fix it. after fix finish. Charts are missing in copied sheet.

-Using ISheet.CopyTo(wb,name,true,true)

  1. Open Workbook which has sheet , it has some charts.
  2. Call ISheet.CopyTo(wb,name,true,true) function.
  3. Save and close.
  4. Open in excel, it open normally, but copied sheet's charts are lost.
@NewBeeCxd NewBeeCxd added the bug label Apr 25, 2024
@tonyqus
Copy link
Member

tonyqus commented Apr 27, 2024

duplicate with #1300

@tonyqus tonyqus closed this as completed Apr 27, 2024
@tonyqus tonyqus mentioned this issue May 6, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug duplicate
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@tonyqus @NewBeeCxd