⟦83d1480d2⟧

TextFile

******
* Uniplex-II Plus Spreadsheet (Industry Standard Interface) Softkeys
* File:    issi.fn
* Release: V6.00  
* Date:    16 Nov 1987
*
* MODS 8/12/87: DJC - add zero field default to sort options.
******

#MESSAGES
99  Sorry this facility is not yet available: Hit any key.
))

#include ../general/general.fn

#PROMPT
F1=EDIT  F2=NAME  F3=ABS  F4=QUIT  F5=GOTO  F6=WINDOW  F7=MACRO  F8=CALC
1=F94 *hello
2=F95 ;this is a comment
3=F96
4=F62
5=';cur {PRM 445}{PNT}\r' ;this is a comment
6=F173
7=';macro\r':D(Enter single letter macro name)
8=';calc\r'
H=M(#HELP)
))

##ISSI
Worksheet  Range  Copy  Move  File  Print  Graph  Data  Integrate  Quit
Global, Insert, Delete, Column, Erase, Titles, Window, Modes
Format, Line-up, Erase, Name, Remove-name, Protect, Unprotect, Input, Value
Copy a Point or Range
Move a Point or Range
Retrieve, Save, Combine, Xtract, Use, List, Import, Export
Setup, Printer, File, Quit
Draw, Range, Place, Link, Options, Xpand, Goto, Erase, Template, Quit
Fill, Sort, Initialize, Blank, Zero, Range-zero
Cut-Paste, Database, 1.Desk, 2.Util, Unix, Read-Unix
Exit from this spreadsheet session
))
1=M(#WORKSHEET)
2=M(#RANGE)
3='copy {PRM 350}{RNG .} > {PRM 351}{RNG}\r'
4='move {PRM 352}{RNG .} > {PRM 353}{PNT}\r'
5=M(#FILE)
6=M(#PRINT)
7=M(#GRAPH)
8=M(#DATA)
9=M(#UCINTEG)
10=M(#QUIT)
))

##QUIT
No  Yes
Do NOT end this spreadsheet session: go back to UNIPLEX mode.
Quit from this spreadsheet session (Remember to save your work first)
))
1=F5
2='{NC}q\r'
))

##UCINTEG
Cut-Paste  Database  1.Desk  2.Util  Unix  Read-Unix
Cut, Paste, Range-Paste, Text, Add, Subtract, Board-Number
Name, Paste, Link, Forms, Sql
Uniplex DESK popup
Uniplex utilities popup
Run a Unix command
Paste output from Unix command into worksheet
))
1=M(#CUTPST)
2=M(#DB)
3=M(#DESK)
4=M(#DESK2)
5='! {PRM 399}{INP}\r'
6='pa "{PRM 399}{INP}"\r'
))

*
* The EDIT menu: a standard Uniplex style softkey line.
* Not sure quit what command set to put in here, could offer F8 MORE?
*

#EDIT
F1=Enter F2=<-GO F3=GO-> F4=QUIT F5=UNDO F6=MATCH BRACKET F7=DEL-> F8>
1=F61:M()
2=F21
3=F22
4=F64:M()
5=F66
6=F16
7=F4
8=^()
))

*
* The WORKSHEET menu set.
*

##WORKSHEET
Global  Insert  Delete  Column  Erase  Titles  Window  Modes
Format, Column-Width, Recalculation, Protection, Modes
Column, Row
Column, Row
Set-Width, Reset-Width, Hide, Display
Clear the Worksheet: display a new blank Worksheet
Header, Row, Col, Display, Move, Quit
Move, Horizontal, Vertical, Link, Unlink, Next, Switch, Join, Reset
Recalculate, Stat-line, View, Cursor, Move, Interface
))
1=M(#GLOBAL)
2=M(#INSERT)
3=M(#DELETE)
4=M(#COLUMN)
5=M(#NEW)
6=M(#TITLE)
7=M(#WINDOW)
8=M(#MODES)
))

##INSERT
Column  Row
Insert 1 or more blank columns to the left of the cell pointer
Insert 1 or more blank rows above the the cell pointer
))
1='ins {PRM 354}{RNG C .}\r'
2='ins {PRM 355}{RNG R .}\r'
))

##DELETE
Column  Row
Delete 1 or more columns
Delete 1 or more rows
))
1='{NC}del {PRM 356}{RNG C .}\r'
2='{NC}del {PRM 357}{RNG R .}\r'
))

