first_build

6 files changed, 152 insertions, 153 deletions

diff --git a/helpcontent2/source/text/scalc/01/04060182.xhp b/helpcontent2/source/text/scalc/01/04060182.xhp
index 2c38afb43d..7ae9e6e869 100755
--- a/helpcontent2/source/text/scalc/01/04060182.xhp
+++ b/helpcontent2/source/text/scalc/01/04060182.xhp
@@ -11,7 +11,7 @@
  * OpenOffice.org - a multi-platform office productivity suite
  *
  * $RCSfile: soffice2xmlhelp.xsl,v $
- * $Revision: 1.10 $
+ * $Revision: 1.12 $
  *
  * This file is part of OpenOffice.org.
  *
@@ -276,20 +276,17 @@
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GTEST" id="bm_id3147569" localize="false"/>
 <paragraph xml-lang="en-US" id="hd_id3153216" role="heading" level="2" l10n="U"
                     oldref="103">ZTEST</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3150758" role="paragraph" l10n="U" oldref="104"><ahelp hid="HID_FUNC_GTEST">Returns the two-tailed P value of a z test with standard distribution.</ahelp></paragraph>
+         <paragraph xml-lang="en-US" id="par_id3150758" role="paragraph" l10n="CHG" oldref="104"><ahelp hid="HID_FUNC_GTEST">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph>
          <paragraph xml-lang="en-US" id="hd_id3150872" role="heading" level="3" l10n="U"
                     oldref="105">Syntax</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3153274" role="code" l10n="U" oldref="106">ZTEST(Data; Number; Sigma)</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph" l10n="U" oldref="107">
-            <emph>Data</emph> is the array of the data.</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph" l10n="U" oldref="108">
-            <emph>Number</emph> is the value to be tested.</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3154740" role="paragraph" l10n="U" oldref="109">
-            <emph>Sigma</emph> (optional) is the standard deviation of the total population. If this argument is missing, the standard deviation of the sample in question will be processed.</paragraph>
-         <paragraph xml-lang="en-US" id="hd_id3151289" role="heading" level="3" l10n="U"
-                    oldref="110">Example</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3153756" role="paragraph" l10n="U" oldref="111">
-            <item type="input">=ZTEST(A1:A50;12)</item> yields the probability that value 12 belongs to the standard distribution of the total population of data in A1:A50.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3153274" role="code" l10n="CHG" oldref="106">ZTEST(Data; mu; Sigma)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph" l10n="CHG" oldref="107">
+            <emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph" l10n="CHG" oldref="108">
+            <emph>mu</emph> is the known mean of the population.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3154740" role="paragraph" l10n="CHG" oldref="109">
+            <emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph>
+	 <paragraph xml-lang="en-US" id="par_id0305200911372999" role="paragraph" l10n="NEW">See also the <link href="http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_ZTEST_function">Wiki page</link>.</paragraph>
       </section>
       <section id="harmean">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153623"><bookmark_value>HARMEAN function</bookmark_value>
diff --git a/helpcontent2/source/text/scalc/01/04060185.xhp b/helpcontent2/source/text/scalc/01/04060185.xhp
index 16a579e51d..677ad095fd 100755
--- a/helpcontent2/source/text/scalc/01/04060185.xhp
+++ b/helpcontent2/source/text/scalc/01/04060185.xhp
@@ -11,7 +11,7 @@
  * OpenOffice.org - a multi-platform office productivity suite
  *
  * $RCSfile: soffice2xmlhelp.xsl,v $
- * $Revision: 1.10 $
+ * $Revision: 1.12 $
  *
  * This file is part of OpenOffice.org.
  *
@@ -507,8 +507,8 @@
                     oldref="175">WEIBULL</paragraph>
          <paragraph xml-lang="en-US" id="par_id3154916" role="paragraph" l10n="U" oldref="176"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull distribution.</ahelp></paragraph>
          <paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph" l10n="NEW">The Weibull distribution is a continuous probability distribution, with parameters Alpha &gt; 0 (shape) and Beta &gt; 0 (scale). </paragraph>
