Conditional formatting not getting copied with Copy funciton

[ykgw-shashikumar]

EPPlus usage

Commercial use (I have a commercial license)

Environment

Windows 11, Ubuntu 16

Epplus version

7.1.2, 7.5.0, 8.6.0

Spreadsheet application

Excel from "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"

Description

Hi Team,

We have noticed 1 issue with respect to conditional formatting, that seems to be working in older version like 7.5.0 and it is not working in latest 8.6.0.
After copying the template sheet , in copied sheets of new workbook conditional formatting is lost.

Code:
for (int i = 1; i <= copyCount; i++)
{
package.Workbook.Worksheets.Copy(
sourceSheet.Name, $"{sheetName}_{i}");
}

Attached is the template and copied sheets.

[OssianEPPlus]

There does not appear to be a template nor copied sheets attached? We cannot verify without them.

[ykgw-shashikumar]

Hi, please find the attached xls sheets.

There is template sheet (Cabinet_template_test_clean.xlsx) and coped sheet (Copied_file_clean.xlsx).

Ideally target should sheet should be without borders (as entries are none).

However it is of this nature.

This needs to be fixed.

Copied_file_clean.xlsx
Cabinet_template_test_clean.xlsx

[OssianEPPlus]

This issue appears to be unrelated to the copying of worksheets. It's enough to simply save the workbook to cause it to happen. All conditionalformattings remain but their connections to different styles get disrupted as their styleIDs get missmatched. We're working on a fix

[OssianEPPlus]

This has been fixed with release of Epplus 8.6.1