##COLUMN
Set-Width  Reset-Width  Hide  Display
Set width for specified columns
Use global width specified columns
Suppress display of current column
Re-enable display of specified column
))
1='cw {PRM 360}{RNG C .} {PRM 361}{INT}\r'
2='cw {PRM 362}{RNG C .}\r'
3=F13:'cw {@L} 0\r'
4='cw {PRM 363}{RNG C}\rcur {LR}\r'
))

##NEW
No Yes
Do NOT clear this worksheet: go back to UNIPLEX mode.
Clear this worksheet (Remember to save your current work first)
))
1=F5
2='{NC}new\r'
))

##MODES
Recalculate  Stat-line  View  Cursor  Move  Interface  Quit
Set recalculation modes
Display status line
Display formulae on status line
Display cursor position on status line
Scroll by line or by page
Change the user interface
Quit the mode setting menu
))
1=M(#CALC)
2='stat\r':M(#MODES)
3='view\r':M(#MODES)
4='cur\r':M(#MODES)
5='scroll\r':M(#MODES)
6=M(#INFACE)
7=F5
))

##CALC
Natural  Col  Row  Auto  Manual  Iterate  Oneshot  Precision  Section  Full
Recalculate in natural order
Recalculate in columnwise order
Recalculate in rowwise order
Recalculate every time the worksheet is changed
Recalculate only by command
Recalcalate every N times
Don't recalculate external functions and database links
Limit, Money, Full
Restrict recalculation to a range of cells
Reset recalculation to the full worksheet
))
1='c nat\r'
2='c col\r'
3='c row\r'
4='c on\r'
5='c off\r'
6='c {PRM 391}{INT}\r'
7='c oneshot\r'
8=M(#PREC)
9='c {PRM 390}{RNG} on\r'
10='c {LR} off\r'
))

##PREC
Limit  Money  Full
Set calculation rounding to any limit
Set calculation rounding to 2 decimal places
No rounding
))
1='pre {PRM 490}{INT}\r'
2='pre 2\r'
3='pre all\r'
))

##INFACE
Uniplex  issi  R1C1  A1
Use the old Uniplex style interface
Use an industry standard spreadsheet interface
Use row and col style addressing (r1c1)
Use alpha style addressing (A1)
))
1='#ucalc\r'
2='#issi\r'
3='#R1C1\r'
4='#A1\r'
))

##TITLE
Header  Row  Column  Display  Move  Quit
Main-header, Sub-header, Display, Hide
Enter a row title on the current row
Enter a column title on the current column
Row-Width, Show-Column, Hide-Column
Row, Column
))
1=M(#HEAD)
2='t {PRM 428}{PNT R}={PRM 430}{INPX}\r':M(#TITLE)
3='t {PRM 429}{PNT C}={PRM 431}{INPX}\r':M(#TITLE)
4=M(#TDISP)
5=M(#TMOVE)
6=F5
))

##HEAD
Main-header  Sub-header  Display  Hide
))
1='t hdr1,{PRM 432}{INPX}\r':M(#TITLE)
2='t hdr2,{PRM 433}{INPX}\r':M(#TITLE)
3='hdr on\r':M(#TITLE)
4='hdr off\r':M(#TITLE)
))

##TDISP
Row-width  Show-Column  Hide-Column
Set width of row title display area
Display column titles
Hide the column titles
))
1='cw title {PRM 434}{INT}\r':M(#TITLE)
2='title on\r':M(#TITLE)
3='title off\r':M(#TITLE)
))

##TMOVE
Row  Column
Move a range of row titles
Move a range of column titles
))
1='move title {PRM 435}{RNG R .} > {PRM 436}{PNT R}\r':M(#TITLE)
2='move title {PRM 437}{RNG C .} > {PRM 438}{PNT C}\r':M(#TITLE)
))

##WINDOW
Move  Horizontal  Vertical  Link  Unlink  Next  Switch  Join  Reset
Move the current window to view another area of the worksheet
Split the screen at the current row
Split the screen at the current column
Both, Row, Column, Number, All
Clear syncronised movement
Move into next window
Move into a specific window
Join 2 windows together into 1
Reset to full screen window
))
1='w {PRM 443}{PNT}\r'
2='spl {ROW}\r'
3='spl {COL}\r'
4='w link  ':M(#LINK)
5='w unlink\r'
6='w +\r'
7='w {PRM 440}{INT}\r'
8='unspl {PRM 441}{INT} {PRM 442}{INT}\r'
9='unspl all\r'
))

##LINK
Both  Row  Column  Number  All
Syncronise both row and column movement
Syncronise row movement only
Syncronise column movement only
Syncronise current window with 1 other window
Syncronise all windows
))
1=M(#LINK)
2=F1:'r':M(#LINK)
3=F1:'c':M(#LINK)
4=' {PRM 444}{INT}\r'
5='\r'
))

*
* Global Options
*

##GLOBAL
Format  Column-Width  Recalculation  Protection  Modes
Set global format
Set the width for all columns
Set recalculation modes
Enable, Disable, Protect-all, Unprotect-all
Set global mode options
))
1='f all':M(#FORMAT)
2='cw all {PRM 361}{INT}\r'
3=M(#CALC)
4=M(#GLOCK)
5=M(#MODES)
))

##GLOCK
Enable  Disable  Protect-all  Unprotect-all
Turn protection on
Turn protection off
Protect all cells in the worksheet
Remove protection on all cells in the worksheet
))
1='lo on\r'
2='lo off\r'
3='lo all\rlo on\r'
4='unl all\rlo off\r'
))

*
* RANGE Options
*

##RANGE
Format  Line-up  Erase  Name  Remove-name  Protect  Unprotect  Input  Value
Set the format for a range of cells
Align a range of cells
Erase a cell or range of cells
Assign a name to a cell or range of cells
Remove the name from a range
Protect a range of cells
Unprotect a range of cells
Enter data into unprotected cells in a range
Copy range of values. Ignore formulae.
))
1='f {PRM 371}{RNG .} ':M(#FORMAT)
2='f {PRM 372}{RNG .} ':M(#FALIGN)
3='{NC}kill {PRM 358}{RNG .}\r'
4='lab {PRM 364}{RNG .}={PRM 365}{INP}\r'
5='unlab {PRM 366}{RNG}\r'
6='lo {PRM 367}{RNG .}\r'
7='unlo {PRM 368}{RNG .}\r'
8='inp {PRM 369}{RNG .}\r'
9='cut {PRM 403}{RNG .}\r':'{PRM 404}{PNT X}paste\r'
))

*
* cell FORMAT menus
* Some of these menus give access to user definable formats and will need
* to be changed when these formats are altered. See UCALC DEFINITIONS file.
*

##FORMAT
Fixed  Money  Percent  ,  Date  Line-up  Zero  Hide  Effect  Sci  Opt  Reset
Set number of decimal places
Dollar, Sterling, Mark, Franc, Lira
Percentage symbol
Display commas in numbers
International date formats
Left, Right, Center
Display zero values as empty cells
Don't display any values in these cells
Uniplex print effects
Exponential format (1.23e6)
Dec_align, Bracket-neg, Highlight-neg
Reset to default display format
))
1='dec {PRM 370}{INT}\r'
2=M(#FMONEY)
3='%\r'
4='comma\r'
5=M(#FDATE)
6=M(#FALIGN)
7='4\r'
8='5\r'
9=M(#FEFFECT)
10='sci\r'
11=M(#FOPTION)
12=' off\r'
))

##FMONEY
Dollar  Sterling  Mark  Franc  Lira
))
1='dec 2 $\r'
2='dec 2 #\r'
3='dec 2 8\r'
4='9\r'
5='10\r'
))

