- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
-
FarPoint.Win.Spread Assembly
-
FarPoint.Win.Spread
- Classes
- Structs
-
Enums
- ActionType
- AnnotationMode
- AutoFilterMode
- BorderCollapse
- BoundaryFeedbackMode
- ButtonDrawModes
- CalculationPolicy
- CellHorizontalAlignment
- CellRangeType
- CellSpanSelectionPolicy
- CellVerticalAlignment
- Centering
- ChangeType
- ClipboardBehavior
- ClipboardCopyOptions
- ClipboardOptions
- ClipboardPasteOptions
- CodeDomStrategies
- CollectionEditorOptions
- CompareStringValidatorOperator
- ComparisonOperator
- ConditionalFormattingChangedEventType
- ConditionalFormattingIcon
- ConditionalFormattingIconSetStyle
- ConditionalFormattingModelEventType
- ConditionalFormattingValueType
- ConditionalStyleOperator
- ContextMenuType
- CursorType
- CustomControlType
- CustomFilterOperatorType
- CustomNameChangeAction
- DataBarAxisPosition
- DateTimeGroupingType
- DragFillMode
- DropDownControl.eDockSide
- DropDownControl.eDropState
- DynamicFilterType
- EditError
- ElementAlign
- EnhancedFilterSortingMode
- EnhancedInterfaceRenderer.ButtonStyles
- EnhancedInterfaceRenderer.SheetTabShape
- EnhancedShapeBehaviors
- FillDirection
- FilterListBehavior
- FilterState
- FlagArrowKeys
- FormatCells.FormatCellsTab
- GridLineType
- GridLines
- GroupState
- HeaderAutoText
- HeaderEditForm.HeaderEditType
- HitTestType
- HorizontalPosition
- HyperLinkTab
- InputDeviceType
- InputMapMode
- LegacyBehaviors
- LengthUnit
- NamedStyleCollectionEventType
- NonEmptyItemFlag
- NoteIndicatorPosition
- NoteStyle
- OperationMode
- PdfWriteMode
- PdfWriteTo
- PreferredSizeColumnOptions
- PreferredSizeRowOptions
- PrintArea
- PrintDocumentEventType
- PrintHeader
- PrintNotes
- PrintOrientation
- PrintPageOrder
- PrintTitle
- PrintType
- RangeGroupButtonStyle
- RangeGroupInfoEventType
- RangeGroupModelEventType
- RecentItemType
- RegularBoldItalicFontStyle
- ResetOption
- ResizeZeroIndicator
- RichTextEditMode
- RowCol
- RowSelectorState
- SaveXMLOptions
- ScaleMode
- ScrollBarButtons
- ScrollBarPolicy
- ScrollBarTrackPolicy
- ScrollTipPolicy
- ScrollingContentRowNumberPolicy
- SearchFoundFlags
- SelectionBlockOptions
- SelectionStyles
- SheetView.ImageLayout
- SortBy
- SortState
- SortingMode
- SparklineAxisMinMax
- SparklineType
- SplitBoxAlignment
- SplitBoxPolicy
- SpreadPanningMode
- SpreadToolTip
- StrikeoutFontStyle
- SystemSoundType
- TabStripButton
- TabStripButtonPolicy
- TabStripPlacement
- TabStripPolicy
- TableStyleCollectionChangedType
- TextConditionOperator
- TextFileFlags
- TextTipPolicy
- TimePeriod
- TouchStripShowingArea
- UnaryComparisonOperator
- UnderlineFontStyle
- ValidateComparisonOperator
- ValidateReasons
- ValueProcessOption
- VerticalPosition
- Xlf
- Interfaces
- Delegates
- FarPoint.Win.Spread.CellType
- FarPoint.Win.Spread.Chart
- FarPoint.Win.Spread.Data
- FarPoint.Win.Spread.Dialogs
- FarPoint.Win.Spread.DrawingSpace
- FarPoint.Win.Spread.Model
- FarPoint.Win.Spread.UndoRedo
- FarPoint.Win.Spread.Visualization
-
FarPoint.Win.Spread
- GrapeCity.CalcEngine Assembly
- GrapeCity.Spreadsheet Assembly
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
FarPoint.Win.Spread.ConditionalFormattingValueType
ConditionalFormattingValueType Enum
Represents the value type of the conditional formatting.
Namespace: FarPoint.Win.Spread
Assembly: FarPoint.Win.Spread.dll
Syntax
[TypeConverter(typeof(EnumFriendlyConverter))]
public enum ConditionalFormattingValueType<TypeConverter(GetType(EnumFriendlyConverter))>
Public Enum ConditionalFormattingValueTypeFields
| Name | Description |
|---|---|
| AutoMax | The larger of zero or the maximum value from the range of cells that the conditional formatting rule applies to. |
| AutoMin | The smaller of zero or the minimum value from the range of cells that the conditional formatting rule applies to. |
| Formula | The result of the formula determines the minimum or maximum value of the cell range that the rule applies to. If the result is not numeric, it is treated as zero. |
| Max | The maximum value from the range of cells that the conditional formatting rule applies to. |
| Min | The minimum value from the range of cells that the conditional formatting rule applies to. |
| Number | Indicates the number value. |
| Percent | The minimum value in the range of cells that the conditional formatting rule applies to plus X percent of the difference between the maximum and minimum values in the range of cells that the conditional formatting rule applies to. |
| Percentile | The minimum value of the cell that is in the X percentile of the range of cells that the conditional formatting rule applies to. |