How to hide Grand Total?

Aspose.Cells Product Family
1

Dear All


I am evaluating Aspose Cells 8.0.2.0, how to hide Grand Total?

please help

Thanks & Regards
2

Hi Winanjaya,


Thank you for contacting Aspose support, and sorry for our delayed response.

In case you wish to to hide the row containing the Subtotal/Grad Total, you may try the approach provided here to search for a particular value in the cells, and hide the fetched row. Please check the below provided code snippet in reference to the approach discussed on your other thread.

C#

Row row = null;
Cell current = null;
while ((current = sheet.Cells.Find(“grand total”, current, opts))!= null)
{
if (current != null)
{
row = sheet.Cells.Rows[current.Row];
row.IsHidden = true;
}
}


If we have misunderstood your requirement then please provide us the sample spreadsheet and your desired results, so we could have a better understanding of what you really wish to accomplish.