Overview  Package  Class  Tree  Deprecated   Index  Help 
 PREV   NEXT FRAMES    NO FRAMES    
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.
LEAP_YEAR_AGGREGATE_DAYS_TO_END_OF_PRECEDING_MONTH - Static variable in class org.jfree.workbook.date.SerialDate
The number of days in a leap year up to the end of the preceding month.
leapYearCount(int) - Static method in class org.jfree.workbook.date.SerialDate
Returns the number of leap years from 1900 to the specified year INCLUSIVE.
left - Variable in class org.jfree.workbook.Border
The left border.
leftPts - Variable in class org.jfree.workbook.Margins
Left margin.
leftUnits - Variable in class org.jfree.workbook.Margins
The left units.
LINE - Static variable in interface org.jfree.workbook.BorderConstants
Constant for Gnumeric border type LINE.

M

main(String[]) - Static method in class org.jfree.workbook.JWorkbook
Test program to demonstrate the JWorkbook.
manager - Variable in class org.jfree.workbook.Summary
Manager.
MARCH - Static variable in interface org.jfree.workbook.date.MonthConstants
Constant for March.
marginA - Variable in class org.jfree.workbook.RowAttributes
The left margin.
marginA - Variable in class org.jfree.workbook.ColumnAttributes
The left margin.
marginB - Variable in class org.jfree.workbook.RowAttributes
The right margin.
marginB - Variable in class org.jfree.workbook.ColumnAttributes
The right margin.
margins - Variable in class org.jfree.workbook.PrintInformation
Margins.
Margins - class org.jfree.workbook.Margins.
Printing margins for a worksheet.
Margins() - Constructor for class org.jfree.workbook.Margins
Default constructor.
MAX_COLUMNS - Static variable in class org.jfree.workbook.Worksheet
The maximum number of columns in a worksheet.
MAX_ROWS - Static variable in class org.jfree.workbook.Worksheet
The maximum number of rows in a worksheet.
maxColumn - Variable in class org.jfree.workbook.Worksheet
The index of the right-most column used in the worksheet.
MAXIMUM_YEAR_SUPPORTED - Static variable in class org.jfree.workbook.date.SerialDate
The highest year value supported by this date format.
maxRow - Variable in class org.jfree.workbook.Worksheet
The index of the bottom-most row used in the worksheet.
MAY - Static variable in interface org.jfree.workbook.date.MonthConstants
Constant for May.
MINIMUM_YEAR_SUPPORTED - Static variable in class org.jfree.workbook.date.SerialDate
The lowest year value supported by this date format.
modifyColumnAttributes(ColumnAttributes) - Method in interface org.jfree.workbook.ColumnAttributesModifier
Apply changes to the specified attributes record.
modifyColumnAttributes(ColumnAttributes) - Method in class org.jfree.workbook.ColumnWidthModifier
Change the width of the column attributes record.
modifyColumnAttributes(ColumnAttributesModifier, int, int) - Method in class org.jfree.workbook.ColumnAttributesManager
General method for modifying column attributes.
modifyHorizontalAlignment - Variable in class org.jfree.workbook.GeneralStyleModifier
Change the horizontal alignment (yes/no).
modifyRowAttributes(RowAttributes) - Method in class org.jfree.workbook.RowHeightModifier
Apply the height change to the specified attributes record.
modifyRowAttributes(RowAttributes) - Method in interface org.jfree.workbook.RowAttributesModifier
Apply changes to the specified attributes record.
modifyRowAttributes(RowAttributesModifier, int, int) - Method in class org.jfree.workbook.RowAttributesManager
General method for modifying row attributes.
modifyStyle(StyleModifier, int, int, int, int) - Method in class org.jfree.workbook.Styles
Apply the style modifier to the styles that cover the specified region.
modifyVerticalAlignment - Variable in class org.jfree.workbook.GeneralStyleModifier
Change the vertical alignment (yes/no).
modifyWrapText - Variable in class org.jfree.workbook.GeneralStyleModifier
Change the wrap text setting (yes/no).
MONDAY - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for Monday.
monochrome - Variable in class org.jfree.workbook.PrintInformation
Flag indicating whether the printing is monochrome.
monthCodeToQuarter(int) - Static method in class org.jfree.workbook.date.SerialDate
Returns the quarter for the specified month.
monthCodeToString(int) - Static method in class org.jfree.workbook.date.SerialDate
Returns a string representing the supplied month.
monthCodeToString(int, boolean) - Static method in class org.jfree.workbook.date.SerialDate
Returns a string representing the supplied month.
MonthConstants - interface org.jfree.workbook.date.MonthConstants.
Useful constants for months.

