Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate

Constant Field Values


Contents
com.aspose.*

com.aspose.cells.BorderLineType
public static final int DASHED 3
public static final int DOTTED 4
public static final int DOUBLE 6
public static final int HAIR 7
public static final int MEDIUM 2
public static final int MEDIUM_DASH_DOT_DOTTED 12
public static final int MEDIUM_DASH_DOTTED 10
public static final int MEDIUM_DASHED 8
public static final int NA 15
public static final int NONE 0
public static final int SLANTED_MEDIUM_DASH_DOTTED 13
public static final int THICK 5
public static final int THIN 1
public static final int THIN_DASH_DOT_DOTTED 11
public static final int THIN_DASH_DOTTED 9

com.aspose.cells.BorderType
public static final int BOTTOM 3
public static final int DIAGONAL_DOWN 4
public static final int DIAGONAL_UP 5
public static final int LEFT 0
public static final int RIGHT 1
public static final int TOP 2

com.aspose.cells.CalculationMode
public static final byte AUTOMATIC 1
public static final byte MANUAL 0
public static final byte SEMIAUTOMATIC 2

com.aspose.cells.CategoryType
public static final short AUTOMATIC_SCALE 239
public static final short CATEGORY_SCALE 111
public static final short TIME_SCALE 127

com.aspose.cells.CellsException
public static final int FILE_CORRUPTED 1
public static final int GENERAL 0
public static final int ILLEGAL_OPERATION 2
public static final int INTERNAL_CHECK_ERROR 5
public static final int INTERNAL_IO_ERROR 4
public static final int INVALID_LICENSE 6
public static final int UNSUPPORTED_FEATURES 3

com.aspose.cells.CellValueType
public static final short BOOLEAN 1
public static final short DATETIME 2
public static final short DOUBLE 5
public static final short ERROR 7
public static final short INT 4
public static final short NULL 0
public static final short RICH_TEXT_STRING 6
public static final short STRING 3

com.aspose.cells.ChartMarkerType
public static final short AUTOMATIC -1
public static final short CIRCLE 8
public static final short DASH 7
public static final short DIAMOND 2
public static final short DOT 6
public static final short NONE 0
public static final short SQUARE 1
public static final short SQUARE_PLUS 9
public static final short SQUARE_STAR 5
public static final short SQUARE_X 4
public static final short TRIANGLE 3

