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 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.
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.
Here’s a link to the new thread I created with regards to ICustomFunction:
Can Aspose provide support for the SUBTOTAL functions? One of our features require support from this function.
Ok, we will look into the function and try to support it soon.
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,