diff options
Diffstat (limited to 'helpcontent2/source/text/scalc')
| -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 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp | 10 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/guide/formulas.xhp | 11 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/guide/line_fix.xhp | 6 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/multioperation.xhp | 10 |
13 files changed, 63 insertions, 76 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"/> diff --git a/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp b/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp index 810a9d2a55..c83c804d28 100755 --- a/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp +++ b/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.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="textscalcguidecellreference_dragdropxml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Referencing Cells by Drag-and-Drop</title> @@ -46,7 +46,7 @@ <paragraph xml-lang="en-US" id="hd_id3154686" role="heading" level="1" l10n="U" oldref="16"><variable id="cellreference_dragdrop"><link href="text/scalc/guide/cellreference_dragdrop.xhp" name="Referencing Cells by Drag-and-Drop">Referencing Cells by Drag-and-Drop</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph" l10n="U" oldref="17">With the help of the Navigator you can reference cells from one spreadsheet to another sheet in the same document or in a different document. The cells can be inserted as a copy, link or hyperlink. The range to be inserted must be defined with a name in the original file so that it can be inserted in the target file.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph" l10n="CHG" oldref="17">With the help of the Navigator you can reference cells from one sheet to another sheet in the same document or in a different document. The cells can be inserted as a copy, link, or hyperlink. The range to be inserted must be defined with a name in the original file so that it can be inserted in the target file.</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3152576" role="listitem" l10n="U" oldref="25">Open the document that contains the source cells.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/formulas.xhp b/helpcontent2/source/text/scalc/guide/formulas.xhp index 769f4c8595..47ee3ac0c3 100644 --- a/helpcontent2/source/text/scalc/guide/formulas.xhp +++ b/helpcontent2/source/text/scalc/guide/formulas.xhp @@ -6,7 +6,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 @@ -106,14 +106,7 @@ <paragraph role="paragraph" id="par_id3159171" xml-lang="en-US" l10n="U" oldref="36">Calculates the sum of cells B10 to B14 and adds the value to B8.</paragraph> </tablecell> </tablerow> -<tablerow> -<tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3148604" xml-lang="en-US" l10n="CHG" oldref="50">=SUM(B1:B65536)</paragraph> -</tablecell> -<tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157982" xml-lang="en-US" l10n="U" oldref="51">Sums all numbers in column B.</paragraph> -</tablecell> -</tablerow> +<comment>removed row with old row limit of 65536</comment> </table> <paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="U" oldref="30">It is also possible to nest functions in formulas, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions.</paragraph> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/line_fix.xhp b/helpcontent2/source/text/scalc/guide/line_fix.xhp index a8ec20cc59..d883cf22a9 100644 --- a/helpcontent2/source/text/scalc/guide/line_fix.xhp +++ b/helpcontent2/source/text/scalc/guide/line_fix.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="textscalcguideline_fixxml" indexer="include" status="PUBLISH"> @@ -52,7 +52,7 @@ </bookmark> <paragraph role="heading" id="hd_id3154684" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="line_fix"><link href="text/scalc/guide/line_fix.xhp" name="Freezing Rows or Columns as Headers">Freezing Rows or Columns as Headers</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="2">If you have long rows or columns of data that extend beyond the viewable area of the spreadsheet, you can freeze them, which allows you to see the columns or rows as you scroll through the rest of the data.</paragraph> +<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="CHG" oldref="2">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.</paragraph> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3156441" xml-lang="en-US" l10n="U" oldref="3">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.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/multioperation.xhp b/helpcontent2/source/text/scalc/guide/multioperation.xhp index 825f31e07e..3c821540ae 100755 --- a/helpcontent2/source/text/scalc/guide/multioperation.xhp +++ b/helpcontent2/source/text/scalc/guide/multioperation.xhp @@ -1,12 +1,12 @@ <?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 @@ -30,8 +30,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalcguidemultioperationxml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Applying Multiple Operations</title> @@ -48,7 +48,7 @@ <paragraph role="heading" id="hd_id3147559" xml-lang="en-US" level="1" l10n="U" oldref="5"><variable id="multioperation"><link href="text/scalc/guide/multioperation.xhp" name="Applying Multiple Operations">Applying Multiple Operations</link> </variable></paragraph> <paragraph role="heading" id="hd_id3145171" xml-lang="en-US" level="2" l10n="U" oldref="1">Multiple Operations in Columns or Rows</paragraph> -<paragraph role="paragraph" id="par_id4123966" xml-lang="en-US" l10n="NEW">The <item type="menuitem">Data - Multiple Operations</item> command provides a planning tool for "what if" questions.In your spreadsheet, you enter a formula to calculate a result from values that are stored in other cells. Then, you set up a cell range where you enter some fixed values, and the Multiple Operations command will calculate the results depending on the formula.</paragraph> +<paragraph role="paragraph" id="par_id4123966" xml-lang="en-US" l10n="NEW">The <item type="menuitem">Data - Multiple Operations</item> command provides a planning tool for "what if" questions. In your spreadsheet, you enter a formula to calculate a result from values that are stored in other cells. Then, you set up a cell range where you enter some fixed values, and the Multiple Operations command will calculate the results depending on the formula.</paragraph> <paragraph role="paragraph" id="par_id3156424" xml-lang="en-US" l10n="CHG" oldref="2">In the <emph>Formula</emph> field, enter the cell reference to the formula that applies to the data range. In the <emph>Column input cell/Row input cell</emph> field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples:</paragraph> <paragraph role="heading" id="hd_id3159153" xml-lang="en-US" level="3" l10n="U" oldref="7">Examples</paragraph> <paragraph role="paragraph" id="par_id3153189" xml-lang="en-US" l10n="U" oldref="8">You produce toys which you sell for $10 each. Each toy costs $2 to make, in addition to which you have fixed costs of $10,000 per year. How much profit will you make in a year if you sell a particular number of toys?</paragraph> |