diff options
| author | Kurt Zenker <kz@openoffice.org> | 2008-03-07 11:14:04 +0000 |
|---|---|---|
| committer | Kurt Zenker <kz@openoffice.org> | 2008-03-07 11:14:04 +0000 |
| commit | 89152a5ca8ce5a39ba7e33b90eb159d4c6bc9845 (patch) | |
| tree | a8587951a7876fb5bf9f168d6e018db9220b768b | |
| parent | 132c9c16bed265ac27580a22f0964179f4a335ba (diff) | |
INTEGRATION: CWS hcshared17_DEV300 (1.6.160); FILE MERGED
2008/02/22 09:23:20 ufi 1.6.160.1: vor resync
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp | 89 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/guide/design.xhp | 77 |
2 files changed, 86 insertions, 80 deletions
diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp index 6749f0fb2e..f147ceaff3 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp @@ -1,14 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> + <!-- *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: cellstyle_by_formula.xhp,v $ + * $RCSfile: cellstyle_by_formula.xhp,v $fileonly,v $ * - * $Revision: 1.6 $ + * $Revision: 1.7 $ * - * last change: $Author: ihi $ $Date: 2006-06-29 09:50:37 $ + * last change: $Author: kz $ $Date: 2008-03-07 12:13:35 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -35,56 +36,58 @@ * ************************************************************************ --> - -<helpdocument version="1.0"> + + + <helpdocument version="1.0"> <meta> <topic id="textscalcguidecellstyle_by_formulaxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Assigning Formats by Formula</title> +<title xml-lang="en-US" id="tit">Assigning Formats by Formula</title> <filename>/text/scalc/guide/cellstyle_by_formula.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-05-15T16:31:14">converted from old format - fpe</lastedited> -</history> </meta> <body> + + + <bookmark xml-lang="en-US" branch="index" id="bm_id3145673"><bookmark_value>formats; assigning by formulas</bookmark_value> <bookmark_value>cell formats; assigning by formulas</bookmark_value> <bookmark_value>STYLE function example</bookmark_value> <bookmark_value>cell styles;assigning by formulas</bookmark_value> <bookmark_value>formulas;assigning cell formats</bookmark_value> -<bookmark_value>applying;cell formats</bookmark_value> -</bookmark><comment>mw added "applying;"</comment> -<paragraph role="heading" id="hd_id3145673" xml-lang="en-US" level="1" l10n="U" oldref="13"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp" name="Assigning Formats by Formula">Assigning Formats by Formula</link> +</bookmark> + <comment>mw deleted "applying;"</comment> + <paragraph xml-lang="en-US" id="hd_id3145673" role="heading" level="1" l10n="U" oldref="13"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp" name="Assigning Formats by Formula">Assigning Formats by Formula</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3150275" xml-lang="en-US" l10n="CHG" oldref="14">The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied.</paragraph> -<paragraph role="paragraph" id="par_id3151385" xml-lang="en-US" l10n="U" oldref="15">If you would like to apply a formula to all cells in a selected area, you can use the<emph> Find & Replace</emph> dialog.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3149456" xml-lang="en-US" l10n="U" oldref="16">Select all the desired cells.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3148797" xml-lang="en-US" l10n="U" oldref="17">Select the menu command <emph>Edit - Find & Replace</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="18">For the <emph>Search for</emph> term, enter: .*</paragraph> -<paragraph role="listitem" id="par_id3153770" xml-lang="en-US" l10n="U" oldref="19">".*" is a regular expression that designates the contents of the current cell.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3153143" xml-lang="en-US" l10n="U" oldref="20">Enter the following formula in the <emph>Replace with</emph> field: =&+STYLE(IF(CURRENT()>3;"Red";"Green"))</paragraph> -<paragraph role="listitem" id="par_id3146975" xml-lang="en-US" l10n="U" oldref="21">The "&" symbol designates the current contents of the <emph>Search for</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3149262" xml-lang="en-US" l10n="U" oldref="22">Mark the fields <link href="text/shared/01/02100000.xhp" name="Regular expressions"><emph>Regular expressions</emph></link> and <emph>Current selection only</emph>. Click <emph>Find All</emph>.</paragraph> -<paragraph role="listitem" id="par_id3144767" xml-lang="en-US" l10n="U" oldref="24">All cells with contents that were included in the selection are now highlighted.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3147127" xml-lang="en-US" l10n="U" oldref="23">Click<emph> Replace all</emph>.</paragraph> -</listitem> -</list> -<section id="relatedtopics"> -<embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> -<embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> -</section> -</body> + <paragraph xml-lang="en-US" id="par_id3150275" role="paragraph" l10n="CHG" oldref="14">The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied.</paragraph> + <paragraph xml-lang="en-US" id="par_id3151385" role="paragraph" l10n="U" oldref="15">If you would like to apply a formula to all cells in a selected area, you can use the<emph> Find & Replace</emph> dialog.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149456" role="listitem" l10n="U" oldref="16">Select all the desired cells.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3148797" role="listitem" l10n="U" oldref="17">Select the menu command <emph>Edit - Find & Replace</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3150767" role="listitem" l10n="U" oldref="18">For the <emph>Search for</emph> term, enter: .*</paragraph> + <paragraph xml-lang="en-US" id="par_id3153770" role="listitem" l10n="U" oldref="19">".*" is a regular expression that designates the contents of the current cell.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3153143" role="listitem" l10n="U" oldref="20">Enter the following formula in the <emph>Replace with</emph> field: =&+STYLE(IF(CURRENT()>3;"Red";"Green"))</paragraph> + <paragraph xml-lang="en-US" id="par_id3146975" role="listitem" l10n="U" oldref="21">The "&" symbol designates the current contents of the <emph>Search for</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149262" role="listitem" l10n="U" oldref="22">Mark the fields <link href="text/shared/01/02100000.xhp" name="Regular expressions"><emph>Regular expressions</emph></link> and <emph>Current selection only</emph>. Click <emph>Find All</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3144767" role="listitem" l10n="U" oldref="24">All cells with contents that were included in the selection are now highlighted.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3147127" role="listitem" l10n="U" oldref="23">Click<emph> Replace all</emph>.</paragraph> + </listitem> + </list> + <section id="relatedtopics"> + + <embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> + <embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> + + </section> + </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/guide/design.xhp b/helpcontent2/source/text/scalc/guide/design.xhp index 23f1077236..4788804857 100644 --- a/helpcontent2/source/text/scalc/guide/design.xhp +++ b/helpcontent2/source/text/scalc/guide/design.xhp @@ -1,14 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> + <!-- *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: design.xhp,v $ + * $RCSfile: design.xhp,v $fileonly,v $ * - * $Revision: 1.6 $ + * $Revision: 1.7 $ * - * last change: $Author: ihi $ $Date: 2006-06-29 09:52:13 $ + * last change: $Author: kz $ $Date: 2008-03-07 12:14:04 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -35,52 +36,54 @@ * ************************************************************************ --> - -<helpdocument version="1.0"> + + + <helpdocument version="1.0"> <meta> <topic id="textscalcguidedesignxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Selecting Themes for Sheets</title> +<title xml-lang="en-US" id="tit">Selecting Themes for Sheets</title> <filename>/text/scalc/guide/design.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-03-07T11:21:24">converted from old format - fpe</lastedited> -</history> </meta> <body> + + + <bookmark xml-lang="en-US" branch="index" id="bm_id3150791"><bookmark_value>theme selection for sheets</bookmark_value> <bookmark_value>layout;spreadsheets</bookmark_value> <bookmark_value>cell styles; selecting</bookmark_value> <bookmark_value>selecting;formatting themes</bookmark_value> -<bookmark_value>applying;formatting themes</bookmark_value> <bookmark_value>sheets;formatting themes</bookmark_value> <bookmark_value>formats;themes for sheets</bookmark_value> <bookmark_value>formatting;themes for sheets</bookmark_value> -</bookmark><comment>mw made "layout..." a two level entry</comment> -<paragraph role="heading" id="hd_id3150791" xml-lang="en-US" level="1" l10n="U" oldref="6"><variable id="design"><link href="text/scalc/guide/design.xhp" name="Selecting Themes for Sheets">Selecting Themes for Sheets</link> +</bookmark> + <comment>mw deleted "applying;"</comment> + <paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1" l10n="U" oldref="6"><variable id="design"><link href="text/scalc/guide/design.xhp" name="Selecting Themes for Sheets">Selecting Themes for Sheets</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US" l10n="U" oldref="13">$[officename] Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets.</paragraph> -<paragraph role="paragraph" id="par_id3154490" xml-lang="en-US" l10n="U" oldref="16">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.</paragraph> -<paragraph role="paragraph" id="par_id3154757" xml-lang="en-US" l10n="U" oldref="17">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 <emph>Theme Selection</emph> dialog.</paragraph> -<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U" oldref="18">To apply a custom cell style to a cell, you can open the Styles and Formatting 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 and Formatting window to apply this style to the selected cells.</paragraph> -<paragraph role="paragraph" id="par_id3153963" xml-lang="en-US" l10n="U" oldref="19">To apply a theme to a spreadsheet:</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3146920" xml-lang="en-US" l10n="CHG" oldref="15">Click the <emph>Choose Themes</emph> icon in the <emph>Tools</emph> bar. </paragraph> -<embed href="text/scalc/02/06080000.xhp#sythemen"/> -<paragraph role="listitem" id="par_id3148488" xml-lang="en-US" l10n="CHG" oldref="20">The <emph>Theme Selection</emph> dialog appears. This dialog lists the available themes for the whole spreadsheet and the Styles and Formatting window lists the custom styles for specific cells.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3155114" xml-lang="en-US" l10n="U" oldref="9">In the <emph>Theme Selection </emph>dialog, select the theme that you want to apply to the spreadsheet.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3150090" xml-lang="en-US" l10n="U" oldref="21">Click OK</paragraph> -<paragraph role="listitem" id="par_id3150201" xml-lang="en-US" l10n="U" oldref="22">As soon as you select another theme in the <emph>Theme Selection</emph> 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.</paragraph> -</listitem> -</list> -<section id="relatedtopics"> -<embed href="text/scalc/guide/autoformat.xhp#autoformat"/> -<paragraph role="paragraph" id="par_id3146979" xml-lang="en-US" l10n="U" oldref="12"><link href="text/scalc/02/06080000.xhp" name="Theme selection">Theme selection</link></paragraph> -</section> -</body> + <paragraph xml-lang="en-US" id="par_id3145786" role="paragraph" l10n="U" oldref="13">$[officename] Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154490" role="paragraph" l10n="U" oldref="16">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.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154757" role="paragraph" l10n="U" oldref="17">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 <emph>Theme Selection</emph> dialog.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156382" role="paragraph" l10n="U" oldref="18">To apply a custom cell style to a cell, you can open the Styles and Formatting 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 and Formatting window to apply this style to the selected cells.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153963" role="paragraph" l10n="U" oldref="19">To apply a theme to a spreadsheet:</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3146920" role="listitem" l10n="CHG" oldref="15">Click the <emph>Choose Themes</emph> icon in the <emph>Tools</emph> bar. </paragraph> + <embed href="text/scalc/02/06080000.xhp#sythemen"/> + <paragraph xml-lang="en-US" id="par_id3148488" role="listitem" l10n="CHG" oldref="20">The <emph>Theme Selection</emph> dialog appears. This dialog lists the available themes for the whole spreadsheet and the Styles and Formatting window lists the custom styles for specific cells.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155114" role="listitem" l10n="U" oldref="9">In the <emph>Theme Selection </emph>dialog, select the theme that you want to apply to the spreadsheet.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3150090" role="listitem" l10n="U" oldref="21">Click OK</paragraph> + <paragraph xml-lang="en-US" id="par_id3150201" role="listitem" l10n="U" oldref="22">As soon as you select another theme in the <emph>Theme Selection</emph> 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.</paragraph> + </listitem> + </list> + <section id="relatedtopics"> + + <embed href="text/scalc/guide/autoformat.xhp#autoformat"/> + <paragraph xml-lang="en-US" id="par_id3146979" role="paragraph" l10n="U" oldref="12"><link href="text/scalc/02/06080000.xhp" name="Theme selection">Theme selection</link></paragraph> + + </section> + </body> </helpdocument> |