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

S

SelectionChangedEvent - class com.jxcell.SelectionChangedEvent.
This event occurs when the selection changes
SelectionChangedListener - interface com.jxcell.SelectionChangedListener.
The listener interface for receiving SelectionChanged events

SeriesScale - Static variable in class com.jxcell.ChartShape
 
SetErrorText(int, String) - Method in class com.jxcell.View
set error text of the corresponding to the specified error number
ShapeFormat - class com.jxcell.ShapeFormat.
This class represents a picture shape object.
ShapeObj - class com.jxcell.ShapeObj.
This class is base class of drawing Format.
ShapePos - class com.jxcell.ShapePos.
the shape placement position
SheetStateHidden - Static variable in class com.jxcell.View
 
SheetStateShown - Static variable in class com.jxcell.View
 
SheetStateVeryHidden - Static variable in class com.jxcell.View
 
ShiftColumns - Static variable in class com.jxcell.View
 
ShiftHorizontal - Static variable in class com.jxcell.View
 
ShiftRows - Static variable in class com.jxcell.View
 
ShiftVertical - Static variable in class com.jxcell.View
 
ShowAutomatic - Static variable in class com.jxcell.View
 
ShowOff - Static variable in class com.jxcell.View
 
ShowOn - Static variable in class com.jxcell.View
 
StartEditEvent - class com.jxcell.StartEditEvent.
This class defines the means to notify registered listeners whenever a cell is about to be edited by the user
StartEditListener - interface com.jxcell.StartEditListener.
The listener interface for receiving StartEdit events

StartRecalcEvent - class com.jxcell.StartRecalcEvent.
This event occurs when the recalculation process is started
StartRecalcListener - interface com.jxcell.StartRecalcListener.
The listener interface for receiving StartRecalc events

saveWindowInfo() - Method in class com.jxcell.View
 
seText(String) - Method in class com.jxcell.FormControlShape
set the lable of the control
selectionChanged(SelectionChangedEvent) - Method in interface com.jxcell.SelectionChangedListener
This method is called whenever the current selection in the worksheet is changed
selectionChanged(ViewEvent) - Method in class com.jxcell.View
 
serialVersionUID - Static variable in class com.jxcell.JBookApplet
 
serialVersionUID - Static variable in class com.jxcell.View
 
