Hi,

Conditional formats don't seem to be preserved when a spreadsheet opened in Aspose is saved as Xml.

For example, the attached spread sheet has conditional formats in the first three cells of the first row.

The following code opens the book and save it as Xml:

Workbook workbook = new Workbook();
workbook.Open("c:\\conditionalformatting.xls", FileFormatType.Default);

workbook.Save("c:\\conditionalformatting.xml", FileFormatType.SpreadsheetML);

The resulting Xml does not contain the same conditional formats in the orignal spreadsheet.

Is this a known bug and if so, would there be a fix for it?

-Steve

Hi Steve,

Currently, condtional formattings would be lost if you save the excel file as SpreadsheetML .xml file. We will support this feature soon for your requirement.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us

Thanks for your reply Amjad.

Any idea whe this feature would be implemented?

Hi,

Thanks for following up.

We will support it soon. Hopefully we can provide the fix within 1-2 weeks time.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us

Hi,

 

Please try the attached version.

The conditional formatting feature of SpreadsheetXml file format is supported now.

Thank you.

---

Karen Huang
Developer
Aspose Nanjing Team
About Us
Contact Us

Thanks. The fix works good.