-         <paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph" l10n="NEW">If C is 1, WEIBULL calculates the probability density function.</paragraph>
-         <paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph" l10n="NEW">If C is 0, WEIBULL calculates the cumulative distribution function.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph" l10n="NEW">If C is 0, WEIBULL calculates the probability density function.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph" l10n="NEW">If C is 1, WEIBULL calculates the cumulative distribution function.</paragraph>
          <paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3" l10n="U"
                     oldref="177">Syntax</paragraph>
          <paragraph xml-lang="en-US" id="par_id3154478" role="code" l10n="U" oldref="178">WEIBULL(Number; Alpha; Beta; C)</paragraph>
@@ -518,8 +518,8 @@
             <emph>Alpha </emph>is the shape parameter of the Weibull distribution.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3154668" role="paragraph" l10n="U" oldref="181">
             <emph>Beta</emph> is the scale parameter of the Weibull distribution.</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3154825" role="paragraph" l10n="U" oldref="182">
-            <emph>C</emph> indicates the type of function. If C equals 0 the form of the function is calculated, if C equals 1 the distribution is calculated.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3154825" role="paragraph" l10n="CHG" oldref="182">
+            <emph>C</emph> indicates the type of function.</paragraph>
          <paragraph xml-lang="en-US" id="hd_id3153794" role="heading" level="3" l10n="U"
                     oldref="183">Example</paragraph>
          <paragraph xml-lang="en-US" id="par_id3146077" role="paragraph" l10n="U" oldref="184">
diff --git a/helpcontent2/source/text/scalc/guide/cell_protect.xhp b/helpcontent2/source/text/scalc/guide/cell_protect.xhp
index 2e67ff433e..5d6cb0eb3d 100755
--- a/helpcontent2/source/text/scalc/guide/cell_protect.xhp
+++ b/helpcontent2/source/text/scalc/guide/cell_protect.xhp
@@ -11,7 +11,7 @@
  * OpenOffice.org - a multi-platform office productivity suite
  *
  * $RCSfile: soffice2xmlhelp.xsl,v $
- * $Revision: 1.10 $
+ * $Revision: 1.12 $
  *
  * This file is part of OpenOffice.org.
  *
@@ -51,7 +51,7 @@
       <bookmark_value>hiding;formulas</bookmark_value>
       <bookmark_value>formulas;hiding</bookmark_value>
 </bookmark><comment>MW transferred "modifying;..." and "changing;..." into one index entry</comment>
-<paragraph xml-lang="en-US" id="hd_id3146119" role="heading" level="1" l10n="U" oldref="5"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link> 
+<paragraph xml-lang="en-US" id="hd_id3146119" role="heading" level="1" l10n="U" oldref="5"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link>
 </variable></paragraph>
       <paragraph xml-lang="en-US" id="par_id3153368" role="paragraph" l10n="U" oldref="17">In <item type="productname">%PRODUCTNAME</item> Calc you can protect sheets and the document as a whole. You can choose whether the cells are protected against accidental changes, whether the formulas can be viewed from within Calc, whether the cells are visible or whether the cells can be printed.</paragraph>
       <paragraph xml-lang="en-US" id="par_id3145261" role="paragraph" l10n="U" oldref="18">Protection can be provided by means of a password, but it does not have to be. If you have assigned a password, protection can only be removed once the correct password has been entered.</paragraph>
@@ -79,7 +79,7 @@
             <paragraph xml-lang="en-US" id="par_idN106C7" role="listitem" l10n="CHG">To protect the structure of the document, for example the count, <link href="text/scalc/guide/rename_table.xhp">names</link>, and order of the sheets, from being changed, choose <item type="menuitem">Tools - Protect Document - Document</item>.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_idN106CF" role="listitem" l10n="NEW">(Optional) Enter a password of at least 5 characters.</paragraph>
+            <paragraph xml-lang="en-US" id="par_idN106CF" role="listitem" l10n="CHG">(Optional) Enter a password.</paragraph>
             <paragraph xml-lang="en-US" id="par_idN106D2" role="warning" l10n="NEW">If you forget your password, you cannot deactivate the protection. If you only want to protect cells from accidental changes, set the sheet protection, but do not enter a password.</paragraph>
          </listitem>
          <listitem>
