Aspose.Cells for .NET : function IFERROR

Hi,

Can i request this function to be supported in the next update?

Thanks.

Hi,


Thank you for using Aspose.Cells.

Can you please tell us how are you trying to use this function using Aspose.Cells in your code? Aspose.Cells does not support formula functions as listed at this LINK.

A simple usage example may be:

Workbook workbook = new Workbook();
workbook.Worksheets[0].Cells["A1"].PutValue(10);
Cell cell = workbook.Worksheets[0].Cells["B1"];
cell.Formula = "=IFERROR(A1/0,2334)";
workbook.CalculateFormula();
workbook.Save("K://Temp.xlsx");

Let us know your feedback and we will try to assist you in a more better manner.

Sorry my mistake,

I saw in this site

http://www.aspose.com/docs/display/cellsnet/List+of+Supported+Functions

that IFERROR is not supported so i did make the request.

Thanks

Hi,


It’s OK. The link that you have mentioned is actually for Grid controls of Aspose.Cells product. The Aspose.Cells supported formula functions are mentioned just above that as you can see in the attached screenshot.

hahaha i think i didn't saw it properly. I just searched from google and it link to the grid page.

thank you for clarifying

Hi,

Thanks for your posting and using Aspose.Cells.

You are right.

Actually, confusion occurred because Aspose.Cells for GridWeb although a separate component but it is now a part of Aspose.Cells for .NET, so their documentation is combined and it sometimes confuses the readers.