en to en-GB translation catalogue (449 entries)

[ctx: RID_ERRHDLSC]
en: Not all cell contents could be saved in the specified format.
en-GB: Not all cell content could be saved in the specified format.

[ctx: RID_ERRHDLSC]
en: The document contains information not recognized by this program version.
    Resaving the document will delete this information!
en-GB: The document contains information not recognised by this program version.
    Resaving the document will delete this information!

[ctx: SCSTR_FILTER_COLOR]
en: Filter by Color
en-GB: Filter by Colour

[ctx: SCSTR_SET_TAB_BG_COLOR]
en: Tab Color
en-GB: Tab Colour

[ctx: SCSTR_UNIT]
en: Centimeter
en-GB: centimetre

[ctx: SCSTR_UNIT]
en: Foot
en-GB: foot

[ctx: SCSTR_UNIT]
en: Inch
en-GB: inch

[ctx: SCSTR_UNIT]
en: Kilometer
en-GB: kilometre

[ctx: SCSTR_UNIT]
en: Meter
en-GB: metre

[ctx: SCSTR_UNIT]
en: Miles
en-GB: mile

[ctx: SCSTR_UNIT]
en: Millimeter
en-GB: millimetre

[ctx: SCSTR_UNIT]
en: Pica
en-GB: pica

[ctx: SCSTR_UNIT]
en: Point
en-GB: point

[ctx: SC_OPCODE_ARABIC]
en: The text that represents a Roman numeral.
en-GB: The text string that represents a Roman numeral.

[ctx: SC_OPCODE_ARC_COS]
en: A value between -1 and 1 for which the arccosine is to be returned.
en-GB: A value in the range -1.0 to +1.0 for which the arc cosine is to be returned.

[ctx: SC_OPCODE_ARC_COS]
en: Returns the arccosine of a number.
en-GB: Returns the arc cosine of a number.

[ctx: SC_OPCODE_ARC_COT_HYP]
en: A value smaller than -1 or greater than 1 for which the inverse hyperbolic cotangent is to be returned.
en-GB: A value smaller than -1.0 or greater than +1.0 for which the inverse hyperbolic cotangent is to be returned.

[ctx: SC_OPCODE_ARC_SIN]
en: A value between -1 and 1 for which the arcsine is to be returned.
en-GB: A value in the range -1.0 to +1.0 for which the arc sine is to be returned.

[ctx: SC_OPCODE_ARC_SIN]
en: Returns the arcsine of a number.
en-GB: Returns the arc sine of a number.

[ctx: SC_OPCODE_ARC_TAN]
en: Returns the arctangent of a number.
en-GB: Returns the arc tangent of a number.

[ctx: SC_OPCODE_ARC_TAN]
en: The value for which the arctangent is to be returned.
en-GB: The value for which the arc tangent is to be returned.

[ctx: SC_OPCODE_ARC_TAN_2]
en: Returns the arctangent for the specified coordinates.
en-GB: Returns the arc tangent for the specified coordinates.

[ctx: SC_OPCODE_ARC_TAN_2]
en: The value for the X coordinate.
en-GB: The value for the x-coordinate.

[ctx: SC_OPCODE_ARC_TAN_2]
en: The value for the Y coordinate.
en-GB: The value for the y-coordinate.

[ctx: SC_OPCODE_ARC_TAN_HYP]
en: A value between -1 and 1 for which the inverse hyperbolic tangent is to be returned.
en-GB: A value in the range -1.0 to +1.0 for which the inverse hyperbolic tangent is to be returned.

[ctx: SC_OPCODE_ASC]
en: The text to convert.
en-GB: The text string to convert.

[ctx: SC_OPCODE_AVERAGE_IFS]
en: Range 1, range 2,... are the ranges to be evaluated by the criteria given.
en-GB: Range 1, range 2, ... are the ranges to be evaluated by the criteria given.

[ctx: SC_OPCODE_B]
en: Returns the probability of a trial result using binomial distribution.
en-GB: Returns the probability of a trial result using the binomial distribution.

[ctx: SC_OPCODE_BASE]
en: If the text is shorter than the specified length, zeros are added to the left of the string.
en-GB: If the resulting text string is shorter than the specified length, zeros are added to the left of the text string.

[ctx: SC_OPCODE_BINOM_DIST]
en: Cumulated. C=0 calculates the individual probability, C=1 the cumulated probability.
en-GB: Cumulative. C=0 calculates the individual probability, C=1 the cumulated probability.

[ctx: SC_OPCODE_CELL]
en: Determines information about address, formatting or contents of a cell.
en-GB: Determines information about address, formatting or content of a cell.

[ctx: SC_OPCODE_CHISQ_INV]
en: The degrees of freedom of the chi square distribution.
en-GB: The degrees of freedom of the chi-square distribution.

[ctx: SC_OPCODE_CHISQ_INV]
en: The probability value for which the inverse of the chi square distribution is to be calculated.
en-GB: The probability value for which the inverse of the chi-square distribution is to be calculated.

[ctx: SC_OPCODE_CHISQ_INV]
en: Values of the inverse of CHISQDIST(x;DegreesOfFreedom;TRUE()).
en-GB: Values of the inverse of CHISQDIST(x; DegreesOfFreedom; TRUE()).

[ctx: SC_OPCODE_CHISQ_INV_MS]
en: The degrees of freedom of the chi square distribution.
en-GB: The degrees of freedom of the chi-square distribution.

[ctx: SC_OPCODE_CHISQ_INV_MS]
en: The probability value for which the inverse of the chi square distribution is to be calculated.
en-GB: The probability value for which the inverse of the chi-square distribution is to be calculated.

[ctx: SC_OPCODE_CHI_DIST]
en: The degrees of freedom of the chi square distribution.
en-GB: The degrees of freedom of the chi-square distribution.

[ctx: SC_OPCODE_CHI_DIST]
en: The value for which the chi square distribution is to be calculated.
en-GB: The value for which the chi-square distribution is to be calculated.

[ctx: SC_OPCODE_CHI_DIST_MS]
en: The degrees of freedom of the chi square distribution.
en-GB: The degrees of freedom of the chi-square distribution.

[ctx: SC_OPCODE_CHI_DIST_MS]
en: The value for which the chi square distribution is to be calculated.
en-GB: The value for which the chi-square distribution is to be calculated.

[ctx: SC_OPCODE_CHI_INV]
en: The degrees of freedom of the chi square distribution.
en-GB: The degrees of freedom of the chi-square distribution.

[ctx: SC_OPCODE_CHI_INV]
en: The probability value for which the inverse chi square distribution is to be calculated.
en-GB: The probability value for which the inverse chi-square distribution is to be calculated.

[ctx: SC_OPCODE_CHI_INV_MS]
en: The degrees of freedom of the chi square distribution.
en-GB: The degrees of freedom of the chi-square distribution.

[ctx: SC_OPCODE_CHI_INV_MS]
en: The probability value for which the inverse chi square distribution is to be calculated.
en-GB: The probability value for which the inverse chi-square distribution is to be calculated.

[ctx: SC_OPCODE_CHI_TEST]
en: Returns the chi square independence test.
en-GB: Returns the chi-square independence test.

[ctx: SC_OPCODE_CHI_TEST_MS]
en: Returns the chi square independence test.
en-GB: Returns the chi-square independence test.

[ctx: SC_OPCODE_CHOOSE]
en: Value 1, value 2,... The list of arguments from which a value is chosen.
en-GB: Value1; Value2; ... Value30: The list of arguments from which a value is chosen.

[ctx: SC_OPCODE_CLEAN]
en: Removes all nonprintable characters from text.
en-GB: Removes all non-printable characters from text.

[ctx: SC_OPCODE_CLEAN]
en: The text from which nonprintable characters are to be removed.
en-GB: The text string from which non-printable characters are to be removed.

[ctx: SC_OPCODE_CODE]
en: This is the text for which the code of the first character is to be found.
en-GB: This is the text string for which the code of the first character is to be found.

[ctx: SC_OPCODE_COLOR]
en: Returns an implementation defined value representing a RGBA color
en-GB: Returns an implementation defined value representing a RGBA colour

[ctx: SC_OPCODE_CONCAT]
en: Text for the concatenation.
en-GB: A text string for concatenation.

[ctx: SC_OPCODE_COS]
en: The angle in the radians for which the cosine is to be returned.
en-GB: The angle in radians for which the cosine is to be returned.

[ctx: SC_OPCODE_COUNT_IFS]
en: Range 1, range 2,... are the ranges to be evaluated by the criteria given.
en-GB: Range 1, range 2, ... are the ranges to be evaluated by the criteria given.

