Translation

sf_calc.xhp par_id841592919903025 help.text
English JWFDb
Context English Portuguese (Brazil) Actions
sf_calc.xhp
par_id501611617808220
help.text
Activating a sheet makes sense only if it is performed on a Calc document. To make sure you have a Calc document at hand you can use the <literal>isCalc</literal> property of the document object, which returns <literal>True</literal> if it is a Calc document and <literal>False</literal> otherwise. Ativar a planilha faz sentido apenas se for executado em um documento Calc. Para garantir que você tem um documento Calc em mãos, você pode usar a propriedade <literal>isCalc</literal> do objeto do documento, a qual retorna <literal>True</literal> se é um documento Calc e <literal>False</literal> caso contrário.
sf_calc.xhp
par_id93158919969856
help.text
Returns either the list with the names of all chart objects in a given sheet or a single <literal>Chart</literal> service instance. Retorna a lista com os nomes de todos os objetos de gráfico em uma planilha ou uma instância do serviço <literal>Chart</literal>.
sf_calc.xhp
par_id371635438503202
help.text
If only <literal>sheetname</literal> is specified, a zero-based array of strings containing the names of all charts is returned. Se apenas <literal>sheetname</literal> for especificado, retorna um Array indexado a partir de zero contendo os nomes de todos os objetos de gráfico.
sf_calc.xhp
par_id371635438509045
help.text
If a <literal>chartname</literal> is provided, then a single object corresponding to the desired chart is returned. The specified chart must exist. Se o argumento <literal>chartname</literal> for fornecido, então um objeto único correspondente ao gráfico desejado é retornado. O gráfico especificado deve existir.
sf_calc.xhp
par_id821591631205026
help.text
<emph>sheetname</emph>: The name of the sheet from which the list of charts is to be retrieved or where the specified chart is located. <emph>sheetname</emph>: Nome da planilha da qual a lista de gráficos será obtida ou o nome da planilha onde o gráfico especificado está localizado.
sf_calc.xhp
par_id821591631203566
help.text
<emph>chartname</emph>: The user-defined name of the chart object to be returned. If the chart does not have a user-defined name, then the internal object name can be used. If this argument is absent, then the list of chart names in the specified sheet is returned. <emph>chartname</emph>: Nome definido pelo usuário do objeto de gráfico a ser retornado. Se o gráfico não tiver um nome definido pelo usuário, então o nome interno do objeto pode ser usado. Se este argumento não for fornecido, então a lista com os nomes dos gráficos da planilha especificada será retornada.
sf_calc.xhp
par_id431635438771588
help.text
Use the <menuitem>Navigator</menuitem> sidebar to check the names assigned to charts under the <menuitem>OLE objects</menuitem> category. Use o <menuitem>Navegador</menuitem> na barra lateral para verificar os nomes atribuídos a gráficos na categoria <menuitem>Objetos OLE</menuitem>.
sf_calc.xhp
par_id41635439328174
help.text
The example below shows the number of chart objects in "Sheet1". O exemplo abaixo mostra o número de objetos de gráfico na planilha "Sheet1".
sf_calc.xhp
par_id571635439417400
help.text
The following example accesses the chart named "MyChart" in "Sheet1" and prints its type. O exemplo a seguir acessa o gráfico chamado "MyChart" na planilha "Sheet1" e imprime seu tipo.
sf_calc.xhp
par_id31592919577984
help.text
Clears all the contents and formats of the given range. Limpa todos os conteúdos e formatos de um dado intervalo.
sf_calc.xhp
par_id441592919577809
help.text
<emph>range</emph>: The range to be cleared, as a string. <emph>range</emph>: O intervalo a ser limpo, como uma string.
sf_calc.xhp
par_id211592919864118
help.text
Clears the formats and styles in the given range. Limpa os formatos e estilos de um dado intervalo.
sf_calc.xhp
par_id611592919864268
help.text
<emph>range</emph>: The range whose formats and styles are to be cleared, as a string. <emph>range</emph>: Intervalo cujos formatos e estilos devem ser limpos, como uma string.
sf_calc.xhp
par_id841592919928169
help.text
Clears the values and formulas in the given range. Limpa os valores e fórmulas em um dado intervalo.
sf_calc.xhp
par_id771592919928320
help.text
<emph>range</emph>: The range whose values and formulas are to be cleared, as a string. <emph>range</emph>: Intervalo cujos valores e fórmulas devem ser limpos, como uma string.
sf_calc.xhp
par_id841592919903025
help.text
Deletes the columns of a specified range that match a filter expressed as a Calc formula. The filter is applied to each column to decide whether it will be deleted or not.
sf_calc.xhp
par_id601652269911029
help.text
The deleted column can be limited to the height of the specified range or span to the height of the entire sheet, thus deleting whole columns.
sf_calc.xhp
par_id701652271281106
help.text
This method returns a string with the range address of the compacted range. If all columns are deleted, then an empty string is returned.
sf_calc.xhp
par_id191652271892064
help.text
If a range of cells is selected, calling this method will not impact the selection.
sf_calc.xhp
par_id771592919922181
help.text
<emph>range</emph>: The range from which columns will be deleted, as a string.
sf_calc.xhp
par_id771592919932260
help.text
<emph>wholecolumn</emph>: If this option is set to <literal>True</literal> the entire column will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted column will be limited to the height of the specified <literal>range</literal>.
sf_calc.xhp
par_id771592919915974
help.text
<emph>filterformula</emph>: The filter to be applied to each column to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first column. When the formula returns <emph>True</emph> for a column, that column will be deleted. The default filter deletes all empty columns.
sf_calc.xhp
par_id361652271022647
help.text
For example, suppose range <emph>A1:J200</emph> is selected (height = 200), so the default formula is <emph>=(COUNTBLANK(A1:A200)=200)</emph>. This means that if all 200 cells are empty in the first column (Column A), then the column is deleted. Note that the formula is expressed with respect to the first column only. Internally the <literal>CompactLeft</literal> method will generalize this formula for all the remaining columns.
sf_calc.xhp
bas_id941652271391005
help.text
' Delete all empty columns in the range G1:L10 from Sheet1
sf_calc.xhp
bas_id691652271390762
help.text
newrange = oDoc.CompactLeft("Sheet1.G1:L10")
sf_calc.xhp
bas_id921652271392627
help.text
' The example below is similar, but the entire column is deleted from the sheet
sf_calc.xhp
bas_id941652271392873
help.text
newrange = oDoc.CompactLeft("Sheet1.G1:L10", WholeColumn := True)
sf_calc.xhp
bas_id751652271393226
help.text
' Deletes all columns where the first row is marked with an "X"
sf_calc.xhp
bas_id761652271393514
help.text
newrange = oDoc.CompactLeft("Sheet1.G1:L10", FilterFormula := "=(G1=""X"")")
sf_calc.xhp
bas_id241652271725676
help.text
' Deletes all columns where the sum of values in the column is odd
sf_calc.xhp
bas_id531652271726131
help.text
newrange = oDoc.CompactLeft("Sheet1.G1:L10", FilterFormula := "=(MOD(SUM(G1:G10);2)=1)")

Loading…

User avatar None

String updated in the repository

LibreOffice Help - master / text/sbasic/shared/03Portuguese (Brazil)

 
a month ago
Browse all component changes

Glossary

English Portuguese (Brazil)
COLUMN COLUNA LibreOffice Help - master
COLUMNS COLUNAS LibreOffice Help - master
Formula Fórmula LibreOffice Help - master
FORMULA FÓRMULA LibreOffice Help - master
MATCH CORRESP LibreOffice Help - master
NOT NÃO LibreOffice Help - master
OR OU LibreOffice Help - master
TEXT TEXTO LibreOffice Help - master

String information

Context
sf_calc.xhp
par_id841592919903025
help.text
Source string description
JWFDb
Source string location
sf_calc.xhp
String age
a month ago
Source string age
a month ago
Translation file
pt-BR/helpcontent2/source/text/sbasic/shared/03.po, string 558