Aspose.Cells for Java changes certain conditional formats

Aspose.Cells Product Family
21

The issue we are facing again is: certain conditional formats (such that set color to white for values=0) set the border color to white, too.
I’ve reattached our testcase for that problem.

22

We have isolated another issue we have when calculating using aspose, i’ve attached a single testcase that reproduces it.

The problem is: in the 6th row, 4 values are calculated.

It should show 0,21,21,0 (openoffice and excel do show so)

Aspose calculates 21,0,21,0


Thanks for your effort,
Christian Wendt

23

Yes, this fix resolves the problem with the conditional formats.

The second testcase i posted still fails -
(5,3)=21.0(5,4)=0.0(5,5)=21.0(5,6)=0.0 <- is what aspose returns

it should be 0,21,21,0

Thanks for the quick response

24

Hi,

Thanks for reporting.

We found the problem and will figure it out soon.

Thank you.

25

Hi,

Please try this fix.

It's caused by that we treated the "" string value as null.

26

Thanks for the quick response, the fix looks great - it passes all our testcases.


Best regards,
Christian Wendt