How to calculate the grandtotal for every row with expanded column?

Aspose.Cells Product Family
21

No setRepreatFormulasWithSubtotal function was found in the WorkbookDesigner class with 20.5.3 jar.

22

@xuanniao,

I can see the method in the newer fix, see the screenshot for your reference:

Please make sure that you are using the latest fix.

23

Sorry, I checked my mvn install command and found that I had used the wrong jar file. I tried with subtotal formula, and found that it only worked for the &=subtotal9 formula but not worked for =SUBTOTAL(9,C3:C4) formula(namely grandTotal).
It already helps a lot, thank you very much!
grandTotalMissing.jpg (270.8 KB)

24

@xuanniao,

Thanks for your feedback with screenshot.

We will evaluate and get back to you soon.

25

@xuanniao,

Please check the formula of E5 in the template0508.xlsx file and confirm there are such formulas in your middle file.

Also, please notice, there is a typo in the name of the newer API “setRepreatFormulasWithSubtotal”, it should be: “setRepeatFormulasWithSubtotal”, we will fix it in the next fix.

26

The issues you have found earlier (filed as CELLSJAVA-43186) have been fixed in Aspose.Cells for Java v20.6. This message was posted using Bugs notification tool by ahsaniqbalsidiqui