Please add support for CORREL formula

Aspose.Cells Product Family
1

I didn’t see the CORREL formula listed in the help file as a supported built-in function. I’d really appreciate it if support for that particular formula could be added.

Thanks.

2

OK. I will add it in the next hotfix.

3

@javadogger,
Aspose.Cells has replaced Aspose.Excel that is no more actively developed now and is discarded. This new product Aspose.Cells has support for all the latest features available in different versions of MS Excel. You can use CORREL and a lot of other functions that are supported by MS Excel as demonstrated in the following example code:

Workbook workbook = new Workbook();
int[] X = new int[] {1,3,2,7,9,11};
int[] Y = new int[] {2,4,3,8,10,11};
workbook.Worksheets[0].Cells.ImportArray(X, 1, 0,true);
workbook.Worksheets[0].Cells.ImportArray(Y, 1, 1, true);
workbook.Worksheets[0].Cells["A8"].Formula = "=CORREL(A2:A7,B2:B7)";
workbook.Save("output.xlsx");

For a complete list of functions that are supported by Aspose.Cells is given below:
Supported Formula Functions
Formula

The latest free trial version of this new product can be downloaded here:
Aspose.Cells for .NET(Latest version)

Here is a runnable complete solution which contains lot of examples to test different features of Aspose.Cells.