TRIAL DOWNLOADS

• Delphi 5 (3.00 MB)
• Delphi 6 (3.87 MB)
• Delphi 7 (4.36 MB)
• Delphi 2005 (3.80 MB)
• Delphi 2006 (8.77 MB)
• Delphi 2007 (8.51 MB)
• Delphi 2009 (8.58 MB)
• C++Builder 5 (3.40 MB)
• C++Builder 6 (4.96 MB)
• C++Builder 2006 (8.77 MB)
• C++Builder 2007 (8.51 MB)
• C++Builder 2009 (8.58 MB)
• Demo (539.00 KB)

BOOKMARKS

TAdvSpreadGrid

Powerful spreadsheet function calculation support added to the full TAdvStringGrid feature set

• Feature overview
• Built-in function overview
• Custom function libraries
• What's new
• Sample application
• Purchase a license

Feature overview

• simple formula editing interface
• auto recalculation
• native XLS file import and export*
• single cell recalculation, full recalculation
• extensive range of mathematical functions
• save with formulas or formula results only
• single cell references in formulas
• cell range formulas
• formula precision for grid on cell basis
• display formulas or formula results
• date / time functions
• intelligent formula aware copy and paste
• can be extended with custom functions
• cell names
• cell name mode can be RxCy style or A1-style
• can reference cells from other TAdvSpreadGrids
• math library infrastructure to allow easy extending
• TAdvSpreadGrid with custom functions
• Includes the free ESBMaths library with 46 scientific constants and 19 mathematical functions from ESB Consultancy
• ESBPCS maths library available for even more statistical functions
• Intelligent and customizable hints while editing formulas
• available as separate add-on for TAdvStringGrid (not included in the TMS component pack)

What's new

v3.5

• Inherits all TAdvStringGrid v3.5 features
• Absolute cell reference support added
• Programmatical function move added
• CHOOSE function added
• COUNTIF, COUNTA, COUNTBLANK functions added
• NAND, NOR, NOT functions added
• Formula entry by cell click
• Automatic formula adaption during cell expansion
• Native XLS file import / export with formula support (import limited to built-in TAdvSpreadGrid functions - extendable with custom libraries)
• Choose to save to HTML, CSV, Text with or without formulas

Sample application

A sample application showing the TAdvSpreadGrid capabilities can be downloaded here

Note : TAdvSpreadGrid is an add-on for TAdvStringGrid or the TMS Component Pack Pro.  The registered version of TAdvSpreadGrid requires a registered version of TAdvStringGrid to be installed. TAdvSpreadGrid is also included in the TMS Grid Pack, TMS Component Studio, TMS VCL Subscription.

Buy online

TAdvSpreadGrid Single developer license for commercial use with full source code

free updates for a full version cycle (from current version to v3.0) and free priority support: 60 EUR
for Delphi 5, 6, 7, 2005, 2006, 2007, 2009, C++Builder 5, 6, 2006, 2007, 2009

Please choose your language   English Nederlands Français Português Deutsch Italiano Español   and order immediately or add to cart

This product is also available in TMS Grid Pack.