VCL
TAdvSpreadGrid
Powerful spreadsheet function calculation support added to the full TAdvStringGrid feature set
Tips and Frequently Asked Questions
Using the expression parser / evaluator
The expression parser / evaluator of TAdvSpreadGrid, our spreadsheet component , can also be separately used. This expression evaluator is in the unit AdvFormula.
To use it, create an instance of the class TAdvFormula and it can be used in the following way:
var
Fm : TAdvFormula;
R: double;
begin
Fm := TAdvFormula.Create(self);
try
Fm.Expression := ''1+2'';
if Fm.Calc(r) then
showmessage(floattostr(r));
finally
Fm.Free;
end;
var
Fm : TAdvFormula;
R: double;
begin
Fm := TAdvFormula.Create(self);
try
fm.v[0] := 12;
fm.v[1] := 25;
Fm.Expression := ''V0+V1'';
if Fm.Calc(r) then
showmessage(floattostr(r));
finally
Fm.Free;
end;
end;
Compatibility
- Delphi 7, 2007, 2010, 2009, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney, 11 Alexandria, C++Builder 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio, 10.4 Sydney, 11 Alexandria (Professional/Enterprise/Architect)
Licensing
- Licensing FAQ
- License for commercial use: Single developer license, Small team license, Site license
- Includes full source code
- Ask questions to our engineers related to purchased product via Support Center
- Free 1 year updates and new releases
- After 1 year, a discount renewal is offered for a 1 year extension. *
* offer valid for 30 days after end of license. Discount price is subject to change.