TAdvStringGrid 1.88 : Apr 10, 2000

**********************************************************************
TAdvStringGrid 1.88 : Apr 10, 2000

Copyright � 1996-2000 by TMS Software
E-mail: [email protected]
Web : http://www.tmssoftware.com
**********************************************************************

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

Files :
-----
advgrid1.zip : component files for Delphi 1.0
advgrid2.zip : component files for Delphi 2.0
advgrid3.zip : component files for Delphi 3.0
advgrid4.zip : component files for Delphi 4.0
advgrid5.zip : component files for Delphi 5.0
advgrdc1.zip : component files for C++Builder 1.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
can be used in Delphi 2 after ignoring errors while loading
asgcdemo.zip : demo with source code for C++Builder 4,5
can be used in C++Builder 1,3 after ignoring errors while loading

Release 1.88 :
------------------

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

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 : [email protected]
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