A B C D E F G H I K L M N O P R S T U V W Y

G

GENERAL - Static variable in class com.jxcell.CellException
 
getAction() - Method in class com.jxcell.ValidationFailedEvent
 
getActiveCell() - Method in class com.jxcell.View
Returns the row and column coordinates of the active cell The active cell is the cell in which the cursor is currently located.
getAutoFillItems(int) - Method in class com.jxcell.View
Returns an autofill list Autofill lists are frequently used series of text such as months and days of the week.
getAutoFillItemsCount() - Method in class com.jxcell.View
Returns the number of existing autofill lists
getBackColor() - Method in class com.jxcell.View
Returns the background color of the current sheet.
getBottomBorder() - Method in class com.jxcell.CellFormat
Returns the border for the bottom edge of the cell
getBottomBorderColor() - Method in class com.jxcell.CellFormat
Returns the color used to display the bottom edge of the cell
getCellFormat() - Method in class com.jxcell.View
Returns the format of the selected range of cells
getCellFormat(int, int, int, int) - Method in class com.jxcell.View
Returns the format of the specified range of cells Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
getCellFormat(int, int, int, int, int, int) - Method in class com.jxcell.View
Returns the format of the specified range of cells in the specified range of sheets Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
getCellFormat(CellFormat) - Method in class com.jxcell.View
Returns the format of the selected range of cells into the specified CellFormat object You can use this method to loop through cells, retrieving cell formats through the same instance of the CellFormat object.
getCellFormat(CellFormat, int, int, int, int) - Method in class com.jxcell.View
Returns the format of the specified range of cells into the specified CellFormat object You can use this method to loop through cells, retrieving cell formats through the same instance of the CellFormat object.
getCellFormat(CellFormat, int, int, int, int, int, int) - Method in class com.jxcell.View
Returns the format of the specified range of cells in the specified range of sheets into the specified CellFormat object You can use this method to loop through cells, retrieving cell formats through the same instance of the CellFormat object.
getClip() - Method in class com.jxcell.View
Imports tab-delimited text strings from workbooks.
getClipValues() - Method in class com.jxcell.View
Imports values from workbooks
getClipboard() - Static method in class com.jxcell.View
Returns the clipboard to be used for clipboard operations.
getCol() - Method in class com.jxcell.CellRef
Gets the active column in the worksheet
getCol() - Method in class com.jxcell.FindReplaceInfo
Determines the starting column for the search in a Find and Replace operation.
getCol() - Method in class com.jxcell.ValidationFailedEvent
 
getCol() - Method in class com.jxcell.View
Returns the active column in the active worksheet.
getCol1() - Method in class com.jxcell.RangeRef
Returns the starting column in a worksheet range.
getCol2() - Method in class com.jxcell.RangeRef
Returns the ending column in a worksheet range.
getColText(int) - Method in class com.jxcell.View
Returns the label for a column.
getColWidth(int) - Method in class com.jxcell.View
Returns the width of a single column.
getColWidthTwips(int) - Method in class com.jxcell.View
Returns the width of the specified column in twips Column width can be specified in units equal to 1/256th of the character O's width in the default font, or to twips, depending on the column width units specified for the workbook.
getColWidthUnits() - Method in class com.jxcell.View
Returns whether column widths are stored and displayed in twips or character units.
getDefaultColWidth() - Method in class com.jxcell.View
Returns the default column width
getDefaultFontName() - Method in class com.jxcell.View
Returns the name of the default font
getDefaultFontSize() - Method in class com.jxcell.View
Returns the size of the default font
getDefaultRowHeight() - Method in class com.jxcell.View
Returns the default height for rows.
getDefinedName(int) - Method in class com.jxcell.View
Returns a defined name
getDefinedName(String) - Method in class com.jxcell.View
Returns the definition associated with a name, in US English.
getDefinedNameCount() - Method in class com.jxcell.View
Returns the number of defined names in a view
getDefinedNameLocal(String) - Method in class com.jxcell.View
Returns the definition of a defined name in the user's local language A defined name can refer to a cell, a group of cells, a value, or a formula.
getEditString() - Method in class com.jxcell.EndEditEvent
Retrieves the edit string to be entered in the active cell
getEditString() - Method in class com.jxcell.StartEditEvent
 
getEntry() - Method in class com.jxcell.ValidationFailedEvent
 
getEntry() - Method in class com.jxcell.View
Returns the contents of the active cell in the first selected worksheet in edit mode format For example, if the cell contains a formula, the text of the formula is displayed.
getEntry(int, int) - Method in class com.jxcell.View
Returns the text value of the specified cell in the first selected worksheet in edit mode format For example, if the cell contains a formula, the text of the formula is displayed.
getEntry(int, int, int) - Method in class com.jxcell.View
Returns the text value of the specified cell in the first selected worksheet in edit mode format For example, if the cell contains a formula, the text of the formula is displayed.
getExtraColor() - Method in class com.jxcell.View
Returns the extra color of the current sheet.
getFileName() - Method in class com.jxcell.View
Returns the name of the workbook file currently attached to a view.
getFirstNumberFormat() - Method in class com.jxcell.View
Returns a NumberFormat object representing the first entry in the workbook's number format table.
getFirstObject() - Method in class com.jxcell.View
Returns the first object in the active worksheet This method can be used in conjunction with the getNextObject method to to loop through all the objects in a worksheet.
getFirstView() - Method in class com.jxcell.View
Returns the first view of the workbook attached to this view.
getFixedCol() - Method in class com.jxcell.View
Returns the starting fixed column.
getFixedCols() - Method in class com.jxcell.View
Returns the number of fixed columns or zero if there are none.
getFixedRow() - Method in class com.jxcell.View
Returns the starting fixed row.
getFixedRows() - Method in class com.jxcell.View
Returns the number of fixed rows or zero if there are none.
getFlags() - Method in class com.jxcell.HTMLWriter
Gets the different flags indicating what TAGS to use and how data is displayed.
getFontColor() - Method in class com.jxcell.CellFormat
Returns the color used to display the font
getFontName() - Method in class com.jxcell.CellFormat
Returns the name of the font
getFontSize() - Method in class com.jxcell.CellFormat
Returns the size of the font
getFontSizeInPoints() - Method in class com.jxcell.CellFormat
Returns the size of the font in points
getFormattedText() - Method in class com.jxcell.View
 
getFormattedText(int, int) - Method in class com.jxcell.View
Returns the formatted text value of the specified cell This method returns the text as it is seen in the worksheet, including all formatting.
getFormattedText(int, int, int) - Method in class com.jxcell.View
Returns the value of the specified cell as it appears in the specified worksheet This method returns the text as it is seen in the worksheet, including all formatting.
getFormula() - Method in class com.jxcell.View
Returns the formula of the active cell.
getFormula(int, int) - Method in class com.jxcell.View
Returns the the text of the formula of the specified cell, in US English.
getFormula(int, int, int) - Method in class com.jxcell.View
Returns the the text of the formula of the specified cell, in US English.
getFormulaLocal() - Method in class com.jxcell.View
Returns the text of the formula of the active cell, in the user's language
getFormulaLocal(int, int) - Method in class com.jxcell.View
Returns the the text of the formula of the specified cell, in the user's language
getFormulaLocal(int, int, int) - Method in class com.jxcell.View
Returns the the text of the formula of the specified cell in the specified sheet, in the user's language
getFoundCount() - Method in class com.jxcell.FindReplaceInfo
Returns the number of items found in a Find operation.
getGroup() - Method in class com.jxcell.View
Returns the group name for the workbook attached to this view.
getHeaderHeight() - Method in class com.jxcell.View
Returns the height of the column headers.
getHeaderWidth() - Method in class com.jxcell.View
Returns the width of the row headers.
getHorizontalAlignment() - Method in class com.jxcell.CellFormat
Returns the type of horizontal alignment.
getHorizontalInsideBorder() - Method in class com.jxcell.CellFormat
Returns the border type for the horizontal inside border
getHorizontalInsideBorderColor() - Method in class com.jxcell.CellFormat
Returns the color used to display the horizontal inside border
getImg(URL) - Method in class com.jxcell.View
 
getInsets() - Method in class com.jxcell.View
 
getIterationMax() - Method in class com.jxcell.View
Returns the maximum number of calculation iterations Iteration can be used to resolve circular references.
getIterationMaxChange() - Method in class com.jxcell.View
Returns the maximum iteration change value Iteration can be used to resolve circular references.
getLastCol() - Method in class com.jxcell.View
Returns the number of the last occupied column This method returns the last column that is not empty, including cells that contain only formatting.
getLastColForRow(int) - Method in class com.jxcell.View
Returns the number of the last occupied column in the specified row This method returns the last column that is not empty, including cells that contain only formatting.
getLastRow() - Method in class com.jxcell.View
Returns the number of the last occupied row This method returns the last row that is not empty, including cells that contain only formatting.
getLeftBorder() - Method in class com.jxcell.CellFormat
Returns the border for the left edge of the cell
getLeftBorderColor() - Method in class com.jxcell.CellFormat
Returns the color used to display the left edge of the cell
getLeftCol() - Method in class com.jxcell.View
Returns the first column currently displayed in this view.
getLock() - Method in class com.jxcell.View
Locks all views and workbooks in the current group.
getMaxCol() - Method in class com.jxcell.View
Returns the last column which may be displayed in the current sheet.
getMaxRow() - Method in class com.jxcell.View
Returns the last row which may be displayed in the current sheet.
getMenu() - Method in class com.jxcell.designer.Designer
 
getMessage() - Method in class com.jxcell.ValidationFailedEvent
 
getMinCol() - Method in class com.jxcell.View
Returns the first column that can be displayed in the active worksheet.
getMinRow() - Method in class com.jxcell.View
Returns the first row that can be displayed in the active worksheet.
getMode() - Method in class com.jxcell.View
Returns the current mode for mouse actions in a view
getNextColPageBreak(int) - Method in class com.jxcell.View
Returns the next column where there is a page break
getNextNumberFormat(NumberFormat) - Method in class com.jxcell.View
Returns a NumberFormat object containing the next entry in the workbook's number format table.
getNextRowPageBreak(int) - Method in class com.jxcell.View
Returns the next row where there is a page break
getNextView() - Method in class com.jxcell.View
Returns the next view of a workbook.
getNumSheets() - Method in class com.jxcell.View
Returns the number of worksheets in the current workbook
getNumber() - Method in class com.jxcell.View
Returns the numeric value of the active cell Cells containing a formula return the numeric result of the formula.
getNumber(int, int) - Method in class com.jxcell.View
Returns the numeric value of the specified cell.
getNumber(int, int, int) - Method in class com.jxcell.View
Returns the numeric value of the specified cell in the specified worksheet Cells containing a formula return the numeric result of the formula.
getNumberFormat() - Method in class com.jxcell.CellFormat
Returns the number format associated with a cell.
getNumberFormat() - Method in class com.jxcell.NumberFormat
Returns a number format string such as #,##0.00.
getNumberFormatLocal() - Method in class com.jxcell.CellFormat
Returns the number format associated with a cell in the local language.
getNumberFormatLocal() - Method in class com.jxcell.NumberFormat
Returns a number format string, in the user's local language.
getNumberFormatType() - Method in class com.jxcell.CellFormat
Returns the type of number format associated with a cell.
getObject() - Method in class com.jxcell.ObjectEvent
 
getObject(int) - Method in class com.jxcell.View
Returns an object specified by its identification number
getObject(String) - Method in class com.jxcell.View
Returns an object specified by name
getPaletteEntry(int) - Method in class com.jxcell.View
Returns a color in the JXCell color palette
getParameterInfo() - Method in class com.jxcell.View
 
getParentFrame() - Method in class com.jxcell.View
Returns the parent window
getPattern() - Method in class com.jxcell.CellFormat
Returns the pattern type.
getPatternBG() - Method in class com.jxcell.CellFormat
Returns the color used to display the pattern background
getPatternFG() - Method in class com.jxcell.CellFormat
Returns the color used to display the pattern foreground
getPolyEditMode() - Method in class com.jxcell.View
Returns the mode for interactive polygon editing In normal polygon editing mode (0), only the width and height of polygons can be interactively edited.
getPrintArea() - Method in class com.jxcell.View
Returns the current print area The returned string is based on the user-defined name, Print_Area, which defines the worksheet range to be printed.
getPrintBottomMargin() - Method in class com.jxcell.View
Returns the bottom print margin in inches.
getPrintFooter() - Method in class com.jxcell.View
Returns the current page footer The following list shows the special codes the footer text can contain.
getPrintFooterMargin() - Method in class com.jxcell.View
Returns the page footer margin used during printing The header and footer margins can be printed.
getPrintHeader() - Method in class com.jxcell.View
Returns the page header printed at the top of each page The following list shows the special codes the footer text can contain.
getPrintHeaderMargin() - Method in class com.jxcell.View
Returns the page header margin used during printing The header and footer margins can be printed.
getPrintLeftMargin() - Method in class com.jxcell.View
Returns the left print margin in inches.
getPrintRightMargin() - Method in class com.jxcell.View
Returns the right print margin in inches.
getPrintScale() - Method in class com.jxcell.View
Returns the scale factor for the active worksheet
getPrintScaleFitHPages() - Method in class com.jxcell.View
Returns the number of horizontal pages to which the print job is fit
getPrintScaleFitVPages() - Method in class com.jxcell.View
Returns the number of vertical pages to which the print job is fit
getPrintTitles() - Method in class com.jxcell.View
Returns the print titles to be printed at the top of each page Print titles are row and column titles that are printed on each page.
getPrintTopMargin() - Method in class com.jxcell.View
Returns the top print margin in inches.
getReplacedCount() - Method in class com.jxcell.FindReplaceInfo
Returns the number of replaced items in a Replace operation.
getRightBorder() - Method in class com.jxcell.CellFormat
Returns the border for the right edge of the cell
getRightBorderColor() - Method in class com.jxcell.CellFormat
Returns the color used to display the right edge of the cell
getRow() - Method in class com.jxcell.CellRef
Gets the active row in the worksheet
getRow() - Method in class com.jxcell.FindReplaceInfo
Determines the starting row for the search in a Find and Replace operation.
getRow() - Method in class com.jxcell.ValidationFailedEvent
 
getRow() - Method in class com.jxcell.View
Returns the row of the active cell.
getRow1() - Method in class com.jxcell.RangeRef
Returns the starting row in a worksheet range.
getRow2() - Method in class com.jxcell.RangeRef
Returns the ending row in a worksheet range.
getRowHeight(int) - Method in class com.jxcell.View
Returns the height of a single specified row.
getRowText(int) - Method in class com.jxcell.View
Returns the name of the specified row Naming a row is useful for providing labels that reflect the data in the row.
getSelEndCol() - Method in class com.jxcell.View
Returns the last selected column.
getSelEndRow() - Method in class com.jxcell.View
Returns the last selected row.
getSelStartCol() - Method in class com.jxcell.View
Returns the first selected col.
getSelStartRow() - Method in class com.jxcell.View
Returns the first selected row.
getSelectedObject(int) - Method in class com.jxcell.View
Returns the ID of a selected object.
getSelectedObjectCount() - Method in class com.jxcell.View
Returns the number of selected objects.
getSelection() - Method in class com.jxcell.View
Returns a formula that represents the row and column coordinates of the current selection.
getSelection(int) - Method in class com.jxcell.View
Returns the row and column coordinates of a selected range.
getSelectionCount() - Method in class com.jxcell.View
Returns the number of selected ranges in the active worksheet.
getSelectionLocal() - Method in class com.jxcell.View
Returns the start and end row and column of the specified selection, in the user's language.
getSheet() - Method in class com.jxcell.FindReplaceInfo
Returns the number identifying the worksheet in a Find and Replace operation
getSheet() - Method in class com.jxcell.ValidationFailedEvent
 
