native0: branding Help - transplanted from 9dbf1800d8b2@native0

5 files changed, 17 insertions, 18 deletions

diff --git a/helpcontent2/source/text/scalc/01/04060110.xhp b/helpcontent2/source/text/scalc/01/04060110.xhp
index 3f04ed4a66..09aaa74e49 100644
--- a/helpcontent2/source/text/scalc/01/04060110.xhp
+++ b/helpcontent2/source/text/scalc/01/04060110.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="textscalc0104060110xml" indexer="include">
          <title xml-lang="en-US" id="tit">Text Functions</title>
@@ -43,7 +43,7 @@
       <bookmark_value>Function Wizard;text</bookmark_value>
 </bookmark>
 <paragraph xml-lang="en-US" id="hd_id3145389" role="heading" level="1" l10n="U" oldref="1">Text Functions</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3152986" role="paragraph" l10n="CHG" oldref="2"><variable id="texttext">This section contains descriptions of the <emph>Text</emph> functions. 
+      <paragraph xml-lang="en-US" id="par_id3152986" role="paragraph" l10n="CHG" oldref="2"><variable id="texttext">This section contains descriptions of the <emph>Text</emph> functions.
 </variable></paragraph>
       <section id="howtoget">
          <embed href="text/scalc/00/00000404.xhp#eikatext"/>
@@ -254,7 +254,7 @@
          <paragraph xml-lang="en-US" id="hd_id3149777" role="heading" level="3" l10n="U"
                     oldref="84">Example</paragraph>
          <paragraph xml-lang="en-US" id="par_id3156263" role="paragraph" l10n="U" oldref="85">
-            <item type="input">=EXACT("Sun microsystems";"Sun Microsystems")</item> returns FALSE.</paragraph>
+            <item type="input">=EXACT("microsystems";"Microsystems")</item> returns FALSE.</paragraph>
       </section>
       <section id="find">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3152589"><bookmark_value>FIND function</bookmark_value>
@@ -387,7 +387,7 @@
          <paragraph xml-lang="en-US" id="hd_id3150509" role="heading" level="3" l10n="U"
                     oldref="155">Example</paragraph>
          <paragraph xml-lang="en-US" id="par_id3158407" role="paragraph" l10n="U" oldref="156">
-            <item type="input">=MID("Sun Microsystems";5;5)</item> returns Micro.</paragraph>
+            <item type="input">=MID("office";2;2)</item> returns ff.</paragraph>
       </section>
       <section id="proper">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3159143"><bookmark_value>PROPER function</bookmark_value>
@@ -404,7 +404,7 @@
          <paragraph xml-lang="en-US" id="hd_id3147529" role="heading" level="3" l10n="U"
                     oldref="75">Example</paragraph>
          <paragraph xml-lang="en-US" id="par_id3155364" role="paragraph" l10n="U" oldref="76">
-            <item type="input">=PROPER("sun microsystems")</item> returns Sun Microsystems.</paragraph>
+            <item type="input">=PROPER("open office")</item> returns Open Office.</paragraph>
       </section>
       <section id="replace">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149171"><bookmark_value>REPLACE function</bookmark_value>
diff --git a/helpcontent2/source/text/scalc/01/04060199.xhp b/helpcontent2/source/text/scalc/01/04060199.xhp
index f9b8194d72..138c768fac 100755..100644
--- a/helpcontent2/source/text/scalc/01/04060199.xhp
+++ b/helpcontent2/source/text/scalc/01/04060199.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
@@ -305,6 +305,6 @@
 </tablecell>
 </tablerow>
 </table>
-<paragraph role="note" id="par_id181890" xml-lang="en-US" l10n="NEW">Reference concatenation using a tilde character is a new operator, available starting with OpenOffice.org 3.0 and StarOffice 9. When a formula with the tilde operator exists in a document that is opened in previous versions of the software, an error is returned. A reference list is not allowed inside an array expression.</paragraph>
+<paragraph role="note" id="par_id181890" xml-lang="en-US" l10n="NEW">Reference concatenation using a tilde character was implemented lately. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression.</paragraph>
 </body>
 </helpdocument>
diff --git a/helpcontent2/source/text/scalc/01/12080700.xhp b/helpcontent2/source/text/scalc/01/12080700.xhp
index 4d845d14cc..06a1436c1b 100644
--- a/helpcontent2/source/text/scalc/01/12080700.xhp
+++ b/helpcontent2/source/text/scalc/01/12080700.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,7 +46,6 @@
 </section>
 <section id="howtoget">
   <embed href="text/scalc/00/00000412.xhp#dngdrill"/>
