  |
GoFiler Legato Script Reference
Legato v 1.4j Application v 5.22b
|
| Table of Contents | < < Previous | Next >> |
Chapter Five — General Functions (continued)
Overview
The CellAddressGetRow function converts a string containing spreadsheet-style cell address to indexed positions and returns the zero-based row value (eg, A1 is row 0, B1 is row 0).
Syntax/Parameters
Syntax
int = CellAddressGetRow ( string data );
Parameters
data
A string containing a cell address sequence such as ‘BA02’. The string cannot be larger than 256 bytes.
Return Value
Returns an int containing the zero-based integer row index or -1 on failure. Use the GetLastError function to retrieve error information. The only error returned is a syntax error.
Remarks
This function converts and returns the zero-based row value (e.g., A1 is 0, B1 is 0). It can be useful for translating spreadsheet column numbers.
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.