+ Ускорение загрузки данных в TXlsMemFileEh
+ Изменение подсветки выделенных ячеек в DBGridEh
+ Диалог настройки колонок грида DBGridEh
+ Возможность в DBGridEh отображения ячейки как кнопки
+ Новые свойства в классе TCellButtonEh и новые возможности отображения CellButtons в ячейках грида
+ Новые функции и особенности в классе TDBSumList

+ Компоненты для сводного анализа данных: PivotGridEh, PivotDataSourceEh, PivotGridToolBoxEh

+ SearchPanel - Поиск и фильтрация по месту, напрямую в ячейке грида
+ Расширенная фильтрация выпадающих списков в компонентах TDBComboboxEh и TDBLookupComboboxEh
+ Событие при печати ячеек грида TPrintDBGridEh.OnPrintDataCell
+ Тонкая настройка формирования строки фильтра DBGridEh.STFilter для DataSet’а через компонент TDatasetFeaturesEh

+ Новая выпадающая DropDown форма фильтрации для колонок типа DateTime с иерархическим разделением по разделам даты/времени
+ Добавлена возможность группировки данных в DataGridEh с использованием столбцов в качестве критерия группировки.

+ Новый вид отображения данных в TPlannerEh - годовой период в разрезе по дням.
+ В DBGridEh возможность сохранения фильтров через SettingsKeeper, указанных в разделе STFilter.
+ Генератор Xlsx файлов.
+ Поддержка экспорта DBGridEh и DBVertGridEh в Xlsx файлы в Lazarus в режиме Win32/64 и CrossPlatform.

+ Поддержка ARC (Automatic Reference Counting) Delphi компиляторов
+ Совместимость с библиотекой CrossVCL. Теперь вы можете создавать GUI приложения под OS X и Linux на основе VCL проектов.
+ Технология сохранения настроек - SettingsKeeper
+ Анимация при перемещении столбцов в DBGridEh

+ Новое окно DropDown календаря с поддержкой ввода даты и времени
+ Подсветка праздников, выходных и текущего дня в компоненте TPlannerCalendarPickerEh
+ Подсветка текущего дня и текущего времени в компоненте TPlannerControlEh
+ AllowedOperations в компоненте TPlannerControlEh
+ Статус ReadOnly в TPlannerControlEh и TPlannerDataItemEh
+ Делитель времени на 5, 6, 10, 15, 30 и 60 минут в компонентах TPlannerDayViewEh и TPlannerWeekViewEh
+ Новые свойства и события в компонентах TPlannerXXXViewEh (TPlannerDayViewEh, TPlannerWeekViewEh …)
+ Коллекция CellButtons в колонках DBGridEh и строках DBVertGridEh для создания кнопок в ячейках грида работающих без активации текстового редактора InplaceEditor
+ Режим поиска "Начинается с" в SearchPanel
+ Выбор записей в режиме DBGridEh.DataGrouping нажатием на групповую запись в разделе столбца индикатора

+ Bookmark’и как указатели на запись в TMemTableEh
+ Печать компонент TDBVertGridEh, TPivotGridEh, TPlannerControlEh
+ Событие для настройки отображения хинтов для элементов плана.
+ Формирование списка элементов в окнах MRUList на основе списка уникальных значений поля DataSet'а.
+ Новые события в TDBGridEh.SearchPanel

+ Технология DropDownForms - пользовательские выпадающие окна.

Типичное DropDown окно - это список, который появляется в контроле TComboBox при нажатии на кнопку со стрелкой вниз внутри контрола.
Новая технология DropDropForms позволяет создавать формы, которые отображаются и работают аналогично выпадающему списку TComboBox. Эти формы можно выводить по нажатию на одну из кнопок редакторов внутри контролов TDBEditEh, TDBNumberEditEh, TInplaceEditor в DBGridEh и т.д.

Детальное описание работы с DropDownForms смотрите в файле <About EhLib 6.2 Rus.doc>, раздел DropDownForms и в примере:

<EhLib Archive>\Demos\DropDownForm\Project1.dpr

скомпилированный проект:

<EhLib Archive>\Demos\Bin\DropDownForm.Exe

Новые свойcтва для настройки отображения выпадающих форм появились в классах:
(Для DBGridEh)

TColumnEh.DropDownFormParam
TColumnEh.EditButtons[i].DropDownFormParam

(Для DBVertGridEh)

TFieldRowEh.DropDownFormParam
TFieldRowEh.EditButtons[i].DropDownFormParam

TDBEditEh.EditButton.DropDownFormParam
TDBEditEh.EditButtons[i].DropDownFormParam

В EditButtons для контролов TDBNumberEditEh, TDBDateTimeEditEh, TDBComboBoxEh, TDBLookupComboBoxEh.

(В DBVertGridEh)

