Typical Applications

Introduction

A broad and flexible array of features makes EditTable particularly suitable for use in applications such as the ones discussed below.



Figure 12: Examples of EditTable Applications

Spreadsheets

EditTable can be used to build spreadsheets that are more specialized and powerful that those provided by general-purpose spreadsheet programs. EditTable lets you use the full capabilities of C or C++, including any C-compatible data types, and have complete control of cell editing, display, and data validation.

The widget's efficient data handling capabilities make it uniquely qualified to handle the display and analysis of large data sets such as those found in financial and scientific applications.

Real-time Monitoring and Analysis

The EditTable widget can be used for monitoring and analysis of real-time data, including:

Applications like these use EditTable's flexible color controls to indicate cells with out-of-range or alarm conditions. EditTable provides the features you need to build multiple widgets that share data - for example, a spreadsheet and plot that automatically update each other.


Figure 13: Example of Real-Time Data Monitoring

Data Entry and Validation

EditTable is especially suited for applications that require intensive data entry. The application can specify which cells are editable or protected. Users can edit cells directly using backspace/retype or cut/copy/paste features. All data can be checked for accuracy or violation of certain minimum/maximum ranges immediately as the user finishes an entry or later when the entire table is saved. When used with the INT scroll widget (XintScroll) multiple tables can be scrolled simultaneously for easier viewing and editing.

Database Display and Browsing

EditTable can be used as browser for relational or flat-file databases. This capability is especially useful for viewing the actual data structure, since EditTable lets you view individual data fields in their native formats (hex, string, float, etc.) or in various converted formats controlled by the application. Selective freezing and scrolling of different rows or columns makes it easy to compare data in any part of the database to certain reference fields.