When setRepeatFormulasWithSubtotal(true) the subtotal9 function gets a wrong result, however when I don’t use this api (setsetRepeatFormulasWithSubtotal), subtotal result is correct, but the subtotal rows haven’t been calculated by “setRepeatFormulasWithSubtotal” int the “row total” column.
This is what I expect:
image.jpg (90.0 KB)
besides the subtotal for “2017,2018,2019” needed to be calculated the red box content is what I also want to calculate.
AsposeTest.zip (90.4 KB)
Above AsposeTest is a simple sample code, the ExpectedResult file is what I want to implement
the OutPut file is result when I setRepeatFormulasWithSubtotal(true)
the WithoutsetRepeatFormulasWithSubtotal file is result when I don’t use this api setRepeatFormulasWithSubtotal
the TestSmartMarkers file is template file.
At last, Again emphasizing : I want to get correct “Level1” subtotal result and also the subtotal rows, grandtotal rows can be calculated correctly by the “setRepeatFormulasWithSubtotal”. Hope your reply, thank you!