-</section><comment>see http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_drill-down_on_data_field</comment><comment>For instance, when the data field function is selected to be SUM, then the number that is shown in the data field cell must be identical to the sum of all the data field values in the constituent rows displayed in the inserted sheet. 
-UFI: this text from spec doc looks like a remark to the developer who implements this feature rather than something for the user</comment><paragraph role="note" id="par_id7132480" xml-lang="en-US" l10n="NEW">Hidden items are not evaluated, the rows for the hidden items are included. Show Details is available only for DataPilot tables that are based on cell ranges or database data.</paragraph>
+</section><paragraph role="note" id="par_id7132480" xml-lang="en-US" l10n="NEW">Hidden items are not evaluated, the rows for the hidden items are included. Show Details is available only for DataPilot tables that are based on cell ranges or database data.</paragraph>
 </body>
 </helpdocument>
diff --git a/helpcontent2/source/text/scalc/01/func_weeknum.xhp b/helpcontent2/source/text/scalc/01/func_weeknum.xhp
index 531aa558b8..133b958a42 100644
--- a/helpcontent2/source/text/scalc/01/func_weeknum.xhp
+++ b/helpcontent2/source/text/scalc/01/func_weeknum.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
@@ -45,7 +45,7 @@
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_KALENDERWOCHE" id="bm_id3158403" localize="false"/><paragraph role="heading" id="hd_id3159161" xml-lang="en-US" level="2" l10n="U" oldref="54"><variable id="weeknum"><link href="text/scalc/01/func_weeknum.xhp">WEEKNUM</link>
 </variable></paragraph>
 <paragraph role="paragraph" id="par_id3149770" xml-lang="en-US" l10n="U" oldref="55"><ahelp hid="HID_FUNC_KALENDERWOCHE">WEEKNUM calculates the week number of the year for the internal date value.</ahelp></paragraph>
-<paragraph role="note" id="par_idN105E4" xml-lang="en-US" l10n="NEW">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.<comment>UFI: see http://www.openoffice.org/issues/show_bug.cgi?id=33709</comment></paragraph>
+<paragraph role="note" id="par_idN105E4" xml-lang="en-US" l10n="NEW">The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th.</paragraph>
 <paragraph role="heading" id="hd_id3153055" xml-lang="en-US" level="3" l10n="U" oldref="56">Syntax</paragraph>
 <paragraph role="code" id="par_id3147236" xml-lang="en-US" l10n="U" oldref="57">WEEKNUM(Number; Mode)</paragraph>
 <paragraph role="paragraph" id="par_id3147511" xml-lang="en-US" l10n="U" oldref="58">
diff --git a/helpcontent2/source/text/scalc/05/empty_cells.xhp b/helpcontent2/source/text/scalc/05/empty_cells.xhp
index 10df6fb614..774afb4bc9 100644
--- a/helpcontent2/source/text/scalc/05/empty_cells.xhp
+++ b/helpcontent2/source/text/scalc/05/empty_cells.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
@@ -43,8 +43,8 @@
 <bookmark xml-lang="en-US" branch="index" id="bm_id3146799"><bookmark_value>empty cells;handling of</bookmark_value>
 </bookmark><comment>i86303</comment><paragraph role="heading" id="hd_id1502121" xml-lang="en-US" level="1" l10n="NEW"><variable id="empty_cells"><link href="text/scalc/05/empty_cells.xhp">Handling of Empty Cells</link>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id2871181" xml-lang="en-US" l10n="NEW">Starting with OpenOffice.org 3.0 and StarOffice 9, the handling of empty cells got changed.</paragraph>
-<paragraph role="paragraph" id="par_id8266853" xml-lang="en-US" l10n="NEW">Previously, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1="" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)="" give TRUE if the lookup resulted in an empty cell being returned. </paragraph>
+
+<paragraph role="paragraph" id="par_id8266853" xml-lang="en-US" l10n="NEW">In older versions of the software, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1="" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)="" give TRUE if the lookup resulted in an empty cell being returned. </paragraph>
 <paragraph role="paragraph" id="par_id2733542" xml-lang="en-US" l10n="NEW">A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected. </paragraph>
 <paragraph role="paragraph" id="par_id4238715" xml-lang="en-US" l10n="NEW">For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:</paragraph>
 <paragraph role="code" id="par_id8277230" xml-lang="en-US" l10n="NEW">A1: 1 B1: &lt;empty&gt; C1: =B1 (displays 0)</paragraph>