Excel printing and display scaling bug

FYI .. I got a new work laptop with windows 10.  Still has the same problem. 

Hi Matthew,

I just wanted to comment and share that I am experiencing the same issue. This affects every computer in my office. It's rather frustrating because I create many templates in Excel for our staff to use. I usually have my display settings in windows at 125% to help with things being small due to my high resolution display. I cannot create templates while using the 125% setting, because the excel templates will end up printing differently for the users in the office who leave their display setting at 100%.

Microsoft, please address this issue.

Windows 7 Pro

Microsoft Office Version 1803 (Build 9126.2259 Click-to-Run)

Thanks,

Taylor

I also am experiencing the same issue. I have used various Excel and Windows versions on different PC's for years. This problem has always existed and causes grief to me and others. I am now using Office 2016 with Windows 10 Pro with a Dell E5470 laptop with an i7 processor, and an Intel HD graphics 530 display adapter.

This is what causes the problem.

I am getting along in years and prefer to have a bigger view of desktop items and files I open when using my desktop, so I go into display settings (Scaling) and increase the size of apps, and text etc to 125% or 150% of normal. (150% is recommended by Windows, however same symptoms on both instances.)

Then when working with an excel file, I format column width to optimum by selecting the column and then tapping beside the vertical bar and the column auto-sizes the width.

After saving the file(s), I then email to various other users in our company who have their display resolution set to 100% instead of my 150%.

When they open the excel file, the columns are too narrow and certain numbers may show as #######, or alternatively the column titles extend beyond the width of the column.

This has been the case for years and years.

In addition, here is another test for you.

Create an excel file with column titles and large numbers in the columns so that when you auto size the width, the columns are pretty much full.

Now still within excel, reduce your screen size to 70%, using the zoom field within excel.

You will notice that the numbers in the columns will become ######## plus the column titles will exceed the width of the field, and need to be auto sized once more.

This is annoying and unproductive.

Thanks.  I have some insight for you. 

I cropped down an image of the "print" screen that I posted above.  I then zoomed in as far as I could in mspaint, and counted the pixels.  The 9 in the default 100% scalling has the same height as in the 125% scaling, but the width is different.  In the 100% case it is 5 pixels wide, while in the 125% case it is 4 pixels wide. 

So it seems to be the aspect ratio of the font that is causing the trouble.

Yes.  It's obviously somehow related to video settings.  This problem is also related to excel.  Excel shouldn't print different to a printer or PDF because I change display settings.

My complaint is about printing and printing only.  Everything else is incidental.

**Excel does NOT look fuzzy after you log out and log back in.  It looks normal.**The reason excel looks fuzzy after you enable DPI scaling in windows is because it doesn't fully enable until you log out.  This is not my problem.  It's just an FYI .

Everything in windows looks fine after you log out and then back in.  All the links you provide are about blurry text.  The problem is that what will fit on a page in excel is slightly changing. This is causing it to print different.

All I really want at this point is the problem to be reported to someone who can actually fix it.  Like the developers.  The links indicate  they have been doing a lot of work on DPI settings and they are VERY complicated.  (This one https://support.microsoft.com/en-us/help/3025083/windows-scaling-issues-for-high-dpi-devices)  My build of office is the 365 with all the continuous updates.  So this may be a new issue?

Even in windows 10, the DPI settings do not fully take effect until you sign out of your profile and sign back in.

I tested without signing out, and the problem does not occur.  Excel also does not look very sharp until you sign out and sign back in.  I retested after signing out and the problem still happens.

You need to sign out in order to reproduce the trouble. please try this.

It might also be worth it for you to try it out on a machine with an nvidia video card.  Both machines I have are using them... and the problem is obviously somehow related to video settings.

1.  Please set the print scaling to No scaling, does it exhibit same behavior?

Yes

2.  Does it exhibits same behavior if you print to PDF document?

Yes.  I will PM you 4 files to cover all combinations of display scaling on and off, and fit to columns on and off.

Apparently you need to PM me first for me to send you the PDF's?  I  don't want to post them publicly.

3.  Just to confirm, Do you mean the following setting as the following picture shows when you mentioned "display scaling"?

You failed to attach a screenshot as noted, so I attached a couple myself.

I set display scaling here:

To work around my problem with printing, I attempted to disable display scaling for excel only here (but it did nothing):

4.  Please help capture a screenshot of your Excel File tab>Account page.