[ctx: SC_OPCODE_DB_COUNT_2]
en: Counts all non-blank cells of a data range where the content corresponds to the search criteria.
en-GB: Counts all non-blank cells of a data range for which the cell content corresponds to the search criteria.

[ctx: SC_OPCODE_DB_MIN]
en: Returns the minimum of all cells of a data range where the contents correspond to the search criteria.
en-GB: Returns the minimum of all cells of a data range for which each cell content matches the search criteria.

[ctx: SC_OPCODE_DB_PRODUCT]
en: Multiplies all cells of a data range where the contents match the search criteria.
en-GB: Multiplies all cells of a data range for which each cell content matches the search criteria.

[ctx: SC_OPCODE_DB_SUM]
en: Adds all the cells of a data range where the contents match the search criteria.
en-GB: Adds all the cells of a data range for which each cell content matches the search criteria.

[ctx: SC_OPCODE_DB_VAR]
en: Determines the variance of all the cells in a data range where the contents match the search criteria.
en-GB: Determines the variance of all the cells in a data range for which each cell content matches the search criteria.

[ctx: SC_OPCODE_DB_VAR_P]
en: Determines variance of a population based on all cells in a data range where contents match the search criteria.
en-GB: Determines variance of a population based on all cells in a data range for which each cell content matches the search criteria.

[ctx: SC_OPCODE_DECIMAL]
en: Converts a text of a specified number system to a positive integer in the base given.
en-GB: Converts a text string in a specified number system to a positive integer in the base given.

[ctx: SC_OPCODE_DECIMAL]
en: The text to be converted.
en-GB: The text string to be converted.

[ctx: SC_OPCODE_DEG]
en: Converts a radian to degrees
en-GB: Converts an angle in radians to degrees

[ctx: SC_OPCODE_DEG]
en: The angle in a radian
en-GB: The angle in radians

[ctx: SC_OPCODE_EASTERSUNDAY]
en: An integer between 1583 and 9956, or 0 and 99 (19xx or 20xx depending on the option set).
en-GB: An integer in the range 1583 to 9956, or 0 to 99 (19xx or 20xx depending on the option set).

[ctx: SC_OPCODE_ERFC_MS]
en: Returns the complementary error function.
en-GB: Returns the complementary error function

[ctx: SC_OPCODE_EUROCONVERT]
en: Converts a value from one to another Euro currency.
en-GB: Converts a value from one to another old European national currency or euro.

[ctx: SC_OPCODE_EUROCONVERT]
en: ISO 4217 code of the currency from which is converted.
en-GB: ISO 4217 code of the currency being converted from.

[ctx: SC_OPCODE_EUROCONVERT]
en: ISO 4217 code of the currency into which is converted.
en-GB: ISO 4217 code of the currency being converted to.

[ctx: SC_OPCODE_EXACT]
en: Specifies whether two texts are identical.
en-GB: Specifies whether two text strings are identical.

[ctx: SC_OPCODE_EXACT]
en: The first text to be used for comparing texts.
en-GB: The first text string to be used for comparison.

[ctx: SC_OPCODE_EXACT]
en: The second text for comparing texts.
en-GB: The second text string for comparison.

[ctx: SC_OPCODE_EXP_DIST]
en: Cumulated. C=0 calculates the density function, C=1 the distribution.
en-GB: Cumulative. C=0 calculates the density function, C=1 the distribution.

[ctx: SC_OPCODE_EXP_DIST_MS]
en: Cumulated. C=0 calculates the density function, C=1 the distribution.
en-GB: Cumulative. C=0 calculates the density function, C=1 the distribution.

[ctx: SC_OPCODE_FIND]
en: Looks for a string of text within another (case sensitive)
en-GB: Looks for a text string within another (case-sensitive)

[ctx: SC_OPCODE_FIND]
en: The position in the text from which the search starts.
en-GB: The position in the text string from which the search starts.

[ctx: SC_OPCODE_FIND]
en: The text in which a search is to be made.
en-GB: The text string in which a search is to be made.

[ctx: SC_OPCODE_FIND]
en: The text to be found.
en-GB: The text string to be found.

[ctx: SC_OPCODE_FINDB]
en: Looks for a string of text within another (case sensitive), using byte positions.
en-GB: Looks for a string of text within another (case-sensitive), using byte positions.

[ctx: SC_OPCODE_FISHER]
en: The value to be transformed (-1 < VALUE < 1).
en-GB: The value to be transformed (-1.0 < VALUE < +1.0).

[ctx: SC_OPCODE_FORECAST]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_FORECAST]
en: The X value for which the Y value on the regression linear is to be calculated.
en-GB: The x-value for which the y-value on the linear regression is to be calculated.

[ctx: SC_OPCODE_FORECAST]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_FORECAST_LIN]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_FORECAST_LIN]
en: The X value for which the Y value on the regression linear is to be calculated.
en-GB: The x-value for which the y-value on the linear regression is to be calculated.

[ctx: SC_OPCODE_FORECAST_LIN]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_F_DIST]
en: The degrees of freedom in the denominator of the F distribution.
en-GB: The degrees of freedom in the denominator of the F-distribution.

[ctx: SC_OPCODE_F_DIST]
en: The degrees of freedom in the numerator of the F distribution.
en-GB: The degrees of freedom in the numerator of the F-distribution.

[ctx: SC_OPCODE_F_DIST]
en: The value for which the F distribution is to be calculated.
en-GB: The value for which the F-distribution is to be calculated.

[ctx: SC_OPCODE_F_DIST_LT]
en: The degrees of freedom in the denominator of the F distribution.
en-GB: The degrees of freedom in the denominator of the F-distribution.

[ctx: SC_OPCODE_F_DIST_LT]
en: The degrees of freedom in the numerator of the F distribution.
en-GB: The degrees of freedom in the numerator of the F-distribution.

[ctx: SC_OPCODE_F_DIST_LT]
en: The value for which the F distribution is to be calculated.
en-GB: The value for which the F-distribution is to be calculated.

[ctx: SC_OPCODE_F_DIST_RT]
en: The degrees of freedom in the denominator of the F distribution.
en-GB: The degrees of freedom in the denominator of the F-distribution.

[ctx: SC_OPCODE_F_DIST_RT]
en: The degrees of freedom in the numerator of the F distribution.
en-GB: The degrees of freedom in the numerator of the F-distribution.

[ctx: SC_OPCODE_F_DIST_RT]
en: The value for which the F distribution is to be calculated.
en-GB: The value for which the F-distribution is to be calculated.

[ctx: SC_OPCODE_F_INV]
en: The degrees of freedom in the denominator of the F distribution.
en-GB: The degrees of freedom in the denominator of the F-distribution.

[ctx: SC_OPCODE_F_INV]
en: The degrees of freedom in the numerator of the F distribution.
en-GB: The degrees of freedom in the numerator of the F-distribution.

[ctx: SC_OPCODE_F_INV]
en: The probability value for which the inverse F distribution is to be calculated.
en-GB: The probability value for which the inverse F-distribution is to be calculated.

[ctx: SC_OPCODE_F_INV]
en: Values of the inverse F distribution.
en-GB: Values of the inverse F-distribution.

[ctx: SC_OPCODE_F_INV_LT]
en: The degrees of freedom in the denominator of the F distribution.
en-GB: The degrees of freedom in the denominator of the F-distribution.

[ctx: SC_OPCODE_F_INV_LT]
en: The degrees of freedom in the numerator of the F distribution.
en-GB: The degrees of freedom in the numerator of the F-distribution.

[ctx: SC_OPCODE_F_INV_RT]
en: The degrees of freedom in the denominator of the F distribution.
en-GB: The degrees of freedom in the denominator of the F-distribution.

[ctx: SC_OPCODE_F_INV_RT]
en: The degrees of freedom in the numerator of the F distribution.
en-GB: The degrees of freedom in the numerator of the F-distribution.

[ctx: SC_OPCODE_F_TEST]
en: Calculates the F test.
en-GB: Calculates the F-test.

[ctx: SC_OPCODE_F_TEST_MS]
en: Calculates the F test.
en-GB: Calculates the F-test.

[ctx: SC_OPCODE_GET_DATE]
en: An integer between 1 and 12 representing the month.
en-GB: An integer in the range 1 to 12 representing the month.

[ctx: SC_OPCODE_GET_DATE]
en: An integer between 1 and 31 representing the day of the month.
en-GB: An integer in the range 1 to 31 representing the day of the month.

