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

I

insertRange(int, int, int, int, short) - Method in class com.smartxls.WorkBook
insert new cells, rows or columns
insertSheets(int, int) - Method in class com.smartxls.WorkBook
Inserts one or more worksheets at the specified location.
is3DClustered() - Method in class com.smartxls.ChartShape
 
is3Dimensional() - Method in class com.smartxls.ChartShape
Indicates whether the chart is 3 dimensional or not.
isAllowBlank() - Method in class com.smartxls.DataValidation
return whether the data validation allows the use of empty or blank entries
isArrayFormula(int, int) - Method in class com.smartxls.WorkBook
return true if the cell is array formula
isAxisScaleCrossAuto(short, int) - Method in class com.smartxls.ChartShape
Indicates whether the axis scale is cross auto
isAxisScaleCrossMax(short, int) - Method in class com.smartxls.ChartShape
Indicates whether the axis scale is cross max
isAxisScaleCrossMin(short, int) - Method in class com.smartxls.ChartShape
Indicates whether the axis scale is cross min
isAxisScaleReversed(short, int) - Method in class com.smartxls.ChartShape
determine if the axis scale is reversed
isAxisVisible() - Method in class com.smartxls.ChartShape
Indicates whether the selected axis is visible.
isAxisVisible(short, int) - Method in class com.smartxls.ChartShape
Indicates whether the specified axis is visible.
isBookProtected() - Method in class com.smartxls.WorkBook
 
isCalcOnSave() - Method in class com.smartxls.WorkBook
sheet calculated on save setting
isCategoryScaleCrossBetween() - Method in class com.smartxls.ChartShape
Indicates whether category scale is cross between
isColHidden(int) - Method in class com.smartxls.WorkBook
Returns true if the column is hidden.
isCompact() - Method in class com.smartxls.BookPivotRange
indicates if it is compact
isDropLinesVisible() - Method in class com.smartxls.ChartShape
Indicates whether drop lines are visible.
isEmpty() - Method in class com.smartxls.DataValidation
 
isFieldItemHidden(int) - Method in class com.smartxls.BookPivotField
is the field specified index shown or hidden
isFillAuto() - Method in class com.smartxls.ChartFormat
Returns whether fill is auto.
isFillShadow() - Method in class com.smartxls.ChartFormat
Returns whether the object has a shadow behind it.
isFillVisible() - Method in class com.smartxls.ChartFormat
visibility for the fill property
isFontAutoScale() - Method in class com.smartxls.ChartFormat
Returns whether fonts are automatically scaled based on chart size.
isFontSubscript() - Method in class com.smartxls.RangeStyle
Returns whether the font is Subscript.
isFontSuperscript() - Method in class com.smartxls.RangeStyle
Returns whether the font is Subscript.
isHidden() - Method in class com.smartxls.RangeStyle
Returns whether the active cell is hiden
isInGridZone() - Method in class com.smartxls.BookPivotRange
indicates if the grid zone is set
isIterationEnabled() - Method in class com.smartxls.WorkBook
Returns true if iteration is enabled.
isLegendVisible() - Method in class com.smartxls.ChartShape
Indicates whether the legend is visible.
isLineAuto() - Method in class com.smartxls.ChartFormat
return if the line auto
isLineNone() - Method in class com.smartxls.ChartFormat
if line is none
isLineShadow() - Method in class com.smartxls.ChartFormat
if the line is shadow.
isLinkedToDataSource() - Method in class com.smartxls.ChartFormat
Returns whether the object gets the value format from the data source.
isLocked() - Method in class com.smartxls.RangeStyle
Returns whether the active cell is locked
isLogScale() - Method in class com.smartxls.ChartShape
Indicates whether the axis is logarithmic.
isLogScale(int, int) - Method in class com.smartxls.ChartShape
Indicates whether the axis is logarithmic.
isMajorGridVisible() - Method in class com.smartxls.ChartShape
Indicates whether the major grid lines of the selected axis are visible.
isMajorGridVisible(short, int) - Method in class com.smartxls.ChartShape
Indicates whether the major grid lines of the specified axis are visible.
isMarkerAuto() - Method in class com.smartxls.ChartFormat
Returns whether to use automatic formatting for a marker.
isMinorGridVisible() - Method in class com.smartxls.ChartShape
Indicates whether the minor grid lines of the selected axis are visible.
isMinorGridVisible(short, int) - Method in class com.smartxls.ChartShape
Indicates whether the minor grid lines of the specified axis are visible.
isPercent() - Method in class com.smartxls.ChartShape
Indicates whether the values in the chart are plotted as percentages of the category.
isPlotStacked() - Method in class com.smartxls.ChartShape
Indicates whether the series in the chart are stacked.
isPlotVisibleDataOnly() - Method in class com.smartxls.ChartShape
Indicates whether the hidden data is shown.
isPrintAutoPageNumbering() - Method in class com.smartxls.WorkBook
Returns true if automatic page numbering is enabled.
isPrintGridLines() - Method in class com.smartxls.WorkBook
Returns true if grid lines are printed for the current sheet.
isPrintHCenter() - Method in class com.smartxls.WorkBook
Returns whether the current sheet is centered horizontally when printed.
isPrintHFAlignMargin() - Method in class com.smartxls.WorkBook
 
isPrintHFScaleDoc() - Method in class com.smartxls.WorkBook
 
isPrintLandscape() - Method in class com.smartxls.WorkBook
Returns true if the workbook is printed with a landscape orientation.
isPrintLeftToRight() - Method in class com.smartxls.WorkBook
Returns whether the current sheet is printed left to right then top to bottom, or top to bottom then left to right.
isPrintNoColor() - Method in class com.smartxls.WorkBook
Returns true if all workbook colors are converted to black and white, and all patterns are removed when printing.
isPrintRowColHeading() - Method in class com.smartxls.WorkBook
Returns whether row/col headings are printed for the current sheet.
isPrintScaleFitToPage() - Method in class com.smartxls.WorkBook
Returns true if the workbook is printed on the number of vertical and horizontal pages returned by the setPrintScaleFitToPage(boolean) method.
isPrintVCenter() - Method in class com.smartxls.WorkBook
Returns true if the current sheet is centered vertically when printed.
isRowHeightAutoSize(int) - Method in class com.smartxls.WorkBook
Returns true if row height is determined automatically.
isRowHidden(int) - Method in class com.smartxls.WorkBook
Returns true if row is hidden.
isRowStripes() - Method in interface com.smartxls.Table
 
isScaleMajorUnitAuto(short, int) - Method in class com.smartxls.ChartShape
indicate if the scale is major unit auto
isScaleMinorUnitAuto(short, int) - Method in class com.smartxls.ChartShape
indicate whether the minor unit of the scale is auto
isSeriesInRows() - Method in class com.smartxls.ChartShape
Indicates whether series data is in rows.
isSeriesSmoothedLine(int) - Method in class com.smartxls.ChartShape
Indicates whether the series use smoothed line
isSheetProtected(int) - Method in class com.smartxls.WorkBook
Returns true if protection is enabled for the specified sheet.
isSheetRightToLeft() - Method in class com.smartxls.WorkBook
sheet right to left setting
isShowColGrandTotal() - Method in class com.smartxls.BookPivotRange
Indicates if the col grand total is shown or not
isShowDrill() - Method in class com.smartxls.BookPivotRange
indicate if drill is set or not
isShowDropDown() - Method in class com.smartxls.DataValidation
 
isShowErrorMessage() - Method in class com.smartxls.DataValidation
 
isShowGridLines() - Method in class com.smartxls.WorkBook
Returns true if grid lines are shown.
isShowHeader() - Method in class com.smartxls.BookPivotRange
indicate if the header is shown or not
isShowInputMessage() - Method in class com.smartxls.DataValidation
 
isShowRowColHeader() - Method in class com.smartxls.WorkBook
Returns true if row/col headers are shown.
isShowRowGrandTotal() - Method in class com.smartxls.BookPivotRange
Indicates if the row grand total is shown or not
isShowZeroValues() - Method in class com.smartxls.WorkBook
Returns true if cells with zero values are displayed.
isShrinkToFit() - Method in class com.smartxls.RangeStyle
Returns whether ShrinkToFit is enabled.
isSolid() - Method in class com.smartxls.ChartFormat
Returns whether fill is solid.
isSummarizeField() - Method in class com.smartxls.BookPivotField
Indicates if this field is a summary field
isSummaryColsBeforeDetail() - Method in class com.smartxls.WorkBook
Returns true if col outline summaries are before col detail information.
isSummaryRowsBeforeDetail() - Method in class com.smartxls.WorkBook
Returns true if row outline summaries are before row detail information.
isTimeScaleBaseUnitAuto(short, int) - Method in class com.smartxls.ChartShape
indicate whether the base unit of the timescale is auto
isTrendLineDisplayEquation(int, int) - Method in class com.smartxls.ChartShape
 
isTrendLineDisplayRSquared(int, int) - Method in class com.smartxls.ChartShape
 
isValueFormatLinkedToDataSource() - Method in class com.smartxls.ChartFormat
Returns whether the object gets the value format from the data source.
isVaryColors() - Method in class com.smartxls.ChartShape
Indicates whether the series in the chart use varied colors.
isWordWrap() - Method in class com.smartxls.RangeStyle
Returns whether word wrap is enabled.
A B C D E F G H I K L M N O P Q R S T U V W X Y Z 
Skip navigation links