  |
GoFiler Legato Script Reference
Legato v 1.4j Application v 5.22b
|
| Table of Contents | < < Previous | Next >> |
Chapter Five — General Functions (continued)
Overview
The IntegerToAlpha function converts an integer to a string containing equivalent letter-style numbering (such as those commonly used in spreadsheet columns).
Syntax/Parameters
Syntax
string = IntegerToAlpha ( int value, [boolean lower] );
Parameters
value
An int to convert.
lower
An optional boolean value, if non-zero the result will be lower case. The default is upper case.
Return Value
Returns the string equivalent of value or an empty string on failure. Use the GetLastError function to retrieve error information.
Remarks
The IntegerToAlpha function is particularly useful when creating data that might be read in spreadsheet applications, which commonly denote columns using letter notation. The conversion from integers to letters is zero inclusive such that 0 becomes ‘A’ and 26 becomes ‘AA’ and so forth. There is no equivalent to negative numbers for alphabetic numbers. Note that the numbering and lettering sequences in XDS and XFR files are incorrect and this routine cannot be used to convert between them.
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.