https://bugs.documentfoundation.org/show_bug.cgi?id=151009
Andreas Heinisch <andreas.heini...@yahoo.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |andreas.heini...@yahoo.de
--- Comment #5 from Andreas Heinisch <andreas.heini...@yahoo.de> ---
The Field of the oSortFields variable is not counted from the beginning of a
sheet, but counted relatively from the selected range.
So, if you want to sort the data contained in column E, you don't have to
specify the Field parameter from the beginning of the sheet, but from the
beginning of the range:
REM Range from D to F
sText2 = "$D$1:$F$5"
oCellRange = oSheet.getCellRangeByName(sText2)
REM Sort by Column E descending (D has index 0, E has index 1, and F has index
2)
oSortFields(0).Field = 1
oSortFields(0).SortAscending = TRUE
oSortFields(0).FieldType = com.sun.star.util.SortFieldType.NUMERIC
Imho, this needs some clarification in the documentation.
--
You are receiving this mail because:
You are the assignee for the bug.
