[ask] Set area print and worng cell and how sum format in cell

[atmanegara]

In my Excel template I use the print area set, and it doesn't work when outputting a new file and there are also several records that have the wrong cell format as in the example in the following image

and how to sum formula with dynamic cells?

template

source code
https://pastecode.io/s/zv4r09be

[Raman117]

how are you rendering the formulas?
i tried to add data in the template but the formulas aren't running before the file is downloaded.

[aVadim483]

Yes, the library writes the output file row by row and does not store the values of the written cells in memory, so it cannot calculate the values of formulas. Excel recalculates the values when open the file