Description:  Return current object class 
Syntax:  class„'obj' Œwi 'class' 

Description:  Get or Set column headings 
Syntax:  'obj' Œwi 'coltext' indices {column headings} 
indices:  column indices or Ð for all columns 
column headings: nested vector of column headings 

Description:  Get or Set the row headings alignments 
Syntax: {res„'} 'obj' Œwi 'hdralign' (A B C){alignment} 
A B C: booleans representing top_leftheader row_headers column_headers 
alignment:  any of 'left' 'center' or 'right' 

Example: 
0 0½'ff' Œwi '*Create' 'TForm5' ('*caption' 'TFOne5 Example') ('*size'300 400) 'DemoShow' 
0 0½'ff.ss' Œwi '*Create' 'TFOne5' ('wherelc'0 0'>>' '>>') ('attach'1 2 3 4) 
0 0½'ff.ss' Œwi 'Add' (2 2) (10 4½'This' 'is' 'Formula' 'One'123 19991231 '0,1234' '78999') 
'ff.ss' Œwi 'rowtext' (1+¼10) ((›'Row '),¨•¨1+¼10) 
'ff.ss' Œwi 'coltext' (2 3 4 5) ((›'Column '),¨•¨1+¼4) 
'ff.ss' Œwi 'hdralign' (0 0 1) 'right' 
'ff.ss' Œwi 'Select'2 2 11 5 
'ff.ss' Œwi 'FontName' 'Arial Black' 
'ff.ss' Œwi 'FontSize'12 
'ff.ss' Œwi 'BackColor' (192 192 255) 
'ff.ss' Œwi 'GetValues' 
'ff.ss' Œwi '*SetSelection'1 1 1 1 

Description:  Get or Set row headings 
Syntax:  'obj' Œwi 'rowtext' indices {row headings} 
indices:  row indices or Ð for all rows 
row headings: nested vector of row headings 

Description:  Get or set the number of sheets in an Formula One book 
Syntax:  'obj' Œwi 'sheets'nbsheets 

Description:  Installs an APL nested array in the Formula One grid at specified location 
Syntax:  res„'obj' Œwi 'Add' (row col)nested_array 
row,col:  row and column where to start installing nested array 
nested_array:  any depth 2 APL nested matrix 
res:  row1,col1,row2,col2: next available cell at bottom and at right of nested array 

Description:  Installs a title above a group of columns 
Syntax:  res„'obj' Œwi 'AddAcross'row(startcol,endcol)title 
res:  row1,col1,row2,col2: next available cell at bottom and at right of nested array 

Description:  Automatically adjusts the row headings width 
Syntax:  'obj' Œwi 'AdjustHdrWidth' 

Description:  Auto sizes column width and row height for all selected cells 
Syntax:  'obj' Œwi 'AutoSize' 

Description:  Auto sizes column width and row height for all selected cells 
the columns are made wide enough for the column headers as well as the specified cells. 

Description:  Sets the background color for all selected cells 
Syntax:  'obj' Œwi 'BackColor' (specs){selection} 
specs: (256ƒR G B) or (R G B) 
selection: optional selection specification 

Description:  Sets the border colors for all selected cells 
Syntax:  'obj' Œwi 'BorderColor' (color1 color2 color3){selection} 
color1,color2,color3: (256ƒR G B) or (R G B) 
color1: outline border color 
color2: vertical line border color 
color3: horizontal line border color 
selection: optional selection specification 

Description:  Sets the border for all selected cells 
Syntax:  'obj' Œwi 'BorderStyle' (specs){selection} 
specs: border type for outline vertical sep lines and horizontal sep lines 
may include: no thin medium dashed dotted thick double hairline 
             medium_dashed dashed_dotted medium_dashed_dotted dash_dot_dot 
             medium_dash_dot_dot slanted_dashed_dotted 
selection: optional selection specification 

Description:  Empties the spreadsheet 
Syntax:  'obj' Œwi 'Clear' 

Description:  Request or change the font name for selected cells 
Syntax:  'obj' Œwi 'FontName'fontname{selection} 

Description:  Request or change the font size for selected cells 
Syntax:  'obj' Œwi 'FontSize'fontsize{selection} 

Description:  Gets part of whole of currently selected sheet and return nested array 
Syntax:  'obj' Œwi 'Get' {selection} 
selection: numeric or character selection 
Use: 'obj' Œwi 'Get' ('obj' Œwi '*Selection') to return current selection 

Description:  Returns a numeric matrix of current selected ranges 
Syntax:  'obj' Œwi 'GetSelections' 

Description:  Gets part of whole of currently selected sheet and return nested array 
Same as Get method but transforms formatted numeric cells into numerics 
Syntax:  'obj' Œwi 'GetValues' {selection} 
selection: numeric or character selection 
Use: 'obj' Œwi 'GetValues' ('obj' Œwi '*Selection') to return current selection 

Description:  Sets the horizontal alignment for all selected cells 
Syntax:  'obj' Œwi 'HAlign' (specs){selection} 
specs: one of: 'general' 'left' 'center' 'right' 'fill' 'justify' 'across' 
selection: optional selection specification 

Description:  Returns my standard print footer as a suitable argument to PrintFooter method 
Syntax:  'obj' Œwi 'MyFooter' 
NOTE: adapt this method to your own needs or better copy it and adapt it 

Description:  Returns my standard print header as a suitable argument to PrintHeader method 
Syntax:  'obj' Œwi 'MyHeader' 
NOTE: adapt this method to your own needs or better copy it and adapt it 

Description:  Returns the color palette index of a given RGB color 
Example:  'obj' Œwi 'PaletteIndex' (2 3½192 192 192 0 0 255) 
     or:  'obj' Œwi 'PaletteIndex' (256ƒ255 255 0) 

Description:  Prints the specified range or whole worksheet now 
'Print'0  „… print with no initial dialog box 
'Print'1  „… first displays a print dialog box 
You may use the following methods before printing: 
'obj' Œwi '*PrintArea' 'A1:C3;A11:C13'    © to define the print area 
'obj' Œwi '*PrintBottomMargin'.5          © to define the print bottom margin in inches 
'obj' Œwi '*PrintColHeading'1             © to say if column headings are to be printed 
'obj' Œwi '*PrintCopies'3                 © to define the number of copies printed by default 
'obj' Œwi 'PrintFooter'footer             © to define the page footer printed on each page 
'obj' Œwi '*PrintFooterMargin'inches      © to define the distance from bottom of page to footer 
'obj' Œwi '*PrintGridLines'1              © to say if grid lines are to be printed 
'obj' Œwi '*PrintHCenter'1                © to say if page must be horizontally centered 
'obj' Œwi 'PrintHeader'header             © to define the page header printed on each page 
'obj' Œwi '*PrintHeaderMargin'inches      © to define the distance from top of page to header 
'obj' Œwi '*PrintLandscape'boolean        © to say if page must be printed in lansdcape mode 
'obj' Œwi '*PrintLeftMargin'inches        © to define the left margin in inches 
'obj' Œwi '*PrintLeftToRight'boolean      © to define if pages are to be printed left to right 
'obj' Œwi '*PrintNoColor'boolean          © to say if the workbook has to be printed in color 
npages„'obj' Œwi 'PrintPreview'page       © to preview page N before printing 
'obj' Œwi '*PrintRightMargin'inches       © to define the right margin in inches 
'obj' Œwi '*PrintRowHeading'1             © to say if row headings are to be printed 
'obj' Œwi '*PrintScale'scale              © to define the print scale (between 10 and 400) 
'obj' Œwi '*PrintScaleFitHPages'N         © to fit the print job to N pages horizontally 
'obj' Œwi '*PrintScaleFitToPage'boolean   © indicate whether to use FitHPages and FitVPages 
'obj' Œwi '*PrintScaleFitVPages'N         © to fit the print job to N pages vertically 
'obj' Œwi '*PrintTitles'formula           © 'A1:IV2,A1:A16384' prints 1st 2 rows and 1st col on every page 
'obj' Œwi '*PrintTopMargin'inches         © to define the print top margin in inches 
'obj' Œwi '*PrintVCenter'1                © to say if page must be vertically centered 

Description:  Uses various methods to set up my default print parameters 
Syntax:  'obj' Œwi 'PrintDefault' 

Description:  Indicates whether printing must be made in landscape mode or portrait mode 
Syntax:  'obj' Œwi 'PrintLandscape'boolean 

Description:  Protects or unprotects selected cells 
Syntax:  'obj' Œwi 'Protect'boolean' 
boolean:  1 if cells are to be protected 

Description:  Reads a file into the Formula One control 
Syntax:  'obj' Œwi 'Read'filetype filename 
filetype for version 6: excel5 excel7 excel95 excel8 excel97 fone3 fone4 fone5 fone6 tabbed tabbedv 
filetype for version 5: excel4 excel5 fone3 fone5 tabbed tabbedv 
filename: full DOS path name with extension 

Description:  Read a comma delimited ASCII text file into the spreadsheet 
Syntax:  'obj' Œwi 'ReadTextFile' textfilename 
textfilename:  complete ASCII file name 
Example: 'ff.ss' Œwi 'ReadTextFile' 'c:\temp\sales.txt'  

Description:  Selects one or more cells 
Syntax:  'obj' Œwi 'Select' {selection} 
selection:  a numeric argument suitable for the SetSelection method 
       or:  a character argument suitable for the Selection property 
       or:  omitted to select the whole spreadsheet 

Description:  Sorts lines according to values in 1, 2 or 3 columns 
Syntax:  'obj' Œwi 'Sort'col1 {col2} {col3} 
col1,col2,col3: column numbers (use negative numbers for descending sorts) 

Description:  Sets the vertical alignment for all selected cells 
Syntax:  'obj' Œwi 'VAlign' (specs){selection} 
specs: one of: 'top' 'center' 'bottom' 
selection: optional selection specification 

Description:  Set validation rule for selected cells 
Syntax:  'obj' Œwi 'Validation'rule text 
rule: an expression involving a Xn cell name. Example:  ' (A1 > 100) ' 
text: the error message text in case rule validation fails 

Description:  Returns Formula One control majopr and minor version numbers 
Syntax:  'obj' Œwi 'Version' 

Description:  Writes the current Formula One control into a file 
Syntax:  'obj' Œwi 'Write'filename filetype 
filetype for version 6: excel5 excel7 excel95 excel8 excel97 fone3 fone4 fone5 fone6 html htmldata tabbed tabbedv 
filetype for version 5: excel4 excel5 fone3 fone5 html htmldata tabbed tabbedv 
filename: full DOS path name with extension