**********************************************************************
TAdvStringGrid 1.92 : Apr 17, 2001

 Copyright © 1996-2001 by TMS Software
 E-mail: info@tmssoftware.com
 Web : http://www.tmssoftware.com
**********************************************************************


Delphi 3.0/4.0/5.0 - C++Builder 3.0/4.0/5.0 stringgrid with added features :

Files :
-------
  advgrid3.zip : component files for Delphi 3.0
  advgrid4.zip : component files for Delphi 4.0
  advgrid5.zip : component files for Delphi 5.0
  advgrdc3.zip : component files for C++Builder 3.0
  advgrdc4.zip : component files for C++Builder 4.0
  advgrdc5.zip : component files for C++Builder 5.0
  asgddemo.zip : demo with source code for Delphi 3,4,5
  democ3.zip   : demo with source code for C++Builder 3
  democ4.zip   : demo with source code for C++Builder 4
  democ5.zip   : demo with source code for C++Builder 5

Release 1.92 :
--------------

 insert / delete rows & colums
 save / load to file
 save / load to stream
 save / load to CSV file
 save / load to XLS file (not supported in Delphi 1)
 copy / paste to clipboard + intelligent automatic series expansion, duplication
 save to HTML
 save to Word DOC file
 save to formatted text
 cell 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, custom 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 (Delphi 4 only)
 Rich text display capability
 Tiled or fixed positioned background image
 Group / Ungroup methods and grouped sorting
 Multi-column filtering
 HTML formatted cells

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

 0.95  : clipboard max. datatransfer size in Delphi 1.0 increased to 64Kb
 0.96  : grid resizes with parent form
 0.97  : automatic text append with ... in string too long for column
 0.98  : centered printouts
         save & load of column sizes in registry / INI file
         enhanced print preview
         print selected rectangle of grid only
 0.99  : enhanced display of sort triangle indicator
         load from XLS and CSV file
         enhanced clipboard paste function
         new property to control sorting fixed columns
         proportional scrollbars
 0.995 : hide /unhide columns
 0.996 : save /load to stream
 0.997 : enhanced printing of grid with more columns than fitable on a page
 0.998 : findfirst, findnext (optional case senstive, full/partial, regular expression)
 0.998b: enhancements to print, sorting saves col/row of grid, colors saved in HTML output
 0.998c: C++Builder 1.0 support
 0.999 : enhanced handling of multiline text for edit, print, save
 1.0   : events for cell click and dblclick, read-only cells
 1.1   : onvalidate event handler for cell validation + minor
         fixes for hidden columns & searching
 1.2   : added icons, bitmaps, imagelist elements
         added fixed rows at bottom of grid
         fixed glitch for printout of multiline cells
 1.3   : added fixed columns at right side of grid
         added changing delimiter for ASCII import/export
         added page orientation and page nr prefix changing for printing
         fixed glitch for handling graphics when inserting/deleting rows/cols
 1.31  : added font control for each cell for printing, enhanced navigation, sizing while editing
 1.32  : fixed print problem with changed fonts
 1.33  : enable/disable prop. scrollbars, selectable cell contents for hints
 1.34  : fixed mixing of graphics and other user defined objects
 1.35  : enablegraphics property let users add non-object datatypes to objects[] property
 1.36  : variable auto or fixed row and column size
 1.37  : printpreview of selectable rectangle, automatic stretched rightmost column
 1.38  : case and not case sensitive sorting + sort on short date in EU and US format
 1.39  : added property AutoGotoWhenSorted to allow jumping to row on keypress in sorted column
 1.40  : intellimouse scroll,zoom & pan if MSWHEEL is installed on form
 1.41  : enhanced inplace editor with left & right aligned input
         fixed selectcell & click event handler problem
 1.42  : much faster Excell output, C++Builder compile problem solved
 1.43  : added AppendToCSV, InsertFromCSV, SaveFixedCells property
         + some bug fixes
 1.44  : formatted text output
 1.45  : shows URLs and handles URL mouseclicks + improved SaveToFile
 1.46  : added custom sorting capability
 1.50b1: inplace editors : combobox, datepicker, ellipsedit, spinedit, checkbox
 1.50b2: improvements to save/load CSV, hideselection function, drawing & in cells, ..
 1.50b3: bug fixes for saving to CSV
 1.50b4: bug fixes for printing, columnstretch, improved performance
 1.50  : added auto wordwrapping, minor bug fixes
 1.51  : automatic cell advancing when masked edit input completed and ssFinancial sorting method
 1.52  : fix ownerdraw cells for Delphi 1 + fix ssFinancial sorting style
 1.53  : enhanced mouse actions to select columns, rows.
 1.55  : COMCTL32 version checking, enhanced print preview, enhance date/time inplace editor
 1.56  : new mouse action : immediate caretpositioning on mouseclicks
 1.57  : set search direction top/down - left/right
 1.58  : automatic caret positioning for cell-editor.
 1.59  : enhanced printing with properties for HeaderFont, FooterFont, repeated
         fixed columns & rows
 1.60  : C++Builder 3.0 support
 1.61  : Improved find routines, small bug fixes, new sorting capabilities
 1.62  : Extra functions to hide/unhide multiple columns
         Added mailto: for URL handling + possibility to edit URL's
         Improved printing + improved implace editors
         Properties to set color of selected cells + border
 1.63  : Improved color printing, bug fixes for cursor handling
         mailto protocol handling when URL enabled, right-click cell event
         direct inplace editor show when mouse click
 1.64  : improved printing of multiline text
         transparent selection of cells
         improved support for local currence formatting
 1.65  : Improved save/load to XLS file
         fixed CanEditCell related problem
 1.66  : Added properties to set column headers and row headers at design time
         New event handler to force new page after custom line
         New edButton inplace control type
 1.70  : enhanced row and column dragging
         improved CSV and XLS input (now uses all used XLS cells)
         autolookup edit controls
         rowspacing property for printing added
 1.71  : improved editbtn handling
         top/center/bottom alignment for single line cells
         improved lookup editing
 1.72  : improved editbtn
         added lookuphistory
         improved cell display routine
         Delphi 4 support
 1.73  : Fit to page printing support added
         Ctl3D property handling improved
         Various small fixed
 1.74  : intermediate test release
 1.75  : enhanced stretch rightcolumn
         enhanced auto-advance when enter (first enter selects proper cell)
         enhanced SizeWhileTyping : works vertically + horizontally
         added autosizerow, autosizerows functions
         added editor type edDataCheckBox, ie checkbox that represents data in the cells
         and indicates checked or not checked depending on CheckTrue, CheckFalse properties
         improved combobox editor with lookup & history possibilities
         extra properties to get grid/column print sizes during OnPrintPage
 1.76  : free rotated text in any cell
         disjunt row selection in rowselect mode
         improved implace edit controls
         spinedit exposed to set minvalue and maxvalue
         improved printing with new border styles
         fix for sorting last column
 1.77  : new flat/encarta style proportional scrollbars
         new property to enable/disable disjunct row selection
         new property to control auto insert before/after of rows
         new event handler : OnPrintSetColumnWidth to set each column width for printing
         improved enhanced column/row moving
 1.78  : improved access to cells as Ints[]
         improved support for copy & paste multiline cells with ExcelClipboardFormat property
         new inplace editors : edNumeric,edFloat,edCapital,edMixedCase
         improved printing
         improved editing : Navigation property extended : AlwaysEdit + ImproveMaskSel
         improved sort indicators
 1.79  : Exposed BtnEdit inplace editor. Allows access to its new ButtonCaption & Glyph property
         OnSpinClick event handler
         OnComboChange event handler
         OnCheckBoxClick event handler
         IsSelected function
         OLE drop target & OLE drop source
         Chained hint handling solved when multiple grids are used on a form
         Autosizerow in wordwrap mode problem solved
         Improved multiline CSV save & load functions + OEM character support
 1.80  : Sorting when using different rowheights is solved
         Improved Autosizerows in wordwrap mode
         Rich text display capability
         Improved printing and printpreview, new OnPrintStart routine
         Improved checkbox handling
         New pagenumsep property in PrintSettings
         New print border style : pbAroundVertical,pbAroundHorizontal
         New public property PreviewPage for preview
         Edit box has same background color as grid
         ReadOnly property for EditBtn
         Disable columnsizing per column
