ClosedXML: Conditional formatting consolidation break priority ordering

Read and complete the full issue template

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

• Bug
• Feature

Version of ClosedXML

0.92.0

What is the current behavior?

The sequence of “conditional formatting rules” has been changed after export Excel by using ClosedXML in my program

What is the expected behavior or new feature?

The sequence should not be changed in Excel template after export excel.

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

No

Reproducibility

This is an important section. Read it carefully. Failure to do so will cause a ‘RTFM’ comment.

Without a code sample, it is unlikely that your issue will get attention. Don’t be lazy. Do the effort and assist the developers to reproduce your problem. Code samples should be minimal complete and verifiable. Sample spreadsheets should be attached whenever applicable. Remove sensitive information.

Code to reproduce problem:

public void Main()
{
      using (XLWorkbook workbook = new XLWorkbook(@"FAI.xlsm"))
   {
       workbook.Save();
   }
}

• I attached a sample spreadsheet. (You can drag files on to this issue) test4.xlsx