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 R S T U V W Y Z

S

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.
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.
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.
SEMIAUTOMATIC - Static variable in interface com.aspose.cells.CalculationMode
automatic except for multiple table operations
SeriesAxis - Class in com.aspose.cells
Encapsulates the object that represents series axis.
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.
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.
setAutomaticStyles(boolean) - Method in class com.aspose.cells.Outline
Sets whether the outline uses automatic styles.
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.
setBackgroundColor(Color) - Method in class com.aspose.cells.Area
Sets the background Color of the Area.
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.
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.
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.
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 .
setBubbleShown(boolean) - Method in class com.aspose.cells.DataLabels
Sets whether the chart's data label Percentage display.
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.
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.
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.
setCharactersWithSpaces(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets an estimate of the number of characters (including spaces) in the excel file.
setColor(Color) - Method in class com.aspose.cells.Font
Sets the font color.
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.
setColor2(Color) - Method in class com.aspose.cells.FillFormat
Sets the gradient color 2 or the pattern foreground color for the the specified fill.
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)
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.
setContent(String) - Method in class com.aspose.cells.TextBox
Sets the content of textbox.
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.
setCrossAt(int) - 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).
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.
setDataDisplayFormat(short) - Method in class com.aspose.cells.PivotField
Sets how to display the values contained in a data field.
setDataSource(ResultSet) - Method in class com.aspose.cells.WorkbookDesigner
Sets data source of a ResultSet object.
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, 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.
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)
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).
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.
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.
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).
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.
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.
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.
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.
setFamily(int) - Method in class com.aspose.cells.Font
 
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.
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.
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.Comment
Sets the font of comment.
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.Legend
Sets a Font object of the chart legend.
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.TextBox
Sets the font of textbox.
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.
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.
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.
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.
setGradientDegree(float) - Method in class com.aspose.cells.FillFormat
Sets the gradient degree for the the specified fill.
setGradientStyle(byte) - Method in class com.aspose.cells.FillFormat
Sets the gradient style for the specified fill.
setGradientVariant(int) - Method in class com.aspose.cells.FillFormat
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.
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
Sets the height, in unit of pixel.
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.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.
setHeightCM(double) - Method in class com.aspose.cells.ChartArea
Sets the height, in unit of centimeters.
setHeightInch(double) - Method in class com.aspose.cells.ChartArea
Sets the height, in unit of inches.
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.
setHorizontalAlignment(boolean) - Method in class com.aspose.cells.StyleFlag
Horizontal alignment setting will be applied.
setHorizontalScrollBarHidden(boolean) - Method in class com.aspose.cells.Workbook
Sets the horizontal scroll bar to be hidden or not.
setIgnoreBlank(boolean) - Method in class com.aspose.cells.Validation
Sets whether blank values are permitted by the range data validation.
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.
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.
setInputMessage(String) - Method in class com.aspose.cells.Validation
Sets the data validation input message.
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.
setItalic(boolean) - Method in class com.aspose.cells.Font
Sets whether the font to be italic or not.
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.
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
Sets the horizontal offset of textbox from its left column, in unit of pixel.
setLeftBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Left border settings will be applied.
setLeftCM(double) - Method in class com.aspose.cells.ChartArea
Sets the horizontal offset of textbox 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
Sets the horizontal offset of textbox from its left column, in unit of inches.
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.
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.
setLines(int) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets an estimate of the number of lines in the document.
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.
setLookinType(byte) - Method in class com.aspose.cells.FindOptions
Sets the lookin type.
setMajorUnit(double) - Method in class com.aspose.cells.ValueAxis
Sets the major units for the value axis.
setManager(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Gets the manager property.
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.
setMarkerForegroundColor(Color) - Method in class com.aspose.cells.ASeries
Represents the marker foregournd color in a line chart, scatter chart, or radar chart.
setMarkerSize(int) - Method in class com.aspose.cells.ASeries
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.
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.
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.
setMinorUnit(double) - Method in class com.aspose.cells.ValueAxis
Sets the minor units for the value axis.
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.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.
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.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(boolean) - Method in class com.aspose.cells.StyleFlag
Number format setting will be applied.
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.
setOrientation(short) - Method in class com.aspose.cells.PageSetup
Sets orientation page print orientation.
setOrientation(int) - Method in class com.aspose.cells.TextBox
Sets text orientation.
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.
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.
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.
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.
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.
setPlacement(byte) - Method in class com.aspose.cells.ChartArea
Sets the way the drawing obejct is attached to the cells below it.
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.
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.
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.
setPrintQuality(int) - Method in class com.aspose.cells.PageSetup
Sets the print quality.
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.
setR1C1Formula(String) - Method in class com.aspose.cells.Cell
Sets a R1C1 formula of the Cell.
setRange(CellArea) - Method in class com.aspose.cells.AutoFilter
Sets cell range of auto filter.
setRangeStyle(int, int, int, int, Style) - Method in class com.aspose.cells.Cells
Sets a style for an area of cells.
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.
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.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.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.
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.
setSelected(boolean) - Method in class com.aspose.cells.PivotTable
Sets whether the PivotTable is selected.Default is false.
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.
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.ChartArea
Sets whether the chart area has a shadow.
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.
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.
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.
setShowLegendKeys(boolean) - Method in class com.aspose.cells.ChartDataTable
Sets whether the data label legend key is visible.
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.
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.
setStandardHeight(float) - Method in class com.aspose.cells.Cells
Sets the default row height of the worksheet, in unit of points.
setStandardWidth(float) - Method in class com.aspose.cells.Cells
Sets the default column width of the worksheet, in unit of characters using default font.
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.
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(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)
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.NamedRange
Sets the name of the range.
setText(String) - Method in class com.aspose.cells.Title
Gets the text of a frame's title.
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.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.DataLabels
Sets the text horizontal alignment.
setTextHorizontalAlignment(int) - Method in class com.aspose.cells.TextBox
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.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.DataLabels
Sets the text vertical alignment of text.
setTextVerticalAlignment(int) - Method in class com.aspose.cells.TextBox
Sets the text vertical alignment of text.
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.
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.
setTitle(String) - Method in class com.aspose.cells.BuiltInDocumentProperties
Sets the title of the document.
setTop(int) - Method in class com.aspose.cells.ChartArea
Sets the vertical offset of textbox from its top row, in unit of pixel.
setTopBorder(boolean) - Method in class com.aspose.cells.StyleFlag
Top border settings will be applied.
setTopCM(double) - Method in class com.aspose.cells.ChartArea
Sets the vertical offset of textbox from its top row, in unit of centimeters.
setTopInch(double) - Method in class com.aspose.cells.ChartArea
Sets the vertical offset of textbox from its top row, in unit of inches.
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.
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).
setType(int) - Method in class com.aspose.cells.ASeries
Sets a data series' type.
setType(int) - Method in class com.aspose.cells.Chart
Sets a chart's type.
setType(int) - Method in class com.aspose.cells.FormatCondition
Sets whether the conditional format is based on a cell value or an expression.If type is changed to FormatConditionType.EXPRESSION, operator type would become OperatorType.NONE and fomula2 would be set null automatically.
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.
setUpperLeftColumn(int) - Method in class com.aspose.cells.ChartArea
Sets the upper left column index.
setUpperLeftRow(int) - Method in class com.aspose.cells.ChartArea
Sets the upper left row index.
setUseDefaultHeight(boolean) - Method in class com.aspose.cells.Row
Sets whether row has default row heigt .
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.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.
setVerticalScrollBarHidden(boolean) - Method in class com.aspose.cells.Workbook
Sets the vertical scroll bar to be 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.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.
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
Sets the width, in unit of pixel.
setWidth(int) - Method in class com.aspose.cells.Legend
Sets the width of frame,in units of 1/4000 of the chart area.
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.
setWidthCM(double) - Method in class com.aspose.cells.ChartArea
Sets the width, in unit of centimeters.
setWidthInch(double) - Method in class com.aspose.cells.ChartArea
Sets the width, in unit of inches.
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.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.
setXValues(String) - Method in class com.aspose.cells.ASeries
Sets the range of x values.
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.
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.
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.
SheetType - Interface in com.aspose.cells
Enumerates worksheet types.
SHINGLE - Static variable in interface com.aspose.cells.FillPatternType
Represents shingle pattern.
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_LINE - Static variable in interface com.aspose.cells.WeightType
Represents the weight of single line.
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.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.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.PivotTables
Gets the number of the PivotTable reports in the worksheet.
size() - Method in class com.aspose.cells.TextBoxes
Gets number of text boxs in the worksheet.
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.
sizeOfConditionList() - Method in class com.aspose.cells.FormatConditions
Gets size of formatting conditions.
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
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.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.
SPHERE - Static variable in interface com.aspose.cells.FillPatternType
Represents sphere pattern.
split() - Method in class com.aspose.cells.Worksheet
Splits window.
SPREADSHEETML - Static variable in interface com.aspose.cells.FileFormatType
Save as an xml spreadsheet file.
SQUARE - Static variable in interface com.aspose.cells.ChartMarkerType
Square markers.
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.
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.
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.
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.
StyleFlag - Class in com.aspose.cells
Represents flags which indicates applied formatting properties.
StyleFlag() - Constructor for class com.aspose.cells.StyleFlag
Constructs an object.
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.
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.

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