Scale and Aspect Ratios diffferent

[owlnevada]

A colleague of mine has created some macros with your respective helps, and
in their use we’ve found something odd arise.
And the outcome appears to depend on the version of excel under which the
file was created.
We’ve 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%.
We’ve 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 ¾â€.
We’ve been looking on the newsgroup, as well as using Chip’s “Google Searchâ€
tool, and cannot find anything that’d 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.
.. .

 

[Jayson]

I suspect it has to do with your print settings. In the Page Setup dialog box
and in the page tab the scaling section may be different. To get them exactly
the same you'll need to make sure the 'Adjust to...' option is selected and
make the percentage the same for both.

 

[owlnevada]

We checked that and previously one was 83% and the other was 100%. We always
print one wide by one high so the "Fit to" is always checked. It sure seems
like its dragging some screen attribute forward from when the file was first
created years ago and we need a way to reset it somehow. . . .

 

[Jayson]

The only other thing I can think to check, without seeing the file is to
check the print areas. Perhaps 1 sheet has an extra row or column that is not
formatted but included in the print area. 1 more thing, too. Check to see how
many rows or columns are repeating on top or on the left. If these aren't the
same that might cause an issue.

Just for kicks, try making both sheets 73% on the page setup screen. If none
of this does it, then hard to tell without seeing the file.

 

[Steve]

hi again Jayson,

We did that.
Although, instead of setting it to 73% for both, I'd set them to 80%.
Down for one, and up for the other.
That placed the width on the formerly 73%'r out into two columns on to a
second page, and 5 rows into the third page-- one down. Thus forcing it from
a 1 x 1 to a 2 x 2.

We also just got done with a mapping light table to compare point for point
on the location of the borders for each row/column grouping. Width for width
in the print out, it appears that the widths are well within reason. It's the
height that's the issue.


Then on the print area, I double checked that-- not the issue. The extrerior
rows and columns are well-defined as being so different that their
inclusion/exclusion would be real clear. Nothing extra there....

can send the file, via your blog, to continue this discussion, if amenable.

 

[Jayson]

my email can be found at http://www.blogger.com/profile/05025372913754824038

 

[Steve]

my email can be found at http://www.blogger.com/profile/05025372913754824038