N

name - Variable in class org.jfree.workbook.Worksheet
The name of the worksheet.
name - Variable in class org.jfree.workbook.FontStyle
The font name.
name - Variable in class org.jfree.workbook.Name
The name.
name - Variable in class org.jfree.workbook.JWorkbook
The workbook name.
Name - class org.jfree.workbook.Name.
Represents a defined name in the workbook or a worksheet.
Name(String, String) - Constructor for class org.jfree.workbook.Name
Standard constructor.
names - Variable in class org.jfree.workbook.JWorkbook
Names defined in the workbook - not currently supported.
names - Variable in class org.jfree.workbook.NamesManager
Storage for the names.
namesManager - Variable in class org.jfree.workbook.Worksheet
Manager for names defined in the worksheet.
NamesManager - class org.jfree.workbook.NamesManager.
Maintains a list of names.
NamesManager() - Constructor for class org.jfree.workbook.NamesManager
Default constructor.
NEAREST - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for specifying a day of the week relative to a fixed date.
NONE - Static variable in interface org.jfree.workbook.BorderConstants
Constant for Gnumeric border type NONE.
NOVEMBER - Static variable in interface org.jfree.workbook.date.MonthConstants
Constant for November.

O

OCTOBER - Static variable in interface org.jfree.workbook.date.MonthConstants
Constant for October.
order - Variable in class org.jfree.workbook.PrintInformation
??
org.jfree.workbook - package org.jfree.workbook
The root package for the JWorkbook class library.
org.jfree.workbook.date - package org.jfree.workbook.date
Date classes copied from the JCommon class library.
org.jfree.workbook.io - package org.jfree.workbook.io
Input/output classes.
orientation - Variable in class org.jfree.workbook.PrintInformation
The paper orientation.
orientation - Variable in class org.jfree.workbook.Style
The orientation.

P

paper - Variable in class org.jfree.workbook.PrintInformation
The paper size.
PATTERN_COLOR - Static variable in interface org.jfree.workbook.ColorConstants
Constant representing the pattern color.
patternColor - Variable in class org.jfree.workbook.Style
The pattern color.
PRECEDING - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for specifying a day of the week relative to a fixed date.
printInfo - Variable in class org.jfree.workbook.Worksheet
Print setup.
PrintInformation - class org.jfree.workbook.PrintInformation.
Records print information for a workbook.
PrintInformation() - Constructor for class org.jfree.workbook.PrintInformation
Default constructor.
problemType - Variable in class org.jfree.workbook.Solver
The problem type.
putComment(int, int, String) - Method in class org.jfree.workbook.Worksheet
Puts a comment in a cell, overwriting any existing cell comments.
putDate(int, int, SerialDate) - Method in class org.jfree.workbook.Worksheet
Puts a date in a cell, overwriting any existing cell contents.
putFormula(int, int, String) - Method in class org.jfree.workbook.Worksheet
Puts a formula in a cell, overwriting any existing cell contents.
putLabel(int, int, String) - Method in class org.jfree.workbook.Worksheet
Puts a label in a cell, overwriting any existing cell contents.
putValue(int, int, double) - Method in class org.jfree.workbook.Worksheet
Puts a value in a cell, overwriting any existing cell contents.

R

