Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate

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

S

Sand - Static variable in interface com.aspose.cells.TextureType
Represents Sand texture type.
SAPPHIRE - Static variable in interface com.aspose.cells.GradientPresetType
Represents sapphire preset color.
save(OutputStream) - Method in class com.aspose.cells.Workbook
Saves the workbook to the given stream.
save(OutputStream, int) - Method in class com.aspose.cells.Workbook
Saves the workbook to the given stream.
save(String) - Method in class com.aspose.cells.Workbook
Saves the workbook to a file.
save(String, int) - Method in class com.aspose.cells.Workbook
Saves the workbook to a file.
save(String, char, String) - Method in class com.aspose.cells.Workbook
Creates text files with user defined separator.
save(OutputStream, char, String) - Method in class com.aspose.cells.Workbook
Creates text files with user defined separator.
save(String) - Method in class com.aspose.cells.WorkbookDesigner
Creates and saves the result spreadsheet to the disk.
save(String, int) - Method in class com.aspose.cells.WorkbookDesigner
Creates and saves the result spreadsheet to the disk.
save(OutputStream) - Method in class com.aspose.cells.WorkbookDesigner
Saves the workbook to the given stream.
save(OutputStream, int) - Method in class com.aspose.cells.WorkbookDesigner
Saves the workbook to the given stream.
saveData() - Method in class com.aspose.cells.PivotTable
Indicates whether data for the PivotTable report is saved with the workbook.
SaveOptions - Class in com.aspose.cells
Provides various options that control how a workbook is saved.
SCATTER - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart.
SCATTER_CONNECTED_BY_CURVES_WITH_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by curves, with data markers.
SCATTER_CONNECTED_BY_CURVES_WITHOUT_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by curves, without data markers.
SCATTER_CONNECTED_BY_LINES_WITH_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by lines, with data markers.
SCATTER_CONNECTED_BY_LINES_WITHOUT_DATA_MARKE - Static variable in interface com.aspose.cells.ChartType
Represents Scatter Chart connected by lines, without data markers.
SCROLL_BAR - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the ScrollBar.
ScrollBar - Class in com.aspose.cells
 
SEARCH_BY_COLUMNS - Static variable in class com.aspose.cells.FindOptions
Represents searching input string column by column.
SEARCH_BY_ROWS - Static variable in class com.aspose.cells.FindOptions
Represents searching input string row by row.
SECONDS - Static variable in interface com.aspose.cells.PivotTableGroupType
Presents group by Seconds.
SelectionType - Interface in com.aspose.cells
 
SEMIAUTOMATIC - Static variable in interface com.aspose.cells.CalculationMode
automatic except for multiple table operations
SEMICOLON - Static variable in interface com.aspose.cells.DataLabelsSeparatorType
 
SeriesAxis - Class in com.aspose.cells
Encapsulates the object that represents series axis.
setAboveAverage(boolean) - Method in class com.aspose.cells.AboveAverage
Sets the flag indicating whether the rule is an "above average" rule.
setActiveCell(String) - Method in class com.aspose.cells.Worksheet
Sets the active cell.
setActiveCell(int, int) - Method in class com.aspose.cells.Worksheet
Sets the active cell.
setActiveSheet(int) - Method in class com.aspose.cells.Worksheets
Sets the active sheet index.
setActiveSheet(Worksheet) - Method in class com.aspose.cells.Worksheets
Sets the active sheet.
setAddInFormula(String, String) - Method in class com.aspose.cells.Cell
 
