1 files changed, 82 insertions, 0 deletions
diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc
index 86b3c2835b74..9cd11bfd44fc 100644
--- a/sc/inc/scfuncs.hrc
+++ b/sc/inc/scfuncs.hrc
@@ -4251,6 +4251,88 @@ 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[] =
+{
+    NC_("SC_OPCODE_CHOOSEROWS", "Returns the specified rows from an array."),
+    NC_("SC_OPCODE_CHOOSEROWS", "Array"),
+    NC_("SC_OPCODE_CHOOSEROWS", "The array containing the columns to be returned in the new array."),
+    NC_("SC_OPCODE_CHOOSEROWS", "Row 1"),
+    NC_("SC_OPCODE_CHOOSEROWS", "The first row number to be returned."),
+    NC_("SC_OPCODE_CHOOSEROWS", "Row 2"),
+    NC_("SC_OPCODE_CHOOSEROWS", "Row 2, Row 3,... The list of row numbers to be returned.")
+};
+
+// -=*# Resource for function DROP #*=-
+const TranslateId SC_OPCODE_DROP_ARY[] =
+{
+    NC_("SC_OPCODE_DROP", "Excludes a specified number of contiguous rows or columns from the start or end of an array."),
+    NC_("SC_OPCODE_DROP", "Array"),
+    NC_("SC_OPCODE_DROP", "The array from which to drop rows or columns."),
+    NC_("SC_OPCODE_DROP", "Rows"),
+    NC_("SC_OPCODE_DROP", "The number of rows to drop. A negative value drops from the end of the array."),
+    NC_("SC_OPCODE_DROP", "Column"),
+    NC_("SC_OPCODE_DROP", "The number of columns to drop. A negative value drops from the end of the array.")
+};
+
+// -=*# Resource for function EXPAND #*=-
+const TranslateId SC_OPCODE_EXPAND_ARY[] =
+{
+    NC_("SC_OPCODE_EXPAND", "Expands or pads an array to specified row and column dimensions."),
+    NC_("SC_OPCODE_EXPAND", "Array"),
+    NC_("SC_OPCODE_EXPAND", "The array to expand."),
+    NC_("SC_OPCODE_EXPAND", "Rows"),
+    NC_("SC_OPCODE_EXPAND", "The number of rows in the expanded array. If missing, rows will not be expanded."),
+    NC_("SC_OPCODE_EXPAND", "Column"),
+    NC_("SC_OPCODE_EXPAND", "The number of columns in the expanded array. If missing, columns will not be expanded."),
+    NC_("SC_OPCODE_EXPAND", "Pad with"),
+    NC_("SC_OPCODE_EXPAND", "The value with which to pad. The default is #N/A.")
+};
+
+// -=*# Resource for function HSTACK #*=-
+const TranslateId SC_OPCODE_HSTACK_ARY[] =
+{
+    NC_("SC_OPCODE_HSTACK", "Appends arrays horizontally to create a larger array"),
+    NC_("SC_OPCODE_HSTACK", "Array"),
+    NC_("SC_OPCODE_HSTACK", "The first array to append."),
+    NC_("SC_OPCODE_HSTACK", "Array 2"),
+    NC_("SC_OPCODE_HSTACK", "Array 2, Array 3,... The following arrays to append. if an array has fewer rows, #N/A error will be returned in the additional rows."),
+};
+
+// -=*# Resource for function VSTACK #*=-
+const TranslateId SC_OPCODE_VSTACK_ARY[] =
+{
+    NC_("SC_OPCODE_VSTACK", "Appends arrays vertically to create a larger array"),
+    NC_("SC_OPCODE_VSTACK", "Array"),
+    NC_("SC_OPCODE_VSTACK", "The first array to append."),
+    NC_("SC_OPCODE_VSTACK", "Array 2"),
+    NC_("SC_OPCODE_VSTACK", "Array 2, Array 3,... The following arrays to append. if an array has fewer columns, #N/A error will be returned in the additional columns."),
+};
+
+// -=*# Resource for function TAKE #*=-
+const TranslateId SC_OPCODE_TAKE_ARY[] =
+{
+    NC_("SC_OPCODE_TAKE", "Returns a specified number of contiguous rows or columns from the start or end of an array."),
+    NC_("SC_OPCODE_TAKE", "Array"),
+    NC_("SC_OPCODE_TAKE", "The array from which to take rows or columns."),
+    NC_("SC_OPCODE_TAKE", "Rows"),
+    NC_("SC_OPCODE_TAKE", "The number of rows to take. A negative value takes from the end of the array."),
+    NC_("SC_OPCODE_TAKE", "Column"),
+    NC_("SC_OPCODE_TAKE", "The number of columns to take. A negative value takes from the end of the array.")
+};
+
 // -=*# Resource for function TOCOL #*=-
 const TranslateId SC_OPCODE_TOCOL_ARY[] =
 {