Skip to main content
Option, result and value types that OfficeJS names, A to Z. This reference is split into one page per feature:
  • Conditional formats: ConditionalCellValueOperator, ConditionalCellValueRule, ConditionalColorScaleCriteria, ConditionalColorScaleCriterion, ConditionalDataBarAxisFormat, ConditionalDataBarDirection, ConditionalDataBarRule, ConditionalFormatColorCriterionType, ConditionalFormatIconRuleType, ConditionalFormatPresetCriterion, ConditionalFormatRuleType, ConditionalFormatType, ConditionalIconCriterion, ConditionalIconCriterionOperator, ConditionalPresetCriteriaRule, ConditionalRangeBorderIndex, ConditionalRangeBorderLineStyle, ConditionalRangeFontUnderlineStyle, ConditionalTextComparisonRule, ConditionalTextOperator, ConditionalTopBottomCriterionType, ConditionalTopBottomRule, GraphicRule, Icon, IconSet
  • PivotTables and slicers: ConsolidationFunction, PivotAxis, PivotEditor, PivotFilters, PivotFilterType, PivotItemsHost, PivotLabelFilter, PivotManualFilter, PivotValueFilter, ShowAsCalculation, ShowAsRule, SlicerCrossFilter, SlicerSortType
  • Charts and sparklines: Axis, ChartDataSourceType, ChartPlotBy, ChartSeriesDimension
  • Shapes and pictures: ArrowheadLength, ArrowheadStyle, ArrowheadWidth, Base64EncodedImage, ConnectorType, GetImageOptions, LocalImageCacheId, LocalImageCellValue, PictureColorType, PictureFormat, ShapeAutoSize, ShapeFillType, ShapeFontUnderlineStyle, ShapeHost, ShapeLineDashStyle, ShapeLineStyle, ShapeScaleFrom, ShapeScaleType, ShapeTextHorizontalAlignment, ShapeTextHorizontalOverflow, ShapeTextOrientation, ShapeTextReadingOrder, ShapeTextVerticalAlignment, ShapeTextVerticalOverflow, ShapeTheme, ShapeType, ShapeZOrder, WebImageCellValue
  • Formulas and names: Fn, FunctionArg, NamedItemType, ScenarioOptions
  • Data, sorting and validation: AutoFillType, BasicDataValidation, ClearApplyTo, CustomDataValidation, DataValidationAlertStyle, DataValidationErrorAlert, DataValidationOperator, DataValidationPrompt, DataValidationRule, DataValidationType, DateTimeDataValidation, DeleteShiftDirection, FilterAction, FilterCriteria, FilterOn, InsertShiftDirection, InsertWorksheetOptions, LabelFilterCondition, ListDataValidation, RemoveDuplicatesResult, ReplaceCriteria, SearchCriteria, SortBy, SortDataOption, SortField, SortMethod, SortOn, SortOrientation, SpecialCellType, SpecialCellValueType, ValidationBound, ValueFilterCondition
  • Page layout and printing: HeaderFooterState, Page, PageLayoutMarginOptions, PageLayoutZoomOptions, PageOrientation, PaperType, PrintComments, PrintErrorType, PrintMarginUnit, PrintOrder
  • Formatting and styles: BorderIndex, BorderPreset, DxfSlot, FillPattern, NumberFormatCategory, StyleOf
  • Comments and protection: AllowEditRangeOptions, CommentMention, CommentRichContent, CommentScope, WorksheetProtectionOptions
  • Editor: KeyboardDirection, RangeViewWritable, Slot
  • Other: Address, Areas, BasicCellValue, Cell, CellControl, CellValueInput, ClientResult, ContentType, Ctx, CustomPropertyValue, DocumentPropertyType, GroupOption, Kind, Model, Nullable, Placement, PropertyLoadOptions, RangeCopyType, RangeHyperlink, Rect, RuleHost, Scope, Setter, UpdateData, UpdateOptions, Value, WorkbookLinksRefreshMode