Banded Table View - advanced grid view by which you can group column's headers, combining them into bands thereby creating hierarchical view of columns. The view is easy to configure. To group several columns into one hierarchy, you just need to create a special band-column that does no have any data connection (binding) and assign it as a parent for a regular column.

For column's headers in this type of grid, in addition to the standard settings for color, visual position and visibility, it is possible to customize the row number on which the column's header is located, to positioning the header one under the other and ability to span the column's headers to several rows.

View Zooming allows to increase or decrease instantly the size of the grid's view by proportional increasing or decreasing the size of the font within the cells and elements of the grid. This can be done by pressing a combination of keys Ctrl+Plus, Ctrl+Minus or from code.

By default, all columns in the grid are positioned horizontally on the line. However, our grid allows you to arrange the column headers vertically. This feature is in demand when the table has many columns and if they are arranged vertically, the end-user will have access to more information on one screen without scrolling. The grid in which the columns are arranged vertically is often called - Vertical Grid.

Sometimes it becomes necessary to provide the end-user with tabular data in the form of a card. It can be done easily using our grid if you activate Card View in it. A row of table data will turn into a card, each field will have its own header. The cells are arranged vertically. The order of the fileds controlled by visual index that can be changed programmatically or using the end-user drag-drop operation.

This feature is under development at the moment. Please let us know if this feature is require for your project as soon as possible - This email address is being protected from spambots. You need JavaScript enabled to view it.

This feature is under development at the moment. Please let us know if this feature is require for your project as soon as possible - This email address is being protected from spambots. You need JavaScript enabled to view it.

The grid implements a mechanism for saving many different settings into to the XML file performed by the end-user in runtime. Using such XML you can restore the state of the grid. Currently, XML stores the settings for view layout (visual index, visibility, band index and etc.), fixed rows/columns, state of filters, state for grouping and sorting.

This feature is under development at the moment. Please let us know if this feature is require for your project as soon as possible - This email address is being protected from spambots. You need JavaScript enabled to view it.

Sorting algorithm is operated at the grid level and does not require any manipulation with the data source. No additional database queries are being performed. You can easily sort by any column, a set of columns and even by columns that are currently being used for grouping. To sort data by several columns, press and hold down the "Control" key during sorting. To cancel sorting by a specific column while preserving all other sorting criteria, press and hold down "Shift" during sorting.

QtitanDataGrid allows you to group your data by any column on the view. Grouping can be enabled directly from the code or manually by dragging the column to grid's header panel like Microsoft Outlook does. Grouping can have multiple nesting levels, but no less than the total number of columns minus 1. You can also lock or unlock specific columns for grouping. This operation can be programmed in the code, so that the end-user has a ready to use view. Additional cool feature, you can highlight with the different color each group's level.

QtitanDataGrid can work with any class derived from QAbstractItemModel as a data source model. In addition to the data, our grid requests from the model the settings for decorating the cells that are behind the roles - Qt::FontRole, Qt::TextAlignmentRole, Qt::BackgroundRole, Qt::BackgroundColorRole, Qt::ForegroundRole, Qt::TextColorRole.

The grid has a large set of features so that the user can quickly hide or re-show the desired columns. This can be done using a special popup "Quick Columns Customization", using the "Field Chooser" window or using drag-drag operation - just drag and drop column outside the view to hide it. From the code, it's easy to control the visibility of the column using the "Visible" property.

Microsoft Outlook Grouping - specially designed mode to emulate the behavior and appearance that you can observe in Outlook Express when make a grouping for the messages. For this mode we changes slightly the height of the group rows and remove the indent on the left side of view.

Frozen Rows - feature allows you to pin some rows at the top or bottom of the grid view, so that they are always in front of the end-user. These rows cannot be scrolled vertically. You can freeze columns and rows at the same time. Features do not conflict with each other and can work simultaneously. Frozen rows participate in sorting, but do not participate in grouping.

QtitanDataGrid now enables you to add frozen columns or bands to either side of the grid view. These fixed elements cannot be scrolled horizontally and are always in the user’s visible area. These columns can only be dragged within the limits of their fixation area to prevent breaking the UI layout or column order recommended by the author of the program. When a summary is shown for a fixed column, summary cells are also fixed.

Apart from automatic column width adjustment, grid will also help you automatically change the height of grid rows. If this option is enabled, the component determines the maximum cell height in the grid and changes the height of all other cells to this value for an even, uniform look of the grid. For the Banded Table View, this function will be disabled if the number of occupied rows (RowSpan property) in either of the columns is more than 1.

Note that if you are using the Per-Pixels vertical scrolling mode, the grid will have to calculate the height of each potentially visible row. If the number of rows is very high (over 1000, for instance), this may result in degraded performance and delays whenever the content or width of the grid cells is changed. We strongly recommend switching to the normal scrolling mode (Per-Items) in such cases.

Both Table View and Banded Table View support automatic adjustment of columns width. This algorithm was written with usability and UI ergonomics in mind to minimize your involvement in the process and provide you with a clean, neat and good-looking output data grid that requires little to no changes. In the Banded Table View, if a column and a band have a single vertical border, it does matter what element is being changed. If the band width is changed, the width of each column or band within the parent band will be recalculated in the same proportion. If the column width is changed, it will only change the width of this column and the parent band. These techniques give developers more flexibility in terms of configuring data presentation in their applications.

Like Microsoft Office our Grid allows showing additional information in the Preview Row for displaying more detailed info regarding the row with expand or collapse options.

