Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Manuals/calci/ADDRESS
(view source)
Revision as of 23:17, 3 August 2018
249 bytes added
,
23:17, 3 August 2018
no edit summary
Line 1:
Line 1:
'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''
'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''
−
*RowNumber is the row number
+
<div style="font-size:30px">'''ADDRESS (RowNumber,ColumnNumber,AbsoluteOption,ReferenceStyle,TableName)'''</div><br/>
−
*ColumnNumber is the column number
+
−
*AbsoluteOption
specifies
the type of reference to return
+
*
<math>
RowNumber
</math>
is the row number
−
*ReferenceStyle is the logical value
+
*
<math>
ColumnNumber
</math>
is the column number
−
*TableName is the name of the Calci worksheet to be used as the external reference.
+
*
<math>
AbsoluteOption
</math>
the type of reference to return
+
*
<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==
==Description==
Devika
writer
6,694
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Community portal
Current events
Recent changes
Help
Tools
ZCubes Web Platform
Printable version