Overview
Package
Class
Tree
Deprecated
Index
Help
PREV NEXT
FRAMES
NO FRAMES
All Classes
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
R
S
T
U
V
W
X
Z
A
add(Cell)
- Method in class org.jfree.workbook.
Cells
Adds the specified cell to the collection of cells (if the cell already exists it is replaced).
add(Cell)
- Method in class org.jfree.workbook.
Row
Adds a cell to the row, replacing the existing cell if any.
add(String)
- Method in class org.jfree.workbook.
JWorkbook
Adds a worksheet with the specified name.
addCell(Cell)
- Method in class org.jfree.workbook.
Worksheet
Sets the value at the specified cell.
addDays(int, SerialDate)
- Static method in class org.jfree.workbook.date.
SerialDate
Creates a new date by adding the specified number of days to the base date.
addMonths(int, SerialDate)
- Static method in class org.jfree.workbook.date.
SerialDate
Creates a new date by adding the specified number of months to the base date.
addName(String, String)
- Method in class org.jfree.workbook.
Worksheet
Adds a name to the worksheet.
addName(String, String)
- Method in class org.jfree.workbook.
NamesManager
Adds a name to the list.
addStyleRegion(StyleRegion)
- Method in class org.jfree.workbook.
Styles
Adds the specified style region, restructuring the existing style regions to avoid any overlapping.
addStyleRegion(StyleRegion)
- Method in class org.jfree.workbook.
Worksheet
Adds the specified style region.
addYears(int, SerialDate)
- Static method in class org.jfree.workbook.date.
SerialDate
Creates a new date by adding the specified number of years to the base date.
AGGREGATE_DAYS_TO_END_OF_MONTH
- Static variable in class org.jfree.workbook.date.
SerialDate
The number of days in a (non-leap) year up to the end of each month.
AGGREGATE_DAYS_TO_END_OF_PRECEDING_MONTH
- Static variable in class org.jfree.workbook.date.
SerialDate
The number of days in a year up to the end of the preceding month.
ALIGN_BOTTOM
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for bottom vertical alignment.
ALIGN_CENTER
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for centered horizontal alignment.
ALIGN_CENTER_ACROSS_SELECTION
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for centered-across-selection horizontal alignment.
ALIGN_FILL
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for "fill" horizontal alignment.
ALIGN_GENERAL
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for "general" horizontal alignment.
ALIGN_JUSTIFY_HORIZONTAL
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for "justify" horizontal alignment.
ALIGN_JUSTIFY_VERTICAL
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for "justified" vertical alignment.
ALIGN_LEFT
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for left horizontal alignment.
ALIGN_MIDDLE
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for centered vertical alignment.
ALIGN_RIGHT
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for right horizontal alignment.
ALIGN_TOP
- Static variable in interface org.jfree.workbook.
StyleConstants
Constant for top vertical alignment.
application
- Variable in class org.jfree.workbook.
Summary
The application that generated the workbook.
applyBackgroundColor(Color, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the background color to the specified cell.
applyBackgroundColor(Color, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the background color to the specified region.
applyBackgroundColor(Style, Color)
- Static method in class org.jfree.workbook.
Style
Creates a new style based on the provided style, but replacing the background color as specified.
applyBorder(Border, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the foreground color to the specified cell.
applyBorder(Border, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the border to the specified region.
applyBorder(Style, Border)
- Static method in class org.jfree.workbook.
Style
Creates a new style based on the provided style, but replacing the border as specified.
applyFont(FontStyle, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the font to the specified cell.
applyFont(FontStyle, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the font to the specified region.
applyFont(Style, FontStyle)
- Static method in class org.jfree.workbook.
Style
Creates a new style based on the provided style, but replacing the font as specified.
applyForegroundColor(Color, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the foreground color to the specified cell.
applyForegroundColor(Color, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the foreground color to the specified region.
applyForegroundColor(Style, Color)
- Static method in class org.jfree.workbook.
Style
Creates a new style based on the provided style, but replacing the foreground color as specified.
applyHorizontalAlignment(int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a horizontal alignment setting to a cell.
applyHorizontalAlignment(int, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a horizontal alignment setting to a range of cells.
applyOutline(int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a thin outline border to a cell.
applyOutline(int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a border to a cell.
applyOutline(int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a thin outline border to a range of cells.
applyOutline(int, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a border around a range of cells.
applyPatternColor(Color, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the pattern color to the specified cell.
applyPatternColor(Color, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the pattern color to the specified region.
applyPatternColor(Style, Color)
- Static method in class org.jfree.workbook.
Style
Creates a new style based on the provided style, but replacing the pattern color as specified.
applyVerticalAlignment(int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a vertical alignment setting to a cell.
applyVerticalAlignment(int, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies a vertical alignment setting to a range of cells.
applyWrapText(boolean, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the "wrap-text" setting to the specified cell.
applyWrapText(boolean, int, int, int, int)
- Method in class org.jfree.workbook.
Worksheet
Applies the "wrap-text" setting to the specified region.
APRIL
- Static variable in interface org.jfree.workbook.date.
MonthConstants
Constant for April.
attributes
- Variable in class org.jfree.workbook.
RowAttributesManager
List of RowAttributes objects.
attributes
- Variable in class org.jfree.workbook.
ColumnAttributesManager
List of ColumnAttributes objects.
AUGUST
- Static variable in interface org.jfree.workbook.date.
MonthConstants
Constant for August.
author
- Variable in class org.jfree.workbook.
Summary
The author or creator of the workbook.
author
- Variable in class org.jfree.workbook.
Comment
The author.
B
BACKGROUND_COLOR
- Static variable in interface org.jfree.workbook.
ColorConstants
Constant representing the background color.
backgroundColor
- Variable in class org.jfree.workbook.
Style
The background color.
BLACK
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard color BLACK.
blue
- Variable in class org.jfree.workbook.
Color
Blue component.
bold
- Variable in class org.jfree.workbook.
FontStyle
Bold.
border
- Variable in class org.jfree.workbook.
Style
The border details.
border
- Variable in class org.jfree.workbook.
BorderStyleModifier
The new border.
Border
- class org.jfree.workbook.
Border
.
Represents the border settings for a style range.
Border(int, int, int, int, int, int)
- Constructor for class org.jfree.workbook.
Border
Standard constructor.
BorderConstants
- interface org.jfree.workbook.
BorderConstants
.
Constants representing border styles.
BorderStyleModifier
- class org.jfree.workbook.
BorderStyleModifier
.
A style modifier that changes the border for a style, but leaves all other settings unchanged.
BorderStyleModifier(Border)
- Constructor for class org.jfree.workbook.
BorderStyleModifier
Standard constructor.
bottom
- Variable in class org.jfree.workbook.
Border
The bottom border.
bottomPts
- Variable in class org.jfree.workbook.
Margins
Bottom margin.
bottomUnits
- Variable in class org.jfree.workbook.
Margins
The bottom units.
C
category
- Variable in class org.jfree.workbook.
Summary
Category.
Cell
- class org.jfree.workbook.
Cell
.
Represents one cell in a worksheet.
Cell(int, String, int, int)
- Constructor for class org.jfree.workbook.
Cell
Constructs a new cell.
CellConstants
- interface org.jfree.workbook.
CellConstants
.
Useful cell constants.
cellIndent
- Variable in class org.jfree.workbook.
Style
The indentation for the cells.
cellReference(int, int)
- Static method in class org.jfree.workbook.
Worksheet
Returns a cell reference using letters for the column (e.g.
cells
- Variable in class org.jfree.workbook.
Worksheet
The cells in the worksheet.
cells
- Variable in class org.jfree.workbook.
Row
The cells in the row.
Cells
- class org.jfree.workbook.
Cells
.
Represents the cells in a worksheet.
Cells()
- Constructor for class org.jfree.workbook.
Cells
Default constructor.
color
- Variable in class org.jfree.workbook.
ColorStyleModifier
The new color.
Color
- class org.jfree.workbook.
Color
.
Represents a color within a style.
Color(int, int, int)
- Constructor for class org.jfree.workbook.
Color
Constructs a Color with the specified red, green and blue components.
ColorConstants
- interface org.jfree.workbook.
ColorConstants
.
Useful constants for defining colors.
ColorStyleModifier
- class org.jfree.workbook.
ColorStyleModifier
.
A style modifier that changes the foreground, background or pattern color for a style, but leaves all other settings unchanged.
ColorStyleModifier(int, Color)
- Constructor for class org.jfree.workbook.
ColorStyleModifier
Standard constructor.
column
- Variable in class org.jfree.workbook.
Cell
The column number (0 to Worksheet.MAX_COLUMNS-1).
column
- Variable in class org.jfree.workbook.
Comment
The cell column.
ColumnAttributes
- class org.jfree.workbook.
ColumnAttributes
.
Stores the attributes for a range of columns (or sometimes just one column).
ColumnAttributes(int, int)
- Constructor for class org.jfree.workbook.
ColumnAttributes
Constructs a new ColumnAttributes object, using default values where necessary.
ColumnAttributes(int, int, double)
- Constructor for class org.jfree.workbook.
ColumnAttributes
Constructs a new ColumnAttributes object.
columnAttributesManager
- Variable in class org.jfree.workbook.
Worksheet
Column attributes (width, margins, hidden etc).
ColumnAttributesManager
- class org.jfree.workbook.
ColumnAttributesManager
.
Records information about the columns in a worksheet.
ColumnAttributesManager()
- Constructor for class org.jfree.workbook.
ColumnAttributesManager
Constructs a new ColumnAttributesManager.
ColumnAttributesModifier
- interface org.jfree.workbook.
ColumnAttributesModifier
.
Standard interface for a column attributes record modifier.
columnHeaderVisible
- Variable in class org.jfree.workbook.
Worksheet
A flag indicating whether or not the column header is visible.
ColumnWidthModifier
- class org.jfree.workbook.
ColumnWidthModifier
.
A class that modifies the column width of a column attributes record.
ColumnWidthModifier(double)
- Constructor for class org.jfree.workbook.
ColumnWidthModifier
Standard constructor.
Comment
- class org.jfree.workbook.
Comment
.
Represents a comment that can be attached to a cell.
Comment(int, int, String)
- Constructor for class org.jfree.workbook.
Comment
Standard constructor.
comments
- Variable in class org.jfree.workbook.
Summary
Comments.
comments
- Variable in class org.jfree.workbook.
Worksheet
Comments for cells in the worksheet.
company
- Variable in class org.jfree.workbook.
Summary
The company.
compare(SerialDate)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns the difference (in days) between this date and the specified 'other' date.
compare(SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Returns the difference (in days) between this date and the specified 'other' date.
compareTo(Object)
- Method in class org.jfree.workbook.
Cell
Implements the Comparable interface so that cells can easily be sorted.
compareTo(Object)
- Method in class org.jfree.workbook.
RowAttributes
Implements the Comparable interface.
compareTo(Object)
- Method in class org.jfree.workbook.
ColumnAttributes
Implements the Comparable interface.
compareTo(Object)
- Method in class org.jfree.workbook.
Row
Implements the Comparator interface so that the rows can easily be sorted into order.
compareTo(Object)
- Method in class org.jfree.workbook.
Comment
Implements the Comparable interface.
contains(int, int)
- Method in class org.jfree.workbook.
StyleRegion
Returns true if the region include the cell at the specified row and column.
content
- Variable in class org.jfree.workbook.
Cell
The cell contents.
createInstance(Date)
- Static method in class org.jfree.workbook.date.
SerialDate
Factory method that returns an instance of a subclass of SerialDate.
createInstance(int)
- Static method in class org.jfree.workbook.
Color
Returns one of the standard Excel or Gnumeric colors.
createInstance(int)
- Static method in class org.jfree.workbook.date.
SerialDate
Factory method that returns an instance of some concrete subclass of
SerialDate
.
createInstance(int, int, int)
- Static method in class org.jfree.workbook.date.
SerialDate
Factory method that returns an instance of some concrete subclass of
SerialDate
.
cursorColumn
- Variable in class org.jfree.workbook.
Selections
The column in which the cursor is located.
cursorRow
- Variable in class org.jfree.workbook.
Selections
The row in which the cursor is located.
D
DASHED1
- Static variable in interface org.jfree.workbook.
BorderConstants
Constant for Gnumeric border type DASHED1.
DASHED2
- Static variable in interface org.jfree.workbook.
BorderConstants
Constant for Gnumeric border type DASHED2.
DASHED3
- Static variable in interface org.jfree.workbook.
BorderConstants
Constant for Gnumeric border type DASHED3.
DASHED4
- Static variable in interface org.jfree.workbook.
BorderConstants
Constant for Gnumeric border type DASHED4.
DATE_FORMAT_SYMBOLS
- Static variable in class org.jfree.workbook.date.
SerialDate
Date format symbols.
DATE_TYPE
- Static variable in interface org.jfree.workbook.
CellConstants
Constant for date cell.
DateCell
- class org.jfree.workbook.
DateCell
.
A worksheet cell that contains a date.
DateCell(SerialDate, int, int)
- Constructor for class org.jfree.workbook.
DateCell
Standard constructor.
DECEMBER
- Static variable in interface org.jfree.workbook.date.
MonthConstants
Constant for December.
DEFAULT_COLUMN_WIDTH
- Static variable in class org.jfree.workbook.
Worksheet
The default width for columns.
DEFAULT_ROW_HEIGHT
- Static variable in class org.jfree.workbook.
Worksheet
The default height for rows.
defaultColumnWidth
- Variable in class org.jfree.workbook.
ColumnAttributesManager
The default column width.
defaultRowHeight
- Variable in class org.jfree.workbook.
RowAttributesManager
The default row height.
diagonal
- Variable in class org.jfree.workbook.
Border
The diagonal 'border'.
displayFormulae
- Variable in class org.jfree.workbook.
Worksheet
Display formulae rather than calculated values (true/false).
DOTTED
- Static variable in interface org.jfree.workbook.
BorderConstants
Constant for Gnumeric border type DOTTED.
DOUBLE
- Static variable in interface org.jfree.workbook.
BorderConstants
Constant for Gnumeric border type DOUBLE.
draft
- Variable in class org.jfree.workbook.
PrintInformation
Flag indicating whether the printing is draft quality.
E
endColumn
- Variable in class org.jfree.workbook.
StyleRegion
The end column.
endColumn
- Variable in class org.jfree.workbook.
ColumnAttributes
The ending column number (startColumn to Worksheet.MAX_COLUMNS-1).
endColumn
- Variable in class org.jfree.workbook.
Selection
The end column for the selection.
endRow
- Variable in class org.jfree.workbook.
RowAttributes
The ending row number (startRow to Worksheet.MAX_ROWS-1).
endRow
- Variable in class org.jfree.workbook.
StyleRegion
The end row.
endRow
- Variable in class org.jfree.workbook.
Selection
The end row for the selection.
equals(Object)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Tests the equality of this SpreadsheetDate with an arbitrary Object.
EXCEL_AQUA
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color AQUA.
EXCEL_BLACK
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color BLACK.
EXCEL_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color BLUE.
EXCEL_BLUE_GRAY
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color BLUE_GRAY.
EXCEL_BRIGHT_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color BRIGHT_GREEN.
EXCEL_BROWN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color BROWN.
EXCEL_DARK_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color DARK_BLUE.
EXCEL_DARK_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color DARK_GREEN.
EXCEL_DARK_RED
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color DARK_RED.
EXCEL_DARK_TEAL
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color DARK_TEAL.
EXCEL_DARK_YELLOW
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color DARK_YELLOW.
EXCEL_GOLD
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color GOLD.
EXCEL_GRAY_25PERCENT
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color GRAY_25PERCENT.
EXCEL_GRAY_40PERCENT
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color GRAY_40PERCENT.
EXCEL_GRAY_50PERCENT
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color GRAY_50PERCENT.
EXCEL_GRAY_80PERCENT
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color GRAY_80PERCENT.
EXCEL_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color GREEN.
EXCEL_INDIGO
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color INDIGO.
EXCEL_LAVENDER
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color LAVENDER.
EXCEL_LIGHT_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color LIGHT_BLUE.
EXCEL_LIGHT_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color LIGHT_GREEN.
EXCEL_LIGHT_ORANGE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color LIGHT_ORANGE.
EXCEL_LIGHT_TURQUOISE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color LIGHT_TURQUOISE.
EXCEL_LIGHT_YELLOW
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color LIGHT_YELLOW.
EXCEL_LIME
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color LIME.
EXCEL_OLIVE_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color OLIVE_GREEN.
EXCEL_ORANGE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color ORANGE.
EXCEL_PALE_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color PALE_BLUE.
EXCEL_PINK
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color PINK.
EXCEL_PLUM
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color PLUM.
EXCEL_RED
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color RED.
EXCEL_ROSE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color ROSE.
EXCEL_SEA_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color SEA_GREEN.
EXCEL_SKY_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color SKY_BLUE.
EXCEL_TAN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color TAN.
EXCEL_TEAL
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color TEAL.
EXCEL_TURQUOISE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color TURQUOISE.
EXCEL_VIOLET
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color VIOLET.
EXCEL_WHITE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color WHITE.
EXCEL_YELLOW
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Excel color YELLOW.
EXPRESSION_TYPE
- Static variable in interface org.jfree.workbook.
CellConstants
Constant for formula cell.
EXTRA_THICK_LINE
- Static variable in interface org.jfree.workbook.
BorderConstants
Constant for Gnumeric border type EXTRA_THICK_LINE.
F
FEBRUARY
- Static variable in interface org.jfree.workbook.date.
MonthConstants
Constant for February.
FIRST_WEEK_IN_MONTH
- Static variable in class org.jfree.workbook.date.
SerialDate
A useful constant for referring to the first week in a month.
FOLLOWING
- Static variable in class org.jfree.workbook.date.
SerialDate
Useful constant for specifying a day of the week relative to a fixed date.
font
- Variable in class org.jfree.workbook.
Style
The font details.
font
- Variable in class org.jfree.workbook.
FontStyleModifier
The new font.
FontStyle
- class org.jfree.workbook.
FontStyle
.
Represents a font within a style.
FontStyle(String)
- Constructor for class org.jfree.workbook.
FontStyle
Constructs a font (12pt) with the given name.
FontStyle(String, int)
- Constructor for class org.jfree.workbook.
FontStyle
Constructs a font with the given name and point size.
FontStyle(String, int, boolean, boolean, boolean, boolean)
- Constructor for class org.jfree.workbook.
FontStyle
Constructs a font with all attributes as specified.
FontStyleModifier
- class org.jfree.workbook.
FontStyleModifier
.
A style modifier that changes the font for a style, but leaves all other settings unchanged.
FontStyleModifier(FontStyle)
- Constructor for class org.jfree.workbook.
FontStyleModifier
Standard constructor.
footerLeft
- Variable in class org.jfree.workbook.
PrintInformation
The left footer.
footerMiddle
- Variable in class org.jfree.workbook.
PrintInformation
The middle footer.
footerPts
- Variable in class org.jfree.workbook.
Margins
Footer margin.
footerRight
- Variable in class org.jfree.workbook.
PrintInformation
The right footer.
footerUnits
- Variable in class org.jfree.workbook.
Margins
The footer units.
FOREGROUND_COLOR
- Static variable in interface org.jfree.workbook.
ColorConstants
Constant representing the foreground color.
foregroundColor
- Variable in class org.jfree.workbook.
Style
The foreground color.
format
- Variable in class org.jfree.workbook.
Style
The format.
FormulaCell
- class org.jfree.workbook.
FormulaCell
.
A cell that contains a formula.
FormulaCell(String, int, int)
- Constructor for class org.jfree.workbook.
FormulaCell
Standard constructor.
FOURTH_WEEK_IN_MONTH
- Static variable in class org.jfree.workbook.date.
SerialDate
A useful constant for referring to the fourth week in a month.
FRIDAY
- Static variable in class org.jfree.workbook.date.
SerialDate
Useful constant for Friday.
G
GeneralStyleModifier
- class org.jfree.workbook.
GeneralStyleModifier
.
A general style modifier that can change a variety of style settings.
GeneralStyleModifier(boolean, boolean)
- Constructor for class org.jfree.workbook.
GeneralStyleModifier
Standard constructor.
GeneralStyleModifier(boolean, int, boolean, int)
- Constructor for class org.jfree.workbook.
GeneralStyleModifier
Standard constructor.
geometryHeight
- Variable in class org.jfree.workbook.
JWorkbook
The height of the workbook when displayed in Gnumeric.
geometryWidth
- Variable in class org.jfree.workbook.
JWorkbook
The width of the workbook when displayed in Gnumeric.
get(int)
- Method in class org.jfree.workbook.
Row
Returns the cell at the specified column.
getApplication()
- Method in class org.jfree.workbook.
Summary
Returns the application.
getAttributesIterator()
- Method in class org.jfree.workbook.
RowAttributesManager
Returns an iterator that provides access to the row attributes.
getAttributesIterator()
- Method in class org.jfree.workbook.
ColumnAttributesManager
Returns an iterator that provides access to the attribute records.
getAuthor()
- Method in class org.jfree.workbook.
Summary
Returns the author.
getAuthor()
- Method in class org.jfree.workbook.
Comment
Returns the name of the comment author.
getBackgroundColor()
- Method in class org.jfree.workbook.
Style
Returns the background color.
getBlue()
- Method in class org.jfree.workbook.
Color
Returns the blue component of the color.
getBorder()
- Method in class org.jfree.workbook.
Style
Returns the border for this style.
getBottom()
- Method in class org.jfree.workbook.
Border
Returns the line type for the border at the bottom of a cell.
getBottomPts()
- Method in class org.jfree.workbook.
Margins
Returns the bottom margin.
getCategory()
- Method in class org.jfree.workbook.
Summary
Returns the category for the workbook.
getCellIndent()
- Method in class org.jfree.workbook.
Style
Returns the indentation.
getCells()
- Method in class org.jfree.workbook.
Worksheet
Returns the cells for the worksheet.
getCellsIterator()
- Method in class org.jfree.workbook.
Row
Returns an iterator that provides access to the cells in the row.
getColumn()
- Method in class org.jfree.workbook.
Cell
Returns the cell's column.
getColumn()
- Method in class org.jfree.workbook.
Comment
Returns the column of the cell that the comment applies to.
getColumnAttributesManager()
- Method in class org.jfree.workbook.
Worksheet
Returns a reference to the object managing the column attributes.
getComments()
- Method in class org.jfree.workbook.
Summary
Returns the comments for the workbook.
getComments()
- Method in class org.jfree.workbook.
Worksheet
Returns the comments for the worksheet.
getCompany()
- Method in class org.jfree.workbook.
Summary
Returns the company.
getContent()
- Method in class org.jfree.workbook.
Cell
Returns the cell's content.
getCursorColumn()
- Method in class org.jfree.workbook.
Selections
Returns the cursor column.
getCursorRow()
- Method in class org.jfree.workbook.
Selections
Returns the cursor row.
getDayOfMonth()
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns the day of the month.
getDayOfMonth()
- Method in class org.jfree.workbook.date.
SerialDate
Returns the day of the month.
getDayOfWeek()
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns a code representing the day of the week.
getDayOfWeek()
- Method in class org.jfree.workbook.date.
SerialDate
Returns the day of the week.
getDefaultColumnWidth()
- Method in class org.jfree.workbook.
ColumnAttributesManager
Returns the default column width.
getDefaultRowHeight()
- Method in class org.jfree.workbook.
RowAttributesManager
Returns the default row height.
getDescription()
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns the description that is attached to the date.
getDescription()
- Method in class org.jfree.workbook.date.
SerialDate
Returns a description of the date.
getDiagonal()
- Method in class org.jfree.workbook.
Border
Returns the line type for the border diagonally crossing a cell.
getDisplayFormulae()
- Method in class org.jfree.workbook.
Worksheet
Returns true if formulae rather than values are being displayed in the worksheet.
getEndColumn()
- Method in class org.jfree.workbook.
StyleRegion
Returns the end column of the region.
getEndColumn()
- Method in class org.jfree.workbook.
ColumnAttributes
Returns the end column.
getEndColumn()
- Method in class org.jfree.workbook.
Selection
Returns the selection's end column.
getEndOfCurrentMonth(SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Rolls the date forward to the last day of the month.
getEndRow()
- Method in class org.jfree.workbook.
RowAttributes
Returns the end row.
getEndRow()
- Method in class org.jfree.workbook.
StyleRegion
Returns the end row of the region.
getEndRow()
- Method in class org.jfree.workbook.
Selection
Returns the selection's end row.
getFollowingDayOfWeek(int)
- Method in class org.jfree.workbook.date.
SerialDate
Returns the earliest date that falls on the specified day-of-the-week and is AFTER this date.
getFollowingDayOfWeek(int, SerialDate)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns the earliest date that falls on the specified day-of-the-week and is AFTER the base date.
getFont()
- Method in class org.jfree.workbook.
Style
Returns the font for this style.
getFooterLeft()
- Method in class org.jfree.workbook.
PrintInformation
Returns the left footer string.
getFooterMiddle()
- Method in class org.jfree.workbook.
PrintInformation
Returns the middle footer string.
getFooterPts()
- Method in class org.jfree.workbook.
Margins
Returns the footer margin.
getFooterRight()
- Method in class org.jfree.workbook.
PrintInformation
Returns the right footer string.
getForegroundColor()
- Method in class org.jfree.workbook.
Style
Returns the foreground color.
getFormat()
- Method in class org.jfree.workbook.
Style
Returns the format string for the cell.
getGeometryHeight()
- Method in class org.jfree.workbook.
JWorkbook
Returns the display width for the workbook.
getGeometryWidth()
- Method in class org.jfree.workbook.
JWorkbook
Returns the display width for the workbook.
getGreen()
- Method in class org.jfree.workbook.
Color
Returns the green component of the color.
getHeaderLeft()
- Method in class org.jfree.workbook.
PrintInformation
Returns the left header string.
getHeaderMiddle()
- Method in class org.jfree.workbook.
PrintInformation
Returns the middle header string.
getHeaderPts()
- Method in class org.jfree.workbook.
Margins
Returns the header margin.
getHeaderRight()
- Method in class org.jfree.workbook.
PrintInformation
Returns the right header string.
getHeight()
- Method in class org.jfree.workbook.
RowAttributes
Returns the row height.
getHeight(int)
- Method in class org.jfree.workbook.
RowAttributesManager
Returns the height of a particular row.
getHideZeros()
- Method in class org.jfree.workbook.
Worksheet
Returns a flag indicating whether or not zero values are displayed.
getHorizontalAlignment()
- Method in class org.jfree.workbook.
Style
Returns the horizontal alignment for this style.
getIndex()
- Method in class org.jfree.workbook.
Row
Returns the index of the row.
getInputs()
- Method in class org.jfree.workbook.
Solver
Returns the inputs.
getIntersectCase(int, int, int, int)
- Method in class org.jfree.workbook.
StyleRegion
Returns an integer denoting one of the 17 cases of intersection.
getIntersectionStyleRegion(int, int, int, int, StyleModifier)
- Method in class org.jfree.workbook.
StyleRegion
Returns a StyleRegion representing the portion of this region that intersects with the specified region.
getIterator()
- Method in class org.jfree.workbook.
Selections
Returns an iterator that provides access to the selections.
getKeywords()
- Method in class org.jfree.workbook.
Summary
Returns the keywords for the workbook.
getLeft()
- Method in class org.jfree.workbook.
Border
Returns the line type for the border at the left of a cell.
getLeftPts()
- Method in class org.jfree.workbook.
Margins
Returns the left margin.
getManager()
- Method in class org.jfree.workbook.
Summary
Returns the manager.
getMarginA()
- Method in class org.jfree.workbook.
RowAttributes
Returns margin A.
getMarginA()
- Method in class org.jfree.workbook.
ColumnAttributes
Returns margin A.
getMarginB()
- Method in class org.jfree.workbook.
RowAttributes
Returns margin B.
getMarginB()
- Method in class org.jfree.workbook.
ColumnAttributes
Returns margin B.
getMargins()
- Method in class org.jfree.workbook.
PrintInformation
Returns the margins.
getMaxColumn()
- Method in class org.jfree.workbook.
Worksheet
Returns the index of the rightmost column in the sheet.
getMaxRow()
- Method in class org.jfree.workbook.
Worksheet
Returns the index of the bottommost row in the sheet.
getModifiedStyle(Style)
- Method in class org.jfree.workbook.
ColorStyleModifier
Returns a new style with the same settings as the style passed in, except with a different foreground, background or pattern color.
getModifiedStyle(Style)
- Method in class org.jfree.workbook.
BorderStyleModifier
Returns a new style with the same settings as the style passed in, except with a different border.
getModifiedStyle(Style)
- Method in class org.jfree.workbook.
FontStyleModifier
Returns a new style with the same settings as the style passed in, except with a different font.
getModifiedStyle(Style)
- Method in interface org.jfree.workbook.
StyleModifier
Returns a new style based on the supplied style, but modified in some way (depends on the implementation).
getModifiedStyle(Style)
- Method in class org.jfree.workbook.
GeneralStyleModifier
Returns a new style based on the supplied style, but modified in some way.
getMonth()
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns the month (January = 1, February = 2, March = 3).
getMonth()
- Method in class org.jfree.workbook.date.
SerialDate
Returns the month (January = 1, February = 2, March = 3).
getMonths()
- Static method in class org.jfree.workbook.date.
SerialDate
Returns an array of month names.
getMonths(boolean)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns an array of month names.
getName()
- Method in class org.jfree.workbook.
Worksheet
Returns the name of the worksheet.
getName()
- Method in class org.jfree.workbook.
FontStyle
Returns the font name.
getName()
- Method in class org.jfree.workbook.
Name
Returns the name.
getName()
- Method in class org.jfree.workbook.
JWorkbook
Returns the name of the workbook.
getNameCount()
- Method in class org.jfree.workbook.
NamesManager
Returns the number of names in the list.
getNamesIterator()
- Method in class org.jfree.workbook.
NamesManager
Returns an iterator that provides access to the names.
getNamesManager()
- Method in class org.jfree.workbook.
Worksheet
Returns a reference to the names manager.
getNearestDayOfWeek(int)
- Method in class org.jfree.workbook.date.
SerialDate
Returns the nearest date that falls on the specified day-of-the-week.
getNearestDayOfWeek(int, SerialDate)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns the date that falls on the specified day-of-the-week and is CLOSEST to the base date.
getNonIntersectionStyleRegionList(int, int, int, int)
- Method in class org.jfree.workbook.
StyleRegion
Returns a list of StyleRegions equivalent to the non-intersection with the specified range.
getNonIntersectionStyleRegionList(StyleRegion)
- Method in class org.jfree.workbook.
StyleRegion
Returns a list of style regions that cover the non-intersecting part of this region.
getOrder()
- Method in class org.jfree.workbook.
PrintInformation
Returns the order of page printing.
getOrientation()
- Method in class org.jfree.workbook.
PrintInformation
Returns the page orientation.
getOrientation()
- Method in class org.jfree.workbook.
Style
Returns the text orientation.
getPaperSize()
- Method in class org.jfree.workbook.
PrintInformation
Returns the paper size.
getPatternColor()
- Method in class org.jfree.workbook.
Style
Returns the pattern color.
getPreviousDayOfWeek(int)
- Method in class org.jfree.workbook.date.
SerialDate
Returns the latest date that falls on the specified day-of-the-week and is BEFORE this date.
getPreviousDayOfWeek(int, SerialDate)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns the latest date that falls on the specified day-of-the-week and is BEFORE the base date.
getPrintInformation()
- Method in class org.jfree.workbook.
Worksheet
Returns the print information for the sheet.
getProblemType()
- Method in class org.jfree.workbook.
Solver
Returns the problem type.
getRed()
- Method in class org.jfree.workbook.
Color
Returns the red component of the color.
getRepeatLeft()
- Method in class org.jfree.workbook.
PrintInformation
Returns ???
getRepeatTop()
- Method in class org.jfree.workbook.
PrintInformation
Returns ???.
getReverseDiagonal()
- Method in class org.jfree.workbook.
Border
Returns the line type for the border reverse-diagonally crossing a cell.
getRight()
- Method in class org.jfree.workbook.
Border
Returns the line type for the border at the right of a cell.
getRightPts()
- Method in class org.jfree.workbook.
Margins
Returns the right margin.
getRow()
- Method in class org.jfree.workbook.
Cell
Returns the cell's row.
getRow()
- Method in class org.jfree.workbook.
Comment
Returns the row of the cell that the comment applies to.
getRowAttributesManager()
- Method in class org.jfree.workbook.
Worksheet
Returns a reference to the object managing the row attributes.
getRowsIterator()
- Method in class org.jfree.workbook.
Cells
Returns an iterator that provides access to the rows.
getSelections()
- Method in class org.jfree.workbook.
Worksheet
Returns the selections for the sheet.
getSerialNumber()
- Method in class org.jfree.workbook.
Cell
Returns an integer that increases across columns and down rows.
getShade()
- Method in class org.jfree.workbook.
Style
Returns the shade.
getSize()
- Method in class org.jfree.workbook.
FontStyle
Returns the font size.
getSolver()
- Method in class org.jfree.workbook.
Worksheet
Returns the solver for the worksheet.
getSplitFromColumn(int)
- Method in class org.jfree.workbook.
ColumnAttributes
Returns a new ColumnAttributes object, based on this one but only from the specified column.
getSplitFromRow(int)
- Method in class org.jfree.workbook.
RowAttributes
Returns a new RowAttributes object, based on this one but only from the specified row.
getSplitToColumn(int)
- Method in class org.jfree.workbook.
ColumnAttributes
Returns a new ColumnAttributes object, based on this one but only up to the specified column.
getSplitToRow(int)
- Method in class org.jfree.workbook.
RowAttributes
Returns a new RowAttributes object, based on this one but only up to the specified row.
getStartColumn()
- Method in class org.jfree.workbook.
StyleRegion
Returns the start column of the region.
getStartColumn()
- Method in class org.jfree.workbook.
ColumnAttributes
Returns the start column.
getStartColumn()
- Method in class org.jfree.workbook.
Selection
Returns the selection's start column.
getStartRow()
- Method in class org.jfree.workbook.
RowAttributes
Returns the start row.
getStartRow()
- Method in class org.jfree.workbook.
StyleRegion
Returns the start row of the region.
getStartRow()
- Method in class org.jfree.workbook.
Selection
Returns the selection's start row.
getStyle()
- Method in class org.jfree.workbook.
StyleRegion
Returns the style for this region.
getStyle(int, int)
- Method in class org.jfree.workbook.
Styles
Returns the style that applies to the specified row and column.
getStyles()
- Method in class org.jfree.workbook.
Worksheet
Returns the styles information for the sheet.
getStylesIterator()
- Method in class org.jfree.workbook.
Styles
Returns an iterator that provides access to all the styles in the collection.
getSubset(int, int)
- Method in class org.jfree.workbook.
RowAttributes
Returns a new RowAttributes object, based on this one but only for the specified range of rows.
getSubset(int, int)
- Method in class org.jfree.workbook.
ColumnAttributes
Returns a new ColumnAttributes object, based on this one but only for the specified range of columns.
getSummary()
- Method in class org.jfree.workbook.
JWorkbook
Returns the summary (author, company etc.) for the workbook.
getTargetColumn()
- Method in class org.jfree.workbook.
Solver
Returns the target column.
getTargetRow()
- Method in class org.jfree.workbook.
Solver
Returns the target row.
getText()
- Method in class org.jfree.workbook.
Comment
Returns the comment text.
getTitle()
- Method in class org.jfree.workbook.
Summary
Returns the workbook title.
getTop()
- Method in class org.jfree.workbook.
Border
Returns the line type for the border at the top of a cell.
getTopPts()
- Method in class org.jfree.workbook.
Margins
Returns the top margin.
getType()
- Method in class org.jfree.workbook.
Cell
Returns the cell's type.
getValue()
- Method in class org.jfree.workbook.
Name
Returns the value.
getVerticalAlignment()
- Method in class org.jfree.workbook.
Style
Returns the vertical alignment for this style.
getWidth()
- Method in class org.jfree.workbook.
ColumnAttributes
Returns the column width.
getWorksheetsIterator()
- Method in class org.jfree.workbook.
JWorkbook
Returns an iterator that gives access to all the worksheets in the workbook.
getYYYY()
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns the year (assume a valid range of 1900 to 9999).
getYYYY()
- Method in class org.jfree.workbook.date.
SerialDate
Returns the year (assume a valid range of 1900 to 9999).
getZoom()
- Method in class org.jfree.workbook.
Worksheet
Returns the zoom factor.
GNUMERIC_BLACK
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color BLACK.
GNUMERIC_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color BLUE.
GNUMERIC_BRIGHT_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color BRIGHT_BLUE.
GNUMERIC_BRIGHT_ORANGE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color BRIGHT_ORANGE.
GNUMERIC_BROWN_GOLD
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color BROWN_GOLD.
GNUMERIC_CYAN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color CYAN.
GNUMERIC_DARK_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DARK_BLUE.
GNUMERIC_DARK_GRAY
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DARK_GRAY.
GNUMERIC_DARK_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DARK_GREEN.
GNUMERIC_DARK_GREEN_2
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DARK_GREEN_2.
GNUMERIC_DARK_RED
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DARK_RED.
GNUMERIC_DULL_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DULL_BLUE.
GNUMERIC_DULL_BLUE_2
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DULL_BLUE_2.
GNUMERIC_DULL_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DULL_GREEN.
GNUMERIC_DULL_PURPLE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color DULL_PURPLE.
GNUMERIC_GOLD
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color GOLD.
GNUMERIC_GRAY
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color GRAY.
GNUMERIC_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color GREEN.
GNUMERIC_LIGHT_BLUE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_BLUE.
GNUMERIC_LIGHT_BROWN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_BROWN.
GNUMERIC_LIGHT_CYAN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_CYAN.
GNUMERIC_LIGHT_GRAY
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_GRAY.
GNUMERIC_LIGHT_GREEN
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_GREEN.
GNUMERIC_LIGHT_ORANGE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_ORANGE.
GNUMERIC_LIGHT_PURPLE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_PURPLE.
GNUMERIC_LIGHT_YELLOW
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIGHT_YELLOW.
GNUMERIC_LIME
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color LIME.
GNUMERIC_MAGENTA
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color MAGENTA.
GNUMERIC_NAVY
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color NAVY.
GNUMERIC_ORANGE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color ORANGE.
GNUMERIC_PINK
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color PINK.
GNUMERIC_PURPLE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color PURPLE.
GNUMERIC_PURPLE_2
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color PURPLE_2.
GNUMERIC_RED
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color RED.
GNUMERIC_RED_ORANGE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color RED_ORANGE.
GNUMERIC_RED_PURPLE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color RED_PURPLE.
GNUMERIC_SKY_BLUE_2
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color SKY_BLUE_2.
GNUMERIC_VERY_DARK_GRAY
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color VERY_DARK_GRAY.
GNUMERIC_WHITE
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color WHITE.
GNUMERIC_YELLOW
- Static variable in interface org.jfree.workbook.
ColorConstants
Useful constant representing the standard Gnumeric color YELLOW.
GnumericWriter
- class org.jfree.workbook.io.
GnumericWriter
.
A class that knows how to write a JWorkbook object to the Gnumeric XML file format.
GnumericWriter(JWorkbook)
- Constructor for class org.jfree.workbook.io.
GnumericWriter
Creates a new writer for the specified workbook.
green
- Variable in class org.jfree.workbook.
Color
Green component.
gridVisible
- Variable in class org.jfree.workbook.
PrintInformation
Flag indicating whether the grid is visible.
gridVisible
- Variable in class org.jfree.workbook.
Worksheet
A flag indicating whether or not the grid is visible.
H
hardSize
- Variable in class org.jfree.workbook.
RowAttributes
Not sure what this is (Gnumeric uses it for something).
hardSize
- Variable in class org.jfree.workbook.
ColumnAttributes
Not sure what this is (Gnumeric uses it for something).
headerLeft
- Variable in class org.jfree.workbook.
PrintInformation
The left header.
headerMiddle
- Variable in class org.jfree.workbook.
PrintInformation
The middle header.
headerPts
- Variable in class org.jfree.workbook.
Margins
Header margin.
headerRight
- Variable in class org.jfree.workbook.
PrintInformation
The right header.
headerUnits
- Variable in class org.jfree.workbook.
Margins
The header units.
height
- Variable in class org.jfree.workbook.
RowAttributes
The row height.
height
- Variable in class org.jfree.workbook.
RowHeightModifier
The new height.
hidden
- Variable in class org.jfree.workbook.
RowAttributes
Flag that indicates whether this row is hidden.
hidden
- Variable in class org.jfree.workbook.
ColumnAttributes
Flag that indicates whether this column is hidden.
hideZeros
- Variable in class org.jfree.workbook.
Worksheet
Hide zeros (true/false).
horizontalAlignment
- Variable in class org.jfree.workbook.
Style
The horizontal alignment.
horizontalAlignment
- Variable in class org.jfree.workbook.
GeneralStyleModifier
The new horizontal alignment, if required.
horizontallyCentered
- Variable in class org.jfree.workbook.
PrintInformation
Flag indicating whether the worksheet is horizontally centered on the page.
I
INCLUDE_BOTH
- Static variable in class org.jfree.workbook.date.
SerialDate
Useful range constant.
INCLUDE_FIRST
- Static variable in class org.jfree.workbook.date.
SerialDate
Useful range constant.
INCLUDE_NONE
- Static variable in class org.jfree.workbook.date.
SerialDate
Useful range constant.
INCLUDE_SECOND
- Static variable in class org.jfree.workbook.date.
SerialDate
Useful range constant.
includesRow(int)
- Method in class org.jfree.workbook.
RowAttributes
Returns true if this attributes record applies to the specified row.
index
- Variable in class org.jfree.workbook.
Row
The row index (0 to Worksheet.MAX_ROWS).
inputs
- Variable in class org.jfree.workbook.
Solver
Inputs.
intersects(int, int, int, int)
- Method in class org.jfree.workbook.
StyleRegion
Returns true if the specified range intersects with this region, and false otherwise.
intersects(StyleRegion)
- Method in class org.jfree.workbook.
StyleRegion
Returns true if the specified region intersects with this region, and false otherwise.
isAfter(SerialDate)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isAfter(SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isBefore(SerialDate)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns true if this SerialDate represents an earlier date compared to the specified SerialDate.
isBefore(SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Returns true if this SerialDate represents an earlier date compared to the specified SerialDate.
isBold()
- Method in class org.jfree.workbook.
FontStyle
Returns a flag indicating whether or not the bold attribute is set.
isColumnHeaderVisible()
- Method in class org.jfree.workbook.
Worksheet
Returns a flag indicating whether or not the column header is visible.
isDraft()
- Method in class org.jfree.workbook.
PrintInformation
Returns a flag indicating the print quality.
isGridVisible()
- Method in class org.jfree.workbook.
PrintInformation
Returns a flag indicating whether or not the grid is visible.
isGridVisible()
- Method in class org.jfree.workbook.
Worksheet
Returns a flag indicating whether or not the grid is visible.
isHardSize()
- Method in class org.jfree.workbook.
RowAttributes
Returns a flag indicating ???.
isHardSize()
- Method in class org.jfree.workbook.
ColumnAttributes
Returns a flag indicating ???.
isHidden()
- Method in class org.jfree.workbook.
RowAttributes
Returns a flag indicating whether or not the row is hidden.
isHidden()
- Method in class org.jfree.workbook.
ColumnAttributes
Returns a flag indicating whether or not the column is hidden.
isHorizontallyCentered()
- Method in class org.jfree.workbook.
PrintInformation
Returns a flag indicating whether or not the content is horizontally centered on the page.
isHorizontalScrollBarVisible()
- Method in class org.jfree.workbook.
JWorkbook
Returns the visibility of the horizontal scroll bar.
isInRange(SerialDate, SerialDate)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns true if this SerialDate is within the specified range (INCLUSIVE).
isInRange(SerialDate, SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Returns true if this SerialDate is within the specified range (INCLUSIVE).
isInRange(SerialDate, SerialDate, int)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns true if this SerialDate is within the specified range (caller specifies whether or not the end-points are included).
isInRange(SerialDate, SerialDate, int)
- Method in class org.jfree.workbook.date.
SerialDate
Returns true if this SerialDate is within the specified range (caller specifies whether or not the end-points are included).
isItalic()
- Method in class org.jfree.workbook.
FontStyle
Returns a flag indicating whether or not the italic attribute is set.
isLeapYear(int)
- Static method in class org.jfree.workbook.date.
SerialDate
Determines whether or not the specified year is a leap year.
isMonochrome()
- Method in class org.jfree.workbook.
PrintInformation
Returns a flag indicating whether or not the output is monochrome.
isNotebookTabsVisible()
- Method in class org.jfree.workbook.
JWorkbook
Returns the visibility of the notebook tabs.
isOn(SerialDate)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isOn(SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isOnOrAfter(SerialDate)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isOnOrAfter(SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isOnOrBefore(SerialDate)
- Method in class org.jfree.workbook.date.
SpreadsheetDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isOnOrBefore(SerialDate)
- Method in class org.jfree.workbook.date.
SerialDate
Returns true if this SerialDate represents the same date as the specified SerialDate.
isRowHeaderVisible()
- Method in class org.jfree.workbook.
Worksheet
Returns a flag indicating whether or not the row header is visible.
isStrikethrough()
- Method in class org.jfree.workbook.
FontStyle
Returns a flag indicating whether or not the strikethrough attribute is set.
isTitlesVisible()
- Method in class org.jfree.workbook.
PrintInformation
Returns a flag indicating whether or not the titles are visible.
isUnderline()
- Method in class org.jfree.workbook.
FontStyle
Returns a flag indicating whether or not the underline attribute is set.
isValidMonthCode(int)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns true if the supplied integer code represents a valid month.
isValidWeekdayCode(int)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns true if the supplied integer code represents a valid day-of-the-week, and false otherwise.
isValidWeekInMonthCode(int)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns true if the supplied integer code represents a valid week-in-the-month, and false otherwise.
isVerticallyCentered()
- Method in class org.jfree.workbook.
PrintInformation
Returns a flag indicating whether or not the content is vertically centered on the page.
isVerticalScrollBarVisible()
- Method in class org.jfree.workbook.
JWorkbook
Returns the visibility of the vertical scroll bar.
isWrapText()
- Method in class org.jfree.workbook.
Style
Returns a flag indicating whether or not the text is wrapped.
italic
- Variable in class org.jfree.workbook.
FontStyle
Italic.
J
JANUARY
- Static variable in interface org.jfree.workbook.date.
MonthConstants
Constant for January.
JULY
- Static variable in interface org.jfree.workbook.date.
MonthConstants
Constant for July.
JUNE
- Static variable in interface org.jfree.workbook.date.
MonthConstants
Constant for June.
JWorkbook
- class org.jfree.workbook.
JWorkbook
.
Represents a workbook so that it can be exported to (for now) the Gnumeric XML file format.
JWorkbook()
- Constructor for class org.jfree.workbook.
JWorkbook
Default constructor: creates a new empty workbook.
JWorkbook(String, int)
- Constructor for class org.jfree.workbook.
JWorkbook
Standard constructor.
K
keywords
- Variable in class org.jfree.workbook.
Summary
Related keywords.
L
LABEL_TYPE
- Static variable in interface org.jfree.workbook.
CellConstants
Constant for label cell.
LabelCell
- class org.jfree.workbook.
LabelCell
.
A cell that contains a label.
LabelCell(String, int, int)
- Constructor for class org.jfree.workbook.
LabelCell
Standard constructor.
LAST_DAY_OF_MONTH
- Static variable in class org.jfree.workbook.date.
SerialDate
The number of days in each month in non leap years.
LAST_WEEK_IN_MONTH
- Static variable in class org.jfree.workbook.date.
SerialDate
A useful constant for referring to the last week in a month.
lastDayOfMonth(int, int)
- Static method in class org.jfree.workbook.date.
SerialDate
Returns the number of the last day of the month, taking into account leap years.
LEAP_YEAR_AGGREGATE_DAYS_TO_END_OF_MONTH
- Static variable in class org.jfree.workbook.date.
SerialDate
The number of days in a leap year up to the end of each month.