MissingCloneSheetProperties (Jett 0.11.0 API)

java.lang.Object
- net.sf.jett.model.MissingCloneSheetProperties

```
public class MissingCloneSheetProperties
extends java.lang.Object
```
As it turns out, Workbook#cloneSheet doesn't clone all the properties of a Sheet, specifically missing things such as Print Setup properties. The coverage is higher for HSSF than for XSSF, but still not complete.

In addition, it seems that calling Workbook#setSheetOrder completely messes up XSSF, including nulling out any Repeating Rows and setting other Print Setup properties to defaults.

This object stores all such incorrectly cloned sheet properties. These properties will be read and assigned to this object prior to any cloning. After cloning and sheet moving, these properties will be the source data to put the data back.

There are other properties that have to do with Print Setup, but if they are correctly copied, then there is no reason for them to be here.

Since:

0.7.0

Author:

Randy Gettman

Constructor Summary

Constructors
Constructor	Description
`MissingCloneSheetProperties()`	Default constructor to set things to default values.
`MissingCloneSheetProperties(MissingCloneSheetProperties other)`	When a `Sheet` is cloned, we will of course need to clone the missing clone sheet properties as well.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`short`	`getCopies()`	Returns the number of copies.
`short`	`getFitHeight()`	Returns the number of pages tall to fit the sheet.
`short`	`getFitWidth()`	Returns the number of pages wide to fit the sheet.
`short`	`getHResolution()`	Returns the "H Resolution".
`short`	`getPageStart()`	Returns the starting page number.
`short`	`getPaperSize()`	Returns the paper size.
`org.apache.poi.ss.util.CellRangeAddress`	`getRepeatingColumns()`	Returns the range of columns to repeat at the left of every page.
`org.apache.poi.ss.util.CellRangeAddress`	`getRepeatingRows()`	Returns the range of rows to repeat at the top of every page.
`short`	`getScale()`	Returns the scale.
`short`	`getVResolution()`	Returns the "V resolution".
`boolean`	`isDraft()`	Returns whether it's draft quality.
`boolean`	`isLandscape()`	Returns whether it's landscape.
`boolean`	`isLeftToRight()`	Returns whether the page print order should be left to right before up to down.
`boolean`	`isNoColor()`	Returns whether to print with no color (b/w).
`boolean`	`isNotes()`	Returns whether to use "notes".
`boolean`	`isUsePage()`	Returns whether to "use page".
`boolean`	`isValidSettings()`	Returns whether the settings are "valid".
`void`	`setCopies(short copies)`	Sets the number of copies.
`void`	`setDraft(boolean draft)`	Sets whether it's draft quality.
`void`	`setFitHeight(short fitHeight)`	Sets the number of pages tall to fit the sheet.
`void`	`setFitWidth(short fitWidth)`	Sets the number of pages wide to fit the sheet.
`void`	`setHResolution(short hResolution)`	Sets the "H Resolution".
`void`	`setLandscape(boolean landscape)`	Sets whether it's landscape.
`void`	`setLeftToRight(boolean leftToRight)`	Sets whether the page print order should be left to right before up to down.
`void`	`setNoColor(boolean noColor)`	Sets whether to print with no color (b/w).
`void`	`setNotes(boolean notes)`	Sets whether to use "notes".
`void`	`setPageStart(short pageStart)`	Sets the starting page number.
`void`	`setPaperSize(short paperSize)`	Sets the paper size.
`void`	`setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress repeatingColumns)`	Sets the range of columns to repeat at the left of every page.
`void`	`setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress repeatingRows)`	Sets the range of rows to repeat at the top of every page.
`void`	`setScale(short scale)`	Sets the scale.
`void`	`setUsePage(boolean usePage)`	Sets whether to "use page".
`void`	`setValidSettings(boolean validSettings)`	Sets whether the settings are "valid".
`void`	`setVResolution(short vResolution)`	Sets the "V resolution".

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - MissingCloneSheetProperties
```
public MissingCloneSheetProperties()
```
    Default constructor to set things to default values.
  - MissingCloneSheetProperties
```
public MissingCloneSheetProperties(MissingCloneSheetProperties other)
```
    When a Sheet is cloned, we will of course need to clone the missing clone sheet properties as well. This is the copy constructor.
    
    Parameters:
    
    other - Another MissingCloneSheetProperties.
- Method Detail
  - getRepeatingColumns
```
public org.apache.poi.ss.util.CellRangeAddress getRepeatingColumns()
```
    Returns the range of columns to repeat at the left of every page.
    
    Returns:
    
    The range of columns to repeat at the left of every page.
  - setRepeatingColumns
```
public void setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress repeatingColumns)
```
    Sets the range of columns to repeat at the left of every page.
    
    Parameters:
    
    repeatingColumns - The range of columns to repeat at the left of every page.
  - getRepeatingRows
```
public org.apache.poi.ss.util.CellRangeAddress getRepeatingRows()
```
    Returns the range of rows to repeat at the top of every page.
    
    Returns:
    
    The range of rows to repeat at the top of every page.
  - setRepeatingRows
```
public void setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress repeatingRows)
```
    Sets the range of rows to repeat at the top of every page.
    
    Parameters:
    
    repeatingRows - The range of rows to repeat at the top of every page.
  - getCopies
```
public short getCopies()
```
    Returns the number of copies.
    
    Returns:
    
    The number of copies.
  - setCopies
