diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/02120100.xhp | 10 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/02140500.xhp | 21 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060109.xhp | 12 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/05020600.xhp | 6 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/05120000.xhp | 12 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/06060100.xhp | 10 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/06070000.xhp | 8 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/06080000.xhp | 17 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/12120300.xhp | 6 |
9 files changed, 48 insertions, 54 deletions
diff --git a/helpcontent2/source/text/scalc/01/02120100.xhp b/helpcontent2/source/text/scalc/01/02120100.xhp index de354371ca..4aaf30bc72 100644 --- a/helpcontent2/source/text/scalc/01/02120100.xhp +++ b/helpcontent2/source/text/scalc/01/02120100.xhp @@ -1,11 +1,11 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -29,8 +29,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalc0102120100xml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Header/Footer</title> @@ -69,7 +69,7 @@ <bookmark xml-lang="en-US" branch="hid/HID_SC_HF_FRC" id="bm_id3145273" localize="false"/> <bookmark xml-lang="en-US" branch="hid/HID_SC_HF_FLC" id="bm_id3153951" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3148648" role="heading" level="2" l10n="U" oldref="5">Center Area</paragraph> - <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph" l10n="U" oldref="6"><ahelp hid="HID_SC_HF_FLC">Enter the text to be displayed at the center of the header or footer</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph" l10n="CHG" oldref="6"><ahelp hid=".">Enter the text to be displayed at the center of the header or footer.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_SC_HF_HRR" id="bm_id3153159" localize="false"/> <bookmark xml-lang="en-US" branch="hid/HID_SC_HF_HLR" id="bm_id3149413" localize="false"/> <bookmark xml-lang="en-US" branch="hid/HID_SC_HF_FRR" id="bm_id3148457" localize="false"/> diff --git a/helpcontent2/source/text/scalc/01/02140500.xhp b/helpcontent2/source/text/scalc/01/02140500.xhp index dac51ddbe1..33a41f5243 100644 --- a/helpcontent2/source/text/scalc/01/02140500.xhp +++ b/helpcontent2/source/text/scalc/01/02140500.xhp @@ -4,7 +4,7 @@ <!--*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -26,34 +26,31 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> +<helpdocument version="1.0"> <meta> <topic id="textscalc0102140500xml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Fill Sheet</title> <filename>/text/scalc/01/02140500.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> -</history> </meta> <body> - - + + <bookmark xml-lang="en-US" branch="hid/FID_FILL_TAB" id="bm_id3912388" localize="false"/><!-- HID added by script --> <bookmark branch="hid/.uno:FillTable" xml-lang="en-US" id="bm_id3148664"/><paragraph role="heading" level="1" id="hd_id3153897" l10n="U" xml-lang="en-US" oldref="1">Fill Sheet</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3150791" xml-lang="en-US" oldref="2"><variable id="tabellenfuellentext"><ahelp hid=".uno:FillTable" visibility="visible">Specifies the options for transferring spreadsheets or ranges of a certain spreadsheet.</ahelp></variable></paragraph> + <paragraph l10n="CHG" role="paragraph" id="par_id3150791" xml-lang="en-US" oldref="2"><variable id="tabellenfuellentext"><ahelp hid=".uno:FillTable" visibility="visible">Specifies the options for transferring sheets or ranges of a certain sheet.</ahelp></variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000402.xhp#baustab"/> </section> <paragraph xml-lang="en-US" role="paragraph" id="par_id3150767" l10n="U" oldref="3">In contrast to copying an area to the clipboard, you can filter certain information and calculate values. This command is only visible if you have selected two sheets in the document. To select multiple sheets, click each sheet tab while pressing <switchinline select="sys"> <caseinline select="MAC">Command</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> or Shift.</paragraph> - <paragraph role="heading" level="2" id="hd_id3155131" l10n="U" xml-lang="en-US" oldref="4">Filling a Spreadsheet</paragraph> + <paragraph role="heading" level="2" id="hd_id3155131" l10n="CHG" xml-lang="en-US" oldref="4">Filling a Sheet</paragraph> <list type="unordered"> <listitem> - <paragraph role="listitem" id="par_id3146119" l10n="U" xml-lang="en-US" oldref="5">Select the entire sheet by clicking the empty gray box in the upper left of the spreadsheet. You can also select an area of the sheet to be copied.</paragraph> + <paragraph role="listitem" id="par_id3146119" l10n="CHG" xml-lang="en-US" oldref="5">Select the entire sheet by clicking the empty gray box in the upper left of the sheet. You can also select an area of the sheet to be copied.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" role="listitem" id="par_id3153726" l10n="U" oldref="6">Press <switchinline select="sys"> <caseinline select="MAC">Command</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> and click the tab of the worksheet where you want to insert the contents.</paragraph> + <paragraph xml-lang="en-US" role="listitem" id="par_id3153726" l10n="U" oldref="6">Press <switchinline select="sys"> <caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> and click the tab of the sheet where you want to insert the contents.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" oldref="7" l10n="U" role="listitem" id="par_id3147436">Select the command <emph>Edit - Fill - Sheet</emph>. In the dialog which appears, the check box <emph>Numbers</emph> must be selected (or <emph>Paste All</emph>) if you want to combine operations with the values. You can also choose the desired operation here.</paragraph> diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index a09582435d..c7b3bc4227 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.xhp @@ -1,11 +1,11 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -29,8 +29,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalc0104060109xml" indexer="include"> <title xml-lang="en-US" id="tit">Spreadsheet Functions</title> @@ -43,7 +43,7 @@ <bookmark_value>functions; spreadsheets</bookmark_value> </bookmark> <paragraph xml-lang="en-US" id="hd_id3148522" role="heading" level="1" l10n="U" oldref="1">Spreadsheet Functions</paragraph> - <paragraph xml-lang="en-US" id="par_id3144508" role="paragraph" l10n="U" oldref="2"><variable id="tabelletext">This section contains descriptions of the <emph>Spreadsheet</emph> functions together with an example. + <paragraph xml-lang="en-US" id="par_id3144508" role="paragraph" l10n="U" oldref="2"><variable id="tabelletext">This section contains descriptions of the <emph>Spreadsheet</emph> functions together with an example. </variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000404.xhp#efefft"/> @@ -406,7 +406,7 @@ <emph>Height</emph> (optional) is the vertical height for an area that starts at the new reference position.</paragraph> <paragraph xml-lang="en-US" id="par_id3147278" role="paragraph" l10n="CHG" oldref="119"> <emph>Width</emph> (optional) is the horizontal width for an area that starts at the new reference position.</paragraph> - <paragraph xml-lang="en-US" id="par_id8662373" role="paragraph" l10n="NEW">Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column</paragraph> + <paragraph xml-lang="en-US" id="par_id8662373" role="paragraph" l10n="CHG">Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column.</paragraph> <paragraph xml-lang="en-US" id="par_id9051484" role="paragraph" l10n="NEW">Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns.</paragraph> <paragraph xml-lang="en-US" id="par_idN1104B" role="paragraph" l10n="NEW"> <embedvar href="text/scalc/00/00000004.xhp#optional"/> diff --git a/helpcontent2/source/text/scalc/01/05020600.xhp b/helpcontent2/source/text/scalc/01/05020600.xhp index 9a98fa1201..313a0d4cc6 100644 --- a/helpcontent2/source/text/scalc/01/05020600.xhp +++ b/helpcontent2/source/text/scalc/01/05020600.xhp @@ -4,7 +4,7 @@ <!--*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -27,7 +27,7 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0105020600xml" indexer="include" status="PUBLISH"> @@ -55,7 +55,7 @@ <bookmark xml-lang="en-US" branch="hid/sc:TriStateBox:RID_SCPAGE_PROTECTION:BTN_PROTECTED" id="bm_id3149260" localize="false"/> <paragraph role="heading" id="hd_id3153190" xml-lang="en-US" level="3" l10n="U" oldref="5">Protected</paragraph> <paragraph role="paragraph" id="par_id3151119" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_PROTECTED">Prevents the selected cells from being modified.</ahelp></paragraph> -<paragraph role="note" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="15">This cell protection only takes effect if you also protect the spreadsheet (<emph>Tools - Protect Document - Sheet</emph>).</paragraph> +<paragraph role="note" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="15">This cell protection only takes effect if you also protect the sheet (<emph>Tools - Protect Document - Sheet</emph>).</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:TriStateBox:RID_SCPAGE_PROTECTION:BTN_HIDE_FORMULAR" id="bm_id3149958" localize="false"/> <paragraph role="heading" id="hd_id3149377" xml-lang="en-US" level="3" l10n="U" oldref="7">Hide formula</paragraph> <paragraph role="paragraph" id="par_id3154510" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_FORMULAR">Hides formulas in the selected cells.</ahelp></paragraph> diff --git a/helpcontent2/source/text/scalc/01/05120000.xhp b/helpcontent2/source/text/scalc/01/05120000.xhp index 1f43e39bf2..2de8eb0f53 100644 --- a/helpcontent2/source/text/scalc/01/05120000.xhp +++ b/helpcontent2/source/text/scalc/01/05120000.xhp @@ -1,11 +1,11 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -29,8 +29,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalc0105120000xml" indexer="include"> <title xml-lang="en-US" id="tit">Conditional Formatting</title> @@ -86,8 +86,8 @@ <paragraph xml-lang="en-US" id="par_id3155114" role="paragraph" l10n="U" oldref="12"><ahelp hid="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_2" visibility="hidden">Enter a reference, value or formula.</ahelp> Enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references.</paragraph> <paragraph xml-lang="en-US" id="par_id3145257" role="paragraph" l10n="U" oldref="13">Once the parameters have been defined, the condition is complete. It may appear as:</paragraph> <paragraph xml-lang="en-US" id="par_id3150784" role="paragraph" l10n="U" oldref="14">Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition).</paragraph> - <paragraph xml-lang="en-US" id="par_id3150365" role="paragraph" l10n="U" oldref="15">Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21)</paragraph> - <paragraph xml-lang="en-US" id="par_id3152992" role="paragraph" l10n="U" oldref="16">Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150365" role="paragraph" l10n="CHG" oldref="15">Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21).</paragraph> + <paragraph xml-lang="en-US" id="par_id3152992" role="paragraph" l10n="CHG" oldref="16">Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10).</paragraph> <embed href="text/shared/00/00000001.xhp#eingabesymbol"/> <section id="relatedtopics"> <paragraph xml-lang="en-US" id="par_idN107E1" role="paragraph" l10n="NEW"> diff --git a/helpcontent2/source/text/scalc/01/06060100.xhp b/helpcontent2/source/text/scalc/01/06060100.xhp index 609ba99edd..ac2a61dd1b 100644 --- a/helpcontent2/source/text/scalc/01/06060100.xhp +++ b/helpcontent2/source/text/scalc/01/06060100.xhp @@ -4,7 +4,7 @@ <!--*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -27,17 +27,13 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0106060100xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Protecting Sheet</title> <filename>/text/scalc/01/06060100.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-01-05T13:57:21">converted from old format - fpe</lastedited> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="hid/FN_TABLE_SET_READ_ONLY_CELLS" id="bm_id5349783" localize="false"/><!-- HID added by script --> @@ -54,7 +50,7 @@ <paragraph role="tip" id="par_id3150329" xml-lang="en-US" l10n="U" oldref="17">Select <emph>Format - Cells - Cell Protection</emph>. Unmark the <emph>Protected</emph> box and click <emph>OK</emph>.</paragraph> <paragraph role="tip" id="par_id3156384" xml-lang="en-US" l10n="U" oldref="18">On the <emph>Tools - Protect Document - Sheet</emph> menu, activate protection for the sheet. Effective immediately, only the cell range you selected in step 1 can be edited.</paragraph> <paragraph role="tip" id="par_id3149566" xml-lang="en-US" l10n="U" oldref="9">To later change an unprotected area to a protected area, select the range. Next, on the <emph>Format - Cells - Cell Protection</emph> tab page, check the <emph>Protected</emph> box. Finally, choose the <emph>Tools - Protect Document - Sheet </emph>menu. The previously editable range is now protected.</paragraph> -<paragraph role="tip" id="par_id3153964" xml-lang="en-US" l10n="U" oldref="10">Sheet protection also affects the context menu of the sheet tabs at the bottom of the screen. The <emph>Delete</emph> and <emph>Move/Copy</emph> commands cannot be selected.</paragraph> +<paragraph role="tip" id="par_id3153964" xml-lang="en-US" l10n="CHG" oldref="10">Sheet protection also affects the context menu of the sheet tabs at the bottom of the screen. The <emph>Delete</emph> and <emph>Rename</emph> commands cannot be selected.</paragraph> <paragraph role="tip" id="par_id3150301" xml-lang="en-US" l10n="U" oldref="19">If a sheet is protected, you will not be able to modify or delete any Cell Styles.</paragraph> <paragraph role="paragraph" id="par_id3154656" xml-lang="en-US" l10n="U" oldref="3">A protected sheet or cell range can no longer be modified until this protection is disabled. To disable the protection, choose the <emph>Tools - Protect Document - Sheet</emph> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password.</paragraph> <paragraph role="paragraph" id="par_id3149815" xml-lang="en-US" l10n="U" oldref="11">Once saved, protected sheets can only be saved again by using the <emph>File - Save As</emph> command.</paragraph> diff --git a/helpcontent2/source/text/scalc/01/06070000.xhp b/helpcontent2/source/text/scalc/01/06070000.xhp index e36ec82470..73aa2a3693 100644 --- a/helpcontent2/source/text/scalc/01/06070000.xhp +++ b/helpcontent2/source/text/scalc/01/06070000.xhp @@ -5,7 +5,7 @@ *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -29,17 +29,13 @@ * ************************************************************************ --> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0106070000xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">AutoCalculate</title> <filename>/text/scalc/01/06070000.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-12-04T12:59:56">converted from old format - fpe</lastedited> -</history> </meta> <body> <section id="automatisch"> diff --git a/helpcontent2/source/text/scalc/01/06080000.xhp b/helpcontent2/source/text/scalc/01/06080000.xhp index 7e2852f688..60a45b752c 100644 --- a/helpcontent2/source/text/scalc/01/06080000.xhp +++ b/helpcontent2/source/text/scalc/01/06080000.xhp @@ -1,11 +1,11 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -29,8 +29,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalc0106080000xml" indexer="include"> <title id="tit" xml-lang="en-US">Recalculate</title> @@ -46,11 +46,16 @@ <bookmark xml-lang="en-US" branch="hid/FID_RECALC" id="bm_id2661876" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:Calculate" id="bm_id3156329" localize="false"/> <paragraph role="heading" id="hd_id3157909" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/06080000.xhp" name="Recalculate">Recalculate</link></paragraph> -<paragraph role="paragraph" id="par_id3154758" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".uno:Calculate">Recalculates the current sheet. Use <item type="menuitem">Tools - Cell Contents - Recalculate</item> or press F9 to recalculate all changed formulas in the current sheet. </ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154758" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".uno:Calculate">Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW.</ahelp></paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000406.xhp#exnb"/> </section> -<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US" l10n="U" oldref="5">After the document has been recalculated, the display is refreshed. Any charts contained in the sheet are also refreshed.</paragraph> +<paragraph role="paragraph" id="par_id315475899" xml-lang="en-US" l10n="NEW">Press F9 to recalculate. Press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document.</paragraph> + +<paragraph role="paragraph" id="par_id3150793" xml-lang="en-US" l10n="U" oldref="5">After the document has been recalculated, the display is refreshed. All charts are also refreshed.</paragraph> + +<paragraph role="paragraph" id="par_id315475855" xml-lang="en-US" l10n="NEW">The Add-In functions like RANDBETWEEN currently cannot respond to the Recalculate command or F9. Press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas, including the Add-In functions.</paragraph> + </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12120300.xhp b/helpcontent2/source/text/scalc/01/12120300.xhp index ff57fd6819..bb3e3d652c 100755 --- a/helpcontent2/source/text/scalc/01/12120300.xhp +++ b/helpcontent2/source/text/scalc/01/12120300.xhp @@ -4,7 +4,7 @@ <!--*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -27,7 +27,7 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0112120300xml" indexer="include" status="PUBLISH"> @@ -51,7 +51,7 @@ </section> <bookmark xml-lang="en-US" branch="hid/sc:TriStateBox:TP_VALIDATION_ERROR:TSB_SHOW" id="bm_id3154908" localize="false"/> <paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2" l10n="U" oldref="3">Show error message when invalid values are entered.</paragraph> -<paragraph role="paragraph" id="par_id3150768" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="SC:TRISTATEBOX:TP_VALIDATION_ERROR:TSB_SHOW">Displays the error message that you enter in the <emph>Contents</emph> area when invalid data is entered in a cell.</ahelp> If unchecked, the message is displayed to prevent an invalid entry.</paragraph> +<paragraph role="paragraph" id="par_id3150768" xml-lang="en-US" l10n="CHG" oldref="4"><ahelp hid=".">Displays the error message that you enter in the <emph>Contents</emph> area when invalid data is entered in a cell.</ahelp> If enabled, the message is displayed to prevent an invalid entry.</paragraph> <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="5">In both cases, if you select "Stop", the invalid entry is deleted and the previous value is reentered in the cell. The same applies if you close the "Warning" and "Information" dialogs by clicking the <emph>Cancel </emph>button. If you close the dialogs with the <emph>OK</emph> button, the invalid entry is not deleted.</paragraph> <paragraph role="heading" id="hd_id3152460" xml-lang="en-US" level="2" l10n="U" oldref="6">Contents</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ListBox:TP_VALIDATION_ERROR:LB_ACTION" id="bm_id3154014" localize="false"/> |