Formula Calculated Columns Example for WPF

Nevron NOV Grid for WPF ships with hundreds of examples with full source code, as part of the Nevron Open Vision Suite. All WPF Grid examples are also available as a stand-alone Visual Studio solution in C# and VB.NET, which you can download from the links below.

Formula Calculated Columns Example for WPF Description

Demonstrates formula calculated columns.

Formula calculated columns are columns whose row values are not obtained from the data source, but are dynamically calculated via a user-specified formula, that can reference data source field values. Formula calculated columns are represented by the NFormulaCalculatedColumn class.

In the example the Total column is a formula calculated column that is calculated via the {Price*Quantity} formula.


Formula Calculated Columns Example

C# Formula Calculated Columns Example Code for Nevron Grid for WPF
Language: C#

using Nevron.Nov;
using Nevron.Nov.Data;
using Nevron.Nov.DataStructures;
using Nevron.Nov.Dom;
using Nevron.Nov.Editors;
using Nevron.Nov.Graphics;
using Nevron.Nov.Grid;
using Nevron.Nov.Layout;
using Nevron.Nov.Presentation;
using Nevron.Nov.UI;
using Nevron.Nov.Windows.Forms;
using System;
using System.Windows.Forms;

namespace NovWinFormsProject
{
	public partial class Form1 : Form
	{
		#region Constructors

		public Form1()
		{
			InitializeComponent();

			// Set form title
			Text = "NOV WinForms - NFormulaCalculatedColumnsExample";

			// Create the NOV example and its controls
			NWidget exampleContent = CreateExampleContent();
			NWidget exampleControls = CreateExampleControls();
			if (exampleControls != null)
			{
				exampleControls.PreferredWidth = 300;
			}

			// Place the example and its controls in a pair box
			NPairBox pairBox = new NPairBox(exampleContent, exampleControls);
			pairBox.FillMode = ENStackFillMode.First;
			pairBox.FitMode = ENStackFitMode.First;
			pairBox.Margins = new NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing);

			// Host the example in the form
			NNovWidgetHost host = new NNovWidgetHost(pairBox);
			host.Dock = DockStyle.Fill;
			Controls.Add(host);
		}

		#endregion

        #region Example

        public NWidget CreateExampleContent()
        {
            m_GridView = new NTableGridView();
            NTableGrid grid = m_GridView.Grid;

            // bind the grid to the data source
            grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource();

            // add a formula column
            m_TotalColumn = new NFormulaCalculatedColumn();
            m_TotalColumn.Title = "Total";
            string fx = grid.CreateFormulaFieldName("Price") + "*" + grid.CreateFormulaFieldName("Quantity");
            m_TotalColumn.Formula = fx;
            m_TotalColumn.Format.BackgroundFill = new NColorFill(NColor.SeaShell); 
            grid.Columns.Add(m_TotalColumn);

            return m_GridView;
        }
        public NWidget CreateExampleControls()
        {
            NStackPanel stack = new NStackPanel();

            NList editors = NDesigner.GetDesigner(m_TotalColumn).CreateMemberEditors(
                m_TotalColumn,
                NFormulaCalculatedColumn.FormulaProperty);

            for (int i = 0; i < editors.Count; i++)
            {
                stack.Add(editors[i]);
            }

            return stack;
        }
        public string GetExampleDescription()
        {
            return @"

Demonstrates formula calculated columns.

Formula calculated columns are columns whose row values are not obtained from the data source, but are dynamically calculated via a user-specified formula, that can reference data source field values. Formula calculated columns are represented by the NFormulaCalculatedColumn class.

In the example the Total column is a formula calculated column that is calculated via the {Price*Quantity} formula.

"; } /// /// Gets the relevant documentation links for the example /// /// public (string Name, string Url)[] GetDocumentationUrls() { return new[] { ("Grid Calculated Columns", "https://www.nevron.com/docs/openvision/grid-calculated-columns.html"), ("Formula Basics", "https://www.nevron.com/docs/openvision/formula-basics.html"), ("Functions", "https://www.nevron.com/docs/openvision/formula-functions.html"), ("Grid Row Values", "https://www.nevron.com/docs/openvision/grid-row-values.html"), }; } #endregion #region Implementation #endregion #region Event Handlers #endregion #region Fields NTableGridView m_GridView; NFormulaCalculatedColumn m_TotalColumn; #endregion #region Static Methods #endregion #region Constants #endregion #region Nested Types #endregion } }

Download a fully functional C# (.cs) Formula Calculated Columns Example for WPF Solution

VB.NET Formula Calculated Columns Example Code for Nevron Grid for WPF
Language: VB.NET

Imports Nevron.Nov
Imports Nevron.Nov.Dom
Imports Nevron.Nov.Editors
Imports Nevron.Nov.Graphics
Imports Nevron.Nov.Grid
Imports Nevron.Nov.Layout
Imports Nevron.Nov.UI
Imports Nevron.Nov.Windows.Wpf

Class MainWindow

#Region "Constructors"

	Public Sub New()
		' This call is required by the designer.
		InitializeComponent()

		' Add any initialization after the InitializeComponent() call.

		' Set form title
		Title = "NOV WPF - NFormulaCalculatedColumnsExample"

		' Create the NOV example and its controls
		Dim exampleContent As NWidget = CreateExampleContent()
		Dim exampleControls As NWidget = CreateExampleControls()
		If Not exampleControls Is Nothing Then
			exampleControls.PreferredWidth = 300
		End If

		' Place the example and its controls in a pair box
		Dim pairBox As NPairBox = New NPairBox(exampleContent, exampleControls)
		pairBox.FillMode = ENStackFillMode.First
		pairBox.FitMode = ENStackFitMode.First
		pairBox.Margins = New NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing)

