Whether there are bugs in SetSort for macros

Document Builder
1

my version is 7.4
I found a problem with API sorting
my marcos I found a problem with API sorting :
oWorksheet.GetRange(“B1:C5”).SetSort(“B1:B5”, “xlDescending”, “xlNo”, “xlSortRows”);
oWorksheet.GetRange(“A4”).SetValue(“1”);
but the result is not what I expected, and I tried to adjust the marcos code ,But it doesn’t work

2

Hi @yuhui,
Sorry, but the SetSort method is currently bugged. Once it is fixed, we will notify you.

4

ok,thanks,Looking forward to resolving the problem