1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
|
unit usortdemo;
{$mode objfpc}{$H+}
interface
uses
Classes, SysUtils, Forms, Controls, Graphics, Dialogs, StdCtrls,
// pour UTF8CompareStr dans DoCompareCells
// nécéssaire pour trier correctement les données contenant des espaces.
LazUTF8,
// pour spreadsheet
fpsTypes,
fpsutils,
fpspreadsheet, fpspreadsheetctrls, fpspreadsheetgrid;
type
TFsortdemo = class(TForm)
BtnLoad: TButton;
BtnSort: TButton;
wb: TsWorkbookSource;
ws: TsWorksheetGrid;
procedure BtnLoadClick(Sender: TObject);
procedure BtnSortClick(Sender: TObject);
// nécéssaire pour trier correctement les données contenant des espaces.
procedure DoCompareCells(Sender: TObject; ACell1, ACell2: PCell; ASortKey: TsSortKey; var AResult: Integer);
procedure FormCreate(Sender: TObject);
private
public
end;
var
Fsortdemo: TFsortdemo;
implementation
{$R *.lfm}
var
sortParams: TsSortParams;
// nécéssaire pour trier correctement les données contenant des espaces.
procedure TFsortdemo.DoCompareCells(Sender: TObject; ACell1, ACell2: PCell; ASortKey: TsSortKey; var AResult: Integer);
var
A, B: string;
begin
A := TsWorksheet(Sender).ReadAsText(ACell1^.row, ACell1^.col);
B := TsWorksheet(Sender).ReadAsText(ACell2^.row, ACell2^.col);
AResult := UTF8CompareStr(A, B);
if (ssoDescending in ASortKey.options) then AResult := -AResult;
end;
procedure TFsortdemo.BtnLoadClick(Sender: TObject);
begin
// initialisation et chargement manuel du Worksheet
with wb.Worksheet do begin
Clear;
WriteText(0, 0, 'ACinq');
WriteText(1, 0, 'A Huit');
WriteText(2, 0, 'ANeuf');
end;
end;
procedure TFsortdemo.BtnSortClick(Sender: TObject);
begin
sortParams := InitSortParams(true, 1); // Col sort, Number of sort (cols or rows)
sortParams.Keys[0].ColRowIndex := 0; // ColRowIndex Index of the sorted column or row
sortParams.Keys[0].Options := []; // TsSortOption = (ssoDescending, ssoCaseInsensitive, ssoAlphaBeforeNum)
with wb.Worksheet do begin
Sort(sortParams, 0, 0, GetLastRowIndex, GetLastColIndex);
end;
end;
procedure TFsortdemo.FormCreate(Sender: TObject);
begin
// nécéssaire pour trier correctement les données contenant des espaces.
wb.Worksheet.OnFullCompareCells := @DoCompareCells;
end;
end. |
Partager