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
Z
A
add(Cell)
- Method in class com.jrefinery.workbook.
Cells
Adds the specified cell to the collection of cells (if the cell already exists it is replaced).
add(Cell)
- Method in class com.jrefinery.workbook.
Row
Adds a cell to the row, replacing the existing cell if any.
add(String)
- Method in class com.jrefinery.workbook.
JWorkbook
Adds a worksheet with the specified name.
addCell(Cell)
- Method in class com.jrefinery.workbook.
Worksheet
Sets the value at the specified cell.
addName(String, String)
- Method in class com.jrefinery.workbook.
Worksheet
Adds a name to the worksheet.
addName(String, String)
- Method in class com.jrefinery.workbook.
NamesManager
Adds a name to the list.
addStyleRegion(StyleRegion)
- Method in class com.jrefinery.workbook.
Worksheet
Adds the specified style region.
addStyleRegion(StyleRegion)
- Method in class com.jrefinery.workbook.
Styles
Adds the specified style region, restructuring the existing style regions to avoid any overlapping.
application
- Variable in class com.jrefinery.workbook.
Summary
The application that generated the workbook.
applyBackgroundColor(StyleColor, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the background color to the specified cell.
applyBackgroundColor(StyleColor, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the background color to the specified region.
applyBackgroundColor(Style, StyleColor)
- Static method in class com.jrefinery.workbook.
Style
Creates a new style based on the provided style, but replacing the background color as specified.
applyBorder(StyleBorder, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the foreground color to the specified cell.
applyBorder(StyleBorder, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the border to the specified region.
applyBorder(Style, StyleBorder)
- Static method in class com.jrefinery.workbook.
Style
Creates a new style based on the provided style, but replacing the border as specified.
applyFont(StyleFont, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the font to the specified cell.
applyFont(StyleFont, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the font to the specified region.
applyFont(Style, StyleFont)
- Static method in class com.jrefinery.workbook.
Style
Creates a new style based on the provided style, but replacing the font as specified.
applyForegroundColor(StyleColor, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the foreground color to the specified cell.
applyForegroundColor(StyleColor, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the foreground color to the specified region.
applyForegroundColor(Style, StyleColor)
- Static method in class com.jrefinery.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 com.jrefinery.workbook.
Worksheet
Applies a horizontal alignment setting to a cell.
applyHorizontalAlignment(int, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies a horizontal alignment setting to a range of cells.
applyOutline(int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies a thin outline border to a cell.
applyOutline(int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies a border to a cell.
applyOutline(int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies a thin outline border to a range of cells.
applyOutline(int, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies a border around a range of cells.
applyPatternColor(StyleColor, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the pattern color to the specified cell.
applyPatternColor(StyleColor, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the pattern color to the specified region.
applyPatternColor(Style, StyleColor)
- Static method in class com.jrefinery.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 com.jrefinery.workbook.
Worksheet
Applies a vertical alignment setting to a cell.
applyVerticalAlignment(int, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies a vertical alignment setting to a range of cells.
applyWrapText(boolean, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the "wrap-text" setting to the specified cell.
applyWrapText(boolean, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Applies the "wrap-text" setting to the specified region.
attributes
- Variable in class com.jrefinery.workbook.
ColumnAttributesManager
List of ColumnAttributes objects.
attributes
- Variable in class com.jrefinery.workbook.
RowAttributesManager
List of RowAttributes objects.
author
- Variable in class com.jrefinery.workbook.
Summary
The author or creator of the workbook.
author
- Variable in class com.jrefinery.workbook.
Comment
The author.
B
BACKGROUND_COLOR
- Static variable in class com.jrefinery.workbook.
StyleColor
Constant representing the background color.
backgroundColor
- Variable in class com.jrefinery.workbook.
Style
The background color.
blue
- Variable in class com.jrefinery.workbook.
StyleColor
Blue component.
bold
- Variable in class com.jrefinery.workbook.
StyleFont
Bold.
border
- Variable in class com.jrefinery.workbook.
Style
The border details.
border
- Variable in class com.jrefinery.workbook.
StyleBorderModifier
The new border.
bottom
- Variable in class com.jrefinery.workbook.
StyleBorder
The bottom border.
BOTTOM
- Static variable in class com.jrefinery.workbook.
Style
Constant for bottom vertical alignment.
bottom_pts
- Variable in class com.jrefinery.workbook.
Margins
Bottom margin.
bottom_units
- Variable in class com.jrefinery.workbook.
Margins
C
category
- Variable in class com.jrefinery.workbook.
Summary
Category.
Cell
- class com.jrefinery.workbook.
Cell
.
Represents one cell in a worksheet.
Cell(int, int, int, String)
- Constructor for class com.jrefinery.workbook.
Cell
Standard constructor.
cellIndent
- Variable in class com.jrefinery.workbook.
Style
The indentation for the cells.
cellReference(int, int)
- Static method in class com.jrefinery.workbook.
Worksheet
Returns a cell reference using letters for the column (e.g.
cells
- Variable in class com.jrefinery.workbook.
Worksheet
The cells in the worksheet.
cells
- Variable in class com.jrefinery.workbook.
Row
The cells in the row.
Cells
- class com.jrefinery.workbook.
Cells
.
Represents the cells in a worksheet.
Cells()
- Constructor for class com.jrefinery.workbook.
Cells
Default constructor.
CENTER_ACROSS_SELECTION
- Static variable in class com.jrefinery.workbook.
Style
Constant for centered-across-selection horizontal alignment.
color
- Variable in class com.jrefinery.workbook.
StyleColorModifier
The new color.
column
- Variable in class com.jrefinery.workbook.
Cell
The column number (0 to Worksheet.MAX_COLUMNS-1).
column
- Variable in class com.jrefinery.workbook.
Comment
The cell column.
ColumnAttributes
- class com.jrefinery.workbook.
ColumnAttributes
.
Stores the attributes for a range of columns (or sometimes just one column).
ColumnAttributes(int, int)
- Constructor for class com.jrefinery.workbook.
ColumnAttributes
Standard constructor: uses default values.
ColumnAttributes(int, int, double)
- Constructor for class com.jrefinery.workbook.
ColumnAttributes
Standard constructor.
columnAttributesManager
- Variable in class com.jrefinery.workbook.
Worksheet
Column attributes (width, margins, hidden etc).
ColumnAttributesManager
- class com.jrefinery.workbook.
ColumnAttributesManager
.
Records information about the columns in a worksheet.
ColumnAttributesManager()
- Constructor for class com.jrefinery.workbook.
ColumnAttributesManager
Default constructor.
ColumnAttributesModifier
- interface com.jrefinery.workbook.
ColumnAttributesModifier
.
Standard interface for a column attributes record modifier.
ColumnWidthModifier
- class com.jrefinery.workbook.
ColumnWidthModifier
.
A class that modifies the column width of a column attributes record.
ColumnWidthModifier(double)
- Constructor for class com.jrefinery.workbook.
ColumnWidthModifier
Standard constructor.
com.jrefinery.workbook
- package com.jrefinery.workbook
Create spreadsheet files from Java.
comment
- Variable in class com.jrefinery.workbook.
Comment
The comment.
Comment
- class com.jrefinery.workbook.
Comment
.
Represents a comment that can be attached to a cell.
Comment(int, int, String)
- Constructor for class com.jrefinery.workbook.
Comment
Standard constructor.
comments
- Variable in class com.jrefinery.workbook.
Summary
Comments.
comments
- Variable in class com.jrefinery.workbook.
Worksheet
Comments for cells in the worksheet.
company
- Variable in class com.jrefinery.workbook.
Summary
The company.
compareTo(Object)
- Method in class com.jrefinery.workbook.
Cell
Implements the Comparable interface so that cells can easily be sorted.
compareTo(Object)
- Method in class com.jrefinery.workbook.
ColumnAttributes
Implements the Comparable interface.
compareTo(Object)
- Method in class com.jrefinery.workbook.
RowAttributes
Implements the Comparable interface.
compareTo(Object)
- Method in class com.jrefinery.workbook.
Comment
Implements the Comparable interface.
compareTo(Object)
- Method in class com.jrefinery.workbook.
Row
Implements the Comparator interface so that the rows can easily be sorted into order.
content
- Variable in class com.jrefinery.workbook.
Cell
The cell contents.
createInstance(int)
- Static method in class com.jrefinery.workbook.
StyleColor
Returns one of the standard Excel or Gnumeric colors.
cursorColumn
- Variable in class com.jrefinery.workbook.
Selections
The column in which the cursor is located.
cursorRow
- Variable in class com.jrefinery.workbook.
Selections
The row in which the cursor is located.
D
DASHED1
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type DASHED1.
DASHED2
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type DASHED2.
DASHED3
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type DASHED3.
DASHED4
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type DASHED4.
DATE
- Static variable in class com.jrefinery.workbook.
Cell
Constant for date cell.
DateCell
- class com.jrefinery.workbook.
DateCell
.
A worksheet cell that contains a date.
DateCell(int, int, SerialDate)
- Constructor for class com.jrefinery.workbook.
DateCell
Standard constructor.
DEFAULT_COLUMN_WIDTH
- Static variable in class com.jrefinery.workbook.
Worksheet
The default width for columns.
DEFAULT_ROW_HEIGHT
- Static variable in class com.jrefinery.workbook.
Worksheet
The default height for rows.
defaultColumnWidth
- Variable in class com.jrefinery.workbook.
ColumnAttributesManager
The default column width.
defaultRowHeight
- Variable in class com.jrefinery.workbook.
RowAttributesManager
The default row height.
diagonal
- Variable in class com.jrefinery.workbook.
StyleBorder
The diagonal 'border'.
displayFormulae
- Variable in class com.jrefinery.workbook.
Worksheet
Display formulae rather than calculated values (true/false).
DOTTED
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type DOTTED.
DOUBLE
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type DOUBLE.
draft
- Variable in class com.jrefinery.workbook.
PrintInformation
Flag indicating whether the printing is draft quality.
E
endColumn
- Variable in class com.jrefinery.workbook.
ColumnAttributes
The ending column number (startColumn to Worksheet.MAX_COLUMNS-1).
endColumn
- Variable in class com.jrefinery.workbook.
Selection
The end column for the selection.
endColumn
- Variable in class com.jrefinery.workbook.
StyleRegion
The end column.
endRow
- Variable in class com.jrefinery.workbook.
RowAttributes
The ending row number (startRow to Worksheet.MAX_ROWS-1).
endRow
- Variable in class com.jrefinery.workbook.
Selection
The end row for the selection.
endRow
- Variable in class com.jrefinery.workbook.
StyleRegion
The end row.
EXCEL_AQUA
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color AQUA.
EXCEL_BLACK
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color BLACK.
EXCEL_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color BLUE.
EXCEL_BLUE_GRAY
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color BLUE_GRAY.
EXCEL_BRIGHT_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color BRIGHT_GREEN.
EXCEL_BROWN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color BROWN.
EXCEL_DARK_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color DARK_BLUE.
EXCEL_DARK_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color DARK_GREEN.
EXCEL_DARK_RED
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color DARK_RED.
EXCEL_DARK_TEAL
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color DARK_TEAL.
EXCEL_DARK_YELLOW
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color DARK_YELLOW.
EXCEL_GOLD
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color GOLD.
EXCEL_GRAY_25PERCENT
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color GRAY_25PERCENT.
EXCEL_GRAY_40PERCENT
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color GRAY_40PERCENT.
EXCEL_GRAY_50PERCENT
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color GRAY_50PERCENT.
EXCEL_GRAY_80PERCENT
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color GRAY_80PERCENT.
EXCEL_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color GREEN.
EXCEL_INDIGO
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color INDIGO.
EXCEL_LAVENDER
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color LAVENDER.
EXCEL_LIGHT_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color LIGHT_BLUE.
EXCEL_LIGHT_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color LIGHT_GREEN.
EXCEL_LIGHT_ORANGE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color LIGHT_ORANGE.
EXCEL_LIGHT_TURQUOISE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color LIGHT_TURQUOISE.
EXCEL_LIGHT_YELLOW
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color LIGHT_YELLOW.
EXCEL_LIME
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color LIME.
EXCEL_OLIVE_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color OLIVE_GREEN.
EXCEL_ORANGE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color ORANGE.
EXCEL_PALE_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color PALE_BLUE.
EXCEL_PINK
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color PINK.
EXCEL_PLUM
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color PLUM.
EXCEL_RED
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color RED.
EXCEL_ROSE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color ROSE.
EXCEL_SEA_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color SEA_GREEN.
EXCEL_SKY_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color SKY_BLUE.
EXCEL_TAN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color TAN.
EXCEL_TEAL
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color TEAL.
EXCEL_TURQUOISE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color TURQUOISE.
EXCEL_VIOLET
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color VIOLET.
EXCEL_WHITE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color WHITE.
EXCEL_YELLOW
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Excel color YELLOW.
EXPRESSION
- Static variable in class com.jrefinery.workbook.
Cell
Constant for formula cell.
EXTRA_THICK_LINE
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type EXTRA_THICK_LINE.
F
FILL
- Static variable in class com.jrefinery.workbook.
Style
Constant for "fill" horizontal alignment.
font
- Variable in class com.jrefinery.workbook.
StyleFontModifier
The new font.
font
- Variable in class com.jrefinery.workbook.
Style
The font details.
footer_left
- Variable in class com.jrefinery.workbook.
PrintInformation
The left footer.
footer_middle
- Variable in class com.jrefinery.workbook.
PrintInformation
The middle footer.
footer_pts
- Variable in class com.jrefinery.workbook.
Margins
Footer margin.
footer_right
- Variable in class com.jrefinery.workbook.
PrintInformation
The right footer.
footer_units
- Variable in class com.jrefinery.workbook.
Margins
FOREGROUND_COLOR
- Static variable in class com.jrefinery.workbook.
StyleColor
Constant representing the foreground color.
foregroundColor
- Variable in class com.jrefinery.workbook.
Style
The foreground color.
format
- Variable in class com.jrefinery.workbook.
Style
The format.
FormulaCell
- class com.jrefinery.workbook.
FormulaCell
.
A cell that contains a formula.
FormulaCell(String, int, int)
- Constructor for class com.jrefinery.workbook.
FormulaCell
Standard constructor.
G
GENERAL
- Static variable in class com.jrefinery.workbook.
Style
Constant for "general" horizontal alignment.
GeneralStyleModifier
- class com.jrefinery.workbook.
GeneralStyleModifier
.
A general style modifier that can change a variety of style settings.
GeneralStyleModifier(boolean, boolean)
- Constructor for class com.jrefinery.workbook.
GeneralStyleModifier
Standard constructor.
GeneralStyleModifier(boolean, int, boolean, int)
- Constructor for class com.jrefinery.workbook.
GeneralStyleModifier
Standard constructor.
geometry_height
- Variable in class com.jrefinery.workbook.
JWorkbook
The height of the workbook when displayed in Gnumeric.
geometry_width
- Variable in class com.jrefinery.workbook.
JWorkbook
The width of the workbook when displayed in Gnumeric.
get(int)
- Method in class com.jrefinery.workbook.
Row
Returns the cell at the specified column.
getApplication()
- Method in class com.jrefinery.workbook.
Summary
Returns the application.
getAuthor()
- Method in class com.jrefinery.workbook.
Summary
Returns the author.
getBackgroundColor()
- Method in class com.jrefinery.workbook.
Style
Returns the background color.
getBlue()
- Method in class com.jrefinery.workbook.
StyleColor
Returns the blue component of the color.
getBorder()
- Method in class com.jrefinery.workbook.
Style
Returns the border for this style.
getCategory()
- Method in class com.jrefinery.workbook.
Summary
Returns the category for the workbook.
getCellIndent()
- Method in class com.jrefinery.workbook.
Style
Returns the indentation.
getColumnAttributesManager()
- Method in class com.jrefinery.workbook.
Worksheet
Returns a reference to the object managing the column attributes.
getComments()
- Method in class com.jrefinery.workbook.
Summary
Returns the comments for the workbook.
getCompany()
- Method in class com.jrefinery.workbook.
Summary
Returns the company.
getDefaultColumnWidth()
- Method in class com.jrefinery.workbook.
ColumnAttributesManager
Returns the default column width.
getDefaultRowHeight()
- Method in class com.jrefinery.workbook.
RowAttributesManager
Returns the default row height.
getEndColumn()
- Method in class com.jrefinery.workbook.
ColumnAttributes
Returns the end column.
getEndColumn()
- Method in class com.jrefinery.workbook.
StyleRegion
Returns the end column of the region.
getEndRow()
- Method in class com.jrefinery.workbook.
RowAttributes
Returns the end row.
getEndRow()
- Method in class com.jrefinery.workbook.
StyleRegion
Returns the end row of the region.
getFont()
- Method in class com.jrefinery.workbook.
Style
Returns the font for this style.
getForegroundColor()
- Method in class com.jrefinery.workbook.
Style
Returns the foreground color.
getFormat()
- Method in class com.jrefinery.workbook.
Style
Returns the format string for the cell.
getGreen()
- Method in class com.jrefinery.workbook.
StyleColor
Returns the green component of the color.
getHeight()
- Method in class com.jrefinery.workbook.
RowAttributes
Returns the row height.
getHorizontalAlignment()
- Method in class com.jrefinery.workbook.
Style
Returns the horizontal alignment for this style.
getIndex()
- Method in class com.jrefinery.workbook.
Row
Returns the index of the row.
getInputs()
- Method in class com.jrefinery.workbook.
Solver
Returns the inputs.
getIntersectCase(int, int, int, int)
- Method in class com.jrefinery.workbook.
StyleRegion
Returns an integer denoting one of the 17 cases of intersection.
getIntersectionStyleRegion(int, int, int, int, StyleModifier)
- Method in class com.jrefinery.workbook.
StyleRegion
Returns a StyleRegion representing the portion of this region that intersects with the specified region.
getKeywords()
- Method in class com.jrefinery.workbook.
Summary
Returns the keywords for the workbook.
getManager()
- Method in class com.jrefinery.workbook.
Summary
Returns the manager.
getModifiedStyle(Style)
- Method in class com.jrefinery.workbook.
StyleColorModifier
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 interface com.jrefinery.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 com.jrefinery.workbook.
StyleFontModifier
Returns a new style with the same settings as the style passed in, except with a different font.
getModifiedStyle(Style)
- Method in class com.jrefinery.workbook.
GeneralStyleModifier
Returns a new style based on the supplied style, but modified in some way.
getModifiedStyle(Style)
- Method in class com.jrefinery.workbook.
StyleBorderModifier
Returns a new style with the same settings as the style passed in, except with a different border.
getName()
- Method in class com.jrefinery.workbook.
Worksheet
Returns the name of the worksheet.
getName()
- Method in class com.jrefinery.workbook.
Name
Returns the name.
getNameCount()
- Method in class com.jrefinery.workbook.
NamesManager
Returns the number of names in the list.
getNamesManager()
- Method in class com.jrefinery.workbook.
Worksheet
Returns a reference to the names manager.
getNonIntersectionStyleRegionList(int, int, int, int)
- Method in class com.jrefinery.workbook.
StyleRegion
Returns a list of StyleRegions equivalent to the non-intersection with the specified range.
getNonIntersectionStyleRegionList(StyleRegion)
- Method in class com.jrefinery.workbook.
StyleRegion
Returns a list of style regions that cover the non-intersecting part of this region.
getOrientation()
- Method in class com.jrefinery.workbook.
Style
Returns the text orientation.
getPatternColor()
- Method in class com.jrefinery.workbook.
Style
Returns the pattern color.
getProblemType()
- Method in class com.jrefinery.workbook.
Solver
Returns the problem type.
getRed()
- Method in class com.jrefinery.workbook.
StyleColor
Returns the red component of the color.
getRowAttributesManager()
- Method in class com.jrefinery.workbook.
Worksheet
Returns a reference to the object managing the row attributes.
getSerialNumber()
- Method in class com.jrefinery.workbook.
Cell
Returns an integer that increases across columns and down rows.
getShade()
- Method in class com.jrefinery.workbook.
Style
Returns the shade.
getSplitFromColumn(int)
- Method in class com.jrefinery.workbook.
ColumnAttributes
Returns a new ColumnAttributes object, based on this one but only from the specified column.
getSplitFromRow(int)
- Method in class com.jrefinery.workbook.
RowAttributes
Returns a new RowAttributes object, based on this one but only from the specified row.
getSplitToColumn(int)
- Method in class com.jrefinery.workbook.
ColumnAttributes
Returns a new ColumnAttributes object, based on this one but only up to the specified column.
getSplitToRow(int)
- Method in class com.jrefinery.workbook.
RowAttributes
Returns a new RowAttributes object, based on this one but only up to the specified row.
getStartColumn()
- Method in class com.jrefinery.workbook.
ColumnAttributes
Returns the start column.
getStartColumn()
- Method in class com.jrefinery.workbook.
StyleRegion
Returns the start column of the region.
getStartRow()
- Method in class com.jrefinery.workbook.
RowAttributes
Returns the start row.
getStartRow()
- Method in class com.jrefinery.workbook.
StyleRegion
Returns the start row of the region.
getStyle()
- Method in class com.jrefinery.workbook.
StyleRegion
Returns the style for this region.
getSubset(int, int)
- Method in class com.jrefinery.workbook.
ColumnAttributes
Returns a new ColumnAttributes object, based on this one but only for the specified range of columns.
getSubset(int, int)
- Method in class com.jrefinery.workbook.
RowAttributes
Returns a new RowAttributes object, based on this one but only for the specified range of rows.
getTargetColumn()
- Method in class com.jrefinery.workbook.
Solver
Returns the target column.
getTargetRow()
- Method in class com.jrefinery.workbook.
Solver
Returns the target row.
getTitle()
- Method in class com.jrefinery.workbook.
Summary
Returns the workbook title.
getValue()
- Method in class com.jrefinery.workbook.
Name
Returns the value.
getVerticalAlignment()
- Method in class com.jrefinery.workbook.
Style
Returns the vertical alignment for this style.
getWidth()
- Method in class com.jrefinery.workbook.
ColumnAttributes
Returns the column width.
getZoom()
- Method in class com.jrefinery.workbook.
Worksheet
Returns the zoom factor.
GNUMERIC_BLACK
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color BLACK.
GNUMERIC_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color BLUE.
GNUMERIC_BRIGHT_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color BRIGHT_BLUE.
GNUMERIC_BRIGHT_ORANGE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color BRIGHT_ORANGE.
GNUMERIC_BROWN_GOLD
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color BROWN_GOLD.
GNUMERIC_CYAN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color CYAN.
GNUMERIC_DARK_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DARK_BLUE.
GNUMERIC_DARK_GRAY
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DARK_GRAY.
GNUMERIC_DARK_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DARK_GREEN.
GNUMERIC_DARK_GREEN_2
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DARK_GREEN_2.
GNUMERIC_DARK_RED
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DARK_RED.
GNUMERIC_DULL_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DULL_BLUE.
GNUMERIC_DULL_BLUE_2
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DULL_BLUE_2.
GNUMERIC_DULL_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DULL_GREEN.
GNUMERIC_DULL_PURPLE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color DULL_PURPLE.
GNUMERIC_GOLD
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color GOLD.
GNUMERIC_GRAY
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color GRAY.
GNUMERIC_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color GREEN.
GNUMERIC_LIGHT_BLUE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_BLUE.
GNUMERIC_LIGHT_BROWN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_BROWN.
GNUMERIC_LIGHT_CYAN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_CYAN.
GNUMERIC_LIGHT_GRAY
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_GRAY.
GNUMERIC_LIGHT_GREEN
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_GREEN.
GNUMERIC_LIGHT_ORANGE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_ORANGE.
GNUMERIC_LIGHT_PURPLE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_PURPLE.
GNUMERIC_LIGHT_YELLOW
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIGHT_YELLOW.
GNUMERIC_LIME
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color LIME.
GNUMERIC_MAGENTA
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color MAGENTA.
GNUMERIC_NAVY
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color NAVY.
GNUMERIC_ORANGE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color ORANGE.
GNUMERIC_PINK
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color PINK.
GNUMERIC_PURPLE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color PURPLE.
GNUMERIC_PURPLE_2
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color PURPLE_2.
GNUMERIC_RED
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color RED.
GNUMERIC_RED_ORANGE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color RED_ORANGE.
GNUMERIC_RED_PURPLE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color RED_PURPLE.
GNUMERIC_SKY_BLUE_2
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color SKY_BLUE_2.
GNUMERIC_VERY_DARK_GRAY
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color VERY_DARK_GRAY.
GNUMERIC_WHITE
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color WHITE.
GNUMERIC_YELLOW
- Static variable in class com.jrefinery.workbook.
StyleColor
Useful constant representing the standard Gnumeric color YELLOW.
green
- Variable in class com.jrefinery.workbook.
StyleColor
Green component.
grid_visible
- Variable in class com.jrefinery.workbook.
PrintInformation
Flag indicating whether the grid is visible.
H
hardSize
- Variable in class com.jrefinery.workbook.
ColumnAttributes
Not sure what this is (Gnumeric uses it for something).
hardSize
- Variable in class com.jrefinery.workbook.
RowAttributes
Not sure what this is (Gnumeric uses it for something).
header_left
- Variable in class com.jrefinery.workbook.
PrintInformation
The left header.
header_middle
- Variable in class com.jrefinery.workbook.
PrintInformation
The middle header.
header_pts
- Variable in class com.jrefinery.workbook.
Margins
Header margin.
header_right
- Variable in class com.jrefinery.workbook.
PrintInformation
The right header.
header_units
- Variable in class com.jrefinery.workbook.
Margins
height
- Variable in class com.jrefinery.workbook.
RowAttributes
The row height.
height
- Variable in class com.jrefinery.workbook.
RowHeightModifier
The new height.
hidden
- Variable in class com.jrefinery.workbook.
ColumnAttributes
Flag that indicates whether this column is hidden.
hidden
- Variable in class com.jrefinery.workbook.
RowAttributes
Flag that indicates whether this row is hidden.
hideColHeader
- Variable in class com.jrefinery.workbook.
Worksheet
Hide the column header (true/false).
hideGrid
- Variable in class com.jrefinery.workbook.
Worksheet
Hide the grid (true/false).
hideRowHeader
- Variable in class com.jrefinery.workbook.
Worksheet
Hide the row header (true/false).
hideZero
- Variable in class com.jrefinery.workbook.
Worksheet
Hide zeros (true/false).
HORIZONTAL_CENTER
- Static variable in class com.jrefinery.workbook.
Style
Constant for centered horizontal alignment.
HORIZONTAL_JUSTIFY
- Static variable in class com.jrefinery.workbook.
Style
Constant for "justify" horizontal alignment.
horizontalAlignment
- Variable in class com.jrefinery.workbook.
GeneralStyleModifier
The new horizontal alignment, if required.
horizontalAlignment
- Variable in class com.jrefinery.workbook.
Style
The horizontal alignment.
horizontally_centered
- Variable in class com.jrefinery.workbook.
PrintInformation
Flag indicating whether the worksheet is horizontally centered on the page.
I
INDENT
- Static variable in class com.jrefinery.workbook.
JWorkbook
Standard indentation in the output file.
index
- Variable in class com.jrefinery.workbook.
Row
The row index (0 to Worksheet.MAX_ROWS).
inputs
- Variable in class com.jrefinery.workbook.
Solver
Inputs.
intersects(int, int, int, int)
- Method in class com.jrefinery.workbook.
StyleRegion
Returns true if the specified range intersects with this region, and false otherwise.
intersects(StyleRegion)
- Method in class com.jrefinery.workbook.
StyleRegion
Returns true if the specified region intersects with this region, and false otherwise.
isWrapText()
- Method in class com.jrefinery.workbook.
Style
Returns a flag indicating whether or not the text is wrapped.
italic
- Variable in class com.jrefinery.workbook.
StyleFont
Italic.
J
JWorkbook
- class com.jrefinery.workbook.
JWorkbook
.
Represents a workbook so that it can be exported to (for now) the Gnumeric XML file format.
JWorkbook()
- Constructor for class com.jrefinery.workbook.
JWorkbook
Default constructor: creates a new empty workbook.
JWorkbook(String, int)
- Constructor for class com.jrefinery.workbook.
JWorkbook
Standard constructor.
K
keywords
- Variable in class com.jrefinery.workbook.
Summary
Related keywords.
L
LABEL
- Static variable in class com.jrefinery.workbook.
Cell
Constant for label cell.
LabelCell
- class com.jrefinery.workbook.
LabelCell
.
A cell that contains a label.
LabelCell(String, int, int)
- Constructor for class com.jrefinery.workbook.
LabelCell
Standard constructor.
left
- Variable in class com.jrefinery.workbook.
StyleBorder
The left border.
LEFT
- Static variable in class com.jrefinery.workbook.
Style
Constant for left horizontal alignment.
left_pts
- Variable in class com.jrefinery.workbook.
Margins
Left margin.
left_units
- Variable in class com.jrefinery.workbook.
Margins
LINE
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type LINE.
M
main(String[])
- Static method in class com.jrefinery.workbook.
JWorkbook
Test program to demonstrate the idea "in principle".
manager
- Variable in class com.jrefinery.workbook.
Summary
Manager.
marginA
- Variable in class com.jrefinery.workbook.
ColumnAttributes
The left margin.
marginA
- Variable in class com.jrefinery.workbook.
RowAttributes
The left margin.
marginB
- Variable in class com.jrefinery.workbook.
ColumnAttributes
The right margin.
marginB
- Variable in class com.jrefinery.workbook.
RowAttributes
The right margin.
margins
- Variable in class com.jrefinery.workbook.
PrintInformation
Margins.
Margins
- class com.jrefinery.workbook.
Margins
.
Printing margins for a worksheet.
Margins()
- Constructor for class com.jrefinery.workbook.
Margins
Default constructor.
MAX_COLUMNS
- Static variable in class com.jrefinery.workbook.
Worksheet
The maximum number of columns in a worksheet.
MAX_ROWS
- Static variable in class com.jrefinery.workbook.
Worksheet
The maximum number of rows in a worksheet.
maxCol
- Variable in class com.jrefinery.workbook.
Worksheet
The index of the right-most column used in the worksheet.
maxRow
- Variable in class com.jrefinery.workbook.
Worksheet
The index of the bottom-most row used in the worksheet.
modifyColumnAttributes(ColumnAttributes)
- Method in interface com.jrefinery.workbook.
ColumnAttributesModifier
Apply changes to the specified attributes record.
modifyColumnAttributes(ColumnAttributes)
- Method in class com.jrefinery.workbook.
ColumnWidthModifier
Change the width of the column attributes record.
modifyColumnAttributes(ColumnAttributesModifier, int, int)
- Method in class com.jrefinery.workbook.
ColumnAttributesManager
General method for modifying column attributes.
modifyHorizontalAlignment
- Variable in class com.jrefinery.workbook.
GeneralStyleModifier
Change the horizontal alignment (yes/no).
modifyRowAttributes(RowAttributes)
- Method in interface com.jrefinery.workbook.
RowAttributesModifier
Apply changes to the specified attributes record.
modifyRowAttributes(RowAttributes)
- Method in class com.jrefinery.workbook.
RowHeightModifier
Apply the height change to the specified attributes record.
modifyRowAttributes(RowAttributesModifier, int, int)
- Method in class com.jrefinery.workbook.
RowAttributesManager
General method for modifying row attributes.
modifyStyle(StyleModifier, int, int, int, int)
- Method in class com.jrefinery.workbook.
Styles
Apply the style modifier to the styles that cover the specified region.
modifyVerticalAlignment
- Variable in class com.jrefinery.workbook.
GeneralStyleModifier
Change the vertical alignment (yes/no).
modifyWrapText
- Variable in class com.jrefinery.workbook.
GeneralStyleModifier
Change the wrap text setting (yes/no).
monochrome
- Variable in class com.jrefinery.workbook.
PrintInformation
Flag indicating whether the printing is monochrome.
N
name
- Variable in class com.jrefinery.workbook.
Worksheet
The name of the worksheet.
name
- Variable in class com.jrefinery.workbook.
JWorkbook
The workbook name.
name
- Variable in class com.jrefinery.workbook.
StyleFont
The font name.
name
- Variable in class com.jrefinery.workbook.
Name
The name.
Name
- class com.jrefinery.workbook.
Name
.
Represents a defined name in the workbook or a worksheet.
Name(String, String)
- Constructor for class com.jrefinery.workbook.
Name
Standard constructor.
names
- Variable in class com.jrefinery.workbook.
JWorkbook
Names defined in the workbook - not currently supported.
names
- Variable in class com.jrefinery.workbook.
NamesManager
Storage for the names.
namesManager
- Variable in class com.jrefinery.workbook.
Worksheet
Manager for names defined in the worksheet.
NamesManager
- class com.jrefinery.workbook.
NamesManager
.
Maintains a list of names.
NamesManager()
- Constructor for class com.jrefinery.workbook.
NamesManager
Default constructor.
NONE
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type NONE.
O
order
- Variable in class com.jrefinery.workbook.
PrintInformation
??
orientation
- Variable in class com.jrefinery.workbook.
PrintInformation
The paper orientation.
orientation
- Variable in class com.jrefinery.workbook.
Style
The orientation.
P
paper
- Variable in class com.jrefinery.workbook.
PrintInformation
The paper size.
PATTERN_COLOR
- Static variable in class com.jrefinery.workbook.
StyleColor
Constant representing the pattern color.
patternColor
- Variable in class com.jrefinery.workbook.
Style
The pattern color.
print_info
- Variable in class com.jrefinery.workbook.
Worksheet
Print setup.
PrintInformation
- class com.jrefinery.workbook.
PrintInformation
.
Records print information for a workbook.
PrintInformation()
- Constructor for class com.jrefinery.workbook.
PrintInformation
Default constructor.
problemType
- Variable in class com.jrefinery.workbook.
Solver
The problem type.
putComment(String, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Puts a comment in a cell, overwriting any existing cell comments.
putDate(SerialDate, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Puts a date in a cell, overwriting any existing cell contents.
putFormula(String, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Puts a formula in a cell, overwriting any existing cell contents.
putLabel(String, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Puts a label in a cell, overwriting any existing cell contents.
putValue(double, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Puts a value in a cell, overwriting any existing cell contents.
R
red
- Variable in class com.jrefinery.workbook.
StyleColor
Red component.
regions
- Variable in class com.jrefinery.workbook.
Styles
Storage for the style regions.
repeat_left
- Variable in class com.jrefinery.workbook.
PrintInformation
??
repeat_top
- Variable in class com.jrefinery.workbook.
PrintInformation
??
reverse_diagonal
- Variable in class com.jrefinery.workbook.
StyleBorder
The reverse diagonal 'border'.
right
- Variable in class com.jrefinery.workbook.
StyleBorder
The right border.
RIGHT
- Static variable in class com.jrefinery.workbook.
Style
Constant for right horizontal alignment.
right_pts
- Variable in class com.jrefinery.workbook.
Margins
Right margin.
right_units
- Variable in class com.jrefinery.workbook.
Margins
row
- Variable in class com.jrefinery.workbook.
Cell
The row number (0 to Worksheet.MAX_ROWS-1).
row
- Variable in class com.jrefinery.workbook.
Comment
The cell row.
Row
- class com.jrefinery.workbook.
Row
.
Represents a single row of cells in a worksheet.
Row(int)
- Constructor for class com.jrefinery.workbook.
Row
Standard constructor: creates an empty row with the specified index.
RowAttributes
- class com.jrefinery.workbook.
RowAttributes
.
Stores the attributes for a range of rows (or sometimes just one row).
RowAttributes(int, int)
- Constructor for class com.jrefinery.workbook.
RowAttributes
Standard constructor: uses default values.
RowAttributes(int, int, double)
- Constructor for class com.jrefinery.workbook.
RowAttributes
Standard constructor.
rowAttributesManager
- Variable in class com.jrefinery.workbook.
Worksheet
Row attributes (height, margins, hidden etc).
RowAttributesManager
- class com.jrefinery.workbook.
RowAttributesManager
.
Records information about the rows in a worksheet, row height, visibility etc.
RowAttributesManager()
- Constructor for class com.jrefinery.workbook.
RowAttributesManager
Default constructor.
RowAttributesModifier
- interface com.jrefinery.workbook.
RowAttributesModifier
.
Standard interface for modifying the row attributes.
RowHeightModifier
- class com.jrefinery.workbook.
RowHeightModifier
.
A class for modifying the row height in a row attributes record.
RowHeightModifier(double)
- Constructor for class com.jrefinery.workbook.
RowHeightModifier
Standard constructor.
rows
- Variable in class com.jrefinery.workbook.
Cells
A list of the rows of cells.
S
saveAs(String)
- Method in class com.jrefinery.workbook.
JWorkbook
Saves the workbook in Gnumeric XML format.
Selection
- class com.jrefinery.workbook.
Selection
.
Stores information on a selection range in a worksheet.
Selection(int, int, int, int)
- Constructor for class com.jrefinery.workbook.
Selection
Standard constructor.
selections
- Variable in class com.jrefinery.workbook.
Worksheet
Ranges that are selected.
selections
- Variable in class com.jrefinery.workbook.
Selections
A list of all selections.
Selections
- class com.jrefinery.workbook.
Selections
.
Stores information about all the selection ranges in a worksheet.
Selections()
- Constructor for class com.jrefinery.workbook.
Selections
Default constructor.
setApplication(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the application.
setAuthor(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the author.
setAuthor(String)
- Method in class com.jrefinery.workbook.
JWorkbook
Sets the author attribute.
setCategory(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the category for the workbook.
setColumnWidth(int, double)
- Method in class com.jrefinery.workbook.
Worksheet
Sets the width of one column.
setColumnWidth(int, int, double)
- Method in class com.jrefinery.workbook.
Worksheet
Sets the width of a range of columns.
setColumnWidth(int, int, double)
- Method in class com.jrefinery.workbook.
ColumnAttributesManager
Sets the width of a range of columns.
setComments(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the comments for the workbook.
setCompany(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the company.
setDefaultColumnWidth(double)
- Method in class com.jrefinery.workbook.
ColumnAttributesManager
Sets the default column width.
setDefaultRowHeight(double)
- Method in class com.jrefinery.workbook.
RowAttributesManager
Sets the default row height.
setHeight(double)
- Method in class com.jrefinery.workbook.
RowAttributes
Sets the row height.
setKeywords(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the keywords for the workbook.
setManager(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the manager.
setName(String)
- Method in class com.jrefinery.workbook.
Worksheet
Sets the name of the worksheet.
setRowHeight(int, double)
- Method in class com.jrefinery.workbook.
Worksheet
Sets the height of one row.
setRowHeight(int, int, double)
- Method in class com.jrefinery.workbook.
Worksheet
Sets the height of a range of rows.
setRowHeight(int, int, double)
- Method in class com.jrefinery.workbook.
RowAttributesManager
Sets the height of a range of rows.
setStyle(Style)
- Method in class com.jrefinery.workbook.
StyleRegion
Sets the style for this region.
setStyle(Style, int, int, int, int)
- Method in class com.jrefinery.workbook.
Worksheet
Set the style for the specified range of the worksheet.
setTitle(String)
- Method in class com.jrefinery.workbook.
Summary
Sets the workbook title.
setWidth(double)
- Method in class com.jrefinery.workbook.
ColumnAttributes
Sets the column width.
setZoom(double)
- Method in class com.jrefinery.workbook.
Worksheet
Sets the zoom factor.
shade
- Variable in class com.jrefinery.workbook.
Style
The shade.
show_horizontal_scrollbar
- Variable in class com.jrefinery.workbook.
JWorkbook
Visibility of the horizontal scroll bar.
show_notebook_tabs
- Variable in class com.jrefinery.workbook.
JWorkbook
Visibility of the notebook tabs.
show_vertical_scrollbar
- Variable in class com.jrefinery.workbook.
JWorkbook
Visibility of the vertical scroll bar.
size
- Variable in class com.jrefinery.workbook.
StyleFont
The size.
solver
- Variable in class com.jrefinery.workbook.
Worksheet
Settings for the solver utility.
Solver
- class com.jrefinery.workbook.
Solver
.
Records solver settings for a worksheet.
Solver()
- Constructor for class com.jrefinery.workbook.
Solver
Default constructor.
startColumn
- Variable in class com.jrefinery.workbook.
ColumnAttributes
The starting column number (0 to Worksheet.MAX_COLUMNS-1).
startColumn
- Variable in class com.jrefinery.workbook.
Selection
The start column for the selection.
startColumn
- Variable in class com.jrefinery.workbook.
StyleRegion
The start column.
startRow
- Variable in class com.jrefinery.workbook.
RowAttributes
The starting row number (0 to Worksheet.MAX_ROWS-1).
startRow
- Variable in class com.jrefinery.workbook.
Selection
The start row for the selection.
startRow
- Variable in class com.jrefinery.workbook.
StyleRegion
The start row.
strikethrough
- Variable in class com.jrefinery.workbook.
StyleFont
Strikethrough.
style
- Variable in class com.jrefinery.workbook.
StyleRegion
The style.
Style
- class com.jrefinery.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 com.jrefinery.workbook.
Style
Default constructor: constructs a new Style object with default values.
Style(StyleFont, int, int)
- Constructor for class com.jrefinery.workbook.
Style
Standard constructor: creates a style with a specific font and alignment.
Style(StyleFont, StyleBorder, int, int, boolean, int, int, int, StyleColor, StyleColor, StyleColor, String)
- Constructor for class com.jrefinery.workbook.
Style
Full constructor.
StyleBorder
- class com.jrefinery.workbook.
StyleBorder
.
Represents the border settings for a style range.
StyleBorder(int, int, int, int, int, int)
- Constructor for class com.jrefinery.workbook.
StyleBorder
Standard constructor.
StyleBorderModifier
- class com.jrefinery.workbook.
StyleBorderModifier
.
A style modifier that changes the border for a style, but leaves all other settings unchanged.
StyleBorderModifier(StyleBorder)
- Constructor for class com.jrefinery.workbook.
StyleBorderModifier
Standard constructor.
StyleColor
- class com.jrefinery.workbook.
StyleColor
.
Represents a color within a style.
StyleColor(int, int, int)
- Constructor for class com.jrefinery.workbook.
StyleColor
Standard constructor: creates a StyleColor with the specified red, green and blue components.
StyleColorModifier
- class com.jrefinery.workbook.
StyleColorModifier
.
A style modifier that changes the foreground, background or pattern color for a style, but leaves all other settings unchanged.
StyleColorModifier(int, StyleColor)
- Constructor for class com.jrefinery.workbook.
StyleColorModifier
Standard constructor.
StyleFont
- class com.jrefinery.workbook.
StyleFont
.
Represents a font within a style.
StyleFont(String)
- Constructor for class com.jrefinery.workbook.
StyleFont
Standard constructor: constructs a font (12pt) with the given name.
StyleFont(String, int)
- Constructor for class com.jrefinery.workbook.
StyleFont
Standard constructor: constructs a font with the given name and point size.
StyleFont(String, int, boolean, boolean, boolean, boolean)
- Constructor for class com.jrefinery.workbook.
StyleFont
Full constructor: constructs a font with all attributes as specified.
StyleFontModifier
- class com.jrefinery.workbook.
StyleFontModifier
.
A style modifier that changes the font for a style, but leaves all other settings unchanged.
StyleFontModifier(StyleFont)
- Constructor for class com.jrefinery.workbook.
StyleFontModifier
Standard constructor.
StyleModifier
- interface com.jrefinery.workbook.
StyleModifier
.
An interface for modifying styles.
StyleRegion
- class com.jrefinery.workbook.
StyleRegion
.
Represents a region and its associated style.
StyleRegion(Style, int, int, int, int)
- Constructor for class com.jrefinery.workbook.
StyleRegion
Standard constructor.
styles
- Variable in class com.jrefinery.workbook.
Worksheet
Styles that apply to ranges within the worksheet.
Styles
- class com.jrefinery.workbook.
Styles
.
A collection of style regions.
Styles()
- Constructor for class com.jrefinery.workbook.
Styles
Default constructor.
summary
- Variable in class com.jrefinery.workbook.
JWorkbook
A summary of the workbook.
Summary
- class com.jrefinery.workbook.
Summary
.
Records a summary of a workbook.
Summary()
- Constructor for class com.jrefinery.workbook.
Summary
Default constructor.
T
targetColumn
- Variable in class com.jrefinery.workbook.
Solver
The target column.
targetRow
- Variable in class com.jrefinery.workbook.
Solver
The target row.
THICK_DASHED1
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type THICK_DASHED1.
THICK_DASHED2
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type THICK_DASHED2.
THICK_DASHED3
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type THICK_DASHED3.
THICK_DASHED4
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type THICK_DASHED4.
THICK_LINE
- Static variable in class com.jrefinery.workbook.
StyleBorder
Constant for Gnumeric border type THICK_LINE.
title
- Variable in class com.jrefinery.workbook.
Summary
The title.
titles
- Variable in class com.jrefinery.workbook.
PrintInformation
Titles?
top
- Variable in class com.jrefinery.workbook.
StyleBorder
The top border.
TOP
- Static variable in class com.jrefinery.workbook.
Style
Constant for top vertical alignment.
top_pts
- Variable in class com.jrefinery.workbook.
Margins
Top margin.
top_units
- Variable in class com.jrefinery.workbook.
Margins
toString()
- Method in class com.jrefinery.workbook.
StyleColor
Returns the color as a string in the format required by Gnumeric.
U
underline
- Variable in class com.jrefinery.workbook.
StyleFont
Underline.
V
value
- Variable in class com.jrefinery.workbook.
Name
The text that the name resolves to.
VALUE
- Static variable in class com.jrefinery.workbook.
Cell
Constant for value cell.
ValueCell
- class com.jrefinery.workbook.
ValueCell
.
A cell that contains a value.
ValueCell(double, int, int)
- Constructor for class com.jrefinery.workbook.
ValueCell
Standard constructor.
valueFormat
- Variable in class com.jrefinery.workbook.
Cell
The value format (if required).
valueType
- Variable in class com.jrefinery.workbook.
Cell
The type of data in the cell.
VERSION
- Static variable in class com.jrefinery.workbook.
JWorkbook
Version identification.
VERTICAL_CENTER
- Static variable in class com.jrefinery.workbook.
Style
Constant for centered vertical alignment.
VERTICAL_JUSTIFY
- Static variable in class com.jrefinery.workbook.
Style
Constant for "justified" vertical alignment.
verticalAlignment
- Variable in class com.jrefinery.workbook.
GeneralStyleModifier
The new vertical alignment, if required.
verticalAlignment
- Variable in class com.jrefinery.workbook.
Style
The vertical alignment.
vertically_centered
- Variable in class com.jrefinery.workbook.
PrintInformation
Flag indicating whether the worksheet is vertically centered on the page.
W
which
- Variable in class com.jrefinery.workbook.
StyleColorModifier
Foreground, background or pattern color.
width
- Variable in class com.jrefinery.workbook.
ColumnAttributes
The column width.
width
- Variable in class com.jrefinery.workbook.
ColumnWidthModifier
The new width.
Worksheet
- class com.jrefinery.workbook.
Worksheet
.
Represents one worksheet within a workbook.
Worksheet(String)
- Constructor for class com.jrefinery.workbook.
Worksheet
Standard constructor: creates a named empty worksheet.
worksheets
- Variable in class com.jrefinery.workbook.
JWorkbook
The worksheets contained in this workbook.
wrapText
- Variable in class com.jrefinery.workbook.
GeneralStyleModifier
The new wrap text setting, if required.
wrapText
- Variable in class com.jrefinery.workbook.
Style
Wrap text (true/false).
writeCell(PrintStream, String)
- Method in class com.jrefinery.workbook.
Cell
Write the cell element.
writeCell(PrintStream, String)
- Method in class com.jrefinery.workbook.
FormulaCell
Write the cell element.
writeCell(PrintStream, String)
- Method in class com.jrefinery.workbook.
DateCell
Write the cell element.
writeCells(PrintStream, String)
- Method in class com.jrefinery.workbook.
Cells
Writes the cells to the specified stream in the format required by the Gnumeric XML file.
writeColInfo(PrintStream, String)
- Method in class com.jrefinery.workbook.
ColumnAttributes
Writes the columns element to the specified stream in the Gnumeric format.
writeColumns(PrintStream, String)
- Method in class com.jrefinery.workbook.
ColumnAttributesManager
Writes the columns element to the specified stream.
writeComment(PrintStream, String)
- Method in class com.jrefinery.workbook.
Comment
Writes a comment element in the Gnumeric file format.
writeContent(PrintStream, String)
- Method in class com.jrefinery.workbook.
Cell
Write the cell contents.
writeMargins(PrintStream, String)
- Method in class com.jrefinery.workbook.
Margins
Writes the margins element to the stream.
writeNames(PrintStream, String)
- Method in class com.jrefinery.workbook.
NamesManager
Writes a names element in the Gnumeric format.
writePrintInformation(PrintStream, String)
- Method in class com.jrefinery.workbook.
PrintInformation
Writes a print information element to the stream.
writeRow(PrintStream, String)
- Method in class com.jrefinery.workbook.
Row
Writes a row element to the stream.
writeRowInfo(PrintStream, String)
- Method in class com.jrefinery.workbook.
RowAttributes
Writes the rows element to the specified stream in the Gnumeric format.
writeRows(PrintStream, String)
- Method in class com.jrefinery.workbook.
RowAttributesManager
Writes the rows element to the specified stream.
writeSelection(PrintStream, String)
- Method in class com.jrefinery.workbook.
Selection
Writes a selection element to the stream.
writeSelections(PrintStream, String)
- Method in class com.jrefinery.workbook.
Selections
Writes a selections element to the stream.
writeSolver(PrintStream, String)
- Method in class com.jrefinery.workbook.
Solver
Writes a solver element to the stream.
writeStyle(PrintStream, String)
- Method in class com.jrefinery.workbook.
Style
Writes a style element to the stream.
writeStyleBorder(PrintStream, String)
- Method in class com.jrefinery.workbook.
StyleBorder
Writes a style border element to the stream.
writeStyleFont(PrintStream, String)
- Method in class com.jrefinery.workbook.
StyleFont
Writes a style font element to the stream.
writeStyleRegion(PrintStream, String)
- Method in class com.jrefinery.workbook.
StyleRegion
Writes a style region element to the stream.
writeStyles(PrintStream, String)
- Method in class com.jrefinery.workbook.
Styles
Writes a styles element to the stream.
writeWorksheet(PrintStream, String)
- Method in class com.jrefinery.workbook.
Worksheet
Writes a worksheet element in the Gnumeric format to a stream.
Z
zoom
- Variable in class com.jrefinery.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
Z
Package
Class
Tree
Deprecated
Index
Help
PREV NEXT
FRAMES
NO FRAMES