VCL
TAdvSpreadGrid
Powerful spreadsheet function calculation support added to the full TAdvStringGrid feature set
Tips and Frequently Asked Questions
How to use the lookup function
LOOKUP(param; range1, range2) : returns the value of the element in range2 that has the index of the matching element in range1 for param
Example:
This code snippet shows how the lookup is performed for the value of 2 in range A1:A5 and the value is retrieved from range B1:B5
begin
advspreadGrid1.Cells[1,1] := '1';
advspreadGrid1.Cells[1,2] := '2';
advspreadGrid1.Cells[1,3] := '3';
advspreadGrid1.Cells[1,4] := '4';
advspreadGrid1.Cells[1,5] := '5';
advspreadGrid1.Cells[2,1] := 'BMW';
advspreadGrid1.Cells[2,2] := 'Audi';
advspreadGrid1.Cells[2,3] := 'Ferrari';
advspreadGrid1.Cells[2,4] := 'Mercedes';
advspreadGrid1.Cells[2,5] := 'Porsche';
advspreadGrid1.Cells[3,1] := '=LOOKUP("2";A1:A5;B1:B5)';
advspreadgrid1.Recalc;
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.