Beefed up Excel sheet looks different in Windows

[Bergström, Martin]

Hi!

A person here where I work use Office 2004 for Mac to creat a PPT
presentation. Some of the slides consist of an Excel sheet that she then
increased in size by dragging in one corner in PowerPoint. It looks just
fine in PPT for the Mac, but when opening in in PPT for Windows all fonts in
the cells are WAY too big and overlap other cells. The funny thing is that
if one double-click the Excel sheet in PPT for Windows (at least in version
2002) to edit it, and then click on another slide, it almost gets fixed,
except that the text in some cells still go "to far" and into another cell.

Why is this?
Any Ideas?

Best regards,
-a Martin B

 

[Jim Gordon MVP]

Hi,

By any chance is the zoom control in the Excel workbook set to something
higher than 100%? Try adjusting the zoom control and see what happens.

-Jim Gordon
Mac MVP

Hi!

A person here where I work use Office 2004 for Mac to creat a PPT
presentation. Some of the slides consist of an Excel sheet that she then
increased in size by dragging in one corner in PowerPoint. It looks just
fine in PPT for the Mac, but when opening in in PPT for Windows all fonts in
the cells are WAY too big and overlap other cells. The funny thing is that
if one double-click the Excel sheet in PPT for Windows (at least in version
2002) to edit it, and then click on another slide, it almost gets fixed,
except that the text in some cells still go "to far" and into another cell.

Why is this?
Any Ideas?

Best regards,
-a Martin B

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Bergström, Martin]

Thanks for your reply, but nope, it's not the zoom.

Here is the same Excel-file opened on the Mac (where it looks correct) and
the same file opened in Ecxel 2002 on Windows XP.

http://home.mac.se/star-affinity/excel_mac.jpg
http://home.mac.se/star-affinity/excel_windows.JPG

Things look quite different in Windows.
The font used is Gill Alt One MT.

Hmm...Maybe I should post this in the Excel section...

Has it got to do with the Mac showing things in 72 dpi and Windows 92 dpi?

Why does the ###### come up in Excel for Windows? If I double click them it
"goes away" and change to show the correct "100.00%"

Wick wack indeed... :|

 

[CyberTaz]

I believe you've hit on _part_ of the problem being the difference in ppi
but that is compounded by :

A) Different fonts on the Mac & the PC - even though the *names* may be the
same the metrics differ, and
B) Having stretched the object in the Mac file the proportionality and
metrics have been thrown off & the PC is doing the best it can to mimic it -
but falling short.

Cross-platform *file* compatibility is one thing, but that doesn't mean that
everything you can do *in* the file will render the same on both

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Steve Rindsberg]

B) Having stretched the object in the Mac file the proportionality and

metrics have been thrown off & the PC is doing the best it can to mimic it -
but falling short.

FWIW, the PC can screw up this part on its own. No need for any Mac assist.

Text in embedded OLE objects behaves oddly when you change the size of the
container object. It seems to jump from one pre-defined point size to another
rather than scaling smoothly. Result: as you gradually scale the object up,
the text will stay the same (too small) size while everything else grows. Then
suddenly the text jumps to the next "approved" size (usually a bit too large)
but as you continue scaling up the object, it gets to a point where the object
and text size match. Then it goes out of whack again as you continue scaling.
And so on.

Linked OLE objects on the PC don't do this, they scale evenly, but as near as I
can tell, you can't create these on the Mac. Bummer.

================================================
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Steve Rindsberg]

Thanks for your reply, but nope, it's not the zoom.

Here is the same Excel-file opened on the Mac (where it looks correct) and
the same file opened in Ecxel 2002 on Windows XP.

http://home.mac.se/star-affinity/excel_mac.jpg
http://home.mac.se/star-affinity/excel_windows.JPG

Things look quite different in Windows.
The font used is Gill Alt One MT.

Is the same font present on the PC? If not, some other font will be substituted,
which would almost certainly cause problems.

Why does the ###### come up in Excel for Windows? If I double click them it
"goes away" and change to show the correct "100.00%"

Excel displays #### when a cell isn't wide enough to display its contents.

