How do I ensure excel file with wide columns does not get truncated in Confluence File Previews
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article contain instructions on how to change the display of excel files in Confluence File Preview / light box, mainly because by default, Confluence file preview will truncate excel files with wide columns/ excel files with huge number of columns.
For example, below is a sample Excel file with a huge number of columns:
Upon uploading to confluence, the columns will be truncated and will be displayed as below:
Solution
The preview in the "file-preview" macro depends on the width of the document itself. The Confluence File Preview macro will display the Excel document as it is suppose to look like, if we were to print the file.
In order to fit the width of the document, we can modify the layout of the Excel page by:
Go to Page Tools > Attachments > "Edit in Office" for the excel file that we'd like to fix ( NOTE: We need to go to
... > Attachments , In case Page Tools option is not visible in the excel version)
Go to Page Layout > Width > 1 Page :
Save
Reload the confluence page
Confluence File Preview is displaying excel file as per desired:
Other Notes
The other layout setting seem to respond well to Confluence file preview, such as:
Orientation" setting to "Landscape" changes the orientation of the file preview in Confluence respectively
Setting the "Page Margins" will also change the previews in respectively
Please note that the "Page Layout" settings location varies in different version of Ms Excel.
Was this helpful?