Hello!

I have this formula in my spreadsheet:

= O24 * J10 * (1-J8/100) *(1 - J9/100)

this formula give an error when execute the program. Where is the error? I changed it to:

= O24 * J10 * (1-J8/100 - J9/100 + J8/100*J9/100)

this formula don't give error but the result is not correct, when validate the formula in excel, the result change and give the correct result.

Aspose excel calculate this:

= O24 * J10 * (1-J8/100 - J9/100 + J8/(100*J9/100))

and Excel calculate:

= O24 * J10 * (1-J8/100 - J9/100 + (J8/100)*(J9/100))

I resolved this issue with this change:

= O24 * J10 * (1-J8/100 - J9/100 + J8*J9/10000)

but Aspose have a error calculating formula and interpreting parenthesis.