Full-Screen, Scrollable APL2 Spreadsheet Input/Output Editor P e t e r A. W. L e w i s Department of Operations Research Naval Postgraduate School Monterey, C A 93940 U S A Abstract A full-screen, scrollab]e, spreadsheet-like editor based on IBM's A P L 2 32-bit interpreter for 386/486based microcomputers is described. It is used for entering, examining, analyzing, editing and printing data_ Mixed numeric and character arrays can be read in from or written out to formatted D O S files (ASCII) or comma-delimited D O S files. Alternatively, a bulk mode input facility allows for rapid direct data entry, or data can be entered, examined and edited cell-by-cell in the usual way. A facility for coding missing values is also provided. No numerical coding of the data is needed. Columns, rows or blocks of data can be highlighted in a chosen color, shadowed, m o v e d or copied. In addition, A P L functions entered on the c o m m a n d line can use the blocks as input or output. The full notational and computational power of A P L is available. Major-to-minor (Icxicographic) sorts can be performed on selected columns,
/lp/association-for-computing-machinery/full-screen-scrollable-apl2-spreadsheet-input-output-editor-vqHhpKQW0a