diff options
author | Gabor Kelemen <kelemeng@gnome.hu> | 2017-05-18 23:19:03 +0200 |
---|---|---|
committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2017-05-30 09:37:17 +0200 |
commit | 1ae135d7569571bc38fc1bcf0dfd24610039a86e (patch) | |
tree | 9ba80ca7de4275eb87766ef8f6636bd4fd68b21d /source/text/scalc/guide | |
parent | 45f6f1757199dbebd364de8d2e1964e59d0c6f1f (diff) |
Mass remove excess spaces from inside tags
This is fallout from the l10n and oldref attribute removal.
Some tags were broken into two rows and the second was
indented with spaces.
The line break was removed along the tags, but those
spaces were not.
Command I used to catch these:
find source/text/ -name "*xhp" | xargs sed -i -e 's#\" *>#\">#g'
Change-Id: I6f9bad46cbfb7416950bee8230e358a3dd851def
Reviewed-on: https://gerrit.libreoffice.org/37791
Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
Diffstat (limited to 'source/text/scalc/guide')
-rw-r--r-- | source/text/scalc/guide/autoformat.xhp | 4 | ||||
-rw-r--r-- | source/text/scalc/guide/background.xhp | 4 | ||||
-rw-r--r-- | source/text/scalc/guide/cell_protect.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/cell_unprotect.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/cellreference_dragdrop.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/cellreferences.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/cellstyle_conditional.xhp | 12 | ||||
-rw-r--r-- | source/text/scalc/guide/cellstyle_minusvalue.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/csv_formula.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/database_define.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/database_filter.xhp | 4 | ||||
-rw-r--r-- | source/text/scalc/guide/database_sort.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/filters.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/format_value_userdef.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/multitables.xhp | 8 | ||||
-rw-r--r-- | source/text/scalc/guide/note_insert.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/rename_table.xhp | 2 | ||||
-rw-r--r-- | source/text/scalc/guide/text_numbers.xhp | 2 |
18 files changed, 29 insertions, 29 deletions
diff --git a/source/text/scalc/guide/autoformat.xhp b/source/text/scalc/guide/autoformat.xhp index 1b01d8db7b..7148e2be27 100644 --- a/source/text/scalc/guide/autoformat.xhp +++ b/source/text/scalc/guide/autoformat.xhp @@ -34,7 +34,7 @@ <bookmark_value>automatic formatting in spreadsheets</bookmark_value> <bookmark_value>sheets;AutoFormat function</bookmark_value> </bookmark><comment>MW deleted "applying;"</comment><comment>MW made "AutoFormat function;" a one level entry</comment> -<paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1" ><variable id="autoformat"><link href="text/scalc/guide/autoformat.xhp" name="Using AutoFormat for Tables">Applying Automatic Formatting to a Selected Cell Range</link> +<paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1"><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></paragraph> <paragraph xml-lang="en-US" id="par_id3149401" role="paragraph">You can use the AutoFormat feature to quickly apply a format to a sheet or a selected cell range.</paragraph> <paragraph xml-lang="en-US" id="par_idN10702" role="heading" level="2">To Apply an AutoFormat to a Sheet or Selected Cell Range</paragraph> @@ -54,7 +54,7 @@ </listitem> </list> <paragraph xml-lang="en-US" id="par_id3149210" role="note">If you do not see any change in color of the cell contents, choose <item type="menuitem">View - Value Highlighting</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3155379" role="heading" level="2" >To Define an AutoFormat for Spreadsheets</paragraph> + <paragraph xml-lang="en-US" id="par_id3155379" role="heading" level="2">To Define an AutoFormat for Spreadsheets</paragraph> <paragraph xml-lang="en-US" id="par_id3148868" role="paragraph">You can define a new AutoFormat that is available to all spreadsheets.</paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/background.xhp b/source/text/scalc/guide/background.xhp index 6dc777f748..57f76d7719 100644 --- a/source/text/scalc/guide/background.xhp +++ b/source/text/scalc/guide/background.xhp @@ -37,7 +37,7 @@ <paragraph xml-lang="en-US" id="hd_id3149346" role="heading" level="1"><variable id="background"><link href="text/scalc/guide/background.xhp" name="Defining Background Colors or Background Graphics">Defining Background Colors or Background Graphics</link> </variable></paragraph><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> - <paragraph xml-lang="en-US" id="hd_id3144760" role="heading" level="2" >Applying a Background Color to a $[officename] Calc Spreadsheet</paragraph> + <paragraph xml-lang="en-US" id="hd_id3144760" role="heading" level="2">Applying a Background Color to a $[officename] Calc Spreadsheet</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3155429" role="listitem">Select the cells.</paragraph> @@ -49,7 +49,7 @@ <paragraph xml-lang="en-US" id="par_id3152938" role="listitem">On the <emph>Background</emph> tab page, select the background color.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3146974" role="heading" level="2" >Graphics in the Background of Cells</paragraph> + <paragraph xml-lang="en-US" id="hd_id3146974" role="heading" level="2">Graphics in the Background of Cells</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3155414" role="listitem">Choose <emph>Insert - Image - From File</emph>.</paragraph> diff --git a/source/text/scalc/guide/cell_protect.xhp b/source/text/scalc/guide/cell_protect.xhp index a5b0161edc..1231259611 100644 --- a/source/text/scalc/guide/cell_protect.xhp +++ b/source/text/scalc/guide/cell_protect.xhp @@ -77,7 +77,7 @@ <section id="relatedtopics"> <embed href="text/scalc/guide/cell_unprotect.xhp#cell_unprotect"/> <embed href="text/shared/guide/protection.xhp#protection"/> - <paragraph xml-lang="en-US" id="par_idN10B8C" role="paragraph" localize="false" > + <paragraph xml-lang="en-US" id="par_idN10B8C" role="paragraph" localize="false"> <embedvar href="text/shared/guide/digital_signatures.xhp#digital_signatures"/> </paragraph> </section> diff --git a/source/text/scalc/guide/cell_unprotect.xhp b/source/text/scalc/guide/cell_unprotect.xhp index e5f74cb67e..52bff13d59 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" name="Unprotecting Cells">Unprotecting Cells</link> </variable></paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/cellreference_dragdrop.xhp b/source/text/scalc/guide/cellreference_dragdrop.xhp index b66b21fede..6f687d6da3 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" name="Referencing Cells by Drag-and-Drop">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"> diff --git a/source/text/scalc/guide/cellreferences.xhp b/source/text/scalc/guide/cellreferences.xhp index b16c2f7c1e..a9f3528951 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> -<paragraph xml-lang="en-US" id="hd_id3147436" role="heading" level="1" ><variable id="cellreferences"><link href="text/scalc/guide/cellreferences.xhp" name="Referencing Other Sheets">Referencing Other Sheets</link> +<paragraph xml-lang="en-US" id="hd_id3147436" role="heading" level="1"><variable id="cellreferences"><link href="text/scalc/guide/cellreferences.xhp" name="Referencing Other Sheets">Referencing Other Sheets</link> </variable></paragraph> <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> diff --git a/source/text/scalc/guide/cellstyle_conditional.xhp b/source/text/scalc/guide/cellstyle_conditional.xhp index d867c21380..8a72c84328 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" name="Applying Conditional Formatting">Applying Conditional Formatting</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph">Using the menu command <emph>Format - Conditional formatting</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> @@ -54,7 +54,7 @@ <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> </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> + <paragraph xml-lang="en-US" id="hd_id3155766" role="heading" level="2">Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value</paragraph> <paragraph xml-lang="en-US" id="hd_id4341868" role="heading" level="3">Step1: Generate Number Values</paragraph> <paragraph xml-lang="en-US" id="par_id3150043" role="paragraph">You want to give certain values in your tables particular emphasis. For example, in a table of turnovers, you can show all the values above the average in green and all those below the average in red. This is possible with conditional formatting.</paragraph> <list type="ordered"> @@ -69,7 +69,7 @@ <paragraph xml-lang="en-US" id="par_id3159236" role="listitem">In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3149211" role="heading" level="3" >Step 2: Define Cell Styles</paragraph> + <paragraph xml-lang="en-US" id="hd_id3149211" role="heading" level="3">Step 2: Define Cell Styles</paragraph> <paragraph xml-lang="en-US" id="par_id3154659" role="paragraph">The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles and Formatting window is visible before proceeding.</paragraph> <list type="ordered"> <listitem> @@ -85,7 +85,7 @@ <paragraph xml-lang="en-US" id="par_id3152889" role="listitem">To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, "Below").</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3148704" role="heading" level="3" >Step 3: Calculate Average</paragraph> + <paragraph xml-lang="en-US" id="hd_id3148704" role="heading" level="3">Step 3: Calculate Average</paragraph> <paragraph xml-lang="en-US" id="par_id3148837" role="paragraph">In our particular example, we are calculating the average of the random values. The result is placed in a cell:</paragraph> <list type="ordered"> <listitem> @@ -98,7 +98,7 @@ <paragraph xml-lang="en-US" id="par_id3153246" role="listitem">Close the Function Wizard with <item type="menuitem">OK</item>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3" >Step 4: Apply Cell Styles</paragraph> + <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3">Step 4: Apply Cell Styles</paragraph> <paragraph xml-lang="en-US" id="par_id3149126" role="paragraph">Now you can apply the conditional formatting to the sheet:</paragraph> <list type="ordered"> <listitem> @@ -111,7 +111,7 @@ <paragraph xml-lang="en-US" id="par_id3153013" role="listitem">Define the condition as follows: If cell value is less than J14, format with cell style "Below", and if cell value is greater than or equal to J14, format with cell style "Above".</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3155761" role="heading" level="3" >Step 5: Copy Cell Style</paragraph> + <paragraph xml-lang="en-US" id="hd_id3155761" role="heading" level="3">Step 5: Copy Cell Style</paragraph> <paragraph xml-lang="en-US" id="par_id3145320" role="paragraph">To apply the conditional formatting to other cells later:</paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/cellstyle_minusvalue.xhp b/source/text/scalc/guide/cellstyle_minusvalue.xhp index 618e6f7220..6f158ca75b 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" name="Highlighting Negative Numbers">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/csv_formula.xhp b/source/text/scalc/guide/csv_formula.xhp index 7fe9bf6906..70edc0b585 100644 --- a/source/text/scalc/guide/csv_formula.xhp +++ b/source/text/scalc/guide/csv_formula.xhp @@ -35,7 +35,7 @@ <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> </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> + <paragraph xml-lang="en-US" id="hd_id3150715" role="heading" level="2">To Import a CSV File</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3153709" role="listitem">Choose <emph>File - Open</emph>.</paragraph> diff --git a/source/text/scalc/guide/database_define.xhp b/source/text/scalc/guide/database_define.xhp index 0a9f0e6ff3..5c4d8ffcc3 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" name="Defining Database Ranges">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 70811148c2..dc1157d0dd 100644 --- a/source/text/scalc/guide/database_filter.xhp +++ b/source/text/scalc/guide/database_filter.xhp @@ -32,7 +32,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" name="Filtering Cell Ranges">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> @@ -51,7 +51,7 @@ <paragraph xml-lang="en-US" id="par_id3153143" role="paragraph">The records that match the filter options that you specified are shown.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3153728" role="heading" level="2" >To Apply an AutoFilter to a Cell Range</paragraph> + <paragraph xml-lang="en-US" id="par_id3153728" role="heading" level="2">To Apply an AutoFilter to a Cell Range</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3144764" role="listitem">Click in a cell range or a database range.</paragraph> diff --git a/source/text/scalc/guide/database_sort.xhp b/source/text/scalc/guide/database_sort.xhp index a3d83f091a..b2dfd79a34 100644 --- a/source/text/scalc/guide/database_sort.xhp +++ b/source/text/scalc/guide/database_sort.xhp @@ -31,7 +31,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" name="Sorting Database Ranges">Sorting Data</link> </variable></paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/filters.xhp b/source/text/scalc/guide/filters.xhp index 3347d2f84e..fb120422ed 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" name="Applying Filters">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_value_userdef.xhp b/source/text/scalc/guide/format_value_userdef.xhp index e035ac1b4e..7e3a949322 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" name="User-defined Number Formats">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/multitables.xhp b/source/text/scalc/guide/multitables.xhp index 1c24ec0d16..7061c99dc3 100644 --- a/source/text/scalc/guide/multitables.xhp +++ b/source/text/scalc/guide/multitables.xhp @@ -37,7 +37,7 @@ </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> </variable></paragraph> - <paragraph xml-lang="en-US" id="hd_id3148576" role="heading" level="2" >Inserting a Sheet</paragraph> + <paragraph xml-lang="en-US" id="hd_id3148576" role="heading" level="2">Inserting a Sheet</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3154731" role="paragraph">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph> @@ -55,13 +55,13 @@ <paragraph xml-lang="en-US" id="par_id050920091402035" role="paragraph"><ahelp hid="." visibility="hidden">Click to select all sheets in the document.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/.uno:TableDeselectAll" id="bm_id9065825" localize="false"/> <paragraph xml-lang="en-US" id="par_id0509200914020391" role="paragraph"><ahelp hid="." visibility="hidden">Click to deselect all sheets in the document, except the current sheet.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3154491" role="heading" level="2" >Selecting Multiple Sheets</paragraph> + <paragraph xml-lang="en-US" id="hd_id3154491" role="heading" level="2">Selecting Multiple Sheets</paragraph> <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> you can select multiple sheets.</paragraph> <paragraph xml-lang="en-US" id="par_idN106B7" role="paragraph">You can use Shift+<switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3155600" role="heading" level="2" >Undoing a Selection</paragraph> + <paragraph xml-lang="en-US" id="hd_id3155600" role="heading" level="2">Undoing a Selection</paragraph> <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key. The sheet that is currently visible cannot be removed from the selection.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="2" >Calculating Across Multiple Sheets</paragraph> + <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="2">Calculating Across Multiple Sheets</paragraph> <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph">You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type="literal">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3.</paragraph> diff --git a/source/text/scalc/guide/note_insert.xhp b/source/text/scalc/guide/note_insert.xhp index 8b7b623ac7..ca75f649c9 100644 --- a/source/text/scalc/guide/note_insert.xhp +++ b/source/text/scalc/guide/note_insert.xhp @@ -34,7 +34,7 @@ <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" name="Inserting and Editing Comments">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> <list type="unordered"> diff --git a/source/text/scalc/guide/rename_table.xhp b/source/text/scalc/guide/rename_table.xhp index 3d47571650..8a18900cff 100644 --- a/source/text/scalc/guide/rename_table.xhp +++ b/source/text/scalc/guide/rename_table.xhp @@ -32,7 +32,7 @@ <bookmark_value>tables;renaming</bookmark_value> <bookmark_value>names; sheets</bookmark_value> </bookmark><comment>mw made "renaming sheets" a two level entry.</comment> -<paragraph xml-lang="en-US" id="hd_id3150398" role="heading" level="1" ><variable id="rename_table"><link href="text/scalc/guide/rename_table.xhp" name="Renaming Sheets">Renaming Sheets</link> +<paragraph xml-lang="en-US" id="hd_id3150398" role="heading" level="1"><variable id="rename_table"><link href="text/scalc/guide/rename_table.xhp" name="Renaming Sheets">Renaming Sheets</link> </variable></paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/text_numbers.xhp b/source/text/scalc/guide/text_numbers.xhp index aaeb908c2c..139ae34691 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" name="Formatting Numbers as Text">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> |