spread COM中可否按多列进行同时排序？

spread COM中可否按多列进行同时排序？好像试了一下方法，没有作用，还只是按第一列排序！
   Dsp1.ColUserSortIndicator(1) = ColUserSortIndicatorAscending
    Dsp1.ColUserSortIndicator(2) = ColUserSortIndicatorAscending
    Dsp1.ColHeadersUserSortIndex = 1
    Dsp1.ColHeadersUserSortIndex = 2
    Dsp1.UserColAction = UserColActionSort

回复 1楼wlosg的帖子

你好，
需要使用 Sort 方法进行排序：

1. 
   
2.     Dim SortKeys, SortKeyOrder As Variant
   
3. 
   
4.     SortKeys = Array(1, 3)
   
5.     SortKeyOrder = Array(1, 1)
   
6.     fpSpread1.Sort 1, 1, 2, 4, SortByRow, SortKeys, SortKeyOrder
   

复制代码