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.

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us

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