+ Появилась возможность группировки строк по категориям. См. свойства TDBVertGridEh.RowCategories

Имя категории прописывается в свойстве TFieldRowEh.CategoryName
Строки можно группировать по: Названию категории, Типу поля или, Наличию/Отсутствию значения в поле текущей записи.

+ Появилась возможность сортировки строк по Заголовку поля. См. свойство TDBVertGridEh.RowsSortOrder.

(В DBGridEh)

+ В DBGridEh в Design-Time появилась возможность быстро создавать компоненты и присваивать свойства DataSource и DataSource.DataSet. Кликните правой кнопкой мышки над Design-Time панелью в нижнем правом углу грида и выберите необходимую операцию присваивания или создания компонента работы с табличными данными.

(В TIniPropStorageManEh)

* В методе TIniPropStorageManEh.WritePropertiesText изменен класс, используемый для записи данных в файл. Вместо TIniFile теперь используется TMemIniFile. Это значительно ускорило операцию записи в файл, но изменилось место сохранения файла, когда в свойстве IniFileName не указан полный путь. В новой версии файл будет сохраняться в текущую директорию вместо директории WINDOWS.

+ Added new components to service the access through the technology DataDrivers.
ConnectionProviders:

TADOConnectionProviderEh - this component provides interaction between the TADODataDriver and TADOConnection in Design-Time and Run-Time. It contains a built-in TADOConnection component. It specifies the type of the SQL server for the correct operation of the extra operations on the server, such as the value of the incremental the table fields after inserting records, etc.

Similar functions are performed by next components:

TDBXConnectionProviderEh to services the access through the DBX Engine.
TIBXConnectionProviderEh to services the access through the IBX Engine.
TBDEConnectionProviderEh to services the access through the BDE Engine.

+ Dynamic properties of the EhLib components - DynProps.
A collection of elements that implement the dynamic properties of the components and class libraries. Every control of EhLib have DynProps collection.

In the DBGridEh component:

+ Added new sort marking images and the sort order now depends of the type of the field.
+ Added ability to customize colors of dividing lines and to define presence/absence of lines in different areas of the grid.
+ Added opportunity of flexible customizing of drawing the grid headers.
+ Added opportunity of flexible customizing of rendering the footer.
+ Added opportunity of flexible customizing of the drawing area SubtitleFilter.
+ Added the ability to display the image data in the cells from the Bolb fields in the various graphic formats.
+ Added the ability to display a graphical background Image.
+ Added ability of the advanced search and filtering of data.
+ Added an extra panel in the horizontal scroll bar.
+ Added opportunity of flexible adjustment of the group title (DataGrouping).
+ Added ability to display summing rows in groups.
+ Added opportunity of flexible adjustment for the HideDuplicates values.
+ Added a new option in display elements of the tree structure.
+ Added the ability to filter data in the drop-down lookup lists when typing text.

In the component MemTableEh

+ Added an ability to change the internal structure of the array without data loss.
+ Added an ability to save/load data from/to a file (s).

- Closed support for Delphi and C++ Builder versions lower than 7.
+ Added support of Embarcadero RAD Studio XE3.

+ Added support of Embarcadero RAD Studio XE2.

+ ThemeTitleFillElement property add to the TDBGridEhStyle class. property ThemeTitleFillElement: TGridThemeTitleFillElementEh; TGridThemeTitleFillElementEh = (gtfeHeaderItemEh, gtfeSplitButtonEh); This property defines Themes element that will be used to fill the background
the grid titles when property TDBGridEh.Flat = False.

* TDBGridEh.Flat property has no effect of filling of then title background under RAD Studio XE2 when TStyleManager.IsCustomStyleActive is True. In this case the grid fills titles using Themes style that is defined by DBGridEhDefaultStyle.ThemeTitleFillElement property.

* The filling of the grid titles uses thHeaderItem Theme style rather then ttbSplitButton style from version EhLib 5.5. Set global property DBGridEhDefaultStyle.ThemeTitleFillElement to gtfeSplitButtonEh for filling the title in the old style.

+ Added support of Embarcadero RAD Studio XE

+ Added Options property in MemTableEh of TMemTableOptionsEh type.
TMemTableOptionsEh = set of TMemTableOptionEh;
TMemTableOptionEh = (mtoTextFieldsCaseInsensitive);
mtoTextFieldsCaseInsensitive - Defines whether string fields should be compared in a case-sensitive or case-insensitive manner when data is sorting and filtering.

+ Added printing of grouped data in TPrintDBGridEh when Grid.DataGrouping is active. Use TPrintDBGridEh component to print and preview data.

+ Added CommandTimeout property in TADOCommandEh component.

* The type of RowPanel property was changed. Instead of Boolean type, now it is an object property with subproperies:
Active: Boolean - Defines if it is possible to place cells under each over and if every propetry can have personal hight.
+ NavKeysNavigationType: defines the order of navigation over cells in the grid when keys Up, Down, Left, Right are pressed.
+ TabNavigationType: defines an order of going through cells of the grid by Tab key