[ctx: SC_OPCODE_GET_DATE]
en: An integer between 1583 and 9956 or 0 and 99 (19xx or 20xx depending on the defined option).
en-GB: An integer in the range 1583 to 9956 or in the range 0 to 99 (19xx or 20xx depending on the defined option).

[ctx: SC_OPCODE_GET_DATE_VALUE]
en: A text enclosed in quotation marks which returns a date in a %PRODUCTNAME date format.
en-GB: A text string enclosed by quotation marks which returns a date in a %PRODUCTNAME date format.

[ctx: SC_OPCODE_GET_DATE_VALUE]
en: Returns an internal number for a text having a possible date format.
en-GB: Returns an internal number for a text string having a possible date format.

[ctx: SC_OPCODE_GET_TIME_VALUE]
en: A text enclosed in quotation marks which returns a time in a %PRODUCTNAME time format.
en-GB: A text string enclosed by quotation marks which returns a time in a %PRODUCTNAME time format.

[ctx: SC_OPCODE_GET_TIME_VALUE]
en: Returns a sequential number for a text shown in a possible time entry format.
en-GB: Returns a sequential number for a text string shown in a possible time entry format.

[ctx: SC_OPCODE_GROWTH]
en: The X data array as the basis for the regression.
en-GB: The x-data array as the basis for the regression.

[ctx: SC_OPCODE_GROWTH]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_GROWTH]
en: The array of X data for recalculating the values.
en-GB: The array of x-data for recalculating the values.

[ctx: SC_OPCODE_HYP_GEOM_DIST]
en: Cumulated. TRUE calculates the cumulative distribution function, FALSE the probability mass function.
en-GB: Cumulative. TRUE calculates the cumulative distribution function, FALSE the probability mass function.

[ctx: SC_OPCODE_INDIRECT]
en: Returns the contents of a cell that is referenced in text form.
en-GB: Returns the content of a cell that is referenced in text form.

[ctx: SC_OPCODE_INFO]
en: Can be "osversion", "system", "release", "numfile", and "recalc".
en-GB: Can be "osversion", "system", "release", "numfile" and "recalc".

[ctx: SC_OPCODE_INTERCEPT]
en: Returns the intercept of the linear regression line and the Y axis.
en-GB: Returns the intercept of the linear regression line and the y-axis.

[ctx: SC_OPCODE_INTERCEPT]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_INTERCEPT]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_ISPMT]
en: Interest rate for a single amortization rate.
en-GB: Interest rate for a single amortisation rate.

[ctx: SC_OPCODE_ISPMT]
en: Number of amortization periods for the calculation of the interest.
en-GB: Number of amortisation periods for the calculation of the interest.

[ctx: SC_OPCODE_ISPMT]
en: Returns the amount of interest for constant amortization rates.
en-GB: Returns the amount of interest for constant amortisation rates.

[ctx: SC_OPCODE_ISPMT]
en: Sum total of amortization periods.
en-GB: Sum total of amortisation periods.

[ctx: SC_OPCODE_JIS]
en: The text to convert.
en-GB: The text string to convert.

[ctx: SC_OPCODE_LEFT]
en: Returns the first character or characters of a text.
en-GB: Defines the first character (or characters) of a text string.

[ctx: SC_OPCODE_LEFT]
en: The number of characters for the start text.
en-GB: The number of characters for the start text string.

[ctx: SC_OPCODE_LEFT]
en: The text where the initial partial words are to be determined.
en-GB: The text string where the initial partial words are to be determined.

[ctx: SC_OPCODE_LEFTB]
en: Returns the first character or characters of a text,with DBCS
en-GB: Defines the first character (or characters) of a text string, with DBCS.

[ctx: SC_OPCODE_LEFTB]
en: The number of characters for the start text.
en-GB: The number of characters for the start text string.

[ctx: SC_OPCODE_LEFTB]
en: The text where the initial partial words are to be determined.
en-GB: The text string where the initial partial words are to be determined.

[ctx: SC_OPCODE_LEN]
en: The text in which the length is to be determined.
en-GB: The text string of which the length is to be determined.

[ctx: SC_OPCODE_LENB]
en: The text in which the length is to be determined.
en-GB: The text string of which the length is to be determined.

[ctx: SC_OPCODE_LINEST]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_LINEST]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_LOGEST]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_LOGEST]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_LOG_INV]
en: Mean value. The mean value of the log normal distribution.
en-GB: Mean value. The mean value of the log-normal distribution.

[ctx: SC_OPCODE_LOG_INV]
en: Standard deviation. The standard deviation of the log normal distribution.
en-GB: Standard deviation. The standard deviation of the log-normal distribution.

[ctx: SC_OPCODE_LOG_INV]
en: The probability value for which the inverse log normal distribution is to be calculated.
en-GB: The probability value for which the inverse log-normal distribution is to be calculated.

[ctx: SC_OPCODE_LOG_INV]
en: Values of the inverse of the lognormal distribution.
en-GB: Values of the inverse of the log-normal distribution.

[ctx: SC_OPCODE_LOG_INV_MS]
en: Mean value. The mean value of the log normal distribution.
en-GB: Mean value. The mean value of the log-normal distribution.

[ctx: SC_OPCODE_LOG_INV_MS]
en: Standard deviation. The standard deviation of the log normal distribution.
en-GB: Standard deviation. The standard deviation of the log-normal distribution.

[ctx: SC_OPCODE_LOG_INV_MS]
en: The probability value for which the inverse log normal distribution is to be calculated.
en-GB: The probability value for which the inverse log-normal distribution is to be calculated.

[ctx: SC_OPCODE_LOG_INV_MS]
en: Values of the inverse of the lognormal distribution.
en-GB: Values of the inverse of the log-normal distribution.

[ctx: SC_OPCODE_LOG_NORM_DIST]
en: The mean value of the log normal distribution. It is set to 0 if omitted.
en-GB: The mean value of the log-normal distribution. It is set to 0 if omitted.

[ctx: SC_OPCODE_LOG_NORM_DIST]
en: The standard deviation of the log normal distribution. It is set to 1 if omitted.
en-GB: The standard deviation of the log-normal distribution. It is set to 1 if omitted.

[ctx: SC_OPCODE_LOG_NORM_DIST]
en: The value for which the log normal distribution is to be calculated.
en-GB: The value for which the log-normal distribution is to be calculated.

[ctx: SC_OPCODE_LOG_NORM_DIST]
en: Values of the log normal distribution.
en-GB: Values of the log-normal distribution.

[ctx: SC_OPCODE_LOG_NORM_DIST_MS]
en: The mean value of the log normal distribution.
en-GB: The mean value of the log-normal distribution.

[ctx: SC_OPCODE_LOG_NORM_DIST_MS]
en: The standard deviation of the log normal distribution.
en-GB: The standard deviation of the log-normal distribution.

[ctx: SC_OPCODE_LOG_NORM_DIST_MS]
en: The value for which the log normal distribution is to be calculated.
en-GB: The value for which the log-normal distribution is to be calculated.

[ctx: SC_OPCODE_LOG_NORM_DIST_MS]
en: Values of the log normal distribution.
en-GB: Values of the log-normal distribution.

[ctx: SC_OPCODE_LOWER]
en: Converts text to lowercase.
en-GB: Converts a text string to lower-case.

[ctx: SC_OPCODE_LOWER]
en: The text in which capitals are converted to lower case letters.
en-GB: The text string in which capitals are converted to lower-case letters.

[ctx: SC_OPCODE_MID]
en: Returns a partial text string of a text.
en-GB: Returns a partial text string of a text string.

[ctx: SC_OPCODE_MID]
en: The number of characters for the text.
en-GB: The number of characters for the text string.

[ctx: SC_OPCODE_MID]
en: The text in which partial words are to be determined.
en-GB: The text string in which partial words are to be determined.

[ctx: SC_OPCODE_MIDB]
en: Returns a partial text string of a text, with DBCS
en-GB: Returns a partial text string of a text string, with DBCS.

[ctx: SC_OPCODE_MIDB]
en: The number of characters for the text.
en-GB: The number of characters for the text string.

[ctx: SC_OPCODE_MIDB]
en: The text in which partial words are to be determined.
en-GB: The text string in which partial words are to be determined.

[ctx: SC_OPCODE_NUMBERVALUE]
en: Converts text to a number, in a locale-independent way.
en-GB: Converts a text string to a number, in a locale-independent way.

[ctx: SC_OPCODE_NUMBERVALUE]
en: The text to be converted to a number.
en-GB: The text string to be converted to a number.

[ctx: SC_OPCODE_POWER]
en: Exponent
en-GB: Power

[ctx: SC_OPCODE_POWER]
en: The base a of the power a^b.
en-GB: The number that is to be raised to the power of another.

