Created attachment 22516 [details] source to demonstrate issue with setRepeatingRowsAndColumns utilizing the HSSFWorkbook.setRepeatingRowsAndColumns method causes the print rendering to scale and rotate improperly. The attached java source file produces 2 Excel files. landscapeTest_noRepeat.xls and landscapeTest_withRepeat.xls. landscapeTest_noRepeat.xls is formatted as expected without the repeating rows; landscape and page fit to 1 page wide. Set the repeating rows and the content appears to be scaled to fit portrait while the page is still rendered in landscape, resulting in a large reduction in resolution and large left and right margins. This is using POI-3.1-FINAL-20080629.jar. No response to email sent to the mailing list with the subject of: "printing issue: Landscape, fixed width, repeating rows"
At least in print-preview in OpenOffice the files looked fine when using POI 3.11-beta2. Please reopen this Bug if you still see the incorrect layout when using the latest version of POI.