org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper
Class ExcelPrintSetupFactory

java.lang.Object
  org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.ExcelPrintSetupFactory

public final class ExcelPrintSetupFactory
extends Object

Performs all steps to setup the printer page of an excel sheet.

This list is based on the specifications found in the OpenOffice documentation. http://sc.openoffice.org/excelfileformat.pdf.

Author:

user

Field Summary

static ExcelPageDefinition	A3 A standard page format mapping for excel.
static ExcelPageDefinition	A4 A standard page format mapping for excel.
static ExcelPageDefinition	A4_SMALL A standard page format mapping for excel.
static ExcelPageDefinition	A5 A standard page format mapping for excel.
static ExcelPageDefinition	B4 A standard page format mapping for excel.
static ExcelPageDefinition	B5 A standard page format mapping for excel.
static ExcelPageDefinition	ENV10 A standard page format mapping for excel.
static ExcelPageDefinition	ENV11 A standard page format mapping for excel.
static ExcelPageDefinition	ENV12 A standard page format mapping for excel.
static ExcelPageDefinition	ENV14 A standard page format mapping for excel.
static ExcelPageDefinition	ENV9 A standard page format mapping for excel.
static ExcelPageDefinition	ENVB5 A standard page format mapping for excel.
static ExcelPageDefinition	ENVB6 A standard page format mapping for excel.
static ExcelPageDefinition	ENVC3 A standard page format mapping for excel.
static ExcelPageDefinition	ENVC4 A standard page format mapping for excel.
static ExcelPageDefinition	ENVC5 A standard page format mapping for excel.
static ExcelPageDefinition	ENVC6 A standard page format mapping for excel.
static ExcelPageDefinition	ENVC65 A standard page format mapping for excel.
static ExcelPageDefinition	ENVDL A standard page format mapping for excel.
static ExcelPageDefinition	ENVELOPE A standard page format mapping for excel.
static ExcelPageDefinition	ENVISOB4 A standard page format mapping for excel.
static ExcelPageDefinition	ENVMONARCH A standard page format mapping for excel.
static ExcelPageDefinition	ENVPERSONAL A standard page format mapping for excel.
static ExcelPageDefinition	EXECUTIVE A standard page format mapping for excel.
static ExcelPageDefinition	FANFOLDGERMAN A standard page format mapping for excel.
static ExcelPageDefinition	FANFOLDGERMANLEGAL A standard page format mapping for excel.
static ExcelPageDefinition	FANFOLDUS A standard page format mapping for excel.
static ExcelPageDefinition	FOLIO A standard page format mapping for excel.
static ExcelPageDefinition	LEDGER A standard page format mapping for excel.
static ExcelPageDefinition	LEGAL A standard page format mapping for excel.
static ExcelPageDefinition	LETTER A standard page format mapping for excel.
static ExcelPageDefinition	LETTER_SMALL A standard page format mapping for excel.
static ExcelPageDefinition	NOTE A standard page format mapping for excel.
static ExcelPageDefinition	PAPER10X14 A standard page format mapping for excel.
static ExcelPageDefinition	PAPER11X17 A standard page format mapping for excel.
static ExcelPageDefinition	QUARTO A standard page format mapping for excel.
static ExcelPageDefinition	STATEMENT A standard page format mapping for excel.
static ExcelPageDefinition	TABLOID A standard page format mapping for excel.

Method Summary

static void

performPageSetup(org.apache.poi.ss.usermodel.PrintSetup printSetup, PhysicalPageBox pageformat, String paperdef, String paperOrientation) Performs the page setup and searches a matching page format for the report.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

LETTER

public static final ExcelPageDefinition LETTER

A standard page format mapping for excel.

LETTER_SMALL

public static final ExcelPageDefinition LETTER_SMALL

A standard page format mapping for excel.

TABLOID

public static final ExcelPageDefinition TABLOID

A standard page format mapping for excel.

LEDGER

