Bug 45729

Summary: setRepeatingRowsAndColumns not working with landscape and fixed width printing
Product: POI Reporter: Jason Vincent <jtvincent>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: P3    
Version: 3.0-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: source to demonstrate issue with setRepeatingRowsAndColumns

Description Jason Vincent 2008-09-02 11:18:45 UTC
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"
Comment 1 Dominik Stadler 2014-08-31 11:53:14 UTC
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.