+ A program for automatically installing library in Delphi/C++ Builder IDE is added. In time of installation the program creates folder, copies files, compile required packages and register packages in the IDE.

+ crpRowPanelColPlacementEh value is added in TColumnEhRestoreParam type, grpRowPanelColPlacementEh values is added in TDBGridEhRestoreParam type. Now, procedure RestoreGridLayout can restore cell positions then RowPanel is active.

+ Propery RowDetailPanelControl is added in public section. Use this property to add components on panel of detail information at RunTime. Use next code:
MyControl.Parent := DBGridEh1.RowDetailPanelControl;

+ Next subproperties are added in propery Grid.STFilter:
InstantApply: Boolean - defines if filter will be applied on chanching or clising of droped down list of filtered values (STFilter).
Location: TSTFilterLocationEh - defines the location STFilter. Under the title (stflUnderTitleFilterEh) or in the title
(stflInTitleFilterEh). When in the title then STFilter doesn't support edit line to enter filter expression.

+ The interface of droped down list of SubTitleFilter was changed. Now it is allowed to select requaried values in the list unsing checkboxes. The Item (Custom...) was added in the list of commands of filter droped down list. When selected, the simple filter dialog appeares to enter filter expression.

+ When the list of items for droped down filter list is formed, the current filter takes in account (Only when grid is conneccted to TMemTableEh).

+ New event added in Grid (TDBGridEh.OnFillSTFilterListValues), in the grid column (TColumnEh.OnFillSTFilterListValues) and in the TDBGridEhCenter (TDBGridEhCenter.OnFillSTFilterListValues). You can use event to fill list of droped down list of STFilter cell.

+ Added support of Embarcadero RAD Studio 2010

+ Added possibility to move the columns in the grid at Design-Time.

+ Added possibility to select the column in the Object Inspector by clicking on header of column.

+ Added DrawGraphicData property of Boolean type. When property is True, the grid draws image from TBlobField with BlobType = ftGraphic in graphic mode.

+ Added OnGetRowHeight event. Write this event to set height of every data row in the grid. The Event is caused when data is changed in DataSet. The Event is caused only when the grid is connected to TMemTableEh and MemTable
not in the TreeView mode.

+ Added dghAutoFitRowHeight in TDBGridEhOption type (OptionsEh). In this mode the grid calculates height of lines dynamically using text in data cells for a columns that TColumnEh.WordWrap = True. This mode works only when
grid is connected to TMemTableEh and MemTable not in mode TreeView. Grid updates the height of the lines not in all cases. For instance, grid does not update the height of the lines when you change Grid.Font property. In this case you need to call Grid.UpdateAllDataRowHeights where it is necessary.

+ In the mode when dgRowSelect is in Options, scrollbar works in smooth mode. (The Step of runner is not limited by the ñolumn width).

+ Added dghColumnMove and dghColumnResize in TDBGridEhOption type (OptionsEh). Now you can control of resizing and moving of columns separately.

+ Added dghShowRecNo in TDBGridEhOption type (OptionsEh). Set this value to show record number in the indicator column. It works only for DataSet which IsSequenced = True.

+ Drawing of 3D title cells in Flat mode is changed. When ThemeServices.ThemesEnabled = True, grid draws 3D cells in gradient style.

* Some bugfixes.

+ Added support of Delphi 2007.

In DBGridEh
+ Added IndicatorTitle property of TDBGridEhIndicatorTitle type:
The Upper left cell can react as button, draw the badge-triangle, and display the dropdown menu on mouse clickling ( with possibility of drawing global menu, which adjust using global property - DBGridEhCenter.IndicatorTitleMenus and IndicatorTitleMenus.OnBuildIndicatorTitleMenu).

IndicatorTitle property has a next subprotperty:
DropdownMenu: TPopupMenu - The Local dropdown menu, appearing when you press the upper left cell of the grid.
ShowDropDownSign: Boolean - Specifies whether to draw the badge-triangle. You can set this property to show that the pressing on upper-left cell will show the droped down menu.
TitleButton: Boolean - Specifies whether the upper left cell will act as button. Besides the DropdownMenu will be droped down only when TitleButton = True.
UseGlobalMenu: Boolean - Specifies whether the global DBGridEhCenter.IndicatorTitleMenus property will be use when building menu.

Added OnIndicatorTitleMouseDown event. Occurs when the mouse click on the upper left cell of grid. The Cell must be adjusted in state of working as buttons (IndicatorTitle.TitleButton = True). You can call DefaultIndicatorTitleMouseDown
method in this event to pass control to a global object - DBGridEhCenter.

