diff options
| author | Balazs Varga <balazs.varga.extern@allotropia.de> | 2024-05-02 11:03:37 +0200 |
|---|---|---|
| committer | Balazs Varga <balazs.varga.extern@allotropia.de> | 2024-05-08 17:45:36 +0200 |
| commit | d68f2394afc3372d867ea6157123e51b278ba81b (patch) | |
| tree | 25880cdf3ea8e19548ab3687f00a9827e47b8bd2 /sc/inc | |
| parent | 4f5f24a4a3dac22e0f2c0d4832e0cbdd566263b9 (diff) | |
tdf#126573 Add Excel2021 array function RANDARRAY to Calc
Add new function called RANDARRAY to the function list.
(TODO: dynamic array in separate patch, oasis proposal)
Change-Id: I34bad3b7e8d631d649a0350d7c1170b26161331d
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/167003
Tested-by: Jenkins
Tested-by: Gabor Kelemen <gabor.kelemen.extern@allotropia.de>
Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>
Diffstat (limited to 'sc/inc')
| -rw-r--r-- | sc/inc/helpids.h | 1 | ||||
| -rw-r--r-- | sc/inc/scfuncs.hrc | 16 |
2 files changed, 17 insertions, 0 deletions
diff --git a/sc/inc/helpids.h b/sc/inc/helpids.h index 40b3abf7d9b1..87823578b966 100644 --- a/sc/inc/helpids.h +++ b/sc/inc/helpids.h @@ -594,6 +594,7 @@ inline constexpr OUString HID_FUNC_REGEX = u"SC_HID_FUNC_REGEX"_ustr; inline constexpr OUString HID_FUNC_FOURIER = u"SC_HID_FUNC_FOURIER"_ustr; inline constexpr OUString HID_FUNC_RAND_NV = u"SC_HID_FUNC_RAND_NV"_ustr; inline constexpr OUString HID_FUNC_RANDBETWEEN_NV = u"SC_HID_FUNC_RANDBETWEEN_NV"_ustr; +inline constexpr OUString HID_FUNC_RANDARRAY_MS = u"SC_HID_FUNC_RANDARRAY_MS"_ustr; inline constexpr OUString HID_FUNC_XLOOKUP_MS = u"SC_HID_FUNC_XLOOKUP_MS"_ustr; 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; diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc index 70354b9a9227..eaeb43326a87 100644 --- a/sc/inc/scfuncs.hrc +++ b/sc/inc/scfuncs.hrc @@ -4235,4 +4235,20 @@ const TranslateId SC_OPCODE_MAT_SEQUENCE_ARY[] = NC_("SC_OPCODE_MAT_SEQUENCE", "The amount to increment each subsequent value in the array.") }; +// -=*# Resource for function RANDARRAY #*=- +const TranslateId SC_OPCODE_RANDARRAY_ARY[] = +{ + NC_("SC_OPCODE_RANDARRAY", "RANDARRAY function generates an array of random numbers between two values."), + NC_("SC_OPCODE_RANDARRAY", "Rows"), + NC_("SC_OPCODE_RANDARRAY", "The number of rows to return."), + NC_("SC_OPCODE_RANDARRAY", "Columns"), + NC_("SC_OPCODE_RANDARRAY", "The number of columns to return."), + NC_("SC_OPCODE_RANDARRAY", "Min"), + NC_("SC_OPCODE_RANDARRAY", "The minimum number you would like returned."), + NC_("SC_OPCODE_RANDARRAY", "Max"), + NC_("SC_OPCODE_RANDARRAY", "The maximum number you would like returned."), + NC_("SC_OPCODE_RANDARRAY", "Whole number"), + NC_("SC_OPCODE_RANDARRAY", "Return a whole number or a decimal value.") +}; + /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |