Feb 18, 2010 at 5:48 PM
Edited Feb 18, 2010 at 5: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"?