I am new to this tool and evaluating the fesibility of using Aspose.Cells.Grid for our requirement.
I am looking to implement some thing similar to the screen shot attached using GridWeb in ASP.NET
My Requirement is as follows
1)For each section like Marcellus,Other NE there should be totals at the bottom for all the rows
also there will be computed columns like (MATB -->Summation of first 4 quarters,MATF-->sum of last four quarters)
2)There will be a summary section like Total East NE which is the summation of Marcellus and Other NE section.
Could you please guide us the best approachs to achieve the below points?
1)Getting the computed columns
2)Getting the totals for each section at the bottom of the rows
3)Getting the summations of all the sections
4)Setting the style for a cell region like from C4 to C10?
5)Setting the style or readyonly for a row region like C2 to F2?