**********************************************************************
* TAdvStringGrid 3.1.1.1 : Sep 26, 2005                              *
*                                                                    *
* Copyright © 1996-2005 by TMS Software                              *
* E-mail: info@tmssoftware.com                                       *     
* Web : http://www.tmssoftware.com                                   *
**********************************************************************


Delphi 5.0/6.0/7.0/2005 - C++Builder 5.0/6.0 stringgrid with added features :

Files :
-------
  AdvStringGridD5.zip : component files for Delphi 5.0
  AdvStringGridD6.zip : component files for Delphi 6.0
  AdvStringGridD7.zip : component files for Delphi 7.0
  AdvStringGridD2005.zip : component files for Delphi 2005 (VCL Win32)
  AdvStringGridD2005NET.zip : component files for Delphi 2005 (VCL.NET)
  AdvStringGridC5.zip : component files for C++Builder 5.0
  AdvStringGridC6.zip : component files for C++Builder 6.0
  
  asgddemo.zip : demo with source code for Delphi 5,6,7,2005
  democ5.zip   : demo with source code for C++Builder 5
  democ6.zip   : demo with source code for C++Builder 6

Release 3.1.1.1 :
-----------------

 insert / delete rows & colums
 save / load to file
 save / load to stream
 save / load to CSV file
 save / load to XLS file 
 save / load to XML file
 copy / paste to clipboard + intelligent automatic series expansion, duplication
 save to HTML
 save to Word DOC file
 save to formatted text
 load from MDB table
 cell horizontal & vertical alignment, cell color, cell font color, read-only cells
 automatic printing with optional title, pagenumber, date, time, border,
                         cell fonts, colors, custom drawing, fit to page, cell border
 automatic column/row sizing
 column sorting + full sort when clicking on column header + arrow indication (like Internet mail)
 automatic goto cell based on sorted column when key pressed
 event handler for setting hint of each cell
 automatic selection of next cell after edit
 insert / delete key to insert or delete  rows
 automatic resizing with parent form
 automatic text display appended with '...' when text does not fit in column
 automatic saving of user resized columns in registry or INI file
 proportional scrollbars, flat scrollbars
 hide / unhide columns
 search capabilities with options for case sensitive, full/partial, regular expressions
 bitmaps, icons, imagelist elements, pictures
 fixed rows at bottom or right side of grid
 intellimouse support for scroll, zoom & pan (with MSWHEEL component)
 enhanced inplace editor with left & right aligned input
 shows URLs and starts apps on mouseclick
 inplace editors : combobox, spinedit, ellipsedit, datepicker, checkbox,
                   buttons, autolookup edits, numeric edit, float edit,
                   capital edit, mixedcase edit, radiobutton, bitbutton, custom inplace editors
                   unicode inplace editors 
 enhanced mouse actions to select columns and rows
 enhanced column and row dragging
 free rotated text
 disjunct row selection in rowselect mode
 OLE drag & drop source + target
 enable/disable column sizing per column 
 Rich text display capability
 Tiled or fixed positioned background image
 Group / Ungroup methods and grouped sorting
 Multi-column filtering
 HTML formatted cells
 Interface for spell check and autocorrection
 Built in JPEG,GIF,WMF,ICO,BMP support
 Cell merging
 Floating footer row
 Unicode cell display, edit, print & sort support
 Native support for reading & writing Excel files
 Workbook grid to handle multiple sheets


Feature Revision history :
--------------------------

2.2    : HideUnSelectedRows method added
         RemoveUnSelectedRows method added
         Significantly improved performance with LoadFromCSV
         SplitAllCells method added
         XYOffset works for text/RTF/HTML
         RangeSelectAndEdit property added in MouseActions
         KeepHorizScroll property added
         Improved handling of empty cells with date inplace editor & sorting
         Column stretch on selectable column
         Inplace or popup memo with scrollbar support
         Improved & faster display with nodes
         GetParentRow, InsertChildRow, RemoveChildRow methods added
         PrintSelectedRows, PrintPreviewSelectedRows
         Preview dialog with PrintSelectedRows property
         Translatable preview & find dialog 
         Printer setup dialog capability from preview dialog
         Improved OLE drag&drop with disjunct row drag&drop support
         Hide comment indicator with clNone color
         Improved alignment & autosizing with rotated text
         OnResize event added
         Cell level persistent color, fontcolor, fontstyle, fontsize, fontname, alignment properties
         Improved virtual cell handling with filtering & hiding rows
         Improved floating footer handling
         Improved CSV file delimiter guess
         glClassic and glTMS looks added
         ActiveCellColor property added
         SelectionResizer property added
         Improved smart clipboard functionality
         SaveToBinFile, LoadFromBinFile methods for saving full grid cell info
         SaveToBinStream, LoadFromBinStream methods 
         Full formatted cell clipboard support including images, checkbox, buttons ...
         Improved virtual cell handling
         Public properties MinRowHeight, MaxRowHeight, MinColWidth, MaxColWidth for 
           AutoSizeRow,AutoSizeCol methods
         NoAutoSizeRows property added under PrintSettings
         New sample applications
         C++Builder 6 support
         Improved printing support
         PrintSettings.PageNumberOffset & PrintSettings.MaxPagesOffset added
         OnCustomCellDraw & OnCustomCellSize events added
         DragDropSettings OleCopyAlways & OleColumnDragDrop added
         Background bitmap bcAll style added
         Improved BIDI mode support
         Find function supports find in hidden columns
2.3    : Improved AutoSizeCells method
         Improved border drawing in flat glSoft and glTMS look
         TMSGradientFrom / TMSGradientTo public properties added
         Save/Load nodes with LoadFromBinFile / SaveToBinFile issue solved
         Improved handling of Alt-Dn for combobox dropdown activation with keyboard
         Improved vertical alignment handling for printing
         Improved checkbox & image alignment handling for printing
         Improved BiDi support for inplace editing
         Fix for selected rich text painting
         Improved printsettings dialog handling
         Correct image drawing issue in floating footer
         Changed behaviour for ssNumeric sort style when used with non-numeric data   
         Disjunct row selection & sort improvement
         Improved ActiveCellShow behaviour
         Improved All cell and Column selection
         SaveColumnPositions, LoadColumnPositions method added
         GetItemClass method added to allow creating descendents with custom column items
         Inplace HTML control handling
         ssCheckBox sort style
         Fix in goTabs handling with hidden columns
         OnClipboardBeforePasteCell event added
         Fix in LoadFromMDB methods with empty fields
         Columnsizing with SynchWithGrid while editing issue solved
         Public property ShowNullDates added
         Improved spin edit handling
         FilterRow method added for applying filtering per row  
2.4    : Unicode display,print,editing and sorting support added for Windows NT, 2000 and XP
         CellControls[] property to add any control into a cell
         Find & Replace dialog for grid added
         Disjunct column selection, column printing, column clipboard handling
         OnGetFloatFormat event added to control floating point precision on cell basis
         AllColCount, AllRowCount properties added
         Improved XML export with corrected & character handling
         Improved handling quoted text in CSV import/export
         ClearNormalRows, ClearNormalCols functions added
         Improved SizeWhileTyping
         OnEndRowSize triggered during SizeWhileTyping
         Improved indication on row/column moving
         SetColumnOrder, ResetColumnOrder methods added
         SaveColPositions, LoadColPositions methods added
         MouseActions.NoAutoRangeScroll property added
         RemoveAllNodes method added
         virtual method LoadCell added 
         Enhanced control for AutoNumberCol, AutoNumberRow
         Autopositioning find dialog
         Improved find function with tests for empty strings & use of quotes
         Public property SaveWithHTML added
         Tab navigation direction control added
         Auto tab to next control on form after tabbing through complete grid
         PrintSelection method added
         Print preview of selection only capability added
         OnPrintCancel event added
         ProgressPie indicators added
         Combined drawing of images & sort indicator
         Index sort glyph properties added
         Readonly cell control for merged cells fixed - based on topleft cell settings
2.4.0.2: Improved SaveToHTML with Font export
         Improved edFloat and edFloatEditBtn decimal/thousand separator handling
         Improved SaveToXLSSheet
         SaveVirtCells public property added
         Improved HTML engine for lists and hidden text tags
2.5.0.0: Undo/redo for cell edits capability
         Multilevel nodes
         Fixed cell editing
         Grouping with summary lines and automatic coloring, merging
         Support for detail rows with embedded controls
         Filtering with suffix / prefix ignoring for conditions for numbers supported
         Filtering with selectable logic operations between multiple filter conditions
         Significantly improved filter speed
         Always visible comboboxes 
         QUnSort method added to undo sorts
         SortSettings InitSortDirection & UndoSort for tristate sort setting (ascending / descending / undo)
         ReadOnly[Col,Row]: Boolean property added to control read-only cells by properties
         MouseActions.PreciseCheckBoxCheck property added to make checkbox clicks sensitive on checkbox area only
         MouseActions.CheckAllCheck property added to check / uncheck all checkboxes per column by header checkbox
         MouseActions.NodeAllExpandContract property added to expand / contract all nodes by header node click
         Persistent disjunct row selections with hidden rows / filtered grids
         New XP node style
         New XP fixed cell look
         Improved progressbar appearance, XP style progress bar + progressbar margins properties
         FindWide function for Unicode find added
         MouseActions.DirectDateDrop property added
         SaveToBinFile, SaveToBinStream uses public SaveFixedCells property
         Progress event added for SaveToBinFile, SaveToBinStream
         IsSelSuperscript, IsSelSubScript methods added to detect rich text subscript / superscript in cells
         Exposed internal incremental search text
         OnBeforecontractNode, OnBeforeExpandNode events added
         Navigation.TabToEndAtEnd property added
         Preview dialog : PrintSelection property added to show preview of selected cells only
         LookupItems + combobox items used for inplace comboedit
         Improved support for time editing with no entry for seconds
         Support for merged cells in floating footer added
         Improvd support for row moving with visible floating footer
         Multiline clipboard copy & paste with Excel supported
         Improved proportional & flat scrolling style
         All fixed columns can be sized
         Grid design time preference save & restore
         MouseActions.MoveRowOnNodeClick added controls whether cell selection changes or not on node click
         Gradient cells with Colors[col,row] and ColorsTo[col,row] properties
         Find function for empty cells with "" capability added
         New helper function GetXLSSheets() to assist for LoadFromXLSSheet method
         Custom inplace editors use goTabs style
         UseDisplayFont & FixedFont setting in grid PrintSettings
         Navigation.SkipFixedCells added for keyboard navigation control with fixed cells in grid
         Column moving synchronised through hidden rows
         Improved selection resizing and new OnSelectionResize event
         Removing rows while rows are hidden or filtered support added
         Automatic numeric alignment in printing
         OnCellValidateWide added for validation of unicode editing
         Simultaneous use of RowSelect mode and nodes capability added
         Lots of smaller optimizations and improvements
2.6.0.0  Native support for reading & writing Excel files
         Improved use of controls inside the grid, including using grids inside the grid
2.6.0.3  Property ControlLook.NoDisableCheckRadioLook added
         Improved SaveToHTML function 
         Improved drag & drop handling
         Improved disjunct selection handling
         New function SaveToHTMLString added
         Improved SaveColPositions/LoadColPositions
         New glListView look to simulate XP style listview look      
2.7.0.x  New TAdvGridWorkbook component
         Enhanced native Excel file (97,2000,XP) reading / writing (based on FlexCel 
           technology) can work with TAdvStringGrid, TAdvGridWorkbook
         Additional control properties for XLS import / export with TAdvGridExcelIO
         New OnProgress event for TAdvGridExcelIO
         Enhanced XP themed appearance
2.8.0.0  Delphi 8 (SP2) VCL.NET Compatibility added
2.8.1.0  TAdvGridExcelIO border export support added
         TAdvGridExcelIO node import / export support added
         TAdvGridExcelIO control to overwrite existing files in XLS export or not
         TAdvStringGrid NoDefaultDraw public property added
         TAdvStringGrid auto XP theme color adaption
         Improved : TAdvStringGrid OnEndColumnSize triggered after sizing of a fixed column
         Improved : TAdvStringGrid active cell display 
2.8.2.1  New : FloatingFooter.OnCalcFooter event added
         Improved node handling
         Improved filter handling with filter for text with ? and * with \ escape character
         Improved row hiding/unhiding flexibility
2.8.4.0  New HTML export options (save with nonbreaking text, auto show, convert special characters)
         Improved inplace spin edit handling
         Improved form control inplace edit handling
         Improved Home/End key navigation handling 
         Miscelleanous smaller improvements/fixes
2.8.5.0  New support for Delphi 2005 added
         New Support for masked & password HTML form controls added
         Improved MouseActions.RowSelect handling with scrolling
         Improved PasteSelectionFromClipboard procedure
         Improved drag&drop with Internet Explorer
         Improved HTML forms handling with tab key navigation
         Option to do column calculations in floating footer taking hidden rows in account or not
         Built-in datetime and time sort format support (D7 or higher)
