Parsing formula is not working

DisWEBru / phpexcel

PHP library for writing and reading files in EXCEL format. Modified to work on PHP 8.

MIT License

3 stars 4 forks source link

Parsing formula is not working #8

Open core2drew opened 6 months ago

core2drew commented 6 months ago

Environment Setup: PHP 8 CodeIgniter 3 Apache

I installed the library using composer to replace the PHPExcel that is already deprecated, but when I tried to generate an Excel I notice that it doesn't compute the formula.

But when I try to a focus cell then focus out, then the auto-compute works.

Maybe you have an idea on how to solve this.

Thanks!

danhutch88 commented 3 months ago

I'm also having this issue. Lots of threads elsewhere suggest

$objWriter->setPreCalculateFormulas(true);

Before the save function, but it makes no difference for me.