  |
GoFiler Legato Script Reference
Legato v 1.5b Application v 5.24b
|
| Table of Contents | < < Previous | Next >> |
Chapter Five — General Functions (continued)
Overview
The CellIndexToAddress function translates a cell position by row and column index to a spreadsheet-style cell address (e.g., row 2, col 2 becomes B3).
Syntax/Parameters
Syntax
string = CellIndexToAddress ( int row, int col );
Parameters
row
A positive zero-based int containing a cell row position.
col
A positive zero-based int containing a cell column position.
Return Value
Returns a string containing the cell address or an empty string on failure. Use the GetLastError function to retrieve error information.
Remarks
Use the CellAddressToIndex function to convert a cell address to an integer array. The only error returned by the GetLastError function for this function is a range error if the values are negative or exceed 31-bits.
Related Functions
Platform Support
Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL
Legato IDE, Legato Basic
| Table of Contents | < < Previous | Next >> |
© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.