Zen

Translation

filter
0/100 · 6

Sign in to save the translation.

English Finnish 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>.
 
<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">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.
 
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
 
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.
 
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">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.
 

Loading…

User avatar None

String added in the repository

  1. Collabora Online
  2. Help
  3. Finnish
filter
 
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 Finnish
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-fi.po, string 345