##FDATE
1.(DD-MMM-YY)  2.(DD-MMM)  3.(MMM-YY)  4.(Long-Int'l)  5.(Short-Int'l)
))
1='datefmt 8\r'
2='datefmt 9\r'
3='datefmt 10\r'
4='datefmt 11\r'
5='datefmt 12\r'
))

##FALIGN
Left  Right  Center
))
1='left\r'
2='right\r'
3='center\r'
))

##FEFFECT
Bold, Cont-underline, Text-underline, Underline-bold, Italic, Large
))
1='bold\r'
2='us\r'
3='ust\r'
4='usbold\r'
5='italic\r'
6='large\r'
))

##FOPTION
Dec_align, Bracket-neg, Highlight-neg
Decimal alignment with floating decimal places
Put brackets around negative numbers
Put negative numbers in bold text
))
1='1\r'
2='2\r'
3='3\r'
))

*
* GRAPH menus
*

##GRAPH
Draw  Range  Place  Link  Options  Xpand  Goto  Erase  Template  Quit
Display the current graph
Select the data range to be graphed
Select range where graph will be placed
Link the graph into the spreadsheet calculations
Use the graph description form
Display in high-res (you must be using a high-res terminal)
Move to a linked graph
Erase the graph
Create a template file for Uniplex Presentation Graphics
Quit the graph menu
))
1='g\r':M(#GRAPH)
2='g {PRM 420}{RNG} on\rg lab {PRM 427}{INPX}\r':M(#GRAPH)
3='g size {PRM 424}{RNG}\r':M(#GRAPH)
4='{PRM 421}{PNT X}=graph\r':M(#GRAPH)
5='{SK :#GRAPH}view graph\r'
6='g expand\r':M(#GRAPH)
7='g {PRM 426}{INT}\r':M(#GRAPH)
8=M(#GKILL)
9='li template in {PRM 419}{SK}{INP F11}'M(#FNAME)
10=F5
))

##GKILL
No  Yes
Don't erase the graph: return to Graph menu
Erase it
))
1=M(#GRAPH)
2='g kill\r':M(#GRAPH)
))

*
* DATA menus.
*

##DATA
Fill  Sort  Initialize  Blank  Zero  Range-zero
Fill a range of cells with a number
Sort a range of cells
Initialize the value of a formula
Clear calculation results from a range of cells
Zeroise worksheet
Zeroise data a range of cells
))
1='init {PRM 400}{RNG .}={PRM 401}{NUM}, {PRM 402}{NUM}\r'
2=M(#SORT)
3='init {PRM 392}{RNG}={PRM 393}{NUM}\r'
4='init {PRM 407}{RNG .}\r'
5='zero\r'
6='zero {PRM 408}{RNG .}\r'
))

##CUTPST
Cut  Paste  Range-Paste  Text  Add  Subtract  Board-Number
Cut a range of cells into a Uniplex clipboard
Paste from a Uniplex clipboard
Paste into range of cells from a Uniplex clipboard
Paste as text from a Uniplex clipboard
Add values from clipboard into worksheet
Subtract values in clipboard from worksheet
Select the clipboard number
))
1='cut {PRM 403}{RNG .}\r'
2='{PRM 404}{PNT X}paste\r'
3='pa {PRM 405}{RNG .}\r'
4='{PRM 404}{PNT X}pa text\r'
5='{PRM 404}{PNT X}pa +\r'
6='{PRM 404}{PNT X}pa -\r'
7='buf {PRM 406}{INT}\r':M(#CUTPST)
))

