nope,
My spreadsheet is built with others spreadsheets, some data can be identical in those spreadsheet, so i have to write identical data once.
I guess it would make the algorithm very slow and complicated if i had to sort datas before writing in the spreadsheet.
But anyway, I found my answer some minutes after I asked for help. Here's the answer if some people need it ;) :
my $SortOrd1 = $Sheet->Range("A2");
my $SortOrd2 = $Sheet->Range("B2");
my $SortOrd3 = $Sheet->Range("C2");
my $Selection = $Sheet->Range("A:M");
$Selection->Sort(
{Key1 => $SortOrd1,
Order1 => xlAscending,
Key2 => $SortOrd2,
Order2 => xlAscending,
Key3 => $SortOrd3,
Order3 => xlAscending,
});
|