From 8aaa14a95b40109cdbfe00e63f5eab32d7c450f0 Mon Sep 17 00:00:00 2001 From: Vladimir Glazounov Date: Wed, 26 Aug 2009 08:17:39 +0000 Subject: CWS-TOOLING: integrate CWS hcshared22 2009-07-21 13:08:41 +0200 ufi r274186 : hidlst 2009-07-21 12:34:16 +0200 ufi r274179 : makefiles 2009-07-21 12:33:01 +0200 ufi r274177 : fixes 2009-07-21 12:22:32 +0200 ufi r274175 : hidlst 2009-07-21 10:20:12 +0200 ufi r274167 : bugfixes 2009-07-21 10:19:42 +0200 ufi r274166 : bugfixes 2009-07-21 10:07:53 +0200 ufi r274165 : errorfix 2009-07-21 09:56:18 +0200 ufi r274162 : vor build 2009-07-13 11:49:18 +0200 ufi r273923 : CWS-TOOLING: rebase CWS hcshared22 to trunk@273858 (milestone: DEV300:m52) 2009-07-10 12:29:33 +0200 ufi r273885 : makefiles 2009-07-10 09:48:46 +0200 ufi r273875 : vor rebase 2009-07-10 09:48:19 +0200 ufi r273874 : vor rebase 2009-07-10 09:47:23 +0200 ufi r273873 : vor rebase --- helpcontent2/source/text/scalc/01/04060109.xhp | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'helpcontent2/source/text/scalc/01/04060109.xhp') diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index 0b9edb1030..2e056abf28 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.xhp @@ -87,8 +87,8 @@ Sheet represents the name of the sheet. It must be placed in double quotes. Example: - - =ADDRESS(1;1;2;"Sheet2") returns the following: Sheet2.A$1 + + =ADDRESS(1;1;2;;"Sheet2") returns the following: Sheet2.A$1i 101187 If the cell A1 in sheet 2 contains the value -6, you can refer indirectly to the referenced cell using a function in B2 by entering =ABS(INDIRECT(B2)). The result is the absolute value of the cell reference specified in B2, which in this case is 6.
@@ -98,6 +98,7 @@ AREAS Returns the number of individual ranges that belong to a multiple range. A range can consist of contiguous cells or a single cell. + The function expects a single argument. If you state multiple ranges, you must enclose them into additional parentheses. Multiple ranges can be entered using the semicolon (;) as divider, but this gets automatically converted to the tilde (~) operator. The tilde is used to join ranges. Syntax AREAS(Reference) @@ -105,7 +106,7 @@ Example - =AREAS(A1:B3;F2;G1) returns 3, as it is a reference to three cells and/or areas. + =AREAS((A1:B3;F2;G1)) returns 3, as it is a reference to three cells and/or areas. After entry this gets converted to =AREAS((A1:B3~F2~G1)). =AREAS(All) returns 1 if you have defined an area named All under Data - Define Range.
@@ -241,7 +242,7 @@ Ref represents a reference to a cell or an area (in text form) for which to return the contents. A1 (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used. - For interoperability with Microsoft Excel, the sheet address separator ! is allowed as in INDIRECT("filename!sheetname"&B1).UFI: finally a fix for #i34465# + If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT("filename!sheetname"&B1) is not converted into the Calc address in INDIRECT("filename.sheetname"&B1).UFI: for #i34465# INDIRECT cannot resolve range names as in INDIRECT("RangeName").i83070 Example @@ -537,7 +538,7 @@ =ROW(D5:D8) returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned. - {=ROW(A1:E1)} and =ROW(A1:E1) both return 1 because the reference only contains row 1 as the first column in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.) + {=ROW(A1:E1)} and =ROW(A1:E1) both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.) =ROW() returns 3 if the formula was entered in row 3. -- cgit