home *** CD-ROM | disk | FTP | other *** search
- >a2:" LESSON3 -- Storing & Printing Your Spreadsheet
- >a5:" Begin by moving the cursor to line 11 and enter the CREATE TWO
- >a6:" WINDOWS Command:
- >a8:" Control--x 2 {answer no to the 'Synchronize Windows' prompt}
- >a10:" Retrieve a copy of the 'b:stockex.pc' file and place it in the top
- >a11:" window. This requires you go to the Other Window using the OTHER
- >a12:" WINDOW Command.
- >a13:" Control--x o (the letter 'o')
- >a14:" Then find the 'b:stockex.pc' file with the FIND FILE Command:
- >a15:" Control--x Control--f
- >a16:" When Perfect Calc responds, "File to find <CR>: ", enter:
- >a17:" 'b:stockex.pc' {Remember to give the disk drive the file is
- >a18:" located on}, followed by a carriage return.
- >a20:" As before, scroll the bottow window with the 'Other Window' commands.
- >a22:" When you read a file from diskette into the computer's memory it
- >a23:" is copied into a temporary work space called a 'buffer'. While
- >a24:" in the memory buffer, the spreadsheet represents only
- >a25:" a 'copy' of the original spreadsheet which still remains on diskette.
- >a26:" Any changes you make to the copy in the buffer does not affect the
- >a27:" original version until you enter the SAVE FILE Command which then saves
- >a28:" the file by writing it onto the diskette, a process which
- >a29:" OVERWRITES the original file with the modified version.
- >a30:"
- >a31:" Perfect Calc provides two commands for storing your spreadsheet.
- >a32:" The first is the SAVE FILE Command. At anytime during spreadsheet
- >a33:" editing type:
- >a34:" Control--x Control--s
- >a35:" Perfect Calc begins saving the spreadsheet to disk. During this
- >a36:" process it displays the message: "Writing STOCKEX.PC..."
- >a37:" Perfect Calc copies the spreadsheet to disk, overwriting whatever
- >a38:" original version of the spreadsheet was there before. If used often,
- >a39:" the SAVE FILE Command guards against accidental losses of new data
- >a40:" during long editing sessions.
- >a41:" The second command for storing a spreadsheet file is the WRITE
- >a42:" FILE Command, which allows you to save a spreadsheet to disk under a
- >a43:" DIFFERENT file name, thereby preserving the original version of the
- >a44:" spreadsheet on disk under the original filename. (The result is two
- >a45:" files saved on disk--the original and the modified copy). Let us
- >a46:" practice the WRITE FILE Command:
- >a47:" Control--x Control--w
- >a48:" Perfect Calc responds with the message:
- >a49:" "Write to file: <CR> "
- >a50:" Type a new filename for the Stock Portfolio spreadsheet, 'b:stocktwo.pc'
- >a51:" Perfect Calc writes the spreadsheet to disk under the new file
- >a52:" name. During this write operation the message is displayed:
- >a53:" "Writing B:STOCKTWO.PC..."
- >a54:" After the write operation is complete Perfect Calc returns you
- >a55:" to the spreadsheet to continue working. The spreadsheet now exists in
- >a56:" in two file locations: the old version, 'stockex.pc', and the newly
- >a57:" modified version, 'stocktwo.pc' . The file you are working with is
- >a58:" now called 'stocktwo.pc', and hereafter, should a SAVE FILE Command
- >a59:" be given, Perfect Calc will overwrite the new version you have just
- >a60:" written to disk.
- >a61:" PRINTING
- >a62:" Printing the spreadsheet is very simple, and can be performed
- >a63:" at anytime during editing. You can print either the entire spread-
- >a64:" sheet, or any defined region of it. Let us print 'stocktwo.pc' now.
- >a65:" Make sure your printer is turned on and properly attached. If you have
- >a66:" no printer, ignore the print commands. Enter the PRINT Command:
- >a67:" Control--x Control--p
- >a68:" Perfect Calc responds with the message: "Print to file: <CR> "
- >a69:" Hit a carriage return. Perfect Calc outputs the spreadsheet to
- >a70:" your printer. Perfect Calc prints by columns. It will print the first
- >a71:" 80 character-columns in their entirety before proceeding to print the
- >a72:" second 80 character-columns. For spreadsheets that are long (i.e.,
- >a73:" have many lines), it may take several pages to print the first screen-
- >a74:" ful of columns, before moving on to print the next group of columns.
- >a76:" Printing a 'region' of the spreadsheet is accomplished in
- >a77:" exactly the same way, except that before executing the PRINT REGION
- >a78:" Command, you must define the region to be printed. Let us see how this
- >a79:" works by printing the first column of our spreadsheet.
- >a81:" Position the cursor at 'a1'.
- >a82:" Set a boundary mark using the MARK SET Command:
- >a83:" Escape...<space bar> {the long bar used for typing spaces}
- >a84:" Perfect Calc responds: "Mark set at a1" .
- >a85:" Move the cursor to the bottom of the column using the BOTTOM OF
- >a86:" COLUMN Command:
- >a87:" Escape...>
- >a89:" (The new position of the cursor marks the other boundary of the
- >a90:" region to be printed.)
- >a92:" Now, type the PRINT REGION Command:
- >a94:" Control--x p
- >a96:" When Perfect Calc responds "Print to file", type a carriage
- >a97:" return. Perfect Calc prints the defined region.
- >a101:" PRINTING TO 'PERFECT WRITER'
- >a102:" It is possible to print the spreadsheet, or any portion thereof,
- >a103:" to disk as a 'screen image'. This is unlike the form in which a file
- >a104:" is stored using the WRITE FILE or SAVE FILE Commands. Printing to
- >a105:" disk is convenient when you want to include your spreadsheet in a
- >a106:" report that you are preparing with Perfect Writer. Execute the print
- >a107:" commands as you would normally, except that when Perfect Calc presents
- >a108:" the message "Print to file", supply a file name that can later
- >a109:" be accessed by Perfect Writer. (Perfect Writer uses the suffix ".mss"
- >a110:" on all its filenames. Thus, 'stocktwo.pc' will become 'stocktwo.mss'.)
- >a111:" This concludes the lesson on storing and printing your spread-
- >a112:" sheet. If you wish to continue to the next lesson which deals with
- >a113:" replicating formulas, inserting, deleting, and moving, clear the
- >a114:" entire memory and read in the "lesson4.pc" file.
- >a116:" The CLEAR ENTIRE MEMORY Command is: Control--x Control--k
- >a118:" The FIND FILE Command is: Control--x Control--f
- >a120:" If you do not wish to continue with the lessons, type the
- >a121:" QUIT Command:
- >a123:" Control--x Control--c
- >a125:" Answer 'y' for yes to Perfect Calc's question: "Ignore changes
- >a126:" this session?"
- >a128:" END OF LESSON 3
- >a1