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