Range.HasFormula Property

Determines whether all cells in the range contain a formula.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

bool HasFormula { get; }

VB.NET

ReadOnly Property HasFormula As Boolean

Property Value

Type	Description
Boolean	true, if all cells in the range contain a formula; otherwise, false.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the HasFormula property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/CS/UDF_Discount/Form1.cs#L36

{
    if (cell.HasFormula)
        // The worksheet references functions from the DiscountXLL.MyFunctions xll Add-in.

xtraspreadsheet-custom-draw-examples-e5044/CS/CustomDrawExample/Form1.cs#L110

{
    if (e.Cell.HasFormula)
    {

how-to-customize-cell-appearance-in-wpf-spreadsheet-based-on-custom-logic-e4985/CS/CellTemplateSelectorExample/MainWindow.xaml.cs#L34

{
    string templateName = cell.HasFormula ? "FormulaTemplate" : "EmptyTemplate";
    return control.TryFindResource(templateName) as DataTemplate;

how-to-edit-rich-text-in-spreadsheetcontrol/CS/SpreadsheetRichText/Form1.cs#L46

Cell activeCell = spreadsheetControl.ActiveCell;
if (activeCell.Value.IsEmpty || (!activeCell.HasFormula && activeCell.Value.IsText))
{

VB.NET

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/VB/UDF_Discount/Form1.vb#L34

For Each cell As DevExpress.Spreadsheet.Cell In existingCells
    If cell.HasFormula Then
        ' The worksheet references functions from the DiscountXLL.MyFunctions xll Add-in.

xtraspreadsheet-custom-draw-examples-e5044/VB/CustomDrawExample/Form1.vb#L107

Private Sub spreadsheetControl1_CustomDrawCellBackground(ByVal sender As Object, ByVal e As CustomDrawCellBackgroundEventArgs)
    If e.Cell.HasFormula Then
        e.Handled = True

how-to-customize-cell-appearance-in-wpf-spreadsheet-based-on-custom-logic-e4985/VB/CellTemplateSelectorExample/MainWindow.xaml.vb#L30

Private Function GetCellTemplate(ByVal cell As DevExpress.Spreadsheet.Cell, ByVal control As SpreadsheetControl) As DataTemplate
    Dim templateName As String = If(cell.HasFormula, "FormulaTemplate", "EmptyTemplate")
    Return TryCast(control.TryFindResource(templateName), DataTemplate)

how-to-edit-rich-text-in-spreadsheetcontrol/VB/SpreadsheetRichText/Form1.vb#L40

Dim activeCell As Cell = spreadsheetControl.ActiveCell
If activeCell.Value.IsEmpty OrElse (Not activeCell.HasFormula AndAlso activeCell.Value.IsText) Then
    Dim setRichTextItem As New SpreadsheetMenuItem("Set Rich Text", New EventHandler(AddressOf SetRichTextItemClick))