- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
- GC.Spread.Sheets
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
-
GC.Spread.Sheets.ConditionalFormatting
- Classes
-
Enumerations
- AverageConditionType
- BarDirection
- ColorCompareType
- ComparisonOperators
- ConditionType
-
CustomValueType
- DataBarAxisPosition
- DateCompareType
- DateOccurringType
- GeneralComparisonOperators
- IconSetType
- IconValueType
- LogicalOperators
- QuarterType
- RuleType
- ScaleValueType
- TextCompareType
- TextComparisonOperators
- Top10ConditionType
- Interfaces
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Excel.IO
GC.Spread.Sheets.ConditionalFormatting.CustomValueType
枚举: CustomValueType
Sheets.ConditionalFormatting.CustomValueType
自定义值类型
代码示例
var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.formulaCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.CustomValueType.nonEmpty});
var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition);
validator.ignoreBlank(false);
activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator);
spread.options.highlightInvalidData = true;
Table of contents
枚举值成员
枚举值成员
empty
• empty = 0
单元格值是否为empty还是null
error
• error = 2
单元格值是否包含计算错误
formula
• formula = 4
单元格值是否为公式
nonEmpty
• nonEmpty = 1
单元格值是否不为empty或null
nonError
• nonError = 3
单元格值是否不包含计算错误