Grand Total Forumla is not evaluating itself

Aspose.Cells Product Family
1

Hello. Grouping and summarising data using smart markers have been achieved after i read the article

https://forum.aspose.com/t/132315
in which i had to download “Aspose.Cell 5.2.0.5”
but in there i have a slight problem It doesn’t calculate the grand total
when i manually execute (double click in the cell) the formula then it performs the forumla and give me desirable result.
e.g.
CustomerID SaleID
1 Sale-1
1 Sale-2
1 Sale-3
2 Sale-4
2 Sale-5
Now after using smart markers i would like to count total number of invoices against each customer. it should give me
CustomerID SaleID
1 Sale-1
1 Sale-2
1 Sale-3
3
2 Sale-4
2 Sale-5
2
-----------------------------------
Total Invoices 5
My Problem is that i am not getting 5 untill and unless i manually go in the cell and double click and click somewhere else to execute the formula.
Please guide me to rectify this.
Thanks.

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please call Workbook.CalculateFormula() before saving your workbook.

Please also download and use the latest version:
Aspose.Cells
for .NET v7.3.0.3

If the problem still occurs, then please provide us your simple console application replicating the problem using the latest version.

We will soon look into it and help you asap.