When we do a copy to Excel from a dashboard, the Part Description field is getting cut off and added to the next Excel row. It looks correct in the dashboard but when doing a copy to excel, it is cutting it off in to a new row. I checked and the characters (with spaces) for this part description is 53. Is this a limitation with copying to excel with how many characters it can copy over within one cell or what else could be causing this issue.
Are you sure you don’t have a new line in your part description?
Not that I am aware of in the part description. When I reviewed the BAQ, I am able to export the ShipDtl_LineDesc that is being used as the part description and copy to Excel works from within the BAQ but not the dashboard.
This is almost certainly it. If you are getting your data from a BAQ, use a calculated field to replace char(10) and char(13) with a space or something. Those are the hidden new-line characters that can be present in your text fields.
Odd that when I copy to Excel from the BAQ, it works fine but when I copy to Excel in the dashboard, it creates the new row.
You can always use a tool like notepad++, or free clipboard viewer to view the underlying data. For example, if you have a text field that contains line breaks, they will show up in the hex code as “0D 0A”. This way you can know for sure what hidden characters you are dealing with.
I copied the description field into Notepad++ and it also creates a second row line and I don’t see any special characters.
In Notepad++ go to View > Show Symbol > Show End of Line. You should see two black boxes with CR and LF inside. Those are your hidden line breaks.
You can also use the replace tool to find and replace those chars. Confusingly, you have to search for \n and \r (make sure to turn on that option in Replace tool under Search Mode).
1 Like