00000001.xhp (f3989ab4) 00000001.xhp (6deb8101)
1<?xml version="1.0" encoding="UTF-8"?>
2
3<!--***********************************************************
4 *
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements. See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership. The ASF licenses this file

--- 155 unchanged lines hidden (view full) ---

164<!-- removed HID HID_SC_FAP_BTN_REF1 -->
165<!-- removed HID HID_SC_FAP_BTN_REF2 -->
166<!-- removed HID HID_SC_FAP_BTN_REF3 -->
167<!-- removed HID HID_SC_FAP_BTN_REF4 -->
168<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_FILTER:RB_COPY_AREA" id="bm_id3150010" localize="false"/>
169<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_SPEC_FILTER:RB_COPY_AREA" id="bm_id3146985" localize="false"/>
170<paragraph xml-lang="en-US" id="hd_id3153760" role="heading" level="2" l10n="U"
171oldref="47">Shrink / Maximize</paragraph>
1<?xml version="1.0" encoding="UTF-8"?>
2
3<!--***********************************************************
4 *
5 * Licensed to the Apache Software Foundation (ASF) under one
6 * or more contributor license agreements. See the NOTICE file
7 * distributed with this work for additional information
8 * regarding copyright ownership. The ASF licenses this file

--- 155 unchanged lines hidden (view full) ---

164<!-- removed HID HID_SC_FAP_BTN_REF1 -->
165<!-- removed HID HID_SC_FAP_BTN_REF2 -->
166<!-- removed HID HID_SC_FAP_BTN_REF3 -->
167<!-- removed HID HID_SC_FAP_BTN_REF4 -->
168<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_FILTER:RB_COPY_AREA" id="bm_id3150010" localize="false"/>
169<bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_SPEC_FILTER:RB_COPY_AREA" id="bm_id3146985" localize="false"/>
170<paragraph xml-lang="en-US" id="hd_id3153760" role="heading" level="2" l10n="U"
171oldref="47">Shrink / Maximize</paragraph>
172<paragraph xml-lang="en-US" id="par_id3153087" role="paragraph" l10n="U" oldref="48"><ahelp hid=".">Click the<emph> Shrink</emph> icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the <emph>Maximize</emph> icon. Click it to restore the dialog to its original size.</ahelp></paragraph>
172<paragraph xml-lang="en-US" id="par_id3153087" role="paragraph" l10n="U" oldref="48"><ahelp hid=".">Click the <emph>Shrink</emph> icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the <emph>Maximize</emph> icon. Click it to restore the dialog to its original size.</ahelp></paragraph>
173<paragraph xml-lang="en-US" id="par_id3155062" role="paragraph" l10n="U" oldref="49">The dialog is automatically minimized when you click into a sheet with the mouse. As soon as you release the mouse button, the dialog is restored and the reference range defined with the mouse is highlighted in the document by a blue frame.</paragraph>
174<table id="tbl_id3148473">
175<tablerow>
176<tablecell>
177<paragraph xml-lang="en-US" id="par_id3157808" role="paragraph" l10n="E">
178<image id="img_id3148685" src="formula/res/refinp1.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3148685">Icon</alt>
179</image></paragraph>
180</tablecell>

--- 27 unchanged lines hidden (view full) ---

208<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_NEXT" id="bm_id1058076" localize="false"/>
209<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_NEXT" id="bm_id480666" localize="false"/>
210<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_NEXT" id="bm_id3149095" localize="false"/>
211<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id3147576" localize="false"/>
212<!-- removed HID HID_DLGREPORT_0_CMDNEXTORREADY -->
213<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_NEXT" id="bm_id3155135" localize="false"/>
214<paragraph xml-lang="en-US" id="hd_id3145609" role="heading" level="2" l10n="U"
215oldref="70">Next</paragraph>
173<paragraph xml-lang="en-US" id="par_id3155062" role="paragraph" l10n="U" oldref="49">The dialog is automatically minimized when you click into a sheet with the mouse. As soon as you release the mouse button, the dialog is restored and the reference range defined with the mouse is highlighted in the document by a blue frame.</paragraph>
174<table id="tbl_id3148473">
175<tablerow>
176<tablecell>
177<paragraph xml-lang="en-US" id="par_id3157808" role="paragraph" l10n="E">
178<image id="img_id3148685" src="formula/res/refinp1.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3148685">Icon</alt>
179</image></paragraph>
180</tablecell>

--- 27 unchanged lines hidden (view full) ---

208<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DBWIZ_NEXT" id="bm_id1058076" localize="false"/>
209<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID0_NEXT" id="bm_id480666" localize="false"/>
210<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_GROUPWIZARD_NEXT" id="bm_id3149095" localize="false"/>
211<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGFORM_CMDNEXT" id="bm_id3147576" localize="false"/>
212<!-- removed HID HID_DLGREPORT_0_CMDNEXTORREADY -->
213<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_NEXT" id="bm_id3155135" localize="false"/>
214<paragraph xml-lang="en-US" id="hd_id3145609" role="heading" level="2" l10n="U"
215oldref="70">Next</paragraph>
216<paragraph xml-lang="en-US" id="par_id3152473" role="paragraph" l10n="U" oldref="71"><ahelp hid=".">Click the<emph> Next </emph>button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes <emph>Create</emph>.</ahelp></paragraph>
216<paragraph xml-lang="en-US" id="par_id3152473" role="paragraph" l10n="U" oldref="71"><ahelp hid=".">Click the <emph>Next</emph> button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes <emph>Create</emph>.</ahelp></paragraph>
217</section>
218<section id="zurueck">
219<!-- removed HID OFFMGR_PUSHBUTTON_RID_OFADLG_OPTIONS_TREE_PB_BACK -->
220<bookmark xml-lang="en-US" branch="hid/cui:PushButton:RID_OFADLG_OPTIONS_TREE:PB_BACK" id="bm_id4539933" localize="false"/>
221<paragraph xml-lang="en-US" id="hd_id3149670" role="heading" level="2" l10n="U"
222oldref="13">Back<comment>in Tools - Options</comment></paragraph>
223<paragraph xml-lang="en-US" id="par_id3145068" role="paragraph" l10n="U" oldref="14"><ahelp hid="OFFMGR_PUSHBUTTON_RID_OFADLG_OPTIONS_TREE_PB_BACK">Resets modified values back to the $[officename] default values.</ahelp></paragraph>
224</section>

--- 29 unchanged lines hidden (view full) ---

254<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_PREVIOUS" id="bm_id3156155" localize="false"/>
255<paragraph xml-lang="en-US" id="hd_id3147502" role="heading" level="2" l10n="U"
256oldref="72">Back</paragraph>
257<paragraph xml-lang="en-US" id="par_id3150439" role="paragraph" l10n="U" oldref="73"><ahelp hid="HID_TABDLG_STANDARD_BTN">View the selections in the dialog made in the previous step. The current settings remain unchanged.</ahelp> This button can only be activated from page two on.</paragraph>
258</section>
259<section id="zusaetze">
260<paragraph xml-lang="en-US" id="hd_id3147352" role="heading" level="2" l10n="U"
261oldref="52">More</paragraph>
217</section>
218<section id="zurueck">
219<!-- removed HID OFFMGR_PUSHBUTTON_RID_OFADLG_OPTIONS_TREE_PB_BACK -->
220<bookmark xml-lang="en-US" branch="hid/cui:PushButton:RID_OFADLG_OPTIONS_TREE:PB_BACK" id="bm_id4539933" localize="false"/>
221<paragraph xml-lang="en-US" id="hd_id3149670" role="heading" level="2" l10n="U"
222oldref="13">Back<comment>in Tools - Options</comment></paragraph>
223<paragraph xml-lang="en-US" id="par_id3145068" role="paragraph" l10n="U" oldref="14"><ahelp hid="OFFMGR_PUSHBUTTON_RID_OFADLG_OPTIONS_TREE_PB_BACK">Resets modified values back to the $[officename] default values.</ahelp></paragraph>
224</section>

--- 29 unchanged lines hidden (view full) ---

