From 156af0219ea25704b386d6c16dca7e1ce8386995 Mon Sep 17 00:00:00 2001 From: Sophia Schröder Date: Sun, 20 May 2018 18:11:37 +0100 Subject: Cleanups and improvements Help files in scalc/00/ Change-Id: I55ffb4961fb5614f75fbc3e71dd50b461dff17de Reviewed-on: https://gerrit.libreoffice.org/54603 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos (cherry picked from commit 3765355e41d02ee3e5f64ef6ece336641553e7c7) Reviewed-on: https://gerrit.libreoffice.org/55435 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/scalc/00/00000004.xhp | 26 +++---- source/text/scalc/00/00000402.xhp | 34 ++++---- source/text/scalc/00/00000403.xhp | 12 +-- source/text/scalc/00/00000404.xhp | 75 +++++++----------- source/text/scalc/00/00000405.xhp | 96 +++++++++-------------- source/text/scalc/00/00000406.xhp | 48 ++++++------ source/text/scalc/00/00000407.xhp | 8 +- source/text/scalc/00/00000412.xhp | 151 +++++++++++++----------------------- source/text/scalc/00/sheet_menu.xhp | 24 +++--- 9 files changed, 177 insertions(+), 297 deletions(-) (limited to 'source') diff --git a/source/text/scalc/00/00000004.xhp b/source/text/scalc/00/00000004.xhp index 49b75e74e9..640164de3b 100644 --- a/source/text/scalc/00/00000004.xhp +++ b/source/text/scalc/00/00000004.xhp @@ -1,7 +1,5 @@ - - - + - - - -To access this function... -/text/scalc/00/00000004.xhp - + + To access this function... + /text/scalc/00/00000004.xhp + -To access this function... - -More explanations on top of this page. - -In the %PRODUCTNAME Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone. -UFI: see #i43239# and #i3879# -Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable. - +To access this function... +More explanations on top of this page. +In the %PRODUCTNAME Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.UFI: see #i43239# and #i3879# +Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable. diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp index 55800e353c..bf8ddefe98 100644 --- a/source/text/scalc/00/00000402.xhp +++ b/source/text/scalc/00/00000402.xhp @@ -24,36 +24,32 @@ /text/scalc/00/00000402.xhp - - - Edit Menu -Choose Insert - Headers and Footers -Choose Insert - Headers and Footers - Header and Footer tabs -Choose Sheet - Fill Cells -Choose Sheet - Fill Cells - Down -Choose Sheet - Fill Cells - Right -Choose Sheet - Fill Cells - Up -Choose Sheet - Fill Cells - Left -Choose Sheet - Fill Cells - Sheets -Choose Sheet - Fill Cells - Series +Choose Insert - Headers and Footers. +Choose Insert - Headers and Footers - Header and Footer tabs. +Choose Sheet - Fill Cells. +Choose Sheet - Fill Cells - Down. +Choose Sheet - Fill Cells - Right. +Choose Sheet - Fill Cells - Up. +Choose Sheet - Fill Cells - Left. +Choose Sheet - Fill Cells - Sheets. +Choose Sheet - Fill Cells - Series.
-Choose Sheet - Clear Cells +Choose Sheet - Clear Cells. Backspace
-Choose Sheet - Delete Cells +Choose Sheet - Delete Cells.
-Choose Sheet - Delete Sheet -Open context menu for a sheet tab +Choose Sheet - Delete Sheet. +Open context menu for a sheet tab.
-Choose Sheet - Move or Copy Sheet -Open context menu for a sheet tab +Choose Sheet - Move or Copy Sheet. +Open context menu for a sheet tab.
- diff --git a/source/text/scalc/00/00000403.xhp b/source/text/scalc/00/00000403.xhp index 48790edf88..8ae11a39b1 100644 --- a/source/text/scalc/00/00000403.xhp +++ b/source/text/scalc/00/00000403.xhp @@ -24,15 +24,11 @@ /text/scalc/00/00000403.xhp - - - View Menu -Choose View - Column & Row Headers -Choose View - Value Highlighting -Choose View - Formula Bar or View - Toolbars - Formula Bar -Choose View - Page Break +Choose View - Column & Row Headers. +Choose View - Value Highlighting. +Choose View - Formula Bar or View - Toolbars - Formula Bar. +Choose View - Page Break. - diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp index 55ca30218f..05bfeca0d7 100644 --- a/source/text/scalc/00/00000404.xhp +++ b/source/text/scalc/00/00000404.xhp @@ -1,6 +1,5 @@ - - + - - - - -Insert Menu -/text/scalc/00/00000404.xhp - - -Sun Microsystems, Inc. - + + Insert Menu + /text/scalc/00/00000404.xhp + + + Sun Microsystems, Inc. + Insert Menu
-Choose Insert - Cells - -Open Insert Cells toolbar from Tools bar: +Choose Insert - Cells. +Open Insert Cells toolbar from Tools bar:
-Icon - +Icon Insert Cells @@ -58,8 +52,7 @@ -Icon - +Icon Insert Cells Down @@ -73,8 +66,7 @@ -Icon - +Icon Insert Cells Right @@ -88,8 +80,7 @@ -Icon - +Icon Insert Rows @@ -103,8 +94,7 @@ -Icon - +Icon Insert Columns @@ -113,13 +103,10 @@
-Choose Sheet - Insert Sheet - -Choose Sheet - Insert Sheet from File - +Choose Sheet - Insert Sheet. +Choose Sheet - Insert Sheet from File.
-Choose Insert - Function - +Choose Insert - Function. CommandCtrl+F2 On Formula Bar, click
@@ -127,8 +114,7 @@ -Icon - +Icon Function Wizard @@ -140,7 +126,7 @@
Insert - Function - Category Database -Insert - Function - Category Date&Time +Insert - Function - Category Date & Time Insert - Function - Category Financial @@ -162,22 +148,15 @@ Insert - Function - Category Add-In -Choose Insert - Function List - -Choose Insert - Named Ranges and Expressions - -Choose Sheet - Link to External data - +Choose Insert - Function List. +Choose Insert - Named Ranges and Expressions. +Choose Sheet - Link to External data.
-Choose Sheet - Named Ranges and Expressions - Define - +Choose Sheet - Named Ranges and Expressions - Define. CommandCtrl+F3
-Choose Sheet - Named Ranges and Expressions - Insert - -Choose Sheet - Named Ranges and Expressions - Create - -Choose Sheet - Named Ranges and Expressions - Labels - +Choose Sheet - Named Ranges and Expressions - Insert. +Choose Sheet - Named Ranges and Expressions - Create. +Choose Sheet - Named Ranges and Expressions - Labels. diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp index 9ba544c2be..58c0ff157f 100644 --- a/source/text/scalc/00/00000405.xhp +++ b/source/text/scalc/00/00000405.xhp @@ -1,6 +1,5 @@ - - + - - + - -Format Menu -/text/scalc/00/00000405.xhp - - -Sun Microsystems, Inc. - + + Format Menu + /text/scalc/00/00000405.xhp + + + Sun Microsystems, Inc. + Format Menu -Choose Format - Cells - -Choose Format - Cells - Cell Protection tab - -Choose Format - Row - -Choose Format - Row - Optimal Height - +Choose Format - Cells. +Choose Format - Cells - Cell Protection tab. +Choose Format - Row. +Choose Format - Row - Optimal Height.
-Choose Format - Row - Hide - -Choose Format - Column - Hide - -Choose Format - Sheet - Hide - +Choose Format - Row - Hide. +Choose Format - Column - Hide. +Choose Format - Sheet - Hide.
-Choose Format - Row - Show - -Choose Format - Column - Show - +Choose Format - Row - Show. +Choose Format - Column - Show.
-Choose Format - Column - +Choose Format - Column.
-Choose Format - Column - Optimal Width - -Double-click right column separator in column headers +Choose Format - Column - Optimal Width. +Double-click right column separator in column headers.
-Choose Format - Sheet - -Choose Format - Sheet - Rename - -Choose Format - Sheet - Show - -Choose Format - Page - -Choose Format - Page - Sheet tab - -Choose Format - Print Ranges - -Choose Format - Print Ranges - Define - -Choose Format - Print Ranges - Add - -Choose Format - Print Ranges - Clear - -Choose Format - Print Ranges - Edit - +Choose Format - Sheet. +Choose Format - Sheet - Rename. +Choose Format - Sheet - Show. +Choose Format - Page. +Choose Format - Page - Sheet tab. +Choose Format - Print Ranges. +Choose Format - Print Ranges - Define. +Choose Format - Print Ranges - Add. +Choose Format - Print Ranges - Clear. +Choose Format - Print Ranges - Edit.
-Choose Format - AutoFormat - -On the Tools bar, click +Choose Format - AutoFormat. + On the Tools bar, click
-Icon - +Icon AutoFormat @@ -100,7 +75,6 @@ -Choose Format - Conditional Formatting - +Choose Format - Conditional Formatting. diff --git a/source/text/scalc/00/00000406.xhp b/source/text/scalc/00/00000406.xhp index bcb89eb446..8818c68057 100644 --- a/source/text/scalc/00/00000406.xhp +++ b/source/text/scalc/00/00000406.xhp @@ -24,44 +24,40 @@ /text/scalc/00/00000406.xhp - - - Tools Menu -Choose Tools - Detective +Choose Tools - Detective.
-Choose Tools - Detective - Trace Precedents +Choose Tools - Detective - Trace Precedents. Shift+F7
-Menu Tools - Language - Hyphenation -Choose Tools - Detective - Remove Precedents +Menu Tools - Language - Hyphenation. +Choose Tools - Detective - Remove Precedents.
-Choose Tools - Detective - Trace Dependents +Choose Tools - Detective - Trace Dependents. Shift+F5
-Choose Tools - Detective - Remove Dependents -Choose Tools - Detective - Remove All Traces -Choose Tools - Detective - Trace Error -Choose Tools - Detective - Fill Mode -Choose Tools - Detective - Mark Invalid Data -Choose Tools - Detective - Refresh Traces -Choose Tools - Detective - AutoRefresh -Choose Tools - Goal Seek -Choose Tools - Solver -Choose Tools - Solver, Options button -Choose Tools - Scenarios -Choose Tools - Protect Sheet -Choose Tools - Protect Spreadsheet +Choose Tools - Detective - Remove Dependents. +Choose Tools - Detective - Remove All Traces. +Choose Tools - Detective - Trace Error. +Choose Tools - Detective - Fill Mode. +Choose Tools - Detective - Mark Invalid Data. +Choose Tools - Detective - Refresh Traces. +Choose Tools - Detective - AutoRefresh. +Choose Tools - Goal Seek. +Choose Tools - Solver. +Choose Tools - Solver, click Options button. +Choose Tools - Scenarios. +Choose Tools - Protect Sheet. +Choose Tools - Protect Spreadsheet.
-Choose Data - Calculate - Recalculate +Choose Data - Calculate - Recalculate. F9
-Choose Data - Calculate - AutoCalculate -Choose Tools - AutoInput +Choose Data - Calculate - AutoCalculate. +Choose Tools - AutoInput. - - \ No newline at end of file + diff --git a/source/text/scalc/00/00000407.xhp b/source/text/scalc/00/00000407.xhp index 2021aeb149..8623bb0ac2 100644 --- a/source/text/scalc/00/00000407.xhp +++ b/source/text/scalc/00/00000407.xhp @@ -24,13 +24,9 @@ /text/scalc/00/00000407.xhp - - - Window Menu -Choose View - Split Window -Choose View - Freeze Cells - Freeze Rows and Columns +Choose >View - Split Window. +Choose View - Freeze Cells - Freeze Rows and Columns. - diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp index ef5b522522..3274de79a6 100644 --- a/source/text/scalc/00/00000412.xhp +++ b/source/text/scalc/00/00000412.xhp @@ -1,7 +1,5 @@ - - - + - - - -Data Menu -/text/scalc/00/00000412.xhp - + + Data Menu + /text/scalc/00/00000412.xhp + Data Menu -Choose Data - Text to Columns - -Choose Data - Define Range - -Choose Data - Select Range - -Choose Data - Sort... - +Choose Data - Text to Columns. +Choose Data - Define Range. +Choose Data - Select Range. +Choose Data - Sort....
-Choose Data - Sort - Sort Criteria tab -On Standard bar, click +Choose Data - Sort - Sort Criteria tab. + On Standard bar, click
-Icon - +Icon Sort Ascending @@ -56,8 +47,7 @@ -Icon - +Icon Sort Descending @@ -66,21 +56,17 @@
-Choose Data - Sort - Options tab - -Choose Data - Filter - +Choose Data - Sort - Options tab. +Choose Data - Filter.
-Choose Data - AutoFilter - -On Tools bar or Table Data bar, click +Choose Data - AutoFilter. +On Tools bar or Table Data bar, click
-Icon - +Icon AutoFilter @@ -89,23 +75,19 @@
-Choose Data - More Filters - Advanced Filter... - +Choose Data - More Filters - Advanced Filter... .
-Choose Data - More Filters - Standard Filter... - Options label -Choose Data - More Filters - Advanced Filter... - Options label +Choose Data - More Filters - Standard Filter... - Options label. +Choose Data - More Filters - Advanced Filter... - Options label.
-Choose Data - More Filters - Reset Filter - -On Table Data bar, click Reset Filter/Sort - +Choose Data - More Filters - Reset Filter. + On Table Data bar, click Reset Filter/Sort. -Icon - +Icon Reset Filter/Sort @@ -113,35 +95,21 @@
-Choose Data - More Filter - Hide AutoFilter - -Choose Data - Subtotals - -Choose Data - Subtotals - 1st, 2nd, 3rd Group tabs - -Choose Data - Subtotals - Options tab - -Choose Data - Validity - -Menu Data - Validity - Criteria tab - -Choose Data - Validity - Input Help tab - -Choose Data - Validity - Error Alert tab - -Choose Data - Multiple Operations - -Choose Data - Consolidate - -Choose Data - Group and Outline - -Choose Data - Group and Outline - Hide Details - -Choose Data - Group and Outline - Show Details - +Choose Data - More Filter - Hide AutoFilter. +Choose Data - Subtotals. +Choose Data - Subtotals - 1st, 2nd, 3rd Group tabs. +Choose Data - Subtotals - Options tab. +Choose Data - Validity. +Menu Data - Validity - Criteria tab. +Choose Data - Validity - Input Help tab. +Choose Data - Validity - Error Alert tab. +Choose Data - Multiple Operations. +Choose Data - Consolidate. +Choose Data - Group and Outline. +Choose Data - Group and Outline - Hide Details. +Choose Data - Group and Outline - Show Details.
-Choose Data - Group and Outline - Group - +Choose Data - Group and Outline - Group. F12 On Tools bar, click
@@ -149,8 +117,7 @@ -Icon - +Icon Group @@ -160,8 +127,7 @@
-Choose Data - Group and Outline - Ungroup - +Choose Data - Group and Outline - Ungroup. CommandCtrl+F12 On Tools bar, click
@@ -169,8 +135,7 @@ -Icon - +Icon Ungroup @@ -179,29 +144,19 @@
-Choose Data - Group and Outline - AutoOutline - -Choose Data - Group and Outline - Remove - -Choose Data - Group and Outline - Show Details (for some pivot tables) - -Choose Data - Pivot Table - -Choose Insert - Pivot Table - -Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename]. - +Choose Data - Group and Outline - AutoOutline. +Choose Data - Group and Outline - Remove. +Choose Data - Group and Outline - Show Details (for some pivot tables). +Choose Data - Pivot Table. +Choose Insert - Pivot Table. +Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename].
-Choose Insert - Pivot Table, in the Select Source dialog choose the option Current selection. -Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename], click OK to see Select Data Source dialog. +Choose Insert - Pivot Table, in the Select Source dialog choose the option Current selection. +Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename], click OK to see Select Data Source dialog.
-Choose Data - Pivot Table - Refresh - -Choose Data - Pivot Table - Delete - -Choose Data - Refresh Range - -Choose Data - Group and Outline - Group - +Choose Data - Pivot Table - Refresh. +Choose Data - Pivot Table - Delete. +Choose Data - Refresh Range. +Choose Data - Group and Outline - Group. diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp index 04e6e6ac0d..41a7be2f7a 100644 --- a/source/text/scalc/00/sheet_menu.xhp +++ b/source/text/scalc/00/sheet_menu.xhp @@ -24,21 +24,17 @@ /scalc/00/sheet_menu.xhp - - - Sheet Menu -Choose Sheet - Insert Rows - Rows Above -Choose Sheet - Insert Rows - Rows Below -Choose Sheet - Insert Columns - Columns Left -Choose Sheet - Insert Columns - Columns Right -Choose Sheet - Insert Page Break - -Choose Sheet - Insert Page Break - Row Break -Choose Sheet - Insert Page Break - Column Break -Choose Sheet - Delete Page Break -Choose Sheet - Delete Page Break - Row Break -Choose Sheet - Delete Page Break - Column Break +Choose Sheet - Insert Rows - Rows Above. +Choose Sheet - Insert Rows - Rows Below. +Choose Sheet - Insert Columns - Columns Left. +Choose Sheet - Insert Columns - Columns Right. +Choose Sheet - Insert Page Break. +Choose Sheet - Insert Page Break - Row Break. +Choose Sheet - Insert Page Break - Column Break. +Choose Sheet - Delete Page Break. +Choose Sheet - Delete Page Break - Row Break. +Choose Sheet - Delete Page Break - Column Break. -- cgit