- 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
-
- 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
-
- add(String) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
-
- add(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotAreaFieldCollection
-
- add(PivotCache, String, String) - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
-
- add(PivotCache, String, ExcelCell) - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
-
- add(int, int) - Method in class com.gembox.spreadsheet.SortLevelCollection
-
- add(int) - Method in class com.gembox.spreadsheet.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
-
- 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
-
- 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
-
- addNew(String, String) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
-
- 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
-
- addStyle(String) - Method in class com.gembox.spreadsheet.ExcelFile
-
- 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(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
-
- append(String, ExcelFont) - Method in class com.gembox.spreadsheet.HeaderFooterSection
-
- 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
-
- appendPicture(String, int, int) - Method in class com.gembox.spreadsheet.HeaderFooterSection
-
- appendPicture(InputStream, ExcelPictureFormat) - Method in class com.gembox.spreadsheet.HeaderFooterSection
-
- appendPicture(InputStream, ExcelPictureFormat, int, int) - Method in class com.gembox.spreadsheet.HeaderFooterSection
-
- 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
-
- 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.
- 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
-
- get(int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollection
-
- get(int) - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
-
- get(int) - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
-
- 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
-
- 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
-
- 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
-
- get(int) - Method in class com.gembox.spreadsheet.NamedRangeCollection
-
- get(String) - Method in class com.gembox.spreadsheet.NamedRangeCollection
-
- get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotCacheCollection
-
- get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
-
- get(String) - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
-
- get(PivotField) - Method in class com.gembox.spreadsheet.pivottables.PivotFilterCollection
-
- get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
-
- get(String) - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
-
- get(int) - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
-
- get(int) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
-
- get(String) - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
-
- get(int) - Method in class com.gembox.spreadsheet.SortLevelCollection
-
- 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
-
- 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
-
- getAxisType() - Method in class com.gembox.spreadsheet.charts.ChartAxis
-
- getAxisType() - Method in class com.gembox.spreadsheet.charts.DateAxis
-
- getAxisType() - Method in class com.gembox.spreadsheet.charts.ValueAxis
-
- getB() - Method in class com.gembox.spreadsheet.SpreadsheetColor
-
- 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
-
- getBaseItemPosition() - Method in class com.gembox.spreadsheet.pivottables.PivotField
-
- 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
-
- 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
-
- 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
-
- getCharacters(int) - Method in class com.gembox.spreadsheet.AbstractRange
-
- getCharacters(int, int) - Method in class com.gembox.spreadsheet.AbstractRange
-
- getCharacters(int) - Method in class com.gembox.spreadsheet.ExcelComment
-
- getCharacters(int, int) - Method in class com.gembox.spreadsheet.ExcelComment
-
- 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
-
- getChartType() - Method in class com.gembox.spreadsheet.charts.BarChart
-
- getChartType() - Method in class com.gembox.spreadsheet.charts.ColumnChart
-
- getChartType() - Method in class com.gembox.spreadsheet.charts.ExcelChart
-
- getChartType() - Method in class com.gembox.spreadsheet.charts.LineChart
-
- getChartType() - Method in class com.gembox.spreadsheet.charts.PieChart
-
- 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
PivotField
s 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
-
- 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
ExcelCell
s.
- 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
-
- getContent() - Method in class com.gembox.spreadsheet.HeaderFooterSection
-
- getContentType() - Method in class com.gembox.spreadsheet.CsvSaveOptions
-
- 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
-
- getContentType() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
-
- 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
-
- 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
-
- 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
PivotField
s 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
-
- 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
-
- 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
-
- getFilesDirectorySrcPath() - Method in class com.gembox.spreadsheet.HtmlSaveOptions
-
- 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
-
- 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
-
- getFilter() - Method in class com.gembox.spreadsheet.tables.Table
-
Gets the table filter.
- getFilterType() - Method in class com.gembox.spreadsheet.CustomFilter
-
- getFilterType() - Method in class com.gembox.spreadsheet.DynamicFilter
-
- getFilterType() - Method in class com.gembox.spreadsheet.Filter
-
Gets the filter type.
- getFilterType() - Method in class com.gembox.spreadsheet.Top10Filter
-
- getFilterType() - Method in class com.gembox.spreadsheet.ValuesFilter
-
- 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
-
- getFooterMargin() - Method in class com.gembox.spreadsheet.ExcelPrintOptions
-
Footer margin (in inches).
- getFormattedValue() - Method in class com.gembox.spreadsheet.ExcelCell
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- getIndex() - Method in class com.gembox.spreadsheet.charts.ChartSeries
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- getName() - Method in class com.gembox.spreadsheet.pivottables.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
-
- getOperator() - Method in class com.gembox.spreadsheet.conditionalformatting.ContainTextCondition
-
- getOperator() - Method in class com.gembox.spreadsheet.conditionalformatting.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
PivotField
s 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
-
- getParent() - Method in class com.gembox.spreadsheet.ExcelWorksheet
-
- getParent() - Method in class com.gembox.spreadsheet.tables.TableColumn
-
- 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
-
- getPivotCaches() - Method in class com.gembox.spreadsheet.ExcelFile
-
- getPivotField() - Method in class com.gembox.spreadsheet.pivottables.PivotItem
-
- getPivotFields() - Method in class com.gembox.spreadsheet.pivottables.PivotTable
-
Gets the collection of all (visible and hidden)
PivotField
s.
- getPivotFilters() - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
-
Gets the filter fields.
- getPivotItems() - Method in class com.gembox.spreadsheet.pivottables.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
-
- getPivotTable() - Method in class com.gembox.spreadsheet.pivottables.PivotTableFilter
-
- getPivotTables() - Method in class com.gembox.spreadsheet.ExcelWorksheet
-
Gets the collection of all
PivotTable
s 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
-
- 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
PivotField
s 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
-
- 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
-
- 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
-
- getSort() - Method in class com.gembox.spreadsheet.ExcelWorksheet
-
- 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
-
- 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
-
- 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
-
- getStyle() - Method in class com.gembox.spreadsheet.conditionalformatting.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
-
- 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)
Style
s 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
Table
s 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
-
- 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
-
- getValue() - Method in class com.gembox.spreadsheet.conditionalformatting.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
-
- 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
-
- 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
-
- 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
-
- 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
-
- getWorksheets() - Method in class com.gembox.spreadsheet.ExcelFile
-
- 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.
- 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
-
- 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
-
- 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.
- isDelayFormulaParse() - Method in class com.gembox.spreadsheet.ExcelFile
-
Return value indicating whether formula parsing is delayed until one of save methods is called
- 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
-
- 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
-
- 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
PivotField
s 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.
- 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
-
- iterator() - Method in class com.gembox.spreadsheet.charts.ChartSeriesCollectionGeneric
-
- iterator() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalFormatRuleCollection
-
- iterator() - Method in class com.gembox.spreadsheet.conditionalformatting.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
-
- iterator() - Method in class com.gembox.spreadsheet.ExcelRowColumnCollectionBaseGeneric
-
Returns an iterator that iterates through the collection.
- iterator() - Method in class com.gembox.spreadsheet.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
-
- 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
PivotFilter
s.
- 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
-
- 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.
- 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
-
- setBaseItemPosition(PivotItemPosition) - Method in class com.gembox.spreadsheet.pivottables.PivotField
-
- 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
-
- 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
-
- 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
ExcelCell
s.
- 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
-
- 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
-
- setCustomFilter() - Method in class com.gembox.spreadsheet.FilterColumn
-
- setCustomFilter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
-
- 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).
- setDelayFormulaParse(boolean) - Method in class com.gembox.spreadsheet.ExcelFile
-
Delays formula parsing until one of saveXls methods is called.
- 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
-
- setDynamicFilter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
-
- 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
-
- 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
-
- setFilesDirectorySrcPath(String) - Method in class com.gembox.spreadsheet.HtmlSaveOptions
-
- 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
-
- 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
-
- 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.
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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.
- 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
-
- setOperator(ContainTextOperator) - Method in class com.gembox.spreadsheet.conditionalformatting.ContainTextCondition
-
- setOperator(ContainValueOperator) - Method in class com.gembox.spreadsheet.conditionalformatting.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
PivotField
s 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
-
- 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
-
- 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
-
- 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
-
- setSort() - Method in class com.gembox.spreadsheet.FilterColumn
-
- 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
-
- 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
-
- setTop10Filter() - Method in class com.gembox.spreadsheet.pivottables.PivotFilter
-
- 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.
- 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
-
- setValue(Object) - Method in class com.gembox.spreadsheet.conditionalformatting.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
-
- 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
-
- 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
-
- 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
-
- SheetType - Enum in com.gembox.spreadsheet
-
Specifies the sheet type.
- SheetVisibility - Enum in com.gembox.spreadsheet
-
- 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
Style
s 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
-
- size() - Method in class com.gembox.spreadsheet.conditionalformatting.ConditionalObjectCollection
-
- size() - Method in class com.gembox.spreadsheet.conditionalformatting.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
-
- 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
-
- size() - Method in class com.gembox.spreadsheet.FilterColumnCollection
-
- size() - Method in class com.gembox.spreadsheet.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
PivotCache
s contained in the collection.
- size() - Method in class com.gembox.spreadsheet.pivottables.PivotFieldBaseCollection
-
Gets the number of
PivotField
s contained in the collection.
- size() - Method in class com.gembox.spreadsheet.pivottables.PivotFilterCollection
-
- size() - Method in class com.gembox.spreadsheet.pivottables.PivotItemCollection
-
Gets the number of
PivotItem
s contained in the collection.
- size() - Method in class com.gembox.spreadsheet.pivottables.PivotTableCollection
-
Gets the number of
PivotTable
s contained in the collection.
- size() - Method in class com.gembox.spreadsheet.ProtectedRangeCollection
-
- size() - Method in class com.gembox.spreadsheet.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
Table
s contained in the collection.
- size() - Method in class com.gembox.spreadsheet.tables.TableColumnCollection
-
Gets the number of
TableColumn
s 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
-
- 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
-
- SpreadsheetException(String) - Constructor for exception com.gembox.spreadsheet.SpreadsheetException
-
- 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
-
- SpreadsheetIcon - Class in com.gembox.spreadsheet
-
Represents a spreadsheet icon.
- SpreadsheetIcon(SpreadsheetIconStyle, int) - Constructor for class com.gembox.spreadsheet.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.
- 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
-
- 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
-
- ViewType - Enum in com.gembox.spreadsheet
-
Specifies the view type.