[ctx: SC_OPCODE_POWER]
en: The exponent b of the power a^b.
en-GB: The power by which the number is to be raised.

[ctx: SC_OPCODE_PROPER]
en: Capitalizes the first letter in all words.
en-GB: Capitalises the first letter in all words.

[ctx: SC_OPCODE_PROPER]
en: The text in which the beginning of words are to be replaced by capital letters.
en-GB: The text string in which the beginning of words are to be replaced by capital letters.

[ctx: SC_OPCODE_QUARTILE_INC]
en: The type of the quartile (0 = MIN, 1 = 25%, 2 = 50%, 3 = 75%, 4 = MAX).
en-GB: The type of the quartile (0 = MIN, 1 = 25%, 2 = 50 %, 3 = 75 %, 4 =MAX).

[ctx: SC_OPCODE_RAD]
en: Converts degrees to radians
en-GB: Converts an angle in degrees to radians

[ctx: SC_OPCODE_RANDOM]
en: Returns a random number between 0 and 1.
en-GB: Returns a random number in the range 0.0 to 1.0.

[ctx: SC_OPCODE_REPLACE]
en: The text in which some characters are to be replaced.
en-GB: The text string in which some characters are to be replaced.

[ctx: SC_OPCODE_REPLACE]
en: The text to be inserted.
en-GB: The text string to be inserted.

[ctx: SC_OPCODE_REPT]
en: Repeats text a given number of times.
en-GB: Repeats a text string a given number of times.

[ctx: SC_OPCODE_REPT]
en: The number of times the text is to be repeated.
en-GB: The number of times the text string is to be repeated.

[ctx: SC_OPCODE_REPT]
en: The text to be repeated.
en-GB: The text string to be repeated.

[ctx: SC_OPCODE_RIGHT]
en: Returns the last character or characters of a text.
en-GB: Returns the last character or characters of a text string.

[ctx: SC_OPCODE_RIGHT]
en: The number of characters for the end text.
en-GB: The number of characters for the end text string.

[ctx: SC_OPCODE_RIGHT]
en: The text in which the end partial words are to be determined.
en-GB: The text string in which the end partial words are to be determined.

[ctx: SC_OPCODE_RIGHTB]
en: Returns the last character or characters of a text,with DBCS
en-GB: Returns the last character or characters of a text string, with DBCS

[ctx: SC_OPCODE_RIGHTB]
en: The number of characters for the end text.
en-GB: The number of characters for the end text string.

[ctx: SC_OPCODE_RIGHTB]
en: The text in which the end partial words are to be determined.
en-GB: The text string in which the end partial words are to be determined.

[ctx: SC_OPCODE_RSQ]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_RSQ]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_SEARCH]
en: Looks for one text value within another (not case-sensitive).
en-GB: Looks for one text string within another (not case-sensitive).

[ctx: SC_OPCODE_SEARCH]
en: The position in the text where the search is started.
en-GB: The position in the text string from which the search is started.

[ctx: SC_OPCODE_SEARCH]
en: The text in which a search is to be made.
en-GB: The text string in which a search is to be made.

[ctx: SC_OPCODE_SEARCH]
en: The text to be found.
en-GB: The text string to be found.

[ctx: SC_OPCODE_SEARCHB]
en: Looks for a string of text within another (not case sensitive), using byte positions.
en-GB: Looks for a string of text within another (not case-sensitive), using byte positions.

[ctx: SC_OPCODE_SHEET]
en: The reference to a cell or a range or the character string of a sheet name.
en-GB: The reference to a cell or a range or the text string of a sheet name.

[ctx: SC_OPCODE_SLOPE]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_SLOPE]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_SQRT]
en: A positive value for which the square root is to be calculated.
en-GB: A positive value, for which the square root is to be calculated.

[ctx: SC_OPCODE_STANDARD]
en: Converts a random variable to a normalized value.
en-GB: Converts a random variable to a normalised value.

[ctx: SC_OPCODE_STANDARD]
en: The value to be standardized.
en-GB: The value to be standardised.

[ctx: SC_OPCODE_STEYX]
en: The X data array.
en-GB: The x-data array.

[ctx: SC_OPCODE_STEYX]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_SUBSTITUTE]
en: The text in which partial words are to be replaced.
en-GB: The text string in which partial words are to be replaced.

[ctx: SC_OPCODE_SUBSTITUTE]
en: The text which is to replace the text string.
en-GB: The text string which is to replace the text string.

[ctx: SC_OPCODE_SUM_IFS]
en: Range 1, range 2,... are the ranges to be evaluated by the criteria given.
en-GB: Range 1, range 2, ... are the ranges to be evaluated by the criteria given.

[ctx: SC_OPCODE_TEXT]
en: Converts a number to text according to a given format.
en-GB: Converts a number to a text string according to a given format.

[ctx: SC_OPCODE_TEXT]
en: The text that describes the format.
en-GB: The text string that describes the format.

[ctx: SC_OPCODE_TREND]
en: The X data array as the basis for the regression.
en-GB: The x-data array as the basis for the regression.

[ctx: SC_OPCODE_TREND]
en: The Y data array.
en-GB: The y-data array.

[ctx: SC_OPCODE_TREND]
en: The array of X data for recalculating the values.
en-GB: The array of x-data for recalculating the values.

[ctx: SC_OPCODE_TRIM]
en: The text in which extra spaces between words are to be deleted.
en-GB: The text string in which extra spaces between words are to be deleted.

[ctx: SC_OPCODE_UNICODE]
en: This is the text for which the code of the first character is to be found.
en-GB: This is the text string for which the code of the first character is to be found.

[ctx: SC_OPCODE_UPPER]
en: Converts text to uppercase.
en-GB: Converts a text string to upper-case.

[ctx: SC_OPCODE_UPPER]
en: The text in which lower case letters are to be converted to capitals.
en-GB: The text string in which lower-case letters are to be converted to capitals.

[ctx: SC_OPCODE_VALUE]
en: Converts text to a number.
en-GB: Converts a text string to a number.

[ctx: SC_OPCODE_VALUE]
en: The text to be converted to a number.
en-GB: The text string to be converted to a number.

[ctx: SC_OPCODE_WEIBULL]
en: Cumulated. C=0 calculates the density function, C=1 the distribution.
en-GB: Cumulative. C=0 calculates the density function, C=1 the distribution.

[ctx: SC_OPCODE_WEIBULL_MS]
en: Cumulated. C=0 calculates the density function, C=1 the distribution.
en-GB: Cumulative. C=0 calculates the density function, C=1 the distribution.

[ctx: STANDARDFILTERDIALOG_COND]
en: Background color
en-GB: Background colour

[ctx: STANDARDFILTERDIALOG_COND]
en: Font color
en-GB: Font colour

[ctx: STR_ACC_CENTERAREA_NAME]
en: Center area
en-GB: Centre area

[ctx: STR_ACC_EDITLINE_DESCR]
en: This is where you enter or edit text, numbers and formulas.
en-GB: This is where you enter or edit text, numbers and formulae.

[ctx: STR_CHANGED_MOVE_REJECTION_WARNING]
en: WARNING: This action may have resulted in unintended changes to cell references in formulas.
en-GB: WARNING: This action may have resulted in unintended changes to cell references in formulae.

[ctx: STR_COND_COLORSCALE]
en: ColorScale
en-GB: ColourScale

[ctx: STR_DEL_AUTOFORMAT_MSG]
en: Do you really want to delete the # AutoFormat?
en-GB: Do you really want to delete the # AutoFomat?

[ctx: STR_DISTRIBUTION_CHI_SQUARED]
en: Chi Squared
en-GB: Chi-Squared

[ctx: STR_FORMULAS]
en: Formulas
en-GB: Formulae

[ctx: STR_HYPOTHESIZED_MEAN_DIFFERENCE_LABEL]
en: Hypothesized Mean Difference
en-GB: Hypothesised Mean Difference

[ctx: STR_LABEL_PREDICTEDY]
en: Predicted Y
en-GB: Predicted y

[ctx: STR_LABEL_XVARIABLES_COUNT]
en: Count of X variables
en-GB: Count of x-variables

[ctx: STR_LONG_ERR_ILL_FPO]
en: Error: Invalid numeric value
en-GB: Error: Invalid floating point operation

[ctx: STR_LONG_ERR_SYNTAX]
en: Internal syntactical error
en-GB: Internal syntax error

[ctx: STR_MESSAGE_MULTIVARIATE_NUMOBS_MISMATCH]
en: Multivariate regression : The observation count in X and Y must match.
en-GB: Multivariate regression : The observation count in x and y must match.

[ctx: STR_MESSAGE_UNIVARIATE_NUMOBS_MISMATCH]
en: Univariate regression : The observation count in X and Y must match.
en-GB: Univariate regression : The observation count in x and y must match.

[ctx: STR_MESSAGE_YVARIABLE_MULTI_COLUMN]
en: Y variable range cannot have more than 1 column.
en-GB: y-Variable range cannot have more than 1 column.

[ctx: STR_MESSAGE_YVARIABLE_MULTI_ROW]
en: Y variable range cannot have more than 1 row.
en-GB: y-Variable range cannot have more than 1 row.

[ctx: STR_MSSG_MAKEAUTOFILTER_0]
en: The range does not contain column headers.
    Do you want the first line to be used as column header?
en-GB: The range does not contain column headers.
    Do you want the first line to be used as column headers?

[ctx: STR_NOCOLFORMULA]
en: Formulas don't form a column.
en-GB: Formulae don't form a column.

[ctx: STR_NOCOLROW]
en: Neither row or column specified.
en-GB: Neither row nor column specified.

[ctx: STR_NOROWFORMULA]
en: Formulas don't form a row.
en-GB: Formulae don't form a row.

[ctx: STR_QUICKHELP_DELETE]
en: Delete contents
en-GB: Delete content

[ctx: STR_SCATTR_PAGE_FORMULAS]
en: Formulas
en-GB: Formulae

[ctx: STR_SPELLING_BEGIN_TAB]
en: Should the spellcheck be continued at the beginning of the current sheet?
en-GB: Should the spell check be continued at the beginning of the current sheet?

[ctx: STR_SPELLING_STOP_OK]
en: The spellcheck of this sheet has been completed.
en-GB: The spell check of this sheet has been completed.

[ctx: STR_UNDO_DRAGDROP]
en: Drag and Drop
en-GB: Drag-and-Drop

[ctx: STR_UNDO_SET_MULTI_TAB_BG_COLOR]
en: Color Tabs
en-GB: Colour Tabs

[ctx: STR_UNDO_SET_TAB_BG_COLOR]
en: Color Tab
en-GB: Colour Tab

[ctx: STR_UNDO_SPELLING]
en: Spellcheck
en-GB: Spell check

[ctx: SparklineDialog|checkBox_DisplayX]
en: Display X axis
en-GB: Display x-Axis

[ctx: SparklineDialog|label_Colors]
en: Colors
en-GB: Colours

[ctx: advancedfilterdialog|case]
en: _Case sensitive
en-GB: _Case-sensitive

[ctx: advancedfilterdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: advancedfilterdialog|extended_tip|case]
en: Distinguishes between uppercase and lowercase letters when filtering the data.
en-GB: Distinguishes between upper-case and lower-case letters when filtering the data.

[ctx: advancedfilterdialog|extended_tip|copyresult]
en: Select the check box, and then select the cell range where you want to display the filter results.
en-GB: Mark the check box, and then select the cell range in which you want to display the filter results.

[ctx: advancedfilterdialog|extended_tip|destpers]
en: Select the Copy results to check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range.
en-GB: Mark the Copy results to check box, and then specify the destination range in which you want to display the filtered data. If this check box is marked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range.

[ctx: advancedfilterdialog|extended_tip|edcopyarea]
en: Select the check box, and then select the cell range where you want to display the filter results.
en-GB: Mark the check box, and then select the cell range in which you want to display the filter results.

[ctx: advancedfilterdialog|extended_tip|lbcopyarea]
en: Select the check box, and then select the cell range where you want to display the filter results.
en-GB: Mark the check box, and then select the cell range in which you want to display the filter results.

[ctx: advancedfilterdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: advancedfilterdialog|extended_tip|rbcopyarea]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: advancedfilterdialog|extended_tip|rbfilterarea]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: autoformattable|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: autoformattable|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: autoformattable|extended_tip|rename]
en: Opens a dialog where you can change the name of the selected AutoFormat.
en-GB: Opens a dialogue box where you can change the name of the selected AutoFormat.

[ctx: cellprotectionpage|extended_tip|checkHideAll]
en: Hides formulas and contents of the selected cells.
en-GB: Hides formulae and contents of the selected cells.

[ctx: cellprotectionpage|extended_tip|checkHideFormula]
en: Hides formulas in the selected cells.
en-GB: Hides formulae in the selected cells.

[ctx: condformatmanager|extended_tip|CondFormatManager]
en: This dialog allows you to see all the conditional formatting defined in the spreadsheet.
en-GB: This dialogue box allows you to see all the conditional formatting defined in the spreadsheet.

[ctx: conditionalentry|colorformat]
en: Color Scale (2 Entries)
en-GB: Colour Scale (2 Entries)

[ctx: conditionalentry|colorformat]
en: Color Scale (3 Entries)
en-GB: Colour Scale (3 Entries)

[ctx: conditionalentry|iconsettype]
en: 3 Colored Smileys
en-GB: 3 Coloured Smileys

[ctx: conditionalentry|iconsettype]
en: 3 Gray Arrows
en-GB: 3 Grey Arrows

[ctx: conditionalentry|iconsettype]
en: 4 Gray Arrows
en-GB: 4 Grey Arrows

[ctx: conditionalentry|iconsettype]
en: 5 Gray Arrows
en-GB: 5 Grey Arrows

[ctx: conditionalformatdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: conditionalformatdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: conditionalformatdialog|extended_tip|rbassign]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: consolidatedialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: consolidatedialog|extended_tip|eddestarea]
en: Displays the first cell in the range where the consolidation results will be displayed.
en-GB: Displays the first cell in the range in which the consolidation results will be displayed.

[ctx: consolidatedialog|extended_tip|lbdestarea]
en: Displays the first cell in the range where the consolidation results will be displayed.
en-GB: Displays the first cell in the range in which the consolidation results will be displayed.

[ctx: consolidatedialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: consolidatedialog|extended_tip|rbdataarea]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: consolidatedialog|extended_tip|rbdestarea]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: databaroptions|extended_tip|fill_type]
en: Select if the fill in color is solid or gradient.
en-GB: Select if the fill in colour is solid or gradient.

[ctx: databaroptions|extended_tip|positive_colour]
en: Select the color for the positive values
en-GB: Select the colour for the positive values

[ctx: databaroptions|fill_type]
en: Color
en-GB: Colour

[ctx: databaroptions|label2]
en: Bar Colors
en-GB: Bar Colours

[ctx: databaroptions|label9]
en: Color of vertical axis:
en-GB: Colour of vertical axis:

[ctx: datafielddialog|extended_tip|expander]
en: Expands or reduces the dialog. The More button is visible for data fields only.
en-GB: Expands or reduces the dialogue box. The More button is visible for data fields only.

[ctx: datafieldoptionsdialog|extended_tip|ascending]
en: Sorts the values from the lowest value to the highest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.
en-GB: Sorts the values from the lowest value to the highest value. If the selected field is the field for which the dialogue box was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.

[ctx: datafieldoptionsdialog|extended_tip|descending]
en: Sorts the values descending from the highest value to the lowest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.
en-GB: Sorts the values descending from the highest value to the lowest value. If the selected field is the field for which the dialogue box was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.

[ctx: datbaroptions|extended_tip|axis_colour]
en: Set the color of the vertical axis
en-GB: Set the colour of the vertical axis

[ctx: datbaroptions|extended_tip|negative_colour]
en: Select the color for the negative values
en-GB: Select the colour for the negative values

[ctx: definedatabaserangedialog|extended_tip|assign]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: definedatabaserangedialog|extended_tip|assignrb]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: definedatabaserangedialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: definedatabaserangedialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: definename|extended_tip|DefineNameDialog]
en: Opens a dialog where you can specify a name for a selected area or a name for a formula expression.
en-GB: Opens a dialogue box where you can specify a name for a selected area or a name for a formula expression.

[ctx: deletecontents|DeleteContentsDialog]
en: Delete Contents
en-GB: Delete Content

[ctx: deletecontents|extended_tip|datetime]
en: Deletes date and time values. Formats, text, numbers and formulas remain unchanged.
en-GB: Deletes date and time values. Formats, text, numbers and formulae remain unchanged.

[ctx: deletecontents|extended_tip|formulas]
en: Deletes formulas. Text, numbers, formats, dates and times remain unchanged.
en-GB: Deletes formulae. Text, numbers, formats, dates and times remain unchanged.

[ctx: deletecontents|extended_tip|numbers]
en: Deletes numbers only. Formats and formulas remain unchanged.
en-GB: Deletes numbers only. Formats and formulae remain unchanged.

[ctx: deletecontents|extended_tip|text]
en: Deletes text only. Formats, formulas, numbers and dates are not affected.
en-GB: Deletes text only. Formats, formulae, numbers and dates are not affected.

[ctx: deletecontents|formulas]
en: _Formulas
en-GB: _Formulae

[ctx: erroralerttabpage|extended_tip|browseBtn]
en: Opens the Macro dialog where you can select the macro that is executed when invalid data is entered in a cell. The macro is executed after the error message is displayed.
en-GB: Opens the Macro dialogue box in which you can select the macro that is executed when invalid data is entered in a cell. The macro is executed after the error message is displayed.

[ctx: extended_tip|OptChangesPage]
en: The Changes dialog specifies various options for highlighting recorded changes in documents.
en-GB: The Changes dialogue box specifies various options for highlighting recorded changes in documents.

[ctx: extended_tip|OptSortLists]
en: All user-defined lists are displayed in the Sort Lists dialog. You can also define and edit your own lists. Only text can be used as sort lists, no numbers.
en-GB: All user-defined lists are displayed in the Sort Lists dialogue box. You can also define and edit your own lists. Only text can be used as sort lists, no numbers.

[ctx: extended_tip|annot]
en: Specifies that a small rectangle in the top right corner of the cell indicates that a comment exists. The comment will be shown only when you enable tips under %PRODUCTNAME - General in the Options dialog box.
en-GB: Specifies that a small rectangle in the top right corner of the cell indicates that a comment exists. The comment will be shown only when you enable tips under %PRODUCTNAME - General in the Options dialogue box.

[ctx: extended_tip|case]
en: Specifies whether to distinguish between upper and lower case in texts when comparing cell contents.
en-GB: Specifies whether to distinguish between upper- and lower-case in text strings when comparing cell content.

[ctx: extended_tip|changes]
en: Specifies the color for changes of cell contents.
en-GB: Specifies the colour for changes of cell contents.

[ctx: extended_tip|columns]
en: Select the Columns option to summarize the contents of the selected columns in a list.
en-GB: Select the Columns option to summarise the contents of the selected columns in a list.

[ctx: extended_tip|copy]
en: Copies the contents of the cells in the Copy list from box. If you select a reference to related rows and columns, the Copy List dialog appears after clicking the button. You can use this dialog to define if the reference is converted to sort lists by row or by column.
en-GB: Copies the contents of the cells in the Copy list from box. If you select a reference to related rows and columns, the Copy List dialogue box appears after clicking the button. You can use this dialogue box to define if the reference is converted to sort lists by row or by column.

[ctx: extended_tip|deletions]
en: Specifies the color to highlight deletions in a document.
en-GB: Specifies the colour to highlight deletions in a document.

[ctx: extended_tip|entries]
en: Specifies the color to highlight moved cell contents.
en-GB: Specifies the colour to highlight moved cell contents.

[ctx: extended_tip|formula]
en: Specifies whether to show formulas instead of results in the cells.
en-GB: Specifies whether to show formulae instead of results in the cells.

[ctx: extended_tip|grid]
en: Specifies when grid lines will be displayed. Default is to display grid lines only on cells that do not have a background color. You can choose to also display grid lines on cells with background color, or to hide them.
en-GB: Specifies when grid lines will be displayed. Default is to display grid lines only on cells that do not have a background colour. You can choose to also display grid lines on cells with background colour, or to hide them.

[ctx: extended_tip|insertions]
en: Specifies the color to highlight insertions in a document.
en-GB: Specifies the colour to highlight insertions in a document.

[ctx: extended_tip|iterate]
en: Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions.
en-GB: Specifies whether formulae with iterative references (formulae that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions.

[ctx: extended_tip|printCB]
en: Specifies that only contents from selected sheets are printed, even if you specify a wider range in the File - Print dialog or in the Format - Print Ranges dialog. Contents from sheets that are not selected will not be printed.
en-GB: Specifies that only contents from selected sheets are printed, even if you specify a wider range in the File - Print dialogue box or in the Format - Print Ranges dialogue box. Contents from sheets that are not selected will not be printed.

[ctx: extended_tip|rangefind]
en: Specifies that each reference is highlighted in color in the formula. The cell range is also enclosed by a colored border as soon as the cell containing the reference is selected for editing.
en-GB: Specifies that each reference is highlighted in colour in the formula. The cell range is also enclosed by a coloured border as soon as the cell containing the reference is selected for editing.

[ctx: extended_tip|rows]
en: Select the Rows option to summarize the contents of the selected rows in a list.
en-GB: Select the Rows option to summarise the contents of the selected rows in a list.

[ctx: extended_tip|synczoom]
en: If checked, all sheets are shown with the same zoom factor. If not checked, each sheet can have its own zoom factor.
en-GB: If marked, all sheets are shown with the same zoom factor. If not marked, each sheet can have its own zoom factor.

[ctx: extended_tip|value]
en: Mark the Value highlighting box to show the cell contents in different colors, depending on type. Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted.
en-GB: Mark the Value highlighting box to show the cell contents in different colours, depending on type. Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted.

[ctx: externaldata|extended_tip|browse]
en: Open a file dialog to locate the file containing the data you want to insert.
en-GB: Open a file dialogue box to locate the file containing the data you want to insert.

[ctx: filldlg|extended_tip|FillSeriesDialog]
en: Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.
en-GB: Automatically generate series with the options in this dialogue box. Determine direction, increment, time unit and series type.

[ctx: filldlg|extended_tip|increment]
en: Determines the value by which the series of the selected type increases by each step.
en-GB: Determines the value by which the series of the selected type is increased each step.

[ctx: filtersubdropdown|background]
en: Background Color
en-GB: Background Colour

[ctx: filtersubdropdown|textcolor]
en: Font Color
en-GB: Font Colour

[ctx: fourieranalysisdialog|extended_tip|FourierAnalysisDialog]
en: Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.
en-GB: Produces the Fourier analysis of a data set by computing the  Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.

[ctx: goalseekdlg|extended_tip|GoalSeekDialog]
en: Opens a dialog where you can solve an equation with a variable.
en-GB: Opens a dialogue box in which you can solve an equation with a variable.

[ctx: goalseekdlg|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: goalseekdlg|extended_tip|formulabutton]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: goalseekdlg|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: goalseekdlg|extended_tip|varbutton]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: headerfootercontent|extended_tip|buttonBTN_TEXT]
en: Opens a dialog to assign formats to new or selected text.
en-GB: Opens a dialogue box to assign formats to new or selected text.

[ctx: headerfootercontent|extended_tip|textviewWND_CENTER]
en: Enter the text to be displayed at the center of the header or footer.
en-GB: Enter the text to be displayed at the centre of the header or footer.

[ctx: headerfootercontent|labelFT_CENTER]
en: _Center area
en-GB: _Centre area

[ctx: headerfootercontent|labelSTR_HF_CUSTOMIZED]
en: Customized
en-GB: Customised

[ctx: imoptdialog|extended_tip|asshown]
en: Enabled by default, data will be saved as displayed, including applied number formats. If this checkbox is not marked, raw data content will be saved, as in older versions of the software.
en-GB: Enabled by default, data will be saved as displayed, including applied number formats. If this check box is not marked, raw data content will be saved, as in older versions of the software.

[ctx: imoptdialog|formulas]
en: Save cell fo_rmulas instead of calculated values
en-GB: Save cell fo_rmulae instead of calculated values

[ctx: inputstringdialog|extended_tip|InputStringDialog]
en: This command opens a dialog where you can assign a different name to the current sheet.
en-GB: This command opens a dialogue box in which you can assign a different name to the current sheet.

[ctx: insertcells|extended_tip|InsertCellsDialog]
en: Opens the Insert Cells dialog, in which you can insert new cells according to the options that you specify.
en-GB: Opens the Insert Cells dialogue box, in which you can insert new cells according to the options that you specify.

[ctx: insertcells|extended_tip|down]
en: Moves the contents of the selected range downward when cells are inserted.
en-GB: Moves the contents of the selected range downwards when cells are inserted.

[ctx: insertsheet|extended_tip|browse]
en: Opens a dialog for selecting a file.
en-GB: Opens a file selection dialogue box.

[ctx: insertsheet|extended_tip|new]
en: Creates a new sheet. Enter a sheet name in the Name field. Allowed characters are letters, numbers, spaces, and the underline character.
en-GB: Creates a new sheet. Enter a sheet name in the Name field. Allowed characters are letters, numbers, spaces and the underline character.

