summaryrefslogtreecommitdiff
path: root/sc/inc
diff options
context:
space:
mode:
authorXisco Fauli <xiscofauli@libreoffice.org>2025-01-31 15:51:15 +0100
committerXisco Fauli <xiscofauli@libreoffice.org>2025-02-01 09:06:05 +0100
commitd595e1aa4111054ca9abe722f23fa7bb54d3fb65 (patch)
tree23d825426dbdd096ba45e6672ec7bbee59d2303e /sc/inc
parentb0a4afc58e1c9434e56ddb96c41f4ebe5985ed0a (diff)
tdf#151000: Add support for CHOOSECOLS function
Change-Id: Id183f79a148080adebe652f63e29716910c638b2 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/180992 Tested-by: Jenkins Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
Diffstat (limited to 'sc/inc')
-rw-r--r--sc/inc/helpids.h1
-rw-r--r--sc/inc/scfuncs.hrc12
2 files changed, 13 insertions, 0 deletions
diff --git a/sc/inc/helpids.h b/sc/inc/helpids.h
index 582ef1457ab7..e961d70f5dc3 100644
--- a/sc/inc/helpids.h
+++ b/sc/inc/helpids.h
@@ -600,6 +600,7 @@ inline constexpr OUString HID_FUNC_XMATCH_MS = u"SC_HID_FUNC_XMATCH_MS"_ustr;
inline constexpr OUString HID_FUNC_FILTER_MS = u"SC_HID_FUNC_FILTER_MS"_ustr;
inline constexpr OUString HID_FUNC_SORT_MS = u"SC_HID_FUNC_SORT_MS"_ustr;
inline constexpr OUString HID_FUNC_SORTBY_MS = u"SC_HID_FUNC_SORTBY_MS"_ustr;
+inline constexpr OUString HID_FUNC_CHOOSECOLS_MS = u"SC_HID_FUNC_CHOOSECOLS_MS"_ustr;
inline constexpr OUString HID_FUNC_CHOOSEROWS_MS = u"SC_HID_FUNC_CHOOSEROWS_MS"_ustr;
inline constexpr OUString HID_FUNC_DROP_MS = u"SC_HID_FUNC_DROP_MS"_ustr;
inline constexpr OUString HID_FUNC_EXPAND_MS = u"SC_HID_FUNC_EXPAND_MS"_ustr;
diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc
index ca156da27fc3..d88090aaee2e 100644
--- a/sc/inc/scfuncs.hrc
+++ b/sc/inc/scfuncs.hrc
@@ -4251,6 +4251,18 @@ const TranslateId SC_OPCODE_RANDARRAY_ARY[] =
NC_("SC_OPCODE_RANDARRAY", "Return integer (TRUE) or decimal (FALSE) values.")
};
+// -=*# Resource for function CHOOSECOLS #*=-
+const TranslateId SC_OPCODE_CHOOSECOLS_ARY[] =
+{
+ NC_("SC_OPCODE_CHOOSECOLS", "Returns the specified columns from an array."),
+ NC_("SC_OPCODE_CHOOSECOLS", "Array"),
+ NC_("SC_OPCODE_CHOOSECOLS", "The array containing the rows to be returned in the new array."),
+ NC_("SC_OPCODE_CHOOSECOLS", "Column 1"),
+ NC_("SC_OPCODE_CHOOSECOLS", "The first column number to be returned."),
+ NC_("SC_OPCODE_CHOOSECOLS", "Column 2"),
+ NC_("SC_OPCODE_CHOOSECOLS", "Column 2, Column 3,... The list of column numbers to be returned.")
+};
+
// -=*# Resource for function CHOOSEROWS #*=-
const TranslateId SC_OPCODE_CHOOSEROWS_ARY[] =
{