com.aspose.cells.ChartType
public static final int AREA 128
public static final int AREA_100PERCENT_STACKED 131
public static final int AREA_3D 65664
public static final int AREA_3D_100PERCENT_STACKED 65667
public static final int AREA_3D_STACKED 65665
public static final int AREA_STACKED 129
public static final int BAR_100PERCENT_STACKED 23
public static final int BAR_3D_100PERCENT_STACKED 65559
public static final int BAR_3D_CLUSTERED 65553
public static final int BAR_3D_STACKED 65555
public static final int BAR_CLUSTERED 17
public static final int BAR_STACKED 19
public static final int BUBBLE 257
public static final int BUBBLE_3D 259
public static final int COLUMN_100PERCENT_STACKED 22
public static final int COLUMN_3D 196624
public static final int COLUMN_3D_100PERCENT_STACKED 65558
public static final int COLUMN_3D_CLUSTERED 65552
public static final int COLUMN_3D_STACKED 65554
public static final int COLUMN_CLUSTERED 16
public static final int COLUMN_STACKED 18
public static final int CONE 69648
public static final int CONE_100PERCENT_STACKED 69654
public static final int CONE_STACKED 69650
public static final int CONICAL_BAR 69649
public static final int CONICAL_BAR_100PERCENT_STACKED 69655
public static final int CONICAL_BAR_STACKED 69651
public static final int CONICAL_COLUMN_3D 200720
public static final int CYLINDER 67600
public static final int CYLINDER_100PERCENT_STACKED 67606
public static final int CYLINDER_STACKED 67602
public static final int CYLINDERICAL_BAR 67601
public static final int CYLINDERICAL_BAR_100PERCENT_STACKED 67607
public static final int CYLINDERICAL_BAR_STACKED 67603
public static final int CYLINDERICAL_COLUMN_3D 198656
public static final int DOUGHNUT 1088
public static final int DOUGHNUT_EXPLODED 263232
public static final int LINE 32
public static final int LINE_100PERCENT_STACKED 35
public static final int LINE_100PERCENT_STACKED_DATA_MARKERS 43
public static final int LINE_3D 196640
public static final int LINE_STACKED 33
public static final int LINE_STACKED_DATA_MARKERS 41
public static final int LINE_WITH_DATA_MARKERS 40
public static final int PIE 64
public static final int PIE_3D 65600
public static final int PIE_3D_EXPLODED 327744
public static final int PIE_BAR 72
public static final int PIE_EXPLODED 262208
public static final int PIE_PIE 68
public static final int PYRAMID 73744
public static final int PYRAMID_100PERCENT_STACKED 73750
public static final int PYRAMID_BAR 73745
public static final int PYRAMID_BAR_100PERCENT_STACKED 73751
public static final int PYRAMID_BAR_STACKED 73747
public static final int PYRAMID_COLUMN_3D 204816
public static final int PYRAMID_STACKED 73746
public static final int RADAR 16384
public static final int RADAR_FILLED 16388
public static final int RADAR_WITH_DATA_MARKERS 16392
public static final int SCATTER 264
public static final int SCATTER_CONNECTED_BY_CURVES_WITH_DATA_MARKE 270
public static final int SCATTER_CONNECTED_BY_CURVES_WITHOUT_DATA_MARKE 262
public static final int SCATTER_CONNECTED_BY_LINES_WITH_DATA_MARKE 266
public static final int SCATTER_CONNECTED_BY_LINES_WITHOUT_DATA_MARKE 258
public static final int STOCK_HIGH_LOW_CLOSE 512
public static final int STOCK_OPEN_HIGH_LOW_CLOSE 514
public static final int STOCK_VOLUME_HIGH_LOW_CLOSE 513
public static final int STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE 515
public static final int SURFACE_3D 98305
public static final int SURFACE_CONTOUR 98307
public static final int SURFACE_CONTOUR_WIREFRAME 98306
public static final int SURFACE_WIREFRAME_3D 98304

com.aspose.cells.ConsolidationFunction
public static final short AVERAGE 2
public static final short COUNT 1
public static final short COUNT_NUMS 6
public static final short MAX 3
public static final short MIN 4
public static final short PRODUCT 5
public static final short STD_DEV 7
public static final short STD_DEVP 8
public static final short SUM 0
public static final short VAR 9
public static final short VARP 10

com.aspose.cells.ErrorBarInclude
public static final byte BOTH 3
public static final byte MINUS_VALUES 2
public static final byte NONE 0
public static final byte PLUS_VALUES 1

com.aspose.cells.ErrorBarType
public static final byte CUSTOM 4
public static final byte FIXED_VALUE 2
public static final byte PERCENT 1
public static final byte STANDARD_DEV 3
public static final byte STANDARD_ERROR 5

com.aspose.cells.FileFormatType
public static final int CSV 5
public static final int DEFAULT 2
public static final int EXCEL2000 2
public static final int EXCEL2003 4
public static final int EXCEL97 1
public static final int EXCELXP 3
public static final int HTML 8
public static final int SPREADSHEETML 7
public static final int TAB_DELIMITED 6

com.aspose.cells.FillPatternType
public static final short DARK_DOWNWARD_DIAGONAL 18
public static final short DARK_HORIZONTAL 27
public static final short DARK_UPWARD_DIAGONAL 19
public static final short DARK_VERTICAL 26
public static final short DASHED_DOWNWARD_DIAGONAL 32
public static final short DASHED_HORIZONTAL 34
public static final short DASHED_UPWARD_DIAGONAL 33
public static final short DASHED_VERTICAL 35
public static final short DIAGONAL_BRICK 40
public static final short DIVOT 48
public static final short DOTTED_DIAMOND 50
public static final short DOTTED_GRID 49
public static final short GRAY10 2
public static final short GRAY20 3
public static final short GRAY25 4
public static final short GRAY30 6
public static final short GRAY40 7
public static final short GRAY5 1
public static final short GRAY50 8
public static final short GRAY60 9
public static final short GRAY70 10
public static final short GRAY75 11
public static final short GRAY80 12
public static final short GRAY90 13
public static final short HORIZONTAL_BRICK 41
public static final short LARGE_CHECKER_BORDER 57
public static final short LARGE_CONFETTI 37
public static final short LARGE_GRID 55
public static final short LIGHT_DOWNWARD_DIAGONAL 16
public static final short LIGHT_HORIZONTAL 23
public static final short LIGHT_UPWARD_DIAGONAL 17
public static final short LIGHT_VERTICAL 22
public static final short NARROW_HORIZONTAL 25
public static final short NARROW_VERTICAL 24
public static final short OUTLINED_DIAMOND 58
public static final short PLAID 43
public static final short SHINGLE 51
public static final short SMALE_CHECKER_BORDER 56
public static final short SMALL_CONFETTI 36
public static final short SMALL_GRID 54
public static final short SOLID_DIAMOND 59
public static final short SPHERE 53
public static final short TRELLIS 52
public static final short WAVE 39
public static final short WEAVE 42
public static final short WIDE_DOWNWARD_DIAGONAL 20
public static final short WIDE_UPWARD_DIAGONAL 21
public static final short ZIG_ZAG 38

com.aspose.cells.FindOptions
public static final byte LOOKIN_FORMULAS 0
public static final byte LOOKIN_VALUES 1
public static final byte MATCH_CONTAINS 0
public static final byte MATCH_END_WITH 2
public static final byte MATCH_ENTIRE 3
public static final byte MATCH_START_WITH 1
public static final byte SEARCH_BY_COLUMNS 1
public static final byte SEARCH_BY_ROWS 0

com.aspose.cells.Font
public static final int ESCAPEMENT_NONE 0
public static final int ESCAPEMENT_SUBSCRIPT 2
public static final int ESCAPEMENT_SUPERSCRIPT 1
public static final int FAMILY_DECORATIVE 5
public static final int FAMILY_MODERN 3
public static final int FAMILY_NONE 0
public static final int FAMILY_ROMAN 1
public static final int FAMILY_SCRIPT 4
public static final int FAMILY_SWISS 2
public static final int UNDERLINE_DOUBLE 2
public static final int UNDERLINE_DOUBLE_ACCOUNTING 34
public static final int UNDERLINE_NONE 0
public static final int UNDERLINE_SINGLE 1
public static final int UNDERLINE_SINGLE_ACCOUNTING 33

com.aspose.cells.FormatConditionType
public static final byte CELL_VALUE 1
public static final byte EXPRESSION 2

com.aspose.cells.FormulaCalcException
public static final int CIRCLE 3
public static final int GENERAL 0
public static final int INVALID_PARAM_NUMBER 3
public static final int INVALID_PARAM_TYPE 4
public static final int UNSUPPORTED_FUNCION 2

com.aspose.cells.GradientColorType
public static final byte NONE 15
public static final byte ONE_COLOR 11
public static final byte PRESET_COLORS 0
public static final byte TWO_COLORS 3

com.aspose.cells.GradientPresetType
public static final short BRASS 4916
public static final short CALM_WATER 7967
public static final short CHROME 2327
public static final short CHROME_II 5641
public static final short DAYBREAK 6153
public static final short DESERT 11572
public static final short EARLY_SUNSET 4660
public static final short FIRE 3344
public static final short FOG 14135
public static final short GOLD 12079
public static final short GOLD_II 12058
public static final short HORIZON 6975
public static final short LATE_SUNSET 2099
public static final short MAHOGANY 12091
public static final short MOSS 10769
public static final short NIGHTFALL 2073
public static final short OCEAN 12574
public static final short PARCHMENT 6678
public static final short PERCOCK 12309
public static final short RAINBOW 5140
public static final short RAINBOW_II 7472
public static final short SAPPHIRE 4620
public static final short SILVER 2313
public static final short WHEAT 6665

com.aspose.cells.GradientStyleType
public static final byte DIAGONAL_DOWN 3
public static final byte DIAGONAL_UP 2
public static final byte FROM_CENTER 5
public static final byte FROM_CORNER 4
public static final byte HORIZONTAL 0
public static final byte VERTICAL 1

com.aspose.cells.HorizontalAlignmentType
public static final short CENTRED 2
public static final short CENTRED_ACROSS 6
public static final short DISTRIBUTED 7
public static final short FILLED 4
public static final short GENERAL 0
public static final short JUSTIFIED 5
public static final short JUSTIFY_DISTRIBUTED 15
public static final short LEFT 1
public static final short RIGHT 3

com.aspose.cells.LabelPositionType
public static final byte ABOVE 5
public static final byte BELOW 6
public static final byte BEST_FIT 9
public static final byte CENTER 3
public static final byte INSIDE_BASE 4
public static final byte INSIDE_END 2
public static final byte LEFT 7
public static final byte OUTSIDE_END 1
public static final byte REIGHT 8

com.aspose.cells.LegendPositionType
public static final int BOTTOM 0
public static final int CORNER 1
public static final int LEFT 4
public static final int NOT_DOCKED 7
public static final int RIGHT 3
public static final int TOP 2

com.aspose.cells.LineType
public static final short DARK_GRAY 6
public static final short DASH 1
public static final short DASH_DOT 3
public static final short DASH_DOT_DOT 4
public static final short DOT 2
public static final short LIGHT_GRAY 8
public static final short MEDIUM_GRAY 7
public static final short NONE 5
public static final short SOLID 0

com.aspose.cells.MsoLineDashStyle
public static final short DASH 6
public static final short DASH_DOT 8
public static final short LONG_DASH 7
public static final short LONG_DASH_DOT 9
public static final short LONG_DASH_DOT_DOT 10
public static final short ROUND_DOT 15
public static final short SOLID 0
public static final short SQUARE_DOT 2

com.aspose.cells.MsoLineStyle
public static final short SINGLE 0
public static final short THICK_BETWEEN_THIN 4
public static final short THICK_THIN 2
public static final short THIN_THICK 3
public static final short THIN_THIN 1

com.aspose.cells.MsoTextOrientation
public static final short DOWNWARD 3
public static final short NO_ROTATED 0
public static final short TOP_TO_BOTTOM 1
public static final short UPWARD 2

com.aspose.cells.OperatorType
public static final byte BETWEEN 0
public static final byte EQUAL 2
public static final byte GREATE_THAN 4
public static final byte GREATER_OR_EQUAL 6
public static final byte LESS_OR_EQUAL 7
public static final byte LESS_THAN 5
public static final byte NONE -1
public static final byte NOT_BETWEEN 1
public static final byte NOT_EQUAL 3

com.aspose.cells.OrderType
public static final byte DOWN_THEN_OVER 0
public static final byte OVER_THEN_DOWN 1

com.aspose.cells.PageOrientationType
public static final short LANDSCAPE 0
public static final short PORTRAIT 1

com.aspose.cells.PaperSizeType
public static final short PAGE_10x11 45
public static final short PAGE_10x14 16
public static final short PAGE_11x17 17
public static final short PAGE_15x11 46
public static final short PAGE_9x11 44
public static final short PAGE_A3 8
public static final short PAGE_A4 9
public static final short PAGE_A4_SMALL 10
public static final short PAGE_A5 11
public static final short PAGE_B4 12
public static final short PAGE_B5 13
public static final short PAGE_C_SHEET 24
public static final short PAGE_D_SHEET 25
public static final short PAGE_E_SHEET 26
public static final short PAGE_ENEVELOP_INVITE 47
public static final short PAGE_ENVELOPE_C3 29
public static final short PAGE_ENVELOPE_C4 30
public static final short PAGE_ENVELOPE_C5 28
public static final short PAGE_ENVELOPE_C6 31
public static final short PAGE_ENVELOPE_C65 32
public static final short PAGE_ENVELOPE_DL 27
public static final short PAGE_ENVELOPE_ITALY 36
public static final short PAGE_ENVELOPE_MONARCH 37
public static final short PAGE_ENVELOPE_PERSONAL 38
public static final short PAGE_ENVELOPE10 20
public static final short PAGE_ENVELOPE11 21
public static final short PAGE_ENVELOPE12 22
public static final short PAGE_ENVELOPE14 23
public static final short PAGE_ENVELOPE9 19
public static final short PAGE_EXECUTIVE 7
public static final short PAGE_FAN_FOLD_LEGAL_GREMAN 41
public static final short PAGE_FAN_FOLD_STD_GERMAN 40
public static final short PAGE_FAN_FOLD_US 39
public static final short PAGE_FILIO 14
public static final short PAGE_LEDAL 5
public static final short PAGE_LEDGER 4
public static final short PAGE_LETTER 1
public static final short PAGE_LETTER_SMALL 2
public static final short PAGE_NOTE 18
public static final short PAGE_POSTCARD_JAPANESE 43
public static final short PAGE_QUARTO 15
public static final short PAGE_STATEMENT 6
public static final short PAGE_TABLOID 3

com.aspose.cells.PatternType
public static final short DIAGONAL_CROSSHATCH 9
public static final short DIAGONAL_STRIPE 8
public static final short GRAY12 17
public static final short GRAY25 4
public static final short GRAY50 2
public static final short GRAY6 18
public static final short GRAY75 3
public static final short HORIZONTAL_STRIPE 5
public static final short NONE 0
public static final short REVERSE_DIAGONAL_STRIPE 7
public static final short SOLID 1
public static final short THICK_DIAGONAL_CROSSHATCH 10
public static final short THIN_DIAGONAL_CROSSHATCH 16
public static final short THIN_DIAGONAL_STRIPE 14
public static final short THIN_HORIZONTAL_CROSSHATCH 15
public static final short THIN_HORIZONTAL_STRIPE 11
public static final short THIN_REVERSE_DIAGONAL_STRIPE 13
public static final short THIN_VERTICAL_STRIPE 12
public static final short VERTICAL_STRIPE 6

com.aspose.cells.PivotFieldDataDisplayFormat
public static final byte DIFFERENCE_FROM 1
public static final byte INDEX 8
public static final byte NORMAL 0
public static final byte PERCENTAGE_DIFFERENCE_FROM 3
public static final byte PERCENTAGE_OF 2
public static final byte PERCENTAGE_OF_COLUMN 6
public static final byte PERCENTAGE_OF_ROW 5
public static final byte PERCENTAGE_OF_TOTAL 7
public static final byte RUNNING_TOTAL_IN 4

com.aspose.cells.PivotFieldSubtotalType
public static final short AUTOMATIC 1
public static final short AVERAGE 8
public static final short COUNT 4
public static final short COUNT_NUMS 128
public static final short MAX 16
public static final short MIN 32
public static final short NONE 0
public static final short PRODUCT 64
public static final short STD_DEV 256
public static final short STD_DEVP 512
public static final short SUM 2
public static final short VAR 1024
public static final short VARP 2048

com.aspose.cells.PivotFieldType
public static final byte COLUMN 2
public static final byte DATA 8
public static final byte PAGE 4
public static final byte ROW 1
public static final byte UNDEFINED 0

com.aspose.cells.PivotItemPosition
public static final short ALL 32765
public static final short NEXT 32764
public static final short PREVIOUS 32763

com.aspose.cells.PivotTableAutoFormatType
public static final short CLASSIC 1
public static final short NONE 4117
public static final short REPORT1 4096
public static final short REPORT10 4105
public static final short REPORT2 4097
public static final short REPORT3 4098
public static final short REPORT4 4099
public static final short REPORT5 4100
public static final short REPORT6 4101
public static final short REPORT7 4102
public static final short REPORT8 4103
public static final short REPORT9 4104
public static final short TABLE1 12298
public static final short TABLE10 12307
public static final short TABLE2 12299
public static final short TABLE3 12300
public static final short TABLE4 12301
public static final short TABLE5 12302
public static final short TABLE6 12303
public static final short TABLE7 12304
public static final short TABLE8 12305
public static final short TABLE9 12306

com.aspose.cells.PlacementType
public static final byte FREE_FLOATING 3
public static final byte MOVE 2
public static final byte MOVE_AND_SIZE 0

com.aspose.cells.PrintCommentsType
public static final byte PRINT_IN_PLACE 0
public static final byte PRINT_NO_COMMNENTS -1
public static final byte PRINT_SHEET_END 1

com.aspose.cells.PrintErrorsType
public static final short PRINT_ERRORS_BLANK 1
public static final short PRINT_ERRORS_DASH 2
public static final short PRINT_ERRORS_DISPLAYED 0
public static final short PRINT_ERRORS_NA 3

com.aspose.cells.PrintOrderType
public static final byte DOWN_THEN_OVER 0
public static final byte OVER_THEN_DOWN 1

com.aspose.cells.PropertyType
public static final int BLOB 5
public static final int BOOLEAN 0
public static final int DATE_TIME 1
public static final int DOUBLE 2
public static final int NUMBER 3
public static final int STRING 4

com.aspose.cells.ProtectionType
public static final byte MODIFY_FILE 4
public static final byte OPEN_FILE 3
public static final byte STRUCTURE 1
public static final byte WINDOWS 2
public static final byte WORKBOOK_ALL 0

com.aspose.cells.SheetType
public static final short CHART 2
public static final short OTHER 6
public static final short WORKSHEET 0

com.aspose.cells.TextAlignmentType
public static final short BOTTOM 3
public static final short CENTER 2
public static final short DISTRIBUTED 7
public static final short JUSTIFY 4
public static final short LEFT 1
public static final short RIGHT 3
public static final short TOP 1

com.aspose.cells.TextDirectionType
public static final byte CONTEXT 0
public static final byte LEFT_TO_RIGHT 1
public static final byte RIGHT_TO_LEFT 2

com.aspose.cells.TickLabelPositionType
public static final int HIGH 2
public static final int LOW 1
public static final int NEXT_TO_AXIS 3
public static final int NONE 0

com.aspose.cells.TickMarkerType
public static final int CROSS 3
public static final int INSIDE 1
public static final int NONE 0
public static final int OUTSIDE 2

com.aspose.cells.TrendlineType
public static final short EXPONENTIAL 1
public static final short LINEAR 0
public static final short LOGARITHMIC 2
public static final short MOVING_AVERAGE 4
public static final short POLYNOMIAL 5
public static final short POWER 3

com.aspose.cells.ValidationAlertType
public static final byte INFORMATION 2
public static final byte STOP 0
public static final byte WARNING 1

com.aspose.cells.ValidationType
public static final byte ANYVALUE 0
public static final byte CUSTOM 7
public static final byte DATE 4
public static final byte DECIMAL 2
public static final byte LIST 3
public static final byte TEXT_LENGTH 6
public static final byte TIME 5
public static final byte WHOLE_NUMBER 1

com.aspose.cells.VerticalAlignmentType
public static final short BOTTOM 2
public static final short CENTRED 1
public static final short DISTRIBUTED 4
public static final short JUSTIFIED 3
public static final short TOP 0

com.aspose.cells.WeightType
public static final short HAIR_LINE -1
public static final short MEDIUME_LINE 1
public static final short SINGLE_LINE 0
public static final short WIDE_LINE 2