Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- CLIPWKS -Spreadsheet Library - <b>lc()</b> <b>cw_core.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lc()                                                               CW_CORE.PRG
------------------------------------------------------------------------------------------

 Purpose
   To convert row and column coordinates to spreadsheet notation

 Syntax
   Lc( nRow,nColumn [,nSheet] )

 Parameters
   nRow     - Row number
   nColumn  - Column number
   nSheet   - Worksheet number, Lotus 3.x only

 Returns
   cCell_address

 Notes
   Lc() is used to convert from row and column notation into spreadsheet
   cell addresses.  It is most often used in loops, as shown in the example
   below:

 Example
function main
    LOCAL k
    LOCAL j
    for k=1 to 10
        goto k              // Goto record 'k'
        for j=1 to 5
            Lput( aWks,fieldget(j),lc(k,j) )
        next
    next
return nil

   The row may be an integer between 1 and 8192 and the column an
   integer between 1 and 256.

 Category
   Miscellaneous functions

See Also: lr()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson