Context English Polish
edit_multitables.xhp
par_idN10614
help.text
You can use <emph>Shift</emph>+<switchinline select="sys"><caseinline select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline>+<emph>Page Up</emph> or <emph>Page Down</emph> to select multiple sheets using the keyboard.
edit_multitables.xhp
par_id3147435
help.text
Now when you insert values, text or formulas into the active sheet, they will also appear in the identical positions in the other selected sheets. For example, data entered in cell "A1" of the active sheet is automatically entered into cell "A1" of any other selected sheet.
format_table.xhp
par_id3154733
help.text
You can assign a format to any group of cells by first selecting the cells (for multiple selection, hold down the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key when clicking), and then activating the <emph>Format Cells</emph> dialog in <item type="menuitem">Format - Cells</item>. In this dialog, you can select attributes such as shadows and backgrounds.
multioperation.xhp
par_id6478774
help.text
<image id="img_id1621753" src="media/helpimg/what-if.png"><alt id="alt_id1621753">what-if sheet area</alt></image>
numbers_text.xhp
par_id0908200901265127
help.text
Defaults settings in Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error.
numbers_text.xhp
par_id0908200901265196
help.text
<emph>Only integer numbers including exponent are converted</emph>, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored.
numbers_text.xhp
par_id761567607207916
help.text
The conversion is done for single scalar values only, not within ranges.
numbers_text.xhp
par_id0908200901265448
help.text
The conversion is done for single scalar values, as in =A1+A2, or ="1E2"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string.
numbers_text.xhp
par_id1005200903485359
help.text
In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally).
numbers_text.xhp
par_id1005200903485341
help.text
In A2 enter <literal>=A1+1</literal> (which correctly results in 101).
numbers_text.xhp
par_id891567607263849
help.text
The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which is ignored for the SUM function.
numbers_text.xhp
par_id611567607779380
help.text
<literal>=SUM("1E2";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.
numbers_text.xhp
hd_id871567772424915
help.text
Changing the default text to number conversion settings
numbers_text.xhp
par_id111567772433803
help.text
The text to number conversion can be customized in the <embedvar href="text/shared/optionen/detailedcalculation.xhp#detailed_heading" markup="ignore"/> option.
pivotchart.xhp
par_id911525139890364
help.text
Different from static sized tables, where the number of rows and columns are constant, pivot tables can have varying dimensions, depending on the pivot table settings and its data source contents.
pivotchart_create.xhp
par_id861525140391601
help.text
Select the <link href="text/schart/01/wiz_chart_type.xhp" name="Chart type">Chart type</link> for the data in the chart wizard.
rename_table.xhp
par_id090920081050307
help.text
In cell references, a sheet name must be enclosed in single quotes ' when the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes).
scenario.xhp
par_id3154020
help.text
Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Command</item></caseinline><defaultinline><item type="keycode">Ctrl</item></defaultinline></switchinline> key as you click each cell.
specialfilter.xhp
hd_id3148798
help.text
<variable id="specialfilter"><link href="text/scalc/guide/specialfilter.xhp" name="Filter: Applying Advanced Filters">Filter: Applying Advanced Filters</link></variable>
specialfilter.xhp
par_id3153726
help.text
Then click OK, and you will see that only the rows from the original sheet whose contents have met the search criteria are still visible. All other rows are temporarily hidden and can be made to reappear with the <emph>Format - Rows - Show </emph>command.