Laurence,

I’m having a problem with the Aspose excel component that I’d like you to look into. I am setting cell.formula programatically to a VLOOKUP for each row. If the formula looks like this:

=VLOOKUP(H{r},ValidCategories!$A$2B$62000,2,FALSE)

It works with no problems. If I enhance the formula to filter out N/A values like this, I get an error when attempting to save the spreadsheet.=IF(ISNA(VLOOKUP(H{r},ValidCategories!$A$2B$62000,2,FALSE)), “”, VLOOKUP(H{r},ValidCategories!$A$2B$62000,2,FALSE))

Note: I’m replacing the {r} with the current row number in my code this isn’t coming from a template.

The error produced is:

Invalid formula in data validation settings.

Stack trace:

at Aspose.Excel.Record.aj.c(String A_0)

at Aspose.Excel.Record.aj.a(Validation A_0, String A_1)

at Aspose.Excel.Record.aj.a(Validation A_0)

at Aspose.Excel.Worksheet.c(bn A_0)

at Aspose.Excel.Worksheets.b(bn A_0)

at Aspose.Excel.Worksheets.a(UCOMIStream A_0)

at Aspose.Excel.Record.c5.a(c3 A_0, t A_1, Worksheets A_2)

at Aspose.Excel.Worksheets.a(String A_0, SaveType A_1, FileFormatType A_2, HttpResponse A_3)

Thanks!

Kris