Free Support Forum - aspose.com

Error setting valid formula

Hello,

I'm receiving an error when setting a formula in Excel (aspose.cells) for java.

When I use the same formula in Excel it works fine !?

Is there a limitation in the formula length ?

My formula : "=INDEX(K4:X4;1;(MATCH(OFFSET(J6;0;MATCH(0;J6:X6;-1);1;1);K6:
X6;0)))"

Thanks,

Goddeau Hendrik

Same for :

received Java exception "java.lang.IllegalArgumentException: Unsupported
formula : =IF(J3='Y';J6-F5;J6)." when calling method "setFormula" with
signature "(Ljava.lang.String;)V" in class "com.aspose.cells.Cell".

Hi,

Thanks for considering Aspose.

Could you post your template file to show the issue.

Thank you.

Hi,

In the formula of Aspose.Cells, we only support "," as param seperator of the function , not support ";" as param seperator of the function. Please change your formula as "= sum(A1,A2)".