[ctx: managenamesdialog|extended_tip|ManageNamesDialog]
en: Opens a dialog where you can specify a name for a selected area or a name for a formula expression.
en-GB: Opens a dialogue box where you can specify a name for a selected area or a name for a formula expression.

[ctx: managenamesdialog|extended_tip|assign]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: managenamesdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: managenamesdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: mergecellsdialog|extended_tip|MergeCellsDialog]
en: Combines the selected cells into a single cell or splits merged cells. Aligns cell content centered.
en-GB: Combines the selected cells into a single cell or splits merged cells. Aligns cell content centred.

[ctx: multipleoperationsdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: multipleoperationsdialog|extended_tip|colref]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: multipleoperationsdialog|extended_tip|formulas]
en: Enter the cell references for the cells containing the formulas that you want to use in the multiple operation.
en-GB: Enter the cell references for the cells containing the formulae that you want to use in the multiple operation.

[ctx: multipleoperationsdialog|extended_tip|formulasref]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: multipleoperationsdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: multipleoperationsdialog|extended_tip|rowref]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: multipleoperationsdialog|formulasft]
en: _Formulas:
en-GB: _Formulae:

[ctx: namerangesdialog|extended_tip|NameRangesDialog]
en: Opens a dialog in which you can define a label range.
en-GB: Opens a dialogue box in which you can define a label range.

[ctx: namerangesdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: namerangesdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: namerangesdialog|extended_tip|rbassign]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: namerangesdialog|extended_tip|rbassign2]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: navigatorpanel|extended_tip|dragmode]
en: Opens a submenu for selecting the drag mode. You decide which action is performed when dragging and dropping an object from the Navigator into a document. Depending on the mode you select, the icon indicates whether a hyperlink, link or a copy is created.
en-GB: Opens a sub-menu for selecting the drag mode. You decide which action is performed when dragging and dropping an object from the Navigator into a document. Depending on the mode you select, the icon indicates whether a hyperlink, link or a copy is created.

[ctx: notebookbar_groupedbar_compact|3Db]
en: 3_D
en-GB: 3-_D

[ctx: notebookbar_groupedbar_compact|formatb]
en: F_ont
en-GB: St_yles

[ctx: notebookbar_groupedbar_full|3Db]
en: 3_D
en-GB: 3-_D

[ctx: notebookbar_groupedbar_full|colorb]
en: C_olor
en-GB: C_olour

[ctx: notebookbar_groups|centerb]
en: Center
en-GB: Centre

[ctx: notebookbar_groups|vcenterb]
en: Center
en-GB: Centre

[ctx: optcalculatepage|case]
en: Case se_nsitive
en-GB: Case-se_nsitive

[ctx: optcalculatepage|case|tooltip_text]
en: Disable case sensitivity for interoperability with Microsoft Excel
en-GB: Disable case-sensitivity for interoperability with Microsoft Excel

[ctx: optcalculatepage|formulaliteral]
en: No wildcards or regular expressions in formulas
en-GB: No wildcards or regular expressions in formulae

[ctx: optcalculatepage|formularegex]
en: Enable r_egular expressions in formulas
en-GB: Enable r_egular expressions in formulae

[ctx: optcalculatepage|formulawildcards]
en: Enable w_ildcards in formulas
en-GB: Enable w_ildcards in formulae

[ctx: optcalculatepage|label5]
en: Formulas Wildcards
en-GB: Formulae Wildcards

[ctx: optchangespage|label1]
en: Colors for Changes
en-GB: Colours for Changes

[ctx: pastespecial|extended_tip|none]
en: Does not apply an operation when you insert the cell range from the clipboard. The contents of the clipboard will replace existing cell contents.
en-GB: Does not apply an operation when you insert the cell range from the clipboard. The content of the clipboard will replace existing cell content.

[ctx: pastespecial|extended_tip|objects]
en: Inserts objects contained within the selected cell range. These can be OLE objects, chart objects, or drawing objects.
en-GB: Inserts objects contained within the selected cell range. These can be OLE objects, chart objects or drawing objects.

[ctx: pastespecial|extended_tip|paste_all]
en: Pastes all cell contents, comments, formats, and objects into the current document.
en-GB: Pastes all cell content, comments, formats and objects into the current document.

[ctx: pastespecial|extended_tip|paste_values_formats]
en: Pastes cell values, formula results and formats applied to cells.
en-GB: Pastes cell values, formula results, and formats applied to cells.

[ctx: pastespecial|extended_tip|paste_values_only]
en: Pastes numbers, text, dates and the results of formulas.
en-GB: Pastes numbers, text, dates, and the results of formulae.

[ctx: pastespecial|formulas]
en: Formulas
en-GB: Formulae

[ctx: pivotfielddialog|extended_tip|options]
en: Opens the Data Field Options dialog. The Options button is visible for filters and column or row fields only.
en-GB: Opens the Data Field Options dialogue box. The Options button is visible for filters and column or row fields only.

[ctx: pivotfilterdialog|case]
en: _Case sensitive
en-GB: _Case-sensitive

[ctx: pivotfilterdialog|extended_tip|case]
en: Distinguishes between uppercase and lowercase letters.
en-GB: Distinguishes between upper-case and lower-case letters.

[ctx: pivottablelayoutdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: pivottablelayoutdialog|extended_tip|check-drill-to-details]
en: Select this check box and double-click an item label in the table to show or hide details for the item. Clear this check box and double-click a cell in the table to edit the contents of the cell.
en-GB: Mark this check box and double-click an item label in the table to show or hide details of the item. Unmark this check box and double-click a cell in the table to edit the contents of the cell.

[ctx: pivottablelayoutdialog|extended_tip|destination-button]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: pivottablelayoutdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: printareasdialog|extended_tip|PrintAreasDialog]
en: Opens a dialog where you can specify the print range.
en-GB: Opens a dialogue box in which you can specify the print range.

[ctx: printareasdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: printareasdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: printareasdialog|extended_tip|rbprintarea]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: printareasdialog|extended_tip|rbrepeatcol]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: printareasdialog|extended_tip|rbrepeatrow]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: randomnumbergenerator|distribution-liststore]
en: Chi Squared
en-GB: Chi-squared