setAddress(String) - Method in class com.aspose.cells.Hyperlink
Sets the address of the hyperlink.
setAlertType(int) - Method in class com.aspose.cells.Validation
Sets the validation alert style.
setAll(boolean) - Method in class com.aspose.cells.StyleFlag
All properties will be applied.
setAmount(byte, double) - Method in class com.aspose.cells.ErrorBars
Sets the error bar type and amount.
setAreaList(ArrayList<CellArea>) - Method in class com.aspose.cells.Validation
Sets a collection of CellArea.
setArrayFormula(String, int, int) - Method in class com.aspose.cells.Cell
Sets an array formula to a range of cells.
setAscendShow(boolean) - Method in class com.aspose.cells.PivotField
Sets whether the specified PivotTable field is autoshown ascending.
setAscendSort(boolean) - Method in class com.aspose.cells.PivotField
Sets whether the specified PivotTable field is autosorted ascending.
setAuthor(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets or sets the name of the document's author.
setAuto(boolean) - Method in class com.aspose.cells.Area
Sets whether Microsoft Workbook automatically determines the area pattern.
setAuto(boolean) - Method in class com.aspose.cells.Line
Sets whether Microsoft Workbook automatically determines the line pattern.
setAutoCross(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether Microsoft Workbook automatically sets the axis crossing point.
setAutoFitHeight(boolean) - Method in class com.aspose.cells.Row
Sets whether row's height is auto-fit.
setAutoFormat(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable report is automatically formatted.
setAutoFormatType(short) - Method in class com.aspose.cells.PivotTable
Sets the PivotTable atuo format type.Only effect when isAutoFormat is true.
setAutoGroupField(int) - Method in class com.aspose.cells.PivotTable
Sets auto field group by the PivotTable.
setAutoGroupField(PivotField) - Method in class com.aspose.cells.PivotTable
Sets auto field group by the PivotTable.
setAutomaticStyles(boolean) - Method in class com.aspose.cells.Outline
Sets whether the outline uses automatic styles.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.Axis
Set whether the text in the object changes font size when the object size changes.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.ChartArea
Set whether the text in the object changes font size when the object size changes.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.ChartDataTable
Set whether the text in the object changes font size when the object size changes.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.DataLabels
Set whether the text in the object changes font size when the object size changes.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.DisplayUnitLabel
Set whether the text in the object changes font size when the object size changes.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.Legend
Set whether the text in the object changes font size when the object size changes.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.LegendEntry
Set whether the text in the object changes font size when the object size changes.
setAutoScaleFont(boolean) - Method in class com.aspose.cells.Title
Set whether the text in the object changes font size when the object size changes.
setAutoScaling(boolean) - Method in class com.aspose.cells.Chart
True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.
setAutoShow(boolean) - Method in class com.aspose.cells.PivotField
Sets whether the specified PivotTable field is automatically shown.
setAutoShowCount(int) - Method in class com.aspose.cells.PivotField
Gets the number of top or bottom items that are automatically shown in the specified PivotTable field.
setAutoShowField(int) - Method in class com.aspose.cells.PivotField
Sets auto show field index.
setAutoSort(boolean) - Method in class com.aspose.cells.PivotField
Sets whether the specified PivotTable field is automatically sorted.
setAutoSortField(int) - Method in class com.aspose.cells.PivotField
Sets auto sort field index.
setAutoSubtotals(boolean) - Method in class com.aspose.cells.PivotField
Sets whether the specified field shows automatic subtotals.
setAxisLine(Line) - Method in class com.aspose.cells.Axis
Sets the appearance of an axis.
setBackground(byte[]) - Method in class com.aspose.cells.Worksheet
Sets the background for the worksheet.
setBackgroundColor(Color) - Method in class com.aspose.cells.Area
Sets the background Color of the Area.
setBackgroundColor(Color) - Method in class com.aspose.cells.PatternFill
Sets the background Color.
setBackgroundMode(byte) - Method in class com.aspose.cells.Axis
Sets the display mode of the background.
setBackgroundMode(byte) - Method in class com.aspose.cells.ChartArea
Sets the display mode of the background.
setBackgroundMode(byte) - Method in class com.aspose.cells.ChartDataTable
Sets the display mode of the background.
setBackgroundMode(byte) - Method in class com.aspose.cells.DataLabels
Sets the display mode of the background.
setBackgroundMode(byte) - Method in class com.aspose.cells.DisplayUnitLabel
Sets the display mode of the background.
setBackgroundMode(byte) - Method in class com.aspose.cells.Legend
Sets the display mode of the background.
setBackgroundMode(byte) - Method in class com.aspose.cells.LegendEntry
Sets the display mode of the background.
setBackgroundMode(byte) - Method in class com.aspose.cells.Title
Sets the display mode of the background.
setBackgroundTransparency(float) - Method in class com.aspose.cells.PatternFill
Sets the transparency of background color.
setBackward(double) - Method in class com.aspose.cells.Trendline
Sets the number of periods (or units on a scatter chart) that the trendline extends backward.
setBarShape(int) - Method in class com.aspose.cells.ASeries
Set the shape used with the 3D bar or column chart
setBaseField(int) - Method in class com.aspose.cells.PivotField
Sets the base field for a custom calculation.
setBaseItem(int) - Method in class com.aspose.cells.PivotField
Sets the item in the base field for a custom calculation.
setBaseUnitScale(short) - Method in class com.aspose.cells.CategoryAxis
Sets the base unit scale for the category axis.
setBeginArrowLengthType(short) - Method in class com.aspose.cells.Line
Sets the begin arrow length type.
setBeginArrowType(short) - Method in class com.aspose.cells.Line
Sets the begin type of arrow settings for line style.
setBeginArrowWidthType(short) - Method in class com.aspose.cells.Line
Sets the begin arrow width type.
setBetweenCategories(boolean) - Method in class com.aspose.cells.CategoryAxis
Sets whether the value axis crosses the category axis between categories.
setBlackAndWhite(boolean) - Method in class com.aspose.cells.PageSetup
Sets elements of the document will be printed in black and white.
setBlue(int) - Method in class com.aspose.cells.Color
Sets the blue component value.
setBold(boolean) - Method in class com.aspose.cells.Font
Sets the font whether to be bold or not.
setBorderColor(int, Color) - Method in class com.aspose.cells.Style
Sets the color of the specified border.
setBorderHorizonal(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the chart data table has horizontal cell borders.
setBorderLine(int, int) - Method in class com.aspose.cells.Style
Sets the border line type of the specified border.
setBorderOutline(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the chart data table has outline borders.
setBorders(boolean) - Method in class com.aspose.cells.StyleFlag
All borders settings will be applied.
setBorderVertical(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the chart data table has vertical cell borders.
setBottom(boolean) - Method in class com.aspose.cells.Top10
Sets the flag indicating whether a "top/bottom n" rule is a "bottom n" rule.
setBottomBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Bottom border settings will be applied.
setBottomMargin(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the bottom margin, in unit of centimeters.
setBottomMarginInch(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the bottom margin, in unit of inches .
setBubbleScale(short) - Method in class com.aspose.cells.ASeries
Sets the scale factor for bubbles in the specified chart group.
setBubbleShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label bubble size display.
setBubbleSizeRepresents(int) - Method in class com.aspose.cells.ASeries
ets what the bubble size represents on a bubble chart.
setBubbleSizes(String) - Method in class com.aspose.cells.ASeries
Sets the size data for the bubble chart.
setBytes(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets an estimate of the number of bytes in the excel file.
setCalculateBeforeSave(boolean) - Method in class com.aspose.cells.Workbook
Sets whether workbooks are calculated before they're saved to disk.
setCalculationMode(int) - Method in class com.aspose.cells.Workbook
Sets the calculation mode.
setCapType(byte) - Method in class com.aspose.cells.Line
Sets the cap type for line style.
setCaseSensitive(boolean) - Method in class com.aspose.cells.DataSorter
Sets whether case sensitive when comparing string.
setCategory(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the category of the document.
setCategoryData(String) - Method in class com.aspose.cells.NSeries
Sets the range of category Axis values.
setCategoryNameShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label category name display.
setCategoryType(int) - Method in class com.aspose.cells.CategoryAxis
Sets the category axis type.
setCell(int, int) - Method in class com.aspose.cells.Comment
Sets the row and column index of the comment.
setCellLocked(boolean) - Method in class com.aspose.cells.Style
Sets whether cells to be locked or not.
setCellShading(boolean) - Method in class com.aspose.cells.StyleFlag
Cell shading setting will be applied.
setCenterFooter(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the center section footer of an Workbook file.
setCenterHeader(String) - Method in class com.aspose.cells.PageSetup
Sets na script formatting the center section header of an Workbook file
setCenterHorizontally(boolean) - Method in class com.aspose.cells.PageSetup
Sets whether the sheet is printed centered horizontally.
setCenterVertically(boolean) - Method in class com.aspose.cells.PageSetup
Sets whether the sheet is printed centered vertically.
setCharacters(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets an estimate of the number of characters in the excel file.
setCharacters(int, int, Font) - Method in class com.aspose.cells.Cell
Performs rich text formatting.
setCharacters(int, int, Font) - Method in class com.aspose.cells.Shape
Performs rich text formatting.
setCharacters(int, int, Font) - Method in class com.aspose.cells.Title
Performs rich text formatting.
setCharactersWithSpaces(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets an estimate of the number of characters (including spaces) in the excel file.
setChecked(boolean) - Method in class com.aspose.cells.RadioButton
Sets if the radiobutton is checked or not.
setCheckValue(byte) - Method in class com.aspose.cells.CheckBox
Sets checkbox' value.
setColor(Color) - Method in class com.aspose.cells.DataBar
Sets this DataBar's Color.
setColor(Color) - Method in class com.aspose.cells.Font
Sets the font color.
setColor(Color) - Method in class com.aspose.cells.GradientStop
Sets the Color of this gradient stop.
setColor(Color) - Method in class com.aspose.cells.Line
Sets the Color of the line.
setColor(int, Color) - Method in class com.aspose.cells.Palette
Sets the color in the palette at the specified index(0-55).
setColor(Color) - Method in class com.aspose.cells.ShapeFill
Sets the fill color of the shape.
setColor(Color) - Method in class com.aspose.cells.ShapeLine
Sets the border line color of the shape.
setColor(Color) - Method in class com.aspose.cells.Style
Sets the cell shading color.
setColor1(Color) - Method in class com.aspose.cells.FillFormat
Sets the gradient color 1 or the pattern foreground color for the the specified fill.
setColor1(Color) - Method in class com.aspose.cells.GradientFill
Sets the gradient color 1.
setColor2(Color) - Method in class com.aspose.cells.FillFormat
Sets the gradient color 2 or the pattern foreground color for the the specified fill.
setColor2(Color) - Method in class com.aspose.cells.GradientFill
Sets the gradient color 2.
setColorVaried(boolean) - Method in class com.aspose.cells.ASeries
Sets whether the color of points is varied.
setColumn(int) - Method in class com.aspose.cells.Comment
Sets the column index of the comment.
setColumn(int) - Method in class com.aspose.cells.VPageBreak
Sets column index, zero based.
setColumnGrand(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable report shows grand totals for columns.
setColumnHidden(int, boolean) - Method in class com.aspose.cells.Cells
Sets whether the specified column to be hidden or not.
setColumnHidden(int, boolean) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setColumnHidden(int,boolean)
setColumnStyle(short, Style) - Method in class com.aspose.cells.Worksheet
Sets a style to the specified column.
setColumnWidth(int, float) - Method in class com.aspose.cells.Cells
Sets the width of the specified column, in unit of characters using default font.
setColumnWidth(int, float) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setColumnWidth(int,float)
setColumnWidthInch(int, double) - Method in class com.aspose.cells.Cells
Sets the column width, in unit of inches.
setColumnWidthPixel(int, int) - Method in class com.aspose.cells.Cells
Sets the column width, in unit of pixels.
setComments(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the document comments.
setCompany(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the company property.
setCompoundType(short) - Method in class com.aspose.cells.Line
Sets compound type for line style.
setContent(String) - Method in class com.aspose.cells.TextBox
Sets the content of textbox.
setContentStatus(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the status of the document.
setContentType(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the content type of the document.
setConvertNumericData(boolean) - Method in class com.aspose.cells.Workbook
Indicates if convert string in text file to numeric data.
setCopies(int) - Method in class com.aspose.cells.PageSetup
Sets number of copies to print.
setCreatedTime(Date) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets date of the document creation in UTC.
setCropFromBottom(float) - Method in class com.aspose.cells.Picture
Sets the bottom cropping information.
setCropFromLeft(float) - Method in class com.aspose.cells.Picture
Sets the left cropping information.
setCropFromRight(float) - Method in class com.aspose.cells.Picture
Sets the right cropping information.
setCropFromTop(float) - Method in class com.aspose.cells.Picture
Sets the top cropping information.
setCrossAt(double) - Method in class com.aspose.cells.CategoryAxis
Sets the point on the category axis where the other axis crosses.
setCrossAt(double) - Method in class com.aspose.cells.ValueAxis
Sets the point on the value axis where the other axis crosses.
setCrossAtMax(boolean) - Method in class com.aspose.cells.CategoryAxis
Sets whether the axis crosses at the maximum value.
setCrossAtMax(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether the axis crosses at the maximum value.
setCurrentPageItem(int) - Method in class com.aspose.cells.PivotField
Sets the current page item showing for the page field (valid only for page fields).
setCurrentValue(int) - Method in class com.aspose.cells.Spinner
Sets the current value of a scroll bar or spinner.
setCustom(String) - Method in class com.aspose.cells.Style
Sets the custom number format string.
setCustomAmount(String, String) - Method in class com.aspose.cells.ErrorBars
Sets the error bar custom amount.
setDashStyle(int) - Method in class com.aspose.cells.ShapeLine
Sets the border line dash style of the shape.
setDashType(short) - Method in class com.aspose.cells.Line
Sets the dash type for line style.
setDataDisplayFormat(short) - Method in class com.aspose.cells.PivotField
Sets how to display the values contained in a data field.
setDataRange(String) - Method in class com.aspose.cells.Sparkline
Sets the data range of the sparkline.
setDataSource(ResultSet) - Method in class com.aspose.cells.WorkbookDesigner
Sets data source of a ResultSet object.
setDataSource(String, AsposeDataTable) - Method in class com.aspose.cells.WorkbookDesigner
Sets data source of a AsposeDataTable object and binds it to a data source name.
setDataSource(String, ResultSet) - Method in class com.aspose.cells.WorkbookDesigner
Sets data source of a ResultSet object and binds it to a data source name.
setDataSource(String, ResultSet, int) - Method in class com.aspose.cells.WorkbookDesigner
Sets data source of a ResultSet object and binds it to a data source name.
setDataSource(String, ResultSet, int, int) - Method in class com.aspose.cells.WorkbookDesigner
Sets data source of a ResultSet object and binds it to a data source name.
setDataSource(String, Object) - Method in class com.aspose.cells.WorkbookDesigner
Sets data binding to a variable.
setDataSource(String, Object[]) - Method in class com.aspose.cells.WorkbookDesigner
Sets data array binding to a variable.
setDataTableShown(boolean) - Method in class com.aspose.cells.Chart
Indicates whether the chart displays a data table.
setDate1904(boolean) - Method in class com.aspose.cells.Workbook
Sets whether the workbook works with 1904 date system.
setDefaultColumnWidth(float) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setStandardWidth(float)
setDefaultHeight() - Method in class com.aspose.cells.Row
Invalidate the row height setting.
setDefaultRowHeight(float) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setStandardHeight(float)
setDeleted(boolean) - Method in class com.aspose.cells.LegendEntry
Sets whether the lengend entry is deleted.
setDeletingColumnsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the deletion of columns is allowed on a protected worksheet.
setDeletingRowsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the deletion of rows is allowed on a protected worksheet.
setDepthPercent(int) - Method in class com.aspose.cells.Chart
Represents the depth of a 3-D chart view as a percentage of the chart width (between 20 and 2000 percent).
setDestination(Cell) - Method in class com.aspose.cells.PdfBookmarkEntry
set the cell to which the bookmark link
setDiagonalDownBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Diagonal down border settings will be applied.
setDiagonalUpBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Diagonal up border settings will be applied.
setDirection(byte) - Method in class com.aspose.cells.GradientFill
Sets direction type for Gradient fill.
setDisplayEquation(boolean) - Method in class com.aspose.cells.Trendline
Sets whether the R-squared value of the trendline is displayed on the chart (in the same data label as the equation).
setDisplayErrorString(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable report displays a custom string in cells that contain errors.
setDisplayHidden(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to show data in hidden rows and columns.
setDisplayHTMLCrossString(boolean) - Method in class com.aspose.cells.SaveOptions
Sets whether a cross-cell string will be displayed in the same way as MS Excel when saving an Excel file in html format.
setDisplayImmediateItems(boolean) - Method in class com.aspose.cells.PivotTable
Sets indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty.
setDisplayName(String) - Method in class com.aspose.cells.PivotField
Sets the PivotField display name.
setDisplayNullString(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable report displays a custom string in cells that contain null values.
setDisplayRSquared(boolean) - Method in class com.aspose.cells.Trendline
Sets whether the equation for the trendline is displayed on the chart (in the same data label as the R-squared value).
setDisplayUnitLabelShown(boolean) - Method in class com.aspose.cells.Axis
Sets whether the display unit label is shown on the specified axis
setDisplayUnitType(byte) - Method in class com.aspose.cells.Axis
Set the unit label for the specified axis.
setDocumentVersion(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the version of the document.
setDoughnutHoleSize(short) - Method in class com.aspose.cells.ASeries
Sets the size of the hole in a doughnut chart group.
setDraftQuality(boolean) - Method in class com.aspose.cells.PageSetup
Sets whether the sheet will be printed without graphics.
setDragToColumn(boolean) - Method in class com.aspose.cells.PivotField
Indicates whether the specified field can be dragged to the column position.
setDragToHide(boolean) - Method in class com.aspose.cells.PivotField
Indicates whether the field can be hidden by being dragged off the PivotTable report.
setDragToPage(boolean) - Method in class com.aspose.cells.PivotField
Indicates whether the specified field can be dragged to the page position.
setDragToRow(boolean) - Method in class com.aspose.cells.PivotField
Indicates whether the specified field can be dragged to the row position.
setDropDownLines(int) - Method in class com.aspose.cells.ComboBox
Sets the number of list lines displayed in the drop-down portion of a combo box.
setEditingContentsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the user is allowed to edit contents of locked cells on a protected worksheet.
setEditingObjectsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the user is allowed to manipulate drawing objects on a protected worksheet.
setEditingScenariosAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the user is allowed to edit scenarios on a protected worksheet.
setElevation(int) - Method in class com.aspose.cells.Chart
Sets the elevation of the 3-D chart view, in degrees(between -90 and 90).
setEnableDrilldown(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether drilldown is enabled.
setEnableFieldDialog(boolean) - Method in class com.aspose.cells.PivotTable
Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field.
setEnableFieldList(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether enable to display the field list for the PivotTable.
setEnableWizard(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable Wizard is available.
setEncoding(String) - Method in class com.aspose.cells.OpenOptions
Sets the name of the character encoding being used.
setEncoding(String) - Method in class com.aspose.cells.SaveOptions
Sets the name of the character encoding being used.
setEncryptionOption(byte, int) - Method in class com.aspose.cells.Workbook
Sets Encryption Options.
setEndArrowLengthType(short) - Method in class com.aspose.cells.Line
Sets the end arrow length type.
setEndArrowType(short) - Method in class com.aspose.cells.Line
Sets the end type of arrow settings for line style.
setEndArrowWidthType(short) - Method in class com.aspose.cells.Line
Sets the end arrow width type.
setEndColumn(int) - Method in class com.aspose.cells.CellArea
Sets the column index of the bottom right cell.
setEndColumn(int) - Method in class com.aspose.cells.NamedRange
Sets the column index of the bottom right cell.
setEndRow(int) - Method in class com.aspose.cells.CellArea
Sets the row index of the bottom right cell.
setEndRow(int) - Method in class com.aspose.cells.NamedRange
Sets the row index of the bottom right cell.
setEndStyleCap(boolean) - Method in class com.aspose.cells.ErrorBars
Sets whether the error bars has the end style cap for the error bars.
setEqualAverage(boolean) - Method in class com.aspose.cells.AboveAverage
Sets the flag indicating whether the 'aboveAverage' and 'belowAverage' criteria is inclusive of the average itself, or exclusive of that value.
setErrorMessage(String) - Method in class com.aspose.cells.Validation
Sets the data validation error message.
setErrorString(String) - Method in class com.aspose.cells.PivotTable
Returns or sets the string displayed in cells that contain errors.
setErrorTitle(String) - Method in class com.aspose.cells.Validation
Sets the title of the data-validation error dialog box.
setEscapement(int) - Method in class com.aspose.cells.Font
Sets the escapement type.
setExplosion(int) - Method in class com.aspose.cells.ASeries
Set the distance of an open pie slice from the center of the pie chart, expressed as a percentage of the pie diameter.
setExplosion(int) - Method in class com.aspose.cells.ChartPoint
Set the distance of an open pie slice from the center of the pie chart, expressed as a percentage of the pie diameter.
setExportObjectListener(ExportObjectListener) - Method in class com.aspose.cells.SaveOptions
Sets the ExportObjectListener to receive ExportObjectEvent.
setFashion(int) - Method in class com.aspose.cells.ImageOptions
Sets the generated image fashion.
setFileFormatType(int) - Method in class com.aspose.cells.Workbook
Sets the file format type for this workbook.
setFileType(byte) - Method in class com.aspose.cells.OleObject
Sets the file type of the embedded ole object data
setFill(Fill) - Method in class com.aspose.cells.Area
Sets specific fill settings for this Area.
setFill(Fill) - Method in class com.aspose.cells.Line
Sets the border color to gradient or pattern using given fill settings.
setFilled(boolean) - Method in class com.aspose.cells.Shape
Sets whether shape is filled.
setFilteringAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
setFirstPageNumber(int) - Method in class com.aspose.cells.PageSetup
Sets the first page number that will be used when this sheet is printed.
setFirstPointColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of the first point of data in the sparkline group.
setFirstSliceAngle(int) - Method in class com.aspose.cells.ASeries
Get the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).
setFirstSliceAngle(int) - Method in class com.aspose.cells.Chart
Sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).
setFirstVisibleColumn(int) - Method in class com.aspose.cells.Worksheet
Sets first visible column index.
setFirstVisibleRow(int) - Method in class com.aspose.cells.Worksheet
Sets first visible row index.
setFitToPagesTall(int) - Method in class com.aspose.cells.PageSetup
Sets the number of pages tall the worksheet will be scaled to when it's printed.
setFitToPagesWide(int) - Method in class com.aspose.cells.PageSetup
Sets the number of pages wide the worksheet will be scaled to when it's printed.
setFlippedHorizontally(boolean) - Method in class com.aspose.cells.Shape
Sets whether shape is flipped horizontally.
setFlippedVertically(boolean) - Method in class com.aspose.cells.Shape
Sets whether shape is flipped vertically.
setFont(Font) - Method in class com.aspose.cells.Axis
Sets a Font object that represents the font of the specified TickLabels object.
setFont(Font) - Method in class com.aspose.cells.ChartArea
Sets a Font object of the chart area.
setFont(Font) - Method in class com.aspose.cells.ChartDataTable
Sets a Font object which represents the font setting of the specified chart data table.
setFont(Font) - Method in class com.aspose.cells.DataLabels
Sets a Font object of the chart data label.
setFont(Font) - Method in class com.aspose.cells.DisplayUnitLabel
Sets a Font object of title.
setFont(Font) - Method in class com.aspose.cells.Legend
Sets a Font object of the chart legend.
setFont(Font) - Method in class com.aspose.cells.Shape
Sets the font of text in shape.
setFont(Font) - Method in class com.aspose.cells.Style
Sets the font of the style.
setFont(boolean) - Method in class com.aspose.cells.StyleFlag
Font settings will be applied.
setFont(Font) - Method in class com.aspose.cells.Title
Sets a Font object of title.
setFontBold(boolean) - Method in class com.aspose.cells.StyleFlag
Font bold setting will be applied.
setFontColor(boolean) - Method in class com.aspose.cells.StyleFlag
Font color setting will be applied.
setFontItalic(boolean) - Method in class com.aspose.cells.StyleFlag
Font bold setting will be applied.
setFontName(boolean) - Method in class com.aspose.cells.StyleFlag
Font name setting will be applied.
setFontPath(String[]) - Method in class com.aspose.cells.SaveOptions
Sets the font path(a list of directories containing fonts.
setFontScript(boolean) - Method in class com.aspose.cells.StyleFlag
Font script setting will be applied.
setFontSize(boolean) - Method in class com.aspose.cells.StyleFlag
Font size setting will be applied.
setFontStrike(boolean) - Method in class com.aspose.cells.StyleFlag
Font stikeout setting will be applied.
setFontUnderline(boolean) - Method in class com.aspose.cells.StyleFlag
Font underline setting will be applied.
setFooterMargin(double) - Method in class com.aspose.cells.PageSetup
Sets the distance from the bottom of the page to the footer, in unit of centimeters.
setFooterMarginInch(double) - Method in class com.aspose.cells.PageSetup
Sets the distance from the bottom of the page to the footer, in unit of inches.
setForegroundColor(Color) - Method in class com.aspose.cells.Area
Sets the foreground Color.
setForegroundColor(Color) - Method in class com.aspose.cells.PatternFill
Sets the foreground Color.
setForegroundTransparency(float) - Method in class com.aspose.cells.Area
Sets the transparency of foreground color.
setForegroundTransparency(float) - Method in class com.aspose.cells.PatternFill
Sets the transparency of foreground color.
setForMac(boolean) - Method in class com.aspose.cells.SaveOptions
Sets whether the workbook will be saved for Mac OS.
setFormattingCellsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the formatting of cells is allowed on a protected worksheet.
setFormattingColumnsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the formatting of columns is allowed on a protected worksheet.
setFormattingRowsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the formatting of rows is allowed on a protected worksheet.
setFormula(String) - Method in class com.aspose.cells.Cell
Sets the formula of the cell at runtime.
setFormula1(String) - Method in class com.aspose.cells.FormatCondition
Sets the value or expression associated with conditional formatting.
setFormula1(String) - Method in class com.aspose.cells.Validation
Sets the value or expression associated with the data validation.
setFormula2(String) - Method in class com.aspose.cells.FormatCondition
Gets the value or expression associated with conditional formatting.
setFormula2(String) - Method in class com.aspose.cells.Validation
Sets the value or expression associated with the data validation.
setFormulaHidden(boolean) - Method in class com.aspose.cells.Style
Sets whether formulas to be hidden or not.
setForward(double) - Method in class com.aspose.cells.Trendline
Sets the number of periods (or units on a scatter chart) that the trendline extends forward.
setFunction(int) - Method in class com.aspose.cells.PivotField
Sets the function used to summarize the PivotTable data field.
setGapDepth(int) - Method in class com.aspose.cells.Chart
Sets the distance between the data series in a 3-D chart, as a percentage of the marker width.
setGapWidth(int) - Method in class com.aspose.cells.ASeries
Set the space between bar or column clusters, as a percentage of the bar or column width.
setGapWidth(int) - Method in class com.aspose.cells.Chart
Sets the space between bar or column clusters, as a percentage of the bar or column width.
setGradientColorType(byte) - Method in class com.aspose.cells.FillFormat
Sets the gradient color type for the specified fill.
setGradientColorType(byte) - Method in class com.aspose.cells.GradientFill
Sets the gradient color type for the specified fill.
setGradientDegree(float) - Method in class com.aspose.cells.FillFormat
Sets the gradient degree for the the specified fill.
setGradientDegree(float) - Method in class com.aspose.cells.GradientFill
Sets the gradient degree for the the specified fill.
setGradientFillAngle(float) - Method in class com.aspose.cells.GradientFill
Sets the angle for linear type Gradient fill.
setGradientStyle(byte) - Method in class com.aspose.cells.FillFormat
Sets the gradient style for the specified fill.
setGradientStyle(byte) - Method in class com.aspose.cells.GradientFill
Sets the gradient style for the specified fill.
setGradientType(byte) - Method in class com.aspose.cells.GradientFill
Sets gradient type.
setGradientVariant(int) - Method in class com.aspose.cells.FillFormat
Sets the gradient variant for the the specified fill.
setGradientVariant(byte) - Method in class com.aspose.cells.GradientFill
Sets the gradient variant for the the specified fill.
setGreen(int) - Method in class com.aspose.cells.Color
Sets the green component value.
setGridlinesVisible(boolean) - Method in class com.aspose.cells.Worksheet
Sets whether the grid lines to be visible or not.
setHAlignment(short) - Method in class com.aspose.cells.Style
Sets the horizontal text alignment type.
setHas3DEffect(boolean) - Method in class com.aspose.cells.ASeries
Sets whether the series has 3D-effect.
setHasDropLine(boolean) - Method in class com.aspose.cells.ASeries
Set the chart has drop line.
setHasHeders(boolean) - Method in class com.aspose.cells.DataSorter
Sets whether the sorted range has header.
setHasHiLoLine(boolean) - Method in class com.aspose.cells.ASeries
Sets whether the line chart has high-low line.
setHasLeaderLine(boolean) - Method in class com.aspose.cells.ASeries
Sets whether the series has leader lines.
setHasLine(boolean) - Method in class com.aspose.cells.Shape
Sets whether shape has border line.
setHasRadarAxisLabels(boolean) - Method in class com.aspose.cells.ASeries
Sets if a radar chart has category axis labels.
setHasSeriesLine(boolean) - Method in class com.aspose.cells.ASeries
Set a stacked column chart or bar chart has series line or if a Pie of Pie chart or Bar of Pie chart has connector line between the two sections.
setHeaderMargin(double) - Method in class com.aspose.cells.PageSetup
Sets the distance from the top of the page to the header, in unit of centimeters.
setHeaderMarginInch(double) - Method in class com.aspose.cells.PageSetup
Sets the distance from the top of the page to the header, in unit of inches.
setHeight(int) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setHeight(int)
setHeight(int) - Method in class com.aspose.cells.Legend
Sets the height of frame,in units of 1/4000 of the chart area.
setHeight(int) - Method in class com.aspose.cells.ListBox
 
setHeight(int) - Method in class com.aspose.cells.PlotArea
Sets the height of the plot area, in units of 1/4000 of the chart area.
setHeight(float) - Method in class com.aspose.cells.Row
Sets the row height, in points.
setHeight(int) - Method in class com.aspose.cells.Shape
Sets the height, in unit of pixel.
setHeightCM(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setHeightCM(double)
setHeightCM(double) - Method in class com.aspose.cells.Shape
Sets the height, in unit of centimeters.
setHeightInch(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setHeightInch(double)
setHeightInch(double) - Method in class com.aspose.cells.Shape
Sets the height, in unit of inches.
setHeightInChart(int) - Method in class com.aspose.cells.Shape
Sets the height, in units of 1/4000 of the chart area.
setHeightPercent(int) - Method in class com.aspose.cells.Chart
Sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
setHidden(boolean) - Method in class com.aspose.cells.Row
Sets whether the row to be hidden or not.
setHighPointColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of the highest points of data in the sparkline group.
setHorizontalAlignment(boolean) - Method in class com.aspose.cells.StyleFlag
Horizontal alignment setting will be applied.
setHorizontalAxisColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of the horizontal axis in the sparkline group.
setHorizontalAxisDateRange(String) - Method in class com.aspose.cells.SparklineGroup
Sets the range that contains the date values for the sparkline data.
setHorizontalResolution(int) - Method in class com.aspose.cells.ImageOptions
Sets the horizontal resolution for generated images, in dots per inch.
setHorizontalScrollBarHidden(boolean) - Method in class com.aspose.cells.Workbook
Sets the horizontal scroll bar to be hidden or not.
setHtmlBasePath(String) - Method in class com.aspose.cells.OpenOptions
Sets the physical path where the html file is saved.
setHtmlExportImagesFolder(String) - Method in class com.aspose.cells.SaveOptions
Sets the physical folder where images are saved when exporting to HTML format.
setHtmlExportImagesFolderAlias(String) - Method in class com.aspose.cells.SaveOptions
Sets the name of the folder used to construct image URIs written into an HTML file.
setIgnoreBlank(boolean) - Method in class com.aspose.cells.Validation
Sets whether blank values are permitted by the range data validation.
setImageData(byte[]) - Method in class com.aspose.cells.TextureFill
Sets the picture data for Picture fill.
setImageFormat(int) - Method in class com.aspose.cells.ImageOptions
Sets the format for generated Image.
setInCellDropDown(boolean) - Method in class com.aspose.cells.Validation
Sets whether data validation displays a drop-down list that contains acceptable values.
setInclude(byte) - Method in class com.aspose.cells.ErrorBars
Sets the type of the error bar parts to include.
setIncrementalChange(int) - Method in class com.aspose.cells.Spinner
Sets the amount that the scroll bar or spinner is incremented a line scroll.
setIndent(int) - Method in class com.aspose.cells.Style
Sets the indent level.
setIndent(boolean) - Method in class com.aspose.cells.StyleFlag
Indent level setting will be applied.
setInnerText(String) - Method in class com.aspose.cells.Name
 
setInputMessage(String) - Method in class com.aspose.cells.Validation
Sets the data validation input message.
setInputRange(String) - Method in class com.aspose.cells.ComboBox
Sets the worksheet range used to fill the specified combo box.
setInputRange(String) - Method in class com.aspose.cells.ListBox
Sets the worksheet range used to fill the specified combo box.
setInputTitle(String) - Method in class com.aspose.cells.Validation
Sets the title of the data validation input dialog box.
setInsertingColumnsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the insertion of columns is allowed on a protected worksheet.
setInsertingHyperlinksAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the insertion of hyperlinks is allowed on a protected worksheet.
setInsertingRowsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the insertion of rows is allowed on a protected worksheet.
setIntercept(double) - Method in class com.aspose.cells.Trendline
Sets the point where the trendline crosses the value axis.
setInterceptAuto(boolean) - Method in class com.aspose.cells.Trendline
Sets whether Microsoft Workbook automatically determines the intercept of the trendline.
setInvertIfNegative(boolean) - Method in class com.aspose.cells.ASeries
Sets whether Microsoft Excel inverts the pattern in the item when it corresponds to a negative number.
setInvertIfNegative(boolean) - Method in class com.aspose.cells.ChartPoint
Sets whether Microsoft Excel inverts the pattern in the item when it corresponds to a negative number.
setIsGTE(boolean) - Method in class com.aspose.cells.CFValueObject
Sets the Greater Than Or Equal flag.
setIsOpen(boolean) - Method in class com.aspose.cells.PdfBookmarkEntry
set the bookmark open status
setIsZS(boolean) - Method in class com.aspose.cells.Workbook
Indicates whether RC-style addresses is Z1S1 style.
setItalic(boolean) - Method in class com.aspose.cells.Font
Sets whether the font to be italic or not.
setJoinType(byte) - Method in class com.aspose.cells.Line
Sets the join type for line style.
setKey(int) - Method in class com.aspose.cells.Cell
Sets the comparable key of this Cell.
setKey(int) - Method in class com.aspose.cells.ChartPoint
Sets the comparable key of this ChartPoint.
setKey(int) - Method in class com.aspose.cells.Column
Sets the comparable key of this Column.
setKey(int) - Method in class com.aspose.cells.LegendEntry
Sets the comparable key of this LegendEntry.
setKey(int) - Method in class com.aspose.cells.Row
Sets the comparable key of this Row.
setKey1(int) - Method in class com.aspose.cells.DataSorter
Sets first sorted key's column index.
setKey2(int) - Method in class com.aspose.cells.DataSorter
Sets second sorted key's column index.
setKey3(int) - Method in class com.aspose.cells.DataSorter
Sets third sorted key's column index.
setKeywords(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the document keywords.
setLabelPosition(byte) - Method in class com.aspose.cells.DataLabels
Sets the label postion.
setLanguage(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the Language of the document.
setLanguage(short) - Method in class com.aspose.cells.Workbook
Sets the user interface language of the Workbook version that has saved the file.
setLastPointColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of the last point of data in the sparkline group.
setLastPrinted(Date) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the date when the document was last printed in UTC.
setLastSavedBy(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the name of the last author.
setLastSavedTime(Date) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the time of the last save in UTC.
setLeft(int) - Method in class com.aspose.cells.ChartArea
Deprecated. if in Chart, use Shape.setLeftInChart(int) instead; if in common sheet, use Shape.setLeftPositionInPixel(short, short) instead.
setLeft(int) - Method in class com.aspose.cells.Shape
Deprecated. for shape in Chart, use Shape.setLeftInChart(int) instead; for shape in common sheet, use Shape.setLeftPositionInPixel(short, short) instead.
setLeftBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Left border settings will be applied.
setLeftCM(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setLeftCM(double)
setLeftCM(double) - Method in class com.aspose.cells.Shape
Sets the horizontal offset of shape from its left column, in unit of centimeters.
setLeftFooter(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the left section footer of an Workbook file.
setLeftHeader(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the left section header of an Workbook file.
setLeftInch(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setLeftInch(double)
setLeftInch(double) - Method in class com.aspose.cells.Shape
Sets the horizontal offset of shape from its left column, in unit of inches.
setLeftInChart(int) - Method in class com.aspose.cells.Shape
Sets the horizontal offset of shape from its left column, in units of 1/4000 of the chart area.
setLeftMargin(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the left margin, in unit of centimeters.
setLeftMarginInch(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the left margin, in unit of inches.
setLeftPosition(short, short) - Method in class com.aspose.cells.Shape
set left border position for shape.
setLeftPositionInPixel(short, short) - Method in class com.aspose.cells.Shape
set left border position for shape.
setLegendKeyShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label legend key display.
setLegendOverlay(boolean) - Method in class com.aspose.cells.Chart
Sets whether the Legend overlaps chart.
setLegendShown(boolean) - Method in class com.aspose.cells.Chart
Sets whether the chart legend will be displayed.Default is true.
setLicense(InputStream) - Method in class com.aspose.cells.License
Licenses the component.
setLine(Line) - Method in class com.aspose.cells.Trendline
Sets the line or border of Trendlines object.
setLineEndArrowHead(short) - Method in class com.aspose.cells.ArcShape
Sets the end arrow head type
setLineEndArrowHead(short) - Method in class com.aspose.cells.LineShape
Sets the end arrow head type
setLineEndArrowLengthType(short) - Method in class com.aspose.cells.ArcShape
Sets the end arrow length
setLineEndArrowLengthType(short) - Method in class com.aspose.cells.LineShape
Sets the end arrow length
setLineEndArrowWidthType(short) - Method in class com.aspose.cells.ArcShape
Sets the end arrow width
setLineEndArrowWidthType(short) - Method in class com.aspose.cells.LineShape
Sets the end arrow width
setLines(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets an estimate of the number of lines in the document.
setLineStartArrowHead(short) - Method in class com.aspose.cells.ArcShape
Sets the start arrow head type
setLineStartArrowHead(short) - Method in class com.aspose.cells.LineShape
Sets the start arrow head type
setLineStartArrowLengthType(short) - Method in class com.aspose.cells.ArcShape
Sets the start arrow length
setLineStartArrowLengthType(short) - Method in class com.aspose.cells.LineShape
Sets the start arrow length
setLineStartArrowWidthType(short) - Method in class com.aspose.cells.ArcShape
Sets the start arrow width
setLineStartArrowWidthType(short) - Method in class com.aspose.cells.LineShape
Sets the start arrow width
setLineWeight(double) - Method in class com.aspose.cells.SparklineGroup
Sets the line weight in each line sparkline in the sparkline group, in the unit of points.
setLinkedCell(String) - Method in class com.aspose.cells.CheckBox
Sets the worksheet range linked to the control's value
setLinkedCell(String) - Method in class com.aspose.cells.ComboBox
Sets the worksheet range linked to the control's value
setLinkedCell(String) - Method in class com.aspose.cells.ListBox
Sets the worksheet range linked to the control's value
setLinkedCell(String) - Method in class com.aspose.cells.RadioButton
Sets the worksheet range linked to the control's value
setLinkedCell(String) - Method in class com.aspose.cells.Shape
Sets the linked cell of shape.
setLinkedCell(String) - Method in class com.aspose.cells.Spinner
Sets the worksheet range linked to the control's value
setLocale(Locale) - Method in class com.aspose.cells.Workbook
Sets locale region at the time the file was saved.
setLockAspectRatio(boolean) - Method in class com.aspose.cells.Shape
Sets whether allow changes in aspect ratio.
setLocked(boolean) - Method in class com.aspose.cells.Shape
Sets if the object is locked when the sheet is protected.
setLocked(boolean) - Method in class com.aspose.cells.StyleFlag
Locked setting will be applied.
setLogarithmic(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether the value axis scale type is logarithmic or not.
setLogarithmicBase(float) - Method in class com.aspose.cells.ValueAxis
Sets the base of logarithmic scale.
setLookinType(byte) - Method in class com.aspose.cells.FindOptions
Sets the lookin type.
setLowPointColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of the lowest points of data in the sparkline group.
setMajorTickMark(int) - Method in class com.aspose.cells.Axis
Sets the type of major tick mark for the axis.
setMajorUnit(double) - Method in class com.aspose.cells.CategoryAxis
Sets the major units for the axis.
setMajorUnit(double) - Method in class com.aspose.cells.ValueAxis
Sets the major units for the value axis.
setMajorUnitScale(short) - Method in class com.aspose.cells.CategoryAxis
Sets the major unit scale for the category axis.
setManager(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the manager property.
setManualGroupField(int, Object, Object, ArrayList<Byte>, Number) - Method in class com.aspose.cells.PivotTable
Sets manual field group by the PivotTable.
setManualGroupField(PivotField, Object, Object, ArrayList<Byte>, Number) - Method in class com.aspose.cells.PivotTable
Sets manual field group by the PivotTable.
setManualUpdate(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable report is recalculated only at the user's request.
setMarkerBackgroundColor(Color) - Method in class com.aspose.cells.ASeries
Sets the marker backgournd color in a line chart, scatter chart, or radar chart.
setMarkerBackgroundColor(Color) - Method in class com.aspose.cells.ChartPoint
Sets the marker backgournd color in a line chart, scatter chart, or radar chart.
setMarkerForegroundColor(Color) - Method in class com.aspose.cells.ASeries
Represents the marker foregournd color in a line chart, scatter chart, or radar chart.
setMarkerForegroundColor(Color) - Method in class com.aspose.cells.ChartPoint
Represents the marker foregournd color in a line chart, scatter chart, or radar chart.
setMarkersColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of points in each line sparkline in the sparkline group.
setMarkerSize(int) - Method in class com.aspose.cells.ASeries
Sets the marker size in a line chart, scatter chart, or radar chart.
setMarkerSize(int) - Method in class com.aspose.cells.ChartPoint
Sets the marker size in a line chart, scatter chart, or radar chart.
setMarkerStyle(short) - Method in class com.aspose.cells.ASeries
Sets the marker style in a line chart, scatter chart, or radar chart.
setMarkerStyle(short) - Method in class com.aspose.cells.ChartPoint
Sets the marker style in a line chart, scatter chart, or radar chart.
setMatchCase(boolean) - Method in class com.aspose.cells.FindOptions
Sets whether is match case.
setMatchType(byte) - Method in class com.aspose.cells.FindOptions
Sets the match type.
setMaxCfvo(CFValueObject) - Method in class com.aspose.cells.ColorScale
Sets the max value object.
setMaxCfvo(CFValueObject) - Method in class com.aspose.cells.DataBar
Sets this DataBar's max value object.
setMaxColor(Color) - Method in class com.aspose.cells.ColorScale
Sets the max value object's corresponding color.
setMaxValue(double) - Method in class com.aspose.cells.CategoryAxis
Sets the max value of axis.
setMaxValue(int) - Method in class com.aspose.cells.Spinner
Sets the maximum value of a scroll bar or spinner range.
setMaxValue(double) - Method in class com.aspose.cells.ValueAxis
Sets the maximum value on the value axis.
setMergeLabels(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells.
setMidCfvo(CFValueObject) - Method in class com.aspose.cells.ColorScale
Sets the mid value object.
setMidColor(Color) - Method in class com.aspose.cells.ColorScale
Sets the mid value object's corresponding color.
setMinCfvo(CFValueObject) - Method in class com.aspose.cells.ColorScale
Sets the min value object.
setMinCfvo(CFValueObject) - Method in class com.aspose.cells.DataBar
Sets this DataBar's min value object.
setMinColor(Color) - Method in class com.aspose.cells.ColorScale
Sets the min value object's corresponding color.
setMinorTickMark(int) - Method in class com.aspose.cells.Axis
Sets the type of minor tick mark for the axis.
setMinorUnit(double) - Method in class com.aspose.cells.CategoryAxis
Sets the minor units for the axis.
setMinorUnit(double) - Method in class com.aspose.cells.ValueAxis
Sets the minor units for the value axis.
setMinorUnitScale(short) - Method in class com.aspose.cells.CategoryAxis
Sets the minor unit scale for the category axis.
setMinValue(double) - Method in class com.aspose.cells.CategoryAxis
Sets the min value of the axis.
setMinValue(int) - Method in class com.aspose.cells.Spinner
Sets the minimum value of a scroll bar or spinner range.
setMinValue(double) - Method in class com.aspose.cells.ValueAxis
Sets the minimum value on the value axis.
setName(String) - Method in class com.aspose.cells.ASeries
Sets the name of the data series.
setName(String) - Method in class com.aspose.cells.Font
Sets the font name.
setName(String) - Method in class com.aspose.cells.PivotTable
Sets the name of the PivotTable.
setName(String) - Method in class com.aspose.cells.Shape
Sets the name of this Shape.
setName(String) - Method in class com.aspose.cells.Style
Sets the name of the style.
setName(String) - Method in class com.aspose.cells.Trendline
Sets the name of the trendline.
setName(String) - Method in class com.aspose.cells.Worksheet
Sets the worksheet name.
setNameAuto(boolean) - Method in class com.aspose.cells.Trendline
Sets whether Microsoft Workbook automatically determines the name of the trendline.
setNameOfApplication(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the name of the application.
setNeedBitonal(boolean) - Method in class com.aspose.cells.ImageOptions
Set whether generate monochrome image.
setNegativePointsColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of the negative values on the sparkline group.
setNote(String) - Method in class com.aspose.cells.Comment
Sets the content of comment.
setNullString(String) - Method in class com.aspose.cells.PivotTable
Returns or sets the string displayed in cells that contain null values when the DisplayNullString property is true.
setNumber(int) - Method in class com.aspose.cells.Axis
Sets the format index for the TickLabels object.
setNumber(int) - Method in class com.aspose.cells.DataLabels
Sets the built-in display format of numbers and dates.
Use built-in numbers for better performance.
setNumber(int) - Method in class com.aspose.cells.PivotField
Sets the built-in display format of numbers and dates.
setNumber(int) - Method in class com.aspose.cells.Style
Sets the built-in display format of numbers and dates.
Use built-in numbers for better performance.
setNumberFormat(String) - Method in class com.aspose.cells.Axis
Sets the format string for the TickLabels object.
setNumberFormat(String) - Method in class com.aspose.cells.DataLabels
Sets the format string for the DataLabels object.
setNumberFormat(String) - Method in class com.aspose.cells.PivotField
Represents the custom display format of numbers and dates.
setNumberFormat(boolean) - Method in class com.aspose.cells.StyleFlag
Number format setting will be applied.
setNumberFormatLinked(boolean) - Method in class com.aspose.cells.Axis
Sets if the number format is linked to the cells(so that the number format changes in the labels when it changes in the cells).
setNumberFormatLinked(boolean) - Method in class com.aspose.cells.DataLabels
Sets if the number format is linked to the cells(so that the number format changes in the labels when it changes in the cells).
setOleSize(int, int, int, int) - Method in class com.aspose.cells.Workbook
Sets displayed size when Workbook file is used as an Ole object.
setOnePagePerSheet(boolean) - Method in class com.aspose.cells.SaveOptions
Sets whether render one sheet in one pdf page.
setOpenDocumentVersion(String) - Method in class com.aspose.cells.SaveOptions
Sets the version of Open Document when saving ODS file.
setOperator(int) - Method in class com.aspose.cells.FormatCondition
Sets the conditional format operator.
setOperator(int) - Method in class com.aspose.cells.Validation
Sets the operator for the data validation.
setOrder(int) - Method in class com.aspose.cells.Trendline
Sets the trendline order (between 2 and 6) when the trendline type is Polynomial.
setOrder1(byte) - Method in class com.aspose.cells.DataSorter
Sets sort order of the first key.
setOrder2(byte) - Method in class com.aspose.cells.DataSorter
Sets sort order of the second key.
setOrder3(byte) - Method in class com.aspose.cells.DataSorter
Sets sort order of the third key.
setOrientation(short) - Method in class com.aspose.cells.PageSetup
Sets orientation page print orientation.
setOrientation(int) - Method in class com.aspose.cells.Shape
Sets text orientation.
setOutlineBorder(int, Color) - Method in class com.aspose.cells.NamedRange
Sets outline border for this range.
setOutlineBorder(int, Color) - Method in class com.aspose.cells.Range
Sets outline border for this range.
setOverlap(int) - Method in class com.aspose.cells.ASeries
Specifies how bars and columns are positioned.
setOverlap(int) - Method in class com.aspose.cells.Chart
Sets the space between bar or column in a cluster, as a percentage of the bar or column width.
setPageBreakPreview(boolean) - Method in class com.aspose.cells.Worksheet
Sets the specified worksheet is shown in normal view or page break preview.
setPageChange(int) - Method in class com.aspose.cells.ScrollBar
 
setPageFieldOrder(byte) - Method in class com.aspose.cells.PivotTable
Sets the order in which page fields are added to the PivotTable report's layout.
setPageFieldWrapCount(int) - Method in class com.aspose.cells.PivotTable
Sets the number of page fields in each column or row in the PivotTable report.
setPageOrder(short) - Method in class com.aspose.cells.PageSetup
Sets the order that Microsoft Workbook uses to number pages when printing a large worksheet.
setPages(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Represents an estimate of the number of pages in the document.
setPaginate(boolean) - Method in class com.aspose.cells.ImageOptions
Set whether paginate sheet.
setPaperSize(short) - Method in class com.aspose.cells.PageSetup
Sets the size of the paper.
setParagraphs(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets an estimate of the number of paragraphs in the document.
setPassword(String) - Method in class com.aspose.cells.Protection
Sets the password to protect the worksheet.
setPattern(short) - Method in class com.aspose.cells.FillFormat
Sets an area's display pattern.
setPattern(short) - Method in class com.aspose.cells.PatternFill
Sets an area's display pattern.
setPatternColor(Color) - Method in class com.aspose.cells.Style
Sets the pattern color.
setPatternStyle(short) - Method in class com.aspose.cells.Style
Sets the pattern style.
setPdfBookmarkEntry(PdfBookmarkEntry) - Method in class com.aspose.cells.SaveOptions
Sets pdf bookmark.
setPdfCompliance(byte) - Method in class com.aspose.cells.SaveOptions
Sets the compliance for PDF convertion.
setPercent(boolean) - Method in class com.aspose.cells.Top10
Sets the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule.
setPercentageShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label Percentage display.
setPeriod(int) - Method in class com.aspose.cells.Trendline
Sets the period for the moving-average trendline.It must be between 2 and 255.
setPerspective(int) - Method in class com.aspose.cells.Chart
Gets the perspective for the 3-D chart view.
setPivotSource(String) - Method in class com.aspose.cells.Chart
Sets the pivot source.It means this chart is a PivotChart.
setPlacement(byte) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setPlacement(byte)
setPlacement(byte) - Method in class com.aspose.cells.Shape
Sets the way the drawing obejct is attached to the cells below it.
setPlotEmptyCellsType(byte) - Method in class com.aspose.cells.Chart
Sets the type to plot empty cells as.
setPlotEmptyCellsType(int) - Method in class com.aspose.cells.SparklineGroup
Sets the type to plot empty cells.
setPlotOnSecondAxis(boolean) - Method in class com.aspose.cells.ASeries
Sets whether this series is plotted on second value axis.
setPlotOrderReversed(boolean) - Method in class com.aspose.cells.ValueAxis
Sets whether Microsoft Workbook plots data points from last to first.
setPlotRightToLeft(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether the plot data is right to left.
setPlotVisibleCells(boolean) - Method in class com.aspose.cells.Chart
Sets whether only plot visible cells.
setPosition(float) - Method in class com.aspose.cells.GradientStop
Sets the stop position.
setPosition(int) - Method in class com.aspose.cells.Legend
Sets the legend position type.
setPreserveFormatting(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether formatting is preserved when the PivotTable is refreshed or recalculated.
setPresetColor(short) - Method in class com.aspose.cells.FillFormat
Sets the gradient preset color for the the specified fill.
setPresetColor(short) - Method in class com.aspose.cells.GradientFill
Sets the gradient preset color.
setPresetStyle(int) - Method in class com.aspose.cells.SparklineGroup
Sets the preset style type of the sparkline group.
setPrintable(boolean) - Method in class com.aspose.cells.Shape
Sets if the object is printable
setPrintArea(String) - Method in class com.aspose.cells.PageSetup
Sets the range to be printed.
setPrintComments(short) - Method in class com.aspose.cells.PageSetup
Sets the way comments are printed with the sheet.
setPrintErrors(short) - Method in class com.aspose.cells.PageSetup
Gets the type of print error displayed.
setPrintGridlines(boolean) - Method in class com.aspose.cells.PageSetup
Sets whether cell gridlines are printed on the page.
setPrintHeadings(boolean) - Method in class com.aspose.cells.PageSetup
Sets whether row and column headings are printed with this page.
setPrintingPageType(int) - Method in class com.aspose.cells.ImageOptions
Set the type that indicates which pages will not be printed.
setPrintQuality(int) - Method in class com.aspose.cells.PageSetup
Sets the print quality.
setPrintSize(byte) - Method in class com.aspose.cells.Chart
Sets the printed chart size.
setPrintTitleColumns(String) - Method in class com.aspose.cells.PageSetup
Sets the columns that contain the cells to be repeated on the left side of each page.
setPrintTitleRows(String) - Method in class com.aspose.cells.PageSetup
Sets the rows that contain the cells to be repeated at the top of each page.
setPrintTitles(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the print titles for the worksheet are set based on the PivotTable report.
setProtectedBy(String) - Method in class com.aspose.cells.Workbook
Sets the user who reserved this workbook by protect file with type ProtectionType.MODIFY_FILE
setQuality(int) - Method in class com.aspose.cells.ImageOptions
Sets a value determining the quality of the generated images to apply only when saving pages to the JPEG format The value must be between 0 and 100
setR1C1ArrayFormula(String, int, int) - Method in class com.aspose.cells.Cell
Sets a R1C1 array formula to a range of cells.
setR1C1Formula(String) - Method in class com.aspose.cells.Cell
Sets a R1C1 formula of the Cell.
setR1C1SharedFormula(String, int, int) - Method in class com.aspose.cells.Cell
Sets a R1C1 shared formula to a range of cells.
setRange(CellArea) - Method in class com.aspose.cells.AutoFilter
Sets cell range of auto filter.
setRangeOutlineBorder(int, int, int, int, int, Color) - Method in class com.aspose.cells.Cells
Sets outline border for an area of cells.
setRangeStyle(int, int, int, int, Style) - Method in class com.aspose.cells.Cells
Sets a style for an area of cells.
setRank(int) - Method in class com.aspose.cells.Top10
Sets the value of "n" in a "top/bottom n" conditional formatting rule.
setReadFormulaText(boolean) - Method in class com.aspose.cells.LightCellsSettings
set whether parse and return cell's formula text when parsing cell
setRectangularCornered(boolean) - Method in class com.aspose.cells.ChartArea
Sets whether area is rectangular cornered.Default is true.
setRed(int) - Method in class com.aspose.cells.Color
Sets the red component value.
setRefersTo(String) - Method in class com.aspose.cells.Name
 
setRefersTo(String) - Method in class com.aspose.cells.NamedRange
 
setRegion(short) - Method in class com.aspose.cells.Workbook
Sets the system regional settings at the time the file was saved.
setReverse(boolean) - Method in class com.aspose.cells.IconSet
Sets the flag indicating whether to reverse the default order of the icons in this icon set.
setReversed(boolean) - Method in class com.aspose.cells.CategoryAxis
Sets whether Microsoft Workbook plots data points from last to first.
setReversed(boolean) - Method in class com.aspose.cells.SeriesAxis
Sets whether Microsoft Workbook plots data points from last to first.
setRevisionNumber(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the document revision number.
setRightAngleAxes(boolean) - Method in class com.aspose.cells.Chart
True if the chart axes are at right angles, independent of chart rotation or elevation.
setRightBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Right border settings will be applied.
setRightFooter(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the right section footer of an Workbook file.
setRightHeader(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the right section header of an Workbook file.
setRightMargin(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the right margin, in unit of centimeters.
setRightMarginInch(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the right margin, in unit of inches.
setRotation(int) - Method in class com.aspose.cells.Axis
Sets text rotation angle.Must be between -90 and 90.
setRotation(int) - Method in class com.aspose.cells.Chart
Sets the rotation of the 3-D chart view (the rotation of the plot area around the series axis, in degrees)(between 0 and 360).
setRotation(int) - Method in class com.aspose.cells.DataLabels
Sets text rotation angel.Must be between -90 and 90.
setRotation(int) - Method in class com.aspose.cells.DisplayUnitLabel
Sets text rotation angel.Must be between -90 and 90.
setRotation(float) - Method in class com.aspose.cells.Shape
Rotates the shape
setRotation(int) - Method in class com.aspose.cells.Style
Sets the rotation degrees.
setRotation(boolean) - Method in class com.aspose.cells.StyleFlag
Rotation setting will be applied.
setRotation(int) - Method in class com.aspose.cells.Title
Sets text rotation angel.Must be between -90 and 90.
setRow(int) - Method in class com.aspose.cells.Comment
Sets the row index of the comment.
setRow(int) - Method in class com.aspose.cells.HPageBreak
Sets rolumn index, zero based.
setRowColumnHeadersVisible(boolean) - Method in class com.aspose.cells.Worksheet
Sets whether the worksheet will display row and column headers.
setRowGrand(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable report shows grand totals for rows.
setRowHeight(int, double) - Method in class com.aspose.cells.Cells
Sets the row height, in points.
setRowHeightInch(int, double) - Method in class com.aspose.cells.Cells
Sets the row height, in inch.
setRowHeightPixel(int, int) - Method in class com.aspose.cells.Cells
Sets the row height, in pixel.
setSaveData(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether data for the PivotTable report is saved with the workbook.
setScreenTip(String) - Method in class com.aspose.cells.Hyperlink
Sets screen tip of the hyperlink.
setSearchType(byte) - Method in class com.aspose.cells.FindOptions
Sets the search type.
setSecondCategoryData(String) - Method in class com.aspose.cells.NSeries
Sets the range of second category Axis values.
setSecondPlotSize(short) - Method in class com.aspose.cells.ASeries
Sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie.
setSelected(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable is selected.Default is false.
setSelected(boolean) - Method in class com.aspose.cells.Worksheet
Sets whether the worksheet is selected.
setSelectedIndex(int) - Method in class com.aspose.cells.ComboBox
Sets the index of currently selected item in the combo box.
setSelectedIndex(int) - Method in class com.aspose.cells.ListBox
Sets the index number of the currently selected item in the list box.
setSelectedItem(int, boolean) - Method in class com.aspose.cells.ListBox
Sets whether the item is selected.
setSelectingLockedCellsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the user is allowed to select locked cells on a protected worksheet.
setSelectingUnlockedCellsAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the user is allowed to select unlocked cells on a protected worksheet.
setSelectionType(byte) - Method in class com.aspose.cells.ListBox
Sets the selection mode of the specified list box.
setSeparator(char) - Method in class com.aspose.cells.DataLabels
Set the separator used for the data labels on a chart.
setSeriesColor(Color) - Method in class com.aspose.cells.SparklineGroup
Sets the color of the sparklines in the sparkline group.
setSeriesNumber(int) - Method in class com.aspose.cells.ASeries
Sets the series number(as shown in name box -- Sereies1, Sereies2, etc.).
setSeriesShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether chart's data label series names display.
setShadow(boolean) - Method in class com.aspose.cells.ASeries
Sets whether the series has a shadow
setShadow(boolean) - Method in class com.aspose.cells.ChartArea
Sets whether the chart area has a shadow.
setShadow(boolean) - Method in class com.aspose.cells.ChartPoint
Sets whether the series has a shadow
setShadow(boolean) - Method in class com.aspose.cells.CheckBox
Sets whether the shape has 3-D shading.
setShadow(boolean) - Method in class com.aspose.cells.ComboBox
Sets whether the combobox has 3-D shading.
setShadow(boolean) - Method in class com.aspose.cells.DataLabels
Sets if the frame has a shadow.
setShadow(boolean) - Method in class com.aspose.cells.DisplayUnitLabel
Sets if the frame has a shadow.
setShadow(boolean) - Method in class com.aspose.cells.GroupBox
Sets whether the shape has 3-D shading.
setShadow(boolean) - Method in class com.aspose.cells.Legend
Sets if the frame has a shadow.
setShadow(boolean) - Method in class com.aspose.cells.ListBox
Sets whether the shape has 3-D shading.
setShadow(boolean) - Method in class com.aspose.cells.RadioButton
Sets whether the shape has 3-D shading.
setShadow(boolean) - Method in class com.aspose.cells.Spinner
Sets whether the shape has 3-D shading.
setShadow(boolean) - Method in class com.aspose.cells.Title
Sets if the frame has a shadow.
setSharedFormula(String, int, int) - Method in class com.aspose.cells.Cell
Sets a shared formula to a range of cells.
setSheetTabBarHidden(boolean) - Method in class com.aspose.cells.Workbook
Sets the sheet tab bar to be hidden or not.
setShowAllItems(boolean) - Method in class com.aspose.cells.PivotField
Indicates whether all items in the PivotTable report are displayed, even if they don't contain summary data.
setShowCompact(boolean) - Method in class com.aspose.cells.PivotField
Indicates when ShowInOutlineForm is true, whether the application will display fields compactly in the sheet on which this PivotTable resides.
setShowError(boolean) - Method in class com.aspose.cells.Validation
Sets whether the data validation error message will be displayed whenever the user enters invalid data.
setShowFirstPoint(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to highlight the first point of data in the sparkline group.
setShowHighPoint(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to highlight the highest points of data in the sparkline group.
setShowHorizontalAxis(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to show the sparkline horizontal axis.
setShowInOutlineForm(boolean) - Method in class com.aspose.cells.PivotField
Indicates whether layout this field in outline form on the Pivot Table view.
setShowInput(boolean) - Method in class com.aspose.cells.Validation
Sets whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
setShowLastPoint(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to highlight the last point of data in the sparkline group.
setShowLegendKeys(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the data label legend key is visible.
setShowLowPoint(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to highlight the lowest points of data in the sparkline group.
setShowMarkers(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to highlight each point in each line sparkline in the sparkline group.
setShowNegativeBubbles(boolean) - Method in class com.aspose.cells.ASeries
Sets if negative bubbles are shown for the chart group.
setShowNegativePoints(boolean) - Method in class com.aspose.cells.SparklineGroup
Sets whether to highlight the negative values on the sparkline group with a different color or marker.
setShowSubtotalAtTop(boolean) - Method in class com.aspose.cells.PivotField
Indicates when ShowInOutlineForm is true, whether the application will display subtotals at the top of the list of items instead of at the bottom.
setShowValue(boolean) - Method in class com.aspose.cells.DataBar
Sets the flag indicating whether to show the values of the cells on which this data bar is applied.
setShowValue(boolean) - Method in class com.aspose.cells.IconSet
Sets the flag indicating whether to show the values of the cells on which this icon set is applied.
setShrinked(boolean) - Method in class com.aspose.cells.Style
Sets whether the text should be shrunk to fit or not.
setShrinkToFit(boolean) - Method in class com.aspose.cells.StyleFlag
Shrink to fit setting will be applied.
setSize(int) - Method in class com.aspose.cells.Font
Sets the font size.
setSize(int) - Method in class com.aspose.cells.Marker
Sets the marker size in a line chart, scatter chart, or radar chart.
setSizeWithWindow(boolean) - Method in class com.aspose.cells.Chart
Sets whether Microsoft Excel resizes the chart to match the size of the chart sheet window.
setSmooth(boolean) - Method in class com.aspose.cells.ASeries
Sets whether curve smoothing is turned on.
setSortingAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the sorting option is allowed on a protected worksheet.
setSourceFullName(String) - Method in class com.aspose.cells.OleObject
Sets the source full name of the source file for the linked OLE object.
setSplitType(short) - Method in class com.aspose.cells.ASeries
Sets the way the two sections of either a pie of pie chart or a bar of pie chart are split
setSplitValue(double) - Method in class com.aspose.cells.ASeries
Sets the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart.
setStandardHeight(float) - Method in class com.aspose.cells.Cells
Sets the default row height of the worksheet, in unit of points.
setStandardHeightPixels(int) - Method in class com.aspose.cells.Cells
/** sets the default row height of the worksheet in pixels.
setStandardWidth(float) - Method in class com.aspose.cells.Cells
Sets the default column width of the worksheet, in unit of characters using default font.
setStandardWidthPixels(int) - Method in class com.aspose.cells.Cells
Sets the default column width of the worksheet, in unit of pixels.
setStartColumn(int) - Method in class com.aspose.cells.CellArea
Sets the column index of the top left cell.
setStartColumn(int) - Method in class com.aspose.cells.NamedRange
Sets the column index of the top left cell.
setStartRow(int) - Method in class com.aspose.cells.CellArea
Sets the row index of the top left cell.
setStartRow(int) - Method in class com.aspose.cells.NamedRange
Sets the row index of the top left cell.
setStdDev(int) - Method in class com.aspose.cells.AboveAverage
Sets the number of standard deviations to include above or below the average in the conditional formatting rule.
setStopIfTrue(boolean) - Method in class com.aspose.cells.FormatCondition
Sets the "Stop If True" flag.
setStretchOffsetBottom(float) - Method in class com.aspose.cells.TextureFill
Sets the bottom offset for stretching picture.
setStretchOffsetLeft(float) - Method in class com.aspose.cells.TextureFill
Sets the left offset for stretching picture.
setStretchOffsetRight(float) - Method in class com.aspose.cells.TextureFill
Sets the right offset for stretching picture.
setStretchOffsetTop(float) - Method in class com.aspose.cells.TextureFill
Sets the top offset for stretching picture.
setStrikeOut(boolean) - Method in class com.aspose.cells.Font
Sets the strikeout horizontal line to be used or not.
setStyle(Style) - Method in class com.aspose.cells.Cell
Sets the cell a style.
setStyle(Style) - Method in class com.aspose.cells.Column
Sets a style to the column.
setStyle(Style) - Method in class com.aspose.cells.FormatCondition
Sets style of conditional formatted cell range.
setStyle(int) - Method in class com.aspose.cells.Line
Sets the style of the line
setStyle(short) - Method in class com.aspose.cells.Marker
Sets the marker style in a line chart, scatter chart, or radar chart.
setStyle(Style) - Method in class com.aspose.cells.Row
Sets the style of the row.
setStyle(int, int, Style) - Method in class com.aspose.cells.Row
Sets style for a continuous range of cells of the row.
setStyle(int) - Method in class com.aspose.cells.ShapeLine
Sets the border line style of the shape.
setStyle(int, int, int, int, Style) - Method in class com.aspose.cells.Worksheet
Deprecated. Replaced by Cells.setRangeStyle(int,int,int,int,Style)
setSubEntryList(ArrayList<PdfBookmarkEntry>) - Method in class com.aspose.cells.PdfBookmarkEntry
Set the sub entry array list of this bookmark
setSubject(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the subject of the document.
setSubtotalHiddenPageItems(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether hidden page field items in the PivotTable report;
setSubtotals(short, boolean) - Method in class com.aspose.cells.PivotField
Sets whether the specified field shows that subtotals.
setSummaryColumnRight(boolean) - Method in class com.aspose.cells.Outline
Sets whether the summary column will be positioned to the right of the detail columns in the outline.
setSummaryRowBelow(boolean) - Method in class com.aspose.cells.Outline
Sets whether the summary row will be positioned below the detail rows in the outline.
setTabColor(Color) - Method in class com.aspose.cells.Worksheet
Sets the colour of the tab below the sheet containing the sheet name.
setTag(String) - Method in class com.aspose.cells.PivotTable
Sets a string saved with the PivotTable report.
setTemplate(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the informational name of the document template.
setText(String) - Method in class com.aspose.cells.DataLabels
Gets the text of a frame's title.
setText(String) - Method in class com.aspose.cells.DisplayUnitLabel
Gets the text of label.
setText(String) - Method in class com.aspose.cells.FormatCondition
Sets the text value in a "text contains" conditional formatting rule.
setText(String) - Method in class com.aspose.cells.Name
Sets the name of the range.
setText(String) - Method in class com.aspose.cells.NamedRange
Sets the name of the range.
setText(String) - Method in class com.aspose.cells.PdfBookmarkEntry
set title of a bookmark
setText(String) - Method in class com.aspose.cells.Shape
Sets the text in shape.
setText(String) - Method in class com.aspose.cells.Title
Sets the text of a frame's title.
setTextDirection(int) - Method in class com.aspose.cells.Axis
Sets the text direction type.
setTextDirection(int) - Method in class com.aspose.cells.DataLabels
Sets the text direction type.
setTextDirection(int) - Method in class com.aspose.cells.DisplayUnitLabel
Sets the text direction type.
setTextDirection(int) - Method in class com.aspose.cells.Style
Sets the text direction type.
setTextDirection(boolean) - Method in class com.aspose.cells.StyleFlag
Text direction setting will be applied.
setTextDirection(int) - Method in class com.aspose.cells.Title
Sets the text direction type.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.DataLabels
Sets the text horizontal alignment.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.DisplayUnitLabel
Sets the text horizontal alignment.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.Shape
Sets the text horizontal alignment.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.Title
Sets the text horizontal alignment.
setTextToDisplay(String) - Method in class com.aspose.cells.Hyperlink
Sets text to be displayed for the hyperlink.
setTexture(short) - Method in class com.aspose.cells.FillFormat
Sets the texture type for the specified fill.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.DataLabels
Sets the text vertical alignment of text.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.DisplayUnitLabel
Sets the text vertical alignment of text.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.Shape
Sets the text vertical alignment.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.Title
Sets the text vertical alignment of text.
setTextWrapped(boolean) - Method in class com.aspose.cells.Style
Sets whether the text should be wrapped.
setTickLabelPosition(int) - Method in class com.aspose.cells.Axis
Sets the position of tick-mark labels on the axis.
setTickLabelSpacing(int) - Method in class com.aspose.cells.CategoryAxis
Sets the number of category between tick-mark labels.
setTickLabelSpacing(int) - Method in class com.aspose.cells.SeriesAxis
Sets the number of series between tick-mark labels.
setTickMarkSpacing(int) - Method in class com.aspose.cells.CategoryAxis
Sets the number of category between tick marks.
setTickMarkSpacing(int) - Method in class com.aspose.cells.SeriesAxis
Sets the number of series between tick marks.
setTickOffset(short) - Method in class com.aspose.cells.CategoryAxis
Sets the distance between the levels of labels, and the distance between the first level and the axis line.
setTileAlignment(byte) - Method in class com.aspose.cells.TextureFill
Sets alignment for tiling.
setTileMirrorType(byte) - Method in class com.aspose.cells.TextureFill
Sets mirror type for tiling.
setTileOffsetX(float) - Method in class com.aspose.cells.TextureFill
Sets the X offset for tiling picture.
setTileOffsetY(float) - Method in class com.aspose.cells.TextureFill
Sets the Y offset for tiling picture.
setTileScaleX(float) - Method in class com.aspose.cells.TextureFill
Sets the X scale for tiling picture.
setTileScaleY(float) - Method in class com.aspose.cells.TextureFill
Sets the Y scale for tiling picture.
setTiling(boolean) - Method in class com.aspose.cells.TextureFill
Sets whether tile picture as texture.
setTimePeriodType(byte) - Method in class com.aspose.cells.FormatCondition
Sets the applicable time period in a "date occurring� conditional formatting rule.
setTitle(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the title of the document.
setTitleOverlay(boolean) - Method in class com.aspose.cells.Chart
Sets whether the chart title overlaps chart.
setTop(int) - Method in class com.aspose.cells.ChartArea
Deprecated. if in Chart, use Shape.setTopInChart(int) instead; if in common sheet, use Shape.setTopPositionInPixel(int, short) instead.
setTop(int) - Method in class com.aspose.cells.Shape
Deprecated. for shape in Chart, use Shape.setTopInChart(int) instead; for shape in common sheet, use Shape.setTopPositionInPixel(int, short) instead.
setTopBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Top border settings will be applied.
setTopCM(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setTopCM(double)
setTopCM(double) - Method in class com.aspose.cells.Shape
Sets the vertical offset of shape from its top row, in unit of centimeters.
setTopInch(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setTopInch(double)
setTopInch(double) - Method in class com.aspose.cells.Shape
Sets the vertical offset of shape from its top row, in unit of inches.
setTopInChart(int) - Method in class com.aspose.cells.Shape
Sets the vertical offset of shape from its top row, in units of 1/4000 of the chart area.
setTopMargin(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the top margin, in unit of centimeters.
setTopMarginInch(double) - Method in class com.aspose.cells.PageSetup
Sets the size of the top margin, in unit of inches.
setTopPosition(int, short) - Method in class com.aspose.cells.Shape
set top border position for shape.
setTopPositionInPixel(int, short) - Method in class com.aspose.cells.Shape
set top border position for shape.
setTotalEditingTime(double) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the total editing time in minutes.
setTransparence(int) - Method in class com.aspose.cells.ShapeFill
Sets the degree of transparency of the specified fill as a value from 0 (opaque) through 100 (clear).
setTransparency(float) - Method in class com.aspose.cells.GradientStop
Sets the transparency of this gradient stop.
setTransparency(float) - Method in class com.aspose.cells.Line
Sets the transparency.
setTransparency(float) - Method in class com.aspose.cells.TextureFill
Sets the transparency of this gradient stop.
setType(int) - Method in class com.aspose.cells.ASeries
Sets a data series' type.
setType(byte) - Method in class com.aspose.cells.CFValueObject
Sets the type of this conditional formatting value object.
setType(int) - Method in class com.aspose.cells.Chart
Sets a chart's type.
setType(int) - Method in class com.aspose.cells.FormatCondition
Sets the conditional format's type.
setType(byte) - Method in class com.aspose.cells.IconSet
Sets the icon set type to display.
setType(int) - Method in class com.aspose.cells.SparklineGroup
Sets the sparkline type of the sparkline group.
setType(short) - Method in class com.aspose.cells.TextureFill
Sets the texture type.
setType(int) - Method in class com.aspose.cells.Trendline
Sets the trendline type
setType(int) - Method in class com.aspose.cells.Validation
Sets the validation data type.
setUnderline(int) - Method in class com.aspose.cells.Font
Sets the underline type.
setUngroup(int) - Method in class com.aspose.cells.PivotTable
Sets ungroup by the PivotTable.
setUngroup(PivotField) - Method in class com.aspose.cells.PivotTable
Sets ungroup by the PivotTable.
setUpDownBar(boolean) - Method in class com.aspose.cells.ASeries
Set a line chart has up and down bars.
setUpperLeftColumn(int) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setLeftPosition(short, short)
setUpperLeftColumn(int) - Method in class com.aspose.cells.Shape
Deprecated. replaced by Shape.setLeftPosition(short, short)
setUpperLeftRow(int) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setTopPosition(int, short)
setUpperLeftRow(int) - Method in class com.aspose.cells.Shape
Deprecated. replaced by Shape.setTopPosition(int, short)
setUseDefaultHeight(boolean) - Method in class com.aspose.cells.Row
Sets whether row has default row height .
setUseDefaultWidth(boolean) - Method in class com.aspose.cells.Column
Sets whether column has default column width.
setUsingPivotTablesAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the user is allowed to manipulate pivot tables on a protected worksheet.
setVAlignment(short) - Method in class com.aspose.cells.Style
Sets the vertical text alignment type.
setValue(int) - Method in class com.aspose.cells.Cell
Sets the cell an int value.
setValue(double) - Method in class com.aspose.cells.Cell
Sets the cell a double value.
setValue(String) - Method in class com.aspose.cells.Cell
Sets the cell a string value.
setValue(String, boolean) - Method in class com.aspose.cells.Cell
Sets a string value into the cell and converts the value to other data type if appropriate.
setValue(boolean) - Method in class com.aspose.cells.Cell
Sets the cell a boolean value.
setValue(Calendar) - Method in class com.aspose.cells.Cell
Sets the cell a datetime value.
setValue(Object) - Method in class com.aspose.cells.Cell
Sets the cell an object value.
setValue(Object) - Method in class com.aspose.cells.CFValueObject
Sets the value of this conditional formatting value object.
setValue(Object) - Method in class com.aspose.cells.DocumentProperty
Sets the value of the property.
setValues(String) - Method in class com.aspose.cells.ASeries
Sets the data of the chart series.
setValueShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label values display.
setVersion(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the version number of the application that created the document.
setVerticalAlignment(boolean) - Method in class com.aspose.cells.StyleFlag
Vertical alignment setting will be applied.
setVerticalAxisMaxValue(double) - Method in class com.aspose.cells.SparklineGroup
Sets the custom maximum value for the vertical axis.
setVerticalAxisMaxValueType(int) - Method in class com.aspose.cells.SparklineGroup
Sets the vertical axis maximum value type.
setVerticalAxisMinValue(double) - Method in class com.aspose.cells.SparklineGroup
Sets the custom minimum value for the vertical axis.
setVerticalAxisMinValueType(int) - Method in class com.aspose.cells.SparklineGroup
Sets the vertical axis minimum value type.
setVerticalResolution(int) - Method in class com.aspose.cells.ImageOptions
Sets the vertical resolution for generated images, in dots per inch.
setVerticalScrollBarHidden(boolean) - Method in class com.aspose.cells.Workbook
Sets the vertical scroll bar to be hidden or not.
setVeryHidden(boolean) - Method in class com.aspose.cells.Worksheet
Sets whether the worksheet to be very hidden or not.
setVisible(boolean) - Method in class com.aspose.cells.Area
Sets whether the area is visible in the chart.
setVisible(boolean) - Method in class com.aspose.cells.Axis
Sets whether the axis is visible.
setVisible(boolean) - Method in class com.aspose.cells.Comment
Sets whether the comment is visible or not.
setVisible(boolean) - Method in class com.aspose.cells.Line
Sets whether the line is visible in the chart.
setVisible(boolean) - Method in class com.aspose.cells.ShapeFill
Sets whether shape is filled.
setVisible(boolean) - Method in class com.aspose.cells.ShapeLine
Sets whether the border line to be visible or not.
setVisible(boolean) - Method in class com.aspose.cells.Worksheet
Sets whether the worksheet to be visible or not.
setWallsAndGridlines2D(boolean) - Method in class com.aspose.cells.Chart
set whether gridlines are drawn two-dimensionally on a 3-D chart.
setWeight(int) - Method in class com.aspose.cells.Line
Sets the weight type of the line.
setWeight(float) - Method in class com.aspose.cells.ShapeLine
Sets the border line weight of the shape,in unit of pts.
setWidth(int) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setWidth(int)
setWidth(int) - Method in class com.aspose.cells.Legend
Sets the width of frame,in units of 1/4000 of the chart area.
setWidth(float) - Method in class com.aspose.cells.Line
Sets the width of line, in points.
setWidth(int) - Method in class com.aspose.cells.PlotArea
Sets the width of the plot area, in units of 1/4000 of the chart area.
setWidth(int) - Method in class com.aspose.cells.Shape
Sets the width, in unit of pixel.
setWidthCM(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setWidthCM(double)
setWidthCM(double) - Method in class com.aspose.cells.Shape
Sets the width, in unit of centimeters.
setWidthInch(double) - Method in class com.aspose.cells.ChartArea
Deprecated. replaced by Shape.setWidthInch(double)
setWidthInch(double) - Method in class com.aspose.cells.Shape
Sets the width, in unit of inches.
setWidthInChart(int) - Method in class com.aspose.cells.Shape
Sets the width, in units of 1/4000 of the chart area.
setWords(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Represents an estimate of the number of words in the document.
setWrapText(boolean) - Method in class com.aspose.cells.StyleFlag
Wrap text setting will be applied.
setX(int) - Method in class com.aspose.cells.DataLabels
Sets position of DataLabels.
setX(int) - Method in class com.aspose.cells.Legend
Sets the x coordinate of the upper left corner in units of 1/4000 of the chart area.
setX(int) - Method in class com.aspose.cells.PlotArea
Sets the x coordinate of the upper left corner in units of 1/4000 of the chart area.
setX(int) - Method in class com.aspose.cells.Title
Sets the x coordinate of the Title's center in units of 1/4000 of the chart area.
setXValues(String) - Method in class com.aspose.cells.ASeries
Sets the range of x values.
setY(int) - Method in class com.aspose.cells.DataLabels
Sets position of DataLabels.
setY(int) - Method in class com.aspose.cells.Legend
Sets the y coordinate of the upper left corner in units of 1/4000 of the chart area.
setY(int) - Method in class com.aspose.cells.PlotArea
Sets the y coordinate of the upper left corner in units of 1/4000 of the chart area.
setY(int) - Method in class com.aspose.cells.Title
Sets the y coordinate of the upper left corner in units of 1/4000 of the chart area.
setZoom(int) - Method in class com.aspose.cells.PageSetup
Sets the scaling factor in percent.
setZoom(int) - Method in class com.aspose.cells.Worksheet
Sets the scaling factor in percent.
Shape - Class in com.aspose.cells
Common Shape Property.
ShapeFill - Class in com.aspose.cells
Encapsulates the object that contains fill formatting properties for the specified shape.
ShapeLine - Class in com.aspose.cells
Encapsulates the object that contains formatting information for the shape's border.
Shapes - Class in com.aspose.cells
Represents all the shapes in the worksheet.
SheetRender - Class in com.aspose.cells
Represents a worksheet render which can render worksheet to various images such as (BMP, PNG, JPEG,EMF...)
SheetRender(Worksheet, ImageOptions) - Constructor for class com.aspose.cells.SheetRender
The construct of SheetRender
SheetType - Interface in com.aspose.cells
Enumerates worksheet types.
shiftRows(int, int, int) - Method in class com.aspose.cells.Cells
Shifts rows between startRow and endRow upward or downward.
SHINGLE - Static variable in interface com.aspose.cells.FillPatternType
Represents shingle pattern.
SHORT - Static variable in interface com.aspose.cells.MsoLineEndLength
Line end length: SHORT
showAll() - Method in class com.aspose.cells.AutoFilter
Shows all items.
showAllItems() - Method in class com.aspose.cells.PivotField
Indicates whether all items in the PivotTable report are displayed, even if they don't contain summary data.
SILVER - Static variable in class com.aspose.cells.Color
The color silver.
SILVER - Static variable in interface com.aspose.cells.GradientPresetType
Represents silver preset color.
SINGLE - Static variable in interface com.aspose.cells.MsoLineStyle
Single line.
SINGLE - Static variable in interface com.aspose.cells.SelectionType
 
SINGLE_LINE - Static variable in interface com.aspose.cells.WeightType
Represents the weight of single line.
size() - Method in interface com.aspose.cells.AsposeDataTable
Gets the size of the records.
size() - Method in class com.aspose.cells.CFValueObjectCollection
Gets the number of CFValueObject objects in this collection.
size() - Method in class com.aspose.cells.ChartPoints
Gets the total DataPoint count of corresponding ASeries.
size() - Method in class com.aspose.cells.Charts
Gets number of charts in the worksheet.
size() - Method in class com.aspose.cells.Comments
Gets number of comments in the worksheet.
size() - Method in class com.aspose.cells.ConditionalFormattings
Gets number of the FormatConditions objects.
size() - Method in class com.aspose.cells.GradientStops
 
size() - Method in class com.aspose.cells.HPageBreaks
Gets number of the HPageBreak objects.
size() - Method in class com.aspose.cells.Hyperlinks
Gets number of the Hyberlink objects.
size() - Method in class com.aspose.cells.LegendEntries
Gets the count of defined LegendEntry in this collection.
size() - Method in class com.aspose.cells.NSeries
Gets number of series.
size() - Method in class com.aspose.cells.Pictures
Gets number of pictures in the worksheet.
size() - Method in class com.aspose.cells.PivotFields
Gets the number of the PiovtFields in the PivotFields.
size() - Method in class com.aspose.cells.PivotItems
Gets the size of the pivot items.
size() - Method in class com.aspose.cells.PivotTables
Gets the number of the PivotTable reports in the worksheet.
size() - Method in class com.aspose.cells.Shapes
get the size of collection
size() - Method in class com.aspose.cells.SparklineCollection
Gets number of sparkline in the collection.
size() - Method in class com.aspose.cells.SparklineGroupCollection
Gets the number of sparklineGroups in this collection.
size() - Method in class com.aspose.cells.TextBoxes
Gets number of text boxs in the worksheet.
size() - Method in class com.aspose.cells.Trendlines
Gets the size of this collection.
size() - Method in class com.aspose.cells.Validations
Gets number of the Validation objects.
size() - Method in class com.aspose.cells.VPageBreaks
Gets number of the VPageBreak objects.
size() - Method in class com.aspose.cells.Worksheets
Gets the number of sheets in the workbook.
sizeOfCellAreaList() - Method in class com.aspose.cells.FormatConditions
Gets size of conditionally formatted ranges.
sizeOfConditionList() - Method in class com.aspose.cells.FormatConditions
Gets size of formatting conditions.
sizeOfPageFields() - Method in class com.aspose.cells.PivotPageFields
Gets the number of page fields.
SLANTED_MEDIUM_DASH_DOTTED - Static variable in interface com.aspose.cells.BorderLineType
Represents slanted medium dash-dotted line.
SMALE_CHECKER_BORDER - Static variable in interface com.aspose.cells.FillPatternType
Deprecated. replaced by FillPatternType.SMALL_CHECKER_BOARD
SMALL_CHECKER_BOARD - Static variable in interface com.aspose.cells.FillPatternType
Represents small checker border pattern.
SMALL_CONFETTI - Static variable in interface com.aspose.cells.FillPatternType
Represents small confetti pattern.
SMALL_GRID - Static variable in interface com.aspose.cells.FillPatternType
Represents small grid pattern.
SOLID - Static variable in interface com.aspose.cells.FillType
Represents solid formatting type.
SOLID - Static variable in interface com.aspose.cells.LineType
Represent a solid line.
SOLID - Static variable in interface com.aspose.cells.MsoLineDashStyle
Represents a solid line.
SOLID - Static variable in interface com.aspose.cells.PatternType
Represents solid pattern.
SOLID_DIAMOND - Static variable in interface com.aspose.cells.FillPatternType
Represents solid diamond pattern.
sort(Cells, CellArea) - Method in class com.aspose.cells.DataSorter
 
sortNames() - Method in class com.aspose.cells.Worksheets
Sorts defined names.
SortOrderType - Interface in com.aspose.cells
Presents sort order type.
SPACE - Static variable in interface com.aspose.cells.DataLabelsSeparatorType
 
SPAIN - Static variable in interface com.aspose.cells.CountryCode
 
Sparkline - Class in com.aspose.cells
A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
SparklineAxisMinMaxType - Interface in com.aspose.cells
Represents the minimum and maximum value types for the sparkline vertical axis.
SparklineCollection - Class in com.aspose.cells
Encapsulates a collection of Sparkline objects.
SparklineGroup - Class in com.aspose.cells
Sparkline is organized into sparkline group.
SparklineGroupCollection - Class in com.aspose.cells
Encapsulates a collection of SparklineGroup objects.
SparklinePresetStyleType - Interface in com.aspose.cells
Represents the preset style types for sparkline.
SparklineType - Interface in com.aspose.cells
Represents the sparkline types.
SPHERE - Static variable in interface com.aspose.cells.FillPatternType
Represents sphere pattern.
SPINNER - Static variable in class com.aspose.cells.MsoDrawingType
Reprents the Spinner.
Spinner - Class in com.aspose.cells
 
split() - Method in class com.aspose.cells.Worksheet
Splits window.
SPREADSHEETML - Static variable in interface com.aspose.cells.FileFormatType
Represents an xml spreadsheet file.
SQUARE - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers.
SQUARE - Static variable in interface com.aspose.cells.LineCapType
Cap type: Square
SQUARE_DOT - Static variable in interface com.aspose.cells.MsoLineDashStyle
Represents a square-dot line.
SQUARE_PLUS - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers with a plus sign.
SQUARE_STAR - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers with an asterisk.
SQUARE_X - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers with an X.
STACKED - Static variable in interface com.aspose.cells.SparklineType
Win/Loss sparkline.
STANDARD_DEV - Static variable in interface com.aspose.cells.ErrorBarType
Standard deviation(s).
STANDARD_ERROR - Static variable in interface com.aspose.cells.ErrorBarType
Standard error.
startCell(int, int) - Method in interface com.aspose.cells.CellHandler
start with a cell, check whether process it.
startSheet(int) - Method in interface com.aspose.cells.CellHandler
start with a worksheet, check whether process it.
Stationery - Static variable in interface com.aspose.cells.TextureType
Represents Stationery texture type.
STD_DEV - Static variable in interface com.aspose.cells.ConsolidationFunction
Represents StdDev function.
STD_DEV - Static variable in interface com.aspose.cells.PivotFieldSubtotalType
Represents StdDev subtotal type.
STD_DEVP - Static variable in interface com.aspose.cells.ConsolidationFunction
Represents StdDevp function.
STD_DEVP - Static variable in interface com.aspose.cells.PivotFieldSubtotalType
Represents StdDevp subtotal type.
STOCK_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents High-Low-Close Stock Chart.
STOCK_OPEN_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents Open-High-Low-Close Stock Chart.
STOCK_VOLUME_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents Volume-High-Low-Close Stock Chart.
STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE - Static variable in interface com.aspose.cells.ChartType
Represents Volume-Open-High-Low-Close Stock Chart.
STONG_CRYPTOGRAPHIC_PROVIDER - Static variable in interface com.aspose.cells.EncryptionType
 
STOP - Static variable in interface com.aspose.cells.ValidationAlertType
STOP alert style.
STRING - Static variable in interface com.aspose.cells.CellValueType
Cell value is string.
STRING - Static variable in interface com.aspose.cells.PropertyType
The property is a string value.
STRUCTURE - Static variable in interface com.aspose.cells.ProtectionType
Represents to protect structure, used in Workbook protection.
Style - Class in com.aspose.cells
Represents display styles of Workbook spreadsheets.
STYLE_1 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 1
STYLE_10 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 10
STYLE_11 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 11
STYLE_12 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 12
STYLE_13 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 13
STYLE_14 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 14
STYLE_15 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 15
STYLE_16 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 16
STYLE_17 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 17
STYLE_18 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 18
STYLE_19 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 19
STYLE_2 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 2
STYLE_20 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 20
STYLE_21 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 21
STYLE_22 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 22
STYLE_23 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 23
STYLE_24 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 24
STYLE_25 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 25
STYLE_26 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 26
STYLE_27 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 27
STYLE_28 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 28
STYLE_29 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 29
STYLE_3 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 3
STYLE_30 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 30
STYLE_31 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 31
STYLE_32 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 32
STYLE_33 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 33
STYLE_34 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 34
STYLE_35 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 35
STYLE_36 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 36
STYLE_4 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 4
STYLE_5 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 5
STYLE_6 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 6
STYLE_7 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 7
STYLE_8 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 8
STYLE_9 - Static variable in interface com.aspose.cells.SparklinePresetStyleType
Style 9
StyleFlag - Class in com.aspose.cells
Represents flags which indicates applied formatting properties.
StyleFlag() - Constructor for class com.aspose.cells.StyleFlag
Constructs an object.
subtotal(CellArea, int, short, int[]) - Method in class com.aspose.cells.Cells
Creates subtotals for the range.
subtotal(CellArea, int, short, String, String, int[]) - Method in class com.aspose.cells.Cells
Creates subtotals for the range.
subtotalHiddenPageItems() - Method in class com.aspose.cells.PivotTable
Indicates whether hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals.
SUM - Static variable in interface com.aspose.cells.ConsolidationFunction
Represents Sum function.
SUM - Static variable in interface com.aspose.cells.PivotFieldSubtotalType
Represents Sum subtotal type.
SURFACE_3D - Static variable in interface com.aspose.cells.ChartType
Represents Surface Chart: 3D Surface Chart.
SURFACE_CONTOUR - Static variable in interface com.aspose.cells.ChartType
Represents Contour Chart.
SURFACE_CONTOUR_WIREFRAME - Static variable in interface com.aspose.cells.ChartType
Represents Wireframe Contour Chart.
SURFACE_WIREFRAME_3D - Static variable in interface com.aspose.cells.ChartType
Represents Wireframe 3D Surface Chart.
SVG - Static variable in interface com.aspose.cells.ImageFormat
Scalable Vector Graphics (SVG)
SVGZ - Static variable in interface com.aspose.cells.ImageFormat
gzip-compressed SVG files
swapSheet(int, int) - Method in class com.aspose.cells.Workbook
Deprecated. Replaced by Worksheets.swapSheet(int,int).
swapSheet(int, int) - Method in class com.aspose.cells.Worksheets
Swaps the positions of two sheets.
SWEDEN - Static variable in interface com.aspose.cells.CountryCode
 

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