- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
- FarPoint.Win.Spread Assembly
- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
-
GrapeCity.Spreadsheet
- Classes
- Structs
- Enums
-
Interfaces
- IAboveAverage
- IAlternatingStyles
- IAreas
- IArray<T>
- IAuthor
- IAutoFilter
- IAutoFilterOwner
- IBorder
- IBorders
- ICellEditor
- ICellRenderer
- ICellType
- ICharacters
- IColorPalette
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStops
- IColumnFooter
- IColumnHeader
- IComment
- ICommentThreaded
- IComments
- ICommentsThreaded
- IConditionValue
- IDataManager
- IDatabar
- IDatabarBorder
- IFilter
- IFilters
- IFont
- IFormatCondition
- IFormatConditions
- IFormatter
- IGradient
- IGraphic
- IHyperlink
- IHyperlinks
- IIconCriteria
- IIconCriterion
- IIconSetCondition
- IInterior
- IMedia
- IName
- INames
- INegativeBarFormat
- INumFmtSupportCellType
- IOutline
- IProtection
-
IRange
-
Properties
- AllowEdit
- Areas
- Borders
- CellType
- Cells
- Column
- Column2
- ColumnCount
- ColumnWidth
- Columns
- Comment
- CommentThreaded
- Count
- CurrentArray
- CurrentRegion
- Dependents
- DirectDependents
- DirectPrecedents
- DisplayFormat
- EntireColumn
- EntireRow
- Font
- FormatConditions
- FormattedValue
- Formula
- Formula2
- Formula2R1C1
- FormulaArray
- FormulaR1C1
- HasArray
- HasFormula
- HasRichDataType
- HasSpill
- Height
- Hidden
- HorizontalAlignment
- Hyperlinks
- IndentLevel
- Interior
- Left
- Locked
- MergeArea
- MergeCells
- MergePolicy
- Next
- NumberFormat
- Orientation
- OutlineLevel
- PageBreak
- Precedents
- Previous
- Resizable
- Row
- Row2
- RowCount
- RowHeight
- Rows
- ShowDetail
- ShrinkToFit
- SparklineGroups
- Style
- Summary
- Table
- Text
- Top
- UseStandardHeight
- UseStandardWidth
- Validation
- Value
- VerticalAlignment
- Width
- Worksheet
- WrapText
- this
- Methods
-
Properties
- IReadonlyArray<T>
- IRowHeader
- ISheet
- ISheetView
- ISheets
- ISort
- ISortComparer
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkPoints
- ISparkVerticalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- IStyle
- IStyles
- ITable
- ITableColumn
- ITableColumns
- ITableRow
- ITableRows
- ITableStyle
- ITableStyleElement
- ITableStyleElements
- ITableStyles
- ITables
- ITop10
- IUniqueValues
- IValidation
- IWorkbook
- IWorkbookSet
- IWorkbooks
- IWorksheet
- IWorksheetStyles
- IWorksheetView
- IWorksheets
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.IO.Pdf
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.Slicers
- GrapeCity.Spreadsheet.UI
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
GrapeCity.Spreadsheet.IRange.Formula
Formula Property
Formula
Gets or sets the formula, which will implicitly intersect as required when set, for this IRange.
Declaration
string Formula { get; set; }Property Formula As StringProperty Value
| Type | Description |
|---|---|
| string | A string value represents the formula of this IRange. |
Remarks
Setting Formula will always result in a formula that will never spill, because implicit intersection will force it to return just one result.