search

aVadim483 / fast-excel-templator

Lightweight and very fast Excel Spreadsheet generator from XLSX-templates in PHP
MIT License
4 stars 1 forks source link

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

Open atmanegara opened 4 months ago

atmanegara commented 4 months ago

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

image

image

and how to sum formula with dynamic cells?

template

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

Raman117 commented 3 months ago

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 commented 3 months ago

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