- Scatter - Static variable in class com.smartxls.ChartShape
-
- SeriesScale - Static variable in class com.smartxls.ChartShape
-
- set3DBevel(int, int, int, int) - Method in class com.smartxls.ChartShape
-
- set3DClustered(boolean) - Method in class com.smartxls.ChartShape
-
- set3Dimensional(boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the chart is 3 dimensional or not.
- set3DRotX(int) - Method in class com.smartxls.ChartShape
-
- set3DRotY(int) - Method in class com.smartxls.ChartShape
-
- set3DViewAngle(boolean, int) - Method in class com.smartxls.ChartShape
-
- setActiveCell(int, int) - Method in class com.smartxls.WorkBook
-
Sets the row and column coordinates of the active cell.
- setAllowBlank(boolean) - Method in class com.smartxls.DataValidation
-
set whether the data validation allows the use of empty or blank entries
- setAltText(String) - Method in interface com.smartxls.Table
-
- setApplicationName(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the application name
- setArrayFormula(int, int, int, int, String) - Method in class com.smartxls.WorkBook
-
Sets the array formula for the specified range.
- setAspectRatioLocked(boolean) - Method in class com.smartxls.PictureShape
-
- setAuthor(String) - Method in class com.smartxls.CommentShape
-
set author of the comment
- setAuthor(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the author name
- setAuthor(String) - Method in class com.smartxls.TextboxShape
-
set author of the comment
- setAutoLayoutDirection(boolean) - Method in class com.smartxls.ShapeObj
-
- setAutoMaximumScale(short, int, boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the upper limit of the scale of the specified axis is automatically calculated.
- setAutoMinimumScale(short, int, boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the lower limit of the scale of the selected axis is automatically calculated.
- setAutoRecalc(boolean) - Method in class com.smartxls.WorkBook
-
enable/disable auto recalc flag
- setAxisAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
-
set the axis type whether based on the value or not,the axis type is one of auto,text,date
- setAxisFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets formatting for the specified axis.
- setAxisLengthRatio(int) - Method in class com.smartxls.ChartShape
-
Sets the ratio of the area taken up on the selected axis.
- setAxisLengthRatio(short, int, int) - Method in class com.smartxls.ChartShape
-
Sets the ratio of the area taken up on the specified axis.
- setAxisScaleCrosses(short, int, boolean, double) - Method in class com.smartxls.ChartShape
-
Sets the crosses value for the specified axis.
- setAxisScaleCrossMax(short, int, boolean) - Method in class com.smartxls.ChartShape
-
set the axis scale to cross max
- setAxisScaleCrossMin(short, int, boolean) - Method in class com.smartxls.ChartShape
-
set the axis scale to cross min
- setAxisScaleLabelUnit(short, int, int) - Method in class com.smartxls.ChartShape
-
set the label unit of the axis scale
- setAxisScaleReversed(short, int, boolean) - Method in class com.smartxls.ChartShape
-
set the axis scale to be reversed
- setAxisScaleTick(short, int, int) - Method in class com.smartxls.ChartShape
-
set the tick of the axis scale
- setAxisScaleType(short) - Method in class com.smartxls.ChartShape
-
Sets the axis scale type for the selected axis.
- setAxisScaleType(short, int, short) - Method in class com.smartxls.ChartShape
-
Sets the axis scale type for the specified axis.
- setAxisTitle(short, int, String) - Method in class com.smartxls.ChartShape
-
Sets the title of the specified axis.
- setAxisTitleFormat(short, int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets the formatting for the title of the specified axis.
- setAxisVisible(boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the selected axis is visible.
- setAxisVisible(short, int, boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the specified axis is visible.
- setBackColor(int) - Method in class com.smartxls.ChartFormat
-
Sets the color used to display the pattern background.
- setBarGapRatio(int) - Method in class com.smartxls.ChartShape
-
Sets the bar gap ratio on a bar or column chart.
- setBookProtection(boolean, int, String) - Method in class com.smartxls.WorkBook
-
Sets whether protection is enabled for this workbook.
- setBottomBorder(short) - Method in class com.smartxls.RangeStyle
-
Sets the style for the bottom border.
- setBottomBorderColor(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the bottom edge of the cell.
- setByteCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the byte count
- setCalcOnSave(boolean) - Method in class com.smartxls.WorkBook
-
sheet calculated on save setting
- setCategory(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the category name
- setCategoryFormula(String) - Method in class com.smartxls.ChartShape
-
Links the chart categories to the specified formula.
- setCategoryScaleCrossBetween(boolean) - Method in class com.smartxls.ChartShape
-
set the category scale to cross between
- setCellLink(String) - Method in class com.smartxls.FormControlShape
-
set the link cell of the control
- setCellRange(String) - Method in class com.smartxls.FormControlShape
-
set the source range link to the control
- setCharCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the char count
- setChartFormat(ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets chart formatting.
- setChartType(short) - Method in class com.smartxls.ChartShape
-
A constant designating a chart type.
- setCheckState(int) - Method in class com.smartxls.FormControlShape
-
set the check box check state
0-uncheck 1-check 2-mixed
- setCol(short) - Method in class com.smartxls.CommentShape
-
set column of the commented cell.
- setCol(short) - Method in class com.smartxls.TextboxShape
-
set column of the commented cell.
- setCol1(int) - Method in class com.smartxls.RangeArea
-
set the start column
- setCol2(int) - Method in class com.smartxls.RangeArea
-
set the end col
- setColHidden(int, boolean) - Method in class com.smartxls.WorkBook
-
Sets a flag indicating whether or not the specified column is hidden.
- setColorScale(int, Color[]) - Method in class com.smartxls.ConditionFormat
-
Sets the colorscale's type of this conditional format.
- setColOutlineLevel(int, int, int, boolean) - Method in class com.smartxls.WorkBook
-
Sets the outline level of a range of columns.
- setColumnTotalsFunc(String, int) - Method in interface com.smartxls.Table
-
- setColWidth(int, int) - Method in class com.smartxls.WorkBook
-
Sets the width of a single column.
- setColWidthAutoSize(int, boolean) - Method in class com.smartxls.WorkBook
-
Sets the widths of the specified columns to automatically adjust to the largest column entry.
- setColWidthAutoSize(int, int, int, int, boolean) - Method in class com.smartxls.WorkBook
-
Sets the widths of the specified columns to automatically
- setCombSelIndex(int) - Method in class com.smartxls.FormControlShape
-
set the combox select index
- setComments(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the comments
- setCompact(boolean) - Method in class com.smartxls.BookPivotRange
-
the compact flag is set if true
- setCompany(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the company name
- setConditionalFormat(ConditionFormat, int, int) - Method in class com.smartxls.BookPivotRange
-
apply the conditional formatting to the pivot table
- setConditionalFormats(ConditionFormat[]) - Method in class com.smartxls.WorkBook
-
Sets the specified conditional formats for the current selection.
- setCreationDate(Date) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the creation date
- setCSVSeparator(char) - Method in class com.smartxls.WorkBook
-
set the csv to use the specified char
- setCSVString(String) - Method in class com.smartxls.WorkBook
-
- setCustomFormat(String) - Method in class com.smartxls.ChartFormat
-
Sets the number format string
- setCustomFormat(String) - Method in class com.smartxls.RangeStyle
-
Sets the number format string.
- setDataCaption(String) - Method in class com.smartxls.BookPivotRange
-
set the data caption
- setDataLabelFormat(int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets data label formatting for the specified series.
- setDataLabelFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets data label formatting for the specified data point.
- setDataLabelPosition(short) - Method in class com.smartxls.ChartFormat
-
Sets position of the data label.
- setDataLabelSeparator(String) - Method in class com.smartxls.ChartFormat
-
Sets the data label separator.
- setDataLabelText(int, int, String, boolean) - Method in class com.smartxls.ChartShape
-
Sets data label text for the specified data point.
- setDataLabelType(short) - Method in class com.smartxls.ChartFormat
-
Sets the type of data label to use.
- setDataLabelTypes(int) - Method in class com.smartxls.ChartFormat
-
Sets the types of data label to use.
- setDataLableType(int) - Method in class com.smartxls.ChartShape
-
Sets the type of data label to use
- setDataOnRow(boolean) - Method in class com.smartxls.BookPivotRange
-
set the data field in the column area if flag is false.
- setDataPointFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets formatting for the specified data point.
- setDataQuery(SXQuery) - Method in class com.smartxls.BookPivotRangeModel
-
- setDataValidation(DataValidation) - Method in class com.smartxls.WorkBook
-
Sets the specified data validations for the current selection.
- setDataValidationForCell(int, int, DataValidation) - Method in class com.smartxls.WorkBook
-
- setDefaultColWidth(int) - Method in class com.smartxls.WorkBook
-
Sets the default column width of worksheet.
- setDefaultFontName(String) - Method in class com.smartxls.WorkBook
-
set the default font name
- setDefaultRowHeight(int) - Method in class com.smartxls.WorkBook
-
Sets the default row height of whole worksheet.
- setDefinedName(String, String) - Method in class com.smartxls.WorkBook
-
Sets the formula associated with a defined name
- setDiagBorderAndColor(boolean, boolean, short, int) - Method in class com.smartxls.RangeStyle
-
- setDisplayName(String) - Method in interface com.smartxls.Table
-
- setDocPropParsing(boolean) - Method in class com.smartxls.WorkBook
-
set this flag will allow to parse the document property,default not parsing
- setDropLinesFormat(ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets drop line formatting.
- setDropLinesVisible(boolean) - Method in class com.smartxls.ChartShape
-
Sets whether drop lines are visible.
- setEnableProtection(boolean) - Method in class com.smartxls.WorkBook
-
enable/disable protection for current selected sheet.
- setEntry(int, int, String) - Method in class com.smartxls.WorkBook
-
Sets the value to the specified cell of current selected worksheets.
- setEntry(int, int, int, String) - Method in class com.smartxls.WorkBook
-
Sets the value of a specified cell on the specified worksheet.
- setErrorBars(int, boolean, int, boolean, String) - Method in class com.smartxls.ChartShape
-
set the errorbar informations
- setErrorBars(int, boolean, int, boolean, int, int) - Method in class com.smartxls.ChartShape
-
set the errorbar informations
- setErrorBoxText(String) - Method in class com.smartxls.DataValidation
-
set dv's error box text
- setErrorBoxTitle(String) - Method in class com.smartxls.DataValidation
-
the dv's error box title
- setErrorCaption(boolean, String) - Method in class com.smartxls.BookPivotRange
-
set the error caption
- setErrorStyle(int) - Method in class com.smartxls.DataValidation
-
- setExplosion(int) - Method in class com.smartxls.ChartShape
-
Sets the explosion percentage.
- seText(String) - Method in class com.smartxls.CommentShape
-
set the text content of the comment
- seText(String) - Method in class com.smartxls.TextboxShape
-
set the text content of the comment
- setFieldItemHidden(int, boolean) - Method in class com.smartxls.BookPivotField
-
set the field item hidden or shown
- setFileShareProtection(String) - Method in class com.smartxls.WorkBook
-
Set the workbook file to readonly with password
- setFill(int) - Method in class com.smartxls.ShapeFormat
-
set the fill color
- setFillAlpha(double) - Method in class com.smartxls.ChartFormat
-
specifies the input color with the specific opacity.
- setFillAuto(boolean) - Method in class com.smartxls.ChartFormat
-
Sets whether fill is auto.
- setFillPicture(String) - Method in class com.smartxls.ChartFormat
-
- setFillShadow(boolean) - Method in class com.smartxls.ChartFormat
-
Sets whether an object includes a shadow behind it.
- setFillTexture(ExcelTexture) - Method in class com.smartxls.ChartFormat
-
- setFillVisible(boolean) - Method in class com.smartxls.ChartFormat
-
set the visibility for this fill property
- setFontAutoScale(boolean) - Method in class com.smartxls.ChartFormat
-
Sets whether fonts are automatically scaled based on chart size.
- setFontBold(boolean) - Method in class com.smartxls.ChartFormat
-
Sets the bold attribute of the font.
- setFontBold(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the bold attribute of the font.
- setFontCharSet(int) - Method in class com.smartxls.RangeStyle
-
Sets the font charset.
- setFontColor(int) - Method in class com.smartxls.ChartFormat
-
Sets the color used to display the font.
- setFontColor(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the font.
- setFontItalic(boolean) - Method in class com.smartxls.ChartFormat
-
Sets the italic attribute of the font.
- setFontItalic(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the italic attribute of the font.
- setFontName(String) - Method in class com.smartxls.ChartFormat
-
Sets the font name.
- setFontName(String) - Method in class com.smartxls.RangeStyle
-
Sets the font name.
- setFontOutline(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the Outline attribute of the font.
- setFontShadow(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the Shadow attribute of the font.
- setFontSize(int) - Method in class com.smartxls.ChartFormat
-
Sets the font size in twips.
- setFontSize(int) - Method in class com.smartxls.RangeStyle
-
Sets the font size in twips.
- setFontSizeInPoints(double) - Method in class com.smartxls.ChartFormat
-
set the font size
- setFontStrikeout(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the strikeout attribute of the font.
- setFontSubscript(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the Subscript attribute of the font.
- setFontSuperscript(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the Subscript attribute of the font.
- setFontUnderline(boolean) - Method in class com.smartxls.ChartFormat
-
Sets the underline attribute of the font.
- setFontUnderline(short) - Method in class com.smartxls.RangeStyle
-
Sets the underline attribute of the font.
- setForeColor(int) - Method in class com.smartxls.ChartFormat
-
Sets the color used to display the pattern foreground.
- setFormat(ShapeFormat) - Method in class com.smartxls.ShapeObj
-
Sets the Format for this shape.
- setFormula(int, int, String) - Method in class com.smartxls.WorkBook
-
Sets the formula for the specified cell in current selected sheets.
- setFormula(int, int, int, String) - Method in class com.smartxls.WorkBook
-
Sets the formula for the specified cell on the specified sheet.
- setFormula1(String, int, int) - Method in class com.smartxls.ConditionFormat
-
Sets the first formula associated with this conditional format
- setFormula1(String) - Method in class com.smartxls.DataValidation
-
set the first formula
- setFormula2(String, int, int) - Method in class com.smartxls.ConditionFormat
-
Sets the second formula associated with this conditional format
- setFormula2(String) - Method in class com.smartxls.DataValidation
-
set the second formula
- setGapWidthRatio(int) - Method in class com.smartxls.ChartShape
-
Sets the gap width ratio.
- setGradient() - Method in class com.smartxls.ChartFormat
-
Sets the fill to Gradient.
- setGradient(ExcelGradientStyle) - Method in class com.smartxls.ChartFormat
-
- setGradientTwoColor(int, int, int, int) - Method in class com.smartxls.RangeStyle
-
Sets the gradient fill with two colors.
- setGroup(String) - Method in class com.smartxls.WorkBook
-
group name
- setHidden(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the hiden cell flag
- setHiddenCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the hidden count
- setHorizontalAlignment(short) - Method in class com.smartxls.RangeStyle
-
Sets the horizontal alignment.
- setHorizontalInsideBorder(short) - Method in class com.smartxls.RangeStyle
-
Sets the horizontal inside border style.
- setHorizontalInsideBorderColor(int) - Method in class com.smartxls.RangeStyle
-
Sets the color of the horizontal inside border.
- setIgnoreEmptyCellsInParsing(boolean) - Method in class com.smartxls.WorkBook
-
ignore empty cells when load xlsx file
- setIndent(int) - Method in class com.smartxls.RangeStyle
-
Set the indent attribute
- setIndex(int) - Method in interface com.smartxls.Table
-
- setInGridZone(boolean) - Method in class com.smartxls.BookPivotRange
-
the grid zone is set if true
- setInlineCellTextMode(boolean) - Method in class com.smartxls.WorkBook
-
enable the xlsx/xlsm file writing in the inlinestr cell text mode
- setIterationEnabled(boolean) - Method in class com.smartxls.WorkBook
-
Sets whether iteration is enabled.
- setIterationMax(int) - Method in class com.smartxls.WorkBook
-
Sets the maximum number of iterations.
- setIterationMaxChange(double) - Method in class com.smartxls.WorkBook
-
Sets the maximum iteration change value.
- setKeywords(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the key words
- setLastAuthor(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the last author name
- setLastPrinted(Date) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the last printed date
- setLastSaveDate(Date) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the last saved date
- setLayout(boolean, boolean, boolean) - Method in class com.smartxls.BookPivotField
-
set the pivot field lay out setting
- setLeftBorder(short) - Method in class com.smartxls.RangeStyle
-
Sets the style for the left border.
- setLeftBorderColor(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the left edge of the cell.
- setLegendFormat(ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets legend formatting.
- setLegendPosition(short) - Method in class com.smartxls.ChartShape
-
set legend position
- setLegendVisible(boolean) - Method in class com.smartxls.ChartShape
-
Sets whether legend is visible.
- setLineAuto() - Method in class com.smartxls.ChartFormat
-
set line auto
- setLineColor(int) - Method in class com.smartxls.ChartFormat
-
Sets the color.
- setLineCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the line count
- setLineCustom() - Method in class com.smartxls.ChartFormat
-
set line custom style and weight
- setLineNone() - Method in class com.smartxls.ChartFormat
-
set line none
- setLineShadow(boolean) - Method in class com.smartxls.ChartFormat
-
set the line shadow.
- setLineStyle(short) - Method in class com.smartxls.ChartFormat
-
Sets the style.
- setLineWeight(int) - Method in class com.smartxls.ChartFormat
-
Sets the weight.
- setLinkedToDataSource(boolean) - Method in class com.smartxls.ChartFormat
-
Sets whether the object gets the value format from the data source.
- setLinkRange(String, boolean) - Method in class com.smartxls.ChartShape
-
Links the chart to the range in the workbook represented by the specified formula.
- setLinkShowString(String) - Method in class com.smartxls.HyperLink
-
set the hyperlink's link show string
- setLinkURLString(String) - Method in class com.smartxls.HyperLink
-
set the hyperlink's link URL string
- setList(String) - Method in class com.smartxls.BookPivotRangeModel
-
- setListSelection(int, boolean[]) - Method in class com.smartxls.FormControlShape
-
set the listbox selection type and selected index
- setLocation(int, int, int) - Method in class com.smartxls.BookPivotRangeModel
-
- setLocked(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the locked cell flag
- setLogScale(boolean) - Method in class com.smartxls.ChartShape
-
Sets the axis to logarithmic base.
- setLogScale(int, int, boolean) - Method in class com.smartxls.ChartShape
-
Sets the axis to logarithmic base.
- setMajorGridFormat(short, int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets grid line formatting information for the major grid of the specified axis.
- setMajorGridVisible(boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the major grid lines of the selected axis are visible.
- setMajorGridVisible(short, int, boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the major grid lines of the specified axis are visible.
- setManager(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the manager name
- setMarkerAuto(boolean) - Method in class com.smartxls.ChartFormat
-
Sets the marker type to be assigned automatically.
- setMarkerBackground(int) - Method in class com.smartxls.ChartFormat
-
Sets marker background color as an RGB value.
- setMarkerForeground(int) - Method in class com.smartxls.ChartFormat
-
Sets marker foreground color as an RGB value.
- setMarkerSize(int) - Method in class com.smartxls.ChartFormat
-
Sets marker size in twips.
- setMarkerStyle(short) - Method in class com.smartxls.ChartFormat
-
Sets marker style.
- setMergeCells(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the mergeCells attribute.
- setMinorGridFormat(short, int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets grid line formatting information for the minor grid of the specified axis.
- setMinorGridVisible(boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the minor grid lines of the selected axis are visible.
- setMinorGridVisible(short, int, boolean) - Method in class com.smartxls.ChartShape
-
Sets whether the minor grid lines of the specified axis are visible.
- setMissingCaption(boolean, String) - Method in class com.smartxls.BookPivotRange
-
set the caption for the null values
- setName(String) - Method in class com.smartxls.ShapeObj
-
set the shape name
- setName(String) - Method in interface com.smartxls.Table
-
- setNumber(int, int, double) - Method in class com.smartxls.WorkBook
-
Sets the numeric value of the specified cell in current selected sheet.
- setNumber(String, double) - Method in class com.smartxls.WorkBook
-
Sets the numeric value of the specified cell in current selected sheet.
- setNumber(int, int, int, double) - Method in class com.smartxls.WorkBook
-
Sets the numeric value of the specified cell in the specified worksheet.
- setNumberFormatting(String) - Method in class com.smartxls.BookPivotField
-
set the custom formatting for area in pivot table
- setNumSheets(int) - Method in class com.smartxls.WorkBook
-
Sets the number of worksheets in the current workbook.
- setOperator(short) - Method in class com.smartxls.ConditionFormat
-
Sets the operator for this conditional format.
- setOperator(int) - Method in class com.smartxls.DataValidation
-
set the dv operator
between
DataValidation.eBetween
notbetween equal notequal greater less greaterorequal lessorequal
- setOrientation(int) - Method in class com.smartxls.ChartFormat
-
set the orientation
- setOrientation(short) - Method in class com.smartxls.RangeStyle
-
Sets the orientation type.
- setPaletteEntry(int, int, int, int) - Method in class com.smartxls.WorkBook
-
Sets a color in the workbook color palette using decimal values.
- setPattern(int) - Method in class com.smartxls.ChartFormat
-
Sets the pattern.
- setPattern(short) - Method in class com.smartxls.RangeStyle
-
Sets the pattern type.
- setPatternBG(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the pattern background.
- setPatternFG(int) - Method in class com.smartxls.ChartFormat
-
set the fg color in RGB
- setPatternFG(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the pattern foreground.
- setPercent(boolean) - Method in class com.smartxls.ChartShape
-
Sets boolean indicating whether the values in the chart are plotted as percentages of the category.
- setPieExplosion(int, int) - Method in class com.smartxls.ChartShape
-
Sets the explosion percentage of the specified data point.
- setPivotSource(BookPivotRange) - Method in class com.smartxls.ChartShape
-
link the chart to pivot range
- setPlacementStyle(int) - Method in class com.smartxls.ShapeFormat
-
- setPlotFormat(ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets plot formatting.
- setPlotGroupStack(int, boolean) - Method in class com.smartxls.ChartShape
-
Sets the selected PlotGroup to display stacked series.
- setPlotStacked(boolean) - Method in class com.smartxls.ChartShape
-
Sets the selected plot to display stacked series.
- setPlotVisibleDataOnly(boolean) - Method in class com.smartxls.ChartShape
-
Sets whether to display the hidden data.
- setPosition(double, double, double, double) - Method in class com.smartxls.ShapeObj
-
set the shape position
- setPrintArea(String) - Method in class com.smartxls.WorkBook
-
Sets the current print area to the specified range
- setPrintAutoPageNumbering(boolean) - Method in class com.smartxls.WorkBook
-
Turns on/off auto page numbering.
- setPrintBottomMargin(double) - Method in class com.smartxls.WorkBook
-
Sets the bottom print margin.
- setPrintFooter(String) - Method in class com.smartxls.WorkBook
-
Sets the current page footer.
- setPrintFooterMargin(double) - Method in class com.smartxls.WorkBook
-
Sets the page footer margin
- setPrintGridLines(boolean) - Method in class com.smartxls.WorkBook
-
Sets a flag indicating whether grid lines are printed for the current sheet.
- setPrintHCenter(boolean) - Method in class com.smartxls.WorkBook
-
Sets a flag indicating whether the current sheet is centered horizontally when printed.
- setPrintHeader(String) - Method in class com.smartxls.WorkBook
-
Sets the page header printed at the top of each page.
- setPrintHeaderMargin(double) - Method in class com.smartxls.WorkBook
-
Sets the page header margin .
- setPrintHFAlignMargin(boolean) - Method in class com.smartxls.WorkBook
-
- setPrintHFScaleDoc(boolean) - Method in class com.smartxls.WorkBook
-
- setPrintLandscape(boolean) - Method in class com.smartxls.WorkBook
-
set the orientation of the print job.
- setPrintLeftMargin(double) - Method in class com.smartxls.WorkBook
-
Sets the left print margin.
- setPrintLeftToRight(boolean) - Method in class com.smartxls.WorkBook
-
Sets a flag determining whether the current sheet is printed left to right then top to bottom, or top to bottom then left to right.
- setPrintNoColor(boolean) - Method in class com.smartxls.WorkBook
-
set print job printed in color black and white.
- setPrintNumberOfCopies(int) - Method in class com.smartxls.WorkBook
-
Sets the number copies to print.
- setPrintPaperSize(short) - Method in class com.smartxls.WorkBook
-
Sets paper size print setting value.
- setPrintPaperSize(int, int) - Method in class com.smartxls.WorkBook
-
Sets the size of the paper in twips (1/20th of a point)
- setPrintRightMargin(double) - Method in class com.smartxls.WorkBook
-
Sets the right print margin in inches.
- setPrintRowColHeading(boolean) - Method in class com.smartxls.WorkBook
-
Sets a flag that determines whether or not row/col headings are printed for the current sheet.
- setPrintScale(int) - Method in class com.smartxls.WorkBook
-
Sets the scale factor for the current worksheet.
- setPrintScaleFitHPages(int) - Method in class com.smartxls.WorkBook
-
Sets the number of horizontal pages to which the print job is fit.
- setPrintScaleFitToPage(boolean) - Method in class com.smartxls.WorkBook
-
Sets whether pages are scaled to fit the specified number of pages when printed.
- setPrintScaleFitVPages(int) - Method in class com.smartxls.WorkBook
-
Sets the number of vertical pages to which the print job is fit.
- setPrintStartPageNumber(int) - Method in class com.smartxls.WorkBook
-
Sets the starting page to print.
- setPrintTitles(String) - Method in class com.smartxls.WorkBook
-
Sets the print titles to be printed at the top of each page
- setPrintTopMargin(double) - Method in class com.smartxls.WorkBook
-
Sets the top print margin.
- setPrintVCenter(boolean) - Method in class com.smartxls.WorkBook
-
Sets a flag indicating whether the current sheet is centered vertically when printed.
- setPromtBoxText(String) - Method in class com.smartxls.DataValidation
-
set the dv's promt box text
- setPromtBoxTitle(String) - Method in class com.smartxls.DataValidation
-
set the title of the dv's promt box
- setPropertyValue(String, Object) - Method in interface com.smartxls.DocumentCustomProperties
-
set the property
- setRange(int, int, int, int) - Method in class com.smartxls.HyperLink
-
set the hyperlink range
- setRangeStyle(RangeStyle) - Method in class com.smartxls.ConditionFormat
-
Sets formatting options for this conditional format from the specified RangeStyle object.
- setRangeStyle(RangeStyle) - Method in class com.smartxls.WorkBook
-
Sets the RangeStyle of the selected range of cells.
- setRangeStyle(RangeStyle, int, int, int, int) - Method in class com.smartxls.WorkBook
-
Sets the RangeStyle of the selected range of cells.
- setRightBorder(short) - Method in class com.smartxls.RangeStyle
-
Sets the style for the right border.
- setRightBorderColor(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the right edge of the cell.
- setRow(short) - Method in class com.smartxls.CommentShape
-
set row of the commented cell
- setRow(short) - Method in class com.smartxls.TextboxShape
-
set row of the commented cell
- setRow1(int) - Method in class com.smartxls.RangeArea
-
set the start row
- setRow2(int) - Method in class com.smartxls.RangeArea
-
set the end row
- setRowHeight(int, int) - Method in class com.smartxls.WorkBook
-
Sets the height of a single specified row.
- setRowHeightAutoSize(int, boolean) - Method in class com.smartxls.WorkBook
-
Specifies that the height of the specified row is automatically set to display the tallest entry in the row.
- setRowHidden(int, boolean) - Method in class com.smartxls.WorkBook
-
Sets the display status of the specified row.
- setRowOutlineLevel(int, int, int, boolean) - Method in class com.smartxls.WorkBook
-
Sets the outline level of a range of rows.
- setRowStripes(boolean) - Method in interface com.smartxls.Table
-
- setScaleMajorUnit(short, int, double) - Method in class com.smartxls.ChartShape
-
set the major scale unit of the selected axis.
- setScaleMajorUnitAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
-
set the major unit of the scale to auto
- setScaleMinorUnit(short, int, double) - Method in class com.smartxls.ChartShape
-
set the minor scale unit of the selected axis.
- setScaleMinorUnitAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
-
set the minor unit of the scale to auto
- setScaleValueRange(short, int, double, double) - Method in class com.smartxls.ChartShape
-
Sets the minimum and maximum range of the selected axis.
- setSelection(int, int, int, int) - Method in class com.smartxls.WorkBook
-
Selects the specified range and moves the active cell to the top left cell in the range.
- setSelection(String) - Method in class com.smartxls.WorkBook
-
Selects the range represented by the formula.
- setSeriesFormat(int, ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets the format of the specified series.
- setSeriesName(int, String) - Method in class com.smartxls.ChartShape
-
Sets the name of the specified series.
- setSeriesPicFormat(int, int) - Method in class com.smartxls.ChartShape
-
Sets the picture/texture fill options of the specified series.
- setSeriesSizeValueFormula(int, String) - Method in class com.smartxls.ChartShape
-
Sets the size value formula of the specified series.
- setSeriesSmoothedLine(int) - Method in class com.smartxls.ChartShape
-
set the series smooth line
- setSeriesSmoothedLine(int, boolean) - Method in class com.smartxls.ChartShape
-
set the series to use smothed line
- setSeriesType(short) - Method in class com.smartxls.ChartShape
-
Sets the series type of the selected series.
- setSeriesType(int, short) - Method in class com.smartxls.ChartShape
-
Sets the series type of the specified series.
- setSeriesXValueFormula(int, String) - Method in class com.smartxls.ChartShape
-
Sets the X axis value formula of the specified series.
- setSeriesYAxisIndex(int, int) - Method in class com.smartxls.ChartShape
-
Sets the index of the Y axis that the specified series is plotted on.
- setSeriesYValueFormula(int, String) - Method in class com.smartxls.ChartShape
-
Returns the Y axis value formula of the specified series.
- setSheet(int) - Method in class com.smartxls.RangeArea
-
set the sheet index
- setSheet(int) - Method in class com.smartxls.WorkBook
-
Selects a worksheet
- setSheetHidden(int) - Method in class com.smartxls.WorkBook
-
Sets the hidden state for the current selected sheet.
- setSheetName(int, String) - Method in class com.smartxls.WorkBook
-
Assigns a name to the specified worksheet.
- setSheetProtected(int, boolean, String) - Method in class com.smartxls.WorkBook
-
Sets whether protection is enabled for the specified sheet.
- setSheetProtected(int, int, String) - Method in class com.smartxls.WorkBook
-
Sets whether protection is enabled for the specified sheet.
- setSheetRightToLeft(boolean) - Method in class com.smartxls.WorkBook
-
sheet right to left setting
- setSheetTabColor(Color) - Method in class com.smartxls.WorkBook
-
set the color to the sheet tab
- setSheetViewType(int) - Method in class com.smartxls.WorkBook
-
Sets the sheet view type..
- setShowColGrandTotal(boolean) - Method in class com.smartxls.BookPivotRange
-
set the col grand total is shown if true
- setShowDataAs(ShowDataAs) - Method in class com.smartxls.BookPivotField
-
set the ShowDataAs value for the summary field
- setShowDetail(boolean) - Method in class com.smartxls.BookPivotField
-
set whether the details are hidden for this field
- setShowDrill(boolean) - Method in class com.smartxls.BookPivotRange
-
the drill flag is set if true
- setShowDropDown(boolean) - Method in class com.smartxls.DataValidation
-
- setShowErrorMessage(boolean) - Method in class com.smartxls.DataValidation
-
- setShowGridLines(boolean) - Method in class com.smartxls.WorkBook
-
Sets whether grid lines are displayed.
- setShowHeader(boolean) - Method in class com.smartxls.BookPivotRange
-
header is shown if true
- setShowHScrollBar(short) - Method in class com.smartxls.WorkBook
-
Sets the mode for the horizontal scroll bar.
- setShowInputMessage(boolean) - Method in class com.smartxls.DataValidation
-
- setShowOutlines(boolean) - Method in class com.smartxls.WorkBook
-
set whether the outline shown or not
- setShowRowColHeader(boolean) - Method in class com.smartxls.WorkBook
-
Sets whether row/col headers are displayed.
- setShowRowGrandTotal(boolean) - Method in class com.smartxls.BookPivotRange
-
set the row grand total is shown if true
- setShowTabs(short) - Method in class com.smartxls.WorkBook
-
Sets the visibility or position of the sheet name tabs on a workbook.
- setShowVScrollBar(short) - Method in class com.smartxls.WorkBook
-
Sets the mode for the vertical scroll bar.
- setShowZeroValues(boolean) - Method in class com.smartxls.WorkBook
-
Sets whether zero value cells are displayed.
- setShrinkToFit(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the ShrinkToFit attribute.
- setSizeEMUs(long, long) - Method in class com.smartxls.PictureShape
-
- setSizePixels(int, int) - Method in class com.smartxls.PictureShape
-
- setSolid() - Method in class com.smartxls.ChartFormat
-
Sets the fill to solid.
- setSortType(int) - Method in class com.smartxls.BookPivotField
-
set the sort type
- setStartAngle(int) - Method in class com.smartxls.ChartShape
-
set the start angle of the 3D chart
- setSubject(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the subject
- setSubTotalType(int) - Method in class com.smartxls.BookPivotField
-
set the type of subtotal
- setSummarizeFieldCalcType(int, String) - Method in class com.smartxls.BookPivotField
-
Set the current calculation type of the summary field
- setSummaryColsBeforeDetail(boolean) - Method in class com.smartxls.WorkBook
-
Sets whether col outline summaries come before col detail information.
- setSummaryRowsBeforeDetail(boolean) - Method in class com.smartxls.WorkBook
-
Sets whether row outline summaries come before row detail information.
- setTabbedText(int, int, boolean, String) - Method in class com.smartxls.WorkBook
-
set tab-delimited text in workbook
- setTableBuiltInStyles(TableBuiltInStyles) - Method in interface com.smartxls.Table
-
- setTableCustomStyle(String) - Method in class com.smartxls.BookPivotRange
-
apply the custom table style to the pivot table,the style must be exist in the workbook
- setTableCustomStyle(String) - Method in interface com.smartxls.Table
-
- setTableFormat(RangeStyle, int) - Method in class com.smartxls.BookPivotRange
-
format the selection part of the pivot table
- setTableStyle(PivotBuiltInStyles) - Method in class com.smartxls.BookPivotRange
-
- setTemplate(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the template name
- setText(String) - Method in class com.smartxls.AutoShape
-
set the text content of the control
- setText(String) - Method in class com.smartxls.FormControlShape
-
set the lable of the control
- setText(int, int, int, String) - Method in class com.smartxls.WorkBook
-
Sets the value of the specified cell in the specified sheet.
- setText(String, String) - Method in class com.smartxls.WorkBook
-
sets the text value to the specified named cell
- setText(int, int, String) - Method in class com.smartxls.WorkBook
-
Sets the value of the specified cell for current selected sheet.
- setTextRotation(int) - Method in class com.smartxls.ChartFormat
-
set the text rotation
- setTextSelection(RangeStyle, int, int) - Method in class com.smartxls.CommentShape
-
Sets text selection formatting
- setTextSelection(int, int) - Method in class com.smartxls.WorkBook
-
Sets text selection for the selected cell
- setTickLabelPosition(int, int, int) - Method in class com.smartxls.ChartShape
-
Sets the tick label position on the specified axis.
- setTickStyle(int, int, boolean, int) - Method in class com.smartxls.ChartShape
-
Sets the tick label position on the specified axis.
- setTimeScaleBaseUnitAndInterval(int, int, int, int) - Method in class com.smartxls.ChartShape
-
set the time scale base unit and interval
- setTimeScaleBaseUnitAuto(short, int, boolean) - Method in class com.smartxls.ChartShape
-
set base unit of the timescale to auto
- setTimeScaleMajorUnit(int, int, int, int) - Method in class com.smartxls.ChartShape
-
set the time scale major unit
- setTimeScaleMinorUnit(int, int, int, int) - Method in class com.smartxls.ChartShape
-
set the time scale minor unit
- setTitle(String) - Method in class com.smartxls.ChartShape
-
Sets the chart title.
- setTitle(String) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the title
- setTitleFormat(ChartFormat) - Method in class com.smartxls.ChartShape
-
Sets chart title formatting.
- setToolTip(String) - Method in class com.smartxls.HyperLink
-
set the tool tip string
- setTopBorder(short) - Method in class com.smartxls.RangeStyle
-
Sets the style for the top edge of the cell.
- setTopBorderColor(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the top edge of the cell.
- setTotalRow(boolean, String) - Method in interface com.smartxls.Table
-
- setTotalRowCount(int) - Method in interface com.smartxls.Table
-
- setTrendLineDisplayEquation(int, int, boolean) - Method in class com.smartxls.ChartShape
-
- setTrendLineDisplayRSquared(int, int, boolean) - Method in class com.smartxls.ChartShape
-
- setTrendLineFormat(int, int, ChartFormat) - Method in class com.smartxls.ChartShape
-
- setTrendLineIntercept(int, int, double) - Method in class com.smartxls.ChartShape
-
- setTrendLinePeriod(int, int, short) - Method in class com.smartxls.ChartShape
-
- setTrendLineType(int, int, int) - Method in class com.smartxls.ChartShape
-
set the trendline type
-1-linear(default) 0-ploy 1-exp 2-log 3-power 4-movingAvg
- setType(short) - Method in class com.smartxls.ConditionFormat
-
Sets the type of this conditional format.
- setType(int) - Method in class com.smartxls.DataValidation
-
set the data validation type
any
DataValidation.eAny
integer decimal user date time textlength formula
- setType(int) - Method in class com.smartxls.HyperLink
-
set the hyperlink type
- setValueFormatLinkedToDataSource(boolean) - Method in class com.smartxls.ChartFormat
-
Sets whether the object gets the value format from the data source.
- setValueScaleDisplayUnit(int, int, int) - Method in class com.smartxls.ChartShape
-
set the display unit of the value scale
- setValueScaleDisplayUnitValue(int, int, int) - Method in class com.smartxls.ChartShape
-
set the display unit of the value scale
- setVaryColors(boolean) - Method in class com.smartxls.ChartShape
-
Sets a boolean indicating whether the series in the chart use varied colors.
- setVerticalAlignment(short) - Method in class com.smartxls.RangeStyle
-
Sets the type of vertical alignment.
- setVerticalInsideBorder(short) - Method in class com.smartxls.RangeStyle
-
Sets the border style for the vertical inside border.
- setVerticalInsideBorderColor(int) - Method in class com.smartxls.RangeStyle
-
Sets the color used to display the vertical inside border.
- setViewScale(int) - Method in class com.smartxls.WorkBook
-
Sets the current display scale for a workbook.
- setWordCount(int) - Method in interface com.smartxls.DocumentBuiltInProperties
-
set the words count
- setWordWrap(boolean) - Method in class com.smartxls.RangeStyle
-
Sets the wordwrap attribute.
- setWorkbookName(String) - Method in class com.smartxls.WorkBook
-
the workbook name
- setWorkBookVersion(ExcelVersion) - Method in class com.smartxls.WorkBook
-
- setXMLStaxMode(boolean) - Method in class com.smartxls.WorkBook
-
enable the xlsx/xlsm file parsing in the stax mode
- setYAxisCount(int) - Method in class com.smartxls.ChartShape
-
Sets the number of Y axes on the chart.
- ShapeFormat - Class in com.smartxls
-
This class represents the shape format object.
- ShapeObj - Class in com.smartxls
-
This class is base class of drawing Format.
- ShapePos - Class in com.smartxls
-
the shape placement position
- SheetNormalView - Static variable in class com.smartxls.WorkBook
-
sheet page layout normal
- SheetPageBreakPreView - Static variable in class com.smartxls.WorkBook
-
sheet page layout in break preview mode
- SheetPageLayoutView - Static variable in class com.smartxls.WorkBook
-
sheet page layout in page mode
- sheetProtectionAllowChangeLocked - Static variable in class com.smartxls.WorkBook
-
sheet protection allow change locked
- sheetProtectionAllowChangeUnlocked - Static variable in class com.smartxls.WorkBook
-
sheet protection allow change unlocked
- sheetProtectionAllowDefault - Static variable in class com.smartxls.WorkBook
-
sheet protection allow default options
- sheetProtectionAllowDeleteColumns - Static variable in class com.smartxls.WorkBook
-
sheet protection allow delete cols
- sheetProtectionAllowDeleteRows - Static variable in class com.smartxls.WorkBook
-
sheet protection allow delete rows
- sheetProtectionAllowEditObjects - Static variable in class com.smartxls.WorkBook
-
sheet protection allow edit object
- sheetProtectionAllowEditScenarios - Static variable in class com.smartxls.WorkBook
-
sheet protection allow edit scenarios
- sheetProtectionAllowEverything - Static variable in class com.smartxls.WorkBook
-
sheet protection allow everything
- sheetProtectionAllowFormatCells - Static variable in class com.smartxls.WorkBook
-
sheet protection allow format cells
- sheetProtectionAllowFormatColumns - Static variable in class com.smartxls.WorkBook
-
sheet protection allow format columns
- sheetProtectionAllowFormatRows - Static variable in class com.smartxls.WorkBook
-
sheet protection allow format rows
- sheetProtectionAllowInsertColumns - Static variable in class com.smartxls.WorkBook
-
sheet protection allow insert columns
- sheetProtectionAllowInsertHyperlinks - Static variable in class com.smartxls.WorkBook
-
sheet protection allow insert hyperlink
- sheetProtectionAllowInsertRows - Static variable in class com.smartxls.WorkBook
-
sheet protection allow insert rows
- sheetProtectionAllowLockedEditFocus - Static variable in class com.smartxls.WorkBook
-
sheet protection allow locked edit focus
- sheetProtectionAllowLockedInCellEdit - Static variable in class com.smartxls.WorkBook
-
sheet protection allow locked in cell edit
- sheetProtectionAllowNone - Static variable in class com.smartxls.WorkBook
-
sheet protection none
- sheetProtectionAllowSelectLocked - Static variable in class com.smartxls.WorkBook
-
sheet protection allow selected locked
- sheetProtectionAllowSelectUnlocked - Static variable in class com.smartxls.WorkBook
-
sheet protection allow select unlocked
- sheetProtectionAllowSort - Static variable in class com.smartxls.WorkBook
-
sheet protection allow sort
- sheetProtectionAllowUseAutoFilter - Static variable in class com.smartxls.WorkBook
-
sheet protection allow use autofilter
- sheetProtectionAllowUseOutlining - Static variable in class com.smartxls.WorkBook
-
sheet protection allow use outlining
- sheetProtectionAllowUsePivotRanges - Static variable in class com.smartxls.WorkBook
-
sheet protection allow use pivot ranges
- sheetRangeToImage(String) - Method in class com.smartxls.WorkBook
-
write sheet range to image
sheet range is from (0,0) to (last row,last col).
- sheetRangeToImage(int, int, int, int, String) - Method in class com.smartxls.WorkBook
-
write specified range to image
- sheetRangeToImage(int, int, int, int) - Method in class com.smartxls.WorkBook
-
rendering specified range content to an image
- SheetStateHidden - Static variable in class com.smartxls.WorkBook
-
sheet hidden
- SheetStateShown - Static variable in class com.smartxls.WorkBook
-
sheet shown normally
- SheetStateVeryHidden - Static variable in class com.smartxls.WorkBook
-
sheet hidden and can't be unhide from UI
- SheetVarType - Enum in com.smartxls
-
ignoredError_numberStoredAsText --- the attribute "numberStoredAsText" of the ignoredError for the current worksheet
- ShiftColumns - Static variable in class com.smartxls.WorkBook
-
cell/range shift direction,cols
- ShiftHorizontal - Static variable in class com.smartxls.WorkBook
-
cell/range shift direction,horizontal
- ShiftRows - Static variable in class com.smartxls.WorkBook
-
cell/range shift direction,rows
- ShiftVertical - Static variable in class com.smartxls.WorkBook
-
cell/range shift direction,vertical
- ShowAutomatic - Static variable in class com.smartxls.WorkBook
-
scrollbar shown automatically
- ShowOff - Static variable in class com.smartxls.WorkBook
-
scrollbar not shown
- ShowOn - Static variable in class com.smartxls.WorkBook
-
scrollbar shown always
- sort(int, int, int, int, boolean, int, int, int) - Method in class com.smartxls.WorkBook
-
Specified a range of data to be sorted by three keys.
- sort(int, int, int, int, boolean, int[]) - Method in class com.smartxls.WorkBook
-
Specified a range of data to be sorted by the keys.
- SortAscend - Static variable in class com.smartxls.BookPivotField
-
- SortAuto - Static variable in class com.smartxls.BookPivotField
-
- SortDescend - Static variable in class com.smartxls.BookPivotField
-
- SortManual - Static variable in class com.smartxls.BookPivotField
-
- Step - Static variable in class com.smartxls.ChartShape
-
- subTotal(int, int, int, int, int, int[]) - Method in class com.smartxls.WorkBook
-
Specified a range of data to be subtotaled.
- SubTotalTypeAutomatic - Static variable in class com.smartxls.BookPivotField
-
- SubTotalTypeCustom - Static variable in class com.smartxls.BookPivotField
-
- SubTotalTypeNone - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcAverage - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcCount - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcCountNums - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcMax - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcMin - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcProduct - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcStdDev - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcStdDevp - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcSum - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcVar - Static variable in class com.smartxls.BookPivotField
-
- SummarizeCalcVarp - Static variable in class com.smartxls.BookPivotField
-
- Surface - Static variable in class com.smartxls.ChartShape
-