- Choose Format - Conditional - Condition. + Choose Format - Conditional - Condition. On the Formatting bar, click -

Icon Conditional Format - Condition +

Icon Conditional Format - Condition - Conditional Format + Conditional Format

@@ -86,11 +86,11 @@ -

Icon Color Scale +

Icon Color Scale - Color Scale + Color Scale @@ -103,11 +103,11 @@ -

Icon Data Bar +

Icon Data Bar - Data Bar + Data Bar @@ -120,11 +120,11 @@ -

Icon Icon Set +

Icon Icon Set - Icon Set + Icon Set @@ -137,11 +137,11 @@ -

Icon Date +

Icon Date - Date + Date @@ -150,23 +150,5 @@

Choose Format - Conditional - Manage

- -

-Choose Format - AutoFormat Styles. - On the Tools bar, click -

- - - - -

AutoFormat Styles Icon - - -AutoFormat - - -

diff --git a/source/text/scalc/01/05110000.xhp b/source/text/scalc/01/05110000.xhp deleted file mode 100644 index 074b7f2c2a..0000000000 --- a/source/text/scalc/01/05110000.xhp +++ /dev/null @@ -1,78 +0,0 @@ - - - - - - - AutoFormat - /text/scalc/01/05110000.xhp - - - - - - - -

AutoFormat

- Use this command to apply an AutoFormat to a selected sheet area or to define your own AutoFormats. -

- The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu. - -

Format

-Choose a predefined AutoFormat to apply to a selected area in your sheet. -

- -

Add

-Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats. The Add AutoFormat dialog then appears. - -Enter a name and click OK. -

- -

Rename

-Opens a dialog where you can change the name of the selected AutoFormat. - -The Rename AutoFormat dialog opens. Enter the new name of the AutoFormat here. - -

Formatting

-In this section you can select or deselect the available formatting options. If you want to keep any of the settings currently in your spreadsheet, deselect the corresponding option. - -

Number format

-When marked, specifies that you want to retain the number format of the selected format. - -

Borders

-When marked, specifies that you want to retain the border of the selected format. - -

Font

-When marked, specifies that you want to retain the font of the selected format. - -

Pattern

-When marked, specifies that you want to retain the pattern of the selected format. - -

Alignment

-When marked, specifies that you want to retain the alignment of the selected format. - -

AutoFit width and height

-When marked, specifies that you want to retain the width and height of the selected cells of the selected format. -

- - diff --git a/source/text/shared/00/00040503.xhp b/source/text/shared/00/00040503.xhp index 46cf148428..9d246936ed 100644 --- a/source/text/shared/00/00040503.xhp +++ b/source/text/shared/00/00040503.xhp @@ -30,6 +30,37 @@ This listing is split over the files 00040500, 00040501, 00040502 and 00040503.

Format Menu

+ + +

+ Choose Table - AutoFormat Styles. +

+ Choose Table - Table Styles. +

+ Open the Styles panel (F11), choose Table styles, double click a style. + + +

+ Choose Format - AutoFormat Styles. +

+ Choose Layout - Table Styles. + + +

+ + + +

AutoFormat Styles Icon + + + AutoFormat + + +

Choose Format - Rows - Height. Open context menu of a row header in an open database table - choose Row Height. diff --git a/source/text/shared/01/AutoFormat.xhp b/source/text/shared/01/AutoFormat.xhp new file mode 100644 index 0000000000..5d1ccdbb81 --- /dev/null +++ b/source/text/shared/01/AutoFormat.xhp @@ -0,0 +1,160 @@ + + + + + + + AutoFormat + /text/shared/01/AutoFormat.xhp + + + + + + + + + + + + + +tables;AutoFormat function +sheet table;AutoFormat function +styles;table styles +AutoFormat function for tables + + +

AutoFormat Styles

+ Use this command to apply an AutoFormat to a selected sheet areatable area or to define your own AutoFormats. +

+ +

+ + + + The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu. + + + + + +

Format

+ + + Choose a predefined AutoFormat to apply to the table. + + + Choose a predefined AutoFormat to apply to a selected area in your sheet. + + + +

+ + + +

Add

+ + + Adds a new table style to the list. + + + Format a table in your document. + + + Select the table, and then choose Table - AutoFormat Styles. + + + Click Add. + + + In the Add AutoFormat dialog, enter a name, and then click OK. + + + + Enter a name for the new AutoFormat, and then click OK. + + + Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats. The Add AutoFormat dialog then appears. + + Enter a name and click OK. + + + +

Delete

+Deletes the selected style. You cannot delete the default style. + + +

Rename

+Opens a dialog where you can change the name of the selected AutoFormat. + + +The Rename AutoFormat dialog opens. Enter the new name of the AutoFormat here. + +

Formatting

+Lists the available formatting styles for tables. Click the format that you want to apply, and then click OK. + + + +

Number format

+Includes numbering formats in the selected style. + + + +

Borders

+Includes border styles in the selected style. + + + +

Font

+Includes font formatting in the selected style. + + + +

Pattern

+Includes background styles in the selected style. + + + +

Alignment

+Includes alignment settings in the selected style. + + + + +

AutoFit width and height

+ When marked, specifies that you want to retain the width and height of the selected cells of the selected format. + + + +

+ + +

+ + diff --git a/source/text/shared/01/Protect.xhp b/source/text/shared/01/Protect.xhp index d58232c169..c479ee1373 100644 --- a/source/text/shared/01/Protect.xhp +++ b/source/text/shared/01/Protect.xhp @@ -133,5 +133,12 @@ +

+ + +

diff --git a/source/text/swriter/01/05150101.xhp b/source/text/swriter/01/05150101.xhp deleted file mode 100644 index 717c091fc5..0000000000 --- a/source/text/swriter/01/05150101.xhp +++ /dev/null @@ -1,103 +0,0 @@ - - - - - - - - -AutoFormat for Tables -/text/swriter/01/05150101.xhp - - - - - - -tables;AutoFormat function - styles;table styles - AutoFormat function for tables - -

AutoFormat for Tables

- Automatically applies formats to the current table, including fonts, shading, and borders. - -

Applying an AutoFormat to a Table

- - - Click in a table cell, or select the cells that you want to format. - - - Choose Table - AutoFormat Styles, and then click the format that you to want to apply. - - - Click OK. - - - -

Format

- Lists the available formatting styles for tables. Click the format that you want to apply, and then click OK. - -

Add

- Adds a new table style to the list. - - - Format a table in your document. - - - Select the table, and then choose Table - AutoFormat Styles. - - - Click Add. - - - In the Add AutoFormat dialog, enter a name, and then click OK. - - - - - Enter a name for the new AutoFormat, and then click OK. - - -

Delete

- Deletes the selected table style. You cannot delete "Default Table Style". -

Rename

- Changes the name of the selected table style. You cannot rename "Default Table Style". -

Formatting

- Select the formatting attributes to include in the selected table style. - -

Number format

- Includes numbering formats in the selected table style. - -

Font

- Includes font formatting in the selected table style. - -

Alignment

- Includes alignment settings in the selected table style. - -

Borders

- Includes border styles in the selected table style. - -

Pattern

- Includes background styles in the selected table style. - - - diff --git a/source/text/swriter/main0110.xhp b/source/text/swriter/main0110.xhp index bb9a9fc9b4..476e5924ce 100644 --- a/source/text/swriter/main0110.xhp +++ b/source/text/swriter/main0110.xhp @@ -54,8 +54,7 @@

AutoFormat Styles

Number Format

Opens a dialog where you can specify the format of numbers in the table. -- cgit