FlexSheet for WPF | ComponentOne
Working with C1FlexSheet / Using Formulas
In This Topic
    Using Formulas
    In This Topic

    To perform calculations in cells, you can enter formulas in the FormulaBar control bound with the FlexSheet control. Binding the C1FormulaBar with C1FlexSheet enables you to perform calculations using Excel-style formulas.

    You can bind C1FormulaBar with C1FlexSheet using the following code:

    XAML
    Copy Code
    <c1:C1FormulaBar Name="formula_Bar" Width="300" HorizontalAlignment="Left" VerticalAlignment="Top" FlexSheet="{Binding ElementName=flex, Mode=OneWay}"/>
    

    Enter a simple function such as SUM at run time to add values of different cells and see the use of formulas as shown in the image below:
    Using C1FormulaBar