diff options
| author | Balazs Varga <balazs.varga.extern@allotropia.de> | 2024-03-13 11:07:10 +0100 |
|---|---|---|
| committer | Balazs Varga <balazs.varga.extern@allotropia.de> | 2024-03-25 15:54:01 +0100 |
| commit | 45435a680be065e44eba385bb2523b27b77fb451 (patch) | |
| tree | 8235cf3caa7c4c2c5c67044ed431e9493212093f /sc/inc/scfuncs.hrc | |
| parent | e6f000c64fa986a9539f68fe5fff096b0b4b7c48 (diff) | |
tdf#126573 Add Excel2021 array function SORT to Calc
TODO/WIP: oasis proposal
More information about how this new function works:
https://support.microsoft.com/en-au/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c
https://exceljet.net/functions/sort-function
Note: Move ScSortInfoArray class to sortparam.hxx, which is a more
logical place.
Change-Id: I70e720e93ba0414d54cb3437de0bfa066508fe30
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/164778
Tested-by: Jenkins
Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>
Diffstat (limited to 'sc/inc/scfuncs.hrc')
| -rw-r--r-- | sc/inc/scfuncs.hrc | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc index 5fa1c12808c1..5f612b957ce9 100644 --- a/sc/inc/scfuncs.hrc +++ b/sc/inc/scfuncs.hrc @@ -4195,4 +4195,18 @@ const TranslateId SC_OPCODE_FILTER_ARY[] = NC_("SC_OPCODE_FILTER", "The value to return if all values in the included array are empty (filter returns nothing).") }; +// -=*# Resource for function SORT #*=- +const TranslateId SC_OPCODE_SORT_ARY[] = +{ + NC_("SC_OPCODE_SORT", "Sorts the contents of a range or array."), + NC_("SC_OPCODE_SORT", "Range"), + NC_("SC_OPCODE_SORT", "The range, or array to sort."), + NC_("SC_OPCODE_SORT", "Sort index"), + NC_("SC_OPCODE_SORT", "A number indicating the row or column to sort by."), + NC_("SC_OPCODE_SORT", "Sort order"), + NC_("SC_OPCODE_SORT", "A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order."), + NC_("SC_OPCODE_SORT", "By col"), + NC_("SC_OPCODE_SORT", "A logical value indicating the desired sort direction; FALSE to sort by row (default), TRUE to sort by column.") +}; + /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |