|
621.
|
|
|
@FUNCTION=T
@SYNTAX=T(value)
@DESCRIPTION=T returns @value if and only if it is text, otherwise a blank string.
* This function is Excel compatible.
@EXAMPLES=
T("text") equals "text".
T(64) returns an empty cell.
@SEEALSO=CELL, N, VALUE
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
622.
|
|
|
@FUNCTION=TEXT
@SYNTAX=TEXT(value,format_text)
@DESCRIPTION=TEXT returns @value as a string with the specified format.
* This function is Excel compatible.
@EXAMPLES=
TEXT(3.223,"$0.00") equals "$3.22".
TEXT(date(1999,4,15),"mmmm, dd, yy") equals "April, 15, 99".
@SEEALSO=DOLLAR, FIXED, VALUE
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
623.
|
|
|
@FUNCTION=TRIM
@SYNTAX=TRIM(text)
@DESCRIPTION=TRIM returns @text with only single spaces between words.
* This function is Excel compatible.
@EXAMPLES=
TRIM(" a bbb cc") equals "a bbb cc".
@SEEALSO=CLEAN, MID, REPLACE, SUBSTITUTE
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
624.
|
|
|
@FUNCTION=VALUE
@SYNTAX=VALUE(text)
@DESCRIPTION=VALUE returns numeric value of @text.
* This function is Excel compatible.
@EXAMPLES=
VALUE("$1,000") equals 1000.
@SEEALSO=DOLLAR, FIXED, TEXT
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
625.
|
|
|
@FUNCTION=SUBSTITUTE
@SYNTAX=SUBSTITUTE(text, old, new [,num])
@DESCRIPTION=SUBSTITUTE replaces @old with @new in @text. Substitutions are only applied to instance @num of @old in @text, otherwise every one is changed.
* This function is Excel compatible.
@EXAMPLES=
SUBSTITUTE("testing","test","wait") equals "waiting".
@SEEALSO=REPLACE, TRIM
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
626.
|
|
|
@FUNCTION=DOLLAR
@SYNTAX=DOLLAR(num[,decimals])
@DESCRIPTION=DOLLAR returns @num formatted as currency.
* This function is Excel compatible.
@EXAMPLES=
DOLLAR(12345) equals "$12,345.00".
@SEEALSO=FIXED, TEXT, VALUE
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
627.
|
|
|
@FUNCTION=SEARCH
@SYNTAX=SEARCH(search_string,text[,start_num])
@DESCRIPTION=SEARCH returns the location of the @search_ string within @text. The search starts with the @start_num character of text @text. If @start_num is omitted, it is assumed to be one. The search is not case sensitive.
@search_string can contain wildcard characters (*) and question marks (?). A question mark matches any character and a wildcard matches any string including the empty string. If you want the actual wildcard or question mark to be found, use tilde (~) before the character.
* If @search_string is not found, SEARCH returns #VALUE! error.
* If @start_num is less than one or it is greater than the length of @text, SEARCH returns #VALUE! error.
* This function is Excel compatible.
@EXAMPLES=
SEARCH("c","Cancel") equals 1.
SEARCH("c","Cancel",2) equals 4.
@SEEALSO=FIND
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
628.
|
|
|
@FUNCTION=ASC
@SYNTAX=ASC(string)
@DESCRIPTION=ASC a compatibility function that is meaningless in Gnumeric. In MS Excel (tm) it converts 2 byte @string into single byte text.
@EXAMPLES=
CHAR("Foo") equals "Foo".
@SEEALSO=
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
../plugins/fn-string/functions.c:1220
|
|
629.
|
|
|
@FUNCTION=interpolation
@SYNTAX=interpolation(abscissas,ordinates,targets[,interpolation])
@DESCRIPTION=
interpolation returns interpolated values corresponding
to the given abscissa targets as a one column matrix.
@abscissas are the absicssas of the data to interpolate.
@ordinates are the ordinates of the data to interpolate.
* Strings and empty cells in @abscissas and @ordinates are simply ignored.
@targets are the abscissas of the interpolated data. If several data
are provided, they must be in the same column, in consecutive cells
@interpolation is the method to be used for the interpolation;
possible values are:
- 0: linear;
- 1: linear with averaging;
- 2: staircase;
- 3: staircase with averaging;
- 4: natural cubic spline;
- 5: natural cubic spline with averaging.
If an averaging method is used, the number of returned values
is one less than the number of targets since the evaluation is made by
averaging the interpolation over the interval between two consecutive data;
in that case, the targets values must be given in increasing order.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
630.
|
|
|
@FUNCTION=periodogram
@SYNTAX=periodogram(ordinates,[filter,[abscissas,[interpolation,[number]]]])
@DESCRIPTION=
periodogram returns the periodogram of the data
as a one column matrix.
@ordinates are the ordinates of the data to interpolate.
@filter gives the window function to be used. Possible values are:
- 0: no filter (rectangular window);
- 1: Bartlett (triangular window);
- 2: Hahn (cosine window);
- 3: Welch (parabolic window);
@abscissas are the absicssas of the data to interpolate. If no
abscissa is given, it is supposed that the data absicssas are regularly
spaced. Otherwise, an interpolation method will be used to evaluate
regularly spaced data.
* Strings and empty cells in @abscissas and @ordinates are simply ignored.
@interpolation is the method to be used for the interpolation;
possible values are:
- 0: linear;
- 1: linear with averaging;
- 2: staircase;
- 3: staircase with averaging;
- 4: natural cubic spline;
- 5: natural cubic spline with averaging.
@number is the number of interpolated data to be used. If not given,
a default number is automatically evaluated.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|