diff --git a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp
index 821d21dc6f..66c15ec5be 100644
--- a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp
+++ b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp
@@ -11,7 +11,7 @@
  * OpenOffice.org - a multi-platform office productivity suite
  *
  * $RCSfile: soffice2xmlhelp.xsl,v $
- * $Revision: 1.8 $
+ * $Revision: 1.12 $
  *
  * This file is part of OpenOffice.org.
  *
@@ -53,7 +53,6 @@
       <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="U" oldref="29">To remove a button from the table, just drag it out of the DataPilot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted.</paragraph>
       <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="40">To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command <emph>Start</emph>, which displays the <emph>DataPilot</emph> dialog for the current DataPilot table.</paragraph>
       <paragraph xml-lang="en-US" id="par_id2666096" role="paragraph" l10n="NEW">In the DataPilot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3149401" role="tip" l10n="U" oldref="38">By double-clicking on some buttons inside the DataPilot table you can hide the subelements below it.</paragraph>
       <section id="relatedtopics">
          <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
          <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
diff --git a/helpcontent2/source/text/scalc/guide/mark_cells.xhp b/helpcontent2/source/text/scalc/guide/mark_cells.xhp
index 3f34af06f0..d6cddc9d6a 100755
--- a/helpcontent2/source/text/scalc/guide/mark_cells.xhp
+++ b/helpcontent2/source/text/scalc/guide/mark_cells.xhp
@@ -1,8 +1,8 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
+	
 <!--
- ***********************************************************************
+***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
  * 
@@ -10,8 +10,8 @@
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
- * $RCSfile: mark_cells.xhp,v $
- * $Revision: 1.7.4.1 $
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.12 $
  *
  * This file is part of OpenOffice.org.
  *
@@ -32,81 +32,87 @@
  *
  ************************************************************************
  -->
+ 
 	
-<helpdocument version="1.0">
 <meta>
-<topic id="textscalcguidemark_cellsxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Selecting Multiple Cells</title>
-<filename>/text/scalc/guide/mark_cells.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2006-03-21T12:48:20">converted from old format - fpe</lastedited>
-</history>
-</meta>
-<body>
+      <topic id="textscalcguidemark_cellsxml" indexer="include" status="PUBLISH">
+         <title xml-lang="en-US" id="tit">Selecting Multiple Cells</title>
+         <filename>/text/scalc/guide/mark_cells.xhp</filename>
+      </topic>
+   </meta>
+   <body>
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153361"><bookmark_value>cells; selecting</bookmark_value>
-<bookmark_value>marking cells</bookmark_value>
-<bookmark_value>selecting;cells</bookmark_value>
-<bookmark_value>multiple cells selection</bookmark_value>
-<bookmark_value>selection modes in spreadsheets</bookmark_value>
-<bookmark_value>tables; selecting ranges</bookmark_value>
+      <bookmark_value>marking cells</bookmark_value>
+      <bookmark_value>selecting;cells</bookmark_value>
+      <bookmark_value>multiple cells selection</bookmark_value>
+      <bookmark_value>selection modes in spreadsheets</bookmark_value>
+      <bookmark_value>tables; selecting ranges</bookmark_value>
 </bookmark><comment>mw changed "selection modes..."</comment>
-<paragraph role="heading" id="hd_id3153361" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp" name="Selecting Multiple Cells">Selecting Multiple Cells</link>
+<paragraph xml-lang="en-US" id="hd_id3153361" role="heading" level="1" l10n="U" oldref="1"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp" name="Selecting Multiple Cells">Selecting Multiple Cells</link>
 </variable></paragraph>
