VCL

TAdvSpreadGrid

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


Release

v2.3.2.6 (October 31, 2017)

Version history

Feature overview

TAdvSpreadGrid extends the full power of TAdvStringGrid with formulas.
  • 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

Sample application

A sample application showing the TAdvSpreadGrid capabilities can be downloaded here

Extra information

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

Help

VCL

Buy online

TMS Component Pack


for Delphi 7, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, C++Builder 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo (Prof/Enterprise/Architect)


View licensing FAQ

Single developer license


license for 1 developer € 275


order now
add to cart

Small
team


license for 2 developers € 450


order now
add to cart

Site
license


unlimited developers in the company € 895


order now
add to cart


CreditCards and PayPal Accepted


This product is also available in the following bundle(s):

Bookmarks