=SUMIF(G2:G21-">"&0-G2:G21) not working

=SUMIF(G2:G21,">"&0,G2:G21) not working for me. It gives output as 0 when I get it from aspose. But excel sheet gives me 634. I’m using aspose version 8.0.2. Kindly help.

Hi Vinod,


Thank you for contacting Aspose support.

Unfortunately, it is hard to tell what is causing the said problem unless we review your sample spreadsheet as well as the source code. We would request you to please give a try to the latest version of Aspose.Cells for Java 8.2.1 a try in your original application. In case the problem persists, please provide us your sample spreadsheet along with the code snippet to replicate the problem on our end.