-<paragraph role="heading" id="hd_id3145272" xml-lang="en-US" level="2" l10n="U" oldref="2">Select a rectangular range</paragraph>
-<paragraph role="paragraph" id="par_id3149261" xml-lang="en-US" l10n="U" oldref="3">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.</paragraph>
-<paragraph role="heading" id="hd_id3151119" xml-lang="en-US" level="2" l10n="U" oldref="4">Mark a single cell</paragraph>
-<paragraph role="paragraph" id="par_id3146975" xml-lang="en-US" l10n="U" oldref="19">Do one of the following:</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="listitem" id="par_id3163710" xml-lang="en-US" l10n="U" oldref="20">Click, then Shift-click the cell.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3149959" xml-lang="en-US" l10n="U" oldref="5">Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. You can now move the individual cell by drag and drop.</paragraph>
-</listitem>
-</list>
-<paragraph role="heading" id="hd_id3154942" xml-lang="en-US" level="2" l10n="U" oldref="6">Select various dispersed cells</paragraph>
-<paragraph role="paragraph" id="par_id3156284" xml-lang="en-US" l10n="U" oldref="7">Mark at least one cell. Then while pressing <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, click each of the additional cells.</paragraph>
-<paragraph role="heading" id="hd_id3146971" xml-lang="en-US" level="2" l10n="U" oldref="8">Switch marking mode</paragraph>
-<paragraph role="paragraph" id="par_id3155064" xml-lang="en-US" l10n="U" oldref="9">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:</paragraph>
-<table id="tbl_id3145643">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3159264" xml-lang="en-US" l10n="U" oldref="10">Field contents</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3155337" xml-lang="en-US" l10n="U" oldref="11">Effect of clicking the mouse</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149568" xml-lang="en-US" l10n="U" oldref="12">STD</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3148486" xml-lang="en-US" l10n="U" oldref="13">A mouse click selects the cell you have clicked on. Unmarks all marked cells.</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3150090" xml-lang="en-US" l10n="U" oldref="14">EXT</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3150305" xml-lang="en-US" l10n="U" oldref="15">A mouse click marks a rectangular range from the current cell to the cell you clicked.</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3145587" xml-lang="en-US" l10n="U" oldref="16">ADD</paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3154368" xml-lang="en-US" l10n="U" oldref="17">A mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-click the cells.</paragraph>
-</tablecell>
-</tablerow>
-</table>
+      <paragraph xml-lang="en-US" id="hd_id3145272" role="heading" level="2" l10n="U" oldref="2">Select a rectangular range</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3149261" role="paragraph" l10n="U" oldref="3">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.</paragraph>
+      <paragraph xml-lang="en-US" id="hd_id3151119" role="heading" level="2" l10n="U" oldref="4">Mark a single cell</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3146975" role="paragraph" l10n="U" oldref="19">Do one of the following:</paragraph>
+      <list type="unordered">
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id3163710" role="listitem" l10n="U" oldref="20">Click, then Shift-click the cell.</paragraph>
+         </listitem>
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id3149959" role="listitem" l10n="CHG" oldref="5">Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. Release the mouse button. You can now move the individual cell by drag and drop.</paragraph>
+         </listitem>
+      </list>
+      <paragraph xml-lang="en-US" id="hd_id3154942" role="heading" level="2" l10n="U" oldref="6">Select various dispersed cells</paragraph>
+      <paragraph xml-lang="en-US" id="par_id1001200901072060" role="paragraph" l10n="NEW">Do one of the following:</paragraph>
+      <list type="unordered">
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id3156284" role="paragraph" l10n="U" oldref="7">Mark at least one cell. Then while pressing <switchinline select="sys"><caseinline select="MAC">Command
+</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, click each of the additional cells.</paragraph>
+         </listitem>
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id1001200901072023" role="paragraph" l10n="NEW">Click the STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to select.</paragraph>
+         </listitem>
+      </list>
+      <paragraph xml-lang="en-US" id="hd_id3146971" role="heading" level="2" l10n="U" oldref="8">Switch marking mode</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3155064" role="paragraph" l10n="U" oldref="9">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:</paragraph>
+      <table id="tbl_id3145643">
+         <tablerow>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3159264" role="paragraph" l10n="U" oldref="10">Field contents</paragraph>
+            </tablecell>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3155337" role="paragraph" l10n="U" oldref="11">Effect of clicking the mouse</paragraph>
+            </tablecell>
+         </tablerow>
+         <tablerow>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3149568" role="paragraph" l10n="U" oldref="12">STD</paragraph>
+            </tablecell>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3148486" role="paragraph" l10n="U" oldref="13">A mouse click selects the cell you have clicked on. Unmarks all marked cells.</paragraph>
+            </tablecell>
+         </tablerow>
+         <tablerow>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3150090" role="paragraph" l10n="U" oldref="14">EXT</paragraph>
+            </tablecell>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3150305" role="paragraph" l10n="CHG" oldref="15">A mouse click marks a rectangular range from the current cell to the cell you clicked. Alternatively, Shift-click a cell.</paragraph>
+            </tablecell>
+         </tablerow>
+         <tablerow>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3145587" role="paragraph" l10n="U" oldref="16">ADD</paragraph>
+            </tablecell>
+            <tablecell>
+               <paragraph xml-lang="en-US" id="par_id3154368" role="paragraph" l10n="U" oldref="17">A mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, <switchinline select="sys"><caseinline select="MAC">Command
+</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-click the cells.</paragraph>
+            </tablecell>
+         </tablerow>
+      </table>
 
