ExpressGridPack 19.1.2

Released: Jun 18, 2019

Updates in 19.1.2

Features

Right-To-Left Support

  • This release adds Right-to-Left (RTL) support to the following DevExpress VCL components:
    • Pivot Grid Control
    • Vertical Grid Control

Filtering UI

  • Excel-inspired Filtering - v19.1 introduces new Microsoft Excel-inspired column/row filter dropdowns for the Grid, TreeList, and Vertical Grid controls. New filter dropdowns provide two tabs:
    • The first tab allows users to select from among all available cell values.
    • The second tab allows users to create a filter expression using filter operators (Equals, Between, Contains, etc.)
  • Use the dxDefaultFilterPopupWindowMode global constant in the source code to make the new filtering UI active for all Grid, TreeList, and Vertical Grid controls.
  • Filter Box Support - Much like the VCL Grid Control, the TreeList and Vertical Grid controls now provide the Filter Box to allow end-users to customize, temporarily disable, and reapply recently used filter criteria.

Skins Library

  • New SVG Office 2019 Colorful Skin - This release ships with a new vector-based skin and associated color palettes - Office 2019 Colorful.

Spreadsheet

  • API Enhancements
    • Evaluate any formula expressions, not only those stored in a document (the EvaluateExpression function).
    • Pass cell ranges in the A1 reference style as string parameters to any cell management method.
    • Track visibility changes of cell comments and prevent their display (the OnCommentShow and OnCommentHide events).
    • Quickly reset a cell, row, or column to its default style (the IsDefault property).
    • Read/write the rich text formatted content directly from/to a cell (the GetAsRTF and SetAsRTF functions).

Pivot Grid

  • A new field option automatically expands group values and keeps them expanded (the AlwaysExpanded property).
  • You can now apply the Min and Max summary functions to date-time or string data fields.
  • A new event (OnGetCellHint) allows you to customize hints displayed for data cells, field values, and field headers, or suppress them.
  • The HitTest property now provides a flag to identify total cells (the HitAtTotalCell property).

Layout Control

  • End-users can now collapse/expand splitter items to temporarily hide a part of a layout with a mouse click or drag and drop.
  • Splitter items now provide an event (OnCanResize) that allows you to dynamically control size operations.