set3Dimensional(boolean) - Method in class com.jxcell.ChartShape
Sets whether the chart is 3 dimensional or not.
setAction(short) - Method in class com.jxcell.ValidationFailedEvent
This method sets the action taken by Formula One when validation fails
setActiveCell(int, int) - Method in class com.jxcell.View
Sets the row and column coordinates of the active cell The active cell is the cell in which the cursor is currently located.
setAllowAutoFill(boolean) - Method in class com.jxcell.View
Sets a value indicating whether auto fill is enabled.
setAllowDelete(boolean) - Method in class com.jxcell.View
Sets a value indicating whether the delete key clears selections.
setAllowFillRange(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether users are allowed to fill a range by clicking and dragging with the mouse.
setAllowFormulas(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether the user is allowed to enter and edit formulas.
setAllowInCellEditing(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether cells are edited in place.
setAllowMoveRange(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether users are allowed to move a range by clicking and dragging with the mouse
setAllowObjectSelections(boolean) - Method in class com.jxcell.View
Sets a flag indicating whether you can select objects at run time.
setAllowResize(boolean) - Method in class com.jxcell.View
Sets a value indicating whether you can resize rows and columns by dragging them.
setAllowSelections(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether a user is allowed to change the selections with the keyboard or mouse.
setAllowTabs(boolean) - Method in class com.jxcell.View
Sets a value indicating whether you can use the TAB key to reposition the active cell in a selected range.
setArrayFormula(int, int, int, int, String) - Method in class com.jxcell.View
Sets the array formula for the specified range.
setArrowLength(short) - Method in class com.jxcell.GRObject
 
setArrowStyle(short) - Method in class com.jxcell.GRObject
 
setArrowWidth(short) - Method in class com.jxcell.GRObject
 
setAutoFillItems(int, String) - Method in class com.jxcell.View
Sets an autofill list.
setAutoMaximumScale(short, int, boolean) - Method in class com.jxcell.ChartShape
Sets whether the upper limit of the scale of the specified axis is automatically calculated.
setAutoMaximumScale(short, int, boolean) - Method in class com.jxcell.GRChart
 
setAutoMinimumScale(short, int, boolean) - Method in class com.jxcell.ChartShape
Sets whether the lower limit of the scale of the selected axis is automatically calculated.
setAutoMinimumScale(short, int, boolean) - Method in class com.jxcell.GRChart
 
setAutoRecalc(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether or not automatic recalc is on.
setAutoSize(boolean) - Method in class com.jxcell.GRObject
 
setAxisFormat(int, int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets formatting for the specified axis.
setAxisFormat(short, int, ChartFormat) - Method in class com.jxcell.GRChart
Sets AxisImpl formatting.
setAxisLengthRatio(int) - Method in class com.jxcell.ChartShape
Sets the ratio of the area taken up on the selected axis.
setAxisLengthRatio(short, int, int) - Method in class com.jxcell.ChartShape
Sets the ratio of the area taken up on the specified axis.
setAxisScaleCrosses(short, int, boolean, double) - Method in class com.jxcell.ChartShape
Sets the crosses value for the specified axis.
setAxisScaleType(short) - Method in class com.jxcell.ChartShape
Sets the axis scale type for the selected axis.
setAxisScaleType(short, int, short) - Method in class com.jxcell.ChartShape
Sets the axis scale type for the specified axis.
setAxisTitle(short, int, String) - Method in class com.jxcell.ChartShape
Sets the title of the specified axis.
setAxisTitle(short, int, String) - Method in class com.jxcell.GRChart
Sets the AxisImpl title
setAxisTitleFormat(short, int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets the formatting for the title of the specified axis.
setAxisVisible(boolean) - Method in class com.jxcell.ChartShape
Sets whether the selected axis is visible.
setAxisVisible(short, int, boolean) - Method in class com.jxcell.ChartShape
Sets whether the specified axis is visible.
setBackColor(int) - Method in class com.jxcell.ChartFormat
Sets the color used to display the pattern background.
setBackColor(Color) - Method in class com.jxcell.View
Sets the background color.
setBarGapRatio(int) - Method in class com.jxcell.ChartShape
Sets the bar gap ratio on a bar or column chart.
setBarGapRatio(int) - Method in class com.jxcell.GRChart
Sets the bar gap ratio on a bar or column chart.
setBorder(boolean) - Method in class com.jxcell.View
Sets wether the workbook has a border painted around it.
setBottomBorder(short) - Method in class com.jxcell.CellFormat
Sets the style for the bottom border.
setBottomBorderColor(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the bottom edge of the cell.
setBottomBorderColor(Color) - Method in class com.jxcell.CellFormat
 
setBoundsWithClip(int, int, int, int, int, int, int, int) - Method in class com.jxcell.View
 
setCanceled(boolean) - Method in class com.jxcell.EndEditEvent
Specifies whether edit mode is to continue
setCanceled(boolean) - Method in class com.jxcell.StartEditEvent
Specifies whether the StartEdit event is to be canceled
setCategoryFormula(String) - Method in class com.jxcell.ChartShape
Links the chart categories to the specified formula.
setCategoryFormula(String) - Method in class com.jxcell.GRChart
Links the chart categories to the specified formula.
setCategoryFormulaLocal(String) - Method in class com.jxcell.GRChart
Links the chart categories to the specified formula, in the user's language
setCell(short, int, int) - Method in class com.jxcell.GRObject
 
setCell(String) - Method in class com.jxcell.GRObject
 
setCell(short, String) - Method in class com.jxcell.GRObject
 
setCellCol(int) - Method in class com.jxcell.GRObject
 
setCellFormat(CellFormat) - Method in class com.jxcell.ConditionFormat
Sets formatting options for this conditional format from the specified RangeStyle object.
setCellFormat(CellFormat) - Method in class com.jxcell.View
Sets the format of the selected range of cells
setCellFormat(CellFormat, int, int, int, int) - Method in class com.jxcell.View
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.
setCellFormat(CellFormat, int, int, int, int, int, int) - Method in class com.jxcell.View
Sets the format of the specified range of cells in the specified range of sheets
setCellFormats(Action) - Method in class com.jxcell.CellFormat
 
setCellLink(String) - Method in class com.jxcell.FormControlShape
set the link cell of the control
setCellRange(String) - Method in class com.jxcell.FormControlShape
set the source range link to the control
setCellRow(int) - Method in class com.jxcell.GRObject
 
setCellType(short) - Method in class com.jxcell.GRObject
 
setChart3DType(short) - Method in class com.jxcell.GRChart
 
setChartFormat(ChartFormat) - Method in class com.jxcell.ChartShape
Sets chart formatting.
setChartFormat(ChartFormat) - Method in class com.jxcell.GRChart
Sets chart formatting.
setChartSheet(int) - Method in class com.jxcell.View
 
setChartType(short) - Method in class com.jxcell.ChartShape
A constant designating a chart type.
setChartType(short) - Method in class com.jxcell.GRChart
Sets the chart type
setClip(String) - Method in class com.jxcell.View
Exports a tab-delimited text block to a worksheet at run time.
setClipValues(String) - Method in class com.jxcell.View
Exports tab-delimited text strings to a workbook at run time ignoring any formatting applied to the text.
setClipboard(Clipboard) - Static method in class com.jxcell.View
Sets the clipboard to be used for clipboard operations.
setCol(int) - Method in class com.jxcell.View
Sets the column of the active cell.
setCol1(int) - Method in class com.jxcell.RangeRef
 
setCol2(int) - Method in class com.jxcell.RangeRef
 
setColHeaderSelected(boolean) - Method in class com.jxcell.View
Sets a value indicating whether or not column headers can be selected.
setColHidden(int, int, boolean) - Method in class com.jxcell.View
Sets the display status of the specified range of columns
setColHidden(int, boolean) - Method in class com.jxcell.View
Sets a value indicating whether or not the specified column is hidden.
setColOutlineLevel(int, int, int, boolean) - Method in class com.jxcell.View
Sets the outline level of a range of columns.
setColText(int, String) - Method in class com.jxcell.View
Sets the label for a column.
setColWidth(int, int) - Method in class com.jxcell.View
Sets the width of a single column.
setColWidth(int, int, int, boolean) - Method in class com.jxcell.View
Sets the width of a single column.
setColWidthAuto(int, int, int, int, boolean) - Method in class com.jxcell.View
Sets the widths of the specified columns to automatically adjust to the largest column entry, including the header.
setColWidthTwips(int, int) - Method in class com.jxcell.View
Changes the width of one or more columns to the specified number of twips.
setColWidthTwips(int, int, int, boolean) - Method in class com.jxcell.View
Changes the width of one or more columns to the specified number of twips.
setColWidthUnits(short) - Method in class com.jxcell.View
Sets how the column width is stored and displayed.
setConditionalFormats(ConditionFormat[]) - Method in class com.jxcell.View
Sets the specified conditional formats for the current selection.
setCustomFormat(String) - Method in class com.jxcell.CellFormat
Sets the number format string.
setCustomFormat(String) - Method in class com.jxcell.ChartFormat
Sets the number format string
setDataLabelFormat(int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets data label formatting for the specified series.
setDataLabelFormat(int, int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets data label formatting for the specified data point.
setDataLabelFormat(int, ChartFormat) - Method in class com.jxcell.GRChart
Sets the data label formatting information of the specified series
setDataLabelFormat(int, int, ChartFormat) - Method in class com.jxcell.GRChart
Sets the data label formatting information for the specified point of the specified series
setDataLabelPosition(short) - Method in class com.jxcell.ChartFormat
Sets position of the data label.
setDataLabelSeparator(String) - Method in class com.jxcell.ChartFormat
Sets the data label separator.
setDataLabelText(int, int, String, boolean) - Method in class com.jxcell.ChartShape
Sets data label text for the specified data point.
setDataLabelType(short) - Method in class com.jxcell.ChartFormat
Sets the type of data label to use.
setDataLabelTypes(int) - Method in class com.jxcell.ChartFormat
Sets the types of data label to use.
setDataLableType(int) - Method in class com.jxcell.ChartShape
Sets the type of data label to use
setDataLableType(int) - Method in class com.jxcell.GRChart
Sets the type of data label to use
setDataPointFormat(int, int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets formatting for the specified data point.
setDataValidation(DataValidation) - Method in class com.jxcell.View
Sets the specified data validations for the current selection.
setDefaultColWidth(int) - Method in class com.jxcell.View
Sets the default column width.
setDefaultFont(String, int) - Method in class com.jxcell.View
Sets the default font and the font size.
setDefaultFontName(String) - Method in class com.jxcell.View
Sets the default font by name.
setDefaultFontSize(int) - Method in class com.jxcell.View
Sets the default font size.
setDefaultRowHeight(int) - Method in class com.jxcell.View
Sets the default row height.
setDefaultRowHeightAutomatic(boolean) - Method in class com.jxcell.View
Sets whether the default row height is determined automatically.
setDefinedName(String, String) - Method in class com.jxcell.View
Sets the formula associated with a defined name, in US English.
setDefinedNameLocal(String, String) - Method in class com.jxcell.View
Sets the formula definition for a user-defined name, in the user's language.
setDescription(String) - Method in class com.jxcell.CellException
 
setDropLinesFormat(ChartFormat) - Method in class com.jxcell.ChartShape
Sets drop line formatting.
setDropLinesVisible(boolean) - Method in class com.jxcell.ChartShape
Sets whether drop lines are visible.
setEditString(String) - Method in class com.jxcell.EndEditEvent
Specifies the edit string to be entered in the active cell
setEditString(String) - Method in class com.jxcell.StartEditEvent
Specifies the edit string to be entered in the active cell
setEnableProtection(boolean) - Method in class com.jxcell.View
Sets whether protection is enabled for all selected sheets.
setEnterMovesDown(boolean) - Method in class com.jxcell.View
Sets whether pressing the ENTER key moves the active cell down to the next cell.
setEntry(String) - Method in class com.jxcell.ValidationFailedEvent
This method can be used within the ValidationFailed event to set the entry to a new value if the setAction method is set to 3 - retry validation.
setErrorBars(int, boolean, int, boolean, String) - Method in class com.jxcell.ChartShape
set the errorbar informations
setErrorBars(int, boolean, int, boolean, int, int) - Method in class com.jxcell.ChartShape
set the errorbar informations
setErrorBars(int, boolean, int, boolean, String) - Method in class com.jxcell.GRChart
set the errorbar informations
setErrorBars(int, boolean, int, boolean, int, int) - Method in class com.jxcell.GRChart
set the errorbar informations
setErrorBoxText(String) - Method in class com.jxcell.DataValidation
 
setErrorBoxTitle(String) - Method in class com.jxcell.DataValidation
 
setErrorStyle(int) - Method in class com.jxcell.DataValidation
 
setExplosion(int) - Method in class com.jxcell.ChartShape
Sets the explosion percentage.
setExtraColor(Color) - Method in class com.jxcell.View
Sets the color used to fill any extra space to the right and below the sheet.
setFillAuto(boolean) - Method in class com.jxcell.ChartFormat
Sets whether fill is auto.
setFillShadow(boolean) - Method in class com.jxcell.ChartFormat
Sets whether an object includes a shadow behind it.
setFixedCol(int) - Method in class com.jxcell.View
Sets the number of fixed columns.
setFixedCols(int) - Method in class com.jxcell.View
Sets the number of fixed columns.
setFixedCols(int, int) - Method in class com.jxcell.View
Sets the number of fixed columns.
setFixedRow(int) - Method in class com.jxcell.View
Sets the starting fixed row.
setFixedRows(int) - Method in class com.jxcell.View
Sets the number of fixed rows.
setFixedRows(int, int) - Method in class com.jxcell.View
Sets the number of fixed rows.
setFontAutoScale(boolean) - Method in class com.jxcell.ChartFormat
Sets whether fonts are automatically scaled based on chart size.
setFontBold(boolean) - Method in class com.jxcell.CellFormat
Sets the bold attribute of the font.
setFontBold(boolean) - Method in class com.jxcell.ChartFormat
Sets the bold attribute of the font.
setFontBold(boolean) - Method in class com.jxcell.GRObject
 
setFontBold(boolean, int, int) - Method in class com.jxcell.GRObject
 
setFontCharSet(int) - Method in class com.jxcell.CellFormat
Sets the font charset.
setFontColor(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the font.
setFontColor(Color) - Method in class com.jxcell.CellFormat
 
setFontColor(int) - Method in class com.jxcell.ChartFormat
Sets the color used to display the font.
setFontColor(int) - Method in class com.jxcell.GRObject
 
setFontColor(int, int, int) - Method in class com.jxcell.GRObject
 
setFontItalic(boolean) - Method in class com.jxcell.CellFormat
Sets the italic attribute of the font.
setFontItalic(boolean) - Method in class com.jxcell.ChartFormat
Sets the italic attribute of the font.
setFontItalic(boolean) - Method in class com.jxcell.GRObject
 
setFontItalic(boolean, int, int) - Method in class com.jxcell.GRObject
 
setFontName(String) - Method in class com.jxcell.CellFormat
Sets the font name.
setFontName(String) - Method in class com.jxcell.ChartFormat
Sets the font name.
setFontName(String) - Method in class com.jxcell.GRObject
 
setFontName(String, int, int) - Method in class com.jxcell.GRObject
 
setFontSize(int) - Method in class com.jxcell.CellFormat
Sets the font size in twips.
setFontSize(int) - Method in class com.jxcell.ChartFormat
Sets the font size in twips.
setFontSize(int) - Method in class com.jxcell.GRObject
 
setFontSize(int, int, int) - Method in class com.jxcell.GRObject
 
setFontSizeInPoints(double) - Method in class com.jxcell.ChartFormat
 
setFontStrikeout(boolean) - Method in class com.jxcell.CellFormat
Sets the strikeout attribute of the font.
setFontUnderline(short) - Method in class com.jxcell.CellFormat
Sets the underline attribute of the font.
setFontUnderline(boolean) - Method in class com.jxcell.ChartFormat
Sets the underline attribute of the font.
setFontUnderline(boolean) - Method in class com.jxcell.GRObject
 
setFontUnderline(boolean, int, int) - Method in class com.jxcell.GRObject
 
setForeColor(int) - Method in class com.jxcell.ChartFormat
Sets the color used to display the pattern foreground.
setFormat() - Method in class com.jxcell.GRObject
 
setFormat() - Method in class com.jxcell.ShapeObj
Sets the Format for this shape.
setFormatPaintMode(boolean) - Method in class com.jxcell.View
Sets the Format Paint Mode.
setFormula(int, int, int, String) - Method in class com.jxcell.View
Sets the formula for the specified cell on the specified sheet.
setFormula(int, int, String) - Method in class com.jxcell.View
Sets the formula for the specified cell in all selected sheets.
setFormula(String) - Method in class com.jxcell.View
Sets the formula for the active cell for all selected sheets.
setFormula1(String, int, int) - Method in class com.jxcell.ConditionFormat
Sets the first formula associated with this conditional format
setFormula1(String) - Method in class com.jxcell.DataValidation
 
setFormula2(String, int, int) - Method in class com.jxcell.ConditionFormat
Sets the second formula associated with this conditional format
setFormula2(String) - Method in class com.jxcell.DataValidation
 
setFormulaLocal(int, int, int, String) - Method in class com.jxcell.View
Sets the text version of the formula of the specified cell in the specified worksheet in the user's language.
setFormulaLocal(int, int, String) - Method in class com.jxcell.View
Sets the text version of the formula of the specified cell, in the user's language.
setFormulaLocal(String) - Method in class com.jxcell.View
Sets the text version of the formula in the active cell, in the user's language.
setGradient() - Method in class com.jxcell.ChartFormat
Sets the fill to Gradient.
setGroup(String) - Method in class com.jxcell.View
Sets the group name for the workbook attached to this view.
setHeaderHeight(int) - Method in class com.jxcell.View
Sets the height of the column headers on all selected sheets.
setHeaderSelection(boolean, boolean, boolean) - Method in class com.jxcell.View
Sets whether the row and column headings are selected.
setHeaderWidth(int) - Method in class com.jxcell.View
Sets the width of the row headers of all selected sheets.
setHidden(boolean) - Method in class com.jxcell.CellFormat
Sets the hidden cell flag
setHorizontalAlignment(short) - Method in class com.jxcell.CellFormat
Sets the horizontal alignment.
setHorizontalAlignment(int) - Method in class com.jxcell.GRObject
 
setHorizontalInsideBorder(short) - Method in class com.jxcell.CellFormat
Sets the horizontal inside border style.
setHorizontalInsideBorderColor(int) - Method in class com.jxcell.CellFormat
Sets the color of the horizontal inside border.
setImage(byte[]) - Method in class com.jxcell.GRObject
 
setImage(InputStream) - Method in class com.jxcell.GRObject
 
setImageFileName(String) - Method in class com.jxcell.GRObject
 
setImageURL(String) - Method in class com.jxcell.GRObject
 
setIndent(int) - Method in class com.jxcell.CellFormat
 
setItem(int, String) - Method in class com.jxcell.GRObject
 
setItems(String) - Method in class com.jxcell.GRObject
 
setIterationEnabled(boolean) - Method in class com.jxcell.View
Sets whether iteration is enabled.
setIterationMax(int) - Method in class com.jxcell.View
Sets the maximum number of iterations.
setIterationMaxChange(double) - Method in class com.jxcell.View
Sets the maximum iteration change value.
setLeftBorder(short) - Method in class com.jxcell.CellFormat
Sets the style for the left border.
setLeftBorderColor(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the left edge of the cell.
setLeftBorderColor(Color) - Method in class com.jxcell.CellFormat
 
setLeftCol(int) - Method in class com.jxcell.View
Sets the leftmost column currently displayed in the view.
setLegendFormat(ChartFormat) - Method in class com.jxcell.ChartShape
Sets legend formatting.
setLegendFormat(ChartFormat) - Method in class com.jxcell.GRChart
Sets legend formatting.
setLegendPos(int) - Method in class com.jxcell.GRChart
Sets legend placement.
setLegendPosition(short) - Method in class com.jxcell.ChartShape
set legend position
setLegendVisible(boolean) - Method in class com.jxcell.ChartShape
Sets whether legend is visible.
setLegendVisible(boolean) - Method in class com.jxcell.GRChart
Sets whether legend is visible.
setLineAuto() - Method in class com.jxcell.ChartFormat
set line auto
setLineAuto(boolean) - Method in class com.jxcell.GRObject
 
setLineColor(int) - Method in class com.jxcell.ChartFormat
Sets the color.
setLineColor(int) - Method in class com.jxcell.GRObject
 
setLineCustom() - Method in class com.jxcell.ChartFormat
set line custom style and weight
setLineNone() - Method in class com.jxcell.ChartFormat
set line none
setLineStyle(short) - Method in class com.jxcell.ChartFormat
Sets the style.
setLineStyle(short) - Method in class com.jxcell.GRObject
 
setLineWeight(int) - Method in class com.jxcell.ChartFormat
Sets the weight.
setLineWeight(int) - Method in class com.jxcell.GRObject
 
setLinkRange(String, boolean) - Method in class com.jxcell.ChartShape
Links the chart to the range in the workbook represented by the specified formula.
setLinkRange(String, boolean) - Method in class com.jxcell.GRChart
Links the chart to the range in the workbook represented by the specified formula.
setLinkRangeLocal(String, boolean) - Method in class com.jxcell.GRChart
Links the chart to the range in the workbook represented by the specified formula.
setLinkString(String) - Method in class com.jxcell.HyperLink
set the hyperlink's link string
setLinkedToDataSource(boolean) - Method in class com.jxcell.ChartFormat
Sets whether the object gets the value format from the data source.
setLocked(boolean) - Method in class com.jxcell.CellFormat
Sets the locked cell flag
setLogScale(boolean) - Method in class com.jxcell.ChartShape
Sets the axis to logarithmic base.
setLogScale(boolean) - Method in class com.jxcell.GRChart
Sets the axis to logarithmic base.
setLogical(int, int, int, boolean) - Method in class com.jxcell.View
Sets the logical (True or False) value of the specified cell in the specified worksheet.
setLogical(int, int, boolean) - Method in class com.jxcell.View
Sets the logical (True or False) value of the specified cell in all selected worksheets.
setLogical(boolean) - Method in class com.jxcell.View
Sets the logical (True or False) value of the active cell in all selected worksheets.
setMajorGridFormat(short, int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets grid line formatting information for the major grid of the specified axis.
setMajorGridFormat(short, int, ChartFormat) - Method in class com.jxcell.GRChart
Sets AxisImpl grid line formatting.
setMajorGridVisible(boolean) - Method in class com.jxcell.ChartShape
Sets whether the major grid lines of the selected axis are visible.
setMajorGridVisible(short, int, boolean) - Method in class com.jxcell.ChartShape
Sets whether the major grid lines of the specified axis are visible.
setMarkerAuto(boolean) - Method in class com.jxcell.ChartFormat
Sets the marker type to be assigned automatically.
setMarkerBackground(int) - Method in class com.jxcell.ChartFormat
Sets marker background color as an RGB value.
setMarkerForeground(int) - Method in class com.jxcell.ChartFormat
Sets marker foreground color as an RGB value.
setMarkerSize(int) - Method in class com.jxcell.ChartFormat
Sets marker size in twips.
setMarkerStyle(short) - Method in class com.jxcell.ChartFormat
Sets marker style.
setMaxCol(int) - Method in class com.jxcell.View
Sets the maximum column which may be displayed in the current sheet.
setMaxRow(int) - Method in class com.jxcell.View
Sets the maximum row which may be displayed in the current sheet.
setMergeCells(boolean) - Method in class com.jxcell.CellFormat
Sets the mergeCells attribute.
setMessage(int, Group, int, String) - Static method in class com.jxcell.CellException
 
setMessage(String) - Method in class com.jxcell.ValidationFailedEvent
This method sets the message returned when validation fails
setMinCol(int) - Method in class com.jxcell.View
Sets the first column that can be displayed in the current worksheet.
setMinRow(int) - Method in class com.jxcell.View
Sets the first row that can be displayed in the current worksheet.
setMinorGridFormat(short, int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets grid line formatting information for the minor grid of the specified axis.
setMinorGridVisible(boolean) - Method in class com.jxcell.ChartShape
Sets whether the minor grid lines of the selected axis are visible.
setMinorGridVisible(short, int, boolean) - Method in class com.jxcell.ChartShape
Sets whether the minor grid lines of the specified axis are visible.
setMode(short) - Method in class com.jxcell.View
Sets the current mode for mouse actions in a view
setMultipleSelections(boolean) - Method in class com.jxcell.GRObject
 
setName(String) - Method in class com.jxcell.GRObject
 
setNumSheets(int) - Method in class com.jxcell.View
Sets the number of worksheets in the current workbook.
setNumber(double) - Method in class com.jxcell.View
Sets the numeric value of the active cell in all selected sheets.
setNumber(int, int, double) - Method in class com.jxcell.View
Sets the numeric value of the specified cell in all selected sheets.
setNumber(int, int, int, double) - Method in class com.jxcell.View
Sets the numeric value of the specified cell in the specified worksheet.
setOperator(short) - Method in class com.jxcell.ConditionFormat
Sets the operator for this conditional format.
setOperator(int) - Method in class com.jxcell.DataValidation
 
setOrientation(short) - Method in class com.jxcell.CellFormat
Sets the orientation type.
setOrientation(int) - Method in class com.jxcell.ChartFormat
 
setPaletteEntry(int, Color) - Method in class com.jxcell.View
Sets a color in the jxcell color palette.
setPattern(short) - Method in class com.jxcell.CellFormat
Sets the pattern type.
setPattern(short) - Method in class com.jxcell.ChartFormat
Sets the pattern.
setPattern(short) - Method in class com.jxcell.GRObject
 
setPatternAuto(boolean) - Method in class com.jxcell.CellFormat
 
setPatternAuto(boolean) - Method in class com.jxcell.ChartFormat
 
setPatternBG(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the pattern background.
setPatternBG(Color) - Method in class com.jxcell.CellFormat
 
setPatternBG(int) - Method in class com.jxcell.GRObject
 
setPatternFG(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the pattern foreground.
setPatternFG(Color) - Method in class com.jxcell.CellFormat
 
setPatternFG(int) - Method in class com.jxcell.ChartFormat
 
setPatternFG(int) - Method in class com.jxcell.GRObject
 
setPatternURL(String) - Method in class com.jxcell.GRObject
 
setPercent(boolean) - Method in class com.jxcell.ChartShape
Sets boolean indicating whether the values in the chart are plotted as percentages of the category.
setPercent(boolean) - Method in class com.jxcell.GRChart
Sets boolean indicating whether the values in the chart are plotted as percentages of the category.
setPieExplosion(int, int) - Method in class com.jxcell.ChartShape
Sets the explosion percentage of the specified data point.
setPieExplosion(int, int) - Method in class com.jxcell.GRChart
Sets the explosion percentage of the specified data point.
setPlacementStyle(int) - Method in class com.jxcell.ShapeFormat
 
setPlotFormat(ChartFormat) - Method in class com.jxcell.ChartShape
Sets plot formatting.
setPlotFormat(ChartFormat) - Method in class com.jxcell.GRChart
Sets plot formatting.
setPlotGroupStack(int, boolean) - Method in class com.jxcell.ChartShape
Sets the selected PlotGroup to display stacked series.
setPlotStacked(boolean) - Method in class com.jxcell.ChartShape
Sets the selected plot to display stacked series.
setPoints(Point[], boolean) - Method in class com.jxcell.GRObject
 
setPolyEditMode(short) - Method in class com.jxcell.View
Sets the mode for interactive polygon editing.
setPos(double, double, double, double) - Method in class com.jxcell.GRObject
 
setPosition(double, double, double, double) - Method in class com.jxcell.ShapeObj
set the shape position
setPrecisionAsDisplayed(boolean) - Method in class com.jxcell.View
Determines whether cell values are stored as entered or as displayed
setPrintArea() - Method in class com.jxcell.View
Sets the current print area.
setPrintArea(String) - Method in class com.jxcell.View
Sets the current print area to the specified range.
setPrintAreaLocal(String) - Method in class com.jxcell.View
Sets the current print area to the specified range in user language.
setPrintBottomMargin(double) - Method in class com.jxcell.View
Sets the bottom print margin.
setPrintColHeading(boolean) - Method in class com.jxcell.View
Determines whether column headings are printed.
setPrintFooter(String) - Method in class com.jxcell.View
Sets the current page footer The following list shows the special codes the footer text can contain.
setPrintFooterMargin(double) - Method in class com.jxcell.View
Sets the page footer margin used during printing The header and footer margins can be printed.
setPrintGridLines(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether or not grid lines are printed for the current sheet.
setPrintHCenter(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether or not the current sheet is centered horizontally when printed.
setPrintHeader(String) - Method in class com.jxcell.View
Sets the page header printed at the top of each page The following list shows the special codes the footer text can contain.
setPrintHeaderMargin(double) - Method in class com.jxcell.View
Sets the page header margin used during printing The header and footer margins can be printed.
setPrintLandscape(boolean) - Method in class com.jxcell.View
Determines the direction of the print job.
setPrintLeftMargin(double) - Method in class com.jxcell.View
Sets the left print margin.
setPrintLeftToRight(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether the current sheet is to be printed left to right then top to bottom, or top to bottom then left to right.
setPrintNoColor(boolean) - Method in class com.jxcell.View
Determines whether job is printed in color or black and white Color formats are translated by the printer driver and printed as patterns.
setPrintPaperSize(int, int) - Method in class com.jxcell.View
Sets the size of the paper in twips.
setPrintRightMargin(double) - Method in class com.jxcell.View
Sets the right print margin.
setPrintRowHeading(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether or not row headings are printed for the current sheet.
setPrintScale(int) - Method in class com.jxcell.View
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.
setPrintScale(int, boolean, int, int) - Method in class com.jxcell.View
Sets the scale factor for the active worksheet
setPrintScaleFitHPages(int) - Method in class com.jxcell.View
Sets sets whether pages are scaled to fit the specified number of pages when printed.
setPrintScaleFitToPage(boolean) - Method in class com.jxcell.View
Sets the number of horizontal pages to which the print job is fit This value has no effect if setPrintScaleFitToPage is False.
setPrintScaleFitVPages(int) - Method in class com.jxcell.View
Sets the number of vertical pages to which the print job is fit.
setPrintTitles() - Method in class com.jxcell.View
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.
setPrintTitles(String) - Method in class com.jxcell.View
Sets the print titles to be printed at the top of each page
setPrintTitlesLocal(String) - Method in class com.jxcell.View
Sets the print titles to be printed at the top of each page in user language
setPrintTopMargin(double) - Method in class com.jxcell.View
Sets the top print margin.
setPrintVCenter(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether or not the current sheet is centered verticall when printed.
setPromtBoxText(String) - Method in class com.jxcell.DataValidation
 
setPromtBoxTitle(String) - Method in class com.jxcell.DataValidation
 
setRange(int, int, int, int) - Method in class com.jxcell.HyperLink
set the hyperlink range
setRepaint(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether or not this view is painted.
setRightBorder(short) - Method in class com.jxcell.CellFormat
Sets the style for the right border.
setRightBorderColor(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the right edge of the cell.
setRightBorderColor(Color) - Method in class com.jxcell.CellFormat
 
setRow(int) - Method in class com.jxcell.View
Sets the row of the active cell.
setRow1(int) - Method in class com.jxcell.RangeRef
 
setRow2(int) - Method in class com.jxcell.RangeRef
 
setRowHeaderSelected(boolean) - Method in class com.jxcell.View
Determines if the row header is selected.
setRowHeight(int, int) - Method in class com.jxcell.View
Sets the height of a single specified row.
setRowHeight(int, int, int, boolean, boolean) - Method in class com.jxcell.View
Sets the height of a range of rows.
setRowHeightAuto(int, int, int, int, boolean) - Method in class com.jxcell.View
Specifies that the heights of the rows in the specified range are automatically set to display the tallest entry in the specified rows.
setRowHeightAutomatic(int, boolean) - Method in class com.jxcell.View
Specifies that the heights of the specified row is automatically set to display the tallest entry in the row.
setRowHidden(int, int, boolean) - Method in class com.jxcell.View
Changes the display status of the specified rows.
setRowHidden(int, boolean) - Method in class com.jxcell.View
Changes the display status of the specified row.
setRowOutlineLevel(int, int, int, boolean) - Method in class com.jxcell.View
Sets the outline level of a range of rows.
setRowText(int, String) - Method in class com.jxcell.View
Sets the name for the specified row.
setScaleMajorUnit(short, int, double) - Method in class com.jxcell.ChartShape
set the major scale unit of the selected axis.
setScaleMajorUnitAuto(short, int, boolean) - Method in class com.jxcell.ChartShape
 
setScaleMinorUnit(short, int, double) - Method in class com.jxcell.ChartShape
set the minor scale unit of the selected axis.
setScaleMinorUnitAuto(short, int, boolean) - Method in class com.jxcell.ChartShape
 
setScaleValueRange(short, int, double, double) - Method in class com.jxcell.ChartShape
Sets the minimum and maximum range of the selected axis.
setScaleValueRange(short, int, double, double) - Method in class com.jxcell.GRChart
 
setScrollToLastRC(boolean) - Method in class com.jxcell.View
Sets how scrollbars work.
setSelEndCol(int) - Method in class com.jxcell.View
Sets the last selected column.
setSelEndRow(int) - Method in class com.jxcell.View
Sets the last selected row.
setSelStartCol(int) - Method in class com.jxcell.View
Sets the first selected column.
setSelStartRow(int) - Method in class com.jxcell.View
Sets the first selected row.
setSelection(int, int, int, int) - Method in class com.jxcell.View
Selects the range represented by the specified parameters and moves the active cell to the top left cell in the range.
setSelection(RangeRef) - Method in class com.jxcell.View
Selects the range represented by the specified RangeRef object and moves the active cell to the top left cell in the range.
setSelection(String) - Method in class com.jxcell.View
Selects the range represented by the specified formula and moves the active cell to the top left cell in the range.
setSelectionLocal(String) - Method in class com.jxcell.View
Selects the range represented by the specified formula and moves the active cell to the top left cell in the range.
setSelections(int[]) - Method in class com.jxcell.GRObject
 
setSeriesFormat(int, ChartFormat) - Method in class com.jxcell.ChartShape
Sets the format of the specified series.
setSeriesFormat(int, ChartFormat) - Method in class com.jxcell.GRChart
Sets the specified series formatting
setSeriesName(int, String) - Method in class com.jxcell.ChartShape
Sets the name of the specified series.
setSeriesName(int, String) - Method in class com.jxcell.GRChart
Sets the name of the specified series
setSeriesNameLocal(int, String) - Method in class com.jxcell.GRChart
Sets the name of the specified series, in the user's language
setSeriesSizeValueFormula(int, String) - Method in class com.jxcell.ChartShape
Sets the size value formula of the specified series.
setSeriesSizeValueFormula(int, String) - Method in class com.jxcell.GRChart
Sets the size value formula of the specified series.
setSeriesSizeValueFormulaLocal(int, String) - Method in class com.jxcell.GRChart
Sets the size value formula of the specified series, in the user's language.
setSeriesSmoothedLine(int) - Method in class com.jxcell.ChartShape
set the series smooth line
setSeriesSmoothedLine(int) - Method in class com.jxcell.GRChart
 
setSeriesType(short) - Method in class com.jxcell.ChartShape
Sets the series type of the selected series.
setSeriesType(int, short) - Method in class com.jxcell.ChartShape
Sets the series type of the specified series.
setSeriesType(int, int) - Method in class com.jxcell.GRChart
Sets the series type of the specified series.
setSeriesXValueFormula(int, String) - Method in class com.jxcell.ChartShape
Sets the X axis value formula of the specified series.
setSeriesXValueFormula(int, String) - Method in class com.jxcell.GRChart
Sets the X axis value formula of the specified series.
setSeriesXValueFormulaLocal(int, String) - Method in class com.jxcell.GRChart
Sets the X axis value formula of the specified series, in the user's language.
setSeriesYAxisIndex(int, int) - Method in class com.jxcell.ChartShape
Sets the index of the Y axis that the specified series is plotted on.
setSeriesYAxisIndex(int, int) - Method in class com.jxcell.GRChart
 
setSeriesYValueFormula(int, String) - Method in class com.jxcell.ChartShape
Returns the Y axis value formula of the specified series.
setSeriesYValueFormula(int, String) - Method in class com.jxcell.GRChart
Sets the Y axis value formula of the specified series
setSeriesYValueFormulaLocal(int, String) - Method in class com.jxcell.GRChart
Sets the Y axis value formula of the specified series, in the user's language
setSheet(int) - Method in class com.jxcell.View
Sets the active worksheet.
setSheetHidden(int) - Method in class com.jxcell.View
Sets the hidden state for the current selected sheet.
setSheetName(int, String) - Method in class com.jxcell.View
Assigns a name to the specified worksheet .
setSheetProtected(int, boolean, String) - Method in class com.jxcell.View
Sets whether protection is enabled for the specified sheet.
setSheetSelected(int, boolean) - Method in class com.jxcell.View
Sets which sheet is selected.
setSheetsCount(int) - Method in class com.jxcell.View
 
setShowColHeading(boolean) - Method in class com.jxcell.View
Sets whether column headings are displayed
setShowEditBar(boolean) - Method in class com.jxcell.View
Sets whether the edit bar is displayed.
setShowFormulas(boolean) - Method in class com.jxcell.View
Sets whether formulas are displayed in place of cell values
setShowGridLines(boolean) - Method in class com.jxcell.View
Sets whether grid lines are displayed.
setShowHScrollBar(short) - Method in class com.jxcell.View
Sets the mode for the horizontal scroll bar
setShowRowHeading(boolean) - Method in class com.jxcell.View
Sets the flag which determines whether row headings are shown.
setShowSelections(short) - Method in class com.jxcell.View
Sets the mode for highlighting selections.
setShowTabs(short) - Method in class com.jxcell.View
Sets the display status and position of the sheet name tabs on a workbook.
setShowTypeMarkers(boolean) - Method in class com.jxcell.View
Sets whether frames are displayed around cells to identify the cell types.
setShowVScrollBar(short) - Method in class com.jxcell.View
Sets the mode for the vertical scroll bar.
setShowZeroValues(boolean) - Method in class com.jxcell.View
Sets or returns whether zero value cells are displayed.
setSolid() - Method in class com.jxcell.ChartFormat
Sets the fill to solid.
setStack(boolean) - Method in class com.jxcell.GRChart
Sets the plot to display stacked series.
setSummaryColsBeforeDetail(boolean) - Method in class com.jxcell.View
Sets whether col outline summaries come before col detail information.
setSummaryRowsBeforeDetail(boolean) - Method in class com.jxcell.View
Sets whether row outline summaries come before row detail information.
setTabFont(String, int, boolean, boolean) - Method in class com.jxcell.View
change the default tab font setting
setTabbedText(int, int, boolean, String) - Method in class com.jxcell.View
Places a block of tab-delimited text in a workbook.
setText(String) - Method in class com.jxcell.GRObject
 
setText(int, int, int, String) - Method in class com.jxcell.View
Sets the value of the specified cell in the specified sheet.
setText(int, int, String) - Method in class com.jxcell.View
Sets the value of the active cell for all selected sheets.
setText(String) - Method in class com.jxcell.View
Sets the value of the active cell for all selected sheets.
setTextAsValue(int, int, int, String) - Method in class com.jxcell.View
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.
setTextAsValue(int, int, String) - Method in class com.jxcell.View
Sets the value of a specified cell of all selected worksheets.
setTextAsValue(String) - Method in class com.jxcell.View
Enters text in the active cell of all selected worksheets.
setTextAsValue(String, String) - Method in class com.jxcell.View
Sets the value of a specified cell.
setTextRotation(int) - Method in class com.jxcell.ChartFormat
set the text rotation
setTextSelection(int, int) - Method in class com.jxcell.View
Sets text selection for the selected cell
setTimeScaleMajorUnit(int, int, int, int) - Method in class com.jxcell.ChartShape
 
setTimeScaleMinorUnit(int, int, int, int) - Method in class com.jxcell.ChartShape
 
setTitle(String) - Method in class com.jxcell.ChartShape
Sets the chart title.
setTitle(String) - Method in class com.jxcell.GRChart
Sets the chart title
setTitleFormat(ChartFormat) - Method in class com.jxcell.ChartShape
Sets chart title formatting.
setTitleFormat(ChartFormat) - Method in class com.jxcell.GRChart
Sets chart Title formatting.
setTopBorder(short) - Method in class com.jxcell.CellFormat
Sets the style for the top edge of the cell.
setTopBorderColor(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the top edge of the cell.
setTopBorderColor(Color) - Method in class com.jxcell.CellFormat
 
setTopRow(int) - Method in class com.jxcell.View
Sets the first row to display in this view.
setType(short) - Method in class com.jxcell.ConditionFormat
Sets the type of this conditional format.
setType(int) - Method in class com.jxcell.DataValidation
 
setType(int) - Method in class com.jxcell.HyperLink
set the hyperlink type
setUndefined(int, boolean) - Method in class com.jxcell.CellFormat
 
setValidationItems(String, int) - Method in class com.jxcell.GRObject
 
setValidationRule(Book, String, int, int) - Method in class com.jxcell.CellFormat
 
setValidationText(String) - Method in class com.jxcell.CellFormat
 
setValue(int) - Method in class com.jxcell.GRObject
 
setValueFormatLinkedToDataSource(boolean) - Method in class com.jxcell.ChartFormat
Sets whether the object gets the value format from the data source.
setValueScaleDisplayUnit(int, int, int) - Method in class com.jxcell.ChartShape
 
setValueScaleDisplayUnitValue(int, int, int) - Method in class com.jxcell.ChartShape
 
setVaryColors(boolean) - Method in class com.jxcell.ChartShape
Sets a boolean indicating whether the series in the chart use varied colors.
setVaryColors(boolean) - Method in class com.jxcell.GRChart
Sets a boolean indicating whether the series in the chart use varied colors.
setVerticalAlignment(short) - Method in class com.jxcell.CellFormat
Sets the type of vertical alignment.
setVerticalAlignment(int) - Method in class com.jxcell.GRObject
 
setVerticalInsideBorder(short) - Method in class com.jxcell.CellFormat
Sets the border style for the vertical inside border.
setVerticalInsideBorderColor(int) - Method in class com.jxcell.CellFormat
Sets the color used to display the vertical inside border.
setViewScale(int) - Method in class com.jxcell.View
Sets the current display scale for a workbook
setVisible(boolean) - Method in class com.jxcell.GRObject
 
setWordWrap(boolean) - Method in class com.jxcell.CellFormat
Sets the wordwrap attribute.
setWorkbookName(String) - Method in class com.jxcell.View
Sets the name assigned to the workbook associated with the current view.
setYAxisCount(int) - Method in class com.jxcell.ChartShape
Sets the number of Y axes on the chart.
setYAxisCount(int) - Method in class com.jxcell.GRChart
 
showActiveCell() - Method in class com.jxcell.View
Positions the view to show the active cell if it is not currently displayed in the window.
showError(String) - Method in class com.jxcell.View
Displays an error message in a message box
showError(Throwable) - Method in class com.jxcell.View
Displays an error message in a message box
showPopupMenu(int, int) - Method in class com.jxcell.ContextMenu
 
sort(int, int, int, int, boolean, int[]) - Method in class com.jxcell.View
Specifies a range of data to be sorted and the keys by which to sort the data.
sort3(int, int, int, int, boolean, int, int, int) - Method in class com.jxcell.View
Specifies a range of data to be sorted and as many as three keys by which to sort the data.
startEdit(StartEditEvent) - Method in interface com.jxcell.StartEditListener
This method is called whenever the user begins to edit the contents of a cell
startEdit(boolean, boolean, boolean) - Method in class com.jxcell.View
Begins edit mode for the active cell.
startRecalc(StartRecalcEvent) - Method in interface com.jxcell.StartRecalcListener
This method is called to notify the registered listener that recalculation is about to begin

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