red - Variable in class org.jfree.workbook.Color
Red component.
regions - Variable in class org.jfree.workbook.Styles
Storage for the style regions.
relativeToString(int) - Static method in class org.jfree.workbook.date.SerialDate
Returns a string representing the supplied 'relative'.
repeatLeft - Variable in class org.jfree.workbook.PrintInformation
??
repeatTop - Variable in class org.jfree.workbook.PrintInformation
??
reverseDiagonal - Variable in class org.jfree.workbook.Border
The reverse diagonal 'border'.
right - Variable in class org.jfree.workbook.Border
The right border.
rightPts - Variable in class org.jfree.workbook.Margins
Right margin.
rightUnits - Variable in class org.jfree.workbook.Margins
The right units.
row - Variable in class org.jfree.workbook.Cell
The row number (0 to Worksheet.MAX_ROWS-1).
row - Variable in class org.jfree.workbook.Comment
The cell row.
Row - class org.jfree.workbook.Row.
Represents a single row of cells in a worksheet.
Row(int) - Constructor for class org.jfree.workbook.Row
Constructs an empty row with the specified index.
RowAttributes - class org.jfree.workbook.RowAttributes.
Stores the attributes for a range of rows (or sometimes just one row).
RowAttributes(int, int) - Constructor for class org.jfree.workbook.RowAttributes
Standard constructor: uses default values.
RowAttributes(int, int, double) - Constructor for class org.jfree.workbook.RowAttributes
Standard constructor.
rowAttributesManager - Variable in class org.jfree.workbook.Worksheet
Row attributes (height, margins, hidden etc).
RowAttributesManager - class org.jfree.workbook.RowAttributesManager.
Records information about the rows in a worksheet, row height, visibility etc.
RowAttributesManager() - Constructor for class org.jfree.workbook.RowAttributesManager
Constructs a RowAttributesManager.
RowAttributesModifier - interface org.jfree.workbook.RowAttributesModifier.
Standard interface for modifying the row attributes.
rowHeaderVisible - Variable in class org.jfree.workbook.Worksheet
A flag indicating whether or not the row header is visible.
RowHeightModifier - class org.jfree.workbook.RowHeightModifier.
A class for modifying the row height in a row attributes record.
RowHeightModifier(double) - Constructor for class org.jfree.workbook.RowHeightModifier
Standard constructor.
rows - Variable in class org.jfree.workbook.Cells
A list of the rows of cells.

S

SATURDAY - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for Saturday.
saveWorkbook(JWorkbook, String) - Method in class org.jfree.workbook.io.XLWriter
Saves the workbook in an XL compatible file format.
saveWorkbook(String) - Method in class org.jfree.workbook.io.GnumericWriter
Saves the workbook in Gnumeric XML format.
SECOND_WEEK_IN_MONTH - Static variable in class org.jfree.workbook.date.SerialDate
A useful constant for referring to the second week in a month.
Selection - class org.jfree.workbook.Selection.
Stores information on a selection range in a worksheet.
Selection(int, int, int, int) - Constructor for class org.jfree.workbook.Selection
Standard constructor.
selections - Variable in class org.jfree.workbook.Worksheet
Ranges that are selected.
selections - Variable in class org.jfree.workbook.Selections
A list of all selections.
Selections - class org.jfree.workbook.Selections.
Stores information about all the selection ranges in a worksheet.
Selections() - Constructor for class org.jfree.workbook.Selections
Default constructor.
SEPTEMBER - Static variable in interface org.jfree.workbook.date.MonthConstants
Constant for September.
SERIAL_LOWER_BOUND - Static variable in class org.jfree.workbook.date.SerialDate
The serial number for 1 January 1900.
SERIAL_UPPER_BOUND - Static variable in class org.jfree.workbook.date.SerialDate
The serial number for 31 December 9999.
SerialDate - class org.jfree.workbook.date.SerialDate.
An abstract class that defines our requirements for manipulating dates, without tying down a particular implementation.
SerialDate() - Constructor for class org.jfree.workbook.date.SerialDate
 
