Calculation of Complex Formulas

Aspose.Cells Product Family
1

We use excel to perform businesslogic and therefore need to calculate some complex formulas. Our formulas and input values are distributed over multiple spreadsheets. In this specific case we have problems with formulas using XOR
e.g.
WENN(UND(ODER(VERWEIS(A2;Maßnahmen!MaßnahmenId;Maßnahmen!ArbeitsschrittId)=Arbeitsschritte!$B$5);NICHT(XODER(NICHT(ISTNV(SVERWEIS(Maßnahmenarten!$B$63;Maßnahmen!MaßnahmenartId;1;0)));NICHT(ISTNV(SVERWEIS(Maßnahmenarten!$B$64;Maßnahmen!MaßnahmenartId;1;0)))));ODER(VERWEIS(A2;Maßnahmen!MaßnahmenId;Maßnahmen!MaßnahmenartId)=Maßnahmenarten!$B$63;VERWEIS(A2;Maßnahmen!MaßnahmenId;Maßnahmen!MaßnahmenartId)=Maßnahmenarten!$B$64));"Das Einmauern einer Badewanne oder einer Brausetasse schließt sich gegenseitig aus";WAHR)

Excel can handle this kind of formulas without a problem and returns the right results but aspose.cells returns “#NAME?”

We are currently using Aspose.Cells Version 20.1.0 for .Net 4.5.2 and have full licence.

If this kind of support falls in the category “Paid Support” please give us a short description on how to get paid support.

Thanks
Christopher Preinsperger

2

@aceneue,

We recommend you to kindly give it a try using Aspose.Cells for .NET v20.6 if it makes any difference as we continuously enhance Aspose.Cells formula calculation engine with each new release of the product. If you still find the issue, kindly give us your template Excel file and share the simplest sample code segment to demonstrate the issue, we will check it soon.

You may post your query regarding get paid support in Aspose.Purchase section. One of our sales staff member will help you soon.