Ubuntu
gnumeric package

Browsing Brazilian Portuguese translation

  1. Karmic (9.10)
  2. Template “gnumeric-functions”
  3. Brazilian Portuguese (pt_BR)
Don't show this notice anymore
Before translating, be sure to go through Ubuntu Translators instructions and Brazilian Portuguese guidelines.
961 → 970 of 987 results First • • • Last
961.
@FUNCTION=REPLACE
@SYNTAX=REPLACE(old,start,num,new)
@DESCRIPTION=REPLACE returns @old with @new replacing @num characters from @start.

* This function is Excel compatible.

@EXAMPLES=
REPLACE("testing",2,3,"*****") equals "t*****ing".

@SEEALSO=MID, SEARCH, SUBSTITUTE, TRIM
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=REPLACE
@SYNTAX=REPLACE(antigo,início,num,novo)
@DESCRIPTION=REPLACE retorna @antigo com @novo substituindo @num caracteres a partir de @início.

* Esta função é compatível com o Excel.

@EXAMPLES=
REPLACE("testando",2,3,"*****") retorna "t*****ando".

@SEEALSO=MID, SEARCH, SUBSTITUTE, TRIM
Translated and reviewed by Afonso Celso Medina
962.
@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
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=T
@SYNTAX=T(valor)
@DESCRIPTION=T retorna @valor se e somente se ele for texto, caso contrário T retorna um texto vazio.

* Esta função é compatível com o Excel.

@EXAMPLES=
T("blah") retorna "blah".
T(64) retorna uma célula vazia.

@SEEALSO=CELL, N, VALUE
Translated and reviewed by Afonso Celso Medina
963.
@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
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=TEXT
@SYNTAX=TEXT(valor,formato_texto)
@DESCRIPTION=TEXT retorna @valor como um texto com o formato especificado.

* Esta função é compatível com o Excel.

@EXAMPLES=
TEXT(3.223,"$0.00") retorna "$3.22".
TEXT(date(1999,4,15),"dd mmmm yy") retorna "15 Abril 99".

@SEEALSO=DOLLAR, FIXED, VALUE
Translated and reviewed by Afonso Celso Medina
964.
@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
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=TRIM
@SYNTAX=TRIM(texto)
@DESCRIPTION=TRIM retorna @texto somente com espaços simples entre as palavras.

* Esta função é compatível com o Excel.

@EXAMPLES=
TRIM(" a bbb cc") retorna "a bbb cc".

@SEEALSO=CLEAN, MID, REPLACE, SUBSTITUTE
Translated and reviewed by Afonso Celso Medina
965.
@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
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=VALUE
@SYNTAX=VALUE(texto)
@DESCRIPTION=VALUE retorna o valor numérico de @texto.

* Esta função é compatível com o Excel.

@EXAMPLES=
VALUE("$1,000") retorna 1000.

@SEEALSO=DOLLAR, FIXED, TEXT
Translated and reviewed by Afonso Celso Medina
966.
@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
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=SUBSTITUTE
@SYNTAX=SUBSTITUTE(texto, antigo, novo [,núm])
@DESCRIPTION=SUBSTITUTE substitui @antigo por @novo em @texto. Substituições são aplicadas somente para instância @núm do @antigo no @texto, do contrário todos são alterados.

* Esta função é compatível com o Excel.

@EXAMPLES=
SUBSTITUTE("testando","test","esper") retorna "esperando".

@SEEALSO=REPLACE, TRIM
Translated and reviewed by Afonso Celso Medina
967.
@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
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=DOLLAR
@SYNTAX=DOLLAR(núm[,decimais])
@DESCRIPTION=DOLLAR retorna @núm formatado como valor monetário.

* Esta função é compatível com o Excel.

@EXAMPLES=
DOLLAR(12345) retorna "$12,345.00".

@SEEALSO=FIXED, TEXT, VALUE
Translated and reviewed by Afonso Celso Medina
968.
@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
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=SEARCH
@SYNTAX=SEARCH(texto_procurado,texto[,núm_início])
@DESCRIPTION=SEARCH retorna a posição de um caracter ou um texto dentro de um outro texto. @texto_procurado é o texto ou caractere a ser procurado. @texto é o texto no qual deseja-se procurar. @núm_início é a posição inicial da procura em @texto. Se @núm_início for omitido, assume-se igual a 1. A procura não é sensível a maiúsculas/minúsculas.

@texto_procurado pode conter caracteres curingas (*) e interrogações (?) para controlar a procura. Uma interrogação combina com qualquer caractere e combina com qualquer texto incluindo o texto vazio. Se você deseja que o caracter curinga ou interrogação sejam procurados, use o til (~) antes do caracter.

* Se @texto_procurado não for encontrado, SEARCH retorna o erro #VALOR!
* Se @núm_início for menor do que 1 ou maior do que o comprimento de @texto, SEARCH retorna o erro #VALOR!
* Esta função é compatível com o Excel.

@EXAMPLES=
SEARCH("c","Cancela") retorna 1.
SEARCH("c","Cancela",2) retorna 4.

@SEEALSO=FIND
Translated and reviewed by Afonso Celso Medina
969.
@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=
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
@FUNCTION=ASC
@SYNTAX=ASC(string)
@DESCRIPTION=ASC é uma função para manter compatibilidade que não tem uso no Gnumeric. No MS Excel (tm) ela converte uma @string de 2 byte em uma string de um byte de texto.

@EXAMPLES=
CHAR("Foo") retorna "Foo".

@SEEALSO=
Translated and reviewed by Afonso Celso Medina
Located in ../plugins/fn-string/functions.c:1220
970.
@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.
@EXAMPLES=

@SEEALSO=PERIODOGRAM
There are line breaks here. Each one represents a line break. Start a new line in the equivalent position in the translation.
There are leading/trailing spaces here. Each one represents a space character. Enter a space in the equivalent position in the translation.
(no translation yet)
961 → 970 of 987 results First • • • Last

This translation is managed by Ubuntu Brazilian Portuguese Translators, assigned by Ubuntu Translators.

You are not logged in. Please log in to work on translations.

Contributors to this translation: Afonso Celso Medina, André Gondim, Auro Florentino, Gandhi Alberto Schünemann, Gerson "fserve" Barreiros, Henrique P. Machado, Rogênio Belém, programad.