1.81   : AutoGotoIncremental in Navigation
         RichEdit exposed
         RemoveComboString/SetComboSelectionString function
         New dataimage type
         GetBitmap function
         FixedColWidth, FixedRowHeight property
         Column/Row sizing design helper hint
         Improved checkbox positioning
         New ClearRowSelect method
         New DateFormat property in PrintSettings to control formatting of printed date
         New PageSuffix property in PrintSettings to set suffix for page nr.
         New functions BeginUpdate/EndUpdate to control repaints during lengthy operations
         New property to control OEM character conversion for LoadFromCSV,SaveToCSV
         Improved DisjunctRowSelect
         Improved RepeatFixedRows usage (also prints fixed row when using PrintRect)
         Improved implace button control
         New dynamic scroll hint
         New sortup / sortdown glyph
         New wallpaper property
         Improved cell validating
         Improved vertical autosizing
         New OnEndColumnSize event handler
1.82   : Improved incremental & case insensitive search
         Improved AutoRowSize in wordwrap mode
         Improved button inplace editor
         Improved header & footer printing
         Improved AutoSizeCol, AutoSizeColumns with rich text
         Horizontal scrollhints added
         Support for hidden rows
         New property PrintNrOfPages : nr. of pages required for printing the grid
         ColumnHeaders, RowHeaders improved update in grid
         Radiobutton inplace editors
         Auto numeric align
         NormalEdit control exposed
         New Fixedfont property
         Improved editing with hidden columns
         New public property PrintPageRect
         Intelligent clipboard functionality
         LoadFromXLS improvement, SaveToXLS improved for multiline text, hidden columns
         SaveToDOC method added
         Improved rich text support
         Intelligent CSV input with delimiter = #0, tries to find delimiter itself
         OnGetCellPrintBorder event added to specify border of each cell during print
         OnPrintSetRowHeight event added to override default row height for printing
1.83   : New SelectionRTFKeep property to control RTF display of selected cells
         New MoveRowOnSort property in Navigation
         JavaCSV property added
         OnGetCellBorder,OnGetCellPrintBorder added
         Arrow indication on move column, move row
         RichEdit extended to TAdvRichEdit with added SelSuperscript, SelSubscript
         RichEdit printing
         New fixed cells through OnIsFixedCell event
         Improved Navigation in AdvanceonEnter mode with jump over read-only cells
         Improved EditBtn, SpinEdit borderless inplace editors
         SpinEdit.EditorEnabled public property added
         New Background property replaces WallPaper property
         RTF clipboard functions
         AddMultiImage method added
         LoadFromFixed method added
         HTMLSettings property added
         SaveToXML method added
         New sortfull property
         Rich text OLE drag'n'drop
         Grouped sorting / Group / Ungroup / GroupColumn property added
         Improved disjunct row select / RowSelectCount property added
         BeginUpdate / EndUpdate methods added
1.84   : New TitleSpacing property in PrintSettings
         New TitleLines property in PrintSettings for multiline print titles
         New AutoComboDropSize property in Navigation
         Improvements for usage in DLLs, MDI applications
         Improved OnCellValidate function
         New method UnhideRowsAll
         Improved autosizerows with hidden columns
