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

A

AboveOrBelowAverageCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells with values that are above or below average.
AbstractRange - Class in com.gembox.spreadsheet
Base class for classes representing one or more excel cells.
add(ExcelWorksheet, String) - Method in class com.gembox.spreadsheet.CellRangeCollection
Adds the CellRange from the specified worksheet to the collection.
add(int, CellRange) - Method in class com.gembox.spreadsheet.CellRangeCollection
 
add(CellRange) - Method in class com.gembox.spreadsheet.CellRangeCollection
 
add(String) - Method in class com.gembox.spreadsheet.CellStyleCollection
Adds an empty Style instance to the CellStyleCollection.
add() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
Adds a new empty series to the chart.
add(String, String) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
Adds a new series with specified name and values reference to the chart.
add(String, Iterable) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
Adds a new series with specified name and values to the chart.
add(String, Object...) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
Adds a new series with specified name and values to the chart.
add() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Adds a new empty series to the chart.
add(String, String) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Adds a new series with specified name and values reference to the chart.
add(String, Iterable) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Adds a new series with specified name and values to the chart.
add(String, Object...) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Adds a new series with specified name and values to the chart.
add(T) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Not supported.
add(int, T) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Not supported.
add(ChartType, double, double, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
add(ChartType, ChartGrouping, double, double, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
add(double, double, double, double, LengthUnit, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
add(ChartGrouping, double, double, double, double, LengthUnit, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which doesn't move nor sizes with cells.
add(ChartType, AnchorCell, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(ChartType, ChartGrouping, AnchorCell, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(AnchorCell, double, double, LengthUnit, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(ChartGrouping, AnchorCell, double, double, LengthUnit, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(ChartType, String, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(ChartType, ChartGrouping, String, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(String, double, double, LengthUnit, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(ChartGrouping, String, double, double, LengthUnit, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves but doesn't size with cells.
add(ChartType, AnchorCell, AnchorCell) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(ChartType, ChartGrouping, AnchorCell, AnchorCell) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(AnchorCell, AnchorCell, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(ChartGrouping, AnchorCell, AnchorCell, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(ChartType, String, String) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(ChartType, ChartGrouping, String, String) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(String, String, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(ChartGrouping, String, String, Class<T>) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Adds a new chart to the worksheet which moves and sizes with cells.
add(int, DataValidation) - Method in class com.gembox.spreadsheet.DataValidationCollection
 
add(DataValidation) - Method in class com.gembox.spreadsheet.DataValidationCollection
 
add(int, T) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Inserting/setting object into collection is not supported.
add(T) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Inserting/setting object into collection is not supported.
add(InputStream, ExcelPictureFormat, double, double, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which doesn't move nor sizes with cells.
add(String, double, double, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which doesn't move nor sizes with cells.
add(String, double, double, double, double, LengthUnit, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which doesn't move nor sizes with cells.
add(String, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which doesn't move nor sizes with cells.
add(String, double, double, LengthUnit, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which doesn't move nor sizes with cells.
add(InputStream, ExcelPictureFormat, AnchorCell, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(InputStream, ExcelPictureFormat, String, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, AnchorCell, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, AnchorCell, double, double, LengthUnit, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, String, double, double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, String, double, double, LengthUnit, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, AnchorCell) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, AnchorCell, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, String) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(String, String, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves but doesn't size with cells.
add(InputStream, ExcelPictureFormat, AnchorCell, AnchorCell) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves and sizes with cells.
add(InputStream, ExcelPictureFormat, String, String) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves and sizes with cells.
add(String, AnchorCell, AnchorCell) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves and sizes with cells.
add(String, AnchorCell, AnchorCell, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves and sizes with cells.
add(String, String, String) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves and sizes with cells.
add(String, String, String, ExcelObjectSourceType) - Method in class com.gembox.spreadsheet.ExcelPictureCollection
Adds a new picture to the worksheet which moves and sizes with cells.
add(String) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Adds an empty worksheet to the end of the collection.
add(SheetType, String) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Adds an empty worksheet to the end of the collection.
add(int) - Method in class com.gembox.spreadsheet.HorizontalPageBreakCollection
Ads a new horizontal page break above the specified row.
add(int, int, int) - Method in class com.gembox.spreadsheet.HorizontalPageBreakCollection
Ads a new horizontal page break above the specified row and within specified columns.
add(String, EnumSet<IgnoredErrorTypes>) - Method in class com.gembox.spreadsheet.IgnoredErrorCollection
Adds a new instance of an IgnoredError which instructs application to ignore all errors specified in the errorTypes parameter on the sequence of references to cell ranges specified in the appliesTo parameter.
add(String, CellRange) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Adds a new named range.
add(String, CellRange, boolean) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Adds a new named range.
add(int) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Adds the PivotField to this area collection.
add(String) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Adds the PivotField to this area collection.
add(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Adds the PivotField to this area collection.
add(PivotCache, String, String) - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
Adds a new PivotTable to the collection.
add(PivotCache, String, ExcelCell) - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
Adds a new PivotTable to the collection.
add(int, int) - Method in class com.gembox.spreadsheet.SortLevelCollection
Inserts a new SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index into the SortLevelCollection at the specified index.
add(int) - Method in class com.gembox.spreadsheet.SortLevelCollection
Adds a new SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index into the SortLevelCollection.
add(String, String, boolean) - Method in class com.gembox.spreadsheet.tables.TableCollection
Adds a new Table to the collection.
add(String, CellRange, boolean) - Method in class com.gembox.spreadsheet.tables.TableCollection
Adds a new Table to the collection.
add() - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Adds a new TableColumn to the collection.
add() - Method in class com.gembox.spreadsheet.tables.TableRowCollection
Adds a new row to the collection.
add(int) - Method in class com.gembox.spreadsheet.tables.TableRowCollection
Inserts a new row at the specified index.
add(int) - Method in class com.gembox.spreadsheet.VerticalPageBreakCollection
Ads a new vertical page break left to the specified column.
add(int, int, int) - Method in class com.gembox.spreadsheet.VerticalPageBreakCollection
Ads a new vertical page break left to the specified column and within specified rows.
add2ColorScale(String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a '2-Color Scale' conditional formatting rule applied to a specified sequence of references to cell ranges.
add3ColorScale(String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a '3-Color Scale' conditional formatting rule applied to a specified sequence of references to cell ranges.
addAboveOrBelowAverage(String, boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds an 'Above or Below Average' conditional formatting rule applied to a specified sequence of references to cell ranges.
addAll(Collection<? extends CellRange>) - Method in class com.gembox.spreadsheet.CellRangeCollection
 
addAll(int, Collection<? extends CellRange>) - Method in class com.gembox.spreadsheet.CellRangeCollection
 
addAll(Collection) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
Not supported.
addAll(Collection<? extends DataValidation>) - Method in class com.gembox.spreadsheet.DataValidationCollection
 
addAll(int, Collection<? extends DataValidation>) - Method in class com.gembox.spreadsheet.DataValidationCollection
 
addAll(Collection<? extends T>) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Inserting/setting object into collection is not supported.
addAll(int, Collection<? extends T>) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Inserting/setting object into collection is not supported.
addCalculated(String, String) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldCollection
Adds a calculated PivotField to the end of the collection of PivotTable fields.
addCalculated(String, String) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Adds a calculated PivotItem at the end of the collection.
addColumn() - Method in class com.gembox.spreadsheet.tables.Table
Adds a new TableColumn to the column collection of this Table.
addContain(String, ContainConditionType) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Cells with Blanks' or 'Cells with No Blanks' or 'Cells with Errors' or 'Cells with No Errors' conditional formatting rule applied to a specified sequence of references to cell ranges.
addContainDate(String, ContainDateOperator) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Cells with Dates Occurring' conditional formatting rule applied to a specified sequence of references to cell ranges.
addContainText(String, ContainTextOperator, String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Cells with Specific Text' conditional formatting rule applied to a specified sequence of references to cell ranges.
addContainValue(String, ContainValueOperator, Object) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Cells with Cell Value' conditional formatting rule applied to a specified sequence of references to cell ranges.
addContainValue(String, ContainValueOperator, Object, Object) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Cells with Cell Value' conditional formatting rule applied to a specified sequence of references to cell ranges.
addCopy(T) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Adds a copy of the drawing (picture, chart, etc.) to the worksheet.
addCopy(String, ExcelWorksheet) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Adds a copy of an existing worksheet to the end of the collection.
addDataBar(String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Data Bar' conditional formatting rule applied to a specified sequence of references to cell ranges.
addDataValidation(DataValidation) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Add a data validation to this worksheet.
addDefinedName(String, String, int) - Method in class com.gembox.spreadsheet.DefinedNameCollection
Adds defined name to collection and returns index of that defined name.
addFormula(String, String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Formula' conditional formatting rule applied to a specified sequence of references to cell ranges.
addFreeLimitReachedListener(FreeLimitReachedListener) - Static method in class com.gembox.spreadsheet.SpreadsheetInfo
Adds a listener to the event which occurs in loading or saving ExcelFile when GemBox.Spreadsheet is used with FREE-LIMITED-KEY license key and free limit is reached.
addIconSet(String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds an 'Icon Set' conditional formatting rule applied to a specified sequence of references to cell ranges.
addMultiple(int) - Method in class com.gembox.spreadsheet.tables.TableRowCollection
Adds the specified number of new rows to the collection.
addMultiple(int, int) - Method in class com.gembox.spreadsheet.tables.TableRowCollection
Inserts the specified number of new rows at the specified index.
addNamedRange(String, CellRange) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Adds a new named range to this worksheet.
addNamedRange(String, CellRange, boolean) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Adds a new named range to this worksheet.
addNew(String, String, String) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Adds the new ProtectedRange to the current ExcelWorksheet.
addNew(String, String) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Adds the new ProtectedRange to the current ExcelWorksheet.
addPivotTable(PivotCache, String, String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Adds a new PivotTable to the PivotTableCollection of this worksheet.
addPivotTable(PivotCache, String, ExcelCell) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Adds a new PivotTable to the PivotTableCollection of this worksheet.
addRow() - Method in class com.gembox.spreadsheet.tables.Table
Adds a new row to the row collection of this Table.
addRow(int) - Method in class com.gembox.spreadsheet.tables.Table
Inserts a new row at the specified index to the row collection of this Table.
addSort() - Method in class com.gembox.spreadsheet.FilterColumn
Adds a SortLevel to this column.
addStyle(String) - Method in class com.gembox.spreadsheet.ExcelFile
Adds an empty Style instance to the CellStyleCollection of this workbook.
addTable(String, String, boolean) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Adds a new Table to the table collection of this worksheet.
addTable(String, CellRange, boolean) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Adds a new Table to the table collection of this worksheet.
addTopOrBottomRanked(String, boolean, int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Top or Bottom Ranked' conditional formatting rule applied to a specified sequence of references to cell ranges.
addUniqueOrDuplicate(String, boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Adds a 'Unique or Duplicate' conditional formatting rule applied to a specified sequence of references to cell ranges.
addWorksheet(String) - Method in class com.gembox.spreadsheet.ExcelFile
Adds an empty worksheet to the end of the worksheet collection of this workbook.
addWorksheetSource(String) - Method in class com.gembox.spreadsheet.pivottables.PivotCacheCollection
Adds a new PivotCache from the worksheet data source.
all() - Static method in enum com.gembox.spreadsheet.ClearOptions
Clears everything (content, formatting, comment and hyperlink).
all() - Static method in enum com.gembox.spreadsheet.IgnoredErrorTypes
Ignore all errors.
all() - Static method in enum com.gembox.spreadsheet.MultipleBorders
All borders except diagonal.
AnchorCell - Class in com.gembox.spreadsheet
Represents an anchor cell object used in ExcelDrawingPosition type to specify from which cell and to which cell drawing (picture, chart, etc.) spans.
AnchorCell(ExcelColumn, ExcelRow, long, long) - Constructor for class com.gembox.spreadsheet.AnchorCell
Initializes a new instance of the AnchorCell class by using offset values in EMU units (1 point = 12 700 EMU).
AnchorCell(ExcelColumn, ExcelRow, double, double, LengthUnit) - Constructor for class com.gembox.spreadsheet.AnchorCell
Initializes a new instance of the AnchorCell class by using offset values in arbitrary length unit.
AnchorCell(ExcelColumn, ExcelRow, boolean) - Constructor for class com.gembox.spreadsheet.AnchorCell
Initializes a new instance of the AnchorCell class.
AnchorCell(ExcelCell, boolean) - Constructor for class com.gembox.spreadsheet.AnchorCell
Initializes a new instance of the AnchorCell class.
AnchorCell(AnchorCell) - Constructor for class com.gembox.spreadsheet.AnchorCell
Initializes a new instance of the AnchorCell class by using another anchor cell.
append(String) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends text to content.
append(String, ExcelFont) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends text to content.
append(HeaderFooterFieldType) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends special header/footer field to content.
append(HeaderFooterFieldType, ExcelFont) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends special header/footer field to content.
appendPicture(String) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends picture to this HeaderFooterSection instance.
appendPicture(String, int, int) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends picture to this HeaderFooterSection instance.
appendPicture(InputStream, ExcelPictureFormat) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends picture to this HeaderFooterSection instance.
appendPicture(InputStream, ExcelPictureFormat, int, int) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Appends picture to this HeaderFooterSection instance.
apply() - Method in class com.gembox.spreadsheet.AutoFilter
Performs the filtering and sorting of this Range based on this AutoFilter settings.
apply(boolean) - Method in class com.gembox.spreadsheet.AutoFilter
Performs the filtering and (optionally) sorting of this Range based on this AutoFilter settings.
apply() - Method in class com.gembox.spreadsheet.SortState
Performs the sorting of this range based on this SortState settings.
AreaChart - Class in com.gembox.spreadsheet.charts
Represents a chart whose series values are drawn using filled areas.
autoDetectCsvSeparator(InputStream) - Static method in class com.gembox.spreadsheet.ExcelFile
Autodetects CSV separator.
autoDetectCsvSeparator(InputStreamReader, int, char[]) - Static method in class com.gembox.spreadsheet.ExcelFile
Autodetects CSV separator.
AutoFilter - Class in com.gembox.spreadsheet
Represents filter settings and provides filter functionality.
AUTOMATIC - Static variable in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
AxisGridlines - Class in com.gembox.spreadsheet.charts
Represents an axis major or minor gridlines.
AxisLabelsPosition - Enum in com.gembox.spreadsheet.charts
Represents the possible positions for axis labels.
AxisType - Enum in com.gembox.spreadsheet.charts
Represents an axis type.

B

BarChart - Class in com.gembox.spreadsheet.charts
Represents a chart whose series values are drawn using horizontal rectangles.
BOLD_WEIGHT - Static variable in class com.gembox.spreadsheet.ExcelFont
Default bold font weight.
BuiltInCellStyleName - Enum in com.gembox.spreadsheet
Represents a built-in style name.
BuiltInDocumentProperties - Enum in com.gembox.spreadsheet
Enumeration of available built-in document properties.
BuiltInPivotStyleName - Enum in com.gembox.spreadsheet.pivottables
Represents a PivotTable built-in styles.
BuiltInTableStyleName - Enum in com.gembox.spreadsheet.tables
Represents a Table built-in styles.
by(int) - Method in class com.gembox.spreadsheet.SortState
Adds a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range).
by(int, Iterable<String>) - Method in class com.gembox.spreadsheet.SortState
Adds a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range) and with the specified custom list by which order of items to sort by.
by(int, String...) - Method in class com.gembox.spreadsheet.SortState
Adds a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range) and with the specified custom list by which order of items to sort by.
by(int, boolean) - Method in class com.gembox.spreadsheet.SortState
Adds a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range) and with the specified order to sort by.
by(int, boolean, Iterable<String>) - Method in class com.gembox.spreadsheet.SortState
Adds a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range) and with the specified order and custom list by which order of items to sort by.
by(int, boolean, String...) - Method in class com.gembox.spreadsheet.SortState
Adds a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range) and with the specified order and custom list by which order of items to sort by.
by(int, Comparator<ExcelCell>) - Method in class com.gembox.spreadsheet.SortState
Adds a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range) and with the specified comparison method to sort by.
byCustom(int, FilterOperator, Object) - Method in class com.gembox.spreadsheet.AutoFilter
Sets a CustomFilter to a column with the specified index (relative to the Range).
byCustom(int, FilterOperator, Object, boolean, FilterOperator, Object) - Method in class com.gembox.spreadsheet.AutoFilter
Sets a CustomFilter to a column with the specified index (relative to the Range).
byCustom(PivotField, FilterOperator, Object) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a CustomFilter to a pivot field.
byCustom(PivotField, PivotField, FilterOperator, Object) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a CustomFilter to a pivot field.
byCustom(PivotField, FilterOperator, Object, boolean, FilterOperator, Object) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a CustomFilter to a pivot field.
byCustom(PivotField, PivotField, FilterOperator, Object, boolean, FilterOperator, Object) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a CustomFilter to a pivot field.
byDynamic(int, DynamicFilterType) - Method in class com.gembox.spreadsheet.AutoFilter
Sets a DynamicFilter to a column with the specified index (relative to the Range).
byDynamic(PivotField, DynamicFilterType) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a DynamicFilterType to a pivot field.
byDynamic(PivotField, PivotField, DynamicFilterType) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a DynamicFilterType to a pivot field.
byPredicate(int, Predicate<ExcelCell>) - Method in class com.gembox.spreadsheet.AutoFilter
Sets a custom filter method to a column with the specified index (relative to the Range).
byTop10(int, boolean, boolean, double) - Method in class com.gembox.spreadsheet.AutoFilter
Sets a Top10Filter to a column with the specified index (relative to the Range).
byTop10(PivotField, boolean, boolean, double) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a Top10Filter to a pivot field.
byTop10(PivotField, PivotField, boolean, boolean, double) - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Sets a Top10Filter to a pivot field.
byValues(int, Iterable) - Method in class com.gembox.spreadsheet.AutoFilter
Sets a ValuesFilter to a column with the specified index (relative to the Range).
byValues(int, Object...) - Method in class com.gembox.spreadsheet.AutoFilter
Sets a ValuesFilter to a column with the specified index (relative to the Range).

C

calculate() - Method in class com.gembox.spreadsheet.AbstractRange
Calculates formula for one or more excel cells.
calculate() - Method in class com.gembox.spreadsheet.CellRange
Calculates formula for every excel cell in this range.
calculate() - Method in class com.gembox.spreadsheet.ExcelCell
Calculates formula for this excel cell.
calculate() - Method in class com.gembox.spreadsheet.ExcelFile
Calculates formula for every excel cell in all worksheets.
calculate() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Calculates formula for every excel cell in this worksheet.
calculateMaxUsedColumns() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Iterates all rows and finds maximum number of used columns.
calculatePasswordHash(String) - Static method in class com.gembox.spreadsheet.WorksheetProtection
 
CalculationOptions - Class in com.gembox.spreadsheet.calculationengine
Class represents various calculation engine options.
CategoryAxis - Class in com.gembox.spreadsheet.charts
Represents an axis used for categories.
CellBorder - Class in com.gembox.spreadsheet
Represents the color and line style for the single border of a cell.
CellBorders - Class in com.gembox.spreadsheet
Represents a single set of cell border formats (left, right, top, bottom and diagonal).
CellRange - Class in com.gembox.spreadsheet
Cell range is a rectangular group of worksheet cells.
CellRangeCollection - Class in com.gembox.spreadsheet
A collection of CellRange items.
CellRangeIterator - Class in com.gembox.spreadsheet
Iterator used for iterating cells in a CellRange.
CellStyle - Class in com.gembox.spreadsheet
Represents cell formatting.
CellStyle() - Constructor for class com.gembox.spreadsheet.CellStyle
Initializes a new instance of the CellStyle class not associated with any workbook.
CellStyle(ExcelFile) - Constructor for class com.gembox.spreadsheet.CellStyle
Initializes a new instance of the CellStyle class which references default (CellStyleCollection.getNormal()) style from the specified workbook.
CellStyleCollection - Class in com.gembox.spreadsheet
Represents a collection of workbook (master) Styles.
CellValueType - Enum in com.gembox.spreadsheet
Represents the possible cell value types.
changeAxisType(AxisType) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Changes the type of the axis.
changeAxisType(Class<TChartAxis>) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Changes the type of the axis.
changeChartType(ChartType) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Changes the chart to a different type of chart.
changeChartType(Class<TChart>) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Changes the chart to a different type of chart.
changeWorksheetSource(String) - Method in class com.gembox.spreadsheet.pivottables.PivotCache
Changes the worksheet source of the PivotCache.
ChartAxes - Class in com.gembox.spreadsheet.charts
Represents chart axes.
ChartAxis - Class in com.gembox.spreadsheet.charts
Represents a base class for all chart axis types.
ChartDataLabels - Class in com.gembox.spreadsheet.charts
Represents the settings for the data labels for an entire series or the entire chart.
ChartGrouping - Enum in com.gembox.spreadsheet.charts
Represents the grouping of a chart series for each category in a chart.
ChartLegend - Class in com.gembox.spreadsheet.charts
Represents a chart legend.
ChartLegendPosition - Enum in com.gembox.spreadsheet.charts
Specifies the possible positions for a legend.
ChartSeries - Class in com.gembox.spreadsheet.charts
Represents a single chart series.
ChartSeriesCollection - Class in com.gembox.spreadsheet.charts
Represents a collection of ChartSeries objects.
ChartSeriesCollectionGeneric<T extends ChartSeries> - Class in com.gembox.spreadsheet.charts
Represents a collection of series of specific type which derives from ChartSeries type.
ChartTitle - Class in com.gembox.spreadsheet.charts
Represents a chart or axis title.
ChartTitleDirection - Enum in com.gembox.spreadsheet.charts
Represents chart or axis title text direction.
ChartType - Enum in com.gembox.spreadsheet.charts
Represents a chart type.
clear(EnumSet<ClearOptions>) - Method in class com.gembox.spreadsheet.AbstractRange
Clears the range (content, formatting, comment, hyperlink or all).
clear() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
clear() - Method in class com.gembox.spreadsheet.DefinedNameCollection
Removes all elements from defined names collection.
clear() - Method in class com.gembox.spreadsheet.ExcelCommentCollection
Removes all comments.
clear() - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
clear() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Clears this worksheet.
clear() - Method in class com.gembox.spreadsheet.IgnoredErrorCollection
Removes all IgnoredErrors from the IgnoredErrorCollection.
clear() - Method in class com.gembox.spreadsheet.PageBreakCollection
Removes all page breaks.
clear() - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Removes all PivotFields from this area collection.
clear() - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
Removes all PivotTables from the collection.
clear() - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Removes all ProtectedRanges from the current ExcelWorksheet.
clear() - Method in class com.gembox.spreadsheet.SortLevelCollection
Removes all SortLevels from the SortLevelCollection.
clear() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlinkCollection
Removes all hyperlinks.
clearFilter() - Method in class com.gembox.spreadsheet.FilterColumn
Clears the filter from this FilterColumn.
clearFilter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Clears the filter from this PivotFilter.
clearFreeLimitReachedListeners() - Static method in class com.gembox.spreadsheet.SpreadsheetInfo
Removes all listeners for free limit reached event.
ClearOptions - Enum in com.gembox.spreadsheet
Specifies the clear options.
clearSort() - Method in class com.gembox.spreadsheet.FilterColumn
Clears the sort level from this FilterColumn.
clearSort() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Removes the sort options from this pivot field.
clone() - Method in class com.gembox.spreadsheet.ExcelFile
Makes a deep clone of this ExcelFile instance.
clone() - Method in class com.gembox.spreadsheet.ProtectedRange
 
collapse(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Collapse/expand entire PivotField.
ColorName - Enum in com.gembox.spreadsheet
Represents a color name of colors available in MS Excel user interface.
ColorScaleCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats fill of all cells based on their values using a specified 2-point or 3-point color scale.
ColumnChart - Class in com.gembox.spreadsheet.charts
Represents a chart whose series values are drawn using vertical rectangles.
columnIndexToName(int) - Static method in class com.gembox.spreadsheet.ExcelColumnCollection
Converts column index (0, 1, ...) to column name ("A", "B", ...).
columnNameToIndex(String) - Static method in class com.gembox.spreadsheet.ExcelColumnCollection
Converts column name ("A", "B", ...) to column index (0, 1, ...).
com.gembox.spreadsheet - package com.gembox.spreadsheet
Contains classes and enums that constitute GemBox.Spreadsheet object model.
com.gembox.spreadsheet.calculationengine - package com.gembox.spreadsheet.calculationengine
Contains types used to calculate cells formula.
com.gembox.spreadsheet.charts - package com.gembox.spreadsheet.charts
Contains types used to display series of numeric data in a graphical format.
com.gembox.spreadsheet.conditionalformatting - package com.gembox.spreadsheet.conditionalformatting
Contains types used to format cells conditionally based on their values.
com.gembox.spreadsheet.pivottables - package com.gembox.spreadsheet.pivottables
Contains types that constitute model of Pivot Tables.
com.gembox.spreadsheet.tables - package com.gembox.spreadsheet.tables
Contains types that constitute model of Tables.
ConditionalColor - Class in com.gembox.spreadsheet.conditionalformatting
Represents a conditional color used in ColorScaleCondition of a conditional formatting rule to specify color scale point.
ConditionalFormatRule - Class in com.gembox.spreadsheet.conditionalformatting
Represents a conditional formatting rule.
ConditionalFormatRuleCollection - Class in com.gembox.spreadsheet.conditionalformatting
Represents a collection of a conditional formatting rules.
ConditionalIcon - Class in com.gembox.spreadsheet.conditionalformatting
Represents a conditional icon used in IconSetCondition of a conditional formatting rule to specify icon and a lower bound of the values onto which the icon is applied.
ConditionalIconCollection - Class in com.gembox.spreadsheet.conditionalformatting
Represents a collection of conditional icons used in IconSetCondition of a conditional formatting rule.
ConditionalLength - Class in com.gembox.spreadsheet.conditionalformatting
Represents a conditional length used in DataBarCondition of a conditional formatting rule to specify data bar length.
ConditionalLengthCollection - Class in com.gembox.spreadsheet.conditionalformatting
Represents a collection of conditional lengths used in DataBarCondition of a conditional formatting rule.
ConditionalObject - Class in com.gembox.spreadsheet.conditionalformatting
Represents a base class for conditional objects used in conditional formatting.
ConditionalObjectCollection - Class in com.gembox.spreadsheet.conditionalformatting
Represents a base class for a collections of ConditionalObjects used in conditional formatting.
ConditionalObjectCollectionGeneric<T extends ConditionalObject> - Class in com.gembox.spreadsheet.conditionalformatting
Represents a base class for a collections of ConditionalObject-derived instances used in conditional formatting.
conditionalObjectIterator() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObjectCollection
Returns an iterator that iterates through the ConditionalObjectCollection.
ConditionalValue - Class in com.gembox.spreadsheet.conditionalformatting
Represents a conditional value used in conditional formatting rules which format all cells based on their values (ColorScaleCondition, DataBarCondition and IconSetCondition).
ConditionalValueType - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a ConditionalValue type.
ContainCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells that contain value which satisfies the specified criteria.
ContainConditionType - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a ContainCondition type.
ContainDateCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells with date that satisfies the specified criteria.
ContainDateOperator - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a ContainDateCondition operator.
contains(String) - Method in class com.gembox.spreadsheet.CellStyleCollection
Determines whether the CellStyleCollection contains a Style instance with specific name.
contains(Object) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
contains(Object) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
contains(ExcelWorksheet) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Determines whether an ExcelWorksheet element is in the ExcelWorksheetCollection.
contains(String) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Determines whether an ExcelWorksheet element with specified name is in the ExcelWorksheetCollection.
contains(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
Determines whether the PivotField is contained in the collection.
contains(PivotItem) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Determines whether an PivotItem element is in the collection.
containsAll(Collection<?>) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
ContainTextCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells with text that satisfies the specified criteria.
ContainTextOperator - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a ContainTextCondition operator.
ContainValueCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells with value that satisfies the specified criteria.
ContainValueOperator - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a ContainValueCondition operator.
convert(double, LengthUnit, LengthUnit) - Static method in class com.gembox.spreadsheet.LengthUnitConverter
Converts the specified length from sourceUnit measurement unit to destinationUnit measurement unit.
convertDateTimeToExcelNumber(LocalDateTime, boolean) - Static method in class com.gembox.spreadsheet.ExcelCell
Converts LocalDateTime to Excel floating-point number.
convertExcelNumberToDateTime(double, boolean) - Static method in class com.gembox.spreadsheet.ExcelCell
Converts Excel floating-point number to java.time.LocalDateTime.
copyTo(int, int) - Method in class com.gembox.spreadsheet.CellRange
Copies this cell range to another position in the same worksheet.
copyTo(ExcelWorksheet, int, int) - Method in class com.gembox.spreadsheet.CellRange
Copies this cell range to another worksheet.
copyTo(String) - Method in class com.gembox.spreadsheet.CellRange
Copies this cell range to another position in the same worksheet or in another worksheet.
copyTo(ExcelWorksheet, String) - Method in class com.gembox.spreadsheet.CellRange
Copies this cell range to another worksheet.
CsvLoadOptions - Class in com.gembox.spreadsheet
Represents options for loading from Character Separated Values file format.
CsvLoadOptions(CsvType) - Constructor for class com.gembox.spreadsheet.CsvLoadOptions
Initializes a new instance of the CsvLoadOptions class.
CsvLoadOptions(char) - Constructor for class com.gembox.spreadsheet.CsvLoadOptions
Initializes a new instance of the CsvLoadOptions class.
CsvSaveOptions - Class in com.gembox.spreadsheet
Represents options for saving to Character Separated Values file format.
CsvSaveOptions(CsvType) - Constructor for class com.gembox.spreadsheet.CsvSaveOptions
Initializes a new instance of the CsvSaveOptions class.
CsvSaveOptions(char) - Constructor for class com.gembox.spreadsheet.CsvSaveOptions
Initializes a new instance of the CsvSaveOptions class.
CsvType - Enum in com.gembox.spreadsheet
Formatting type for CSV files.
CustomFilter - Class in com.gembox.spreadsheet
Represents a filter that specifies one or two conditions (operators and values) and whether the two conditions are joined by 'and' or 'or'.

D

DataBarAxisPosition - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a data bar axis position.
DataBarCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats all cells based on their values by displaying a data bar whose length is proportional to cell's value.
DataBarDirection - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a data bar direction.
DataBarStyle - Class in com.gembox.spreadsheet.conditionalformatting
Represents an appearance settings of a data bar.
DataLabelPosition - Enum in com.gembox.spreadsheet.charts
Represents the possible positions for a data label.
DataValidation - Class in com.gembox.spreadsheet
A single item of data validation defined on ranges of the worksheet.
DataValidation() - Constructor for class com.gembox.spreadsheet.DataValidation
Initializes a new instance of the DataValidation class.
DataValidation(ExcelWorksheet, Iterable<String>) - Constructor for class com.gembox.spreadsheet.DataValidation
Initializes a new instance of the DataValidation class with specified worksheet and cell references on which this data validation will be applied.
DataValidation(ExcelWorksheet, String...) - Constructor for class com.gembox.spreadsheet.DataValidation
Initializes a new instance of the DataValidation class with specified worksheet and cell references on which this data validation will be applied.
DataValidation(Iterable<CellRange>) - Constructor for class com.gembox.spreadsheet.DataValidation
Initializes a new instance of the DataValidation class with specified cell ranges on which this data validation will be applied.
DataValidation(CellRange...) - Constructor for class com.gembox.spreadsheet.DataValidation
Initializes a new instance of the DataValidation class with specified cell ranges on which this data validation will be applied.
DataValidationCollection - Class in com.gembox.spreadsheet
A collection of DataValidation items.
DataValidationErrorStyle - Enum in com.gembox.spreadsheet
The style of data validation error alert.
DataValidationOperator - Enum in com.gembox.spreadsheet
The relational operator used in data validation.
DataValidationType - Enum in com.gembox.spreadsheet
Specifies the type of data validation used to validate user input.
DateAxis - Class in com.gembox.spreadsheet.charts
Represents an axis used for categories which are dates / times.
DateTimeGroup - Class in com.gembox.spreadsheet
Represents a group of LocalDateTimes.
DateTimeGroup(int) - Constructor for class com.gembox.spreadsheet.DateTimeGroup
Initializes a new instance of the DateTimeGroup type with DateTimeGroupLevel.YEAR level.
DateTimeGroup(int, int) - Constructor for class com.gembox.spreadsheet.DateTimeGroup
Initializes a new instance of the DateTimeGroup type with DateTimeGroupLevel.MONTH level.
DateTimeGroup(int, int, int) - Constructor for class com.gembox.spreadsheet.DateTimeGroup
Initializes a new instance of the DateTimeGroup type with DateTimeGroupLevel.DAY level.
DateTimeGroup(int, int, int, int) - Constructor for class com.gembox.spreadsheet.DateTimeGroup
Initializes a new instance of the DateTimeGroup type with DateTimeGroupLevel.HOUR level.
DateTimeGroup(int, int, int, int, int) - Constructor for class com.gembox.spreadsheet.DateTimeGroup
Initializes a new instance of the DateTimeGroup type with DateTimeGroupLevel.MINUTE level.
DateTimeGroup(int, int, int, int, int, int) - Constructor for class com.gembox.spreadsheet.DateTimeGroup
Initializes a new instance of the DateTimeGroup type with DateTimeGroupLevel.SECOND level.
DateTimeGroupLevel - Enum in com.gembox.spreadsheet
Represents a level of a DateTimeGroup.
DefinedName - Class in com.gembox.spreadsheet
Defined name class describes defined name that is not directly related with one cell range.
DefinedNameCollection - Class in com.gembox.spreadsheet
Collection of defined names that are not directly related with one cell range.
delete() - Method in class com.gembox.spreadsheet.charts.AxisGridlines
Deletes gridlines.
delete() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Deletes axes.
delete() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Deletes axis.
delete() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Deletes data labels.
delete() - Method in class com.gembox.spreadsheet.charts.ChartLegend
Deletes legend.
delete() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Deletes the series.
delete() - Method in class com.gembox.spreadsheet.charts.ChartTitle
Deletes the title.
delete() - Method in class com.gembox.spreadsheet.charts.Marker
Deletes the marker from series.
delete() - Method in class com.gembox.spreadsheet.ExcelPicture
Removes this ExcelPicture instance from the worksheet.
delete() - Method in class com.gembox.spreadsheet.NamedRange
Deletes this named range from the named ranges collection.
deleteBackgroundPicture() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Removes the worksheet background picture.
diagonal() - Static method in enum com.gembox.spreadsheet.MultipleBorders
Diagonal borders.
DocumentProperties - Class in com.gembox.spreadsheet
Contains a collection of built-in and custom document properties.
DynamicFilter - Class in com.gembox.spreadsheet
Represents a dynamic filter criteria that can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today").
DynamicFilterType - Enum in com.gembox.spreadsheet
Represents a dynamic filter type.

E

EmptyCellDisplayMode - Enum in com.gembox.spreadsheet.charts
Specifies the possible ways to display empty cell values (cells with value equal to null).
equals(Object) - Method in class com.gembox.spreadsheet.AnchorCell
Determines whether the specified java.lang.Object is equal to this AnchorCell instance.
equals(Object) - Method in class com.gembox.spreadsheet.CellRange
Determines whether the specified java.lang.Object is equal to this CellRange instance.
equals(Object) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Determines whether the specified java.lang.Object is equal to this ConditionalValue instance.
equals(Object) - Method in class com.gembox.spreadsheet.DateTimeGroup
Determines whether the specified Object is equal to this DateTimeGroup instance.
equals(Object) - Method in class com.gembox.spreadsheet.ExcelCell
Determines whether the specified Object is equal to this ExcelCell instance.
equals(Object) - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Determines whether the specified Object is equal to this ExcelColumnRowBase instance.
equals(Object) - Method in class com.gembox.spreadsheet.ExcelComment
Determines whether the specified Object is equal to this ExcelComment instance.
equals(Object) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Determines whether the specified ExcelPrintOptions is equal to the current ExcelPrintOptions.
equals(Object) - Method in class com.gembox.spreadsheet.NamedRange
Determines whether the specified Object is equal to this NamedRange instance.
equals(Object) - Method in class com.gembox.spreadsheet.SpreadsheetColor
Determines whether the specified Object is equal to this SpreadsheetColor instance.
equals(Object) - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Determines whether the specified Object is equal to this SpreadsheetHyperlink instance.
equals(Object) - Method in class com.gembox.spreadsheet.SpreadsheetIcon
Determines whether the specified Object is equal to this SpreadsheetIcon instance.
equals(Object) - Method in class com.gembox.spreadsheet.tables.Table
Determines whether the specified java.lang.Object is equal to this Table instance.
equalsGeneric(ConditionalValue) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Determines whether the other ConditionalValue is equal to this ConditionalValue instance.
ExcelCell - Class in com.gembox.spreadsheet
Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
ExcelCellCollection - Class in com.gembox.spreadsheet
Collection of excel cells (ExcelCell).
ExcelChart - Class in com.gembox.spreadsheet.charts
Represents a base class for all charts in a worksheet.
ExcelChartCollection - Class in com.gembox.spreadsheet.charts
Represents a collection of charts in the worksheet.
ExcelColumn - Class in com.gembox.spreadsheet
Excel column contains column options and cell range with column cells.
ExcelColumnCollection - Class in com.gembox.spreadsheet
Collection of excel columns (ExcelColumn).
ExcelColumnRowBase - Class in com.gembox.spreadsheet
Base class for the excel column and row classes.
ExcelComment - Class in com.gembox.spreadsheet
Represents a comment object used by ExcelCell.setComment(com.gembox.spreadsheet.ExcelComment) in the worksheet.
ExcelCommentCollection - Class in com.gembox.spreadsheet
Collection of comments (ExcelComment).
ExcelDrawing - Class in com.gembox.spreadsheet
Represents a base class for all drawings (pictures, charts, etc.) in the worksheet.
ExcelDrawingCollectionImpl<T extends ExcelDrawing> - Class in com.gembox.spreadsheet
Represents a collection of drawings (pictures, charts, etc.) in the worksheet.
ExcelDrawingMetadata - Class in com.gembox.spreadsheet
Represents a set of non-visual properties which shall be applied to the parent ExcelDrawing.
ExcelDrawingPosition - Class in com.gembox.spreadsheet
Represents a class which holds information about position and size of the ExcelDrawing (picture, chart, etc.) in the worksheet.
ExcelEmbeddedObject - Class in com.gembox.spreadsheet
Represents a read-only embedded object in the worksheet.
ExcelEmbeddedObjectCollection - Class in com.gembox.spreadsheet
Represents a read-only collection of embedded objects in the worksheet.
ExcelFile - Class in com.gembox.spreadsheet
Excel file contains one or more worksheets (ExcelWorksheet) and workbook related properties and methods.
ExcelFile() - Constructor for class com.gembox.spreadsheet.ExcelFile
Initializes an empty (no worksheets) instance of the ExcelFile class.
ExcelFillPattern - Class in com.gembox.spreadsheet
Represents cell fill (background) formatting which can be either pattern or gradient.
ExcelFont - Class in com.gembox.spreadsheet
Represents a typeface (for example, Calibri), along with its attributes (size, font style, underlining, color, and effects).
ExcelFont() - Constructor for class com.gembox.spreadsheet.ExcelFont
Initializes a new instance of the ExcelFont class.
ExcelObjectSourceType - Enum in com.gembox.spreadsheet
Represents an enumeration of possible sources of various objects (such as pictures, audio and other files) that can be either embedded, linked or both.
ExcelPicture - Class in com.gembox.spreadsheet
Represents a picture in the worksheet.
ExcelPictureCollection - Class in com.gembox.spreadsheet
Represents a collection of pictures in the worksheet.
ExcelPictureFormat - Enum in com.gembox.spreadsheet
Picture formats.
ExcelPrintOptions - Class in com.gembox.spreadsheet
Stores MS Excel print and print related options.
ExcelRow - Class in com.gembox.spreadsheet
Excel row contains row options and cell range with row cells.
ExcelRowCollection - Class in com.gembox.spreadsheet
Collection of excel rows (ExcelRow).
ExcelRowColumnCellCollectionBase - Class in com.gembox.spreadsheet
Base class for row, column and cell collections.
ExcelRowColumnCollectionBase - Class in com.gembox.spreadsheet
Base class for row and column collections.
ExcelRowColumnCollectionBaseGeneric<T extends ExcelColumnRowBase> - Class in com.gembox.spreadsheet
Generic base class for row and column collections.
ExcelViewOptions - Class in com.gembox.spreadsheet
Stores MS Excel display and view related options.
ExcelWorksheet - Class in com.gembox.spreadsheet
Excel worksheet is a table with additional properties, identified by a unique name.
ExcelWorksheetCollection - Class in com.gembox.spreadsheet
Collection of worksheets (ExcelWorksheet).
exists() - Method in class com.gembox.spreadsheet.ExcelComment
If comment exists returns true, otherwise returns false.
exists() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
If hyperlink exists returns true, otherwise returns false.

F

FileFormatLimitations - Class in com.gembox.spreadsheet
Represents file format limitations when saving ExcelFile to some format.
FileFormatLimitations(int, int, int, int) - Constructor for class com.gembox.spreadsheet.FileFormatLimitations
Initializes instance of FileFormatLimitations class.
FillPatternStyle - Enum in com.gembox.spreadsheet
Represents the style of fill pattern being used for a cell format.
filter() - Method in class com.gembox.spreadsheet.CellRange
Gets the AutoFilter active on the parent worksheet (ExcelWorksheet.getFilter()) or Table (Table.getFilter()) if active range is equal to this CellRange; otherwise, a new AutoFilter instance, which is set as active on the parent worksheet or table.
filter(boolean) - Method in class com.gembox.spreadsheet.CellRange
Gets the AutoFilter active on the parent worksheet (ExcelWorksheet.getFilter()) or Table (Table.getFilter()) if active range is equal to this CellRange and parameter active is true; otherwise, a new AutoFilter instance, which is set as active on the parent worksheet or table if parameter active is true.
Filter - Class in com.gembox.spreadsheet
Represents a base class for filters contained in AutoFilter.
FILTER_RESERVED_NAME - Static variable in class com.gembox.spreadsheet.NamedRangeCollection
 
FilterColumn - Class in com.gembox.spreadsheet
Represents filter and sort settings for a single filter column.
FilterColumnCollection - Class in com.gembox.spreadsheet
Represents a collection of filter columns.
FilterOperator - Enum in com.gembox.spreadsheet
Operator enumerations for filtering.
FilterType - Enum in com.gembox.spreadsheet
Represents a filter type.
findText(String) - Method in class com.gembox.spreadsheet.CellRange
Finds the first occurrence of the specified text in the current cell range.
findText(String, boolean) - Method in class com.gembox.spreadsheet.CellRange
Finds the first occurrence of the specified text in the current cell range.
findText(String, boolean, boolean) - Method in class com.gembox.spreadsheet.CellRange
Finds the first occurrence of the specified text in the current cell range.
findText(Pattern) - Method in class com.gembox.spreadsheet.CellRange
Finds the first occurrence which matches the specified Pattern in the current cell range.
FixedWidthColumn - Class in com.gembox.spreadsheet
Class that represents column in Fixed-Width Text format.
FixedWidthColumn(int) - Constructor for class com.gembox.spreadsheet.FixedWidthColumn
Initializes a new instance of the FixedWidthColumn class.
FixedWidthLoadOptions - Class in com.gembox.spreadsheet
Represents options for loading from Fixed-Width Text file format.
FixedWidthLoadOptions(Iterable<FixedWidthColumn>) - Constructor for class com.gembox.spreadsheet.FixedWidthLoadOptions
Initializes a new instance of the FixedWidthLoadOptions class.
FixedWidthLoadOptions(FixedWidthColumn...) - Constructor for class com.gembox.spreadsheet.FixedWidthLoadOptions
Initializes a new instance of the FixedWidthLoadOptions class.
FixedWidthSaveOptions - Class in com.gembox.spreadsheet
Represents options for saving to Fixed-Width Text file format.
FixedWidthSaveOptions(Iterable<FixedWidthColumn>) - Constructor for class com.gembox.spreadsheet.FixedWidthSaveOptions
Initializes a new instance of the FixedWidthSaveOptions class.
FixedWidthSaveOptions(FixedWidthColumn...) - Constructor for class com.gembox.spreadsheet.FixedWidthSaveOptions
Initializes a new instance of the FixedWidthSaveOptions class.
FormatCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a base class for all conditions that can be specified in a conditional formatting rule.
FormatConditionType - Enum in com.gembox.spreadsheet.conditionalformatting
Represents a FormatCondition type.
FormattedCharacterRange - Class in com.gembox.spreadsheet
Represents a range of characters within the cell or comment text.
FormulaCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells for which the specified formula result evaluates to true.
FreeLimitEventArgs - Class in com.gembox.spreadsheet
Provides data for the free limit reached event.
FreeLimitReachedAction - Enum in com.gembox.spreadsheet
Type of action that can be chosen when free limit is reached.
FreeLimitReachedException - Exception in com.gembox.spreadsheet
Exception that occurs when free limit is reached.
FreeLimitReachedListener - Interface in com.gembox.spreadsheet
Represents a listener for the free limit reached event in SpreadsheetInfo
fromArgb(int) - Static method in class com.gembox.spreadsheet.SpreadsheetColor
Creates a SpreadsheetColor class from a 32-bit ARGB value.
fromArgb(int, int, int) - Static method in class com.gembox.spreadsheet.SpreadsheetColor
Creates a SpreadsheetColor class from the specified 8-bit color values (red, green, and blue).
fromColor(Color) - Static method in class com.gembox.spreadsheet.SpreadsheetColor
Performs a conversion from Color to SpreadsheetColor.
fromFormula(String) - Static method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Creates a new instance of the ConditionalValue from the specified formula.
fromName(ColorName) - Static method in class com.gembox.spreadsheet.SpreadsheetColor
Creates a SpreadsheetColor class from the specified predefined color.
fromNumber(double) - Static method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Creates a new instance of the ConditionalValue from the specified number.
fromPercent(double) - Static method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Creates a new instance of the ConditionalValue from the specified percent.
fromPercentile(double) - Static method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Creates a new instance of the ConditionalValue from the specified percentile.

G

get(IndividualBorder) - Method in class com.gembox.spreadsheet.CellBorders
Gets the CellBorder which contains the color and line style for the specified individual border of a cell.
get(int) - Method in class com.gembox.spreadsheet.CellRange
Gets excel cell at the specified index.
get(int, int) - Method in class com.gembox.spreadsheet.CellRange
Gets excel cell at the specified relative position.
get(String) - Method in class com.gembox.spreadsheet.CellRange
Gets excel cell with the specified full or partial name.
get(String) - Method in class com.gembox.spreadsheet.CellStyleCollection
Gets the Style that corresponds to given name.
get(BuiltInCellStyleName) - Method in class com.gembox.spreadsheet.CellStyleCollection
Gets the Style that corresponds to given BuiltInCellStyleName.
get(int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
Gets the ChartSeries that is stored at the zero-based index of the ChartSeriesCollection.
get(int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Gets the item that is stored at the zero-based index of the ChartSeriesCollectionGeneric<T>.
get(int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Gets the ConditionalFormatRule at the specified index.
get(int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObjectCollection
Gets the conditional object at the specified index.
get(int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObjectCollectionGeneric
Gets the conditional object at the specified index.
get(int) - Method in class com.gembox.spreadsheet.DefinedNameCollection
Gets defined name described by index from collection.
get(String) - Method in class com.gembox.spreadsheet.DefinedNameCollection
Gets defined name described by name from collection.
get(int) - Method in class com.gembox.spreadsheet.ExcelCellCollection
Gets the cell with the specified index.
get(int) - Method in class com.gembox.spreadsheet.ExcelColumnCollection
Gets the column with the specified index.
get(int) - Method in class com.gembox.spreadsheet.ExcelCommentCollection
Gets the comment at the specified index.
get(int) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Gets the element at the specified index.
get(int) - Method in class com.gembox.spreadsheet.ExcelEmbeddedObjectCollection
Gets the ExcelEmbeddedObject at the specified index.
get(int) - Method in class com.gembox.spreadsheet.ExcelRowCollection
Gets the row with the specified index.
get(int) - Method in class com.gembox.spreadsheet.ExcelRowColumnCollectionBaseGeneric
Gets the row / column with the specified index.
get(String) - Method in class com.gembox.spreadsheet.ExcelRowColumnCollectionBaseGeneric
Gets the row / column with the specified name.
get(int) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Gets the worksheet with the specified index.
get(String) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Gets the worksheet with the specified name.
get(int) - Method in class com.gembox.spreadsheet.FilterColumnCollection
Gets the FilterColumn at the specified index.
get(int) - Method in class com.gembox.spreadsheet.HorizontalPageBreakCollection
Gets the horizontal page break at the specified index.
get(int) - Method in class com.gembox.spreadsheet.IgnoredErrorCollection
Gets the IgnoredError at the specified index.
get(int) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Gets the NamedRange at the specified index.
get(String) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Gets the NamedRange with the specified name.
get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotCacheCollection
Gets the PivotCache at the specified index.
get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
Gets the PivotField at the specified index.
get(String) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
Gets the PivotField with the specified name.
get(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotFilterCollection
Gets the PivotFilter for the specified pivot field.
get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Gets the PivotItem at the specified index.
get(String) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Gets the PivotItem with the specified name.
get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
Gets the PivotTable at the specified index.
get(int) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Gets the ProtectedRange at the specified index.
get(String) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Gets the ProtectedRange with the specified title or null.
get(int) - Method in class com.gembox.spreadsheet.SortLevelCollection
Gets the SortLevel at the specified index.
get(int) - Method in class com.gembox.spreadsheet.SpreadsheetHyperlinkCollection
Gets the hyperlink at the specified index.
get(int) - Method in class com.gembox.spreadsheet.tables.TableCollection
Gets the Table at the specified index.
get(String) - Method in class com.gembox.spreadsheet.tables.TableCollection
Gets Table described by name from the collection.
get(int) - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Gets the TableColumn at the specified index.
get(String) - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Gets TableColumn described by name from the collection.
get(int) - Method in class com.gembox.spreadsheet.VerticalPageBreakCollection
Gets the vertical page break at the specified index.
getActivePane() - Method in class com.gembox.spreadsheet.WorksheetPanes
Gets the active pane.
getActiveWorksheet() - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Gets active worksheet.
getAllocatedCells() - Method in class com.gembox.spreadsheet.ExcelRow
Gets only currently allocated cells for this row.
getAlternativeText() - Method in class com.gembox.spreadsheet.tables.Table
Gets the table alternative text.
getAnd() - Method in class com.gembox.spreadsheet.CustomFilter
Gets the value indicating whether the two conditions have an "and" relationship.
getAppliesTo() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Gets the sequence of references to cell ranges over which this conditional formatting rule is applied.
getAppliesTo() - Method in class com.gembox.spreadsheet.IgnoredError
Gets the sequence of references to cell ranges over which this ignored error is applied.
getAuthor() - Method in class com.gembox.spreadsheet.ExcelComment
Gets comment author.
getAutomaticPageBreakScalingFactor() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Scaling factor for automatic page breaks.
getAxes() - Method in class com.gembox.spreadsheet.charts.AreaChart
Gets the chart axes.
getAxes() - Method in class com.gembox.spreadsheet.charts.BarChart
Gets the chart axes.
getAxes() - Method in class com.gembox.spreadsheet.charts.ColumnChart
Gets the chart axes.
getAxes() - Method in class com.gembox.spreadsheet.charts.LineChart
Gets the chart axes.
getAxisColor() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets the data bar axis color.
getAxisPosition() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets the data bar axis position.
getAxisType() - Method in class com.gembox.spreadsheet.charts.CategoryAxis
Gets the axis type for CategoryAxis which is AxisType.CATEGORY.
getAxisType() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the AxisType of this ChartAxis instance.
getAxisType() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the axis type for DateAxis which is AxisType.DATE.
getAxisType() - Method in class com.gembox.spreadsheet.charts.ValueAxis
Gets the axis type for ValueAxis which is AxisType.VALUE.
getB() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Gets the blue component value of this SpreadsheetColor class.
getBackgroundPictureFormat() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet background picture format.
getBackgroundPictureStream() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet background picture stream.
getBarStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarCondition
Gets the bar appearance settings.
getBaseField() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the base field used for a custom calculation.
getBaseItem() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the item in the PivotField.getBaseField() used for a custom calculation.
getBaseItemPosition() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the item position in the PivotField.getBaseField() used for a custom calculation.
getBaseUnit() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the smallest time unit that is represented on the date axis or Optional.empty() if value should be automatically calculated based on chart's data.
getBooleanValue() - Method in class com.gembox.spreadsheet.ExcelCell
Gets the boolean value of this cell or of merged range if this cell is merged.
getBorderColor() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets the data bar border color.
getBorders() - Method in class com.gembox.spreadsheet.CellStyle
Gets the borders.
getBottomMargin() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Bottom margin (in inches).
getBottomRightCell() - Method in class com.gembox.spreadsheet.ExcelComment
Gets the bottom right anchor cell for the comment shape.
getBuiltIn() - Method in class com.gembox.spreadsheet.DocumentProperties
Gets a collection of built-in document properties.
getBuiltIn(BuiltInDocumentProperties) - Method in class com.gembox.spreadsheet.DocumentProperties
Gets a built-in property This method has the same effect as using properties.getBuiltIn().get(builtInDocumentProperty)
getBuiltInStyle() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the built-in style used in the body of the PivotTable.
getBuiltInStyle() - Method in class com.gembox.spreadsheet.tables.Table
Gets the built-in style used in the body of the Table.
getByColumnRowIndex(int) - Method in class com.gembox.spreadsheet.SortLevelCollection
Gets the sort level applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index (relative to the range) or null if such sort level doesn't exist.
getCacheSource() - Method in class com.gembox.spreadsheet.pivottables.PivotCache
Gets the source of the PivotCache.
getCalculationOptions() - Method in class com.gembox.spreadsheet.ExcelFile
Gets the calculation engine options.
getCategoryLabels() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the chart's category labels.
getCategoryLabelsReference() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the chart's category labels as a cell range reference (for example, 'Sheet1!A1:D1').
getCell(int) - Method in class com.gembox.spreadsheet.ExcelColumn
Gets excel cell at the specified index from this column.
getCell(String) - Method in class com.gembox.spreadsheet.ExcelColumn
Gets excel cell with the specified partial name from this column.
getCell(int) - Method in class com.gembox.spreadsheet.ExcelRow
Gets excel cell at the specified index from this row.
getCell(String) - Method in class com.gembox.spreadsheet.ExcelRow
Gets excel cell with the specified partial name from this row.
getCell(int, int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets excel cell at the specified position from this worksheet.
getCell(String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets excel cell with the specified full name from this worksheet.
getCellName() - Method in exception com.gembox.spreadsheet.calculationengine.SpreadsheetParserException
Gets the name of the ExcelCell.
getCellRange() - Method in class com.gembox.spreadsheet.pivottables.WorksheetSource
Gets the cell range that is the source of the data.
getCellRanges() - Method in class com.gembox.spreadsheet.DataValidation
Gets the ranges over which data validation is applied.
getCells() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets cell range with column / row cells.
getCells() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets all the cells in the sheet.
getCenterSection() - Method in class com.gembox.spreadsheet.HeaderFooter
Gets center section.
getCharacterRanges() - Method in class com.gembox.spreadsheet.AbstractRange
Returns all FormattedCharacterRange objects that represents a range of characters within the cell text.
getCharacters(int) - Method in class com.gembox.spreadsheet.AbstractRange
Returns a FormattedCharacterRange object that represents a range of characters within the cell text.
getCharacters(int, int) - Method in class com.gembox.spreadsheet.AbstractRange
Returns a FormattedCharacterRange object that represents a range of characters within the cell text.
getCharacters(int) - Method in class com.gembox.spreadsheet.ExcelComment
Returns a FormattedCharacterRange object that represents a range of characters within the comment text.
getCharacters(int, int) - Method in class com.gembox.spreadsheet.ExcelComment
Returns a FormattedCharacterRange object that represents a range of characters within the comment text.
getCharset() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets the charset for the CSV file.
getCharset() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets the charset for the CSV file.
getCharset() - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets the charset for the Fixed-Width Text file.
getCharset() - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets the charset for the Fixed-Width Text file.
getCharset() - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Gets the charset for the HTML file.
getCharset() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets the charset for the Html file.
getChart(int) - Method in class com.gembox.spreadsheet.charts.ExcelChartCollection
Gets the chart at the specified index and casts it to the specified chart subtype deriving from ExcelChart.
getCharts() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet charts.
getChartType() - Method in class com.gembox.spreadsheet.charts.AreaChart
Gets the chart type for AreaChart which is ChartType.AREA.
getChartType() - Method in class com.gembox.spreadsheet.charts.BarChart
Gets the chart type for BarChart which is ChartType.BAR.
getChartType() - Method in class com.gembox.spreadsheet.charts.ColumnChart
Gets the chart type for ColumnChart which is ChartType.COLUMN.
getChartType() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the ChartType of this ExcelChart instance.
getChartType() - Method in class com.gembox.spreadsheet.charts.LineChart
Gets the chart type for LineChart which is ChartType.LINE.
getChartType() - Method in class com.gembox.spreadsheet.charts.PieChart
Gets the chart type for PieChart which is ChartType.PIE.
getColor() - Method in enum com.gembox.spreadsheet.ColorName
 
getColor() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalColor
Gets the color.
getColor() - Method in class com.gembox.spreadsheet.ExcelFont
Gets the color of the text.
getColumn() - Method in class com.gembox.spreadsheet.AnchorCell
Gets the column for the anchor cell.
getColumn() - Method in class com.gembox.spreadsheet.ExcelCell
Gets column of the cell.
getColumn(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the column with the specified index from this worksheet.
getColumn(String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the column with the specified name from this worksheet.
getColumn() - Method in class com.gembox.spreadsheet.RowColumn
Returns column index
getColumn(int) - Method in class com.gembox.spreadsheet.tables.Table
Gets the TableColumn at the specified index from the column collection of this Table.
getColumn(String) - Method in class com.gembox.spreadsheet.tables.Table
Gets TableColumn described by name from the column collection of this Table.
getColumn() - Method in class com.gembox.spreadsheet.VerticalPageBreak
Gets index of the first column of the new page.
getColumnFields() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the collection of all PivotFields that are currently shown as column fields.
getColumnHeaderCaption() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the String to be displayed in column header in compact mode.
getColumnOffset() - Method in class com.gembox.spreadsheet.AnchorCell
Gets the column offset for the anchor cell in EMU units (1 point = 12 700 EMU).
getColumnOffset(LengthUnit) - Method in class com.gembox.spreadsheet.AnchorCell
Gets the column offset for the anchor cell in arbitrary length unit.
getColumnRowIndex() - Method in class com.gembox.spreadsheet.SortLevel
Gets the column (or the row, if SortState.isLeftToRight() is true) index relative to the range that this sort level applies to.
getColumns() - Method in class com.gembox.spreadsheet.AutoFilter
Gets the filter columns.
getColumns() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets collection of all columns (ExcelColumn) in the worksheet.
getColumns() - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets the list of column definitions for Fixed-Width Text file.
getColumns() - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets the List of column definitions for saving data.
getColumns() - Method in class com.gembox.spreadsheet.tables.Table
Gets the collection of table columns.
getComment() - Method in class com.gembox.spreadsheet.AbstractRange
Gets comment.
getComment() - Method in class com.gembox.spreadsheet.CellRange
Gets comment
getComment() - Method in class com.gembox.spreadsheet.ExcelCell
Gets cell comment.
getComments() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets comments in this sheet.
getComparator() - Method in class com.gembox.spreadsheet.SortLevel
Gets the comparison method that compares two ExcelCells.
getCondition() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Gets the condition specified in this conditional formatting rule.
getConditionalFormatting() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the conditional formatting rules applied on cell ranges of this sheet.
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.ColorScaleCondition
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainCondition
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarCondition
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.FormatCondition
Gets the condition type.
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.FormulaCondition
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
getConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.UniqueOrDuplicateCondition
getContainConditionType() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainCondition
Gets the ContainCondition type.
getContent() - Method in class com.gembox.spreadsheet.HeaderFooterSection
Gets header/footer section content.
getContentType() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets the content-type for CSV file format: "text/tab-separated-values; charset=" + CsvSaveOptions.getCharset()}.name() if CsvSaveOptions.getType() is CsvType.TAB_DELIMITED, otherwise "text/csv; charset=" + CsvSaveOptions.getCharset()}.name().
getContentType() - Method in class com.gembox.spreadsheet.ExcelEmbeddedObject
Gets the content type of the embedded object data.
getContentType() - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets the content-type for Fixed-Width Text file format: "text/plain; charset=" + FixedWidthSaveOptions.getCharset().name().
getContentType() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets the content-type for HTML file format: message/rfc822 if HtmlSaveOptions.getHtmlType() is HtmlType.MHTML, otherwise "text/html; charset=" + HtmlSaveOptions.getCharset().name().
getContentType() - Method in class com.gembox.spreadsheet.OdsSaveOptions
Gets the content-type for ODS file format: application/vnd.oasis.opendocument.spreadsheet-template if workbook is template (file extension is .odt), otherwise application/vnd.oasis.opendocument.spreadsheet.
getContentType() - Method in class com.gembox.spreadsheet.SaveOptions
Gets the content-type for this specific file format as defined in the RFC 2616.
getContentType() - Method in class com.gembox.spreadsheet.XlsSaveOptions
Gets the content-type for XLS file format: application/vnd.ms-excel.
getContentType() - Method in class com.gembox.spreadsheet.XlsxSaveOptions
Gets the content-type for XLSX file format: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet if XlsxSaveOptions.getType() is XlsxType.XLSX, application/vnd.ms-excel.sheet.macroenabled.12 if XlsxSaveOptions.getType() is XlsxType.XLSM, application/vnd.openxmlformats-officedocument.spreadsheetml.template if XlsxSaveOptions.getType() is XlsxType.XLSX, application/vnd.ms-excel.template.macroenabled.12 if XlsxSaveOptions.getType() is XlsxType.XLSM.
getCsvDefault() - Static method in class com.gembox.spreadsheet.LoadOptions
Gets the default options for loading from Character Separated Values file format.
getCsvDefault() - Static method in class com.gembox.spreadsheet.SaveOptions
Gets the default options for saving to Character Separated Values file format.
getCurrentColumn() - Method in class com.gembox.spreadsheet.CellRangeIterator
Gets current absolute column index in the cell range.
getCurrentPageItem() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the current page item showing for the page field.
getCurrentRegion() - Method in class com.gembox.spreadsheet.CellRange
Selects a worksheet region to which the cell range belongs to.
getCurrentRegion() - Method in class com.gembox.spreadsheet.ExcelCell
Selects a worksheet region to which the cell belongs to.
getCurrentRow() - Method in class com.gembox.spreadsheet.CellRangeIterator
Gets current absolute row index in the cell range.
getCustom() - Method in class com.gembox.spreadsheet.DocumentProperties
Gets a collection of custom document properties.
getCustom(String) - Method in class com.gembox.spreadsheet.DocumentProperties
Gets a custom property This method has the same effect as using properties.DocumentProperties.getCustom() () getCustom()}.get(name)
getCustomList() - Method in class com.gembox.spreadsheet.SortLevel
Gets the custom list by which order of items to sort by.
getCustomPageHeight() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
 
getCustomPageWidth() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
 
getData() - Method in class com.gembox.spreadsheet.ExcelEmbeddedObject
Gets the embedded object data.
getDataField() - Method in class com.gembox.spreadsheet.pivottables.PivotTableSortOptions
Gets a data field that is used to sort the pivot field.
getDataFields() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the collection of all PivotFields that are currently shown as data fields.
getDataLabels() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Gets the settings for the data labels for an entire series.
getDataLabels() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the settings for the data labels for the entire chart.
getDataPivotField() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets a PivotField object that represents all the data fields in this PivotTable.
getDataRange() - Method in class com.gembox.spreadsheet.tables.Table
Gets the table data range.
getDataRange() - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the column data range.
getDataValidations() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the collection that expresses all data validation information for cells in a sheet which have data validation features applied.
getDateTime() - Method in class com.gembox.spreadsheet.DateTimeGroup
Gets the date/time of this DateTimeGroup.
getDateTimeValue() - Method in class com.gembox.spreadsheet.ExcelCell
Gets the DateTime value of this cell or of merged range if this cell is merged.
getDefaultColumnWidth() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the default column width in 1/256th of the width of the zero character in default font.
getDefaultPage() - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Gets default header/footer.
getDefaultRowHeight() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the default row height in twips (1/20th of a point).
getDefinedNames() - Method in class com.gembox.spreadsheet.ExcelFile
Gets the collection of defined names that are not directly related with one cell range.
getDescription() - Method in enum com.gembox.spreadsheet.ColorName
 
getDescription() - Method in enum com.gembox.spreadsheet.tables.BuiltInTableStyleName
 
getDescription() - Method in class com.gembox.spreadsheet.tables.TableAlternativeText
Gets the alternative description.
getDirection() - Method in class com.gembox.spreadsheet.charts.ChartTitle
Gets the title text direction.
getDirection() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets the data bar direction.
getDisplayName() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Gets the series display name.
getDisplayText() - Method in class com.gembox.spreadsheet.charts.ChartTitle
Gets the title display text.
getDocumentProperties() - Method in class com.gembox.spreadsheet.ExcelFile
getDoubleValue() - Method in class com.gembox.spreadsheet.ExcelCell
Gets the double value of this cell or of merged range if this cell is merged.
getDynamicFilterType() - Method in class com.gembox.spreadsheet.DynamicFilter
Gets the dynamic filter type.
getEmbeddedObjects() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet embedded objects.
getEndPosition() - Method in class com.gembox.spreadsheet.CellRange
Gets name of the last (bottom-right) cell in this cell range.
getError() - Method in exception com.gembox.spreadsheet.calculationengine.SpreadsheetCalculationException
Gets the calculation error type.
getErrorMessage() - Method in class com.gembox.spreadsheet.DataValidation
Gets the message text of error alert.
getErrorStyle() - Method in class com.gembox.spreadsheet.DataValidation
Gets the style of error alert used for this data validation.
getErrorTitle() - Method in class com.gembox.spreadsheet.DataValidation
Gets the title bar text of error alert.
getErrorTypes() - Method in class com.gembox.spreadsheet.IgnoredError
Gets the ignored error types.
getErrorValue(SpreadsheetCalculationError) - Static method in exception com.gembox.spreadsheet.calculationengine.SpreadsheetCalculationException
Gets the string value for provided calculation error type.
getEvenPage() - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Gets header/footer for even pages.
getExtentEmuVisible() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets the extent in EMU.
getField() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Gets the pivot field that this pivot filter applies to.
getFile() - Method in class com.gembox.spreadsheet.FreeLimitEventArgs
Gets the ExcelFile on which limit was reached.
getFilesDirectoryPath() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets the physical directory where ExcelPictures and ExcelWorksheets files will be saved.
getFilesDirectorySrcPath() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets the relative directory that will be used when referencing ExcelPictures and ExcelWorksheets files in the HTML.
getFillColor() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets the data bar fill color.
getFillPattern() - Method in class com.gembox.spreadsheet.CellStyle
Gets the fill (cell background).
getFilter() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the active AutoFilter.
getFilter() - Method in class com.gembox.spreadsheet.FilterColumn
Gets the filter settings applied to this column or null if no filter settings are applied to this column.
getFilter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Gets the filter settings applied to this pivot field or null if no filter settings are applied to this pivot field.
getFilter() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the pivot table PivotTableFilter.
getFilter() - Method in class com.gembox.spreadsheet.tables.Table
Gets the table filter.
getFilterType() - Method in class com.gembox.spreadsheet.CustomFilter
Gets the FilterType.CUSTOM value.
getFilterType() - Method in class com.gembox.spreadsheet.DynamicFilter
Gets the FilterType.DYNAMIC value.
getFilterType() - Method in class com.gembox.spreadsheet.Filter
Gets the filter type.
getFilterType() - Method in class com.gembox.spreadsheet.Top10Filter
Gets the FilterType.TOP_10 value.
getFilterType() - Method in class com.gembox.spreadsheet.ValuesFilter
Gets the FilterType.VALUES value.
getFirstColumn() - Method in class com.gembox.spreadsheet.HorizontalPageBreak
Index of the first column of the new page.
getFirstColumnIndex() - Method in class com.gembox.spreadsheet.CellRange
Gets index of the first (leftmost) column.
getFirstPage() - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Gets first page header/footer.
getFirstRow() - Method in class com.gembox.spreadsheet.VerticalPageBreak
Gets index of the first row of the new page.
getFirstRowIndex() - Method in class com.gembox.spreadsheet.CellRange
Gets index of the first (topmost) row.
getFirstVisibleColumn() - Method in class com.gembox.spreadsheet.ExcelViewOptions
Gets index of the first visible column in the worksheet.
getFirstVisibleRow() - Method in class com.gembox.spreadsheet.ExcelViewOptions
Gets index of the first visible row in the worksheet.
getFitWorksheetHeightToPages() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Fit worksheet height to this number of pages (0 = use as many as needed).
getFitWorksheetWidthToPages() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Fit worksheet width to this number of pages (0 = use as many as needed).
getFont() - Method in class com.gembox.spreadsheet.CellStyle
Gets the font.
getFont() - Method in class com.gembox.spreadsheet.FormattedCharacterRange
Gets the font of the characters.
getFooter() - Method in class com.gembox.spreadsheet.HeaderFooterPage
Gets footer for this HeaderFooterPage instance.
getFooterMargin() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Footer margin (in inches).
getFormattedValue() - Method in class com.gembox.spreadsheet.ExcelCell
Converts cell value of this ExcelCell instance to string representation using number format that is specified on this ExcelCell instance.
getFormula() - Method in class com.gembox.spreadsheet.AbstractRange
Gets formula string.
getFormula() - Method in class com.gembox.spreadsheet.CellRange
Gets formula string.
getFormula() - Method in class com.gembox.spreadsheet.conditionalformatting.FormulaCondition
Gets the formula used to determine which cells to format (only cells for which the formula result evaluates to true are formatted).
getFormula() - Method in class com.gembox.spreadsheet.ExcelCell
Gets cell formula string.
getFormula() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the PivotField's formula in A1-style notation.
getFormula() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Gets the PivotItem's formula in A1-style notation.
getFormula1() - Method in class com.gembox.spreadsheet.DataValidation
Gets the first formula in the DataValidation dropdown.
getFormula2() - Method in class com.gembox.spreadsheet.DataValidation
Gets the second formula in the DataValidation dropdown.
getFormulaHidden() - Method in class com.gembox.spreadsheet.CellStyle
Gets a value indicating whether the contents of the cell will not be displayed in the formula bar.
getFreeLimitReachedAction() - Method in class com.gembox.spreadsheet.FreeLimitEventArgs
Gets the choice for proceeding when free limit is reached.
getFrom() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the anchor cell which the ExcelDrawing (picture, chart, etc.) spans from.
getFullVersion() - Static method in class com.gembox.spreadsheet.SpreadsheetInfo
GemBox.Spreadsheet full version.
getFunction() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the function used to summarize/aggregate this PivotField.
getG() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Gets the green component value of this SpreadsheetColor class.
getGradientColor1() - Method in class com.gembox.spreadsheet.ExcelFillPattern
Gets the first color of the gradient fill effect.
getGradientColor2() - Method in class com.gembox.spreadsheet.ExcelFillPattern
Gets the second color of the gradient fill effect.
getGradientStyle() - Method in class com.gembox.spreadsheet.ExcelFillPattern
Gets the shading style of the gradient fill effect, if there is any gradient fill effect applied.
getGrouping() - Method in class com.gembox.spreadsheet.charts.AreaChart
Gets the chart grouping.
getGrouping() - Method in class com.gembox.spreadsheet.charts.BarChart
Gets the chart grouping.
getGrouping() - Method in class com.gembox.spreadsheet.charts.ColumnChart
Gets the chart grouping.
getGrouping() - Method in class com.gembox.spreadsheet.charts.LineChart
Gets the chart grouping.
getGroupMethodsAffectedCellsLimit() - Method in class com.gembox.spreadsheet.ExcelFile
Maximum number of affected cells in group get method.
getHeader() - Method in class com.gembox.spreadsheet.HeaderFooterPage
Gets header for this HeaderFooterPage instance.
getHeaderMargin() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Header margin (in inches).
getHeadersFooters() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets headers/footers for the sheet.
getHeight() - Method in class com.gembox.spreadsheet.CellRange
Gets height of this cell range, in rows.
getHeight() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the height (in points) of the ExcelDrawing (picture, chart, etc.).
getHeight(LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the height of the ExcelDrawing (picture, chart, etc.).
getHeight() - Method in class com.gembox.spreadsheet.ExcelRow
Gets row height.
getHeight(LengthUnit) - Method in class com.gembox.spreadsheet.ExcelRow
Gets the height of row in arbitrary length unit.
getHorizontal() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the horizontal chart axis.
getHorizontalAlignment() - Method in class com.gembox.spreadsheet.CellStyle
Gets the horizontal alignment.
getHorizontalCategory() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the horizontal chart axis as category axis, if horizontal chart axis is category axis; otherwise null.
getHorizontalDate() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the horizontal chart axis as date axis, if horizontal chart axis is date axis; otherwise null.
getHorizontalPageBreaks() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets collection of all horizontal page breaks (HorizontalPageBreak) in the worksheet.
getHorizontalValue() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the horizontal chart axis as value axis, if horizontal chart axis is value axis; otherwise null.
getHtmlColumnIndex() - Method in class com.gembox.spreadsheet.HtmlExportPosition
Gets column index for the current column in HTML table.
getHtmlDefault() - Static method in class com.gembox.spreadsheet.LoadOptions
Gets the default options for loading from HyperText Markup Language File (HTML) format.
getHtmlDefault() - Static method in class com.gembox.spreadsheet.SaveOptions
Gets the default options for saving to HyperText Markup Language File format.
getHtmlRowIndex() - Method in class com.gembox.spreadsheet.HtmlExportPosition
Gets row index for the current row in HTML table.
getHtmlType() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets the type of export.
getHyperlink() - Method in class com.gembox.spreadsheet.AbstractRange
Gets hyperlink.
getHyperlink() - Method in class com.gembox.spreadsheet.CellRange
Gets hyperlink
getHyperlink() - Method in class com.gembox.spreadsheet.ExcelCell
Gets cell hyperlink.
getHyperlink() - Method in class com.gembox.spreadsheet.ExcelDrawing
Gets the hyperlink on this drawing (picture, chart, etc.).
getHyperlinks() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets hyperlinks in this sheet.
getIcon() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalIcon
Gets the icon.
getIcons() - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Gets the icons.
getIconStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Gets the icon style for all icons contained in the icons collection.
getIconStyle() - Method in class com.gembox.spreadsheet.SpreadsheetIcon
Gets the icon style.
getId() - Method in class com.gembox.spreadsheet.ExcelDrawingMetadata
Gets a unique identifier for the current drawing within the worksheet.
getId() - Method in class com.gembox.spreadsheet.SpreadsheetIcon
Gets the identifier of the icon from the set of icons specified in SpreadsheetIcon.getIconStyle().
getIgnoredErrors() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the ignored errors applied on cell ranges of this sheet.
getIndent() - Method in class com.gembox.spreadsheet.CellStyle
Gets the number of spaces (of the CellStyleCollection.getNormal() style font) of indentation for text in a cell.
getIndex() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Gets the index of this ChartSeries instance in the parent ChartSeriesCollection.
getIndex() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets the row / column zero-based index which represents its position in a worksheet.
getIndex() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets worksheet zero-based index.
getIndex() - Method in class com.gembox.spreadsheet.FilterColumn
Gets the column index relative to the range that this column filter applies to.
getIndex() - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the column index.
getIndexingMode() - Method in class com.gembox.spreadsheet.CellRange
Gets indexing mode used for cell range.
getInputMessage() - Method in class com.gembox.spreadsheet.DataValidation
Gets the message text of input prompt.
getInputMessageTitle() - Method in class com.gembox.spreadsheet.DataValidation
Gets the title bar text of input prompt.
getIntValue() - Method in class com.gembox.spreadsheet.ExcelCell
Gets the integer value of this cell or of merged range if this cell is merged.
getLabelPosition() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets the position of the data label.
getLabelsInterval() - Method in class com.gembox.spreadsheet.charts.CategoryAxis
Gets the interval between labels that are drawn.
getLabelsPosition() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the axis labels position.
getLastColumn() - Method in class com.gembox.spreadsheet.HorizontalPageBreak
Index of the last column of the new page.
getLastColumnIndex() - Method in class com.gembox.spreadsheet.CellRange
Gets index of the last (rightmost) column.
getLastRow() - Method in class com.gembox.spreadsheet.VerticalPageBreak
Gets index of the last row of the new page.
getLastRowIndex() - Method in class com.gembox.spreadsheet.CellRange
Gets index of the last (bottommost) row.
getLayoutForm() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the layout form for this PivotField.
getLeft() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the distance (in points) of the left edge of the ExcelDrawing (picture, chart, etc.) from the left edge of the worksheet.
getLeft(LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the distance of the left edge of the ExcelDrawing (picture, chart, etc.) from the left edge of the worksheet.
getLeftMargin() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Left margin (in inches).
getLeftSection() - Method in class com.gembox.spreadsheet.HeaderFooter
Gets left section.
getLegend() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the chart's legend.
getLength() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalLength
Gets the data bar length as a percentage of the cell width.
getLength() - Method in class com.gembox.spreadsheet.FormattedCharacterRange
Gets the number of characters.
getLevel() - Method in class com.gembox.spreadsheet.DateTimeGroup
Gets the grouping level of this DateTimeGroup.
getLevels() - Method in class com.gembox.spreadsheet.SortState
Gets the sort levels.
getLimitations() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets limitations for saving to CSV file format.
getLimitations() - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets limitations for saving to Fixed-Width Text file format.
getLimitations() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets limitations for saving to HTML file format.
getLimitations() - Method in class com.gembox.spreadsheet.OdsSaveOptions
Gets limitations for saving to ODS file format.
getLimitations() - Method in class com.gembox.spreadsheet.SaveOptions
Gets limitations for saving to a file formats.
getLimitations() - Method in class com.gembox.spreadsheet.XlsSaveOptions
Gets limitations for saving to XLS file format.
getLimitations() - Method in class com.gembox.spreadsheet.XlsxSaveOptions
Gets limitations for saving to XLSX file format.
getLimitationsInternal() - Static method in class com.gembox.spreadsheet.FixedWidthSaveOptions
 
getLineColor() - Method in class com.gembox.spreadsheet.CellBorder
Gets the border line color.
getLineStyle() - Method in class com.gembox.spreadsheet.CellBorder
Gets the line style for this CellBorder.
getLoadConverter() - Method in class com.gembox.spreadsheet.FixedWidthColumn
Gets the converter for converting value from file to ExcelCell value when loading from Fixed-Width Text file.
getLocale() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets the locale for the CSV file.
getLocale() - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets the locale for the Fixed-Width Text file.
getLocale() - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets the locale for the Fixed-Width Text file.
getLocalSheetIndex() - Method in class com.gembox.spreadsheet.DefinedName
Gets the local sheet index of the defined name.
getLocation() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Gets the location string for hyperlink.
getMajorGridlines() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the major gridlines.
getMajorTickMarkType() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the major tick marks position.
getMajorTimeUnit() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the time unit for major tick marks.
getMajorUnit() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the distance between major ticks or Optional.empty() if value should be automatically calculated based on chart's data.
getMajorUnit() - Method in class com.gembox.spreadsheet.charts.ValueAxis
Gets the distance between major ticks or Optional.empty() if value should be automatically calculated based on chart's data.
getMarker() - Method in class com.gembox.spreadsheet.charts.LineChartSeries
Gets the marker.
getMarkerType() - Method in class com.gembox.spreadsheet.charts.Marker
Gets the marker type.
getMatch() - Method in class com.gembox.spreadsheet.FilterColumn
Gets the method that defines a set of criteria and determines whether the specified ExcelCell meets those criteria.
getMaxCellStyles() - Method in class com.gembox.spreadsheet.FileFormatLimitations
Get maximum number of cell styles.
getMaxColors() - Method in class com.gembox.spreadsheet.FileFormatLimitations
Get maximum number of colors.
getMaxColumns() - Method in class com.gembox.spreadsheet.FileFormatLimitations
Get maximum number of columns.
getMaximum() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the maximum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
getMaximum() - Method in class com.gembox.spreadsheet.charts.ValueAxis
Gets the maximum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
getMaximum() - Method in class com.gembox.spreadsheet.conditionalformatting.ColorScaleCondition
Gets the maximum color point.
getMaximum() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarCondition
Gets the data bar maximum.
getMaximumChange() - Method in class com.gembox.spreadsheet.calculationengine.CalculationOptions
Gets the maximum calculation change.
getMaximumIterations() - Method in class com.gembox.spreadsheet.calculationengine.CalculationOptions
Gets the maximum calculation iterations.
getMaxRows() - Method in class com.gembox.spreadsheet.FileFormatLimitations
Get maximum number of rows.
getMeasureField() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Gets the pivot field containing summary values being filtered.
getMergedRange() - Method in class com.gembox.spreadsheet.ExcelCell
Returns associated merged range if the cell is merged; otherwise, null.
getMetadata() - Method in class com.gembox.spreadsheet.ExcelDrawing
Gets the metadata (non-visual properties) of this ExcelDrawing instance.
getMidpoint() - Method in class com.gembox.spreadsheet.conditionalformatting.ColorScaleCondition
Gets the midpoint color point or null if conditional formatting rule is '2-Color Scale'.
getMinimum() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the minimum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
getMinimum() - Method in class com.gembox.spreadsheet.charts.ValueAxis
Gets the minimum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
getMinimum() - Method in class com.gembox.spreadsheet.conditionalformatting.ColorScaleCondition
Gets the minimum color point.
getMinimum() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarCondition
Gets the data bar minimum.
getMinorGridlines() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the minor gridlines.
getMinorTickMarkType() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the minor tick marks position.
getMinorTimeUnit() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the time unit for minor tick marks.
getMinorUnit() - Method in class com.gembox.spreadsheet.charts.DateAxis
Gets the distance between minor ticks or Optional.empty() if value should be automatically calculated based on chart's data.
getMinorUnit() - Method in class com.gembox.spreadsheet.charts.ValueAxis
Gets the distance between minor ticks or Optional.empty() if value should be automatically calculated based on chart's data.
getMode() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the positioning mode of the ExcelDrawing (picture, chart, etc.).
getName() - Method in class com.gembox.spreadsheet.AbstractRange
Gets the name of AbstractRange instance.
getName() - Method in class com.gembox.spreadsheet.CellStyle
If CellStyle is workbook Style, Gets the name of the style; otherwise, gets the name of the referenced workbook Style from which this CellStyle inherits formatting.
getName() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Gets the series name as direct value (for example, 'My series') or as a reference to a cell with value (for example, '=Sheet1!A1').
getName() - Method in class com.gembox.spreadsheet.DefinedName
Gets the name of the defined name object.
getName(boolean, boolean, boolean) - Method in class com.gembox.spreadsheet.ExcelCell
 
getName() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets the name of ExcelColumnRowBase instance.
getName() - Method in class com.gembox.spreadsheet.ExcelDrawingMetadata
Gets the name for the current drawing.
getName() - Method in class com.gembox.spreadsheet.ExcelFont
Gets the face name of this font.
getName() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets worksheet name.
getName() - Method in class com.gembox.spreadsheet.NamedRange
Gets the named range name.
getName() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the custom name (label text) of this PivotField.
getName() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Gets the name of the PivotItem.
getName() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the name of the PivotTable.
getName() - Method in class com.gembox.spreadsheet.Style
Gets the name of this style.
getName() - Method in class com.gembox.spreadsheet.tables.Table
Gets the table name.
getName() - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the column name.
getNamedRange(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the NamedRange at the specified index from this worksheet.
getNamedRange(String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the NamedRange with the specified name from this worksheet.
getNamedRange() - Method in class com.gembox.spreadsheet.pivottables.WorksheetSource
Gets the named range that is the source of the data.
getNamedRanges() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets NamedRangeCollection containing descriptive names which are used to represent cells, ranges of cells, formulas, or constant values.
getNegativeBorderColor() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets the data bar border color for negative values.
getNegativeFillColor() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets the data bar fill color for negative values.
getNormal() - Method in class com.gembox.spreadsheet.CellStyleCollection
Gets the 'Normal' style.
getNumberFormat() - Method in class com.gembox.spreadsheet.CellStyle
Gets the number format which indicates how to format and render the numeric value of a cell.
getNumberFormat() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the number format used for formatting axis value labels.
getNumberFormat() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets the number format used for formatting data labels.
getNumberFormat() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the number format which indicates how to format the numeric value of this field.
getNumberFormatLocal() - Method in class com.gembox.spreadsheet.CellStyle
Gets a String that represents the format code for the numeric value in the language of the user.
getNumberOfCopies() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Number of copies to print.
getNumberStyles() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets a value indicating numeric type used when parsing strings to numeric types.
getNumberType() - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets a value indicating numeric type used when parsing strings to numeric types.
getNumberType() - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Gets a value indicating numeric type used when parsing strings to numeric types.
getOdsDefault() - Static method in class com.gembox.spreadsheet.LoadOptions
Gets the default options for loading from OpenDocument Spreadsheet file format.
getOdsDefault() - Static method in class com.gembox.spreadsheet.SaveOptions
Gets the default options for saving to OpenDocument Spreadsheet file format.
getOperator() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainDateCondition
Gets the operator of this ContainDateCondition.
getOperator() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainTextCondition
Gets the operator of this ContainTextCondition.
getOperator() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainValueCondition
Gets the operator of this ContainValueCondition.
getOperator() - Method in class com.gembox.spreadsheet.CustomFilter
Gets the operator used by the (first) filter condition.
getOperator() - Method in class com.gembox.spreadsheet.DataValidation
Gets the relational operator used with this data validation.
getOperator2() - Method in class com.gembox.spreadsheet.CustomFilter
Gets the operator used by the second filter condition.
getOutlineLevel() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets outline level.
getPageBreakViewZoom() - Method in class com.gembox.spreadsheet.ExcelViewOptions
Magnification factor in page break view.
getPageFields() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the collection of all PivotFields that are currently showing as page fields.
getPageHeight() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Gets the height of the page (in inches).
getPageWidth() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Gets the width of the page (in inches).
getPanes() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the panes in the worksheet.
getPaperType() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Gets the type of the paper for the page.
getParent() - Method in class com.gembox.spreadsheet.CellRangeIterator
Parent CellRange.
getParent() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the parent ExcelFile of this ExcelWorksheet instance.
getParent() - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the parent Table.
getParseLocale() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets the locale for the CSV file.
getParseLocale() - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Gets the Locale for the HTML file.
getPassword() - Method in class com.gembox.spreadsheet.XlsLoadOptions
Gets the password to open protected / encrypted workbook.
getPassword() - Method in class com.gembox.spreadsheet.XlsSaveOptions
Gets the password used to protect / encrypt the workbook.
getPassword() - Method in class com.gembox.spreadsheet.XlsxLoadOptions
Gets the password to open protected / encrypted workbook.
getPassword() - Method in class com.gembox.spreadsheet.XlsxSaveOptions
Gets the password used to protect / encrypt the workbook.
getPasswordHash() - Method in class com.gembox.spreadsheet.WorkbookProtection
Gets the password hash for protected workbook.
getPasswordHash() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets the password hash for protected sheet.
getPatternBackgroundColor() - Method in class com.gembox.spreadsheet.ExcelFillPattern
Gets the pattern fill background color.
getPatternForegroundColor() - Method in class com.gembox.spreadsheet.ExcelFillPattern
Gets the pattern fill foreground color.
getPatternStyle() - Method in class com.gembox.spreadsheet.ExcelFillPattern
Gets the pattern fill style.
getPictureFormat() - Method in class com.gembox.spreadsheet.ExcelPicture
Gets the picture format.
getPictures() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet pictures.
getPictureStream() - Method in class com.gembox.spreadsheet.ExcelPicture
Gets the picture stream.
getPivotCache() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the PivotCache associated with this PivotTable.
getPivotCaches() - Method in class com.gembox.spreadsheet.ExcelFile
Gets the collection of PivotCaches defined in this ExcelFile instance.
getPivotField() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Gets the parent PivotField.
getPivotFields() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the collection of all (visible and hidden) PivotFields.
getPivotFilters() - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Gets the filter fields.
getPivotItems() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the collection of all (visible and hidden) PivotItems in this PivotField.
getPivotItems() - Method in class com.gembox.spreadsheet.pivottables.PivotTableSortOptions
Gets the pivot items that specify the row (or column) that which will be used to sort the pivot field.
getPivotTable() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the parent PivotTable.
getPivotTable() - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
Gets the PivotTable to filter.
getPivotTables() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the collection of all PivotTables contained in this worksheet.
getPosition() - Method in class com.gembox.spreadsheet.charts.ChartLegend
Gets the legend position.
getPosition() - Method in class com.gembox.spreadsheet.ExcelDrawing
Gets the position of this drawing (picture, chart, etc.) in the worksheet.
getPosition() - Method in class com.gembox.spreadsheet.ExcelEmbeddedObject
Gets the position of this embedded object in the worksheet.
getPrintOptions() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Contains MS Excel print and print related options.
getPrintResolution() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Print resolution in DPI (dots per inch).
getProtectedRanges() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the protected ranges.
getProtectionSettings() - Method in class com.gembox.spreadsheet.ExcelFile
Gets workbook protection properties.
getProtectionSettings() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets worksheet protection properties.
getQuotePrefix() - Method in class com.gembox.spreadsheet.CellStyle
Gets a value indicating whether the text string in a cell should be prefixed by a single quote mark (e.g., 'text).
getR() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Gets the red component value of this SpreadsheetColor class.
getRange() - Method in class com.gembox.spreadsheet.AutoFilter
Gets the range to filter.
getRange() - Method in class com.gembox.spreadsheet.HtmlExportPosition
Gets the cell range that is exporting to HTML.
getRange() - Method in class com.gembox.spreadsheet.NamedRange
Gets the named cell range.
getRange() - Method in class com.gembox.spreadsheet.SortState
Gets the range to sort.
getRange() - Method in class com.gembox.spreadsheet.tables.Table
Gets the table range.
getRange() - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the column range.
getRank() - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Gets the number or percentage of top or bottom ranked cells which are formatted.
getReadIterator() - Method in class com.gembox.spreadsheet.CellRange
Returns iterator for the CellRange (only allocated cells).
getRefersToCells() - Method in class com.gembox.spreadsheet.ProtectedRange
Gets the range to be protected.
getRightMargin() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Right margin (in inches).
getRightSection() - Method in class com.gembox.spreadsheet.HeaderFooter
Gets right section.
getRotation() - Method in class com.gembox.spreadsheet.CellStyle
Gets the text rotation in degrees (1/360th of a full circle).
getRow() - Method in class com.gembox.spreadsheet.AnchorCell
Gets the row for the anchor cell.
getRow() - Method in class com.gembox.spreadsheet.ExcelCell
Gets row of the cell.
getRow(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the row with the specified index from this worksheet.
getRow(String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the row with the specified name from this worksheet.
getRow() - Method in class com.gembox.spreadsheet.HorizontalPageBreak
Index of the first row of the new page.
getRow() - Method in class com.gembox.spreadsheet.RowColumn
Returns row index
getRowFields() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the collection of all PivotFields that are currently showing as row fields.
getRowHeaderCaption() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the String to be displayed in row header in compact mode.
getRowOffset() - Method in class com.gembox.spreadsheet.AnchorCell
Gets row offset for the anchor cell in EMU units (1 point = 12 700 EMU).
getRowOffset(LengthUnit) - Method in class com.gembox.spreadsheet.AnchorCell
Gets the row offset for the anchor cell in arbitrary length unit.
getRows() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets collection of all rows (ExcelRow) in the worksheet.
getRows() - Method in class com.gembox.spreadsheet.tables.Table
Gets the collection of table rows.
getRule() - Method in class com.gembox.spreadsheet.conditionalformatting.FormatCondition
Gets the conditional formatting rule associated with this condition.
getSaveConverter() - Method in class com.gembox.spreadsheet.FixedWidthColumn
Gets the converter for converting ExcelCell value to text when saving to Fixed-Width Text file.
getScriptPosition() - Method in class com.gembox.spreadsheet.ExcelFont
Gets the vertical position of the text relative to the text's default appearance.
getSelectedRanges() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the selected ranges of cells in the worksheet.
getSelectionType() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets a value indicating whether to save the whole ExcelFile or just active worksheet.
getSeparator() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets the text that should be used to separate the parts of a data label.
getSeparator() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets character that serves as value delimiter.
getSeparator() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets character that serves as value delimiter.
getSeries() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the chart's series.
getSeries() - Method in class com.gembox.spreadsheet.charts.LineChart
Gets the chart's series.
getSheetColumn() - Method in class com.gembox.spreadsheet.HtmlExportPosition
Gets the current sheet column.
getSheetRow() - Method in class com.gembox.spreadsheet.HtmlExportPosition
Gets the current sheet row.
getShowDataAs() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the display format for this PivotField.
getShowEmptyCellsAs() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the value which indicates how empty cells (cells with value equal to null) shall be plotted on the chart.
getSize() - Method in class com.gembox.spreadsheet.charts.Marker
Gets the marker size.
getSize() - Method in class com.gembox.spreadsheet.ExcelFont
Gets the size of the text in twips (1/20th of a point).
getSort() - Method in class com.gembox.spreadsheet.AutoFilter
Gets the AutoFilter sort state.
getSort() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the active SortState.
getSort() - Method in class com.gembox.spreadsheet.FilterColumn
Gets the sort settings applied to this column or null if no sort settings are applied to this column.
getSort() - Method in class com.gembox.spreadsheet.tables.Table
Gets the table sort.
getSortOptions() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the sort options of this pivot field.
getSource() - Method in class com.gembox.spreadsheet.ExcelPicture
 
getSourceName() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the source name (cache field name) of this PivotField.
getSourceType() - Method in class com.gembox.spreadsheet.pivottables.PivotCacheSource
Gets the type of the PivotCache source.
getSourceType() - Method in class com.gembox.spreadsheet.pivottables.WorksheetSource
getStandardDeviations() - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Gets the number of standard deviations above or below average.
getStartIndex() - Method in class com.gembox.spreadsheet.FormattedCharacterRange
Gets the zero-based starting character position.
getStartPageNumber() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Start page number.
getStartPosition() - Method in class com.gembox.spreadsheet.CellRange
Gets name of the first (top-left) cell in this cell range.
getStartRow() - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets the index of the first row of data being loaded from Fixed-Width Text file.
getStartRow() - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets the index of the first row of data being saved to Fixed-Width Text file.
getState() - Method in class com.gembox.spreadsheet.WorksheetPanes
Gets the state of the panes.
getStringValue() - Method in class com.gembox.spreadsheet.ExcelCell
Gets the string value of this cell or of merged range if this cell is merged.
getStyle() - Method in class com.gembox.spreadsheet.AbstractRange
Gets the cell formatting of one or more cells.
getStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Gets the actual formatting which will be applied to a cell if its value satisfies this AboveOrBelowAverageCondition.
getStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainCondition
Gets the actual formatting which will be applied to a cell if its value satisfies this ContainCondition.
getStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.FormulaCondition
Gets the actual formatting which will be applied to a cell if its value satisfies this FormulaCondition.
getStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Gets the actual formatting which will be applied to a cell if its value satisfies this TopOrBottomRankedCondition.
getStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.UniqueOrDuplicateCondition
Gets the actual formatting which will be applied to a cell if its value satisfies this UniqueOrDuplicateCondition.
getStyle() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets the cell formatting of cells in this column / row.
getStyle(String) - Method in class com.gembox.spreadsheet.ExcelFile
Gets the Style from the styles of this workbook that corresponds to given name.
getStyle(BuiltInCellStyleName) - Method in class com.gembox.spreadsheet.ExcelFile
Gets the Style from the styles of this workbook that corresponds to given BuiltInCellStyleName.
getStyleOptions() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the options to be applied to the PivotTable style.
getStyleOptions() - Method in class com.gembox.spreadsheet.tables.Table
Gets the options to be applied to the Table style.
getStyles() - Method in class com.gembox.spreadsheet.ExcelFile
Gets the collection of workbook (master) Styles defined for this ExcelFile instance.
getSubrange(String, String) - Method in class com.gembox.spreadsheet.CellRange
Returns new cell range using start and end position.
getSubrange(String) - Method in class com.gembox.spreadsheet.CellRange
Returns new cell range using A1 style notation.
getSubrangeAbsolute(int, int, int, int) - Method in class com.gembox.spreadsheet.CellRange
Returns new cell range using absolute indexing.
getSubrangeRelative(int, int, int, int) - Method in class com.gembox.spreadsheet.CellRange
Returns new cell range using relative indexing.
getSubtotals() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the subtotals displayed with this PivotField.
getTabColor() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet tab color.
getTable(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the Table at the specified index from the collection of this worksheet.
getTable(String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets Table described by name from the collection of this worksheet.
getTables() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the collection of all Tables contained in this worksheet.
getText() - Method in class com.gembox.spreadsheet.charts.ChartTitle
Gets the title text as direct value (for example, 'My chart title') or as a reference to a cell with value (for example, '=Sheet1!A1').
getText() - Method in class com.gembox.spreadsheet.ExcelComment
Gets the comment text assigned to excel cell
getText() - Method in class com.gembox.spreadsheet.FormattedCharacterRange
Gets the text represented by this character range.
getTickMarksInterval() - Method in class com.gembox.spreadsheet.charts.CategoryAxis
Gets the interval between tick marks that are drawn.
getTitle() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the axis title.
getTitle() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Gets the chart's title.
getTitle() - Method in class com.gembox.spreadsheet.ProtectedRange
Gets the ProtectedRange title.
getTitle() - Static method in class com.gembox.spreadsheet.SpreadsheetInfo
GemBox.Spreadsheet title.
getTitle() - Method in class com.gembox.spreadsheet.tables.TableAlternativeText
Gets the alternative title.
getTo() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the anchor cell which the ExcelDrawing (picture, chart, etc.) spans to.
getToolTip() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Gets ToolTip for hyperlink.
getTop() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the distance (in points) of the top edge of the ExcelDrawing (picture, chart, etc.) from the top edge of the worksheet.
getTop(LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the distance of the top edge of the ExcelDrawing (picture, chart, etc.) from the top edge of the worksheet.
getTopLeftCell() - Method in class com.gembox.spreadsheet.ExcelComment
Gets the top left anchor cell for the comment shape.
getTopLeftCell() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the location of this PivotTable in the worksheet.
getTopLeftCell() - Method in class com.gembox.spreadsheet.WorksheetPanes
Gets the top left visible cell in the bottom right pane.
getTopMargin() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Top margin (in inches).
getTotalsRowFormula() - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the totals row formula.
getTotalsRowFunction() - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the totals row function.
getTransparentColor() - Method in class com.gembox.spreadsheet.ExcelPicture
 
getType() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets value delimiter type, see CsvType.
getType() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets value delimiter type, see CsvType.
getType() - Method in class com.gembox.spreadsheet.DataValidation
Gets the type of data validation.
getType() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets worksheet type.
getType() - Method in class com.gembox.spreadsheet.XlsxSaveOptions
Specifies type of generated file.
getUnderlineStyle() - Method in class com.gembox.spreadsheet.ExcelFont
Gets the underline formatting of the text.
getUnresolvedBorder(IndividualBorder) - Method in class com.gembox.spreadsheet.CellBorders
Gets the unresolved (direct) CellBorder which contains the color and line style for the specified individual border of a cell.
getUsedCellRange(boolean) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Calculates cell range that is used in the worksheet.
getValue() - Method in class com.gembox.spreadsheet.AbstractRange
Gets cell value on one or more excel cells.
getValue() - Method in class com.gembox.spreadsheet.CellRange
Gets cell value on one or more excel cells.
getValue() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObject
Gets the value.
getValue() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Gets the value.
getValue() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainTextCondition
Gets the value of this ContainTextCondition.
getValue() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainValueCondition
Gets the value of this ContainValueCondition.
getValue() - Method in class com.gembox.spreadsheet.CustomFilter
Gets the value used by the (first) filter condition.
getValue() - Method in class com.gembox.spreadsheet.DefinedName
Gets the value of the defined name.
getValue() - Method in class com.gembox.spreadsheet.ExcelCell
Gets value of this cell or of merged range if this cell is merged.
getValue() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Gets the value of the PivotItem.
getValue() - Method in class com.gembox.spreadsheet.Top10Filter
Gets the top or bottom value to use as the filter criteria.
getValue2() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainValueCondition
Gets the second value of this ContainValueCondition used with ContainValueOperator.BETWEEN and ContainValueOperator.NOT_BETWEEN operators.
getValue2() - Method in class com.gembox.spreadsheet.CustomFilter
Gets the value used by the second filter condition.
getValues() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Gets the chart series values.
getValues() - Method in class com.gembox.spreadsheet.ValuesFilter
Gets the list of values to filter by.
getValuesReference() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Gets the chart series values as a cell range reference (for example, 'Sheet1!A1:D1').
getValueType() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Gets the conditional value type.
getValueType() - Method in class com.gembox.spreadsheet.ExcelCell
Gets the cell value type.
getVertical() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the vertical chart axis.
getVerticalAlignment() - Method in class com.gembox.spreadsheet.CellStyle
Gets the vertical alignment.
getVerticalCategory() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the vertical chart axis as category axis, if vertical chart axis is category axis; otherwise null.
getVerticalDate() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the vertical chart axis as date axis, if vertical chart axis is date axis; otherwise null.
getVerticalPageBreaks() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets collection of all vertical page breaks (VerticalPageBreak) in the worksheet.
getVerticalPrintResolution() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Vertical print resolution in DPI (dots per inch).
getVerticalValue() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets the vertical chart axis as value axis, if vertical chart axis is value axis; otherwise null.
getViewOptions() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Contains MS Excel display and view related options.
getViewType() - Method in class com.gembox.spreadsheet.ExcelViewOptions
Gets the view type.
getVisibility() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet visibility.
getWeight() - Method in class com.gembox.spreadsheet.ExcelFont
Gets the font weight (font boldness).
getWidth() - Method in class com.gembox.spreadsheet.CellRange
Gets width of this cell range, in columns.
getWidth() - Method in class com.gembox.spreadsheet.ExcelColumn
Gets column width.
getWidth(LengthUnit) - Method in class com.gembox.spreadsheet.ExcelColumn
Gets the width of column in arbitrary length unit.
getWidth() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the width (in points) of the ExcelDrawing (picture, chart, etc.).
getWidth(LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Gets the width of the ExcelDrawing (picture, chart, etc.).
getWidth() - Method in class com.gembox.spreadsheet.FixedWidthColumn
Gets a value that represents column width.
getWorksheet() - Method in class com.gembox.spreadsheet.ExcelCell
Gets the parent worksheet.
getWorksheet(int) - Method in class com.gembox.spreadsheet.ExcelFile
Gets the worksheet from the worksheet collection of this workbook with the specified index.
getWorksheet(String) - Method in class com.gembox.spreadsheet.ExcelFile
Gets the worksheet from the worksheet collection of this workbook with the specified name.
getWorksheetName() - Method in exception com.gembox.spreadsheet.calculationengine.SpreadsheetParserException
Gets the name of the ExcelWorksheet.
getWorksheets() - Method in class com.gembox.spreadsheet.ExcelFile
Collection of all worksheets (ExcelWorksheet) in a workbook.
getXlsDefault() - Static method in class com.gembox.spreadsheet.LoadOptions
Gets the default options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
getXlsDefault() - Static method in class com.gembox.spreadsheet.SaveOptions
Gets the default options for saving to, XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
getXlsxDefault() - Static method in class com.gembox.spreadsheet.LoadOptions
Gets the default options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
getXlsxDefault() - Static method in class com.gembox.spreadsheet.SaveOptions
Gets the default options for saving to XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
getXSplit() - Method in class com.gembox.spreadsheet.WorksheetPanes
Gets the XSplit value.
getYSplit() - Method in class com.gembox.spreadsheet.WorksheetPanes
Gets the YSplit value.
getZoom() - Method in class com.gembox.spreadsheet.ExcelViewOptions
Magnification factor in normal view.
GradientShadingStyle - Enum in com.gembox.spreadsheet
Represents a shading style and variant of a gradient fill effect.

H

hasEvenPage() - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Returns true if SheetHeaderFooter.getEvenPage() header/footer is specified.
hasFirstPage() - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Returns true if SheetHeaderFooter.getFirstPage() header/footer is specified.
hasFormulas() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets a value indicating the text is formula if it starts with '='.
hashCode() - Method in class com.gembox.spreadsheet.AnchorCell
Returns a hash code for this AnchorCell instance.
hashCode() - Method in class com.gembox.spreadsheet.CellRange
Returns a hash code for this CellRange instance.
hashCode() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Returns a hash code for this ConditionalValue instance.
hashCode() - Method in class com.gembox.spreadsheet.DateTimeGroup
Returns a hash code for this DateTimeGroup instance.
hashCode() - Method in class com.gembox.spreadsheet.ExcelCell
Returns a hash code for this ExcelCell instance.
hashCode() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Returns a hash code for this ExcelColumnRowBase instance.
hashCode() - Method in class com.gembox.spreadsheet.ExcelComment
Returns a hash code for this ExcelComment instance.
hashCode() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Returns the hash code of this object.
hashCode() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Returns a hash code for this SpreadsheetColor instance.
hashCode() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Returns a hash code for this SpreadsheetHyperlink instance.
hashCode() - Method in class com.gembox.spreadsheet.SpreadsheetIcon
Returns a hash code for this SpreadsheetIcon instance.
hashCode() - Method in class com.gembox.spreadsheet.tables.Table
Returns a hash code for this Table instance.
hasHeadersFooters() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Returns true if worksheet has headers/footers.
hasNext() - Method in class com.gembox.spreadsheet.CellRangeIterator
 
hasPassword() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets a value indicating whether the protected sheet has a password.
hasQuotedValues() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets a value indicating whether values in CSV file can be quoted.
hasSplitOrFreezePanes() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Returns true if worksheet has split or freeze panes.
hasTotalsRow() - Method in class com.gembox.spreadsheet.tables.Table
Gets a value indicating whether this table has a totals row.
HeaderFooter - Class in com.gembox.spreadsheet
Represents worksheet's header or footer.
HeaderFooter() - Constructor for class com.gembox.spreadsheet.HeaderFooter
HeaderFooter constructor.
HeaderFooterFieldType - Enum in com.gembox.spreadsheet
Represents types of HeaderFooterSection predefined fields.
HeaderFooterPage - Class in com.gembox.spreadsheet
Represents header/footer which should be shown on a specific worksheet page (first page, even pages and all other pages).
HeaderFooterPage() - Constructor for class com.gembox.spreadsheet.HeaderFooterPage
HeaderFooterPage constructor.
HeaderFooterSection - Class in com.gembox.spreadsheet
Represents header or footer section.
HeaderFooterSection() - Constructor for class com.gembox.spreadsheet.HeaderFooterSection
HeaderFooterSection constructor.
HIGHEST - Static variable in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
horizontal() - Static method in enum com.gembox.spreadsheet.MultipleBorders
Horizontal borders.
HorizontalAlignmentStyle - Enum in com.gembox.spreadsheet
Represents available horizontal alignment options used in CellStyle horizontal alignment member.
HorizontalPageBreak - Class in com.gembox.spreadsheet
Specifies a horizontal position where the new page begins when the worksheet is printed.
HorizontalPageBreakCollection - Class in com.gembox.spreadsheet
Collection of horizontal page breaks (HorizontalPageBreak).
HtmlExportPosition - Class in com.gembox.spreadsheet
Data that describes the current position in the exporter methods.
HtmlExportPosition(CellRange, ExcelRow, ExcelColumn, int, int) - Constructor for class com.gembox.spreadsheet.HtmlExportPosition
Creates new HTML export position.
HtmlLoadOptions - Class in com.gembox.spreadsheet
Represents options for loading from HyperText Markup Language File (HTML) format.
HtmlLoadOptions() - Constructor for class com.gembox.spreadsheet.HtmlLoadOptions
Initializes a new instance of the HtmlLoadOptions class.
HtmlSaveOptions - Class in com.gembox.spreadsheet
Represents options for saving to HyperText Markup Language File (HTML) format.
HtmlSaveOptions() - Constructor for class com.gembox.spreadsheet.HtmlSaveOptions
Initializes a new instance of the HtmlSaveOptions class.
HtmlType - Enum in com.gembox.spreadsheet
Defines type of HTML export.

I

IconSetCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats all cells based on their values by displaying an icon from the specified icon set according to cell's value.
IgnoredError - Class in com.gembox.spreadsheet
Represents a single ignored error for a range of cells.
IgnoredErrorCollection - Class in com.gembox.spreadsheet
Represents a collection of an ignored errors in the worksheet.
IgnoredErrorTypes - Enum in com.gembox.spreadsheet
Represents an ignored error conditions.
indexOf(Object) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
indexOf(Object) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
indexOf(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
Searches for the specified PivotField and returns the zero-based index of the first occurrence within the entire collection.
indexOf(PivotItem) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Searches for the specified PivotItem and returns the zero-based index of the first occurrence within the entire collection.
IndividualBorder - Enum in com.gembox.spreadsheet
Represents single border type of a cell.
insert(InsertShiftDirection) - Method in class com.gembox.spreadsheet.AbstractRange
Inserts a range by shifting cells in the specified direction.
insert(InsertShiftDirection) - Method in class com.gembox.spreadsheet.CellRange
Inserts a range by shifting cells in the specified direction.
insert(InsertShiftDirection) - Method in class com.gembox.spreadsheet.ExcelCell
Inserts a cell by shifting cells in the specified direction.
insert(int) - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Inserts a new TableColumn at the specified index.
insertColumn(int) - Method in class com.gembox.spreadsheet.tables.Table
Inserts a new TableColumn at the specified index to the column collection of this Table.
insertCopy(int, ExcelColumn) - Method in class com.gembox.spreadsheet.ExcelColumnCollection
Inserts copied column at the specified index.
insertCopy(int, int, ExcelColumn) - Method in class com.gembox.spreadsheet.ExcelColumnCollection
Inserts specified number of copied columns at the specified index.
insertCopy(int, ExcelRow) - Method in class com.gembox.spreadsheet.ExcelRowCollection
Inserts copied row at the specified index.
insertCopy(int, int, ExcelRow) - Method in class com.gembox.spreadsheet.ExcelRowCollection
Inserts specified number of copied rows at the specified index.
insertCopy(int, String, ExcelWorksheet) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Inserts a copy of an existing worksheet at the specified index.
insertEmpty(int) - Method in class com.gembox.spreadsheet.ExcelColumnCollection
Inserts empty column at the specified index.
insertEmpty(int, int) - Method in class com.gembox.spreadsheet.ExcelColumnCollection
Inserts specified number of empty columns at the specified index.
insertEmpty(int) - Method in class com.gembox.spreadsheet.ExcelRowCollection
Inserts empty row at the specified index.
insertEmpty(int, int) - Method in class com.gembox.spreadsheet.ExcelRowCollection
Inserts specified number of empty rows at the specified index.
insertEmpty(int, String) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Inserts empty worksheet at the specified index.
insertEmpty(int, SheetType, String) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Inserts empty worksheet at the specified index.
InsertShiftDirection - Enum in com.gembox.spreadsheet
Represents the possible cell add shift directions.
inside() - Static method in enum com.gembox.spreadsheet.MultipleBorders
Inside borders.
isAlignWithMargins() - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Gets if header/footer margin will align with page margins.
isAllowDeletingColumns() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if deleting columns is allowed.
isAllowDeletingRows() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if deleting rows is allowed.
isAllowEditingObjects() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if editing objects is allowed.
isAllowEditingScenarios() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if editing scenarios is allowed.
isAllowFormattingCells() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if formatting cells is allowed.
isAllowFormattingColumns() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if formatting columns is allowed.
isAllowFormattingRows() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if formatting rows is allowed.
isAllowInsertingColumns() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if inserting columns is allowed.
isAllowInsertingHyperlinks() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if inserting hyperlinks is allowed.
isAllowInsertingRows() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if inserting rows is allowed.
isAllowNewLineInQuotes() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets a value indicating whether a new line character can be inside quotes.
isAllowOverlap() - Method in class com.gembox.spreadsheet.charts.ChartLegend
Gets a value indicating whether legend overlaps chart's plot area or resizes it.
isAllowOverlap() - Method in class com.gembox.spreadsheet.charts.ChartTitle
Gets a value indicating whether title overlaps chart's plot area or resizes it.
isAllowSelectingLockedCells() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if selecting locked cells is allowed.
isAllowSelectingUnlockedCells() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if selecting unlocked cells is allowed.
isAllowSorting() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if sorting is allowed.
isAllowUsingAutoFilter() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if using autofilter is allowed.
isAllowUsingPivotTableReports() - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if using pivot table reports is allowed.
isAlwaysQuoteValues() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets a value indicating whether values in CSV file will always be quoted.
isAnyCellMerged() - Method in class com.gembox.spreadsheet.CellRange
Returns true is any cell in this cell range is merged; otherwise, false.
isAutomaticFormulaUpdate() - Method in class com.gembox.spreadsheet.ExcelFile
Gets a value indicating whether the formula address references are automatically updated.
isAxisPositionOnTickMarks() - Method in class com.gembox.spreadsheet.charts.CategoryAxis
Gets a value indicating whether the value axis shall cross the category axis at the midpoint of a category or between data markers.
isBelow() - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Gets a value indicating whether to format cells with values below average.
isBottom() - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Gets a value indicating whether to format cells with bottom ranked values.
isCalculated() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether this PivotField is a calculated field.
isCalculated() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Gets a value indicating whether the PivotItem is a calculated item.
isCaseSensitive() - Method in class com.gembox.spreadsheet.SortState
Gets a value indicating whether the sort is case-sensitive.
isClassicPivotTableLayout() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets a value indicating whether the classic layout should be used for PivotTable display.
isCollapsed() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets whether object is collapsed in outlining.
isCollapsed() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Gets whether the PivotItem is collapsed.
isColumnGrandTotals() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets a value indicating whether the PivotTable shows grand totals for columns.
isDefault() - Method in class com.gembox.spreadsheet.CellStyle
Gets a value indicating whether the referenced workbook style is default (CellStyleCollection.getNormal()) and there are no additional modifications of cell formatting.
isDescending() - Method in class com.gembox.spreadsheet.pivottables.PivotTableSortOptions
Gets a value indicating whether the sort is descending.
isDescending() - Method in class com.gembox.spreadsheet.SortLevel
Gets a value indicating whether to sort the values in the descending order.
isDraftQuality() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing in draft quality, false otherwise.
isDragToColumn() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether this field can be dragged to the column position.
isDragToData() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether this field can be dragged to the data position.
isDragToHide() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether this field can be dragged to the hide position.
isDragToPage() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether this field can be dragged to the page position.
isDragToRow() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether this field can be dragged to the row position.
isDuplicate() - Method in class com.gembox.spreadsheet.conditionalformatting.UniqueOrDuplicateCondition
Gets a value indicating whether to format cells with duplicate values.
isEmbedImages() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets a value indicating whether images are embedded directly within the HTML file in form of Base64 encoding.
isEmpty() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
isEmpty() - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
isEmpty() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Specifies whether this SpreadsheetColor class is uninitialized.
isEnableIterativeCalculation() - Method in class com.gembox.spreadsheet.calculationengine.CalculationOptions
Gets a value indicating whether iterative calculation is enabled.
isEnableMultiplePageItems() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether this field can have multiple items selected in the page field.
isEqual() - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Gets a value indicating whether to format cells with values equal to average.
isEqual() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalIcon
Gets a value indicating whether this or next icon will be shown if cell's value is equal to this ConditionalObject.getValue().
isExternal() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Defines if hyperlink location is in this excel file.
isFieldListSortAscending() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets a value indicating whether fields in the PivotTable are sorted in non-default order in the field list.
isFilterMode() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets a value indicating whether the worksheet is in filter mode.
isFitToPage() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
isGlobalName() - Method in class com.gembox.spreadsheet.NamedRange
Gets global flag
isGradientFill() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Gets a value indicating whether the data bar fill color is gradient or solid.
isHidden() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Gets whether excel object is hidden.
isHidden() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Gets a value indicating whether the PivotItem is hidden.
isHidden() - Method in class com.gembox.spreadsheet.Style
Gets a value indicating whether this style is hidden in the application UI.
isHiddenAutoButton() - Method in class com.gembox.spreadsheet.FilterColumn
Gets a value indicating whether the AutoFilter button for this column is hidden.
isHorizontalCentered() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing sheet horizontal centered, false otherwise.
isIgnoreBlank() - Method in class com.gembox.spreadsheet.DataValidation
Gets a value indicating whether the data validation treats empty or blank entries as valid.
isInCellDropdown() - Method in class com.gembox.spreadsheet.DataValidation
Gets a value indicating whether to display the dropdown combo box for a DataValidationType.LIST data validation type.
isIncludeAlignment() - Method in class com.gembox.spreadsheet.Style
Gets a value indicating whether the alignment formatting specified for this style will be used when this style is applied to a cell.
isIncludeBorder() - Method in class com.gembox.spreadsheet.Style
Gets a value indicating whether the border formatting specified for this style will be used when this style is applied to a cell.
isIncludeFill() - Method in class com.gembox.spreadsheet.Style
Gets a value indicating whether the fill formatting specified for this style will be used when this style is applied to a cell.
isIncludeFont() - Method in class com.gembox.spreadsheet.Style
Gets a value indicating whether the font formatting specified for this style will be used when this style is applied to a cell.
isIncludeNumber() - Method in class com.gembox.spreadsheet.Style
Gets a value indicating whether the number formatting specified for this style will be used when this style is applied to a cell.
isIncludeProtection() - Method in class com.gembox.spreadsheet.Style
Gets a value indicating whether the protection formatting specified for this style will be used when this style is applied to a cell.
isInsertBlankRow() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether to add a blank row after each item.
isItalic() - Method in class com.gembox.spreadsheet.ExcelFont
Gets a value indicating whether to display characters in italic font style.
isLabelContainsCategoryName() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether the category name should be shown in a data label.
isLabelContainsLegendKey() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether the legend key should be shown in a data label.
isLabelContainsSeriesName() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether the series name should be shown in a data label.
isLabelContainsValue() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether the value should be shown in a data label.
isLeftToRight() - Method in class com.gembox.spreadsheet.SortState
Gets a value indicating whether to sort from left to right (whether to sort columns instead of rows).
isLegendEntryVisible() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Gets a value indicating whether legend entry for this series instance is visible.
isLocked() - Method in class com.gembox.spreadsheet.CellStyle
Gets a value indicating whether the cell is locked.
isMerged() - Method in class com.gembox.spreadsheet.CellRange
Gets whether cells in this range are merged.
isNumberFormatLinkedToSource() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets a value indicating whether number format from chart's source data (cells) will be used to format axis value labels.
isNumberFormatLinkedToSource() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether number format from chart's source data (cells) will be used to format data labels.
isOutlineColumnButtonsRight() - Method in class com.gembox.spreadsheet.ExcelViewOptions
Gets whether outline column buttons are displayed on the right side of groups.
isOutlineRowButtonsBelow() - Method in class com.gembox.spreadsheet.ExcelViewOptions
Gets whether outline row buttons are displayed below groups.
isPageOverThenDown() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets a value indicating how the page fields are laid out when there are multiple PivotFields in the page area.
isParseNumbers() - Method in class com.gembox.spreadsheet.CsvLoadOptions
Gets a value indicating whether numbers will be parsed and stored as double value when loading CSV file.
isParseNumbers() - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets a value indicating whether numbers will be parsed and stored as double value when loading Fixed-Width Text file.
isParseNumbers() - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Gets a value indicating whether numbers will be parsed and stored as double value when loading HTML file.
isPercent() - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Gets a value indicating whether the rank value is expressed as a percentage of a number of cells in the applied range.
isPercent() - Method in class com.gembox.spreadsheet.Top10Filter
Gets a value indicating whether or not to filter by percent value of the column.
isPortrait() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for portrait orientation, false for landscape orientation.
isPreserveUnsupportedFeatures() - Method in class com.gembox.spreadsheet.OdsLoadOptions
Gets a value indicating whether to preserve ODS file format features that are not directly supported through GemBox.Spreadsheet object model.
isPreserveUnsupportedFeatures() - Method in class com.gembox.spreadsheet.XlsLoadOptions
Gets a value indicating whether to preserve XLS file format features that are not directly supported through GemBox.Spreadsheet object model.
isPreserveUnsupportedFeatures() - Method in class com.gembox.spreadsheet.XlsxLoadOptions
Gets a value indicating whether to preserve XLSX file format features that are not directly supported through GemBox.Spreadsheet object model.
isPrintBlackWhite() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing in black and white, false otherwise.
isPrintCellNotes() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing cell notes, false otherwise.
isPrintGridlines() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing gridlines, false otherwise.
isPrintHeadings() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for print headings, false otherwise.
isPrintNotesSheetEnd() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing notes at end of sheet, false otherwise.
isPrintPagesInRows() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing pages in rows, false otherwise.
isProtected() - Method in class com.gembox.spreadsheet.ExcelFile
Gets the workbook protection flag.
isProtected() - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the worksheet protection flag.
isProtectStructure() - Method in class com.gembox.spreadsheet.WorkbookProtection
Gets if workbook structure is protected.
isProtectWindows() - Method in class com.gembox.spreadsheet.WorkbookProtection
Gets if workbook window is protected.
isReadDisplayValues() - Method in class com.gembox.spreadsheet.OdsLoadOptions
Read display values instead of stored values.
isReverseIconOrder() - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Gets a value indicating whether the order of icons should be reversed.
isReverseOrder() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets a value indicating whether values on the axis shall be reversed so they go from maximum to minimum.
isRowGrandTotals() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets a value indicating whether the PivotTable shows grand totals for rows.
isScaleWithDoc() - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Gets if headers/footers will be scaled with document scaling.
isShowAll() - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets a value indicating whether to show all items for this field.
isShowBarOnly() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarCondition
Gets a value indicating whether to show bar only.
isShowButton() - Method in class com.gembox.spreadsheet.FilterColumn
Gets a value indicating whether the filter button is visible.
isShowColumnsFromRightToLeft() - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows columns from right to left.
isShowErrorAlert() - Method in class com.gembox.spreadsheet.DataValidation
Gets a value indicating whether to display the error alert message when an invalid value has been entered, according to the criteria specified.
isShowFormulas() - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows formulas.
isShowGridLines() - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows grid lines.
isShowIconOnly() - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Gets a value indicating whether to show icon only.
isShowInPageBreakPreview() - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows worksheet in page break preview.
isShowInputMessage() - Method in class com.gembox.spreadsheet.DataValidation
Gets a value indicating whether to display the input prompt message.
isShowLeaderLines() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether leader lines should be shown for data labels.
isShowMarkers() - Method in class com.gembox.spreadsheet.charts.LineChart
Gets a value indicating whether markers will be shown on series points.
isShowOutlineSymbols() - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows outline symbols.
isShowSheetHeaders() - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows row and column headers.
isShowZeroValues() - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows zero values.
isShrinkToFit() - Method in class com.gembox.spreadsheet.CellStyle
Gets a value indicating whether the displayed text in the cell should be shrunk to fit the cell width.
isStopIfTrue() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Gets a value indicating whether a rule with lower priority may be applied over this rule, when this rule evaluates to true.
isStrikeout() - Method in class com.gembox.spreadsheet.ExcelFont
Gets a value indicating whether to draw a strike-through line through the horizontal middle of the text.
isTextVertical() - Method in class com.gembox.spreadsheet.CellStyle
Gets a value indicating whether text orientation is vertical.
isTop() - Method in class com.gembox.spreadsheet.Top10Filter
Gets a value indicating whether or not to filter by top order.
isUse1904DateSystem() - Method in class com.gembox.spreadsheet.ExcelFile
Gets whether 1904 date system is used.
isUseFormattedValues() - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets a value indicating whether values in CSV file will be formatted using number format.
isUseStartPageNumber() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for using start page number, false otherwise.
isVerticalCentered() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing sheet vertical centered, false otherwise.
isVisible() - Method in class com.gembox.spreadsheet.charts.AxisGridlines
Gets a value indicating whether gridlines are visible.
isVisible() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Gets a value indicating whether any axis is visible.
isVisible() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets a value indicating whether axis is visible.
isVisible() - Method in class com.gembox.spreadsheet.charts.ChartLegend
Gets a value indicating whether legend is visible.
isVisible() - Method in class com.gembox.spreadsheet.charts.ChartTitle
Gets a value indicating whether title is visible.
isVisible() - Method in class com.gembox.spreadsheet.ExcelComment
Gets a value indicating whether this instance is visible.
isWrapText() - Method in class com.gembox.spreadsheet.CellStyle
Gets a value indicating whether the text in a cell should be line-wrapped within the cell.
isWriteCellAddress() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Gets a value indicating whether each td HTML element should contain data-cell attribute with cell address for this cell.
iterator() - Method in class com.gembox.spreadsheet.CellRange
Returns an iterator for the CellRange (all cells).
iterator() - Method in class com.gembox.spreadsheet.CellStyleCollection
Returns an iterator that iterates through the CellStyleCollection.
iterator() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
 
iterator() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Returns an iterator that iterates through the ConditionalFormatRuleCollection.
iterator() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObjectCollectionGeneric
Returns an iterator that iterates through the ConditionalObjectCollectionGeneric.
iterator() - Method in class com.gembox.spreadsheet.DefinedNameCollection
Returns an Iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.ExcelCellCollection
 
iterator() - Method in class com.gembox.spreadsheet.ExcelCommentCollection
Returns an iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
iterator() - Method in class com.gembox.spreadsheet.ExcelEmbeddedObjectCollection
Returns an iterator that iterates through the ExcelEmbeddedObjectCollection.
iterator() - Method in class com.gembox.spreadsheet.ExcelRowColumnCollectionBaseGeneric
Returns an iterator that iterates through the collection.
iterator() - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Returns an iterator for the ExcelWorksheetCollection.
iterator() - Method in class com.gembox.spreadsheet.FilterColumnCollection
Returns an iterator that iterates through the sort levels.
iterator() - Method in class com.gembox.spreadsheet.IgnoredErrorCollection
Returns an iterator that iterates through the IgnoredErrorCollection.
iterator() - Method in class com.gembox.spreadsheet.NamedRangeCollection
Returns an iterator that can iterate through a collection.
iterator() - Method in class com.gembox.spreadsheet.PageBreakCollection
Returns an iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.pivottables.PivotCacheCollection
Returns an iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
Returns an iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.pivottables.PivotFilterCollection
Returns an iterator that iterates through the PivotFilters.
iterator() - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Returns an iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
Returns an iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Returns an iterator that iterates through the ProtectedRangeCollection.
iterator() - Method in class com.gembox.spreadsheet.SortLevelCollection
Returns an iterator that iterates through the sort levels.
iterator() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlinkCollection
Returns an iterator for the collection.
iterator() - Method in class com.gembox.spreadsheet.tables.TableCollection
Gets the collection enumerator.
iterator() - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Gets the collection enumerator.

L

lastIndexOf(Object) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
LengthUnit - Enum in com.gembox.spreadsheet
Represents the measurement unit for measuring length or distance.
LengthUnitConverter - Class in com.gembox.spreadsheet
Utility class used for converting values between various LengthUnit measurement units.
LengthUnitConverter() - Constructor for class com.gembox.spreadsheet.LengthUnitConverter
 
LineChart - Class in com.gembox.spreadsheet.charts
Represents a chart whose series values are drawn using lines.
LineChartSeries - Class in com.gembox.spreadsheet.charts
Represents a single LineChart series.
LineChartSeriesCollection - Class in com.gembox.spreadsheet.charts
Represents a collection of LineChartSeries objects.
LineStyle - Enum in com.gembox.spreadsheet
Represents the line style of a border in a cell.
listIterator() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
listIterator(int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
load(String) - Static method in class com.gembox.spreadsheet.ExcelFile
Loads a spreadsheet from a file with the specified path.
load(String, LoadOptions) - Static method in class com.gembox.spreadsheet.ExcelFile
Loads a spreadsheet from a file with the specified path.
load(InputStream) - Static method in class com.gembox.spreadsheet.ExcelFile
Loads a spreadsheet from the specified stream.
load(InputStream, LoadOptions) - Static method in class com.gembox.spreadsheet.ExcelFile
Loads a spreadsheet from the specified stream.
load(Reader, CsvLoadOptions) - Static method in class com.gembox.spreadsheet.ExcelFile
Loads a spreadsheet from CSV data using the specified reader.
LoadOptions - Class in com.gembox.spreadsheet
Represents a base class for loading options of various file formats.
LOWEST - Static variable in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue

M

Marker - Class in com.gembox.spreadsheet.charts
Represents a marker for LineChartSeries.
MarkerType - Enum in com.gembox.spreadsheet.charts
Represents a marker symbol which will be used on each LineChartSeries data point.
MAX_WEIGHT - Static variable in class com.gembox.spreadsheet.ExcelFont
Maximum font weight.
MIN_WEIGHT - Static variable in class com.gembox.spreadsheet.ExcelFont
Minimum font weight.
move(int, int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
Moves the series at the specified index to a new location in the collection.
move(int, int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Moves the series at the specified index to a new location in the collection.
move(int, int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Moves the ConditionalFormatRule at the specified index to a new location in the ConditionalFormatRuleCollection.
move(int, int) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Moves the ExcelDrawing at the specified index to a new location in the collection thus affecting its Z-index.
move(int, int) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Moves the worksheet at the specified index to a new location in the collection.
move(int, int) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Moves the PivotField at the specified index to a new location in the collection.
move(int, int) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Moves the PivotItem at the specified index to a new location in the collection.
move(int, int) - Method in class com.gembox.spreadsheet.SortLevelCollection
Moves the SortLevel at the specified index to a new location in the SortLevelCollection.
MultipleBorders - Enum in com.gembox.spreadsheet
Represents multiple border types of a cell.

N

NamedRange - Class in com.gembox.spreadsheet
Represents a named range in the worksheet.
NamedRangeCollection - Class in com.gembox.spreadsheet
Collection of the descriptive names which are used to represent cells, ranges of cells, formulas, or constant values.
next() - Method in class com.gembox.spreadsheet.CellRangeIterator
Advances the iterator to the next element of the cell range.
NONE - Static variable in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
NONE - Static variable in class com.gembox.spreadsheet.SpreadsheetIcon
NORMAL_WEIGHT - Static variable in class com.gembox.spreadsheet.ExcelFont
Normal font weight.
NumberType - Enum in com.gembox.spreadsheet
Specifies numeric type

O

OdsLoadOptions - Class in com.gembox.spreadsheet
Represents options for loading from OpenDocument Spreadsheet file format.
OdsLoadOptions() - Constructor for class com.gembox.spreadsheet.OdsLoadOptions
Initializes a new instance of the OdsLoadOptions class.
OdsSaveOptions - Class in com.gembox.spreadsheet
Represents options for saving to OpenDocument Spreadsheet file format.
OdsSaveOptions() - Constructor for class com.gembox.spreadsheet.OdsSaveOptions
Initializes a new instance of the OdsSaveOptions class.
onFreeLimitReached(FreeLimitEventArgs) - Method in interface com.gembox.spreadsheet.FreeLimitReachedListener
The method is called when the free limit is reached
outside() - Static method in enum com.gembox.spreadsheet.MultipleBorders
Outside borders.
overlaps(CellRange) - Method in class com.gembox.spreadsheet.CellRange
Checks if this cell range overlaps with another cell range.

P

PageBreak - Class in com.gembox.spreadsheet
Base class for all page breaks.
PageBreak() - Constructor for class com.gembox.spreadsheet.PageBreak
 
PageBreakCollection<T extends PageBreak> - Class in com.gembox.spreadsheet
Base class for page break collections.
PanePosition - Enum in com.gembox.spreadsheet
Represents the position of the pane.
PanesState - Enum in com.gembox.spreadsheet
Represents the state of the pane.
PaperType - Enum in com.gembox.spreadsheet
Specifies the paper type.
PieChart - Class in com.gembox.spreadsheet.charts
Represents a chart whose single series values are drawn as filled arcs in a pie-like form.
PivotAreaFieldCollection - Class in com.gembox.spreadsheet.pivottables
Represents a collection of visible (row, column, page or data) PivotFields.
PivotCache - Class in com.gembox.spreadsheet.pivottables
Represents a memory cache for a PivotTable.
PivotCacheCollection - Class in com.gembox.spreadsheet.pivottables
Represents a collection of all PivotCache objects in the workbook.
PivotCacheSource - Class in com.gembox.spreadsheet.pivottables
Represents an abstract source of PivotCache data.
PivotCacheSource() - Constructor for class com.gembox.spreadsheet.pivottables.PivotCacheSource
 
PivotCacheSourceType - Enum in com.gembox.spreadsheet.pivottables
Specifies the type of the PivotCache source.
PivotField - Class in com.gembox.spreadsheet.pivottables
Represents a field within a PivotTable.
PivotFieldBaseCollection - Class in com.gembox.spreadsheet.pivottables
Represents a base collection of PivotFields.
PivotFieldCalculationType - Enum in com.gembox.spreadsheet.pivottables
Represents a data PivotField subtotal function.
PivotFieldCollection - Class in com.gembox.spreadsheet.pivottables
Represents a collection of PivotFields.
PivotFieldDisplayFormat - Enum in com.gembox.spreadsheet.pivottables
Represents a data PivotField display format.
PivotFieldLayoutForm - Enum in com.gembox.spreadsheet.pivottables
Represents the way the specified PivotField appear.
PivotFieldSubtotalTypes - Enum in com.gembox.spreadsheet.pivottables
Represents a data PivotField displayed subtotals.
PivotFilter - Class in com.gembox.spreadsheet.pivottables
Represents a filter for a single pivot field.
PivotFilterCollection - Class in com.gembox.spreadsheet.pivottables
Represents a collection of PivotFilters.
PivotItem - Class in com.gembox.spreadsheet.pivottables
Represents an item in a PivotField.
PivotItemCollection - Class in com.gembox.spreadsheet.pivottables
Represents a collection of PivotItems.
PivotItemPosition - Enum in com.gembox.spreadsheet.pivottables
Represents base item Next/Previous/All position in the base field.
PivotTable - Class in com.gembox.spreadsheet.pivottables
Represents a pivot table.
PivotTableCollection - Class in com.gembox.spreadsheet.pivottables
Represents a collection of all PivotTable objects in the worksheet.
PivotTableFilter - Class in com.gembox.spreadsheet.pivottables
Represents PivotTable filter settings and provides filter functionality.
PivotTableSortOptions - Class in com.gembox.spreadsheet.pivottables
Represents the sort options of a pivot field.
PivotTableStyleOptions - Enum in com.gembox.spreadsheet.pivottables
Specifies which options are applied to a PivotTable style.
PositioningMode - Enum in com.gembox.spreadsheet
Option that specify the moving and sizing behavior of the ExcelDrawing (picture, chart, etc.) in the worksheet.
positionToRowColumn(String) - Static method in class com.gembox.spreadsheet.CellRange
Converts position String ("A1", "BN27", etc.) to row and column index.
PRINT_AREA_RESERVED_NAME - Static variable in class com.gembox.spreadsheet.NamedRangeCollection
 
PRINT_TITLES_RESERVED_NAME - Static variable in class com.gembox.spreadsheet.NamedRangeCollection
 
ProtectedRange - Class in com.gembox.spreadsheet
Represents a range of cells to be protected.
ProtectedRangeCollection - Class in com.gembox.spreadsheet
Represents a collection of all protected ranges on the ExcelWorksheet.

R

RangeIndexingMode - Enum in com.gembox.spreadsheet
Indexing modes used by CellRange.
remove(RemoveShiftDirection) - Method in class com.gembox.spreadsheet.AbstractRange
Removes a range by shifting cells in the specified direction.
remove(RemoveShiftDirection) - Method in class com.gembox.spreadsheet.CellRange
Removes a range by shifting cells in the specified direction.
remove(String) - Method in class com.gembox.spreadsheet.CellStyleCollection
Removes style with the specified name from the workbook.
remove(BuiltInCellStyleName) - Method in class com.gembox.spreadsheet.CellStyleCollection
Removes built-in style with the specified name from the workbook.
remove(Style) - Method in class com.gembox.spreadsheet.CellStyleCollection
Removes the specified style from the workbook.
remove(int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
remove(Object) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
remove(ConditionalFormatRule) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
remove(FormatCondition) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Removes a ConditionalFormatRule associated with the specified FormatCondition from the ConditionalFormatRuleCollection.
remove(int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Removes the ConditionalFormatRule at the specified index of the ConditionalFormatRuleCollection.
remove(RemoveShiftDirection) - Method in class com.gembox.spreadsheet.ExcelCell
Removes a cell by shifting cells in the specified direction.
remove(int) - Method in class com.gembox.spreadsheet.ExcelColumnCollection
Removes the column with the specified index.
remove(int, int) - Method in class com.gembox.spreadsheet.ExcelColumnCollection
Removes specified number of columns starting at the specified index.
remove(int) - Method in class com.gembox.spreadsheet.ExcelCommentCollection
Removes the comment at the specified index.
remove(ExcelComment) - Method in class com.gembox.spreadsheet.ExcelCommentCollection
Removes the first occurrence of a specific from the collection.
remove(Object) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
remove(int) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
remove(int) - Method in class com.gembox.spreadsheet.ExcelRowCollection
Removes the row with the specified index.
remove(int, int) - Method in class com.gembox.spreadsheet.ExcelRowCollection
Removes specified number of rows starting at the specified index.
remove(int) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Removes the worksheet with the specified index.
remove(String) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Removes the worksheet with the specified name.
remove(IgnoredError) - Method in class com.gembox.spreadsheet.IgnoredErrorCollection
Removes the specified IgnoredError from the IgnoredErrorCollection.
remove(int) - Method in class com.gembox.spreadsheet.IgnoredErrorCollection
Removes the IgnoredError at the specified index of the IgnoredErrorCollection.
remove(int) - Method in class com.gembox.spreadsheet.PageBreakCollection
Removes the page break at the specified index.
remove(int) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Removes PivotField at the specified index from this area collection.
remove(String) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Removes PivotField with the specified name from this area collection.
remove(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
Removes PivotField from this area collection.
remove(int) - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
Removes the PivotTable at the specified index.
remove(int) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Removes the ProtectedRange at the specified index of the ProtectedRangeCollection.
remove(SortLevel) - Method in class com.gembox.spreadsheet.SortLevelCollection
Removes the specific SortLevel from the SortLevelCollection.
remove(int) - Method in class com.gembox.spreadsheet.SortLevelCollection
Removes the SortLevel at the specified index of the SortLevelCollection.
remove(int) - Method in class com.gembox.spreadsheet.SpreadsheetHyperlinkCollection
Removes the hyperlink at the specified index.
remove(SpreadsheetHyperlink) - Method in class com.gembox.spreadsheet.SpreadsheetHyperlinkCollection
Removes the first occurrence of a specific SpreadsheetHyperlink from the collection.
remove(int, RemoveShiftDirection) - Method in class com.gembox.spreadsheet.tables.TableCollection
Removes the Table at the specified index.
remove(Table, RemoveShiftDirection) - Method in class com.gembox.spreadsheet.tables.TableCollection
Removes the specified Table.
remove(int) - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Removes the TableColumn at the specified index.
remove(TableColumn) - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Removes the specified TableColumn.
remove(int) - Method in class com.gembox.spreadsheet.tables.TableRowCollection
Removes the row at the specified index.
removeAll(Collection<?>) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
removeByColumnRowIndex(int) - Method in class com.gembox.spreadsheet.SortLevelCollection
Removes a SortLevel applied to a column (or a row, if SortState.isLeftToRight() is true) with the specified index from the SortLevelCollection.
removeCalculated(String) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldCollection
Removes the calculated PivotField from the collection of PivotTable fields.
removeCalculated(String) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Removes the calculated PivotItem from the collection.
removeColumn(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Removes the column with the specified index from this worksheet.
removeColumn(int) - Method in class com.gembox.spreadsheet.tables.Table
Removes the TableColumn at the specified index from the column collection of this Table.
removeColumn(TableColumn) - Method in class com.gembox.spreadsheet.tables.Table
Removes the specified TableColumn from the column collection of this Table.
removeDefinedName(String) - Method in class com.gembox.spreadsheet.DefinedNameCollection
Removes the defined name described by name from collection.
removeDefinedNameAt(int) - Method in class com.gembox.spreadsheet.DefinedNameCollection
Removes the defined name described by index from collection.
removeFreeLimitReachedListener(FreeLimitReachedListener) - Static method in class com.gembox.spreadsheet.SpreadsheetInfo
Removes a listener for free limit reached event.
removeMultiple(int, int) - Method in class com.gembox.spreadsheet.tables.TableRowCollection
Removes the specified number of rows at the specified index.
removeRow(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Removes the row with the specified index from this worksheet.
removeRow(int) - Method in class com.gembox.spreadsheet.tables.Table
Removes the row at the specified index from the row collection of this Table.
RemoveShiftDirection - Enum in com.gembox.spreadsheet
Represents the possible cell remove shift directions.
removeStyle(String) - Method in class com.gembox.spreadsheet.ExcelFile
Removes style with the specified name from the workbook.
removeStyle(BuiltInCellStyleName) - Method in class com.gembox.spreadsheet.ExcelFile
Removes built-in style with the specified name from the workbook.
removeStyle(Style) - Method in class com.gembox.spreadsheet.ExcelFile
Removes the specified style from the workbook.
removeWorksheet(int) - Method in class com.gembox.spreadsheet.ExcelFile
Removes the worksheet from the worksheet collection of this workbook with the specified index.
removeWorksheet(String) - Method in class com.gembox.spreadsheet.ExcelFile
Removes the worksheet from the worksheet collection of this workbook with the specified name.
replaceText(String, String) - Method in class com.gembox.spreadsheet.AbstractRange
Replaces all occurrences of the specified text with another text in the current AbstractRange.
replaceText(String, String, boolean) - Method in class com.gembox.spreadsheet.AbstractRange
Replaces all occurrences of the specified text with another text in the current AbstractRange.
replaceText(String, String, boolean, boolean) - Method in class com.gembox.spreadsheet.AbstractRange
Replaces all occurrences of the specified text with another text in the current AbstractRange.
replaceText(Pattern, String) - Method in class com.gembox.spreadsheet.AbstractRange
Replaces all matches of the specified Pattern with specified text in the current AbstractRange.
replaceTextCore(Pattern, String, String, boolean, boolean) - Method in class com.gembox.spreadsheet.CellRange
 
reset() - Method in class com.gembox.spreadsheet.CellRangeIterator
Sets the iterator to its initial position, which is one column before the first cell in the cell range.
RowColumn - Class in com.gembox.spreadsheet
Tuple representing row and column index
rowColumnToPosition(int, int) - Static method in class com.gembox.spreadsheet.CellRange
Converts row and column index to position string ("A1", "BN27", etc.).
rowIndexToName(int) - Static method in class com.gembox.spreadsheet.ExcelRowCollection
Converts row index (0, 1, ...) to row name ("1", "2", ...).
rowNameToIndex(String) - Static method in class com.gembox.spreadsheet.ExcelRowCollection
Converts row name ("1", "2", ...) to row index (0, 1, ...).

S

save(String) - Method in class com.gembox.spreadsheet.ExcelFile
Saves the spreadsheet to a file with the specified path.
save(String, SaveOptions) - Method in class com.gembox.spreadsheet.ExcelFile
Saves the spreadsheet to a file with the specified path.
save(OutputStream, SaveOptions) - Method in class com.gembox.spreadsheet.ExcelFile
Saves the spreadsheet to the specified stream.
save(Writer, CsvSaveOptions) - Method in class com.gembox.spreadsheet.ExcelFile
Save the spreadsheet to CSV format using the specified writer.
SaveOptions - Class in com.gembox.spreadsheet
Represents a base class for saving options of various file formats.
ScriptPosition - Enum in com.gembox.spreadsheet
Defines the possible settings for vertical alignment of a text and is used in ExcelFont.getScriptPosition() member to get superscript or subscript text without altering the font size.
selectData(String) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
selectData(String, boolean) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
selectData(String, boolean, boolean) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
selectData(String, boolean, boolean, boolean) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
selectData(CellRange) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
selectData(CellRange, boolean) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
selectData(CellRange, boolean, boolean) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
selectData(CellRange, boolean, boolean, boolean) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Selects the data for the chart.
SelectionType - Enum in com.gembox.spreadsheet
Defines the selection which will be saved or printed.
set(int, CellRange) - Method in class com.gembox.spreadsheet.CellRangeCollection
 
set(int, T) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
Not supported.
set(int, DataValidation) - Method in class com.gembox.spreadsheet.DataValidationCollection
 
set(int, DefinedName) - Method in class com.gembox.spreadsheet.DefinedNameCollection
Sets defined name described by index from collection.
set(int, T) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
Inserting/setting object into collection is not supported.
set(int, HorizontalPageBreak) - Method in class com.gembox.spreadsheet.HorizontalPageBreakCollection
Sets the horizontal page break at the specified index.
set(int, VerticalPageBreak) - Method in class com.gembox.spreadsheet.VerticalPageBreakCollection
Sets the vertical page break at the specified index.
set2ColorScale() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a '2-Color Scale' formatting condition to this conditional formatting rule.
set3ColorScale() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a '3-Color Scale' formatting condition to this conditional formatting rule.
setAboveOrBelowAverage(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets an 'Above or Below Average' formatting condition to this conditional formatting rule.
setActivePane(PanePosition) - Method in class com.gembox.spreadsheet.WorksheetPanes
Sets the active pane.
setActiveWorksheet(ExcelWorksheet) - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Gets active worksheet.
setAlignWithMargins(boolean) - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Sets if header/footer margin will align with page margins.
setAllowDeletingColumns(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if deleting columns is allowed.
setAllowDeletingRows(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if deleting rows is allowed.
setAllowEditingObjects(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if editing objects is allowed.
setAllowEditingScenarios(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if editing scenarios is allowed.
setAllowFormattingCells(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if formatting cells is allowed.
setAllowFormattingColumns(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if formatting columns is allowed.
setAllowFormattingRows(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if formatting rows is allowed.
setAllowInsertingColumns(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if inserting columns is allowed.
setAllowInsertingHyperlinks(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if inserting hyperlinks is allowed.
setAllowInsertingRows(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if inserting rows is allowed.
setAllowNewLineInQuotes(boolean) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets a value indicating whether a new line character can be inside quotes.
setAllowOverlap(boolean) - Method in class com.gembox.spreadsheet.charts.ChartLegend
Sets a value indicating whether legend overlaps chart's plot area or resizes it.
setAllowOverlap(boolean) - Method in class com.gembox.spreadsheet.charts.ChartTitle
Gets a value indicating whether title overlaps chart's plot area or resizes it.
setAllowSelectingLockedCells(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if selecting locked cells is allowed.
setAllowSelectingUnlockedCells(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if selecting unlocked cells is allowed.
setAllowSorting(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if sorting is allowed.
setAllowUsingAutoFilter(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets if using autofilter is allowed.
setAllowUsingPivotTableReports(boolean) - Method in class com.gembox.spreadsheet.WorksheetProtection
Gets if using pivot table reports is allowed.
setAlwaysQuoteValues(boolean) - Method in class com.gembox.spreadsheet.CsvSaveOptions
Gets a value indicating whether values in CSV file will always be quoted.
setAnd(Optional<Boolean>) - Method in class com.gembox.spreadsheet.CustomFilter
Sets the value indicating whether the two conditions have an "and" relationship.
setAppliesTo(String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets the sequence of references to cell ranges over which this conditional formatting rule is applied.
setAppliesTo(String) - Method in class com.gembox.spreadsheet.IgnoredError
Sets the sequence of references to cell ranges over which this ignored error is applied.
setAuthor(String) - Method in class com.gembox.spreadsheet.ExcelComment
Sets comment author.
setAutomaticFormulaUpdate(boolean) - Method in class com.gembox.spreadsheet.ExcelFile
Sets a value indicating whether the formula address references are automatically updated.
setAutomaticPageBreakScalingFactor(int) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Sets scaling factor for automatic page breaks.
setAxisColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets the data bar axis color.
setAxisPosition(DataBarAxisPosition) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets the data bar axis position.
setAxisPositionOnTickMarks(boolean) - Method in class com.gembox.spreadsheet.charts.CategoryAxis
Sets a value indicating whether the value axis shall cross the category axis at the midpoint of a category or between data markers.
setBackgroundPicture(InputStream, ExcelPictureFormat) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the worksheet background picture.
setBackgroundPicture(String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the worksheet background picture.
setBaseField(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the base field used for a custom calculation.
setBaseItem(PivotItem) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the item in the PivotField.getBaseField() used for a custom calculation.
setBaseItemPosition(PivotItemPosition) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the item position in the PivotField.getBaseField() used for a custom calculation.
setBaseUnit(Optional<TimeUnit>) - Method in class com.gembox.spreadsheet.charts.DateAxis
Sets the smallest time unit that is represented on the date axis or Optional.empty() if value should be automatically calculated based on chart's data.
setBelow(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Sets a value indicating whether to format cells with values below average.
setBorder(SpreadsheetColor, LineStyle) - Method in class com.gembox.spreadsheet.CellBorder
Sets the border color and line style.
setBorderColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets the data bar border color.
setBorders(EnumSet<MultipleBorders>, SpreadsheetColor, LineStyle) - Method in class com.gembox.spreadsheet.CellBorders
Sets the color and line style for the specified multiple borders of a cell.
setBorders(CellBorders) - Method in class com.gembox.spreadsheet.CellStyle
Sets the borders.
setBottom(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Sets a value indicating whether to format cells with bottom ranked values.
setBottomMargin(double) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Bottom margin (in inches).
setBottomRightCell(AnchorCell) - Method in class com.gembox.spreadsheet.ExcelComment
Sets the bottom right anchor cell for the comment shape.
setBuiltIn(BuiltInDocumentProperties, String) - Method in class com.gembox.spreadsheet.DocumentProperties
Sets a built-in property This method has the same effect as using properties.getBuiltIn().put(builtInDocumentProperty, value)
setBuiltInStyle(BuiltInPivotStyleName) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets the built-in style used in the body of the PivotTable.
setBuiltInStyle(BuiltInTableStyleName) - Method in class com.gembox.spreadsheet.tables.Table
Sets the built-in style used in the body of the Table.
setCaseSensitive(boolean) - Method in class com.gembox.spreadsheet.SortState
Sets a value indicating whether the sort is case-sensitive.
setCategoryLabels(Iterable<String>) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Sets the chart's category labels.
setCategoryLabels(String...) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Sets the chart's category labels.
setCategoryLabelsReference(String) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Sets the chart's category labels as a cell range reference (for example, 'Sheet1!A1:D1').
setCenterSection(HeaderFooterSection) - Method in class com.gembox.spreadsheet.HeaderFooter
Sets center section.
setCharset(Charset) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets the charset for the CSV file.
setCharset(Charset) - Method in class com.gembox.spreadsheet.CsvSaveOptions
Sets the charset for the CSV file.
setCharset(Charset) - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets the charset for the Fixed-Width Text file.
setCharset(Charset) - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets the charset for the Fixed-Width Text file.
setCharset(Charset) - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Sets the charset for the HTML file.
setCharset(Charset) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Sets the charset for the Html file.
setClassicPivotTableLayout(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets a value indicating whether the classic layout should be used for PivotTable display.
setCollapsed(boolean) - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Sets whether object is collapsed in outlining.
setCollapsed(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Sets whether the PivotItem is collapsed.
setColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalColor
Sets the color.
setColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFont
Sets the color of the text.
setColumn(ExcelColumn) - Method in class com.gembox.spreadsheet.AnchorCell
Sets the column for the anchor cell.
setColumn(int) - Method in class com.gembox.spreadsheet.VerticalPageBreak
Sets index of the first column of the new page.
setColumnGrandTotals(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets a value indicating whether the PivotTable shows grand totals for columns.
setColumnHeaderCaption(String) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets the String to be displayed in column header in compact mode.
setColumnOffset(long) - Method in class com.gembox.spreadsheet.AnchorCell
Sets the column offset for the anchor cell in EMU units (1 point = 12 700 EMU).
setColumnOffset(double, LengthUnit) - Method in class com.gembox.spreadsheet.AnchorCell
Sets the column offset for the anchor cell in arbitrary length unit.
setColumnRowIndex(int) - Method in class com.gembox.spreadsheet.SortLevel
Sets the column (or the row, if SortState.isLeftToRight() is true) index relative to the range that this sort level applies to.
setComment(ExcelComment) - Method in class com.gembox.spreadsheet.AbstractRange
Sets comment.
setComment(ExcelComment) - Method in class com.gembox.spreadsheet.CellRange
Sets comment
setComment(ExcelComment) - Method in class com.gembox.spreadsheet.ExcelCell
Sets cell comment.
setComparator(Comparator<ExcelCell>) - Method in class com.gembox.spreadsheet.SortLevel
Sets the comparison method that compares two ExcelCells.
setContain(ContainConditionType) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Cells with Blanks' or 'Cells with No Blanks' or 'Cells with Errors' or 'Cells with No Errors' formatting condition to this conditional formatting rule.
setContainDate(ContainDateOperator) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Cells with Dates Occurring' formatting condition to this conditional formatting rule.
setContainText(ContainTextOperator, String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Cells with Specific Text' formatting condition to this conditional formatting rule.
setContainValue(ContainValueOperator, Object) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Cells with Cell Value' formatting condition to this conditional formatting rule.
setContainValue(ContainValueOperator, Object, Object) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Cells with Cell Value' formatting condition to this conditional formatting rule.
setContent(String) - Method in class com.gembox.spreadsheet.HeaderFooterSection
Sets header/footer section content.
setCurrentPageItem(PivotItem) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the current page item showing for the page field.
setCustom(String, String) - Method in class com.gembox.spreadsheet.DocumentProperties
Sets a custom property This method has the same effect as using properties.DocumentProperties.getCustom() () getCustom()}.put(name, value)
setCustomFilter() - Method in class com.gembox.spreadsheet.FilterColumn
Sets a CustomFilter to this column.
setCustomFilter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Sets a CustomFilter to this field.
setCustomList(Iterable<String>) - Method in class com.gembox.spreadsheet.SortLevel
Sets the custom list by which order of items to sort by.
setCustomList(String...) - Method in class com.gembox.spreadsheet.SortLevel
Sets the custom list by which order of items to sort by.
setCustomPageHeight(Optional<Double>) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
 
setCustomPageWidth(Optional<Double>) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
 
setDataBar() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Data Bar' formatting condition to this conditional formatting rule.
setDefaultColumnWidth(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the default column width in 1/256th of the width of the zero character in default font.
setDefaultPage(HeaderFooterPage) - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Sets default header/footer.
setDefaultRowHeight(int) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the default row height in twips (1/20th of a point).
setDescending(boolean) - Method in class com.gembox.spreadsheet.SortLevel
Sets a value indicating whether to sort the values in the descending order.
setDescription(String) - Method in class com.gembox.spreadsheet.tables.TableAlternativeText
Sets the alternative description.
setDirection(ChartTitleDirection) - Method in class com.gembox.spreadsheet.charts.ChartTitle
Sets the title text direction.
setDirection(DataBarDirection) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets the data bar direction.
setDraftQuality(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing in draft quality, false otherwise.
setDragToColumn(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether this field can be dragged to the column position.
setDragToData(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether this field can be dragged to the data position.
setDragToHide(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether this field can be dragged to the hide position.
setDragToPage(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether this field can be dragged to the page position.
setDragToRow(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether this field can be dragged to the row position.
setDuplicate(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.UniqueOrDuplicateCondition
Sets a value indicating whether to format cells with duplicate values.
setDynamicFilter() - Method in class com.gembox.spreadsheet.FilterColumn
Sets a DynamicFilter to this column.
setDynamicFilter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Sets a DynamicFilter to this field.
setDynamicFilterType(DynamicFilterType) - Method in class com.gembox.spreadsheet.DynamicFilter
Sets the dynamic filter type.
setEmbedImages(boolean) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Sets a value indicating whether images are embedded directly within the HTML file in form of Base64 encoding.
setEnableIterativeCalculation(boolean) - Method in class com.gembox.spreadsheet.calculationengine.CalculationOptions
Sets a value indicating whether iterative calculation is enabled.
setEnableMultiplePageItems(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether this field can have multiple items selected in the page field.
setEqual(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Sets a value indicating whether to format cells with values equal to average.
setEqual(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalIcon
Sets a value indicating whether this or next icon will be shown if cell's value is equal to this ConditionalObject.getValue().
setErrorMessage(String) - Method in class com.gembox.spreadsheet.DataValidation
Sets the message text of error alert.
setErrorStyle(DataValidationErrorStyle) - Method in class com.gembox.spreadsheet.DataValidation
Sets the style of error alert used for this data validation.
setErrorTitle(String) - Method in class com.gembox.spreadsheet.DataValidation
Sets the title bar text of error alert.
setErrorTypes(EnumSet<IgnoredErrorTypes>) - Method in class com.gembox.spreadsheet.IgnoredError
Sets the ignored error types.
setEvenPage(HeaderFooterPage) - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Sets header/footer for even pages.
setExternal(boolean) - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Defines if hyperlink location is in this excel file.
setFieldListSortAscending(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets a value indicating whether fields in the PivotTable are sorted in non-default order in the field list.
setFilesDirectoryPath(String) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Sets the physical directory where ExcelPictures and ExcelWorksheets files will be saved.
setFilesDirectorySrcPath(String) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Sets the relative directory that will be used when referencing ExcelPictures and ExcelWorksheets files in the HTML.
setFillColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets the data bar fill color.
setFillPattern(ExcelFillPattern) - Method in class com.gembox.spreadsheet.CellStyle
Sets the fill (cell background).
setFilter(AutoFilter) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Gets the active AutoFilter.
setFilter(AutoFilter) - Method in class com.gembox.spreadsheet.tables.Table
Sets the table filter.
setFirstColumn(int) - Method in class com.gembox.spreadsheet.HorizontalPageBreak
Index of the first column of the new page.
setFirstPage(HeaderFooterPage) - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Sets first page header/footer.
setFirstRow(int) - Method in class com.gembox.spreadsheet.VerticalPageBreak
Sets index of the first row of the new page.
setFirstVisibleColumn(int) - Method in class com.gembox.spreadsheet.ExcelViewOptions
Sets index of the first visible column in the worksheet.
setFirstVisibleRow(int) - Method in class com.gembox.spreadsheet.ExcelViewOptions
Sets index of the first visible row in the worksheet.
setFitToPage(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
setFitWorksheetHeightToPages(int) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Fit worksheet height to this number of pages (0 = use as many as needed).
setFitWorksheetWidthToPages(int) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Fit worksheet width to this number of pages (0 = use as many as needed).
setFont(ExcelFont) - Method in class com.gembox.spreadsheet.CellStyle
Sets the font.
setFooter(HeaderFooter) - Method in class com.gembox.spreadsheet.HeaderFooterPage
Sets footer for this HeaderFooterPage instance.
setFooterMargin(double) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Footer margin (in inches).
setFormula(String) - Method in class com.gembox.spreadsheet.AbstractRange
Sets formula string.
setFormula(String) - Method in class com.gembox.spreadsheet.CellRange
Sets formula string.
setFormula(String) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Formula' formatting condition to this conditional formatting rule.
setFormula(String) - Method in class com.gembox.spreadsheet.conditionalformatting.FormulaCondition
Sets the formula used to determine which cells to format (only cells for which the formula result evaluates to true are formatted).
setFormula(String) - Method in class com.gembox.spreadsheet.ExcelCell
Sets cell formula string.
setFormula1(Object) - Method in class com.gembox.spreadsheet.DataValidation
Sets the first formula in the DataValidation dropdown.
setFormula2(Object) - Method in class com.gembox.spreadsheet.DataValidation
Sets the second formula in the DataValidation dropdown.
setFormulaHidden(boolean) - Method in class com.gembox.spreadsheet.CellStyle
Sets a value indicating whether the contents of the cell will not be displayed in the formula bar.
setFreeLimitReachedAction(FreeLimitReachedAction) - Method in class com.gembox.spreadsheet.FreeLimitEventArgs
Sets the choice for proceeding when free limit is reached.
setFrom(AnchorCell) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the anchor cell which the ExcelDrawing (picture, chart, etc.) spans from.
setFunction(PivotFieldCalculationType) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the function used to summarize/aggregate this PivotField.
setGradient(GradientShadingStyle, SpreadsheetColor, SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the gradient fill effect.
setGradientColor1(SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the first color of the gradient fill effect.
setGradientColor2(SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the second color of the gradient fill effect.
setGradientFill(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets a value indicating whether the data bar fill color is gradient or solid.
setGradientStyle(GradientShadingStyle) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the shading style of the gradient fill effect, if there is any gradient fill effect applied.
setGrouping(ChartGrouping) - Method in class com.gembox.spreadsheet.charts.AreaChart
Sets the chart grouping.
setGrouping(ChartGrouping) - Method in class com.gembox.spreadsheet.charts.BarChart
Gets the chart grouping.
setGrouping(ChartGrouping) - Method in class com.gembox.spreadsheet.charts.ColumnChart
Sets the chart grouping.
setGrouping(ChartGrouping) - Method in class com.gembox.spreadsheet.charts.LineChart
Sets the chart grouping.
setGroupMethodsAffectedCellsLimit(int) - Method in class com.gembox.spreadsheet.ExcelFile
Maximum number of affected cells in group set methods.
setHasFormulas(boolean) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets a value indicating the text is formula if it starts with '='.
setHasQuotedValues(boolean) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets a value indicating whether values in CSV file can be quoted.
setHasTotalsRow(boolean) - Method in class com.gembox.spreadsheet.tables.Table
Sets a value indicating whether this table has a totals row.
setHeader(HeaderFooter) - Method in class com.gembox.spreadsheet.HeaderFooterPage
Sets header for this HeaderFooterPage instance.
setHeaderMargin(double) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Header margin (in inches).
setHeadersFooters(SheetHeaderFooter) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets headers/footers for the sheet.
setHeight(double) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the height (in points) of the ExcelDrawing (picture, chart, etc.).
setHeight(double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the height of the ExcelDrawing (picture, chart, etc.).
setHeight(int) - Method in class com.gembox.spreadsheet.ExcelRow
Sets row height.
setHeight(double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelRow
Sets the height of row in arbitrary length unit.
setHidden(boolean) - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Sets whether excel object is hidden.
setHidden(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotItem
Sets a value indicating whether the PivotItem is hidden.
setHidden(boolean) - Method in class com.gembox.spreadsheet.Style
Sets a value indicating whether this style is hidden in the application UI.
setHiddenAutoButton(boolean) - Method in class com.gembox.spreadsheet.FilterColumn
Sets a value indicating whether the AutoFilter button for this column is hidden.
setHorizontalAlignment(HorizontalAlignmentStyle) - Method in class com.gembox.spreadsheet.CellStyle
Sets the horizontal alignment.
setHorizontalCentered(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing sheet horizontal centered, false otherwise.
setHtmlType(HtmlType) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Sets the type of export.
setHyperlink(SpreadsheetHyperlink) - Method in class com.gembox.spreadsheet.AbstractRange
Sets hyperlink.
setHyperlink(SpreadsheetHyperlink) - Method in class com.gembox.spreadsheet.CellRange
Sets hyperlink
setHyperlink(SpreadsheetHyperlink) - Method in class com.gembox.spreadsheet.ExcelCell
Sets cell hyperlink.
setHyperlink(SpreadsheetHyperlink) - Method in class com.gembox.spreadsheet.ExcelDrawing
Sets the hyperlink on this drawing (picture, chart, etc.).
setIcon(SpreadsheetIcon) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalIcon
Sets the icon.
setIconSet() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets an 'Icon Set' formatting condition to this conditional formatting rule.
setIconStyle(SpreadsheetIconStyle) - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Sets the icon style for all icons contained in the icons collection.
setIgnoreBlank(boolean) - Method in class com.gembox.spreadsheet.DataValidation
Sets a value indicating whether the data validation treats empty or blank entries as valid.
setInCellDropdown(boolean) - Method in class com.gembox.spreadsheet.DataValidation
Sets a value indicating whether to display the dropdown combo box for a DataValidationType.LIST data validation type.
setIncludeAlignment(boolean) - Method in class com.gembox.spreadsheet.Style
Sets a value indicating whether the alignment formatting specified for this style will be used when this style is applied to a cell.
setIncludeBorder(boolean) - Method in class com.gembox.spreadsheet.Style
Sets a value indicating whether the border formatting specified for this style will be used when this style is applied to a cell.
setIncludeFill(boolean) - Method in class com.gembox.spreadsheet.Style
Sets a value indicating whether the fill formatting specified for this style will be used when this style is applied to a cell.
setIncludeFont(boolean) - Method in class com.gembox.spreadsheet.Style
Sets a value indicating whether the font formatting specified for this style will be used when this style is applied to a cell.
setIncludeNumber(boolean) - Method in class com.gembox.spreadsheet.Style
Sets a value indicating whether the number formatting specified for this style will be used when this style is applied to a cell.
setIncludeProtection(boolean) - Method in class com.gembox.spreadsheet.Style
Sets a value indicating whether the protection formatting specified for this style will be used when this style is applied to a cell.
setIndent(int) - Method in class com.gembox.spreadsheet.CellStyle
Sets the number of spaces (of the CellStyleCollection.getNormal() style font) of indentation for text in a cell.
setInputMessage(String) - Method in class com.gembox.spreadsheet.DataValidation
Sets the message text of input prompt.
setInputMessageTitle(String) - Method in class com.gembox.spreadsheet.DataValidation
Sets the title bar text of input prompt.
setInsertBlankRow(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether to add a blank row after each item.
setItalic(boolean) - Method in class com.gembox.spreadsheet.ExcelFont
Sets a value indicating whether to display characters in italic font style.
setLabelContainsCategoryName(boolean) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Sets a value indicating whether the category name should be shown in a data label.
setLabelContainsLegendKey(boolean) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Sets a value indicating whether the legend key should be shown in a data label.
setLabelContainsSeriesName(boolean) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether the series name should be shown in a data label.
setLabelContainsValue(boolean) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Gets a value indicating whether the value should be shown in a data label.
setLabelPosition(DataLabelPosition) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Sets the position of the data label.
setLabelsInterval(Optional<Integer>) - Method in class com.gembox.spreadsheet.charts.CategoryAxis
Sets the interval between labels that are drawn.
setLabelsPosition(AxisLabelsPosition) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets the axis labels position.
setLastColumn(int) - Method in class com.gembox.spreadsheet.HorizontalPageBreak
Index of the last column of the new page.
setLastRow(int) - Method in class com.gembox.spreadsheet.VerticalPageBreak
Sets index of the last row of the new page.
setLayoutForm(PivotFieldLayoutForm) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the layout form for this PivotField.
setLeft(double) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the distance (in points) of the left edge of the ExcelDrawing (picture, chart, etc.) from the left edge of the worksheet.
setLeft(double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the distance of the left edge of the ExcelDrawing (picture, chart, etc.) from the left edge of the worksheet.
setLeftMargin(double) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Left margin (in inches).
setLeftSection(HeaderFooterSection) - Method in class com.gembox.spreadsheet.HeaderFooter
Sets left section.
setLeftToRight(boolean) - Method in class com.gembox.spreadsheet.SortState
Sets a value indicating whether to sort from left to right (whether to sort columns instead of rows).
setLegend(ChartLegend) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Sets the chart's legend.
setLegendEntryVisible(boolean) - Method in class com.gembox.spreadsheet.charts.ChartSeries
Sets a value indicating whether legend entry for this series instance is visible.
setLength(int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalLength
Sets the data bar length as a percentage of the cell width.
setLicense(String) - Static method in class com.gembox.spreadsheet.SpreadsheetInfo
Call this method from your application to set GemBox.Spreadsheet serial key.
setLineColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.CellBorder
Sets the border line color.
setLineStyle(LineStyle) - Method in class com.gembox.spreadsheet.CellBorder
Sets the line style for this CellBorder.
setLoadConverter(Function<String, Object>) - Method in class com.gembox.spreadsheet.FixedWidthColumn
Sets the converter for converting value from file to ExcelCell value when loading from Fixed-Width Text file.
setLocale(Locale) - Method in class com.gembox.spreadsheet.CsvSaveOptions
Sets the locale for the CSV file.
setLocale(Locale) - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Gets the locale for the Fixed-Width Text file.
setLocale(Locale) - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Gets the locale for the Fixed-Width Text file.
setLocalSheetIndex(int) - Method in class com.gembox.spreadsheet.DefinedName
Sets the local sheet index of the defined name.
setLocation(String) - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Sets the location string for hyperlink.
setLocked(boolean) - Method in class com.gembox.spreadsheet.CellStyle
Sets a value indicating whether the cell is locked.
setMajorTickMarkType(TickMarkType) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Sets the major tick marks position.
setMajorTimeUnit(TimeUnit) - Method in class com.gembox.spreadsheet.charts.DateAxis
Sets the time unit for major tick marks.
setMajorUnit(Optional<Double>) - Method in class com.gembox.spreadsheet.charts.DateAxis
Sets the distance between major ticks or Optional.empty() if value should be automatically calculated based on chart's data.
setMajorUnit(Optional<Double>) - Method in class com.gembox.spreadsheet.charts.ValueAxis
Sets the distance between major ticks or Optional.empty() if value should be automatically calculated based on chart's data.
setMarkerType(MarkerType) - Method in class com.gembox.spreadsheet.charts.Marker
Sets the marker type.
setMatch(Predicate<ExcelCell>) - Method in class com.gembox.spreadsheet.FilterColumn
Sets the method that defines a set of criteria and determines whether the specified ExcelCell meets those criteria.
setMaximum(Optional<LocalDateTime>) - Method in class com.gembox.spreadsheet.charts.DateAxis
Sets or sets the maximum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
setMaximum(Optional<Double>) - Method in class com.gembox.spreadsheet.charts.ValueAxis
Sets the maximum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
setMaximumChange(double) - Method in class com.gembox.spreadsheet.calculationengine.CalculationOptions
Sets the maximum calculation change.
setMaximumIterations(int) - Method in class com.gembox.spreadsheet.calculationengine.CalculationOptions
Sets the maximum calculation iterations.
setMeasureField(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Sets the pivot field containing summary values being filtered.
setMerged(boolean) - Method in class com.gembox.spreadsheet.CellRange
Sets whether cells in this range are merged.
setMinimum(Optional<LocalDateTime>) - Method in class com.gembox.spreadsheet.charts.DateAxis
Sets the minimum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
setMinimum(Optional<Double>) - Method in class com.gembox.spreadsheet.charts.ValueAxis
Sets the minimum value of the axis or Optional.empty() if value should be automatically calculated based on chart's data.
setMinorTickMarkType(TickMarkType) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Sets the minor tick marks position.
setMinorTimeUnit(TimeUnit) - Method in class com.gembox.spreadsheet.charts.DateAxis
Sets the time unit for minor tick marks.
setMinorUnit(Optional<Double>) - Method in class com.gembox.spreadsheet.charts.DateAxis
Sets the distance between minor ticks or Optional.empty() if value should be automatically calculated based on chart's data.
setMinorUnit(Optional<Double>) - Method in class com.gembox.spreadsheet.charts.ValueAxis
Sets the distance between minor ticks or Optional.empty() if value should be automatically calculated based on chart's data.
setMode(PositioningMode) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the positioning mode of the ExcelDrawing (picture, chart, etc.).
setName(String) - Method in class com.gembox.spreadsheet.charts.ChartSeries
Sets the series name as direct value (for example, 'My series') or as a reference to a cell with value (for example, '=Sheet1!A1').
setName(String) - Method in class com.gembox.spreadsheet.DefinedName
Sets the name of the defined name object.
setName(String) - Method in class com.gembox.spreadsheet.ExcelDrawingMetadata
Sets the name for the current drawing.
setName(String) - Method in class com.gembox.spreadsheet.ExcelFont
Sets the face name of this font.
setName(String) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets worksheet name.
setName(String) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the custom name (label text) of this PivotField.
setName(String) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Gets the name of the PivotTable.
setName(String) - Method in class com.gembox.spreadsheet.Style
Sets the name of this style.
setName(String) - Method in class com.gembox.spreadsheet.tables.TableColumn
Sets the column name.
setNameInternal(String) - Method in class com.gembox.spreadsheet.pivottables.PivotField
 
setNegativeBorderColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets the data bar border color for negative values.
setNegativeFillColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Sets the data bar fill color for negative values.
setNumberFormat(String) - Method in class com.gembox.spreadsheet.CellStyle
Sets the number format which indicates how to format and render the numeric value of a cell.
setNumberFormat(String) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Sets the number format used for formatting axis value labels.
setNumberFormat(String) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Sets the number format used for formatting data labels.
setNumberFormat(String) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Gets the number format which indicates how to format the numeric value of this field.
setNumberFormatLinkedToSource(boolean) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Gets a value indicating whether number format from chart's source data (cells) will be used to format axis value labels.
setNumberFormatLinkedToSource(boolean) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Sets a value indicating whether number format from chart's source data (cells) will be used to format data labels.
setNumberOfCopies(int) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Number of copies to print.
setNumberStyles(NumberType) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets a value indicating numeric type used when parsing strings to numeric types.
setNumberType(NumberType) - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Sets a value indicating numeric type used when parsing strings to numeric types.
setNumberType(NumberType) - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Sets a value indicating numeric type used when parsing strings to numeric types.
setOperator(ContainDateOperator) - Method in class com.gembox.spreadsheet.conditionalformatting.ContainDateCondition
Sets the operator of this ContainDateCondition.
setOperator(ContainTextOperator) - Method in class com.gembox.spreadsheet.conditionalformatting.ContainTextCondition
Sets the operator of this ContainTextCondition.
setOperator(ContainValueOperator) - Method in class com.gembox.spreadsheet.conditionalformatting.ContainValueCondition
Sets the operator of this ContainValueCondition.
setOperator(FilterOperator) - Method in class com.gembox.spreadsheet.CustomFilter
Sets the operator used by the (first) filter condition.
setOperator(DataValidationOperator) - Method in class com.gembox.spreadsheet.DataValidation
Sets the relational operator used with this data validation.
setOperator2(FilterOperator) - Method in class com.gembox.spreadsheet.CustomFilter
Sets the operator used by the second filter condition.
setOutlineColumnButtonsRight(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
Sets whether outline column buttons are displayed on the right side of groups.
setOutlineLevel(int) - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Sets outline level.
setOutlineRowButtonsBelow(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
Sets whether outline row buttons are displayed below groups.
setPageBreakViewZoom(int) - Method in class com.gembox.spreadsheet.ExcelViewOptions
Magnification factor in page break view.
setPageOverThenDown(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets a value indicating how the page fields are laid out when there are multiple PivotFields in the page area.
setPanes(WorksheetPanes) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the panes in the worksheet.
setPaperType(PaperType) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Sets the type of the paper for the page.
setParseLocale(Locale) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets the locale for the CSV file.
setParseLocale(Locale) - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Sets the Locale for the HTML file.
setParseNumbers(boolean) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets a value indicating whether numbers will be parsed and stored as double value when loading CSV file.
setParseNumbers(boolean) - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Sets a value indicating whether numbers will be parsed and stored as double value when loading Fixed-Width Text file.
setParseNumbers(boolean) - Method in class com.gembox.spreadsheet.HtmlLoadOptions
Sets a value indicating whether numbers will be parsed and stored as double value when loading HTML file.
setPassword(String) - Method in class com.gembox.spreadsheet.ProtectedRange
Sets the ProtectedRange password.
setPassword(String) - Method in class com.gembox.spreadsheet.WorkbookProtection
Sets the password for protected workbook.
setPassword(String) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets the password for protected sheet.
setPassword(String) - Method in class com.gembox.spreadsheet.XlsLoadOptions
Sets the password to open protected / encrypted workbook.
setPassword(String) - Method in class com.gembox.spreadsheet.XlsSaveOptions
Sets the password used to protect / encrypt the workbook.
setPassword(String) - Method in class com.gembox.spreadsheet.XlsxLoadOptions
Sets the password to open protected / encrypted workbook.
setPassword(String) - Method in class com.gembox.spreadsheet.XlsxSaveOptions
Sets the password used to protect / encrypt the workbook.
setPasswordHash(int) - Method in class com.gembox.spreadsheet.WorkbookProtection
Sets the password hash for protected workbook.
setPasswordHash(int) - Method in class com.gembox.spreadsheet.WorksheetProtection
Sets the password hash for protected sheet.
setPattern(FillPatternStyle, SpreadsheetColor, SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the pattern fill.
setPatternBackgroundColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the pattern fill background color.
setPatternForegroundColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the pattern fill foreground color.
setPatternStyle(FillPatternStyle) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the pattern fill style.
setPercent(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Sets a value indicating whether the rank value is expressed as a percentage of a number of cells in the applied range.
setPercent(boolean) - Method in class com.gembox.spreadsheet.Top10Filter
Sets a value indicating whether or not to filter by percent value of the column.
setPortrait(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for portrait orientation, false for landscape orientation.
setPosition(ChartLegendPosition) - Method in class com.gembox.spreadsheet.charts.ChartLegend
Sets the legend position.
setPreserveUnsupportedFeatures(boolean) - Method in class com.gembox.spreadsheet.OdsLoadOptions
Sets a value indicating whether to preserve ODS file format features that are not directly supported through GemBox.Spreadsheet object model.
setPreserveUnsupportedFeatures(boolean) - Method in class com.gembox.spreadsheet.XlsLoadOptions
Sets a value indicating whether to preserve XLS file format features that are not directly supported through GemBox.Spreadsheet object model.
setPreserveUnsupportedFeatures(boolean) - Method in class com.gembox.spreadsheet.XlsxLoadOptions
Sets a value indicating whether to preserve XLSX file format features that are not directly supported through GemBox.Spreadsheet object model.
setPrintArea(CellRange) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Sets print area.
setPrintArea(CellRange...) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Sets multi-range print area.
setPrintArea(Iterable<CellRange>) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Sets multi-range print area.
setPrintBlackWhite(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing in black and white, false otherwise.
setPrintCellNotes(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing cell notes, false otherwise.
setPrintGridlines(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing gridlines, false otherwise.
setPrintHeadings(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for print headings, false otherwise.
setPrintNotesSheetEnd(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing notes at end of sheet, false otherwise.
setPrintPagesInRows(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing pages in rows, false otherwise.
setPrintResolution(int) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Print resolution in DPI (dots per inch).
setPrintTitles(ExcelRow, int) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Sets print titles (rows to repeat at top).
setPrintTitles(ExcelColumn, int) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Sets print titles (columns to repeat at left).
setPrintTitles(ExcelColumnRowBase, int, ExcelColumnRowBase, int) - Method in class com.gembox.spreadsheet.NamedRangeCollection
Sets print titles.
setProtected(boolean) - Method in class com.gembox.spreadsheet.ExcelFile
Sets the workbook protection flag.
setProtected(boolean) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the worksheet protection flag.
setProtectStructure(boolean) - Method in class com.gembox.spreadsheet.WorkbookProtection
Sets if workbook structure is protected.
setProtectWindows(boolean) - Method in class com.gembox.spreadsheet.WorkbookProtection
Sets if workbook window is protected.
setQuotePrefix(boolean) - Method in class com.gembox.spreadsheet.CellStyle
Sets a value indicating whether the text string in a cell should be prefixed by a single quote mark (e.g., 'text).
setRange(CellRange) - Method in class com.gembox.spreadsheet.NamedRange
Sets the named cell range.
setRank(int) - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Sets the number or percentage of top or bottom ranked cells which are formatted.
setReadDisplayValues(boolean) - Method in class com.gembox.spreadsheet.OdsLoadOptions
Set to read display values instead of stored values.
setRefersToCells(String) - Method in class com.gembox.spreadsheet.ProtectedRange
Sets the range to be protected.
setReverseIconOrder(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Sets a value indicating whether the order of icons should be reversed.
setReverseOrder(boolean) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Sets a value indicating whether values on the axis shall be reversed so they go from maximum to minimum.
setRightMargin(double) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Left margin (in inches).
setRightSection(HeaderFooterSection) - Method in class com.gembox.spreadsheet.HeaderFooter
Sets right section.
setRotation(int) - Method in class com.gembox.spreadsheet.CellStyle
Sets the text rotation in degrees (1/360th of a full circle).
setRow(ExcelRow) - Method in class com.gembox.spreadsheet.AnchorCell
Sets the row for the anchor cell.
setRow(int) - Method in class com.gembox.spreadsheet.HorizontalPageBreak
Index of the first row of the new page.
setRowGrandTotals(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets a value indicating whether the PivotTable shows grand totals for rows.
setRowHeaderCaption(String) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets the String to be displayed in row header in compact mode.
setRowOffset(long) - Method in class com.gembox.spreadsheet.AnchorCell
Sets row offset for the anchor cell in EMU units (1 point = 12 700 EMU).
setRowOffset(double, LengthUnit) - Method in class com.gembox.spreadsheet.AnchorCell
Sets the row offset for the anchor cell in arbitrary length unit.
setSaveConverter(Function<Object, String>) - Method in class com.gembox.spreadsheet.FixedWidthColumn
Sets the converter for converting ExcelCell value to text when saving to Fixed-Width Text file.
setScaleWithDoc(boolean) - Method in class com.gembox.spreadsheet.SheetHeaderFooter
Sets if headers/footers will be scaled with document scaling.
setScriptPosition(ScriptPosition) - Method in class com.gembox.spreadsheet.ExcelFont
Sets the vertical position of the text relative to the text's default appearance.
setSelectionType(SelectionType) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Sets a value indicating whether to save the whole ExcelFile or just active worksheet.
setSeparator(String) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Sets the text that should be used to separate the parts of a data label.
setSeparator(char) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets character that serves as value delimiter.
setSeparator(char) - Method in class com.gembox.spreadsheet.CsvSaveOptions
Sets character that serves as value delimiter.
setShowAll(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets a value indicating whether to show all items for this field.
setShowBarOnly(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarCondition
Sets a value indicating whether to show bar only.
setShowButton(boolean) - Method in class com.gembox.spreadsheet.FilterColumn
Sets a value indicating whether the filter button is visible.
setShowColumnsFromRightToLeft(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows columns from right to left.
setShowDataAs(PivotFieldDisplayFormat) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the display format for this PivotField.
setShowEmptyCellsAs(EmptyCellDisplayMode) - Method in class com.gembox.spreadsheet.charts.ExcelChart
Sets the value which indicates how empty cells (cells with value equal to null) shall be plotted on the chart.
setShowErrorAlert(boolean) - Method in class com.gembox.spreadsheet.DataValidation
Sets a value indicating whether to display the error alert message when an invalid value has been entered, according to the criteria specified.
setShowFormulas(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows formulas.
setShowGridLines(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows grid lines.
setShowIconOnly(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Sets a value indicating whether to show icon only.
setShowInPageBreakPreview(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows worksheet in page break preview.
setShowInputMessage(boolean) - Method in class com.gembox.spreadsheet.DataValidation
Sets a value indicating whether to display the input prompt message.
setShowLeaderLines(boolean) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Sets a value indicating whether leader lines should be shown for data labels.
setShowMarkers(boolean) - Method in class com.gembox.spreadsheet.charts.LineChart
Sets a value indicating whether markers will be shown on series points.
setShowOutlineSymbols(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows outline symbols.
setShowSheetHeaders(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows row and column headers.
setShowZeroValues(boolean) - Method in class com.gembox.spreadsheet.ExcelViewOptions
If true, MS Excel shows zero values.
setShrinkToFit(boolean) - Method in class com.gembox.spreadsheet.CellStyle
Sets a value indicating whether the displayed text in the cell should be shrunk to fit the cell width.
setSize(double) - Method in class com.gembox.spreadsheet.charts.Marker
Sets the marker size.
setSize(int) - Method in class com.gembox.spreadsheet.ExcelFont
Sets the size of the text in twips (1/20th of a point).
setSolid(SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelFillPattern
Sets the solid pattern fill with the specified fill color.
setSort(SortState) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the active SortState.
setSort() - Method in class com.gembox.spreadsheet.FilterColumn
Sets a SortLevel to this column.
setStandardDeviations(int) - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Sets the number of standard deviations above or below average.
setStartPageNumber(int) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Set start page number.
setStartRow(int) - Method in class com.gembox.spreadsheet.FixedWidthLoadOptions
Sets the index of the first row of data being loaded from Fixed-Width Text file.
setStartRow(int) - Method in class com.gembox.spreadsheet.FixedWidthSaveOptions
Sets the index of the first row of data being saved to Fixed-Width Text file.
setState(PanesState) - Method in class com.gembox.spreadsheet.WorksheetPanes
Sets the state of the panes.
setStopIfTrue(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a value indicating whether a rule with lower priority may be applied over this rule, when this rule evaluates to true.
setStrikeout(boolean) - Method in class com.gembox.spreadsheet.ExcelFont
Sets a value indicating whether to draw a strike-through line through the horizontal middle of the text.
setStyle(CellStyle) - Method in class com.gembox.spreadsheet.AbstractRange
Sets the cell formatting of one or more cells.
setStyle(CellStyle) - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Sets the cell formatting of cells in this column / row.
setStyleOptions(EnumSet<PivotTableStyleOptions>) - Method in class com.gembox.spreadsheet.pivottables.PivotTable
Sets the options to be applied to the PivotTable style.
setStyleOptions(EnumSet<TableStyleOptions>) - Method in class com.gembox.spreadsheet.tables.Table
Sets the options to be applied to the Table style.
setSubtotals(EnumSet<PivotFieldSubtotalTypes>) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sets the subtotals displayed with this PivotField.
setTabColor(SpreadsheetColor) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the worksheet tab color.
setText(String) - Method in class com.gembox.spreadsheet.charts.ChartTitle
Sets the title text as direct value (for example, 'My chart title') or as a reference to a cell with value (for example, '=Sheet1!A1').
setText(String) - Method in class com.gembox.spreadsheet.ExcelComment
Sets the comment text assigned to excel cell
setTextVertical(boolean) - Method in class com.gembox.spreadsheet.CellStyle
Sets the text rotation in degrees (1/360th of a full circle).
setTickMarksInterval(int) - Method in class com.gembox.spreadsheet.charts.CategoryAxis
Sets the interval between tick marks that are drawn.
setTitle(String) - Method in class com.gembox.spreadsheet.ProtectedRange
Sets the ProtectedRange title.
setTitle(String) - Method in class com.gembox.spreadsheet.tables.TableAlternativeText
Sets the alternative title.
setTo(AnchorCell) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the anchor cell which the ExcelDrawing (picture, chart, etc.) spans to.
setToolTip(String) - Method in class com.gembox.spreadsheet.SpreadsheetHyperlink
Sets ToolTip for hyperlink.
setTop(double) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the distance (in points) of the top edge of the ExcelDrawing (picture, chart, etc.) from the top edge of the worksheet.
setTop(double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the distance of the top edge of the ExcelDrawing (picture, chart, etc.) from the top edge of the worksheet.
setTop(boolean) - Method in class com.gembox.spreadsheet.Top10Filter
Sets a value indicating whether or not to filter by top order.
setTop10Filter() - Method in class com.gembox.spreadsheet.FilterColumn
Sets a Top10Filter to this column.
setTop10Filter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Sets a Top10Filter to this field.
setTopLeftCell(AnchorCell) - Method in class com.gembox.spreadsheet.ExcelComment
Sets the top left anchor cell for the comment shape.
setTopLeftCell(String) - Method in class com.gembox.spreadsheet.WorksheetPanes
Sets the top left visible cell in the bottom right pane.
setTopMargin(double) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Footer margin (in inches).
setTopOrBottomRanked(boolean, int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Top or Bottom Ranked' formatting condition to this conditional formatting rule.
setTotalsRowFormula(String) - Method in class com.gembox.spreadsheet.tables.TableColumn
Gets the totals row formula.
setTotalsRowFunction(TotalsRowFunction) - Method in class com.gembox.spreadsheet.tables.TableColumn
Sets the totals row function.
setTransparentColor(Optional<SpreadsheetColor>) - Method in class com.gembox.spreadsheet.ExcelPicture
 
setType(CsvType) - Method in class com.gembox.spreadsheet.CsvLoadOptions
Sets value delimiter type, see CsvType.
setType(CsvType) - Method in class com.gembox.spreadsheet.CsvSaveOptions
Sets value delimiter type, see CsvType.
setType(DataValidationType) - Method in class com.gembox.spreadsheet.DataValidation
Sets the type of data validation.
setType(Optional<XlsxType>) - Method in class com.gembox.spreadsheet.XlsxSaveOptions
Specifies type of generated file.
setUnderlineStyle(UnderlineStyle) - Method in class com.gembox.spreadsheet.ExcelFont
Sets the underline formatting of the text.
setUniqueOrDuplicate(boolean) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Sets a 'Unique or Duplicate' formatting condition to this conditional formatting rule.
setUse1904DateSystem(boolean) - Method in class com.gembox.spreadsheet.ExcelFile
Sets whether 1904 date system is used.
setUseFormattedValues(boolean) - Method in class com.gembox.spreadsheet.CsvSaveOptions
Sets a value indicating whether values in CSV file will be formatted using number format.
setUseStartPageNumber(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing cell notes, false otherwise.
setValue(Object) - Method in class com.gembox.spreadsheet.AbstractRange
Gets cell value on one or more excel cells.
setValue(Object) - Method in class com.gembox.spreadsheet.CellRange
Sets cell value on one or more excel cells.
setValue(ConditionalValue) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObject
Sets the value.
setValue(String) - Method in class com.gembox.spreadsheet.conditionalformatting.ContainTextCondition
Sets the value of this ContainTextCondition.
setValue(Object) - Method in class com.gembox.spreadsheet.conditionalformatting.ContainValueCondition
Sets the value of this ContainValueCondition.
setValue(Object) - Method in class com.gembox.spreadsheet.CustomFilter
Sets the value used by the (first) filter condition.
setValue(String) - Method in class com.gembox.spreadsheet.DefinedName
Sets the value of the defined name.
setValue(Object) - Method in class com.gembox.spreadsheet.ExcelCell
Sets value of this cell or of merged range if this cell is merged.
setValue(boolean) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the boolean value to this cell or to merged range if this cell is merged.
setValue(int) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the integer value to this cell or to merged range if this cell is merged.
setValue(double) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the double value to this cell or to merged range if this cell is merged.
setValue(byte) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the byte value to this cell or to merged range if this cell is merged.
setValue(short) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the short value to this cell or to merged range if this cell is merged.
setValue(long) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the long value to this cell or to merged range if this cell is merged.
setValue(float) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the float value to this cell or to merged range if this cell is merged.
setValue(char) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the char value to this cell or to merged range if this cell is merged.
setValue(LocalDateTime) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the DateTime value to this cell or to merged range if this cell is merged.
setValue(String) - Method in class com.gembox.spreadsheet.ExcelCell
Sets the string value to this cell or to merged range if this cell is merged.
setValue(String, HtmlLoadOptions) - Method in class com.gembox.spreadsheet.ExcelCell
Loads the specified HTML text as the value of this ExcelCell.
setValue(double) - Method in class com.gembox.spreadsheet.Top10Filter
Sets the top or bottom value to use as the filter criteria.
setValue2(Object) - Method in class com.gembox.spreadsheet.conditionalformatting.ContainValueCondition
Sets the second value of this ContainValueCondition used with ContainValueOperator.BETWEEN and ContainValueOperator.NOT_BETWEEN operators.
setValue2(Object) - Method in class com.gembox.spreadsheet.CustomFilter
Sets the value used by the second filter condition.
setValues(Iterable) - Method in class com.gembox.spreadsheet.charts.ChartSeries
Sets the chart series values.
setValues(Object...) - Method in class com.gembox.spreadsheet.charts.ChartSeries
Sets the chart series values.
setValues(Iterable) - Method in class com.gembox.spreadsheet.ValuesFilter
Sets the list of values to filter by.
setValues(Object...) - Method in class com.gembox.spreadsheet.ValuesFilter
Sets the list of values to filter by.
setValuesFilter() - Method in class com.gembox.spreadsheet.FilterColumn
Sets a ValuesFilter to this column.
setValuesReference(String) - Method in class com.gembox.spreadsheet.charts.ChartSeries
Sets the chart series values as a cell range reference (for example, 'Sheet1!A1:D1').
setVerticalAlignment(VerticalAlignmentStyle) - Method in class com.gembox.spreadsheet.CellStyle
Sets the vertical alignment.
setVerticalCentered(boolean) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
true for printing sheet vertical centered, false otherwise.
setVerticalPrintResolution(int) - Method in class com.gembox.spreadsheet.ExcelPrintOptions
Set vertical print resolution in DPI (dots per inch).
setViewType(ViewType) - Method in class com.gembox.spreadsheet.ExcelViewOptions
Sets the view type.
setVisibility(SheetVisibility) - Method in class com.gembox.spreadsheet.ExcelWorksheet
Sets the worksheet visibility.
setVisible(boolean) - Method in class com.gembox.spreadsheet.charts.AxisGridlines
Sets a value indicating whether gridlines are visible.
setVisible(boolean) - Method in class com.gembox.spreadsheet.charts.ChartAxes
Sets a value indicating whether any axis is visible.
setVisible(boolean) - Method in class com.gembox.spreadsheet.charts.ChartAxis
Sets a value indicating whether axis is visible.
setVisible(boolean) - Method in class com.gembox.spreadsheet.charts.ChartLegend
Sets a value indicating whether legend is visible.
setVisible(boolean) - Method in class com.gembox.spreadsheet.charts.ChartTitle
Sets a value indicating whether title is visible.
setVisible(boolean) - Method in class com.gembox.spreadsheet.ExcelComment
Sets a value indicating whether this instance is visible.
setWeight(int) - Method in class com.gembox.spreadsheet.ExcelFont
Sets the font weight (font boldness).
setWidth(int) - Method in class com.gembox.spreadsheet.ExcelColumn
Sets column width.
setWidth(double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelColumn
Sets the width of column in arbitrary length unit.
setWidth(double) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the width (in points) of the ExcelDrawing (picture, chart, etc.).
setWidth(double, LengthUnit) - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Sets the width of the ExcelDrawing (picture, chart, etc.).
setWidth(int) - Method in class com.gembox.spreadsheet.FixedWidthColumn
Sets a value that represents column width.
setWrapText(boolean) - Method in class com.gembox.spreadsheet.CellStyle
Sets a value indicating whether the text in a cell should be line-wrapped within the cell.
setWriteCellAddress(boolean) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
Sets a value indicating whether each td HTML element should contain data-cell attribute with cell address for this cell.
setXSplit(float) - Method in class com.gembox.spreadsheet.WorksheetPanes
Sets the XSplit value.
setYSplit(float) - Method in class com.gembox.spreadsheet.WorksheetPanes
Sets the YSplit value.
setZoom(int) - Method in class com.gembox.spreadsheet.ExcelViewOptions
Magnification factor in normal view.
SheetHeaderFooter - Class in com.gembox.spreadsheet
Represents sheet header/footer.
SheetHeaderFooter() - Constructor for class com.gembox.spreadsheet.SheetHeaderFooter
SheetHeaderFooter constructor.
SheetType - Enum in com.gembox.spreadsheet
Specifies the sheet type.
SheetVisibility - Enum in com.gembox.spreadsheet
Script positions used in ExcelWorksheet visibility.
show() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Shows the value in the data label.
show(DataLabelPosition) - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Shows the value in the data label at the specified position.
showAll() - Method in class com.gembox.spreadsheet.AutoFilter
Shows all rows (sets Hidden to false) to which Range belongs.
size() - Method in class com.gembox.spreadsheet.CellStyleCollection
Gets the number of Styles contained in the collection.
size() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
size() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
 
size() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
Gets the number of ConditionalFormatRules contained in the ConditionalFormatRuleCollection.
size() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObjectCollection
Gets the number of conditional objects contained in the ConditionalObjectCollection.
size() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObjectCollectionGeneric
Gets the number of conditional objects contained in the ConditionalObjectCollectionGeneric.
size() - Method in class com.gembox.spreadsheet.DefinedNameCollection
Returns the number of defined names in collection.
size() - Method in class com.gembox.spreadsheet.ExcelCellCollection
Gets the number of currently allocated elements (dynamically changes when worksheet is modified).
size() - Method in class com.gembox.spreadsheet.ExcelCommentCollection
Gets the number of comments contained in the collection.
size() - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
size() - Method in class com.gembox.spreadsheet.ExcelEmbeddedObjectCollection
Gets the number of ExcelEmbeddedObjects contained in the ExcelEmbeddedObjectCollection.
size() - Method in class com.gembox.spreadsheet.ExcelRowColumnCellCollectionBase
Gets the number of currently allocated elements (dynamically changes when worksheet is modified).
size() - Method in class com.gembox.spreadsheet.ExcelRowColumnCollectionBaseGeneric
Gets the number of currently allocated elements (dynamically changes when worksheet is modified).
size() - Method in class com.gembox.spreadsheet.ExcelWorksheetCollection
Gets the number of elements contained in the ExcelWorksheetCollection.
size() - Method in class com.gembox.spreadsheet.FilterColumnCollection
Gets the total number of filter columns in the FilterColumnCollection.
size() - Method in class com.gembox.spreadsheet.IgnoredErrorCollection
Gets the number of IgnoredErrors contained in the IgnoredErrorCollection.
size() - Method in class com.gembox.spreadsheet.NamedRangeCollection
Gets the number of named ranges contained in the collection.
size() - Method in class com.gembox.spreadsheet.PageBreakCollection
Gets the number of page breaks contained in the collection.
size() - Method in class com.gembox.spreadsheet.pivottables.PivotCacheCollection
Gets the number of PivotCaches contained in the collection.
size() - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
Gets the number of PivotFields contained in the collection.
size() - Method in class com.gembox.spreadsheet.pivottables.PivotFilterCollection
Gets the total number of PivotFilters in the PivotFilterCollection.
size() - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
Gets the number of PivotItems contained in the collection.
size() - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
Gets the number of PivotTables contained in the collection.
size() - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
Gets the number of ProtectedRanges actually contained in the ProtectedRangeCollection.
size() - Method in class com.gembox.spreadsheet.SortLevelCollection
Gets the number of sort levels actually contained in the SortLevelCollection.
size() - Method in class com.gembox.spreadsheet.SpreadsheetHyperlinkCollection
Gets the number of hyperlinks contained in the collection.
size() - Method in class com.gembox.spreadsheet.tables.TableCollection
Gets the number of Tables contained in the collection.
size() - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
Gets the number of TableColumns contained in the collection.
size() - Method in class com.gembox.spreadsheet.tables.TableRowCollection
Gets the number of rows contained in the collection, not including the header row and, if enabled, totals row.
sort(boolean) - Method in class com.gembox.spreadsheet.CellRange
Gets the SortState active on the parent worksheet (ExcelWorksheet.getSort()) if active range is equal to this CellRange and parameter active is true; otherwise, a new SortState instance, which is set as active on the parent worksheet if parameter active is true.
sort(boolean) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sorts this pivot field by the pivot items in it.
sort(boolean, PivotField, PivotItem...) - Method in class com.gembox.spreadsheet.pivottables.PivotField
Sorts this pivot field by the data field.
sortBy(int) - Method in class com.gembox.spreadsheet.AutoFilter
Adds a SortLevel to a column with the specified index (relative to the Range).
sortBy(int, Iterable<String>) - Method in class com.gembox.spreadsheet.AutoFilter
Adds a SortLevel to a column with the specified index (relative to the Range) and with the specified custom list by which order of items to sort by.
sortBy(int, String...) - Method in class com.gembox.spreadsheet.AutoFilter
Adds a SortLevel to a column with the specified index (relative to the Range) and with the specified custom list by which order of items to sort by.
sortBy(int, boolean) - Method in class com.gembox.spreadsheet.AutoFilter
Adds a SortLevel to a column with the specified index (relative to the Range) and with the specified order to sort by.
sortBy(int, boolean, Iterable<String>) - Method in class com.gembox.spreadsheet.AutoFilter
Adds a SortLevel to a column with the specified index (relative to the Range) and with the specified order and custom list by which order of items to sort by.
sortBy(int, boolean, String...) - Method in class com.gembox.spreadsheet.AutoFilter
Adds a SortLevel to a column with the specified index (relative to the Range) and with the specified order and custom list by which order of items to sort by.
sortBy(int, Comparator<ExcelCell>) - Method in class com.gembox.spreadsheet.AutoFilter
Adds a SortLevel to a column with the specified index (relative to the Range) and with the specified comparison method to sort by.
SortLevel - Class in com.gembox.spreadsheet
Represents sort settings for a single sort level.
SortLevelCollection - Class in com.gembox.spreadsheet
Represents a collection of sort levels.
SortState - Class in com.gembox.spreadsheet
Represents sort settings and provides sort functionality.
SpreadsheetCalculationError - Enum in com.gembox.spreadsheet.calculationengine
Spreadsheet calculation error type enumeration.
SpreadsheetCalculationException - Exception in com.gembox.spreadsheet.calculationengine
Represents errors that can occur in GemBox.Spreadsheet formula calculation process.
SpreadsheetColor - Class in com.gembox.spreadsheet
Represents a spreadsheet color.
SpreadsheetException - Exception in com.gembox.spreadsheet
Represents errors that can occur in the GemBox.Spreadsheet component.
SpreadsheetException() - Constructor for exception com.gembox.spreadsheet.SpreadsheetException
Initializes a new instance of the SpreadsheetException class.
SpreadsheetException(String) - Constructor for exception com.gembox.spreadsheet.SpreadsheetException
Initializes a new instance of the SpreadsheetException class with a specified error message.
SpreadsheetException(String, Exception) - Constructor for exception com.gembox.spreadsheet.SpreadsheetException
Initializes a new instance of the SpreadsheetException class with a specified error message and a reference to the inner exception that is the cause of this exception.
SpreadsheetHyperlink - Class in com.gembox.spreadsheet
Hyperlink class.
SpreadsheetHyperlinkCollection - Class in com.gembox.spreadsheet
Collection of hyperlinks (SpreadsheetHyperlink).
SpreadsheetIcon - Class in com.gembox.spreadsheet
Represents a spreadsheet icon.
SpreadsheetIcon(SpreadsheetIconStyle, int) - Constructor for class com.gembox.spreadsheet.SpreadsheetIcon
Initializes a new instance of the SpreadsheetIcon.
SpreadsheetIconStyle - Enum in com.gembox.spreadsheet
Represents an enumeration of visually distinct icon sets.
SpreadsheetInfo - Class in com.gembox.spreadsheet
Contains static licensing methods and diagnostic information about executing GemBox.Spreadsheet assembly.
SpreadsheetInfo() - Constructor for class com.gembox.spreadsheet.SpreadsheetInfo
 
SpreadsheetParserException - Exception in com.gembox.spreadsheet.calculationengine
Represents exception that can occur in GemBox.Spreadsheet formula parsing process.
Style - Class in com.gembox.spreadsheet
Represents a workbook (master) style which can be shared by multiple cells.
subList(int, int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
supportsType(Class) - Static method in class com.gembox.spreadsheet.ExcelFile
Gets a value indicating whether the objects of specified type can be assigned to ExcelCell's value field.

T

Table - Class in com.gembox.spreadsheet.tables
Represents a worksheet table.
TableAlternativeText - Class in com.gembox.spreadsheet.tables
Represents alternative, text-based representation of the information contained in the parent Table.
TableCollection - Class in com.gembox.spreadsheet.tables
A collection of Table items.
TableColumn - Class in com.gembox.spreadsheet.tables
Represents a Table column.
TableColumnCollection - Class in com.gembox.spreadsheet.tables
A collection of TableColumn items.
TableRowCollection - Class in com.gembox.spreadsheet.tables
Represents a collection of Table rows, not including header and, if enabled, totals row.
TableStyleOptions - Enum in com.gembox.spreadsheet.tables
Specifies which options are applied to a Table style.
TickMarkType - Enum in com.gembox.spreadsheet.charts
Represents the possible positions for axis major and minor tick marks.
TimeUnit - Enum in com.gembox.spreadsheet.charts
Represents a unit of time used by DateAxis.
toArgb() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Gets the 32-bit ARGB value of this SpreadsheetColor class.
toArray() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
 
toArray() - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
toArray(T1[]) - Method in class com.gembox.spreadsheet.ExcelDrawingCollectionImpl
 
toColor() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Performs a conversion from SpreadsheetColor to Color.
toImage() - Method in class com.gembox.spreadsheet.ExcelPicture
Converts this ExcelPicture instance to a new Image instance.
Top10Filter - Class in com.gembox.spreadsheet
Represents a filter that filters by a top N (percent or number of items).
TopOrBottomRankedCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells with top or bottom ranked values.
toString() - Method in class com.gembox.spreadsheet.AbstractRange
Returns a String that represents this AbstractRange instance.
toString() - Method in class com.gembox.spreadsheet.AnchorCell
Returns a String that represents this AnchorCell instance.
toString() - Method in class com.gembox.spreadsheet.AutoFilter
Returns a String that represents this AutoFilter instance.
toString() - Method in class com.gembox.spreadsheet.CellBorder
Returns a String that represents this CellBorder instance.
toString() - Method in class com.gembox.spreadsheet.CellBorders
Returns a String that represents this CellBorders instance.
toString() - Method in class com.gembox.spreadsheet.CellStyle
Returns a String that represents this CellStyle instance.
toString() - Method in class com.gembox.spreadsheet.charts.AxisGridlines
Returns a String that represents this AxisGridlines instance.
toString() - Method in class com.gembox.spreadsheet.charts.ChartAxes
Returns a String that represents this ChartAxes instance.
toString() - Method in class com.gembox.spreadsheet.charts.ChartAxis
Returns a String that represents this ChartAxis instance.
toString() - Method in class com.gembox.spreadsheet.charts.ChartDataLabels
Returns a String that represents this ChartDataLabels instance.
toString() - Method in class com.gembox.spreadsheet.charts.ChartLegend
Returns a String that represents this ChartLegend instance.
toString() - Method in class com.gembox.spreadsheet.charts.ChartSeries
Returns the display name value.
toString() - Method in class com.gembox.spreadsheet.charts.ChartTitle
Returns the ChartTitle.getDisplayText() value.
toString() - Method in class com.gembox.spreadsheet.charts.ExcelChart
Returns a String that represents this ExcelChart instance.
toString() - Method in class com.gembox.spreadsheet.charts.Marker
Returns a String that represents this Marker instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.AboveOrBelowAverageCondition
Returns a String that represents this AboveOrBelowAverageCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ColorScaleCondition
Returns a String that represents this ColorScaleCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalColor
Returns a String that represents this ConditionalColor instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRule
Returns a String that represents this ConditionalFormatRule instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalIcon
Returns a String that represents this ConditionalIcon instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalLength
Returns a String that represents this ConditionalLength instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObject
Returns a String that represents this ConditionalObject instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalValue
Returns a String that represents this ConditionalValue instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainCondition
Returns a String that represents this ContainCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainDateCondition
Returns a String that represents this ContainDateCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainTextCondition
Returns a String that represents this ContainTextCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainValueCondition
Returns a String that represents this ContainValueCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarCondition
Returns a String that represents this DataBarCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.DataBarStyle
Returns a String that represents this DataBarStyle instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.FormatCondition
Returns a String that represents this FormatCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.FormulaCondition
Returns a String that represents this FormulaCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.IconSetCondition
Returns a String that represents this IconSetCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.TopOrBottomRankedCondition
Returns a String that represents this TopOrBottomRankedCondition instance.
toString() - Method in class com.gembox.spreadsheet.conditionalformatting.UniqueOrDuplicateCondition
Returns a String that represents this UniqueOrDuplicateCondition instance.
toString() - Method in class com.gembox.spreadsheet.CustomFilter
Returns a String that represents this CustomFilter instance.
toString() - Method in class com.gembox.spreadsheet.DateTimeGroup
Returns a String that represents this DateTimeGroup instance.
toString() - Method in class com.gembox.spreadsheet.DefinedName
Returns a String that represents this DefinedName instance.
toString() - Method in class com.gembox.spreadsheet.DocumentProperties
Returns a String that represents the current DocumentProperties.
toString() - Method in class com.gembox.spreadsheet.DynamicFilter
Returns a String that represents this DynamicFilter instance.
toString() - Method in class com.gembox.spreadsheet.ExcelColumnRowBase
Returns a String that represents this ExcelColumnRowBase instance.
toString() - Method in class com.gembox.spreadsheet.ExcelDrawingMetadata
Returns a String that represents this ExcelDrawingMetadata instance.
toString() - Method in class com.gembox.spreadsheet.ExcelDrawingPosition
Returns a String that represents this ExcelDrawingPosition instance.
toString() - Method in class com.gembox.spreadsheet.ExcelEmbeddedObject
Returns a String that represents this ExcelEmbeddedObject instance.
toString() - Method in class com.gembox.spreadsheet.ExcelFillPattern
Returns a String that represents this ExcelFillPattern instance.
toString() - Method in class com.gembox.spreadsheet.ExcelFont
Returns a String that represents this ExcelFont instance.
toString() - Method in class com.gembox.spreadsheet.ExcelPicture
Returns a String that represents this ExcelPicture instance.
toString() - Method in class com.gembox.spreadsheet.Filter
Returns a String that represents this Filter instance.
toString() - Method in class com.gembox.spreadsheet.FilterColumn
Returns a String that represents this FilterColumn instance.
toString() - Method in class com.gembox.spreadsheet.IgnoredError
Returns a String that represents this IgnoredError instance.
toString() - Method in class com.gembox.spreadsheet.NamedRange
Returns a String that represents this NamedRange instance.
toString() - Method in enum com.gembox.spreadsheet.PanePosition
 
toString() - Method in enum com.gembox.spreadsheet.PanesState
 
toString() - Method in enum com.gembox.spreadsheet.pivottables.PivotFieldCalculationType
 
toString() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
Returns a String that represents this PivotFilter instance.
toString() - Method in class com.gembox.spreadsheet.ProtectedRange
Returns a String that represents this ProtectedRange instance.
toString() - Method in class com.gembox.spreadsheet.SortLevel
Returns a String that represents this SortLevel instance.
toString() - Method in class com.gembox.spreadsheet.SortState
Returns a String that represents this SortState instance.
toString() - Method in class com.gembox.spreadsheet.SpreadsheetColor
Returns a String that represents this SpreadsheetColor instance.
toString() - Method in class com.gembox.spreadsheet.SpreadsheetIcon
Returns a String that represents this SpreadsheetIcon instance.
toString() - Method in class com.gembox.spreadsheet.tables.Table
Returns a String that represents this Table instance.
toString() - Method in class com.gembox.spreadsheet.Top10Filter
Returns a String that represents this Top10Filter instance.
toString() - Method in class com.gembox.spreadsheet.ValuesFilter
Returns a String that represents this ValuesFilter instance.
TotalsRowFunction - Enum in com.gembox.spreadsheet.tables
Total row functions.

U

UnderlineStyle - Enum in com.gembox.spreadsheet
Represents the different types of possible underline formatting used in ExcelFont.getUnderlineStyle() member.
UniqueOrDuplicateCondition - Class in com.gembox.spreadsheet.conditionalformatting
Represents a condition that formats only cells with unique or duplicate values.

V

ValueAxis - Class in com.gembox.spreadsheet.charts
Represents an axis used for series values.
valueOf(String) - Static method in enum com.gembox.spreadsheet.BuiltInCellStyleName
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.BuiltInDocumentProperties
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.calculationengine.SpreadsheetCalculationError
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.CellValueType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.AxisLabelsPosition
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.AxisType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.ChartGrouping
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.ChartLegendPosition
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.ChartTitleDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.ChartType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.DataLabelPosition
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.EmptyCellDisplayMode
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.MarkerType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.TickMarkType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.charts.TimeUnit
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.ClearOptions
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.ColorName
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.ConditionalValueType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainConditionType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainDateOperator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainTextOperator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainValueOperator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.DataBarAxisPosition
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.DataBarDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.conditionalformatting.FormatConditionType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.CsvType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.DataValidationErrorStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.DataValidationOperator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.DataValidationType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.DateTimeGroupLevel
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.DynamicFilterType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.ExcelObjectSourceType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.ExcelPictureFormat
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.FillPatternStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.FilterOperator
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.FilterType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.FreeLimitReachedAction
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.GradientShadingStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.HeaderFooterFieldType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.HorizontalAlignmentStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.HtmlType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.IgnoredErrorTypes
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.IndividualBorder
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.InsertShiftDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.LengthUnit
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.LineStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.MultipleBorders
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.NumberType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.PanePosition
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.PanesState
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.PaperType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.BuiltInPivotStyleName
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.PivotCacheSourceType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldCalculationType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldDisplayFormat
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldLayoutForm
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldSubtotalTypes
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.PivotItemPosition
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.pivottables.PivotTableStyleOptions
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.PositioningMode
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.RangeIndexingMode
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.RemoveShiftDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.ScriptPosition
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.SelectionType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.SheetType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.SheetVisibility
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.SpreadsheetIconStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.tables.BuiltInTableStyleName
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.tables.TableStyleOptions
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.tables.TotalsRowFunction
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.UnderlineStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.VerticalAlignmentStyle
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.ViewType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.gembox.spreadsheet.XlsxType
Returns the enum constant of this type with the specified name.
values() - Static method in enum com.gembox.spreadsheet.BuiltInCellStyleName
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.BuiltInDocumentProperties
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.calculationengine.SpreadsheetCalculationError
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.CellValueType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.AxisLabelsPosition
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.AxisType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.ChartGrouping
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.ChartLegendPosition
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.ChartTitleDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.ChartType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.DataLabelPosition
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.EmptyCellDisplayMode
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.MarkerType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.TickMarkType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.charts.TimeUnit
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.ClearOptions
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.ColorName
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.ConditionalValueType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainConditionType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainDateOperator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainTextOperator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.ContainValueOperator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.DataBarAxisPosition
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.DataBarDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.conditionalformatting.FormatConditionType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.CsvType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.DataValidationErrorStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.DataValidationOperator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.DataValidationType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.DateTimeGroupLevel
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.DynamicFilterType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.ExcelObjectSourceType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.ExcelPictureFormat
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.FillPatternStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.FilterOperator
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.FilterType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.FreeLimitReachedAction
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.GradientShadingStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.HeaderFooterFieldType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.HorizontalAlignmentStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.HtmlType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.IgnoredErrorTypes
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.IndividualBorder
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.InsertShiftDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.LengthUnit
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.LineStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.MultipleBorders
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.NumberType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.PanePosition
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.PanesState
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.PaperType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.BuiltInPivotStyleName
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.PivotCacheSourceType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldCalculationType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldDisplayFormat
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldLayoutForm
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.PivotFieldSubtotalTypes
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.PivotItemPosition
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.pivottables.PivotTableStyleOptions
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.PositioningMode
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.RangeIndexingMode
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.RemoveShiftDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.ScriptPosition
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.SelectionType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.SheetType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.SheetVisibility
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.SpreadsheetIconStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.tables.BuiltInTableStyleName
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.tables.TableStyleOptions
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.tables.TotalsRowFunction
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.UnderlineStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.VerticalAlignmentStyle
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.ViewType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.gembox.spreadsheet.XlsxType
Returns an array containing the constants of this enum type, in the order they are declared.
ValuesFilter - Class in com.gembox.spreadsheet
Represents a filter that filters by a list of values.
verifyRefersToCells(String, String) - Static method in class com.gembox.spreadsheet.ProtectedRange
 
vertical() - Static method in enum com.gembox.spreadsheet.MultipleBorders
Vertical borders.
VerticalAlignmentStyle - Enum in com.gembox.spreadsheet
Represents available vertical alignment options used in CellStyle.setVerticalAlignment(com.gembox.spreadsheet.VerticalAlignmentStyle) member.
VerticalPageBreak - Class in com.gembox.spreadsheet
Specifies a vertical position where the new page begins when the worksheet is printed.
VerticalPageBreakCollection - Class in com.gembox.spreadsheet
Collection of vertical page breaks (VerticalPageBreak).
ViewType - Enum in com.gembox.spreadsheet
Specifies the view type.

W

WorkbookProtection - Class in com.gembox.spreadsheet
Protection settings.
WorksheetPanes - Class in com.gembox.spreadsheet
Represents the worksheet panes.
WorksheetPanes(PanesState, float, float, String, PanePosition) - Constructor for class com.gembox.spreadsheet.WorksheetPanes
Worksheet panes constructor.
WorksheetPanes(WorksheetPanes) - Constructor for class com.gembox.spreadsheet.WorksheetPanes
Copy constructor.
WorksheetProtection - Class in com.gembox.spreadsheet
Protection settings.
WorksheetSource - Class in com.gembox.spreadsheet.pivottables
Represents a worksheet source of PivotCache data.

X

XlsLoadOptions - Class in com.gembox.spreadsheet
Represents options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions).
XlsLoadOptions() - Constructor for class com.gembox.spreadsheet.XlsLoadOptions
Initializes a new instance of the XlsLoadOptions class.
XlsSaveOptions - Class in com.gembox.spreadsheet
Represents options for saving to, XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .
XlsSaveOptions() - Constructor for class com.gembox.spreadsheet.XlsSaveOptions
Initializes a new instance of the XlsSaveOptions class.
XlsxLoadOptions - Class in com.gembox.spreadsheet
Represent options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
XlsxLoadOptions() - Constructor for class com.gembox.spreadsheet.XlsxLoadOptions
Initializes a new instance of the XlsxLoadOptions class.
XlsxSaveOptions - Class in com.gembox.spreadsheet
Represent options for saving to XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).
XlsxSaveOptions() - Constructor for class com.gembox.spreadsheet.XlsxSaveOptions
Initializes a new instance of the XlsxSaveOptions class.
XlsxType - Enum in com.gembox.spreadsheet
OpenXML file type.
A B C D E F G H I L M N O P R S T U V W X 

© GemBox Ltd. — All rights reserved.