Wick wack indeed... :|

================================================
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Bergström, Martin]

Is the same font present on the PC? If not, some other font will be

substituted,
which would almost certainly cause problems.

Excel displays #### when a cell isn't wide enough to display its contents.

Thanks for your reply, but nope, it's not the zoom.

Here is the same Excel-file opened on the Mac (where it looks correct) and
the same file opened in Ecxel 2002 on Windows XP.

http://home.mac.se/star-affinity/excel_mac.jpg
http://home.mac.se/star-affinity/excel_windows.JPG

Things look quite different in Windows.
The font used is Gill Alt One MT.

Is the same font present on the PC? If not, some other font will be
substituted,
which would almost certainly cause problems.

Why does the ###### come up in Excel for Windows? If I double click them it
"goes away" and change to show the correct "100.00%"

Excel displays #### when a cell isn't wide enough to display its contents.

Wick wack indeed... :|

Hi,

By any chance is the zoom control in the Excel workbook set to something
higher than 100%? Try adjusting the zoom control and see what happens.

-Jim Gordon
Mac MVP


Quoting from "Bergström, Martin" <[email protected]>, in article
C19DD3A0.7CF2%[email protected], on [DATE:

Hi!

A person here where I work use Office 2004 for Mac to creat a PPT
presentation. Some of the slides consist of an Excel sheet that she then
increased in size by dragging in one corner in PowerPoint. It looks just
fine in PPT for the Mac, but when opening in in PPT for Windows all fonts
in
the cells are WAY too big and overlap other cells. The funny thing is that
if one double-click the Excel sheet in PPT for Windows (at least in version
2002) to edit it, and then click on another slide, it almost gets fixed,
except that the text in some cells still go "to far" and into another cell.

Why is this?
Any Ideas?

Best regards,
-a Martin B

================================================
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

 

[Bergström, Martin]

I see what you mean, It's just that the user don't really understand those
things. They just find it frustrating that it doesn't work the same.

 

[Steve Rindsberg]

Let's doublecheck that. "Same" to organic lifeforms and "Same" to computers isn't
always the ... um ... well ... same. ;-)

Open the file on the PC and from the main menu choose Format, Replace Fonts.
In the upper of the two list boxes, scan down the list of fonts. They should all
have TT or printer icons. If any has a ? or some other icon, that's a problem.

Excel displays #### when a cell isn't wide enough to display its contents.

OK. Thanks for this info!

Thanks for your reply, but nope, it's not the zoom.

Here is the same Excel-file opened on the Mac (where it looks correct) and
the same file opened in Ecxel 2002 on Windows XP.

http://home.mac.se/star-affinity/excel_mac.jpg
http://home.mac.se/star-affinity/excel_windows.JPG

Things look quite different in Windows.
The font used is Gill Alt One MT.

Is the same font present on the PC? If not, some other font will be
substituted,
which would almost certainly cause problems.

Why does the ###### come up in Excel for Windows? If I double click them it
"goes away" and change to show the correct "100.00%"

Excel displays #### when a cell isn't wide enough to display its contents.

Wick wack indeed... :|

On 8/12/06 01:27, in article
C19E1B90.13F90%[email protected], "Jim Gordon MVP"

Hi,

By any chance is the zoom control in the Excel workbook set to something
higher than 100%? Try adjusting the zoom control and see what happens.

-Jim Gordon
Mac MVP


Quoting from "Bergström, Martin" <[email protected]>, in article
C19DD3A0.7CF2%[email protected], on [DATE:

Hi!

A person here where I work use Office 2004 for Mac to creat a PPT
presentation. Some of the slides consist of an Excel sheet that she then
increased in size by dragging in one corner in PowerPoint. It looks just
fine in PPT for the Mac, but when opening in in PPT for Windows all fonts
in
the cells are WAY too big and overlap other cells. The funny thing is that
if one double-click the Excel sheet in PPT for Windows (at least in version
2002) to edit it, and then click on another slide, it almost gets fixed,
except that the text in some cells still go "to far" and into another cell.

Why is this?
Any Ideas?

Best regards,
-a Martin B

================================================
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

================================================
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================