Dear Aspose Team,
I've some problem with cell.
I put some code to create a summary in a cell with some formula, like this :
Dim cellSumJan As Cell = cells(0, 0)
cellSumJan = cells("I397")
cellSumJan.Formula = "=SUM(I7:I396)"
And it works, there is some value in cell "I397". But if i filter the data with an autofilter ( for example, i choose "BMW" in Brand category ), the summary in that cell was disappear.
How to fix this problem?? I beg you please...