Author: Jonathan Rivera
Date: February 14, 2024
Audience: Everyone
Environmental details: Self-hosted or Cloud
Summary:
After exporting a report from Trace View, opening the CSV in Excel has broken formatting. This will likely show up as large gaps between rows with seemingly random words being cut off.
Solution:
- Check how many characters are in the cell that precedes the broken formatting.
- If it is at (or close to) 32,767 characters, that cell is too large for Excel to handle.
- Exclude columns from Trace View that are too large. (This will typically be large text fields, such as the Description field.)
Cause:
Excel's character limit for a single cell is 32,767 characters. The formatting in Excel will break right around where a large cell hits that limit.
Prevention:
Do not include large fields in the Trace View columns when exporting.
Related Articles, Work orders, Zendesk tickets, Defects, etc.
Additional Information/Metadata:
- Report
- Trace View
Feedback: Please leave feedback in the comments below.
Related to
Comments
0 comments
Please sign in to leave a comment.