Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
This is what I derived as my provisional guide for a Microsoft Office user who needs to print from an inherited 1-2-3 spreadsheet while using Lotus. (Note that .123 files cannot be opened directly in Excel. From 1-2-3 you can export to Excel 97 format, but that sometimes is a long and tiring process.)
Heretically posting a Lotus question here might be redeemed in that it is a small example of how pathetic 1-2-3 is. (I have to say, as utterly lame and foolish as Microsoft is, IBM leaves them in the dust for cluelessness. Redmondites should be prohibited from touching computers; IBMers should be placed in padded rooms.)
A quick primer in 1-2-3 printing:
It only prints what’s selected. Select, then print. If you click a sheet and print, it ignores what sheet you're on. (This means, over and over in the future, when you have to print a sheet again, you have to locate and define the print area every single time. Lovely when there are thousands of lines of supporting calculations there.)
Always preview first, so you can ...
Check and correct as necessary in the preview box:
- Landscape?
- Number of copies?
- Fit all to page (etc.) ?
- Margins
Each of these stays the same as the previous page printed - thus the need to check and correct.
E.g. if you change number of print copies to 3, it stays there until told otherwise - even if you go to another sheet and select something there. All this is because 1-2-3 doesn’t know or remember different margins for different sheets, or that one sheet should be landscape, etc. For crying out loud!
Any corrections or further advice from anyone who has to do this?
Heretically posting a Lotus question here might be redeemed in that it is a small example of how pathetic 1-2-3 is. (I have to say, as utterly lame and foolish as Microsoft is, IBM leaves them in the dust for cluelessness. Redmondites should be prohibited from touching computers; IBMers should be placed in padded rooms.)
A quick primer in 1-2-3 printing:
It only prints what’s selected. Select, then print. If you click a sheet and print, it ignores what sheet you're on. (This means, over and over in the future, when you have to print a sheet again, you have to locate and define the print area every single time. Lovely when there are thousands of lines of supporting calculations there.)
Always preview first, so you can ...
Check and correct as necessary in the preview box:
- Landscape?
- Number of copies?
- Fit all to page (etc.) ?
- Margins
Each of these stays the same as the previous page printed - thus the need to check and correct.
E.g. if you change number of print copies to 3, it stays there until told otherwise - even if you go to another sheet and select something there. All this is because 1-2-3 doesn’t know or remember different margins for different sheets, or that one sheet should be landscape, etc. For crying out loud!
Any corrections or further advice from anyone who has to do this?
