NOV Grid for .NET について

データを表形式で表示して編集するための優れたデータグリッドコンポーネント

NOV Grid for .NET is a high performance Data Grid component for displaying and editing tabular data within your WinForms, WPF, Blazor and Xamarin.Mac applications. The NOV Grid includes a TableGrid and a TreeGrid (ListTreeView) with many advanced features for editing, navigation, seamless databinding and more.

NOV Grid for .NET features:

  • Great performance.
  • Binding to diverse set of data sources.
  • Grouping, Sorting, Filtering.
  • Master - Detail.
  • Hierarchical View.
  • Calculated Columns.
  • Frozen rows and columns.
  • Column reordering and resizing.
  • Row resizing.
  • Conditional column formatting.
  • Null values support.
  • In-place editing.
  • Selection and navigation.
  • NOV Widget Hosting.

NOV Grid is part of Open Vision for .NET Professional Edition.

Binding to diverse set of data sources
NOV Grid for .NET provides support for data-binding to many sets of data sources. The Grid displays data from a data source assigned to it's DataSource property. A data source is an attribute that aggregates a Data Table. Data Tables help you define data in-memory, or bind to different collections of objects. You can work with all types of data tables in a consistent and intuitive manner. The Data Table exposes various operations that help you add/remove fields and rows, get or set cell values as well as perform different queries.

Optimized for high performance
With NOV Grid for .NET you can load 1M+ records (million records) without compromising performance. The Grid allows end-users to perform Smooth Scrolling, Grouping, Sorting and Filtering on hundreds of thousands of records instantly, without lags or delays.

Data Processing
Filtering, Grouping, Sorting - The NOV Grid for .NET data processing capabilities allow you to easily perform Filtering, Grouping, Sorting or Self-Referencing operations on your data. Both the Table Grid and Tree Grid are performing the Filtering and Sorting processes, however the order of the data processing algorithm is different for each type of grid. Following is an overview of the data processing algorithm for each type of grid:

  • The Table Grid allows Filtering, Grouping and Sorting.
  • The Tree Grid allows Filtering, Self-Referencing and Sorting.

Master - Details
Allows you to display additional information (details) for each record data row.

Calculated Columns
Unlike Data Columns, calculated columns do not show a specific data source field. Instead it is a user responsibility to define a value for each data source row. Typically this value is a product of other data source fields. Calculated columns can also be used when you want to extract information about a specific data row from another data source. There are two types of calculated columns:

  • Formula Calculated Column - this is a calculated column that is defined as a formula. The value that this column assigns to each row is the result of a formula evaluation, where you can use other column values.
  • Custom Calculated Column - this is a calculated column that calls a user handled delegate to obtain a row value on-demand.

Filtering, Grouping and Sorting can be performed on the calculated columns.

Column Conditional Formatting
Column Conditional Formatting helps you format certain data cell views, according to specific rules. NOV Grid for .NET provides strong support for authoring complex cell conditions as well as support for gradient background and text fill declarations, that can be defined as a two color or three color gradient.

Column Formats
The NOV Grid Column Format allows the modification of the visualization of the data cell value. Generally, the Column Formats are logically divided into two categories:

  • Default Column Formats - these are the standard column formats that the grid by default uses, for specific row values types.
  • Extended Column Formats - these are column formats that the grid does not use by default, but you can manually assign to certain columns.

NOV Grid also provides support for Custom Column Formatting - this allows you to use any NOV widget to represent the row values e.g. Charts, Gauges, Barcodes, or other widgets.

Column Reordering and Resizing
Resizing Grid columns - the width of the column can be determined in several ways:

  • Auto.
  • Fixed.
  • Size To Cells.
  • Size To Header.
  • Percent.

Users can also resize the columns or double-click the column separators to "best fit" the columns.
Reordering Grid columns – allows the user to change the order of the columns by dragging them.

Grid Frozen Columns and Frozen Rows
Frozen Columns can be frozen to the left or right side of the grid window area. Frozen Rows appear pinned to the column headers and they are controlled by the FrozenRows grid property. It specifies the count of rows from the top of the grid, that are non-scrollable.

Grid Protection and Column Protection
Grid protection refers to the set of properties that can help you restrict the user to perform certain actions with the grid in general. For operations that apply to columns, there is also a respective Column Protection property that can restrict the same operation for a specific column only.

Support for Null Values
NOV Grid for .NET provides support for Null Values as well as support for editing null values.

Grid Selection
The Grid selection is organized to work around grid rows and to maintain the notion of a Current Row and Current Cell. Selection can be configured to operate in two modes via its Mode property:

  • Single - only a single row can be selected.
  • Multiple - multiple rows can be selected.

The Grid selection is also responsible for performing a variety of navigation commands that can alter the current cell, select/deselect rows and also change the current cell. The selection also exposes properties that control the events that trigger the current cell editing.

Grid Alternating Rows
The Grid alternating rows are useful when you need to display grids with many columns, since the user can easily follow the values that belong to the same row. Alternating rows increase the readability of the grid. NOV Grid for .NET provides full control over the alternating rows appearance, interval and length.

Gridlines
NOV Grid for .NET features several types of gridlines that are displayed by the Grid cells, Columns and Row Headers:

  • Grid Gridlines - the gridlines that separate the rows and data cells.
  • Columns Gridlines - Top Gridline, Bottom Gridline and Vertical Columns Gridlines.
  • Row Headers Gridlines - Left Gridline, Right Gridline and Horizontal Row Headers Gridlines.

NOV Grid provides full control over the appearance of the gridlines stroke.

Right-to-Left and Localization Support
NOV Grid for .NET provides full localization support and right-to-left support. The NOV Framework Localization support allows you to translate the entire user interface (UI) of your applications.

NOV Widget Hosting
The architecture of the NOV Framework allows you to host any NOV Widget into other NOV Widget. This allows you to use NOV widgets to represent the Grid row values, for example Charts, Gauges, Barcodes, or other widgets.