- 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
Types: OfficeJS
Types: OfficeJS
Option, result and value types that OfficeJS names, A to Z.
This reference is split into one page per feature:
Was this page helpful?