Conditional formatting is not retaining after excel is processed in Aspose dll.
Below are the details:
Dll Name : Aspose.Cells
Below is the code snippet–
Workbook sourceWorkbook = new Workbook(@“ConditionalFormattingIssue.xlsx”);
attached below files
“ConditionalFormattingIssue.xlsx” —> File before processing in Aspose dll
“ConditionalFormattingIssue_Output.xlsx” --> File after processing in Aspose dll
“ConditionalFormattingIssue_Output_1.xlsx” --> File created after opening “ConditionalFormattingIssue_Output.xlsx” file and saved the file using “SaveAs” functionality.
Here on opening of “ConditionalFormattingIssue_Output_1.xlsx” file it showing some error and it loosing conditional formatting. (might be some configuration related to conditional formatting is loosing after processing in Aspose Dll)
If you have any doubts please reach out to us.
ConditionalFormattingIssue.zip (20.4 KB)