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.

| 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
}
} | 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