diff options
author | Noel Grandin <noel.grandin@collabora.co.uk> | 2021-07-19 13:18:49 +0200 |
---|---|---|
committer | Noel Grandin <noel.grandin@collabora.co.uk> | 2021-08-05 09:39:11 +0200 |
commit | 14cfff500e93f0d6cbf8412065feea85c01ea81d (patch) | |
tree | 76e3fb8fbf2b0d8a12c8406d8cf994ea6a37aaff /sc | |
parent | d924ce30e0ca260682bd2aed192b8b1b2ca3e7c0 (diff) |
Pass context and resource string down to boost::locale separately
because this is often on a hot path, and we can avoid the splitting and
joining of strings like this.
Change-Id: Ia36047209368ca53431178c2e8723a18cfe8260a
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/119220
Tested-by: Jenkins
Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
Diffstat (limited to 'sc')
89 files changed, 545 insertions, 537 deletions
diff --git a/sc/inc/compiler.hrc b/sc/inc/compiler.hrc index 8e7b50dafb06..e77dd26ea6a4 100644 --- a/sc/inc/compiler.hrc +++ b/sc/inc/compiler.hrc @@ -19,9 +19,11 @@ #pragma once -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) +#include <unotools/resmgr.hxx> -const char* RID_FUNCTION_CATEGORIES[] = +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) + +const TranslateId RID_FUNCTION_CATEGORIES[] = { NC_("RID_FUNCTION_CATEGORIES", "Database"), NC_("RID_FUNCTION_CATEGORIES", "Date&Time"), diff --git a/sc/inc/dpobject.hxx b/sc/inc/dpobject.hxx index 6d740769637c..3552f14fb657 100644 --- a/sc/inc/dpobject.hxx +++ b/sc/inc/dpobject.hxx @@ -29,6 +29,7 @@ #include <com/sun/star/sheet/DataPilotFieldOrientation.hpp> #include <o3tl/sorted_vector.hxx> +#include <unotools/resmgr.hxx> #include <memory> #include <vector> @@ -383,7 +384,7 @@ public: ScDPCollection(const ScDPCollection& r); ~ScDPCollection(); - const char* ReloadCache(const ScDPObject* pDPObj, o3tl::sorted_vector<ScDPObject*>& rRefs); + TranslateId ReloadCache(const ScDPObject* pDPObj, o3tl::sorted_vector<ScDPObject*>& rRefs); bool ReloadGroupsInCache(const ScDPObject* pDPObj, o3tl::sorted_vector<ScDPObject*>& rRefs); SC_DLLPUBLIC bool GetReferenceGroups(const ScDPObject& rDPObj, const ScDPDimensionSaveData** pGroups) const; diff --git a/sc/inc/dpshttab.hxx b/sc/inc/dpshttab.hxx index 39406a7c4386..c34482bc2105 100644 --- a/sc/inc/dpshttab.hxx +++ b/sc/inc/dpshttab.hxx @@ -23,6 +23,7 @@ #include "address.hxx" #include "scdllapi.h" #include "queryparam.hxx" +#include <unotools/resmgr.hxx> #include <unordered_set> #include <vector> @@ -70,7 +71,7 @@ public: * @return nullptr if the source range is sane, otherwise an error message ID is * returned. */ - const char* CheckSourceRange() const; + TranslateId CheckSourceRange() const; private: mutable ScRange maSourceRange; diff --git a/sc/inc/globstr.hrc b/sc/inc/globstr.hrc index 4e0eb49d6f63..44776504b47e 100644 --- a/sc/inc/globstr.hrc +++ b/sc/inc/globstr.hrc @@ -20,8 +20,8 @@ #ifndef SC_GLOBSTR_HRC #define SC_GLOBSTR_HRC -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) -#define NNC_(Context, StringSingular, StringPlural) reinterpret_cast<char const *>(Context "\004" u8##StringSingular "\004" u8##StringPlural) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) +#define NNC_(Context, StringSingular, StringPlural) TranslateNId(Context, reinterpret_cast<char const *>(u8##StringSingular), reinterpret_cast<char const *>(u8##StringPlural)) /* * This file is reserved for string IDs of permanently loaded resident string diff --git a/sc/inc/pvfundlg.hrc b/sc/inc/pvfundlg.hrc index 9c890035a68c..0f3fe4dd424f 100644 --- a/sc/inc/pvfundlg.hrc +++ b/sc/inc/pvfundlg.hrc @@ -19,9 +19,9 @@ #pragma once -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) -const char* SCSTR_DPFUNCLISTBOX[] = +const TranslateId SCSTR_DPFUNCLISTBOX[] = { NC_("SCSTR_DPFUNCLISTBOX", "Sum"), NC_("SCSTR_DPFUNCLISTBOX", "Count"), diff --git a/sc/inc/scerrors.hrc b/sc/inc/scerrors.hrc index 82f23585ff70..b2ee886174ee 100644 --- a/sc/inc/scerrors.hrc +++ b/sc/inc/scerrors.hrc @@ -19,7 +19,7 @@ #pragma once -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) #include <svtools/ehdl.hxx> #include "scerrors.hxx" @@ -103,7 +103,7 @@ const ErrMsgCode RID_ERRHDLSC[] = SCWARN_IMPORT_FILE_ROWCOL }, { NC_("RID_ERRHDLSC", "Not all attributes could be read.") , SCWARN_IMPORT_FEATURES_LOST }, - { nullptr, ERRCODE_NONE } + { {}, ERRCODE_NONE } }; /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/sc/inc/scfuncs.hrc b/sc/inc/scfuncs.hrc index b8ac0476956c..88d78f2f7c28 100644 --- a/sc/inc/scfuncs.hrc +++ b/sc/inc/scfuncs.hrc @@ -18,7 +18,7 @@ */ #pragma once -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) /* Resource file for the function wizard / autopilot. * @@ -31,7 +31,7 @@ */ // -=*# Resource for function DCOUNT #*=- -const char* SC_OPCODE_DB_COUNT_ARY[] = +const TranslateId SC_OPCODE_DB_COUNT_ARY[] = { NC_("SC_OPCODE_DB_COUNT", "Counts the cells of a data range whose contents match the search criteria."), NC_("SC_OPCODE_DB_COUNT", "Database"), @@ -43,7 +43,7 @@ const char* SC_OPCODE_DB_COUNT_ARY[] = }; // -=*# Resource for function DCOUNTA #*=- -const char* SC_OPCODE_DB_COUNT_2_ARY[] = +const TranslateId SC_OPCODE_DB_COUNT_2_ARY[] = { NC_("SC_OPCODE_DB_COUNT_2", "Counts all non-blank cells of a data range where the content corresponds to the search criteria."), NC_("SC_OPCODE_DB_COUNT_2", "Database"), @@ -55,7 +55,7 @@ const char* SC_OPCODE_DB_COUNT_2_ARY[] = }; // -=*# Resource for function DAVERAGE #*=- -const char* SC_OPCODE_DB_AVERAGE_ARY[] = +const TranslateId SC_OPCODE_DB_AVERAGE_ARY[] = { NC_("SC_OPCODE_DB_AVERAGE", "Returns the average value of all the cells of a data range whose contents match the search criteria."), NC_("SC_OPCODE_DB_AVERAGE", "Database"), @@ -67,7 +67,7 @@ const char* SC_OPCODE_DB_AVERAGE_ARY[] = }; // -=*# Resource for function DGET #*=- -const char* SC_OPCODE_DB_GET_ARY[] = +const TranslateId SC_OPCODE_DB_GET_ARY[] = { NC_("SC_OPCODE_DB_GET", "Defines the contents of the cell of a data range which matches the search criteria."), NC_("SC_OPCODE_DB_GET", "Database"), @@ -79,7 +79,7 @@ const char* SC_OPCODE_DB_GET_ARY[] = }; // -=*# Resource for function DMAX #*=- -const char* SC_OPCODE_DB_MAX_ARY[] = +const TranslateId SC_OPCODE_DB_MAX_ARY[] = { NC_("SC_OPCODE_DB_MAX", "Returns the maximum value from all of the cells of a data range which correspond to the search criteria."), NC_("SC_OPCODE_DB_MAX", "Database"), @@ -91,7 +91,7 @@ const char* SC_OPCODE_DB_MAX_ARY[] = }; // -=*# Resource for function DMIN #*=- -const char* SC_OPCODE_DB_MIN_ARY[] = +const TranslateId SC_OPCODE_DB_MIN_ARY[] = { NC_("SC_OPCODE_DB_MIN", "Returns the minimum of all cells of a data range where the contents correspond to the search criteria."), NC_("SC_OPCODE_DB_MIN", "Database"), @@ -103,7 +103,7 @@ const char* SC_OPCODE_DB_MIN_ARY[] = }; // -=*# Resource for function DPRODUCT #*=- -const char* SC_OPCODE_DB_PRODUCT_ARY[] = +const TranslateId SC_OPCODE_DB_PRODUCT_ARY[] = { NC_("SC_OPCODE_DB_PRODUCT", "Multiplies all cells of a data range where the contents match the search criteria."), NC_("SC_OPCODE_DB_PRODUCT", "Database"), @@ -115,7 +115,7 @@ const char* SC_OPCODE_DB_PRODUCT_ARY[] = }; // -=*# Resource for function DSTDEV #*=- -const char* SC_OPCODE_DB_STD_DEV_ARY[] = +const TranslateId SC_OPCODE_DB_STD_DEV_ARY[] = { NC_("SC_OPCODE_DB_STD_DEV", "Calculates the standard deviation of all cells in a data range whose contents match the search criteria."), NC_("SC_OPCODE_DB_STD_DEV", "Database"), @@ -127,7 +127,7 @@ const char* SC_OPCODE_DB_STD_DEV_ARY[] = }; // -=*# Resource for function DSTDEVP #*=- -const char* SC_OPCODE_DB_STD_DEV_P_ARY[] = +const TranslateId SC_OPCODE_DB_STD_DEV_P_ARY[] = { NC_("SC_OPCODE_DB_STD_DEV_P", "Returns the standard deviation with regards to the population of all cells of a data range matching the search criteria."), NC_("SC_OPCODE_DB_STD_DEV_P", "Database"), @@ -139,7 +139,7 @@ const char* SC_OPCODE_DB_STD_DEV_P_ARY[] = }; // -=*# Resource for function DSUM #*=- -const char* SC_OPCODE_DB_SUM_ARY[] = +const TranslateId SC_OPCODE_DB_SUM_ARY[] = { NC_("SC_OPCODE_DB_SUM", "Adds all the cells of a data range where the contents match the search criteria."), NC_("SC_OPCODE_DB_SUM", "Database"), @@ -151,7 +151,7 @@ const char* SC_OPCODE_DB_SUM_ARY[] = }; // -=*# Resource for function DVAR #*=- -const char* SC_OPCODE_DB_VAR_ARY[] = +const TranslateId SC_OPCODE_DB_VAR_ARY[] = { NC_("SC_OPCODE_DB_VAR", "Determines the variance of all the cells in a data range where the contents match the search criteria."), NC_("SC_OPCODE_DB_VAR", "Database"), @@ -163,7 +163,7 @@ const char* SC_OPCODE_DB_VAR_ARY[] = }; // -=*# Resource for function DVARP #*=- -const char* SC_OPCODE_DB_VAR_P_ARY[] = +const TranslateId SC_OPCODE_DB_VAR_P_ARY[] = { NC_("SC_OPCODE_DB_VAR_P", "Determines variance of a population based on all cells in a data range where contents match the search criteria."), NC_("SC_OPCODE_DB_VAR_P", "Database"), @@ -175,7 +175,7 @@ const char* SC_OPCODE_DB_VAR_P_ARY[] = }; // -=*# Resource for function DATE #*=- -const char* SC_OPCODE_GET_DATE_ARY[] = +const TranslateId SC_OPCODE_GET_DATE_ARY[] = { NC_("SC_OPCODE_GET_DATE", "Provides an internal number for the date given."), NC_("SC_OPCODE_GET_DATE", "Year"), @@ -187,7 +187,7 @@ const char* SC_OPCODE_GET_DATE_ARY[] = }; // -=*# Resource for function DATE_VALUE #*=- -const char* SC_OPCODE_GET_DATE_VALUE_ARY[] = +const TranslateId SC_OPCODE_GET_DATE_VALUE_ARY[] = { NC_("SC_OPCODE_GET_DATE_VALUE", "Returns an internal number for a text having a possible date format."), NC_("SC_OPCODE_GET_DATE_VALUE", "Text"), @@ -195,7 +195,7 @@ const char* SC_OPCODE_GET_DATE_VALUE_ARY[] = }; // -=*# Resource for function DAY #*=- -const char* SC_OPCODE_GET_DAY_ARY[] = +const TranslateId SC_OPCODE_GET_DAY_ARY[] = { NC_("SC_OPCODE_GET_DAY", "Returns the sequential date of the month as an integer (1-31) in relation to the date value."), NC_("SC_OPCODE_GET_DAY", "Number"), @@ -203,7 +203,7 @@ const char* SC_OPCODE_GET_DAY_ARY[] = }; // -=*# Resource for function DAYS360 #*=- -const char* SC_OPCODE_GET_DIFF_DATE_360_ARY[] = +const TranslateId SC_OPCODE_GET_DIFF_DATE_360_ARY[] = { NC_("SC_OPCODE_GET_DIFF_DATE_360", "Calculates the number of days between two dates based on a 360-day year."), NC_("SC_OPCODE_GET_DIFF_DATE_360", "Date 1"), @@ -215,7 +215,7 @@ const char* SC_OPCODE_GET_DIFF_DATE_360_ARY[] = }; // -=*# Resource for function NETWORKDAYS #*=- -const char* SC_OPCODE_NETWORKDAYS_ARY[] = +const TranslateId SC_OPCODE_NETWORKDAYS_ARY[] = { NC_("SC_OPCODE_NETWORKDAYS", "Returns the number of workdays between two dates using arguments to indicate weekenddays and holidays."), NC_("SC_OPCODE_NETWORKDAYS", "Start date"), @@ -229,7 +229,7 @@ const char* SC_OPCODE_NETWORKDAYS_ARY[] = }; // -=*# Resource for function NETWORKDAYS.INTL #*=- -const char* SC_OPCODE_NETWORKDAYS_MS_ARY[] = +const TranslateId SC_OPCODE_NETWORKDAYS_MS_ARY[] = { NC_("SC_OPCODE_NETWORKDAYS_MS", "Returns the number of workdays between two dates using arguments to indicate weekend days and holidays."), NC_("SC_OPCODE_NETWORKDAYS_MS", "Start date"), @@ -243,7 +243,7 @@ const char* SC_OPCODE_NETWORKDAYS_MS_ARY[] = }; // -=*# Resource for function WORKDAY.INTL #*=- -const char* SC_OPCODE_WORKDAY_MS_ARY[] = +const TranslateId SC_OPCODE_WORKDAY_MS_ARY[] = { NC_("SC_OPCODE_WORKDAY_MS", "Returns the serial number of the date before or after a number of workdays using arguments to indicate weekend days and holidays."), NC_("SC_OPCODE_WORKDAY_MS", "Start date"), @@ -257,7 +257,7 @@ const char* SC_OPCODE_WORKDAY_MS_ARY[] = }; // -=*# Resource for function HOUR #*=- -const char* SC_OPCODE_GET_HOUR_ARY[] = +const TranslateId SC_OPCODE_GET_HOUR_ARY[] = { NC_("SC_OPCODE_GET_HOUR", "Determines the sequential number of the hour of the day (0-23) for the time value."), NC_("SC_OPCODE_GET_HOUR", "Number"), @@ -265,7 +265,7 @@ const char* SC_OPCODE_GET_HOUR_ARY[] = }; // -=*# Resource for function MINUTE #*=- -const char* SC_OPCODE_GET_MIN_ARY[] = +const TranslateId SC_OPCODE_GET_MIN_ARY[] = { NC_("SC_OPCODE_GET_MIN", "Determines the sequential number for the minute of the hour (0-59) for the time value."), NC_("SC_OPCODE_GET_MIN", "Number"), @@ -273,7 +273,7 @@ const char* SC_OPCODE_GET_MIN_ARY[] = }; // -=*# Resource for function MONTH #*=- -const char* SC_OPCODE_GET_MONTH_ARY[] = +const TranslateId SC_OPCODE_GET_MONTH_ARY[] = { NC_("SC_OPCODE_GET_MONTH", "Determines the sequential number of a month of the year (1-12) for the date value."), NC_("SC_OPCODE_GET_MONTH", "Number"), @@ -281,13 +281,13 @@ const char* SC_OPCODE_GET_MONTH_ARY[] = }; // -=*# Resource for function NOW #*=- -const char* SC_OPCODE_GET_ACT_TIME_ARY[] = +const TranslateId SC_OPCODE_GET_ACT_TIME_ARY[] = { NC_("SC_OPCODE_GET_ACT_TIME", "Determines the current time of the computer.") }; // -=*# Resource for function SECOND #*=- -const char*SC_OPCODE_GET_SEC_ARY[] = +const TranslateId SC_OPCODE_GET_SEC_ARY[] = { NC_("SC_OPCODE_GET_SEC", "Determines the sequential number of the second of a minute (0-59) for the time value."), NC_("SC_OPCODE_GET_SEC", "Number"), @@ -295,7 +295,7 @@ const char*SC_OPCODE_GET_SEC_ARY[] = }; // -=*# Resource for function TIME #*=- -const char* SC_OPCODE_GET_TIME_ARY[] = +const TranslateId SC_OPCODE_GET_TIME_ARY[] = { NC_("SC_OPCODE_GET_TIME", "Determines a time value from the details for hour, minute and second."), NC_("SC_OPCODE_GET_TIME", "Hour"), @@ -307,7 +307,7 @@ const char* SC_OPCODE_GET_TIME_ARY[] = }; // -=*# Resource for function TIMEVALUE #*=- -const char* SC_OPCODE_GET_TIME_VALUE_ARY[] = +const TranslateId SC_OPCODE_GET_TIME_VALUE_ARY[] = { NC_("SC_OPCODE_GET_TIME_VALUE", "Returns a sequential number for a text shown in a possible time entry format."), NC_("SC_OPCODE_GET_TIME_VALUE", "Text"), @@ -315,13 +315,13 @@ const char* SC_OPCODE_GET_TIME_VALUE_ARY[] = }; // -=*# Resource for function TODAY #*=- -const char* SC_OPCODE_GET_ACT_DATE_ARY[] = +const TranslateId SC_OPCODE_GET_ACT_DATE_ARY[] = { NC_("SC_OPCODE_GET_ACT_DATE", "Determines the current date of the computer.") }; // -=*# Resource for function WEEKDAY #*=- -const char* SC_OPCODE_GET_DAY_OF_WEEK_ARY[] = +const TranslateId SC_OPCODE_GET_DAY_OF_WEEK_ARY[] = { NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Returns the day of the week for the date value as an integer."), NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Number"), @@ -331,7 +331,7 @@ const char* SC_OPCODE_GET_DAY_OF_WEEK_ARY[] = }; // -=*# Resource for function YEAR #*=- -const char* SC_OPCODE_GET_YEAR_ARY[] = +const TranslateId SC_OPCODE_GET_YEAR_ARY[] = { NC_("SC_OPCODE_GET_YEAR", "Returns the year of a date value as an integer."), NC_("SC_OPCODE_GET_YEAR", "Number"), @@ -339,7 +339,7 @@ const char* SC_OPCODE_GET_YEAR_ARY[] = }; // -=*# Resource for function DAYS #*=- -const char* SC_OPCODE_GET_DIFF_DATE_ARY[] = +const TranslateId SC_OPCODE_GET_DIFF_DATE_ARY[] = { NC_("SC_OPCODE_GET_DIFF_DATE", "Calculates the number of days between two dates."), NC_("SC_OPCODE_GET_DIFF_DATE", "Date 2"), @@ -349,7 +349,7 @@ const char* SC_OPCODE_GET_DIFF_DATE_ARY[] = }; // -=*# Resource for function DATEDIF #*=- -const char* SC_OPCODE_GET_DATEDIF_ARY[] = +const TranslateId SC_OPCODE_GET_DATEDIF_ARY[] = { NC_("SC_OPCODE_GET_DATEDIF", "Returns the number of whole days, months or years between 'start date' and 'end date'."), NC_("SC_OPCODE_GET_DATEDIF", "Start date"), @@ -361,7 +361,7 @@ const char* SC_OPCODE_GET_DATEDIF_ARY[] = }; // -=*# Resource for function WEEKNUM #*=- -const char* SC_OPCODE_WEEK_ARY[] = +const TranslateId SC_OPCODE_WEEK_ARY[] = { NC_("SC_OPCODE_WEEK", "Calculates the calendar week corresponding to the given date."), NC_("SC_OPCODE_WEEK", "Number"), @@ -371,14 +371,14 @@ const char* SC_OPCODE_WEEK_ARY[] = }; // -=*# Resource for function ISOWEEKNUM #*=- -const char* SC_OPCODE_ISOWEEKNUM_ARY[] = +const TranslateId SC_OPCODE_ISOWEEKNUM_ARY[] = { NC_("SC_OPCODE_ISOWEEKNUM", "Calculates the ISO 8601 calendar week for the given date."), NC_("SC_OPCODE_ISOWEEKNUM", "Number"), NC_("SC_OPCODE_ISOWEEKNUM", "The internal number of the date.") }; -const char* SC_OPCODE_WEEKNUM_OOO_ARY[] = +const TranslateId SC_OPCODE_WEEKNUM_OOO_ARY[] = { NC_("SC_OPCODE_WEEKNUM_OOO", "Calculates the calendar week corresponding to the given date.\nThis function only provides interoperability with %PRODUCTNAME 5.0 and earlier and OpenOffice.org."), NC_("SC_OPCODE_WEEKNUM_OOO", "Number"), @@ -388,7 +388,7 @@ const char* SC_OPCODE_WEEKNUM_OOO_ARY[] = }; // -=*# Resource for function EASTERSUNDAY #*=- -const char* SC_OPCODE_EASTERSUNDAY_ARY[] = +const TranslateId SC_OPCODE_EASTERSUNDAY_ARY[] = { NC_("SC_OPCODE_EASTERSUNDAY", "Calculates the date of Easter Sunday in a given year."), NC_("SC_OPCODE_EASTERSUNDAY", "Year"), @@ -396,7 +396,7 @@ const char* SC_OPCODE_EASTERSUNDAY_ARY[] = }; // -=*# Resource for function PV #*=- -const char* SC_OPCODE_PV_ARY[] = +const TranslateId SC_OPCODE_PV_ARY[] = { NC_("SC_OPCODE_PV", "Present value. Calculates the present value of an investment."), NC_("SC_OPCODE_PV", "Rate"), @@ -412,7 +412,7 @@ const char* SC_OPCODE_PV_ARY[] = }; // -=*# Resource for function FV #*=- -const char* SC_OPCODE_FV_ARY[] = +const TranslateId SC_OPCODE_FV_ARY[] = { NC_("SC_OPCODE_FV", "Future value. Returns the future value of an investment based on regular payments and a constant interest rate."), NC_("SC_OPCODE_FV", "Rate"), @@ -428,7 +428,7 @@ const char* SC_OPCODE_FV_ARY[] = }; // -=*# Resource for function NPER #*=- -const char* SC_OPCODE_NPER_ARY[] = +const TranslateId SC_OPCODE_NPER_ARY[] = { NC_("SC_OPCODE_NPER", "Payment period. Calculates the number of payment periods for an investment based on regular payments and a constant interest rate."), NC_("SC_OPCODE_NPER", "Rate"), @@ -444,7 +444,7 @@ const char* SC_OPCODE_NPER_ARY[] = }; // -=*# Resource for function PMT #*=- -const char* SC_OPCODE_PMT_ARY[] = +const TranslateId SC_OPCODE_PMT_ARY[] = { NC_("SC_OPCODE_PMT", "Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate."), NC_("SC_OPCODE_PMT", "Rate"), @@ -460,7 +460,7 @@ const char* SC_OPCODE_PMT_ARY[] = }; // -=*# Resource for function RATE #*=- -const char* SC_OPCODE_RATE_ARY[] = +const TranslateId SC_OPCODE_RATE_ARY[] = { NC_("SC_OPCODE_RATE", "Calculates the constant interest rate of an investment with regular payments."), NC_("SC_OPCODE_RATE", "NPER"), @@ -478,7 +478,7 @@ const char* SC_OPCODE_RATE_ARY[] = }; // -=*# Resource for function IPMT #*=- -const char* SC_OPCODE_IPMT_ARY[] = +const TranslateId SC_OPCODE_IPMT_ARY[] = { NC_("SC_OPCODE_IPMT", "Compounded interest. Calculates the interest payment on the principal for an investment with regular payments and a constant interest rate for a given period."), NC_("SC_OPCODE_IPMT", "Rate"), @@ -496,7 +496,7 @@ const char* SC_OPCODE_IPMT_ARY[] = }; // -=*# Resource for function PPMT #*=- -const char* SC_OPCODE_PPMT_ARY[] = +const TranslateId SC_OPCODE_PPMT_ARY[] = { NC_("SC_OPCODE_PPMT", "Repayment. Calculates the repayment amount for a period for an investment whereby the payments are at regular intervals and the interest rate constant."), NC_("SC_OPCODE_PPMT", "Rate"), @@ -514,7 +514,7 @@ const char* SC_OPCODE_PPMT_ARY[] = }; // -=*# Resource for function CUMPRINC #*=- -const char* SC_OPCODE_CUM_PRINC_ARY[] = +const TranslateId SC_OPCODE_CUM_PRINC_ARY[] = { NC_("SC_OPCODE_CUM_PRINC", "Cumulative capital. Calculates the total amount of the repayment share in a period for an investment with constant interest rate."), NC_("SC_OPCODE_CUM_PRINC", "Rate"), @@ -532,7 +532,7 @@ const char* SC_OPCODE_CUM_PRINC_ARY[] = }; // -=*# Resource for function CUMIPMT #*=- -const char* SC_OPCODE_CUM_IPMT_ARY[] = +const TranslateId SC_OPCODE_CUM_IPMT_ARY[] = { NC_("SC_OPCODE_CUM_IPMT", "Cumulative compounded interest. Calculates the total amount of the interest share in a period for an investment with a constant interest rate."), NC_("SC_OPCODE_CUM_IPMT", "Rate"), @@ -550,7 +550,7 @@ const char* SC_OPCODE_CUM_IPMT_ARY[] = }; // -=*# Resource for function SYD #*=- -const char* SC_OPCODE_SYD_ARY[] = +const TranslateId SC_OPCODE_SYD_ARY[] = { NC_("SC_OPCODE_SYD", "Calculates the arithmetically declining value of an asset (depreciation) for a specified period."), NC_("SC_OPCODE_SYD", "Cost"), @@ -564,7 +564,7 @@ const char* SC_OPCODE_SYD_ARY[] = }; // -=*# Resource for function SLN #*=- -const char* SC_OPCODE_SLN_ARY[] = +const TranslateId SC_OPCODE_SLN_ARY[] = { NC_("SC_OPCODE_SLN", "Calculates the linear depreciation per period."), NC_("SC_OPCODE_SLN", "Cost"), @@ -576,7 +576,7 @@ const char* SC_OPCODE_SLN_ARY[] = }; // -=*# Resource for function DDB #*=- -const char* SC_OPCODE_DDB_ARY[] = +const TranslateId SC_OPCODE_DDB_ARY[] = { NC_("SC_OPCODE_DDB", "Calculates the depreciation of an asset for a specific period using the double-declining balance method or declining balance factor."), NC_("SC_OPCODE_DDB", "Cost"), @@ -592,7 +592,7 @@ const char* SC_OPCODE_DDB_ARY[] = }; // -=*# Resource for function DB #*=- -const char* SC_OPCODE_DB_ARY[] = +const TranslateId SC_OPCODE_DB_ARY[] = { NC_("SC_OPCODE_DB", "Returns the real depreciation of an asset for a specified period using the fixed-declining balance method."), NC_("SC_OPCODE_DB", "Cost"), @@ -608,7 +608,7 @@ const char* SC_OPCODE_DB_ARY[] = }; // -=*# Resource for function VDB #*=- -const char* SC_OPCODE_VBD_ARY[] = +const TranslateId SC_OPCODE_VBD_ARY[] = { NC_("SC_OPCODE_VBD", "Variable declining balance. Returns the declining balance depreciation for a particular period."), NC_("SC_OPCODE_VBD", "Cost"), @@ -628,7 +628,7 @@ const char* SC_OPCODE_VBD_ARY[] = }; // -=*# Resource for function EFFECT #*=- -const char* SC_OPCODE_EFFECT_ARY[] = +const TranslateId SC_OPCODE_EFFECT_ARY[] = { NC_("SC_OPCODE_EFFECT", "Calculates the annual net interest rate for a nominal interest rate."), NC_("SC_OPCODE_EFFECT", "NOM"), @@ -638,7 +638,7 @@ const char* SC_OPCODE_EFFECT_ARY[] = }; // -=*# Resource for function NOMINAL #*=- -const char* SC_OPCODE_NOMINAL_ARY[] = +const TranslateId SC_OPCODE_NOMINAL_ARY[] = { NC_("SC_OPCODE_NOMINAL", "Calculates the yearly nominal interest rate as an effective interest rate."), NC_("SC_OPCODE_NOMINAL", "Effective rate"), @@ -648,7 +648,7 @@ const char* SC_OPCODE_NOMINAL_ARY[] = }; // -=*# Resource for function NPV #*=- -const char* SC_OPCODE_NPV_ARY[] = +const TranslateId SC_OPCODE_NPV_ARY[] = { NC_("SC_OPCODE_NPV", "Net present value. Calculates the net present value of an investment based on a series of periodic payments and a discount rate."), NC_("SC_OPCODE_NPV", "Rate"), @@ -658,7 +658,7 @@ const char* SC_OPCODE_NPV_ARY[] = }; // -=*# Resource for function IRR #*=- -const char* SC_OPCODE_IRR_ARY[] = +const TranslateId SC_OPCODE_IRR_ARY[] = { NC_("SC_OPCODE_IRR", "Returns the actuarial rate of interest of an investment excluding costs or profits."), NC_("SC_OPCODE_IRR", "Values"), @@ -668,7 +668,7 @@ const char* SC_OPCODE_IRR_ARY[] = }; // -=*# Resource for function MIRR #*=- -const char* SC_OPCODE_MIRR_ARY[] = +const TranslateId SC_OPCODE_MIRR_ARY[] = { NC_("SC_OPCODE_MIRR", "Returns the modified internal rate of return for a series of investments."), NC_("SC_OPCODE_MIRR", "Values"), @@ -680,7 +680,7 @@ const char* SC_OPCODE_MIRR_ARY[] = }; // -=*# Resource for function ISPMT #*=- -const char* SC_OPCODE_ISPMT_ARY[] = +const TranslateId SC_OPCODE_ISPMT_ARY[] = { NC_("SC_OPCODE_ISPMT", "Returns the amount of interest for constant amortization rates."), NC_("SC_OPCODE_ISPMT", "Rate"), @@ -694,7 +694,7 @@ const char* SC_OPCODE_ISPMT_ARY[] = }; // -=*# Resource for function PDURATION #*=- -const char* SC_OPCODE_PDURATION_ARY[] = +const TranslateId SC_OPCODE_PDURATION_ARY[] = { NC_("SC_OPCODE_PDURATION", "Duration. Calculates the number of periods required by an investment to attain the desired value."), NC_("SC_OPCODE_PDURATION", "Rate"), @@ -706,7 +706,7 @@ const char* SC_OPCODE_PDURATION_ARY[] = }; // -=*# Resource for function RRI #*=- -const char* SC_OPCODE_RRI_ARY[] = +const TranslateId SC_OPCODE_RRI_ARY[] = { NC_("SC_OPCODE_RRI", "Interest. Calculates the interest rate which represents the rate of return from an investment."), NC_("SC_OPCODE_RRI", "Periods"), @@ -718,7 +718,7 @@ const char* SC_OPCODE_RRI_ARY[] = }; // -=*# Resource for function ISREF #*=- -const char* SC_OPCODE_IS_REF_ARY[] = +const TranslateId SC_OPCODE_IS_REF_ARY[] = { NC_("SC_OPCODE_IS_REF", "Returns TRUE if value is a reference."), NC_("SC_OPCODE_IS_REF", "Value"), @@ -726,7 +726,7 @@ const char* SC_OPCODE_IS_REF_ARY[] = }; // -=*# Resource for function ISERR #*=- -const char* SC_OPCODE_IS_ERR_ARY[] = +const TranslateId SC_OPCODE_IS_ERR_ARY[] = { NC_("SC_OPCODE_IS_ERR", "Returns TRUE if the value is an error value not equal to #N/A."), NC_("SC_OPCODE_IS_ERR", "Value"), @@ -734,7 +734,7 @@ const char* SC_OPCODE_IS_ERR_ARY[] = }; // -=*# Resource for function ISERROR #*=- -const char* SC_OPCODE_IS_ERROR_ARY[] = +const TranslateId SC_OPCODE_IS_ERROR_ARY[] = { NC_("SC_OPCODE_IS_ERROR", "Returns TRUE if the value is an error value."), NC_("SC_OPCODE_IS_ERROR", "Value"), @@ -742,7 +742,7 @@ const char* SC_OPCODE_IS_ERROR_ARY[] = }; // -=*# Resource for function ISBLANK #*=- -const char* SC_OPCODE_IS_EMPTY_ARY[] = +const TranslateId SC_OPCODE_IS_EMPTY_ARY[] = { NC_("SC_OPCODE_IS_EMPTY", "Returns TRUE if value refers to an empty cell."), NC_("SC_OPCODE_IS_EMPTY", "Value"), @@ -750,7 +750,7 @@ const char* SC_OPCODE_IS_EMPTY_ARY[] = }; // -=*# Resource for function ISLOGICAL #*=- -const char* SC_OPCODE_IS_LOGICAL_ARY[] = +const TranslateId SC_OPCODE_IS_LOGICAL_ARY[] = { NC_("SC_OPCODE_IS_LOGICAL", "Returns TRUE if the value carries a logical number format."), NC_("SC_OPCODE_IS_LOGICAL", "Value"), @@ -758,7 +758,7 @@ const char* SC_OPCODE_IS_LOGICAL_ARY[] = }; // -=*# Resource for function ISNA #*=- -const char* SC_OPCODE_IS_NV_ARY[] = +const TranslateId SC_OPCODE_IS_NV_ARY[] = { NC_("SC_OPCODE_IS_NV", "Returns TRUE if value equals #N/A."), NC_("SC_OPCODE_IS_NV", "Value"), @@ -766,7 +766,7 @@ const char* SC_OPCODE_IS_NV_ARY[] = }; // -=*# Resource for function ISNONTEXT #*=- -const char* SC_OPCODE_IS_NON_STRING_ARY[] = +const TranslateId SC_OPCODE_IS_NON_STRING_ARY[] = { NC_("SC_OPCODE_IS_NON_STRING", "Returns TRUE if the value is not text."), NC_("SC_OPCODE_IS_NON_STRING", "Value"), @@ -774,7 +774,7 @@ const char* SC_OPCODE_IS_NON_STRING_ARY[] = }; // -=*# Resource for function ISTEXT #*=- -const char* SC_OPCODE_IS_STRING_ARY[] = +const TranslateId SC_OPCODE_IS_STRING_ARY[] = { NC_("SC_OPCODE_IS_STRING", "Returns TRUE if value is text."), NC_("SC_OPCODE_IS_STRING", "Value"), @@ -782,7 +782,7 @@ const char* SC_OPCODE_IS_STRING_ARY[] = }; // -=*# Resource for function ISNUMBER #*=- -const char* SC_OPCODE_IS_VALUE_ARY[] = +const TranslateId SC_OPCODE_IS_VALUE_ARY[] = { NC_("SC_OPCODE_IS_VALUE", "Returns TRUE if value is a number."), NC_("SC_OPCODE_IS_VALUE", "Value"), @@ -790,7 +790,7 @@ const char* SC_OPCODE_IS_VALUE_ARY[] = }; // -=*# Resource for function ISFORMULA #*=- -const char* SC_OPCODE_IS_FORMULA_ARY[] = +const TranslateId SC_OPCODE_IS_FORMULA_ARY[] = { NC_("SC_OPCODE_IS_FORMULA", "Returns TRUE if the cell is a formula cell."), NC_("SC_OPCODE_IS_FORMULA", "Reference"), @@ -798,7 +798,7 @@ const char* SC_OPCODE_IS_FORMULA_ARY[] = }; // -=*# Resource for function FORMULA #*=- -const char* SC_OPCODE_FORMULA_ARY[] = +const TranslateId SC_OPCODE_FORMULA_ARY[] = { NC_("SC_OPCODE_FORMULA", "Returns the formula of a formula cell."), NC_("SC_OPCODE_FORMULA", "Reference"), @@ -806,7 +806,7 @@ const char* SC_OPCODE_FORMULA_ARY[] = }; // -=*# Resource for function N #*=- -const char* SC_OPCODE_N_ARY[] = +const TranslateId SC_OPCODE_N_ARY[] = { NC_("SC_OPCODE_N", "Converts a value to a number."), NC_("SC_OPCODE_N", "Value"), @@ -814,13 +814,13 @@ const char* SC_OPCODE_N_ARY[] = }; // -=*# Resource for function NA #*=- -const char* SC_OPCODE_NO_VALUE_ARY[] = +const TranslateId SC_OPCODE_NO_VALUE_ARY[] = { NC_("SC_OPCODE_NO_VALUE", "Not available. Returns the error value #N/A.") }; // -=*# Resource for function TYPE #*=- -const char* SC_OPCODE_TYPE_ARY[] = +const TranslateId SC_OPCODE_TYPE_ARY[] = { NC_("SC_OPCODE_TYPE", "Returns the data type of a value (1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array)."), NC_("SC_OPCODE_TYPE", "Value"), @@ -828,7 +828,7 @@ const char* SC_OPCODE_TYPE_ARY[] = }; // -=*# Resource for function CELL #*=- -const char* SC_OPCODE_CELL_ARY[] = +const TranslateId SC_OPCODE_CELL_ARY[] = { NC_("SC_OPCODE_CELL", "Determines information about address, formatting or contents of a cell."), NC_("SC_OPCODE_CELL", "Info type"), @@ -838,19 +838,19 @@ const char* SC_OPCODE_CELL_ARY[] = }; // -=*# Resource for function CURRENT #*=- -const char* SC_OPCODE_CURRENT_ARY[] = +const TranslateId SC_OPCODE_CURRENT_ARY[] = { NC_("SC_OPCODE_CURRENT", "Calculates the current value of the formula at the present location.") }; // -=*# Resource for function FALSE #*=- -const char* SC_OPCODE_FALSE_ARY[] = +const TranslateId SC_OPCODE_FALSE_ARY[] = { NC_("SC_OPCODE_FALSE", "Defines the logical value as FALSE.") }; // -=*# Resource for function NOT #*=- -const char* SC_OPCODE_NOT_ARY[] = +const TranslateId SC_OPCODE_NOT_ARY[] = { NC_("SC_OPCODE_NOT", "Reverses the value of the argument."), NC_("SC_OPCODE_NOT", "Logical value"), @@ -858,13 +858,13 @@ const char* SC_OPCODE_NOT_ARY[] = }; // -=*# Resource for function TRUE #*=- -const char* SC_OPCODE_TRUE_ARY[] = +const TranslateId SC_OPCODE_TRUE_ARY[] = { NC_("SC_OPCODE_TRUE", "Returns the logical value TRUE.") }; // -=*# Resource for function IF #*=- -const char* SC_OPCODE_IF_ARY[] = +const TranslateId SC_OPCODE_IF_ARY[] = { NC_("SC_OPCODE_IF", "Specifies a logical test to be performed."), NC_("SC_OPCODE_IF", "Test"), @@ -876,7 +876,7 @@ const char* SC_OPCODE_IF_ARY[] = }; // -=*# Resource for function IFERROR #*=- -const char* SC_OPCODE_IF_ERROR_ARY[] = +const TranslateId SC_OPCODE_IF_ERROR_ARY[] = { NC_("SC_OPCODE_IF_ERROR", "Returns value if not an error value, else alternative."), NC_("SC_OPCODE_IF_ERROR", "Value"), @@ -886,7 +886,7 @@ const char* SC_OPCODE_IF_ERROR_ARY[] = }; // -=*# Resource for function IFNA #*=- -const char* SC_OPCODE_IF_NA_ARY[] = +const TranslateId SC_OPCODE_IF_NA_ARY[] = { NC_("SC_OPCODE_IF_NA", "Returns value if not a #N/A error, else alternative."), NC_("SC_OPCODE_IF_NA", "Value"), @@ -896,7 +896,7 @@ const char* SC_OPCODE_IF_NA_ARY[] = }; // -=*# Resource for function OR #*=- -const char* SC_OPCODE_OR_ARY[] = +const TranslateId SC_OPCODE_OR_ARY[] = { NC_("SC_OPCODE_OR", "Returns TRUE if an argument is TRUE."), NC_("SC_OPCODE_OR", "Logical value "), @@ -904,7 +904,7 @@ const char* SC_OPCODE_OR_ARY[] = }; // -=*# Resource for function XOR #*=- -const char* SC_OPCODE_XOR_ARY[] = +const TranslateId SC_OPCODE_XOR_ARY[] = { NC_("SC_OPCODE_XOR", "Returns TRUE if an odd number of arguments evaluates to TRUE."), NC_("SC_OPCODE_XOR", "Logical value "), @@ -912,7 +912,7 @@ const char* SC_OPCODE_XOR_ARY[] = }; // -=*# Resource for function AND #*=- -const char* SC_OPCODE_AND_ARY[] = +const TranslateId SC_OPCODE_AND_ARY[] = { NC_("SC_OPCODE_AND", "Returns TRUE if all arguments are TRUE."), NC_("SC_OPCODE_AND", "Logical value "), @@ -920,7 +920,7 @@ const char* SC_OPCODE_AND_ARY[] = }; // -=*# Resource for function ABS #*=- -const char* SC_OPCODE_ABS_ARY[] = +const TranslateId SC_OPCODE_ABS_ARY[] = { NC_("SC_OPCODE_ABS", "Absolute value of a number."), NC_("SC_OPCODE_ABS", "Number"), @@ -928,7 +928,7 @@ const char* SC_OPCODE_ABS_ARY[] = }; // -=*# Resource for function POWER #*=- -const char* SC_OPCODE_POWER_ARY[] = +const TranslateId SC_OPCODE_POWER_ARY[] = { NC_("SC_OPCODE_POWER", "Returns a^b, base a raised to the power of exponent b."), NC_("SC_OPCODE_POWER", "Base"), @@ -938,7 +938,7 @@ const char* SC_OPCODE_POWER_ARY[] = }; // -=*# Resource for function COUNTBLANK #*=- -const char* SC_OPCODE_COUNT_EMPTY_CELLS_ARY[] = +const TranslateId SC_OPCODE_COUNT_EMPTY_CELLS_ARY[] = { NC_("SC_OPCODE_COUNT_EMPTY_CELLS", "Counts the blank cells in a specified range."), NC_("SC_OPCODE_COUNT_EMPTY_CELLS", "Range"), @@ -946,13 +946,13 @@ const char* SC_OPCODE_COUNT_EMPTY_CELLS_ARY[] = }; // -=*# Resource for function PI #*=- -const char* SC_OPCODE_PI_ARY[] = +const TranslateId SC_OPCODE_PI_ARY[] = { NC_("SC_OPCODE_PI", "Returns the value of the number Pi.") }; // -=*# Resource for function SUM #*=- -const char* SC_OPCODE_SUM_ARY[] = +const TranslateId SC_OPCODE_SUM_ARY[] = { NC_("SC_OPCODE_SUM", "Returns the sum of all arguments."), NC_("SC_OPCODE_SUM", "Number "), @@ -960,7 +960,7 @@ const char* SC_OPCODE_SUM_ARY[] = }; // -=*# Resource for function SUMSQ #*=- -const char* SC_OPCODE_SUM_SQ_ARY[] = +const TranslateId SC_OPCODE_SUM_SQ_ARY[] = { NC_("SC_OPCODE_SUM_SQ", "Returns the sum of the squares of the arguments."), NC_("SC_OPCODE_SUM_SQ", "Number "), @@ -968,7 +968,7 @@ const char* SC_OPCODE_SUM_SQ_ARY[] = }; // -=*# Resource for function PRODUCT #*=- -const char* SC_OPCODE_PRODUCT_ARY[] = +const TranslateId SC_OPCODE_PRODUCT_ARY[] = { NC_("SC_OPCODE_PRODUCT", "Multiplies the arguments."), NC_("SC_OPCODE_PRODUCT", "Number "), @@ -976,7 +976,7 @@ const char* SC_OPCODE_PRODUCT_ARY[] = }; // -=*# Resource for function SUMIF #*=- -const char* SC_OPCODE_SUM_IF_ARY[] = +const TranslateId SC_OPCODE_SUM_IF_ARY[] = { NC_("SC_OPCODE_SUM_IF", "Totals the arguments that meet the condition."), NC_("SC_OPCODE_SUM_IF", "Range"), @@ -988,7 +988,7 @@ const char* SC_OPCODE_SUM_IF_ARY[] = }; // -=*# Resource for function AVERAGEIF #*=- -const char* SC_OPCODE_AVERAGE_IF_ARY[] = +const TranslateId SC_OPCODE_AVERAGE_IF_ARY[] = { NC_("SC_OPCODE_AVERAGE_IF", "Averages the arguments that meet the conditions."), NC_("SC_OPCODE_AVERAGE_IF", "Range"), @@ -999,7 +999,7 @@ const char* SC_OPCODE_AVERAGE_IF_ARY[] = NC_("SC_OPCODE_AVERAGE_IF", "The range from which the values are to be averaged.") }; -const char* SC_OPCODE_SUM_IFS_ARY[] = +const TranslateId SC_OPCODE_SUM_IFS_ARY[] = { NC_("SC_OPCODE_SUM_IFS", "Totals the values of cells in a range that meet multiple criteria in multiple ranges."), NC_("SC_OPCODE_SUM_IFS", "Sum range"), @@ -1011,7 +1011,7 @@ const char* SC_OPCODE_SUM_IFS_ARY[] = }; // -=*# Resource for function AVERAGEIFS #*=- -const char* SC_OPCODE_AVERAGE_IFS_ARY[] = +const TranslateId SC_OPCODE_AVERAGE_IFS_ARY[] = { NC_("SC_OPCODE_AVERAGE_IFS", "Averages the value of the cells that meet multiple criteria in multiple ranges."), NC_("SC_OPCODE_AVERAGE_IFS", "Average range"), @@ -1023,7 +1023,7 @@ const char* SC_OPCODE_AVERAGE_IFS_ARY[] = }; // -=*# Resource for function COUNTIFS #*=- -const char* SC_OPCODE_COUNT_IFS_ARY[] = +const TranslateId SC_OPCODE_COUNT_IFS_ARY[] = { NC_("SC_OPCODE_COUNT_IFS", "Counts the cells that meet multiple criteria in multiple ranges."), NC_("SC_OPCODE_COUNT_IFS", "Range "), @@ -1033,7 +1033,7 @@ const char* SC_OPCODE_COUNT_IFS_ARY[] = }; // -=*# Resource for function COUNTIF #*=- -const char* SC_OPCODE_COUNT_IF_ARY[] = +const TranslateId SC_OPCODE_COUNT_IF_ARY[] = { NC_("SC_OPCODE_COUNT_IF", "Counts the arguments which meet the set conditions."), NC_("SC_OPCODE_COUNT_IF", "Range"), @@ -1043,7 +1043,7 @@ const char* SC_OPCODE_COUNT_IF_ARY[] = }; // -=*# Resource for function SQRT #*=- -const char* SC_OPCODE_SQRT_ARY[] = +const TranslateId SC_OPCODE_SQRT_ARY[] = { NC_("SC_OPCODE_SQRT", "Returns the square root of a number."), NC_("SC_OPCODE_SQRT", "Number"), @@ -1051,13 +1051,13 @@ const char* SC_OPCODE_SQRT_ARY[] = }; // -=*# Resource for function RAND #*=- -const char* SC_OPCODE_RANDOM_ARY[] = +const TranslateId SC_OPCODE_RANDOM_ARY[] = { NC_("SC_OPCODE_RANDOM", "Returns a random number between 0 and 1.") }; // -=*# Resource for function ISEVEN #*=- -const char* SC_OPCODE_IS_EVEN_ARY[] = +const TranslateId SC_OPCODE_IS_EVEN_ARY[] = { NC_("SC_OPCODE_IS_EVEN", "Returns TRUE if value is an even integer."), NC_("SC_OPCODE_IS_EVEN", "Value"), @@ -1065,7 +1065,7 @@ const char* SC_OPCODE_IS_EVEN_ARY[] = }; // -=*# Resource for function ISODD #*=- -const char* SC_OPCODE_IS_ODD_ARY[] = +const TranslateId SC_OPCODE_IS_ODD_ARY[] = { NC_("SC_OPCODE_IS_ODD", "Returns TRUE if value is an odd integer."), NC_("SC_OPCODE_IS_ODD", "Value"), @@ -1073,7 +1073,7 @@ const char* SC_OPCODE_IS_ODD_ARY[] = }; // -=*# Resource for function COMBIN #*=- -const char* SC_OPCODE_COMBIN_ARY[] = +const TranslateId SC_OPCODE_COMBIN_ARY[] = { NC_("SC_OPCODE_COMBIN", "Calculates the number of combinations for elements without repetition."), NC_("SC_OPCODE_COMBIN", "Number 1"), @@ -1083,7 +1083,7 @@ const char* SC_OPCODE_COMBIN_ARY[] = }; // -=*# Resource for function COMBINA #*=- -const char* SC_OPCODE_COMBIN_A_ARY[] = +const TranslateId SC_OPCODE_COMBIN_A_ARY[] = { NC_("SC_OPCODE_COMBIN_A", "Calculates the number of combinations of elements including repetition."), NC_("SC_OPCODE_COMBIN_A", "Number 1"), @@ -1093,7 +1093,7 @@ const char* SC_OPCODE_COMBIN_A_ARY[] = }; // -=*# Resource for function ARCCOS #*=- -const char* SC_OPCODE_ARC_COS_ARY[] = +const TranslateId SC_OPCODE_ARC_COS_ARY[] = { NC_("SC_OPCODE_ARC_COS", "Returns the arccosine of a number."), NC_("SC_OPCODE_ARC_COS", "Number"), @@ -1101,7 +1101,7 @@ const char* SC_OPCODE_ARC_COS_ARY[] = }; // -=*# Resource for function ARCSIN #*=- -const char* SC_OPCODE_ARC_SIN_ARY[] = +const TranslateId SC_OPCODE_ARC_SIN_ARY[] = { NC_("SC_OPCODE_ARC_SIN", "Returns the arcsine of a number."), NC_("SC_OPCODE_ARC_SIN", "Number"), @@ -1109,7 +1109,7 @@ const char* SC_OPCODE_ARC_SIN_ARY[] = }; // -=*# Resource for function ARCCOSHYP #*=- -const char* SC_OPCODE_ARC_COS_HYP_ARY[] = +const TranslateId SC_OPCODE_ARC_COS_HYP_ARY[] = { NC_("SC_OPCODE_ARC_COS_HYP", "Returns the inverse hyperbolic cosine of a number."), NC_("SC_OPCODE_ARC_COS_HYP", "Number"), @@ -1117,7 +1117,7 @@ const char* SC_OPCODE_ARC_COS_HYP_ARY[] = }; // -=*# Resource for function ARCSINHYP #*=- -const char* SC_OPCODE_ARC_SIN_HYP_ARY[] = +const TranslateId SC_OPCODE_ARC_SIN_HYP_ARY[] = { NC_("SC_OPCODE_ARC_SIN_HYP", "Returns the inverse hyperbolic sine of a number."), NC_("SC_OPCODE_ARC_SIN_HYP", "Number"), @@ -1125,7 +1125,7 @@ const char* SC_OPCODE_ARC_SIN_HYP_ARY[] = }; // -=*# Resource for function ARCCOT #*=- -const char* SC_OPCODE_ARC_COT_ARY[] = +const TranslateId SC_OPCODE_ARC_COT_ARY[] = { NC_("SC_OPCODE_ARC_COT", "Returns the inverse cotangent of a number."), NC_("SC_OPCODE_ARC_COT", "Number"), @@ -1133,7 +1133,7 @@ const char* SC_OPCODE_ARC_COT_ARY[] = }; // -=*# Resource for function ARCTAN #*=- -const char* SC_OPCODE_ARC_TAN_ARY[] = +const TranslateId SC_OPCODE_ARC_TAN_ARY[] = { NC_("SC_OPCODE_ARC_TAN", "Returns the arctangent of a number."), NC_("SC_OPCODE_ARC_TAN", "Number"), @@ -1141,7 +1141,7 @@ const char* SC_OPCODE_ARC_TAN_ARY[] = }; // -=*# Resource for function ARCCOTHYP #*=- -const char* SC_OPCODE_ARC_COT_HYP_ARY[] = +const TranslateId SC_OPCODE_ARC_COT_HYP_ARY[] = { NC_("SC_OPCODE_ARC_COT_HYP", "Returns the inverse hyperbolic cotangent of a number."), NC_("SC_OPCODE_ARC_COT_HYP", "Number"), @@ -1149,7 +1149,7 @@ const char* SC_OPCODE_ARC_COT_HYP_ARY[] = }; // -=*# Resource for function ARCTANHYP #*=- -const char* SC_OPCODE_ARC_TAN_HYP_ARY[] = +const TranslateId SC_OPCODE_ARC_TAN_HYP_ARY[] = { NC_("SC_OPCODE_ARC_TAN_HYP", "Returns the inverse hyperbolic tangent of a number."), NC_("SC_OPCODE_ARC_TAN_HYP", "Number"), @@ -1157,7 +1157,7 @@ const char* SC_OPCODE_ARC_TAN_HYP_ARY[] = }; // -=*# Resource for function COS #*=- -const char* SC_OPCODE_COS_ARY[] = +const TranslateId SC_OPCODE_COS_ARY[] = { NC_("SC_OPCODE_COS", "Returns the cosine of a number."), NC_("SC_OPCODE_COS", "Number"), @@ -1165,7 +1165,7 @@ const char* SC_OPCODE_COS_ARY[] = }; // -=*# Resource for function SIN #*=- -const char* SC_OPCODE_SIN_ARY[] = +const TranslateId SC_OPCODE_SIN_ARY[] = { NC_("SC_OPCODE_SIN", "Returns the sine of a number."), NC_("SC_OPCODE_SIN", "Number"), @@ -1173,7 +1173,7 @@ const char* SC_OPCODE_SIN_ARY[] = }; // -=*# Resource for function COT #*=- -const char* SC_OPCODE_COT_ARY[] = +const TranslateId SC_OPCODE_COT_ARY[] = { NC_("SC_OPCODE_COT", "Returns the cotangent of a number."), NC_("SC_OPCODE_COT", "Number"), @@ -1181,7 +1181,7 @@ const char* SC_OPCODE_COT_ARY[] = }; // -=*# Resource for function TAN #*=- -const char* SC_OPCODE_TAN_ARY[] = +const TranslateId SC_OPCODE_TAN_ARY[] = { NC_("SC_OPCODE_TAN", "Returns the tangent of a number."), NC_("SC_OPCODE_TAN", "Number"), @@ -1189,7 +1189,7 @@ const char* SC_OPCODE_TAN_ARY[] = }; // -=*# Resource for function COSHYP #*=- -const char* SC_OPCODE_COS_HYP_ARY[] = +const TranslateId SC_OPCODE_COS_HYP_ARY[] = { NC_("SC_OPCODE_COS_HYP", "Returns the hyperbolic cosine of a number."), NC_("SC_OPCODE_COS_HYP", "Number"), @@ -1197,7 +1197,7 @@ const char* SC_OPCODE_COS_HYP_ARY[] = }; // -=*# Resource for function SINHYP #*=- -const char* SC_OPCODE_SIN_HYP_ARY[] = +const TranslateId SC_OPCODE_SIN_HYP_ARY[] = { NC_("SC_OPCODE_SIN_HYP", "Returns the hyperbolic sine of a number."), NC_("SC_OPCODE_SIN_HYP", "Number"), @@ -1205,7 +1205,7 @@ const char* SC_OPCODE_SIN_HYP_ARY[] = }; // -=*# Resource for function COTHYP #*=- -const char* SC_OPCODE_COT_HYP_ARY[] = +const TranslateId SC_OPCODE_COT_HYP_ARY[] = { NC_("SC_OPCODE_COT_HYP", "Returns the hyperbolic cotangent of a number."), NC_("SC_OPCODE_COT_HYP", "Number"), @@ -1213,7 +1213,7 @@ const char* SC_OPCODE_COT_HYP_ARY[] = }; // -=*# Resource for function TANHYP #*=- -const char* SC_OPCODE_TAN_HYP_ARY[] = +const TranslateId SC_OPCODE_TAN_HYP_ARY[] = { NC_("SC_OPCODE_TAN_HYP", "Returns the hyperbolic tangent of a number."), NC_("SC_OPCODE_TAN_HYP", "Number"), @@ -1221,7 +1221,7 @@ const char* SC_OPCODE_TAN_HYP_ARY[] = }; // -=*# Resource for function ARCTAN2 #*=- -const char* SC_OPCODE_ARC_TAN_2_ARY[] = +const TranslateId SC_OPCODE_ARC_TAN_2_ARY[] = { NC_("SC_OPCODE_ARC_TAN_2", "Returns the arctangent for the specified coordinates."), NC_("SC_OPCODE_ARC_TAN_2", "Number X"), @@ -1231,7 +1231,7 @@ const char* SC_OPCODE_ARC_TAN_2_ARY[] = }; // -=*# Resource for function CSC #*=- -const char* SC_OPCODE_COSECANT_ARY[] = +const TranslateId SC_OPCODE_COSECANT_ARY[] = { NC_("SC_OPCODE_COSECANT", "Return the cosecant of an angle. CSC(x)=1/SIN(x)"), NC_("SC_OPCODE_COSECANT", "Angle"), @@ -1239,7 +1239,7 @@ const char* SC_OPCODE_COSECANT_ARY[] = }; // -=*# Resource for function SEC #*=- -const char* SC_OPCODE_SECANT_ARY[] = +const TranslateId SC_OPCODE_SECANT_ARY[] = { NC_("SC_OPCODE_SECANT", "Return the secant of an angle. SEC(x)=1/COS(x)"), NC_("SC_OPCODE_SECANT", "Angle"), @@ -1247,7 +1247,7 @@ const char* SC_OPCODE_SECANT_ARY[] = }; // -=*# Resource for function CSCH #*=- -const char* SC_OPCODE_COSECANT_HYP_ARY[] = +const TranslateId SC_OPCODE_COSECANT_HYP_ARY[] = { NC_("SC_OPCODE_COSECANT_HYP", "Return the hyperbolic cosecant of a hyperbolic angle. CSCH(x)=1/SINH(x)"), NC_("SC_OPCODE_COSECANT_HYP", "Angle"), @@ -1255,7 +1255,7 @@ const char* SC_OPCODE_COSECANT_HYP_ARY[] = }; // -=*# Resource for function SECH #*=- -const char* SC_OPCODE_SECANT_HYP_ARY[] = +const TranslateId SC_OPCODE_SECANT_HYP_ARY[] = { NC_("SC_OPCODE_SECANT_HYP", "Return the hyperbolic secant of a hyperbolic angle. SECH(x)=1/COSH(x)"), NC_("SC_OPCODE_SECANT_HYP", "Angle"), @@ -1263,7 +1263,7 @@ const char* SC_OPCODE_SECANT_HYP_ARY[] = }; // -=*# Resource for function DEG #*=- -const char* SC_OPCODE_DEG_ARY[] = +const TranslateId SC_OPCODE_DEG_ARY[] = { NC_("SC_OPCODE_DEG", "Converts a radian to degrees"), NC_("SC_OPCODE_DEG", "Number"), @@ -1271,7 +1271,7 @@ const char* SC_OPCODE_DEG_ARY[] = }; // -=*# Resource for function RAD #*=- -const char* SC_OPCODE_RAD_ARY[] = +const TranslateId SC_OPCODE_RAD_ARY[] = { NC_("SC_OPCODE_RAD", "Converts degrees to radians"), NC_("SC_OPCODE_RAD", "Number"), @@ -1279,7 +1279,7 @@ const char* SC_OPCODE_RAD_ARY[] = }; // -=*# Resource for function EXP #*=- -const char* SC_OPCODE_EXP_ARY[] = +const TranslateId SC_OPCODE_EXP_ARY[] = { NC_("SC_OPCODE_EXP", "Calculates the exponent for basis e."), NC_("SC_OPCODE_EXP", "Number"), @@ -1287,7 +1287,7 @@ const char* SC_OPCODE_EXP_ARY[] = }; // -=*# Resource for function LOG #*=- -const char* SC_OPCODE_LOG_ARY[] = +const TranslateId SC_OPCODE_LOG_ARY[] = { NC_("SC_OPCODE_LOG", "Calculates the logarithm to any specified base."), NC_("SC_OPCODE_LOG", "Number"), @@ -1297,7 +1297,7 @@ const char* SC_OPCODE_LOG_ARY[] = }; // -=*# Resource for function LN #*=- -const char* SC_OPCODE_LN_ARY[] = +const TranslateId SC_OPCODE_LN_ARY[] = { NC_("SC_OPCODE_LN", "Calculates the natural logarithm of a number."), NC_("SC_OPCODE_LN", "Number"), @@ -1305,7 +1305,7 @@ const char* SC_OPCODE_LN_ARY[] = }; // -=*# Resource for function LOG10 #*=- -const char* SC_OPCODE_LOG10_ARY[] = +const TranslateId SC_OPCODE_LOG10_ARY[] = { NC_("SC_OPCODE_LOG10", "Calculates the base-10 logarithm of a number."), NC_("SC_OPCODE_LOG10", "Number"), @@ -1313,7 +1313,7 @@ const char* SC_OPCODE_LOG10_ARY[] = }; // -=*# Resource for function FACT #*=- -const char* SC_OPCODE_FACT_ARY[] = +const TranslateId SC_OPCODE_FACT_ARY[] = { NC_("SC_OPCODE_FACT", "Calculates the factorial of a number."), NC_("SC_OPCODE_FACT", "Number"), @@ -1321,7 +1321,7 @@ const char* SC_OPCODE_FACT_ARY[] = }; // -=*# Resource for function MOD #*=- -const char* SC_OPCODE_MOD_ARY[] = +const TranslateId SC_OPCODE_MOD_ARY[] = { NC_("SC_OPCODE_MOD", "Calculates the remainder of a division."), NC_("SC_OPCODE_MOD", "Dividend"), @@ -1331,7 +1331,7 @@ const char* SC_OPCODE_MOD_ARY[] = }; // -=*# Resource for function SIGN #*=- -const char* SC_OPCODE_PLUS_MINUS_ARY[] = +const TranslateId SC_OPCODE_PLUS_MINUS_ARY[] = { NC_("SC_OPCODE_PLUS_MINUS", "Returns the algebraic sign of a number."), NC_("SC_OPCODE_PLUS_MINUS", "Number"), @@ -1339,7 +1339,7 @@ const char* SC_OPCODE_PLUS_MINUS_ARY[] = }; // -=*# Resource for function SUBTOTAL #*=- -const char* SC_OPCODE_SUB_TOTAL_ARY[] = +const TranslateId SC_OPCODE_SUB_TOTAL_ARY[] = { NC_("SC_OPCODE_SUB_TOTAL", "Calculates subtotals in a spreadsheet."), NC_("SC_OPCODE_SUB_TOTAL", "Function"), @@ -1349,7 +1349,7 @@ const char* SC_OPCODE_SUB_TOTAL_ARY[] = }; // -=*# Resource for function AGGREGATE #*=- -const char* SC_OPCODE_AGGREGATE_ARY[] = +const TranslateId SC_OPCODE_AGGREGATE_ARY[] = { NC_("SC_OPCODE_AGGREGATE", "Calculates an aggregate in a spreadsheet."), NC_("SC_OPCODE_AGGREGATE", "Function"), @@ -1363,7 +1363,7 @@ const char* SC_OPCODE_AGGREGATE_ARY[] = }; // -=*# Resource for function INT #*=- -const char* SC_OPCODE_INT_ARY[] = +const TranslateId SC_OPCODE_INT_ARY[] = { NC_("SC_OPCODE_INT", "Rounds a number down to the nearest integer."), NC_("SC_OPCODE_INT", "Number"), @@ -1371,7 +1371,7 @@ const char* SC_OPCODE_INT_ARY[] = }; // -=*# Resource for function TRUNC #*=- -const char* SC_OPCODE_TRUNC_ARY[] = +const TranslateId SC_OPCODE_TRUNC_ARY[] = { NC_("SC_OPCODE_TRUNC", "Truncates the decimal places of a number."), NC_("SC_OPCODE_TRUNC", "Number"), @@ -1381,7 +1381,7 @@ const char* SC_OPCODE_TRUNC_ARY[] = }; // -=*# Resource for function ROUND #*=- -const char* SC_OPCODE_ROUND_ARY[] = +const TranslateId SC_OPCODE_ROUND_ARY[] = { NC_("SC_OPCODE_ROUND", "Rounds a number to a predefined accuracy."), NC_("SC_OPCODE_ROUND", "Number"), @@ -1391,7 +1391,7 @@ const char* SC_OPCODE_ROUND_ARY[] = }; // -=*# Resource for function ROUNDUP #*=- -const char* SC_OPCODE_ROUND_UP_ARY[] = +const TranslateId SC_OPCODE_ROUND_UP_ARY[] = { NC_("SC_OPCODE_ROUND_UP", "Rounds a number up to the predefined accuracy."), NC_("SC_OPCODE_ROUND_UP", "Number"), @@ -1401,7 +1401,7 @@ const char* SC_OPCODE_ROUND_UP_ARY[] = }; // -=*# Resource for function ROUNDDOWN #*=- -const char* SC_OPCODE_ROUND_DOWN_ARY[] = +const TranslateId SC_OPCODE_ROUND_DOWN_ARY[] = { NC_("SC_OPCODE_ROUND_DOWN", "Rounds a number down to a predefined accuracy."), NC_("SC_OPCODE_ROUND_DOWN", "Number"), @@ -1411,7 +1411,7 @@ const char* SC_OPCODE_ROUND_DOWN_ARY[] = }; // -=*# Resource for function EVEN #*=- -const char* SC_OPCODE_EVEN_ARY[] = +const TranslateId SC_OPCODE_EVEN_ARY[] = { NC_("SC_OPCODE_EVEN", "Rounds a positive number up and negative number down to the nearest even integer."), NC_("SC_OPCODE_EVEN", "Number"), @@ -1419,7 +1419,7 @@ const char* SC_OPCODE_EVEN_ARY[] = }; // -=*# Resource for function ODD #*=- -const char* SC_OPCODE_ODD_ARY[] = +const TranslateId SC_OPCODE_ODD_ARY[] = { NC_("SC_OPCODE_ODD", "Rounds a positive number up and negative number down to the nearest odd integer."), NC_("SC_OPCODE_ODD", "Number"), @@ -1427,7 +1427,7 @@ const char* SC_OPCODE_ODD_ARY[] = }; // -=*# Resource for function CEILING.XCL #*=- -const char* SC_OPCODE_CEIL_MS_ARY[] = +const TranslateId SC_OPCODE_CEIL_MS_ARY[] = { NC_("SC_OPCODE_CEIL_MS", "Rounds a number away from zero to the nearest multiple of significance.\nThis function exists for interoperability with Microsoft Excel 2007 or older versions."), NC_("SC_OPCODE_CEIL_MS", "Number"), @@ -1437,7 +1437,7 @@ const char* SC_OPCODE_CEIL_MS_ARY[] = }; // -=*# Resource for function CEILING.PRECISE #*=- -const char* SC_OPCODE_CEIL_PRECISE_ARY[] = +const TranslateId SC_OPCODE_CEIL_PRECISE_ARY[] = { NC_("SC_OPCODE_CEIL_PRECISE", "Rounds a number up to the nearest multiple of significance, regardless of sign of significance."), NC_("SC_OPCODE_CEIL_PRECISE", "Number"), @@ -1447,7 +1447,7 @@ const char* SC_OPCODE_CEIL_PRECISE_ARY[] = }; // -=*# Resource for function ISO.CEILING #*=- -const char* SC_OPCODE_CEIL_ISO_ARY[] = +const TranslateId SC_OPCODE_CEIL_ISO_ARY[] = { NC_("SC_OPCODE_CEIL_ISO", "Rounds a number up to the nearest multiple of significance, regardless of sign of significance."), NC_("SC_OPCODE_CEIL_ISO", "Number"), @@ -1457,7 +1457,7 @@ const char* SC_OPCODE_CEIL_ISO_ARY[] = }; // -=*# Resource for function CEILING #*=- -const char* SC_OPCODE_CEIL_ARY[] = +const TranslateId SC_OPCODE_CEIL_ARY[] = { NC_("SC_OPCODE_CEIL", "Rounds a number up to the nearest multiple of significance."), NC_("SC_OPCODE_CEIL", "Number"), @@ -1469,7 +1469,7 @@ const char* SC_OPCODE_CEIL_ARY[] = }; // -=*# Resource for function CEILING.MATH #*=- -const char* SC_OPCODE_CEIL_MATH_ARY[] = +const TranslateId SC_OPCODE_CEIL_MATH_ARY[] = { NC_("SC_OPCODE_CEIL_MATH", "Rounds a number up to the nearest multiple of significance."), NC_("SC_OPCODE_CEIL_MATH", "Number"), @@ -1481,7 +1481,7 @@ const char* SC_OPCODE_CEIL_MATH_ARY[] = }; // -=*# Resource for function FLOOR #*=- -const char* SC_OPCODE_FLOOR_ARY[] = +const TranslateId SC_OPCODE_FLOOR_ARY[] = { NC_("SC_OPCODE_FLOOR", "Rounds number down to the nearest multiple of significance."), NC_("SC_OPCODE_FLOOR", "Number"), @@ -1493,7 +1493,7 @@ const char* SC_OPCODE_FLOOR_ARY[] = }; // -=*# Resource for function FLOOR.XCL #*=- -const char* SC_OPCODE_FLOOR_MS_ARY[] = +const TranslateId SC_OPCODE_FLOOR_MS_ARY[] = { NC_("SC_OPCODE_FLOOR_MS", "Rounds number towards zero to the nearest multiple of absolute value of significance.\nThis function exists for interoperability with Microsoft Excel 2007 or older versions."), NC_("SC_OPCODE_FLOOR_MS", "Number"), @@ -1503,7 +1503,7 @@ const char* SC_OPCODE_FLOOR_MS_ARY[] = }; // -=*# Resource for function FLOOR.MATH #*=- -const char* SC_OPCODE_FLOOR_MATH_ARY[] = +const TranslateId SC_OPCODE_FLOOR_MATH_ARY[] = { NC_("SC_OPCODE_FLOOR_MATH", "Rounds number down to the nearest multiple of significance, regardless of sign of significance."), NC_("SC_OPCODE_FLOOR_MATH", "Number"), @@ -1515,7 +1515,7 @@ const char* SC_OPCODE_FLOOR_MATH_ARY[] = }; // -=*# Resource for function FLOOR.PRECISE #*=- -const char* SC_OPCODE_FLOOR_PRECISE_ARY[] = +const TranslateId SC_OPCODE_FLOOR_PRECISE_ARY[] = { NC_("SC_OPCODE_FLOOR_PRECISE", "Rounds number down (towards -∞) to the nearest multiple of significance."), NC_("SC_OPCODE_FLOOR_PRECISE", "Number"), @@ -1525,7 +1525,7 @@ const char* SC_OPCODE_FLOOR_PRECISE_ARY[] = }; // -=*# Resource for function GCD #*=- -const char* SC_OPCODE_GCD_ARY[] = +const TranslateId SC_OPCODE_GCD_ARY[] = { NC_("SC_OPCODE_GCD", "Greatest Common Divisor"), NC_("SC_OPCODE_GCD", "Integer "), @@ -1533,7 +1533,7 @@ const char* SC_OPCODE_GCD_ARY[] = }; // -=*# Resource for function LCM #*=- -const char* SC_OPCODE_LCM_ARY[] = +const TranslateId SC_OPCODE_LCM_ARY[] = { NC_("SC_OPCODE_LCM", "Lowest common multiple"), NC_("SC_OPCODE_LCM", "Integer "), @@ -1541,7 +1541,7 @@ const char* SC_OPCODE_LCM_ARY[] = }; // -=*# Resource for function TRANSPOSE #*=- -const char* SC_OPCODE_MAT_TRANS_ARY[] = +const TranslateId SC_OPCODE_MAT_TRANS_ARY[] = { NC_("SC_OPCODE_MAT_TRANS", "Array transposition. Exchanges the rows and columns of an array."), NC_("SC_OPCODE_MAT_TRANS", "Array"), @@ -1549,7 +1549,7 @@ const char* SC_OPCODE_MAT_TRANS_ARY[] = }; // -=*# Resource for function MMULT #*=- -const char* SC_OPCODE_MAT_MULT_ARY[] = +const TranslateId SC_OPCODE_MAT_MULT_ARY[] = { NC_("SC_OPCODE_MAT_MULT", "Array multiplication. Returns the product of two arrays."), NC_("SC_OPCODE_MAT_MULT", "Array 1"), @@ -1559,7 +1559,7 @@ const char* SC_OPCODE_MAT_MULT_ARY[] = }; // -=*# Resource for function MDETERM #*=- -const char* SC_OPCODE_MAT_DET_ARY[] = +const TranslateId SC_OPCODE_MAT_DET_ARY[] = { NC_("SC_OPCODE_MAT_DET", "Returns the array determinant."), NC_("SC_OPCODE_MAT_DET", "Array"), @@ -1567,7 +1567,7 @@ const char* SC_OPCODE_MAT_DET_ARY[] = }; // -=*# Resource for function MINVERSE #*=- -const char* SC_OPCODE_MAT_INV_ARY[] = +const TranslateId SC_OPCODE_MAT_INV_ARY[] = { NC_("SC_OPCODE_MAT_INV", "Returns the inverse of an array."), NC_("SC_OPCODE_MAT_INV", "Array"), @@ -1575,7 +1575,7 @@ const char* SC_OPCODE_MAT_INV_ARY[] = }; // -=*# Resource for function MUNIT #*=- -const char* SC_OPCODE_MATRIX_UNIT_ARY[] = +const TranslateId SC_OPCODE_MATRIX_UNIT_ARY[] = { NC_("SC_OPCODE_MATRIX_UNIT", "Returns the unitary square array of a certain size."), NC_("SC_OPCODE_MATRIX_UNIT", "Dimensions"), @@ -1583,7 +1583,7 @@ const char* SC_OPCODE_MATRIX_UNIT_ARY[] = }; // -=*# Resource for function SUMPRODUCT #*=- -const char* SC_OPCODE_SUM_PRODUCT_ARY[] = +const TranslateId SC_OPCODE_SUM_PRODUCT_ARY[] = { NC_("SC_OPCODE_SUM_PRODUCT", "(Inner products) Returns the sum of the products of array arguments."), NC_("SC_OPCODE_SUM_PRODUCT", "Array "), @@ -1591,7 +1591,7 @@ const char* SC_OPCODE_SUM_PRODUCT_ARY[] = }; // -=*# Resource for function SUMX2MY2 #*=- -const char* SC_OPCODE_SUM_X2MY2_ARY[] = +const TranslateId SC_OPCODE_SUM_X2MY2_ARY[] = { NC_("SC_OPCODE_SUM_X2MY2", "Returns the sum of the difference of squares of two arrays."), NC_("SC_OPCODE_SUM_X2MY2", "Array X"), @@ -1601,7 +1601,7 @@ const char* SC_OPCODE_SUM_X2MY2_ARY[] = }; // -=*# Resource for function SUMX2PY2 #*=- -const char* SC_OPCODE_SUM_X2DY2_ARY[] = +const TranslateId SC_OPCODE_SUM_X2DY2_ARY[] = { NC_("SC_OPCODE_SUM_X2DY2", "Returns the total of the square sum of two arrays."), NC_("SC_OPCODE_SUM_X2DY2", "Array X"), @@ -1611,7 +1611,7 @@ const char* SC_OPCODE_SUM_X2DY2_ARY[] = }; // -=*# Resource for function SUMXMY2 #*=- -const char* SC_OPCODE_SUM_XMY2_ARY[] = +const TranslateId SC_OPCODE_SUM_XMY2_ARY[] = { NC_("SC_OPCODE_SUM_XMY2", "Returns the sum of squares of differences of two arrays."), NC_("SC_OPCODE_SUM_XMY2", "Array X"), @@ -1621,7 +1621,7 @@ const char* SC_OPCODE_SUM_XMY2_ARY[] = }; // -=*# Resource for function FREQUENCY #*=- -const char* SC_OPCODE_FREQUENCY_ARY[] = +const TranslateId SC_OPCODE_FREQUENCY_ARY[] = { NC_("SC_OPCODE_FREQUENCY", "Returns a frequency distribution as a vertical array."), NC_("SC_OPCODE_FREQUENCY", "Data"), @@ -1631,7 +1631,7 @@ const char* SC_OPCODE_FREQUENCY_ARY[] = }; // -=*# Resource for function LINEST #*=- -const char* SC_OPCODE_LINEST_ARY[] = +const TranslateId SC_OPCODE_LINEST_ARY[] = { NC_("SC_OPCODE_LINEST", "Calculates parameters of the linear regression as an array."), NC_("SC_OPCODE_LINEST", "Data Y"), @@ -1645,7 +1645,7 @@ const char* SC_OPCODE_LINEST_ARY[] = }; // -=*# Resource for function LOGEST #*=- -const char* SC_OPCODE_LOGEST_ARY[] = +const TranslateId SC_OPCODE_LOGEST_ARY[] = { NC_("SC_OPCODE_LOGEST", "Calculates the parameters of the exponential regression curve as an array."), NC_("SC_OPCODE_LOGEST", "Data Y"), @@ -1659,7 +1659,7 @@ const char* SC_OPCODE_LOGEST_ARY[] = }; // -=*# Resource for function TREND #*=- -const char* SC_OPCODE_TREND_ARY[] = +const TranslateId SC_OPCODE_TREND_ARY[] = { NC_("SC_OPCODE_TREND", "Calculates points along a regression line."), NC_("SC_OPCODE_TREND", "Data Y"), @@ -1673,7 +1673,7 @@ const char* SC_OPCODE_TREND_ARY[] = }; // -=*# Resource for function GROWTH #*=- -const char* SC_OPCODE_GROWTH_ARY[] = +const TranslateId SC_OPCODE_GROWTH_ARY[] = { NC_("SC_OPCODE_GROWTH", "Calculates points on the exponential regression function."), NC_("SC_OPCODE_GROWTH", "Data Y"), @@ -1687,7 +1687,7 @@ const char* SC_OPCODE_GROWTH_ARY[] = }; // -=*# Resource for function COUNT #*=- -const char* SC_OPCODE_COUNT_ARY[] = +const TranslateId SC_OPCODE_COUNT_ARY[] = { NC_("SC_OPCODE_COUNT", "Counts how many numbers are in the list of arguments."), NC_("SC_OPCODE_COUNT", "Value "), @@ -1695,7 +1695,7 @@ const char* SC_OPCODE_COUNT_ARY[] = }; // -=*# Resource for function COUNTA #*=- -const char* SC_OPCODE_COUNT_2_ARY[] = +const TranslateId SC_OPCODE_COUNT_2_ARY[] = { NC_("SC_OPCODE_COUNT_2", "Counts how many values are in the list of arguments."), NC_("SC_OPCODE_COUNT_2", "Value "), @@ -1703,7 +1703,7 @@ const char* SC_OPCODE_COUNT_2_ARY[] = }; // -=*# Resource for function MAX #*=- -const char* SC_OPCODE_MAX_ARY[] = +const TranslateId SC_OPCODE_MAX_ARY[] = { NC_("SC_OPCODE_MAX", "Returns the maximum value in a list of arguments."), NC_("SC_OPCODE_MAX", "Number "), @@ -1711,7 +1711,7 @@ const char* SC_OPCODE_MAX_ARY[] = }; // -=*# Resource for function MAXA #*=- -const char* SC_OPCODE_MAX_A_ARY[] = +const TranslateId SC_OPCODE_MAX_A_ARY[] = { NC_("SC_OPCODE_MAX_A", "Returns the maximum value in a list of arguments. Text is evaluated as Zero."), NC_("SC_OPCODE_MAX_A", "Value "), @@ -1719,7 +1719,7 @@ const char* SC_OPCODE_MAX_A_ARY[] = }; // -=*# Resource for function MIN #*=- -const char* SC_OPCODE_MIN_ARY[] = +const TranslateId SC_OPCODE_MIN_ARY[] = { NC_("SC_OPCODE_MIN", "Returns the minimum value in a list of arguments."), NC_("SC_OPCODE_MIN", "Number "), @@ -1727,7 +1727,7 @@ const char* SC_OPCODE_MIN_ARY[] = }; // -=*# Resource for function MINA #*=- -const char* SC_OPCODE_MIN_A_ARY[] = +const TranslateId SC_OPCODE_MIN_A_ARY[] = { NC_("SC_OPCODE_MIN_A", "Returns the smallest value in a list of arguments. Text is evaluated as zero."), NC_("SC_OPCODE_MIN_A", "Value "), @@ -1735,7 +1735,7 @@ const char* SC_OPCODE_MIN_A_ARY[] = }; // -=*# Resource for function VAR #*=- -const char* SC_OPCODE_VAR_ARY[] = +const TranslateId SC_OPCODE_VAR_ARY[] = { NC_("SC_OPCODE_VAR", "Calculates the variance based on a sample."), NC_("SC_OPCODE_VAR", "Number "), @@ -1743,7 +1743,7 @@ const char* SC_OPCODE_VAR_ARY[] = }; // -=*# Resource for function VAR.S #*=- -const char* SC_OPCODE_VAR_S_ARY[] = +const TranslateId SC_OPCODE_VAR_S_ARY[] = { NC_("SC_OPCODE_VAR_S", "Calculates the variance based on a sample."), NC_("SC_OPCODE_VAR_S", "Number "), @@ -1751,7 +1751,7 @@ const char* SC_OPCODE_VAR_S_ARY[] = }; // -=*# Resource for function VARA #*=- -const char* SC_OPCODE_VAR_A_ARY[] = +const TranslateId SC_OPCODE_VAR_A_ARY[] = { NC_("SC_OPCODE_VAR_A", "Returns the variance based on a sample. Text is evaluated as zero."), NC_("SC_OPCODE_VAR_A", "Value "), @@ -1759,7 +1759,7 @@ const char* SC_OPCODE_VAR_A_ARY[] = }; // -=*# Resource for function VARP #*=- -const char* SC_OPCODE_VAR_P_ARY[] = +const TranslateId SC_OPCODE_VAR_P_ARY[] = { NC_("SC_OPCODE_VAR_P", "Calculates variance based on the entire population."), NC_("SC_OPCODE_VAR_P", "Number "), @@ -1767,7 +1767,7 @@ const char* SC_OPCODE_VAR_P_ARY[] = }; // -=*# Resource for function VAR.P #*=- -const char* SC_OPCODE_VAR_P_MS_ARY[] = +const TranslateId SC_OPCODE_VAR_P_MS_ARY[] = { NC_("SC_OPCODE_VAR_P_MS", "Calculates variance based on the entire population."), NC_("SC_OPCODE_VAR_P_MS", "Number "), @@ -1775,7 +1775,7 @@ const char* SC_OPCODE_VAR_P_MS_ARY[] = }; // -=*# Resource for function VARPA #*=- -const char* SC_OPCODE_VAR_P_A_ARY[] = +const TranslateId SC_OPCODE_VAR_P_A_ARY[] = { NC_("SC_OPCODE_VAR_P_A", "Returns the variance based on the entire population. Text is evaluated as zero."), NC_("SC_OPCODE_VAR_P_A", "Value "), @@ -1783,7 +1783,7 @@ const char* SC_OPCODE_VAR_P_A_ARY[] = }; // -=*# Resource for function STDEV #*=- -const char* SC_OPCODE_ST_DEV_ARY[] = +const TranslateId SC_OPCODE_ST_DEV_ARY[] = { NC_("SC_OPCODE_ST_DEV", "Calculates the standard deviation based on a sample."), NC_("SC_OPCODE_ST_DEV", "Number "), @@ -1791,7 +1791,7 @@ const char* SC_OPCODE_ST_DEV_ARY[] = }; // -=*# Resource for function STDEV.S #*=- -const char* SC_OPCODE_ST_DEV_S_ARY[] = +const TranslateId SC_OPCODE_ST_DEV_S_ARY[] = { NC_("SC_OPCODE_ST_DEV_S", "Calculates the standard deviation based on a sample."), NC_("SC_OPCODE_ST_DEV_S", "Number "), @@ -1799,7 +1799,7 @@ const char* SC_OPCODE_ST_DEV_S_ARY[] = }; // -=*# Resource for function STDEVA #*=- -const char* SC_OPCODE_ST_DEV_A_ARY[] = +const TranslateId SC_OPCODE_ST_DEV_A_ARY[] = { NC_("SC_OPCODE_ST_DEV_A", "Returns the standard deviation based on a sample. Text is evaluated as zero."), NC_("SC_OPCODE_ST_DEV_A", "Value "), @@ -1807,7 +1807,7 @@ const char* SC_OPCODE_ST_DEV_A_ARY[] = }; // -=*# Resource for function STDEVP #*=- -const char* SC_OPCODE_ST_DEV_P_ARY[] = +const TranslateId SC_OPCODE_ST_DEV_P_ARY[] = { NC_("SC_OPCODE_ST_DEV_P", "Calculates the standard deviation based on the entire population."), NC_("SC_OPCODE_ST_DEV_P", "Number "), @@ -1815,7 +1815,7 @@ const char* SC_OPCODE_ST_DEV_P_ARY[] = }; // -=*# Resource for function STDEV.P #*=- -const char* SC_OPCODE_ST_DEV_P_MS_ARY[] = +const TranslateId SC_OPCODE_ST_DEV_P_MS_ARY[] = { NC_("SC_OPCODE_ST_DEV_P_MS", "Calculates the standard deviation based on the entire population."), NC_("SC_OPCODE_ST_DEV_P_MS", "Number "), @@ -1823,7 +1823,7 @@ const char* SC_OPCODE_ST_DEV_P_MS_ARY[] = }; // -=*# Resource for function STDEVPA #*=- -const char* SC_OPCODE_ST_DEV_P_A_ARY[] = +const TranslateId SC_OPCODE_ST_DEV_P_A_ARY[] = { NC_("SC_OPCODE_ST_DEV_P_A", "Returns the standard deviation based on the entire population. Text is evaluated as zero."), NC_("SC_OPCODE_ST_DEV_P_A", "Value "), @@ -1831,7 +1831,7 @@ const char* SC_OPCODE_ST_DEV_P_A_ARY[] = }; // -=*# Resource for function AVERAGE #*=- -const char* SC_OPCODE_AVERAGE_ARY[] = +const TranslateId SC_OPCODE_AVERAGE_ARY[] = { NC_("SC_OPCODE_AVERAGE", "Returns the average of a sample."), NC_("SC_OPCODE_AVERAGE", "Number "), @@ -1839,7 +1839,7 @@ const char* SC_OPCODE_AVERAGE_ARY[] = }; // -=*# Resource for function AVERAGEA #*=- -const char* SC_OPCODE_AVERAGE_A_ARY[] = +const TranslateId SC_OPCODE_AVERAGE_A_ARY[] = { NC_("SC_OPCODE_AVERAGE_A", "Returns the average value for a sample. Text is evaluated as zero."), NC_("SC_OPCODE_AVERAGE_A", "Value "), @@ -1847,7 +1847,7 @@ const char* SC_OPCODE_AVERAGE_A_ARY[] = }; // -=*# Resource for function DEVSQ #*=- -const char* SC_OPCODE_DEV_SQ_ARY[] = +const TranslateId SC_OPCODE_DEV_SQ_ARY[] = { NC_("SC_OPCODE_DEV_SQ", "Returns the sum of squares of deviations from the sample mean value"), NC_("SC_OPCODE_DEV_SQ", "Number "), @@ -1855,7 +1855,7 @@ const char* SC_OPCODE_DEV_SQ_ARY[] = }; // -=*# Resource for function AVEDEV #*=- -const char* SC_OPCODE_AVE_DEV_ARY[] = +const TranslateId SC_OPCODE_AVE_DEV_ARY[] = { NC_("SC_OPCODE_AVE_DEV", "Returns the average of the absolute deviations of a sample from the mean."), NC_("SC_OPCODE_AVE_DEV", "Number "), @@ -1863,7 +1863,7 @@ const char* SC_OPCODE_AVE_DEV_ARY[] = }; // -=*# Resource for function SKEW #*=- -const char* SC_OPCODE_SKEW_ARY[] = +const TranslateId SC_OPCODE_SKEW_ARY[] = { NC_("SC_OPCODE_SKEW", "Returns the skewness of a distribution."), NC_("SC_OPCODE_SKEW", "Number "), @@ -1871,7 +1871,7 @@ const char* SC_OPCODE_SKEW_ARY[] = }; // -=*# Resource for function SKEWP #*=- -const char* SC_OPCODE_SKEWP_ARY[] = +const TranslateId SC_OPCODE_SKEWP_ARY[] = { NC_("SC_OPCODE_SKEWP", "Returns the skewness of a distribution using the population of a random variable."), NC_("SC_OPCODE_SKEWP", "Number "), @@ -1879,7 +1879,7 @@ const char* SC_OPCODE_SKEWP_ARY[] = }; // -=*# Resource for function KURT #*=- -const char* SC_OPCODE_KURT_ARY[] = +const TranslateId SC_OPCODE_KURT_ARY[] = { NC_("SC_OPCODE_KURT", "Returns the kurtosis of a distribution."), NC_("SC_OPCODE_KURT", "Number "), @@ -1887,7 +1887,7 @@ const char* SC_OPCODE_KURT_ARY[] = }; // -=*# Resource for function GEOMEAN #*=- -const char* SC_OPCODE_GEO_MEAN_ARY[] = +const TranslateId SC_OPCODE_GEO_MEAN_ARY[] = { NC_("SC_OPCODE_GEO_MEAN", "Returns the geometric mean of a sample."), NC_("SC_OPCODE_GEO_MEAN", "Number "), @@ -1895,7 +1895,7 @@ const char* SC_OPCODE_GEO_MEAN_ARY[] = }; // -=*# Resource for function HARMEAN #*=- -const char* SC_OPCODE_HAR_MEAN_ARY[] = +const TranslateId SC_OPCODE_HAR_MEAN_ARY[] = { NC_("SC_OPCODE_HAR_MEAN", "Returns the harmonic mean of a sample."), NC_("SC_OPCODE_HAR_MEAN", "Number "), @@ -1903,7 +1903,7 @@ const char* SC_OPCODE_HAR_MEAN_ARY[] = }; // -=*# Resource for function MODE #*=- -const char* SC_OPCODE_MODAL_VALUE_ARY[] = +const TranslateId SC_OPCODE_MODAL_VALUE_ARY[] = { NC_("SC_OPCODE_MODAL_VALUE", "Returns the most common value in a sample."), NC_("SC_OPCODE_MODAL_VALUE", "Number "), @@ -1911,7 +1911,7 @@ const char* SC_OPCODE_MODAL_VALUE_ARY[] = }; // -=*# Resource for function MODE.SNGL #*=- -const char* SC_OPCODE_MODAL_VALUE_MS_ARY[] = +const TranslateId SC_OPCODE_MODAL_VALUE_MS_ARY[] = { NC_("SC_OPCODE_MODAL_VALUE_MS", "Returns the most common value in a sample."), NC_("SC_OPCODE_MODAL_VALUE_MS", "Number "), @@ -1919,7 +1919,7 @@ const char* SC_OPCODE_MODAL_VALUE_MS_ARY[] = }; // -=*# Resource for function MODE.MULT #*=- -const char* SC_OPCODE_MODAL_VALUE_MULTI_ARY[] = +const TranslateId SC_OPCODE_MODAL_VALUE_MULTI_ARY[] = { NC_("SC_OPCODE_MODAL_VALUE_MULTI", "Returns the most common value in a sample."), NC_("SC_OPCODE_MODAL_VALUE_MULTI", "Number "), @@ -1927,7 +1927,7 @@ const char* SC_OPCODE_MODAL_VALUE_MULTI_ARY[] = }; // -=*# Resource for function MEDIAN #*=- -const char* SC_OPCODE_MEDIAN_ARY[] = +const TranslateId SC_OPCODE_MEDIAN_ARY[] = { NC_("SC_OPCODE_MEDIAN", "Returns the median of a given sample."), NC_("SC_OPCODE_MEDIAN", "Number "), @@ -1935,7 +1935,7 @@ const char* SC_OPCODE_MEDIAN_ARY[] = }; // -=*# Resource for function PERCENTILE #*=- -const char* SC_OPCODE_PERCENTILE_ARY[] = +const TranslateId SC_OPCODE_PERCENTILE_ARY[] = { NC_("SC_OPCODE_PERCENTILE", "Returns the alpha percentile of a sample."), NC_("SC_OPCODE_PERCENTILE", "Data"), @@ -1945,7 +1945,7 @@ const char* SC_OPCODE_PERCENTILE_ARY[] = }; // -=*# Resource for function PERCENTILE.EXC #*=- -const char* SC_OPCODE_PERCENTILE_EXC_ARY[] = +const TranslateId SC_OPCODE_PERCENTILE_EXC_ARY[] = { NC_("SC_OPCODE_PERCENTILE_EXC", "Returns the alpha percentile of a sample."), NC_("SC_OPCODE_PERCENTILE_EXC", "Data"), @@ -1955,7 +1955,7 @@ const char* SC_OPCODE_PERCENTILE_EXC_ARY[] = }; // -=*# Resource for function PERCENTILE.INC #*=- -const char* SC_OPCODE_PERCENTILE_INC_ARY[] = +const TranslateId SC_OPCODE_PERCENTILE_INC_ARY[] = { NC_("SC_OPCODE_PERCENTILE_INC", "Returns the alpha percentile of a sample."), NC_("SC_OPCODE_PERCENTILE_INC", "Data"), @@ -1965,7 +1965,7 @@ const char* SC_OPCODE_PERCENTILE_INC_ARY[] = }; // -=*# Resource for function QUARTILE #*=- -const char* SC_OPCODE_QUARTILE_ARY[] = +const TranslateId SC_OPCODE_QUARTILE_ARY[] = { NC_("SC_OPCODE_QUARTILE", "Returns the quartile of a sample."), NC_("SC_OPCODE_QUARTILE", "Data"), @@ -1975,7 +1975,7 @@ const char* SC_OPCODE_QUARTILE_ARY[] = }; // -=*# Resource for function QUARTILE.EXC #*=- -const char* SC_OPCODE_QUARTILE_EXC_ARY[] = +const TranslateId SC_OPCODE_QUARTILE_EXC_ARY[] = { NC_("SC_OPCODE_QUARTILE_EXC", "Returns the quartile of a sample."), NC_("SC_OPCODE_QUARTILE_EXC", "Data"), @@ -1985,7 +1985,7 @@ const char* SC_OPCODE_QUARTILE_EXC_ARY[] = }; // -=*# Resource for function QUARTILE.INC #*=- -const char* SC_OPCODE_QUARTILE_INC_ARY[] = +const TranslateId SC_OPCODE_QUARTILE_INC_ARY[] = { NC_("SC_OPCODE_QUARTILE_INC", "Returns the quartile of a sample."), NC_("SC_OPCODE_QUARTILE_INC", "Data"), @@ -1995,7 +1995,7 @@ const char* SC_OPCODE_QUARTILE_INC_ARY[] = }; // -=*# Resource for function LARGE #*=- -const char* SC_OPCODE_LARGE_ARY[] = +const TranslateId SC_OPCODE_LARGE_ARY[] = { NC_("SC_OPCODE_LARGE", "Returns the k-th largest value of a sample."), NC_("SC_OPCODE_LARGE", "Data"), @@ -2005,7 +2005,7 @@ const char* SC_OPCODE_LARGE_ARY[] = }; // -=*# Resource for function SMALL #*=- -const char* SC_OPCODE_SMALL_ARY[] = +const TranslateId SC_OPCODE_SMALL_ARY[] = { NC_("SC_OPCODE_SMALL", "Returns the k-th smallest value of a sample."), NC_("SC_OPCODE_SMALL", "Data"), @@ -2015,7 +2015,7 @@ const char* SC_OPCODE_SMALL_ARY[] = }; // -=*# Resource for function PERCENTRANK #*=- -const char* SC_OPCODE_PERCENT_RANK_ARY[] = +const TranslateId SC_OPCODE_PERCENT_RANK_ARY[] = { NC_("SC_OPCODE_PERCENT_RANK", "Returns the percentage rank of a value in a sample."), NC_("SC_OPCODE_PERCENT_RANK", "Data"), @@ -2027,7 +2027,7 @@ const char* SC_OPCODE_PERCENT_RANK_ARY[] = }; // -=*# Resource for function PERCENTRANK.EXC #*=- -const char* SC_OPCODE_PERCENT_RANK_EXC_ARY[] = +const TranslateId SC_OPCODE_PERCENT_RANK_EXC_ARY[] = { NC_("SC_OPCODE_PERCENT_RANK_EXC", "Returns the percentage rank (0..1, exclusive) of a value in a sample."), NC_("SC_OPCODE_PERCENT_RANK_EXC", "Data"), @@ -2039,7 +2039,7 @@ const char* SC_OPCODE_PERCENT_RANK_EXC_ARY[] = }; // -=*# Resource for function PERCENTRANK.INC #*=- -const char* SC_OPCODE_PERCENT_RANK_INC_ARY[] = +const TranslateId SC_OPCODE_PERCENT_RANK_INC_ARY[] = { NC_("SC_OPCODE_PERCENT_RANK_INC", "Returns the percentage rank (0..1, inclusive) of a value in a sample."), NC_("SC_OPCODE_PERCENT_RANK_INC", "Data"), @@ -2051,7 +2051,7 @@ const char* SC_OPCODE_PERCENT_RANK_INC_ARY[] = }; // -=*# Resource for function RANK #*=- -const char* SC_OPCODE_RANK_ARY[] = +const TranslateId SC_OPCODE_RANK_ARY[] = { NC_("SC_OPCODE_RANK", "Returns the ranking of a value in a sample."), NC_("SC_OPCODE_RANK", "Value"), @@ -2063,7 +2063,7 @@ const char* SC_OPCODE_RANK_ARY[] = }; // -=*# Resource for function RANK.EQ #*=- -const char* SC_OPCODE_RANK_EQ_ARY[] = +const TranslateId SC_OPCODE_RANK_EQ_ARY[] = { NC_("SC_OPCODE_RANK_EQ", "Returns the ranking of a value in a sample; if more than one value has the same rank, the top rank of that set of values is returned."), NC_("SC_OPCODE_RANK_EQ", "Value"), @@ -2075,7 +2075,7 @@ const char* SC_OPCODE_RANK_EQ_ARY[] = }; // -=*# Resource for function RANK.AVG #*=- -const char* SC_OPCODE_RANK_AVG_ARY[] = +const TranslateId SC_OPCODE_RANK_AVG_ARY[] = { NC_("SC_OPCODE_RANK_AVG", "Returns the ranking of a value in a sample; if more than one value has the same rank, the average rank is returned."), NC_("SC_OPCODE_RANK_AVG", "Value"), @@ -2087,7 +2087,7 @@ const char* SC_OPCODE_RANK_AVG_ARY[] = }; // -=*# Resource for function TRIMMEAN #*=- -const char* SC_OPCODE_TRIM_MEAN_ARY[] = +const TranslateId SC_OPCODE_TRIM_MEAN_ARY[] = { NC_("SC_OPCODE_TRIM_MEAN", "Returns the mean of a sample without including the marginal values."), NC_("SC_OPCODE_TRIM_MEAN", "Data"), @@ -2097,7 +2097,7 @@ const char* SC_OPCODE_TRIM_MEAN_ARY[] = }; // -=*# Resource for function PROB #*=- -const char* SC_OPCODE_PROB_ARY[] = +const TranslateId SC_OPCODE_PROB_ARY[] = { NC_("SC_OPCODE_PROB", "Returns the discrete probability of an interval."), NC_("SC_OPCODE_PROB", "Data"), @@ -2111,7 +2111,7 @@ const char* SC_OPCODE_PROB_ARY[] = }; // -=*# Resource for function B #*=- -const char* SC_OPCODE_B_ARY[] = +const TranslateId SC_OPCODE_B_ARY[] = { NC_("SC_OPCODE_B", "Returns the probability of a trial result using binomial distribution."), NC_("SC_OPCODE_B", "Trials"), @@ -2125,7 +2125,7 @@ const char* SC_OPCODE_B_ARY[] = }; // -=*# Resource for function PHI #*=- -const char* SC_OPCODE_PHI_ARY[] = +const TranslateId SC_OPCODE_PHI_ARY[] = { NC_("SC_OPCODE_PHI", "Values of the distribution function for a standard normal distribution."), NC_("SC_OPCODE_PHI", "Number"), @@ -2133,7 +2133,7 @@ const char* SC_OPCODE_PHI_ARY[] = }; // -=*# Resource for function GAUSS #*=- -const char* SC_OPCODE_GAUSS_ARY[] = +const TranslateId SC_OPCODE_GAUSS_ARY[] = { NC_("SC_OPCODE_GAUSS", "Returns the integral values of the standard normal cumulative distribution."), NC_("SC_OPCODE_GAUSS", "Number"), @@ -2141,7 +2141,7 @@ const char* SC_OPCODE_GAUSS_ARY[] = }; // -=*# Resource for function FISHER #*=- -const char* SC_OPCODE_FISHER_ARY[] = +const TranslateId SC_OPCODE_FISHER_ARY[] = { NC_("SC_OPCODE_FISHER", "Returns the Fisher transformation."), NC_("SC_OPCODE_FISHER", "Number"), @@ -2149,7 +2149,7 @@ const char* SC_OPCODE_FISHER_ARY[] = }; // -=*# Resource for function FISHERINV #*=- -const char* SC_OPCODE_FISHER_INV_ARY[] = +const TranslateId SC_OPCODE_FISHER_INV_ARY[] = { NC_("SC_OPCODE_FISHER_INV", "Returns the inverse of the Fisher transformation."), NC_("SC_OPCODE_FISHER_INV", "Number"), @@ -2157,7 +2157,7 @@ const char* SC_OPCODE_FISHER_INV_ARY[] = }; // -=*# Resource for function BINOMDIST #*=- -const char* SC_OPCODE_BINOM_DIST_ARY[] = +const TranslateId SC_OPCODE_BINOM_DIST_ARY[] = { NC_("SC_OPCODE_BINOM_DIST", "Values of the binomial distribution."), NC_("SC_OPCODE_BINOM_DIST", "X"), @@ -2171,7 +2171,7 @@ const char* SC_OPCODE_BINOM_DIST_ARY[] = }; // -=*# Resource for function BINOM.DIST #*=- -const char* SC_OPCODE_BINOM_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_BINOM_DIST_MS_ARY[] = { NC_("SC_OPCODE_BINOM_DIST_MS", "Values of the binomial distribution."), NC_("SC_OPCODE_BINOM_DIST_MS", "X"), @@ -2185,7 +2185,7 @@ const char* SC_OPCODE_BINOM_DIST_MS_ARY[] = }; // -=*# Resource for function NEGBINOMDIST #*=- -const char* SC_OPCODE_NEG_BINOM_VERT_ARY[] = +const TranslateId SC_OPCODE_NEG_BINOM_VERT_ARY[] = { NC_("SC_OPCODE_NEG_BINOM_VERT", "Values of the negative binomial distribution."), NC_("SC_OPCODE_NEG_BINOM_VERT", "X"), @@ -2197,7 +2197,7 @@ const char* SC_OPCODE_NEG_BINOM_VERT_ARY[] = }; // -=*# Resource for function NEGBINOM.DIST #*=- -const char* SC_OPCODE_NEG_BINOM_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_NEG_BINOM_DIST_MS_ARY[] = { NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "Values of the negative binomial distribution."), NC_("SC_OPCODE_NEG_BINOM_DIST_MS", "X"), @@ -2211,7 +2211,7 @@ const char* SC_OPCODE_NEG_BINOM_DIST_MS_ARY[] = }; // -=*# Resource for function CRITBINOM #*=- -const char* SC_OPCODE_CRIT_BINOM_ARY[] = +const TranslateId SC_OPCODE_CRIT_BINOM_ARY[] = { NC_("SC_OPCODE_CRIT_BINOM", "Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value."), NC_("SC_OPCODE_CRIT_BINOM", "Trials"), @@ -2223,7 +2223,7 @@ const char* SC_OPCODE_CRIT_BINOM_ARY[] = }; // -=*# Resource for function BINOM.INV #*=- -const char* SC_OPCODE_BINOM_INV_ARY[] = +const TranslateId SC_OPCODE_BINOM_INV_ARY[] = { NC_("SC_OPCODE_BINOM_INV", "Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value."), NC_("SC_OPCODE_BINOM_INV", "Trials"), @@ -2235,7 +2235,7 @@ const char* SC_OPCODE_BINOM_INV_ARY[] = }; // -=*# Resource for function POISSON #*=- -const char* SC_OPCODE_POISSON_DIST_ARY[] = +const TranslateId SC_OPCODE_POISSON_DIST_ARY[] = { NC_("SC_OPCODE_POISSON_DIST", "Returns the Poisson distribution."), NC_("SC_OPCODE_POISSON_DIST", "Number"), @@ -2247,7 +2247,7 @@ const char* SC_OPCODE_POISSON_DIST_ARY[] = }; // -=*# Resource for function POISSON.DIST #*=- -const char* SC_OPCODE_POISSON_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_POISSON_DIST_MS_ARY[] = { NC_("SC_OPCODE_POISSON_DIST_MS", "Returns the Poisson distribution."), NC_("SC_OPCODE_POISSON_DIST_MS", "Number"), @@ -2259,7 +2259,7 @@ const char* SC_OPCODE_POISSON_DIST_MS_ARY[] = }; // -=*# Resource for function NORMDIST #*=- -const char* SC_OPCODE_NORM_DIST_ARY[] = +const TranslateId SC_OPCODE_NORM_DIST_ARY[] = { NC_("SC_OPCODE_NORM_DIST", "Values of the normal distribution."), NC_("SC_OPCODE_NORM_DIST", "Number"), @@ -2273,7 +2273,7 @@ const char* SC_OPCODE_NORM_DIST_ARY[] = }; // -=*# Resource for function NORM.DIST #*=- -const char* SC_OPCODE_NORM_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_NORM_DIST_MS_ARY[] = { NC_("SC_OPCODE_NORM_DIST_MS", "Values of the normal distribution."), NC_("SC_OPCODE_NORM_DIST_MS", "Number"), @@ -2287,7 +2287,7 @@ const char* SC_OPCODE_NORM_DIST_MS_ARY[] = }; // -=*# Resource for function NORMINV #*=- -const char* SC_OPCODE_NORM_INV_ARY[] = +const TranslateId SC_OPCODE_NORM_INV_ARY[] = { NC_("SC_OPCODE_NORM_INV", "Values of the inverse normal distribution."), NC_("SC_OPCODE_NORM_INV", "Number"), @@ -2299,7 +2299,7 @@ const char* SC_OPCODE_NORM_INV_ARY[] = }; // -=*# Resource for function NORM.INV #*=- -const char* SC_OPCODE_NORM_INV_MS_ARY[] = +const TranslateId SC_OPCODE_NORM_INV_MS_ARY[] = { NC_("SC_OPCODE_NORM_INV_MS", "Values of the inverse normal distribution."), NC_("SC_OPCODE_NORM_INV_MS", "Number"), @@ -2311,7 +2311,7 @@ const char* SC_OPCODE_NORM_INV_MS_ARY[] = }; // -=*# Resource for function NORMSDIST #*=- -const char* SC_OPCODE_STD_NORM_DIST_ARY[] = +const TranslateId SC_OPCODE_STD_NORM_DIST_ARY[] = { NC_("SC_OPCODE_STD_NORM_DIST", "The values of the standard normal cumulative distribution."), NC_("SC_OPCODE_STD_NORM_DIST", "Number"), @@ -2319,7 +2319,7 @@ const char* SC_OPCODE_STD_NORM_DIST_ARY[] = }; // -=*# Resource for function NORM.S.DIST #*=- -const char* SC_OPCODE_STD_NORM_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_STD_NORM_DIST_MS_ARY[] = { NC_("SC_OPCODE_STD_NORM_DIST_MS", "The values of the standard normal distribution."), NC_("SC_OPCODE_STD_NORM_DIST_MS", "Number"), @@ -2329,7 +2329,7 @@ const char* SC_OPCODE_STD_NORM_DIST_MS_ARY[] = }; // -=*# Resource for function NORMSINV #*=- -const char* SC_OPCODE_S_NORM_INV_ARY[] = +const TranslateId SC_OPCODE_S_NORM_INV_ARY[] = { NC_("SC_OPCODE_S_NORM_INV", "Values of the inverse standard normal distribution."), NC_("SC_OPCODE_S_NORM_INV", "Number"), @@ -2337,7 +2337,7 @@ const char* SC_OPCODE_S_NORM_INV_ARY[] = }; // -=*# Resource for function NORM.S.INV #*=- -const char* SC_OPCODE_S_NORM_INV_MS_ARY[] = +const TranslateId SC_OPCODE_S_NORM_INV_MS_ARY[] = { NC_("SC_OPCODE_S_NORM_INV_MS", "Values of the inverse standard normal distribution."), NC_("SC_OPCODE_S_NORM_INV_MS", "Number"), @@ -2345,7 +2345,7 @@ const char* SC_OPCODE_S_NORM_INV_MS_ARY[] = }; // -=*# Resource for function LOGNORMDIST #*=- -const char* SC_OPCODE_LOG_NORM_DIST_ARY[] = +const TranslateId SC_OPCODE_LOG_NORM_DIST_ARY[] = { NC_("SC_OPCODE_LOG_NORM_DIST", "Values of the log normal distribution."), NC_("SC_OPCODE_LOG_NORM_DIST", "Number"), @@ -2359,7 +2359,7 @@ const char* SC_OPCODE_LOG_NORM_DIST_ARY[] = }; // -=*# Resource for function LOGNORM.DIST #*=- -const char* SC_OPCODE_LOG_NORM_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_LOG_NORM_DIST_MS_ARY[] = { NC_("SC_OPCODE_LOG_NORM_DIST_MS", "Values of the log normal distribution."), NC_("SC_OPCODE_LOG_NORM_DIST_MS", "Number"), @@ -2373,7 +2373,7 @@ const char* SC_OPCODE_LOG_NORM_DIST_MS_ARY[] = }; // -=*# Resource for function LOGINV #*=- -const char* SC_OPCODE_LOG_INV_ARY[] = +const TranslateId SC_OPCODE_LOG_INV_ARY[] = { NC_("SC_OPCODE_LOG_INV", "Values of the inverse of the lognormal distribution."), NC_("SC_OPCODE_LOG_INV", "Number"), @@ -2385,7 +2385,7 @@ const char* SC_OPCODE_LOG_INV_ARY[] = }; // -=*# Resource for function LOGNORM.INV #*=- -const char* SC_OPCODE_LOG_INV_MS_ARY[] = +const TranslateId SC_OPCODE_LOG_INV_MS_ARY[] = { NC_("SC_OPCODE_LOG_INV_MS", "Values of the inverse of the lognormal distribution."), NC_("SC_OPCODE_LOG_INV_MS", "Number"), @@ -2397,7 +2397,7 @@ const char* SC_OPCODE_LOG_INV_MS_ARY[] = }; // -=*# Resource for function EXPONDIST #*=- -const char* SC_OPCODE_EXP_DIST_ARY[] = +const TranslateId SC_OPCODE_EXP_DIST_ARY[] = { NC_("SC_OPCODE_EXP_DIST", "Values of the exponential distribution."), NC_("SC_OPCODE_EXP_DIST", "Number"), @@ -2409,7 +2409,7 @@ const char* SC_OPCODE_EXP_DIST_ARY[] = }; // -=*# Resource for function EXPON.DIST #*=- -const char* SC_OPCODE_EXP_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_EXP_DIST_MS_ARY[] = { NC_("SC_OPCODE_EXP_DIST_MS", "Values of the exponential distribution."), NC_("SC_OPCODE_EXP_DIST_MS", "Number"), @@ -2421,7 +2421,7 @@ const char* SC_OPCODE_EXP_DIST_MS_ARY[] = }; // -=*# Resource for function GAMMADIST #*=- -const char* SC_OPCODE_GAMMA_DIST_ARY[] = +const TranslateId SC_OPCODE_GAMMA_DIST_ARY[] = { NC_("SC_OPCODE_GAMMA_DIST", "Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution."), NC_("SC_OPCODE_GAMMA_DIST", "Number"), @@ -2435,7 +2435,7 @@ const char* SC_OPCODE_GAMMA_DIST_ARY[] = }; // -=*# Resource for function GAMMA.DIST #*=- -const char* SC_OPCODE_GAMMA_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_GAMMA_DIST_MS_ARY[] = { NC_("SC_OPCODE_GAMMA_DIST_MS", "Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution."), NC_("SC_OPCODE_GAMMA_DIST_MS", "Number"), @@ -2449,7 +2449,7 @@ const char* SC_OPCODE_GAMMA_DIST_MS_ARY[] = }; // -=*# Resource for function GAMMAINV #*=- -const char* SC_OPCODE_GAMMA_INV_ARY[] = +const TranslateId SC_OPCODE_GAMMA_INV_ARY[] = { NC_("SC_OPCODE_GAMMA_INV", "Values of the inverse gamma distribution."), NC_("SC_OPCODE_GAMMA_INV", "Number"), @@ -2461,7 +2461,7 @@ const char* SC_OPCODE_GAMMA_INV_ARY[] = }; // -=*# Resource for function GAMMA.INV #*=- -const char* SC_OPCODE_GAMMA_INV_MS_ARY[] = +const TranslateId SC_OPCODE_GAMMA_INV_MS_ARY[] = { NC_("SC_OPCODE_GAMMA_INV_MS", "Values of the inverse gamma distribution."), NC_("SC_OPCODE_GAMMA_INV_MS", "Number"), @@ -2473,7 +2473,7 @@ const char* SC_OPCODE_GAMMA_INV_MS_ARY[] = }; // -=*# Resource for function GAMMALN #*=- -const char* SC_OPCODE_GAMMA_LN_ARY[] = +const TranslateId SC_OPCODE_GAMMA_LN_ARY[] = { NC_("SC_OPCODE_GAMMA_LN", "Returns the natural logarithm of the gamma function."), NC_("SC_OPCODE_GAMMA_LN", "Number"), @@ -2481,7 +2481,7 @@ const char* SC_OPCODE_GAMMA_LN_ARY[] = }; // -=*# Resource for function GAMMALN.PRECISE #*=- -const char* SC_OPCODE_GAMMA_LN_MS_ARY[] = +const TranslateId SC_OPCODE_GAMMA_LN_MS_ARY[] = { NC_("SC_OPCODE_GAMMA_LN_MS", "Returns the natural logarithm of the gamma function."), NC_("SC_OPCODE_GAMMA_LN_MS", "Number"), @@ -2490,7 +2490,7 @@ const char* SC_OPCODE_GAMMA_LN_MS_ARY[] = // -=*# Resource for function GAMMA #*=- -const char* SC_OPCODE_GAMMA_ARY[] = +const TranslateId SC_OPCODE_GAMMA_ARY[] = { NC_("SC_OPCODE_GAMMA", "Returns the value of the Gamma function."), NC_("SC_OPCODE_GAMMA", "Number"), @@ -2499,7 +2499,7 @@ const char* SC_OPCODE_GAMMA_ARY[] = // -=*# Resource for function BETADIST #*=- -const char* SC_OPCODE_BETA_DIST_ARY[] = +const TranslateId SC_OPCODE_BETA_DIST_ARY[] = { NC_("SC_OPCODE_BETA_DIST", "Values of the beta distribution."), NC_("SC_OPCODE_BETA_DIST", "Number"), @@ -2517,7 +2517,7 @@ const char* SC_OPCODE_BETA_DIST_ARY[] = }; // -=*# Resource for function BETAINV #*=- -const char* SC_OPCODE_BETA_INV_ARY[] = +const TranslateId SC_OPCODE_BETA_INV_ARY[] = { NC_("SC_OPCODE_BETA_INV", "Values of the inverse beta distribution."), NC_("SC_OPCODE_BETA_INV", "Number"), @@ -2533,7 +2533,7 @@ const char* SC_OPCODE_BETA_INV_ARY[] = }; // -=*# Resource for function BETA.DIST #*=- -const char* SC_OPCODE_BETA_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_BETA_DIST_MS_ARY[] = { NC_("SC_OPCODE_BETA_DIST_MS", "Values of the beta distribution."), NC_("SC_OPCODE_BETA_DIST_MS", "Number"), @@ -2551,7 +2551,7 @@ const char* SC_OPCODE_BETA_DIST_MS_ARY[] = }; // -=*# Resource for function BETA.INV #*=- -const char* SC_OPCODE_BETA_INV_MS_ARY[] = +const TranslateId SC_OPCODE_BETA_INV_MS_ARY[] = { NC_("SC_OPCODE_BETA_INV_MS", "Values of the inverse beta distribution."), NC_("SC_OPCODE_BETA_INV_MS", "Number"), @@ -2567,7 +2567,7 @@ const char* SC_OPCODE_BETA_INV_MS_ARY[] = }; // -=*# Resource for function WEIBULL #*=- -const char* SC_OPCODE_WEIBULL_ARY[] = +const TranslateId SC_OPCODE_WEIBULL_ARY[] = { NC_("SC_OPCODE_WEIBULL", "Returns the values of the Weibull distribution."), NC_("SC_OPCODE_WEIBULL", "Number"), @@ -2581,7 +2581,7 @@ const char* SC_OPCODE_WEIBULL_ARY[] = }; // -=*# Resource for function WEIBULL.DIST #*=- -const char* SC_OPCODE_WEIBULL_MS_ARY[] = +const TranslateId SC_OPCODE_WEIBULL_MS_ARY[] = { NC_("SC_OPCODE_WEIBULL_MS", "Returns the values of the Weibull distribution."), NC_("SC_OPCODE_WEIBULL_MS", "Number"), @@ -2595,7 +2595,7 @@ const char* SC_OPCODE_WEIBULL_MS_ARY[] = }; // -=*# Resource for function HYPGEOMDIST #*=- -const char* SC_OPCODE_HYP_GEOM_DIST_ARY[] = +const TranslateId SC_OPCODE_HYP_GEOM_DIST_ARY[] = { NC_("SC_OPCODE_HYP_GEOM_DIST", "Values of the hypergeometric distribution."), NC_("SC_OPCODE_HYP_GEOM_DIST", "X"), @@ -2611,7 +2611,7 @@ const char* SC_OPCODE_HYP_GEOM_DIST_ARY[] = }; // -=*# Resource for function HYPGEOM.DIST #*=- -const char* SC_OPCODE_HYP_GEOM_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_HYP_GEOM_DIST_MS_ARY[] = { NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "Values of the hypergeometric distribution."), NC_("SC_OPCODE_HYP_GEOM_DIST_MS", "X"), @@ -2627,7 +2627,7 @@ const char* SC_OPCODE_HYP_GEOM_DIST_MS_ARY[] = }; // -=*# Resource for function TDIST #*=- -const char* SC_OPCODE_T_DIST_ARY[] = +const TranslateId SC_OPCODE_T_DIST_ARY[] = { NC_("SC_OPCODE_T_DIST", "Returns the t-distribution."), NC_("SC_OPCODE_T_DIST", "Number"), @@ -2639,7 +2639,7 @@ const char* SC_OPCODE_T_DIST_ARY[] = }; // -=*# Resource for function T.DIST.2T #*=- -const char* SC_OPCODE_T_DIST_2T_ARY[] = +const TranslateId SC_OPCODE_T_DIST_2T_ARY[] = { NC_("SC_OPCODE_T_DIST_2T", "Returns the two-tailed t-distribution."), NC_("SC_OPCODE_T_DIST_2T", "Number"), @@ -2649,7 +2649,7 @@ const char* SC_OPCODE_T_DIST_2T_ARY[] = }; // -=*# Resource for function T.DIST #*=- -const char* SC_OPCODE_T_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_T_DIST_MS_ARY[] = { NC_("SC_OPCODE_T_DIST_MS", "Returns the t-distribution."), NC_("SC_OPCODE_T_DIST_MS", "Number"), @@ -2661,7 +2661,7 @@ const char* SC_OPCODE_T_DIST_MS_ARY[] = }; // -=*# Resource for function T.DIST.RT #*=- -const char* SC_OPCODE_T_DIST_RT_ARY[] = +const TranslateId SC_OPCODE_T_DIST_RT_ARY[] = { NC_("SC_OPCODE_T_DIST_RT", "Returns the right-tailed t-distribution."), NC_("SC_OPCODE_T_DIST_RT", "Number"), @@ -2671,7 +2671,7 @@ const char* SC_OPCODE_T_DIST_RT_ARY[] = }; // -=*# Resource for function TINV #*=- -const char* SC_OPCODE_T_INV_ARY[] = +const TranslateId SC_OPCODE_T_INV_ARY[] = { NC_("SC_OPCODE_T_INV", "Values of the inverse t-distribution."), NC_("SC_OPCODE_T_INV", "Number"), @@ -2681,7 +2681,7 @@ const char* SC_OPCODE_T_INV_ARY[] = }; // -=*# Resource for function T.INV #*=- -const char* SC_OPCODE_T_INV_MS_ARY[] = +const TranslateId SC_OPCODE_T_INV_MS_ARY[] = { NC_("SC_OPCODE_T_INV_MS", "Values of the left-tailed inverse t-distribution."), NC_("SC_OPCODE_T_INV_MS", "Number"), @@ -2691,7 +2691,7 @@ const char* SC_OPCODE_T_INV_MS_ARY[] = }; // -=*# Resource for function T.INV.2T #*=- -const char* SC_OPCODE_T_INV_2T_ARY[] = +const TranslateId SC_OPCODE_T_INV_2T_ARY[] = { NC_("SC_OPCODE_T_INV_2T", "Values of the two-tailed inverse t-distribution."), NC_("SC_OPCODE_T_INV_2T", "Number"), @@ -2701,7 +2701,7 @@ const char* SC_OPCODE_T_INV_2T_ARY[] = }; // -=*# Resource for function FDIST #*=- -const char* SC_OPCODE_F_DIST_ARY[] = +const TranslateId SC_OPCODE_F_DIST_ARY[] = { NC_("SC_OPCODE_F_DIST", "Values of the F probability distribution."), NC_("SC_OPCODE_F_DIST", "Number"), @@ -2713,7 +2713,7 @@ const char* SC_OPCODE_F_DIST_ARY[] = }; // -=*# Resource for function F.DIST #*=- -const char* SC_OPCODE_F_DIST_LT_ARY[] = +const TranslateId SC_OPCODE_F_DIST_LT_ARY[] = { NC_("SC_OPCODE_F_DIST_LT", "Values of the left tail F probability distribution."), NC_("SC_OPCODE_F_DIST_LT", "Number"), @@ -2727,7 +2727,7 @@ const char* SC_OPCODE_F_DIST_LT_ARY[] = }; // -=*# Resource for function F.DIST.RT #*=- -const char* SC_OPCODE_F_DIST_RT_ARY[] = +const TranslateId SC_OPCODE_F_DIST_RT_ARY[] = { NC_("SC_OPCODE_F_DIST_RT", "Values of the right tail F probability distribution."), NC_("SC_OPCODE_F_DIST_RT", "Number"), @@ -2739,7 +2739,7 @@ const char* SC_OPCODE_F_DIST_RT_ARY[] = }; // -=*# Resource for function FINV #*=- -const char* SC_OPCODE_F_INV_ARY[] = +const TranslateId SC_OPCODE_F_INV_ARY[] = { NC_("SC_OPCODE_F_INV", "Values of the inverse F distribution."), NC_("SC_OPCODE_F_INV", "Number"), @@ -2751,7 +2751,7 @@ const char* SC_OPCODE_F_INV_ARY[] = }; // -=*# Resource for function F.INV #*=- -const char* SC_OPCODE_F_INV_LT_ARY[] = +const TranslateId SC_OPCODE_F_INV_LT_ARY[] = { NC_("SC_OPCODE_F_INV_LT", "Values of the inverse left tail F distribution."), NC_("SC_OPCODE_F_INV_LT", "Number"), @@ -2763,7 +2763,7 @@ const char* SC_OPCODE_F_INV_LT_ARY[] = }; // -=*# Resource for function F.INV.RT #*=- -const char* SC_OPCODE_F_INV_RT_ARY[] = +const TranslateId SC_OPCODE_F_INV_RT_ARY[] = { NC_("SC_OPCODE_F_INV_RT", "Values of the inverse right tail F distribution."), NC_("SC_OPCODE_F_INV_RT", "Number"), @@ -2775,7 +2775,7 @@ const char* SC_OPCODE_F_INV_RT_ARY[] = }; // -=*# Resource for function CHIDIST #*=- -const char* SC_OPCODE_CHI_DIST_ARY[] = +const TranslateId SC_OPCODE_CHI_DIST_ARY[] = { NC_("SC_OPCODE_CHI_DIST", "Returns the right-tail probability of the chi-square distribution."), NC_("SC_OPCODE_CHI_DIST", "Number"), @@ -2785,7 +2785,7 @@ const char* SC_OPCODE_CHI_DIST_ARY[] = }; // -=*# Resource for function CHISQ.DIST.RT #*=- -const char* SC_OPCODE_CHI_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_CHI_DIST_MS_ARY[] = { NC_("SC_OPCODE_CHI_DIST_MS", "Returns the right-tail probability of the chi-square distribution."), NC_("SC_OPCODE_CHI_DIST_MS", "Number"), @@ -2796,7 +2796,7 @@ const char* SC_OPCODE_CHI_DIST_MS_ARY[] = // -=*# Resource for function CHISQDIST #*=- -const char* SC_OPCODE_CHISQ_DIST_ARY[] = +const TranslateId SC_OPCODE_CHISQ_DIST_ARY[] = { NC_("SC_OPCODE_CHISQ_DIST", "Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution."), NC_("SC_OPCODE_CHISQ_DIST", "Number"), @@ -2809,7 +2809,7 @@ const char* SC_OPCODE_CHISQ_DIST_ARY[] = // -=*# Resource for function CHISQ.DIST #*=- -const char* SC_OPCODE_CHISQ_DIST_MS_ARY[] = +const TranslateId SC_OPCODE_CHISQ_DIST_MS_ARY[] = { NC_("SC_OPCODE_CHISQ_DIST_MS", "Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution."), NC_("SC_OPCODE_CHISQ_DIST_MS", "Number"), @@ -2822,7 +2822,7 @@ const char* SC_OPCODE_CHISQ_DIST_MS_ARY[] = // -=*# Resource for function CHIINV #*=- -const char* SC_OPCODE_CHI_INV_ARY[] = +const TranslateId SC_OPCODE_CHI_INV_ARY[] = { NC_("SC_OPCODE_CHI_INV", "Values of the inverse of CHIDIST(x; DegreesOfFreedom)."), NC_("SC_OPCODE_CHI_INV", "Number"), @@ -2833,7 +2833,7 @@ const char* SC_OPCODE_CHI_INV_ARY[] = // -=*# Resource for function CHISQ.INV.RT #*=- -const char* SC_OPCODE_CHI_INV_MS_ARY[] = +const TranslateId SC_OPCODE_CHI_INV_MS_ARY[] = { NC_("SC_OPCODE_CHI_INV_MS", "Values of the inverse of CHIDIST(x; DegreesOfFreedom)."), NC_("SC_OPCODE_CHI_INV_MS", "Number"), @@ -2844,7 +2844,7 @@ const char* SC_OPCODE_CHI_INV_MS_ARY[] = // -=*# Resource for function CHISQINV #*=- -const char* SC_OPCODE_CHISQ_INV_ARY[] = +const TranslateId SC_OPCODE_CHISQ_INV_ARY[] = { NC_("SC_OPCODE_CHISQ_INV", "Values of the inverse of CHISQDIST(x;DegreesOfFreedom;TRUE())."), NC_("SC_OPCODE_CHISQ_INV", "Probability"), @@ -2855,7 +2855,7 @@ const char* SC_OPCODE_CHISQ_INV_ARY[] = // -=*# Resource for function CHISQ.INV #*=- -const char* SC_OPCODE_CHISQ_INV_MS_ARY[] = +const TranslateId SC_OPCODE_CHISQ_INV_MS_ARY[] = { NC_("SC_OPCODE_CHISQ_INV_MS", "Values of the inverse of CHISQ.DIST(x;DegreesOfFreedom;TRUE())."), NC_("SC_OPCODE_CHISQ_INV_MS", "Probability"), @@ -2866,7 +2866,7 @@ const char* SC_OPCODE_CHISQ_INV_MS_ARY[] = // -=*# Resource for function STANDARDIZE #*=- -const char* SC_OPCODE_STANDARD_ARY[] = +const TranslateId SC_OPCODE_STANDARD_ARY[] = { NC_("SC_OPCODE_STANDARD", "Converts a random variable to a normalized value."), NC_("SC_OPCODE_STANDARD", "Number"), @@ -2878,7 +2878,7 @@ const char* SC_OPCODE_STANDARD_ARY[] = }; // -=*# Resource for function PERMUT #*=- -const char* SC_OPCODE_PERMUT_ARY[] = +const TranslateId SC_OPCODE_PERMUT_ARY[] = { NC_("SC_OPCODE_PERMUT", "Returns the number of permutations for a given number of elements without repetition."), NC_("SC_OPCODE_PERMUT", "Count 1"), @@ -2888,7 +2888,7 @@ const char* SC_OPCODE_PERMUT_ARY[] = }; // -=*# Resource for function PERMUTATIONA #*=- -const char* SC_OPCODE_PERMUTATION_A_ARY[] = +const TranslateId SC_OPCODE_PERMUTATION_A_ARY[] = { NC_("SC_OPCODE_PERMUTATION_A", "Returns the number of permutations for a given number of objects (repetition allowed)."), NC_("SC_OPCODE_PERMUTATION_A", "Count 1"), @@ -2898,7 +2898,7 @@ const char* SC_OPCODE_PERMUTATION_A_ARY[] = }; // -=*# Resource for function CONFIDENCE #*=- -const char* SC_OPCODE_CONFIDENCE_ARY[] = +const TranslateId SC_OPCODE_CONFIDENCE_ARY[] = { NC_("SC_OPCODE_CONFIDENCE", "Returns a (1-alpha) confidence interval for a normal distribution."), NC_("SC_OPCODE_CONFIDENCE", "Alpha"), @@ -2910,7 +2910,7 @@ const char* SC_OPCODE_CONFIDENCE_ARY[] = }; // -=*# Resource for function CONFIDENCE.NORM #*=- -const char* SC_OPCODE_CONFIDENCE_N_ARY[] = +const TranslateId SC_OPCODE_CONFIDENCE_N_ARY[] = { NC_("SC_OPCODE_CONFIDENCE_N", "Returns a (1-alpha) confidence interval for a normal distribution."), NC_("SC_OPCODE_CONFIDENCE_N", "Alpha"), @@ -2922,7 +2922,7 @@ const char* SC_OPCODE_CONFIDENCE_N_ARY[] = }; // -=*# Resource for function CONFIDENCE.T #*=- -const char* SC_OPCODE_CONFIDENCE_T_ARY[] = +const TranslateId SC_OPCODE_CONFIDENCE_T_ARY[] = { NC_("SC_OPCODE_CONFIDENCE_T", "Returns a (1-alpha) confidence interval for a Student's t distribution."), NC_("SC_OPCODE_CONFIDENCE_T", "Alpha"), @@ -2934,7 +2934,7 @@ const char* SC_OPCODE_CONFIDENCE_T_ARY[] = }; // -=*# Resource for function ZTEST #*=- -const char* SC_OPCODE_Z_TEST_ARY[] = +const TranslateId SC_OPCODE_Z_TEST_ARY[] = { NC_("SC_OPCODE_Z_TEST", "Calculates the probability of observing a z-statistic greater than the one computed based on a sample."), NC_("SC_OPCODE_Z_TEST", "Data"), @@ -2946,7 +2946,7 @@ const char* SC_OPCODE_Z_TEST_ARY[] = }; // -=*# Resource for function Z.TEST #*=- -const char* SC_OPCODE_Z_TEST_MS_ARY[] = +const TranslateId SC_OPCODE_Z_TEST_MS_ARY[] = { NC_("SC_OPCODE_Z_TEST_MS", "Calculates the probability of observing a z-statistic greater than the one computed based on a sample."), NC_("SC_OPCODE_Z_TEST_MS", "Data"), @@ -2958,7 +2958,7 @@ const char* SC_OPCODE_Z_TEST_MS_ARY[] = }; // -=*# Resource for function CHITEST #*=- -const char* SC_OPCODE_CHI_TEST_ARY[] = +const TranslateId SC_OPCODE_CHI_TEST_ARY[] = { NC_("SC_OPCODE_CHI_TEST", "Returns the chi square independence test."), NC_("SC_OPCODE_CHI_TEST", "Data B"), @@ -2968,7 +2968,7 @@ const char* SC_OPCODE_CHI_TEST_ARY[] = }; // -=*# Resource for function CHISQ.TEST #*=- -const char* SC_OPCODE_CHI_TEST_MS_ARY[] = +const TranslateId SC_OPCODE_CHI_TEST_MS_ARY[] = { NC_("SC_OPCODE_CHI_TEST_MS", "Returns the chi square independence test."), NC_("SC_OPCODE_CHI_TEST_MS", "Data B"), @@ -2978,7 +2978,7 @@ const char* SC_OPCODE_CHI_TEST_MS_ARY[] = }; // -=*# Resource for function FTEST #*=- -const char* SC_OPCODE_F_TEST_ARY[] = +const TranslateId SC_OPCODE_F_TEST_ARY[] = { NC_("SC_OPCODE_F_TEST", "Calculates the F test."), NC_("SC_OPCODE_F_TEST", "Data 1"), @@ -2988,7 +2988,7 @@ const char* SC_OPCODE_F_TEST_ARY[] = }; // -=*# Resource for function F.TEST #*=- -const char* SC_OPCODE_F_TEST_MS_ARY[] = +const TranslateId SC_OPCODE_F_TEST_MS_ARY[] = { NC_("SC_OPCODE_F_TEST_MS", "Calculates the F test."), NC_("SC_OPCODE_F_TEST_MS", "Data 1"), @@ -2998,7 +2998,7 @@ const char* SC_OPCODE_F_TEST_MS_ARY[] = }; // -=*# Resource for function TTEST #*=- -const char* SC_OPCODE_T_TEST_ARY[] = +const TranslateId SC_OPCODE_T_TEST_ARY[] = { NC_("SC_OPCODE_T_TEST", "Calculates the T test."), NC_("SC_OPCODE_T_TEST", "Data 1"), @@ -3012,7 +3012,7 @@ const char* SC_OPCODE_T_TEST_ARY[] = }; // -=*# Resource for function T.TEST #*=- -const char* SC_OPCODE_T_TEST_MS_ARY[] = +const TranslateId SC_OPCODE_T_TEST_MS_ARY[] = { NC_("SC_OPCODE_T_TEST_MS", "Calculates the T test."), NC_("SC_OPCODE_T_TEST_MS", "Data 1"), @@ -3026,7 +3026,7 @@ const char* SC_OPCODE_T_TEST_MS_ARY[] = }; // -=*# Resource for function RSQ #*=- -const char* SC_OPCODE_RSQ_ARY[] = +const TranslateId SC_OPCODE_RSQ_ARY[] = { NC_("SC_OPCODE_RSQ", "Returns the square of the Pearson product moment correlation coefficient."), NC_("SC_OPCODE_RSQ", "Data Y"), @@ -3036,7 +3036,7 @@ const char* SC_OPCODE_RSQ_ARY[] = }; // -=*# Resource for function INTERCEPT #*=- -const char* SC_OPCODE_INTERCEPT_ARY[] = +const TranslateId SC_OPCODE_INTERCEPT_ARY[] = { NC_("SC_OPCODE_INTERCEPT", "Returns the intercept of the linear regression line and the Y axis."), NC_("SC_OPCODE_INTERCEPT", "Data Y"), @@ -3046,7 +3046,7 @@ const char* SC_OPCODE_INTERCEPT_ARY[] = }; // -=*# Resource for function SLOPE #*=- -const char* SC_OPCODE_SLOPE_ARY[] = +const TranslateId SC_OPCODE_SLOPE_ARY[] = { NC_("SC_OPCODE_SLOPE", "Returns the slope of the linear regression line."), NC_("SC_OPCODE_SLOPE", "Data Y"), @@ -3056,7 +3056,7 @@ const char* SC_OPCODE_SLOPE_ARY[] = }; // -=*# Resource for function STEYX #*=- -const char* SC_OPCODE_STEYX_ARY[] = +const TranslateId SC_OPCODE_STEYX_ARY[] = { NC_("SC_OPCODE_STEYX", "Returns the standard error of the linear regression."), NC_("SC_OPCODE_STEYX", "Data Y"), @@ -3066,7 +3066,7 @@ const char* SC_OPCODE_STEYX_ARY[] = }; // -=*# Resource for function PEARSON #*=- -const char* SC_OPCODE_PEARSON_ARY[] = +const TranslateId SC_OPCODE_PEARSON_ARY[] = { NC_("SC_OPCODE_PEARSON", "Returns the Pearson product moment correlation coefficient."), NC_("SC_OPCODE_PEARSON", "Data 1"), @@ -3076,7 +3076,7 @@ const char* SC_OPCODE_PEARSON_ARY[] = }; // -=*# Resource for function CORREL #*=- -const char* SC_OPCODE_CORREL_ARY[] = +const TranslateId SC_OPCODE_CORREL_ARY[] = { NC_("SC_OPCODE_CORREL", "Returns the correlation coefficient."), NC_("SC_OPCODE_CORREL", "Data 1"), @@ -3086,7 +3086,7 @@ const char* SC_OPCODE_CORREL_ARY[] = }; // -=*# Resource for function COVAR #*=- -const char* SC_OPCODE_COVAR_ARY[] = +const TranslateId SC_OPCODE_COVAR_ARY[] = { NC_("SC_OPCODE_COVAR", "Calculates the population covariance."), NC_("SC_OPCODE_COVAR", "Data 1"), @@ -3096,7 +3096,7 @@ const char* SC_OPCODE_COVAR_ARY[] = }; // -=*# Resource for function COVARIANCE.P #*=- -const char* SC_OPCODE_COVARIANCE_P_ARY[] = +const TranslateId SC_OPCODE_COVARIANCE_P_ARY[] = { NC_("SC_OPCODE_COVARIANCE_P", "Calculates the population covariance."), NC_("SC_OPCODE_COVARIANCE_P", "Data 1"), @@ -3106,7 +3106,7 @@ const char* SC_OPCODE_COVARIANCE_P_ARY[] = }; // -=*# Resource for function COVARIANCE.S #*=- -const char* SC_OPCODE_COVARIANCE_S_ARY[] = +const TranslateId SC_OPCODE_COVARIANCE_S_ARY[] = { NC_("SC_OPCODE_COVARIANCE_S", "Calculates the sample covariance."), NC_("SC_OPCODE_COVARIANCE_S", "Data 1"), @@ -3116,7 +3116,7 @@ const char* SC_OPCODE_COVARIANCE_S_ARY[] = }; // -=*# Resource for function FORECAST #*=- -const char* SC_OPCODE_FORECAST_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ARY[] = { NC_("SC_OPCODE_FORECAST", "Returns a value along a linear regression"), NC_("SC_OPCODE_FORECAST", "Value"), @@ -3128,7 +3128,7 @@ const char* SC_OPCODE_FORECAST_ARY[] = }; // -=*# Resource for function FORECAST.ETS #*=- -const char* SC_OPCODE_FORECAST_ETS_ADD_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ETS_ADD_ARY[] = { NC_("SC_OPCODE_FORECAST_ETS_ADD", "Calculates future value(s) using additive Exponential Smoothing algorithm."), NC_("SC_OPCODE_FORECAST_ETS_ADD", "Target"), @@ -3146,7 +3146,7 @@ const char* SC_OPCODE_FORECAST_ETS_ADD_ARY[] = }; // -=*# Resource for function FORECAST.ETS.MULT #*=- -const char* SC_OPCODE_FORECAST_ETS_MUL_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ETS_MUL_ARY[] = { NC_("SC_OPCODE_FORECAST_ETS_MUL", "Calculates future value(s) using multiplicative Exponential Smoothing algorithm."), NC_("SC_OPCODE_FORECAST_ETS_MUL", "Target"), @@ -3164,7 +3164,7 @@ const char* SC_OPCODE_FORECAST_ETS_MUL_ARY[] = }; // -=*# Resource for function FORECAST.ETS.CONFINT #*=- -const char* SC_OPCODE_FORECAST_ETS_PIA_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ETS_PIA_ARY[] = { NC_("SC_OPCODE_FORECAST_ETS_PIA", "Returns a prediction interval at the specified target value(s) for additive Exponential Smoothing method"), NC_("SC_OPCODE_FORECAST_ETS_PIA", "Target"), @@ -3184,7 +3184,7 @@ const char* SC_OPCODE_FORECAST_ETS_PIA_ARY[] = }; // -=*# Resource for function FORECAST.ETS.PI.MULT #*=- -const char* SC_OPCODE_FORECAST_ETS_PIM_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ETS_PIM_ARY[] = { NC_("SC_OPCODE_FORECAST_ETS_PIM", "Returns a prediction interval at the specified target value(s) for multiplicative Exponential Smoothing method"), NC_("SC_OPCODE_FORECAST_ETS_PIM", "Target"), @@ -3204,7 +3204,7 @@ const char* SC_OPCODE_FORECAST_ETS_PIM_ARY[] = }; // -=*# Resource for function FORECAST.ETS.SEASONALITY #*=- -const char* SC_OPCODE_FORECAST_ETS_SEA_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ETS_SEA_ARY[] = { NC_("SC_OPCODE_FORECAST_ETS_SEA", "Calculates the number of samples in period (season) using additive Exponential Triple Smoothing algorithm."), NC_("SC_OPCODE_FORECAST_ETS_SEA", "Values"), @@ -3218,7 +3218,7 @@ const char* SC_OPCODE_FORECAST_ETS_SEA_ARY[] = }; // -=*# Resource for function FORECAST.ETS.STAT #*=- -const char* SC_OPCODE_FORECAST_ETS_STA_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ETS_STA_ARY[] = { NC_("SC_OPCODE_FORECAST_ETS_STA", "Returns statistical value(s) using additive Exponential Smoothing algorithm."), NC_("SC_OPCODE_FORECAST_ETS_STA", "Values"), @@ -3236,7 +3236,7 @@ const char* SC_OPCODE_FORECAST_ETS_STA_ARY[] = }; // -=*# Resource for function FORECAST.ETS.STAT.MULT #*=- -const char* SC_OPCODE_FORECAST_ETS_STM_ARY[] = +const TranslateId SC_OPCODE_FORECAST_ETS_STM_ARY[] = { NC_("SC_OPCODE_FORECAST_ETS_STM", "Returns statistical value(s) using multiplicative Exponential Smoothing algorithm."), NC_("SC_OPCODE_FORECAST_ETS_STM", "Values"), @@ -3254,7 +3254,7 @@ const char* SC_OPCODE_FORECAST_ETS_STM_ARY[] = }; // -=*# Resource for function FORECAST.LINEAR #*=- -const char* SC_OPCODE_FORECAST_LIN_ARY[] = +const TranslateId SC_OPCODE_FORECAST_LIN_ARY[] = { NC_("SC_OPCODE_FORECAST_LIN", "Returns a value along a linear regression"), NC_("SC_OPCODE_FORECAST_LIN", "Value"), @@ -3266,7 +3266,7 @@ const char* SC_OPCODE_FORECAST_LIN_ARY[] = }; // -=*# Resource for function ADDRESS #*=- -const char* SC_OPCODE_ADDRESS_ARY[] = +const TranslateId SC_OPCODE_ADDRESS_ARY[] = { NC_("SC_OPCODE_ADDRESS", "Returns the reference to a cell as text."), NC_("SC_OPCODE_ADDRESS", "Row"), @@ -3282,7 +3282,7 @@ const char* SC_OPCODE_ADDRESS_ARY[] = }; // -=*# Resource for function AREAS #*=- -const char* SC_OPCODE_AREAS_ARY[] = +const TranslateId SC_OPCODE_AREAS_ARY[] = { NC_("SC_OPCODE_AREAS", "Returns the number of individual ranges that belong to a (multiple) range."), NC_("SC_OPCODE_AREAS", "Reference"), @@ -3290,7 +3290,7 @@ const char* SC_OPCODE_AREAS_ARY[] = }; // -=*# Resource for function CHOOSE #*=- -const char* SC_OPCODE_CHOOSE_ARY[] = +const TranslateId SC_OPCODE_CHOOSE_ARY[] = { NC_("SC_OPCODE_CHOOSE", "Selects a value from a list of up to 30 value arguments."), NC_("SC_OPCODE_CHOOSE", "Index"), @@ -3300,7 +3300,7 @@ const char* SC_OPCODE_CHOOSE_ARY[] = }; // -=*# Resource for function COLUMNS #*=- -const char* SC_OPCODE_COLUMN_ARY[] = +const TranslateId SC_OPCODE_COLUMN_ARY[] = { NC_("SC_OPCODE_COLUMN", "Returns the internal column number of a reference."), NC_("SC_OPCODE_COLUMN", "Reference"), @@ -3308,7 +3308,7 @@ const char* SC_OPCODE_COLUMN_ARY[] = }; // -=*# Resource for function ROW #*=- -const char* SC_OPCODE_ROW_ARY[] = +const TranslateId SC_OPCODE_ROW_ARY[] = { NC_("SC_OPCODE_ROW", "Defines the internal row number of a reference."), NC_("SC_OPCODE_ROW", "Reference"), @@ -3316,7 +3316,7 @@ const char* SC_OPCODE_ROW_ARY[] = }; // -=*# Resource for function SHEET #*=- -const char* SC_OPCODE_SHEET_ARY[] = +const TranslateId SC_OPCODE_SHEET_ARY[] = { NC_("SC_OPCODE_SHEET", "Returns the internal sheet number of a reference or a string."), NC_("SC_OPCODE_SHEET", "Reference"), @@ -3324,7 +3324,7 @@ const char* SC_OPCODE_SHEET_ARY[] = }; // -=*# Resource for function COLUMNS #*=- -const char* SC_OPCODE_COLUMNS_ARY[] = +const TranslateId SC_OPCODE_COLUMNS_ARY[] = { NC_("SC_OPCODE_COLUMNS", "Returns the number of columns in an array or reference."), NC_("SC_OPCODE_COLUMNS", "Array"), @@ -3332,7 +3332,7 @@ const char* SC_OPCODE_COLUMNS_ARY[] = }; // -=*# Resource for function ROWS #*=- -const char* SC_OPCODE_ROWS_ARY[] = +const TranslateId SC_OPCODE_ROWS_ARY[] = { NC_("SC_OPCODE_ROWS", "Returns the number of rows in a reference or array."), NC_("SC_OPCODE_ROWS", "Array"), @@ -3340,7 +3340,7 @@ const char* SC_OPCODE_ROWS_ARY[] = }; // -=*# Resource for function SHEETS #*=- -const char* SC_OPCODE_SHEETS_ARY[] = +const TranslateId SC_OPCODE_SHEETS_ARY[] = { NC_("SC_OPCODE_SHEETS", "Returns the number of sheets of a given reference. If no parameter has been entered, the total number of sheets in the document is returned."), NC_("SC_OPCODE_SHEETS", "Reference"), @@ -3348,7 +3348,7 @@ const char* SC_OPCODE_SHEETS_ARY[] = }; // -=*# Resource for function HLOOKUP #*=- -const char* SC_OPCODE_H_LOOKUP_ARY[] = +const TranslateId SC_OPCODE_H_LOOKUP_ARY[] = { NC_("SC_OPCODE_H_LOOKUP", "Horizontal search and reference to the cells located below."), NC_("SC_OPCODE_H_LOOKUP", "Search criterion"), @@ -3362,7 +3362,7 @@ const char* SC_OPCODE_H_LOOKUP_ARY[] = }; // -=*# Resource for function VLOOKUP #*=- -const char* SC_OPCODE_V_LOOKUP_ARY[] = +const TranslateId SC_OPCODE_V_LOOKUP_ARY[] = { NC_("SC_OPCODE_V_LOOKUP", "Vertical search and reference to indicated cells."), NC_("SC_OPCODE_V_LOOKUP", "Search criterion"), @@ -3376,7 +3376,7 @@ const char* SC_OPCODE_V_LOOKUP_ARY[] = }; // -=*# Resource for function INDEX #*=- -const char* SC_OPCODE_INDEX_ARY[] = +const TranslateId SC_OPCODE_INDEX_ARY[] = { NC_("SC_OPCODE_INDEX", "Returns a reference to a cell from a defined range."), NC_("SC_OPCODE_INDEX", "Reference"), @@ -3390,7 +3390,7 @@ const char* SC_OPCODE_INDEX_ARY[] = }; // -=*# Resource for function INDIRECT #*=- -const char* SC_OPCODE_INDIRECT_ARY[] = +const TranslateId SC_OPCODE_INDIRECT_ARY[] = { NC_("SC_OPCODE_INDIRECT", "Returns the contents of a cell that is referenced in text form."), NC_("SC_OPCODE_INDIRECT", "Reference"), @@ -3400,7 +3400,7 @@ const char* SC_OPCODE_INDIRECT_ARY[] = }; // -=*# Resource for function LOOKUP #*=- -const char* SC_OPCODE_LOOKUP_ARY[] = +const TranslateId SC_OPCODE_LOOKUP_ARY[] = { NC_("SC_OPCODE_LOOKUP", "Determines a value in a vector by comparison to values in another vector."), NC_("SC_OPCODE_LOOKUP", "Search criterion"), @@ -3412,7 +3412,7 @@ const char* SC_OPCODE_LOOKUP_ARY[] = }; // -=*# Resource for function MATCH #*=- -const char* SC_OPCODE_MATCH_ARY[] = +const TranslateId SC_OPCODE_MATCH_ARY[] = { NC_("SC_OPCODE_MATCH", "Defines a position in an array after comparing values."), NC_("SC_OPCODE_MATCH", "Search criterion"), @@ -3424,7 +3424,7 @@ const char* SC_OPCODE_MATCH_ARY[] = }; // -=*# Resource for function OFFSET #*=- -const char* SC_OPCODE_OFFSET_ARY[] = +const TranslateId SC_OPCODE_OFFSET_ARY[] = { NC_("SC_OPCODE_OFFSET", "Returns a reference which has been moved in relation to the starting point."), NC_("SC_OPCODE_OFFSET", "Reference"), @@ -3440,7 +3440,7 @@ const char* SC_OPCODE_OFFSET_ARY[] = }; // -=*# Resource for function ERRORTYPE #*=- -const char* SC_OPCODE_ERROR_TYPE_ARY[] = +const TranslateId SC_OPCODE_ERROR_TYPE_ARY[] = { NC_("SC_OPCODE_ERROR_TYPE", "Returns a number corresponding to an error type"), NC_("SC_OPCODE_ERROR_TYPE", "Reference"), @@ -3448,7 +3448,7 @@ const char* SC_OPCODE_ERROR_TYPE_ARY[] = }; // -=*# Resource for function ERROR.TYPE #*=- -const char* SC_OPCODE_ERROR_TYPE_ODF_ARY[] = +const TranslateId SC_OPCODE_ERROR_TYPE_ODF_ARY[] = { NC_("SC_OPCODE_ERROR_TYPE_ODF", "Returns a number corresponding to one of the error values or #N/A if no error exists"), NC_("SC_OPCODE_ERROR_TYPE_ODF", "Expression"), @@ -3456,7 +3456,7 @@ const char* SC_OPCODE_ERROR_TYPE_ODF_ARY[] = }; // -=*# Resource for function STYLE #*=- -const char* SC_OPCODE_STYLE_ARY[] = +const TranslateId SC_OPCODE_STYLE_ARY[] = { NC_("SC_OPCODE_STYLE", "Applies a Style to the formula cell."), NC_("SC_OPCODE_STYLE", "Style"), @@ -3468,7 +3468,7 @@ const char* SC_OPCODE_STYLE_ARY[] = }; // -=*# Resource for function DDE #*=- -const char* SC_OPCODE_DDE_ARY[] = +const TranslateId SC_OPCODE_DDE_ARY[] = { NC_("SC_OPCODE_DDE", "Result of a DDE link."), NC_("SC_OPCODE_DDE", "Server"), @@ -3482,7 +3482,7 @@ const char* SC_OPCODE_DDE_ARY[] = }; // -=*# Resource for function HYPERLINK #*=- -const char* SC_OPCODE_HYPERLINK_ARY[] = +const TranslateId SC_OPCODE_HYPERLINK_ARY[] = { NC_("SC_OPCODE_HYPERLINK", "Construct a Hyperlink."), NC_("SC_OPCODE_HYPERLINK", "URL"), @@ -3492,7 +3492,7 @@ const char* SC_OPCODE_HYPERLINK_ARY[] = }; // -=*# Resource for function GETPIVOTDATA #*=- -const char* SC_OPCODE_GET_PIVOT_DATA_ARY[] = +const TranslateId SC_OPCODE_GET_PIVOT_DATA_ARY[] = { NC_("SC_OPCODE_GET_PIVOT_DATA", "Extracts value(s) from a pivot table."), NC_("SC_OPCODE_GET_PIVOT_DATA", "Data field"), @@ -3504,7 +3504,7 @@ const char* SC_OPCODE_GET_PIVOT_DATA_ARY[] = }; // -=*# Resource for function BAHTTEXT #*=- -const char* SC_OPCODE_BAHTTEXT_ARY[] = +const TranslateId SC_OPCODE_BAHTTEXT_ARY[] = { NC_("SC_OPCODE_BAHTTEXT", "Converts a number to text (Baht)."), NC_("SC_OPCODE_BAHTTEXT", "Number"), @@ -3512,7 +3512,7 @@ const char* SC_OPCODE_BAHTTEXT_ARY[] = }; // -=*# Resource for function JIS #*=- -const char* SC_OPCODE_JIS_ARY[] = +const TranslateId SC_OPCODE_JIS_ARY[] = { NC_("SC_OPCODE_JIS", "Converts half-width ASCII and katakana characters to full-width."), NC_("SC_OPCODE_JIS", "Text"), @@ -3520,7 +3520,7 @@ const char* SC_OPCODE_JIS_ARY[] = }; // -=*# Resource for function ASC #*=- -const char* SC_OPCODE_ASC_ARY[] = +const TranslateId SC_OPCODE_ASC_ARY[] = { NC_("SC_OPCODE_ASC", "Converts full-width ASCII and katakana characters to half-width."), NC_("SC_OPCODE_ASC", "Text"), @@ -3528,7 +3528,7 @@ const char* SC_OPCODE_ASC_ARY[] = }; // -=*# Resource for function CODE #*=- -const char* SC_OPCODE_CODE_ARY[] = +const TranslateId SC_OPCODE_CODE_ARY[] = { NC_("SC_OPCODE_CODE", "Returns a numeric code for the first character in a text string."), NC_("SC_OPCODE_CODE", "Text"), @@ -3536,7 +3536,7 @@ const char* SC_OPCODE_CODE_ARY[] = }; // -=*# Resource for function DOLLAR #*=- -const char* SC_OPCODE_CURRENCY_ARY[] = +const TranslateId SC_OPCODE_CURRENCY_ARY[] = { NC_("SC_OPCODE_CURRENCY", "Converts a number to text in currency format."), NC_("SC_OPCODE_CURRENCY", "Value"), @@ -3546,7 +3546,7 @@ const char* SC_OPCODE_CURRENCY_ARY[] = }; // -=*# Resource for function CHAR #*=- -const char* SC_OPCODE_CHAR_ARY[] = +const TranslateId SC_OPCODE_CHAR_ARY[] = { NC_("SC_OPCODE_CHAR", "Converts a code number into a character or letter."), NC_("SC_OPCODE_CHAR", "Number"), @@ -3554,7 +3554,7 @@ const char* SC_OPCODE_CHAR_ARY[] = }; // -=*# Resource for function CLEAN #*=- -const char* SC_OPCODE_CLEAN_ARY[] = +const TranslateId SC_OPCODE_CLEAN_ARY[] = { NC_("SC_OPCODE_CLEAN", "Removes all nonprintable characters from text."), NC_("SC_OPCODE_CLEAN", "Text"), @@ -3562,7 +3562,7 @@ const char* SC_OPCODE_CLEAN_ARY[] = }; // -=*# Resource for function CONCATENATE #*=- -const char* SC_OPCODE_CONCAT_ARY[] = +const TranslateId SC_OPCODE_CONCAT_ARY[] = { NC_("SC_OPCODE_CONCAT", "Combines several text items into one."), NC_("SC_OPCODE_CONCAT", "Text"), @@ -3570,7 +3570,7 @@ const char* SC_OPCODE_CONCAT_ARY[] = }; // -=*# Resource for function CONCAT #*=- -const char* SC_OPCODE_CONCAT_MS_ARY[] = +const TranslateId SC_OPCODE_CONCAT_MS_ARY[] = { NC_("SC_OPCODE_CONCAT_MS", "Combines several text items into one, accepts cell ranges as arguments."), NC_("SC_OPCODE_CONCAT_MS", "Text"), @@ -3578,7 +3578,7 @@ const char* SC_OPCODE_CONCAT_MS_ARY[] = }; // -=*# Resource for function TEXTJOIN #*=- -const char* SC_OPCODE_TEXTJOIN_MS_ARY[] = +const TranslateId SC_OPCODE_TEXTJOIN_MS_ARY[] = { NC_("SC_OPCODE_TEXTJOIN_MS", "Combines several text items into one, accepts cell ranges as arguments. Uses delimiter between items."), NC_("SC_OPCODE_TEXTJOIN_MS", "Delimiter"), @@ -3590,7 +3590,7 @@ const char* SC_OPCODE_TEXTJOIN_MS_ARY[] = }; // -=*# Resource for function IFS #*=- -const char* SC_OPCODE_IFS_MS_ARY[] = +const TranslateId SC_OPCODE_IFS_MS_ARY[] = { NC_("SC_OPCODE_IFS_MS", "Checks 1 or more conditions and returns a value corresponding to the first true condition."), NC_("SC_OPCODE_IFS_MS", "Test"), @@ -3600,7 +3600,7 @@ const char* SC_OPCODE_IFS_MS_ARY[] = }; // -=*# Resource for function SWITCH #*=- -const char* SC_OPCODE_SWITCH_MS_ARY[] = +const TranslateId SC_OPCODE_SWITCH_MS_ARY[] = { NC_("SC_OPCODE_SWITCH_MS", "Compares expression against list of value/result pairs, and returns result for first value that matches the expression. If expression does not match any value, a default result is returned, if it is placed as final item in parameter list without a value."), NC_("SC_OPCODE_SWITCH_MS", "Expression"), @@ -3611,7 +3611,7 @@ const char* SC_OPCODE_SWITCH_MS_ARY[] = NC_("SC_OPCODE_SWITCH_MS", "Value to return when corresponding value argument matches expression.") }; -const char* SC_OPCODE_MINIFS_MS_ARY[] = +const TranslateId SC_OPCODE_MINIFS_MS_ARY[] = { NC_("SC_OPCODE_MINIFS_MS", "Returns the minimum value in a range that meet multiple criteria in multiple ranges."), NC_("SC_OPCODE_MINIFS_MS", "Min range"), @@ -3622,7 +3622,7 @@ const char* SC_OPCODE_MINIFS_MS_ARY[] = NC_("SC_OPCODE_MINIFS_MS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.") }; -const char* SC_OPCODE_MAXIFS_MS_ARY[] = +const TranslateId SC_OPCODE_MAXIFS_MS_ARY[] = { NC_("SC_OPCODE_MAXIFS_MS", "Returns the maximum value in a range that meet multiple criteria in multiple ranges."), NC_("SC_OPCODE_MAXIFS_MS", "Max range"), @@ -3634,7 +3634,7 @@ const char* SC_OPCODE_MAXIFS_MS_ARY[] = }; // -=*# Resource for function EXACT #*=- -const char* SC_OPCODE_EXACT_ARY[] = +const TranslateId SC_OPCODE_EXACT_ARY[] = { NC_("SC_OPCODE_EXACT", "Specifies whether two texts are identical."), NC_("SC_OPCODE_EXACT", "Text 1"), @@ -3644,7 +3644,7 @@ const char* SC_OPCODE_EXACT_ARY[] = }; // -=*# Resource for function FIND #*=- -const char* SC_OPCODE_FIND_ARY[] = +const TranslateId SC_OPCODE_FIND_ARY[] = { NC_("SC_OPCODE_FIND", "Looks for a string of text within another (case sensitive)"), NC_("SC_OPCODE_FIND", "Find text"), @@ -3656,7 +3656,7 @@ const char* SC_OPCODE_FIND_ARY[] = }; // -=*# Resource for function SEARCH #*=- -const char* SC_OPCODE_SEARCH_ARY[] = +const TranslateId SC_OPCODE_SEARCH_ARY[] = { NC_("SC_OPCODE_SEARCH", "Looks for one text value within another (not case-sensitive)."), NC_("SC_OPCODE_SEARCH", "Find text"), @@ -3668,7 +3668,7 @@ const char* SC_OPCODE_SEARCH_ARY[] = }; // -=*# Resource for function TRIM #*=- -const char* SC_OPCODE_TRIM_ARY[] = +const TranslateId SC_OPCODE_TRIM_ARY[] = { NC_("SC_OPCODE_TRIM", "Removes extra spaces from text."), NC_("SC_OPCODE_TRIM", "Text"), @@ -3676,7 +3676,7 @@ const char* SC_OPCODE_TRIM_ARY[] = }; // -=*# Resource for function PROPER #*=- -const char* SC_OPCODE_PROPER_ARY[] = +const TranslateId SC_OPCODE_PROPER_ARY[] = { NC_("SC_OPCODE_PROPER", "Capitalizes the first letter in all words."), NC_("SC_OPCODE_PROPER", "Text"), @@ -3684,7 +3684,7 @@ const char* SC_OPCODE_PROPER_ARY[] = }; // -=*# Resource for function UPPER #*=- -const char* SC_OPCODE_UPPER_ARY[] = +const TranslateId SC_OPCODE_UPPER_ARY[] = { NC_("SC_OPCODE_UPPER", "Converts text to uppercase."), NC_("SC_OPCODE_UPPER", "Text"), @@ -3692,7 +3692,7 @@ const char* SC_OPCODE_UPPER_ARY[] = }; // -=*# Resource for function LOWER #*=- -const char* SC_OPCODE_LOWER_ARY[] = +const TranslateId SC_OPCODE_LOWER_ARY[] = { NC_("SC_OPCODE_LOWER", "Converts text to lowercase."), NC_("SC_OPCODE_LOWER", "Text"), @@ -3700,7 +3700,7 @@ const char* SC_OPCODE_LOWER_ARY[] = }; // -=*# Resource for function VALUE #*=- -const char* SC_OPCODE_VALUE_ARY[] = +const TranslateId SC_OPCODE_VALUE_ARY[] = { NC_("SC_OPCODE_VALUE", "Converts text to a number."), NC_("SC_OPCODE_VALUE", "Text"), @@ -3708,7 +3708,7 @@ const char* SC_OPCODE_VALUE_ARY[] = }; // -=*# Resource for function TEXT #*=- -const char* SC_OPCODE_TEXT_ARY[] = +const TranslateId SC_OPCODE_TEXT_ARY[] = { NC_("SC_OPCODE_TEXT", "Converts a number to text according to a given format."), NC_("SC_OPCODE_TEXT", "Number"), @@ -3718,7 +3718,7 @@ const char* SC_OPCODE_TEXT_ARY[] = }; // -=*# Resource for function T #*=- -const char* SC_OPCODE_T_ARY[] = +const TranslateId SC_OPCODE_T_ARY[] = { NC_("SC_OPCODE_T", "Returns a value if it is text, otherwise an empty string."), NC_("SC_OPCODE_T", "Value"), @@ -3726,7 +3726,7 @@ const char* SC_OPCODE_T_ARY[] = }; // -=*# Resource for function REPLACE #*=- -const char* SC_OPCODE_REPLACE_ARY[] = +const TranslateId SC_OPCODE_REPLACE_ARY[] = { NC_("SC_OPCODE_REPLACE", "Replaces characters within a text string with a different text string."), NC_("SC_OPCODE_REPLACE", "Text"), @@ -3740,7 +3740,7 @@ const char* SC_OPCODE_REPLACE_ARY[] = }; // -=*# Resource for function FIXED #*=- -const char* SC_OPCODE_FIXED_ARY[] = +const TranslateId SC_OPCODE_FIXED_ARY[] = { NC_("SC_OPCODE_FIXED", "Formats a number with a fixed number of places after the decimal point and thousands separator."), NC_("SC_OPCODE_FIXED", "Number"), @@ -3752,7 +3752,7 @@ const char* SC_OPCODE_FIXED_ARY[] = }; // -=*# Resource for function LEN #*=- -const char* SC_OPCODE_LEN_ARY[] = +const TranslateId SC_OPCODE_LEN_ARY[] = { NC_("SC_OPCODE_LEN", "Calculates length of a text string."), NC_("SC_OPCODE_LEN", "Text"), @@ -3760,7 +3760,7 @@ const char* SC_OPCODE_LEN_ARY[] = }; // -=*# Resource for function LEFT #*=- -const char* SC_OPCODE_LEFT_ARY[] = +const TranslateId SC_OPCODE_LEFT_ARY[] = { NC_("SC_OPCODE_LEFT", "Returns the first character or characters of a text."), NC_("SC_OPCODE_LEFT", "Text"), @@ -3770,7 +3770,7 @@ const char* SC_OPCODE_LEFT_ARY[] = }; // -=*# Resource for function RIGHT #*=- -const char* SC_OPCODE_RIGHT_ARY[] = +const TranslateId SC_OPCODE_RIGHT_ARY[] = { NC_("SC_OPCODE_RIGHT", "Returns the last character or characters of a text."), NC_("SC_OPCODE_RIGHT", "Text"), @@ -3780,7 +3780,7 @@ const char* SC_OPCODE_RIGHT_ARY[] = }; // -=*# Resource for function MID #*=- -const char* SC_OPCODE_MID_ARY[] = +const TranslateId SC_OPCODE_MID_ARY[] = { NC_("SC_OPCODE_MID", "Returns a partial text string of a text."), NC_("SC_OPCODE_MID", "Text"), @@ -3792,7 +3792,7 @@ const char* SC_OPCODE_MID_ARY[] = }; // -=*# Resource for function REPT #*=- -const char* SC_OPCODE_REPT_ARY[] = +const TranslateId SC_OPCODE_REPT_ARY[] = { NC_("SC_OPCODE_REPT", "Repeats text a given number of times."), NC_("SC_OPCODE_REPT", "Text"), @@ -3802,7 +3802,7 @@ const char* SC_OPCODE_REPT_ARY[] = }; // -=*# Resource for function SUBSTITUTE #*=- -const char* SC_OPCODE_SUBSTITUTE_ARY[] = +const TranslateId SC_OPCODE_SUBSTITUTE_ARY[] = { NC_("SC_OPCODE_SUBSTITUTE", "Substitutes new text for old text in a string."), NC_("SC_OPCODE_SUBSTITUTE", "Text"), @@ -3816,7 +3816,7 @@ const char* SC_OPCODE_SUBSTITUTE_ARY[] = }; // -=*# Resource for function REGEX #*=- -const char* SC_OPCODE_REGEX_ARY[] = +const TranslateId SC_OPCODE_REGEX_ARY[] = { NC_("SC_OPCODE_REGEX", "Matches and extracts or optionally replaces text using regular expressions."), NC_("SC_OPCODE_REGEX", "Text"), @@ -3830,7 +3830,7 @@ const char* SC_OPCODE_REGEX_ARY[] = }; // -=*# Resource for function BASE #*=- -const char* SC_OPCODE_BASE_ARY[] = +const TranslateId SC_OPCODE_BASE_ARY[] = { NC_("SC_OPCODE_BASE", "Converts a positive integer to text from a number system to the base defined."), NC_("SC_OPCODE_BASE", "Number"), @@ -3842,7 +3842,7 @@ const char* SC_OPCODE_BASE_ARY[] = }; // -=*# Resource for function DECIMAL #*=- -const char* SC_OPCODE_DECIMAL_ARY[] = +const TranslateId SC_OPCODE_DECIMAL_ARY[] = { NC_("SC_OPCODE_DECIMAL", "Converts a text of a specified number system to a positive integer in the base given."), NC_("SC_OPCODE_DECIMAL", "Text"), @@ -3852,7 +3852,7 @@ const char* SC_OPCODE_DECIMAL_ARY[] = }; // -=*# Resource for function CONVERT_OOO #*=- -const char* SC_OPCODE_CONVERT_OOO_ARY[] = +const TranslateId SC_OPCODE_CONVERT_OOO_ARY[] = { NC_("SC_OPCODE_CONVERT_OOO", "Converts a value according to a conversion table in the configuration (main.xcd)."), NC_("SC_OPCODE_CONVERT_OOO", "Value"), @@ -3864,7 +3864,7 @@ const char* SC_OPCODE_CONVERT_OOO_ARY[] = }; // -=*# Resource for function ROMAN #*=- -const char* SC_OPCODE_ROMAN_ARY[] = +const TranslateId SC_OPCODE_ROMAN_ARY[] = { NC_("SC_OPCODE_ROMAN", "Converts a number to a Roman numeral."), NC_("SC_OPCODE_ROMAN", "Number"), @@ -3874,35 +3874,35 @@ const char* SC_OPCODE_ROMAN_ARY[] = }; // -=*# Resource for function ARABIC #*=- -const char* SC_OPCODE_ARABIC_ARY[] = +const TranslateId SC_OPCODE_ARABIC_ARY[] = { NC_("SC_OPCODE_ARABIC", "Calculates the value of a Roman numeral."), NC_("SC_OPCODE_ARABIC", "Text"), NC_("SC_OPCODE_ARABIC", "The text that represents a Roman numeral.") }; -const char* SC_OPCODE_INFO_ARY[] = +const TranslateId SC_OPCODE_INFO_ARY[] = { NC_("SC_OPCODE_INFO", "Returns information about the environment."), NC_("SC_OPCODE_INFO", "Text"), NC_("SC_OPCODE_INFO", "Can be \"osversion\", \"system\", \"release\", \"numfile\", and \"recalc\".") }; -const char* SC_OPCODE_UNICODE_ARY[] = +const TranslateId SC_OPCODE_UNICODE_ARY[] = { NC_("SC_OPCODE_UNICODE", "Returns the numeric code for the first Unicode character in a text string."), NC_("SC_OPCODE_UNICODE", "Text"), NC_("SC_OPCODE_UNICODE", "This is the text for which the code of the first character is to be found.") }; -const char* SC_OPCODE_UNICHAR_ARY[] = +const TranslateId SC_OPCODE_UNICHAR_ARY[] = { NC_("SC_OPCODE_UNICHAR", "Converts a code number into a Unicode character or letter."), NC_("SC_OPCODE_UNICHAR", "Number"), NC_("SC_OPCODE_UNICHAR", "The code value for the character.") }; -const char* SC_OPCODE_EUROCONVERT_ARY[] = +const TranslateId SC_OPCODE_EUROCONVERT_ARY[] = { NC_("SC_OPCODE_EUROCONVERT", "Converts a value from one to another Euro currency."), NC_("SC_OPCODE_EUROCONVERT", "Value"), @@ -3918,7 +3918,7 @@ const char* SC_OPCODE_EUROCONVERT_ARY[] = NC_("SC_OPCODE_EUROCONVERT", "If given and >=3, the intermediate result of a triangular conversion is rounded to that precision. If omitted, the result is not rounded.") }; -const char* SC_OPCODE_NUMBERVALUE_ARY[] = +const TranslateId SC_OPCODE_NUMBERVALUE_ARY[] = { NC_("SC_OPCODE_NUMBERVALUE", "Converts text to a number, in a locale-independent way."), NC_("SC_OPCODE_NUMBERVALUE", "Text"), @@ -3930,7 +3930,7 @@ const char* SC_OPCODE_NUMBERVALUE_ARY[] = }; -const char* SC_OPCODE_BITAND_ARY[] = +const TranslateId SC_OPCODE_BITAND_ARY[] = { NC_("SC_OPCODE_BITAND", "Bitwise \"AND\" of two integers."), NC_("SC_OPCODE_BITAND", "Number1"), @@ -3939,7 +3939,7 @@ const char* SC_OPCODE_BITAND_ARY[] = NC_("SC_OPCODE_BITAND", "Positive integer less than 2^48.") }; -const char* SC_OPCODE_BITOR_ARY[] = +const TranslateId SC_OPCODE_BITOR_ARY[] = { NC_("SC_OPCODE_BITOR", "Bitwise \"OR\" of two integers."), NC_("SC_OPCODE_BITOR", "Number1"), @@ -3948,7 +3948,7 @@ const char* SC_OPCODE_BITOR_ARY[] = NC_("SC_OPCODE_BITOR", "Positive integer less than 2^48.") }; -const char* SC_OPCODE_BITXOR_ARY[] = +const TranslateId SC_OPCODE_BITXOR_ARY[] = { NC_("SC_OPCODE_BITXOR", "Bitwise \"exclusive OR\" of two integers."), NC_("SC_OPCODE_BITXOR", "Number1"), @@ -3957,7 +3957,7 @@ const char* SC_OPCODE_BITXOR_ARY[] = NC_("SC_OPCODE_BITXOR", "Positive integer less than 2^48.") }; -const char* SC_OPCODE_BITRSHIFT_ARY[] = +const TranslateId SC_OPCODE_BITRSHIFT_ARY[] = { NC_("SC_OPCODE_BITRSHIFT", "Bitwise right shift of an integer value."), NC_("SC_OPCODE_BITRSHIFT", "Number"), @@ -3966,7 +3966,7 @@ const char* SC_OPCODE_BITRSHIFT_ARY[] = NC_("SC_OPCODE_BITRSHIFT", "The integer number of bits the value is to be shifted.") }; -const char* SC_OPCODE_BITLSHIFT_ARY[] = +const TranslateId SC_OPCODE_BITLSHIFT_ARY[] = { NC_("SC_OPCODE_BITLSHIFT", "Bitwise left shift of an integer value."), NC_("SC_OPCODE_BITLSHIFT", "Number"), @@ -3975,14 +3975,14 @@ const char* SC_OPCODE_BITLSHIFT_ARY[] = NC_("SC_OPCODE_BITLSHIFT", "The integer number of bits the value is to be shifted.") }; -const char* SC_OPCODE_LENB_ARY[] = +const TranslateId SC_OPCODE_LENB_ARY[] = { NC_("SC_OPCODE_LENB", "Calculates length of a text string, with DBCS"), NC_("SC_OPCODE_LENB", "Text"), NC_("SC_OPCODE_LENB", "The text in which the length is to be determined.") }; -const char* SC_OPCODE_RIGHTB_ARY[] = +const TranslateId SC_OPCODE_RIGHTB_ARY[] = { NC_("SC_OPCODE_RIGHTB", "Returns the last character or characters of a text,with DBCS"), NC_("SC_OPCODE_RIGHTB", "Text"), @@ -3991,7 +3991,7 @@ const char* SC_OPCODE_RIGHTB_ARY[] = NC_("SC_OPCODE_RIGHTB", "The number of characters for the end text.") }; -const char* SC_OPCODE_LEFTB_ARY[] = +const TranslateId SC_OPCODE_LEFTB_ARY[] = { NC_("SC_OPCODE_LEFTB", "Returns the first character or characters of a text,with DBCS"), NC_("SC_OPCODE_LEFTB", "Text"), @@ -4000,7 +4000,7 @@ const char* SC_OPCODE_LEFTB_ARY[] = NC_("SC_OPCODE_LEFTB", "The number of characters for the start text.") }; -const char* SC_OPCODE_MIDB_ARY[] = +const TranslateId SC_OPCODE_MIDB_ARY[] = { NC_("SC_OPCODE_MIDB", "Returns a partial text string of a text, with DBCS"), NC_("SC_OPCODE_MIDB", "Text"), @@ -4011,7 +4011,7 @@ const char* SC_OPCODE_MIDB_ARY[] = NC_("SC_OPCODE_MIDB", "The number of characters for the text.") }; -const char* SC_OPCODE_FILTERXML_ARY[] = +const TranslateId SC_OPCODE_FILTERXML_ARY[] = { NC_("SC_OPCODE_FILTERXML", "Apply an XPath expression to an XML document"), NC_("SC_OPCODE_FILTERXML", "XML Document"), @@ -4020,7 +4020,7 @@ const char* SC_OPCODE_FILTERXML_ARY[] = NC_("SC_OPCODE_FILTERXML", "String containing a valid XPath expression") }; -const char* SC_OPCODE_COLOR_ARY[] = +const TranslateId SC_OPCODE_COLOR_ARY[] = { NC_("SC_OPCODE_COLOR", "Returns an implementation defined value representing a RGBA color"), NC_("SC_OPCODE_COLOR", "Red"), @@ -4033,35 +4033,35 @@ const char* SC_OPCODE_COLOR_ARY[] = NC_("SC_OPCODE_COLOR", "Value of alpha") }; -const char* SC_OPCODE_WEBSERVICE_ARY[] = +const TranslateId SC_OPCODE_WEBSERVICE_ARY[] = { NC_("SC_OPCODE_WEBSERVICE", "Get some web-content from a URI."), NC_("SC_OPCODE_WEBSERVICE", "URI"), NC_("SC_OPCODE_WEBSERVICE", "URI of the webservice") }; -const char* SC_OPCODE_ENCODEURL_ARY[] = +const TranslateId SC_OPCODE_ENCODEURL_ARY[] = { NC_("SC_OPCODE_ENCODEURL", "Return a URL-encoded string."), NC_("SC_OPCODE_ENCODEURL", "Text"), NC_("SC_OPCODE_ENCODEURL", "A string to be URL-encoded") }; -const char* SC_OPCODE_ERF_MS_ARY[] = +const TranslateId SC_OPCODE_ERF_MS_ARY[] = { NC_("SC_OPCODE_ERF_MS", "Returns the error function."), NC_("SC_OPCODE_ERF_MS", "Lower limit"), NC_("SC_OPCODE_ERF_MS", "The lower limit for integration") }; -const char* SC_OPCODE_ERFC_MS_ARY[] = +const TranslateId SC_OPCODE_ERFC_MS_ARY[] = { NC_("SC_OPCODE_ERFC_MS", "Returns the complementary error function."), NC_("SC_OPCODE_ERFC_MS", "Lower limit"), NC_("SC_OPCODE_ERFC_MS", "The lower limit for integration") }; -const char* SC_OPCODE_RAWSUBTRACT_ARY[] = +const TranslateId SC_OPCODE_RAWSUBTRACT_ARY[] = { NC_("SC_OPCODE_RAWSUBTRACT", "Returns the subtraction of numbers. Like a-b-c but without eliminating small roundoff errors."), NC_("SC_OPCODE_RAWSUBTRACT", "Minuend"), @@ -4071,7 +4071,7 @@ const char* SC_OPCODE_RAWSUBTRACT_ARY[] = }; // -=*# Resource for function ROUNDSIG #*=- -const char* SC_OPCODE_ROUNDSIG_ARY[] = +const TranslateId SC_OPCODE_ROUNDSIG_ARY[] = { NC_("SC_OPCODE_ROUNDSIG", "Rounds a number to predefined significant digits."), NC_("SC_OPCODE_ROUNDSIG", "Value"), @@ -4080,7 +4080,7 @@ const char* SC_OPCODE_ROUNDSIG_ARY[] = NC_("SC_OPCODE_ROUNDSIG", "The number of significant digits to which value is to be rounded.") }; -const char* SC_OPCODE_REPLACEB_ARY[] = +const TranslateId SC_OPCODE_REPLACEB_ARY[] = { NC_("SC_OPCODE_REPLACEB", "Replaces characters within a text string with a different text string, with DBCS."), NC_("SC_OPCODE_REPLACEB", "Text"), @@ -4094,7 +4094,7 @@ const char* SC_OPCODE_REPLACEB_ARY[] = }; // -=*# Resource for function FINDB #*=- -const char* SC_OPCODE_FINDB_ARY[] = +const TranslateId SC_OPCODE_FINDB_ARY[] = { NC_("SC_OPCODE_FINDB", "Looks for a string of text within another (case sensitive), using byte positions."), NC_("SC_OPCODE_FINDB", "Find text"), @@ -4106,7 +4106,7 @@ const char* SC_OPCODE_FINDB_ARY[] = }; // -=*# Resource for function SEARCHB #*=- -const char* SC_OPCODE_SEARCHB_ARY[] = +const TranslateId SC_OPCODE_SEARCHB_ARY[] = { NC_("SC_OPCODE_SEARCHB", "Looks for a string of text within another (not case sensitive), using byte positions."), NC_("SC_OPCODE_SEARCHB", "Find text"), @@ -4118,7 +4118,7 @@ const char* SC_OPCODE_SEARCHB_ARY[] = }; // -=*# Resource for function FOURIER #*=- -const char* SC_OPCODE_FOURIER_ARY[] = +const TranslateId SC_OPCODE_FOURIER_ARY[] = { NC_("SC_OPCODE_FOURIER", "Computes the Discrete Fourier Transform (DFT) of an array"), NC_("SC_OPCODE_FOURIER", "Array"), @@ -4134,13 +4134,13 @@ const char* SC_OPCODE_FOURIER_ARY[] = }; // -=*# Resource for function RAND.NV #*=- -const char* SC_OPCODE_RANDOM_NV_ARY[] = +const TranslateId SC_OPCODE_RANDOM_NV_ARY[] = { NC_("SC_OPCODE_RANDOM_NV", "Returns a random number between 0 and 1, non-volatile.") }; // -=*# Resource for function RANDBETWEEN.NV #*=- -const char* SC_OPCODE_RANDBETWEEN_NV_ARY[] = +const TranslateId SC_OPCODE_RANDBETWEEN_NV_ARY[] = { NC_("SC_OPCODE_RANDBETWEEN_NV", "Returns a random integer between the numbers you specify, non-volatile."), NC_("SC_OPCODE_RANDBETWEEN_NV", "Bottom"), diff --git a/sc/inc/scresid.hxx b/sc/inc/scresid.hxx index 017c7a91c5c8..99a392cdb63e 100644 --- a/sc/inc/scresid.hxx +++ b/sc/inc/scresid.hxx @@ -21,8 +21,9 @@ #include <rtl/ustring.hxx> #include "scdllapi.h" +#include <unotools/resmgr.hxx> -OUString SC_DLLPUBLIC ScResId(std::string_view aId); -OUString ScResId(std::string_view aId, int nCardinality); +OUString SC_DLLPUBLIC ScResId(TranslateId aId); +OUString ScResId(TranslateNId aContextSingularPlural, int nCardinality); /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/sc/inc/scstyles.hrc b/sc/inc/scstyles.hrc index 3022cc8afa05..2d11b56d713f 100644 --- a/sc/inc/scstyles.hrc +++ b/sc/inc/scstyles.hrc @@ -21,23 +21,23 @@ #include <svl/style.hxx> -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) -const std::pair<const char*, SfxStyleSearchBits> RID_CELLSTYLEFAMILY[] = +const std::pair<TranslateId, SfxStyleSearchBits> RID_CELLSTYLEFAMILY[] = { { NC_("RID_CELLSTYLEFAMILY", "All Styles") , SfxStyleSearchBits::AllVisible }, { NC_("RID_CELLSTYLEFAMILY", "Hidden Styles") , SfxStyleSearchBits::Hidden }, { NC_("RID_CELLSTYLEFAMILY", "Applied Styles") , SfxStyleSearchBits::Used }, { NC_("RID_CELLSTYLEFAMILY", "Custom Styles") , SfxStyleSearchBits::UserDefined }, - { nullptr, SfxStyleSearchBits::Auto } + { {}, SfxStyleSearchBits::Auto } }; -const std::pair<const char*, SfxStyleSearchBits> RID_PAGESTYLEFAMILY[] = +const std::pair<TranslateId, SfxStyleSearchBits> RID_PAGESTYLEFAMILY[] = { { NC_("RID_PAGESTYLEFAMILY", "All Styles") , SfxStyleSearchBits::All }, { NC_("RID_PAGESTYLEFAMILY", "Hidden Styles") , SfxStyleSearchBits::Hidden }, { NC_("RID_PAGESTYLEFAMILY", "Custom Styles") , SfxStyleSearchBits::UserDefined }, - { nullptr, SfxStyleSearchBits::Auto } + { {}, SfxStyleSearchBits::Auto } }; /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/sc/inc/strings.hrc b/sc/inc/strings.hrc index 2815c9aa6d74..649ffd4d4020 100644 --- a/sc/inc/strings.hrc +++ b/sc/inc/strings.hrc @@ -19,8 +19,8 @@ #pragma once -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) -#define NNC_(Context, StringSingular, StringPlural) reinterpret_cast<char const *>(Context "\004" u8##StringSingular "\004" u8##StringPlural) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) +#define NNC_(Context, StringSingular, StringPlural) TranslateNId(Context, reinterpret_cast<char const *>(u8##StringSingular), reinterpret_cast<char const *>(u8##StringPlural)) // Strings for interface names ------------------------------------------- diff --git a/sc/inc/subtotals.hrc b/sc/inc/subtotals.hrc index 488802d711a2..bbf7884fcbaf 100644 --- a/sc/inc/subtotals.hrc +++ b/sc/inc/subtotals.hrc @@ -19,9 +19,9 @@ #pragma once -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) -const char* SCSTR_SUBTOTALS[] = +const TranslateId SCSTR_SUBTOTALS[] = { NC_("subtotalgrppage|liststore1", "Sum"), NC_("subtotalgrppage|liststore1", "Count"), diff --git a/sc/inc/units.hrc b/sc/inc/units.hrc index cf90776bbdaa..426141fab788 100644 --- a/sc/inc/units.hrc +++ b/sc/inc/units.hrc @@ -19,13 +19,13 @@ #pragma once -#define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) +#define NC_(Context, String) TranslateId(Context, reinterpret_cast<char const *>(u8##String)) #include <tools/fldunit.hxx> #include <utility> -const std::pair<const char*, FieldUnit> SCSTR_UNIT[] = +const std::pair<TranslateId, FieldUnit> SCSTR_UNIT[] = { { NC_("SCSTR_UNIT", "Millimeter") , FieldUnit::MM }, { NC_("SCSTR_UNIT", "Centimeter") , FieldUnit::CM }, diff --git a/sc/qa/unit/ucalc_pivottable.cxx b/sc/qa/unit/ucalc_pivottable.cxx index 62c971de6b22..2100e50d531a 100644 --- a/sc/qa/unit/ucalc_pivottable.cxx +++ b/sc/qa/unit/ucalc_pivottable.cxx @@ -466,8 +466,8 @@ void TestPivottable::testPivotTable() // This time clear the cache to refresh the data from the source range. CPPUNIT_ASSERT_MESSAGE("This datapilot should be based on sheet data.", pDPObj2->IsSheetData()); o3tl::sorted_vector<ScDPObject*> aRefs; - const char* pErrId = pDPs->ReloadCache(pDPObj2, aRefs); - CPPUNIT_ASSERT_EQUAL_MESSAGE("Cache reload failed.", static_cast<const char*>(nullptr), pErrId); + TranslateId pErrId = pDPs->ReloadCache(pDPObj2, aRefs); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Cache reload failed.", false, bool(pErrId)); CPPUNIT_ASSERT_EQUAL_MESSAGE("Reloading a cache shouldn't remove any cache.", static_cast<size_t>(1), pDPs->GetSheetCaches().size()); @@ -1718,7 +1718,7 @@ void TestPivottable::testPivotTableEmptyRows() m_pDoc->SetString(1, 2, 0, "B"); o3tl::sorted_vector<ScDPObject*> aRefs; - const char* pErr = pDPs->ReloadCache(pDPObj, aRefs); + TranslateId pErr = pDPs->ReloadCache(pDPObj, aRefs); CPPUNIT_ASSERT_MESSAGE("Failed to reload cache.", !pErr); CPPUNIT_ASSERT_EQUAL_MESSAGE("There should only be one pivot table linked to this cache.", o3tl::sorted_vector<ScDPObject*>::size_type(1), aRefs.size()); diff --git a/sc/source/core/data/attrib.cxx b/sc/source/core/data/attrib.cxx index 324c2c59c322..6bdee5cafc29 100644 --- a/sc/source/core/data/attrib.cxx +++ b/sc/source/core/data/attrib.cxx @@ -763,7 +763,7 @@ bool ScShrinkToFitCell::GetPresentation(SfxItemPresentation, OUString& rText, const IntlWrapper&) const { - const char* pId = GetValue() ? STR_SHRINKTOFITCELL_ON : STR_SHRINKTOFITCELL_OFF; + TranslateId pId = GetValue() ? STR_SHRINKTOFITCELL_ON : STR_SHRINKTOFITCELL_OFF; rText = ScResId(pId); return true; } @@ -783,7 +783,7 @@ bool ScVerticalStackCell::GetPresentation(SfxItemPresentation, OUString& rText, const IntlWrapper&) const { - const char* pId = GetValue() ? STR_VERTICALSTACKCELL_ON : STR_VERTICALSTACKCELL_OFF; + TranslateId pId = GetValue() ? STR_VERTICALSTACKCELL_ON : STR_VERTICALSTACKCELL_OFF; rText = ScResId(pId); return true; } @@ -803,7 +803,7 @@ bool ScLineBreakCell::GetPresentation(SfxItemPresentation, OUString& rText, const IntlWrapper&) const { - const char* pId = GetValue() ? STR_LINEBREAKCELL_ON : STR_LINEBREAKCELL_OFF; + TranslateId pId = GetValue() ? STR_LINEBREAKCELL_ON : STR_LINEBREAKCELL_OFF; rText = ScResId(pId); return true; } @@ -823,7 +823,7 @@ bool ScHyphenateCell::GetPresentation(SfxItemPresentation, OUString& rText, const IntlWrapper&) const { - const char* pId = GetValue() ? STR_HYPHENATECELL_ON : STR_HYPHENATECELL_OFF; + TranslateId pId = GetValue() ? STR_HYPHENATECELL_ON : STR_HYPHENATECELL_OFF; rText = ScResId(pId); return true; } diff --git a/sc/source/core/data/dpdimsave.cxx b/sc/source/core/data/dpdimsave.cxx index fa9b2ded7d78..ec80ec3d664b 100644 --- a/sc/source/core/data/dpdimsave.cxx +++ b/sc/source/core/data/dpdimsave.cxx @@ -758,7 +758,7 @@ OUString ScDPDimensionSaveData::CreateGroupDimName( namespace { - const char* aDatePartIds[] = + const TranslateId aDatePartIds[] = { STR_DPFIELD_GROUP_BY_SECONDS, STR_DPFIELD_GROUP_BY_MINUTES, diff --git a/sc/source/core/data/dpobject.cxx b/sc/source/core/data/dpobject.cxx index 287ccbcd36f3..ea0929f5a18d 100644 --- a/sc/source/core/data/dpobject.cxx +++ b/sc/source/core/data/dpobject.cxx @@ -3365,7 +3365,7 @@ public: } -const char* ScDPCollection::ReloadCache(const ScDPObject* pDPObj, o3tl::sorted_vector<ScDPObject*>& rRefs) +TranslateId ScDPCollection::ReloadCache(const ScDPObject* pDPObj, o3tl::sorted_vector<ScDPObject*>& rRefs) { if (!pDPObj) return STR_ERR_DATAPILOTSOURCE; @@ -3377,7 +3377,7 @@ const char* ScDPCollection::ReloadCache(const ScDPObject* pDPObj, o3tl::sorted_v if (!pDesc) return STR_ERR_DATAPILOTSOURCE; - const char* pErrId = pDesc->CheckSourceRange(); + TranslateId pErrId = pDesc->CheckSourceRange(); if (pErrId) return pErrId; @@ -3426,7 +3426,7 @@ const char* ScDPCollection::ReloadCache(const ScDPObject* pDPObj, o3tl::sorted_v GetAllTables(pDesc->GetCommandType(), pDesc->aDBName, pDesc->aObject, rRefs); } } - return nullptr; + return {}; } bool ScDPCollection::ReloadGroupsInCache(const ScDPObject* pDPObj, o3tl::sorted_vector<ScDPObject*>& rRefs) diff --git a/sc/source/core/data/dpoutput.cxx b/sc/source/core/data/dpoutput.cxx index ca9b214b5605..ada646b361fc 100644 --- a/sc/source/core/data/dpoutput.cxx +++ b/sc/source/core/data/dpoutput.cxx @@ -284,7 +284,7 @@ void ScDPOutputImpl::OutputBlockFrame ( SCCOL nStartCol, SCROW nStartRow, SCCOL void lcl_SetStyleById(ScDocument* pDoc, SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, - const char* pStrId) + TranslateId pStrId) { if ( nCol1 > nCol2 || nRow1 > nRow2 ) { @@ -303,12 +303,12 @@ void lcl_SetStyleById(ScDocument* pDoc, SCTAB nTab, SfxStyleSearchBits::UserDefined ) ); pStyle->SetParent( ScResId(STR_STYLENAME_STANDARD) ); SfxItemSet& rSet = pStyle->GetItemSet(); - if (strcmp(pStrId, STR_PIVOT_STYLENAME_RESULT) == 0 || strcmp(pStrId, STR_PIVOT_STYLENAME_TITLE) == 0){ + if (pStrId == STR_PIVOT_STYLENAME_RESULT || pStrId == STR_PIVOT_STYLENAME_TITLE){ rSet.Put( SvxWeightItem( WEIGHT_BOLD, ATTR_FONT_WEIGHT ) ); rSet.Put( SvxWeightItem( WEIGHT_BOLD, ATTR_CJK_FONT_WEIGHT ) ); rSet.Put( SvxWeightItem( WEIGHT_BOLD, ATTR_CTL_FONT_WEIGHT ) ); } - if (strcmp(pStrId, STR_PIVOT_STYLENAME_CATEGORY) == 0 || strcmp(pStrId, STR_PIVOT_STYLENAME_TITLE) == 0) + if (pStrId == STR_PIVOT_STYLENAME_CATEGORY || pStrId == STR_PIVOT_STYLENAME_TITLE) rSet.Put( SvxHorJustifyItem( SvxCellHorJustify::Left, ATTR_HOR_JUSTIFY ) ); } @@ -1483,7 +1483,7 @@ namespace { OUString lcl_GetDataFieldName( std::u16string_view rSourceName, sal_Int16 eFunc ) { - const char* pStrId = nullptr; + TranslateId pStrId; switch ( eFunc ) { case sheet::GeneralFunction2::SUM: pStrId = STR_FUN_TEXT_SUM; break; diff --git a/sc/source/core/data/dpshttab.cxx b/sc/source/core/data/dpshttab.cxx index c15ba043fffe..36060b282d0c 100644 --- a/sc/source/core/data/dpshttab.cxx +++ b/sc/source/core/data/dpshttab.cxx @@ -283,7 +283,7 @@ const ScDPCache* ScSheetSourceDesc::CreateCache(const ScDPDimensionSaveData* pDi if (!mpDoc) return nullptr; - const char* pErrId = CheckSourceRange(); + TranslateId pErrId = CheckSourceRange(); if (pErrId) { OSL_FAIL( "Error Create Cache" ); @@ -303,7 +303,7 @@ const ScDPCache* ScSheetSourceDesc::CreateCache(const ScDPDimensionSaveData* pDi return rCaches.getCache(GetSourceRange(), pDimData); } -const char* ScSheetSourceDesc::CheckSourceRange() const +TranslateId ScSheetSourceDesc::CheckSourceRange() const { if (!mpDoc) return STR_ERR_DATAPILOTSOURCE; @@ -316,7 +316,7 @@ const char* ScSheetSourceDesc::CheckSourceRange() const if (rSrcRange.aStart.Col() > rSrcRange.aEnd.Col() || rSrcRange.aStart.Row() > rSrcRange.aEnd.Row()) return STR_ERR_DATAPILOTSOURCE; - return nullptr; + return {}; } /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/sc/source/core/data/dptabres.cxx b/sc/source/core/data/dptabres.cxx index 46311e3570a8..4c8f38c8e558 100644 --- a/sc/source/core/data/dptabres.cxx +++ b/sc/source/core/data/dptabres.cxx @@ -59,9 +59,9 @@ using ::com::sun::star::uno::Sequence; namespace { -const char* aFuncStrIds[] = // matching enum ScSubTotalFunc +const TranslateId aFuncStrIds[] = // matching enum ScSubTotalFunc { - nullptr, // SUBTOTAL_FUNC_NONE + {}, // SUBTOTAL_FUNC_NONE STR_FUN_TEXT_AVG, // SUBTOTAL_FUNC_AVE STR_FUN_TEXT_COUNT, // SUBTOTAL_FUNC_CNT STR_FUN_TEXT_COUNT, // SUBTOTAL_FUNC_CNT2 @@ -74,7 +74,7 @@ const char* aFuncStrIds[] = // matching enum ScSubTotalFunc STR_FUN_TEXT_VAR, // SUBTOTAL_FUNC_VAR STR_FUN_TEXT_VAR, // SUBTOTAL_FUNC_VARP STR_FUN_TEXT_MEDIAN, // SUBTOTAL_FUNC_MED - nullptr // SUBTOTAL_FUNC_SELECTION_COUNT - not used for pivot table + {} // SUBTOTAL_FUNC_SELECTION_COUNT - not used for pivot table }; bool lcl_SearchMember( const std::vector<std::unique_ptr<ScDPResultMember>>& list, SCROW nOrder, SCROW& rIndex) diff --git a/sc/source/core/data/dputil.cxx b/sc/source/core/data/dputil.cxx index 62d61a733055..07794c6c3a5d 100644 --- a/sc/source/core/data/dputil.cxx +++ b/sc/source/core/data/dputil.cxx @@ -362,8 +362,8 @@ sal_Int32 ScDPUtil::getDatePartValue( namespace { -const char* aFuncStrIds[] = { - nullptr, // SUBTOTAL_FUNC_NONE +const TranslateId aFuncStrIds[] = { + {}, // SUBTOTAL_FUNC_NONE STR_FUN_TEXT_AVG, // SUBTOTAL_FUNC_AVE STR_FUN_TEXT_COUNT, // SUBTOTAL_FUNC_CNT STR_FUN_TEXT_COUNT, // SUBTOTAL_FUNC_CNT2 @@ -376,7 +376,7 @@ const char* aFuncStrIds[] = { STR_FUN_TEXT_VAR, // SUBTOTAL_FUNC_VAR STR_FUN_TEXT_VAR, // SUBTOTAL_FUNC_VARP STR_FUN_TEXT_MEDIAN, // SUBTOTAL_FUNC_MED - nullptr // SUBTOTAL_FUNC_SELECTION_COUNT - not used for pivot table + {} // SUBTOTAL_FUNC_SELECTION_COUNT - not used for pivot table }; } @@ -384,7 +384,7 @@ const char* aFuncStrIds[] = { OUString ScDPUtil::getDisplayedMeasureName(const OUString& rName, ScSubTotalFunc eFunc) { assert(unsigned(eFunc) < SAL_N_ELEMENTS(aFuncStrIds)); - const char* pId = aFuncStrIds[eFunc]; + TranslateId pId = aFuncStrIds[eFunc]; if (!pId) return rName; return ScResId(pId) + // function name diff --git a/sc/source/core/data/funcdesc.cxx b/sc/source/core/data/funcdesc.cxx index 4f3187d078e8..741b785e0869 100644 --- a/sc/source/core/data/funcdesc.cxx +++ b/sc/source/core/data/funcdesc.cxx @@ -49,7 +49,7 @@ struct ScFuncDescCore /* * Pointer to list of strings */ - const char** pResource; + const TranslateId* pResource; /* * Count of list of strings */ diff --git a/sc/source/core/data/global.cxx b/sc/source/core/data/global.cxx index 8c18329ab67b..60f66f6fd97d 100644 --- a/sc/source/core/data/global.cxx +++ b/sc/source/core/data/global.cxx @@ -300,7 +300,7 @@ void ScGlobal::SetUserList( const ScUserList* pNewList ) OUString ScGlobal::GetErrorString(FormulaError nErr) { - const char* pErrNumber; + TranslateId pErrNumber; switch (nErr) { case FormulaError::NoRef: @@ -332,7 +332,7 @@ OUString ScGlobal::GetErrorString(FormulaError nErr) OUString ScGlobal::GetLongErrorString(FormulaError nErr) { - const char* pErrNumber; + TranslateId pErrNumber; switch (nErr) { case FormulaError::NONE: diff --git a/sc/source/core/data/table3.cxx b/sc/source/core/data/table3.cxx index 48c05bcaa40d..b3af3c17ec73 100644 --- a/sc/source/core/data/table3.cxx +++ b/sc/source/core/data/table3.cxx @@ -1914,7 +1914,7 @@ struct RowEntry } -static const char* lcl_GetSubTotalStrId(int id) +static TranslateId lcl_GetSubTotalStrId(int id) { switch ( id ) { @@ -2072,7 +2072,7 @@ bool ScTable::DoSubTotals( ScSubTotalParam& rParam ) if (aOutString.isEmpty()) aOutString = ScResId( STR_EMPTYDATA ); aOutString += " "; - const char* pStrId = STR_TABLE_ERGEBNIS; + TranslateId pStrId = STR_TABLE_ERGEBNIS; if ( nResCount == 1 ) pStrId = lcl_GetSubTotalStrId(pResFunc[0]); aOutString += ScResId(pStrId); diff --git a/sc/source/core/tool/autoform.cxx b/sc/source/core/tool/autoform.cxx index 9e88957575b4..7430eff33c91 100644 --- a/sc/source/core/tool/autoform.cxx +++ b/sc/source/core/tool/autoform.cxx @@ -563,7 +563,7 @@ void ScAutoFormatData::GetFromItemSet( sal_uInt16 nIndex, const SfxItemSet& rIte rField.SetRotateMode ( rItemSet.Get( ATTR_ROTATE_MODE ) ); } -static const char* RID_SVXSTR_TBLAFMT[] = +const TranslateId RID_SVXSTR_TBLAFMT[] = { RID_SVXSTR_TBLAFMT_3D, RID_SVXSTR_TBLAFMT_BLACK1, diff --git a/sc/source/core/tool/chgtrack.cxx b/sc/source/core/tool/chgtrack.cxx index d68009446dcc..24da3d93cc3a 100644 --- a/sc/source/core/tool/chgtrack.cxx +++ b/sc/source/core/tool/chgtrack.cxx @@ -671,7 +671,7 @@ void ScChangeActionIns::GetDescription( { ScChangeAction::GetDescription( rStr, rDoc, bSplitRange, bWarning ); - const char* pWhatId; + TranslateId pWhatId; switch ( GetType() ) { case SC_CAT_INSERT_COLS : @@ -905,7 +905,7 @@ void ScChangeActionDel::GetDescription( { ScChangeAction::GetDescription( rStr, rDoc, bSplitRange, bWarning ); - const char* pWhatId; + TranslateId pWhatId; switch ( GetType() ) { case SC_CAT_DELETE_COLS : diff --git a/sc/source/filter/excel/xepivot.cxx b/sc/source/filter/excel/xepivot.cxx index 8156b4579499..53a95144b3fc 100644 --- a/sc/source/filter/excel/xepivot.cxx +++ b/sc/source/filter/excel/xepivot.cxx @@ -870,7 +870,7 @@ OUString lclGetDataFieldCaption( std::u16string_view rFieldName, ScGeneralFuncti { OUString aCaption; - const char* pResIdx = nullptr; + TranslateId pResIdx; switch( eFunc ) { case ScGeneralFunction::SUM: pResIdx = STR_FUN_TEXT_SUM; break; diff --git a/sc/source/filter/ftools/fprogressbar.cxx b/sc/source/filter/ftools/fprogressbar.cxx index 89301c14da56..3b84e84924dd 100644 --- a/sc/source/filter/ftools/fprogressbar.cxx +++ b/sc/source/filter/ftools/fprogressbar.cxx @@ -42,7 +42,7 @@ ScfProgressBar::ScfProgressBar( SfxObjectShell* pDocShell, const OUString& rText Init( pDocShell ); } -ScfProgressBar::ScfProgressBar(SfxObjectShell* pDocShell, const char* pResId) +ScfProgressBar::ScfProgressBar(SfxObjectShell* pDocShell, TranslateId pResId) : maText(ScResId(pResId)) { Init( pDocShell ); @@ -200,7 +200,7 @@ ScfSimpleProgressBar::ScfSimpleProgressBar( std::size_t nSize, SfxObjectShell* p Init( nSize ); } -ScfSimpleProgressBar::ScfSimpleProgressBar(std::size_t nSize, SfxObjectShell* pDocShell, const char* pResId) +ScfSimpleProgressBar::ScfSimpleProgressBar(std::size_t nSize, SfxObjectShell* pDocShell, TranslateId pResId) : maProgress(pDocShell, pResId) { Init( nSize ); diff --git a/sc/source/filter/inc/fprogressbar.hxx b/sc/source/filter/inc/fprogressbar.hxx index e5ae8aaf5d6c..71baa3766edf 100644 --- a/sc/source/filter/inc/fprogressbar.hxx +++ b/sc/source/filter/inc/fprogressbar.hxx @@ -23,6 +23,7 @@ #include <memory> #include <rtl/ustring.hxx> #include <progress.hxx> +#include <unotools/resmgr.hxx> class SfxObjectShell; class SvStream; @@ -105,7 +106,7 @@ public: const ScfProgressBar operator=(const ScfProgressBar&) = delete; explicit ScfProgressBar(SfxObjectShell* pDocShell, const OUString& rText); - explicit ScfProgressBar(SfxObjectShell* pDocShell, const char* pResId); + explicit ScfProgressBar(SfxObjectShell* pDocShell, TranslateId pResId); ~ScfProgressBar(); /** Adds a new segment to the progress bar. @@ -186,7 +187,7 @@ class ScfSimpleProgressBar { public: explicit ScfSimpleProgressBar(std::size_t nSize, SfxObjectShell* pDocShell, const OUString& rText); - explicit ScfSimpleProgressBar(std::size_t nSize, SfxObjectShell* pDocShell, const char* pResId); + explicit ScfSimpleProgressBar(std::size_t nSize, SfxObjectShell* pDocShell, TranslateId pResId); /** Set progress bar to the specified position. */ void ProgressAbs( std::size_t nPos ) { maProgress.ProgressAbs( nPos ); } diff --git a/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx b/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx index 9c59007314af..f6871ccffa46 100644 --- a/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx @@ -22,7 +22,7 @@ namespace { struct StatisticCalculation { - const char* aLabelId; + TranslateId aLabelId; const char* aFormula; const char* aResultRangeName; }; @@ -34,10 +34,10 @@ StatisticCalculation const lclBasicStatistics[] = { STRID_CALC_SUM, "=SUM(%RANGE%)", "SUM_RANGE" }, { STRID_CALC_MEAN, "=AVERAGE(%RANGE%)", "MEAN_RANGE" }, { STRID_CALC_VARIANCE, "=VAR(%RANGE%)", "VAR_RANGE" }, - { nullptr, nullptr, nullptr } + { {}, nullptr, nullptr } }; -const char* lclAnovaLabels[] = +const TranslateId lclAnovaLabels[] = { STR_ANOVA_LABEL_SOURCE_OF_VARIATION, STR_ANOVA_LABEL_SS, @@ -46,7 +46,7 @@ const char* lclAnovaLabels[] = STR_ANOVA_LABEL_F, STR_ANOVA_LABEL_P_VALUE, STR_ANOVA_LABEL_F_CRITICAL, - nullptr + {} }; constexpr OUStringLiteral strWildcardRange = u"%RANGE%"; @@ -116,7 +116,7 @@ void ScAnalysisOfVarianceDialog::Close() DoClose( ScAnalysisOfVarianceDialogWrapper::GetChildWindowId() ); } -const char* ScAnalysisOfVarianceDialog::GetUndoNameId() +TranslateId ScAnalysisOfVarianceDialog::GetUndoNameId() { return STR_ANALYSIS_OF_VARIANCE_UNDO_NAME; } @@ -164,7 +164,7 @@ void ScAnalysisOfVarianceDialog::RowColumn(ScRangeList& rRangeList, AddressWalke } else { - const char* pLabelId = (aGroupedBy == BY_COLUMN) ? STR_COLUMN_LABEL_TEMPLATE : STR_ROW_LABEL_TEMPLATE; + TranslateId pLabelId = (aGroupedBy == BY_COLUMN) ? STR_COLUMN_LABEL_TEMPLATE : STR_ROW_LABEL_TEMPLATE; OUString aLabelTemplate(ScResId(pLabelId)); for (size_t i = 0; i < rRangeList.size(); i++) diff --git a/sc/source/ui/StatisticsDialogs/ChiSquareTestDialog.cxx b/sc/source/ui/StatisticsDialogs/ChiSquareTestDialog.cxx index 7fb2d50d7dee..cfcf53699df9 100644 --- a/sc/source/ui/StatisticsDialogs/ChiSquareTestDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/ChiSquareTestDialog.cxx @@ -32,7 +32,7 @@ void ScChiSquareTestDialog::Close() DoClose(ScChiSquareTestDialogWrapper::GetChildWindowId()); } -const char* ScChiSquareTestDialog::GetUndoNameId() +TranslateId ScChiSquareTestDialog::GetUndoNameId() { return STR_CHI_SQUARE_TEST; } diff --git a/sc/source/ui/StatisticsDialogs/CovarianceDialog.cxx b/sc/source/ui/StatisticsDialogs/CovarianceDialog.cxx index 7abff79dc571..b2849d316c37 100644 --- a/sc/source/ui/StatisticsDialogs/CovarianceDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/CovarianceDialog.cxx @@ -21,7 +21,7 @@ ScCovarianceDialog::ScCovarianceDialog( "modules/scalc/ui/covariancedialog.ui", "CovarianceDialog") {} -const char* ScCovarianceDialog::GetUndoNameId() +TranslateId ScCovarianceDialog::GetUndoNameId() { return STR_COVARIANCE_UNDO_NAME; } diff --git a/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx b/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx index ca2da6458860..0924278c50d9 100644 --- a/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx @@ -20,7 +20,7 @@ namespace { struct StatisticCalculation { - const char* aCalculationNameId; + TranslateId aCalculationNameId; const char* aFormula; }; @@ -41,7 +41,7 @@ const StatisticCalculation lclCalcDefinitions[] = { STRID_CALC_MAX, "=MAX(%RANGE%)"}, { STRID_CALC_SUM, "=SUM(%RANGE%)"}, { STRID_CALC_COUNT, "=COUNT(%RANGE%)" }, - { nullptr, nullptr } + { {}, nullptr } }; } @@ -63,7 +63,7 @@ void ScDescriptiveStatisticsDialog::Close() DoClose( ScDescriptiveStatisticsDialogWrapper::GetChildWindowId() ); } -const char* ScDescriptiveStatisticsDialog::GetUndoNameId() +TranslateId ScDescriptiveStatisticsDialog::GetUndoNameId() { return STR_DESCRIPTIVE_STATISTICS_UNDO_NAME; } diff --git a/sc/source/ui/StatisticsDialogs/ExponentialSmoothingDialog.cxx b/sc/source/ui/StatisticsDialogs/ExponentialSmoothingDialog.cxx index df3aef026b50..1a87f5beb3cd 100644 --- a/sc/source/ui/StatisticsDialogs/ExponentialSmoothingDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/ExponentialSmoothingDialog.cxx @@ -36,7 +36,7 @@ void ScExponentialSmoothingDialog::Close() DoClose( ScExponentialSmoothingDialogWrapper::GetChildWindowId() ); } -const char* ScExponentialSmoothingDialog::GetUndoNameId() +TranslateId ScExponentialSmoothingDialog::GetUndoNameId() { return STR_EXPONENTIAL_SMOOTHING_UNDO_NAME; } diff --git a/sc/source/ui/StatisticsDialogs/FTestDialog.cxx b/sc/source/ui/StatisticsDialogs/FTestDialog.cxx index d7b86bc4869f..76b2bade62db 100644 --- a/sc/source/ui/StatisticsDialogs/FTestDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/FTestDialog.cxx @@ -34,7 +34,7 @@ void ScFTestDialog::Close() DoClose( ScFTestDialogWrapper::GetChildWindowId() ); } -const char* ScFTestDialog::GetUndoNameId() +TranslateId ScFTestDialog::GetUndoNameId() { return STR_FTEST_UNDO_NAME; } diff --git a/sc/source/ui/StatisticsDialogs/FourierAnalysisDialog.cxx b/sc/source/ui/StatisticsDialogs/FourierAnalysisDialog.cxx index 69da12adc126..13e622963f5b 100644 --- a/sc/source/ui/StatisticsDialogs/FourierAnalysisDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/FourierAnalysisDialog.cxx @@ -49,7 +49,7 @@ void ScFourierAnalysisDialog::Close() DoClose(ScFourierAnalysisDialogWrapper::GetChildWindowId()); } -const char* ScFourierAnalysisDialog::GetUndoNameId() { return STR_FOURIER_ANALYSIS; } +TranslateId ScFourierAnalysisDialog::GetUndoNameId() { return STR_FOURIER_ANALYSIS; } ScRange ScFourierAnalysisDialog::ApplyOutput(ScDocShell* pDocShell) { diff --git a/sc/source/ui/StatisticsDialogs/MatrixComparisonGenerator.cxx b/sc/source/ui/StatisticsDialogs/MatrixComparisonGenerator.cxx index 1b26119f8893..4345b816bb96 100644 --- a/sc/source/ui/StatisticsDialogs/MatrixComparisonGenerator.cxx +++ b/sc/source/ui/StatisticsDialogs/MatrixComparisonGenerator.cxx @@ -50,7 +50,7 @@ ScMatrixComparisonGenerator::ScMatrixComparisonGenerator( ScMatrixComparisonGenerator::~ScMatrixComparisonGenerator() {} -const char* ScMatrixComparisonGenerator::GetUndoNameId() +TranslateId ScMatrixComparisonGenerator::GetUndoNameId() { return STR_CORRELATION_UNDO_NAME; } diff --git a/sc/source/ui/StatisticsDialogs/MovingAverageDialog.cxx b/sc/source/ui/StatisticsDialogs/MovingAverageDialog.cxx index 813378cab952..9d990ed5a406 100644 --- a/sc/source/ui/StatisticsDialogs/MovingAverageDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/MovingAverageDialog.cxx @@ -37,7 +37,7 @@ void ScMovingAverageDialog::Close() DoClose( ScMovingAverageDialogWrapper::GetChildWindowId() ); } -const char* ScMovingAverageDialog::GetUndoNameId() +TranslateId ScMovingAverageDialog::GetUndoNameId() { return STR_MOVING_AVERAGE_UNDO_NAME; } diff --git a/sc/source/ui/StatisticsDialogs/RandomNumberGeneratorDialog.cxx b/sc/source/ui/StatisticsDialogs/RandomNumberGeneratorDialog.cxx index 3aa6b93626ee..91b43cbe0433 100644 --- a/sc/source/ui/StatisticsDialogs/RandomNumberGeneratorDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/RandomNumberGeneratorDialog.cxx @@ -250,7 +250,7 @@ void ScRandomNumberGeneratorDialog::SelectGeneratorAndGenerateNumbers() } template<class RNG> -void ScRandomNumberGeneratorDialog::GenerateNumbers(RNG& randomGenerator, const char* pDistributionStringId, std::optional<sal_Int8> aDecimalPlaces) +void ScRandomNumberGeneratorDialog::GenerateNumbers(RNG& randomGenerator, TranslateId pDistributionStringId, std::optional<sal_Int8> aDecimalPlaces) { OUString aUndo = ScResId(STR_UNDO_DISTRIBUTION_TEMPLATE); OUString aDistributionName = ScResId(pDistributionStringId); diff --git a/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx b/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx index 5a4002f97d62..fb4342444e95 100644 --- a/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx @@ -103,7 +103,7 @@ namespace POWER }; - const char* constRegressionModel[] = + const TranslateId constRegressionModel[] = { STR_LABEL_LINEAR, STR_LABEL_LOGARITHMIC, @@ -167,7 +167,7 @@ void ScRegressionDialog::Close() DoClose(ScRegressionDialogWrapper::GetChildWindowId()); } -const char* ScRegressionDialog::GetUndoNameId() +TranslateId ScRegressionDialog::GetUndoNameId() { return STR_REGRESSION_UNDO_NAME; } @@ -396,7 +396,7 @@ void ScRegressionDialog::WriteRegressionStatistics(AddressWalkerWriter& rOutput, rOutput.writeString(ScResId(STR_LABEL_REGRESSION_STATISTICS)); rOutput.newLine(); - const char* aMeasureNames[] = + const TranslateId aMeasureNames[] = { STR_LABEL_RSQUARED, STRID_CALC_STD_ERROR, diff --git a/sc/source/ui/StatisticsDialogs/TTestDialog.cxx b/sc/source/ui/StatisticsDialogs/TTestDialog.cxx index 9788fc192d4d..864d4ac4f6c2 100644 --- a/sc/source/ui/StatisticsDialogs/TTestDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/TTestDialog.cxx @@ -34,7 +34,7 @@ void ScTTestDialog::Close() DoClose( ScTTestDialogWrapper::GetChildWindowId() ); } -const char* ScTTestDialog::GetUndoNameId() +TranslateId ScTTestDialog::GetUndoNameId() { return STR_TTEST_UNDO_NAME; } diff --git a/sc/source/ui/StatisticsDialogs/ZTestDialog.cxx b/sc/source/ui/StatisticsDialogs/ZTestDialog.cxx index 2421b3ef19f7..a1731fa8f055 100644 --- a/sc/source/ui/StatisticsDialogs/ZTestDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/ZTestDialog.cxx @@ -34,7 +34,7 @@ void ScZTestDialog::Close() DoClose( ScZTestDialogWrapper::GetChildWindowId() ); } -const char* ScZTestDialog::GetUndoNameId() +TranslateId ScZTestDialog::GetUndoNameId() { return STR_ZTEST_UNDO_NAME; } diff --git a/sc/source/ui/app/inputhdl.cxx b/sc/source/ui/app/inputhdl.cxx index b3e644fc8620..1dea0d05109e 100644 --- a/sc/source/ui/app/inputhdl.cxx +++ b/sc/source/ui/app/inputhdl.cxx @@ -2375,7 +2375,7 @@ bool ScInputHandler::StartTable( sal_Unicode cTyped, bool bFromCommand, bool bIn // whether it's part of an array or not or whether explicit cell // activation is requested (double-click or F2) or a click in input // line. - bool bShowError = (!bInputActivated || !aTester.GetMessageId() || strcmp(aTester.GetMessageId(), STR_PROTECTIONERR) != 0) && + bool bShowError = (!bInputActivated || !aTester.GetMessageId() || aTester.GetMessageId() != STR_PROTECTIONERR) && !pActiveViewSh->GetViewData().GetDocShell()->IsReadOnly(); if (bShowError) { diff --git a/sc/source/ui/app/inputwin.cxx b/sc/source/ui/app/inputwin.cxx index 7aa3084fe84e..252e2f21a745 100644 --- a/sc/source/ui/app/inputwin.cxx +++ b/sc/source/ui/app/inputwin.cxx @@ -2438,7 +2438,7 @@ IMPL_LINK_NOARG(ScPosWnd, ModifyHdl, weld::ComboBox&, void) // determine the action that would be taken for the current input ScNameInputType eType = lcl_GetInputType(m_xWidget->get_active_text()); // uses current view - const char* pStrId = nullptr; + TranslateId pStrId; switch ( eType ) { case SC_NAME_INPUT_CELL: @@ -2523,7 +2523,7 @@ void ScPosWnd::DoEnter() ScNameInputType eType = lcl_GetInputType( aText ); if ( eType == SC_NAME_INPUT_BAD_NAME || eType == SC_NAME_INPUT_BAD_SELECTION ) { - const char* pId = (eType == SC_NAME_INPUT_BAD_NAME) ? STR_NAME_ERROR_NAME : STR_NAME_ERROR_SELECTION; + TranslateId pId = (eType == SC_NAME_INPUT_BAD_NAME) ? STR_NAME_ERROR_NAME : STR_NAME_ERROR_SELECTION; pViewSh->ErrorMessage(pId); } else if ( eType == SC_NAME_INPUT_DEFINE ) diff --git a/sc/source/ui/app/scdll.cxx b/sc/source/ui/app/scdll.cxx index 2dbebc32f675..b7f58002f71b 100644 --- a/sc/source/ui/app/scdll.cxx +++ b/sc/source/ui/app/scdll.cxx @@ -86,14 +86,14 @@ #include <filter.hxx> #include <scabstdlg.hxx> -OUString ScResId(std::string_view aId) +OUString ScResId(TranslateId aId) { return Translate::get(aId, SC_MOD()->GetResLocale()); } -OUString ScResId(std::string_view aId, int nCardinality) +OUString ScResId(TranslateNId aContextSingularPlural, int nCardinality) { - return Translate::nget(aId, nCardinality, SC_MOD()->GetResLocale()); + return Translate::nget(aContextSingularPlural, nCardinality, SC_MOD()->GetResLocale()); } void ScDLL::Init() diff --git a/sc/source/ui/condformat/condformathelper.cxx b/sc/source/ui/condformat/condformathelper.cxx index b595b6f8d157..00509b7e2559 100644 --- a/sc/source/ui/condformat/condformathelper.cxx +++ b/sc/source/ui/condformat/condformathelper.cxx @@ -103,7 +103,7 @@ OUString getExpression(sal_Int32 nIndex) OUString getDateString(sal_Int32 nIndex) { - const char* aCondStrs[] = + const TranslateId aCondStrs[] = { STR_COND_TODAY, STR_COND_YESTERDAY, diff --git a/sc/source/ui/dbgui/PivotLayoutDialog.cxx b/sc/source/ui/dbgui/PivotLayoutDialog.cxx index 39357771105d..05a9428eda5e 100644 --- a/sc/source/ui/dbgui/PivotLayoutDialog.cxx +++ b/sc/source/ui/dbgui/PivotLayoutDialog.cxx @@ -441,7 +441,7 @@ void ScPivotLayoutDialog::UpdateSourceRange() return; aSourceSheet.SetSourceRange(aSourceRange); - if (aSourceSheet.CheckSourceRange() != nullptr) + if (aSourceSheet.CheckSourceRange()) { mxSourceEdit->SetRefValid(false); return; diff --git a/sc/source/ui/dbgui/PivotLayoutTreeListData.cxx b/sc/source/ui/dbgui/PivotLayoutTreeListData.cxx index 0e5b5bfd4021..a894a03d14c4 100644 --- a/sc/source/ui/dbgui/PivotLayoutTreeListData.cxx +++ b/sc/source/ui/dbgui/PivotLayoutTreeListData.cxx @@ -25,7 +25,7 @@ namespace OUString lclGetFunctionMaskName(const PivotFunc nFunctionMask) { - const char* pStrId = nullptr; + TranslateId pStrId; switch (nFunctionMask) { case PivotFunc::Sum: pStrId = STR_FUN_TEXT_SUM; break; diff --git a/sc/source/ui/dbgui/consdlg.cxx b/sc/source/ui/dbgui/consdlg.cxx index 3c63a9f14692..a4d02ac792b4 100644 --- a/sc/source/ui/dbgui/consdlg.cxx +++ b/sc/source/ui/dbgui/consdlg.cxx @@ -38,7 +38,7 @@ namespace { - void INFOBOX(weld::Window* pWindow, const char* id) + void INFOBOX(weld::Window* pWindow, TranslateId id) { std::unique_ptr<weld::MessageDialog> xInfoBox(Application::CreateMessageDialog(pWindow, VclMessageType::Info, VclButtonsType::Ok, diff --git a/sc/source/ui/dbgui/dpgroupdlg.cxx b/sc/source/ui/dbgui/dpgroupdlg.cxx index 4846a9c48aed..550695cc3199 100644 --- a/sc/source/ui/dbgui/dpgroupdlg.cxx +++ b/sc/source/ui/dbgui/dpgroupdlg.cxx @@ -43,7 +43,7 @@ const sal_Int32 spnDateParts[] = css::sheet::DataPilotFieldGroupBy::YEARS }; -const char* aDatePartResIds[] = +const TranslateId aDatePartResIds[] = { STR_DPFIELD_GROUP_BY_SECONDS, STR_DPFIELD_GROUP_BY_MINUTES, diff --git a/sc/source/ui/dbgui/sfiltdlg.cxx b/sc/source/ui/dbgui/sfiltdlg.cxx index 4f47e4e940a1..030741e3e2bc 100644 --- a/sc/source/ui/dbgui/sfiltdlg.cxx +++ b/sc/source/ui/dbgui/sfiltdlg.cxx @@ -40,7 +40,7 @@ namespace { - void ERRORBOX(weld::Window* pParent, const char* rid) + void ERRORBOX(weld::Window* pParent, TranslateId rid) { std::unique_ptr<weld::MessageDialog> xBox(Application::CreateMessageDialog(pParent, VclMessageType::Warning, VclButtonsType::Ok, diff --git a/sc/source/ui/docshell/dbdocfun.cxx b/sc/source/ui/docshell/dbdocfun.cxx index 6c374e1b09a3..b53d5842446c 100644 --- a/sc/source/ui/docshell/dbdocfun.cxx +++ b/sc/source/ui/docshell/dbdocfun.cxx @@ -1640,7 +1640,7 @@ void ScDBDocFunc::RefreshPivotTables(const ScDPObject* pDPObj, bool bApi) return; o3tl::sorted_vector<ScDPObject*> aRefs; - const char* pErrId = pDPs->ReloadCache(pDPObj, aRefs); + TranslateId pErrId = pDPs->ReloadCache(pDPObj, aRefs); if (pErrId) return; diff --git a/sc/source/ui/docshell/dbdocimp.cxx b/sc/source/ui/docshell/dbdocimp.cxx index 2d8f7dce8ddb..42b20f3d2cb5 100644 --- a/sc/source/ui/docshell/dbdocimp.cxx +++ b/sc/source/ui/docshell/dbdocimp.cxx @@ -142,7 +142,7 @@ bool ScDBDocFunc::DoImport( SCTAB nTab, const ScImportParam& rParam, bool bSuccess = false; bool bTruncated = false; // for warning - const char* pErrStringId = nullptr; + TranslateId pErrStringId; OUString aErrorMessage; SCCOL nCol = rParam.nCol1; diff --git a/sc/source/ui/docshell/docfunc.cxx b/sc/source/ui/docshell/docfunc.cxx index 2133ee93bd6e..ac011281dd36 100644 --- a/sc/source/ui/docshell/docfunc.cxx +++ b/sc/source/ui/docshell/docfunc.cxx @@ -5751,7 +5751,7 @@ void ScDocFunc::ConvertFormulaToValue( const ScRange& rRange, bool bInteraction aModificator.SetDocumentModified(); } -void ScDocFunc::EnterListAction(const char* pNameResId) +void ScDocFunc::EnterListAction(TranslateId pNameResId) { OUString aUndo(ScResId(pNameResId)); ViewShellId nViewShellId(-1); diff --git a/sc/source/ui/docshell/docsh5.cxx b/sc/source/ui/docshell/docsh5.cxx index 08ac3b5f0fe0..3afc8c5b4fa5 100644 --- a/sc/source/ui/docshell/docsh5.cxx +++ b/sc/source/ui/docshell/docsh5.cxx @@ -67,7 +67,7 @@ using ::std::vector; // former viewfunc/dbfunc methods -void ScDocShell::ErrorMessage(const char* pGlobStrId) +void ScDocShell::ErrorMessage(TranslateId pGlobStrId) { //! StopMarking at the (active) view? @@ -75,7 +75,7 @@ void ScDocShell::ErrorMessage(const char* pGlobStrId) weld::WaitObject aWaitOff( pParent ); bool bFocus = pParent && pParent->has_focus(); - if (pGlobStrId && strcmp(pGlobStrId, STR_PROTECTIONERR) == 0) + if (pGlobStrId && pGlobStrId == STR_PROTECTIONERR) { if (IsReadOnly()) { diff --git a/sc/source/ui/docshell/editable.cxx b/sc/source/ui/docshell/editable.cxx index 1de616790124..86bbb9f2e004 100644 --- a/sc/source/ui/docshell/editable.cxx +++ b/sc/source/ui/docshell/editable.cxx @@ -149,10 +149,10 @@ void ScEditableTester::TestBlockForAction( } } -const char* ScEditableTester::GetMessageId() const +TranslateId ScEditableTester::GetMessageId() const { if (mbIsEditable) - return nullptr; + return {}; else if (mbOnlyMatrix) return STR_MATRIXFRAGMENTERR; else diff --git a/sc/source/ui/drawfunc/fuconrec.cxx b/sc/source/ui/drawfunc/fuconrec.cxx index 6e9056027009..c112617652b4 100644 --- a/sc/source/ui/drawfunc/fuconrec.cxx +++ b/sc/source/ui/drawfunc/fuconrec.cxx @@ -56,7 +56,7 @@ FuConstRectangle::~FuConstRectangle() namespace { -::basegfx::B2DPolyPolygon getPolygon(const char* pResId, const SdrModel& rModel) +::basegfx::B2DPolyPolygon getPolygon(TranslateId pResId, const SdrModel& rModel) { ::basegfx::B2DPolyPolygon aRetval; XLineEndListRef pLineEndList(rModel.GetLineEndList()); diff --git a/sc/source/ui/inc/AnalysisOfVarianceDialog.hxx b/sc/source/ui/inc/AnalysisOfVarianceDialog.hxx index 675cc422e1e6..35c53e72778f 100644 --- a/sc/source/ui/inc/AnalysisOfVarianceDialog.hxx +++ b/sc/source/ui/inc/AnalysisOfVarianceDialog.hxx @@ -54,7 +54,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/ChiSquareTestDialog.hxx b/sc/source/ui/inc/ChiSquareTestDialog.hxx index 584035c8e83c..20e7d696c95f 100644 --- a/sc/source/ui/inc/ChiSquareTestDialog.hxx +++ b/sc/source/ui/inc/ChiSquareTestDialog.hxx @@ -24,7 +24,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/CovarianceDialog.hxx b/sc/source/ui/inc/CovarianceDialog.hxx index ae30b34e086b..181bebeac154 100644 --- a/sc/source/ui/inc/CovarianceDialog.hxx +++ b/sc/source/ui/inc/CovarianceDialog.hxx @@ -24,7 +24,7 @@ public: protected: virtual OUString getLabel() override; virtual OUString getTemplate() override; - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; }; /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/sc/source/ui/inc/DescriptiveStatisticsDialog.hxx b/sc/source/ui/inc/DescriptiveStatisticsDialog.hxx index 9edd1329021e..dd2488450beb 100644 --- a/sc/source/ui/inc/DescriptiveStatisticsDialog.hxx +++ b/sc/source/ui/inc/DescriptiveStatisticsDialog.hxx @@ -24,7 +24,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/ExponentialSmoothingDialog.hxx b/sc/source/ui/inc/ExponentialSmoothingDialog.hxx index 0d425fdbc0a2..54b877167805 100644 --- a/sc/source/ui/inc/ExponentialSmoothingDialog.hxx +++ b/sc/source/ui/inc/ExponentialSmoothingDialog.hxx @@ -30,7 +30,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/FTestDialog.hxx b/sc/source/ui/inc/FTestDialog.hxx index f1a0467b24d0..efd477ce08bb 100644 --- a/sc/source/ui/inc/FTestDialog.hxx +++ b/sc/source/ui/inc/FTestDialog.hxx @@ -24,7 +24,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/FourierAnalysisDialog.hxx b/sc/source/ui/inc/FourierAnalysisDialog.hxx index ab9507e31c49..f839b274e4d8 100644 --- a/sc/source/ui/inc/FourierAnalysisDialog.hxx +++ b/sc/source/ui/inc/FourierAnalysisDialog.hxx @@ -41,7 +41,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; virtual bool InputRangesValid() override; diff --git a/sc/source/ui/inc/MatrixComparisonGenerator.hxx b/sc/source/ui/inc/MatrixComparisonGenerator.hxx index e68d60772035..058b9611a758 100644 --- a/sc/source/ui/inc/MatrixComparisonGenerator.hxx +++ b/sc/source/ui/inc/MatrixComparisonGenerator.hxx @@ -26,7 +26,7 @@ public: virtual ~ScMatrixComparisonGenerator() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; virtual OUString getLabel() = 0; diff --git a/sc/source/ui/inc/MovingAverageDialog.hxx b/sc/source/ui/inc/MovingAverageDialog.hxx index fe03e2631d08..216b67c8b400 100644 --- a/sc/source/ui/inc/MovingAverageDialog.hxx +++ b/sc/source/ui/inc/MovingAverageDialog.hxx @@ -31,7 +31,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/RandomNumberGeneratorDialog.hxx b/sc/source/ui/inc/RandomNumberGeneratorDialog.hxx index 40a457732909..0f890fc79936 100644 --- a/sc/source/ui/inc/RandomNumberGeneratorDialog.hxx +++ b/sc/source/ui/inc/RandomNumberGeneratorDialog.hxx @@ -62,7 +62,7 @@ private: template<class RNG> - void GenerateNumbers(RNG& randomGenerator, const char* pDistributionStringId, const std::optional<sal_Int8> aDecimalPlaces); + void GenerateNumbers(RNG& randomGenerator, TranslateId pDistributionStringId, const std::optional<sal_Int8> aDecimalPlaces); void SelectGeneratorAndGenerateNumbers(); diff --git a/sc/source/ui/inc/RegressionDialog.hxx b/sc/source/ui/inc/RegressionDialog.hxx index cab704d96384..59accf265c3b 100644 --- a/sc/source/ui/inc/RegressionDialog.hxx +++ b/sc/source/ui/inc/RegressionDialog.hxx @@ -40,7 +40,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; virtual bool InputRangesValid() override; diff --git a/sc/source/ui/inc/StatisticsInputOutputDialog.hxx b/sc/source/ui/inc/StatisticsInputOutputDialog.hxx index 6f35e75472ea..2de05951b3ab 100644 --- a/sc/source/ui/inc/StatisticsInputOutputDialog.hxx +++ b/sc/source/ui/inc/StatisticsInputOutputDialog.hxx @@ -37,7 +37,7 @@ protected: void CalculateInputAndWriteToOutput(); virtual ScRange ApplyOutput(ScDocShell* pDocShell) = 0; - virtual const char* GetUndoNameId() = 0; + virtual TranslateId GetUndoNameId() = 0; virtual bool InputRangesValid(); void ValidateDialogInput(); diff --git a/sc/source/ui/inc/StatisticsTwoVariableDialog.hxx b/sc/source/ui/inc/StatisticsTwoVariableDialog.hxx index 8ac10b3c42df..3b1d5e46781f 100644 --- a/sc/source/ui/inc/StatisticsTwoVariableDialog.hxx +++ b/sc/source/ui/inc/StatisticsTwoVariableDialog.hxx @@ -36,7 +36,7 @@ protected: void CalculateInputAndWriteToOutput(); virtual ScRange ApplyOutput(ScDocShell* pDocShell) = 0; - virtual const char* GetUndoNameId() = 0; + virtual TranslateId GetUndoNameId() = 0; virtual bool InputRangesValid(); void ValidateDialogInput(); diff --git a/sc/source/ui/inc/TTestDialog.hxx b/sc/source/ui/inc/TTestDialog.hxx index 1cfa7475c2d1..0ed370dce2d4 100644 --- a/sc/source/ui/inc/TTestDialog.hxx +++ b/sc/source/ui/inc/TTestDialog.hxx @@ -24,7 +24,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/ZTestDialog.hxx b/sc/source/ui/inc/ZTestDialog.hxx index c9b62603ca48..2476c38f32a7 100644 --- a/sc/source/ui/inc/ZTestDialog.hxx +++ b/sc/source/ui/inc/ZTestDialog.hxx @@ -24,7 +24,7 @@ public: virtual void Close() override; protected: - virtual const char* GetUndoNameId() override; + virtual TranslateId GetUndoNameId() override; virtual ScRange ApplyOutput(ScDocShell* pDocShell) override; }; diff --git a/sc/source/ui/inc/docfunc.hxx b/sc/source/ui/inc/docfunc.hxx index 43839eb94d21..4a8cad6dc9d6 100644 --- a/sc/source/ui/inc/docfunc.hxx +++ b/sc/source/ui/inc/docfunc.hxx @@ -23,6 +23,7 @@ #include <global.hxx> #include <formula/grammar.hxx> #include <tabbgcolor.hxx> +#include <unotools/resmgr.hxx> #include <memory> #include <vector> @@ -73,7 +74,7 @@ public: void NotifyDrawUndo(std::unique_ptr<SdrUndoAction>); // for grouping multiple operations into one with a new name - void EnterListAction(const char* pNameResId); + void EnterListAction(TranslateId pNameResId); void EndListAction(); bool DetectiveAddPred(const ScAddress& rPos); diff --git a/sc/source/ui/inc/docsh.hxx b/sc/source/ui/inc/docsh.hxx index 57f172ef2b5e..83cd3a20857e 100644 --- a/sc/source/ui/inc/docsh.hxx +++ b/sc/source/ui/inc/docsh.hxx @@ -259,7 +259,7 @@ public: void DoAutoStyle( const ScRange& rRange, const OUString& rStyle ); static weld::Window* GetActiveDialogParent(); - void ErrorMessage(const char* pGlobStrId); + void ErrorMessage(TranslateId pGlobStrId); bool IsEditable() const; bool AdjustRowHeight( SCROW nStartRow, SCROW nEndRow, SCTAB nTab ); diff --git a/sc/source/ui/inc/editable.hxx b/sc/source/ui/inc/editable.hxx index e03a1235743a..1c229a1b11ef 100644 --- a/sc/source/ui/inc/editable.hxx +++ b/sc/source/ui/inc/editable.hxx @@ -20,6 +20,7 @@ #pragma once #include <address.hxx> +#include <unotools/resmgr.hxx> class ScDocument; class ScViewFunc; @@ -82,7 +83,7 @@ public: bool IsEditable() const { return mbIsEditable; } bool IsFormatEditable() const { return mbIsEditable || mbOnlyMatrix; } - const char* GetMessageId() const; + TranslateId GetMessageId() const; }; /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/sc/source/ui/inc/tabview.hxx b/sc/source/ui/inc/tabview.hxx index 93cedfee36ec..0bdc143d3e62 100644 --- a/sc/source/ui/inc/tabview.hxx +++ b/sc/source/ui/inc/tabview.hxx @@ -576,7 +576,7 @@ public: void SplitAtPixel( const Point& rPixel ); void InvalidateSplit(); - void ErrorMessage(const char* pGlobStrId); + void ErrorMessage(TranslateId pGlobStrId); void EnableRefInput(bool bFlag); diff --git a/sc/source/ui/navipi/content.cxx b/sc/source/ui/navipi/content.cxx index d477fef62439..a5d464821f12 100644 --- a/sc/source/ui/navipi/content.cxx +++ b/sc/source/ui/navipi/content.cxx @@ -163,7 +163,7 @@ ScContentTree::~ScContentTree() } } -static const char* SCSTR_CONTENT_ARY[] = +const TranslateId SCSTR_CONTENT_ARY[] = { SCSTR_CONTENT_ROOT, SCSTR_CONTENT_TABLE, diff --git a/sc/source/ui/pagedlg/areasdlg.cxx b/sc/source/ui/pagedlg/areasdlg.cxx index e90f32408fcd..2c52fcdd868d 100644 --- a/sc/source/ui/pagedlg/areasdlg.cxx +++ b/sc/source/ui/pagedlg/areasdlg.cxx @@ -51,7 +51,7 @@ enum { namespace { - void ERRORBOX(weld::Window* pParent, const char* rId) + void ERRORBOX(weld::Window* pParent, TranslateId rId) { std::unique_ptr<weld::MessageDialog> xBox(Application::CreateMessageDialog(pParent, VclMessageType::Warning, VclButtonsType::Ok, diff --git a/sc/source/ui/undo/undoblk.cxx b/sc/source/ui/undo/undoblk.cxx index 6706b19adc0b..438cacb4884d 100644 --- a/sc/source/ui/undo/undoblk.cxx +++ b/sc/source/ui/undo/undoblk.cxx @@ -1986,7 +1986,7 @@ ScUndoIndent::~ScUndoIndent() OUString ScUndoIndent::GetComment() const { - const char* pId = bIsIncrement ? STR_UNDO_INC_INDENT : STR_UNDO_DEC_INDENT; + TranslateId pId = bIsIncrement ? STR_UNDO_INC_INDENT : STR_UNDO_DEC_INDENT; return ScResId(pId); } diff --git a/sc/source/ui/undo/undocell.cxx b/sc/source/ui/undo/undocell.cxx index 583e2dd4e832..8323cd824612 100644 --- a/sc/source/ui/undo/undocell.cxx +++ b/sc/source/ui/undo/undocell.cxx @@ -893,7 +893,7 @@ ScUndoDetective::~ScUndoDetective() OUString ScUndoDetective::GetComment() const { - const char* pId = STR_UNDO_DETDELALL; + TranslateId pId = STR_UNDO_DETDELALL; if ( !bIsDelete ) switch ( static_cast<ScDetOpType>(nAction) ) { diff --git a/sc/source/ui/undo/undodat.cxx b/sc/source/ui/undo/undodat.cxx index cd92934d1b6c..5f6578f71ff1 100644 --- a/sc/source/ui/undo/undodat.cxx +++ b/sc/source/ui/undo/undodat.cxx @@ -1419,7 +1419,7 @@ ScUndoDataPilot::ScUndoDataPilot( ScDocShell* pNewDocShell, OUString ScUndoDataPilot::GetComment() const { - const char* pResId; + TranslateId pResId; if (xOldUndoDoc && xNewUndoDoc) pResId = STR_UNDO_PIVOT_MODIFY; else if (xNewUndoDoc) diff --git a/sc/source/ui/undo/undostyl.cxx b/sc/source/ui/undo/undostyl.cxx index 9596edb07a01..f110d0190051 100644 --- a/sc/source/ui/undo/undostyl.cxx +++ b/sc/source/ui/undo/undostyl.cxx @@ -83,7 +83,7 @@ ScUndoModifyStyle::~ScUndoModifyStyle() OUString ScUndoModifyStyle::GetComment() const { - const char* pId = (eFamily == SfxStyleFamily::Para) ? + TranslateId pId = (eFamily == SfxStyleFamily::Para) ? STR_UNDO_EDITCELLSTYLE : STR_UNDO_EDITPAGESTYLE; return ScResId(pId); diff --git a/sc/source/ui/undo/undotab.cxx b/sc/source/ui/undo/undotab.cxx index e0def882cea6..28f8188b34b0 100644 --- a/sc/source/ui/undo/undotab.cxx +++ b/sc/source/ui/undo/undotab.cxx @@ -1138,7 +1138,7 @@ bool ScUndoShowHideTab::CanRepeat(SfxRepeatTarget& rTarget) const OUString ScUndoShowHideTab::GetComment() const { - const char* pId; + TranslateId pId; if (undoTabs.size() > 1) { pId = bShow ? STR_UNDO_SHOWTABS : STR_UNDO_HIDETABS; @@ -1214,7 +1214,7 @@ bool ScUndoDocProtect::CanRepeat(SfxRepeatTarget& /* rTarget */) const OUString ScUndoDocProtect::GetComment() const { - const char* pId = mpProtectSettings->isProtected() ? STR_UNDO_PROTECT_DOC : STR_UNDO_UNPROTECT_DOC; + TranslateId pId = mpProtectSettings->isProtected() ? STR_UNDO_PROTECT_DOC : STR_UNDO_UNPROTECT_DOC; return ScResId(pId); } @@ -1284,7 +1284,7 @@ bool ScUndoTabProtect::CanRepeat(SfxRepeatTarget& /* rTarget */) const OUString ScUndoTabProtect::GetComment() const { - const char* pId = mpProtectSettings->isProtected() ? STR_UNDO_PROTECT_TAB : STR_UNDO_UNPROTECT_TAB; + TranslateId pId = mpProtectSettings->isProtected() ? STR_UNDO_PROTECT_TAB : STR_UNDO_UNPROTECT_TAB; return ScResId(pId); } diff --git a/sc/source/ui/unoobj/styleuno.cxx b/sc/source/ui/unoobj/styleuno.cxx index dfbee4752ae7..98568aa82994 100644 --- a/sc/source/ui/unoobj/styleuno.cxx +++ b/sc/source/ui/unoobj/styleuno.cxx @@ -894,7 +894,7 @@ uno::Any SAL_CALL ScStyleFamilyObj::getPropertyValue( const OUString& sPropertyN } SolarMutexGuard aGuard; - const char* pResId = nullptr; + TranslateId pResId; switch ( eFamily ) { case SfxStyleFamily::Para: diff --git a/sc/source/ui/unoobj/targuno.cxx b/sc/source/ui/unoobj/targuno.cxx index 35e695451ce1..b7ecd021f369 100644 --- a/sc/source/ui/unoobj/targuno.cxx +++ b/sc/source/ui/unoobj/targuno.cxx @@ -43,7 +43,7 @@ using namespace ::com::sun::star; -static const char* aTypeResIds[SC_LINKTARGETTYPE_COUNT] = +const TranslateId aTypeResIds[SC_LINKTARGETTYPE_COUNT] = { SCSTR_CONTENT_TABLE, // SC_LINKTARGETTYPE_SHEET SCSTR_CONTENT_RANGENAME, // SC_LINKTARGETTYPE_RANGENAME diff --git a/sc/source/ui/view/cellsh1.cxx b/sc/source/ui/view/cellsh1.cxx index fa0b55d75e66..972fe5675f54 100644 --- a/sc/source/ui/view/cellsh1.cxx +++ b/sc/source/ui/view/cellsh1.cxx @@ -3016,7 +3016,7 @@ void RunPivotLayoutDialog(ScModule* pScMod, void SetupRangeForPivotTableDialog(const ScRange& rRange, ScAddress& rDestPos, ScDocument* pDoc, - const char* pSrcErrorId, + TranslateId pSrcErrorId, std::unique_ptr<ScDPObject>& pNewDPObject) { ScSheetSourceDesc aShtDesc(pDoc); @@ -3035,7 +3035,7 @@ void SetupRangeForPivotTableDialog(const ScRange& rRange, rRange.aStart.Tab() ); } -void ErrorOrRunPivotLayoutDialog(const char* pSrcErrorId, +void ErrorOrRunPivotLayoutDialog(TranslateId pSrcErrorId, ScAddress& rDestPos, ScModule* pScMod, ScTabViewShell* pTabViewShell, @@ -3171,7 +3171,7 @@ void ScCellShell::ExecuteDataPilotDialog() } else { - const char* pSrcErrorId = nullptr; + TranslateId pSrcErrorId; if (pTypeDlg->IsNamedRange()) { diff --git a/sc/source/ui/view/dbfunc3.cxx b/sc/source/ui/view/dbfunc3.cxx index 8258b52d6846..31a922ff0613 100644 --- a/sc/source/ui/view/dbfunc3.cxx +++ b/sc/source/ui/view/dbfunc3.cxx @@ -1395,7 +1395,7 @@ void ScDBFunc::DataPilotInput( const ScAddress& rPos, const OUString& rString ) return; } - const char* pErrorId = nullptr; + TranslateId pErrorId; pDPObj->BuildAllDimensionMembers(); ScDPSaveData aData( *pDPObj->GetSaveData() ); diff --git a/sc/source/ui/view/tabview2.cxx b/sc/source/ui/view/tabview2.cxx index 0ec66ee6eb3c..ecfcd036c750 100644 --- a/sc/source/ui/view/tabview2.cxx +++ b/sc/source/ui/view/tabview2.cxx @@ -1410,7 +1410,7 @@ void ScTabView::MakeDrawLayer() } } -void ScTabView::ErrorMessage(const char* pGlobStrId) +void ScTabView::ErrorMessage(TranslateId pGlobStrId) { if ( SC_MOD()->IsInExecuteDrop() ) { @@ -1424,7 +1424,7 @@ void ScTabView::ErrorMessage(const char* pGlobStrId) weld::WaitObject aWaitOff( pParent ); bool bFocus = pParent && pParent->has_focus(); - if (pGlobStrId && strcmp(pGlobStrId, STR_PROTECTIONERR) == 0) + if (pGlobStrId && pGlobStrId == STR_PROTECTIONERR) { if (aViewData.GetDocShell()->IsReadOnly()) { diff --git a/sc/source/ui/view/tabvwsha.cxx b/sc/source/ui/view/tabvwsha.cxx index 07c915ad7b7f..a3f06eb69e63 100644 --- a/sc/source/ui/view/tabvwsha.cxx +++ b/sc/source/ui/view/tabvwsha.cxx @@ -86,7 +86,7 @@ bool ScTabViewShell::GetFunction( OUString& rFuncStr, FormulaError nErrCode ) return true; } - const char* pGlobStrId = nullptr; + TranslateId pGlobStrId; switch (eFunc) { case SUBTOTAL_FUNC_AVE: pGlobStrId = STR_FUN_TEXT_AVG; break; diff --git a/sc/source/ui/view/viewfunc.cxx b/sc/source/ui/view/viewfunc.cxx index 4e5e149c9755..31e36774d187 100644 --- a/sc/source/ui/view/viewfunc.cxx +++ b/sc/source/ui/view/viewfunc.cxx @@ -1773,7 +1773,7 @@ void ScViewFunc::DeleteMulti( bool bRows ) // test if allowed - const char* pErrorId = nullptr; + TranslateId pErrorId; bool bNeedRefresh = false; for (size_t i = 0, n = aSpans.size(); i < n && !pErrorId; ++i) { |