Value Highlighting

+To remove the highlighting, unmark the menu entry. +

-Text cells are formatted in black, formulas in green, and number cells in blue, no matter how their display is formatted. -If this function is active, colors that you define in the document will not be displayed. When you deactivate the function, the user-defined colors are displayed again. +Text cells are formatted in black, formulas in green, and number cells in blue, no matter how their display is formatted. +If this function is active, colors that you define in the document will not be displayed. When you deactivate the function, the user-defined colors are displayed again. - + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/05070000.xhp b/helpcontent2/source/text/scalc/01/05070000.xhp index add22f3457..54b94b63e8 100644 --- a/helpcontent2/source/text/scalc/01/05070000.xhp +++ b/helpcontent2/source/text/scalc/01/05070000.xhp @@ -4,7 +4,7 @@ Page Style Opens a dialog where you can define the appearance of all pages in your document. @@ -53,6 +53,6 @@

diff --git a/helpcontent2/source/text/scalc/01/12090100.xhp b/helpcontent2/source/text/scalc/01/12090100.xhp index 1cf06da8dd..ca607ea14c 100644 --- a/helpcontent2/source/text/scalc/01/12090100.xhp +++ b/helpcontent2/source/text/scalc/01/12090100.xhp @@ -60,7 +60,7 @@ Uses a table or query in a database that is registered in $[officename] as the data source for the DataPilot table. External source/interface -Opens the External Source dialog where you can select the OLAP data source for the DataPilot table. +Opens the External Source dialog where you can select the OLAP data source for the DataPilot table. DataPilot dialog diff --git a/helpcontent2/source/text/scalc/02/06040000.xhp b/helpcontent2/source/text/scalc/02/06040000.xhp index 506114fc4f..e1abbd8f8b 100644 --- a/helpcontent2/source/text/scalc/02/06040000.xhp +++ b/helpcontent2/source/text/scalc/02/06040000.xhp @@ -34,10 +34,6 @@ Function /text/scalc/02/06040000.xhp - -Sun Microsystems, Inc. -converted from old format - fpe -

@@ -48,7 +44,7 @@ Function Adds a formula to the current cell. Click this icon, and then enter the formula in the Input line.

-This icon is only available when the Input line box is hidden. +This icon is only available when the Input line box is not active.

diff --git a/helpcontent2/source/text/scalc/guide/borders.xhp b/helpcontent2/source/text/scalc/guide/borders.xhp index f1b32ec60c..160840f2b5 100755 --- a/helpcontent2/source/text/scalc/guide/borders.xhp +++ b/helpcontent2/source/text/scalc/guide/borders.xhp @@ -1,11 +1,11 @@ - + - - + + User Defined Borders in Cells - text/scalc/guide/borders.xhp + /text/scalc/guide/borders.xhp diff --git a/helpcontent2/source/text/scalc/guide/calculate.xhp b/helpcontent2/source/text/scalc/guide/calculate.xhp index c764a0b755..564da5d59f 100644 --- a/helpcontent2/source/text/scalc/guide/calculate.xhp +++ b/helpcontent2/source/text/scalc/guide/calculate.xhp @@ -1,11 +1,8 @@ - - - - - - + ************************************************************************ --> + - - Calculating in Spreadsheets - /text/scalc/guide/calculate.xhp - - - -spreadsheets; calculating - calculating; spreadsheets - formulas; calculating + +Calculating in Spreadsheets +text/scalc/guide/calculate.xhp + + + + +spreadsheets; calculating +calculating; spreadsheets +formulas; calculating mw changed "formulas;..." entry -Calculating in Spreadsheets - - The following is an example of a calculation in $[officename] Calc. - - - Click in a cell, and type a number - - - Press Enter. - The cursor moves down to the next cell. - - - Enter another number. - - - Press the Tab key. - The cursor moves to the right into the next cell. - - - Type in a formula, for example, =A3 * A4 / 100. - - - - Press Enter. - The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar. - When you edit a formula, the new result is calculated automatically. - - -

- +Calculating in Spreadsheets +The following is an example of a calculation in $[officename] Calc. + + +Click in a cell, and type a number + + +Press Enter. +The cursor moves down to the next cell. + + +Enter another number. + + +Press the Tab key. +The cursor moves to the right into the next cell. + + +Type in a formula, for example, =A3 * A4 / 100. + + + Press Enter. +The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar. +When you edit a formula, the new result is calculated automatically. + + +

+ \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp index 3e5ac91aa7..20082ed7dd 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp @@ -1,11 +1,11 @@ - + - - + + Editing DataPilot Tables @@ -50,6 +50,8 @@ To remove a button from the table, just drag it out of the DataPilot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted. To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command Start, which displays the DataPilot dialog for the current DataPilot table. In the DataPilot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields. + You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside DataPilot tables. A custom display name is assigned to an item by overwriting the original name with another name. +

