Error setting valid formula

HGOAS4 · July 3, 2017, 1:09am

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

HGOAS4 · July 3, 2017, 1:09am

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".

Amjad_Sahi · July 3, 2017, 1:09am

Hi,

Thanks for considering Aspose.

Could you post your template file to show the issue.

Thank you.

Warren · July 3, 2017, 1:09am

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)".