254<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_LISTWIZARD_PREVIOUS" id="bm_id3156155" localize="false"/>
255<paragraph xml-lang="en-US" id="hd_id3147502" role="heading" level="2" l10n="U"
256oldref="72">Back</paragraph>
257<paragraph xml-lang="en-US" id="par_id3150439" role="paragraph" l10n="U" oldref="73"><ahelp hid="HID_TABDLG_STANDARD_BTN">View the selections in the dialog made in the previous step. The current settings remain unchanged.</ahelp> This button can only be activated from page two on.</paragraph>
258</section>
259<section id="zusaetze">
260<paragraph xml-lang="en-US" id="hd_id3147352" role="heading" level="2" l10n="U"
261oldref="52">More</paragraph>
262<paragraph xml-lang="en-US" id="par_id3155314" role="paragraph" l10n="U" oldref="53"><ahelp hid="HID_TABDLG_STANDARD_BTN">Click the<emph> More</emph> button to expand the dialog to show further options. Click again to restore the dialog.</ahelp></paragraph>
262<paragraph xml-lang="en-US" id="par_id3155314" role="paragraph" l10n="U" oldref="53"><ahelp hid="HID_TABDLG_STANDARD_BTN">Click the <emph>More</emph> button to expand the dialog to show further options. Click again to restore the dialog.</ahelp></paragraph>
263</section>
264<paragraph xml-lang="en-US" id="par_id3161659" role="paragraph" l10n="U" oldref="41"><variable id="siehe">See also the following functions:
265</variable></paragraph>
266<paragraph xml-lang="en-US" id="par_id3147418" role="paragraph" l10n="CHG" oldref="55"><variable id="regulaer">The search supports <link href="text/shared/01/02100001.xhp" name="regular expressions">regular expressions</link>. You can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must precede every character with a \ character. You can switch the automatic evaluation of regular expression on and off in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.
267</variable></paragraph>
268<paragraph xml-lang="en-US" id="par_id3163714" role="paragraph" l10n="U" oldref="56"><variable id="wahr">If an error occurs, the function returns a logical or numerical value.
269</variable></paragraph>
270<paragraph xml-lang="en-US" id="par_id3154145" role="paragraph" l10n="U" oldref="54"><variable id="kontext">(This command is only accessible through the <link href="text/shared/00/00000005.xhp#kontextmenue" name="context menu">context menu</link>).
271</variable></paragraph>
272<paragraph xml-lang="en-US" id="par_id3152791" role="paragraph" l10n="U" oldref="61"><variable id="wiederholen">By double-clicking a tool, you can use it for multiple tasks. If you call the tool with a single-click, it reverts back to the last selection after completing the task.
273</variable></paragraph>
274<paragraph xml-lang="en-US" id="par_id9345377" role="paragraph" l10n="NEW"><variable id="ShiftF1">Press Shift+F1 and point to a control to learn more about that control.
275</variable></paragraph>
276</body>
277</helpdocument>
263</section>
264<paragraph xml-lang="en-US" id="par_id3161659" role="paragraph" l10n="U" oldref="41"><variable id="siehe">See also the following functions:
265</variable></paragraph>
266<paragraph xml-lang="en-US" id="par_id3147418" role="paragraph" l10n="CHG" oldref="55"><variable id="regulaer">The search supports <link href="text/shared/01/02100001.xhp" name="regular expressions">regular expressions</link>. You can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must precede every character with a \ character. You can switch the automatic evaluation of regular expression on and off in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.
267</variable></paragraph>
268<paragraph xml-lang="en-US" id="par_id3163714" role="paragraph" l10n="U" oldref="56"><variable id="wahr">If an error occurs, the function returns a logical or numerical value.
269</variable></paragraph>
270<paragraph xml-lang="en-US" id="par_id3154145" role="paragraph" l10n="U" oldref="54"><variable id="kontext">(This command is only accessible through the <link href="text/shared/00/00000005.xhp#kontextmenue" name="context menu">context menu</link>).
271</variable></paragraph>
272<paragraph xml-lang="en-US" id="par_id3152791" role="paragraph" l10n="U" oldref="61"><variable id="wiederholen">By double-clicking a tool, you can use it for multiple tasks. If you call the tool with a single-click, it reverts back to the last selection after completing the task.
273</variable></paragraph>
274<paragraph xml-lang="en-US" id="par_id9345377" role="paragraph" l10n="NEW"><variable id="ShiftF1">Press Shift+F1 and point to a control to learn more about that control.
275</variable></paragraph>
276</body>
277</helpdocument>