jxl
Class SheetSettings

java.lang.Object
  |
  +--jxl.SheetSettings

public final class SheetSettings

extends java.lang.Object

This is a bean which client applications may use to get/set various properties which are associated with a particular worksheet, such as headers and footers, page orientation etc.

Field Summary

private double	bottomMargin The margin from the bottom of the paper in inches
private static double	defaultFooterMargin
private static double	defaultHeaderMargin
private static double	defaultHeightMargin
private static PageOrientation	defaultOrientation
private static PaperSize	defaultPaperSize
private static int	defaultPrintResolution
private static double	defaultWidthMargin
private int	fitHeight The number of pages into which this excel sheet is squeezed heightwise
private boolean	fitToPages Indicates whether to fit the print to the pages or scale the output This field is manipulated indirectly by virtue of the setFitWidth/Height methods
private int	fitWidth The number of pages into which this excel sheet is squeezed widthwise
private double	footerMargin The margin allocated for any page footers, in inches
private double	headerMargin The margin allocated for any page headers, in inches
private boolean	hidden Indicates whether or not this sheet is hidden
private int	horizontalPrintResolution The horizontal print resolution
private double	leftMargin The margin from the left hand side of the paper in inches
private PageOrientation	orientation The page orientation
private int	pageStart The page number at which to commence printing
private PaperSize	paperSize The paper size for printing
private double	rightMargin The margin from the right hand side of the paper in inches
private int	scaleFactor The scale factor used when printing
private boolean	selected Indicates whether or not this sheet is selected
private boolean	sheetProtected Indicates whether or not this sheet is protected
private double	topMargin The margin from the top of the paper in inches
private int	verticalPrintResolution The vertical print resolution

Constructor Summary

SheetSettings()
Default constructor

SheetSettings(SheetSettings copy)
Copy constructor.

Method Summary

double	getBottomMargin() Accessor for the bottom margin
double	getDefaultHeightMargin() Gets the default margin height
double	getDefaultWidthMargin() Gets the default margin width
int	getFitHeight() Accessor for the fit height
boolean	getFitToPages() Accessor for the fit width print flag
int	getFitWidth() Accessor for the fit width
double	getFooterMargin() Accessor for the footer margin
double	getHeaderMargin() Accessor for the header margin
int	getHorizontalPrintResolution() Accessor for the horizontal print resolution
double	getLeftMargin() Accessor for the left margin
PageOrientation	getOrientation() Accessor for the orientation
int	getPageStart() Accessor for the page start
PaperSize	getPaperSize() Accessor for the paper size
double	getRightMargin() Accessor for the right margin
int	getScaleFactor() Accessor for the scale factor
double	getTopMargin() Accessor for the top margin
int	getVerticalPrintResolution() Accessor for the vertical print resolution
boolean	isHidden() Accessor for the hidden nature of this sheet
boolean	isProtected() Queries whether this sheet is protected (ie.
boolean	isSelected() Accessor for the selected nature of the sheet
void	setBottomMargin(double m) Sets the bottom margin
void	setFitHeight(int fh) Sets the number of pages vertically that this sheet will be printed into
void	setFitToPages(boolean b) Accessor for the fit to pages flag
void	setFitWidth(int fw) Sets the number of pages widthwise which this sheet should be printed into
void	setFooterMargin(double d) Sets the margin for any page footer
void	setHeaderMargin(double d) Sets the margin for any page headers
void	setHidden(boolean h) Sets the hidden status of this worksheet
void	setHorizontalPrintResolution(int hpw) Sets the horizontal print resolution
void	setLeftMargin(double m) Sets the left margin
void	setOrientation(PageOrientation po) Sets the paper orientation for printing this sheet
void	setPageStart(int ps) Sets the page number at which to commence printing
void	setPaperSize(PaperSize ps) Sets the paper size to be used when printing this sheet
void	setProtected(boolean p) Sets the protected (ie.
void	setRightMargin(double m) Sets the right margin
void	setScaleFactor(int sf) Sets the scale factor for this sheet to be used when printing.
void	setSelected() Sets this sheet to be when it is opened in excel
void	setTopMargin(double m) Sets the top margin
void	setVerticalPrintResolution(int vpw) Sets the vertical print reslution

Methods inherited from class java.lang.Object

, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait

Field Detail

orientation

private PageOrientation orientation

The page orientation

paperSize

private PaperSize paperSize

The paper size for printing

sheetProtected

private boolean sheetProtected

Indicates whether or not this sheet is protected

hidden

private boolean hidden

Indicates whether or not this sheet is hidden

selected

private boolean selected

Indicates whether or not this sheet is selected

headerMargin

private double headerMargin

The margin allocated for any page headers, in inches

footerMargin

private double footerMargin

The margin allocated for any page footers, in inches

scaleFactor

private int scaleFactor

The scale factor used when printing

pageStart

private int pageStart

The page number at which to commence printing

fitWidth

private int fitWidth

The number of pages into which this excel sheet is squeezed widthwise

fitHeight

private int fitHeight

The number of pages into which this excel sheet is squeezed heightwise

horizontalPrintResolution

private int horizontalPrintResolution

The horizontal print resolution

verticalPrintResolution

private int verticalPrintResolution

The vertical print resolution

leftMargin

private double leftMargin

The margin from the left hand side of the paper in inches

rightMargin

private double rightMargin

The margin from the right hand side of the paper in inches

topMargin

private double topMargin

The margin from the top of the paper in inches

bottomMargin

private double bottomMargin

The margin from the bottom of the paper in inches

fitToPages

private boolean fitToPages

Indicates whether to fit the print to the pages or scale the output This field is manipulated indirectly by virtue of the setFitWidth/Height methods

defaultOrientation

private static final PageOrientation defaultOrientation

defaultPaperSize

private static final PaperSize defaultPaperSize

defaultHeaderMargin

private static final double defaultHeaderMargin

defaultFooterMargin

private static final double defaultFooterMargin

defaultPrintResolution

private static final int defaultPrintResolution

defaultWidthMargin

private static final double defaultWidthMargin

defaultHeightMargin

private static final double defaultHeightMargin

Constructor Detail

SheetSettings

public SheetSettings()

Default constructor

SheetSettings

public SheetSettings(SheetSettings copy)

Copy constructor. Called when copying sheets

Parameters:

copy -

Method Detail

setOrientation

public void setOrientation(PageOrientation po)

Sets the paper orientation for printing this sheet

Parameters:

po - the orientation

getOrientation

public PageOrientation getOrientation()

Accessor for the orientation

Returns:

the orientation

setPaperSize

public void setPaperSize(PaperSize ps)

Sets the paper size to be used when printing this sheet

Parameters:

ps - the paper size

getPaperSize

public PaperSize getPaperSize()

Accessor for the paper size

Returns:

the paper size

isProtected

public boolean isProtected()

Queries whether this sheet is protected (ie. read only)

Returns:

TRUE if this sheet is read only, FALSE otherwise

setProtected

public void setProtected(boolean p)

Sets the protected (ie. read only) status of this sheet

Parameters:

p - the protected status

setHeaderMargin

public void setHeaderMargin(double d)

Sets the margin for any page headers

Parameters:

d - the margin in inches

getHeaderMargin

public double getHeaderMargin()

Accessor for the header margin

Returns:

the header margin

setFooterMargin

public void setFooterMargin(double d)

Sets the margin for any page footer

Parameters:

d - the footer margin in inches

getFooterMargin

public double getFooterMargin()

Accessor for the footer margin

Returns:

the footer margin

setHidden

public void setHidden(boolean h)

Sets the hidden status of this worksheet

Parameters:

h - the hidden flag

isHidden

public boolean isHidden()

Accessor for the hidden nature of this sheet

Returns:

TRUE if this sheet is hidden, FALSE otherwise

setSelected

public void setSelected()

Sets this sheet to be when it is opened in excel

isSelected

public boolean isSelected()

Accessor for the selected nature of the sheet

Returns:

TRUE if this sheet is selected, FALSE otherwise

setScaleFactor

public void setScaleFactor(int sf)

Sets the scale factor for this sheet to be used when printing. The parameter is a percentage, therefore setting a scale factor of 100 will print at normal size, 50 half size, 200 double size etc

Parameters:

sf - the scale factor as a percentage

getScaleFactor

public int getScaleFactor()

Accessor for the scale factor

Returns:

the scale factor

setPageStart

public void setPageStart(int ps)

Sets the page number at which to commence printing

Parameters:

ps - the page start number

getPageStart

public int getPageStart()

Accessor for the page start

Returns:

the page start

setFitWidth

public void setFitWidth(int fw)

Sets the number of pages widthwise which this sheet should be printed into

Parameters:

fw - the number of pages

getFitWidth

public int getFitWidth()

Accessor for the fit width

Returns:

the number of pages this sheet will be printed into widthwise

setFitHeight

public void setFitHeight(int fh)

Sets the number of pages vertically that this sheet will be printed into

Parameters:

fh - the number of pages this sheet will be printed into heightwise

getFitHeight

public int getFitHeight()

Accessor for the fit height

Returns:

the number of pages this sheet will be printed into heightwise

setHorizontalPrintResolution

public void setHorizontalPrintResolution(int hpw)

Sets the horizontal print resolution

Parameters:

hpw -

getHorizontalPrintResolution

public int getHorizontalPrintResolution()

Accessor for the horizontal print resolution

Returns:

the horizontal print resolution

setVerticalPrintResolution

public void setVerticalPrintResolution(int vpw)

Sets the vertical print reslution

Parameters:

vpw - the vertical print resolution

getVerticalPrintResolution

public int getVerticalPrintResolution()

Accessor for the vertical print resolution

Returns:

the vertical print resolution

setRightMargin

public void setRightMargin(double m)

Sets the right margin

Parameters:

m - the right margin in inches

getRightMargin

public double getRightMargin()

Accessor for the right margin

Returns:

the right margin in inches

setLeftMargin

public void setLeftMargin(double m)

Sets the left margin

Parameters:

m - the left margin in inches

getLeftMargin

public double getLeftMargin()

Accessor for the left margin

Returns:

the left margin in inches

setTopMargin

public void setTopMargin(double m)

Sets the top margin

Parameters:

m - the top margin in inches

getTopMargin

public double getTopMargin()

Accessor for the top margin

Returns:

the top margin in inches

setBottomMargin

public void setBottomMargin(double m)

Sets the bottom margin

Parameters:

m - the bottom margin in inches

getBottomMargin

public double getBottomMargin()

Accessor for the bottom margin

Returns:

the bottom margin in inches

getDefaultWidthMargin

public double getDefaultWidthMargin()

Gets the default margin width

Returns:

the default margin width

getDefaultHeightMargin

public double getDefaultHeightMargin()

Gets the default margin height

Returns:

the default margin height

getFitToPages

public boolean getFitToPages()

Accessor for the fit width print flag

Returns:

TRUE if the print is to fit to pages, false otherwise

setFitToPages

public void setFitToPages(boolean b)

Accessor for the fit to pages flag

Parameters:

b - TRUE to fit to pages, FALSE to use a scale factor