Collabora Online/Help — English (South Africa) @ Hosted Weblate: filter

Zen

	English	English (South Africa)	Actions
	The formula language should be extremely familiar to any spreadsheet user, and is specified in great detail in the <a href="https://www.oasis-open.org/committees/download.php/16826/openformula-spec-20060221.html" target="_blank" rel="noopener noreferrer">OASIS OpenFormula specification</a>.	The formula language should be extremely familiar to any spreadsheet user, and is specified in great detail in the <a href="https://www.oasis-open.org/committees/download.php/16826/openformula-spec-20060221.html" target="_blank" rel="noopener noreferrer">OASIS OpenFormula specification</a>.
	<span class="def">Direct formatting:</span> You can format spreadsheets cells, columns, rows and sheets by formatting directly from the menus, toolbar or context menus. Direct formatting applies only to the current object selected. To format a cell either use the menu or hit <kbd>Ctrl</kbd><span class="kbd--plus">+</span><kbd>1</kbd>. The dialog allows complex and custom number formatting, as well as font, complex border, background, cell protection and other options.	<span class="def">Direct formatting:</span> You can format spreadsheets cells, columns, rows and sheets by formatting directly from the menus, toolbar or context menus. Direct formatting applies only to the current object selected. To format a cell either use the menu or hit <kbd>Ctrl</kbd><span class="kbd--plus">+</span><kbd>1</kbd>. The dialogue box allows complex and custom number formatting, as well as font, complex border, background, cell protection and other options.
	<span class="def">Sorting data:</span> You can sort a list of numbers or text ascending or descending. <span class="productname">%productName</span> automatically detects cells that are headers, and adjoining columns, to extend the selection.	<span class="def">Sorting data:</span> You can sort a list of numbers or text ascending or descending. <span class="productname">%productName</span> automatically detects cells that are headers, and adjoining columns, to extend the selection.
	<span class="def">Filtering data:</span> Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in <span class="productname">%productName</span> there are various possibilities for applying filters.	<span class="def">Filtering data:</span> Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in <span class="productname">%productName</span> there are various possibilities for applying filters.
	One use for the <span class="ui">AutoFilter</span> function is to quickly restrict the display to records with identical entries in a data field.	One use for the <span class="ui">AutoFilter</span> function is to quickly restrict the display to records with identical entries in a data field.
	filter	filter
	In the <span class="ui">Standard Filter</span> dialog, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect the conditions with either a logical AND or a logical OR operator.	In the <span class="ui">Standard Filter</span> dialogue box, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect the conditions with either a logical AND or a logical OR operator.
	The <span class="ui">Advanced Filter</span> allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.	The <span class="ui">Advanced Filter</span> allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.
	<span class="def">Outlining:</span> You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click making it easy to represent hierarchical data.	<span class="def">Outlining:</span> You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click making it easy to represent hierarchical data.
	<span class="def">Data validation:</span> For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected. To enable data validation:	<span class="def">Data validation:</span> For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected. To enable data validation:
	Choose <span class="ui">Validity</span> from the <span class="ui">Data</span> menu. The <span class="ui">Validity</span> dialog opens.	Choose <span class="ui">Validity</span> from the <span class="ui">Data</span> menu. The <span class="ui">Validity</span> dialogue box opens.

Loading…

rob.dunedin

Translation added

English

English (South Africa) 6 characters edited Current translation Translated

2 months ago

None

String added in the repository

English

English (South Africa) 0 characters edited Empty

2 months ago

Browse all string changes

Things to check

Inconsistent

This string has more than one translation in this project or is untranslated in some components.

Reset

Glossary

English	English (South Africa)
No related strings found in the glossary.

String information

Source string location

html/cool-help.html+div.div.div.div.ol.li.div.img[alt]:592-34

String age

2 months ago

Last updated

2 months ago

Source string age

2 months ago

Translation file

browser/po/help-en_ZA.po, string 345