Summ with Conditional Format returns 0

[amestre]

See the attached ZIP (XLSX and PDF) for an example the problem:

In cell B10, there is a sum with a conditional format. When converting into PDF with Aspose.Cells Java, it turns out as ‘grey/0’ instead of ‘green/12’. If the sum is done without conditional formatting (cell H10), it’s calculated correctly.

Can you reproduce this problem and if so, what’s your advice?

Thanks,
Thomas

[Amjad_Sahi]

Hi,

Thanks for the template files.

Please try our latest version/fix Aspose.Cells for Java v8.6.0:

http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/entry657707.aspx

I have tested using the following sample code and it works fine with it:

e.g

Sample code:

Workbook workbook = new Workbook(“Conditional Format.xlsx”);

workbook.save(“out1.pdf”);

Thank you.

[amestre]

Thanks, I can confirm that with Aspose.Cells for Java 8.6.0 all works as expected.

Regards,
Thomas

[Amjad_Sahi]

Hi,

Thanks for your feedback.

Good to know that your issue is fixed by our latest version/fix. Feel free to write back if you have further comments or questions, we will be happy to assist you soon.

Thank you.