diff options
| author | Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> | 2022-12-06 14:05:20 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2022-12-07 17:39:02 +0000 |
| commit | 7e42394ecbf921ee53160b495aa12c1cba158604 (patch) | |
| tree | 9f0b4dcbbf31112c0260a6a6831cbddf86d82c6d /source/text/scalc/guide | |
| parent | 490d42493e8dbec31ad58978df5084b080a36fcb (diff) | |
tdf#152323 drop name attribute from <link> elements
Replacement done with
find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \
's#(<link[^>]*?) +name *="[^"]*" *( [^>]+|) *>#$1$2>#g'
(note some inconsistencies with space between name and = and also having
empty value, and some more complicated expression to also clear up
double space before/after the attribute)
translation files will be prepped with:
find */helpcontent2 -name \*.po -print0 |xargs -0 -P 0 perl -CS -pi -e \
$'s#(<link[^>]*?) +name=(?:\\\\"[^"]*\\\\"|\'[^\']*\') *( [^>]+|) *(/?>)#$1$2$3#g unless /^#/'
(note that not all languages use the " as quote character for the
attributes, but that also single quotes appera in the po file. Hence
the use of the shell $'string' syntax to be able to quote ' as \'
It also requires to quote the backslash, so that it needs to be escaped
once for the shell, then another time for perl. Also don't work on
obsolete strings (those are prefixed with #~ in the po files)
Also note that <link..></link> gets turned into <link ../> during
translation extraction (along with removal of the space between the
attribute name and the value), so the pattern needs to be slightly
different here)
Change-Id: I95e53a08e6b0095cd894109ea0de154cc4859d8f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143713
Tested-by: Jenkins
Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
Diffstat (limited to 'source/text/scalc/guide')
90 files changed, 178 insertions, 178 deletions
diff --git a/source/text/scalc/guide/address_auto.xhp b/source/text/scalc/guide/address_auto.xhp index 0679b7aa7f..92fc4ffbcc 100644 --- a/source/text/scalc/guide/address_auto.xhp +++ b/source/text/scalc/guide/address_auto.xhp @@ -42,7 +42,7 @@ </bookmark> <comment>mw changes "names;..." entry to "text in cells;..."</comment><comment>mw inserted three index entries from text/shared/optionen/01060500.xhp. Changed "finding;..." entry to "recognizing;..." entry. Adding (Calc) is no longer necessary in this file.</comment> -<paragraph id="hd_id3148797" role="heading" level="1" xml-lang="en-US"><variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp" name="Recognizing Names as Addressing">Recognizing Names as Addressing</link></variable></paragraph> +<paragraph id="hd_id3148797" role="heading" level="1" xml-lang="en-US"><variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp">Recognizing Names as Addressing</link></variable></paragraph> <paragraph id="par_id3152597" role="paragraph" xml-lang="en-US">You can use cells with text to refer to the rows or to the columns that contain the cells.</paragraph><comment>removed table as a workaround for issue 108715</comment> <paragraph id="par_id3156283" role="paragraph" xml-lang="en-US"><image id="img_id3154942" src="media/helpimg/names_as_addressing.png" width="5.408cm" height="2.212cm" localize="true"><alt xml-lang="en-US" id="alt_id3154942">Example spreadsheet</alt></image></paragraph> <paragraph id="par_id3154512" role="paragraph" xml-lang="en-US">In the example spreadsheet, you can use the string <item type="literal">'Column One'</item> in a formula to refer to the cell range <item type="literal">B3</item> to <item type="literal">B5</item>, or <item type="literal">'Column Two'</item> for the cell range <item type="literal">C2</item> to <item type="literal">C5</item>. You can also use <item type="literal">'Row One'</item> for the cell range <item type="literal">B3</item> to <item type="literal">D3</item>, or <item type="literal">'Row Two'</item> for the cell range <item type="literal">B4</item> to <item type="literal">D4</item>. The result of a formula that uses a cell name, for example, <item type="literal">SUM('Column One')</item>, is 600.</paragraph> diff --git a/source/text/scalc/guide/auto_off.xhp b/source/text/scalc/guide/auto_off.xhp index 7ac4ebcaa1..d01db05e2b 100644 --- a/source/text/scalc/guide/auto_off.xhp +++ b/source/text/scalc/guide/auto_off.xhp @@ -46,14 +46,14 @@ </bookmark> <comment>mw added one entry</comment> -<paragraph id="hd_id3149456" role="heading" level="1" xml-lang="en-US"><variable id="auto_off"><link href="text/scalc/guide/auto_off.xhp" name="Deactivating Automatic Changes">Deactivating Automatic Changes</link> </variable></paragraph> +<paragraph id="hd_id3149456" role="heading" level="1" xml-lang="en-US"><variable id="auto_off"><link href="text/scalc/guide/auto_off.xhp">Deactivating Automatic Changes</link> </variable></paragraph> <paragraph id="par_id3156442" role="paragraph" xml-lang="en-US">By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Z.</paragraph> <paragraph id="par_id3145273" role="paragraph" xml-lang="en-US">The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:</paragraph> <paragraph id="hd_id3145748" role="heading" level="2" xml-lang="en-US">Automatic Text or Number Completion</paragraph> <paragraph id="par_id3154730" role="paragraph" xml-lang="en-US">When making an entry in a cell, $[officename] Calc automatically suggests matching input found in the same column. This function is known as <emph>AutoInput</emph>.</paragraph> -<paragraph id="par_id3153878" role="paragraph" xml-lang="en-US">To turn the AutoInput on and off, set or remove the check mark in front of <link href="text/scalc/01/06130000.xhp" name="Tools - AutoInput"><emph>Tools - AutoInput</emph></link>.</paragraph> +<paragraph id="par_id3153878" role="paragraph" xml-lang="en-US">To turn the AutoInput on and off, set or remove the check mark in front of <link href="text/scalc/01/06130000.xhp"><emph>Tools - AutoInput</emph></link>.</paragraph> <paragraph id="hd_id3146972" role="heading" level="2" xml-lang="en-US">Automatic Conversion to Date Format</paragraph> <paragraph id="par_id3153707" role="paragraph" xml-lang="en-US">$[officename] Calc automatically converts certain entries to dates. For example, the entry <emph>1.1</emph> may be interpreted as January 1 of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell.<comment>for sure 1.1 will not be interpreted as a date in the USofA !!</comment></paragraph> @@ -69,8 +69,8 @@ <paragraph id="par_id3166425" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Tools - AutoCorrect - AutoCorrect Options</item>. Go to the <item type="menuitem">Replace</item> tab. Select the word pair and click <item type="menuitem">Delete</item>.</paragraph> <section id="relatedtopics"> -<paragraph id="par_id3152992" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/06130000.xhp" name="Tools - AutoInput">Tools - AutoInput</link></paragraph> -<paragraph id="par_id3154368" role="paragraph" xml-lang="en-US"><link href="text/shared/01/06040000.xhp" name="Tools - AutoCorrect">Tools - AutoCorrect - AutoCorrect Options</link></paragraph> +<paragraph id="par_id3152992" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/06130000.xhp">Tools - AutoInput</link></paragraph> +<paragraph id="par_id3154368" role="paragraph" xml-lang="en-US"><link href="text/shared/01/06040000.xhp">Tools - AutoCorrect - AutoCorrect Options</link></paragraph> </section> </body> diff --git a/source/text/scalc/guide/autofilter.xhp b/source/text/scalc/guide/autofilter.xhp index 9d7f1b5a0e..c17cbc0d8a 100644 --- a/source/text/scalc/guide/autofilter.xhp +++ b/source/text/scalc/guide/autofilter.xhp @@ -34,7 +34,7 @@ <bookmark_value>drop-down menus in sheet columns</bookmark_value> <bookmark_value>database ranges; AutoFilter function</bookmark_value> </bookmark><comment>mw made "drop-down..." a one level entry and added a "see also" reference</comment> -<h1 id="hd_id3156423"><variable id="autofilter"><link href="text/scalc/guide/autofilter.xhp" name="Applying AutoFilter">Applying AutoFilter</link> +<h1 id="hd_id3156423"><variable id="autofilter"><link href="text/scalc/guide/autofilter.xhp">Applying AutoFilter</link> </variable></h1> <paragraph xml-lang="en-US" id="par_id3147427" role="paragraph">The <emph>AutoFilter</emph> function inserts a combo box on one or more data columns that lets you select the records (rows) to be displayed.</paragraph> <section id="autofiltertext"> @@ -56,15 +56,15 @@ <section id="autofiltertip"> <tip id="par_id4303415">To assign different AutoFilters to different sheets, you must first define a database range on each sheet.</tip> </section> - <warning id="par_id3159236">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</warning> + <warning id="par_id3159236">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</warning> </section> <section id="relatedtopics"> <embed href="text/scalc/01/12040100.xhp#autofilterh1"/> <embed href="text/scalc/guide/filters.xhp#filters"/> <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> - <paragraph xml-lang="en-US" id="par_id3152985" role="paragraph"><link href="text/scalc/01/12040100.xhp" name="Data - Filter - AutoFilter">Data - Filter - AutoFilter</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3154484" role="paragraph"><link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3152985" role="paragraph"><link href="text/scalc/01/12040100.xhp">Data - Filter - AutoFilter</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3154484" role="paragraph"><link href="text/scalc/01/04060106.xhp">SUBTOTAL</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/autoformat.xhp b/source/text/scalc/guide/autoformat.xhp index 59cea0c960..f47087af72 100644 --- a/source/text/scalc/guide/autoformat.xhp +++ b/source/text/scalc/guide/autoformat.xhp @@ -32,7 +32,7 @@ <bookmark_value>formats; automatically formatting spreadsheets</bookmark_value> <bookmark_value>sheets;AutoFormat</bookmark_value> </bookmark> - <h1 id="hd_id3155132"><variable id="autoformat"><link href="text/scalc/guide/autoformat.xhp" name="Using AutoFormat for Tables">Applying Automatic Formatting to a Selected Cell Range</link></variable></h1> + <h1 id="hd_id3155132"><variable id="autoformat"><link href="text/scalc/guide/autoformat.xhp">Applying Automatic Formatting to a Selected Cell Range</link></variable></h1> <paragraph xml-lang="en-US" id="par_id3149401" role="paragraph">Use the AutoFormat feature to quickly apply a format to a selected cell range.</paragraph> <h2 id="par_idN10702">Applying an AutoFormat to a Selected Cell Range</h2> <list type="ordered"> @@ -76,7 +76,7 @@ </list> <note id="par_id51630343134146">The new AutoFormat styles created using the steps above can be applied to any %PRODUCTNAME Calc file. Hence they are not limited to the file where the style was created.</note> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3159203" role="paragraph"><link href="text/scalc/01/05110000.xhp" name="Format - AutoFormat">Format - AutoFormat Styles</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3159203" role="paragraph"><link href="text/scalc/01/05110000.xhp">Format - AutoFormat Styles</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/background.xhp b/source/text/scalc/guide/background.xhp index 788fa0f6e0..b665c14910 100644 --- a/source/text/scalc/guide/background.xhp +++ b/source/text/scalc/guide/background.xhp @@ -34,7 +34,7 @@ <bookmark_value>rows, see also cells</bookmark_value> <bookmark_value>columns, see also cells</bookmark_value> </bookmark> - <h1 id="hd_id3149346"><variable id="background"><link href="text/scalc/guide/background.xhp" name="Defining Background Colors or Background Graphics">Defining Background Colors or Background Graphics</link> + <h1 id="hd_id3149346"><variable id="background"><link href="text/scalc/guide/background.xhp">Defining Background Colors or Background Graphics</link> </variable></h1><comment>MW created this file from splitting shared/guide/background.xhp</comment> <paragraph xml-lang="en-US" id="par_id9520249" role="paragraph">You can define a background color or use a graphic as a background for cell ranges in $[officename] Calc.</paragraph> <h2 id="hd_id3144760">Applying a Background Color to a $[officename] Calc Spreadsheet</h2> @@ -56,12 +56,12 @@ </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3149664" role="listitem">Select the graphic and click <emph>Open</emph>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153575" role="listitem">The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <menuitem>Arrange - To Background</menuitem> command to place this in the background. To select a graphic that has been placed in the background, use the <link href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153575" role="listitem">The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <menuitem>Arrange - To Background</menuitem> command to place this in the background. To select a graphic that has been placed in the background, use the <link href="text/scalc/01/02110000.xhp">Navigator</link>.</paragraph> </listitem> </list> <section id="relatedtopics"> <paragraph xml-lang="en-US" id="par_id51576" role="paragraph"><link href="text/shared/guide/background.xhp">Watermarks</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3156180" role="paragraph"><link href="text/shared/01/05210100.xhp" name="Background tab page"><emph>Background</emph> tab page</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3156180" role="paragraph"><link href="text/shared/01/05210100.xhp"><emph>Background</emph> tab page</link></paragraph> <paragraph xml-lang="en-US" id="par_id7601245" role="paragraph"><link href="text/scalc/guide/format_table.xhp">Formatting Spreadsheets</link></paragraph> </section> </body> diff --git a/source/text/scalc/guide/calc_date.xhp b/source/text/scalc/guide/calc_date.xhp index 9e866ef00c..9d7e0ad89d 100644 --- a/source/text/scalc/guide/calc_date.xhp +++ b/source/text/scalc/guide/calc_date.xhp @@ -35,7 +35,7 @@ </bookmark> -<paragraph id="hd_id3146120" role="heading" level="1" xml-lang="en-US"><variable id="calc_date"><link href="text/scalc/guide/calc_date.xhp" name="Calculating With Dates and Times">Calculating With Dates and Times</link></variable></paragraph> +<paragraph id="hd_id3146120" role="heading" level="1" xml-lang="en-US"><variable id="calc_date"><link href="text/scalc/guide/calc_date.xhp">Calculating With Dates and Times</link></variable></paragraph> <paragraph id="par_id3154320" role="paragraph" xml-lang="en-US">In $[officename] Calc, you can perform calculations with current date and time values. As an example, to find out exactly how old you are in seconds or hours, follow the following steps:</paragraph> <list type="ordered"> diff --git a/source/text/scalc/guide/calc_series.xhp b/source/text/scalc/guide/calc_series.xhp index 3e89fff538..f3ba21842a 100644 --- a/source/text/scalc/guide/calc_series.xhp +++ b/source/text/scalc/guide/calc_series.xhp @@ -38,7 +38,7 @@ <bookmark_value>AutoFill function</bookmark_value> <bookmark_value>filling;cells, automatically</bookmark_value> </bookmark><comment>mw made "powers of 2;..." a one level entry and changed "AutoFill" entry</comment><comment>MW changed "auto filling cells"</comment> -<paragraph xml-lang="en-US" id="hd_id3150769" role="heading" level="1"><variable id="calc_series"><link href="text/scalc/guide/calc_series.xhp" name="Automatically Calculating Series">Automatically Filling in Data Based on Adjacent Cells</link> +<paragraph xml-lang="en-US" id="hd_id3150769" role="heading" level="1"><variable id="calc_series"><link href="text/scalc/guide/calc_series.xhp">Automatically Filling in Data Based on Adjacent Cells</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_idN106A8" role="paragraph">You can automatically fill cells with data with the AutoFill command or the Series command.</paragraph> <paragraph xml-lang="en-US" id="par_idN106D3" role="heading" level="2">Using AutoFill</paragraph> @@ -77,7 +77,7 @@ </list> <section id="relatedtopics"> <embed href="text/scalc/guide/sorted_list.xhp#sorted_list"/> - <paragraph xml-lang="en-US" id="par_id3159173" role="paragraph"><link href="text/shared/optionen/01060400.xhp" name="Sort lists">Sort lists</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3159173" role="paragraph"><link href="text/shared/optionen/01060400.xhp">Sort lists</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/calc_timevalues.xhp b/source/text/scalc/guide/calc_timevalues.xhp index e79700198a..785c1d395e 100644 --- a/source/text/scalc/guide/calc_timevalues.xhp +++ b/source/text/scalc/guide/calc_timevalues.xhp @@ -33,7 +33,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150769"><bookmark_value>calculating;time differences</bookmark_value> <bookmark_value>time differences</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3150769" xml-lang="en-US" level="1"><variable id="calc_timevalues"><link href="text/scalc/guide/calc_timevalues.xhp" name="Calculating Time Differences">Calculating Time Differences</link> +<paragraph role="heading" id="hd_id3150769" xml-lang="en-US" level="1"><variable id="calc_timevalues"><link href="text/scalc/guide/calc_timevalues.xhp">Calculating Time Differences</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3149263" xml-lang="en-US">If you want to calculate time differences, for example, the time between 23:30 and 01:10 in the same night, use the following formula:</paragraph> <paragraph role="paragraph" id="par_id3159153" xml-lang="en-US">=(B2<A2)+B2-A2</paragraph> diff --git a/source/text/scalc/guide/calculate.xhp b/source/text/scalc/guide/calculate.xhp index 1694c4134c..4d31598097 100644 --- a/source/text/scalc/guide/calculate.xhp +++ b/source/text/scalc/guide/calculate.xhp @@ -29,7 +29,7 @@ <bookmark_value>calculating; spreadsheets</bookmark_value> <bookmark_value>formulas; calculating</bookmark_value> </bookmark><comment>mw changed "formulas;..." entry</comment> -<paragraph id="hd_id3150791" role="heading" xml-lang="en-US" level="1"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp" name="Calculating in Spreadsheets">Calculating in Spreadsheets</link></variable></paragraph> +<paragraph id="hd_id3150791" role="heading" xml-lang="en-US" level="1"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp">Calculating in Spreadsheets</link></variable></paragraph> <paragraph id="par_id3146120" role="paragraph" xml-lang="en-US">The following is an example of a calculation in $[officename] Calc.</paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/cell_protect.xhp b/source/text/scalc/guide/cell_protect.xhp index 6cb10c7223..e72eb0aaaf 100644 --- a/source/text/scalc/guide/cell_protect.xhp +++ b/source/text/scalc/guide/cell_protect.xhp @@ -38,7 +38,7 @@ <bookmark_value>formulas;hiding</bookmark_value> </bookmark> -<h1 id="hd_id3146119"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link> +<h1 id="hd_id3146119"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp">Protecting Cells from Changes</link> </variable></h1> <paragraph xml-lang="en-US" id="par_id3153368" role="paragraph">In <item type="productname">%PRODUCTNAME</item> Calc you can protect sheets and the document as a whole. You can choose whether the cells are protected against accidental changes, whether the formulas can be viewed from within Calc, whether the cells are visible or whether the cells can be printed.</paragraph> <paragraph xml-lang="en-US" id="par_id3145261" role="paragraph">Protection can be provided by means of a password, but it does not have to be. If you have assigned a password, protection can only be removed once the correct password has been entered.</paragraph> @@ -63,7 +63,7 @@ </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3145362" role="listitem">Apply the protection options.</paragraph> - <paragraph xml-lang="en-US" id="par_idN106C0" role="listitem">To protect the cells from being changed, viewed or printed according to your settings in the <emph>Format - Cells</emph> dialog, choose <link href="text/scalc/01/06060100.xhp" name="Tools protect sheet"><menuitem>Tools - Protect Sheet</menuitem></link>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106C0" role="listitem">To protect the cells from being changed, viewed or printed according to your settings in the <emph>Format - Cells</emph> dialog, choose <link href="text/scalc/01/06060100.xhp"><menuitem>Tools - Protect Sheet</menuitem></link>.</paragraph> <paragraph xml-lang="en-US" id="par_idN106C7" role="listitem">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>.</paragraph> </listitem> <listitem> diff --git a/source/text/scalc/guide/cell_unprotect.xhp b/source/text/scalc/guide/cell_unprotect.xhp index 5039c927f1..f7cc88b3a7 100644 --- a/source/text/scalc/guide/cell_unprotect.xhp +++ b/source/text/scalc/guide/cell_unprotect.xhp @@ -31,7 +31,7 @@ <bookmark_value>protecting; unprotecting cells</bookmark_value> <bookmark_value>unprotecting cells</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3153252" role="heading" level="1"><variable id="cell_unprotect"><link href="text/scalc/guide/cell_unprotect.xhp" name="Unprotecting Cells">Unprotecting Cells</link> +<paragraph xml-lang="en-US" id="hd_id3153252" role="heading" level="1"><variable id="cell_unprotect"><link href="text/scalc/guide/cell_unprotect.xhp">Unprotecting Cells</link> </variable></paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/cellcopy.xhp b/source/text/scalc/guide/cellcopy.xhp index 23d1a612d0..57b3986ddd 100644 --- a/source/text/scalc/guide/cellcopy.xhp +++ b/source/text/scalc/guide/cellcopy.xhp @@ -37,7 +37,7 @@ <bookmark_value>filters;copying visible cells only</bookmark_value> <bookmark_value>hidden cells</bookmark_value> </bookmark><comment>mw changed "cells;"</comment> -<paragraph xml-lang="en-US" id="hd_id3150440" role="heading" level="1"><variable id="cellcopy"><link href="text/scalc/guide/cellcopy.xhp" name="Only Copy Visible Cells">Only Copy Visible Cells</link> +<paragraph xml-lang="en-US" id="hd_id3150440" role="heading" level="1"><variable id="cellcopy"><link href="text/scalc/guide/cellcopy.xhp">Only Copy Visible Cells</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3148577" role="paragraph">Assume you have hidden a few rows in a cell range. Now you want to copy, delete, or format only the remaining visible rows.</paragraph> <paragraph xml-lang="en-US" id="par_id3154729" role="paragraph">$[officename] behavior depends on how the cells were made invisible, by a filter or manually.</paragraph> @@ -61,7 +61,7 @@ </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3166427" role="tablecontent">Cells were hidden using the <emph>Hide</emph> command in the context menu of the row or column headers, or through an <link href="text/scalc/01/12080000.xhp" name="outline">outline</link>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3166427" role="tablecontent">Cells were hidden using the <emph>Hide</emph> command in the context menu of the row or column headers, or through an <link href="text/scalc/01/12080000.xhp">outline</link>.</paragraph> <paragraph xml-lang="en-US" id="par_id3152990" role="tablecontent">Copy, delete, move, or format a selection of currently visible cells.</paragraph> </tablecell> <tablecell> diff --git a/source/text/scalc/guide/cellreference_dragdrop.xhp b/source/text/scalc/guide/cellreference_dragdrop.xhp index 6f687d6da3..0508352c88 100644 --- a/source/text/scalc/guide/cellreference_dragdrop.xhp +++ b/source/text/scalc/guide/cellreference_dragdrop.xhp @@ -32,7 +32,7 @@ <bookmark_value>references;inserting by drag and drop</bookmark_value> <bookmark_value>inserting;references, by drag and drop</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3154686" role="heading" level="1"><variable id="cellreference_dragdrop"><link href="text/scalc/guide/cellreference_dragdrop.xhp" name="Referencing Cells by Drag-and-Drop">Referencing Cells by Drag-and-Drop</link> +<paragraph xml-lang="en-US" id="hd_id3154686" role="heading" level="1"><variable id="cellreference_dragdrop"><link href="text/scalc/guide/cellreference_dragdrop.xhp">Referencing Cells by Drag-and-Drop</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph">With the help of the Navigator you can reference cells from one sheet to another sheet in the same document or in a different document. The cells can be inserted as a copy, link, or hyperlink. The range to be inserted must be defined with a name in the original file so that it can be inserted in the target file.</paragraph> <list type="ordered"> @@ -46,7 +46,7 @@ <paragraph xml-lang="en-US" id="par_id3151073" role="listitem">Open the sheet in which you want to insert something.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3154732" role="listitem">Open the <link href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link>. In the lower box of the Navigator select the source file.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154732" role="listitem">Open the <link href="text/scalc/01/02110000.xhp">Navigator</link>. In the lower box of the Navigator select the source file.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3150752" role="listitem">In the Navigator, the source file object appears under "Range names".</paragraph> diff --git a/source/text/scalc/guide/cellreferences.xhp b/source/text/scalc/guide/cellreferences.xhp index bdd676bc64..b468cb9f3a 100644 --- a/source/text/scalc/guide/cellreferences.xhp +++ b/source/text/scalc/guide/cellreferences.xhp @@ -32,7 +32,7 @@ <bookmark_value>cells; operating in another document</bookmark_value> <bookmark_value>documents;references</bookmark_value> </bookmark><comment>mw made "sheet references;" a one level entry</comment><comment>MW changed "references;" and added "documents;"</comment> -<h1 id="hd_id3147436"><variable id="cellreferences"><link href="text/scalc/guide/cellreferences.xhp" name="Referencing Other Sheets">Referencing Other Sheets</link> +<h1 id="hd_id3147436"><variable id="cellreferences"><link href="text/scalc/guide/cellreferences.xhp">Referencing Other Sheets</link> </variable></h1> <paragraph xml-lang="en-US" id="par_id9663075" role="paragraph">In a sheet cell you can show a reference to a cell in another sheet.</paragraph> <paragraph xml-lang="en-US" id="par_id1879329" role="paragraph">In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file.</paragraph> @@ -78,7 +78,7 @@ <paragraph xml-lang="en-US" id="par_id7099826" role="listitem">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>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id674459" role="paragraph">If you examine the name of the other document in this formula, you will notice that it is written as a <link href="text/shared/00/00000002.xhp#url" name="URL">URL</link>. This means that you can also enter a URL from the Internet.</paragraph> + <paragraph xml-lang="en-US" id="par_id674459" role="paragraph">If you examine the name of the other document in this formula, you will notice that it is written as a <link href="text/shared/00/00000002.xhp#url">URL</link>. This means that you can also enter a URL from the Internet.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/> <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> diff --git a/source/text/scalc/guide/cellreferences_url.xhp b/source/text/scalc/guide/cellreferences_url.xhp index de83a313cc..8a40eb3cd0 100644 --- a/source/text/scalc/guide/cellreferences_url.xhp +++ b/source/text/scalc/guide/cellreferences_url.xhp @@ -32,7 +32,7 @@ <bookmark_value>cells; Internet references</bookmark_value> <bookmark_value>URL; in Calc</bookmark_value> </bookmark><comment>mw deleted "sheet references;"</comment> -<paragraph xml-lang="en-US" id="hd_id3150441" role="heading" level="1"><variable id="cellreferences_url"><link href="text/scalc/guide/cellreferences_url.xhp" name="Referencing URLs">Referencing URLs</link> +<paragraph xml-lang="en-US" id="hd_id3150441" role="heading" level="1"><variable id="cellreferences_url"><link href="text/scalc/guide/cellreferences_url.xhp">Referencing URLs</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id1955626" role="paragraph">For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure:</paragraph> <list type="ordered"> @@ -40,7 +40,7 @@ <paragraph xml-lang="en-US" id="par_id3152993" role="listitem">In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data.</paragraph> </listitem> <listitem> -<paragraph xml-lang="en-US" id="par_id3145384" role="listitem">Choose <item type="menuitem">Sheet - External Links</item>. The <link href="text/scalc/01/04090000.xhp" name="External Data"><item type="menuitem">External Data</item></link> dialog appears.</paragraph> +<paragraph xml-lang="en-US" id="par_id3145384" role="listitem">Choose <item type="menuitem">Sheet - External Links</item>. The <link href="text/scalc/01/04090000.xhp"><item type="menuitem">External Data</item></link> dialog appears.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3152892" role="listitem">Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the <item type="menuitem">File - Open</item> dialog.</paragraph> @@ -54,7 +54,7 @@ <paragraph xml-lang="en-US" id="par_id3144768" role="listitem">Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry.</paragraph> </listitem> <listitem> -<paragraph xml-lang="en-US" id="par_id3159204" role="listitem">Under <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01040900.xhp" name="Spreadsheet - General"><item type="menuitem">%PRODUCTNAME Calc - General</item></link> you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under <item type="menuitem">Edit - Links</item>.</paragraph> +<paragraph xml-lang="en-US" id="par_id3159204" role="listitem">Under <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01040900.xhp"><item type="menuitem">%PRODUCTNAME Calc - General</item></link> you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under <item type="menuitem">Edit - Links</item>.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/source/text/scalc/guide/cellstyle_by_formula.xhp b/source/text/scalc/guide/cellstyle_by_formula.xhp index f7c19604b9..197f46ab45 100644 --- a/source/text/scalc/guide/cellstyle_by_formula.xhp +++ b/source/text/scalc/guide/cellstyle_by_formula.xhp @@ -36,7 +36,7 @@ </bookmark> <comment>mw deleted "applying;"</comment> -<paragraph id="hd_id3145673" role="heading" level="1" xml-lang="en-US"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp" name="Assigning Formats by Formula">Assigning Formats by Formula</link></variable></paragraph> +<paragraph id="hd_id3145673" role="heading" level="1" xml-lang="en-US"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp">Assigning Formats by Formula</link></variable></paragraph> <paragraph id="par_id3150275" role="paragraph" xml-lang="en-US">The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied.</paragraph> <paragraph id="par_id3151385" role="paragraph" xml-lang="en-US">If you would like to apply a formula to all cells in a selected area, you can use the <item type="menuitem">Find & Replace</item> dialog.</paragraph> @@ -56,7 +56,7 @@ <paragraph id="par_id3146975" role="listitem" xml-lang="en-US">The "&" symbol designates the current contents of the <emph>Find</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist.</paragraph> </listitem> <listitem> - <paragraph id="par_id3149262" role="listitem" xml-lang="en-US">Mark the fields <link href="text/shared/01/02100000.xhp" name="Regular expressions"><emph>Regular expressions</emph></link> and <emph>Current selection only</emph>. Click <emph>Find All</emph>.</paragraph> + <paragraph id="par_id3149262" role="listitem" xml-lang="en-US">Mark the fields <link href="text/shared/01/02100000.xhp"><emph>Regular expressions</emph></link> and <emph>Current selection only</emph>. Click <emph>Find All</emph>.</paragraph> <paragraph id="par_id3144767" role="listitem" xml-lang="en-US">All cells with contents that were included in the selection are now highlighted.</paragraph> </listitem> <listitem> diff --git a/source/text/scalc/guide/cellstyle_conditional.xhp b/source/text/scalc/guide/cellstyle_conditional.xhp index aa738a32df..7f7d478326 100644 --- a/source/text/scalc/guide/cellstyle_conditional.xhp +++ b/source/text/scalc/guide/cellstyle_conditional.xhp @@ -37,7 +37,7 @@ <bookmark_value>copying; cell styles</bookmark_value> <bookmark_value>tables; copying cell styles</bookmark_value> </bookmark><comment>mw deleted "formats;"</comment> -<paragraph xml-lang="en-US" id="hd_id3149263" role="heading" level="1"><variable id="cellstyle_conditional"><link href="text/scalc/guide/cellstyle_conditional.xhp" name="Applying Conditional Formatting">Applying Conditional Formatting</link> +<paragraph xml-lang="en-US" id="hd_id3149263" role="heading" level="1"><variable id="cellstyle_conditional"><link href="text/scalc/guide/cellstyle_conditional.xhp">Applying Conditional Formatting</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph">Using the menu command <emph>Format - Conditional - Condition</emph>, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> <paragraph xml-lang="en-US" id="par_id8039796" role="warning">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> @@ -51,7 +51,7 @@ <paragraph xml-lang="en-US" id="par_id3155603" role="listitem">Choose <emph>Format - Conditional - Condition</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3146969" role="listitem">Enter the condition(s) into the dialog box. The dialog is described in detail in <link href="text/scalc/01/05120000.xhp" name="$[officename] Help">$[officename] Help</link>, and an example is provided below:</paragraph> + <paragraph xml-lang="en-US" id="par_id3146969" role="listitem">Enter the condition(s) into the dialog box. The dialog is described in detail in <link href="text/scalc/01/05120000.xhp">$[officename] Help</link>, and an example is provided below:</paragraph> </listitem> </list> <paragraph xml-lang="en-US" id="hd_id3155766" role="heading" level="2">Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value</paragraph> @@ -92,7 +92,7 @@ <paragraph xml-lang="en-US" id="par_id3144768" role="listitem">Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3156016" role="listitem">Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href="text/shared/00/00000001.xhp#shrink_maximize" name="Shrink or Maximize"><item type="menuitem">Shrink</item></link> icon.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156016" role="listitem">Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href="text/shared/00/00000001.xhp#shrink_maximize"><item type="menuitem">Shrink</item></link> icon.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3153246" role="listitem">Close the Function Wizard with <item type="menuitem">OK</item>.</paragraph> @@ -133,7 +133,7 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> <embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> - <paragraph xml-lang="en-US" id="par_id3159123" role="paragraph"><link href="text/scalc/01/05120000.xhp" name="Format - Conditional formatting">Format - Conditional - Condition</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3159123" role="paragraph"><link href="text/scalc/01/05120000.xhp">Format - Conditional - Condition</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/cellstyle_minusvalue.xhp b/source/text/scalc/guide/cellstyle_minusvalue.xhp index 6f158ca75b..c7a0eda0a1 100644 --- a/source/text/scalc/guide/cellstyle_minusvalue.xhp +++ b/source/text/scalc/guide/cellstyle_minusvalue.xhp @@ -33,7 +33,7 @@ <bookmark_value>colors;negative numbers</bookmark_value> <bookmark_value>number formats;colors for negative numbers</bookmark_value> </bookmark><comment>MW made "negative numbers;" a one level entry</comment><comment>MW changed "numbers formats;" and "colors;"</comment> -<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1"><variable id="cellstyle_minusvalue"><link href="text/scalc/guide/cellstyle_minusvalue.xhp" name="Highlighting Negative Numbers">Highlighting Negative Numbers</link> +<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1"><variable id="cellstyle_minusvalue"><link href="text/scalc/guide/cellstyle_minusvalue.xhp">Highlighting Negative Numbers</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153878" role="paragraph">You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors.</paragraph> <list type="ordered"> diff --git a/source/text/scalc/guide/change_image_anchor.xhp b/source/text/scalc/guide/change_image_anchor.xhp index 7216360d6a..a218794ea0 100644 --- a/source/text/scalc/guide/change_image_anchor.xhp +++ b/source/text/scalc/guide/change_image_anchor.xhp @@ -21,7 +21,7 @@ <bookmark_value>image anchor;in Calc</bookmark_value> <bookmark_value>image anchor in Calc;changing</bookmark_value> </bookmark> -<h1 id="par_id851607971999527"><variable id="anchor_image"><link href="text/scalc/guide/change_image_anchor.xhp" name="Changing Anchor of Image">Changing the Anchor of an Image</link> +<h1 id="par_id851607971999527"><variable id="anchor_image"><link href="text/scalc/guide/change_image_anchor.xhp">Changing the Anchor of an Image</link> </variable></h1> <paragraph xml-lang="en-US" role="paragraph" id="par_id881607972030094">Images are inserted in a Calc spreadsheet anchored to cells by default and do not resize when the cell is moved.</paragraph> <paragraph xml-lang="en-US" role="paragraph" id="par_id741607810664944">Images can be anchored in three different ways:</paragraph> diff --git a/source/text/scalc/guide/consolidate.xhp b/source/text/scalc/guide/consolidate.xhp index d33d464859..55eb650e06 100644 --- a/source/text/scalc/guide/consolidate.xhp +++ b/source/text/scalc/guide/consolidate.xhp @@ -34,7 +34,7 @@ <bookmark_value>data; merging cell ranges</bookmark_value> <bookmark_value>merging;data ranges</bookmark_value> </bookmark><comment>mw deleted "values;"</comment> -<paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1"><variable id="consolidate"><link href="text/scalc/guide/consolidate.xhp" name="Consolidating Data">Consolidating Data</link> +<paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1"><variable id="consolidate"><link href="text/scalc/guide/consolidate.xhp">Consolidating Data</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153191" role="paragraph">During consolidation, the contents of the cells from several sheets will be combined in one place.</paragraph> <paragraph xml-lang="en-US" id="hd_id892056" role="heading" level="2">To Combine Cell Contents</paragraph> @@ -83,7 +83,7 @@ </list> <paragraph xml-lang="en-US" id="par_id3147468" role="paragraph">The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available.</paragraph> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3153039" role="paragraph"><link href="text/scalc/01/12070000.xhp" name="Data - Consolidate">Data - Consolidate</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3153039" role="paragraph"><link href="text/scalc/01/12070000.xhp">Data - Consolidate</link></paragraph> </section> </body> </helpdocument>
\ No newline at end of file diff --git a/source/text/scalc/guide/csv_files.xhp b/source/text/scalc/guide/csv_files.xhp index d0cbd01f0c..a28dedf80a 100644 --- a/source/text/scalc/guide/csv_files.xhp +++ b/source/text/scalc/guide/csv_files.xhp @@ -96,9 +96,9 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/> <embed href="text/shared/guide/data_im_export.xhp#data_im_export"/> -<paragraph xml-lang="en-US" id="par_id3153487" role="paragraph"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060100.xhp" name="Spreadsheet - View">%PRODUCTNAME Calc - View</link></paragraph> -<paragraph xml-lang="en-US" id="par_id3153008" role="paragraph"><link href="text/shared/00/00000207.xhp" name="Export text files">Export text files</link></paragraph> -<paragraph xml-lang="en-US" id="par_id3155595" role="paragraph"><link href="text/shared/00/00000208.xhp" name="Import text files">Import text files</link></paragraph> +<paragraph xml-lang="en-US" id="par_id3153487" role="paragraph"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060100.xhp">%PRODUCTNAME Calc - View</link></paragraph> +<paragraph xml-lang="en-US" id="par_id3153008" role="paragraph"><link href="text/shared/00/00000207.xhp">Export text files</link></paragraph> +<paragraph xml-lang="en-US" id="par_id3155595" role="paragraph"><link href="text/shared/00/00000208.xhp">Import text files</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/csv_formula.xhp b/source/text/scalc/guide/csv_formula.xhp index 70edc0b585..1e793caf7a 100644 --- a/source/text/scalc/guide/csv_formula.xhp +++ b/source/text/scalc/guide/csv_formula.xhp @@ -32,7 +32,7 @@ <bookmark_value>exporting;formulas as csv files</bookmark_value> <bookmark_value>importing;csv files with formulas</bookmark_value> </bookmark><comment>mw deleted "inserting;", copied 4 index entries to scalc/guide/csv_files.xhp, changed "csv files;" and "formulas;" and added 2 index entries</comment> -<paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1"><variable id="csv_formula"><link href="text/scalc/guide/csv_formula.xhp" name="Importing and Exporting Text Files">Importing and Exporting CSV Text Files with Formulas</link> +<paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1"><variable id="csv_formula"><link href="text/scalc/guide/csv_formula.xhp">Importing and Exporting CSV Text Files with Formulas</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3149402" role="paragraph">Comma separated values (CSV) files are text files that contain the cell contents of a single sheet. Commas, semicolons, or other characters can be used as the field delimiters between the cells. Text strings are put in quotation marks, numbers are written without quotation marks.</paragraph> <paragraph xml-lang="en-US" id="hd_id3150715" role="heading" level="2">To Import a CSV File</paragraph> @@ -78,9 +78,9 @@ </list> <section id="relatedtopics"> <embed href="text/scalc/guide/csv_files.xhp#csv_files"/> - <paragraph xml-lang="en-US" id="par_id3153487" role="paragraph"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060100.xhp" name="Spreadsheet - View">%PRODUCTNAME Calc - View</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3153008" role="paragraph"><link href="text/shared/00/00000207.xhp" name="Export text files">Export text files</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3155595" role="paragraph"><link href="text/shared/00/00000208.xhp" name="Import text files">Import text files</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3153487" role="paragraph"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060100.xhp">%PRODUCTNAME Calc - View</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3153008" role="paragraph"><link href="text/shared/00/00000207.xhp">Export text files</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3155595" role="paragraph"><link href="text/shared/00/00000208.xhp">Import text files</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/currency_format.xhp b/source/text/scalc/guide/currency_format.xhp index f0b2f0cb92..d4f158233e 100644 --- a/source/text/scalc/guide/currency_format.xhp +++ b/source/text/scalc/guide/currency_format.xhp @@ -35,7 +35,7 @@ <bookmark_value>defaults;currency formats</bookmark_value> <bookmark_value>changing;currency formats</bookmark_value> </bookmark><comment>mw changed one index entry</comment> -<paragraph xml-lang="en-US" id="hd_id3156329" role="heading" level="1"><variable id="currency_format"><link href="text/scalc/guide/currency_format.xhp" name="Cells in Currency Format">Cells in Currency Format</link> +<paragraph xml-lang="en-US" id="hd_id3156329" role="heading" level="1"><variable id="currency_format"><link href="text/scalc/guide/currency_format.xhp">Cells in Currency Format</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153968" role="paragraph">In <item type="productname">%PRODUCTNAME</item> Calc you can give numbers any currency format. When you click the <item type="menuitem">Currency</item> icon <image id="img_id3150791" src="cmd/sc_currencyfield.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3150791">Icon</alt> @@ -53,7 +53,7 @@ </list> <section id="relatedtopics"> <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> -<paragraph xml-lang="en-US" id="par_id3154255" role="paragraph"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> +<paragraph xml-lang="en-US" id="par_id3154255" role="paragraph"><link href="text/shared/01/05020300.xhp">Format - Cells - Numbers</link></paragraph> </section> </body> </helpdocument>
\ No newline at end of file diff --git a/source/text/scalc/guide/database_define.xhp b/source/text/scalc/guide/database_define.xhp index 5c4d8ffcc3..c284ec838e 100644 --- a/source/text/scalc/guide/database_define.xhp +++ b/source/text/scalc/guide/database_define.xhp @@ -32,7 +32,7 @@ <bookmark_value>ranges; defining database ranges</bookmark_value> <bookmark_value>defining;database ranges</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3154758" role="heading" level="1"><variable id="database_define"><link href="text/scalc/guide/database_define.xhp" name="Defining Database Ranges">Defining a Database Range</link> +<paragraph xml-lang="en-US" id="hd_id3154758" role="heading" level="1"><variable id="database_define"><link href="text/scalc/guide/database_define.xhp">Defining a Database Range</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153768" role="paragraph">You can define a range of cells in a spreadsheet to use as a database. Each row in this database range corresponds to a database record and each cell in a row corresponds to a database field. You can sort, group, search, and perform calculations on the range as you would in a database.</paragraph> <paragraph xml-lang="en-US" id="par_id3145801" role="warning">You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the %PRODUCTNAME Data Sources view. </paragraph> diff --git a/source/text/scalc/guide/database_filter.xhp b/source/text/scalc/guide/database_filter.xhp index 2da674b8f8..be0468eee4 100644 --- a/source/text/scalc/guide/database_filter.xhp +++ b/source/text/scalc/guide/database_filter.xhp @@ -31,7 +31,7 @@ <bookmark_value>database ranges;applying/removing filters</bookmark_value> <bookmark_value>removing;cell range filters</bookmark_value> </bookmark><comment>MW changed "cell ranges," added "removing;" and made one "database ranges;" entry out of two. Same for "filtering;"</comment> -<paragraph xml-lang="en-US" id="hd_id3153541" role="heading" level="1"><variable id="database_filter"><link href="text/scalc/guide/database_filter.xhp" name="Filtering Cell Ranges">Filtering Cell Ranges</link> +<paragraph xml-lang="en-US" id="hd_id3153541" role="heading" level="1"><variable id="database_filter"><link href="text/scalc/guide/database_filter.xhp">Filtering Cell Ranges</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3145069" role="paragraph">You can use several filters to filter cell ranges in spreadsheets. A standard filter uses the options that you specify to filter the data. An AutoFilter filters data according to a specific value or string. An advanced filter uses filter criteria from specified cells.</paragraph> <paragraph xml-lang="en-US" id="par_idN10682" role="heading" level="2">To Apply a Standard Filter to a Cell Range</paragraph> @@ -82,7 +82,7 @@ <embed href="text/scalc/guide/database_sort.xhp#database_sort"/> <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> - <paragraph xml-lang="en-US" id="par_id4525284" role="paragraph"><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></paragraph> + <paragraph xml-lang="en-US" id="par_id4525284" role="paragraph"><link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range">Wiki page about defining a data range</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/database_sort.xhp b/source/text/scalc/guide/database_sort.xhp index e10dd45ca7..861efdf972 100644 --- a/source/text/scalc/guide/database_sort.xhp +++ b/source/text/scalc/guide/database_sort.xhp @@ -30,7 +30,7 @@ <bookmark_value>sorting; database ranges</bookmark_value> <bookmark_value>data;sorting in databases</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3150767" role="heading" level="1"><variable id="database_sort"><link href="text/scalc/guide/database_sort.xhp" name="Sorting Database Ranges">Sorting Data</link> +<paragraph xml-lang="en-US" id="hd_id3150767" role="heading" level="1"><variable id="database_sort"><link href="text/scalc/guide/database_sort.xhp">Sorting Data</link> </variable></paragraph> <list type="ordered"> <listitem> @@ -51,7 +51,7 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/database_define.xhp#database_define"/> <embed href="text/scalc/guide/database_filter.xhp#database_filter"/> - <paragraph xml-lang="en-US" id="par_id1846980" role="paragraph"><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></paragraph> + <paragraph xml-lang="en-US" id="par_id1846980" role="paragraph"><link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range">Wiki page about defining a data range</link></paragraph> </section> </body> </helpdocument>
\ No newline at end of file diff --git a/source/text/scalc/guide/datapilot.xhp b/source/text/scalc/guide/datapilot.xhp index 6391a629e4..ae8cdaa769 100644 --- a/source/text/scalc/guide/datapilot.xhp +++ b/source/text/scalc/guide/datapilot.xhp @@ -27,10 +27,10 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150448"><bookmark_value>pivot table function; introduction</bookmark_value> <bookmark_value>DataPilot, see pivot table function</bookmark_value> </bookmark> -<h1 id="hd_id3150448"><variable id="datapilot"><link href="text/scalc/guide/datapilot.xhp" name="Pivot Table">Pivot Table</link> +<h1 id="hd_id3150448"><variable id="datapilot"><link href="text/scalc/guide/datapilot.xhp">Pivot Table</link> </variable></h1> <paragraph role="paragraph" id="par_id3156024" xml-lang="en-US">The <emph>pivot table</emph> (formerly known as <emph>DataPilot</emph>) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports.</paragraph> -<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US">A table that has been created as a <link href="text/scalc/01/12090000.xhp" name="pivot table">pivot table</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.</paragraph> +<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US">A table that has been created as a <link href="text/scalc/01/12090000.xhp">pivot table</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#pivot"/> <section id="relatedtopics"> diff --git a/source/text/scalc/guide/datapilot_createtable.xhp b/source/text/scalc/guide/datapilot_createtable.xhp index 92a25abd2e..dbbdafdf18 100644 --- a/source/text/scalc/guide/datapilot_createtable.xhp +++ b/source/text/scalc/guide/datapilot_createtable.xhp @@ -30,7 +30,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148491"><bookmark_value>pivot tables</bookmark_value> <bookmark_value>pivot table function; calling up and applying</bookmark_value> </bookmark> -<h1 id="hd_id3148491"><variable id="datapilot_createtable"><link href="text/scalc/guide/datapilot_createtable.xhp" name="Creating Pivot Tables">Creating Pivot Tables</link> +<h1 id="hd_id3148491"><variable id="datapilot_createtable"><link href="text/scalc/guide/datapilot_createtable.xhp">Creating Pivot Tables</link> </variable></h1> <list type="ordered"> <listitem> @@ -47,7 +47,7 @@ <paragraph xml-lang="en-US" id="par_id3154011" role="paragraph">If the button is dropped in the <emph>Data Fields</emph> area it will be given a caption that also shows the formula that will be used to calculate the data.</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3146974" role="listitem">By double-clicking on one of the fields in the <emph>Data Fields</emph> area you can call up the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> dialog.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146974" role="listitem">By double-clicking on one of the fields in the <emph>Data Fields</emph> area you can call up the <link href="text/scalc/01/12090105.xhp"><emph>Data Field</emph></link> dialog.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3156286" role="listitem">Use the <item type="menuitem">Data Field</item> dialog to select the calculations to be used for the data. To make a multiple selection, press the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key while clicking the desired calculation.</paragraph> @@ -61,7 +61,7 @@ <paragraph xml-lang="en-US" id="par_id3153714" role="listitem">Remove a button by dragging it back to the area of the other buttons at the right of the dialog.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3147338" role="listitem">To open the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> dialog, double-click one of the buttons in the <emph>Row Fields</emph> or <emph>Column Fields</emph> area. Use the dialog to select if and to what extent <item type="productname">%PRODUCTNAME</item> calculates display subtotals.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147338" role="listitem">To open the <link href="text/scalc/01/12090105.xhp"><emph>Data Field</emph></link> dialog, double-click one of the buttons in the <emph>Row Fields</emph> or <emph>Column Fields</emph> area. Use the dialog to select if and to what extent <item type="productname">%PRODUCTNAME</item> calculates display subtotals.</paragraph> </listitem> </list> <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph">Exit the Pivot Table dialog by pressing OK. A <emph>Filter</emph> button will now be inserted, or a page button for every data field that you dropped in the <emph>Filters</emph> area. The pivot table is inserted further down.</paragraph> diff --git a/source/text/scalc/guide/datapilot_deletetable.xhp b/source/text/scalc/guide/datapilot_deletetable.xhp index 29e849cb73..2debe1e93e 100644 --- a/source/text/scalc/guide/datapilot_deletetable.xhp +++ b/source/text/scalc/guide/datapilot_deletetable.xhp @@ -30,7 +30,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>pivot table function; deleting tables</bookmark_value> <bookmark_value>deleting;pivot tables</bookmark_value> </bookmark> -<h1 id="hd_id3153726"><variable id="datapilot_deletetable"><link href="text/scalc/guide/datapilot_deletetable.xhp" name="Deleting Pivot Tables">Deleting Pivot Tables</link> +<h1 id="hd_id3153726"><variable id="datapilot_deletetable"><link href="text/scalc/guide/datapilot_deletetable.xhp">Deleting Pivot Tables</link> </variable></h1> <paragraph xml-lang="en-US" id="par_id3154014" role="paragraph">In order to delete a pivot table, click any cell in the pivot table, then choose <emph>Delete</emph> in the context menu.</paragraph> <warning id="par_id141525148751543">If you delete a pivot table linked to a pivot chart, the pivot chart is also deleted. A dialog box opens to confirm the pivot chart deletion.</warning> diff --git a/source/text/scalc/guide/datapilot_edittable.xhp b/source/text/scalc/guide/datapilot_edittable.xhp index ab0385e567..f0fcf2e92c 100644 --- a/source/text/scalc/guide/datapilot_edittable.xhp +++ b/source/text/scalc/guide/datapilot_edittable.xhp @@ -30,7 +30,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148663"><bookmark_value>pivot table function; editing tables</bookmark_value> <bookmark_value>editing;pivot tables</bookmark_value> </bookmark> -<h1 id="hd_id3148663"><variable id="datapilot_edittable"><link href="text/scalc/guide/datapilot_edittable.xhp" name="Editing Pivot Tables">Editing Pivot Tables</link> +<h1 id="hd_id3148663"><variable id="datapilot_edittable"><link href="text/scalc/guide/datapilot_edittable.xhp">Editing Pivot Tables</link> </variable></h1> <paragraph xml-lang="en-US" id="par_id3150868" role="paragraph">Click one of the buttons in the pivot table and hold the mouse button down. A special symbol will appear next to the mouse pointer.</paragraph> <paragraph xml-lang="en-US" id="par_id3145786" role="paragraph">By dragging the button to a different position in the same row you can alter the order of the columns. If you drag a button to the left edge of the table into the row headings area, you can change a column into a row.</paragraph> diff --git a/source/text/scalc/guide/datapilot_filtertable.xhp b/source/text/scalc/guide/datapilot_filtertable.xhp index 3b39683ba1..88959399f1 100644 --- a/source/text/scalc/guide/datapilot_filtertable.xhp +++ b/source/text/scalc/guide/datapilot_filtertable.xhp @@ -29,9 +29,9 @@ <bookmark_value>pivot table function; filtering tables</bookmark_value> <bookmark_value>filtering;pivot tables</bookmark_value> </bookmark> -<h1 id="hd_id3150792"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering Pivot Tables">Filtering Pivot Tables</link></variable></h1> +<h1 id="hd_id3150792"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp">Filtering Pivot Tables</link></variable></h1> <paragraph id="par_id3153192" role="paragraph" xml-lang="en-US">You can use filters to remove unwanted data from a pivot table.</paragraph> -<paragraph id="par_id3150441" role="paragraph" xml-lang="en-US">Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the <emph>Filter</emph> command. The <link href="text/scalc/01/12090103.xhp" name="Filter"><emph>Filter</emph></link> dialog appears. Here you can filter the pivot table.</paragraph> +<paragraph id="par_id3150441" role="paragraph" xml-lang="en-US">Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the <emph>Filter</emph> command. The <link href="text/scalc/01/12090103.xhp"><emph>Filter</emph></link> dialog appears. Here you can filter the pivot table.</paragraph> <paragraph id="par_id315044199" role="paragraph" xml-lang="en-US">You can also click the arrow on a button in the pivot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field.</paragraph> <list type="unordered"> <listitem> diff --git a/source/text/scalc/guide/datapilot_formatting.xhp b/source/text/scalc/guide/datapilot_formatting.xhp index 8206230045..18b8276619 100644 --- a/source/text/scalc/guide/datapilot_formatting.xhp +++ b/source/text/scalc/guide/datapilot_formatting.xhp @@ -20,7 +20,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id931656104694657"> <bookmark_value>formatting;pivot tables</bookmark_value> </bookmark> - <h1 id="hd_id341656099297638"><variable id="h1"><link href="text/scalc/guide/datapilot_formatting.xhp" name="Formatting Pivot Tables">Formatting Pivot Tables</link></variable></h1> + <h1 id="hd_id341656099297638"><variable id="h1"><link href="text/scalc/guide/datapilot_formatting.xhp">Formatting Pivot Tables</link></variable></h1> <paragraph id="par_id121656099297641" role="paragraph" xml-lang="en-US">You can format pivot tables cells using specific cell styles.</paragraph> </section> <warning id="par_id751656100824556">Direct formatting of pivot tables cells is lost when updating or editing the table.</warning> diff --git a/source/text/scalc/guide/datapilot_tipps.xhp b/source/text/scalc/guide/datapilot_tipps.xhp index 9966532b16..a1bd507083 100644 --- a/source/text/scalc/guide/datapilot_tipps.xhp +++ b/source/text/scalc/guide/datapilot_tipps.xhp @@ -27,7 +27,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148663"><bookmark_value>pivot table function; preventing data overwriting</bookmark_value> <bookmark_value>output ranges of pivot tables</bookmark_value> </bookmark> -<h1 id="hd_id3148663"><variable id="datapilot_tipps"><link href="text/scalc/guide/datapilot_tipps.xhp" name="Selecting Pivot Table Output Ranges">Selecting Pivot Table Output Ranges</link> +<h1 id="hd_id3148663"><variable id="datapilot_tipps"><link href="text/scalc/guide/datapilot_tipps.xhp">Selecting Pivot Table Output Ranges</link> </variable></h1> <paragraph role="paragraph" id="par_id3154123" xml-lang="en-US">Click the button <emph>More</emph> in the <emph>Pivot Table</emph> dialog. The dialog will be extended.</paragraph> <paragraph role="paragraph" id="par_id3153771" xml-lang="en-US">You can select a named range in which the pivot table is to be created, from the <emph>Results to</emph> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the <emph>Results to</emph> box. You can also click on the appropriate cell to have the coordinates entered accordingly.</paragraph> diff --git a/source/text/scalc/guide/datapilot_updatetable.xhp b/source/text/scalc/guide/datapilot_updatetable.xhp index 9d9beea680..dc6eea061c 100644 --- a/source/text/scalc/guide/datapilot_updatetable.xhp +++ b/source/text/scalc/guide/datapilot_updatetable.xhp @@ -29,7 +29,7 @@ <bookmark_value>recalculating;pivot tables</bookmark_value> <bookmark_value>updating;pivot tables</bookmark_value> </bookmark> -<h1 id="hd_id3150792"><variable id="datapilot_updatetable"><link href="text/scalc/guide/datapilot_updatetable.xhp" name="Updating Pivot Tables">Updating Pivot Tables</link> +<h1 id="hd_id3150792"><variable id="datapilot_updatetable"><link href="text/scalc/guide/datapilot_updatetable.xhp">Updating Pivot Tables</link> </variable></h1> <paragraph role="paragraph" id="par_id3154684" xml-lang="en-US">If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do the same after you have imported an Excel pivot table into $[officename] Calc.</paragraph> diff --git a/source/text/scalc/guide/design.xhp b/source/text/scalc/guide/design.xhp index 0674f5353f..912d397a38 100644 --- a/source/text/scalc/guide/design.xhp +++ b/source/text/scalc/guide/design.xhp @@ -41,7 +41,7 @@ <bookmark_value>formatting;themes for sheets</bookmark_value> </bookmark> <comment>mw deleted "applying;"</comment> - <paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1"><variable id="design"><link href="text/scalc/guide/design.xhp" name="Selecting Themes for Sheets">Selecting Themes for Sheets</link> + <paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1"><variable id="design"><link href="text/scalc/guide/design.xhp">Selecting Themes for Sheets</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3145786" role="paragraph">$[officename] Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets.</paragraph> <paragraph xml-lang="en-US" id="par_id3154490" role="paragraph">It is not possible to add themes to Calc, and they cannot be modified. However, you can modify their styles after you apply them to a spreadsheet.</paragraph> @@ -65,7 +65,7 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/autoformat.xhp#autoformat"/> - <paragraph xml-lang="en-US" id="par_id3146979" role="paragraph"><link href="text/scalc/02/06080000.xhp" name="Theme selection">Theme selection</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3146979" role="paragraph"><link href="text/scalc/02/06080000.xhp">Theme selection</link></paragraph> </section> </body> diff --git a/source/text/scalc/guide/edit_multitables.xhp b/source/text/scalc/guide/edit_multitables.xhp index e889dc392b..ab7b141dd8 100644 --- a/source/text/scalc/guide/edit_multitables.xhp +++ b/source/text/scalc/guide/edit_multitables.xhp @@ -32,7 +32,7 @@ <bookmark_value>sheets; simultaneous multiple filling</bookmark_value> </bookmark> <comment>mw moved "multiple sheets" and "selecting;" to multitables.xhp, transferred "sheets;" from there and deleted "sheets;transferring.."</comment> -<paragraph xml-lang="en-US" id="hd_id3149456" role="heading" level="1"><variable id="edit_multitables"><link href="text/scalc/guide/edit_multitables.xhp" name="Copying to Multiple Sheets">Copying to Multiple Sheets</link></variable></paragraph> +<paragraph xml-lang="en-US" id="hd_id3149456" role="heading" level="1"><variable id="edit_multitables"><link href="text/scalc/guide/edit_multitables.xhp">Copying to Multiple Sheets</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id3150868" role="paragraph">In $[officename] Calc, you can insert values, text or formulas that are simultaneously copied to other selected sheets of your document.</paragraph> <list type="unordered"> <listitem> diff --git a/source/text/scalc/guide/filters.xhp b/source/text/scalc/guide/filters.xhp index fb120422ed..ed67334ccb 100644 --- a/source/text/scalc/guide/filters.xhp +++ b/source/text/scalc/guide/filters.xhp @@ -31,7 +31,7 @@ <bookmark_value>rows;removing/redisplaying with filters</bookmark_value> <bookmark_value>removing;filters</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3153896" role="heading" level="1"><variable id="filters"><link href="text/scalc/guide/filters.xhp" name="Applying Filters">Applying Filters</link> +<paragraph xml-lang="en-US" id="hd_id3153896" role="heading" level="1"><variable id="filters"><link href="text/scalc/guide/filters.xhp">Applying Filters</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3150869" role="paragraph">Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in $[officename] there are various possibilities for applying filters.</paragraph> <list type="ordered"> diff --git a/source/text/scalc/guide/format_table.xhp b/source/text/scalc/guide/format_table.xhp index b0bc1e1ac2..823e80d1e0 100644 --- a/source/text/scalc/guide/format_table.xhp +++ b/source/text/scalc/guide/format_table.xhp @@ -37,7 +37,7 @@ <bookmark_value>cells; number formats</bookmark_value> <bookmark_value>currencies;formats</bookmark_value> </bookmark><comment>mw transferred 2 entries from shared/01/05020300.xhp and added 2 new entries</comment><comment>mw deleted "defaults;"</comment> -<paragraph role="heading" id="hd_id3154125" xml-lang="en-US" level="1"><variable id="format_table"><link href="text/scalc/guide/format_table.xhp" name="Designing Spreadsheets">Formatting Spreadsheets</link> +<paragraph role="heading" id="hd_id3154125" xml-lang="en-US" level="1"><variable id="format_table"><link href="text/scalc/guide/format_table.xhp">Formatting Spreadsheets</link> </variable></paragraph> <paragraph role="heading" id="hd_id3153912" xml-lang="en-US" level="2">Formatting Text in a Spreadsheet </paragraph> <list type="ordered"> @@ -66,7 +66,7 @@ <paragraph role="listitem" id="par_id3145116" xml-lang="en-US">To apply formatting attributes to an entire sheet, choose <emph>Format - Page Style</emph>. You can define headers and footers, for example, to appear on each printed page.</paragraph> </listitem> </list> -<paragraph role="note" id="par_id3145389" xml-lang="en-US">An image that you have loaded with <item type="menuitem">Format - Page Style - Background</item> is only visible in print or in the print preview. To display a background image on screen as well, insert the graphic image by choosing <item type="menuitem">Insert - Image - From File</item> and arrange the image behind the cells by choosing <item type="menuitem">Format - Arrange - To Background</item>. Use the <link href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link> to select the background image.</paragraph> +<paragraph role="note" id="par_id3145389" xml-lang="en-US">An image that you have loaded with <item type="menuitem">Format - Page Style - Background</item> is only visible in print or in the print preview. To display a background image on screen as well, insert the graphic image by choosing <item type="menuitem">Insert - Image - From File</item> and arrange the image behind the cells by choosing <item type="menuitem">Format - Arrange - To Background</item>. Use the <link href="text/scalc/01/02110000.xhp">Navigator</link> to select the background image.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/autoformat.xhp#autoformat"/> <paragraph role="paragraph" id="par_id2837916" xml-lang="en-US"><link href="text/shared/01/05020300.xhp">Number Formatting Options</link></paragraph> diff --git a/source/text/scalc/guide/format_value.xhp b/source/text/scalc/guide/format_value.xhp index 852f4b26a1..515fbee7fc 100644 --- a/source/text/scalc/guide/format_value.xhp +++ b/source/text/scalc/guide/format_value.xhp @@ -38,7 +38,7 @@ <bookmark_value>deleting; decimal places</bookmark_value> <bookmark_value>decimal places; adding/deleting</bookmark_value> </bookmark><comment>mw changed "numbers;"</comment> -<paragraph xml-lang="en-US" id="hd_id3145367" role="heading" level="1"><variable id="format_value"><link href="text/scalc/guide/format_value.xhp" name="Formatting Numbers With Decimals">Formatting Numbers With Decimals</link> +<paragraph xml-lang="en-US" id="hd_id3145367" role="heading" level="1"><variable id="format_value"><link href="text/scalc/guide/format_value.xhp">Formatting Numbers With Decimals</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3148576" role="paragraph">Enter a number into the sheet, for example, 1234.5678. This number will be displayed in the default number format, with two decimal places. You will see 1234.57 when you confirm the entry. Only the display in the document will be rounded off; internally, the number retains all four decimal places after the decimal point.</paragraph> <paragraph xml-lang="en-US" id="par_id3154012" role="paragraph">To format numbers with decimals:</paragraph> diff --git a/source/text/scalc/guide/format_value_userdef.xhp b/source/text/scalc/guide/format_value_userdef.xhp index 7e3a949322..fb55ae2150 100644 --- a/source/text/scalc/guide/format_value_userdef.xhp +++ b/source/text/scalc/guide/format_value_userdef.xhp @@ -32,7 +32,7 @@ <bookmark_value>number formats; millions</bookmark_value> <bookmark_value>format codes; user-defined number formats</bookmark_value> </bookmark><comment>mw changed "numbers;"</comment> -<paragraph xml-lang="en-US" id="hd_id3143268" role="heading" level="1"><variable id="format_value_userdef"><link href="text/scalc/guide/format_value_userdef.xhp" name="User-defined Number Formats">User-defined Number Formats</link> +<paragraph xml-lang="en-US" id="hd_id3143268" role="heading" level="1"><variable id="format_value_userdef"><link href="text/scalc/guide/format_value_userdef.xhp">User-defined Number Formats</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3150400" role="paragraph">You can define your own number formats to display numbers in <item type="productname">%PRODUCTNAME</item> Calc.</paragraph> <paragraph xml-lang="en-US" id="par_id3150767" role="paragraph">As an example, to display the number 10,200,000 as 10.2 Million:</paragraph> diff --git a/source/text/scalc/guide/formula_copy.xhp b/source/text/scalc/guide/formula_copy.xhp index 0a1fe693d8..c0a84a5bff 100644 --- a/source/text/scalc/guide/formula_copy.xhp +++ b/source/text/scalc/guide/formula_copy.xhp @@ -34,7 +34,7 @@ <bookmark_value>copying; formulas</bookmark_value> <bookmark_value>pasting;formulas</bookmark_value> </bookmark><comment>mw added "pasting;" and changed "formulas;"</comment> -<paragraph role="heading" id="hd_id3151113" xml-lang="en-US" level="1"><variable id="formula_copy"><link href="text/scalc/guide/formula_copy.xhp" name="Copying Formulas">Copying Formulas</link> +<paragraph role="heading" id="hd_id3151113" xml-lang="en-US" level="1"><variable id="formula_copy"><link href="text/scalc/guide/formula_copy.xhp">Copying Formulas</link> </variable></paragraph> <section id="copytext"> <paragraph role="paragraph" id="par_id3156424" xml-lang="en-US">There are various ways to copy a formula. One suggested method is:</paragraph> diff --git a/source/text/scalc/guide/formula_enter.xhp b/source/text/scalc/guide/formula_enter.xhp index 7e9eddb68e..f2232906a1 100644 --- a/source/text/scalc/guide/formula_enter.xhp +++ b/source/text/scalc/guide/formula_enter.xhp @@ -34,7 +34,7 @@ <bookmark_value>formulas; inputting</bookmark_value> <bookmark_value>inserting;formulas</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3150868" xml-lang="en-US" level="1"><variable id="formula_enter"><link href="text/scalc/guide/formula_enter.xhp" name="Entering Formulas">Entering Formulas</link> +<paragraph role="heading" id="hd_id3150868" xml-lang="en-US" level="1"><variable id="formula_enter"><link href="text/scalc/guide/formula_enter.xhp">Entering Formulas</link> </variable></paragraph> <paragraph role="paragraph" id="par_id6848353" xml-lang="en-US">You can enter formulas in several ways: using the icons, or by typing on the keyboard, or by a mixture of both methods.</paragraph> <list type="ordered"> @@ -53,13 +53,13 @@ <paragraph role="paragraph" id="par_id4206976" xml-lang="en-US">You can also press the + or - key on the numerical keyboard to start a formula. NumLock must be "on". For example, press the following keys in succession:</paragraph> <paragraph role="code" id="par_id1836909" xml-lang="en-US">+ 5 0 - 8 Enter</paragraph> <paragraph role="paragraph" id="par_id8171330" xml-lang="en-US">You see the result <item type="literal">42</item> in the cell. The cell contains the formula <item type="literal">=+50-8</item>.</paragraph> -<paragraph role="note" id="par_id3155764" xml-lang="en-US">If you are editing a formula with references, the references and the associated cells will be highlighted with the same color. You can now resize the reference border using the mouse, and the reference in the formula displayed in the input line also changes. <emph>Show references in color</emph> can be deactivated under <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060300.xhp" name="Spreadsheet - View">%PRODUCTNAME Calc - View</link>.</paragraph> +<paragraph role="note" id="par_id3155764" xml-lang="en-US">If you are editing a formula with references, the references and the associated cells will be highlighted with the same color. You can now resize the reference border using the mouse, and the reference in the formula displayed in the input line also changes. <emph>Show references in color</emph> can be deactivated under <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060300.xhp">%PRODUCTNAME Calc - View</link>.</paragraph> <paragraph role="tip" id="par_id3149210" xml-lang="en-US"><variable id="tip">If you would like to view the calculation of individual elements of a formula, select the respective elements and press F9. For example, in the formula =SUM(A1:B12)*SUM(C1:D12) select the section SUM(C1:D12) and press F9 to view the subtotal for this area. </variable></paragraph> -<paragraph role="paragraph" id="par_id3150304" xml-lang="en-US">If an error occurs when creating the formula, an <link href="text/scalc/05/02140000.xhp" name="error message">error message</link> appears in the active cell.</paragraph> +<paragraph role="paragraph" id="par_id3150304" xml-lang="en-US">If an error occurs when creating the formula, an <link href="text/scalc/05/02140000.xhp">error message</link> appears in the active cell.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/formulas.xhp#formulas"/> -<paragraph role="paragraph" id="par_id3152993" xml-lang="en-US"><link href="text/scalc/main0206.xhp" name="Formula bar">Formula bar</link></paragraph> +<paragraph role="paragraph" id="par_id3152993" xml-lang="en-US"><link href="text/scalc/main0206.xhp">Formula bar</link></paragraph> <embed href="text/scalc/guide/cell_enter.xhp#cell_enter"/> <embed href="text/scalc/guide/multitables.xhp#multitables"/> <embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> diff --git a/source/text/scalc/guide/formula_value.xhp b/source/text/scalc/guide/formula_value.xhp index e125921f0d..b2529ef5b9 100644 --- a/source/text/scalc/guide/formula_value.xhp +++ b/source/text/scalc/guide/formula_value.xhp @@ -36,7 +36,7 @@ <bookmark_value>results display vs. formulas display</bookmark_value> <bookmark_value>displaying; formulas instead of results</bookmark_value> </bookmark><comment>mw inserted "displaying;..." entry from shared/optionen/01060100.xhp. Adding (Calc) is no longer necessary in this file. mw made "results;..." a two level entry.</comment> -<paragraph role="heading" id="hd_id3153195" xml-lang="en-US" level="1"><variable id="formula_value"><link href="text/scalc/guide/formula_value.xhp" name="Displaying Formulas or Values">Displaying Formulas or Values</link> +<paragraph role="heading" id="hd_id3153195" xml-lang="en-US" level="1"><variable id="formula_value"><link href="text/scalc/guide/formula_value.xhp">Displaying Formulas or Values</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3150010" xml-lang="en-US">If you want to display the formulas in the cells, for example in the form =SUM(A1:B5), proceed as follows:</paragraph> <list type="ordered"> @@ -49,7 +49,7 @@ </list> <paragraph role="paragraph" id="par_id3147396" xml-lang="en-US">If you want to view the calculation results instead of the formula, do not mark the Formulas box.</paragraph> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3153157" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060100.xhp" name="Spreadsheet - View">%PRODUCTNAME Calc - View</link></paragraph> +<paragraph role="paragraph" id="par_id3153157" xml-lang="en-US"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060100.xhp">%PRODUCTNAME Calc - View</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/formulas.xhp b/source/text/scalc/guide/formulas.xhp index acc8ae6b0c..29b34c69cc 100644 --- a/source/text/scalc/guide/formulas.xhp +++ b/source/text/scalc/guide/formulas.xhp @@ -32,7 +32,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3155411"><bookmark_value>formulas;calculating with</bookmark_value> <bookmark_value>calculating; with formulas</bookmark_value> <bookmark_value>examples;formula calculation</bookmark_value> -</bookmark><paragraph role="heading" id="hd_id3155411" xml-lang="en-US" level="1"><variable id="formulas"><link href="text/scalc/guide/formulas.xhp" name="Calculating With Formulas">Calculating With Formulas</link> +</bookmark><paragraph role="heading" id="hd_id3155411" xml-lang="en-US" level="1"><variable id="formulas"><link href="text/scalc/guide/formulas.xhp">Calculating With Formulas</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3156281" xml-lang="en-US">All formulas begin with an equals sign. The formulas can contain numbers, text, arithmetic operators, logic operators, or functions.</paragraph> <paragraph role="tip" id="par_id3145272" xml-lang="en-US">Remember that the basic arithmetic operators (+, -, *, /) can be used in formulas using the "Multiplication and Division before Addition and Subtraction" rule. Instead of writing =SUM(A1:B1) you can write =A1+B1.</paragraph> @@ -99,8 +99,8 @@ <paragraph role="paragraph" id="par_id3150109" xml-lang="en-US">It is also possible to nest functions in formulas, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> -<paragraph role="paragraph" id="par_id3150213" xml-lang="en-US"><link href="text/scalc/01/04060100.xhp" name="Functions list">Functions list</link></paragraph> -<paragraph role="paragraph" id="par_id3152869" xml-lang="en-US"><link href="text/scalc/01/04060000.xhp" name="AutoPilot: Functions">Function Wizard</link></paragraph> +<paragraph role="paragraph" id="par_id3150213" xml-lang="en-US"><link href="text/scalc/01/04060100.xhp">Functions list</link></paragraph> +<paragraph role="paragraph" id="par_id3152869" xml-lang="en-US"><link href="text/scalc/01/04060000.xhp">Function Wizard</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/fraction_enter.xhp b/source/text/scalc/guide/fraction_enter.xhp index b3917bafb0..f0191fccb5 100644 --- a/source/text/scalc/guide/fraction_enter.xhp +++ b/source/text/scalc/guide/fraction_enter.xhp @@ -34,7 +34,7 @@ <bookmark_value>numbers; entering fractions </bookmark_value> <bookmark_value>inserting;fractions</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3155411" xml-lang="en-US" level="1"><variable id="fraction_enter"><link href="text/scalc/guide/fraction_enter.xhp" name="Entering Fractions ">Entering Fractions </link> +<paragraph role="heading" id="hd_id3155411" xml-lang="en-US" level="1"><variable id="fraction_enter"><link href="text/scalc/guide/fraction_enter.xhp">Entering Fractions </link> </variable></paragraph> <section id="fractiontext"> <paragraph role="paragraph" id="par_id3153968" xml-lang="en-US">You can enter a fractional number in a cell and use it for calculation:</paragraph> diff --git a/source/text/scalc/guide/goalseek.xhp b/source/text/scalc/guide/goalseek.xhp index 69a77fb339..f17b3b4dec 100644 --- a/source/text/scalc/guide/goalseek.xhp +++ b/source/text/scalc/guide/goalseek.xhp @@ -34,7 +34,7 @@ <bookmark_value>variables;calculating equations</bookmark_value> <bookmark_value>examples;goal seek</bookmark_value> </bookmark><comment>mw changed "goal seek example" to "goal seeking;"</comment> -<paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="1"><variable id="goalseek"><link href="text/scalc/guide/goalseek.xhp" name="Applying Goal Seek">Applying Goal Seek</link> +<paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="1"><variable id="goalseek"><link href="text/scalc/guide/goalseek.xhp">Applying Goal Seek</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3145171" xml-lang="en-US">With the help of Goal Seek you can calculate a value that, as part of a formula, leads to the result you specify for the formula. You thus define the formula with several fixed values and one variable value and the result of the formula.</paragraph> <paragraph role="heading" id="hd_id3153966" xml-lang="en-US" level="2">Goal Seek Example</paragraph> @@ -60,7 +60,7 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3149409" xml-lang="en-US"><link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link></paragraph> +<paragraph role="paragraph" id="par_id3149409" xml-lang="en-US"><link href="text/scalc/01/06040000.xhp">Goal Seek</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/html_doc.xhp b/source/text/scalc/guide/html_doc.xhp index 2a98b9e9ee..2c7a800184 100644 --- a/source/text/scalc/guide/html_doc.xhp +++ b/source/text/scalc/guide/html_doc.xhp @@ -34,7 +34,7 @@ <bookmark_value>saving; sheets in HTML</bookmark_value> <bookmark_value>opening; sheets in HTML</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3150542" xml-lang="en-US" level="1"><variable id="html_doc"><link href="text/scalc/guide/html_doc.xhp" name="Saving and Opening Sheets in HTML">Saving and Opening Sheets in HTML</link> +<paragraph role="heading" id="hd_id3150542" xml-lang="en-US" level="1"><variable id="html_doc"><link href="text/scalc/guide/html_doc.xhp">Saving and Opening Sheets in HTML</link> </variable></paragraph> <paragraph role="heading" id="hd_id3154124" xml-lang="en-US" level="2">Saving Sheets in HTML</paragraph> <paragraph role="paragraph" id="par_id3145785" xml-lang="en-US"> @@ -64,8 +64,8 @@ <embed href="text/simpress/guide/html_export.xhp#html_export"/> <embed href="text/swriter/guide/send2html.xhp#send2html"/> <embed href="text/scalc/guide/webquery.xhp#webquery"/> -<paragraph role="paragraph" id="par_id3150370" xml-lang="en-US"><link href="text/shared/01/01020000.xhp" name="File - Open">File - Open</link></paragraph> -<paragraph role="paragraph" id="par_id3150199" xml-lang="en-US"><link href="text/shared/01/01070000.xhp" name="File - Save As">File - Save As</link></paragraph> +<paragraph role="paragraph" id="par_id3150370" xml-lang="en-US"><link href="text/shared/01/01020000.xhp">File - Open</link></paragraph> +<paragraph role="paragraph" id="par_id3150199" xml-lang="en-US"><link href="text/shared/01/01070000.xhp">File - Save As</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/integer_leading_zero.xhp b/source/text/scalc/guide/integer_leading_zero.xhp index 8380d830bd..70391f0582 100644 --- a/source/text/scalc/guide/integer_leading_zero.xhp +++ b/source/text/scalc/guide/integer_leading_zero.xhp @@ -39,7 +39,7 @@ </bookmark> <comment>UFI: inserted "converting;text to numbers"</comment><comment>mw changed "converting;" and deleted "numbers,changing..."</comment> -<paragraph id="hd_id3147560" role="heading" level="1" xml-lang="en-US"><variable id="integer_leading_zero"><link href="text/scalc/guide/integer_leading_zero.xhp" name="Entering a Number with Leading Zeros">Entering a Number with Leading Zeros</link></variable></paragraph> +<paragraph id="hd_id3147560" role="heading" level="1" xml-lang="en-US"><variable id="integer_leading_zero"><link href="text/scalc/guide/integer_leading_zero.xhp">Entering a Number with Leading Zeros</link></variable></paragraph> <section id="inttext"> <paragraph id="par_id3153194" role="paragraph" xml-lang="en-US">There are various ways to enter integers starting with a zero:</paragraph> diff --git a/source/text/scalc/guide/keyboard.xhp b/source/text/scalc/guide/keyboard.xhp index e827a77a97..72c6461195 100644 --- a/source/text/scalc/guide/keyboard.xhp +++ b/source/text/scalc/guide/keyboard.xhp @@ -33,7 +33,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3145120"><bookmark_value>accessibility; %PRODUCTNAME Calc shortcuts</bookmark_value> <bookmark_value>shortcut keys;%PRODUCTNAME Calc accessibility</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3145120" xml-lang="en-US" level="1"><variable id="keyboard"><link href="text/scalc/guide/keyboard.xhp" name="Shortcut Keys (%PRODUCTNAME Calc Accessibility)">Shortcut Keys (<item type="productname">%PRODUCTNAME</item> Calc Accessibility)</link> +<paragraph role="heading" id="hd_id3145120" xml-lang="en-US" level="1"><variable id="keyboard"><link href="text/scalc/guide/keyboard.xhp">Shortcut Keys (<item type="productname">%PRODUCTNAME</item> Calc Accessibility)</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3154760" xml-lang="en-US">Refer also to the lists of shortcut keys for <item type="productname">%PRODUCTNAME</item> Calc and <item type="productname">%PRODUCTNAME</item> in general.</paragraph> <embed href="text/shared/00/00000099.xhp#keys"/> @@ -53,7 +53,7 @@ <paragraph role="paragraph" id="par_id3145272" xml-lang="en-US">In the cell selection mode, you can use the common navigation keys to select cells.</paragraph> <paragraph role="heading" id="hd_id3148646" xml-lang="en-US" level="2">Controlling the Outline</paragraph> -<paragraph role="paragraph" id="par_id3146120" xml-lang="en-US">You can use the keyboard in <link href="text/scalc/01/12080000.xhp" name="Outline">Outline</link>:</paragraph> +<paragraph role="paragraph" id="par_id3146120" xml-lang="en-US">You can use the keyboard in <link href="text/scalc/01/12080000.xhp">Outline</link>:</paragraph> <list type="unordered"> <listitem> <paragraph role="listitem" id="par_id3147394" xml-lang="en-US">Press <item type="keycode">F6</item> or <item type="keycode">Shift+F6</item> until the vertical or horizontal outline window has the focus.</paragraph> diff --git a/source/text/scalc/guide/line_fix.xhp b/source/text/scalc/guide/line_fix.xhp index 688669bad3..93e8e4790c 100644 --- a/source/text/scalc/guide/line_fix.xhp +++ b/source/text/scalc/guide/line_fix.xhp @@ -40,7 +40,7 @@ </bookmark> -<h1 id="hd_id3154684" xml-lang="en-US"><variable id="line_fix"><link href="text/scalc/guide/line_fix.xhp" name="Freezing Rows or Columns as Headers">Freezing Rows or Columns as Headers</link> </variable></h1> +<h1 id="hd_id3154684" xml-lang="en-US"><variable id="line_fix"><link href="text/scalc/guide/line_fix.xhp">Freezing Rows or Columns as Headers</link> </variable></h1> <paragraph id="par_id3148576" role="paragraph" xml-lang="en-US">If you have long rows or columns of data that extend beyond the viewable area of the sheet, you can freeze some rows or columns, which allows you to see the frozen columns or rows as you scroll through the rest of the data.</paragraph> <list type="ordered"> @@ -57,10 +57,10 @@ <paragraph id="par_id3147345" role="note" xml-lang="en-US">If you want to print a certain row on all pages of a document, choose <item type="menuitem">Format - Print ranges - Edit</item>.</paragraph> <section id="relatedtopics"> -<paragraph id="par_id3147004" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/07090000.xhp" name="View - Freeze Cells - Freeze Rows and Columns">View - Freeze Rows and Columns</link></paragraph> -<paragraph id="par_id3150088" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/07080000.xhp" name="View - Split">View - Split Window</link></paragraph> +<paragraph id="par_id3147004" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/07090000.xhp">View - Freeze Rows and Columns</link></paragraph> +<paragraph id="par_id3150088" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/07080000.xhp">View - Split Window</link></paragraph> <embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/> -<paragraph id="par_id3150304" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/05080300.xhp" name="Format - Print ranges - Edit">Format - Print ranges - Edit</link></paragraph> +<paragraph id="par_id3150304" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/05080300.xhp">Format - Print ranges - Edit</link></paragraph> </section> </body> diff --git a/source/text/scalc/guide/main.xhp b/source/text/scalc/guide/main.xhp index 771a35c2b6..3c7ffc299f 100644 --- a/source/text/scalc/guide/main.xhp +++ b/source/text/scalc/guide/main.xhp @@ -31,7 +31,7 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150770"><bookmark_value>HowTos for Calc</bookmark_value> <bookmark_value>instructions; $[officename] Calc</bookmark_value> -</bookmark><comment>MWdeleted one entry and added one</comment><paragraph role="heading" id="hd_id3150770" xml-lang="en-US" level="1"><variable id="main"><link href="text/scalc/guide/main.xhp" name="Instructions for Using $[officename] Calc">Instructions for Using $[officename] Calc</link> +</bookmark><comment>MWdeleted one entry and added one</comment><paragraph role="heading" id="hd_id3150770" xml-lang="en-US" level="1"><variable id="main"><link href="text/scalc/guide/main.xhp">Instructions for Using $[officename] Calc</link> </variable></paragraph> <embed href="text/shared/00/00000099.xhp#table"/> <paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2">Formatting Tables and Cells</paragraph> diff --git a/source/text/scalc/guide/mark_cells.xhp b/source/text/scalc/guide/mark_cells.xhp index ab777c706e..73eea1c8af 100644 --- a/source/text/scalc/guide/mark_cells.xhp +++ b/source/text/scalc/guide/mark_cells.xhp @@ -34,7 +34,7 @@ <bookmark_value>selection modes in spreadsheets</bookmark_value> <bookmark_value>tables; selecting ranges</bookmark_value> </bookmark><comment>mw changed "selection modes..."</comment> -<paragraph xml-lang="en-US" id="hd_id3153361" role="heading" level="1"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp" name="Selecting Multiple Cells">Selecting Multiple Cells</link> +<paragraph xml-lang="en-US" id="hd_id3153361" role="heading" level="1"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp">Selecting Multiple Cells</link> </variable></paragraph> <paragraph xml-lang="en-US" id="hd_id3145272" role="heading" level="2">Select a rectangular range</paragraph> <paragraph xml-lang="en-US" id="par_id3149261" role="paragraph">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.</paragraph> @@ -98,7 +98,7 @@ </table> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3154487" role="paragraph"><link href="text/scalc/main0208.xhp" name="Status bar">Status bar</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3154487" role="paragraph"><link href="text/scalc/main0208.xhp">Status bar</link></paragraph> </section> </body> </helpdocument>
\ No newline at end of file diff --git a/source/text/scalc/guide/matrixformula.xhp b/source/text/scalc/guide/matrixformula.xhp index 8766483f14..533f1f7dd0 100644 --- a/source/text/scalc/guide/matrixformula.xhp +++ b/source/text/scalc/guide/matrixformula.xhp @@ -34,7 +34,7 @@ <bookmark_value>formulas; matrix formulas</bookmark_value> <bookmark_value>inserting;matrix formulas</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3153969" xml-lang="en-US" level="1"><variable id="matrixformula"><link href="text/scalc/guide/matrixformula.xhp" name="Entering Matrix Formulas">Entering Matrix Formulas</link> +<paragraph role="heading" id="hd_id3153969" xml-lang="en-US" level="1"><variable id="matrixformula"><link href="text/scalc/guide/matrixformula.xhp">Entering Matrix Formulas</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3153144" xml-lang="en-US">The following is an example of how you can enter a matrix formula, without going into the details of matrix functions.</paragraph> <paragraph role="paragraph" id="par_id3153188" xml-lang="en-US">Assume you have entered 10 numbers in Columns A and B (A1:A10 and B1:B10), and would like to calculate the sum of each row in Column C.</paragraph> diff --git a/source/text/scalc/guide/multi_tables.xhp b/source/text/scalc/guide/multi_tables.xhp index 54efa74b14..8639535346 100644 --- a/source/text/scalc/guide/multi_tables.xhp +++ b/source/text/scalc/guide/multi_tables.xhp @@ -36,7 +36,7 @@ <bookmark_value>sheet tabs;using</bookmark_value> <bookmark_value>views;multiple sheets</bookmark_value> </bookmark> - <paragraph xml-lang="en-US" id="hd_id3150769" role="heading" level="1"><variable id="multi_tables"><link href="text/scalc/guide/multi_tables.xhp" name="Navigating Through Sheet Tabs">Navigating Through Sheet Tabs</link> + <paragraph xml-lang="en-US" id="hd_id3150769" role="heading" level="1"><variable id="multi_tables"><link href="text/scalc/guide/multi_tables.xhp">Navigating Through Sheet Tabs</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153771" role="paragraph">By default $[officename] displays three sheets "Sheet1" to "Sheet3", in each new spreadsheet. You can switch between sheets in a spreadsheet using the sheet tabs at the bottom of the screen.</paragraph> <paragraph xml-lang="en-US" id="par_idN106AF" role="paragraph"> diff --git a/source/text/scalc/guide/multioperation.xhp b/source/text/scalc/guide/multioperation.xhp index 8a4a8e0e02..a4f6413cd8 100644 --- a/source/text/scalc/guide/multioperation.xhp +++ b/source/text/scalc/guide/multioperation.xhp @@ -33,7 +33,7 @@ <bookmark_value>data tables; multiple operations in</bookmark_value> <bookmark_value>cross-classified tables</bookmark_value> </bookmark><comment>mw made "what if operations" a two level entry</comment> -<h1 id="hd_id3147559"><variable id="multioperation"><link href="text/scalc/guide/multioperation.xhp" name="Applying Multiple Operations">Applying Multiple Operations</link> +<h1 id="hd_id3147559"><variable id="multioperation"><link href="text/scalc/guide/multioperation.xhp">Applying Multiple Operations</link> </variable></h1> <h2 id="hd_id3145171">Multiple Operations in Columns or Rows</h2> <paragraph role="paragraph" id="par_id4123966" xml-lang="en-US">The <item type="menuitem">Data - Multiple Operations</item> command provides a planning tool for "what if" questions. In your spreadsheet, you enter a formula to calculate a result from values that are stored in other cells. Then, you set up a cell range where you enter some fixed values, and the Multiple Operations command will calculate the results depending on the formula.</paragraph> @@ -117,7 +117,7 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3155104" xml-lang="en-US"><link href="text/scalc/01/12060000.xhp" name="Multiple operations">Multiple operations</link></paragraph> +<paragraph role="paragraph" id="par_id3155104" xml-lang="en-US"><link href="text/scalc/01/12060000.xhp">Multiple operations</link></paragraph> <embed href="text/scalc/guide/scenario.xhp#scenario"/> </section> </body> diff --git a/source/text/scalc/guide/multitables.xhp b/source/text/scalc/guide/multitables.xhp index 7061c99dc3..20065e8204 100644 --- a/source/text/scalc/guide/multitables.xhp +++ b/source/text/scalc/guide/multitables.xhp @@ -35,7 +35,7 @@ <bookmark_value>multiple sheets</bookmark_value> <bookmark_value>calculating;multiple sheets</bookmark_value> </bookmark><comment>MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;"</comment> -<paragraph xml-lang="en-US" id="hd_id3154759" role="heading" level="1"><variable id="multitables"><link href="text/scalc/guide/multitables.xhp" name="Applying Multiple Sheets">Applying Multiple Sheets</link> +<paragraph xml-lang="en-US" id="hd_id3154759" role="heading" level="1"><variable id="multitables"><link href="text/scalc/guide/multitables.xhp">Applying Multiple Sheets</link> </variable></paragraph> <paragraph xml-lang="en-US" id="hd_id3148576" role="heading" level="2">Inserting a Sheet</paragraph> <list type="ordered"> diff --git a/source/text/scalc/guide/note_insert.xhp b/source/text/scalc/guide/note_insert.xhp index ca75f649c9..4cdd8827bd 100644 --- a/source/text/scalc/guide/note_insert.xhp +++ b/source/text/scalc/guide/note_insert.xhp @@ -34,9 +34,9 @@ <bookmark_value>viewing;comments on cells</bookmark_value> <bookmark_value>displaying; comments</bookmark_value> </bookmark><comment>MW deleted double index "comments;on cells" and copied "displaying;comments" from shared/optionen/01060100.xhp</comment> -<paragraph xml-lang="en-US" id="hd_id3153968" role="heading" level="1"><variable id="note_insert"><link href="text/scalc/guide/note_insert.xhp" name="Inserting and Editing Comments">Inserting and Editing Comments</link> +<paragraph xml-lang="en-US" id="hd_id3153968" role="heading" level="1"><variable id="note_insert"><link href="text/scalc/guide/note_insert.xhp">Inserting and Editing Comments</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3150440" xml-lang="en-US">You can assign a comment to each cell by choosing <link href="text/shared/01/04050000.xhp" name="Insert - Comment"><emph>Insert - Comment</emph></link>. The comment is indicated by a small red square, the comment indicator, in the cell.</paragraph> +<paragraph role="paragraph" id="par_id3150440" xml-lang="en-US">You can assign a comment to each cell by choosing <link href="text/shared/01/04050000.xhp"><emph>Insert - Comment</emph></link>. The comment is indicated by a small red square, the comment indicator, in the cell.</paragraph> <list type="unordered"> <listitem> <paragraph role="listitem" id="par_id3145750" xml-lang="en-US">The comment is visible whenever the mouse pointer is over the cell.</paragraph> @@ -59,7 +59,7 @@ </list> <paragraph role="paragraph" id="par_id3150715" xml-lang="en-US">To display a help tip for a selected cell, use <emph>Data - Validity - Input Help</emph>.</paragraph> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3153707" xml-lang="en-US"><link href="text/shared/01/04050000.xhp" name="Insert - Comment">Insert - Comment</link></paragraph> +<paragraph role="paragraph" id="par_id3153707" xml-lang="en-US"><link href="text/shared/01/04050000.xhp">Insert - Comment</link></paragraph> <embed href="text/scalc/guide/validity.xhp#validity"/> </section> </body> diff --git a/source/text/scalc/guide/numbers_text.xhp b/source/text/scalc/guide/numbers_text.xhp index e63054fb0c..80085077c4 100644 --- a/source/text/scalc/guide/numbers_text.xhp +++ b/source/text/scalc/guide/numbers_text.xhp @@ -33,7 +33,7 @@ <bookmark_value>date formats;conversion</bookmark_value> <bookmark_value>converting;text, into numbers</bookmark_value> </bookmark> - <h1 id="hd_id0908200901265171"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp" name="Converting Text to Numbers">Converting Text to Numbers</link></variable></h1> + <h1 id="hd_id0908200901265171"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp">Converting Text to Numbers</link></variable></h1> <section id="text"> <paragraph xml-lang="en-US" id="par_id0908200901265127" role="paragraph">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.</paragraph> <paragraph xml-lang="en-US" id="par_id0908200901265196" role="paragraph"><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.</paragraph> @@ -81,12 +81,12 @@ <paragraph role="paragraph" id="par_id611567607779380"><literal>=SUM("1E2";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.</paragraph> </section> <h2 id="hd_id871567772424915">Changing the default text to number conversion settings</h2> - <paragraph role="paragraph" id="par_id111567772433803">The text to number conversion can be customized in the <link href="text/shared/optionen/detailedcalculation.xhp" name="detailed_link">Detailed Calculation Settings</link> option.</paragraph> + <paragraph role="paragraph" id="par_id111567772433803">The text to number conversion can be customized in the <link href="text/shared/optionen/detailedcalculation.xhp">Detailed Calculation Settings</link> option.</paragraph> <section id="relatedtopics"> <embed href="text/shared/optionen/detailedcalculation.xhp#detailed_heading"/> <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> <embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> - <paragraph xml-lang="en-US" id="par_id0908200901265544" role="paragraph"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> + <paragraph xml-lang="en-US" id="par_id0908200901265544" role="paragraph"><link href="text/shared/01/05020300.xhp">Format - Cells - Numbers</link></paragraph> <embed href="text/scalc/guide/format_value.xhp#format_value"/> </section> </body> diff --git a/source/text/scalc/guide/pivotchart.xhp b/source/text/scalc/guide/pivotchart.xhp index 80dc442ad4..03136db32d 100644 --- a/source/text/scalc/guide/pivotchart.xhp +++ b/source/text/scalc/guide/pivotchart.xhp @@ -20,9 +20,9 @@ <bookmark_value>chart;pivot chart</bookmark_value> <bookmark_value>pivot table;pivot chart</bookmark_value> </bookmark> - <h1 id="hd_id141525139671420"><variable id="pivotchart"><link href="text/scalc/guide/pivotchart.xhp" name="Pivot Chart">Pivot Chart</link></variable></h1> + <h1 id="hd_id141525139671420"><variable id="pivotchart"><link href="text/scalc/guide/pivotchart.xhp">Pivot Chart</link></variable></h1> - <paragraph role="paragraph" id="par_id291525139878423" xml-lang="en-US">A pivot chart is a chart with data range and data series of a <link href="text/scalc/guide/datapilot.xhp" name="Pivot Table">pivot table</link>.</paragraph> + <paragraph role="paragraph" id="par_id291525139878423" xml-lang="en-US">A pivot chart is a chart with data range and data series of a <link href="text/scalc/guide/datapilot.xhp">pivot table</link>.</paragraph> <paragraph role="paragraph" id="par_id911525139890364" xml-lang="en-US">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.</paragraph> <paragraph role="paragraph" id="par_id201525141351484" xml-lang="en-US">Pivot charts track the changes in the data issued from a pivot table and adjust the data series and data range accordingly.</paragraph> @@ -34,7 +34,7 @@ <embed href="text/scalc/guide/pivotchart_update.xhp#pivotchartupdate"/> <embed href="text/scalc/guide/pivotchart_filter.xhp#pivotchartfilter"/> <embed href="text/scalc/guide/pivotchart_delete.xhp#pivotchartdelete"/> - <paragraph role="paragraph" id="par_id191525177790601" xml-lang="en-US"><link href="https://tomazvajngerl.blogspot.com/2017/03/pivot-charts-in-libreoffice-part-1.html" name="Tomaž Vajngerl blog">Technical details on %PRODUCTNAME pivot chart implementation</link>.</paragraph> + <paragraph role="paragraph" id="par_id191525177790601" xml-lang="en-US"><link href="https://tomazvajngerl.blogspot.com/2017/03/pivot-charts-in-libreoffice-part-1.html">Technical details on %PRODUCTNAME pivot chart implementation</link>.</paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/pivotchart_create.xhp b/source/text/scalc/guide/pivotchart_create.xhp index a4ff84dcf2..a960da8cd1 100644 --- a/source/text/scalc/guide/pivotchart_create.xhp +++ b/source/text/scalc/guide/pivotchart_create.xhp @@ -19,7 +19,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id531525141739769"> <bookmark_value>pivot chart;creating</bookmark_value> </bookmark> - <paragraph role="heading" id="hd_id441525141699185" level="1" xml-lang="en-US"><variable id="pivotchartcreate"><link href="text/scalc/guide/pivotchart_create.xhp" name="pivot chart create">Creating Pivot Charts</link></variable></paragraph> + <paragraph role="heading" id="hd_id441525141699185" level="1" xml-lang="en-US"><variable id="pivotchartcreate"><link href="text/scalc/guide/pivotchart_create.xhp">Creating Pivot Charts</link></variable></paragraph> <paragraph role="paragraph" id="par_id481525142550652" xml-lang="en-US">To create a pivot chart proceed as below:</paragraph> <list type="ordered"> <listitem> @@ -33,13 +33,13 @@ <paragraph role="paragraph" id="par_id151525140367370" xml-lang="en-US">%PRODUCTNAME Calc automatically detects the pivot table and opens the pivot chart wizard.</paragraph> <list type="ordered" startwith="3"> <listitem> - <paragraph id="par_id861525140391601" role="listitem" xml-lang="en-US">Select the <link href="text/schart/01/wiz_chart_type.xhp" name="Chart type">Chart type</link> for the data in the chart wizard.</paragraph> + <paragraph id="par_id861525140391601" role="listitem" xml-lang="en-US">Select the <link href="text/schart/01/wiz_chart_type.xhp">Chart type</link> for the data in the chart wizard.</paragraph> </listitem> </list> <paragraph xml-lang="en-US" id="par_id41525141917275" role="note">The data range and the data series pages of the chart wizard are not enabled. They are controlled by the pivot table.</paragraph> <list type="ordered" startwith="4"> <listitem> - <paragraph id="par_id511525140411625" role="listitem" xml-lang="en-US">Select the <link href="text/schart/01/wiz_chart_elements.xhp" name="Chart elements">Chart Elements</link> of the pivot chart in the wizard.</paragraph> + <paragraph id="par_id511525140411625" role="listitem" xml-lang="en-US">Select the <link href="text/schart/01/wiz_chart_elements.xhp">Chart Elements</link> of the pivot chart in the wizard.</paragraph> </listitem> <listitem> <paragraph id="par_id1001525165156188" role="listitem" xml-lang="en-US">Click <emph>OK</emph> to close the wizard and create the pivot chart.</paragraph> diff --git a/source/text/scalc/guide/pivotchart_delete.xhp b/source/text/scalc/guide/pivotchart_delete.xhp index 597730164c..3a57a36437 100644 --- a/source/text/scalc/guide/pivotchart_delete.xhp +++ b/source/text/scalc/guide/pivotchart_delete.xhp @@ -16,7 +16,7 @@ </topic> </meta> <body> - <paragraph role="heading" id="hd_id231525147891984" level="1" xml-lang="en-US"><variable id="pivotchartdelete"><link href="text/scalc/guide/pivotchart_delete.xhp" name="Deleting a Pivot Chart">Deleting a Pivot Chart</link></variable></paragraph> + <paragraph role="heading" id="hd_id231525147891984" level="1" xml-lang="en-US"><variable id="pivotchartdelete"><link href="text/scalc/guide/pivotchart_delete.xhp">Deleting a Pivot Chart</link></variable></paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id231525149357908"> <bookmark_value>pivot chart;deleting</bookmark_value> </bookmark> diff --git a/source/text/scalc/guide/pivotchart_edit.xhp b/source/text/scalc/guide/pivotchart_edit.xhp index 428edacd37..8666b70fa9 100644 --- a/source/text/scalc/guide/pivotchart_edit.xhp +++ b/source/text/scalc/guide/pivotchart_edit.xhp @@ -19,7 +19,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id661525144028976"> <bookmark_value>pivot chart;editing</bookmark_value> </bookmark> - <paragraph role="heading" id="hd_id271525144002806" level="1" xml-lang="en-US"><variable id="pivotchartedit"><link href="text/scalc/guide/pivotchart_edit.xhp" name="Pivot Chart Editing">Editing Pivot Charts</link></variable></paragraph> + <paragraph role="heading" id="hd_id271525144002806" level="1" xml-lang="en-US"><variable id="pivotchartedit"><link href="text/scalc/guide/pivotchart_edit.xhp">Editing Pivot Charts</link></variable></paragraph> <paragraph role="paragraph" id="par_id971525144066574" xml-lang="en-US">Edit a pivot chart in the same way as normal charts.</paragraph> <paragraph xml-lang="en-US" id="hd_id5631580" role="heading" level="2">To edit a pivot chart</paragraph> <embed href="text/schart/main0000.xhp#chartedit"/> diff --git a/source/text/scalc/guide/pivotchart_filter.xhp b/source/text/scalc/guide/pivotchart_filter.xhp index 11ccabb53c..5a6269f821 100644 --- a/source/text/scalc/guide/pivotchart_filter.xhp +++ b/source/text/scalc/guide/pivotchart_filter.xhp @@ -16,8 +16,8 @@ </topic> </meta> <body> - <paragraph role="heading" id="hd_id401525165755583" level="1" xml-lang="en-US"><variable id="pivotchartfilter"><link href="text/scalc/guide/pivotchart_filter.xhp" name="Filtering Pivot Charts">Filtering Pivot Charts</link></variable></paragraph> - <paragraph role="paragraph" id="par_id781525166702239" xml-lang="en-US">Filters are used to remove unwanted data from the pivot chart. You can use filters in the pivot chart or in the corresponding <link href="text/scalc/guide/datapilot_filtertable.xhp" name="Pivot table filtering">pivot table</link>, since the resulting chart is exactly the same.</paragraph> + <paragraph role="heading" id="hd_id401525165755583" level="1" xml-lang="en-US"><variable id="pivotchartfilter"><link href="text/scalc/guide/pivotchart_filter.xhp">Filtering Pivot Charts</link></variable></paragraph> + <paragraph role="paragraph" id="par_id781525166702239" xml-lang="en-US">Filters are used to remove unwanted data from the pivot chart. You can use filters in the pivot chart or in the corresponding <link href="text/scalc/guide/datapilot_filtertable.xhp">pivot table</link>, since the resulting chart is exactly the same.</paragraph> <paragraph role="heading" id="hd_id201525166689277" level="2" xml-lang="en-US">Pivot chart field buttons</paragraph> diff --git a/source/text/scalc/guide/pivotchart_update.xhp b/source/text/scalc/guide/pivotchart_update.xhp index 41cfed9cb2..64d793c2ec 100644 --- a/source/text/scalc/guide/pivotchart_update.xhp +++ b/source/text/scalc/guide/pivotchart_update.xhp @@ -19,7 +19,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id801525146393791"> <bookmark_value>pivot chart;update</bookmark_value> </bookmark> - <paragraph role="heading" id="hd_id281525146417678" level="1" xml-lang="en-US"><variable id="pivotchartupdate"><link href="text/scalc/guide/pivotchart_update.xhp" name="Pivot Chart Update">Updating Pivot Charts</link></variable></paragraph> + <paragraph role="heading" id="hd_id281525146417678" level="1" xml-lang="en-US"><variable id="pivotchartupdate"><link href="text/scalc/guide/pivotchart_update.xhp">Updating Pivot Charts</link></variable></paragraph> <paragraph role="paragraph" id="par_id831525146706944" xml-lang="en-US">If the data of the source sheet has been changed, you must refresh the pivot table and the pivot chart is updated accordingly. To refresh the pivot table (and thus the pivot chart):</paragraph> <list type="unordered"> <listitem> diff --git a/source/text/scalc/guide/print_details.xhp b/source/text/scalc/guide/print_details.xhp index 3d9a946038..56ee18d472 100644 --- a/source/text/scalc/guide/print_details.xhp +++ b/source/text/scalc/guide/print_details.xhp @@ -43,7 +43,7 @@ <bookmark_value>null values; printing</bookmark_value> <bookmark_value>draw objects;printing</bookmark_value> </bookmark><comment>mw inserted 4 index entries from text/scalc/01/05070500.xhp. Added "draw objects;..." entry and changed "formulas;..." entry</comment> -<paragraph role="heading" id="hd_id3154346" xml-lang="en-US" level="1"><variable id="print_details"><link href="text/scalc/guide/print_details.xhp" name="Printing Sheet Details">Printing Sheet Details</link> +<paragraph role="heading" id="hd_id3154346" xml-lang="en-US" level="1"><variable id="print_details"><link href="text/scalc/guide/print_details.xhp">Printing Sheet Details</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3153728" xml-lang="en-US">When printing a sheet you can select which details are to be printed:</paragraph> <list type="unordered"> @@ -86,7 +86,7 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3150345" xml-lang="en-US"><link href="text/scalc/01/03100000.xhp" name="View - Page Break">View - Page Break</link></paragraph> +<paragraph role="paragraph" id="par_id3150345" xml-lang="en-US"><link href="text/scalc/01/03100000.xhp">View - Page Break</link></paragraph> <embed href="text/scalc/guide/print_exact.xhp#print_exact"/> </section> </body> diff --git a/source/text/scalc/guide/print_exact.xhp b/source/text/scalc/guide/print_exact.xhp index 5e6715cd7f..64bf69d2d0 100644 --- a/source/text/scalc/guide/print_exact.xhp +++ b/source/text/scalc/guide/print_exact.xhp @@ -37,7 +37,7 @@ <bookmark_value>viewing;print ranges</bookmark_value> <bookmark_value>previews;page breaks for printing</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3153194" xml-lang="en-US" level="1"><variable id="print_exact"><link href="text/scalc/guide/print_exact.xhp" name="Defining Number of Pages for Printing">Defining Number of Pages for Printing</link> +<paragraph role="heading" id="hd_id3153194" xml-lang="en-US" level="1"><variable id="print_exact"><link href="text/scalc/guide/print_exact.xhp">Defining Number of Pages for Printing</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3153771" xml-lang="en-US">If a sheet is too large for a single printed page, $[officename] Calc will print the current sheet evenly divided over several pages. Since the automatic page break does not always take place in the optimal position, you can define the page distribution yourself.</paragraph> <list type="ordered"> @@ -55,7 +55,7 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US"><link href="text/scalc/01/03100000.xhp" name="View - Page Break">View - Page Break</link></paragraph> +<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US"><link href="text/scalc/01/03100000.xhp">View - Page Break</link></paragraph> <embed href="text/scalc/guide/print_landscape.xhp#print_landscape"/> <embed href="text/scalc/guide/print_details.xhp#print_details"/> </section> diff --git a/source/text/scalc/guide/print_landscape.xhp b/source/text/scalc/guide/print_landscape.xhp index dd0b279bd2..3491195e21 100644 --- a/source/text/scalc/guide/print_landscape.xhp +++ b/source/text/scalc/guide/print_landscape.xhp @@ -32,7 +32,7 @@ <bookmark_value>printing; landscape</bookmark_value> <bookmark_value>landscape printing</bookmark_value> </bookmark><comment>mw corrected a typo in "printing; sheet..."</comment> -<paragraph xml-lang="en-US" id="hd_id3153418" role="heading" level="1"><variable id="print_landscape"><link href="text/scalc/guide/print_landscape.xhp" name="Printing Sheets in Landscape Format">Printing Sheets in Landscape Format</link> +<paragraph xml-lang="en-US" id="hd_id3153418" role="heading" level="1"><variable id="print_landscape"><link href="text/scalc/guide/print_landscape.xhp">Printing Sheets in Landscape Format</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3149257" role="paragraph">In order to print a sheet you have a number of interactive options available under <emph>View - Page Break</emph>. Drag the delimiter lines to define the range of printed cells on each page.</paragraph> <paragraph xml-lang="en-US" id="par_id3153963" role="paragraph">To print in landscape format, proceed as follows:</paragraph> @@ -71,7 +71,7 @@ </list> <paragraph xml-lang="en-US" id="par_id3145076" role="paragraph">If under <emph>Format - Print ranges</emph> you have defined one or more print ranges, only the contents of these print ranges will be printed.</paragraph> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3156019" role="paragraph"><link href="text/scalc/01/03100000.xhp" name="View - Page Break">View - Page Break</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3156019" role="paragraph"><link href="text/scalc/01/03100000.xhp">View - Page Break</link></paragraph> <paragraph xml-lang="en-US" id="par_id8254646" role="paragraph"><link href="text/scalc/guide/printranges.xhp">Defining Print Ranges on a Sheet</link></paragraph> <embed href="text/scalc/guide/print_exact.xhp#print_exact"/> </section> diff --git a/source/text/scalc/guide/print_title_row.xhp b/source/text/scalc/guide/print_title_row.xhp index 0121006d37..b2a1520163 100644 --- a/source/text/scalc/guide/print_title_row.xhp +++ b/source/text/scalc/guide/print_title_row.xhp @@ -39,7 +39,7 @@ <bookmark_value>headings;repeating rows/columns as</bookmark_value> </bookmark><comment>mw deleted one index entry ("fixed...") and added "headings;..." entry</comment> <paragraph role="paragraph" id="par_id3151112" xml-lang="en-US" localize="false"/> -<h1 id="hd_id3153727"><variable id="print_title_row"><link href="text/scalc/guide/print_title_row.xhp" name="Printing Rows or Columns on Every Page">Printing Rows or Columns on Every Page</link> +<h1 id="hd_id3153727"><variable id="print_title_row"><link href="text/scalc/guide/print_title_row.xhp">Printing Rows or Columns on Every Page</link> </variable></h1> <paragraph role="paragraph" id="par_id3154014" xml-lang="en-US">If you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page.</paragraph> <paragraph role="paragraph" id="par_id3146975" xml-lang="en-US">As an example, If you want to print the top two rows of the sheet as well as the first column (A) on all pages, do the following:</paragraph> @@ -73,10 +73,10 @@ <paragraph role="paragraph" id="par_idN107A9" xml-lang="en-US" localize="false"> <embedvar href="text/scalc/guide/printranges.xhp#printranges"/> </paragraph> -<paragraph role="paragraph" id="par_id3155380" xml-lang="en-US"><link href="text/scalc/01/03100000.xhp" name="View - Page Break Preview">View - Page Break Preview</link></paragraph> +<paragraph role="paragraph" id="par_id3155380" xml-lang="en-US"><link href="text/scalc/01/03100000.xhp">View - Page Break Preview</link></paragraph> <embed href="text/scalc/guide/line_fix.xhp#line_fix"/> -<paragraph role="paragraph" id="par_id3154371" xml-lang="en-US"><link href="text/scalc/01/05080300.xhp" name="Format - Print ranges - Edit">Format - Print ranges - Edit</link></paragraph> -<paragraph role="paragraph" id="par_id3146113" xml-lang="en-US"><link href="text/scalc/01/05070000.xhp" name="Format - Page Style - (Header / Footer)">Format - Page Style - (Header / Footer)</link></paragraph> +<paragraph role="paragraph" id="par_id3154371" xml-lang="en-US"><link href="text/scalc/01/05080300.xhp">Format - Print ranges - Edit</link></paragraph> +<paragraph role="paragraph" id="par_id3146113" xml-lang="en-US"><link href="text/scalc/01/05070000.xhp">Format - Page Style - (Header / Footer)</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/relativ_absolut_ref.xhp b/source/text/scalc/guide/relativ_absolut_ref.xhp index 35d15b6a53..caa3d07a15 100644 --- a/source/text/scalc/guide/relativ_absolut_ref.xhp +++ b/source/text/scalc/guide/relativ_absolut_ref.xhp @@ -39,7 +39,7 @@ <bookmark_value>references; to cells</bookmark_value> <bookmark_value>cells; references</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3156423" xml-lang="en-US" level="1"><variable id="relativ_absolut_ref"><link href="text/scalc/guide/relativ_absolut_ref.xhp" name="Addresses and References, Absolute and Relative">Addresses and References, Absolute and Relative</link> +<paragraph role="heading" id="hd_id3156423" xml-lang="en-US" level="1"><variable id="relativ_absolut_ref"><link href="text/scalc/guide/relativ_absolut_ref.xhp">Addresses and References, Absolute and Relative</link> </variable></paragraph> <paragraph role="heading" id="hd_id3163712" xml-lang="en-US" level="2">Relative Addressing</paragraph> <paragraph role="paragraph" id="par_id3146119" xml-lang="en-US">The cell in column A, row 1 is addressed as A1. You can address a range of adjacent cells by first entering the coordinates of the upper left cell of the area, then a colon followed by the coordinates of the lower right cell. For example, the square formed by the first four cells in the upper left corner is addressed as A1:B2.</paragraph> diff --git a/source/text/scalc/guide/remove_duplicates.xhp b/source/text/scalc/guide/remove_duplicates.xhp index 812f261539..48a9065152 100644 --- a/source/text/scalc/guide/remove_duplicates.xhp +++ b/source/text/scalc/guide/remove_duplicates.xhp @@ -30,14 +30,14 @@ <bookmark_value>filters; removing duplicates</bookmark_value> <bookmark_value>filters; finding unique values</bookmark_value> </bookmark> - <h1 id="hd_id501630021281902"><variable id="filters"><link href="text/scalc/guide/remove_duplicates.xhp" name="Duplicates_h1">Removing Duplicate Values</link></variable></h1> + <h1 id="hd_id501630021281902"><variable id="filters"><link href="text/scalc/guide/remove_duplicates.xhp">Removing Duplicate Values</link></variable></h1> <paragraph xml-lang="en-US" id="par_id3150869" role="paragraph">Consider a single column with values where some may be duplicates. To remove duplicate values and obtain only the unique entries in the column:</paragraph> <list type="ordered"> <listitem> <paragraph id="par_id631630021463659" role="listitem">Select the range of values from which duplicate values are to be removed. The values have to be arranged in a single column.</paragraph> </listitem> <listitem> - <paragraph id="par_id31630021517873" role="listitem">Go to <menuitem>Data - More Filters - Standard Filter</menuitem>. This opens the <link href="text/shared/02/12090100.xhp" name="std_dialog_link"> Standard Filter</link> dialog.</paragraph> + <paragraph id="par_id31630021517873" role="listitem">Go to <menuitem>Data - More Filters - Standard Filter</menuitem>. This opens the <link href="text/shared/02/12090100.xhp"> Standard Filter</link> dialog.</paragraph> </listitem> <listitem> <paragraph id="par_id801630022108301" role="listitem">In <emph>Field Name</emph> make sure that the selected column is the column where the values are stored. If a single column is selected this field will be set automatically.</paragraph> diff --git a/source/text/scalc/guide/rename_table.xhp b/source/text/scalc/guide/rename_table.xhp index dd03da71ec..f27e8850a4 100644 --- a/source/text/scalc/guide/rename_table.xhp +++ b/source/text/scalc/guide/rename_table.xhp @@ -30,7 +30,7 @@ <bookmark_value>tables;renaming</bookmark_value> <bookmark_value>names; sheets</bookmark_value> </bookmark> -<h1 xml-lang="en-US" id="hd_id3150398"><variable id="rename_table"><link href="text/scalc/guide/rename_table.xhp" name="Renaming Sheets">Renaming Sheets</link> +<h1 xml-lang="en-US" id="hd_id3150398"><variable id="rename_table"><link href="text/scalc/guide/rename_table.xhp">Renaming Sheets</link> </variable></h1> <paragraph role="paragraph" id="par_id701519308848244" xml-lang="en-US">Setting sheet names is an important feature to produce readable and understandable spreadsheets documents.</paragraph> <tip xml-lang="en-US" id="par_id3155444">The name of a sheet is independent of the name of the spreadsheet. You enter the spreadsheet name when you save it for the first time as a file.</tip> diff --git a/source/text/scalc/guide/rounding_numbers.xhp b/source/text/scalc/guide/rounding_numbers.xhp index b9ebc4ac7f..105c795686 100644 --- a/source/text/scalc/guide/rounding_numbers.xhp +++ b/source/text/scalc/guide/rounding_numbers.xhp @@ -43,7 +43,7 @@ <bookmark_value>spreadsheets; values as shown</bookmark_value> </bookmark><comment>mw reduced "tables in spreadsheets;" to "tables;"</comment> <paragraph role="paragraph" id="par_id3153361" xml-lang="en-US" localize="false"/> -<paragraph role="heading" id="hd_id3156422" xml-lang="en-US" level="1"><variable id="rounding_numbers"><link href="text/scalc/guide/rounding_numbers.xhp" name="Using Rounded Off Numbers">Using Rounded Off Numbers</link> +<paragraph role="heading" id="hd_id3156422" xml-lang="en-US" level="1"><variable id="rounding_numbers"><link href="text/scalc/guide/rounding_numbers.xhp">Using Rounded Off Numbers</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3153726" xml-lang="en-US">In $[officename] Calc, all decimal numbers are displayed rounded off to two decimal places.</paragraph> <paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="3">To change this for selected cells</paragraph> @@ -77,8 +77,8 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3145790" xml-lang="en-US"><link href="text/shared/01/05020300.xhp" name="Numbers">Numbers</link></paragraph> -<paragraph role="paragraph" id="par_id3147005" xml-lang="en-US"><link href="text/shared/optionen/01060500.xhp" name="Calculate">Calculate</link></paragraph> +<paragraph role="paragraph" id="par_id3145790" xml-lang="en-US"><link href="text/shared/01/05020300.xhp">Numbers</link></paragraph> +<paragraph role="paragraph" id="par_id3147005" xml-lang="en-US"><link href="text/shared/optionen/01060500.xhp">Calculate</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/row_height.xhp b/source/text/scalc/guide/row_height.xhp index 0275f52dcf..f9aefb6564 100644 --- a/source/text/scalc/guide/row_height.xhp +++ b/source/text/scalc/guide/row_height.xhp @@ -40,7 +40,7 @@ <bookmark_value>columns; widths</bookmark_value> <bookmark_value>changing;row heights/column widths</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="1"><variable id="row_height"><link href="text/scalc/guide/row_height.xhp" name="Changing Row Height or Column Width">Changing Row Height or Column Width</link> +<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="1"><variable id="row_height"><link href="text/scalc/guide/row_height.xhp">Changing Row Height or Column Width</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3154017" xml-lang="en-US">You can change the height of the rows with the mouse or through the dialog.</paragraph> <paragraph role="note" id="par_id3154702" xml-lang="en-US">What is described here for rows and row height applies accordingly for columns and column width.</paragraph> @@ -64,10 +64,10 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3154487" xml-lang="en-US"><link href="text/shared/01/05340100.xhp" name="Row height">Row height</link></paragraph> -<paragraph role="paragraph" id="par_id3149408" xml-lang="en-US"><link href="text/scalc/01/05030200.xhp" name="Optimal row height">Optimal row height</link></paragraph> -<paragraph role="paragraph" id="par_id3153305" xml-lang="en-US"><link href="text/shared/01/05340200.xhp" name="Column width">Column width</link></paragraph> -<paragraph role="paragraph" id="par_id3153815" xml-lang="en-US"><link href="text/scalc/01/05040200.xhp" name="Optimal column width">Optimal column width</link></paragraph> +<paragraph role="paragraph" id="par_id3154487" xml-lang="en-US"><link href="text/shared/01/05340100.xhp">Row height</link></paragraph> +<paragraph role="paragraph" id="par_id3149408" xml-lang="en-US"><link href="text/scalc/01/05030200.xhp">Optimal row height</link></paragraph> +<paragraph role="paragraph" id="par_id3153305" xml-lang="en-US"><link href="text/shared/01/05340200.xhp">Column width</link></paragraph> +<paragraph role="paragraph" id="par_id3153815" xml-lang="en-US"><link href="text/scalc/01/05040200.xhp">Optimal column width</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/scenario.xhp b/source/text/scalc/guide/scenario.xhp index a6cdd29792..2743cdb541 100644 --- a/source/text/scalc/guide/scenario.xhp +++ b/source/text/scalc/guide/scenario.xhp @@ -32,7 +32,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3149664"><bookmark_value>scenarios; creating/editing/deleting</bookmark_value> <bookmark_value>opening;scenarios</bookmark_value> <bookmark_value>selecting;scenarios in Navigator</bookmark_value> -</bookmark><comment>UFI: removed "sample" from index term: no sample in OOo</comment><comment>MW changed "scenarios;"</comment><paragraph role="heading" id="hd_id3125863" xml-lang="en-US" level="1"><variable id="scenario"><link href="text/scalc/guide/scenario.xhp" name="Using Scenarios">Using Scenarios</link> +</bookmark><comment>UFI: removed "sample" from index term: no sample in OOo</comment><comment>MW changed "scenarios;"</comment><paragraph role="heading" id="hd_id3125863" xml-lang="en-US" level="1"><variable id="scenario"><link href="text/scalc/guide/scenario.xhp">Using Scenarios</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3150869" xml-lang="en-US">A $[officename] Calc scenario is a set of cell values that can be used within your calculations. You assign a name to every scenario on your sheet. Define several scenarios on the same sheet, each with some different values in the cells. Then you can easily switch the sets of cell values by their name and immediately observe the results. Scenarios are a tool to test out "what-if" questions.</paragraph> <paragraph role="heading" id="hd_id3149255" xml-lang="en-US" level="3">Creating Your Own Scenarios</paragraph> @@ -78,7 +78,7 @@ </list> <paragraph role="note" id="par_id3154368" xml-lang="en-US">If you want to know which values in the scenario affect other values, choose <emph>Tools - Detective - Trace Dependents</emph>. You see arrows to the cells that are directly dependent on the current cell.</paragraph> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3154484" xml-lang="en-US"><link href="text/scalc/01/06050000.xhp" name="Creating Scenarios">Creating Scenarios</link></paragraph> +<paragraph role="paragraph" id="par_id3154484" xml-lang="en-US"><link href="text/scalc/01/06050000.xhp">Creating Scenarios</link></paragraph> <embed href="text/scalc/guide/multioperation.xhp#multioperation"/> </section> </body> diff --git a/source/text/scalc/guide/sorted_list.xhp b/source/text/scalc/guide/sorted_list.xhp index 26a27df953..2729ca94d5 100644 --- a/source/text/scalc/guide/sorted_list.xhp +++ b/source/text/scalc/guide/sorted_list.xhp @@ -42,7 +42,7 @@ <bookmark_value>customized lists</bookmark_value> </bookmark> <comment>mw deleted "applying;"</comment> - <paragraph xml-lang="en-US" id="hd_id3150870" role="heading" level="1"><variable id="sorted_list"><link href="text/scalc/guide/sorted_list.xhp" name="Applying Sort Lists">Applying Sort Lists</link> + <paragraph xml-lang="en-US" id="hd_id3150870" role="heading" level="1"><variable id="sorted_list"><link href="text/scalc/guide/sorted_list.xhp">Applying Sort Lists</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3159154" role="paragraph">Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items.</paragraph> <paragraph xml-lang="en-US" id="par_id3148645" role="paragraph">For example, enter the text "Jan" or "January" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months.</paragraph> @@ -51,7 +51,7 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/calc_series.xhp#calc_series"/> - <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph"><link href="text/shared/optionen/01060400.xhp" name="Sort lists">Sort lists</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph"><link href="text/shared/optionen/01060400.xhp">Sort lists</link></paragraph> </section> </body> diff --git a/source/text/scalc/guide/specialfilter.xhp b/source/text/scalc/guide/specialfilter.xhp index e206214360..b8803391f2 100644 --- a/source/text/scalc/guide/specialfilter.xhp +++ b/source/text/scalc/guide/specialfilter.xhp @@ -34,7 +34,7 @@ </bookmark> <comment>MW made "applying;advanced filters" a one level entry</comment> <section id="AdvancedFilter"> - <h1 id="hd_id3148798"><variable id="specialfilter"><link href="text/scalc/guide/specialfilter.xhp" name="Applying Advanced Filters">Applying Advanced Filters</link> + <h1 id="hd_id3148798"><variable id="specialfilter"><link href="text/scalc/guide/specialfilter.xhp">Applying Advanced Filters</link> </variable></h1> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/subtotaltool.xhp b/source/text/scalc/guide/subtotaltool.xhp index 3ec316002b..ebb9ca5a83 100644 --- a/source/text/scalc/guide/subtotaltool.xhp +++ b/source/text/scalc/guide/subtotaltool.xhp @@ -20,8 +20,8 @@ <bookmark_value>subtotals;using subtotals tool</bookmark_value> </bookmark> <section id="usingsubtotal"> - <h1 id="hd_id631585177069332"><variable id="subtotaltoolh1"><link href="text/scalc/guide/subtotaltool.xhp" name="Using Subtotal Tool">Using Subtotal Tool</link></variable></h1> - <paragraph id="par_id301585177069332" role="paragraph">Calc offers the Subtotals tool as a more comprehensive alternative to the <link href="text/scalc/01/04060106.xhp#Section12" name="subtotal">SUBTOTAL function</link>. In contrast to SUBTOTAL, which only works on a single array, the Subtotals tool can create subtotals for up to three arrays arranged in labeled columns. It also groups subtotals by category and sorts them automatically, thereby eliminating the need to apply AutoFilters and filter categories by hand.</paragraph> + <h1 id="hd_id631585177069332"><variable id="subtotaltoolh1"><link href="text/scalc/guide/subtotaltool.xhp">Using Subtotal Tool</link></variable></h1> + <paragraph id="par_id301585177069332" role="paragraph">Calc offers the Subtotals tool as a more comprehensive alternative to the <link href="text/scalc/01/04060106.xhp#Section12">SUBTOTAL function</link>. In contrast to SUBTOTAL, which only works on a single array, the Subtotals tool can create subtotals for up to three arrays arranged in labeled columns. It also groups subtotals by category and sorts them automatically, thereby eliminating the need to apply AutoFilters and filter categories by hand.</paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dntegs"/> diff --git a/source/text/scalc/guide/super_subscript.xhp b/source/text/scalc/guide/super_subscript.xhp index d700476394..83a8cfc138 100644 --- a/source/text/scalc/guide/super_subscript.xhp +++ b/source/text/scalc/guide/super_subscript.xhp @@ -35,7 +35,7 @@ <bookmark_value>cells; text super/sub</bookmark_value> <bookmark_value>characters;superscript/subscript</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3151112" xml-lang="en-US" level="1"><variable id="super_subscript"><link href="text/scalc/guide/super_subscript.xhp" name="Text Superscript / Subscript">Text Superscript / Subscript</link> +<paragraph role="heading" id="hd_id3151112" xml-lang="en-US" level="1"><variable id="super_subscript"><link href="text/scalc/guide/super_subscript.xhp">Text Superscript / Subscript</link> </variable></paragraph> <list type="ordered"> <listitem> @@ -53,7 +53,7 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US"><link href="text/shared/01/05020500.xhp" name="Context menu - Character - Font Position">Context menu - Character - Font Position</link></paragraph> +<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US"><link href="text/shared/01/05020500.xhp">Context menu - Character - Font Position</link></paragraph> <embed href="text/swriter/guide/subscript.xhp#subscript"/> </section> </body> diff --git a/source/text/scalc/guide/table_cellmerge.xhp b/source/text/scalc/guide/table_cellmerge.xhp index fe16ebb63f..bcca2b3227 100644 --- a/source/text/scalc/guide/table_cellmerge.xhp +++ b/source/text/scalc/guide/table_cellmerge.xhp @@ -31,7 +31,7 @@ <bookmark_value>split/splitting cells</bookmark_value> </bookmark> <section id="merge_unmerge_cells"> - <paragraph xml-lang="en-US" id="hd_id8005005" role="heading" level="1"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp" name="Merging and Unmerging Cells">Merge and Unmerge Cells</link></variable></paragraph> + <paragraph xml-lang="en-US" id="hd_id8005005" role="heading" level="1"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp">Merge and Unmerge Cells</link></variable></paragraph> <paragraph xml-lang="en-US" id="par_id8049867" role="paragraph">You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells.</paragraph> </section> <paragraph xml-lang="en-US" id="par_id0509200913480176" role="note">When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.</paragraph> diff --git a/source/text/scalc/guide/table_rotate.xhp b/source/text/scalc/guide/table_rotate.xhp index 2593105f7d..56f3951377 100644 --- a/source/text/scalc/guide/table_rotate.xhp +++ b/source/text/scalc/guide/table_rotate.xhp @@ -39,7 +39,7 @@ <bookmark_value>tables; rotating</bookmark_value> <bookmark_value>rotating; tables</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3154346" xml-lang="en-US" level="1"><variable id="table_rotate"><link href="text/scalc/guide/table_rotate.xhp" name="Rotating Tables (Transposing)">Rotating Tables (Transposing)</link> +<paragraph role="heading" id="hd_id3154346" xml-lang="en-US" level="1"><variable id="table_rotate"><link href="text/scalc/guide/table_rotate.xhp">Rotating Tables (Transposing)</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3154013" xml-lang="en-US">In $[officename] Calc, there is a way to "rotate" a spreadsheet so that rows become columns and columns become rows.</paragraph> <list type="ordered"> @@ -61,7 +61,7 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3146969" xml-lang="en-US"><link href="text/shared/01/02070000.xhp" name="Paste Special">Paste Special</link></paragraph> +<paragraph role="paragraph" id="par_id3146969" xml-lang="en-US"><link href="text/shared/01/02070000.xhp">Paste Special</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/table_view.xhp b/source/text/scalc/guide/table_view.xhp index b36cee5f5a..7504c4bedf 100644 --- a/source/text/scalc/guide/table_view.xhp +++ b/source/text/scalc/guide/table_view.xhp @@ -38,7 +38,7 @@ <bookmark_value>hiding;headers/grid lines</bookmark_value> <bookmark_value>changing;table views</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3147304" xml-lang="en-US" level="1"><variable id="table_view"><link href="text/scalc/guide/table_view.xhp" name="Changing Table Views">Changing Table Views</link> +<paragraph role="heading" id="hd_id3147304" xml-lang="en-US" level="1"><variable id="table_view"><link href="text/scalc/guide/table_view.xhp">Changing Table Views</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3153192" xml-lang="en-US">To hide column and line headers in a table:</paragraph> <list type="unordered"> diff --git a/source/text/scalc/guide/text_numbers.xhp b/source/text/scalc/guide/text_numbers.xhp index 139ae34691..12322cab5e 100644 --- a/source/text/scalc/guide/text_numbers.xhp +++ b/source/text/scalc/guide/text_numbers.xhp @@ -33,7 +33,7 @@ <bookmark_value>cell formats; text/numbers</bookmark_value> <bookmark_value>formatting;numbers as text</bookmark_value> </bookmark><comment>mw deleted "numbers; entering without..." and changed "numbers;as text"</comment> -<paragraph xml-lang="en-US" id="hd_id3145068" role="heading" level="1"><variable id="text_numbers"><link href="text/scalc/guide/text_numbers.xhp" name="Formatting Numbers as Text">Formatting Numbers as Text</link> +<paragraph xml-lang="en-US" id="hd_id3145068" role="heading" level="1"><variable id="text_numbers"><link href="text/scalc/guide/text_numbers.xhp">Formatting Numbers as Text</link> </variable></paragraph> <section id="text"> <paragraph xml-lang="en-US" id="par_id3156280" role="paragraph">You can format numbers as text in $[officename] Calc. Open the context menu of a cell or range of cells and choose <emph>Format Cells - Numbers</emph>, then select "Text" from the <emph>Category</emph> list. Any numbers subsequently entered into the formatted range are interpreted as text. The display of these "numbers" is left-justified, just as with other text.</paragraph> @@ -43,7 +43,7 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/numbers_text.xhp#numbers_text"/> <embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> - <paragraph xml-lang="en-US" id="par_id3156284" role="paragraph"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3156284" role="paragraph"><link href="text/shared/01/05020300.xhp">Format - Cells - Numbers</link></paragraph> <embed href="text/scalc/guide/format_value.xhp#format_value"/> </section> </body> diff --git a/source/text/scalc/guide/text_rotate.xhp b/source/text/scalc/guide/text_rotate.xhp index 2c8b1bbaa2..4b4dba7333 100644 --- a/source/text/scalc/guide/text_rotate.xhp +++ b/source/text/scalc/guide/text_rotate.xhp @@ -31,7 +31,7 @@ <bookmark_value>rotating; text in cells</bookmark_value> <bookmark_value>text in cells; writing vertically</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3151112" role="heading" level="1"><variable id="text_rotate"><link href="text/scalc/guide/text_rotate.xhp" name="Rotating Text">Rotating Text</link> +<paragraph xml-lang="en-US" id="hd_id3151112" role="heading" level="1"><variable id="text_rotate"><link href="text/scalc/guide/text_rotate.xhp">Rotating Text</link> </variable></paragraph> <list type="ordered"> <listitem> @@ -48,8 +48,8 @@ </listitem> </list><comment>removed a wrong para, i104207</comment> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3148456" role="paragraph"><link href="text/scalc/01/05020000.xhp" name="Format - Cells">Format - Cells</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3154944" role="paragraph"><link href="text/shared/01/05340300.xhp" name="Format - Cells - Alignment">Format - Cells - Alignment</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3148456" role="paragraph"><link href="text/scalc/01/05020000.xhp">Format - Cells</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3154944" role="paragraph"><link href="text/shared/01/05340300.xhp">Format - Cells - Alignment</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/text_wrap.xhp b/source/text/scalc/guide/text_wrap.xhp index 2bc0603e7a..e47b896efa 100644 --- a/source/text/scalc/guide/text_wrap.xhp +++ b/source/text/scalc/guide/text_wrap.xhp @@ -32,7 +32,7 @@ <bookmark_value>breaks in cells</bookmark_value> <bookmark_value>multi-line text in cells</bookmark_value> </bookmark> -<h1 id="hd_id3154346"><variable id="text_wrap"><link href="text/scalc/guide/text_wrap.xhp" name="Writing Multi-line Text">Writing Multi-line Text</link> +<h1 id="hd_id3154346"><variable id="text_wrap"><link href="text/scalc/guide/text_wrap.xhp">Writing Multi-line Text</link> </variable></h1> <section id="wraptext"> <paragraph role="listitem" id="par_id3156280" xml-lang="en-US">Pressing the <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+Enter keys inserts a manual line break. This shortcut works directly in the cell or in the input line. The input line can be expanded to the multi-line by the Down arrow button on the right.</paragraph> @@ -50,7 +50,7 @@ </section> </section> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US"><link href="text/scalc/01/05020000.xhp" name="Format - Cells">Format - Cells</link></paragraph> +<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US"><link href="text/scalc/01/05020000.xhp">Format - Cells</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/userdefined_function.xhp b/source/text/scalc/guide/userdefined_function.xhp index 80d4f25257..f5c8453992 100644 --- a/source/text/scalc/guide/userdefined_function.xhp +++ b/source/text/scalc/guide/userdefined_function.xhp @@ -34,7 +34,7 @@ <bookmark_value>IDE; Basic IDE</bookmark_value> <bookmark_value>programming;functions</bookmark_value> </bookmark> -<h1 id="hd_id3155411"><variable id="userdefined_function"><link href="text/scalc/guide/userdefined_function.xhp" name="Defining Functions Yourself">User-Defined Functions</link> +<h1 id="hd_id3155411"><variable id="userdefined_function"><link href="text/scalc/guide/userdefined_function.xhp">User-Defined Functions</link> </variable></h1> <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US">You can apply user-defined functions in $[officename] Calc in the following ways:</paragraph> <list type="unordered"> @@ -42,7 +42,7 @@ <paragraph role="listitem" id="par_id3145366" xml-lang="en-US">You can define your own functions using the Basic-IDE. This method requires a basic knowledge of programming.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3153768" xml-lang="en-US">You can program functions as <link href="text/scalc/01/04060111.xhp" name="add-ins">add-ins</link>. This method requires an advanced knowledge of programming.</paragraph> +<paragraph role="listitem" id="par_id3153768" xml-lang="en-US">You can program functions as <link href="text/scalc/01/04060111.xhp">add-ins</link>. This method requires an advanced knowledge of programming.</paragraph> </listitem> </list> <h2 id="hd_id3149260">Defining A Function Using %PRODUCTNAME Basic</h2> diff --git a/source/text/scalc/guide/validity.xhp b/source/text/scalc/guide/validity.xhp index 76d5eb8ec8..6f6e6f1332 100644 --- a/source/text/scalc/guide/validity.xhp +++ b/source/text/scalc/guide/validity.xhp @@ -45,11 +45,11 @@ <bookmark_value>macros; running when incorrect input</bookmark_value> <bookmark_value>data; validity check</bookmark_value> </bookmark><comment>mw changed "limit...;"</comment> -<paragraph role="heading" id="hd_id3156442" xml-lang="en-US" level="1"><variable id="validity"><link href="text/scalc/guide/validity.xhp" name="Validity of Cell Contents">Validity of Cell Contents</link> +<paragraph role="heading" id="hd_id3156442" xml-lang="en-US" level="1"><variable id="validity"><link href="text/scalc/guide/validity.xhp">Validity of Cell Contents</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3156283" xml-lang="en-US">For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected.</paragraph> <paragraph role="warning" id="par_id3145252" xml-lang="en-US">The validity rule is activated when a new value is entered. If an invalid value has already been inserted into the cell, or if you insert a value in the cell either with drag-and-drop or by copying and pasting, the validity rule will not take effect.</paragraph> -<paragraph role="note" id="par_id5174718" xml-lang="en-US">You can choose <emph>Tools - Detective</emph> at any time and choose the command <link href="text/scalc/01/06030800.xhp" name="Mark Invalid Data"><emph>Mark Invalid Data</emph></link> to display which cells contain invalid values.</paragraph> +<paragraph role="note" id="par_id5174718" xml-lang="en-US">You can choose <emph>Tools - Detective</emph> at any time and choose the command <link href="text/scalc/01/06030800.xhp"><emph>Mark Invalid Data</emph></link> to display which cells contain invalid values.</paragraph> <paragraph role="heading" id="hd_id3155603" xml-lang="en-US" level="2">Using Cell Contents Validity</paragraph> <list type="ordered"> <listitem> @@ -65,7 +65,7 @@ <paragraph role="paragraph" id="par_id3159208" xml-lang="en-US">In the <emph>Allow</emph> field, select an option.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id3153011" xml-lang="en-US">If you select "Whole Numbers", values such as "12.5" are not allowed. Choosing "Date" allows date information both in the local date format as well as in the form of a <link href="text/sbasic/shared/03030101.xhp" name="serial date">serial date</link>. Similarly, the "Time" condition permits time values such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to contain text only.</paragraph> +<paragraph role="paragraph" id="par_id3153011" xml-lang="en-US">If you select "Whole Numbers", values such as "12.5" are not allowed. Choosing "Date" allows date information both in the local date format as well as in the form of a <link href="text/sbasic/shared/03030101.xhp">serial date</link>. Similarly, the "Time" condition permits time values such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to contain text only.</paragraph> <paragraph role="paragraph" id="par_id9224829" xml-lang="en-US">Select "List" to enter a list of valid entries.</paragraph> </listitem> <listitem> @@ -84,10 +84,10 @@ <paragraph role="listitem" id="par_id3149947" xml-lang="en-US">If you select "Macro", then by using the <emph>Browse</emph> button you can specify a macro to be run in the event of an error.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id3149011" xml-lang="en-US">To display the error message, select <link href="text/scalc/01/12120300.xhp" name="erroralert">Show error message when invalid values are entered</link>.</paragraph> +<paragraph role="paragraph" id="par_id3149011" xml-lang="en-US">To display the error message, select <link href="text/scalc/01/12120300.xhp">Show error message when invalid values are entered</link>.</paragraph> <paragraph role="note" id="par_id3148586" xml-lang="en-US">After changing the action for a cell on the <emph>Error Alert</emph> tab page and closing the dialog with OK, you must first select another cell before the change takes effect.</paragraph> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3154805" xml-lang="en-US"><link href="text/scalc/01/12120000.xhp" name="Data - Validity">Data - Validity</link></paragraph> +<paragraph role="paragraph" id="par_id3154805" xml-lang="en-US"><link href="text/scalc/01/12120000.xhp">Data - Validity</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp index 1822b2f668..e7840121b5 100644 --- a/source/text/scalc/guide/value_with_name.xhp +++ b/source/text/scalc/guide/value_with_name.xhp @@ -41,7 +41,7 @@ <bookmark_value>allowed cell names</bookmark_value> <bookmark_value>renaming;cells</bookmark_value> </bookmark><comment>mw changed "names;...", "addressing;..." and "references,..." entries.</comment><comment>mw added "renaming;"</comment> -<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1"><variable id="value_with_name"><link href="text/scalc/guide/value_with_name.xhp" name="Naming Cells">Naming Cells</link> +<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1"><variable id="value_with_name"><link href="text/scalc/guide/value_with_name.xhp">Naming Cells</link> </variable></paragraph> <paragraph xml-lang="en-US" id="hd_id4391918" role="heading" level="2">Allowed names</paragraph> <paragraph xml-lang="en-US" id="par_id2129581" role="paragraph">Names in Calc can contain letters, numeric characters, and the underline character. Names must start with a letter or an underline character.</paragraph> @@ -77,7 +77,7 @@ </listitem> </list> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3153711" role="paragraph"><link href="text/scalc/01/04070100.xhp" name="Sheet - Named Ranges and Expressions - Define">Sheet - Named Ranges and Expressions - Define</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3153711" role="paragraph"><link href="text/scalc/01/04070100.xhp">Sheet - Named Ranges and Expressions - Define</link></paragraph> <embed href="text/scalc/guide/goalseek.xhp#goalseek"/> <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> <embed href="text/scalc/guide/address_auto.xhp#address_auto"/><comment>mw deleted one EMBED paragraph and copied two EMBED paragraphs from Calc guide address_byname.xhp</comment> diff --git a/source/text/scalc/guide/webquery.xhp b/source/text/scalc/guide/webquery.xhp index c98461be33..b9bd334f53 100644 --- a/source/text/scalc/guide/webquery.xhp +++ b/source/text/scalc/guide/webquery.xhp @@ -38,7 +38,7 @@ <bookmark_value>inserting; external data</bookmark_value> <bookmark_value>data sources; external data</bookmark_value> </bookmark><comment>UFI: removed "external data;WebQuery" because both index entries "external data" led to this page.</comment><paragraph role="paragraph" id="par_id3154346" xml-lang="en-US" localize="false"/> -<paragraph role="heading" id="hd_id3125863" xml-lang="en-US" level="1"><variable id="webquery"><link href="text/scalc/guide/webquery.xhp" name="Inserting External Data in Table (WebQuery)">Inserting External Data in Table (WebQuery)</link> +<paragraph role="heading" id="hd_id3125863" xml-lang="en-US" level="1"><variable id="webquery"><link href="text/scalc/guide/webquery.xhp">Inserting External Data in Table (WebQuery)</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3155131" xml-lang="en-US">With the help of the <emph>Web Page Query ($[officename] Calc)</emph> import filter, you can insert tables from HTML documents in a Calc spreadsheet.</paragraph> <paragraph role="paragraph" id="par_id3148575" xml-lang="en-US">You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet.</paragraph> @@ -100,7 +100,7 @@ </listitem> </list> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3154650" xml-lang="en-US"><link href="text/scalc/01/04090000.xhp" name="External data dialog">External data dialog</link></paragraph> +<paragraph role="paragraph" id="par_id3154650" xml-lang="en-US"><link href="text/scalc/01/04090000.xhp">External data dialog</link></paragraph> <embed href="text/scalc/guide/cellreferences_url.xhp#cellreferences_url"/> </section> </body> diff --git a/source/text/scalc/guide/wildcards.xhp b/source/text/scalc/guide/wildcards.xhp index 6f8c46fe48..5c0b9630a9 100644 --- a/source/text/scalc/guide/wildcards.xhp +++ b/source/text/scalc/guide/wildcards.xhp @@ -21,7 +21,7 @@ <bookmark_value>wildcards in formulas</bookmark_value> <bookmark_value>wildcards;examples</bookmark_value> </bookmark> - <h1 id="hd_id941629155075179"><variable id="wildcards_h1"><link href="text/scalc/guide/wildcards.xhp" name="wildcards_link">Using Wildcards in Formulas</link></variable></h1> + <h1 id="hd_id941629155075179"><variable id="wildcards_h1"><link href="text/scalc/guide/wildcards.xhp">Using Wildcards in Formulas</link></variable></h1> <paragraph role="paragraph" id="par_id571629155308959">Wildcards are special characters that can be used in search strings that are passed as arguments to some Calc functions. They can also be used to define search criteria in the <emph>Find & Replace</emph> dialog. The use of wildcards enables the definition of more advanced search parameters with a single search string.</paragraph> <paragraph role="paragraph" id="par_id391629156224638">%PRODUCTNAME Calc supports either <emph>wildcards</emph> or <emph>regular expressions</emph> as arguments depending on the current application settings. By default %PRODUCTNAME Calc is set to support wildcards instead of regular expressions.</paragraph> <tip id="par_id551629156504794">To make sure wildcards are supported, go to <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline> and check if the option <emph>Enable wildcards in formulas</emph> is selected. Note that you can use this dialog to switch to regular expressions by choosing <emph>Enable regular expressions in formulas</emph> or choose to support neither wildcards nor regular expressions.</tip> diff --git a/source/text/scalc/guide/year2000.xhp b/source/text/scalc/guide/year2000.xhp index 8ff336c552..94001610dd 100644 --- a/source/text/scalc/guide/year2000.xhp +++ b/source/text/scalc/guide/year2000.xhp @@ -33,7 +33,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150439"><bookmark_value>years; 2-digits</bookmark_value> <bookmark_value>dates; 19xx/20xx</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="1"><variable id="year2000"><link href="text/scalc/guide/year2000.xhp" name="19xx/20xx Years">19xx/20xx Years</link> +<paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="1"><variable id="year2000"><link href="text/scalc/guide/year2000.xhp">19xx/20xx Years</link> </variable></paragraph> <section id="text"> <paragraph role="paragraph" id="par_id3151116" xml-lang="en-US">The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years.</paragraph> |