View Menu

-spreadsheets; displaying headers of columns/rows -displaying; headers of columns/rows + + +

+ + spreadsheets; displaying headers of columns/rows + displaying; headers of columns/rows + - -Column & Row Headers -Shows column headers and row headers. + +Column & Row Headers +Shows column headers and row headers.

+ - -To hide the column and row headers unmark this menu entry. - - + + To hide the column and row headers, unmark this menu entry. + +

+ - -You can also set the view of the column and row headers in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View. - - + + You can also set the view of the column and row headers in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View. + + diff --git a/source/text/scalc/01/03080000.xhp b/source/text/scalc/01/03080000.xhp index a007a339f9..de53520a4e 100644 --- a/source/text/scalc/01/03080000.xhp +++ b/source/text/scalc/01/03080000.xhp @@ -1,4 +1,5 @@ - + + +--> - -Value Highlighting -/text/scalc/01/03080000.xhp - + + Value Highlighting + /text/scalc/01/03080000.xhp + + -

+ + +

-spreadsheets; value highlighting -values;highlighting -highlighting; values in sheets -colors;values + spreadsheets; value highlighting + values;highlighting + highlighting; values in sheets + colors;values + -Value Highlighting -Displays cell contents in different colors, depending on type. + +Value Highlighting +Displays cell contents in different colors, depending on type.

To remove the highlighting, unmark the menu entry. -

+ +

Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, 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. + diff --git a/source/text/scalc/01/03090000.xhp b/source/text/scalc/01/03090000.xhp index 3bd775d0f0..1ced423ed1 100644 --- a/source/text/scalc/01/03090000.xhp +++ b/source/text/scalc/01/03090000.xhp @@ -1,6 +1,5 @@ - - + - - +--> + - -Formula Bar -/text/scalc/01/03090000.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - + + Formula Bar + /text/scalc/01/03090000.xhp + + -

-formula bar;spreadsheets -spreadsheets; formula bar + + +

+ + formula bar;spreadsheets + spreadsheets; formula bar - - -Formula Bar -Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets. + + + +Formula Bar +Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets.

-To hide the Formula Bar, unmark the menu item. +To hide the Formula Bar, unmark the menu item. +

-If the Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After editing cells, accept the changes by pressing Enter, or discard entries by pressing Esc. Esc is also used to exit the edit mode. +If the Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After editing cells, accept the changes by pressing Enter, or discard entries by pressing Esc. Esc is also used to exit the edit mode. + diff --git a/source/text/scalc/01/03100000.xhp b/source/text/scalc/01/03100000.xhp index 927e65f2e4..4396d76949 100644 --- a/source/text/scalc/01/03100000.xhp +++ b/source/text/scalc/01/03100000.xhp @@ -1,6 +1,5 @@ - - + - - +--> + - -Page Break Preview -/text/scalc/01/03100000.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - + + Page Break View + /text/scalc/01/03100000.xhp + + -

- - -Page Break Preview -Display the page breaks and print ranges in the sheet. Choose View - Normal to switch this mode off. + + +

+ + +Page Break View +Display the page breaks and print ranges in the sheet. Choose View - Normal to switch this mode off.

-The context menu of the page break preview contains functions for editing page breaks, including the following options: - - -Delete All Manual Breaks -Deletes all manual breaks in the current sheet. -Add Print Range -Adds the selected cells to print ranges. +The context menu of the page break preview contains functions for editing page breaks, including the following options: + + +Delete All Manual Breaks +Deletes all manual breaks in the current sheet. + +Add Print Range +Adds the selected cells to print ranges. + diff --git a/source/text/scalc/01/04080000.xhp b/source/text/scalc/01/04080000.xhp index 7bae5f7c78..7b46e44902 100644 --- a/source/text/scalc/01/04080000.xhp +++ b/source/text/scalc/01/04080000.xhp @@ -1,6 +1,5 @@ - - + - - +--> + - -Function List -/text/scalc/01/04080000.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - + + Function List + /text/scalc/01/04080000.xhp + + -formula list window -function list window -inserting functions; function list window + + + formula list window + function list window + inserting functions; function list window - - - -Function List -This command opens the Function List window, which displays all functions that can be inserted into your document. - The Function List window is similar to the Functions tab page of the Function Wizard. The functions are inserted with placeholders to be replaced with your own values. + + + +Function List +Opens the Function List deck of the Sidebar, which displays all functions that can be inserted into your document. The Function List deck is similar to the Functions tab page of the Function Wizard. The functions are inserted with placeholders to be replaced with your own values. +

-The Function List window is a resizable dockable window. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters. +The Function List window is a resizable dockable window. Use it to quickly enter functions in the spreadsheet. By double-clicking an entry in the functions list, the respective function is directly inserted with all parameters. -Category List + +Category List

-Function List -Displays the available functions. When you select a function, the area below the list box displays a short description. To insert the selected function double-click it or click the Insert Function into calculation sheet icon. + +Function List +Displays the available functions. When you select a function, the area below the list box displays a short description. To insert the selected function double-click it or click the Insert Function into calculation sheet icon. -Insert Function into calculation sheet + +Insert Function into calculation sheet + - - - -

