--- source/text/scalc/00/00000405.xhp | 28 ++++++++++++++++ source/text/scalc/01/05120000.xhp | 49 +++++++++++++++------------- source/text/scalc/01/FormatSparklineMenu.xhp | 48 +++++++++++++++++++++++++++ source/text/scalc/02/06080000.xhp | 29 ++++------------ source/text/scalc/guide/design.xhp | 45 ++++++++++--------------- source/text/scalc/main0105.xhp | 10 +++--- source/text/shared/01/themesdialog.xhp | 3 +- source/text/swriter/01/format_object.xhp | 2 +- 8 files changed, 136 insertions(+), 78 deletions(-) create mode 100644 source/text/scalc/01/FormatSparklineMenu.xhp (limited to 'source') diff --git a/source/text/scalc/00/00000405.xhp b/source/text/scalc/00/00000405.xhp index 197c0f8984..4d0bce96ba 100644 --- a/source/text/scalc/00/00000405.xhp +++ b/source/text/scalc/00/00000405.xhp @@ -29,6 +29,34 @@

Format Menu

+ Choose Format - Sparklines. +

+ In a cell with sparklines, choose Sparklines. +

+ On the Data menu of the Data tab, choose Sparklines. +

+ Choose Format - Spreadsheet Themes. +

+ Choose Layout - Spreadsheet Themes. +

+ + + + +

Icon Themes + + + Choose Themes + + +

Choose Format - Number Format. diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp index 4e41c6dc61..2a8940be32 100644 --- a/source/text/scalc/01/05120000.xhp +++ b/source/text/scalc/01/05120000.xhp @@ -21,18 +21,21 @@ - Conditional Formatting + Conditional Formatting /text/scalc/01/05120000.xhp - - - - -

Conditional Formatting

- Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents. The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar. - You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format. + + + + +

Conditional Formatting

+ Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents. +

+ The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar. + You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format. Conditional formats do not overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats. To apply conditional formatting, AutoCalculate must be enabled. Choose Data - Calculate - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). @@ -41,30 +44,30 @@

Range

- Defines the range of cells concerned by the conditional formatting. Click on the Shrink button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected. + Defines the range of cells concerned by the conditional formatting. Click on the Shrink button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected. - conditional formatting; conditions + conditional formatting; conditions - + - +

Condition list

- List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want. - + List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want. +

Up

- Increase priority of the selected condition. + Increase priority of the selected condition.

Down

- - Decrease priority of the selected condition. - + + Decrease priority of the selected condition. +

Add

Adds the condition to the condition list. - +

Delete

Deletes the condition from the condition list. - +

Condition list entries

- Specify if conditional formatting is dependent on one of the entry listed on the drop down box. + Specify if conditional formatting is dependent on one of the entry listed on the drop down box.

@@ -73,12 +76,12 @@

- +

Apply Style

Select the cell style to apply when the condition is verified. Select New Style to open the Cell Style dialog and define the style properties.

- +

diff --git a/source/text/scalc/01/FormatSparklineMenu.xhp b/source/text/scalc/01/FormatSparklineMenu.xhp new file mode 100644 index 0000000000..d0708000d8 --- /dev/null +++ b/source/text/scalc/01/FormatSparklineMenu.xhp @@ -0,0 +1,48 @@ + + + + + + + FormatSparklineMenu + /text/scalc/01/FormatSparklineMenu.xhp + + + + +

Sparkline

+ Opens a menu for sparklines formatting. +

+ +

Delete Sparkline

+ Deletes the sparkline of the current cell, if any. + +

Delete Sparkline Group

+ Deletes all sparklines of the group at the current cell or selection. + +

Edit Sparkline Group

+ Edits the properties of the sparkline group. The properties applies to all sparklines in the group. + +

Edit Sparkline

+ Edits the properties of the sparkline at the current cell, if any. + +

Group Sparklines

+ Creates a group for all sparklines selected. + +

Ungroup Sparklines

+ Ungroup the sparkines previously grouped. + + + diff --git a/source/text/scalc/02/06080000.xhp b/source/text/scalc/02/06080000.xhp index 1c088e6818..e9d5f19c67 100644 --- a/source/text/scalc/02/06080000.xhp +++ b/source/text/scalc/02/06080000.xhp @@ -1,6 +1,4 @@ - - - -Theme Selection +Theme Selection /text/scalc/02/06080000.xhp @@ -30,27 +27,15 @@ - +

