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

S

SEMIAUTOMATIC - Static variable in interface com.aspose.cells.CalculationMode
automatic except for multiple table operations
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.
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.
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.
setBorderLine(int, int) - Method in class com.aspose.cells.Style
Sets the border line type of the specified border.
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 .
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.
setCellLocked(boolean) - Method in class com.aspose.cells.Style
Sets whether cells to be locked or not.
setCenterFooter(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the center section footer of an Excel file.
setCenterHeader(String) - Method in class com.aspose.cells.PageSetup
Sets na script formatting the center section header of an Excel 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, int, Font) - Method in class com.aspose.cells.Cell
Performs rich text formatting.
setColor(Color) - Method in class com.aspose.cells.Font
Sets the font color.
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.Style
Sets the cell shading color.
setColumn(int) - Method in class com.aspose.cells.VPageBreak
Sets column index, zero based.
setColumnHidden(int, boolean) - Method in class com.aspose.cells.Worksheet
Sets whether the specified column to be hidden or not.
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.Worksheet
Sets the width of the specified column, in unit of characters using default font.
setCustom(String) - Method in class com.aspose.cells.Style
Sets the custom number format string.
setDefaultColumnWidth(float) - Method in class com.aspose.cells.Worksheet
Sets the default column width of the worksheet, in unit of characters using default font.
setDefaultHeight() - Method in class com.aspose.cells.Row
Invalidate the row height setting.
setDefaultRowHeight(float) - Method in class com.aspose.cells.Worksheet
Sets the default row height of the worksheet, in unit of points.
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.
setDraftQuality(boolean) - Method in class com.aspose.cells.PageSetup
Sets whether the sheet will be printed without graphics.
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.
setEndColumn(int) - Method in class com.aspose.cells.CellArea
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.
setErrorMessage(String) - Method in class com.aspose.cells.Validation
Sets the data validation error message.
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(short) - Method in class com.aspose.cells.PageSetup
Sets the first page number that will be used when this sheet is printed.
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(short) - Method in class com.aspose.cells.PageSetup
Sets the number of pages tall the worksheet will be scaled to when it's printed.
setFitToPagesWide(short) - 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.Style
Sets the font of the style.
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.
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.
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(float) - Method in class com.aspose.cells.Row
Sets the row height, in points.
setHidden(boolean) - Method in class com.aspose.cells.Row
Sets whether the row to be hidden or not.
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.
setIndent(int) - Method in class com.aspose.cells.Style
Sets the indent level.
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.
setItalic(boolean) - Method in class com.aspose.cells.Font
Sets whether the font to be italic or not.
setLeftFooter(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the left section footer of an Excel file.
setLeftHeader(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the left section header of an Excel file.
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.
setLicense(InputStream) - Method in class com.aspose.cells.License
Licenses the component.
setName(String) - Method in class com.aspose.cells.Font
Sets the font name.
setName(String) - Method in class com.aspose.cells.Style
Sets the name of the style.
setName(String) - Method in class com.aspose.cells.Worksheet
Sets the worksheet name.
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.
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.
setOrientation(short) - Method in class com.aspose.cells.PageSetup
Sets orientation page print orientation.
setPageBreakPreview(boolean) - Method in class com.aspose.cells.Worksheet
Sets the specified worksheet is shown in normal view or page break preview.
setPageOrder(short) - Method in class com.aspose.cells.PageSetup
Sets the order that Microsoft Excel uses to number pages when printing a large worksheet.
setPaperSize(short) - Method in class com.aspose.cells.PageSetup
Sets the size of the paper.
setPassword(String) - Method in class com.aspose.cells.Protection
Sets the password to protect the worksheet.
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.
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(short) - 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.
setRed(int) - Method in class com.aspose.cells.Color
Sets the red component value.
setRightFooter(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the right section footer of an Excel file.
setRightHeader(String) - Method in class com.aspose.cells.PageSetup
Sets a script formatting the right section header of an Excel 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.Style
Sets the rotation degrees.
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.
setScreenTip(String) - Method in class com.aspose.cells.Hyperlink
Sets screen tip of the hyperlink.
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.
setSheetTabBarHidden(boolean) - Method in class com.aspose.cells.Workbook
Sets the sheet tab bar to be hidden or not.
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.
setShrinked(boolean) - Method in class com.aspose.cells.Style
Sets whether the text should be shrunk to fit or not.
setSize(int) - Method in class com.aspose.cells.Font
Sets the font size.
setSortingAllowed(boolean) - Method in class com.aspose.cells.Protection
Sets if the sorting option is allowed on a protected worksheet.
setStartColumn(int) - Method in class com.aspose.cells.CellArea
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.
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.FormatCondition
Sets style of conditional formatted cell range.
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, int, int, int, Style) - Method in class com.aspose.cells.Worksheet
Sets a style for an area of cells.
setTabColor(Color) - Method in class com.aspose.cells.Worksheet
Sets the colour of the tab below the sheet containing the sheet name.
setTextDirection(int) - Method in class com.aspose.cells.Style
Sets the text direction type.
setTextToDisplay(String) - Method in class com.aspose.cells.Hyperlink
Sets text to be displayed for the hyperlink.
setTextWrapped(boolean) - Method in class com.aspose.cells.Style
Sets whether the text should be wrapped.
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.
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.
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(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.
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.Worksheet
Sets whether the worksheet to be visible or not.
setZoom(short) - Method in class com.aspose.cells.PageSetup
Sets the scaling factor in percent.
setZoom(short) - Method in class com.aspose.cells.Worksheet
Sets the scaling factor in percent.
SheetType - Interface in com.aspose.cells
Enumerates worksheet types.
SILVER - Static variable in class com.aspose.cells.Color
The color silver.
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.Validations
Gets number of the Validation objects.
size() - Method in class com.aspose.cells.VPageBreaks
Gets number of the VPageBreak objects.
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.
SOLID - Static variable in interface com.aspose.cells.PatternType
Represents solid pattern.
split() - Method in class com.aspose.cells.Worksheet
Splits window.
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.
Style - Class in com.aspose.cells
Represents display styles of Excel spreadsheets.
swapSheet(int, int) - Method in class com.aspose.cells.Workbook
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