Icon - - - -Inserts the selected function into the document. - - + + +

Icon + + + Inserts the selected function into the document. + +

+ diff --git a/source/text/scalc/01/05100000.xhp b/source/text/scalc/01/05100000.xhp index d18f1e3f34..2b3a076c9f 100644 --- a/source/text/scalc/01/05100000.xhp +++ b/source/text/scalc/01/05100000.xhp @@ -1,6 +1,5 @@ - - - +--> + - - Styles and Formatting - /text/scalc/01/05100000.xhp - - - -

-Stylist, see Styles and Formatting window - Styles and Formatting window - formats; Styles and Formatting window - formatting; Styles and Formatting window - paint can for applying styles + + Styles and Formatting + /text/scalc/01/05100000.xhp + + + + + + +

+ + Stylist, see Styles and Formatting window + Styles and Formatting window + formats; Styles and Formatting window + formatting; Styles and Formatting window + paint can for applying styles -Styles and Formatting - Use the Styles and Formatting window to assign styles to objects and text sections. You can update Styles, modify existing Styles or create new Styles. -

- The Styles and Formatting dockable window can remain open while editing the document. -

- How to apply a cell style: - - - Select the cell or cell range. - - - Double-click the style in the Styles and Formatting window. - - + + +Styles and Formatting +Use the Styles and Formatting deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles. +

+The Styles and Formatting dockable window can remain open while editing the document. + +

+ +How to apply a cell style: + + + + Select the cell or cell range. + + + Double-click the style in the Styles and Formatting window. + + - -Cell Styles - Displays the list of the available Cell Styles for indirect cell formatting. - - - - -

Icon - - - - Cell Styles - - -

+ +Cell Styles +Displays the list of the available Cell Styles for indirect cell formatting. + + + + +

Icon + + + Cell Styles + + +

- -Page Styles - Displays the Page Styles available for indirect page formatting. - - - - -

Icon - - - - Page Styles - - -

+ +Page Styles +Displays the Page Styles available for indirect page formatting. + + + + +

Icon + + + Page Styles + + +

-Fill Format Mode - Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window. - - - - -

Icon - - - - Fill Format Mode - - -

- - How to apply a new style with the paint can: - - - Select the desired style from the Styles and Formatting window. - - - Click the Fill Format Mode icon. - - - Click a cell to format it, or drag your mouse over a certain range to format the whole range. Repeat this action for other cells and ranges. - - - Click the Fill Format Mode again to exit this mode. - - + +Fill Format Mode +Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window. + + + + +

Icon + + + Fill Format Mode + + +

+ + +How to apply a new style with the paint can: + + + + Select the desired style from the Styles and Formatting window. + + + Click the Fill Format Mode icon. + + + Click a cell to format it, or drag your mouse over a certain range to format the whole range. Repeat this action for other cells and ranges. + + + Click the Fill Format Mode again to exit this mode. + + -New Style from Selection - Creates a new style based on the formatting of a selected object. Assign a name for the style in the Create Style dialog. - - - - -

Icon - - - - New Style from Selection - - -

+ +New Style from Selection +Creates a new style based on the formatting of a selected object. Assign a name for the style in the Create Style dialog. + + + + +

Icon + + + New Style from Selection + + +

-Update Style - Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object. - - - - -

Icon - - - - Update Style - - -

+ +Update Style +Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object. + + + + +

Icon + + + Update Style + + +

-Style List - Displays the list of the styles from the selected style category. - In the context menu you can choose commands to create a new style, delete a user-defined style, or change the selected style. + +Style List +Displays the list of the styles from the selected style category. +In the context menu you can choose commands to create a new style, delete a user-defined style, or change the selected style. -Style GroupsUFI: use "groups" to be consistent with Writer - Lists the available style groups. - + +Style GroupsUFI: use "groups" to be consistent with Writer +Lists the available style groups. + + \ No newline at end of file diff --git a/source/text/scalc/01/07080000.xhp b/source/text/scalc/01/07080000.xhp index 5fb554f2e6..9e0beeae16 100644 --- a/source/text/scalc/01/07080000.xhp +++ b/source/text/scalc/01/07080000.xhp @@ -1,6 +1,5 @@ - - + - +--> + - -Split -/text/scalc/01/07080000.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - + + Split Window + /text/scalc/01/07080000.xhp + + - - -

- -Split - Divides the current window at the top left corner of the active cell. -

+ + +

+ + +Split Window +Divides the current window at the top left corner of the active cell.

- You can also use the mouse to split the window horizontally or vertically. To do this, drag the thick black line located directly above the vertical scrollbar or directly to the right of the horizontal scrollbar into the window. A thick black line will show where the window is split. - A split window has its own scrollbars in each partial section; by contrast, fixed window sections are not scrollable. - - + +

