Dealing with formulas in pdf exports in Laravel Excel

I am using Laravel Excel to export data from my laravel app to an excel spreadsheet or pdf file. Once small issue I have is when exporting to pdf it is not calculating the values for my formulas prior to exporting so I just see the formulas in the pdf.

If there a way to tell it to calculate the formulas first?

If not, can I see the export format (xlsx or pdf) from within my export class? Because if so I could add logic to set the cell to the correct value manually when exporting to pdf.

https://stackoverflow.com/questions/66937920/dealing-with-formulas-in-pdf-exports-in-laravel-excel April 04, 2021 at 12:04PM