-<section id="relatedtopics">
-<paragraph role="paragraph" id="par_id3154487" xml-lang="en-US" l10n="U" oldref="18"><link href="text/scalc/main0208.xhp" name="Status bar">Status bar</link></paragraph>
-</section>
-</body>
-</helpdocument>
+      <section id="relatedtopics">
+         <paragraph xml-lang="en-US" id="par_id3154487" role="paragraph" l10n="U" oldref="18"><link href="text/scalc/main0208.xhp" name="Status bar">Status bar</link></paragraph>
+      </section>
+   </body>
+</helpdocument>
\ No newline at end of file
diff --git a/helpcontent2/source/text/scalc/guide/note_insert.xhp b/helpcontent2/source/text/scalc/guide/note_insert.xhp
index a06b85a258..32644ced09 100755
--- a/helpcontent2/source/text/scalc/guide/note_insert.xhp
+++ b/helpcontent2/source/text/scalc/guide/note_insert.xhp
@@ -1,7 +1,8 @@
 <?xml version="1.0" encoding="UTF-8"?>
-
-
-<!--***********************************************************************
+<helpdocument version="1.0">
+	
+<!--
+***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
  * 
@@ -9,8 +10,8 @@
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
- * $RCSfile: note_insert.xhp,v $
- * $Revision: 1.9 $
+ * $RCSfile: soffice2xmlhelp.xsl,v $
+ * $Revision: 1.12 $
  *
  * This file is part of OpenOffice.org.
  *
@@ -29,56 +30,52 @@
  * <http://www.openoffice.org/license.html>
  * for a copy of the LGPLv3 License.
  *
- ************************************************************************-->
-
-
+ ************************************************************************
+ -->
+ 
 	
-<helpdocument version="1.0">
 <meta>
-<topic id="textscalcguidenote_insertxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Inserting and Editing Comments</title>
-<filename>/text/scalc/guide/note_insert.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2006-01-17T12:10:26">converted from old format - fpe</lastedited>
-</history>
-</meta>
-<body>
+      <topic id="textscalcguidenote_insertxml" indexer="include" status="PUBLISH">
+         <title xml-lang="en-US" id="tit">Inserting and Editing Comments</title>
+         <filename>/text/scalc/guide/note_insert.xhp</filename>
+      </topic>
+   </meta>
+   <body>
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153968"><bookmark_value>comments; on cells</bookmark_value>
-<bookmark_value>cells;comments</bookmark_value>
-<bookmark_value>comments; on cells</bookmark_value>
-<bookmark_value>remarks on cells</bookmark_value>
-<bookmark_value>formatting;comments on cells</bookmark_value>
-<bookmark_value>viewing;comments on cells</bookmark_value>
+      <bookmark_value>cells;comments</bookmark_value>
+      <bookmark_value>comments; on cells</bookmark_value>
+      <bookmark_value>remarks on cells</bookmark_value>
+      <bookmark_value>formatting;comments on cells</bookmark_value>
+      <bookmark_value>viewing;comments on cells</bookmark_value>
 </bookmark>
