diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/address_auto.xhp')
-rw-r--r-- | helpcontent2/source/text/scalc/guide/address_auto.xhp | 17 |
1 files changed, 6 insertions, 11 deletions
diff --git a/helpcontent2/source/text/scalc/guide/address_auto.xhp b/helpcontent2/source/text/scalc/guide/address_auto.xhp index e03baa41f4..53db98f834 100644 --- a/helpcontent2/source/text/scalc/guide/address_auto.xhp +++ b/helpcontent2/source/text/scalc/guide/address_auto.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="textscalcguideaddress_autoxml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Recognizing Names as Addressing</title> @@ -57,15 +57,10 @@ oldref="20"><variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp" name="Recognizing Names as Addressing">Recognizing Names as Addressing</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3152597" role="paragraph" l10n="CHG" oldref="21">You can use cells with text to refer to the rows or to the columns that contain the cells.</paragraph> - <table id="tbl_id3152577"> - <tablerow> - <tablecell> +<comment>removed table as a workaround for issue 108715</comment> <paragraph xml-lang="en-US" id="par_id3156283" role="paragraph" l10n="E"> -<image id="img_id3154942" src="res/helpimg/names_as_addressing.png" width="4.1291in" height="1.6709in" localize="true"><alt xml-lang="en-US" id="alt_id3154942">Example spreadsheet</alt> +<image id="img_id3154942" src="res/helpimg/names_as_addressing.png" width="2.1291in" height="0.8709in" localize="true"><alt xml-lang="en-US" id="alt_id3154942">Example spreadsheet</alt> </image></paragraph> - </tablecell> - </tablerow> - </table> <paragraph xml-lang="en-US" id="par_id3154512" role="paragraph" l10n="CHG" oldref="22">In the example spreadsheet, you can use the string <item type="literal">'Column One'</item> in a formula to refer to the cell range <item type="literal">B3</item> to <item type="literal">B5</item>, or <item type="literal">'Column Two'</item> for the cell range <item type="literal">C2</item> to <item type="literal">C5</item>. You can also use <item type="literal">'Row One'</item> for the cell range <item type="literal">B3</item> to <item type="literal">D3</item>, or <item type="literal">'Row Two'</item> for the cell range <item type="literal">B4</item> to <item type="literal">D4</item>. The result of a formula that uses a cell name, for example, <item type="literal">SUM('Column One')</item>, is 600.</paragraph> <paragraph xml-lang="en-US" id="par_id3155443" role="paragraph" l10n="CHG" oldref="24">This function is active by default. To turn this function off, choose <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Calculate</emph> and clear the <emph>Automatically find column and row labels</emph> check box.</paragraph> |