diff options
Diffstat (limited to 'sc/inc/scfuncs.hrc')
| -rw-r--r-- | sc/inc/scfuncs.hrc | 106 |
1 files changed, 106 insertions, 0 deletions
diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc index 06eccaebd3fb..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[] = { @@ -4299,4 +4381,28 @@ const TranslateId SC_OPCODE_LET_ARY[] = NC_("SC_OPCODE_LET", "A calculation that uses all names within the LET function. This must be the last argument in the LET function. Or a second Name to assign to a second Name value. If a second Name is specified, Name value 2 and Calculation or Name 3 become required.") }; +// -=*# Resource for function WRAPCOLS #*=- +const TranslateId SC_OPCODE_WRAPCOLS_ARY[] = +{ + NC_("SC_OPCODE_WRAPCOLS", "Wraps the provided row or column of values by columns after a specified number of elements to form a new array."), + NC_("SC_OPCODE_WRAPCOLS", "Range"), + NC_("SC_OPCODE_WRAPCOLS", "the range to wrap."), + NC_("SC_OPCODE_WRAPCOLS", "Wrap count"), + NC_("SC_OPCODE_WRAPCOLS", "The maximum number of values for each column."), + NC_("SC_OPCODE_WRAPCOLS", "Pad with"), + NC_("SC_OPCODE_WRAPCOLS", "The value with which to pad. The default is #N/A.") +}; + +// -=*# Resource for function WRAPROWS #*=- +const TranslateId SC_OPCODE_WRAPROWS_ARY[] = +{ + NC_("SC_OPCODE_WRAPROWS", "Wraps the provided row or column of values by rows after a specified number of elements to form a new array."), + NC_("SC_OPCODE_WRAPROWS", "Range"), + NC_("SC_OPCODE_WRAPROWS", "the range to wrap."), + NC_("SC_OPCODE_WRAPROWS", "Wrap count"), + NC_("SC_OPCODE_WRAPROWS", "The maximum number of values for each row."), + NC_("SC_OPCODE_WRAPROWS", "Pad with"), + NC_("SC_OPCODE_WRAPROWS", "The value with which to pad. The default is #N/A.") +}; + /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |