# Constant Field Values

## Contents

- com.smartxls.*

## com.smartxls.*

- com.smartxls.AutoShape
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final short` | `Line` | `2`
  `public static final short` | `Oval` | `1`
  `public static final short` | `Rectangle` | `0`
  `public static final short` | `TextBox` | `3`

- com.smartxls.BookPivotField
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `SortAscend` | `1`
  `public static final int` | `SortAuto` | `0`
  `public static final int` | `SortDescend` | `2`
  `public static final int` | `SortManual` | `3`
  `public static final int` | `SubTotalTypeAutomatic` | `1`
  `public static final int` | `SubTotalTypeCustom` | `2`
  `public static final int` | `SubTotalTypeNone` | `0`
  `public static final short` | `SummarizeCalcAverage` | `2`
  `public static final short` | `SummarizeCalcCount` | `1`
  `public static final short` | `SummarizeCalcCountNums` | `6`
  `public static final short` | `SummarizeCalcMax` | `3`
  `public static final short` | `SummarizeCalcMin` | `4`
  `public static final short` | `SummarizeCalcProduct` | `5`
  `public static final short` | `SummarizeCalcStdDev` | `7`
  `public static final short` | `SummarizeCalcStdDevp` | `8`
  `public static final short` | `SummarizeCalcSum` | `0`
  `public static final short` | `SummarizeCalcVar` | `9`
  `public static final short` | `SummarizeCalcVarp` | `10`

- com.smartxls.BookPivotRange
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final short` | `areaAll` | `3`
  `public static final short` | `areaBlankColumnHeader` | `0`
  `public static final short` | `areaData` | `2`
  `public static final short` | `areaHeaders` | `7`
  `public static final short` | `areaTopLeft` | `4`
  `public static final short` | `column` | `2`
  `public static final short` | `data` | `4`
  `public static final short` | `page` | `3`
  `public static final short` | `row` | `1`

- com.smartxls.ChartFormat
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final short` | `DataLabelBubbleSize` | `5`
  `public static final short` | `DataLabelCategory` | `3`
  `public static final short` | `DataLabelCategoryAndPercent` | `4`
  `public static final short` | `DataLabelNone` | `0`
  `public static final short` | `DataLabelPercent` | `2`
  `public static final short` | `DataLabelPercentageMask` | `8`
  `public static final short` | `DataLabelPositionAbove` | `5`
  `public static final short` | `DataLabelPositionAuto` | `9`
  `public static final short` | `DataLabelPositionAxis` | `4`
  `public static final short` | `DataLabelPositionBelow` | `6`
  `public static final short` | `DataLabelPositionCenter` | `3`
  `public static final short` | `DataLabelPositionDefault` | `0`
  `public static final short` | `DataLabelPositionInside` | `2`
  `public static final short` | `DataLabelPositionLeft` | `7`
  `public static final short` | `DataLabelPositionOutside` | `1`
  `public static final short` | `DataLabelPositionRight` | `8`
  `public static final short` | `DataLabelSeriesNameMask` | `1`
  `public static final short` | `DataLabelSizeValueMask` | `16`
  `public static final short` | `DataLabelValue` | `1`
  `public static final short` | `DataLabelXValueMask` | `2`
  `public static final short` | `DataLabelYValueMask` | `4`
  `public static final short` | `Hairline` | `0`
  `public static final short` | `LegendPlacementBottom` | `0`
  `public static final short` | `LegendPlacementCorner` | `1`
  `public static final short` | `LegendPlacementLeft` | `4`
  `public static final short` | `LegendPlacementRight` | `3`
  `public static final short` | `LegendPlacementTop` | `2`
  `public static final short` | `LineDash` | `6`
  `public static final short` | `LineDashDot` | `7`
  `public static final short` | `LineDashDotDot` | `8`
  `public static final short` | `LineDot` | `3`
  `public static final short` | `LineNull` | `255`
  `public static final short` | `LineSolid` | `1`
  `public static final short` | `MarkerCircle` | `8`
  `public static final short` | `MarkerDiamond` | `2`
  `public static final short` | `MarkerDowJonesClose` | `6`
  `public static final short` | `MarkerDowJonesOpen` | `11`
  `public static final short` | `MarkerDownTriangle` | `10`
  `public static final short` | `MarkerNone` | `0`
  `public static final short` | `MarkerPlus` | `9`
  `public static final short` | `MarkerSquare` | `1`
  `public static final short` | `MarkerStar` | `5`
  `public static final short` | `MarkerStdDeviation` | `7`
  `public static final short` | `MarkerTriangle` | `3`
  `public static final short` | `MarkerX` | `4`
  `public static final short` | `Medium` | `30`
  `public static final short` | `Narrow` | `15`
  `public static final short` | `Wide` | `45`

- com.smartxls.ChartShape
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final short` | `Area` | `2`
  `public static final short` | `Bar` | `4`
  `public static final short` | `Bubble` | `9`
  `public static final short` | `CategoryScale` | `0`
  `public static final short` | `Column` | `0`
  `public static final short` | `Combination` | `5`
  `public static final short` | `Doughnut` | `7`
  `public static final short` | `LegendPlacementBottom` | `0`
  `public static final short` | `LegendPlacementBottomLeftCorner` | `9`
  `public static final short` | `LegendPlacementBottomRightCorner` | `6`
  `public static final short` | `LegendPlacementCorner` | `1`
  `public static final short` | `LegendPlacementLeft` | `4`
  `public static final short` | `LegendPlacementNotDocked` | `7`
  `public static final short` | `LegendPlacementRight` | `3`
  `public static final short` | `LegendPlacementTop` | `2`
  `public static final short` | `LegendPlacementTopLeftCorner` | `8`
  `public static final short` | `LegendPlacementTopRightCorner` | `5`
  `public static final short` | `Line` | `1`
  `public static final short` | `Pie` | `6`
  `public static final short` | `Radar` | `11`
  `public static final short` | `Scatter` | `8`
  `public static final short` | `SeriesScale` | `3`
  `public static final short` | `Step` | `3`
  `public static final short` | `Surface` | `13`
  `public static final short` | `TickCross` | `3`
  `public static final short` | `TickInside` | `1`
  `public static final short` | `TickLabelPositionHigh` | `2`
  `public static final short` | `TickLabelPositionLow` | `1`
  `public static final short` | `TickLabelPositionNextToAxis` | `3`
  `public static final short` | `TickLabelPositionNone` | `0`
  `public static final short` | `TickLNone` | `0`
  `public static final short` | `TickOutside` | `2`
  `public static final short` | `TimeScale` | `2`
  `public static final short` | `ValueScale` | `1`
  `public static final short` | `XAxis` | `0`
  `public static final short` | `YAxis` | `1`
  `public static final short` | `ZAxis` | `2`

- com.smartxls.ConditionFormat
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final short` | `eOperatorBetween` | `1`
  `public static final short` | `eOperatorEqual` | `3`
  `public static final short` | `eOperatorGreaterThan` | `5`
  `public static final short` | `eOperatorGreaterThanOrEqual` | `7`
  `public static final short` | `eOperatorLessThan` | `6`
  `public static final short` | `eOperatorLessThanOrEqual` | `8`
  `public static final short` | `eOperatorNone` | `0`
  `public static final short` | `eOperatorNotBetween` | `2`
  `public static final short` | `eOperatorNotEqual` | `4`
  `public static final short` | `eTypeCell` | `1`
  `public static final short` | `eTypeFormula` | `2`
  `public static final short` | `eTypeNone` | `0`

- com.smartxls.FormControlShape
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final short` | `CheckBox` | `11`
  `public static final short` | `CombBox` | `20`
  `public static final short` | `ListBox` | `18`

- com.smartxls.HyperLink
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `kFileAbs` | `3`
  `public static final int` | `kFileRel` | `4`
  `public static final int` | `kNet` | `5`
  `public static final int` | `kRange` | `0`
  `public static final int` | `kUnknown` | `-1`
  `public static final int` | `kURLAbs` | `1`
  `public static final int` | `kURLRel` | `2`

- com.smartxls.RangeStyle
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final short` | `BorderDashDot` | `9`
  `public static final short` | `BorderDashDotDot` | `11`
  `public static final short` | `BorderDashed` | `3`
  `public static final short` | `BorderDotted` | `4`
  `public static final short` | `BorderDouble` | `6`
  `public static final short` | `BorderHair` | `7`
  `public static final short` | `BorderMedium` | `2`
  `public static final short` | `BorderMediumDash` | `8`
  `public static final short` | `BorderMediumDashDot` | `10`
  `public static final short` | `BorderMediumDashDotDot` | `12`
  `public static final short` | `BorderNone` | `0`
  `public static final short` | `BorderSlantedDashDot` | `13`
  `public static final short` | `BorderThick` | `5`
  `public static final short` | `BorderThin` | `1`
  `public static final short` | `HorizontalAlignmentCenter` | `2`
  `public static final short` | `HorizontalAlignmentCenterAcrossCells` | `6`
  `public static final short` | `HorizontalAlignmentFill` | `4`
  `public static final short` | `HorizontalAlignmentGeneral` | `0`
  `public static final short` | `HorizontalAlignmentJustify` | `5`
  `public static final short` | `HorizontalAlignmentLeft` | `1`
  `public static final short` | `HorizontalAlignmentRight` | `3`
  `public static final short` | `OrientationClockwise` | `-90`
  `public static final short` | `OrientationCounterClockwise` | `90`
  `public static final short` | `OrientationNone` | `0`
  `public static final short` | `OrientationTopToBottom` | `91`
  `public static final short` | `PatternNull` | `0`
  `public static final short` | `PatternSolid` | `1`
  `public static final short` | `UnderlineDouble` | `2`
  `public static final short` | `UnderlineNone` | `0`
  `public static final short` | `UnderlineSingle` | `1`
  `public static final short` | `VerticalAlignmentBottom` | `2`
  `public static final short` | `VerticalAlignmentCenter` | `1`
  `public static final short` | `VerticalAlignmentJustify` | `3`
  `public static final short` | `VerticalAlignmentTop` | `0`

- com.smartxls.ShapeFormat
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `PlacementFreeFloating` | `0`
  `public static final int` | `PlacementMove` | `1`
  `public static final int` | `PlacementMoveAndSize` | `2`

- com.smartxls.WorkBook
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `bookProtectStructure` | `-2147483648`
  `public static final int` | `bookProtectWindow` | `1073741824`
  `public static final int` | `CopyAll` | `7`
  `public static final int` | `CopyFormats` | `4`
  `public static final int` | `CopyFormulas` | `1`
  `public static final int` | `CopyValues` | `2`
  `public static final short` | `SheetNormalView` | `0`
  `public static final short` | `SheetPageBreakPreView` | `2`
  `public static final short` | `SheetPageLayoutView` | `1`
  `public static final int` | `sheetProtectionAllowChangeLocked` | `268435456`
  `public static final int` | `sheetProtectionAllowChangeUnlocked` | `536870912`
  `public static final int` | `sheetProtectionAllowDefault` | `17408`
  `public static final int` | `sheetProtectionAllowDeleteColumns` | `256`
  `public static final int` | `sheetProtectionAllowDeleteRows` | `512`
  `public static final int` | `sheetProtectionAllowEditObjects` | `1`
  `public static final int` | `sheetProtectionAllowEditScenarios` | `2`
  `public static final int` | `sheetProtectionAllowEverything` | `-2147483648`
  `public static final int` | `sheetProtectionAllowFormatCells` | `4`
  `public static final int` | `sheetProtectionAllowFormatColumns` | `8`
  `public static final int` | `sheetProtectionAllowFormatRows` | `16`
  `public static final int` | `sheetProtectionAllowInsertColumns` | `32`
  `public static final int` | `sheetProtectionAllowInsertHyperlinks` | `128`
  `public static final int` | `sheetProtectionAllowInsertRows` | `64`
  `public static final int` | `sheetProtectionAllowLockedEditFocus` | `67108864`
  `public static final int` | `sheetProtectionAllowLockedInCellEdit` | `134217728`
  `public static final int` | `sheetProtectionAllowNone` | `0`
  `public static final int` | `sheetProtectionAllowSelectLocked` | `1024`
  `public static final int` | `sheetProtectionAllowSelectUnlocked` | `16384`
  `public static final int` | `sheetProtectionAllowSort` | `2048`
  `public static final int` | `sheetProtectionAllowUseAutoFilter` | `4096`
  `public static final int` | `sheetProtectionAllowUseOutlining` | `1073741824`
  `public static final int` | `sheetProtectionAllowUsePivotRanges` | `8192`
  `public static final short` | `SheetStateHidden` | `1`
  `public static final short` | `SheetStateShown` | `0`
  `public static final short` | `SheetStateVeryHidden` | `2`
  `public static final short` | `ShiftColumns` | `4`
  `public static final short` | `ShiftHorizontal` | `1`
  `public static final short` | `ShiftRows` | `3`
  `public static final short` | `ShiftVertical` | `2`
  `public static final short` | `ShowAutomatic` | `2`
  `public static final short` | `ShowOff` | `0`
  `public static final short` | `ShowOn` | `1`
  `public static final short` | `TabsBottom` | `1`
  `public static final short` | `TabsOff` | `0`
  `public static final short` | `TabsTop` | `2`
  `public static final short` | `TypeEmpty` | `0`
  `public static final short` | `TypeError` | `4`
  `public static final short` | `TypeLogical` | `3`
  `public static final short` | `TypeNumber` | `1`
  `public static final short` | `TypeText` | `2`