ExpressGridPack 19.1.2

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 Microsoft 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.