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>lsortrange()</b> <b>sortwks.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lsortrange()                                                       SORTWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   Writes the sort range out to the spreadsheet

 Syntax
   Lsortrange( aSpreadsheet,cRange )

 Parameters
   aSpreadsheet    - Spreadsheet handle array
   cRange          - Range of cells

 Returns
   nStatus         -   0   = All ok
                      -5   = Invalid range
                      -6   = Invalid parameters

 Example
procedure main
    LOCAL aWks := Lcreate("TAXES.WK1")
    if !empty(aWks)
        LsortRange(aWks,"A1..H50")
        LsortKey(aWks,"A1..A50","A")
        LsortKey2(aWks,"B1..B50","D")
        Lclose(aWks)
     endif
return

 Notes
   The sort range determines which cells are sorted when the /DS command
   is executed.  It is normally all active cells within the spreadsheet.

 Category
   Creating spreadsheet files

See Also: Lsortkey() Lsortkey2()

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