```
public void setCopies(short copies)
```
    Sets the number of copies.
    
    Parameters:
    
    copies - The number of copies.
  - isDraft
```
public boolean isDraft()
```
    Returns whether it's draft quality.
    
    Returns:
    
    Whether it's draft quality.
  - setDraft
```
public void setDraft(boolean draft)
```
    Sets whether it's draft quality.
    
    Parameters:
    
    draft - Whether it's draft quality.
  - getFitHeight
```
public short getFitHeight()
```
    Returns the number of pages tall to fit the sheet.
    
    Returns:
    
    The number of pages tall to fit the sheet.
  - setFitHeight
```
public void setFitHeight(short fitHeight)
```
    Sets the number of pages tall to fit the sheet.
    
    Parameters:
    
    fitHeight - The number of pages tall to fit the sheet.
  - getFitWidth
```
public short getFitWidth()
```
    Returns the number of pages wide to fit the sheet.
    
    Returns:
    
    The number of pages wide to fit the sheet.
  - setFitWidth
```
public void setFitWidth(short fitWidth)
```
    Sets the number of pages wide to fit the sheet.
    
    Parameters:
    
    fitWidth - The number of pages wide to fit the sheet.
  - getHResolution
```
public short getHResolution()
```
    Returns the "H Resolution".
    
    Returns:
    
    The "H Resolution".
  - setHResolution
```
public void setHResolution(short hResolution)
```
    Sets the "H Resolution".
    
    Parameters:
    
    hResolution - The "H Resolution".
  - isLandscape
```
public boolean isLandscape()
```
    Returns whether it's landscape.
    
    Returns:
    
    Whether it's landscape.
  - setLandscape
```
public void setLandscape(boolean landscape)
```
    Sets whether it's landscape.
    
    Parameters:
    
    landscape - Whether it's landscape.
  - isLeftToRight
```
public boolean isLeftToRight()
```
    Returns whether the page print order should be left to right before up to down.
    
    Returns:
    
    Whether the page print order should be left to right before up to down.
  - setLeftToRight
```
public void setLeftToRight(boolean leftToRight)
```
    Sets whether the page print order should be left to right before up to down.
    
    Parameters:
    
    leftToRight - Whether the page print order should be left to right before up to down.
  - isNoColor
```
public boolean isNoColor()
```
    Returns whether to print with no color (b/w).
    
    Returns:
    
    Whether to print with no color (b/w).
  - setNoColor
```
public void setNoColor(boolean noColor)
```
    Sets whether to print with no color (b/w).
    
    Parameters:
    
    noColor - Whether to print with no color (b/w).
  - isNotes
```
public boolean isNotes()
```
    Returns whether to use "notes".
    
    Returns:
    
    Whether to use "notes".
  - setNotes
```
public void setNotes(boolean notes)
```
    Sets whether to use "notes".
    
    Parameters:
    
    notes - Whether to use "notes".
  - getPageStart
```
public short getPageStart()
```
    Returns the starting page number.
    
    Returns:
    
    The starting page number.
  - setPageStart
```
public void setPageStart(short pageStart)
```
    Sets the starting page number.
    
    Parameters:
    
    pageStart - The starting page number.
  - getPaperSize
```
public short getPaperSize()
```
    Returns the paper size.
    
    Returns:
    
    The paper size.
  - setPaperSize
```
public void setPaperSize(short paperSize)
```
    Sets the paper size.
    
    Parameters:
    
    paperSize - The paper size.
  - getScale
```
public short getScale()
```
    Returns the scale.
    
    Returns:
    
    The scale.
  - setScale
```
public void setScale(short scale)
```
    Sets the scale.
    
    Parameters:
    
    scale - The scale.
  - isUsePage
```
public boolean isUsePage()
```
    Returns whether to "use page".
    
    Returns:
    
    Whether to "use page".
  - setUsePage
```
public void setUsePage(boolean usePage)
```
    Sets whether to "use page".
    
    Parameters:
    
    usePage - Whether to "use page".
  - isValidSettings
```
public boolean isValidSettings()
```
    Returns whether the settings are "valid".
    
    Returns:
    
    Whether the settings are "valid".
  - setValidSettings
```
public void setValidSettings(boolean validSettings)
```
    Sets whether the settings are "valid".
    
    Parameters:
    
    validSettings - Whether the settings are "valid".
  - getVResolution
```
public short getVResolution()
```
    Returns the "V resolution".
    
    Returns:
    
    The "V resolution".
  - setVResolution
```
public void setVResolution(short vResolution)
```
    Sets the "V resolution".
    
    Parameters:
    
    vResolution - The "V resolution".

Class MissingCloneSheetProperties

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

MissingCloneSheetProperties

MissingCloneSheetProperties

Method Detail

getRepeatingColumns

setRepeatingColumns

getRepeatingRows

setRepeatingRows

getCopies

setCopies

isDraft

setDraft

getFitHeight

setFitHeight

getFitWidth

setFitWidth

getHResolution

setHResolution

isLandscape

setLandscape

isLeftToRight

setLeftToRight

isNoColor

setNoColor

isNotes

setNotes

getPageStart

setPageStart

getPaperSize

setPaperSize

getScale

setScale

isUsePage

setUsePage

isValidSettings

setValidSettings

getVResolution

setVResolution