hcshared25: intermediate commit

3 files changed, 18 insertions, 16 deletions

diff --git a/helpcontent2/source/text/scalc/01/func_eomonth.xhp b/helpcontent2/source/text/scalc/01/func_eomonth.xhp
index bcbb83d362..b0f81f7d2c 100644
--- a/helpcontent2/source/text/scalc/01/func_eomonth.xhp
+++ b/helpcontent2/source/text/scalc/01/func_eomonth.xhp
@@ -6,7 +6,7 @@
  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2008 by Sun Microsystems, Inc.
  *
  * OpenOffice.org - a multi-platform office productivity suite
@@ -56,7 +56,9 @@
 <emph>Months</emph> is the number of months before (negative) or after (positive) the start date.</paragraph>
 <paragraph role="heading" id="hd_id3156335" xml-lang="en-US" level="3" l10n="U" oldref="237">Example</paragraph>
 <paragraph role="paragraph" id="par_id3154829" xml-lang="en-US" l10n="U" oldref="238">What is the last day of the month that falls 6 months after September 14 2001?</paragraph>
-<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US" l10n="U" oldref="239">
-<item type="input">=EOMONTH(9.14.2001;6)</item> returns 3.31.2002.</paragraph>
+
+<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US" l10n="U" oldref="239"><item type="input">=EOMONTH(DATE(2001;9;14);6)</item> returns the serial number 37346. Formatted as a date, this is 2002-03-31.</paragraph>
+<paragraph role="paragraph" id="par_id3156144" xml-lang="en-US" l10n="U" oldref="239"><item type="input">=EOMONTH("2001-09-14";6)</item> works as well. If the date is given as string, it has to be in ISO format.</paragraph>
+
 </body>
 </helpdocument>
diff --git a/helpcontent2/source/text/scalc/01/func_minute.xhp b/helpcontent2/source/text/scalc/01/func_minute.xhp
index ba3957343d..4d0bdaceb2 100644
--- a/helpcontent2/source/text/scalc/01/func_minute.xhp
+++ b/helpcontent2/source/text/scalc/01/func_minute.xhp
@@ -6,7 +6,7 @@
  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2008 by Sun Microsystems, Inc.
  *
  * OpenOffice.org - a multi-platform office productivity suite
@@ -47,7 +47,7 @@
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_MINUTE" id="bm_id3148616" localize="false"/><paragraph role="heading" id="hd_id3149803" xml-lang="en-US" level="2" l10n="U" oldref="66"><variable id="minute"><link href="text/scalc/01/func_minute.xhp">MINUTE</link>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3148988" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_MINUTE">Calculates the minute for an internal time value</ahelp> The minute is returned as a number between 0 and 59.</paragraph>
+<paragraph role="paragraph" id="par_id3148988" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_FUNC_MINUTE">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59.</paragraph>
 <paragraph role="heading" id="hd_id3154343" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph>
 <paragraph role="code" id="par_id3148660" xml-lang="en-US" l10n="U" oldref="69">MINUTE(Number)</paragraph>
 <paragraph role="paragraph" id="par_id3154611" xml-lang="en-US" l10n="U" oldref="70">
diff --git a/helpcontent2/source/text/scalc/04/01020000.xhp b/helpcontent2/source/text/scalc/04/01020000.xhp
index 5babb060de..934bef74de 100755
--- a/helpcontent2/source/text/scalc/04/01020000.xhp
+++ b/helpcontent2/source/text/scalc/04/01020000.xhp
@@ -6,7 +6,7 @@
  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2008 by Sun Microsystems, Inc.
  *
  * OpenOffice.org - a multi-platform office productivity suite
@@ -51,11 +51,11 @@
 </variable></paragraph>
 <embed href="text/shared/00/00000099.xhp#keys"/>
 </section>
-<paragraph role="paragraph" id="par_id3155067" xml-lang="en-US" l10n="U" oldref="3">To fill a selected cell range with the formula that you entered on the <emph>Input line</emph>, press <switchinline select="sys"><caseinline select="MAC">Option 
-</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter. Hold down <switchinline select="sys"><caseinline select="MAC">Option 
+<paragraph role="paragraph" id="par_id3155067" xml-lang="en-US" l10n="U" oldref="3">To fill a selected cell range with the formula that you entered on the <emph>Input line</emph>, press <switchinline select="sys"><caseinline select="MAC">Option
+</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter. Hold down <switchinline select="sys"><caseinline select="MAC">Option
 </caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter+Shift to apply the cell format of the input cell to the entire cell range.</paragraph>
 <paragraph role="paragraph" id="par_id3153967" xml-lang="en-US" l10n="U" oldref="84">To create a matrix in which all the cells contain the same information as what you entered on the <emph>Input line</emph>, press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter. You cannot edit the components of the matrix.</paragraph>
-<paragraph role="paragraph" id="par_id3166426" xml-lang="en-US" l10n="U" oldref="4">To select multiple cells in different areas of a sheet, hold down <switchinline select="sys"><caseinline select="MAC">Command 
+<paragraph role="paragraph" id="par_id3166426" xml-lang="en-US" l10n="U" oldref="4">To select multiple cells in different areas of a sheet, hold down <switchinline select="sys"><caseinline select="MAC">Command
 </caseinline><defaultinline>Ctrl </defaultinline></switchinline>and drag in the different areas.</paragraph>
 <paragraph role="paragraph" id="par_id3150207" xml-lang="en-US" l10n="U" oldref="127">To select multiple sheets in a spreadsheet, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, and then click the name tabs at the lower edge of the workspace. To select only one sheet in a selection, hold down Shift, and then click the name tab of the sheet.</paragraph>
 <paragraph role="paragraph" id="par_id3166432" xml-lang="en-US" l10n="U" oldref="129">To insert a manual line break in a cell, click in the cell, and then press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter.</paragraph>
@@ -164,7 +164,7 @@
 </tablerow>
 <tablerow>
 <tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="hd_id3146885" xml-lang="en-US" l10n="U" oldref="113"><switchinline select="sys"><caseinline select="MAC">Option 
+<paragraph role="tablecontent" id="hd_id3146885" xml-lang="en-US" l10n="U" oldref="113"><switchinline select="sys"><caseinline select="MAC">Option
 </caseinline><defaultinline>Alt</defaultinline></switchinline> + Page Up</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
@@ -173,7 +173,7 @@
 </tablerow>
 <tablerow>
 <tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="hd_id3149013" xml-lang="en-US" l10n="U" oldref="115"><switchinline select="sys"><caseinline select="MAC">Option 
+<paragraph role="tablecontent" id="hd_id3149013" xml-lang="en-US" l10n="U" oldref="115"><switchinline select="sys"><caseinline select="MAC">Option
 </caseinline><defaultinline>Alt</defaultinline></switchinline> + Page Down</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
@@ -335,7 +335,7 @@
 </tablerow>
 <tablerow>
 <tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="hd_id3148430" xml-lang="en-US" l10n="U" oldref="27"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F5</paragraph>
+<paragraph role="tablecontent" id="hd_id3148430" xml-lang="en-US" l10n="U" oldref="27">Shift+F7</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
 <paragraph role="tablecontent" id="par_id3153179" xml-lang="en-US" l10n="U" oldref="28">Traces precedents.</paragraph>
@@ -447,7 +447,7 @@
 </tablerow>
 <tablerow>
 <tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="hd_id3151264" xml-lang="en-US" l10n="U" oldref="117"><switchinline select="sys"><caseinline select="MAC">Option 
+<paragraph role="tablecontent" id="hd_id3151264" xml-lang="en-US" l10n="U" oldref="117"><switchinline select="sys"><caseinline select="MAC">Option
 </caseinline><defaultinline>Alt</defaultinline></switchinline> + Down Arrow</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
@@ -456,7 +456,7 @@
 </tablerow>
 <tablerow>
 <tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="hd_id3151297" xml-lang="en-US" l10n="U" oldref="119"><switchinline select="sys"><caseinline select="MAC">Option 
+<paragraph role="tablecontent" id="hd_id3151297" xml-lang="en-US" l10n="U" oldref="119"><switchinline select="sys"><caseinline select="MAC">Option
 </caseinline><defaultinline>Alt</defaultinline></switchinline> + Up Arrow</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
@@ -465,7 +465,7 @@
 </tablerow>
 <tablerow>
 <tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="hd_id3155997" xml-lang="en-US" l10n="U" oldref="121"><switchinline select="sys"><caseinline select="MAC">Option 
+<paragraph role="tablecontent" id="hd_id3155997" xml-lang="en-US" l10n="U" oldref="121"><switchinline select="sys"><caseinline select="MAC">Option
 </caseinline><defaultinline>Alt</defaultinline></switchinline> + Right Arrow</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
@@ -474,7 +474,7 @@
 </tablerow>
 <tablerow>
 <tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="hd_id3154046" xml-lang="en-US" l10n="U" oldref="123"><switchinline select="sys"><caseinline select="MAC">Option 
+<paragraph role="tablecontent" id="hd_id3154046" xml-lang="en-US" l10n="U" oldref="123"><switchinline select="sys"><caseinline select="MAC">Option
 </caseinline><defaultinline>Alt</defaultinline></switchinline> + Left Arrow</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">