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
| sub tri (colonne as integer , FeuilleATrier as string)
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
Dim monDocument As Object
Dim lesFeuilles as Object
Dim uneFeuille As Object
monDocument = ThisComponent
lesFeuilles = monDocument.Sheets
uneFeuille = lesFeuilles.getByName(FeuilleATrier)
monDocument.CurrentController.ActiveSheet = uneFeuille
rem ----------------------------------------------------------------------
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
dim args1(7) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ByRows"
args1(0).Value = true
args1(1).Name = "HasHeader"
args1(1).Value = true
args1(2).Name = "CaseSensitive"
args1(2).Value = false
args1(3).Name = "NaturalSort"
args1(3).Value = false
args1(4).Name = "IncludeAttribs"
args1(4).Value = true
args1(5).Name = "UserDefIndex"
args1(5).Value = 0
args1(6).Name = "Col1"
args1(6).Value = colonne
args1(7).Name = "Ascending1"
args1(7).Value = true
dispatcher.executeDispatch(document, ".uno:DataSort", "", 0, args1())
end sub |
Partager