View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
owlnevada owlnevada is offline
external usenet poster
 
Posts: 44
Default Scale and Aspect Ratios diffferent

A colleague of mine has created some macros with your respective helps, and
in their use weve found something odd arise.
And the outcome appears to depend on the version of excel under which the
file was created.
Weve got two workbooks. One came from excel 1997, and the other from excel
2007.
In reviewing all of the row heights, and column widths, both worksheets are
identical.
In reviewing the page set up scaling, alignment, headers/footers, margins,
etc€¦, both sheets are identical.
In every way that we can readily identify, both worksheets are identical.

However€¦..
In selecting a €śview side by side,€ť as well as when we print them out, they
have what appears to be a zoom scale difference€”even though the zoom for both
is set at 70%.
Weve found that with both the screen view, and the print out, when set to
compare their view, the row heights, and column widths do not align, as one
would expect. At the bottom, and at right, by as much as Âľ€ť.
Weve been looking on the newsgroup, as well as using Chips €śGoogle Search€ť
tool, and cannot find anything thatd explain this discrepancy, or how to
rectify it.
By and large this appears to be mostly an aesthetic issue more than a core
issue. However, as our documents are accessible for the public, we really
want to have as common appearing a form as possible.

Anything one can offer to explain what's occuring will be much appreciated.
.. .