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.
I am also attaching the Excel file so you can check how it is getting generated.
When saving standard report to Excel the columns are not expanding to the full lengths
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: When saving standard report to Excel the columns are not expanding to the full lengths
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: When saving standard report to Excel the columns are not expanding to the full lengths
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.
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.
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: When saving standard report to Excel the columns are not expanding to the full lengths
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.
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.