##DB
Name  Paste  Link  Forms  Sql
Select the database to work with
Paste result of database query
Link database query to current cell
Invoke database forms interface
Run database SQL interface
))
1='db {PRM 470}{INP}\r':M(#DB)
2='pa db "{PRM 471}{INP}"\r'
3='{MD 9}=pipe("select {MSG 472}'
4=X(,,,IOR,exec uform,105)
5=X(,,,IOR,exec usql,106)
))

##IMPORT
Ascii  123  DIF
Read data from ascii file
Read a 123 worksheet file
Read data from a DIF file
))
1='inp from {PRM 409}{SK}{INP F11}':M(#FNAME)
2='get conv 1 from {PRM 281}{SK}{INP F11}':M(#FNAME)
3='get conv 0 from {PRM 280}{SK}{INP F11}':M(#FNAME)
))

##EXPORT
Ascii  DIF
Write data into ascii file
Write data into DIF format file
))
1='pri {PRM 466}{RNG .} on 9 on 10 on 11 in {PRM 465}{SK}{INP F11}':M(#FNAME)
2='list {PRM 467}{RNG .} dif in {PRM 465}{SK}{INP F11}':M(#FNAME)
))

##SORT
Data-Range  Order  Key  Go  Quit
Enter range to be sorted
Dictionary, Numeric, Reverse
Select the key field. (default is the first value in each line)
Run the sort
Abandon the sort
))
1='cut {PRM 410}{RNG .} | "sort -b ':M(#SORT)
2=M(#ORDER)
3='+{PRM 413}{INT} ':M(#SORT)
4=' +0"{PRM 411}{PNT X}\r':M()
5=F5
))


##ORDER
Dictionary  Numeric  Reverse
))
1='-d -f ':M(#SORT)
2='-n ':M(#SORT)
3='-r ':M(#SORT)
))

*
* Printing options.
* Print options will change between Beta-test versions 01 and 02 due to
* work about to start on uprop/pwp/styles
*

##PRINT
Setup  Printer  File  Quit
Page-format, Entire-file, Specific-range, Compressed, Normal, Reset
Print direct to the printer: check your PRINT DESK printer selection
Print into a named file
Quit the print menu
))
1=M(#PSET)
2='pri in TMPFILE\r':X(,,,I,(eval set xx `uprtcmd -c SS`;eval uprop -p$3 $2 $Utmpfile $4 ;rm -f $Utmpfile\)&):F5
3='pri in {PRM 453}{SK}{INP F11}':M(#FNAME)
4=F2
))

