From 3bf3b943ff05fda627498426a23f94cd0e0b7aab Mon Sep 17 00:00:00 2001 From: Kalman Szalai - KAMI Date: Fri, 2 Dec 2011 21:56:52 +0100 Subject: Uniformize shortcuts --- helpcontent2/source/text/scalc/01/04060107.xhp | 4 ++-- helpcontent2/source/text/scalc/04/01020000.xhp | 17 ++++++++--------- helpcontent2/source/text/scalc/guide/calc_series.xhp | 4 ++-- .../source/text/scalc/guide/datapilot_createtable.xhp | 3 +-- .../source/text/scalc/guide/edit_multitables.xhp | 2 +- helpcontent2/source/text/scalc/guide/format_table.xhp | 2 +- helpcontent2/source/text/scalc/guide/move_dragdrop.xhp | 6 +++--- helpcontent2/source/text/scalc/guide/multitables.xhp | 6 ++---- helpcontent2/source/text/scalc/guide/scenario.xhp | 2 +- helpcontent2/source/text/scalc/guide/sorted_list.xhp | 2 +- 10 files changed, 22 insertions(+), 26 deletions(-) (limited to 'helpcontent2/source/text/scalc') diff --git a/helpcontent2/source/text/scalc/01/04060107.xhp b/helpcontent2/source/text/scalc/01/04060107.xhp index 5fa4da4162..598712905f 100644 --- a/helpcontent2/source/text/scalc/01/04060107.xhp +++ b/helpcontent2/source/text/scalc/01/04060107.xhp @@ -173,7 +173,7 @@ Editing Array Formulas -Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press Command Ctrl + /, where / is the Division key on the numeric keypad. +Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press CommandCtrl+/, where / is the Division key on the numeric keypad. Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula. @@ -212,7 +212,7 @@ When you adjust the array range, the array formula will not automatically be adjusted. You are only changing the range in which the result will appear. -By holding down the Command Ctrl key, you can create a copy of the array formula in the given range. +By holding down the CommandCtrl key, you can create a copy of the array formula in the given range. Conditional Array Calculations A conditional array calculation is an array or matrix formula that includes an IF() or CHOOSE() function. The condition argument in the formula is an area reference or a matrix result. In the following example, the >0 test of the {=IF(A1:A3>0;"yes";"no")} formula is applied to each cell in the range A1:A3 and the result is copied to the corresponding cell. diff --git a/helpcontent2/source/text/scalc/04/01020000.xhp b/helpcontent2/source/text/scalc/04/01020000.xhp index 0d77bd2a14..0d50c1bd7a 100644 --- a/helpcontent2/source/text/scalc/04/01020000.xhp +++ b/helpcontent2/source/text/scalc/04/01020000.xhp @@ -52,8 +52,7 @@ Alt+Enter. Hold down Option Alt+Enter+Shift to apply the cell format of the input cell to the entire cell range. To create a matrix in which all the cells contain the same information as what you entered on the Input line, press Shift+CommandCtrl+Enter. You cannot edit the components of the matrix. -To select multiple cells in different areas of a sheet, hold down Command -Ctrl and drag in the different areas. +To select multiple cells in different areas of a sheet, hold down CommandCtrl and drag in the different areas. To select multiple sheets in a spreadsheet, hold down CommandCtrl, and then click the name tabs at the lower edge of the workspace. To select only one sheet in a selection, hold down Shift, and then click the name tab of the sheet. To insert a manual line break in a cell, click in the cell, and then press CommandCtrl+Enter. To delete the contents of selected cells, press Delete. This opens the Delete Contents dialog, where you choose which contents of the cell you want to delete. To delete the contents of selected cells without a dialog, press the Backspace key. @@ -227,7 +226,7 @@ -CommandCtrl + * +CommandCtrl+ * where (*) is the multiplication sign on the numeric key pad @@ -236,7 +235,7 @@ -CommandCtrl + / +CommandCtrl+ / where (/) is the division sign on the numeric key pad @@ -269,7 +268,7 @@ -Command Ctrl + ` (see note below this table) +CommandCtrl+ ` (see note below this table) Displays or hides the formulas instead of the values in all cells.i56202 @@ -477,7 +476,7 @@ Option -Alt + Down Arrow +Alt+ Down Arrow Increases the height of current row. @@ -486,7 +485,7 @@ Option -Alt + Up Arrow +Alt+ Up Arrow Decreases the height of current row. @@ -495,7 +494,7 @@ Option -Alt + Right Arrow +Alt+ Right Arrow Increases the width of the current column. @@ -504,7 +503,7 @@ Option -Alt + Left Arrow +Alt+ Left Arrow Decreases the width of the current column. diff --git a/helpcontent2/source/text/scalc/guide/calc_series.xhp b/helpcontent2/source/text/scalc/guide/calc_series.xhp index b3642f22d4..0b5d441a69 100644 --- a/helpcontent2/source/text/scalc/guide/calc_series.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_series.xhp @@ -67,8 +67,8 @@ To quickly create a list of consecutive days, enter Monday in a cell, and drag the fill handle. - Hold down Command -Ctrl if you do not want to fill the cells with different values. + Hold down Command +Ctrl if you do not want to fill the cells with different values. If you select two or more adjacent cells that contain different numbers, and drag, the remaining cells are filled with the arithmetic pattern that is recognized in the numbers. The AutoFill function also recognizes customized lists that are defined under %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - Sort Lists. You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter Jan into A1 and drag the fill handle down to A12 to get the twelve months in the first column. Now enter some values into B1 and C1. Select those two cells, and double-click the fill handle. This fills automatically the data block B1:C12. Using a Defined Series diff --git a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp index 1a6be7babf..1ef495f404 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp @@ -61,8 +61,7 @@ By double-clicking on one of the fields in the Data Fields area you can call up the Data Field dialog. - Use the Data Field dialog to select the calculations to be used for the data. To make a multiple selection, press the Command -Ctrl key while clicking the desired calculation. + Use the Data Field dialog to select the calculations to be used for the data. To make a multiple selection, press the CommandCtrl key while clicking the desired calculation. diff --git a/helpcontent2/source/text/scalc/guide/edit_multitables.xhp b/helpcontent2/source/text/scalc/guide/edit_multitables.xhp index a46d8a26ad..10dbd10f66 100644 --- a/helpcontent2/source/text/scalc/guide/edit_multitables.xhp +++ b/helpcontent2/source/text/scalc/guide/edit_multitables.xhp @@ -53,7 +53,7 @@ In $[officename] Calc, you can insert values, text or formulas that are simultaneously copied to other selected sheets of your document. - Select all desired sheets by holding down the Command Ctrl key and clicking the corresponding register tabs that are still gray at the bottom margin of the workspace. All selected register tabs are now white. + Select all desired sheets by holding down the CommandCtrl key and clicking the corresponding register tabs that are still gray at the bottom margin of the workspace. All selected register tabs are now white. You can use Shift+CommandCtrl+Page Up or Page Down to select multiple sheets using the keyboard. diff --git a/helpcontent2/source/text/scalc/guide/format_table.xhp b/helpcontent2/source/text/scalc/guide/format_table.xhp index c71896440c..a42be7a31b 100644 --- a/helpcontent2/source/text/scalc/guide/format_table.xhp +++ b/helpcontent2/source/text/scalc/guide/format_table.xhp @@ -71,7 +71,7 @@ Formatting Borders and Backgrounds for Cells and Pages -You can assign a format to any group of cells by first selecting the cells (for multiple selection, hold down the Command Ctrl key when clicking), and then activating the Format Cells dialog in Format - Cell. In this dialog, you can select attributes such as shadows and backgrounds. +You can assign a format to any group of cells by first selecting the cells (for multiple selection, hold down the CommandCtrl key when clicking), and then activating the Format Cells dialog in Format - Cell. In this dialog, you can select attributes such as shadows and backgrounds. To apply formatting attributes to an entire sheet, choose Format - Page. You can define headers and footers, for example, to appear on each printed page. diff --git a/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp b/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp index a9bd366561..b309baf69c 100644 --- a/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp +++ b/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp @@ -61,7 +61,7 @@ If you move cells in insert mode within the same row (only horizontally), then after insertion of the cells, all cells will be shifted to the left to fill the source area. -In both modes, you can hold down the Command Ctrl key, or CommandCtrl+Shift keys while you release the mouse button to insert a copy or a link, respectively. +In both modes, you can hold down the CommandCtrl key, or CommandCtrl+Shift keys while you release the mouse button to insert a copy or a link, respectively. @@ -81,7 +81,7 @@ -Command Ctrl key +CommandCtrl key Cells are copied and overwrite the cells in the target area. Source cells stay as they are. @@ -106,7 +106,7 @@ -Option+Command Alt+Ctrl keys +Option+Command Alt+Ctrl keys Cells are copied and shift the cells in the target area to the right or to the bottom. Source cells stay as they are. diff --git a/helpcontent2/source/text/scalc/guide/multitables.xhp b/helpcontent2/source/text/scalc/guide/multitables.xhp index 927ced0d9d..537405dc97 100644 --- a/helpcontent2/source/text/scalc/guide/multitables.xhp +++ b/helpcontent2/source/text/scalc/guide/multitables.xhp @@ -69,14 +69,12 @@ Click to deselect all sheets in the document, except the current sheet. Selecting Multiple Sheets - 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 Command -Ctrl you can select multiple sheets. + 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 CommandCtrl you can select multiple sheets. You can use Shift+Command Ctrl+Page Up or Page Down to select multiple sheets using the keyboard. Undoing a Selection - To undo the selection of a sheet, click its sheet tab again while pressing the Command -Ctrl key. The sheet that is currently visible cannot be removed from the selection. + To undo the selection of a sheet, click its sheet tab again while pressing the CommandCtrl key. The sheet that is currently visible cannot be removed from the selection. Calculating Across Multiple Sheets You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, =SUM(Sheet1.A1:Sheet3.A1) sums up all A1 cells on Sheet1 through Sheet3. diff --git a/helpcontent2/source/text/scalc/guide/scenario.xhp b/helpcontent2/source/text/scalc/guide/scenario.xhp index 1fc9e30174..53c53f2ae9 100644 --- a/helpcontent2/source/text/scalc/guide/scenario.xhp +++ b/helpcontent2/source/text/scalc/guide/scenario.xhp @@ -50,7 +50,7 @@ To create a scenario, select all the cells that provide the data for the scenario. -Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the Command Ctrl key as you click each cell. +Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the CommandCtrl key as you click each cell. Choose Tools - Scenarios. The Create Scenario dialog appears. diff --git a/helpcontent2/source/text/scalc/guide/sorted_list.xhp b/helpcontent2/source/text/scalc/guide/sorted_list.xhp index b880cbf662..778914c693 100644 --- a/helpcontent2/source/text/scalc/guide/sorted_list.xhp +++ b/helpcontent2/source/text/scalc/guide/sorted_list.xhp @@ -57,7 +57,7 @@ Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items. 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. - Hold down Command Ctrl if you do not want to fill the cells with different values. + Hold down CommandCtrl if you do not want to fill the cells with different values. The predefined series can be found under %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - Sort Lists. You can also create your own lists of text strings tailored to your needs, such as a list of your company's branch offices. When you use the information in these lists later (for example, as headings), just enter the first name in the list and expand the entry by dragging it with your mouse.
-- cgit