How to copy cells in PHPExcel?

Question

PHP

Good day! Help Wanted. There is a board with a similar structure .
(in pink indicated the lines in this plate).
I need to sum up the whole output. Cell B45 is calculated according to the formula SUM (B35; B25; B15; B5), C45 according to the formula SUM (C35; C25; C15; B5), B46 - SUM (B36; B26; B16; B6).
When in Excel we entered a formula into a cell, we can stretch it to the entire line - in this case, the value of the column will be substituted automatically; the resulting line was stretched into several others - everything also works without errors and the Row / Column substitutions work out with a bang.
I don’t want to loop through the formula for calculating the value of the final cells. I don’t understand how to drive a formula into cell B45, then copy its value to the range of cells B45:I45.
How to copy a cell (range of cells) so that when pasted, formulas work on new coordinates?

Answer 1

If you have a value calculated at the stage of building a document. then I suppose that after the calculation, you just need to add the "calculated" value to the desired cells.
You can get it, as far as I remember, like this: ->getCalculatedValue();
Or, after building the file, reopen it -> edit -> profit