Added OnBuildIndicatorTitleMenu event. Occurs when need to build list of menus before menu is shown. You can call DefaultBuildIndicatorTitleMenu method in this event to pass control to a global object - DBGridEhCenter.

Added OnCellMouseClick event. Occurs when mouse click in any cell of grid.
Event pass coordinates of the cell and offset of the mouse for upper left corner of the cell. You can call DefaultCellMouseClick method in this event to pass control to a global object - DBGridEhCenter.

+ In module DBGridEh.Pas appeared the new global object DBGridEhCenter of TDBGridEhCenter type. This object is intended to manage a behaviour of all objects of TCustomGridEh type or inherited from it. For instance, in DBGridEhCenter you can specify the list a menu to be appearing in the drop-down menu of the all grids when clicking on top left grid cell. Besides, you may write the event of this global object and it will be caused at activations of the similar event in any grid of the project.

Global object - DBGridEhCenter has a following properties and events:
IndicatorTitleMenus: Is the list of menu, which will be formed when clicking on upper left cell of grid is occured. This property of the global object will work for all grids, which IndicatorTitle.TitleButton = True. (itmVisibleColumnsEh, itmCut, itmCopy, itmPaste, itmDelete, itmSelectAll).
OnBuildIndicatorTitleMenu: Occurs when need to build list of menus before menu is shown.
OnCellMouseClick: Occurs when mouse click in any cell of grid.
OnIndicatorTitleMouseDown: Occurs when mouse click upper left cell of grid.

+ Added global variable - DBGridEhCenter. This variable controls the part of behaviour of the grids. You can set properties, or events of this variable to change the behaviour of all grids.

