Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
XL.Sheet.RowColToAddr
Converts row and column to a cell reference.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| XL | 3.5 | Yes | Yes | Yes | Yes | Yes |
Parameters
| Parameter | Description | Example |
|---|---|---|
| bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
| sheetIndex | The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. | 0 |
| Row | The row for the cell. First row has index 0. | $row |
| Column | The column for the cell. First column has index 0. | $column |
| rowRelative | Whether to use relative row. Pass 1 for relative and 0 for absolute. | 1 |
| colRelative | Whether to use relative column. Pass 1 for relative and 0 for absolute. | 1 |
Result
Returns address value or error.
Description
Converts row and column to a cell reference.Examples
Calculates address and returns "$D$18":
MBS( "XL.Sheet.RowColToAddr"; $book; $sheet; 17; 3; 0; 0)
Calculates address and returns "D18":
MBS( "XL.Sheet.RowColToAddr"; $book; $sheet; 17; 3)
See also
Created 18th August 2014, last changed 18th August 2014
XL.Sheet.RightToLeft - XL.Sheet.SetAutoFitArea
Feedback: Report problem or ask question.
Links
MBS Xojo PDF Plugins
