index   prev   next RISC OS Notes

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