[ctx: randomnumbergenerator|extended_tip|seed-spin]
en: Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature.
en-GB: Value set to initiate the random number generator algorithm. It is used to initialise (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence or leave the field blank if you don't need this particular feature.

[ctx: regressiondialog|variable1-range-label]
en: Independent variable(s) (X) range:
en-GB: Independent variable(s) (x) range:

[ctx: regressiondialog|variable2-range-label]
en: Dependent variable (Y) range:
en-GB: Dependent variable (y) range:

[ctx: regressiondialog|withlabels-check]
en: Both X and Y ranges have labels
en-GB: Both x- and y-ranges have labels

[ctx: scenariodialog|extended_tip|bordercolor]
en: Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.
en-GB: Highlights the scenario in your table with a border. The colour for the border is specified in the field to the right of this option.

[ctx: scenariodialog|extended_tip|copyback]
en: Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes settings.
en-GB: Copies the values of cells that you change into the active scenario. If you do not mark this check box, the scenario is not changed when you change cell values. The behaviour of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes settings.

[ctx: scenariodialog|extended_tip|preventchanges]
en: Prevents changes to the active scenario. The behavior of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes settings.
en-GB: Prevents changes to the active scenario. The behaviour of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes settings.

[ctx: scenariodialog|extended_tip|showframe]
en: Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.
en-GB: Highlights the scenario in your table with a border. The colour for the border is specified in the field to the right of this option.

[ctx: scenariomenu|edit]
en: Properties...
en-GB: Properties…

[ctx: scenariomenu|extended_tip|edit]
en: Opens the Edit scenario dialog, where you can edit the scenario properties.
en-GB: Opens the Edit scenario dialogue box, where you can edit the scenario properties.

[ctx: searchresults|ShowBox]
en: _Show this dialog
en-GB: _Show this dialogue box

[ctx: selectdatasource|extended_tip|type]
en: Click the source type of for the selected data source.
en-GB: Click the source type for the selected data source.

[ctx: selectrange|extended_tip|treeview]
en: Lists the available database ranges. To select a database range, click its name, and then click OK.
en-GB: Lists the available database ranges. To select a database range in your spreadsheet, click its name, and then click OK.

[ctx: selectsource|extended_tip|SelectSourceDialog]
en: Opens a dialog where you can select the source for your pivot table, and then create your table.
en-GB: Opens a dialogue box where you can select the source for your pivot table, and then create your table.

[ctx: selectsource|extended_tip|external]
en: Opens the External Source dialog where you can select the OLAP data source for the pivot table.
en-GB: Opens the External Source dialogue box where you can select the OLAP data source for the pivot table.

[ctx: sharedocumentdlg|warning]
en: Note: Changes to formatting attributes like fonts, colors, and number formats will not be saved and some functionalities like editing charts and drawing objects are not available in shared mode. Turn off shared mode to get exclusive access needed for those changes and functionalities.
en-GB: Note: Changes to formatting attributes like fonts, colours and number formats will not be saved and some functionalities like editing charts and drawing objects are not available in shared mode. Turn off shared mode to get exclusive access needed for those changes and functionalities.

[ctx: sharedwarningdialog|SharedWarningDialog]
en: Changes to formatting attributes like fonts, colors, and number formats will not be saved and some functionalities like editing charts and drawing objects are not available in shared mode. Turn off shared mode to get exclusive access needed for those changes and functionalities.
en-GB: Changes to formatting attributes like fonts, colours and number formats will not be saved and some functionalities like editing charts and drawing objects are not available in shared mode. Turn off shared mode to get exclusive access needed for those changes and functionalities.

[ctx: sheetprintpage|checkBTN_FORMULAS]
en: _Formulas
en-GB: _Formulae

[ctx: sheetprintpage|extended_tip|checkBTN_FORMULAS]
en: Prints the formulas contained in the cells, instead of the results.
en-GB: Prints the formulae contained in the cells, instead of the results.

[ctx: sheetprintpage|extended_tip|checkBTN_PAGENO]
en: Select this option if you want the first page to start with a number other than 1.
en-GB: Mark this check box if you want the first page to start with a number other than 1.

[ctx: showdetaildialog|extended_tip|dimsTreeview]
en: Choose the field that you want to view the details for.
en-GB: Choose the field for which you want to view details.

[ctx: sidebarcellappearance|borderlinecolor-atkobject]
en: Border Line Color
en-GB: Border Line Colour

[ctx: sidebarcellappearance|borderlinecolor|tooltip_text]
en: Select the line color of the borders.
en-GB: Select the line colour of the borders.

[ctx: sidebarcellappearance|cellbackgroundcolor|tooltip_text]
en: Select the background color of the selected cells.
en-GB: Select the background colour of the selected cells.

[ctx: sidebarcellappearance|cellbackground|tooltip_text]
en: Select the background color of the selected cells.
en-GB: Select the background colour of the selected cells.

[ctx: sidebarcellappearance|linecolor|tooltip_text]
en: Select the line color of the borders.
en-GB: Select the line colour of the borders.

[ctx: sidebarnumberformat|leadingzeroes-atkobject]
en: Leading Zeroes
en-GB: Leading Zeros

[ctx: sidebarnumberformat|leadingzeroeslabel]
en: Leading _zeroes:
en-GB: Leading _zeros:

[ctx: sidebarnumberformat|leadingzeroes|tooltip_text]
en: Enter the maximum number of zeroes to display before the decimal point.
en-GB: Enter the maximum number of zeros to display before the decimal point.

[ctx: sidebarnumberformat|negativenumbersred|tooltip_text]
en: Changes the font color of negative numbers to red.
en-GB: Changes the font colour of negative numbers to red.

[ctx: solverdlg|extended_tip|SolverDialog]
en: Opens the Solver dialog. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.
en-GB: Opens the Solver dialogue box. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.

[ctx: solverdlg|extended_tip|targetedit]
en: Enter or click the cell reference of the target cell. This field takes the address of the cell whose value is to be optimized.
en-GB: Enter or click the cell reference of the target cell. This field takes the address of the cell whose value is to be optimised.

[ctx: solverdlg|result]
en: Optimize result to
en-GB: Optimise result to

[ctx: solveroptionsdialog|extended_tip|edit]
en: If the current entry in the Settings listbox allows you to edit a value, you can click the Edit button. A dialog opens where you can change the value.
en-GB: If the current entry in the Settings list box allows you to edit a value, you can click the Edit button. A dialogue box opens where you can change the value.

[ctx: solveroptionsdialog|extended_tip|engine]
en: Select a solver engine. The listbox is disabled if only one solver engine is installed.
en-GB: Select a solver engine. The list box is disabled if only one solver engine is installed.

[ctx: sortoptionspage|extended_tip|naturalsort]
en: Natural sort is a sort algorithm that sorts string-prefixed numbers based on the value of the numerical element in each sorted number, instead of the traditional way of sorting them as ordinary strings.
en-GB: Natural sort is a sort algorithm that sorts string-prefixed numbers based on the value of the numeric element in each sorted number, instead of the traditional way of sorting them as ordinary strings.

[ctx: sortwarning|sorttip]
en: Tip: The sort range can be detected automatically. Place the cell cursor inside a list and execute sort. The whole range of neighboring non-empty cells will then be sorted.
en-GB: Tip: The sort range can be detected automatically. Place the cell cursor inside a list and execute sort. The whole range of neighbouring non-empty cells will then be sorted.

[ctx: standardfilterdialog|case]
en: _Case sensitive
en-GB: _Case-sensitive

[ctx: standardfilterdialog|cond]
en: Background color
en-GB: Background colour

[ctx: standardfilterdialog|cond]
en: Font color
en-GB: Font colour

[ctx: standardfilterdialog|extended_tip|cancel]
en: Closes dialog and discards all changes.
en-GB: Closes dialogue box and discards all changes.

[ctx: standardfilterdialog|extended_tip|case]
en: Distinguishes between uppercase and lowercase letters when filtering the data.
en-GB: Distinguishes between upper-case and lower-case letters when filtering the data.

[ctx: standardfilterdialog|extended_tip|copyresult]
en: Select the check box, and then select the cell range where you want to display the filter results.
en-GB: Mark the check box, and then select the cell range in which you want to display the filter results.

[ctx: standardfilterdialog|extended_tip|destpers]
en: Select the Copy results to check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range.
en-GB: Mark the Copy results to check box, and then specify the destination range in which you want to display the filtered data. If this check box is marked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range.

[ctx: standardfilterdialog|extended_tip|edcopyarea]
en: Select the check box, and then select the cell range where you want to display the filter results.
en-GB: Mark the check box, and then select the cell range in which you want to display the filter results.

[ctx: standardfilterdialog|extended_tip|lbcopyarea]
en: Select the check box, and then select the cell range where you want to display the filter results.
en-GB: Mark the check box, and then select the cell range in which you want to display the filter results.

[ctx: standardfilterdialog|extended_tip|ok]
en: Saves all changes and closes dialog.
en-GB: Saves all changes and closes dialogue box.

[ctx: standardfilterdialog|extended_tip|rbcopyarea]
en: Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
en-GB: Click the Shrink icon to reduce the dialogue box to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximise icon. Click it to restore the dialogue box to its original size.

[ctx: subtotalgrppage|extended_tip|group_by]
en: Select the column that you want to control the subtotal calculation process. If the contents of the selected column change, the subtotals are automatically recalculated.
en-GB: Select the column that you want to control the subtotal calculation process. If the contents of the selected column changes, the subtotals are automatically recalculated.

[ctx: subtotaloptionspage|case]
en: _Case sensitive
en-GB: _Case-sensitive

[ctx: subtotaloptionspage|extended_tip|lbuserdef]
en: Uses a custom sorting order that you defined in the Options dialog box at %PRODUCTNAME Calc - Sort Lists.
en-GB: Uses a custom sorting order that you defined in the Options dialogue box at %PRODUCTNAME Calc - Sort Lists.

[ctx: subtotaloptionspage|extended_tip|pagebreak]
en: Inserts a new page after each group of subtotaled data.
en-GB: Inserts a new page after each group of subtotalled data.

[ctx: textimportcsv|evaluateformulas]
en: If enabled, cells starting with '=' will be evaluated as formulas.
en-GB: If enabled, cells starting with '=' will be evaluated as formulae.

[ctx: texttransformation_type|capitalize]
en: Capitalize
en-GB: Capitalise

[ctx: tpviewpage|formula]
en: _Formulas
en-GB: _Formulae

[ctx: tpviewpage|grid]
en: Show on colored cells
en-GB: Show on coloured cells

[ctx: tpviewpage|rangefind]
en: _Show references in color
en-GB: _Show references in colour

[ctx: tpviewpage|synczoom]
en: S_ynchronize sheets
en-GB: S_ynchronise sheets

[ctx: validationcriteriapage|extended_tip|sortascend]
en: Sorts the selection list in ascending order and filters duplicates from the list. If not checked, the order from the data source is taken.
en-GB: Sorts the selection list in ascending order and filters duplicates from the list. If not marked, the order is taken from the data source.
