Width of these spreadsheet documents is 104. But the second document doesn't fit in the printing page if we print it / export it to PDF / export it to Excel.
I'm trying to understand why. The only difference between these documents is that the second of them has several row formats as far as I see.
The difference is in page setup Scale option. For one document you have Scale 100% and for another one (I guess the one that fits the page), you have Fit page width.
Its clear what is the difference between this 2 mxl files.
But could you clarify 1 more thing: why both of this mxl comes on 1 page in print preview and also its printing on 1 page. But if we make an export - it comes on 2 pages.
I understand this, but i just want to clarify why printing and exporting operations give me different results without changing of page scale properties?
When I tried to reproduce it, I got the same result: printing and saving as PDF produce 2 pages is you do not set scale to fit the page size and 1 page otherwise.
If possible, please add screenshots to demonstrate what is incorrect.
Please find attached 3 files, this is second mxl which don't have "fit to page" property on.
I dont change any settings (you can see it on Print Preview). When i m going to print preview it comes to 1 page as well as when i m printing (see attached photo).
But when i saving that mxl to PDF - its comes on 2 pages (see attached PDF.zip: i compress it because i cannot attach PDF file).
Maybe you have some specific settings in your printer that allow you to print on a single page. While when I tried on my printer, I see that the document does not fit it on the print preview:
I'm not sure how can we reproduce this issue. Do you have some configuration script for your printers?
Think, that setting Fit page width option will be fine for your users... You can set the FitToPage property value to True when create the printed form as a spreadsheet document and all of them will have the same result then.
No, as i told not our office have that issue. But anyway i just have a default printer without any additional settings.
Unfortunately "Fit to page" is not applicable for this case. Because that template is a report. For reports we are using common report form. And reports could have a landscape orientation. That's why we don't wanna use "Fit to page" by default.
You can set it for reports that should be sent by email automatically. For reports that are generated and checked by users, you can inform them that they should adjust a correct scale or select the fit to page option.
Because PDF is like another printer with settings that do not match your hardware printer.
Desktop version
