So for a bit of context. We are using the "Jira Cloud for Excel (official)" plugin for reporting, meaning that we export all the issues via this plugin. We don't use the Jira native export option as it cannot get all the tickets (we have thousands).
We report only the custom fields we need.

The problem when using this plugin is that these 2 custom fields appear blank or "no field found" in Excel. This is not good for us. This is when exporting as XLSX.

When exporting as CSV the fields are not blank anymore nor with "no field found", but they are now with the object(asset) ID key. This is a bit better as we have a value, but we have a rule in place to copy the info as plain text in the field.
This is what we see in Jira when searching for the 2 custom fields.

This is what we get when exporting now.
I am wondering if anyone encountered this issue. If there is a workaround. If there is some way better for us to export these values. Any help is much appreciated.
Thank you for your time.