##PSET
Page-format  Entire-file  Specific-range  Compressed  Normal  Reset
Length, Width, Cols, Indent, Top, Dbl, Single, Bar, Formatted, Raw
Print the whole worksheet
Print only part of the worksheet
Print in a small font
Print in a normal font
Reset print setup to defaults
))
1=M(#PPAGE)
2='set all\n':M(#PRINT)
3='set {PRM 450}{RNG}\n':M(#PRINT)
4='set on 5\n':M(#PRINT)
5='set off 5\n':M(#PRINT)
6='set opt 3 0\n':M(#PRINT)
))

##PPAGE
Length  Width  Cols  Indent  Top  Dbl  Single  Bar  Formatted  Raw
Set page length for auto page breaks
Set page width for auto page breaks
Set worksheet columns per page; overrides page width setting
Set left margin indent
Set top margin
Print double spaced
Print single spaced
Print line between titles and data
Generate print format controls
Print without any format controls
))
1='set length {PRM 452}{INT}\r':M(#PRINT)
2='set width {PRM 451}{INT}\r':M(#PRINT)
3='set c {PRM 454}{INT}\r':M(#PRINT)
4='set opt 1 {PRM 455}{INT}\r':M(#PRINT)
5='set opt 2 {PRM 456}{INT}\r':M(#PRINT)
6='set spacing 2\r':M(#PRINT)
7='set spacing 1\r':M(#PRINT)
8='set bar\r':M(#PRINT)
9='set off 9\r':M(#PRINT)
10='set on 9\r':M(#PRINT)
))

*
* The FILE i/o menus
*

##FILE
Retrieve  Save  Combine  Xtract  Use  List  Import  Export
Erase the current worksheet and replace with a saved one
Store the worksheet in fast access format
Combine all or part of a worksheet file into the worksheet
Store a part of a worksheet
Interpret commands stored in a file
Store the worksheet in portable command list format
Ascii, 123, DIF
Ascii, DIF
))
1='get from {PRM 381}{SK}{INP F11}':M(#FNAME)
2='save all in {PRM 382}{SK}{INP F11}{WF}':M(#FNAME)
3=M(#COMBINE)
4=M(#XTRACT)
5='use {PRM 380}{SK}{INP F11}':M(#FNAME)
6='list ':M(#LIST)
7=M(#IMPORT)
8=M(#EXPORT)
))

##COMBINE
Copy  Data-copy Add  Subtract
Replace cells in worksheet with cells from file, including formulas
Replace cells in worksheet with cells from file, text and data only
Add values from file to values in worksheet
Subtract values from file from values in worksheet
))
1='get rules ':M(#COMB2)
2='get data ':M(#COMB2)
3='get + ':M(#COMB2)
4='get - ':M(#COMB2)
))

* Note: combine can adjust target range.

##COMB2
Entire-file  Specific-range
Combine entire file into worksheet
Combine a specific range only
))
1='from {PRM 386}{SK}{INP F11}':M(#FNAME)
2='{PRM 387}{RNG} from {PRM 386}{SK}{INP F11}':M(#FNAME)
))

##XTRACT
Formulae  Values
Save formulas and values
Save values only
))
1='save {PRM 389}{RNG .} in {PRM 382}{SK}{INP F11}{WF}':M(#FNAME)
2='save {PRM 389}{RNG .} data in {PRM 382}{SK}{INP F11}{WF}':M(#FNAME)
))

##LIST
All  Data  Formulae  Graphs  Specific-range
List data, text and formulae
List data values only
List formulae only
List graphs only
Specify area of the worksheet to list
))
1='in {PRM 383}{SK}{INP F11}':M(#FNAME)
2='data in {PRM 383}{SK}{INP F11}':M(#FNAME)
3='rules in {PRM 383}{SK}{INP F11}':M(#FNAME)
4='graph in {PRM 383}{SK}{INP F11}':M(#FNAME)
5='{PRM 388}{RNG .} ':M(#LIST)
))

#FNAME
F1=ACCEPT  F2=FILE MANAGER  F3=LIST FILES  F4=QUIT
1=F11:M()
2='#':F11:F11
3=X(,,,L,ls)
4=F5
8=^()
))

#HELP
''
"S P R E A D S H E E T  H E L P
"
"
1-  Basic concepts
2-  Quick reference
3-  Menu structure
4-  Function list
"
"Basics
5-  Moving the cell pointer
6-  Addressing
7-  Entering numbers
8-  Entering dates
9-  Entering commands
10- Entering formulae
11- Entering Text
"
"
"Commands
12- Calculating
13- Copying and Moving
14- Editing
15- Formatting
16- Naming ranges
17- Protecting cells
18- Windows
19- Saving and retrieving
20- Printing
21- Quitting
22- Graphics
23- Emulations
"
"
"
"Functions
24- Statistical
25- Mathematical
26- Financial
27- Strings
28- Dates
29- Logical
30- Trigonometric
31- External
32- Special
))
1=H(SSBASIC)
2=H(SSQUICK)
3=H(SSMENU)
4=H(SSFUNCT)
5=H(SSPOINT)
6=M(#SS_ADDR)
7=H(SSENUMS)
8=H(SSEDATES)
9=H(SSCOMS)
10=M(#SS_FORMS)
11=M(#SS_TEXT)
12=M(#SS_CALC)
13=M(#SS_COPY)
14=M(#SS_EDIT)
15=M(#SS_FORMAT)
16=M(#SS_NAMES)
17=H(SSPROTECT)
18=M(#SS_WINDOW)
19=M(#SS_SAVE)
20=M(#SS_PRINT)
21=M(#SS_QUIT)
22=M(#SS_GRAPH)
23=H(SSEMULATE)
24=M(#SS_STAT)
25=M(#SS_MATH)
26=M(#SS_FINANCE)
27=M(#SS_STRING)
28=M(#SS_DATE)
29=M(#SS_LOGIC)
30=H(SSTRIG)
31=M(#SS_EXT)
32=M(#SS_SPECIAL)
))

#SS_ADDR
''
"Addressing
1- Relative
2- Absolute
3- Mixed
4- Ranges
5- Named ranges
))
1=H(SSADDRESS1)
2=H(SSADDRESS2)
3=H(SSADDRESS3)
4=H(SSADDRESS4)
5=M(#SS_NAMES)
))

#SS_FORMS
''
"Entering formulae
1- Entering a formula
2- Maths operators
3- Logical operators
))
1=H(SSFORM1)
2=H(SSFORM2)
3=H(SSFORM3)
))

#SS_TEXT
''
"Entering text
1- Into currrent cell
2- Repeating text
3- Align text
4- Row & Column titles
5- Worksheet headings
))
1=H(SSTEXT1)
2=H(SSTEXT2)
3=H(SSTEXT3)
4=H(SSTEXT4)
5=H(SSTEXT5)
))

#SS_CALC
''
"Calculating
1- Auto/Manual
2- Ordering
3- Specific range
4- Oneshot
5- Precision
))
1=H(SSCALCULATE1)
2=H(SSCALCULATE2)
3=H(SSCALCULATE3)
4=H(SSCALCULATE4)
5=H(SSCALCULATE5)
))

#SS_COPY
''
"Copying and moving
1- Copy cell contents
2- Move cell contents
3- Cut and Paste
))
1=H(SSCOPY1)
2=H(SSCOPY2)
3=H(SSCOPY3)
))

#SS_EDIT
''
"Editing
1- Edit a cell
2- Insert
3- Delete
4- Erase cells
5- Sort values
))
1=H(SSEDIT1)
2=H(SSEDIT2)
3=H(SSEDIT3)
4=H(SSEDIT4)
5=H(SSEDIT5)
))

#SS_FORMAT
''
"Formatting
1- Entire worksheet
2- Specific area
3- Formats
4- Reset to default
5- Column widths
))
1=H(SSFORMAT1)
2=H(SSFORMAT2)
3=H(SSFORMAT3)
4=H(SSFORMAT4)
5=H(SSFORMAT5)
))

