CUBEMEMBER and CUBERANKEDMEMBER functions not supported

Aspose.Cells Product Family
1

Currently those 2 functions are not supported in Cells for .NET. Is there an estimate for when they will be?

Thank you.

2

@manikya.rao,

Yes, Aspose.Cells formula calculation engine may not calculate CUBEMEMBER and CUBERANKEDMEMBER functions. If will be better if you could provide sample Excel file containing those two formulas for evaluation, you may create the file manually in MS Excel and attach here (please zip the Excel file prior attaching). I have logged a ticket with an id “CELLSNET-50285” for your issue/requirements. We will look into it soon.

Once we have an update on it, we will let you know here.

3

I have attached the inputFile, also a WebApp which contains the sample code reproducing this issue:

    using (FileStream fs = File.OpenRead(Server.MapPath("/File") + "\\inputFile.xlsx"))
    {
        var wb = new Workbook(fs);
        wb.CalculateFormula(new CalculationOptions
        {
            IgnoreError = false
        });
    };

inputFile.zip (7.4 KB)
WebApp.zip (15.3 KB)

4

@manikya.rao,

Thanks for the sample Excel file.

We have recorded your provided sample file and code in your existing ticket “CELLSNET-50285” into our database. We will evaluate the unsupported functions soon.

5

@manikya.rao,

We are afraid we cannot support such kind of functions because there is not any data in the template file about the connection and data source. Even with connection-related information, we are afraid connecting to an external data source and performing certain operations still poses user-concerned security risks and other problems.

For such kind of functions, you may implement the calculation by yourselves through AbstractCalculationEngine(Class AbstractCalculationEngine | Aspose.Cells for .NET API Reference) with “true” value for property ProcessBuiltInFunctions(AbstractCalculationEngine.ProcessBuiltInFunctions | Aspose.Cells for .NET API Reference).