+You can also use the mouse to split the window horizontally or vertically. To do this, drag the thick black line located directly above the vertical scrollbar or directly to the right of the horizontal scrollbar into the window. A thick black line will show where the window is split. +A split window has its own scrollbars in each partial section; by contrast, fixed window sections are not scrollable. + + diff --git a/source/text/scalc/01/07090000.xhp b/source/text/scalc/01/07090000.xhp index 95d85b515a..c5b1c7362d 100644 --- a/source/text/scalc/01/07090000.xhp +++ b/source/text/scalc/01/07090000.xhp @@ -1,6 +1,5 @@ - - + +--> - - -Freeze -/text/scalc/01/07090000.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - + + Freeze Rows and Columns + /text/scalc/01/07090000.xhp + + - - -

- -Freeze - Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable. -

+ + +

+ + +Freeze Rows and Columns +Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable.

- + +

+ + diff --git a/source/text/scalc/guide/line_fix.xhp b/source/text/scalc/guide/line_fix.xhp index 911ac12603..400debbd15 100644 --- a/source/text/scalc/guide/line_fix.xhp +++ b/source/text/scalc/guide/line_fix.xhp @@ -1,6 +1,5 @@ - - + +--> - - -Freezing Rows or Columns as Headers -/text/scalc/guide/line_fix.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - + + Freezing Rows or Columns as Headers + /text/scalc/guide/line_fix.xhp + + -tables; freezing -title rows; freezing during table split -rows; freezing -columns; freezing -freezing rows or columns -headers; freezing during table split -scrolling prevention in tables -windows; splitting -tables; splitting windows + + + tables; freezing + title rows; freezing during table split + rows; freezing + columns; freezing + freezing rows or columns + headers; freezing during table split + scrolling prevention in tables + windows; splitting + tables; splitting windows -Freezing Rows or Columns as Headers - -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. + + +Freezing Rows or Columns as Headers +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. + - -Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen. -To freeze both horizontally and vertically, select the cell that is below the row and to the right of the column that you want to freeze. - - -Choose Window - Freeze. -To deactivate, choose Window - Freeze again. - + + Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen. + To freeze both horizontally and vertically, select the cell that is below the row and to the right of the column that you want to freeze. + + + Choose View - Freeze Rows and Columns. + To deactivate, choose View - Freeze Rows and Columns again. + -If the area defined is to be scrollable, apply the Window - Split command. -If you want to print a certain row on all pages of a document, choose Format - Print ranges - Edit. +If the area defined is to be scrollable, apply the View - Split Window command. +If you want to print a certain row on all pages of a document, choose Format - Print ranges - Edit. +

-Window - Freeze -Window - Split +View - Freeze Rows and Columns +View - Split Window

-Format - Print ranges - Edit +Format - Print ranges - Edit

+ diff --git a/source/text/scalc/main0103.xhp b/source/text/scalc/main0103.xhp index 268f9570f8..8cdf445f09 100644 --- a/source/text/scalc/main0103.xhp +++ b/source/text/scalc/main0103.xhp @@ -1,6 +1,5 @@ - - - +--> + - -View -/text/scalc/main0103.xhp - + + View + /text/scalc/main0103.xhp + + + +

-View -This menu contains commands for controlling the on-screen display of the document. + +View +This menu contains commands for controlling the on-screen display of the document.

- -Normal -Displays the normal view of the sheet. -

+ +Normal +Displays the normal layout view of the sheet. + +Page Break +

+ +Grid Lines for Sheet +Toggle the visibility of grid lines for the current sheet. +

+ +Clip Art Gallery +

-Zoom -

+ + +

+ +Zoom +

+ diff --git a/source/text/scalc/main0104.xhp b/source/text/scalc/main0104.xhp index e1584d9008..96a0e56267 100644 --- a/source/text/scalc/main0104.xhp +++ b/source/text/scalc/main0104.xhp @@ -55,9 +55,6 @@ Function

- -Function List -

Comment @@ -74,4 +71,4 @@

- \ No newline at end of file + diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp index ece20c3207..c09666849e 100644 --- a/source/text/scalc/main0105.xhp +++ b/source/text/scalc/main0105.xhp @@ -1,6 +1,5 @@ - - + - - +--> + - -Format -/text/scalc/main0105.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - + + Format + /text/scalc/main0105.xhp + + + +

- -Format -The Format menu contains commands for formatting selected cells, objects, and cell contents in your document. + +Format +The Format menu contains commands for formatting selected cells, objects, and cell contents in your document.

-Cells + +Cells

-Page + +Page

-Character + +Character

-Paragraph + +Paragraph

-AutoFormat + +AutoFormat

-Conditional Formatting + +Conditional Formatting

@@ -64,9 +66,12 @@

-Control + +Control

-Form + +Form

+ diff --git a/source/text/scalc/main0107.xhp b/source/text/scalc/main0107.xhp index aed8939430..7ae0f944a9 100644 --- a/source/text/scalc/main0107.xhp +++ b/source/text/scalc/main0107.xhp @@ -1,7 +1,5 @@ - - - + +--> - - - -Window -/text/scalc/main0107.xhp - + + Window + /text/scalc/main0107.xhp + + + +

-Window -Contains commands for manipulating and displaying document windows. + + +Window +Contains commands for manipulating and displaying document windows.

- + + \ No newline at end of file -- cgit