Changes in the other objects and procedures.
* The Corrections in ADODataDriverEh, SelectCommand, UpdateCommand... properties now have a TADOCommandEh type.
* The parameters of OnAssignCommandParameter and OnGetBackUpdatedValues have been changed in ADODataDriverEh object.
* All dfm files stores data in the text type.
* Fixed drawing lines in the gride when TColumnEh.HideDuplicated = True.
* Fixed memory leaks in the search box TDBGridEhFindDlg.
* Fixed error in the search dialogue, when invisible columns is present.
* Added support ftWideMemo.
* Fixed error of the recirculation in TPrintDBGridEh component when printing the rows with height above of the page height.
* Fixed error when developer create new TDataDriver component on Form using Popup menu 'Create DataDriver...' of TMemTableEh components.
+ In TDBLookupComboboxEh, Added support of the Memo fields.
* Fixed error of entering values from previous record (using Ctrl+') when DBGridEh is connected to TMemTableEh.

* This version does not support Delphi 4 and C++ Builer 4 anymore.

+ New components:
TMemTableEh - dataset, which hold all data in memory.
TDataDriverEh - Delivers records in TMemTableEh and processes changed records.
TSQLDataDriverEh, TBDEDataDriverEh, TIBXDataDriverEh, TDBXDataDriverEh
and TADODataDriverEh

See detail info in AboutEhlib4_0.Txt of EhLib archive.

+ Added Action property or TBasicAction type in TEditButtonEh. So edit buttons
of the Edit controls can be associated with action.

+ In DBGridEh
When DBGridEh is connected to DataSet of TMemTable type it allows:
To view all data without moving active record.
To display a tree-type structure of TMemTable records.
To form list of values in dropdown list of SubTitle filter automatically.

+ Added HighlightRequired property in TDBEditEh, TDBDateTimeEditEh, TDBNumberEditEh, TDBLookupComboboxEh and TColumnEh, TColumnDefValuesEh. Determines whether need to draw dotted red line under the text editor for empty required field (when TField.Required = True and field is empty).

+ Added OnCheckDrawRequiredState event in TDBEditEh, TDBDateTimeEditEh, TDBNumberEditEh, TDBLookupComboboxEh and TColumnEh. Write event need to change if need to draw a condition RequiredState (dotted red line under the text editor).

In TColumnEh
+ Added property Layout: TTextLayout in TColumnEh. Specifies the vertical placement of the text within the grid cell.
+ Added property HideDuplicates: Boolean in TColumnEh. Determines whether to hide duplicated values in the column.

* Changed image of 3D borders in grid when the Windows XP themes active in application.

* Procedure ExcecuteDBGridEhFindDialog is renamed to ExecuteDBGridEhFindDialog.

* In AdvTech\MemTableEh: Added indexes and autogenerating the list of values for dropdown box in filter cells.

EhLib setup files for Evaluation version available for download in 'Downloads' area. Setup automatically deinstall previous version of EhLib packages from Delphi (BCB) IDE, install new version of packages and help files in IDE.

For TDBGridEh
+ Added new form 'DBGridEhFindDlgs' - find dialog in DBGridEh. Dialog allows to find text in the grid: In specified column or on whole grid; From any part of field, Whole field or From beging of the field. Set new dghDialogFind value to OptionsEh to allows find dialog in DBGridEh. Default shortcut to show find dialog in the grid is 'Ctrl-F'. When dghIncSearch also included in the OptionsEh then first pressing 'Ctrl-F' enters the grid in the Increment Search mode and holding 'Ctrl' press 'F' again to show the find dialog.

In TDBGridEh
+ Added dghDialogFind value to the TDBGridEhOption type (property OptionsEh).

In TSTColumnFilterEh
+ Added KeyField, ListField, ListSource properties. Now you can adjust combobox in SubTitle Filter cell. If Column.STFilter.ListSource is not empty then grid will create combobox for such filter cell. ListSource defines the list of values in drop-down list, ListField defines field whose values are displayed in drop-down list, KeyField identifies the field in the ListSource dataset whose value will takes to build filter expression.

In TSQLDatasetFeaturesEh
+ Added SupportsLocalLike property. Determines if the dataset supports 'Like' keyword in Filter property. Modules from DataService directory of EhLib archive rewrited to support this property.

In TMRUListEh
+ Added AutoAdd property of Boolean type. Determines that the edit control will add new Text in MRUList automagically when control loses focus. Default value for property is True. You can use it (set to False) to fill MRUList manually, for instance from database table.

* Some bugfixes.

EhLib home page is moved. Now, home page of ehlib is http://www.ehlib.com.

EhLib suppor e-mail is opened. support@ehlib.com

EhLib forum is opened - http://groups.yahoo.com/group/EhLib

Deployed EhLib 3.1

* Changes in TRegPropStorageManEh:
'Key' property moved from 'published' to 'public' part.
(C++ Builder does not support HKEY type in published part).

Added RegistryKey property of TRegistryKeyEh type.

+ Added (in source included version only) preview version of the TMemTableEh component. Dataset, which hold all its data in memory, furthermore can fetch data from other dataset's, unload changes
back to dataset and support special interface, that allow to view all data without changing active record.

See detail info in AdvTech\MemTableEh\readme.txt dir.

+ In DBGridEh: Added support of IMemTableEh interface in DataSet that allow to view all data, without changing active record.

+ Added Windows XP themes support (Only under Delphi 7).

+ Added (in source included version only) preview restricted version of EhLibCLX - EhLib under Borland Component Library for Cross-Platform.

+ Added (in source included version only) preview version of technology to store components properties to/from settings storage such as ini files, registry etc.

+ Added Delphi 7 support.

+ New units: CalculatorEh - TCalculatorEh, TPopupCalculatorEh
DbUtilsEh - Utilities to sort data in DataSet from DBGrid
EhLibADO - Register object that sort data in TADOQuery
EhLibBDE - Register object that sort data in TQuery
EhLibCDS - Register object that sort data in TCustomClientDataSet

In TDbGridEh
+ Added possiblity to sort data in DataSet after sorting markers will be changed. You have to add dlgAutoSortMarkingEh to OptionsEh, set TColumnEh.Title.TitleButton to True for required columns, keep OnSortMarkingChanged event empty, add one of the units EhLib... (EhLibADO, EhLibBDE, EhLibCDS) to 'uses' clause of any unit of your project. Now EhLib have objects to sort data in TClientDataSet, TQuery and TADOQuery. You have to write and register you own object to sort data in DataSet that not present in this list.

+ Added SortLocal property in TDBGridEh. Objects that sort data in DataSet can use this property to determine how to sort data, on client or on server.

+ Changed highlight coloring in TDBGridEh for multiselected cells and active cell when TDBGridEh have not focus when color mode have more then 256 color. I recombinate you to use dgAlwaysShowSelection in Options and dghRowHighlight in OptionsEh. If you want to keep old method of highlighting for all grids set DBGridEhDefaultStyle.LuminateSelection to false (at run time).

In TDBNumberEditEh and TColumnEh
+ Added dropped down calculator in TDBNumberEditEh and TColumnEh for numbered fields (need set TColumnEh.ButtonStyle to cbsDropDown).

In TColumnEh
+ Added DisplayFormat and EditMask properties.

In TColumnFooterEh
+ Added DisplayFormat property.

+ Added MRUList property (Most recently used values) in all edit controls and TCloumnEh. If MRUList is Active then in time of edit text the special listbox will be dropded down where users can select last entered values. When user leave edit control or inplace editor in the grid the value will be added in MRUList.

MRUList: TMRUListEh = class(TPersistent)
property Active: Boolean - MRU list will drop down in time of edit text.
property CaseSensitive: Boolean - take into account char case.
property Items: TStrings - list of items.
property Limit: Integer - max count of items. Old will be deleted.
property Rows: Integer - Count of rows in dtop down window.
end;

To distinguish MRU dropdown box from other, all other dropdown boxes have 3D border.

+ Added new component - TDBCheckBoxEh.
Can works as in data-aware mode as in usual not data-aware mode. If DataField and DataSource properties is not assigned then checkbox works in usual not data-aware mode.

Have Flat and AlwaysShowBorder properties to show in the flat mode.

In TDropDownBoxEh (TColumnEh.DropDownBox, TLookupComboBoxEh.DropDownBox) added property
+ ListSource of TDataSource type.
This property will be used when lookup inplace editor in the grid or LookupComboBox have focus. It allows to have different list of lookup list values for different records of master data.

In TDBSumList
+ Added OnAfterRecalcAll event. Event is call after SumList recalculate aggregated values.

In TDbGridEh
+ Added OnSumListAfterRecalcAll event.

In TDBEditEh
+ Added properties WantTabs and WantReturns.

INCOMPATIBILITY: In TColumnEh all published properties moved to public section. New TDBGridColumnEh object added that inherited from TColumnEh and have properties in published section. TDBGridEh uses TDBGridColumnEh to create columns. You can have incompatibility if you inherit TColumnEh object. Use TDBGridColumnEh object now.

+ Dropdown box in TDBLookupComboBoxEh and TColumnEh for look fields now inherited from TCustomDBGridEh. Now dropdown box can have MultiTitle, can fit columns width to window width, can have column lines and row lines, allows to change column widths, can have sortmarkers in titles, have event that calls when user press title, allows to change characteristics of individual column.

RESTRICTION: In EhLIb compiled under Delphi 4 or CBuilder 4 dropdown box can not resize or move columns or click the titles.

+ Added new unit - DBLookupGrid.Pas, contains TPopupDataGridEh component that uses as Dropdown box in TDBLookupComboBoxEh and TColumnEh for look fields.

In TColumnEh
+ Added property DropDownBox of TColumnDropDownBoxEh type
TColumnDropDownBoxEh = class(TPersistent)
property AutoFitColWidths: Boolean;
property ColumnDefValues: TColumnDefValuesEh;
property Columns: TDBGridColumnsEh;
property Options: TDBLookupGridEhOptions;
property UseMultiTitle: Boolean;
end;
using properties of DropDownBox property you can control dropdown box for inplace editor of columns that connected to lookup fields.

In TDBLookupComboboxEh
+ Added
property AutoFitColWidths: Boolean;
property ColumnDefValues: TColumnDefValuesEh;
property Columns: TDBGridColumnsEh;
property Options: TDBLookupGridEhOptions;
property UseMultiTitle: Boolean;
in TLookupComboboxDropDownBoxEh object (TDBLookupComboboxEh.DropDownBox property)

In TColumnEh and TDBLookupComboboxEh
+ Added events
OnDropDownBoxCheckButton - Occurs to define is there title can be pressed.
OnDropDownBoxDrawColumnCell - Occurs when the dropdown box needs to paint a cell.
OnDropDownBoxGetCellParams - Occurs when the dropdown box needs to paint a cell.
OnDropDownBoxSortMarkingChanged - Occurs after changing sortmarker.
OnDropDownBoxTitleBtnClick - Occurs after clicking on title button.

EhLib 2.0 does not support Delphi 3 and C++ Builder 3.

In TDBGridEh
+ For columns that attached to lookup Fields it support possibility of changing values if TField.KeyFields and TField.LookupKeyFields is kept a list of several names of fields (list is separated by semicolon).

+ In TDBGridEhOption type (OptionsEh propery) dghRowHighlight value is added - it allows to highlight current record.

+ Added crpDropDownRowsEh and crpDropDownWidthEh values in TColumnEhRestoreParam type, it allows to save and restore DropDownRows and DropDownWidth properties of TColumnEh in/from the registry or ini file.

+ Added property AllowedSelections: TDBGridEhAllowedSelections;
TDBGridEhAllowedSelections = set of (gstRecordBookmarks, gstRectangle, gstColumns, gstAll);
Defines what types of selection is available in grid. dgMultiSelect value in Options property also affects available of selection.

+ Added property ColumnDefValues: TColumnDefValuesEh
TColumnDefValuesEh = class(TPersistent)
AlwaysShowEditButton: Boolean
EndEllipsis: Boolean
AutoDropDown: Boolean
DblClickNextVal: Boolean
ToolTips: Boolean
DropDownSizing: Boolean
DropDownShowTitles: Boolean
Title.Alignment: TAlignment
Title.Color: TColor
Title.TitleButton: Boolean
Title.EndEllipsis: Boolean
Title.ToolTips: Boolean
Title.Orientation: TTextOrientationEh
defines default values for newly created colonies.

In TColumEh
+ Added OnNotInList event. Operates when user enter a text not kept in the list of values. If this event is assigned then user is automatically allowed to enter a text not kept in the list. Event makes sense if row is based on lookup field or PickList is filled or PickList and KeyList is filled.

+ Added OnGetCellParams event:
TGetColCellParamsEventEh = procedure (Sender: TObject; EditMode: Boolean; Params: TColCellParamsEh) of object;
TColCellParamsEh = class
property Col:Longint;
property Row:Longint;
property State: TGridDrawState;
property Font: TFont read FFont;
property Background: TColo;
property Alignment: TAlignment;
property ImageIndex: Integer;
property Text: String read;
property CheckboxState: TCheckBoxState;
property ReadOnly: Boolean;
end;
Requests the parameters of cell before draw/editing.

+ Added OnUpdateData event: TColCellUpdateDataEventEh = procedure(Sender: TObject; var Text: String; var Value: Variant; var UseText: Boolean; var Processed: Boolean) of object;
Operates when writing data from InplaceEditor in DataSet field. You can change text or value, UseText defines what parameter is used for writing: Text or Value. You may themselves write data to the field and sets Processed in True.

+ Added OnEditButtonClick event: TButtonClickEventEh = procedure(Sender: TObject; var Handled: Boolean) of object;

+ Added OnEditButtonDown event: TButtonDownEventEh = procedure(Sender: TObject; TopButton: Boolean; var AutoRepeat: Boolean; var Handled: Boolean) of object;
TopButton - when style of the button ebsUpDownEh, defines that pressed upper button. AutoRepeat - repeat events if mouse is keeping pressed.

In TDBSumListProducer
* State Of working group operations goCount is changed. When in TDBSum installed by GroupOperation = goCount and FieldName <> '' that SumValue will contain an amount of records for which field <FieldName> is not Null.

In TDBLookupComboboxEh
* Component has changed an ancestor, so possible inconsistency of functioning with the preceding version.

+ Supports working with lookup fields that containing in TField.KeyFields and TField.LookupKeyFields properties the list of the several names of fields, in the same way possible enter a list of several names of fields in DataField and KeyField properties of combobox. List of field names must be separated by semicolon (For instance: 'CustNo;EmpNo').

+ Added OnButtonDown event: TButtonDownEventEh = procedure(Sender: TObject; TopButton: Boolean; var AutoRepeat: Boolean; var Handled: Boolean) of object;
TopButton - when style of the button ebsUpDownEh, defines that pressed upper button. AutoRepeat - repeat events if mouse is keeping pressed.

Added 4 new components:
TDBEditEh - to edit text values.
TDBDateTimeEditEh - to edit date or time values.
TDBComboBoxEh - to edit text values with capacity to select values from list.
TDBNumberEditEh - to edit numeric values.

Common features in all components:
Can works as in data-aware mode as in usual not data-aware mode. If DataField and DataSource properties is not assigned then component works in usual not data-aware mode.
Have Flat and AlwaysShowBorder properties to show in the flat mode.

Have Text (String type) and Value (Variant type) properties.
Moreover Value can accept Null value or:
String type for TDBEditEh and TDBComboBoxEh,
TDateTime, TDate, TTime, Double type for TDBDateTimeEditEh,
all numeric types for TDBNumberEditEh.

Have an OnUpdateData event that occurs before writing data in DataSet field or in internal variable when not data-aware mode. Event is call when component lose the focus or when DataSet send PostData event.

Individual features of components:
TDBEditEh, TDBComboBoxEh and TDBLookupComboboxEh have WordWrap propertiy to show and edit multiline text. Don't forget to hang up AutoSize propertiy if you want to change and fix a height of the control.

In TDBLookupComboboxEh:
+ Added OnNotInList event. Event occurs when the user enters a value that isn't in the lookup list.

In TDBSumListProducer
+ Added group operation goAvg to calculate average values.

In TPrintDBGridEh
+ Added OnBeforePrint and OnAfterPrint events to write specifyed action before or after grid have been printed/previewed.

In TDBGridEh
+ Added possibility to set aggregate fields in footers at design time. So you can use more powerful mechanism of aggregate values imbedded in TClientDataSet component.

* Some bugfixes.

In TDBGridEh
+ Added dghIncSearch and dghPreferIncSearch values in TDBGridEhOption type (property OptionsEh).
dghIncSearch value allows to do increment search in grid.
dghPreferIncSearch value determine that the grid prefer increment search to cell editing.
At run time you can use next key for increment searching:
Ctrl+F - to begin increment searching.
Ctrl+Enter - to search next matching.
Ctrl+Shift+Enter - to search prior matching.
If dghIncSearch in OptionsEh and column is read only then grid will set increment search mode automatically on first key press and will set normal mode after 1.5 sec.

In TColumnEh
+ Added Tag property. Tag has no predefined meaning. The Tag property is provided for the convenience of developers.
+ Added DropDownSizing property. Set DropDownSizing to True to allow users to resize dropdown lookup or picklist window.

* Some bugfixes.

TPassthroughColumn class has been unloaded. In csDefault and csCustomized state uses the same class TColumnEh. It allows to inherit TDBGridEh class and add new properties in TColumnEh class.

In TColumnEh
+ Allows to show tooltips text for KeyImage based columns. When you adjust column properies to show bitmaps depending on field values you can fill also PickList propery by values of tooltip text.Set also Tooltips property to True and ShowHint property of DGBGridEh to True. At runtime by moving mouse above image will forces to show text from PickList in tooltips window.

In TColumnTitleEh
+ Added property Orientation: TTextOrientationEh;
TTextOrientationEh = (tohHorizontal, tohVertical);
Allows to draw text vertically. Only single line text support for vertical orientation.

* Some bugfixes.

In TDBGridEh
+ Added dghTraceColSizing value in TDBGridEhOption type (property OptionsEh).
dghTraceColSizing: Determines whether the column size changes before mouse button is released.
dghTraceColSizing is not supported under Delphi 3.
+ Procedures SaveColumnsLayout, RestoreColumnsLayout, SaveGridLayout, RestoreGridLayout overloaded to support TCustomIniFile in addition to TRegIniFile.
+ Added OnColWidthsChanged event. Occurs immediately after the column widths change.
+ Added Flat property. Makes the grid 3D borders more thinner, makes the grid rows more narrow, makes the fixed line gray.

In TPrintDBGridEh
+ Added support of the macro "&[Pages]" in PageColontitles.
&[Pages] substitutes the count of pages.

+ Added allows to set focus to and resize of the frozen columns.

In TDBGridEh
+ Added property FooterFont: TFont. Controls the attributes of the default footer font.
+ Added property FooterColor: TColor. Default background color of the footer.

In TColumnEh
+ Added property ToolTips: Boolean. Allows to show hint for text that don't fit in data cell.
+ Added property Footers: TColumnFootersEh. Allows to assign individual footer parameters for multiple footer rows.

In TColumnTitleEh
+ Added property ToolTips: Boolean. Allows to show hint if text don't fit in title cell.

In TPrintDBGridEh
+ Added pghFitingByColWidths, pghOptimalColWidths values in TPrintDBGridEhOption type.
pghFitingByColWidths: allows to fit grid to page width by changing column widths (not scaling whole image).
pghOptimalColWidths: change column widths to fit text in the cells.
+ Added BeforeGridText: TStrings property to print/preview the rich text before grid.
+ Added AfterGridText: TStrings property to print/preview the rich text after grid.
+ Added procedure SetSubstitutes to set substitutes for BeforeGridText and AfterGridText.

In TDBGridEh
+ Added allows to create one title for several columns in frozen and nonfrozen zones simultaneously (in MultiTitle mode).
* In RowSelect mode change column widths don't move view to first column.
+ Added selecting a columns and rectangle areas
Added property Selection: TDBGridEhSelection;
TDBGridEhSelection contains next properties
SelectionType: TDBGridEhSelectionType;
TDBGridEhSelectionType = (gstNon, gstRecordBookmarks, gstRectangle, gstColumns, gstAll);
Columns: TDBGridEhSelectionCols;
Rect: TDBGridEhSelectionRect;
Rows: TBookmarkListEh;
see EhLib.hlp and DEMO1 for detail.
* Clicks on left top cell in grid sets SelectionType = gstAll, but not selects all records.
+ When DragMode = dmAutomatic and dgMultiSelect is included in Options the grid enters in Dragging mode only when user pressed mouse on multiselected data area (not includes title, indicator and footer areas).

This version don't support print and preview of the selected area yet.

* Some bugfixes.

What's new in version 1.03:
New help file that can be inserted in Delphi help system.
Included support Borland C++ Builder versions 3 & 4.

In TDBGridEH
+ Added dghAutoSortMarking, dghMultiSortMarking values in TDBGridEhOption type (property OptionsEh).
dghAutoSortMarking Automaticaly marking title by SortMarking images.
dghMultiSortMarking Allow sortmarking multiple columns. At runtime use Ctrl + Mouse combination for multisortmarking.
+ Added event OnSortMarkingChanged : TNotifyEvent;
+ Added procedure SaveGridLayout(ARegIni: TRegIniFile);
+ Added procedure RestoreGridLayout(ARegIni: TRegIniFile; RestoreParams:TDBGridEhRestoreParams);
+ Added procedure SaveGridLayoutIni(IniFileName: String; Section: String; DeleteSection: Boolean);
+ Added procedure RestoreGridLayoutIni(IniFileName: String; Section: String; RestoreParams:TDBGridEhRestoreParams);

In TColumnEH
+ Added property Checkboxes: Boolean. Determine need show checkboxes enstead of text. Checkboxes automativcaly true for boolean field. For non boolean fill first line of KeyList for checked checkboxes. Second line for nonchecked.

* Fixed some bugs.