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>lblank()</b> <b>writewks.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lblank()                                                          WRITEWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   Write a blank cell into the worksheet

 Syntax
   Lblank( aSpreadsheet, cCell, cFormat )

 Parameters:
   aSpreadsheet - spreadsheet handle array
   cCell        - Cell address to write blank into
   cFormat      - Format to write in cell
                  Dx  = Date           1- DD-MMM-YY
                                       2- MMM-YY
                                       3- DD-MMM
                  Fd  = Fixed          [d] decimals
                  Pd  = Percent        [d] decimals
                  ,d  = Comma          [d] decimals
                  Cd  = Currency       [d] decimals
                  Sd  = Sci Notation   [d] decimals

 Returns
   nStatus      0  All ok
                4  Invalid cell
                6  Invalid parameters

 Notes
   Lblank() allows you to write a blank cell into a spreadsheet.  Unless
   the cell is referred to by a formula or has a different format, blank
   cells are normally not saved within a spreadsheet.

 Example
function main
    LOCAL aWks  := Lcreate( "TAXES","L2" )
    Lblank( aWks,"A1","D3")   // Set A1's format to DD-MMM
    Lclose( aWks )
return nil

 Category
   Creating spreadsheet files

See Also: Lput()

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