We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Summ with Conditional Format returns 0

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

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.


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

Regards,
Thomas

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.