From 5ce821dd59435366c5d8d3ca8a200f99a7fe3670 Mon Sep 17 00:00:00 2001 From: Uwe Fischer Date: Mon, 7 Dec 2009 12:35:04 +0100 Subject: native0: branding Help --- helpcontent2/source/text/scalc/01/04060110.xhp | 16 ++++++++-------- helpcontent2/source/text/scalc/01/04060199.xhp | 4 ++-- helpcontent2/source/text/scalc/01/12080700.xhp | 5 ++--- helpcontent2/source/text/scalc/01/func_weeknum.xhp | 4 ++-- helpcontent2/source/text/scalc/05/empty_cells.xhp | 6 +++--- 5 files changed, 17 insertions(+), 18 deletions(-) (limited to 'helpcontent2/source/text/scalc') 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 @@ - + - - + + Text Functions @@ -46,7 +46,7 @@ Function Wizard;text Text Functions - This section contains descriptions of the Text functions. + This section contains descriptions of the Text functions.
@@ -257,7 +257,7 @@ Example - =EXACT("Sun microsystems";"Sun Microsystems") returns FALSE. + =EXACT("microsystems";"Microsystems") returns FALSE.
FIND function @@ -390,7 +390,7 @@ Example - =MID("Sun Microsystems";5;5) returns Micro. + =MID("office";2;2) returns ff.
PROPER function @@ -407,7 +407,7 @@ Example - =PROPER("sun microsystems") returns Sun Microsystems. + =PROPER("open office") returns Open Office.
REPLACE function 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 @@ -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. +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. 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 @@
-
see http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_drill-down_on_data_fieldFor 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 userHidden 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. +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. 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 @@ WEEKNUM WEEKNUM calculates the week number of the year for the internal date value. -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.UFI: see http://www.openoffice.org/issues/show_bug.cgi?id=33709 +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. Syntax WEEKNUM(Number; Mode) 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 @@ empty cells;handling of i86303Handling of Empty Cells -Starting with OpenOffice.org 3.0 and StarOffice 9, the handling of empty cells got changed. -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. + +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. 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. For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1: A1: 1 B1: <empty> C1: =B1 (displays 0) -- cgit