The "new row" is located in-place and you do not need to create an additional form for new data. While the new row is filling, the grid highlights the place where a new row will be added inside the view (displayed as normal row but translucent. Or it may flash, it is configured separately). For example, if you change the data in the column by which sorting is enabled, then the place where the row appears will be changing and the end-user will see this and can analyze neighboring data.

To remove the row, the end-user can use the context menu by pressing the right mouse button on the specified row and selecting the corresponding menu item.

Our Qt (C++) grid includes a rich set of editors for editing values in the grid's cell. Using a minimum of settings, you can edit integers, floating-point numbers, strings, time and date values as well as use universal editors for editing - checkbox, combobox, progress bar, editor for pictures and icons, blobs and massive blocks of text with formatting. For advanced users, we provide a cell interface that allows you to implement absolutely any editor logic and even embed your own QWidget control into the cell for editing.

A set of events from the grid allows you to check the entered data before placing it in the data source. For example, you can check the format of the entered value and correct it for end-user if the format of value does not match. Or ask the end-user to re-enter the value.

A pop-up window that is opened by clicking on the filter icon on the column header and contains a list of values that are existing in grid cells in this column. You can select one or more values and show only those rows that contain the selected values in the current column.

To colorize the summary-cell or change the result text, the grid provides a number of events in the handler of which you can customize the appearance of cells with the summaries based on your preferences.

Several API interfaces allow you to create a filter of any complexity and apply it to the grid from your app code. You can use either the classes provided by the grid for standard conditions - equal, not equal, more, less, and so on, or make a new implementation for these interfaces in which to implement functions for comparing values and generating a string representation (it is how the filter will be displayed to the end-user at the filter panel or in the filter history).

Aggregate data can be configured to calculate within a group of rows, after grouping by column. For such summaries, only the values from the shared group take part. The summary-cells are located at the footer of the grouped rows. However, there is a option that allows to change the layout of a group row and place cells with summaries on it, instead of the footer.

For your convenience, our grid provides a mechanism for summary calculation for values around the data set. You can show the end-user the sum of values, maximum value, minimum value, average value in the column. End-user can change the type of calculation from the pop-up menu, which appears by pressing the right button on the cell with the summary.

The following summary types are supported by QtitanDataGrid widget:

• Min (minimal value in the column)
• Max (maximum value in the column)
• Sum (the sum of all column values)
• Count (the number of all column values)
• Avg (the average value of all column values)

Once the summary is calculated, you can change the output value or format the text to be shown in the summary cell. This possibility may come in handy if you want to make the result clearer for the end user – for instance, to add a currency identifier for all money amounts a column.

"Ctrl + F" and the end-user will see a panel for quick search the data in the grid. Founded text is highlighted. End-user can also hide rows that do not contain the search text. Navigation buttons allow to move the focus to the cell with the founded text forward or backward.

Any filter superimposed on the grid can be edited in the filter editor. You can add new conditions, change the values and comparison operators. The editor can be called from the footer filter panel or programmatically from the source code.

The grid keeps a history of filters that have been applied to the grid view. To the filter history fall the filter's conditions from Excel-like filter, Filter Dialog or any user-defined conditions from source code. You can re-assign any previous filter through a convenient filter history window.

Filter Dialog is an intuitive mechanism to add conditions for rows filtering into the grid. Activated by Control+Shift+F or via the context menu by the right mouse button. The dialog allows you to create a filter from scratch or add more conditions to an already active filter.

Being an advanced Qt widget, QtitanDataGrid has its own paint engine that facilitates the rendering of basic geometric primitives. The purpose of this engine is to increase the rendering speed of basic UI elements while preserving the same level of intuitiveness, clarity, expandability and readability of the framework. This intelligent engine only renders the elements that need to be updated at the moment and are in the visible area of the form, thus saving resources and providing end users with a much more enjoyable grid browsing experience. The parts that require substantial time for rendering can be buffered.

Optimizing Scrolling Performance method is designed to speed up the rendering of cells during scrolling. The idea is that the grid displays only the frame of cells at the first time. Data is not retrived from the data source and not displayed. If the scrolling ended at this point, then during the second rendering iteration the data is retrived and displayed with a pleasant fade-effect. If scrolling continues, then new cells are drawn at this place and again without data. This happens until scrolling is over.

Virtual rows mode used in the our grid allows to display and scroll hundreds of thousands rows with data without lost in performance and memory usage. For the grid does not matter how many rows of data you need to process. 100 or 100000+, they will be processed with the same ease. Performance is limited only by the data source not the grid.

To display the contents and elements, QtitanDataGrid uses a native Qt styles (QStyle) from the QApplication object or from style that being connected to the QWidget directly. This contributes to seamless mesh integration into your application. Despite this, the grid provides the ability to customize the icons and color palette of important elements.

QtitanDataGrid was initially designed as a cross-platform component intended for desktop applications. The primary focus of development was on code quality and functionality. Grid for now can be used for Windows and Mac OS. The component is well tested and targeted to work on 32 or 64 bit platforms as you wish.

The grid is fully adapted for use in Python applications based on Qt PySide2. By default, Python version number 3.x is used. But Python bindings can be re-compilled for Python 2.7 too. Configuration scripts are reconfigured easily. They are made on the basis of QMake script.

TreeView - Grid view allows to show data as a tree. In this case the classic table column headings are used.

BandedTreeView - Grid view allows to show data as a tree with ability to unite the column headers to the bands.