QualityLogic forum for discussions regarding Fax and Telecom Testing, Printer and MFP Testing, and Web Site Testing.
Microsoft Excel 2010 (RC1): Column Size Distortion

Excel in the Beta and RC1 releases has been stable and very functional. One major issue that we have encountered is the distortion in the column size between Normal and Page Layout views. The Excel 2010 ATS IF file EX4TH1C3.xlsx uses absolute measurements to help printer manufacturers discern distortion in their printer drivers, but in this case the file illustrates the problems associated with switching between Normal and Page Layout. Below are two screen captures showing the column size in Page Layout (left) and Normal (right). The worksheet was created with one-inch columns and rows, but when you switch to Normal view the column shrinks to 89 rather than 96 pixels. If you define the column as 96 pixels in Normal view the column width adjusts to 103 pixels in Page Layout. This adjustment also affects images imbedded in the worksheet. Placing a two-inch square image or shape in Normal view will measure 2.0” x 2.18” in Page Layout. The reverse occurs with a two-inch square in Layout becoming 2.0” x 1.82” in Normal. Page Layout displays the view that the printer will render.

Page Layout View (96 pixels)       Normal View (86 pixels)


Posted 5 Feb 2010 12:24 PM by Steve Kang

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
© 2009 QualityLogic Inc. All rights reserved.