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

1 files changed, 6 insertions, 5 deletions

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 @@
             <emph>Sheet</emph> represents the name of the sheet. It must be placed in double quotes.</paragraph>
          <paragraph xml-lang="en-US" id="hd_id3147299" role="heading" level="3" l10n="U"
                     oldref="15">Example:</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3148744" role="paragraph" l10n="U" oldref="16">
-            <item type="input">=ADDRESS(1;1;2;"Sheet2")</item> returns the following: Sheet2.A$1</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3148744" role="paragraph" l10n="CHG" oldref="16">
+            <item type="input">=ADDRESS(1;1;2;;"Sheet2")</item> returns the following: Sheet2.A$1<comment>i 101187</comment></paragraph>
          <paragraph xml-lang="en-US" id="par_id3159260" role="paragraph" l10n="U" oldref="17">If the cell A1 in sheet 2 contains the value <item type="input">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type="input">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6.</paragraph>
       </section>
       <section id="Section2">
@@ -98,6 +98,7 @@
 <paragraph xml-lang="en-US" id="hd_id3150372" role="heading" level="2" l10n="U"
                     oldref="19">AREAS</paragraph>
          <paragraph xml-lang="en-US" id="par_id3150036" role="paragraph" l10n="U" oldref="20"><ahelp hid="HID_FUNC_BEREICHE">Returns the number of individual ranges that belong to a multiple range.</ahelp> A range can consist of contiguous cells or a single cell.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id061020090307073" role="paragraph" l10n="NEW">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.</paragraph>
          <paragraph xml-lang="en-US" id="hd_id3145222" role="heading" level="3" l10n="U"
                     oldref="21">Syntax</paragraph>
          <paragraph xml-lang="en-US" id="par_id3155907" role="code" l10n="U" oldref="22">AREAS(Reference)</paragraph>
@@ -105,7 +106,7 @@
          <paragraph xml-lang="en-US" id="hd_id3148891" role="heading" level="3" l10n="U"
                     oldref="24">Example</paragraph>
          <paragraph xml-lang="en-US" id="par_id3149946" role="paragraph" l10n="U" oldref="25">
-            <item type="input">=AREAS(A1:B3;F2;G1)</item> returns 3, as it is a reference to three cells and/or areas.</paragraph>
+            <item type="input">=AREAS((A1:B3;F2;G1))</item> returns 3, as it is a reference to three cells and/or areas. After entry this gets converted to =AREAS((A1:B3~F2~G1)).</paragraph>
          <paragraph xml-lang="en-US" id="par_id3146820" role="paragraph" l10n="U" oldref="26">
             <item type="input">=AREAS(All)</item> returns 1 if you have defined an area named All under <emph>Data - Define Range</emph>.</paragraph>
       </section>
@@ -241,7 +242,7 @@
             <emph>Ref</emph> represents a reference to a cell or an area (in text form) for which to return the contents.</paragraph>
          <paragraph xml-lang="en-US" id="par_id1027200802470312" role="paragraph" l10n="NEW">
             <emph>A1</emph> (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.</paragraph>
-         <paragraph xml-lang="en-US" id="par_idN10CAE" role="note" l10n="NEW">For interoperability with Microsoft Excel, the sheet address separator ! is allowed as in INDIRECT("filename!sheetname"&amp;B1).<comment>UFI: finally a fix for #i34465#</comment></paragraph>
+         <paragraph xml-lang="en-US" id="par_idN10CAE" role="note" l10n="NEW">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"&amp;B1) is not converted into the Calc address in INDIRECT("filename.sheetname"&amp;B1).<comment>UFI: for #i34465#</comment></paragraph>
          <paragraph xml-lang="en-US" id="par_id7687917" role="note" l10n="NEW">INDIRECT cannot resolve range names as in INDIRECT("RangeName").<comment>i83070</comment></paragraph>
          <paragraph xml-lang="en-US" id="hd_id3150389" role="heading" level="3" l10n="U"
                     oldref="67">Example</paragraph>
@@ -537,7 +538,7 @@
          <paragraph xml-lang="en-US" id="par_id3153701" role="paragraph" l10n="U" oldref="207">
             <item type="input">=ROW(D5:D8)</item> 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.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3150996" role="paragraph" l10n="U" oldref="208">
-            <item type="input">{=ROW(A1:E1)}</item> and <item type="input">=ROW(A1:E1)</item> 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.)</paragraph>
+            <item type="input">{=ROW(A1:E1)}</item> and <item type="input">=ROW(A1:E1)</item> 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.)</paragraph>
          <paragraph xml-lang="en-US" id="par_id3153671" role="paragraph" l10n="U" oldref="209">
             <item type="input">=ROW()</item> returns 3 if the formula was entered in row 3.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3153790" role="paragraph" l10n="U" oldref="210">