Quelle scfuncs.hrc
Sprache: unbekannt
|
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#pragma once
#include <unotools/resmgr.hxx>
#define NC_(Context, String) TranslateId(Context, u8##String)
/* Resource file for the function wizard / autopilot.
*
* For every function there is a StringArray with a resource id (offset by
* RID_SC_FUNC_DESCRIPTIONS_START) with the OpCode of the function
*
* In this stringarray, the description of the function is given as the first
* entry, followed by two entries for each parameter, first the type or name
* of the parameter, second a description of the parameter.
*/
// -=*# Resource for function DCOUNT #*=-
const TranslateId SC_OPCODE_DB_COUNT_ARY[] =
{
NC_("SC_OPCODE_DB_COUNT", "Counts the cells of a data range whose contents match the search c riteria."),
NC_("SC_OPCODE_DB_COUNT", "Database"),
NC_("SC_OPCODE_DB_COUNT", "The range of cells containing data."),
NC_("SC_OPCODE_DB_COUNT", "Database field"),
NC_("SC_OPCODE_DB_COUNT", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_COUNT", "Search criteria"),
NC_("SC_OPCODE_DB_COUNT", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DCOUNTA #*=-
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"),
NC_("SC_OPCODE_DB_COUNT_2", "The range of cells containing data."),
NC_("SC_OPCODE_DB_COUNT_2", "Database field"),
NC_("SC_OPCODE_DB_COUNT_2", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_COUNT_2", "Search criteria"),
NC_("SC_OPCODE_DB_COUNT_2", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DAVERAGE #*=-
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"),
NC_("SC_OPCODE_DB_AVERAGE", "The range of cells containing data."),
NC_("SC_OPCODE_DB_AVERAGE", "Database field"),
NC_("SC_OPCODE_DB_AVERAGE", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_AVERAGE", "Search criteria"),
NC_("SC_OPCODE_DB_AVERAGE", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DGET #*=-
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"),
NC_("SC_OPCODE_DB_GET", "The range of cells containing data."),
NC_("SC_OPCODE_DB_GET", "Database field"),
NC_("SC_OPCODE_DB_GET", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_GET", "Search criteria"),
NC_("SC_OPCODE_DB_GET", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DMAX #*=-
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"),
NC_("SC_OPCODE_DB_MAX", "The range of cells containing data."),
NC_("SC_OPCODE_DB_MAX", "Database field"),
NC_("SC_OPCODE_DB_MAX", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_MAX", "Search criteria"),
NC_("SC_OPCODE_DB_MAX", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DMIN #*=-
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"),
NC_("SC_OPCODE_DB_MIN", "The range of cells containing data."),
NC_("SC_OPCODE_DB_MIN", "Database field"),
NC_("SC_OPCODE_DB_MIN", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_MIN", "Search criteria"),
NC_("SC_OPCODE_DB_MIN", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DPRODUCT #*=-
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"),
NC_("SC_OPCODE_DB_PRODUCT", "The range of cells containing data."),
NC_("SC_OPCODE_DB_PRODUCT", "Database field"),
NC_("SC_OPCODE_DB_PRODUCT", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_PRODUCT", "Search criteria"),
NC_("SC_OPCODE_DB_PRODUCT", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DSTDEV #*=-
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"),
NC_("SC_OPCODE_DB_STD_DEV", "The range of cells containing data."),
NC_("SC_OPCODE_DB_STD_DEV", "Database field"),
NC_("SC_OPCODE_DB_STD_DEV", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_STD_DEV", "Search criteria"),
NC_("SC_OPCODE_DB_STD_DEV", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DSTDEVP #*=-
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"),
NC_("SC_OPCODE_DB_STD_DEV_P", "The range of cells containing data."),
NC_("SC_OPCODE_DB_STD_DEV_P", "Database field"),
NC_("SC_OPCODE_DB_STD_DEV_P", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_STD_DEV_P", "Search criteria"),
NC_("SC_OPCODE_DB_STD_DEV_P", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DSUM #*=-
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"),
NC_("SC_OPCODE_DB_SUM", "The range of cells containing data."),
NC_("SC_OPCODE_DB_SUM", "Database field"),
NC_("SC_OPCODE_DB_SUM", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_SUM", "Search criteria"),
NC_("SC_OPCODE_DB_SUM", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DVAR #*=-
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"),
NC_("SC_OPCODE_DB_VAR", "The range of cells containing data."),
NC_("SC_OPCODE_DB_VAR", "Database field"),
NC_("SC_OPCODE_DB_VAR", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_VAR", "Search criteria"),
NC_("SC_OPCODE_DB_VAR", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DVARP #*=-
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"),
NC_("SC_OPCODE_DB_VAR_P", "The range of cells containing data."),
NC_("SC_OPCODE_DB_VAR_P", "Database field"),
NC_("SC_OPCODE_DB_VAR_P", "Indicates which database field (column) is to be used for the search criteria."),
NC_("SC_OPCODE_DB_VAR_P", "Search criteria"),
NC_("SC_OPCODE_DB_VAR_P", "Defines the cell range containing the search criteria.")
};
// -=*# Resource for function DATE #*=-
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"),
NC_("SC_OPCODE_GET_DATE", "An integer between 1583 and 9956 or 0 and 99 (19xx or 20xx depending on the defined option)."),
NC_("SC_OPCODE_GET_DATE", "Month"),
NC_("SC_OPCODE_GET_DATE", "An integer between 1 and 12 representing the month."),
NC_("SC_OPCODE_GET_DATE", "Day"),
NC_("SC_OPCODE_GET_DATE", "An integer between 1 and 31 representing the day of the month.")
};
// -=*# Resource for function DATE_VALUE #*=-
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"),
NC_("SC_OPCODE_GET_DATE_VALUE", "A text enclosed in quotation marks which returns a date in a %PRODUCTNAME date format.")
};
// -=*# Resource for function DAY #*=-
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"),
NC_("SC_OPCODE_GET_DAY", "The internal number for the date.")
};
// -=*# Resource for function DAYS360 #*=-
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"),
NC_("SC_OPCODE_GET_DIFF_DATE_360", "The start date for calculating the difference in days."),
NC_("SC_OPCODE_GET_DIFF_DATE_360", "Date 2"),
NC_("SC_OPCODE_GET_DIFF_DATE_360", "The end date for calculating the difference in days."),
NC_("SC_OPCODE_GET_DIFF_DATE_360", "Type"),
NC_("SC_OPCODE_GET_DIFF_DATE_360", "Method used to form differences: Type = 0 denotes US method (NASD), Type = 1 denotes the European method.")
};
// -=*# Resource for function NETWORKDAYS #*=-
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"),
NC_("SC_OPCODE_NETWORKDAYS", "Start date for calculation."),
NC_("SC_OPCODE_NETWORKDAYS", "End date"),
NC_("SC_OPCODE_NETWORKDAYS", "End date for calculation."),
NC_("SC_OPCODE_NETWORKDAYS", "List of dates"),
NC_("SC_OPCODE_NETWORKDAYS", "Optional set of one or more dates to be considered as holiday."),
NC_("SC_OPCODE_NETWORKDAYS", "Array"),
NC_("SC_OPCODE_NETWORKDAYS", "Optional list of numbers to indicate working (0) and weekend (non-zero) days. When omitted, weekend is Saturday and Sunday.")
};
// -=*# Resource for function NETWORKDAYS.INTL #*=-
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"),
NC_("SC_OPCODE_NETWORKDAYS_MS", "Start date for calculation."),
NC_("SC_OPCODE_NETWORKDAYS_MS", "End date"),
NC_("SC_OPCODE_NETWORKDAYS_MS", "End date for calculation."),
NC_("SC_OPCODE_NETWORKDAYS_MS", "Number or string"),
NC_("SC_OPCODE_NETWORKDAYS_MS", "Optional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday."),
NC_("SC_OPCODE_NETWORKDAYS_MS", "Array"),
NC_("SC_OPCODE_NETWORKDAYS_MS", "Optional set of one or more dates to be considered as holiday.")
};
// -=*# Resource for function WORKDAY.INTL #*=-
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"),
NC_("SC_OPCODE_WORKDAY_MS", "Start date for calculation."),
NC_("SC_OPCODE_WORKDAY_MS", "Days"),
NC_("SC_OPCODE_WORKDAY_MS", "The number of workdays before or after start date."),
NC_("SC_OPCODE_WORKDAY_MS", "Number or string"),
NC_("SC_OPCODE_WORKDAY_MS", "Optional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday."),
NC_("SC_OPCODE_WORKDAY_MS", "Array"),
NC_("SC_OPCODE_WORKDAY_MS", "Optional set of one or more dates to be considered as holiday.")
};
// -=*# Resource for function HOUR #*=-
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"),
NC_("SC_OPCODE_GET_HOUR", "Internal time value")
};
// -=*# Resource for function MINUTE #*=-
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"),
NC_("SC_OPCODE_GET_MIN", "Internal time value.")
};
// -=*# Resource for function MONTH #*=-
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"),
NC_("SC_OPCODE_GET_MONTH", "The internal number of the date.")
};
// -=*# Resource for function NOW #*=-
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 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"),
NC_("SC_OPCODE_GET_SEC", "The internal time value.")
};
// -=*# Resource for function TIME #*=-
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"),
NC_("SC_OPCODE_GET_TIME", "The integer for the hour."),
NC_("SC_OPCODE_GET_TIME", "Minute"),
NC_("SC_OPCODE_GET_TIME", "The integer for the minute."),
NC_("SC_OPCODE_GET_TIME", "Second"),
NC_("SC_OPCODE_GET_TIME", "The integer for the second.")
};
// -=*# Resource for function TIMEVALUE #*=-
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"),
NC_("SC_OPCODE_GET_TIME_VALUE", "A text enclosed in quotation marks which returns a time in a %PRODUCTNAME time format.")
};
// -=*# Resource for function TODAY #*=-
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 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"),
NC_("SC_OPCODE_GET_DAY_OF_WEEK", "The internal number for the date."),
NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Type"),
NC_("SC_OPCODE_GET_DAY_OF_WEEK", "Fixes the beginning of the week and the type of calculation to be used.")
};
// -=*# Resource for function YEAR #*=-
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"),
NC_("SC_OPCODE_GET_YEAR", "Internal number of the date.")
};
// -=*# Resource for function DAYS #*=-
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"),
NC_("SC_OPCODE_GET_DIFF_DATE", "The end date for calculating the difference in days."),
NC_("SC_OPCODE_GET_DIFF_DATE", "Date 1"),
NC_("SC_OPCODE_GET_DIFF_DATE", "The start date for calculating the difference in days.")
};
// -=*# Resource for function DATEDIF #*=-
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"),
NC_("SC_OPCODE_GET_DATEDIF", "The start date."),
NC_("SC_OPCODE_GET_DATEDIF", "End date"),
NC_("SC_OPCODE_GET_DATEDIF", "The end date."),
NC_("SC_OPCODE_GET_DATEDIF", "Interval"),
NC_("SC_OPCODE_GET_DATEDIF", "Interval to be calculated. Can be \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\".")
};
// -=*# Resource for function WEEKNUM #*=-
const TranslateId SC_OPCODE_WEEK_ARY[] =
{
NC_("SC_OPCODE_WEEK", "Calculates the calendar week corresponding to the given date."),
NC_("SC_OPCODE_WEEK", "Number"),
NC_("SC_OPCODE_WEEK", "The internal number of the date."),
NC_("SC_OPCODE_WEEK", "Mode"),
NC_("SC_OPCODE_WEEK", "Indicates the first day of the week and when week 1 starts.")
};
// -=*# Resource for function ISOWEEKNUM #*=-
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 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"),
NC_("SC_OPCODE_WEEKNUM_OOO", "The internal number of the date."),
NC_("SC_OPCODE_WEEKNUM_OOO", "Mode"),
NC_("SC_OPCODE_WEEKNUM_OOO", "Indicates the first day of the week (1 = Sunday, other values = Monday).")
};
// -=*# Resource for function EASTERSUNDAY #*=-
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"),
NC_("SC_OPCODE_EASTERSUNDAY", "An integer between 1583 and 9956, or 0 and 99 (19xx or 20xx depending on the option set).")
};
// -=*# Resource for function PV #*=-
const TranslateId SC_OPCODE_PV_ARY[] =
{
NC_("SC_OPCODE_PV", "Present value. Calculates the present value of an investment."),
NC_("SC_OPCODE_PV", "Rate"),
NC_("SC_OPCODE_PV", "The rate of interest for the period given."),
NC_("SC_OPCODE_PV", "NPER"),
NC_("SC_OPCODE_PV", "The payment period. The total number of periods in which the annuity is paid."),
NC_("SC_OPCODE_PV", "PMT"),
NC_("SC_OPCODE_PV", "Regular payments. The constant amount of annuity that is paid in each period."),
NC_("SC_OPCODE_PV", "FV"),
NC_("SC_OPCODE_PV", "Future value. The value (final value) to be attained after the last payment."),
NC_("SC_OPCODE_PV", "Type"),
NC_("SC_OPCODE_PV", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function FV #*=-
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"),
NC_("SC_OPCODE_FV", "The rate of interest per period."),
NC_("SC_OPCODE_FV", "NPER"),
NC_("SC_OPCODE_FV", "Payment period. The total number of periods in which the annuity (pension) is paid."),
NC_("SC_OPCODE_FV", "PMT"),
NC_("SC_OPCODE_FV", "Regular payments. The constant annuity to be paid in each period."),
NC_("SC_OPCODE_FV", "PV"),
NC_("SC_OPCODE_FV", "Present value. The current value of a series of payments"),
NC_("SC_OPCODE_FV", "Type"),
NC_("SC_OPCODE_FV", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function NPER #*=-
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"),
NC_("SC_OPCODE_NPER", "The rate of interest per period."),
NC_("SC_OPCODE_NPER", "PMT"),
NC_("SC_OPCODE_NPER", "Regular payments. The constant annuity to be paid in each period."),
NC_("SC_OPCODE_NPER", "PV"),
NC_("SC_OPCODE_NPER", "Present value. The current value of a series of payments"),
NC_("SC_OPCODE_NPER", "FV"),
NC_("SC_OPCODE_NPER", "Future value. The value (end value) to be attained after the final payment."),
NC_("SC_OPCODE_NPER", "Type"),
NC_("SC_OPCODE_NPER", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function PMT #*=-
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"),
NC_("SC_OPCODE_PMT", "The rate of interest per period."),
NC_("SC_OPCODE_PMT", "NPER"),
NC_("SC_OPCODE_PMT", "Payment period. The total number of periods in which the annuity (pension) is paid."),
NC_("SC_OPCODE_PMT", "PV"),
NC_("SC_OPCODE_PMT", "Present value. The current value of a series of payments"),
NC_("SC_OPCODE_PMT", "FV"),
NC_("SC_OPCODE_PMT", "Future value. The value (end value) to be attained after the final payment."),
NC_("SC_OPCODE_PMT", "Type"),
NC_("SC_OPCODE_PMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function RATE #*=-
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"),
NC_("SC_OPCODE_RATE", "Payment period. The total number of periods in which the annuity (pension) is paid."),
NC_("SC_OPCODE_RATE", "PMT"),
NC_("SC_OPCODE_RATE", "Regular payments. The constant annuity to be paid in each period."),
NC_("SC_OPCODE_RATE", "PV"),
NC_("SC_OPCODE_RATE", "Present value. The current value of a series of payments"),
NC_("SC_OPCODE_RATE", "FV"),
NC_("SC_OPCODE_RATE", "Future value. The value (end value) to be attained after the final payment."),
NC_("SC_OPCODE_RATE", "Type"),
NC_("SC_OPCODE_RATE", "Type = 1 denotes due at the beginning of the period, = 0 at the end."),
NC_("SC_OPCODE_RATE", "Guess"),
NC_("SC_OPCODE_RATE", "Guess. The estimate of the interest rate for the iterative calculating method.")
};
// -=*# Resource for function IPMT #*=-
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"),
NC_("SC_OPCODE_IPMT", "The rate of interest per period."),
NC_("SC_OPCODE_IPMT", "Period"),
NC_("SC_OPCODE_IPMT", "Periods. The periods for which the compounded interest is to be calculated. P = 1 denotes for the first period, P = NPER for the last one."),
NC_("SC_OPCODE_IPMT", "NPER"),
NC_("SC_OPCODE_IPMT", "Payment period. The total number of periods in which the annuity (pension) is paid."),
NC_("SC_OPCODE_IPMT", "PV"),
NC_("SC_OPCODE_IPMT", "Present value. The current value of a series of payments"),
NC_("SC_OPCODE_IPMT", "FV"),
NC_("SC_OPCODE_IPMT", "Future value. The value (end value) to be attained after the final payment."),
NC_("SC_OPCODE_IPMT", "Type"),
NC_("SC_OPCODE_IPMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function PPMT #*=-
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"),
NC_("SC_OPCODE_PPMT", "The interest rate per period."),
NC_("SC_OPCODE_PPMT", "Period"),
NC_("SC_OPCODE_PPMT", "Period. The period for which the repayments are to be calculated. Per = 1 denotes for the first period, P = NPER for the last"),
NC_("SC_OPCODE_PPMT", "NPER"),
NC_("SC_OPCODE_PPMT", "The payment period. The total number of periods in which the annuity (pension) is paid."),
NC_("SC_OPCODE_PPMT", "PV"),
NC_("SC_OPCODE_PPMT", "The present value. The present value or the amount the annuity is currently worth."),
NC_("SC_OPCODE_PPMT", "FV"),
NC_("SC_OPCODE_PPMT", "Future value. The value (end value) attained after the last payment has been made."),
NC_("SC_OPCODE_PPMT", "Type"),
NC_("SC_OPCODE_PPMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function CUMPRINC #*=-
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"),
NC_("SC_OPCODE_CUM_PRINC", "The rate of interest per period."),
NC_("SC_OPCODE_CUM_PRINC", "NPER"),
NC_("SC_OPCODE_CUM_PRINC", "Payment period. The total number of periods in which the annuity (pension) is paid."),
NC_("SC_OPCODE_CUM_PRINC", "PV"),
NC_("SC_OPCODE_CUM_PRINC", "The present value. The present value or the amount the annuity is currently worth."),
NC_("SC_OPCODE_CUM_PRINC", "S"),
NC_("SC_OPCODE_CUM_PRINC", "The start period. The first period to be taken into account. S = 1 denotes the very first period."),
NC_("SC_OPCODE_CUM_PRINC", "E"),
NC_("SC_OPCODE_CUM_PRINC", "End period. The last period to be taken into account."),
NC_("SC_OPCODE_CUM_PRINC", "Type"),
NC_("SC_OPCODE_CUM_PRINC", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function CUMIPMT #*=-
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"),
NC_("SC_OPCODE_CUM_IPMT", "The rate of interest per period."),
NC_("SC_OPCODE_CUM_IPMT", "NPER"),
NC_("SC_OPCODE_CUM_IPMT", "Payment period. The total number of periods in which the annuity (pension) is paid."),
NC_("SC_OPCODE_CUM_IPMT", "PV"),
NC_("SC_OPCODE_CUM_IPMT", "The present value. The present value or the amount the annuity is currently worth."),
NC_("SC_OPCODE_CUM_IPMT", "S"),
NC_("SC_OPCODE_CUM_IPMT", "The start period. The first period to be taken into account. S = 1 denotes the very first period."),
NC_("SC_OPCODE_CUM_IPMT", "E"),
NC_("SC_OPCODE_CUM_IPMT", "The end period. The last period to be taken into account."),
NC_("SC_OPCODE_CUM_IPMT", "Type"),
NC_("SC_OPCODE_CUM_IPMT", "Type = 1 denotes due at the beginning of the period, = 0 at the end.")
};
// -=*# Resource for function SYD #*=-
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"),
NC_("SC_OPCODE_SYD", "Acquisition costs. The initial cost of the asset."),
NC_("SC_OPCODE_SYD", "Salvage"),
NC_("SC_OPCODE_SYD", "Salvage: The remaining value of the asset at the end of its life."),
NC_("SC_OPCODE_SYD", "Life"),
NC_("SC_OPCODE_SYD", "Useful life. The number of periods in the useful life of the asset."),
NC_("SC_OPCODE_SYD", "Period"),
NC_("SC_OPCODE_SYD", "Period. The depreciation period which must have the same time unit as average useful life.")
};
// -=*# Resource for function SLN #*=-
const TranslateId SC_OPCODE_SLN_ARY[] =
{
NC_("SC_OPCODE_SLN", "Calculates the linear depreciation per period."),
NC_("SC_OPCODE_SLN", "Cost"),
NC_("SC_OPCODE_SLN", "Acquisition cost. The initial cost of an asset."),
NC_("SC_OPCODE_SLN", "Salvage"),
NC_("SC_OPCODE_SLN", "Salvage: The remaining value of the asset at the end of its life."),
NC_("SC_OPCODE_SLN", "Life"),
NC_("SC_OPCODE_SLN", "Useful life. The number of periods in the useful life of the asset.")
};
// -=*# Resource for function DDB #*=-
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"),
NC_("SC_OPCODE_DDB", "Acquisition costs. The initial cost of the asset."),
NC_("SC_OPCODE_DDB", "Salvage"),
NC_("SC_OPCODE_DDB", "Salvage: The remaining value of the asset at the end of its life."),
NC_("SC_OPCODE_DDB", "Life"),
NC_("SC_OPCODE_DDB", "Useful life. The number of periods in the useful life of the asset."),
NC_("SC_OPCODE_DDB", "Period"),
NC_("SC_OPCODE_DDB", "Period. The depreciation period in the same time unit as the average useful life entry."),
NC_("SC_OPCODE_DDB", "Factor"),
NC_("SC_OPCODE_DDB", "Factor. The factor for balance decline. F = 2 means a double declining balance factor")
};
// -=*# Resource for function DB #*=-
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"),
NC_("SC_OPCODE_DB", "Acquisition costs: The initial cost of the asset."),
NC_("SC_OPCODE_DB", "Salvage"),
NC_("SC_OPCODE_DB", "Salvage: The remaining value of the asset at the end of its life."),
NC_("SC_OPCODE_DB", "Life"),
NC_("SC_OPCODE_DB", "Useful life. The number of periods in the useful life of the asset."),
NC_("SC_OPCODE_DB", "Period"),
NC_("SC_OPCODE_DB", "Periods: The period for which the depreciation is calculated. The time unit used for period must be the same as that for the useful life."),
NC_("SC_OPCODE_DB", "Month"),
NC_("SC_OPCODE_DB", "Months: The number of months in the first year of depreciation.")
};
// -=*# Resource for function VDB #*=-
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"),
NC_("SC_OPCODE_VBD", "Cost. The initial cost of the asset."),
NC_("SC_OPCODE_VBD", "Salvage"),
NC_("SC_OPCODE_VBD", "Salvage. The salvage value of an asset at the end of its useful life."),
NC_("SC_OPCODE_VBD", "Life"),
NC_("SC_OPCODE_VBD", "Useful life. The number of periods in the useful life of the asset."),
NC_("SC_OPCODE_VBD", "Start"),
NC_("SC_OPCODE_VBD", "Start. The first period for depreciation in the same time unit as the useful life."),
NC_("SC_OPCODE_VBD", "End"),
NC_("SC_OPCODE_VBD", "End. The last period of the depreciation using the same time unit as for the useful life."),
NC_("SC_OPCODE_VBD", "Factor"),
NC_("SC_OPCODE_VBD", "Factor. The factor for the reduction of the depreciation. Factor = 2 denotes double rate depreciation."),
NC_("SC_OPCODE_VBD", "NoSwitch"),
NC_("SC_OPCODE_VBD", "NoSwitch = 0 denotes switch to linear depreciation, NoSwitch = 1 do not switch.")
};
// -=*# Resource for function EFFECT #*=-
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"),
NC_("SC_OPCODE_EFFECT", "Nominal interest"),
NC_("SC_OPCODE_EFFECT", "P"),
NC_("SC_OPCODE_EFFECT", "Periods. The number of interest payments per year.")
};
// -=*# Resource for function NOMINAL #*=-
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"),
NC_("SC_OPCODE_NOMINAL", "The effective interest rate"),
NC_("SC_OPCODE_NOMINAL", "NPER"),
NC_("SC_OPCODE_NOMINAL", "Periods. The number of interest payment per year.")
};
// -=*# Resource for function NPV #*=-
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"),
NC_("SC_OPCODE_NPV", "The rate of discount for one period."),
NC_("SC_OPCODE_NPV", "Value "),
NC_("SC_OPCODE_NPV", "Value 1, value 2,... are arguments representing payments and income.")
};
// -=*# Resource for function IRR #*=-
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"),
NC_("SC_OPCODE_IRR", "An array or reference to cells whose contents correspond to the payments."),
NC_("SC_OPCODE_IRR", "Guess"),
NC_("SC_OPCODE_IRR", "Guess. An estimated value of the rate of return to be used for the iteration calculation.")
};
// -=*# Resource for function MIRR #*=-
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"),
NC_("SC_OPCODE_MIRR", "An array or reference to cells whose contents correspond to the payments."),
NC_("SC_OPCODE_MIRR", "Investment"),
NC_("SC_OPCODE_MIRR", "Interest rate for investments (the negative values in the array)."),
NC_("SC_OPCODE_MIRR", "Reinvest rate"),
NC_("SC_OPCODE_MIRR", "Interest rate for reinvestments (the positive values in the array).")
};
// -=*# Resource for function ISPMT #*=-
const TranslateId SC_OPCODE_ISPMT_ARY[] =
{
NC_("SC_OPCODE_ISPMT", "Returns the amount of interest for constant amortization rates."),
NC_("SC_OPCODE_ISPMT", "Rate"),
NC_("SC_OPCODE_ISPMT", "Interest rate for a single amortization rate."),
NC_("SC_OPCODE_ISPMT", "Period"),
NC_("SC_OPCODE_ISPMT", "Number of amortization periods for the calculation of the interest."),
NC_("SC_OPCODE_ISPMT", "Total periods"),
NC_("SC_OPCODE_ISPMT", "Sum total of amortization periods."),
NC_("SC_OPCODE_ISPMT", "Investment"),
NC_("SC_OPCODE_ISPMT", "Amount of the investment.")
};
// -=*# Resource for function PDURATION #*=-
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"),
NC_("SC_OPCODE_PDURATION", "The constant rate of interest."),
NC_("SC_OPCODE_PDURATION", "PV"),
NC_("SC_OPCODE_PDURATION", "The present value. The current value of the investment."),
NC_("SC_OPCODE_PDURATION", "FV"),
NC_("SC_OPCODE_PDURATION", "The future value of the investment.")
};
// -=*# Resource for function RRI #*=-
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"),
NC_("SC_OPCODE_RRI", "The number of periods used in the calculation."),
NC_("SC_OPCODE_RRI", "PV"),
NC_("SC_OPCODE_RRI", "Present value. The current value of the investment."),
NC_("SC_OPCODE_RRI", "FV"),
NC_("SC_OPCODE_RRI", "The future value of the investment.")
};
// -=*# Resource for function ISREF #*=-
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"),
NC_("SC_OPCODE_IS_REF", "The value to be tested.")
};
// -=*# Resource for function ISERR #*=-
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"),
NC_("SC_OPCODE_IS_ERR", "The value to be tested.")
};
// -=*# Resource for function ISERROR #*=-
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"),
NC_("SC_OPCODE_IS_ERROR", "The value to be tested.")
};
// -=*# Resource for function ISBLANK #*=-
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"),
NC_("SC_OPCODE_IS_EMPTY", "The value to be tested.")
};
// -=*# Resource for function ISLOGICAL #*=-
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"),
NC_("SC_OPCODE_IS_LOGICAL", "The value to be tested.")
};
// -=*# Resource for function ISNA #*=-
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"),
NC_("SC_OPCODE_IS_NV", "The value to be tested.")
};
// -=*# Resource for function ISNONTEXT #*=-
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"),
NC_("SC_OPCODE_IS_NON_STRING", "The value to be tested.")
};
// -=*# Resource for function ISTEXT #*=-
const TranslateId SC_OPCODE_IS_STRING_ARY[] =
{
NC_("SC_OPCODE_IS_STRING", "Returns TRUE if value is text."),
NC_("SC_OPCODE_IS_STRING", "Value"),
NC_("SC_OPCODE_IS_STRING", "The value to be tested.")
};
// -=*# Resource for function ISNUMBER #*=-
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"),
NC_("SC_OPCODE_IS_VALUE", "The value to be tested.")
};
// -=*# Resource for function ISFORMULA #*=-
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"),
NC_("SC_OPCODE_IS_FORMULA", "The cell to be tested.")
};
// -=*# Resource for function FORMULA #*=-
const TranslateId SC_OPCODE_FORMULA_ARY[] =
{
NC_("SC_OPCODE_FORMULA", "Returns the formula of a formula cell."),
NC_("SC_OPCODE_FORMULA", "Reference"),
NC_("SC_OPCODE_FORMULA", "The formula cell.")
};
// -=*# Resource for function N #*=-
const TranslateId SC_OPCODE_N_ARY[] =
{
NC_("SC_OPCODE_N", "Converts a value to a number."),
NC_("SC_OPCODE_N", "Value"),
NC_("SC_OPCODE_N", "The value to be interpreted as a number.")
};
// -=*# Resource for function NA #*=-
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 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"),
NC_("SC_OPCODE_TYPE", "The value for which the data type is to be determined.")
};
// -=*# Resource for function CELL #*=-
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"),
NC_("SC_OPCODE_CELL", "String that specifies the type of information."),
NC_("SC_OPCODE_CELL", "Reference"),
NC_("SC_OPCODE_CELL", "The position of the cell you want to examine.")
};
// -=*# Resource for function CURRENT #*=-
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 TranslateId SC_OPCODE_FALSE_ARY[] =
{
NC_("SC_OPCODE_FALSE", "Defines the logical value as FALSE.")
};
// -=*# Resource for function NOT #*=-
const TranslateId SC_OPCODE_NOT_ARY[] =
{
NC_("SC_OPCODE_NOT", "Reverses the value of the argument."),
NC_("SC_OPCODE_NOT", "Logical value"),
NC_("SC_OPCODE_NOT", "An expression that can be either TRUE or FALSE.")
};
// -=*# Resource for function TRUE #*=-
const TranslateId SC_OPCODE_TRUE_ARY[] =
{
NC_("SC_OPCODE_TRUE", "Returns the logical value TRUE.")
};
// -=*# Resource for function IF #*=-
const TranslateId SC_OPCODE_IF_ARY[] =
{
NC_("SC_OPCODE_IF", "Specifies a logical test to be performed."),
NC_("SC_OPCODE_IF", "Test"),
NC_("SC_OPCODE_IF", "Any value or expression which can be either TRUE or FALSE."),
NC_("SC_OPCODE_IF", "Then value"),
NC_("SC_OPCODE_IF", "The result of the function if the logical test returns a TRUE."),
NC_("SC_OPCODE_IF", "Otherwise value"),
NC_("SC_OPCODE_IF", "The result of the function if the logical test returns FALSE.")
};
// -=*# Resource for function IFERROR #*=-
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"),
NC_("SC_OPCODE_IF_ERROR", "The value to be calculated."),
NC_("SC_OPCODE_IF_ERROR", "Alternative value"),
NC_("SC_OPCODE_IF_ERROR", "The alternative to be returned, should value be an error value.")
};
// -=*# Resource for function IFNA #*=-
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"),
NC_("SC_OPCODE_IF_NA", "The value to be calculated."),
NC_("SC_OPCODE_IF_NA", "Alternative value"),
NC_("SC_OPCODE_IF_NA", "The alternative to be returned, should value be a #N/A error.")
};
// -=*# Resource for function OR #*=-
const TranslateId SC_OPCODE_OR_ARY[] =
{
NC_("SC_OPCODE_OR", "Returns TRUE if an argument is TRUE."),
NC_("SC_OPCODE_OR", "Logical value "),
NC_("SC_OPCODE_OR", "Logical value 1, logical value 2,... are conditions to be tested and which return either TRUE or FALSE.")
};
// -=*# Resource for function XOR #*=-
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 "),
NC_("SC_OPCODE_XOR", "Logical value 1, logical value 2, ... are conditions to be tested and which return either TRUE or FALSE.")
};
// -=*# Resource for function AND #*=-
const TranslateId SC_OPCODE_AND_ARY[] =
{
NC_("SC_OPCODE_AND", "Returns TRUE if all arguments are TRUE."),
NC_("SC_OPCODE_AND", "Logical value "),
NC_("SC_OPCODE_AND", "Logical value 1, logical value 2;...are conditions to be tested and each returns either TRUE or FALSE.")
};
// -=*# Resource for function ABS #*=-
const TranslateId SC_OPCODE_ABS_ARY[] =
{
NC_("SC_OPCODE_ABS", "Absolute value of a number."),
NC_("SC_OPCODE_ABS", "Number"),
NC_("SC_OPCODE_ABS", "The number whose absolute value is to be returned.")
};
// -=*# Resource for function POWER #*=-
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"),
NC_("SC_OPCODE_POWER", "The base a of the power a^b."),
NC_("SC_OPCODE_POWER", "Exponent"),
NC_("SC_OPCODE_POWER", "The exponent b of the power a^b.")
};
// -=*# Resource for function COUNTBLANK #*=-
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"),
NC_("SC_OPCODE_COUNT_EMPTY_CELLS", "The range in which empty cells are to be counted.")
};
// -=*# Resource for function PI #*=-
const TranslateId SC_OPCODE_PI_ARY[] =
{
NC_("SC_OPCODE_PI", "Returns the value of the number Pi.")
};
// -=*# Resource for function SUM #*=-
const TranslateId SC_OPCODE_SUM_ARY[] =
{
NC_("SC_OPCODE_SUM", "Returns the sum of all arguments."),
NC_("SC_OPCODE_SUM", "Number "),
NC_("SC_OPCODE_SUM", "Number 1, number 2, ... are arguments whose total is to be calculated.")
};
// -=*# Resource for function SUMSQ #*=-
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 "),
NC_("SC_OPCODE_SUM_SQ", "Number 1, number 2,... are arguments for which the sum of the squares is to be calculated.")
};
// -=*# Resource for function PRODUCT #*=-
const TranslateId SC_OPCODE_PRODUCT_ARY[] =
{
NC_("SC_OPCODE_PRODUCT", "Multiplies the arguments."),
NC_("SC_OPCODE_PRODUCT", "Number "),
NC_("SC_OPCODE_PRODUCT", "Number 1, number 2, ... are arguments to be multiplied and a result returned.")
};
// -=*# Resource for function SUMIF #*=-
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"),
NC_("SC_OPCODE_SUM_IF", "The range to be evaluated by the criteria given."),
NC_("SC_OPCODE_SUM_IF", "Criteria"),
NC_("SC_OPCODE_SUM_IF", "The criteria to be applied to the range."),
NC_("SC_OPCODE_SUM_IF", "Sum range"),
NC_("SC_OPCODE_SUM_IF", "The range from which the values are to be totalled.")
};
// -=*# Resource for function AVERAGEIF #*=-
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"),
NC_("SC_OPCODE_AVERAGE_IF", "The range to be evaluated by the criteria given."),
NC_("SC_OPCODE_AVERAGE_IF", "Criteria"),
NC_("SC_OPCODE_AVERAGE_IF", "The criteria to be applied to the range."),
NC_("SC_OPCODE_AVERAGE_IF", "Average range"),
NC_("SC_OPCODE_AVERAGE_IF", "The range from which the values are to be averaged.")
};
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"),
NC_("SC_OPCODE_SUM_IFS", "The range from which the values are to be totalled."),
NC_("SC_OPCODE_SUM_IFS", "Range "),
NC_("SC_OPCODE_SUM_IFS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."),
NC_("SC_OPCODE_SUM_IFS", "Criteria "),
NC_("SC_OPCODE_SUM_IFS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.")
};
// -=*# Resource for function AVERAGEIFS #*=-
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"),
NC_("SC_OPCODE_AVERAGE_IFS", "The range from which the values are to be averaged."),
NC_("SC_OPCODE_AVERAGE_IFS", "Range "),
NC_("SC_OPCODE_AVERAGE_IFS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."),
NC_("SC_OPCODE_AVERAGE_IFS", "Criteria "),
NC_("SC_OPCODE_AVERAGE_IFS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.")
};
// -=*# Resource for function COUNTIFS #*=-
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 "),
NC_("SC_OPCODE_COUNT_IFS", "Range 1, range 2,... are the ranges to be evaluated by the criteria given."),
NC_("SC_OPCODE_COUNT_IFS", "Criteria "),
NC_("SC_OPCODE_COUNT_IFS", "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given.")
};
// -=*# Resource for function COUNTIF #*=-
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"),
NC_("SC_OPCODE_COUNT_IF", "The range of cells to be evaluated by the criteria given."),
NC_("SC_OPCODE_COUNT_IF", "Criteria"),
NC_("SC_OPCODE_COUNT_IF", "The criteria to be applied to the range.")
};
// -=*# Resource for function SQRT #*=-
const TranslateId SC_OPCODE_SQRT_ARY[] =
{
NC_("SC_OPCODE_SQRT", "Returns the square root of a number."),
NC_("SC_OPCODE_SQRT", "Number"),
NC_("SC_OPCODE_SQRT", "A positive value for which the square root is to be calculated.")
};
// -=*# Resource for function RAND #*=-
const TranslateId SC_OPCODE_RANDOM_ARY[] =
{
NC_("SC_OPCODE_RANDOM", "Returns a random number between 0 and 1.")
};
// -=*# Resource for function ISEVEN #*=-
const TranslateId SC_OPCODE_IS_EVEN_ARY[] =
{
NC_("SC_OPCODE_IS_EVEN", "Returns TRUE if the value truncated to integer is even."),
NC_("SC_OPCODE_IS_EVEN", "Value"),
NC_("SC_OPCODE_IS_EVEN", "The value to be tested.")
};
// -=*# Resource for function ISODD #*=-
const TranslateId SC_OPCODE_IS_ODD_ARY[] =
{
NC_("SC_OPCODE_IS_ODD", "Returns TRUE if the value truncated to integer is odd."),
NC_("SC_OPCODE_IS_ODD", "Value"),
NC_("SC_OPCODE_IS_ODD", "The value to be tested.")
};
// -=*# Resource for function COMBIN #*=-
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"),
NC_("SC_OPCODE_COMBIN", "The total number of elements."),
NC_("SC_OPCODE_COMBIN", "Number 2"),
NC_("SC_OPCODE_COMBIN", "The number of elements selected.")
};
// -=*# Resource for function COMBINA #*=-
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"),
NC_("SC_OPCODE_COMBIN_A", "The total number of elements."),
NC_("SC_OPCODE_COMBIN_A", "Number 2"),
NC_("SC_OPCODE_COMBIN_A", "The number of elements selected.")
};
// -=*# Resource for function ARCCOS #*=-
const TranslateId SC_OPCODE_ARC_COS_ARY[] =
{
NC_("SC_OPCODE_ARC_COS", "Returns the arccosine of a number."),
NC_("SC_OPCODE_ARC_COS", "Number"),
NC_("SC_OPCODE_ARC_COS", "A value between -1 and 1 for which the arccosine is to be returned.")
};
// -=*# Resource for function ARCSIN #*=-
const TranslateId SC_OPCODE_ARC_SIN_ARY[] =
{
NC_("SC_OPCODE_ARC_SIN", "Returns the arcsine of a number."),
NC_("SC_OPCODE_ARC_SIN", "Number"),
NC_("SC_OPCODE_ARC_SIN", "A value between -1 and 1 for which the arcsine is to be returned.")
};
// -=*# Resource for function ARCCOSHYP #*=-
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"),
NC_("SC_OPCODE_ARC_COS_HYP", "A value greater than or equal to 1 for which the inverse hyperbolic cosine is to be returned.")
};
// -=*# Resource for function ARCSINHYP #*=-
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"),
NC_("SC_OPCODE_ARC_SIN_HYP", "The value for which the inverse hyperbolic sine is to be returned.")
};
// -=*# Resource for function ARCCOT #*=-
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"),
NC_("SC_OPCODE_ARC_COT", "The value for which the inverse cotangent is to be returned.")
};
// -=*# Resource for function ARCTAN #*=-
const TranslateId SC_OPCODE_ARC_TAN_ARY[] =
{
NC_("SC_OPCODE_ARC_TAN", "Returns the arctangent of a number."),
NC_("SC_OPCODE_ARC_TAN", "Number"),
NC_("SC_OPCODE_ARC_TAN", "The value for which the arctangent is to be returned.")
};
// -=*# Resource for function ARCCOTHYP #*=-
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"),
NC_("SC_OPCODE_ARC_COT_HYP", "A value smaller than -1 or greater than 1 for which the inverse hyperbolic cotangent is to be returned.")
};
// -=*# Resource for function ARCTANHYP #*=-
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"),
NC_("SC_OPCODE_ARC_TAN_HYP", "A value between -1 and 1 for which the inverse hyperbolic tangent is to be returned.")
};
// -=*# Resource for function COS #*=-
const TranslateId SC_OPCODE_COS_ARY[] =
{
NC_("SC_OPCODE_COS", "Returns the cosine of a number."),
NC_("SC_OPCODE_COS", "Number"),
NC_("SC_OPCODE_COS", "The angle in the radians for which the cosine is to be returned.")
};
// -=*# Resource for function SIN #*=-
const TranslateId SC_OPCODE_SIN_ARY[] =
{
NC_("SC_OPCODE_SIN", "Returns the sine of a number."),
NC_("SC_OPCODE_SIN", "Number"),
NC_("SC_OPCODE_SIN", "The angle in radians for which the sine is to be calculated.")
};
// -=*# Resource for function COT #*=-
const TranslateId SC_OPCODE_COT_ARY[] =
{
NC_("SC_OPCODE_COT", "Returns the cotangent of a number."),
NC_("SC_OPCODE_COT", "Number"),
NC_("SC_OPCODE_COT", "The angle in radians whose cotangent value is to be returned.")
};
// -=*# Resource for function TAN #*=-
const TranslateId SC_OPCODE_TAN_ARY[] =
{
NC_("SC_OPCODE_TAN", "Returns the tangent of a number."),
NC_("SC_OPCODE_TAN", "Number"),
NC_("SC_OPCODE_TAN", "The angle in radians for which the tangent is to be calculated.")
};
// -=*# Resource for function COSHYP #*=-
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"),
NC_("SC_OPCODE_COS_HYP", "The value for which the hyperbolic cosine is to be returned.")
};
// -=*# Resource for function SINHYP #*=-
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"),
NC_("SC_OPCODE_SIN_HYP", "The value for which the hyperbolic sine is to be calculated.")
};
// -=*# Resource for function COTHYP #*=-
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"),
NC_("SC_OPCODE_COT_HYP", "A value not equal to 0 for which the hyperbolic cotangent is to be returned.")
};
// -=*# Resource for function TANHYP #*=-
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"),
NC_("SC_OPCODE_TAN_HYP", "The value for which the hyperbolic tangent is to be calculated.")
};
// -=*# Resource for function ARCTAN2 #*=-
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"),
NC_("SC_OPCODE_ARC_TAN_2", "The value for the X coordinate."),
NC_("SC_OPCODE_ARC_TAN_2", "Number Y"),
NC_("SC_OPCODE_ARC_TAN_2", "The value for the Y coordinate.")
};
// -=*# Resource for function CSC #*=-
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"),
NC_("SC_OPCODE_COSECANT", "The angle in radians for which the cosecant is to be calculated.")
};
// -=*# Resource for function SEC #*=-
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"),
NC_("SC_OPCODE_SECANT", "The angle in radians for which the secant is to be calculated.")
};
// -=*# Resource for function CSCH #*=-
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"),
NC_("SC_OPCODE_COSECANT_HYP", "The hyperbolic angle in radians for which the hyperbolic cosecant is to be calculated.")
};
// -=*# Resource for function SECH #*=-
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"),
NC_("SC_OPCODE_SECANT_HYP", "The hyperbolic angle in radians for which the hyperbolic secant is to be calculated.")
};
// -=*# Resource for function DEG #*=-
const TranslateId SC_OPCODE_DEG_ARY[] =
{
NC_("SC_OPCODE_DEG", "Converts a radian to degrees"),
NC_("SC_OPCODE_DEG", "Number"),
NC_("SC_OPCODE_DEG", "The angle in a radian")
};
// -=*# Resource for function RAD #*=-
const TranslateId SC_OPCODE_RAD_ARY[] =
{
NC_("SC_OPCODE_RAD", "Converts degrees to radians"),
NC_("SC_OPCODE_RAD", "Number"),
NC_("SC_OPCODE_RAD", "The angle in degrees.")
};
// -=*# Resource for function EXP #*=-
const TranslateId SC_OPCODE_EXP_ARY[] =
{
NC_("SC_OPCODE_EXP", "Calculates the exponent for basis e."),
NC_("SC_OPCODE_EXP", "Number"),
NC_("SC_OPCODE_EXP", "The exponent applied to base e.")
};
// -=*# Resource for function LOG #*=-
const TranslateId SC_OPCODE_LOG_ARY[] =
{
NC_("SC_OPCODE_LOG", "Calculates the logarithm to any specified base."),
NC_("SC_OPCODE_LOG", "Number"),
NC_("SC_OPCODE_LOG", "A value greater than 0 for which the logarithm is to be calculated."),
NC_("SC_OPCODE_LOG", "Base"),
NC_("SC_OPCODE_LOG", "The base of the logarithm. If omitted, the base is regarded as 10.")
};
// -=*# Resource for function LN #*=-
const TranslateId SC_OPCODE_LN_ARY[] =
{
NC_("SC_OPCODE_LN", "Calculates the natural logarithm of a number."),
NC_("SC_OPCODE_LN", "Number"),
NC_("SC_OPCODE_LN", "A value greater than 0 for which the natural logarithm is to be calculated.")
};
// -=*# Resource for function LOG10 #*=-
const TranslateId SC_OPCODE_LOG10_ARY[] =
{
NC_("SC_OPCODE_LOG10", "Calculates the base-10 logarithm of a number."),
NC_("SC_OPCODE_LOG10", "Number"),
NC_("SC_OPCODE_LOG10", "A value greater than 0 for which the logarithm is to be calculated.")
};
// -=*# Resource for function FACT #*=-
const TranslateId SC_OPCODE_FACT_ARY[] =
{
NC_("SC_OPCODE_FACT", "Calculates the factorial of a number."),
NC_("SC_OPCODE_FACT", "Number"),
NC_("SC_OPCODE_FACT", "The number for which the factorial is to be calculated.")
};
// -=*# Resource for function MOD #*=-
const TranslateId SC_OPCODE_MOD_ARY[] =
{
NC_("SC_OPCODE_MOD", "Calculates the remainder of a division."),
NC_("SC_OPCODE_MOD", "Dividend"),
NC_("SC_OPCODE_MOD", "The number to be divided."),
NC_("SC_OPCODE_MOD", "Divisor"),
NC_("SC_OPCODE_MOD", "The number by which the dividend is divided.")
};
// -=*# Resource for function SIGN #*=-
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"),
NC_("SC_OPCODE_PLUS_MINUS", "The number for which the algebraic sign is to be determined.")
};
// -=*# Resource for function SUBTOTAL #*=-
const TranslateId SC_OPCODE_SUB_TOTAL_ARY[] =
{
NC_("SC_OPCODE_SUB_TOTAL", "Calculates subtotals in a spreadsheet."),
NC_("SC_OPCODE_SUB_TOTAL", "Function"),
NC_("SC_OPCODE_SUB_TOTAL", "Function index. Is an index of the possible functions Total, Max, ..."),
NC_("SC_OPCODE_SUB_TOTAL", "Range"),
NC_("SC_OPCODE_SUB_TOTAL", "The cells of the range which are to be taken into account.")
};
// -=*# Resource for function AGGREGATE #*=-
const TranslateId SC_OPCODE_AGGREGATE_ARY[] =
{
NC_("SC_OPCODE_AGGREGATE", "Calculates an aggregate in a spreadsheet."),
NC_("SC_OPCODE_AGGREGATE", "Function"),
NC_("SC_OPCODE_AGGREGATE", "Function index. Is an index of the possible functions Total, Max, ..."),
NC_("SC_OPCODE_AGGREGATE", "Options"),
NC_("SC_OPCODE_AGGREGATE", "Option index. Is an index of the possible ignore options."),
NC_("SC_OPCODE_AGGREGATE", "Reference 1 or array"),
NC_("SC_OPCODE_AGGREGATE", "The cell(s) of the range which are to be taken into account."),
NC_("SC_OPCODE_AGGREGATE", "Reference 2..n or k "),
NC_("SC_OPCODE_AGGREGATE", "The cells of the range which are to be taken into account or mandatory 2nd argument for certain functions.")
};
// -=*# Resource for function INT #*=-
const TranslateId SC_OPCODE_INT_ARY[] =
{
NC_("SC_OPCODE_INT", "Rounds a number down to the nearest integer."),
NC_("SC_OPCODE_INT", "Number"),
NC_("SC_OPCODE_INT", "The number to be rounded down.")
};
// -=*# Resource for function TRUNC #*=-
const TranslateId SC_OPCODE_TRUNC_ARY[] =
{
NC_("SC_OPCODE_TRUNC", "Truncates the decimal places of a number."),
NC_("SC_OPCODE_TRUNC", "Number"),
NC_("SC_OPCODE_TRUNC", "The number to be truncated."),
NC_("SC_OPCODE_TRUNC", "Count"),
NC_("SC_OPCODE_TRUNC", "The number of places after the decimal point that are not to be truncated.")
};
// -=*# Resource for function ROUND #*=-
const TranslateId SC_OPCODE_ROUND_ARY[] =
{
NC_("SC_OPCODE_ROUND", "Rounds a number to a predefined accuracy."),
NC_("SC_OPCODE_ROUND", "Number"),
NC_("SC_OPCODE_ROUND", "The number to be rounded."),
NC_("SC_OPCODE_ROUND", "Count"),
NC_("SC_OPCODE_ROUND", "The number of places to which a number is to be rounded.")
};
// -=*# Resource for function ROUNDUP #*=-
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"),
NC_("SC_OPCODE_ROUND_UP", "The number to be rounded up."),
NC_("SC_OPCODE_ROUND_UP", "Count"),
NC_("SC_OPCODE_ROUND_UP", "The number of places to which a number is to be rounded.")
};
// -=*# Resource for function ROUNDDOWN #*=-
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"),
NC_("SC_OPCODE_ROUND_DOWN", "The number to be rounded down."),
NC_("SC_OPCODE_ROUND_DOWN", "Count"),
NC_("SC_OPCODE_ROUND_DOWN", "The number of places down to which a number is to be rounded.")
};
// -=*# Resource for function EVEN #*=-
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"),
NC_("SC_OPCODE_EVEN", "The number to be rounded up.")
};
// -=*# Resource for function ODD #*=-
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"),
NC_("SC_OPCODE_ODD", "The number to be rounded up.")
};
// -=*# Resource for function CEILING.XCL #*=-
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"),
NC_("SC_OPCODE_CEIL_MS", "The number to be rounded up."),
NC_("SC_OPCODE_CEIL_MS", "Significance"),
NC_("SC_OPCODE_CEIL_MS", "The number to whose multiple the value is rounded.")
};
// -=*# Resource for function CEILING.PRECISE #*=-
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"),
NC_("SC_OPCODE_CEIL_PRECISE", "The number to be rounded up."),
NC_("SC_OPCODE_CEIL_PRECISE", "Significance"),
NC_("SC_OPCODE_CEIL_PRECISE", "The number to whose multiple the value is rounded.")
};
// -=*# Resource for function ISO.CEILING #*=-
const TranslateId SC_OPCODE_CEIL_ISO_ARY[] =
{
--> --------------------
--> maximum size reached
--> --------------------
[ Dauer der Verarbeitung: 0.22 Sekunden
(vorverarbeitet)
]
|
2026-04-04
|