diff --git a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp index 65d2663b99..87e7e3ab5c 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp @@ -1,11 +1,8 @@ - - - - - - + ************************************************************************ --> + - - Filtering DataPilot Tables - /text/scalc/guide/datapilot_filtertable.xhp - - - -DataPilot function; filtering tables - filtering;DataPilot tables -mw deleted "filters;" -Filtering DataPilot Tables - - You can use filters to remove unwanted data from a DataPilot table.UFI: removed help id -Click the Filter button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the Filter command. The Filter dialog appears. Here you can filter the DataPilot table. -

- + +Filtering DataPilot Tables +/text/scalc/guide/datapilot_filtertable.xhp + + + + +DataPilot function; filtering tables +filtering;DataPilot tables + +Filtering DataPilot Tables +You can use filters to remove unwanted data from a DataPilot table. +Click the Filter button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the Filter command. The Filter dialog appears. Here you can filter the DataPilot table. +You can also click the arrow on a button in the DataPilot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field. + + +The pop-up window displays a list of field members associated with that field. A check box is placed to the left of each field member name. When a field has an alternative display name that differs from its original name, that name is displayed in the list. + + +Enable or disable a checkbox to show or hide the associated field member in the DataPilot table. + + +Enable or disable the All checkbox to show all or none of the field members. + + +Select a field member in the pop-up window and click the Show only the current item button to show only the selected field member. All other field members are hidden in the DataPilot table. + + +Select a field member in the pop-up window and click the Hide only the current item button to hide only the selected field member. All other field members are shown in the DataPilot table. + + +Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list. + + +To edit the custom sort lists, open %PRODUCTNAME - Preferences +Tools - Options - %PRODUCTNAME Calc - Sort Lists. + + +The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner. + + +You can also open the pop-up window by positioning the cell cursor at the button and pressing Command +Ctrl+D. + +

+ \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/finding.xhp b/helpcontent2/source/text/scalc/guide/finding.xhp index d3bafa15c0..6b23d1a583 100644 --- a/helpcontent2/source/text/scalc/guide/finding.xhp +++ b/helpcontent2/source/text/scalc/guide/finding.xhp @@ -1,11 +1,11 @@ - + - - + + Finding and Replacing in Calc -text/scalc/guide/finding.xhp +/text/scalc/guide/finding.xhp diff --git a/helpcontent2/source/text/scalc/guide/multitables.xhp b/helpcontent2/source/text/scalc/guide/multitables.xhp index 0aa8986679..ca5895d771 100644 --- a/helpcontent2/source/text/scalc/guide/multitables.xhp +++ b/helpcontent2/source/text/scalc/guide/multitables.xhp @@ -1,11 +1,11 @@ - + - - + + Applying Multiple Sheets @@ -55,23 +55,33 @@ Choose Insert - Sheet to insert a new sheet or an existing sheet from another file. + +Sheet Events +Opens a dialog box where you can assign macros to sheet events. + +Tab Color + +Opens a window where you can assign a color to the sheet tab. + Click to select all sheets in the document. 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 + 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. 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 + 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. 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/value_with_name.xhp b/helpcontent2/source/text/scalc/guide/value_with_name.xhp index cbc431b0f4..5cb9169e04 100755 --- a/helpcontent2/source/text/scalc/guide/value_with_name.xhp +++ b/helpcontent2/source/text/scalc/guide/value_with_name.xhp @@ -1,11 +1,11 @@ - + - - + + Naming Cells @@ -69,6 +69,7 @@ Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell. + Names must not start with the letter R followed by a number. See the ADDRESS function for more information. Names for cell ranges must not include blanks. Blanks are allowed within names for single cells, sheets and documents. Naming cells and formulas A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 Start. You can then write a formula such as "=SUM(Start)". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces. -- cgit From b0515ab706d76725b0f4f3a37b7b86df05a900b5 Mon Sep 17 00:00:00 2001 From: Uwe Fischer Date: Wed, 20 Oct 2010 12:57:06 +0200 Subject: hcshared28: before first build --- helpcontent2/source/text/scalc/01/04050000.xhp | 16 ++++++++-------- helpcontent2/source/text/scalc/guide/multioperation.xhp | 6 +++--- helpcontent2/source/text/scalc/guide/rename_table.xhp | 2 +- helpcontent2/source/text/scalc/guide/row_height.xhp | 2 +- helpcontent2/source/text/scalc/guide/text_rotate.xhp | 10 +++++----- 5 files changed, 18 insertions(+), 18 deletions(-) (limited to 'helpcontent2/source/text/scalc') diff --git a/helpcontent2/source/text/scalc/01/04050000.xhp b/helpcontent2/source/text/scalc/01/04050000.xhp index d4cbb09f32..b4c719ac1d 100644 --- a/helpcontent2/source/text/scalc/01/04050000.xhp +++ b/helpcontent2/source/text/scalc/01/04050000.xhp @@ -1,11 +1,11 @@ - + - - + + Insert Sheet @@ -44,7 +44,7 @@ Insert Sheet -Defines the options to be used to insert a new sheet. You can create a new sheet, or insert an existing sheet from a file. +Defines the options to be used to insert a new sheet. You can create a new sheet, or insert an existing sheet from a file.

@@ -57,13 +57,13 @@ After current sheet Inserts a new sheet directly after the current sheet. -Create +Sheet Specifies whether a new sheet or an existing sheet is inserted into the document. -Create +New sheet Creates a new sheet. Enter a sheet name in the Name field. Allowed characters are letters, numbers, spaces, and the underline character. -No. of Sheets +No. of sheets Specifies the number of sheets to be created. Name diff --git a/helpcontent2/source/text/scalc/guide/multioperation.xhp b/helpcontent2/source/text/scalc/guide/multioperation.xhp index 3c821540ae..6a0b5cfff8 100755 --- a/helpcontent2/source/text/scalc/guide/multioperation.xhp +++ b/helpcontent2/source/text/scalc/guide/multioperation.xhp @@ -49,7 +49,7 @@ Multiple Operations in Columns or Rows The Data - Multiple Operations 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. -In the Formula field, enter the cell reference to the formula that applies to the data range. In the Column input cell/Row input cell field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples: +In the Formulas field, enter the cell reference to the formula that applies to the data range. In the Column input cell/Row input cell field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples: Examples You produce toys which you sell for $10 each. Each toy costs $2 to make, in addition to which you have fixed costs of $10,000 per year. How much profit will you make in a year if you sell a particular number of toys? @@ -105,7 +105,7 @@ Multiple Operations Across Rows and Columns -%PRODUCTNAME allows you to carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell has to refer to both the data range arranged in rows and the one arranged in columns. Select the range defined by both data ranges and call the multiple operation dialog. Enter the reference to the formula in the Formula field. The Row input cell and the Column input cell fields are used to enter the reference to the corresponding cells of the formula. +%PRODUCTNAME allows you to carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell has to refer to both the data range arranged in rows and the one arranged in columns. Select the range defined by both data ranges and call the multiple operation dialog. Enter the reference to the formula in the Formulas field. The Row input cell and the Column input cell fields are used to enter the reference to the corresponding cells of the formula. Calculating with Two Variables Consider columns A and B of the sample table above. You now want to vary not just the quantity produced annually, but also the selling price, and you are interested in the profit in each case. Expand the table shown above. D2 thru D11 contain the numbers 500, 1000 and so on, up to 5000. In E1 through H1 enter the numbers 8, 10, 15 and 20. @@ -117,7 +117,7 @@ Choose Data - Multiple Operations. -With the cursor in the Formulas field, click cell B5. +With the cursor in the Formulas field, click cell B5. Set the cursor in the Row input cell field and click cell B1. This means that B1, the selling price, is the horizontally entered variable (with the values 8, 10, 15 and 20). diff --git a/helpcontent2/source/text/scalc/guide/rename_table.xhp b/helpcontent2/source/text/scalc/guide/rename_table.xhp index f43a5d288f..b80c07a946 100644 --- a/helpcontent2/source/text/scalc/guide/rename_table.xhp +++ b/helpcontent2/source/text/scalc/guide/rename_table.xhp @@ -51,7 +51,7 @@ Click the name of the sheet that you want to change. - Open the context menu and choose the Rename command. A dialog box appears where you can enter a new name. + Open the context menu and choose the Rename Sheet command. A dialog box appears where you can enter a new name. Enter a new name for the sheet and click OK. diff --git a/helpcontent2/source/text/scalc/guide/row_height.xhp b/helpcontent2/source/text/scalc/guide/row_height.xhp index 6b658b9403..f5a8a9a0e6 100644 --- a/helpcontent2/source/text/scalc/guide/row_height.xhp +++ b/helpcontent2/source/text/scalc/guide/row_height.xhp @@ -70,7 +70,7 @@ Start the context menu on the header at the left-hand side. -You will see the commands Height and Optimal row height. Choosing either opens a dialog. +You will see the commands Row Height and Optimal row height. Choosing either opens a dialog.

diff --git a/helpcontent2/source/text/scalc/guide/text_rotate.xhp b/helpcontent2/source/text/scalc/guide/text_rotate.xhp index 65f5fc35bc..634bf62801 100755 --- a/helpcontent2/source/text/scalc/guide/text_rotate.xhp +++ b/helpcontent2/source/text/scalc/guide/text_rotate.xhp @@ -1,11 +1,11 @@ - + - - + + Rotating Text @@ -55,7 +55,7 @@ Click the Alignment tab. - In the Text direction area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click OK. + In the Text orientation area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click OK. removed a wrong para, i104207

-- cgit