We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Support for SUBTOTAL Function

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

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.

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

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



http://www.aspose.com/community/forums/134228/icustomfunction-doesn-t-override-existing-excel-functions/showthread.aspx#134228

Amjad,



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



-Steve

Hi,

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

Thank you.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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,