Bug 48485

Summary:	Paper size A3 not available in HSSFPrintSetup
Product:	POI	Reporter:	Babu <kala>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	P2
Version:	3.6-FINAL
Target Milestone:	---
Hardware:	PC
OS:	Windows XP

Description Babu 2010-01-05 00:02:30 UTC

The setPaperSize(short) method in HSSFPrintSetup does not currently support A3 papersize. (Supports A4,A5,Letter,Legal, Executive and a few Envelope sizes only). For large reports, A3 seems important. Would it be possible to add this also ?

Comment 1 Nick Burch 2010-01-05 01:21:17 UTC

Any chance you could upload two very simple otherwise identical files, one set to A4, and one set to A3?

That'll be useful for double checking the settings needed in the file for A3, as well as being the basis for the unit tests for the feature once added.

Comment 2 Kai Richter 2010-03-26 06:25:04 UTC

I tried to create A3 size excel files. With a missing support for A3, i read an existing file and found the (short) vaule 8. 
Using 
sheet.getPrintSetup().setPaperSize((short)8);
seems to be a workaround to create A3 excel files.

Comment 3 Nick Burch 2010-03-30 10:06:35 UTC

I've added constants for a number of missing sizes, including A3, in r929064.