Unsupported Formulas

Aspose.Cells Product Family
1

Would it be possible to add support for formulas for which you have not already coded your parsing routines to handle?

For example, I need to use the CountIf() in Excel. But you haven't programmed support for this function. So I can't.

Perhaps you could find a way for us to assign our own formula values and tell Aspose.Excel not to parse, interpret, or include in the Calculate() function, but just store it as a formula in the referenced cell.

This would allow for much more flexibility on my end as a programmer because I could use "formulas" for which you haven't programmed yet.

If cells have referenced this cell such that it would require the "formula you don't support" to calculate, you could always throw some exception. I would much rather deal with this than wait for you to program every "formula".

Thanks for your time.

2

Please try this attached fix. CountIf function is supported now.

3

Thanks for your quick reply!

4

@richcouch,
Aspose.Cells has replaced Aspose.Excel that is no more available now. You can work with all the formulas which are supported by MS Excel. Here is an example that demonstrates the usage of COUNTIF(). It uses an existing workbook where data is counted based on different criteria.

Workbook workbook = new Workbook("Book1.xlsx");
workbook.Worksheets[0].Cells["F3"].Formula = "=COUNTIF(C3:C10,\">100\")";
workbook.Worksheets[0].Cells["F4"].Formula = "=COUNTIF(A3:A10,\"jim\")";
workbook.Worksheets[0].Cells["F5"].Formula = "=COUNTIF(B3:B10,\"CA\")";
workbook.CalculateFormula();
workbook.Save("Book2.xlsx");

Here is a detailed article about working with formulas:
Formulas

Download the latest trial version here:
Aspose.Cells for .NET (Latest Version)

Download a complete runnable solution here to test a variety of features of this product.