Formulae calculation

Aspose.Cells Product Family
1

Hi,

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?

Thanks

2

Hi,

Well, I think for your scenario, you may try to create pivot table reports in GridWeb control using its API. See the demos in the section:




Thank you.

3

Hi,

But I found that I can't edit the Pivot table data right?

In my scenario I should be able to edit the data and save it to DB as well

4

Hi,

Well, I am afraid, currently Aspose.Cells.GridWeb only supports to provide static picture of the pivot table report and you cannot edit. We will look into it and get back to you.

Thanks for being patient!