getSheet() - Method in class com.jxcell.View
Returns the active worksheet.
getSheetName(int) - Method in class com.jxcell.View
Returns the name of the specified worksheet.
getShowHScrollBar() - Method in class com.jxcell.View
Returns the mode for the horizontal scroll bar.
getShowSelections() - Method in class com.jxcell.View
Returns the mode for highlighting selections.
getShowTabs() - Method in class com.jxcell.View
Returns the display status and position of the sheet name tabs on a workbook.
getShowVScrollBar() - Method in class com.jxcell.View
Returns the mode for the vertical scroll bar.
getTabbedText(int, int, int, int, boolean) - Method in class com.jxcell.View
Takes the specified range of data and converts it to a tab-delimited block of text.
getText() - Method in class com.jxcell.View
Returns the text representation of the value of the active cell.
getText(int, int) - Method in class com.jxcell.View
Returns the text value of the specified cell
getText(int, int, int) - Method in class com.jxcell.View
Returns the text value of the specified cell
getTopBorder() - Method in class com.jxcell.CellFormat
Returns the border for the top edge of the cell
getTopBorderColor() - Method in class com.jxcell.CellFormat
Returns the color used to display the top edge of the cell
getTopLeftText() - Method in class com.jxcell.View
Returns the text displayed at the intersection of the row and column headings in the top left corner, affects all selected sheets.
getTopRow() - Method in class com.jxcell.View
Returns the top row displayed in the active worksheet.
getTransferData(DataFlavor) - Method in class com.jxcell.View
 
getTransferDataFlavors() - Method in class com.jxcell.View
 
getType() - Method in class com.jxcell.NumberFormat
Returns one of the following number format types: eNumberFormatTypeGeneral eNumberFormatTypeNumber eNumberFormatTypeCurrency eNumberFormatTypeDate eNumberFormatTypeDateTime eNumberFormatTypePercent eNumberFormatTypeFraction eNumberFormatTypeScientific eNumberFormatTypeString
getType() - Method in class com.jxcell.View
Returns the cell type of the active cell.
getType(int, int) - Method in class com.jxcell.View
Returns the cell type of the specified cell.
getType(int, int, int) - Method in class com.jxcell.View
Returns the cell type of the specified cell.
getValidationRule() - Method in class com.jxcell.CellFormat
Returns the validation rule associated with the active cell in US english.
getValidationText() - Method in class com.jxcell.CellFormat
Returns the text to be displayed in the cell if the validation rule fails.
getVersion() - Static method in class com.jxcell.View
Returns the version of the component.
getVersionString() - Static method in class com.jxcell.View
Returns the version of the component in a string.
getVerticalAlignment() - Method in class com.jxcell.CellFormat
Returns the type of vertical alignment.
getVerticalInsideBorder() - Method in class com.jxcell.CellFormat
Returns the color used to display the vertical inside border
getVerticalInsideBorderColor() - Method in class com.jxcell.CellFormat
 
getView() - Method in class com.jxcell.designer.Designer
 
getViewScale() - Method in class com.jxcell.View
Returns the current display scale for a workbook.
getWorkbookName() - Method in class com.jxcell.View
Returns the name assigned to the workbook associated with the current view control

A B C D E F G H I K L M N O P R S T U V W Y