Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Thank you.

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

- Ludek

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question