Aspose errors for excel formulas

Aspose.Cells Product Family
1

Hi Team,
We are using Aspose.cells version 20.3.0, When we are passing excel template to aspose library and when we call WorkbookDesigners Process function we get error for below formulas which were working fine previously in .Net framework project.
Formula -----> Error

  1. &=&=IF(OR(Data!B{r}=0,Data!B{r}=" "),value1,value2)) ----> Invalid reference for sign ’ ’
  2. &=&=NOW()(noadd) ----> Invalid function name(NOW())
  3. &=&=(AD{r}-AF{r}){ROUND,4} ----> Unrecognized: {ROUND,4}
  4. &=&=Text(Data!B{r},“DD/MM/YYY”)(noadd) ----> Invalid function name(Text(Data!B1,“DD/MM/YYY”))
  5. &=&=IF(N{r}<>"",IF(IFERROR(FIND(".",N{r}),-1)<>-1,SUBSTITUTE(N{r},".","")N{r},),"") ----> Unrecognized:

Could you check and let me know what changes to be done

2

@Umeshb,

Please try our latest version/fix: Aspose.Cells for .NET v22.3 (Download | NuGet).

If you still find the issue with latest version/fix, kindly create a standalone sample console application (source code without compilation errors), zip the project and post us with sample files (input file (if any) and output file, etc.), we will check it soon.