Issues with Registrant Export Excel File

Arbind Bhagat
Topic Author
Offline
Elite Member

More

1 year 3 months ago #163575 by Arbind Bhagat

Issues with Registrant Export Excel File was created by Arbind Bhagat

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?

Please Log in or Create an account to join the conversation.

Tuan Pham Ngoc
Offline
Administrator

More

1 year 3 months ago #163594 by Tuan Pham Ngoc

Replied by Tuan Pham Ngoc on topic Issues with Registrant Export Excel File

Hi

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

Regards,

Tuan

Please Log in or Create an account to join the conversation.

Arbind Bhagat
Topic Author
Offline
Elite Member

More

1 year 2 months ago #164120 by Arbind Bhagat

Replied by Arbind Bhagat on topic Issues with Registrant Export Excel File

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.

Please Log in or Create an account to join the conversation.

Arbind Bhagat
Topic Author
Offline
Elite Member

More

1 year 2 months ago #164121 by Arbind Bhagat

Replied by Arbind Bhagat on topic Issues with Registrant Export Excel File

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.

Please Log in or Create an account to join the conversation.

Tuan Pham Ngoc
Offline
Administrator

More

1 year 2 months ago #164132 by Tuan Pham Ngoc

Replied by Tuan Pham Ngoc on topic Issues with Registrant Export Excel File

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

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc

Powered by Kunena Forum

Issues with Registrant Export Excel File

Support

Documentation

Information

Connect Us