Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: DPI or other setting problem ?

04 May 2014   #1

windows 7 PRO 32bit
DPI or other setting problem ?

I was unsure which category to place my question so hope I am in the right place.
I recently changed monitors and am now using a Benq FP731. The resolution is set to default but I needed to increase the DPI to 120%. While using my previous monitor I had created (over the past year) a great number of worksheets on a related subject and had meticulously entered information so that it fitted precisely onto each page of each worksheet (page breaks etc). Since the change of monitors and the DPI setting when I check the worksheets they don't appear how I had set them up (using my old monitor). The page breaks are now overlapping into next pages and outside the width of the page.
I have tried every setting I can think of but the only DPI setting that does show the worksheets correctly is 125% but this makes everything else on my PC too big. I also want to be able to put the files on disc for my family but want them to be able to view it as I had set it up.
I would have expected that changing the DPI would only change the size of viewing, not the actual setup of previously saved work.
Is there a setting I have missed - I have tried everything I can think of and I'm desperate for some help.

My System SpecsSystem Spec

05 May 2014   #2

Windows 7 Ultimate 64bit

It's your new monitor the same size as your previous one?, and these worksheets, what software are you using?. You could try to create a more suitable display file like a PDF, but I'm not 100% sure in what are you working.

Oh, and I'm not a mod but maybe this would go in Hardware & Devices.
My System SpecsSystem Spec
06 May 2014   #3

windows 7 PRO 32bit

Yes the monitor is the same size as the old one but I have tried different sizes even a widescreen all giving me the same result. The worksheets are done in Excel (Microsoft Office).
It doesn't make sense that changing the DPI could cause this problem. I'm thinking it must be software, maybe another setting that would counteract this ? That's why I thought hardware & devices wouldn't be right to post my questions, but am open to any suggestions anyone has so might be worth a try, thanks.
My System SpecsSystem Spec

14 May 2014   #4

Windows 7 Ultimate 64bit

Hey julia, I'm sorry I wasn't able to reply sooner again.
Quote   Quote: Originally Posted by julia99r View Post
Yes the monitor is the same size as the old one but I have tried different sizes even a widescreen all giving me the same result. The worksheets are done in Excel (Microsoft Office). It doesn't make sense that changing the DPI could cause this problem.
You are somewhat wrong, because DPI scaling changes not just text, but the user interface also, here is a little explanation:
Optimize Display Scaling and Fix Scaling Issues on Windows 7

So, if you say you are trying to watch some sheets, with a different scaling than the one you originally used, it will change your entire work on the display. Could I suggest you try your old monitor and see how it looks?, and if it does looks the way you need it, try to save it in a different format like .pdf and then connect your new monitor, with the same DPI scaling, and open that .pdf file, see how it looks. I could also suggest you try perhaps another procedure, one that doesn't require a specific screen size for the desired result, in other words, don't rely on the size of your monitor hardware, instead, if what you want is to let others watch the information you have worked on a sheet previously, use a different set of document sizes in resolution (for example, the most common would be 800x600, 1024x768, 1366x768, 1920x1080 pixels, and so on, you normally see this option under the Design tab) in order to fit different monitors as you need. If you have any questions, just ask.
My System SpecsSystem Spec
14 May 2014   #5

windows 7 PRO 32bit

Thanks for getting back to me..
By your opening statement it would mean:- unless another person has exactly the same DPI and Resolution settings as me, and I emailed or copied to disc a Word, Excel, or PDF document the recipient will not be able to view or print it properly (in the way it had been setup). Nothing would fit to page or within margins ??? Of course that would not just apply to me it would apply to everyone who emails a document or copies it to disc. ...sorry but I just can't believe that to be the case. It would mean that I would need contact a recipient to obtain their computer settings, change my computer to the same settings as their, laboriously change all the files I want to send/copy, just so they can view them properly (the way they were set up). I have posted my problem on a heap of forums and no-one has heard of it before nor know how to fix it, but if this problem is the way the programs/settings work wouldn't it be an extremely common complaint that everyone knows about?
The old monitor does exactly the same thing as the one I am using now when changing DPI & resolution. I have tried other monitors & a widescreen all with the same outcome. Saving as a .pdf has no affect, the page break & margins still appear differently when dpi & res are changed (and different monitors with different settings). I have tried changing to various resolutions keeping my DPI at default (or higher/lower)... nothing has worked. I just cannot figure it out.
Thanks kindly again for your reply and suggestions, but unfortunately the problem still exists.
My System SpecsSystem Spec
15 May 2014   #6

Windows 7 Ultimate 64bit

Hey julia, I can understand a lot of people don't getting exactly what's your issue with the desired display of your info, perhaps one of the documents you are working could make a better graphic example?, that way here we could have a better idea of what's the problem. Although, you also need to have a little understanding of how resolutions and units of measure play a role in the whole process, because you clearly are having trouble with working on different screen sizes (a recurring theme in graphic design). You don't need to know the exact size (in pixels per inch and/or DPI) of every single monitor your colleagues are using, that would be insane, but, you need to understand there are different sizes when in comes not only to screen but to display size (since maybe someone would be using a better graphics card than the rest, and chances are it may have a bigger resolution on his/her PC). Also, what I'm getting is that, your work on these spreadsheets will be eventually printed?, is the printing the final goal?, because if so, then now you would be limited by what printer are you using, and which paper size it handles. Even if you take your time to arrange the sheets in a very specific way, finally the program and the printer driver will decide how the sheets will be printed (unless, of course, you use a .pdf file, which are, by the way, specially designed for printing, this time the format will help you). So you see julia, there are a lot of small but interconnected details, which need to be explained for particular issues like this one, because otherwise, as it happened to you, it will be hard to get people to understand. But post a file, let's have a look how are you working, if it's ok with you.
My System SpecsSystem Spec
16 May 2014   #7