2.8.7.4  New : OnGetDisplWideText event added for virtual unicode text handling in grid
         New : FloatingFooter.CalculateHiddenRows to select calculations with or without taking hidden rows in account
         New : Navigation.AppendOnArrowDown property added
         Various smaller code improvements & optimizations
2.8.8.1  Fixed Ctrl-A select all with disjunct row selection mode
         Added MouseActions.WheelIncrement property
         Added MouseActions.WheelAction property
         Fixed issue with RemoveRows() causing TopRow to become negative
         Fix for flicker during painting with FixedRightCols > 0
         Fix for AlwaysEdit mode with edButton inplace editor type
         Fix for cell validation & floating footer recalculation
         Fix for keydown event in combination with floating footer
3.0      New: AppendToDoc method, export by appending to existing MS Word DOC file with insert at bookmark option
         New: AppendToAscii method, export by appending to existing ASCII file 
         New: CopyToClipboardAsHTML method, copies grid as HTML on the clipboard
         New: Balloon hints for cells
         New: Support for multi column sorting in grouped grid
         New: SubGroup method to add subgroups in grouped grid
         New: RangeIndicator cell type
         New: Automatic modified row indication in fixed column
         New: Wordwrap control per cell
         New: Firefox style search pane
         New: XML Import
         New: Built-in Hotmail style row selection
         New: Active row indication for full row
         New: Sort styles ssAlphaNumeric, ssAlphaNumericNoCase
         New: edUniEditBtn Unicode inplace editor with embedded button
         New: Always visible vertical, horizontal or both scrollbars
         New: OnAutoAdvance event to control advance on enter behaviour
         New: Support for background display over full background, also non cell grid background and background gradient
         New: InsertNormalRow, RemoveNormalRow methods to insert/remove non-child rows in a grid with nodes
         New: Progress bar with formatted display of value and non percentage values
         New: Keyboard left/right arrow to open/close nodes in grid
         New: RemoveAllComments, RemoveAllMarkers added
         New: Support for hints on floating footer added
         New: Custom floating footer painting support added with OnFooterPaint event
         New: OnFindDOne, OnReplaceDone, OnDialogKeyDown events added in TAdvGridFindDialog, TAdvGridReplaceDialog
         New: MouseActions.SizeFixedRow added to enable sizing of fixed rows
         New: MouseActions.NoScrollOnPartialRow property added to prevent auto scroll on partial visible row click
         New: Grid gallery of visual appearance settings
         New: Gradient selection color capability
         New: Filter selection to filter on virtual cell text or grid cells text
         New: property DefaultEditor
         New: OnSelectionResized event added
         New: Title attribute support for anchors added for setting custom hints for HTML hyperlinks
         New: EditLink.PopupLeft, EditLink.PopupTop properties added to control popup editor position
         New: TMemoEditLink.SelectAll property added to control selection in inplace memo editor
         New: Public property PrintSettings.FixedCellsAlways to print fixed cells in case of PrintSelectedRows, PrintSelectedCols
         Improved: BidiMode RightToLeft support
         Improved: XML export
         Improved: HTML export optimized with use of CSS
         Improved: Optimized DFM property storage
         Improved: tab key handling in grid with readonly cells
         Improved: disjunct selection with shift/non shift Home/End key
         Improved: grouping summary & header display with additional underline capability
         Improved: HintShowLargeText functionality
         Improved: Navigation.AllowInsertRow, Navigation.AllowDeleteRow support for grids with nodes
         Improved: Navigation.AutoGotoincremental behaviour with timer based lookup reset
         Improved: Print option added to print with default paper orientation instead of forced orientation
         Improved: Shift row selection now possible with MouseActions.RowSelect = true
         Improved: Row / column moving for multiple fixed rows / columns
         Improved: Node display
         Improved: Grouping with group row merging & column merge combined
         Fixed: issue with drag & drop arrow color on Windows XP themed apps
3.1      New: TAdvGridRTFIO component for native export as RTF (rich text) file
         New: DragScrollOptions property to control scrolling during mouse drag operations
         New: Event OnCanClick cell
         New: 3 new sample applications
         Improved: Subgrouping
         Improved: DirectEdit handling
3.1.1.1  New: OnDateTimeChange event added
         Improved: combobox dropdown button appearance
         Fixed: size while typing for rich text cells
         Fixed: SelectOnRightClick issue with disjunct row selection
         Fixed: issue with printing hidden columns for 0 fixed columns 

