Thu. March 28 2024 @
Username:    Password:   
center-left.png center-right.png
Navigation
 Main
Home
In Remembrance
TI99ers Awards (UPDATED)
TI99ers Hall of Fame
Web Links
Event Calendar
Articles
TI-99/4A Emulators
Search
News Categories
Privacy Policy
Contact Me

 Members Only
blank.gif blank.gif
Event Calendar

Summer
Sun Mon Tue Wed Thu Fri Sat
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31            
Legend:
Normal: 
Event: 
Today: 
blank.gif blank.gif
Member Birthdays

Month of March

03/03 - jslicer
03/31 - harleystroker2

No Birthdays Today

blank.gif blank.gif
Forum Threads
Newest Threads
bullet.gif Call for Jim Peterso...
bullet.gif OLUG Rules
Hottest Threads
No Threads created
blank.gif blank.gif
Latest Articles
bullet.gif Nominations Closed
bullet.gif Nominations are closed
bullet.gif Multiplan Part 10 by...
bullet.gif Multiplan Part 9 by ...
bullet.gif Multiplan Part 8 by ...
blank.gif blank.gif
Articles Hierarchy
Articles Home » Multiplan by Audrey Bucher » Multiplan Part 5 by Audrey Bucher
purple-btm-left.png purple-btm-right.png
Multiplan Part 5 by Audrey Bucher
In this article, we are going to concentrate on the Print Command. One word of caution, be sure you recalculate your spreadsheet before printing. If you are saving the spreadsheet, Multiplan will automatically recalculate if you have made any entries, but this is not true with the Print command. There are four subcommands under Print...Printer, File, Margins and Options. Printer will begin printing if printer is turned on. File is used to print the record to disk. This may then be loaded into TI Writer and edited or included in a document.

The other two subcommands are the ones you will mostly be dealing with. I usually set the Options first. The command line when you select O is as follows:

area:R1:255
setup:
formulas Yes (No) r-c nums: Yes (No)

I usually change the area to print only the rows and columns that my spreadsheet occupies. For instance, R1:16C1:11 in our sample check balance sheet. When the sheet is saved, the changes are saved with it. On some of my spreadsheets that are quite lengthy, I usually only print the bottom four lines that give at totals at various times during the month and then at the end of the month, I will print the entire sheet to have a copy of the month's activities. Another option to enter in the area section is a Name. This would be used to print only a specific part of your worksheet that you have named. (More about that next month)

In the setup area you will put your printer configuration. Ex. I use PIO here.

The defaults for printing the formulas and row column numbers are both No. However if there is a reason you would like to have them printed, just change these to Y. If you choose to print formulas, the listing will display the actual formulas that appear in each cell, rather than the calculated values of the formulas as it normally would. This feature is useful when you want a record of the logic behind the worksheet. Column widths are doubled when formulas is set to Yes. Next, I usually set the Margins. When choosing M, the command line will be as follows:

left:5 top:6
width:70 print length:54
page length:66

The left margin and top margin are given as number of characters, the print length and page length are given in number of lines. You may change these defaults to anything you like in order to center your printout on the page if you choose.

Multiplan will print as many columns across the page as will fit within the margins you set. Any columns left over will be printed on a second page with row and column numbers continued. This method of printing permits you to cut and attach the printed pages to form a worksheet with the same dimensions you set up on the screen. Most of my spreadsheets have at least 15 columns in them and I prefer to print them all on one sheet of paper, so I use condensed print. I use the TIMP Print program by Jack and BJ Mathis that allows you to set printer controls from within Multiplan using the external copy command. It is a Fairware program and is in our library. It has files for many different kinds of printers, select the one that applies to your printer and copy it to your MP disk so it can be accessed.

Because I use condensed print, I set my width to 132. Again, I usually adjust my print length and page length to suit the particular spreadsheet that I as working with at the time. Saves the printer from putting a lot of blank lines on the paper if it is a short spread sheet.

Now that you have all the margins and options set, just hit P for print and the printer will start to hum away. If you wish to cancel printing just hit FCTN 4 (Print Cancel). During printing, the Print Cancel key is the only key that is functional and it is only effective while 'PRINT on printer' is displayed on the command line. If the printing is canceled, MP will display the 'Printer error' message.

Next month we'll talk about the Name command. Any questions, feel free to call.
purple-btm-left.png purple-btm-right.png
Comments
No Comments have been Posted.
purple-btm-left.png purple-btm-right.png
Post Comment
Please Login to Post a Comment.
purple-btm-left.png purple-btm-right.png
Ratings
Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.
purple-btm-left.png purple-btm-right.png
Login
Username
Password


Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
blank.gif blank.gif
Users Online
bullet.gif Guests Online: 28

bullet.gif Members Online: 0

bullet.gif Total Members: 147
bullet.gif Newest Member: suberbanator
blank.gif blank.gif
Shoutbox
You must login to post a message.

December 21 2017
I wish each and everyone one a very Blessed Christmas and a prosperous New Year! Santa

December 31 2016
Happy New Year all Smile

June 23 2016
Hi Mike, welcome Smile. There are still lots of TI99 users out there Smile

June 22 2016
Just wanted to say 'I'm glad I found you!' Pulled out my TI and have started to play with it again. I forgot how much fun it was. Wish there were more people out there still using it!

April 23 2016
Hello my fellow ti99ers, have a great weekend Smile

blank.gif blank.gif
Member Poll
There are no polls defined.
blank.gif blank.gif
centerb-left.png centerb-right.png
center-left.png center-right.png
centerb-left.png centerb-right.png