[Feature Request]: Adjusting formulas for repeated lines

[LoreScianatico]

Problem to solve
Adjusting formulas on rows/columns when multiple lines are printed

Proposed solution
Suppose I'm printing a template with some kind of iterations, and I have sums across rows and columns. At the moment the formula gets repeated as it is, without being adjusted according to the new inserted lines. I guess this happens because it is considered to be a constant. It would be nice if the formulas would be adjusted, even if I totally understand that it's not easy to detect if the cell content is a formula or not.

Describe alternatives you've considered
At the moment I'm simply doing some post-processing of the file after carbone gives me the filled report.

Additional context
I'm attaching an example of printed report:
simple.xlsx

[steevepay]

Hello Lorenzo, thank you for reaching us!
I totally acknowledge the issue and you have two solutions:

• Before the rendering, define your formulas to a longer range.
• After the rendering, a VBA Macro would adjust formulas based on the data range.
  For 2021, we plan to improve the XLSX support and I keep the idea of adjusting formulas.

[loneil]

I'm wondering if the comment from @steevepay about "Before the rendering, define your formulas to a longer range" will work for Excel spreadsheets?

I'm trying to just sum up a column of data and can't seem to get it to render the formula after the replacements no matter what I try in the SUM...

If I set the endpoint of the sum

With this data

{"people":[{"name":"Mike","age":22},{"name":"Vanessa","age":33},{"name":"Michelle","age":44},{"name":"Patrick","age":55}]}

I'm still getting 0 as the result out of Carbone.

Has anyone figured out how to get a simple column sum in Excel to work in Carbone?

[lucasoboli]

Maybe if you start from B2 instead of B1, so you don't take into account the first row which contains text instead of an integer.

[loneil]

@lucasoboli sorry my screenshot had a mistake there, yes I've been trying from B2 with the same results (had pasted B1 to take the screenshot by accident)

So using =SUM(B2:B99999) for example, has the same result where the resultant cell after Carbone is still 0.

[erennyuksell]

any solution?