Page size ignored in Excel 2008 for Mac

Topics: User Forum
Feb 18, 2010 at 6:48 PM
Edited Feb 18, 2010 at 6:50 PM

I use the following code to set page options:


When I open my file in Excel 2003 for Windows (with Compatibility Pack), all options are set correctly.

In Excel 2008 for Mac on OS 10.6, orientation is set but paper size is not. This happens with Excel2007 and Excel5 documents.

The problem is not just with Legal size. I tried specifying A4, and it was also ignored.

This appears to be a general problem with Office 2008. I used Excel 2003 to create a fresh .xlsx file with the page size set to Legal, then copied it to my Mac. The page size was still ignored. Could someone else confirm?

Is there a workaround available, like specifying the actual page dimensions (8.5x14) instead of a named size like "Legal"?

Feb 18, 2010 at 9:58 PM

So it sounds like the problem is really outside PHPExcel?

Can you try to upload a file created in Excel 2008 / Mac OS 10.6 where paper size and orientation is set correctly? Please upload here:

Feb 19, 2010 at 12:06 AM

Yes, I continued to look after posting and it looks like this is a long-standing bug in Excel 2008. I found this post on Microsoft's forum from almost a year ago about it.

Feb 19, 2010 at 12:19 AM

Ok, thanks for the info.