Support for SUBTOTAL Function

Aspose.Cells Product Family
1

Hi,



Would it be possible for Aspose.Cells to support the Subtotal function in .NET? Having this function would save us alot of time to implement our own version of it.



Thanks,



Stephen Tung

Software Developer

Clarity Systems

2

Hi,

Thanks for considering Aspose.

Well, Aspose.Cells Formula Calculation Engine allows you to set or read the SubTotal formula using Cell.Formula property but currently does not support it to calculate the results at runtime using Workbook.CalculateFormula() method, kindly check: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/supported-formulas-functions.html If you don't need to get the results of the formula at runtime, you may simply set the formula and don't call the Workbook.CalculateFormula() method, when you open the resultant file into MS Excel, the formula would be calculated automatically.

We may consider and support the formula for calculating results soon.

Thank you.

3

Thanks Amjad,



That’s fine. In that case maybe our only alternative is to implement a ICustomFunction class to handle the SUBTOTAL function.



However, when we tried that out, the calculation engine errors out before it gives it a chance to execute the CalculateCustomFunction method.



I will create a new thread with regards to this new problem. Thanks.



Stephen Tung

Software Developer

Clarity Systems

4

Here’s a link to the new thread I created with regards to ICustomFunction:



ICustomFunction doesn't Override existing Excel Functions - Free Support Forum - aspose.com

5

Amjad,



Can Aspose provide support for the SUBTOTAL functions? One of our features require support from this function.



-Steve

6

Hi,

Ok, we will look into the function and try to support it soon.

Thank you.

7

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have supported to calculate the function SUBTOTAL.

Thank You & Best Regards,