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

• TAdvStringGrid filters, free interface between TMS Grids and TMS Flexcel to provide import/export capabilities to .XLS & .XLSX, .PDF formats.
• Grid built-in functions
• Grid custom functions

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 VCL UI Pack, TMS Grid Pack, TMS Component Studio, TMS VCL Subscription.

Help

• PDF manual
• Support Center
• Tips & FAQ

What our customers say

We have been using TMS components in our software development for almost 30 years. Throughout this time, we have consistently experienced friendly and high-quality service. Problems are not simply dismissed with the words "no error found," but rather, solutions are actively sought in collaboration with the customer. The components are well-designed and highly configurable to meet individual needs. We have also found TMS to be a reliable partner in custom development projects.

- Holger Hanschmann

Excellent components, enhances and improves the end product. Support is excellent. Reply promptly and always have an answer or fix, something which is important when trying to develop software to a deadline. Would highly recommend the components and the company to any fellow Delphi developers.

- Trevor Bradley

I use TMS components since a couple of years and I'm really happy with the components but especially with the support the company does provide, too. I always (!) get fast and competent help. In my opinion they have a great package of software and service.

- Jimi Romano

As a developer for 30+ years, and a Delphi developer since 1996, I've a solid foundation on desktop development. But I was skeptical of indulging in web development. Though the market was demanding a switch, it seemed too difficult to make the transition. TMS Software was my "magic bullet" to get me started with zero intimidation. Love their Web Core and XData products. Now I can develop powerful web applications using Delphi. TMS Software has renewed my love for Delphi and won my heart for their innovators. Thanks to the team for great products and a large volume of demos and manuals. You ROCK!

- Larry

In the past I have purchased other components from other parties. I will say proudly that TMS is the best in support, price and style. Whenever I need a help your team is always there to help me. Keep up the good work

- Mohamed Thooloon

❮ ❯

Bookmarks