Difference between revisions of "Manuals/calci/ADDRESS"

Latest revision as of 17:18, 3 August 2018

ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)

$RowNumber$ is the row number
$ColumnNumber$ is the column number
$AbsoluteOption$ the type of reference to return
$ReferenceStyle$ is the logical value
is the name of the Calci worksheet to be used as the external reference.
- ADDRESS(), returns a reference as text to a single cell in a worksheet.

This function generates a cell address as text, given specified row and column numbers.

AN	Types of reference
1 or omitted	Absolute
2	Absolute row,relative column
3	Relative row,absolute column
4	Relative

A1 is a logical value CText is text specifying the name of the calcisheet to be used as the external reference.

=ADDRESS(2,3) : Table1!$C$2
=ADDRESS(2,3,1) : Table1!$C$2
=ADDRESS(2,3,2) : Table1!C$2
=ADDRESS(2,3,3) : Table1!$C2
=ADDRESS(2,3,4) : Table1!C2
=ADDRESS(2,3,4,"FALSE","CALCI") : CALCI!C2

@@ Line 1: / Line 1: @@
-'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''
+<div style="font-size:25px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/>
-*RowNumber is the row number
-*ColumnNumber is the column number
+*<math>RowNumber</math> is the row number
-*AbsoluteOption specifies the type of reference to return
+*<math>ColumnNumber</math> is the column number
-*ReferenceStyle is the logical value
+*<math>AbsoluteOption</math> the type of reference to return
-*TableName is the name of the Calci worksheet to be used as the external reference.
+*<math>ReferenceStyle</math> is the logical value
+*<math>TableName</math> is the name of the Calci worksheet to be used as the external reference.
+**ADDRESS(), returns a reference as text to a single cell in a worksheet.
 ==Description==