diff options
| author | Xisco Fauli <xiscofauli@libreoffice.org> | 2025-01-15 23:31:12 +0100 |
|---|---|---|
| committer | Xisco Fauli <xiscofauli@libreoffice.org> | 2025-01-16 14:13:20 +0100 |
| commit | 6b620171f6b3fb15f48890d46fb6e8fb51bfd383 (patch) | |
| tree | b022bd155dfa5147f034a79f4845a85d201fda19 /sc/inc | |
| parent | 41de340e048c3545480c0cd209f4d1a3bb9b83ff (diff) | |
tdf#150878: Add support for TOROW function
Change-Id: Ic1acb5c2fd08ecab7c3ee059888cf44aa45ee287
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/180308
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
Diffstat (limited to 'sc/inc')
| -rw-r--r-- | sc/inc/helpids.h | 1 | ||||
| -rw-r--r-- | sc/inc/scfuncs.hrc | 12 |
2 files changed, 13 insertions, 0 deletions
diff --git a/sc/inc/helpids.h b/sc/inc/helpids.h index 4d645ea88715..d47f1275f0e9 100644 --- a/sc/inc/helpids.h +++ b/sc/inc/helpids.h @@ -601,6 +601,7 @@ 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_TOCOL_MS = u"SC_HID_FUNC_TOCOL_MS"_ustr; +inline constexpr OUString HID_FUNC_TOROW_MS = u"SC_HID_FUNC_TOROW_MS"_ustr; inline constexpr OUString HID_FUNC_UNIQUE_MS = u"SC_HID_FUNC_UNIQUE_MS"_ustr; inline constexpr OUString HID_FUNC_LET_MS = u"SC_HID_FUNC_LET_MS"_ustr; diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc index d9135b41c144..06eccaebd3fb 100644 --- a/sc/inc/scfuncs.hrc +++ b/sc/inc/scfuncs.hrc @@ -4263,6 +4263,18 @@ const TranslateId SC_OPCODE_TOCOL_ARY[] = NC_("SC_OPCODE_TOCOL", "Scan the array by column. FALSE or omitted (default) - the array is scanned by row. TRUE - the array is scanned by column.") }; +// -=*# Resource for function TOROW #*=- +const TranslateId SC_OPCODE_TOROW_ARY[] = +{ + NC_("SC_OPCODE_TOROW", "transforms an array into a single row."), + NC_("SC_OPCODE_TOROW", "Array"), + NC_("SC_OPCODE_TOROW", "The range or array to return as a row."), + NC_("SC_OPCODE_TOROW", "Ignore"), + NC_("SC_OPCODE_TOROW", "Whether to ignore certain types of values. 0 or omitted - keep all values (default). 1 - ignore blanks. 2 - ignore errors. 3 - ignore blanks and errors."), + NC_("SC_OPCODE_TOROW", "Scan by column"), + NC_("SC_OPCODE_TOROW", "Scan the array by column. FALSE or omitted (default) - the array is scanned by row. TRUE - the array is scanned by column.") +}; + // -=*# Resource for function UNIQUE #*=- const TranslateId SC_OPCODE_UNIQUE_ARY[] = { |