- 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
-
- 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.