Skip to main content
All docs
V24.2

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

ExplainFormulaBehavior Class

Generates a detailed explanation of the formula used in a worksheet cell (which clarifies its purpose and function).

Namespace: DevExpress.AIIntegration.Wpf

Assembly: DevExpress.AIIntegration.Wpf.v24.2.dll

NuGet Package: DevExpress.AIIntegration.Wpf

#Declaration

public class ExplainFormulaBehavior :
    TextModificationBehavior

#Remarks

To enable the “Explain Formula” functionality in a DevExpress WPF Spreadsheet control, add mvvm and ai namespaces to the Window and attach ExplainFormulaBehavior to the Spreadsheet control:

<dx:ThemedWindow
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core"
    xmlns:dxsps="http://schemas.devexpress.com/winfx/2008/xaml/spreadsheet"
    xmlns:dxmvvm="http://schemas.devexpress.com/winfx/2008/xaml/mvvm" 
    xmlns:dxai="http://schemas.devexpress.com/winfx/2008/xaml/ai"
    x:Class="AIAssistant.MainWindow"
    Title="MainWindow" Height="800" Width="800">
    <Grid>
        <dxsps:SpreadsheetControl CommandBarStyle="Ribbon" ShowStatusBar="True" ShowFormulaBar="True">
            <dxmvvm:Interaction.Behaviors>
                <dxai:ExplainFormulaBehavior x:Name="ExplainFormula"/>
            </dxmvvm:Interaction.Behaviors>
        </dxsps:SpreadsheetControl>
    </Grid>
</dx:ThemedWindow>

Read the following class description for additional information: ExplainFormulaBehavior Class.

#Inheritance

Show 12 items
Object
DispatcherObject
DependencyObject
Freezable
Animatable
DevExpress.Mvvm.UI.Interactivity.AttachableObjectBase
DevExpress.Mvvm.UI.Interactivity.Behavior
DevExpress.Mvvm.UI.Interactivity.Behavior<DependencyObject>
DevExpress.AIIntegration.Wpf.Internal.AIBehavior
DevExpress.AIIntegration.Wpf.Internal.TextBehaviorBase<DevExpress.AIIntegration.Wpf.Internal.ITextModificationBehaviorSource, DevExpress.AIIntegration.Wpf.Internal.CustomRequestViewModel>
DevExpress.AIIntegration.Wpf.Internal.TextModificationBehavior
ExplainFormulaBehavior
See Also