BUI extra spaces in fields when report gets exported to Excel
I have a report and when I export it to Excel from the admin tool, it looks fine. But when a user exports the same report to Excel using the BUI, it adds spaces before and after every piece of data in every column in the report. I do have a custom margin on the columns to make it appear nicer on the page. But when I changed that to 0 it still adds the spaces before after the text.
The problem is it needs to be imported into another system once the report has been run and that system is having issues with the extra spaces. I don't want the user to have to do find and replace to remove all the spaces. Has anyone run into this issue and is there a workaround that anyone has found?