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:
