Cross Platform Screen Resolution Problems

[RickGreg]

I am designing some spreadsheet tools on a Mac that will be used by a
primarily Windows Laptop audience. When I sent my first draft for review,
the sheets that fit perfectly in my Powerbook monitor were oversized for the
PC by about 150%.

Is there a way to ensure that my designs will fit on the PC? Simply
reducing the zoom on the PC shrinks the text as well, so it becomes
unreadable. Do I need to set my screen resolution to whatever the PCs are
running? Or should I design at 150% and send to them at 100%??? Any way to
set up an automatic conversion?

Many thanks!

 

[Bob Greenblatt]

I am designing some spreadsheet tools on a Mac that will be used by a
primarily Windows Laptop audience. When I sent my first draft for review,
the sheets that fit perfectly in my Powerbook monitor were oversized for the
PC by about 150%.

Is there a way to ensure that my designs will fit on the PC? Simply
reducing the zoom on the PC shrinks the text as well, so it becomes
unreadable. Do I need to set my screen resolution to whatever the PCs are
running? Or should I design at 150% and send to them at 100%??? Any way to
set up an automatic conversion?

Many thanks!

What's not fitting? Is it the window size with the scroll bars not showing?
What I usually do is to resize the window to fit the platform in the
auto_open routine. This is easily done by a windows.arrange of the active
document only.

 

[RickGreg]

Bob-

The window pane opens fine on the desktop of the PC (with scroll bars where
thy should be). However, my row and column sizing (and text sizes) appear
150% larger.

The users then have to reduce zoom to around 66% to see what I intend them
to see. This reduces text size on drop down boxes and other features.

I'd like the window to leave my mac and appear as intended on the PC, even
if that means I have to revise the way I work on the mac. Make sense?

Thx. -Rick

 

[Bob Greenblatt]

Bob-

The window pane opens fine on the desktop of the PC (with scroll bars where
thy should be). However, my row and column sizing (and text sizes) appear
150% larger.

The users then have to reduce zoom to around 66% to see what I intend them
to see. This reduces text size on drop down boxes and other features.

I'd like the window to leave my mac and appear as intended on the PC, even
if that means I have to revise the way I work on the mac. Make sense?

Thx. -Rick

From: Bob Greenblatt <[email protected]>
Newsgroups: microsoft.public.mac.office.excel
Date: Tue, 01 Feb 2005 07:51:50 -0500
Subject: Re: Cross Platform Screen Resolution Problems


What's not fitting? Is it the window size with the scroll bars not showing?
What I usually do is to resize the window to fit the platform in the
auto_open routine. This is easily done by a windows.arrange of the active
document only.

Is the file zoomed at 100% on the Mac when you are developing it? What fonts
and styles are you using? I've seen some issues here but not nearly as
extreme as you are reporting.

 

[RickGreg]

Yes... original was developed at 100% on Mac. Main fonts used are Helvetica
and Arial.

I've had this happen before with other PC-based clients.

I'm wondering if it's as simple as my powerbook's screen resolution settings
(1024 x 768) being different than the pc folks...?

From: Bob Greenblatt <[email protected]>
Newsgroups: microsoft.public.mac.office.excel
Date: Tue, 01 Feb 2005 11:40:47 -0500
Subject: Re: Cross Platform Screen Resolution Problems

 

[CyberTaz]

Hello RickGreg-

Just passing thru, but you may be on the right track if there is a
difference in resolution. If the other screens are @ 800x600, they
aren't able to show as many rows & columns in the comparably sized
window. As a result more scrolling and the content will appear to be
"magnified". Same thing happens on either platform if you create a file
and then change your display res., you don't even have to take the file
to a different system. Try that out and see if that may be what's
happening. Web page design is similar in effect. If a page is created
taking full advantage of a hi-res display area (no regard for pixel
dimensions of the page), the typical low-res User viewing the page has
to scroll <-&-> as well a up & down more than they should.
Hope this is useful.|:>)