Shape Effects Lost When Copying Worksheets Between Workbooks

[kentyap1997]

I'm using Spire.XLS in a C# application to consolidate multiple Excel files into a single workbook. My goal is to preserve all content, including shapes with visual effects (such as glow, shadow, reflection, and bevel).

Issue:
When I copy worksheets from a source workbook to a new workbook, the shapes themselves are copied, but any effects applied to them are lost in the resulting file.

Steps Taken:
-Loaded the source workbook via Workbook.LoadFromFile(...)
-Created a new target workbook.
-Tried both methods:
targetWorkbook.Worksheets.AddCopy(sourceSheet, WorksheetCopyType.CopyAll)
targetSheet.CopyFrom(sourceSheet, true)
-Called targetWorkbook.CopyTheme(sourceWorkbook) before copying.
-Cleared default worksheets from the new workbook.
-Saved the final file using Workbook.SaveToFile(path, ExcelVersion.Version2016)

Observations:
Shapes are present in the new workbook, but their visual effects (like glow, shadow, etc.) are missing.
Tried both AddCopy and CopyFrom, but neither preserved the effects.
CopyTheme() had no visible impact on the issue.

Expected Result:
The copied sheets should retain all shape formatting and effects exactly as they appear in the original workbook.

Environment:
Spire.XLS version: 14.7.2.0
.NET Framework version: 4.0
OS: Windows 10 Pro

Request:
Is this a known limitation of Spire.XLS when copying shape objects between workbooks?
Is there a workaround or additional method required to retain shape visual effects?
If not currently supported, is this feature planned for a future version?

[Nina.Tang]

Hi,

Thank you so much for taking the time to provide such thorough details.
I have reproduced the issue and logged it into our bug tracking system with the issue ID: SPIREXLS-5804. Once it is resolved or there is any update, I will notify you immediately. Apologize for the inconvenience caused.

Sincerely,
Nina
E-iceblue support team

[Nina.Tang]

Hi,

Thanks for your patient waiting.

Glad to inform you that the reported bug SPIREXLS-5804 has been resolved and the new version (Spire.XLS Pack(Hotfix) Version:15.6.6) is available. Please download it from the following link.

Websit download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link：https://www.nuget.org/packages/Spire.XLS
https://www.nuget.org/packages/Spire.XLSfor.NETStandard

Sincerely,
Nina
E-iceblue support team