Issues with Registrant Export Excel File

The excel file that gets exported for the registrants, has the columns for numbers, like amount, etc. These numbers are stored as text and hence excel formula like sum, etc doesn't work on them. Can we store those numbers in the number format instead?

Hi

This is not possible at the moment. I will see if it is possible to change it in the future

Regards,

Tuan

Hi Tuan,
I need this so badly. Upon so much googling and chatGPT, I found this. At least, could you please let me know the path of the file where I can find the code to modify. Attached is some idea from chatGPT.
 

I further found this, from chatGPT:

"Unfortunately, as of my last knowledge update in January 2022, Box/Spout does not directly support setting cell formats or data types such as numeric. This limitation may make it challenging to enforce a numeric data type during the export."

So, if its not possible, so be it.

For the time being, please accept this limitation. In the future, we would developing a new plugin for import/export using a better library github.com/PHPOffice/PhpSpreadsheet and we should be able to handle that. It will take sometime for the plugin to be available, though

Tuan