Dont display full data when export to Excel

Stimulsoft Reports.NET discussion
Post Reply
AAA
Posts: 8
Joined: Tue Jul 07, 2009 11:40 pm
Location: dsda

Dont display full data when export to Excel

Post by AAA »

Export to PDF is ok
But when export Excel the data do not show full
This image dont full data
Image

This image full data (I pull down the line 11)
Image

Attach report
Thanks
Attachments
222.ListProjectHistory.mrt
(27.14 KiB) Downloaded 271 times
Ivan
Posts: 960
Joined: Thu Aug 10, 2006 1:37 am

Dont display full data when export to Excel

Post by Ivan »

Hello,
Export to PDF is ok
But when export Excel the data do not show full
MS-Word/Excel allows you to set precisely the sizes of objects, but does not allow you to set the sizes of the text precisely.
In MS-Office applications the WYSIWYG function most frequently work incorrectly.
For example, your report (in EXCEL) looks different in edit mode and in print preview.
More differences can be found if you change the zoom of a page from 50% to 200% in the edit mode. The longest text lines on the page can be cut depending on zoom.
Also text drawing in Excel is processed using their own methods and does not concur neither with GDI+ (Standard, Typographic) nor with GDI (WYSIWYG).

So, this is not a report generator bug but Word's/Excel's bug.

Solution:
For each font try to select appropriate TextQuality;
Here some examples: For Arial font the best choice is 'Standard' mode. For Courier font is 'WYSIWYG'.

Thank you.
Post Reply