poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48707] New: Excel: Custom Paper size (height/Width)
Date Tue, 09 Feb 2010 07:40:30 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=48707

           Summary: Excel: Custom Paper size (height/Width)
           Product: POI
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: tariq.zubairy@gmail.com


HSSFPrintSetup/XSSFPrintSetup setPaperSize method does not allow to set custom
width and custom height of paper used for printing ...

Here is my scenario...

HSSFSheet hssfSheet = hssfWorkBook.getSheetAt(0);
HSSFPrintSetup hssfPS = hssfSheet.getPrintSetup();

hssfPS.setFitWidth((short)1);
hssfPS.setFitHeight((short)999);
hssfSheet.setFitToPage(true);


here I want to set the custom paper size, as setPaperSize only gives few option
for paper size so it is not feasible due to that limitation. I want to set the
custom paper size according to the maximum physical number of cells in excel
sheet so that the data in my sheet should not shrink when I made its actual
printout or PDF.... (i.e. set width to 17 inches when max physical columns in
sheet are more than 10 and set width of page to 20 inches when max physical
columns are greater than 15 etc...)

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message