#SS_NAMES
''
"Naming ranges
1- Create a name
2- Remove a name
3- View and use names
4- Name a macro
))
1=H(#SSNAME1)
2=H(#SSNAME2)
3=H(#SSNAME3)
4=H(#SSNAME4)
))

#SS_WINDOW
''
"Windows
1- Open a window
2- Change window
3- Synchronise
4- Join/Close
))
1=H(SSWINDOW1)
2=H(SSWINDOW2)
3=H(SSWINDOW3)
4=H(SSWINDOW4)
))

#SS_SAVE
''
"Saving and retrieving
1- Save fast format
2- List commands
3- Specify range
4- Document format
5- Retrieve fast format
6- Use a command list
))
1=H(SSSAVE1)
2=H(SSSAVE2)
3=H(SSSAVE3)
4=H(SSSAVE4)
5=H(SSSAVE5)
6=H(SSSAVE6)
))

#SS_PRINT
''
"Printing
1- Specify range
2- Page size
3- Page breaks
4- Columns per page
5- Headers & titles
6- Compressed text
7- Raw format
8- Select printer 
))
1=H(SSPRINT1)
2=H(SSPRINT2)
3=H(SSPRINT3)
4=H(SSPRINT4)
5=H(SSPRINT5)
6=H(SSPRINT6)
7=H(SSPRINT7)
8=H(SSPRINT8)
))

#SS_QUIT
'
"Quitting
1- Erase the worksheet
2- Quit the worksheet
3- Zeroise the worksheet
))
1=H(SSQUIT1)
2=H(SSQUIT2)
3=H(SSQUIT3)
))

#SS_GRAPH
''
"Graphics
1- Draw a graph
2- Link a graph
3- Change a graph
))
1=H(SSGRAPH1)
2=H(SSGRAPH2)
3=H(SSGRAPH3)
))

#SS_STAT
''
"Statistical
1- @sum(range)
2- @max(range)
3- @min(range)
4- @count(range)
5- @avg(range)
6- @stdev(range)
7- @abs(range)
8- @eval(@func(range,expr(X)))
9- @where(@func(range,expr(X)))
))
1=H(sum)
2=H(max)
3=H(min)
4=H(count)
5=H(avg)
6=H(stdev)
7=H(abs)
8=H(eval)
9=H(where)
))

#SS_MATH
''
"Mathematical
1- @exp(expr)
2- @log(expr)
3- @log10(expr)
4- @int(expr)
5- @mod(expr)
6- @div(expr)
7- @root(expr)
8- @rnd(expr)
))
1=H(exp)
2=H(log)
3=H(log10)
4=H(int)
5=H(mod)
6=H(div)
7=H(root)
8=H(rnd)
))

#SS_FINANCE
''
"Financial
1-  @fv()
2-  @sfv()
3-  @pv()
4-  @spv()
5-  @irr()
6-  @npv()
7-  @sink()
8-  @rate()
9-  @pmt()
10- @period()
))
1=H(fv)
2=H(sfv)
3=H(pv)
4=H(spv)
5=H(irr)
6=H(npv)
7=H(sink)
8=H(rate)
9=H(pmt)
10=H(period)
))

#SS_STRING
''
"Strings
1- @cmp()
2- @len()
3- @str()
4- @val()
5- @mid()
6- @lit()
7- @rpt()
))
1=H(cmp)
2=H(len)
3=H(str)
4=H(val)
5=H(mid)
6=H(lit)
7=H(rpt)
))

#SS_DATE
''
"Dates
1- @TODAY
2- @day()
3- @month()
4- @year()
5- @date()
6- @day_mon()
))
1=H(TODAY)
2=H(day)
3=H(month)
4=H(year)
5=H(date)
6=H(day_mon)
))

#SS_LOGIC
''
"Logical
1- @if()
2- @TRUE, @FALSE
3- @NOT()
4- @OR()
5- @AND()
6- test cell contents
))
1=H(if)
2=H(TRUE)
3=H(NOT)
4=H(OR)
5=H(AND)
6=H(empty)
))

#SS_EXT
''
"External
1- @link("retrieve command")
2- @graph(id,range)
3- @sh("UNIX command")
4- @rsh("UNIX command")
5- @pipe("SQL command")
))
1=H(link)
2=H(graph)
3=H(sh)
4=H(rsh)
5=H(pipe)
))

#SS_SPECIAL
''
"Special
1- @ROW, @COL
2- @rand()
3- @self()
4- @index()
5- @choose()
6- @lookup()
7- @NA, @isna(range)
8- @ERR, @iserr(range)
))
1=H(ROW)
2=H(rand)
3=H(self)
4=H(index)
5=H(choose)
6=H(lookup)
7=H(isna)
8=H(iserr)
))
DataMuseum.dk

Regnecentalen RC-900

⟦83d1480d2⟧ TextFile

Derivation

TextFile
