Excel 2007 A4 Landscape printing still not fixed
Printing spreadsheets in A4-Landscape mode from XP/Excel 2007 is still problematic with the current (Mar/Apr 2010) HP software suite (see below for configuration and version details).
The problem seems to be that in Excel 2007 the page setup can be for A4 Landscape and (you think) the 8500 is set to A4 Portrait; at the instance of printing the 8500 is reporting to Excel a page width of LETTER Landscape. This causing the Excel page width to be re-scaled (compressed) and if you haven't set hard page breaks the length of the page to be extended by Excel. Interestingly, the A4-Landscape page length is being retained as Excel headers and footers are being printed correctly.
In summary your Excel A4L page size (in mm) of: 297 wide x 210 long is being resized and printed on a page size of 279.4 wide x 210 long.
I've confirmed the problem exists for both Excel 2003 and 2007 spreadsheets printed via Excel 2007 and suspect that the problem applies to any spreadsheet printed directly from Excel 2007, as the problem does not arise with spreadsheets printed via PDF (ExpertPDF v6).
I've also confirmed that Excel 2007 prints these spreadsheets without problem on an HP Deskjet 960c and a PSC1205 - both of which use drivers that predate HP Solution Center and MS Office 2007.
Hence I conclude the problem is with current version(s) of HP Solution Center and associated drivers.
The workaround (including checks) I have discovered for this problem seems to be to set A4 and Landscape in both Excel and in the printer driver just before you print, specifically:
- Print: Confirm/select the printer
- Page Layout: Set page setup ie. A4 Landscape etc.
- View -> Page Break Preview: Set page breaks.
- Print Preview: Confirm Excel's version of what is to be printed on each A4 page (you can also confirm via Page Setup your page settings).
- Print -> Properties
Printing Shortcuts: Select the shortcut you wish to use
Features: Make sure Landscape is selected and re-select A4 as the paper size.
Click 'OK'
- Print: now just select the pages and sheets you want printed and click 'OK'.
I've noticed that the A4 and Landscape settings are not particularly 'sticky' and so the only reliable way to ensure that a spreadsheet is correctly printed is to reset these on every print (ie. repeat the above...).
I suspect that the root cause of this problem is that HP Solution Center
assumes a default page size of LETTER and that within the function that automatically handles the landscape/portrait transposition this has been hardcoded and hence this problem will arise for page sizes different to LETTER (I've confirmed the resizing problem defined above also occurs when I set Excel to use Legal landscape).
The problems that arise with the inability to set a default other than LETTER are well documented across the HP (and third-party) forums - along with HP's inability to understand and resolve this problem. It seems that this problem is generic to the HP Solution Center versions released in 2008 and later (I can confirm that it happens with versions 12 and 13). Since Solution Center is used across the Deskjet, Photosmart, Officejet and Scanjet ranges, I anticipate the problems being seen on the 8500 also being seen on other models within these ranges; a search of the HP Consumer and Business Forums seems to confirm this is the case. Based on what I've read in the HP Forums, my recommendation to any one who has pre-HP Solution Center software is to fully uninstall Solution Center and re-install the older drivers and disable automatic update.
This combined with several other problems (well documented on various forums) has lead me to two conclusions:
- This device is not suitable for business use and that potentially HP are in breach of UK law in the claims they make for this product.
- None of the various reviewers of this product actually used this product beyond printing out a few test pages to analyse print quality and speed.
APPENDICES
System Information
HP OJPro8500 Wifi (A909g) - currently connected via USB (!)
Firmware: DLM1FN0924AR (version shipped with in Jan-2010)
HP Solution Center 13.0 (displayed version: 130.0.44.62)
MS Office 2007-SP2
MS XP-Pro-SP3
Note: HP software installed using the following HP downloads:
"HP Officejet Full Feature Software and Driver" version 12.0.0
"Solution Center Update" version 13.0
Landscape Page Sizes (in mm) for Quick Reference
A4: 297 x 210
Letter: 279.4 x 215.9