Applications - minor
  ** for application shortcuts see Shortcuts
  ** some apps have entries in main list eg Ovation

#   FireWorks spreadsheet

   # hints

    to enable text to be keyed directly tick Choices - Edit in cell

    >make >constant is useful for time column if you need to copy it

    integer - define new style based on number, select style 0;[negative]-0

   # calculation expression
     use = to start a

   # cell references
    fixed cell references use $ eg $b$4
    relative references         eg b4
    !BUT use propagate down or sideways NOT clipboard!
    Note - the above info came from the Pipedream manual.

   # charts
     use x-y Scatter for time on x axis

   # csv
      drop on sheet... choose - insert overwriting blank cells
      (convert TSV to CSV - replace tab by comma)

   # decimals
    set the number of places via style number
     eg 0.00
    for a single column use effect not style
     eg 0 for integers

   # functions

      trig functions assume radians except for RAD - assumes degrees

      eg TAN(1)              = 1.54
         DEG(1)              = 57.29 degrees
         ATAN(1.54)          = 1

         DEG(ATAN(1.54)))    = 57.29 deg

   #  columns and rows

     ctrl  F7    insert row
     ctrl  F8    delete row

     shift f7    insert column
     shift f8    delete column

     to change row height:-
     >>Style>Styles...
      >Basesheet>Change...
      >Row>Height>change number

     you will probably want to change the fontsize also
     >>Style>Styles...
      >Basesheet>Change...
      >Text>Height etc


    # sort
      select All the cells you want sorted
      select sort dialogue
      key in column letter and click descending if required
      go

    # widths of cells
       create new style "narrow"
       set ruler column width to eg 1.4 cm
       apply style to selected rows

     wide text cell - use style- BaseHeadFoot


    # propagation
       use buttons for row and col propagation of the same value
       1 2 3 ...
        1    >>  a1
        =a1+1 >> a2
        propagate b1




#  !MoreDesk

   1 violet     ..........      APPZ; DOWNS; PROJECTS; PC
   2 indigo     ..........      Research - eg on web
   3 blue       study           DOCZ: cook; Addrs;
   4 green      workshop        System maintenance; programming;
   5 yellow     art room        CLIPS; PHOTOZ; drawing painting
   6 orange     music room      SOUNDZ;language
   7 red        ........        WEBZ

     top row    Arts and crafts         Artworks Photos Music
     middle     communication           email web including maintenance
     bottom     system workshop         cookbook applist CDs


   1 red        kitchen utility         !APPS;WEB;download;review
Projects*
   2 orange     games room              !Music; language
   3 yellow     art room or studio      !PHOTOS; !Drawing
   4 green      library, the study      DOCS: cook; Addrs
   5 aqua       wireless room           !Connect: email; Grapevine
   6 blue       workshop                PGMING; surfing;


#  !PipeDream
    SEE HARDCOPY BOOK
    to sum a column  - there may be other ways
       ! on target cell
       ^x
       type sum(
       ! on first number
       ! on last number
       type )
       return

    to set column widths
       select columns and
       put values in columns then
        >>Layout>autowidth
       (makes them narrow if empty)

    to Insert Row - F7
    to Delete Row - F8

#  !Publisher -aka Impression
     output text with styles gives DDF
     DDF2HTML reads DDF files and converts standard styles to H1,H2 etc
     standard styles are in impdoc
     ADFS::HardDisc5.$.DOCZ.HTML.HTML

     needs cmykpal in system in order to work under aemulor

# !Rename   - see section - Files Names and Types

#  !TemplEd
   1) to create icons on window:
     select, hold, and drag from the icon palette window

   2) to resize icons:
     adjust, hold, and drag

   3) to move icons:
     select, hold, and drag

#  !Thump
   Properties are kept in !Boot.Choices.Thump
    BootInfo - launchers
    Keys     - mappings
    Prefs    - settings

   Save thumbnails as a draw file:-
    drop folder on icon bar - viewer opens
    >>Viewer >Save as Draw... DrgnDrp

#  !ViewXLS  XL use for XL
   or !FireWorks up to v4 xl


#  !WebGet
      set target directory in !Run - eg
      Set WebGet$SitesDir ADFS::Panto.$.temp

    >> Add URL...
       key in URL with http://
       set search depth
       set links Same host - if true
       set Fetch Images

       this will create a file in the target dir eg temp
    to delete  URL - delete the file

© JR 2013