		' Host the example in the form
		Dim host As NNovWidgetHost(Of NWidget) = New NNovWidgetHost(Of NWidget)(pairBox)
		Content = host
	End Sub


#End Region

#Region "Example"

        Public Function CreateExampleContent() As NWidget
            m_GridView = New NTableGridView()
            Dim grid = m_GridView.Grid

            ' bind the grid to the data source
            grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource()

            ' add a formula column
            m_TotalColumn = New NFormulaCalculatedColumn()
            m_TotalColumn.Title = "Total"
            Dim fx = grid.CreateFormulaFieldName("Price") & "*" & grid.CreateFormulaFieldName("Quantity")
            m_TotalColumn.Formula = fx
            m_TotalColumn.Format.BackgroundFill = New NColorFill(NColor.SeaShell)
            grid.Columns.Add(m_TotalColumn)

            Return m_GridView
        End Function
        Public Function CreateExampleControls() As NWidget
            Dim stack As NStackPanel = New NStackPanel()

            Dim editors = NDesigner.GetDesigner(m_TotalColumn).CreateMemberEditors(m_TotalColumn, NFormulaCalculatedColumn.FormulaProperty)

            For i = 0 To editors.Count - 1
                stack.Add(editors(i))
            Next

            Return stack
        End Function
        Public Function GetExampleDescription() As String
            Return "

Demonstrates formula calculated columns.

Formula calculated columns are columns whose row values are not obtained from the data source, but are dynamically calculated via a user-specified formula, that can reference data source field values. Formula calculated columns are represented by the NFormulaCalculatedColumn class.

In the example the Total column is a formula calculated column that is calculated via the {Price*Quantity} formula.

" End Function ''' ''' Gets the relevant documentation links for the example ''' ''' Public Function GetDocumentationUrls() As (String, String)() Return {("Grid Calculated Columns", "https://www.nevron.com/docs/openvision/grid-calculated-columns.html"), ("Formula Basics", "https://www.nevron.com/docs/openvision/formula-basics.html"), ("Functions", "https://www.nevron.com/docs/openvision/formula-functions.html"), ("Grid Row Values", "https://www.nevron.com/docs/openvision/grid-row-values.html")} End Function #End Region #Region "Implementation" #End Region #Region "Event Handlers" #End Region #Region "Fields" Private m_GridView As NTableGridView Private m_TotalColumn As NFormulaCalculatedColumn #End Region #Region "Static Methods" #End Region #Region "Constants" #End Region #Region "Nested Types" #End Region End Class

Download a fully functional VB.NET (.vb) Formula Calculated Columns Example for WPF Solution