How to reserve the page size when exporting to MS Excel 2010
Hello. I have a report which exports to MS Excel 2010. I applied the page size as legal in Crystal Report and would like to use the same page size in Excel
However, MS Excel print preview says the page size is letter.
How could I keep the same page size in Excel as I applied in Crystal Report. We have a lot of business reports and would like to avoid applying page setting manually in Excel when users print them out each time.
Ludek Uher replied
Well, I eat crow. Thanks Abhilash LOL
Abhilash is correct and I need to read the threads a bit more carefully. The option is "No Printer (optimize for screen display). As the printer driver dependency is removed, the paper size information is not propagated on export and thus paper size defaults to 8 1/2 X 11 inches (as it has to default to something). This is true for all paper sizes and export formats. I tested the above with Legal paper size and 4'' X 6'' paper size. Export to XLS, DOC and PDF.
E.g.; once again, note to self; trust Abhilash