Excel 2010 Row Height rounding up to one decimal place on some PCs

This is a weird issue nobody on our department has been able to figure out, and I haven't found any conclusive answers from a google search.

All of the users within our company use Excel 2010 on Windows 7. One user has made spreadsheet that has rows that need to be a specific size, however on some users' PCs, it changes. We can always fit it to one page, but that's still not good enough as even though it fits on the page, things get squished and put out of alignment.

I finally managed to figure out what was causing it - On my PC and the user in question, row heights will have more than one number after a decimal point, whereas on the problem PCs, it rounds up. I.E. if a row is 11.25 on mine, it will round up to 11.3 on a problem PC. I cannot go in and change it to 11.25 manually on a problem computer, it just rounds up on its own.

I don't know why it's doing this on some PCs and not others. They should be identical, Excel 2010, Windows 7. Anyone ever run into this before?

Thanks!

November 20th, 2013 6:17pm

Please check the different settings between these computers. Like resolution, DPI, Printer DPI, Regional and language options
Also there seems to be a similar issue you can refer to: http://www.excelforum.com/excel-general/779106-same-excel-file-different-display-between-computers.html
The poster suggest to tick  the option "Install files for complex script and right-to-left languages (including Thai)", since his program is originally written in Thai languages.
In windows 7, you can try to set up MS Office for a Keyman Keyboard.
http://help.keymandesktop.com/docs/start_configure_office.php
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2013 10:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics