|
|||||||||||
PREV NEXT | FRAMES NO FRAMES |
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 |
|
|||||||||||
PREV NEXT | FRAMES NO FRAMES |