-<paragraph role="heading" id="hd_id3153968" xml-lang="en-US" level="1" l10n="U" oldref="31"><variable id="note_insert"><link href="text/scalc/guide/note_insert.xhp" name="Inserting and Editing Comments">Inserting and Editing Comments</link>
+<paragraph xml-lang="en-US" id="hd_id3153968" role="heading" level="1" l10n="U"
+                 oldref="31"><variable id="note_insert"><link href="text/scalc/guide/note_insert.xhp" name="Inserting and Editing Comments">Inserting and Editing Comments</link>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150440" xml-lang="en-US" l10n="U" oldref="32">You can assign a comment to each cell by choosing <link href="text/shared/01/04050000.xhp" name="Insert - Comment"><emph>Insert - Comment</emph></link>. The comment is indicated by a small red square, the comment indicator, in the cell.</paragraph>
-<list type="unordered">
-<listitem>
-<paragraph role="listitem" id="par_id3145750" xml-lang="en-US" l10n="U" oldref="34">The comment is visible whenever the mouse pointer is over the cell, provided you have activated <emph>Help - Tips</emph> or - <emph>Extended Tips</emph>.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="33">When you select the cell, you can choose <emph>Show Comment</emph> from the context menu of the cell. Doing so keeps the comment visible until you deactivate the <emph>Show Comment</emph> command from the same context menu.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3149958" xml-lang="en-US" l10n="U" oldref="35">To edit a permanently visible comment, just click in it. If you delete the entire text of the comment, the comment itself is deleted.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_idN10699" xml-lang="en-US" l10n="NEW">Move or resize each comment as you like.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_idN1069D" xml-lang="en-US" l10n="NEW">Format each comment by specifying background color, transparency, border style, and text alignment. Choose the commands from the context menu of the comment.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3144764" xml-lang="en-US" l10n="U" oldref="38">To show or hide the comment indicator, choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph> and mark or unmark the <emph>Comment indicator</emph> check box.</paragraph>
-</listitem>
-</list>
-<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U" oldref="39">To display a help tip for a selected cell, use <emph>Data - Validity - Input Help</emph>.</paragraph>
-<section id="relatedtopics">
-<paragraph role="paragraph" id="par_id3153707" xml-lang="en-US" l10n="U" oldref="36"><link href="text/shared/01/04050000.xhp" name="Insert - Comment">Insert - Comment</link></paragraph>
-<embed href="text/scalc/guide/validity.xhp#validity"/>
-</section>
-</body>
-</helpdocument>
+      <paragraph xml-lang="en-US" id="par_id3150440" role="paragraph" l10n="U" oldref="32">You can assign a comment to each cell by choosing <link href="text/shared/01/04050000.xhp" name="Insert - Comment"><emph>Insert - Comment</emph></link>. The comment is indicated by a small red square, the comment indicator, in the cell.</paragraph>
+      <list type="unordered">
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id3145750" role="listitem" l10n="CHG" oldref="34">The comment is visible whenever the mouse pointer is over the cell, if you did enable tips under <emph>Tools - Options - %PRODUCTNAME - General</emph>.</paragraph>
+         </listitem>
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id3148575" role="listitem" l10n="U" oldref="33">When you select the cell, you can choose <emph>Show Comment</emph> from the context menu of the cell. Doing so keeps the comment visible until you deactivate the <emph>Show Comment</emph> command from the same context menu.</paragraph>
+         </listitem>
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id3149958" role="listitem" l10n="U" oldref="35">To edit a permanently visible comment, just click in it. If you delete the entire text of the comment, the comment itself is deleted.</paragraph>
+         </listitem>
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_idN10699" role="listitem" l10n="NEW">Move or resize each comment as you like.</paragraph>
+         </listitem>
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_idN1069D" role="listitem" l10n="NEW">Format each comment by specifying background color, transparency, border style, and text alignment. Choose the commands from the context menu of the comment.</paragraph>
+         </listitem>
+         <listitem>
+            <paragraph xml-lang="en-US" id="par_id3144764" role="listitem" l10n="U" oldref="38">To show or hide the comment indicator, choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph> and mark or unmark the <emph>Comment indicator</emph> check box.</paragraph>
+         </listitem>
+      </list>
+      <paragraph xml-lang="en-US" id="par_id3150715" role="paragraph" l10n="U" oldref="39">To display a help tip for a selected cell, use <emph>Data - Validity - Input Help</emph>.</paragraph>
+      <section id="relatedtopics">
+         <paragraph xml-lang="en-US" id="par_id3153707" role="paragraph" l10n="U" oldref="36"><link href="text/shared/01/04050000.xhp" name="Insert - Comment">Insert - Comment</link></paragraph>
+         <embed href="text/scalc/guide/validity.xhp#validity"/>
+      </section>
+   </body>
+</helpdocument>
\ No newline at end of file