1.85   : New menu property editors LoadFromCSV & Clear
         Column sizing on double click in size region (like listview)
         SaveToCSV : no longer outputs " " when text contains comma, only when it contains the delimiter
         Improved SaveToFile for RTF text
         Added methods SaveColSizes, LoadColSizes + support for runtime created grids
         Added methods SavePrintSettings, LoadPrintSettings
         Improved SaveToXLS
         Improved column size handling for hidden columns
         New method UnHideColumnsAll
         SaveFixedCells is now also used for SaveToXLS, LoadFromXLS
         New inplace editor UnitEditBtn
         Custom sorting order through property SortIndexes & QSortIndexed method
         Printing graphics supported
         New property OriginalCellValue
1.86   : New properties RealRow, RealCol
         fnIncludeFixed,fnAutoGoto style added
         SaveToDoc improved
         Improved hidden column behaviour with inplace editors
         Caretpositioning works for comboboxes now as well
         Improved paste function within a cell
         Improved handling of vk_up / vk_down in multiline cells
         Improved onexit / onenter with special inplace editors
         Improved Lookup, LookupCaseSensitive added
         SaveToXML declaration change to TStrings
         New sorting styles : ssAnsiAlphaCase, ssAnsiAlphaNoCase, ssRaw,ssHTML
         Improved automatic sort style guess
         Password cells, PasswordChar property
         Mini-HTML engine support added
         OnAnchorClick event
         New method : AutoSizeCells
         New methods : SelectRange, SelectRows, SelectCols
         New methods : DisplColIndex, DisplRowIndex
         New events : OnRowChanging, OnColChanging, OnCellChanging
         New inplace editor : edDateEditUpDown
         Improved flat time / date inplace editors
         Improved vertical radiobutton display
         Multiline column & row header support through \n
         Added capability to save column widths into INI file
         Proportional column sizing
         Matching / finds based on numeric data
         StrippedCells property
         Multicolumn filtering
1.87   : Events for copy/paste/cut + allow
         Progress control
         Cell Comment (like Excel)
         File progress event for normal file and CSV file operations
         Faster file loading
         Fixed cells can be buttons
         ShowSelection property added
         HideFocusRect property added
         New ssImages sorting style
         Faster grouping, filtering, row hiding
         New Floats property and FloatFormat
         New methods : ColumnSum, RowSum
1.88   : C++Builder 5 support added
         added ColumnAvg, ColumnMin, ColumnMax, RowAvg, RowMin, RowMax
         added fnMatchStart in Findparameters
         New methods : GroupSum, GroupAvg, GroupMin, GroupMax
         New events : OnCheckBoxMouseUp, OnRadioMouseUp
         New inplace editors : edFloatSpinEdit, edTimeSpinEdit, edDateSpinEdit
         DirectComboDrop property added in MouseActions
         ScrollInView method added
         edPositiveNumeric edit style added
         cell://rXXcXX anchor handled to allow navigation from cell to cell 
         ctPicture and ctFilePicture cell graphics
         SortNormalCellsOnly property added
         HideInplaceEdit method added
         CreatePicture, CreateFilePicture, CreateBitmap, CreateIcon functions added
         AllColumnSize, AllRowSize properties in MouseActions added
         SaveToFixed method improved
         faster display
         solved hint on cell with hidden cols
         bidimode issue solved
         ColumnSum, RowSum improved
         Lookupcombo behaviour improved
         clipboard events improved
         Faster clipboard paste
1.89   : fixed preview for Win 2000
         fixed RTF drawing for Win 2000
         events before Insert, Delete, Add row
         Add row event if auto insert is active in combination with edit AutoAdvance
         CopyHTMLTagsToClipboard property added in Navigation
         AllObjects property added
         Printing with centered alignment fixed for Win NT , Win 2000
         AnchorClick event, aRow, aCol parameters sequence fixed
         OnFloatSpinClick, OnDateSpinClick, OnTimeSpinClick events added
         New Bands property
         New SaveToXLSSheet, LoadFromXLSSheet
         New ctButton type to add permanent a visible button in a cell
         Improved checkbox alignment
         CutSelectionToClipboard added
         Improved AutoSizeRows, AutoSizeColumns with radiobutton inplace editors
         Enhanced matching function
         New SaveHiddenCells property for SaveToCSV functions
         New property SortIndexShow + UI for multi column sorting
         Extended SortIndexes capabilities
1.90   : F4 support for keyboard trigger of EllipsClick in edEditBtn control
         RemoveRows sets Entered state to false to avoid extra cell validation
         AdvanceOnEnter works now when NormalEdit.LengthLimit is reached
         New property MaxEditLength to easily set the limit and improved handling of this limit
         New property EnableHTML to enable/disable the mini-HTML engine
         Improved float inplace editor handling & float spinedit handling
         New alignment styles vaFull, haFull for cellgraphics
         New property ScrollSynch for vertical scrolling
         Fixed inplace editor visibility with contract / expand nodes
         New LineFeedOnEnter in Navigation added
         Options goTabs property now allows tabbing inside the grid
         New HintShowLargeText property to show only hints on cells that do not fit
         New property Navigation.AllowClipboardAlways to allow clipboard in read-only grids
         New properties Navigation.AllowClipboardColGrow and Navigation.AllowClipboardRowGrow to 
         disable grid resizing during paste
         New methods PrintDraw & PrintDrawRect introduced to facilitate printing of multiple grids per page
         SavePrintSettings / LoadPrintSettings saves TitleLines property
         Made methods RepaintRow, RepaintCol,RepaintCell, RepaintRect public
         New methods : RemoveSelectedRows, HideSelectedRows in DisjunctRowSelect mode
         New CellPadding property in HTMLSettings
         New setting inch/mm in PrintSettings dialog
         New save/load tab in PrintSettings dialog
         Improved navigation with cursor keys
         Custom inplace editors
         New Times[] property
         Filtering supports dates
         Background image now selectable between normal cells & fixed cells
1.91   : Flat style fixed cells supported
         Fixed multiline title print title save/load
         New SaveToFixed method added
         Improved printing with background color for RTF & HTML cells
         Improved button moving/painting in EnhRowColMove mode
         New events :  OnColumnMove, OnRowMove, OnRowSize
         New property : IntelliZoom to enable/disable zomm with wheel mouse
         OLE drag&drop added for C++Builder 3,4,5 & improved OLE drag&drop
         AppendToHTML added
         Improved HTML export
         SaveFixedCells taken into account for CopyToClipboard and PasteFromClipboard
         LookupCaseSensitive now also works for combobox inplace editors
         Fix for saving multiple sheets into XLS
         Row indicator
         Improved OLE dragdrop & enhanced functionality for dragdrop rows, columns, cells and cell ranges
         Faster printing & improved printing with graphics
         New properties FixedRowAlways, FixedColAlways
1.92   : LoadFromStream./SaveToStream compatible with LoadFromFile/SaveToFile
         Filter.CaseSensitive added
         OnCellsChanged event added
         Improved Find function with backward search option
         New : GroupCount function
         New : property CurrentCell
         New : HTML formatting in print footer/header added
         New : rich text inplace editing
         AddProgressEx method added
         New HTMLSettings.ColWidths:TIntList property to set HTML column widths for SaveToHTML
         New method TextFill
         HTML cell drawing with end ellipsis
         Several smaller code improvements and speed optimizations
         ActiveCellShow, ActiveCellFont added
         AddRow, AddColumn methods added
         AutoNumberRow method added
         Enhanced full row select and full column select handling
         SortIgnoreBlanks and SortSingleColumn properties added
         ColumnSize.SynchWithGrid added


License :
---------
This component is free for use in non-commercial applications, that is
any software that is not being sold in one or another way or that does
not generate income in any way by the use of the application.
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

