Uses of Class
com.jxcell.CellException

Packages that use CellException
com.jxcell   
 

Uses of CellException in com.jxcell
 

Methods in com.jxcell that throw CellException
 void View.addColPageBreak(int i)
          Adds a vertical page break to the left edge of the specified column

 GRObject View.addObject(short objectType, double x1, double y1, double x2, double y2)
          Creates and adds an object to the active worksheet

 void View.addPageBreak()
          Adds a horizontal and vertical page break adjacent to the active cell

The horizontal page break is added at the cell's top edge; the vertical page break is added at the cell's left edge.

 GRObject View.addPicture(double x1, double y1, double x2, double y2, byte[] imageData)
          Adds picture object to the worksheet

 GRObject View.addPicture(double x1, double y1, double x2, double y2, java.net.URL url)
          Adds picture object to the worksheet

 GRObject View.addPolygon(double x1, double y1, double x2, double y2, java.awt.Point[] apoint, boolean closed)
          Creates and adds a polygon to a view, and specifieds the placement of points in the polygon.
 void View.addRowPageBreak(int row)
          Adds a horizontal page break adjacent to the top edge of the specified row

 void View.addSelection(int row1, int col1, int row2, int col2)
          Adds a new selection to the current selection list Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
 void View.attach(java.lang.String workbookName)
          Searches for a workbook with the specified name, and attaches the current view to it.
 int View.charWidthToTwips(int nCharWidth)
          Converts column widths to units equal to 1/256th of the character 0's width in the default font.
 void View.clearRange(int row1, int col1, int row2, int col2, short clearType)
          Clears the specified range Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
 void View.copyAll(View view)
          Copies the contents of one workbook to another workbook Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
 void View.copyDataFromArray(int sheet, int row1, int col1, int row2, int col2, double[][] data)
          Copies data from an array into a sheet The array and the sheet do not have to be the same size.
 void View.copyDataToArray(int sheet, int row1, int col1, int row2, int col2, double[][] data)
          Copies data from the sheet into an array The array and the sheet do not have to be the same size.
 void View.copyRange(int dstRow1, int dstCol1, int dstRow2, int dstCol2, View srcView, int srcRow1, int srcCol1, int srcRow2, int srcCol2)
          Copies a range of cells to a new location in the current workbook The source range can be in a different workbook.
 void View.copyRange(int dstRow1, int dstCol1, int dstRow2, int dstCol2, View srcView, int srcRow1, int srcCol1, int srcRow2, int srcCol2, short what)
          Copies a range of cells to a new location in the current workbook The source range can be in a different workbook.
 void View.copyRange(int dstSheet, int dstRow1, int dstCol1, int dstRow2, int dstCol2, View srcView, int srcSheet, int srcRow1, int srcCol1, int srcRow2, int srcCol2)
          Copies a range of cells to a new location in the current workbook Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
 void View.copyRange(int dstSheet, int dstRow1, int dstCol1, int dstRow2, int dstCol2, View srcView, int srcSheet, int srcRow1, int srcCol1, int srcRow2, int srcCol2, short what)
          Copies a range of cells to a new location in the current workbook This method allows you to choose the type of data to copy: formulas only, values only, formats only, any combination of the previous types, or all of the types.
 void View.deleteAutoFillItems(int index)
          Deletes the specified autofill list Autofill lists are frequently used series of data, such as months and days of the week.
 void View.deleteDefinedName(java.lang.String name)
          Deletes the specified user-defined name You cannot delete a defined name that is currently referenced by a formula in a cell, another defined name, or a chart object.
 void View.deleteRange(int row1, int col1, int row2, int col2, short shiftType)
          Deletes cells, rows, or columns from the specified range in all selected sheets.
 void View.deleteSheets(int sheet, int sheets)
          Deletes one or more worksheets from a workbook The names displayed on the sheet tabs are not affected by deletions; however, the worksheet index is adjusted.
 void View.draw(java.awt.Graphics g, int x, int y, int cx, int cy, int nRow, int nCol, int[] rows, int[] cols, int nFixedR1, int nFixedRows, int nFixedC1, int nFixedCols)
          Draws a workbook to the specified device context, such as a printer or window.
 void View.editClear(short clearType)
          Clears all cells in the selected range and all selected objects in all selected sheets

 void View.editCopy()
          Copies the selected range or objects to the clipboard Only one range can be selected.
 void View.editCopyDown()
          Copies cells in the top row a selection to the other rows in the selected range and adjusts relative cell references appropriately

 void View.editCopyRight()
          Copies cells in the left column of a selection to the other columns in the selected range and adjusts relative cell references appropriately

 void View.editCut()
          Cuts the selected range or object to the clipboard and clears the range or object from the active worksheet.
 void View.editDelete(short shift)
          Deletes the selected range in all selected sheets
 void View.editDeleteSheets()
          Deletes the selected sheets Sheet names displayed on the tabs are not affect by the deletion; however, the remaining worksheet indexes are adjusted to reflect the new position.
 void View.editInsert(short shift)
          Moves the selected range in all selected worksheets to insert new cells, rows, or columns
 void View.editInsertSheets()
          Inserts one or more new worksheets, depending on the number and position of the currently selected worksheets.
 void View.editPaste()
          Pastes the contents of the clipboard to the selected range.
 void View.editPasteSpecial(short what)
          Pastes data from the clipboard to the selected range This method allows you to choose the type of data to paste: formulas only, values only, formats only, any combination of the previous types, or all of the types.
 void View.endEdit()
          Ends edit mode and applies changes to the active cell If an invalid entry has been made (e.g., an incorrect formula), edit mode cannot end.
 java.lang.String View.errorNumberToText(short error)
          Returns a string containing the text of the corresponding to the specified error number
 void View.filePrint(boolean showPrintDlg)
          Prints the selected worksheet If the user-defined name Print_Area is defined, only those ranges specified in Print_Area are printed.
 FindReplaceInfo View.findFirst(int row1, int col1, int row2, int col2, java.lang.String findWhat, int flags)
          Finds the first cell in the current sheet for the given range.
 FindReplaceInfo View.findFirst(int sheet1, int row1, int col1, int sheet2, int row2, int col2, java.lang.String findWhat, int flags)
          Finds the first cell in the current sheet for the given range.
 FindReplaceInfo View.findFirst(java.lang.String findWhat, int flags)
          Finds the first cell in the current sheet for the given range.
 FindReplaceInfo View.findNext(java.lang.String findWhat, int flags)
          Finds the next cell containing the specified text
 java.lang.String View.formatRCNr(int row, int col, boolean doAbsolute)
          Returns a string containing a formatted row and column reference
 RangeRef View.formulaToRangeRef(java.lang.String formula)
          Creates and returns an instance of RangeRef from a formula.
 CellRef View.getActiveCell()
          Returns the row and column coordinates of the active cell The active cell is the cell in which the cursor is currently located.
 java.lang.String View.getAutoFillItems(int index)
          Returns an autofill list Autofill lists are frequently used series of text such as months and days of the week.
 CellFormat View.getCellFormat(int row1, int col1, int row2, int col2)
          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.
 CellFormat View.getCellFormat(int sheet1, int row1, int col1, int sheet2, int row2, int col2)
          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.
 void View.getCellFormat(CellFormat cellformat, int row1, int col1, int row2, int col2)
          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.
 void View.getCellFormat(CellFormat cellformat, int sheet1, int row1, int col1, int sheet2, int row2, int col2)
          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.
 java.lang.String View.getClip()
          Imports tab-delimited text strings from workbooks.
 java.lang.String View.getClipValues()
          Imports values from workbooks
 int View.getCol()
          Returns the active column in the active worksheet.
 java.lang.String View.getColText(int col)
          Returns the label for a column.
 int View.getColWidth(int col)
          Returns the width of a single column.
 int View.getColWidthTwips(int col)
          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.
 java.lang.String View.getDefinedName(int name)
          Returns a defined name
 java.lang.String View.getDefinedName(java.lang.String name)
          Returns the definition associated with a name, in US English.
 java.lang.String View.getDefinedNameLocal(java.lang.String name)
          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.
 java.lang.String View.getEntry()
          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.
 java.lang.String View.getEntry(int row, int col)
          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.
 java.lang.String View.getEntry(int sheet, int row, int col)
          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.
 NumberFormat View.getFirstNumberFormat()
          Returns a NumberFormat object representing the first entry in the workbook's number format table.
 java.lang.String View.getFormattedText()
           
 java.lang.String View.getFormattedText(int row, int col)
          Returns the formatted text value of the specified cell This method returns the text as it is seen in the worksheet, including all formatting.
 java.lang.String View.getFormattedText(int sheet, int row, int col)
          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.
 java.lang.String View.getFormula()
          Returns the formula of the active cell.
 java.lang.String View.getFormula(int row, int col)
          Returns the the text of the formula of the specified cell, in US English.
 java.lang.String View.getFormula(int sheetnum, int row, int col)
          Returns the the text of the formula of the specified cell, in US English.
 java.lang.String View.getFormulaLocal()
          Returns the text of the formula of the active cell, in the user's language
 java.lang.String View.getFormulaLocal(int row, int col)
          Returns the the text of the formula of the specified cell, in the user's language
 java.lang.String View.getFormulaLocal(int sheetnum, int row, int col)
          Returns the the text of the formula of the specified cell in the specified sheet, in the user's language
 int View.getLastColForRow(int rownum)
          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.
 int View.getLeftCol()
          Returns the first column currently displayed in this view.
 int View.getNextColPageBreak(int col)
          Returns the next column where there is a page break
 NumberFormat View.getNextNumberFormat(NumberFormat numberformat)
          Returns a NumberFormat object containing the next entry in the workbook's number format table.
 int View.getNextRowPageBreak(int row)
          Returns the next row where there is a page break
 double View.getNumber()
          Returns the numeric value of the active cell Cells containing a formula return the numeric result of the formula.
 double View.getNumber(int row, int col)
          Returns the numeric value of the specified cell.
 double View.getNumber(int sheet, int row, int col)
          Returns the numeric value of the specified cell in the specified worksheet Cells containing a formula return the numeric result of the formula.
 java.awt.Color View.getPaletteEntry(int entry)
          Returns a color in the JXCell color palette
 java.lang.String View.getPrintArea()
          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.
 java.lang.String View.getPrintTitles()
          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.
 int View.getRow()
          Returns the row of the active cell.
 int View.getRowHeight(int row)
          Returns the height of a single specified row.
 java.lang.String View.getRowText(int row)
          Returns the name of the specified row Naming a row is useful for providing labels that reflect the data in the row.
 GRObject View.getSelectedObject(int selection)
          Returns the ID of a selected object.
 RangeRef View.getSelection(int selection)
          Returns the row and column coordinates of a selected range.
 int View.getSelEndCol()
          Returns the last selected column.
 int View.getSelEndRow()
          Returns the last selected row.
 int View.getSelStartCol()
          Returns the first selected col.
 int View.getSelStartRow()
          Returns the first selected row.
 java.lang.String View.getSheetName(int sheet)
          Returns the name of the specified worksheet.
 java.lang.String View.getTabbedText(int row1, int row2, int col1, int col2, boolean valuesOnly)
          Takes the specified range of data and converts it to a tab-delimited block of text.
 java.lang.String View.getText()
          Returns the text representation of the value of the active cell.
 java.lang.String View.getText(int row, int col)
          Returns the text value of the specified cell
 java.lang.String View.getText(int sheet, int row, int col)
          Returns the text value of the specified cell
 int View.getTopRow()
          Returns the top row displayed in the active worksheet.
 short View.getType()
          Returns the cell type of the active cell.
 short View.getType(int row, int col)
          Returns the cell type of the specified cell.
 short View.getType(int sheet, int row, int col)
          Returns the cell type of the specified cell.
 void View.initWorkbook()
           
 void View.insertRange(int row1, int col1, int row2, int col2, short shifttype)
          Moves the specified range in order to insert new cells, rows or columns.
 void View.insertSheets(int sheet, int sheets)
          Inserts one or more worksheets at the specified location.
 boolean View.isColHidden(int col)
          Returns true if the column is hidden.
 boolean View.isEnableProtection(int sheet)
          Returns true if protection is enabled for all sheets in a workbook.
 boolean View.isLogical()
          Returns the logical (True or False) value of the active cell.
 boolean View.isLogical(int row, int col)
          Returns the logical (True or False) value of the specified cell.
 boolean View.isLogical(int nSheet, int nRow, int nCol)
          Returns the logical (True or False) value of the specified cell.
 boolean View.isRowHeightAutomatic(int row)
          Returns True if row height is automatic, False otherwise.
 boolean View.isRowHidden(int row)
          Returns True if row is hidden, False otherwise. .
 boolean View.isSheetSelected(int sheet)
          Returns True if worksheet is selected, False otherwise.
 void View.moveRange(int row1, int col1, int row2, int col2, int rowOffset, int colOffset)
          Moves a range of cells.
 short View.objectPosToTwips(double x1, double y1, double x2, double y2, java.awt.Rectangle rectangle)
          Given an object position in relation to rows and columns, this method returns the object position in twips.
 short View.rangeToPixels(int row1, int col1, int row2, int col2, java.awt.Rectangle rectangle)
          Returns the offset, width, and height of the specified range in pixels.
 short View.rangeToTwips(int row1, int col1, int row2, int col2, java.awt.Rectangle rectangle)
          Determines the offset, width, and height of the specified range in twips.
 short View.read(java.io.InputStream inputstream)
          Reads a worksheet or workbook from disk
 short View.read(java.lang.String string)
          Reads a worksheet or workbook from disk.
 short View.readFromBlob(byte[] blob)
          Reads a worksheet or workbook that has been stored in memory in a byte array
 short View.readURL(java.lang.String spec)
          Loads a worksheet from a URL address.
 void View.recalc()
          Recalculates the workbook attached to a view.
 void View.removeColPageBreak(int col)
          Removes a a vertical page break adjacent to the left edge of the specified column.
 void View.removeObject(GRObject grobject)
          Removes the specified object.
 void View.removePageBreak()
          Removes vertical and horizontal page breaks adjacent to the current cell.
 void View.removeRowPageBreak(int row)
          Removes a horizontal page break adjacent to the current cell
 boolean View.replace(java.lang.String findWhat, java.lang.String replaceWith, int flags, FindReplaceInfo findreplaceinfo)
          Invokes a find and replace session in a JXCell workbook and sets the criteria for the find and replace actions.
 void View.setActiveCell(int row, int col)
          Sets the row and column coordinates of the active cell The active cell is the cell in which the cursor is currently located.
 void View.setAutoFillItems(int index, java.lang.String items)
          Sets an autofill list.
 void View.setCellFormat(CellFormat cellformat)
          Sets the format of the selected range of cells
 void View.setCellFormat(CellFormat cellformat, int row1, int col1, int row2, int col2)
          Sets 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.
 void View.setCellFormat(CellFormat cellformat, int sheet1, int row1, int col1, int sheet2, int row2, int col2)
          Sets the format of the specified range of cells in the specified range of sheets
 void View.setClip(java.lang.String text)
          Exports a tab-delimited text block to a worksheet at run time.
 void View.setClipValues(java.lang.String text)
          Exports tab-delimited text strings to a workbook at run time ignoring any formatting applied to the text.
 void View.setCol(int col)
          Sets the column of the active cell.
 void View.setColHidden(int col, boolean colHidden)
          Sets a value indicating whether or not the specified column is hidden.
 void View.setColHidden(int col1, int col2, boolean colHidden)
          Sets the display status of the specified range of columns
 void View.setColText(int col, java.lang.String colText)
          Sets the label for a column.
 void View.setColWidth(int col, int width)
          Sets the width of a single column.
 void View.setColWidth(int col1, int col2, int width, boolean defColWidth)
          Sets the width of a single column.
 void View.setColWidthAuto(int row1, int col1, int row2, int col2, boolean setDefaults)
          Sets the widths of the specified columns to automatically adjust to the largest column entry, including the header.
 void View.setColWidthTwips(int col1, int width)
          Changes the width of one or more columns to the specified number of twips.
 void View.setColWidthTwips(int col1, int col2, int width, boolean defColWidth)
          Changes the width of one or more columns to the specified number of twips.
 void View.setColWidthUnits(short colWidthUnits)
          Sets how the column width is stored and displayed.
 void View.setDefaultColWidth(int width)
          Sets the default column width.
 void View.setDefaultRowHeight(int height)
          Sets the default row height.
 void View.setDefaultRowHeightAutomatic(boolean automatic)
          Sets whether the default row height is determined automatically.
 void View.setDefinedName(java.lang.String name, java.lang.String formula)
          Sets the formula associated with a defined name, in US English.
 void View.setDefinedNameLocal(java.lang.String name, java.lang.String formula)
          Sets the formula definition for a user-defined name, in the user's language.
 void View.setEntry(java.lang.String entry)
          Enters text in the active cell of all selected worksheets.
 void View.setEntry(int row, int col, java.lang.String entry)
          Sets the value of a specified cell of all selected worksheets.
 void View.setEntry(int sheet, int row, int col, java.lang.String entry)
          Sets the value of a specified cell on the specified worksheet This method allows you to enter information in a cell just as a user would enter information.
 void View.setFixedCol(int col)
          Sets the number of fixed columns.
 void View.setFixedCols(int cols)
          Sets the number of fixed columns.
 void View.setFixedCols(int nCol1, int nCols)
          Sets the number of fixed columns.
 void View.setFixedRow(int row)
          Sets the starting fixed row.
 void View.setFixedRows(int rows)
          Sets the number of fixed rows.
 void View.setFixedRows(int nRow1, int nRows)
          Sets the number of fixed rows.
 void View.setFormatPaintMode(boolean isFormatPaintMode)
          Sets the Format Paint Mode.
 void View.setFormula(java.lang.String formula)
          Sets the formula for the active cell for all selected sheets.
 void View.setFormula(int row, int col, java.lang.String formula)
          Sets the formula for the specified cell in all selected sheets.
 void View.setFormula(int sheet, int row, int col, java.lang.String formula)
          Sets the formula for the specified cell on the specified sheet.
 void View.setFormulaLocal(java.lang.String formula)
          Sets the text version of the formula in the active cell, in the user's language.
 void View.setFormulaLocal(int row, int col, java.lang.String formula)
          Sets the text version of the formula of the specified cell, in the user's language.
 void View.setFormulaLocal(int sheet, int row, int col, java.lang.String formula)
          Sets the text version of the formula of the specified cell in the specified worksheet in the user's language.
 void View.setGroup(java.lang.String group)
          Sets the group name for the workbook attached to this view.
 void View.setHeaderHeight(int height)
          Sets the height of the column headers on all selected sheets.
 void View.setHeaderWidth(int width)
          Sets the width of the row headers of all selected sheets.
 void View.setLeftCol(int leftCol)
          Sets the leftmost column currently displayed in the view.
 void View.setLogical(boolean logical)
          Sets the logical (True or False) value of the active cell in all selected worksheets.
 void View.setLogical(int row, int col, boolean logical)
          Sets the logical (True or False) value of the specified cell in all selected worksheets.
 void View.setLogical(int sheet, int row, int col, boolean logical)
          Sets the logical (True or False) value of the specified cell in the specified worksheet.
 void View.setMaxCol(int maxCol)
          Sets the maximum column which may be displayed in the current sheet.
 void View.setMaxRow(int maxRow)
          Sets the maximum row which may be displayed in the current sheet.
 void View.setMinCol(int minCol)
          Sets the first column that can be displayed in the current worksheet.
 void View.setMinRow(int minRow)
          Sets the first row that can be displayed in the current worksheet.
 void View.setMode(short mode)
          Sets the current mode for mouse actions in a view
 void View.setNumber(double number)
          Sets the numeric value of the active cell in all selected sheets.
 void View.setNumber(int row, int col, double number)
          Sets the numeric value of the specified cell in all selected sheets.
 void View.setNumber(int sheet, int row, int col, double number)
          Sets the numeric value of the specified cell in the specified worksheet.
 void View.setNumSheets(int sheets)
          Sets the number of worksheets in the current workbook.
 void View.setPaletteEntry(int entry, java.awt.Color color)
          Sets a color in the JXCell color palette.
 void View.setPolyEditMode(short polyEditMode)
          Sets the mode for interactive polygon editing.
 void View.setPrintArea()
          Sets the current print area.
 void View.setPrintArea(java.lang.String formula)
          Sets the current print area to the specified range.
 void View.setPrintScale(int scale, boolean fitToPage, int verticalPages, int horizontalPages)
          Sets the scale factor for the active worksheet
 void View.setPrintScale(int scale)
          Sets the scale factor for the active worksheet To print a worksheet at the largest scale possible, set this value to 400 and setPrintScaleToFitPage to True.Then, specify the number of pages on which you want the worksheet printed.
 void View.setPrintScaleFitHPages(int horizontalPages)
          Sets the number of horizontal pages to which the print job is fit This value has no effect if setPrintScaleFitToPage is False.
 void View.setPrintScaleFitVPages(int verticalPages)
          Sets the number of vertical pages to which the print job is fit.
 void View.setPrintTitles()
          Sets the current selection to be 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.
 void View.setPrintTitles(java.lang.String formula)
          Sets the print titles to be printed at the top of each page
 void View.setRow(int row)
          Sets the row of the active cell.
 void View.setRowHeight(int row, int height)
          Sets the height of a single specified row.
 void View.setRowHeight(int row1, int row2, int height, boolean defRowHeight, boolean automatic)
          Sets the height of a range of rows.
 void View.setRowHeightAuto(int row1, int col1, int row2, int col2, boolean setDefaults)
          Specifies that the heights of the rows in the specified range are automatically set to display the tallest entry in the specified rows.
 void View.setRowHeightAutomatic(int row, boolean automatic)
          Specifies that the heights of the specified row is automatically set to display the tallest entry in the row.
 void View.setRowHidden(int row, boolean rowHidden)
          Changes the display status of the specified row.
 void View.setRowHidden(int row1, int row2, boolean rowHidden)
          Changes the display status of the specified rows.
 void View.setRowText(int row, java.lang.String rowText)
          Sets the name for the specified row.
 void View.setSelection(int row1, int col1, int row2, int col2)
          Selects the range represented by the specified parameters and moves the active cell to the top left cell in the range.
 void View.setSelectionLocal(java.lang.String string)
          Selects the range represented by the specified formula and moves the active cell to the top left cell in the range.
 void View.setSelEndCol(int selEndCol)
          Sets the last selected column.
 void View.setSelEndRow(int selEndRow)
          Sets the last selected row.
 void View.setSelStartCol(int selStartCol)
          Sets the first selected column.
 void View.setSelStartRow(int selStartRow)
          Sets the first selected row.
 void View.setSheet(int sheet)
          Sets the active worksheet.
 void View.setSheetName(int sheet, java.lang.String sheetName)
          Assigns a name to the specified worksheet .
 void View.setSheetSelected(int sheet, boolean selected)
          Sets which sheet is selected.
 void View.setShowHScrollBar(short showHScrollBar)
          Sets the mode for the horizontal scroll bar
 void View.setShowSelections(short showSelections)
          Sets the mode for highlighting selections.
 void View.setShowTabs(short showTabs)
          Sets the display status and position of the sheet name tabs on a workbook.
 void View.setShowVScrollBar(short showVScrollBar)
          Sets the mode for the vertical scroll bar.
 RangeRef View.setTabbedText(int row1, int col1, boolean valuesOnly, java.lang.String text)
          Places a block of tab-delimited text in a workbook.
 void View.setText(java.lang.String text)
          Sets the value of the active cell for all selected sheets.
 void View.setText(int row, int Col, java.lang.String text)
          Sets the value of the active cell for all selected sheets.
 void View.setText(int sheet, int row, int Col, java.lang.String text)
          Sets the value of the specified cell in the specified sheet.
 void View.setTopLeftText(java.lang.String topLeftText)
          Sets the text displayed at the intersection of the row and column headings in the top left corner of all selected sheets.
 void View.setTopRow(int leftRow)
          Sets the first row to display in this view.
 void View.setViewScale(int scale)
          Sets the current display scale for a workbook
 void View.showActiveCell()
          Positions the view to show the active cell if it is not currently displayed in the window.
 void View.sort(int row1, int col1, int row2, int col2, boolean sortByRows, int[] keys)
          Specifies a range of data to be sorted and the keys by which to sort the data.
 void View.sort3(int row1, int col1, int row2, int col2, boolean sortByRows, int keys, int key2, int key3)
          Specifies a range of data to be sorted and as many as three keys by which to sort the data.
 void View.transactCommit()
          Commits changes made during a transaction.
 void View.transactRollback()
          Undoes all changes made to a table since the last TransactStart method was called.
 void View.transactStart()
          Starts a transaction.
 int View.twipsToCharWidth(int nTwips)
          Converts twips (1/1440th of an inch) to character width based units.
 boolean View.writeURL(java.lang.String s1, int i1, java.lang.String s2, java.lang.String s3, short word0)
           
 boolean View.writeURL(java.lang.String s1, short word0)
           
 boolean View.writeURL(java.net.URL url, short word0)
           
 void View.write(java.io.OutputStream outputstream, short fileType)
          Saves the workbook to the specified output stream.
 void View.write(java.io.OutputStream outputstream, int sheet1, int row1, int col1, int sheet2, int row2, int col2, short fileType)
          Writes a range of data to the specified output stream.
 void View.write(java.lang.String pathName, short fileType)
          Saves the workbook to a file.
 void View.write(java.lang.String s, int sheet1, int row1, int col1, int sheet, int row2, int col2, short fileType)
          Writes specified portion of the workbook to a file.
 byte[] View.writeToBlob()
          Writes the workbook to a blob.
 void ValidationFailedEvent.setAction(short word0)
           
 void HTMLWriter.write(View view, int sheet1, int row1, int col1, int sheet2, int row2, int col2, java.io.Writer writer)
          Write the specified range to an HTML table
 boolean CellFormat.isUndefined(short property)
          Returns whether a CellFormat attribute has been defined.
 void CellFormat.setBottomBorder(short bottom)
          Sets the style for the bottom border.
 void CellFormat.setBottomBorderColor(java.awt.Color color)
          Sets the color used to display the bottom edge of the cell.
 void CellFormat.setFontSize(int size)
          Sets the font size.
 void CellFormat.setFontSizeInPoints(double size)
          Sets the font size in points.
 void CellFormat.setHorizontalAlignment(short alignment)
          Sets the horizontal alignment.
 void CellFormat.setHorizontalInsideBorder(short horizontalInside)
          Sets the horizontal inside border.
 void CellFormat.setLeftBorder(short left)
          Sets the style for the left border
 void CellFormat.setNumberFormat(java.lang.String format)
          Sets the number format string in U.
 void CellFormat.setNumberFormatLocal(java.lang.String format)
          Sets the number format string in the user's local language Each format string can have as many as four sections: one for positive numbers, one for negative numbers, one for zeros, and one for text.
 void CellFormat.setPattern(short pattern1)
          Sets the pattern type
 void CellFormat.setRightBorder(short right)
          Sets the style for the right border.
 void CellFormat.setRightBorderColor(java.awt.Color color)
          Sets the color used to display the right edge of the cell.
 void CellFormat.setTopBorder(short top)
          Sets the style for the bottom border
 void CellFormat.setTopBorderColor(java.awt.Color color)
          Sets the color used to display the top edge of the cell.
 void CellFormat.setUndefined(short property, boolean undefined)
          Sets whether a cell format attribute has been defined
 void CellFormat.setValidationRule(View view1, java.lang.String rule)
          Sets the validation rule expression in U.
 void CellFormat.setValidationRule(View view1, java.lang.String rule, int row, int col)
          Sets the validation rule expression in U.
 void CellFormat.setVerticalAlignment(short alignment)
          Sets the type of vertical alignment
 void CellFormat.setVerticalInsideBorder(short verticalInside)
          Sets the border type for the vertical inside border
 void CellFormat.setVerticalInsideBorderColor(java.awt.Color verticalInside)
          Sets the color used to display the vertical inside border