diff options
Diffstat (limited to 'helpcontent2/source/text/scalc')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060110.xhp | 16 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060199.xhp | 4 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/12080700.xhp | 5 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/01/func_weeknum.xhp | 4 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/05/empty_cells.xhp | 6 |
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 94801039de..e2b1cd1f4a 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 2008 by Sun Microsystems, Inc. * * OpenOffice.org - a multi-platform office productivity suite @@ -32,8 +32,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalc0104060110xml" indexer="include"> <title xml-lang="en-US" id="tit">Text Functions</title> @@ -46,7 +46,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"/> @@ -257,7 +257,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> @@ -390,7 +390,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> @@ -407,7 +407,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 931f123877..3226988959 100755 --- 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 2008 by Sun Microsystems, Inc. * * OpenOffice.org - a multi-platform office productivity suite @@ -308,6 +308,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 301b586922..d147901766 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 2008 by Sun Microsystems, Inc. * * OpenOffice.org - a multi-platform office productivity suite @@ -49,7 +49,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 284f873c60..298ee81519 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 2008 by Sun Microsystems, Inc. * * OpenOffice.org - a multi-platform office productivity suite @@ -48,7 +48,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 0141b2ecd5..fbabb037b7 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 2008 by Sun Microsystems, Inc. * * OpenOffice.org - a multi-platform office productivity suite @@ -46,8 +46,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: <empty> C1: =B1 (displays 0)</paragraph> |