You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BUI extra spaces in fields when report gets exported to Excel

edited Aug 10, 2018 9:56PM in Reporting & Analytics for B2C Service 1 comment

Content

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!