When saving standard report to Excel the columns are not expanding to the full lengths

[Anas]

Hi All,
When exporting the report as Excel the columns are not expanded to full height and width to cover the whole text.
Instead, the text is cut out and not visible.

image (1).png (78.7 KiB) Viewed 230 times

I am also attaching the Excel file so you can check how it is getting generated.

Report.xlsx

(43.24 KiB) Downloaded 36 times

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[Anas]

Hi Lech,
Thanks for your reply.
Please find the required JSON you can check this at your end and you will figure out the issue at your end.

Line Item Summary – By Status and Priority – Generate report and Save as Microsoft Excel.json

(6.5 MiB) Downloaded 6 times

[Lech Kulikowski]

Hello,

When exporting reports to Excel in Stimulsoft Reports, you may encounter issue: the line spacing for multi-line text might be larger than the spacing shown in the preview, which can cause the last line of text to be truncated.

The rendering of the text in Excel is done there with its methods.
Usually, the line spacing in Excel is about 5-15% more than in the preview, especially for the small fonts.
Unfortunately, Excel does not support any means of controlling the line spacing.

The best solution at this moment is to change the Line Spacing property of textbox (by default it's 1). In the preview, the line height will be larger which will make the cell in Excel larger. The line space in Excel will be the same as before.
The Line Spacing should be different for different fonts. It could be from 1.1 to 1.25 for different fonts.

Thank you.