public static final ExcelPageDefinition LEDGER

A standard page format mapping for excel.

LEGAL

public static final ExcelPageDefinition LEGAL

A standard page format mapping for excel.

STATEMENT

public static final ExcelPageDefinition STATEMENT

A standard page format mapping for excel.

EXECUTIVE

public static final ExcelPageDefinition EXECUTIVE

A standard page format mapping for excel.

A3

public static final ExcelPageDefinition A3

A standard page format mapping for excel.

A4

public static final ExcelPageDefinition A4

A standard page format mapping for excel.

A4_SMALL

public static final ExcelPageDefinition A4_SMALL

A standard page format mapping for excel.

A5

public static final ExcelPageDefinition A5

A standard page format mapping for excel.

B4

public static final ExcelPageDefinition B4

A standard page format mapping for excel.

B5

public static final ExcelPageDefinition B5

A standard page format mapping for excel.

FOLIO

public static final ExcelPageDefinition FOLIO

A standard page format mapping for excel.

QUARTO

public static final ExcelPageDefinition QUARTO

A standard page format mapping for excel.

PAPER10X14

public static final ExcelPageDefinition PAPER10X14

A standard page format mapping for excel.

PAPER11X17

public static final ExcelPageDefinition PAPER11X17

A standard page format mapping for excel.

NOTE

public static final ExcelPageDefinition NOTE

A standard page format mapping for excel.

ENV9

public static final ExcelPageDefinition ENV9

A standard page format mapping for excel.

ENV10

public static final ExcelPageDefinition ENV10

A standard page format mapping for excel.

ENV11

public static final ExcelPageDefinition ENV11

A standard page format mapping for excel.

ENV12

public static final ExcelPageDefinition ENV12

A standard page format mapping for excel.

ENV14

public static final ExcelPageDefinition ENV14

A standard page format mapping for excel.

ENVDL

public static final ExcelPageDefinition ENVDL

A standard page format mapping for excel.

ENVC5

public static final ExcelPageDefinition ENVC5

A standard page format mapping for excel.

ENVC3

public static final ExcelPageDefinition ENVC3

A standard page format mapping for excel.

ENVC4

public static final ExcelPageDefinition ENVC4

A standard page format mapping for excel.

ENVC6

public static final ExcelPageDefinition ENVC6

A standard page format mapping for excel.

ENVC65

public static final ExcelPageDefinition ENVC65

A standard page format mapping for excel.

ENVISOB4

public static final ExcelPageDefinition ENVISOB4

A standard page format mapping for excel.

ENVB5

public static final ExcelPageDefinition ENVB5

A standard page format mapping for excel.

ENVB6

public static final ExcelPageDefinition ENVB6

A standard page format mapping for excel.

ENVELOPE

public static final ExcelPageDefinition ENVELOPE

A standard page format mapping for excel.

ENVMONARCH

public static final ExcelPageDefinition ENVMONARCH

A standard page format mapping for excel.

ENVPERSONAL

public static final ExcelPageDefinition ENVPERSONAL

A standard page format mapping for excel.

FANFOLDUS

public static final ExcelPageDefinition FANFOLDUS

A standard page format mapping for excel.

FANFOLDGERMAN

public static final ExcelPageDefinition FANFOLDGERMAN

A standard page format mapping for excel.

FANFOLDGERMANLEGAL

public static final ExcelPageDefinition FANFOLDGERMANLEGAL

A standard page format mapping for excel.

Method Detail

performPageSetup

public static void performPageSetup(org.apache.poi.ss.usermodel.PrintSetup printSetup,
                                    PhysicalPageBox pageformat,
                                    String paperdef,
                                    String paperOrientation)

Performs the page setup and searches a matching page format for the report.

Parameters:

printSetup - the print setup object of the current sheet.

pageformat - the pageformat defined for the report.

paperdef - the excel paper size property (may be null).

paperOrientation - the paper orientation, either "Landscape" or "Portrait"