diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2008-01-24 12:49:30 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2008-01-24 12:49:30 +0000 |
| commit | 6a34669b0af18125dd7ebfdefbe3c26dd61595d6 (patch) | |
| tree | cc484366133e59b4c45269707ee60c2096142311 | |
| parent | 6943abd0025a027e44faf20702efdbcf087d6eae (diff) | |
INTEGRATION: CWS hcshared15 (1.7.144); FILE MERGED
2007/12/18 12:12:14 ufi 1.7.144.1: saving
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060102.xhp | 30 |
1 files changed, 12 insertions, 18 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060102.xhp b/helpcontent2/source/text/scalc/01/04060102.xhp index 323964fb8b..143aba9f10 100644 --- a/helpcontent2/source/text/scalc/01/04060102.xhp +++ b/helpcontent2/source/text/scalc/01/04060102.xhp @@ -1,14 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> + <!-- *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 04060102.xhp,v $ + * $RCSfile: 04060102.xhp,v $fileonly,v $ * - * $Revision: 1.7 $ + * $Revision: 1.8 $ * - * last change: $Author: ihi $ $Date: 2006-06-29 09:38:28 $ + * last change: $Author: vg $ $Date: 2008-01-24 13:49:30 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -35,18 +36,14 @@ * ************************************************************************ --> - -<helpdocument version="1.0"> + + + <helpdocument version="1.0"> <meta> <topic id="textscalc0104060102xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Date & Time Functions</title> <filename>/text/scalc/01/04060102.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-02-16T15:09:18">converted from old format - fpe -YJ: checked</lastedited> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154536"><bookmark_value>date and time functions</bookmark_value> @@ -78,7 +75,7 @@ YJ: checked</lastedited> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id6794030" xml-lang="en-US" l10n="NEW">'12/30/99'</paragraph> +<paragraph role="tablecontent" id="par_id6794030" xml-lang="en-US" l10n="NEW">12/30/1899</paragraph> </tablecell> <tablecell colspan="" rowspan=""> <paragraph role="tablecontent" id="par_id7096774" xml-lang="en-US" l10n="NEW">(default)</paragraph> @@ -86,7 +83,7 @@ YJ: checked</lastedited> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id5699942" xml-lang="en-US" l10n="NEW">'01/01/00'</paragraph> +<paragraph role="tablecontent" id="par_id5699942" xml-lang="en-US" l10n="NEW">01/01/1900</paragraph> </tablecell> <tablecell colspan="" rowspan=""> <paragraph role="tablecontent" id="par_id6420484" xml-lang="en-US" l10n="NEW">(used in former StarCalc 1.0)</paragraph> @@ -94,22 +91,20 @@ YJ: checked</lastedited> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id6986602" xml-lang="en-US" l10n="NEW">'01/01/04'</paragraph> +<paragraph role="tablecontent" id="par_id6986602" xml-lang="en-US" l10n="NEW">01/01/1904</paragraph> </tablecell> <tablecell colspan="" rowspan=""> <paragraph role="tablecontent" id="par_id616779" xml-lang="en-US" l10n="NEW">(used in Apple software)</paragraph> </tablecell> </tablerow> </table> - <paragraph role="paragraph" id="par_id791039" xml-lang="en-US" l10n="NEW">Choose <emph>Tools - Options - %PRODUCTNAME Calc - Calculate</emph> to select the date base.</paragraph> <paragraph role="warning" id="par_id1953489" xml-lang="en-US" l10n="NEW">When you copy and paste cells containing date values between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!</paragraph> <paragraph role="heading" id="hd_id757469" xml-lang="en-US" level="2" l10n="NEW">Two digits years</paragraph> <paragraph role="paragraph" id="par_id3149720" xml-lang="en-US" l10n="U" oldref="183">In <emph>Tools - Options - $[officename] - General</emph> you find the area <emph>Year (two digits)</emph>. This sets the period for which two-digit information applies. Note that changes made here have an effect on some of the following functions.</paragraph> <paragraph role="note" id="par_id3150654" xml-lang="en-US" l10n="U" oldref="185">When entering dates, slashes or dashes used as date separators may be interpreted as arithmetic operators. Therefore, dates entered in this format are not always recognized as dates and result in erroneous calculations. To keep dates from being interpreted as parts of formulas, place them in quotation marks, for example, "07/20/54".</paragraph> <paragraph role="heading" id="par_idN1067A" xml-lang="en-US" level="2" l10n="NEW">Functions</paragraph> -<sort order="asc"> -<section id="workday"> +<sort order="asc"><section id="workday"> <paragraph role="paragraph" id="par_idN10683" xml-lang="en-US" l10n="NEW"> <embedvar href="text/scalc/01/func_workday.xhp#workday"/> </paragraph> @@ -224,6 +219,5 @@ YJ: checked</lastedited> <embedvar href="text/scalc/01/func_timevalue.xhp#timevalue"/> </paragraph> </section> -</sort> -</body> +</sort></body> </helpdocument> |