summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorUwe Fischer <ufi@openoffice.org>2010-06-08 13:04:41 +0200
committerUwe Fischer <ufi@openoffice.org>2010-06-08 13:04:41 +0200
commit03d08e61fa03d5fa02b9e24f9520b9ab14f67b8b (patch)
treeb75ce4afda4702dba5c71a58e667cb6dfe6a4f3c
parent53c024f50eaa7488ca75945b4a66921f52074ecf (diff)
hcshared26: Help changes
-rw-r--r--helpcontent2/source/text/scalc/01/02120100.xhp10
-rw-r--r--helpcontent2/source/text/scalc/01/02140500.xhp21
-rw-r--r--helpcontent2/source/text/scalc/01/04060109.xhp12
-rw-r--r--helpcontent2/source/text/scalc/01/05020600.xhp6
-rw-r--r--helpcontent2/source/text/scalc/01/05120000.xhp12
-rw-r--r--helpcontent2/source/text/scalc/01/06060100.xhp10
-rwxr-xr-xhelpcontent2/source/text/scalc/01/12120300.xhp6
-rwxr-xr-xhelpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp10
-rw-r--r--helpcontent2/source/text/scalc/guide/formulas.xhp11
-rw-r--r--helpcontent2/source/text/scalc/guide/line_fix.xhp6
-rwxr-xr-xhelpcontent2/source/text/scalc/guide/multioperation.xhp10
-rw-r--r--helpcontent2/source/text/shared/00/00000004.xhp11
-rw-r--r--helpcontent2/source/text/shared/00/00000406.xhp2
-rw-r--r--helpcontent2/source/text/shared/01/02230100.xhp9
-rwxr-xr-xhelpcontent2/source/text/shared/05/00000100.xhp9
-rwxr-xr-xhelpcontent2/source/text/shared/05/00000120.xhp87
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/01000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/02000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/03000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/04000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/05000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/06000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/07000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/08000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/09000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/10000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/12000000.xhp5
-rwxr-xr-xhelpcontent2/source/text/shared/autokorr/13000000.xhp7
-rwxr-xr-xhelpcontent2/source/text/shared/guide/spadmin.xhp6
-rwxr-xr-xhelpcontent2/source/text/swriter/guide/search_regexp.xhp8
30 files changed, 178 insertions, 150 deletions
diff --git a/helpcontent2/source/text/scalc/01/02120100.xhp b/helpcontent2/source/text/scalc/01/02120100.xhp
index de354371c..4aaf30bc7 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 dac51ddbe..33a41f524 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 a09582435..c7b3bc422 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 9a98fa120..313a0d4cc 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 1f43e39bf..2de8eb0f5 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 609ba99ed..ac2a61dd1 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/12120300.xhp b/helpcontent2/source/text/scalc/01/12120300.xhp
index ff57fd681..bb3e3d652 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 810a9d2a5..c83c804d2 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 769f4c859..47ee3ac0c 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 a8ec20cc5..d883cf22a 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 825f31e07..3c821540a 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>
diff --git a/helpcontent2/source/text/shared/00/00000004.xhp b/helpcontent2/source/text/shared/00/00000004.xhp
index d330d17d6..80fbf4ade 100644
--- a/helpcontent2/source/text/shared/00/00000004.xhp
+++ b/helpcontent2/source/text/shared/00/00000004.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
@@ -29,7 +29,7 @@
************************************************************************-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textshared0000000004xml" indexer="exclude" status="PUBLISH">
@@ -42,12 +42,17 @@
</history>
</meta>
<body>
-<paragraph role="heading" id="hd_id3160447" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="wie">To access this command...
+<paragraph role="heading" id="hd_id3160447" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="wie">To access this command...
</variable></paragraph>
<section id="related">
<paragraph role="related" id="par_id3147212" xml-lang="en-US" l10n="U" oldref="47"><variable id="related"><emph>Related Topics</emph>
</variable></paragraph>
</section>
+
+<section id="agentoff">
+<paragraph role="tip" id="par_id56935339" xml-lang="en-US" l10n="NEW">Enable or disable the Help Agent on <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME - General</emph>.</paragraph>
+</section>
+
<section id="sytextfarbe">
<table id="tbl_id3156421">
<tablerow>
diff --git a/helpcontent2/source/text/shared/00/00000406.xhp b/helpcontent2/source/text/shared/00/00000406.xhp
index 3a3e7ec1d..d16dda556 100644
--- a/helpcontent2/source/text/shared/00/00000406.xhp
+++ b/helpcontent2/source/text/shared/00/00000406.xhp
@@ -136,7 +136,7 @@
</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3157895" role="paragraph" l10n="U" oldref="50"><variable id="autokorr">Choose <emph>Tools - AutoCorrect Options</emph>
</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3153768" role="paragraph" l10n="U" oldref="51"><variable id="autokooptionen">Choose <emph>Tools - AutoCorrect Options</emph>tab
+ <paragraph xml-lang="en-US" id="par_id3153768" role="paragraph" l10n="U" oldref="51"><variable id="autokooptionen">Choose <emph>Tools - AutoCorrect Options</emph> tab
</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id1978514" role="paragraph" l10n="NEW"><variable id="autokosmarttags">Choose <emph>Tools - AutoCorrect Options - Smart Tags</emph> tab
</variable></paragraph>
diff --git a/helpcontent2/source/text/shared/01/02230100.xhp b/helpcontent2/source/text/shared/01/02230100.xhp
index 71a0611e0..51e2f3ae2 100644
--- a/helpcontent2/source/text/shared/01/02230100.xhp
+++ b/helpcontent2/source/text/shared/01/02230100.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
@@ -113,11 +113,6 @@
</case>
</switch>
-<switch select="appl">
-<case select="WRITER">
-<paragraph role="note" id="par_id3154366" xml-lang="en-US" l10n="U" oldref="18">Changes made to formulas or numbers in tables are not recorded.</paragraph>
-
-</case>
-</switch>
+<comment>removed the note about no-tables-comparing in Writer</comment>
</body>
</helpdocument>
diff --git a/helpcontent2/source/text/shared/05/00000100.xhp b/helpcontent2/source/text/shared/05/00000100.xhp
index f3ff04d07..85464efbd 100755
--- a/helpcontent2/source/text/shared/05/00000100.xhp
+++ b/helpcontent2/source/text/shared/05/00000100.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,20 +29,17 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textshared0500000100xml" indexer="exclude" status="PUBLISH">
<title id="tit" xml-lang="en-US"/>
<filename>/text/shared/05/00000100.xhp</filename>
</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2006-12-14T14:08:39">converted from old format - fpe</lastedited>
-</history>
</meta>
<body>
<section id="neuehilfe"><comment>this section is displayed on all module main pages above the other "Help about Help" links.</comment>
+<paragraph role="paragraph" id="par_id3150699" xml-lang="en-US" l10n="NEW">The Help references the default settings of the program on a system that is set to defaults. Descriptions of colors, mouse actions, or other configurable items can be different for your program and system.</paragraph>
</section>
<paragraph role="paragraph" id="par_id3150618" xml-lang="en-US" l10n="U" oldref="1">The <emph>$[officename] Help system</emph> provides easy access to information and support. There are several ways to find what you are looking for in the <link href="text/shared/05/00000110.xhp" name="Help environment">Help environment</link>: You can search for a specific keyword in the <link href="text/shared/05/00000130.xhp" name="Index">Index</link>, carry out a full-text search under <link href="text/shared/05/00000140.xhp" name="Find">Find</link>, or look through a hierarchical list of the <link href="text/shared/05/00000160.xhp" name="Topics">Topics</link>.</paragraph>
</body>
diff --git a/helpcontent2/source/text/shared/05/00000120.xhp b/helpcontent2/source/text/shared/05/00000120.xhp
index fb97fbf6b..f3dbbf6ea 100755
--- a/helpcontent2/source/text/shared/05/00000120.xhp
+++ b/helpcontent2/source/text/shared/05/00000120.xhp
@@ -1,15 +1,18 @@
<?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.
+ * Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.12 $
+ *
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
@@ -29,46 +32,46 @@
*
************************************************************************
-->
+
-<helpdocument version="1.0">
<meta>
-<topic id="textshared0500000120xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Help Agent, Tips and Extended Tips</title>
-<filename>/text/shared/05/00000120.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2007-02-23T10:58:54">converted from old format - fpe
-DEDR: Reviewed</lastedited>
-</history>
-</meta>
-<body>
+ <topic id="textshared0500000120xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Help Agent, Tips and Extended Tips</title>
+ <filename>/text/shared/05/00000120.xhp</filename>
+ </topic>
+ </meta>
+ <body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150672"><bookmark_value>Help; Help tips</bookmark_value>
-<bookmark_value>tooltips; help</bookmark_value>
-<bookmark_value>Help Agent; help</bookmark_value>
+ <bookmark_value>tooltips; help</bookmark_value>
+ <bookmark_value>Help Agent; help</bookmark_value>
+ <bookmark_value>Clippy, see Help Agent</bookmark_value>
</bookmark>
-<paragraph role="paragraph" id="par_id3150672" xml-lang="en-US" l10n="E" oldref="11" localize="false"/>
-<paragraph role="heading" id="hd_id3155599" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="00000120"><link href="text/shared/05/00000120.xhp" name="Help Agent, Tips and Extended Tips">Help Agent, Tips and Extended Tips</link>
+<paragraph xml-lang="en-US" id="par_id3150672" role="paragraph" l10n="E" oldref="11"
+ localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id3155599" role="heading" level="1" l10n="U" oldref="1"><variable id="00000120"><link href="text/shared/05/00000120.xhp" name="Help Agent, Tips and Extended Tips">Help Agent, Tips and Extended Tips</link>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3148520" xml-lang="en-US" l10n="CHG" oldref="2">The Help Agent, Tips, and Extended Tips provide help while you work. </paragraph>
-<paragraph role="heading" id="hd_id3147285" xml-lang="en-US" level="2" l10n="U" oldref="7">The Help Agent</paragraph>
-<paragraph role="paragraph" id="par_id3149716" xml-lang="en-US" l10n="U" oldref="8">The <link href="text/shared/optionen/01010600.xhp" name="Help Agent">Help Agent</link> starts automatically when you are performing a task that might require some assistance. The Help Agent appears in a small window in a corner of the document. To view the help for the task, click inside the Help Agent window.</paragraph>
-<paragraph role="tip" id="par_idN10634" xml-lang="en-US" l10n="CHG">The Help Agent automatically closes after a short delay. If you ignore or close the Help Agent three times you perform a certain task, the Help Agent no longer opens for that task.</paragraph>
-<paragraph role="tip" id="par_id5693533" xml-lang="en-US" l10n="NEW">Enable or disable the Help Agent on <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME - General</emph>.</paragraph>
-<paragraph role="heading" id="hd_id3149140" xml-lang="en-US" level="2" l10n="U" oldref="3">Tips</paragraph>
-<paragraph role="paragraph" id="par_id3157896" xml-lang="en-US" l10n="U" oldref="4">Tips provide you with the names of toolbar buttons. To display a tip, rest the pointer over a toolbar button until the name of the button appears.</paragraph>
-<paragraph role="paragraph" id="par_id3153910" xml-lang="en-US" l10n="U" oldref="9">Tips are also displayed for some elements in a document, such as chapter names when you scroll through a long document.</paragraph>
-<paragraph role="tip" id="par_id992156" xml-lang="en-US" l10n="NEW">Enable or disable the tips on <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME - General</emph>.</paragraph>
-<paragraph role="heading" id="hd_id3147571" xml-lang="en-US" level="2" l10n="U" oldref="5">Extended Tips</paragraph>
-<paragraph role="paragraph" id="par_id3149346" xml-lang="en-US" l10n="CHG" oldref="6">Extended tips provide a brief description about buttons and commands. To display an extended tip, press Shift+F1, then point to a button or command.</paragraph>
-<paragraph role="tip" id="par_idN10666" xml-lang="en-US" l10n="NEW">If you always want extended tips instead of tips, enable the extended tips on <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME - General</emph>.</paragraph>
-<section id="relatedtopics">
-<embed href="text/shared/guide/active_help_on_off.xhp#active_help_on_off"/>
-<embed href="text/shared/05/00000110.xhp#00000110"/>
-<embed href="text/shared/05/00000160.xhp#doc_title"/>
-<embed href="text/shared/05/00000130.xhp#00000130"/>
-<embed href="text/shared/05/00000140.xhp#00000140"/>
-<embed href="text/shared/05/00000150.xhp#doc_title"/>
-</section>
-</body>
-</helpdocument>
+ <paragraph xml-lang="en-US" id="par_id3148520" role="paragraph" l10n="CHG" oldref="2">The Help Agent, Tips, and Extended Tips provide help while you work. </paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3147285" role="heading" level="2" l10n="U" oldref="7">The Help Agent</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149716" role="paragraph" l10n="U" oldref="8">The <link href="text/shared/optionen/01010600.xhp" name="Help Agent">Help Agent</link> starts automatically when you are performing a task that might require some assistance. The Help Agent appears in a small window in a corner of the document. To view the help for the task, click inside the Help Agent window.</paragraph>
+ <paragraph xml-lang="en-US" id="par_idN10634" role="tip" l10n="CHG">The Help Agent automatically closes after a short delay. If you ignore or close the Help Agent three times you perform a certain task, the Help Agent no longer opens for that task. To disable the Help Agent choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
+</caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME - General</emph>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#agentoff"/>
+ <paragraph xml-lang="en-US" id="hd_id3149140" role="heading" level="2" l10n="U" oldref="3">Tips</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3157896" role="paragraph" l10n="U" oldref="4">Tips provide you with the names of toolbar buttons. To display a tip, rest the pointer over a toolbar button until the name of the button appears.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153910" role="paragraph" l10n="U" oldref="9">Tips are also displayed for some elements in a document, such as chapter names when you scroll through a long document.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id992156" role="tip" l10n="NEW">Enable or disable the tips on <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
+</caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME - General</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3147571" role="heading" level="2" l10n="U" oldref="5">Extended Tips</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149346" role="paragraph" l10n="CHG" oldref="6">Extended tips provide a brief description about buttons and commands. To display an extended tip, press Shift+F1, then point to a button or command.</paragraph>
+ <paragraph xml-lang="en-US" id="par_idN10666" role="tip" l10n="NEW">If you always want extended tips instead of tips, enable the extended tips on <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
+</caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME - General</emph>.</paragraph>
+ <section id="relatedtopics">
+ <embed href="text/shared/guide/active_help_on_off.xhp#active_help_on_off"/>
+ <embed href="text/shared/05/00000110.xhp#00000110"/>
+ <embed href="text/shared/05/00000160.xhp#doc_title"/>
+ <embed href="text/shared/05/00000130.xhp#00000130"/>
+ <embed href="text/shared/05/00000140.xhp#00000140"/>
+ <embed href="text/shared/05/00000150.xhp#doc_title"/>
+ </section>
+ </body>
+</helpdocument> \ No newline at end of file
diff --git a/helpcontent2/source/text/shared/autokorr/01000000.xhp b/helpcontent2/source/text/shared/autokorr/01000000.xhp
index ee7c404ee..0bb93c05e 100755
--- a/helpcontent2/source/text/shared/autokorr/01000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/01000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr01000000xml" indexer="exclude" status="PUBLISH">
@@ -50,6 +50,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/02000000.xhp b/helpcontent2/source/text/shared/autokorr/02000000.xhp
index bb04d5b99..91993c59c 100755
--- a/helpcontent2/source/text/shared/autokorr/02000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/02000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr02000000xml" indexer="exclude" status="PUBLISH">
@@ -50,6 +50,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/03000000.xhp b/helpcontent2/source/text/shared/autokorr/03000000.xhp
index 3c43491bb..de2e7abff 100755
--- a/helpcontent2/source/text/shared/autokorr/03000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/03000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr03000000xml" indexer="exclude" status="PUBLISH">
@@ -50,6 +50,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/04000000.xhp b/helpcontent2/source/text/shared/autokorr/04000000.xhp
index 81298cd1b..502e72125 100755
--- a/helpcontent2/source/text/shared/autokorr/04000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/04000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr04000000xml" indexer="exclude" status="PUBLISH">
@@ -51,6 +51,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/05000000.xhp b/helpcontent2/source/text/shared/autokorr/05000000.xhp
index afbc831d1..a4eb3bfca 100755
--- a/helpcontent2/source/text/shared/autokorr/05000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/05000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr05000000xml" indexer="exclude" status="PUBLISH">
@@ -49,6 +49,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/06000000.xhp b/helpcontent2/source/text/shared/autokorr/06000000.xhp
index 1d47b5413..70e0f75a3 100755
--- a/helpcontent2/source/text/shared/autokorr/06000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/06000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr06000000xml" indexer="exclude" status="PUBLISH">
@@ -49,6 +49,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokotyafz"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/07000000.xhp b/helpcontent2/source/text/shared/autokorr/07000000.xhp
index 6cc4e5211..45117e6ea 100755
--- a/helpcontent2/source/text/shared/autokorr/07000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/07000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr07000000xml" indexer="exclude" status="PUBLISH">
@@ -49,6 +49,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokotyafz"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/08000000.xhp b/helpcontent2/source/text/shared/autokorr/08000000.xhp
index 3ad7520fa..7fd6245d6 100755
--- a/helpcontent2/source/text/shared/autokorr/08000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/08000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr08000000xml" indexer="exclude" status="PUBLISH">
@@ -49,6 +49,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/09000000.xhp b/helpcontent2/source/text/shared/autokorr/09000000.xhp
index ce4c7053e..ff4af8ffe 100755
--- a/helpcontent2/source/text/shared/autokorr/09000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/09000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr09000000xml" indexer="exclude" status="PUBLISH">
@@ -49,6 +49,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/10000000.xhp b/helpcontent2/source/text/shared/autokorr/10000000.xhp
index 66c7f5d71..b3531239d 100755
--- a/helpcontent2/source/text/shared/autokorr/10000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/10000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr10000000xml" indexer="exclude" status="PUBLISH">
@@ -49,6 +49,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/12000000.xhp b/helpcontent2/source/text/shared/autokorr/12000000.xhp
index 7f52d2c25..53e18538b 100755
--- a/helpcontent2/source/text/shared/autokorr/12000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/12000000.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
@@ -46,6 +46,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/autokorr/13000000.xhp b/helpcontent2/source/text/shared/autokorr/13000000.xhp
index bccedc53b..4abe69ef8 100755
--- a/helpcontent2/source/text/shared/autokorr/13000000.xhp
+++ b/helpcontent2/source/text/shared/autokorr/13000000.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,7 +29,7 @@
*
************************************************************************
-->
-
+
<helpdocument version="1.0">
<meta>
<topic id="textsharedautokorr13000000xml" indexer="exclude" status="PUBLISH">
@@ -49,6 +49,9 @@
<section id="howtoget">
<embed href="text/shared/00/00000406.xhp#autokooptionen"/>
</section>
+
+<embed href="text/shared/00/00000004.xhp#agentoff"/>
+
<section id="relatedtopics">
<embed href="text/shared/guide/autocorr_url.xhp#autocorr_url"/>
<switch select="appl">
diff --git a/helpcontent2/source/text/shared/guide/spadmin.xhp b/helpcontent2/source/text/shared/guide/spadmin.xhp
index 79f667244..23d61bb1e 100755
--- a/helpcontent2/source/text/shared/guide/spadmin.xhp
+++ b/helpcontent2/source/text/shared/guide/spadmin.xhp
@@ -50,9 +50,11 @@
<bookmark_value>PDF; PostScript to PDF converter, UNIX</bookmark_value>
</bookmark><comment>mw deleted "printer programs under UNIX", "fax programs under UNIX" and "font programs under UNIX" and changed "faxes;..."</comment>
<paragraph role="paragraph" id="par_id3154422" xml-lang="en-US" l10n="E" oldref="341" localize="false"/>
-<paragraph role="heading" id="hd_id3147834" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="spadmin"><link href="text/shared/guide/spadmin.xhp" name="Setting up Printer, Fax and Fonts Under UNIX Based Platforms">Setting up Printer, Fax and Fonts Under UNIX Based Platforms</link>
+<paragraph role="heading" id="hd_id3147834" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><variable id="spadmin"><link href="text/shared/guide/spadmin.xhp" name="Setting up Printer and Fax Under UNIX Based Platforms">Setting up Printer and Fax Under UNIX Based Platforms</link>
</variable></paragraph>
<section id="chapter_body">
+<paragraph role="paragraph" id="par_id3159876" xml-lang="en-US" l10n="NEW">%PRODUCTNAME uses the installed fonts of your system. In a text document you can select from all printable fonts. In an HTML document or in Web layout, only fonts that are visible on screen are offered. In spreadsheets and drawings you can select from all installed fonts.</paragraph>
+
<paragraph role="paragraph" id="par_id3159233" xml-lang="en-US" l10n="U" oldref="2">Under UNIX based platforms, the printer administration program <emph>spadmin</emph> is provided to help you set up printers and faxes for use with the $[officename] software.</paragraph>
<paragraph role="paragraph" id="par_id3156410" xml-lang="en-US" l10n="U" oldref="117">Call the printer administration program <emph>spadmin</emph> as follows:</paragraph>
<list type="unordered">
@@ -220,7 +222,7 @@
</listitem>
</list>
<paragraph role="paragraph" id="par_id3153064" xml-lang="en-US" l10n="U" oldref="313">You can now create PDF documents by printing to the converter that has just been created.</paragraph>
-<paragraph role="paragraph" id="par_id3159222" xml-lang="en-US" l10n="E" oldref="345" localize="false"/>
+
</section>
</section>
</body>
diff --git a/helpcontent2/source/text/swriter/guide/search_regexp.xhp b/helpcontent2/source/text/swriter/guide/search_regexp.xhp
index a52160366..cdeeae9b6 100755
--- a/helpcontent2/source/text/swriter/guide/search_regexp.xhp
+++ b/helpcontent2/source/text/swriter/guide/search_regexp.xhp
@@ -6,10 +6,13 @@
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
- * Copyright 2000, 2010 Oracle and/or its affiliates.
+ * Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.12 $
+ *
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
@@ -44,7 +47,8 @@
<bookmark_value>examples for regular expressions</bookmark_value>
<bookmark_value>characters;finding all</bookmark_value>
<bookmark_value>invisible characters;finding</bookmark_value>
-</bookmark><comment>mw deleted "wildcards;" and inserted wildcards crossreference</comment>
+ <bookmark_value>paragraph marks;searching</bookmark_value>
+</bookmark><comment>mw deleted "wildcards;" and inserted wildcards crossreference</comment><comment>mw added "paragraph marks;"</comment>
<paragraph xml-lang="en-US" id="hd_id3150099" role="heading" level="1" l10n="U"
oldref="15"><variable id="search_regexp"><link href="text/swriter/guide/search_regexp.xhp">Using Wildcards in Text Searches</link>
</variable></paragraph>