windows 7 PRO 32bit

To give you a “CLEAR” understanding of my issue, this is exactly what it is…

Example:- I set the DPI% to 125% (through “personalisation” & “Display”).. I create a 5 page long Excel Spreadsheet. The information I enter on page 1 fits precisely within the first pagebreak. I manually number the page "1". I continue entering my information on the next 5 pages, ensuring each page is within the page “pagebreak”….preview & save the document…Now if I go back into “personalisation” & “display” and change the DPI to 100% (or another %) and open the same document I had created, the page breaks have lowered, so that page 1 data is overlapping by pagebreak into page 2… page two is overlapping into 3 and so on.NOT only by the actual “preview” view but the actual setup.
Similarly, if I were to copy that document onto disc, or email it to you, AND you have a different DPI setting on your computer other than 125% you also would "see" pages flowing into the next with the page breaks in the wrong places. If you wanted to print the document by “data page” as it was originally created, you would have to adjust the pagebreaks etc manually on the document before you could print.It has nothing at all to do with Printer settings or preferences it is the actual set up of the spreadsheet that would need to be changed.
So if I change monitors and prefer to use a different DPI% setting other than the one I originally used to create the document on, all the “created” pages would appear incorrect with page breaks changed. I would have to physical change ALL my document .
Attached are various images as listed below.

Spreadsheet was created with DPI setting on 125%
Image 1 – Spreadsheet pg 1, 2, 3, image screenshot with DPI setting on 125% DPI (appears correct)
Image 2 – cont'd - pg 4 & 5 image screenshot with DPI setting on 125% (appears correct)

Image 3 – the same spreadsheet view with DPI setting at 100% -Page 1, 2, 3 (pagebreaks have changed)
Image 4 - cont'd - page 4, 5, & overflow of page 5(view with 100% DPI) (pagebreaks have changed)

Attached Thumbnails
DPI or other setting problem ?-image-1-pg-1-2-3-125-dpi.jpg   DPI or other setting problem ?-image-2-pg-4-5-125-dpi.jpg   DPI or other setting problem ?-image-3-pg-1-2-3-100-dpi.jpg   DPI or other setting problem ?-image-4-pg-4-5-6-100-dpi.jpg  
My System SpecsSystem Spec
16 May 2014   #8

windows 7 PRO 32bit

in addition to my previous message, I emailed one of my spreadsheets to a friend, the spreadsheet text fitted perfectly within the margins and the pagebreak. My friend replied saying there was issues with the margins and pagebreaks as they do not appear in the right places. Also a popup message appeared as soon as she viewed it and so she sent me back a snapshot of the image view. I have smudged out personal information to show you this (for obvious reasons) but you will be able to see how margins etc are being changed.
I felt this extra information would be of assistance.

Attached Thumbnails
DPI or other setting problem ?-popup-message.jpg  
My System SpecsSystem Spec
18 May 2014   #9

Windows 7 Ultimate 64bit

It's weird, I just did the same procedure as you, made a document with at least 3 sheets, saved (Fig. 1), changed DPI to 125% but all looks fine. (Fig. 2)
Just by pure curiosity, have you changed any of these settings in any way? (Fig.3), especially the Width and Height settings, are they in Automatic? (not only yours, but your colleagues PC's too?). Have you tried to start Excel in safe mode or re-registering it?:
Startup Errors In Excel

Attached Thumbnails
DPI or other setting problem ?-fig1.png   DPI or other setting problem ?-fig2.png   DPI or other setting problem ?-fig3.jpg  
My System SpecsSystem Spec
18 May 2014   #10

windows 7 PRO 32bit

Yes, I too have done a quick test by creating a worksheet and viewing it at different DPI settings and it looks fine, but I'm going to play around with that test sheet a bit more and one by one change excel settings to see if I can duplicate the problem.
(90% of the time I change margin size to suit the entries I need to enter, and the orientation is changed quite often to suit also. Not just for the spreadsheets in question but every one I ever create.
When doing this group of spreadsheets (which are my "family history") I never use one as a template for another spreadsheet I always create a new one from scratch. Yes I DID adjust the margins, orientation, row height, column width, I DID NOT change: print area, background, print titles, scale. There is a lot of information that I want to appear on each page these sheets so I need to adjust things to fit, but always making sure they are within the margin & pagebreak . Excel supplies the options to adjust these settings, so I wouldn't have thought they would corrupt the sheet if used.
My colleague made no changes at all, she just viewed it, did a screen print and emailed it back to me.
I have not tried to start Excel in safe mode or re-registered it.. I have run "detect and repair".
I will do those things and look through the "startup errors in Excel" link supplied at the bottom of your last message. I'll get back to you with the outcome. Thanks for your extra suggestions
My System SpecsSystem Spec

 DPI or other setting problem ?

Thread Tools

Similar help and support threads for2: DPI or other setting problem ?
Thread Forum
Problem deciding Gbs setting on HDD Hardware & Devices
Solved Problem in setting icon Performance & Maintenance
Setting up remote problem Media Center

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:23 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33