Context English Polish
autoformat.xhp
par_idN106D5
help.text
Choose <item type="menuitem">Format - AutoFormat Styles</item>.
autoformat.xhp
par_id3151242
help.text
Select which properties to include in an AutoFormat.
autoformat.xhp
par_id3155379
help.text
To Define an AutoFormat for Spreadsheets or Ranges
autoformat.xhp
par_id3148868
help.text
You can define a new AutoFormat that is available to all spreadsheets and ranges.
autoformat.xhp
par_id3152985
help.text
Format a sheet or range.
autoformat.xhp
par_id3145384
help.text
Choose <item type="menuitem">Edit - Select All</item> or select the formatted range.
autoformat.xhp
par_id3153815
help.text
Choose <item type="menuitem">Format - AutoFormat Styles</item>.
autoformat.xhp
par_id3159203
help.text
<link href="text/scalc/01/05110000.xhp" name="Format - AutoFormat">Format - AutoFormat Styles</link>
cell_protect.xhp
par_idN106C7
help.text
To protect the structure of the document, for example the count, <link href="text/scalc/guide/rename_table.xhp">names</link>, and order of the sheets, from being changed, choose <item type="menuitem">Tools - Protect Spreadsheet Structure</item>.
cellreferences.xhp
par_id2078005
help.text
Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on <emph>+</emph> button to the left of the sheet tab in the bottom (it will be named Sheet2 by default).
cellreferences.xhp
par_id3147338
help.text
When referencing a sheet with name containing spaces, use single quotes around the name: <item type="literal">='Sheet with spaces in name'.A1</item>
cellreferences.xhp
par_id3147383
help.text
The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on <link href="text/shared/optionen/01060900.xhp">Formula options page</link>.
cellreferences.xhp
par_id7099826
help.text
If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a "$" sign to designate it as an <link href="text/scalc/guide/relativ_absolut_ref.xhp">absolute reference</link>.
csv_files.xhp
par_idN108A5
help.text
If the CSV file has another extension, select the file, and then select "Text CSV" in the <emph>Filter</emph> box
csv_files.xhp
par_idN1090D
help.text
In the <emph>Filter</emph> box, select "Text CSV".
database_filter.xhp
par_idN10693
help.text
Choose <item type="menuitem">Data - More Filters - Standard Filter</item>.
database_sort.xhp
par_id1846980
help.text
<link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range" name="wiki.documentfoundation.org: Defining a Data Range">Wiki page about defining a data range</link>
edit_multitables.xhp
bm_id3149456
help.text
<bookmark_value>copying;values, to multiple sheets</bookmark_value><bookmark_value>pasting;values in multiple sheets</bookmark_value><bookmark_value>data;inserting in multiple sheets</bookmark_value><bookmark_value>sheets; simultaneous multiple filling</bookmark_value>
edit_multitables.xhp
hd_id3149456
help.text
<variable id="edit_multitables"><link href="text/scalc/guide/edit_multitables.xhp" name="Copying to Multiple Sheets">Copying to Multiple Sheets</link></variable>
edit_multitables.xhp
par_id3153768
help.text
Select all desired sheets by holding down the <switchinline select="sys"><caseinline select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline> key and clicking the corresponding register tabs that are still gray at the bottom margin of the workspace. All selected register tabs are now white.