Free Support Forum - aspose.com

Preserving Conditional Formatting when Saving as SpreadsheetXml

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.

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.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached version.

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

Thank you.

Thanks. The fix works good.