summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/01
diff options
context:
space:
mode:
authorUwe Fischer <ufi@openoffice.org>2009-10-16 09:01:02 +0000
committerUwe Fischer <ufi@openoffice.org>2009-10-16 09:01:02 +0000
commitc17ce7625aaff3a47958fa17f6b832bcd1018aca (patch)
treeffb86a9b4d19b251e2921e1507ef106b3534317d /helpcontent2/source/text/scalc/01
parent8697c1feab99e674b7fab543a89a90f37e6665e1 (diff)
Zwischenstand
Diffstat (limited to 'helpcontent2/source/text/scalc/01')
-rw-r--r--helpcontent2/source/text/scalc/01/02140600.xhp2
-rw-r--r--helpcontent2/source/text/scalc/01/04060102.xhp4
-rw-r--r--helpcontent2/source/text/scalc/01/05070500.xhp2
-rw-r--r--helpcontent2/source/text/scalc/01/func_date.xhp2
-rw-r--r--helpcontent2/source/text/scalc/01/func_weekday.xhp2
5 files changed, 6 insertions, 6 deletions
diff --git a/helpcontent2/source/text/scalc/01/02140600.xhp b/helpcontent2/source/text/scalc/01/02140600.xhp
index 376d2117ac..25380d19c5 100644
--- a/helpcontent2/source/text/scalc/01/02140600.xhp
+++ b/helpcontent2/source/text/scalc/01/02140600.xhp
@@ -80,7 +80,7 @@
<paragraph role="paragraph" id="par_id3150887" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DATE">Creates a date series using the defined increment and end date.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL" id="bm_id3152985" localize="false"/>
<paragraph role="heading" id="hd_id3150202" xml-lang="en-US" level="3" l10n="U" oldref="22">AutoFill</paragraph>
-<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="U" oldref="23"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL">Forms a series directly in the sheet.</ahelp> The AutoFill function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <emph>Tools - Options - %PRODUCTNAME Calc - Sort Lists</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3156288" xml-lang="en-US" l10n="U" oldref="23"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL">Forms a series directly in the sheet.</ahelp> The AutoFill function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists</emph>.</paragraph>
<paragraph role="paragraph" id="par_id3155811" xml-lang="en-US" l10n="U" oldref="24">AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used.</paragraph>
<paragraph role="paragraph" id="par_id2956483" xml-lang="en-US" l10n="NEW" localize="false">
<embedvar href="text/scalc/guide/calc_series.xhp#calc_series"/>
diff --git a/helpcontent2/source/text/scalc/01/04060102.xhp b/helpcontent2/source/text/scalc/01/04060102.xhp
index 4a02eaeaba..5d29ae02d7 100644
--- a/helpcontent2/source/text/scalc/01/04060102.xhp
+++ b/helpcontent2/source/text/scalc/01/04060102.xhp
@@ -92,10 +92,10 @@
</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="paragraph" id="par_id791039" xml-lang="en-US" l10n="NEW">Choose <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %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="paragraph" id="par_id3149720" xml-lang="en-US" l10n="U" oldref="183">In <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - $[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">
diff --git a/helpcontent2/source/text/scalc/01/05070500.xhp b/helpcontent2/source/text/scalc/01/05070500.xhp
index 17b11f38d4..8e5e10a79c 100644
--- a/helpcontent2/source/text/scalc/01/05070500.xhp
+++ b/helpcontent2/source/text/scalc/01/05070500.xhp
@@ -58,7 +58,7 @@
<bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_HEADER" id="bm_id3150767" localize="false"/><paragraph role="heading" id="hd_id3151041" xml-lang="en-US" level="3" l10n="U" oldref="5">Column and row headers</paragraph>
<paragraph role="paragraph" id="par_id3147228" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_HEADER">Specifies whether you want the column and row headers to be printed.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_GRID" id="bm_id3154320" localize="false"/><paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="3" l10n="U" oldref="7">Grid</paragraph>
-<paragraph role="paragraph" id="par_id3147436" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_GRID">Prints out the borders of the individual cells as a grid.</ahelp> For the view on screen, make your choice under <emph>Tools - Options - %PRODUCTNAME Calc</emph> - <link href="text/shared/optionen/01060100.xhp" name="View"><emph>View</emph></link> - <emph>Grid lines</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3147436" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_GRID">Prints out the borders of the individual cells as a grid.</ahelp> For the view on screen, make your choice under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc</emph> - <link href="text/shared/optionen/01060100.xhp" name="View"><emph>View</emph></link> - <emph>Grid lines</emph>.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_NOTES" id="bm_id3159153" localize="false"/><paragraph role="heading" id="hd_id3145750" xml-lang="en-US" level="3" l10n="U" oldref="9">Comments</paragraph>
<paragraph role="paragraph" id="par_id3150010" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_NOTES">Prints the comments defined in your spreadsheet.</ahelp> They will be printed on a separate page, along with the corresponding cell reference.</paragraph>
<bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_OBJECTS" id="bm_id3144764" localize="false"/><paragraph role="heading" id="hd_id3154944" xml-lang="en-US" level="3" l10n="U" oldref="11">Objects/graphics</paragraph>
diff --git a/helpcontent2/source/text/scalc/01/func_date.xhp b/helpcontent2/source/text/scalc/01/func_date.xhp
index 96f41f517d..6a32c0e1ba 100644
--- a/helpcontent2/source/text/scalc/01/func_date.xhp
+++ b/helpcontent2/source/text/scalc/01/func_date.xhp
@@ -52,7 +52,7 @@
<paragraph role="code" id="par_id3150474" xml-lang="en-US" l10n="U" oldref="6">DATE(Year; Month; Day)</paragraph>
<paragraph role="paragraph" id="par_id3152815" xml-lang="en-US" l10n="CHG" oldref="7">
<emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99.</paragraph>
-<paragraph role="paragraph" id="par_id3153222" xml-lang="en-US" l10n="U" oldref="174">In <item type="menuitem">Tools - Options - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx.</paragraph>
+<paragraph role="paragraph" id="par_id3153222" xml-lang="en-US" l10n="U" oldref="174">In <item type="menuitem"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx.</paragraph>
<paragraph role="paragraph" id="par_id3155817" xml-lang="en-US" l10n="CHG" oldref="8">
<emph>Month</emph> is an integer indicating the month.</paragraph>
<paragraph role="paragraph" id="par_id3153183" xml-lang="en-US" l10n="CHG" oldref="9">
diff --git a/helpcontent2/source/text/scalc/01/func_weekday.xhp b/helpcontent2/source/text/scalc/01/func_weekday.xhp
index 494d2fcb00..ceb465dc34 100644
--- a/helpcontent2/source/text/scalc/01/func_weekday.xhp
+++ b/helpcontent2/source/text/scalc/01/func_weekday.xhp
@@ -54,7 +54,7 @@
<emph>Number</emph>, as a date value, is a decimal for which the weekday is to be returned.</paragraph>
<paragraph role="paragraph" id="par_id3154394" xml-lang="en-US" l10n="U" oldref="141">
<emph>Type</emph> determines the type of calculation. For Type=1, the weekdays are counted starting from Sunday (this is the default even when the Type parameter is missing). For Type=2, the weekdays are counted starting from Monday=1. For Type=3, the weekdays are counted starting from Monday=0.</paragraph>
-<paragraph role="note" id="par_id3156188" xml-lang="en-US" l10n="U" oldref="142">These values apply only to the standard date format that you select under <emph>Tools - Options - %PRODUCTNAME Calc - Calculate</emph>.</paragraph>
+<paragraph role="note" id="par_id3156188" xml-lang="en-US" l10n="U" oldref="142">These values apply only to the standard date format that you select under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Calculate</emph>.</paragraph>
<paragraph role="heading" id="hd_id3153836" xml-lang="en-US" level="3" l10n="U" oldref="143">Examples</paragraph>
<paragraph role="paragraph" id="par_id3150317" xml-lang="en-US" l10n="CHG" oldref="144">=WEEKDAY("2000-06-14") returns 4 (the Type parameter is missing, therefore the standard count is used. The standard count starts with Sunday as day number 1. June 14, 2000 was a Wednesday and therefore day number 4).</paragraph>
<paragraph role="paragraph" id="par_id3153174" xml-lang="en-US" l10n="CHG" oldref="145">=WEEKDAY("1996-07-24";2) returns 3 (the Type parameter is 2, therefore Monday is day number 1. July 24, 1996 was a Wednesday and therefore day number 3).</paragraph>