setApplication(String) - Method in class org.jfree.workbook.Summary
Sets the application.
setAuthor(String) - Method in class org.jfree.workbook.Summary
Sets the author.
setAuthor(String) - Method in class org.jfree.workbook.JWorkbook
Sets the author attribute.
setCategory(String) - Method in class org.jfree.workbook.Summary
Sets the category for the workbook.
setColumnWidth(int, double) - Method in class org.jfree.workbook.Worksheet
Sets the width of one column.
setColumnWidth(int, int, double) - Method in class org.jfree.workbook.Worksheet
Sets the width of a range of columns.
setColumnWidth(int, int, double) - Method in class org.jfree.workbook.ColumnAttributesManager
Sets the width of a range of columns.
setComments(String) - Method in class org.jfree.workbook.Summary
Sets the comments for the workbook.
setCompany(String) - Method in class org.jfree.workbook.Summary
Sets the company.
setDefaultColumnWidth(double) - Method in class org.jfree.workbook.ColumnAttributesManager
Sets the default column width.
setDefaultRowHeight(double) - Method in class org.jfree.workbook.RowAttributesManager
Sets the default row height.
setDescription(String) - Method in class org.jfree.workbook.date.SpreadsheetDate
Sets the description for the date.
setDescription(String) - Method in class org.jfree.workbook.date.SerialDate
Sets the description for the date.
setHeight(double) - Method in class org.jfree.workbook.RowAttributes
Sets the row height.
setKeywords(String) - Method in class org.jfree.workbook.Summary
Sets the keywords for the workbook.
setManager(String) - Method in class org.jfree.workbook.Summary
Sets the manager.
setName(String) - Method in class org.jfree.workbook.Worksheet
Sets the name of the worksheet.
setName(String) - Method in class org.jfree.workbook.JWorkbook
Sets the name of the workbook.
setRowHeight(int, double) - Method in class org.jfree.workbook.Worksheet
Sets the height of one row.
setRowHeight(int, int, double) - Method in class org.jfree.workbook.RowAttributesManager
Sets the height of a range of rows.
setRowHeight(int, int, double) - Method in class org.jfree.workbook.Worksheet
Sets the height of a range of rows.
setStyle(Style) - Method in class org.jfree.workbook.StyleRegion
Sets the style for this region.
setStyle(Style, int, int, int, int) - Method in class org.jfree.workbook.Worksheet
Set the style for the specified range of the worksheet.
setTitle(String) - Method in class org.jfree.workbook.Summary
Sets the workbook title.
setWidth(double) - Method in class org.jfree.workbook.ColumnAttributes
Sets the column width.
setZoom(double) - Method in class org.jfree.workbook.Worksheet
Sets the zoom factor.
shade - Variable in class org.jfree.workbook.Style
The shade.
showHorizontalScrollbar - Variable in class org.jfree.workbook.JWorkbook
Visibility of the horizontal scroll bar.
showNotebookTabs - Variable in class org.jfree.workbook.JWorkbook
Visibility of the notebook tabs.
showVerticalScrollbar - Variable in class org.jfree.workbook.JWorkbook
Visibility of the vertical scroll bar.
size - Variable in class org.jfree.workbook.FontStyle
The size.
solver - Variable in class org.jfree.workbook.Worksheet
Settings for the solver utility.
Solver - class org.jfree.workbook.Solver.
Records solver settings for a worksheet.
Solver() - Constructor for class org.jfree.workbook.Solver
Default constructor.
SpreadsheetDate - class org.jfree.workbook.date.SpreadsheetDate.
Represents a date using an integer, in a similar fashion to the implementation in Microsoft Excel.
SpreadsheetDate(int) - Constructor for class org.jfree.workbook.date.SpreadsheetDate
Standard constructor - creates a new date object representing the specified day number (which should be in the range 2 to 2958465.
SpreadsheetDate(int, int, int) - Constructor for class org.jfree.workbook.date.SpreadsheetDate
Constructs a new spreadsheet date.
startColumn - Variable in class org.jfree.workbook.StyleRegion
The start column.
startColumn - Variable in class org.jfree.workbook.ColumnAttributes
The starting column number (0 to Worksheet.MAX_COLUMNS-1).
startColumn - Variable in class org.jfree.workbook.Selection
The start column for the selection.
startRow - Variable in class org.jfree.workbook.RowAttributes
The starting row number (0 to Worksheet.MAX_ROWS-1).
startRow - Variable in class org.jfree.workbook.StyleRegion
The start row.
startRow - Variable in class org.jfree.workbook.Selection
The start row for the selection.
strikethrough - Variable in class org.jfree.workbook.FontStyle
Strikethrough.
stringToMonthCode(String) - Static method in class org.jfree.workbook.date.SerialDate
Converts a string to a month code.
stringToWeekdayCode(String) - Static method in class org.jfree.workbook.date.SerialDate
Converts the supplied string to a day of the week.
style - Variable in class org.jfree.workbook.StyleRegion
The style.
Style - class org.jfree.workbook.Style.
Represents a style that (when incorporated within a StyleRegion object) applies to a range of cells in a worksheet.
Style() - Constructor for class org.jfree.workbook.Style
Constructs a new Style object with default values.
Style(FontStyle, Border, int, int, boolean, int, int, int, Color, Color, Color, String) - Constructor for class org.jfree.workbook.Style
Full constructor.
Style(FontStyle, int, int) - Constructor for class org.jfree.workbook.Style
Constructs a style with a specific font and alignment.
StyleConstants - interface org.jfree.workbook.StyleConstants.
Useful style constants.
StyleModifier - interface org.jfree.workbook.StyleModifier.
An interface for modifying styles.
StyleRegion - class org.jfree.workbook.StyleRegion.
Represents a region and its associated style.
StyleRegion(Style, int, int, int, int) - Constructor for class org.jfree.workbook.StyleRegion
Constructs a style region.
styles - Variable in class org.jfree.workbook.Worksheet
Styles that apply to ranges within the worksheet.
Styles - class org.jfree.workbook.Styles.
A collection of style regions.
Styles() - Constructor for class org.jfree.workbook.Styles
Constructs a new default styles collection.
summary - Variable in class org.jfree.workbook.JWorkbook
A summary of the workbook.
Summary - class org.jfree.workbook.Summary.
Records a summary of a workbook.
Summary() - Constructor for class org.jfree.workbook.Summary
Constructs a new default summary.
SUNDAY - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for Sunday.

T

targetColumn - Variable in class org.jfree.workbook.Solver
The target column.
targetRow - Variable in class org.jfree.workbook.Solver
The target row.
text - Variable in class org.jfree.workbook.Comment
The comment.
THICK_DASHED1 - Static variable in interface org.jfree.workbook.BorderConstants
Constant for Gnumeric border type THICK_DASHED1.
THICK_DASHED2 - Static variable in interface org.jfree.workbook.BorderConstants
Constant for Gnumeric border type THICK_DASHED2.
THICK_DASHED3 - Static variable in interface org.jfree.workbook.BorderConstants
Constant for Gnumeric border type THICK_DASHED3.
THICK_DASHED4 - Static variable in interface org.jfree.workbook.BorderConstants
Constant for Gnumeric border type THICK_DASHED4.
THICK_LINE - Static variable in interface org.jfree.workbook.BorderConstants
Constant for Gnumeric border type THICK_LINE.
THIRD_WEEK_IN_MONTH - Static variable in class org.jfree.workbook.date.SerialDate
A useful constant for referring to the third week in a month.
THURSDAY - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for Thrusday.
title - Variable in class org.jfree.workbook.Summary
The title.
titles - Variable in class org.jfree.workbook.PrintInformation
Titles?
toDate() - Method in class org.jfree.workbook.date.SpreadsheetDate
Returns a java.util.Date equivalent to this date.
toDate() - Method in class org.jfree.workbook.date.SerialDate
Returns a java.util.Date.
top - Variable in class org.jfree.workbook.Border
The top border.
topPts - Variable in class org.jfree.workbook.Margins
Top margin.
topUnits - Variable in class org.jfree.workbook.Margins
The top units.
toSerial() - Method in class org.jfree.workbook.date.SpreadsheetDate
Returns the serial number for the date, where 1 January 1900 = 2 (this corresponds, almost, to the numbering system used in Microsoft Excel for Windows and Lotus 1-2-3).
toSerial() - Method in class org.jfree.workbook.date.SerialDate
Returns the serial number for the date, where 1 January 1900 = 2 (this corresponds, almost, to the numbering system used in Microsoft Excel for Windows and Lotus 1-2-3).
toString() - Method in class org.jfree.workbook.Color
Returns the color as a string in the format required by Gnumeric.
toString() - Method in class org.jfree.workbook.date.SerialDate
Converts the date to a string.
TUESDAY - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for Tuesday.
type - Variable in class org.jfree.workbook.Cell
The type of data in the cell.

U

underline - Variable in class org.jfree.workbook.FontStyle
Underline.

V

value - Variable in class org.jfree.workbook.Name
The text that the name resolves to.
VALUE_TYPE - Static variable in interface org.jfree.workbook.CellConstants
Constant for value cell.
ValueCell - class org.jfree.workbook.ValueCell.
A cell that contains a value.
ValueCell(double, int, int) - Constructor for class org.jfree.workbook.ValueCell
Standard constructor.
valueFormat - Variable in class org.jfree.workbook.Cell
The value format (if required).
VERSION - Static variable in class org.jfree.workbook.JWorkbook
Version identification.
verticalAlignment - Variable in class org.jfree.workbook.Style
The vertical alignment.
verticalAlignment - Variable in class org.jfree.workbook.GeneralStyleModifier
The new vertical alignment, if required.
verticallyCentered - Variable in class org.jfree.workbook.PrintInformation
Flag indicating whether the worksheet is vertically centered on the page.

W

WEDNESDAY - Static variable in class org.jfree.workbook.date.SerialDate
Useful constant for Wednesday.
weekdayCodeToString(int) - Static method in class org.jfree.workbook.date.SerialDate
Returns a string representing the supplied day-of-the-week.
weekInMonthToString(int) - Static method in class org.jfree.workbook.date.SerialDate
Returns a string corresponding to the week-in-the-month code.
which - Variable in class org.jfree.workbook.ColorStyleModifier
Foreground, background or pattern color.
WHITE - Static variable in interface org.jfree.workbook.ColorConstants
Useful constant representing the standard color BLACK.
width - Variable in class org.jfree.workbook.ColumnAttributes
The column width in pts.
width - Variable in class org.jfree.workbook.ColumnWidthModifier
The new width.
workbook - Variable in class org.jfree.workbook.io.GnumericWriter
The workbook.
Worksheet - class org.jfree.workbook.Worksheet.
Represents one worksheet within a workbook.
Worksheet(String) - Constructor for class org.jfree.workbook.Worksheet
Standard constructor: creates a named empty worksheet.
worksheets - Variable in class org.jfree.workbook.JWorkbook
The worksheets contained in this workbook.
wrapText - Variable in class org.jfree.workbook.Style
Wrap text (true/false).
wrapText - Variable in class org.jfree.workbook.GeneralStyleModifier
The new wrap text setting, if required.
writeBorderStyle(Border, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a style border element to the stream.
writeCell(Cell, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Write the cell element.
writeCell2(Cell, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Write the cell element.
writeCellContent(Cell, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Write the cell contents.
writeCells(Cells, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes the cells to the specified stream in the format required by the Gnumeric XML file.
writeColInfo(ColumnAttributes, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes the columns element to the specified stream in the Gnumeric format.
writeColumns(ColumnAttributesManager, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes the columns element to the specified stream.
writeComment(Comment, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a comment element in the Gnumeric file format.
writeDateCell(Cell, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a date cell.
writeFontStyle(FontStyle, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a style font element to the stream.
writeMargins(Margins, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes the margins element to the stream.
writePrintInformation(PrintInformation, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a print information element to the stream.
writeRow(Row, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a row element to the stream.
writeRowInfo(RowAttributes, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes the rows element to the specified stream in the Gnumeric format.
writeRows(RowAttributesManager, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes the rows element to the specified stream.
writeSelection(Selection, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a selection element to the stream.
writeSelections(Selections, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a selections element to the stream.
writeSolver(Solver, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a solver element to the stream.
writeStyle(Style, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a style element to the stream.
writeStyleRegion(StyleRegion, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a style region element to the stream.
writeStyles(Styles, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a styles element to the stream.
writeWorksheet(Worksheet, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a worksheet element in the Gnumeric format to a stream.
writeWorksheetNames(NamesManager, PrintStream, String) - Method in class org.jfree.workbook.io.GnumericWriter
Writes a names element in the Gnumeric format.

X

XLWriter - class org.jfree.workbook.io.XLWriter.
This class takes a JWorkbook object and saves it to an XL compatible file format.
XLWriter() - Constructor for class org.jfree.workbook.io.XLWriter
Constructs an XLWriter.

Z

zoom - Variable in class org.jfree.workbook.Worksheet
The current zoom factor (in the range 0.05 to 5.00, that is 5% to 500%).
A B C D E F G H I J K L M N O P R S T U V W X Z
Overview  Package  Class  Tree  Deprecated   Index  Help 
 PREV   NEXT FRAMES    NO FRAMES