I have an Excel problem with viewing and printing documents from Excel.
The exact same document will view and print differently on two separate PC's. At the bottom of one document (see screenshots) there is a large white space at the bottom while on another PC there is no space and the document fits the page perfectly. We don't want the large space to appear.
Please, note that I have compared every page setup and print setting such as margins, page percentage, DPI setting and they are the exact same.
WHAT I'VE FOUND
This issue occurs on multiple machines and setups randomly in my company. What I have noticed is is the following. The PC's seem to render/present row height in excel differently. I noticed the main difference between the PC's is the default row height in excel.
The PC's that render the document with the large white space have a default row height of 14.4 when a blank workbook is created in excel.
The PC's that render the document correctly, filling the page completely, have a default row height of 15 when a blank workbook is created in excel.
WHY ARE THE DEFAULT ROW HEIGHTS DIFFERENT?
It seems like 15 is the true default row hight within Excel. Although, it can depend on the font type and size used within the cell. I am using the same font/size on both PC's.
I have no idea why some machines show 14.4 but feel that this is directly related to my original problem of displaying the excel document correctly.
I have tried changing many settings, uninstalling and reinstalling MS Office 2007. Trying different Office service packs but the problem continues to happen on the PC's. Even after completely re imaging the laptops they still show the problem, while others of the same make/model do not. This issue also spans across different models of our Lenovo laptops.
Lenovo T500 or T510 - both have 15" displays
Office 2007 SP2 (SP1 shows the same issue on the problematic, 14.4, PC's)
Same additional third party software installed both (comes from an image we deploy)
Sorry this is such a long question. It is a complex and weird one that is driving me crazy. Any suggestions or help would be appreciated.