License :
---------
Use of the component requires a license. A license is obtained by registration.
The component cannot be distributed in any other way except through free
accessible Internet Web pages or ftp servers. The component can only
be distributed on CD-ROM or other media with written autorization of the
author.
Online registration for TAdvStringGrid is available through the ShareIt
service at http://www.shareit.com/programs/100838.htm.
Alternatively, you can go to http://www.shareit.com and enter the program
number there: 100838.

Source code & license is sent immediately upon receipt of check or
registration by email. Payment grants users the right for a full version
cycle source code updates.


Help, hints, tips, bug reports :
--------------------------------
Send any remarks to : info@tmssoftware.com
Please clearly state which Delphi or C++Builder version you are using
and which version of the component you are using. In case of doubt,
download the latest version first at http://www.tmssoftware.com
When installing newer versions of the component, make sure to update
all your form files that used the previous version of TAdvStringGrid
before recompiling your application to make sure all new properties
are available. You can update the form file by opening it, ignoring
remarks about new properties and save the form.

Additional demos :
------------------
Available at : http://www.tmssoftware.com

example application 1 : printing with TAdvStringGrid
example application 2 : setting colors with TAdvStringGrid
example application 3 : navigation in TAdvStringGrid
example application 4 : general demo of TAdvStringGrid
example application 5 : comboboxes, lookupediting & imagelist images in TAdvStringGrid.
example application 6 : sorting, including custom sorting in TAdvStringGrid
example application 7 : C++Builder demo showing setting of cell color, alignment and sorting styles.
example application 8 : rich text capabilities in TAdvStringGrid
example application 9 : using bitmaps for printing headers & footers
example application 10 : demonstration of some new v1.81 features
example application 11 : using nodes to expand/contract rows
example application 12 : radiobutton inplace editors
example application 13 : combining TAdvStringGrid and TWebData to build a stock quote downloader
example application 14 : grouping with TAdvStringGrid
example application 15 : rich text drag & drop and printing, custom borders sample
example application 16 : using the printsettings & printpreview dialogs
example application 17 : loading data in the grid through ADO
example application 18 : using custom sort sequences
example application 19 : using the new edUnitEditBtn for split physical value editing in C++Builder
example application 20 : using the new HTML formatting capabilities
example application 21 : C++Builder version of the main demo
example application 22 : using the new filtering capabilities
example application 23 : a picture viewer with TAdvStringGrid
example application 24 : using custom inplace editors with TAdvStringGrid
example application 25 : printing multiple grids on a single page
example application 26 : using the ESBPCS edit controls as inplace editors
example application 27 : using the JPM open edit controls as inplace editors
example application 28 : using row, cell, cell ranges and column drag & drop
example application 29 : adding a field chooser to TAdvStringGrid
example application 30 : inplace rich text editing
example application 31 : using TAdvStringGrid with the new TChartLink component
example application 32 : using the new TImagePicker as inplace editor
example application 33 : using TAdvStringGrid with tAtPascalScripter
example application 34 : using TAdvStringGrid with Addict Spell Checker
example application 35 : using a TColumnComboBox as inplace editor for TAdvStringGrid
example application 36 : using the new ControlLook property to select different inplace editor control looks 
example application 37 : sorting on selected fixed rows of choice 
example application 38 : grouping and merged group headers in TAdvStringGrid 
example application 39 : merged cell access, merge cell printing and HTML export 
example application 40 : sort independent cell access 
example application 41 : virtual cells and disjunct row selection 
example application 42 : merged cell printing 
example application 43 : advanced border control 
example application 44 : floating footer usage 
example application 45 : virtual cell sorting 
example application 46 : various new TAdvStringGrid v2.0 features 
example application 47 : using the new capability to load data from MDB files
example application 48 : disjunct cell selection
example application 49 : automatic fixed floating footer calculations
example application 50 : (ab)using TAdvStringGrid : console app based sorting & fileformat conversion 
example application 51 : cell property access, clipboard persistent cell properties and binary save 
example application 52 : custom drawing and custom drawing printing support 
example application 53 : inplace memo and popup memo editor
example application 54 : using HTML forms in the grid
example application 55 : almost codeless interface to use any TWinControl as inplace editor for TAdvStringGrid
example application 56 : using the new TAdvGridExcelIO for reading / writing Excel files directly with TAdvStringGrid 
example application 57 : using cell controls to show a grid inside a grid
example application 58 : using TAdvGridWorkbook
example application 59 : using TAdvGridWorkbook with TAdvGridExcelIO
example application 60 : using data-dependent images
example application 61 : some combobox tricks with TAdvStringGrid


