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>lname()</b> <b>miscwks.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lname()                                                            MISCWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   Write a named range into the spreadsheet

 Syntax
   Lname( aSpreadsheet, cName, cRange )

 Parameters
   aSpreadsheet - Array of spreadsheet parameters
   cName        - Name for specified range
   cRange       - Range of cells

 Returns
   nStatus        - 0 = All Ok
                   -5 = Invalid range
                   -6 = Invalid parameters
                   -7 = Missing range name

 Notes
   A spreadsheet allows a range of cells to have a name assigned to them.
   This assists in documenting function calls. The Lname() function
   writes an range name out to the spreadsheet. If a formula references
   the range, it will display the range name when the formula is view.

 Example
function DemoOne
    LOCAL aWks := Lcreate("PAYROLL","L3")
    if !empty(aWks)
       Lname(aWks,"SALARY","A1..A15")
       Lname(aWks,"TAXES","B1..B15")
       Lclose(aWks)
    endif
return nil

 Category
   Creating spreadsheet files

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