The Input-Output system in the program is standardized through an Excel 5/6/7-compatible spreadsheet.
An example of this spreadsheet is opened when you select “Open a New Spreadsheet” from the File menu. This spreadsheet can also be used to perform modifications and calculations on data at any given time.
The main function of the spreadsheet is to import data from :
- an ASCII file,
- an Excel 5/6/7 compatible spreadsheet,
- Windows clipboard transfer by Cut/Copy/Paste option,
- direct keyboard input into the spreadsheet.
The spreadsheet will also export to :
- an ASCII file,
- to an Excel 5/6/7 compatible spreadsheet
- transfer data to Windows clipboard using Cut/Copy/Paste Option.
For Input:
Click the File menu, and select the Open New Spreadsheet option.
A new spreadsheet will appear.
In the toolbar of the spreadsheet, find the Read File Into Worksheet button, and click it.
The file name selection window will appear.
Select the file. It will be read into the spreadsheet.
To enter data from the keyboard, just type the numbers into the spreadsheet.
To copy data from another Windows program, cut/copy into the Clipboard from the other program, then click to the beginning cell in the spreadsheet, and select Paste from the Edit menu.
For Output:
Find the Save button on the toolbar of the spreadsheet.
The file name selection menu will appear. Select a file type and enter a file name.
To copy data to another Windows program, highlight the data range, then click the Edit menu and select Copy. Then, switch to the target Windows program, and use Paste.
Since this is a spreadsheet, you can do calculations, create new columns, etc.
There are also many buttons for various functions in the spreadsheet. By placing the cursor on a particular button you can read its function.
To Insert:
- A row : Click on the row you want the new row to appear. Find the + button in the toolbar of the spreadsheet, and click it. The new row will appear.
- A column : Click on the column you want the new column to appear. Find the + button in the toolbar of the spreadsheet, and click it. The new column will appear.
When the spreadsheet is to be closed, the program confirms the user’s intent to close:
