Excel Value Sum of Column

[ginnifer.johnson]

Is there a way to sum the value of a column so that the exported Excel file shows the formula (Excel Value) of a column that is not static? (I want the part in yellow to calculate using Excel formulas, but the part in blue may increase or decrease in rows.)

[Lech Kulikowski]

Hello,

Please check the following article:
https://www.stimulsoft.com/en/documenta ... _value.htm

Thank you.

[ginnifer.johnson]

Right, that works for the rows, but I'm looking to do the column. When I put in Sum(C{Line}) I get the value of a random cell (granted, it's in the same column, but I need the sum of the range).

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[ginnifer.johnson]

In these files, the totals are already there, as calculated in Stimulsoft. We would want to replace these with formulas in Excel.

[Lech Kulikowski]

Hello,

Please explain, where you use excel formula in your report?

Thank you.

[ginnifer.johnson]

I would want to use it for the Total Revenues, Total Expenses, etc. See the example above: It would be the yellow highlighted cells.

[ginnifer.johnson]

We found a solution: We added in an index column (=0) and section counts. From there we are able to calculate the row numbers of the different sections since the report starts on the same row every time. This works when we only have one project. We are still thinking through how to do this for a multi-project report.

[Lech Kulikowski]

Hello,

You sent data in json, and business objects are used in the report. We couldn't run your report.

First, read the article that was sent to you right away to the end. It is well-written about cell offsets. The formula for the sum of a column looks like this: SUM(C2:C8).
In your case, you should substitute for example like this:
=SUM(B{14}:B{14+dataSource.Count})
14 is a random number, your report does not run to find out the real offset.

Thank you.