Theme Selection

-Applies a formatting style to the selected cells. +Applies a formatting style to the selected cells. The styles include font, border, and background color information. -

- - - - -

Icon - - - -Choose Themes - - -

- +

- -Click the formatting theme that you want to apply, and then click OK. + +Click the formatting theme that you want to apply, and then click OK.

diff --git a/source/text/scalc/guide/design.xhp b/source/text/scalc/guide/design.xhp index 912d397a38..402e61ba34 100644 --- a/source/text/scalc/guide/design.xhp +++ b/source/text/scalc/guide/design.xhp @@ -1,7 +1,4 @@ - - - - - - + -Selecting Themes for Sheets +Selecting Themes for Sheets /text/scalc/guide/design.xhp - - - -theme selection for sheets +theme selection for sheets layout;spreadsheets cell styles; selecting selecting;formatting themes @@ -41,32 +33,31 @@ formatting;themes for sheets mw deleted "applying;" - Selecting Themes for Sheets - - $[officename] Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets. - It is not possible to add themes to Calc, and they cannot be modified. However, you can modify their styles after you apply them to a spreadsheet. - Before you format a sheet with a theme, you have to apply at least one custom cell style to the cells on the sheet. You can then change the cell formatting by selecting and applying a theme in the Theme Selection dialog. - To apply a custom cell style to a cell, you can open the Styles window and, in its lower list box, set the Custom Styles view. A list of the existing custom defined cell styles will be displayed. Double click a name from the Styles window to apply this style to the selected cells. - To apply a theme to a spreadsheet: +

Selecting Themes for Sheets +

+ $[officename] Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets. + It is not possible to add themes to Calc, and they cannot be modified. However, you can modify their styles after you apply them to a spreadsheet. + Before you format a sheet with a theme, you have to apply at least one custom cell style to the cells on the sheet. You can then change the cell formatting by selecting and applying a theme in the Theme Selection dialog. + To apply a custom cell style to a cell, you can open the Styles window and, in its lower list box, set the Custom Styles view. A list of the existing custom defined cell styles will be displayed. Double click a name from the Styles window to apply this style to the selected cells. + To apply a theme to a spreadsheet: - Click the Choose Themes icon in the Tools bar. -

- The Theme Selection dialog appears. This dialog lists the available themes for the whole spreadsheet and the Styles window lists the custom styles for specific cells. + Click the Choose Themes icon in the Tools bar. +

+ The Theme Selection dialog appears. This dialog lists the available themes for the whole spreadsheet and the Styles window lists the custom styles for specific cells. - In the Theme Selection dialog, select the theme that you want to apply to the spreadsheet. + In the Theme Selection dialog, select the theme that you want to apply to the spreadsheet. - Click OK - As soon as you select another theme in the Theme Selection dialog, some of the properties of the custom style will be applied to the current spreadsheet. The modifications will be immediately visible in your spreadsheet. + Click OK + As soon as you select another theme in the Theme Selection dialog, some of the properties of the custom style will be applied to the current spreadsheet. The modifications will be immediately visible in your spreadsheet.

- Theme selection - + Theme selection +

diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp index f37dfd6e4c..25355bff21 100644 --- a/source/text/scalc/main0105.xhp +++ b/source/text/scalc/main0105.xhp @@ -45,12 +45,14 @@

Conditional Formatting

AutoFormat

diff --git a/source/text/shared/01/themesdialog.xhp b/source/text/shared/01/themesdialog.xhp index a94edbc9a5..c374955425 100644 --- a/source/text/shared/01/themesdialog.xhp +++ b/source/text/shared/01/themesdialog.xhp @@ -15,9 +15,10 @@ + - + document themes;choosing applying document themes diff --git a/source/text/swriter/01/format_object.xhp b/source/text/swriter/01/format_object.xhp index 22320fa4be..2af76e8423 100644 --- a/source/text/swriter/01/format_object.xhp +++ b/source/text/swriter/01/format_object.xhp @@ -27,9 +27,9 @@ -

Text Box and Shape

Opens a submenu to edit the properties of the selected textbox or shape.

-- cgit