Lotus 1 2 3 User Manual

Ed shows how you can use Lotus 1-2-3 keystroke macros or 95LX System Macros (User Defined Keys) to make using 1-2-3 on the HP 95LX a little easier.

[Although this article was written for the 95LX, the tips given should be useful to users of the new HP 100LX Palmtop PC -- Editor.]

By Ed Keefe

TLF Gold with Lotus CoP - £175.00 for first year then £48.00/year TLF Gold - £48.00/year FFM - UK - £24.00/year. 05 09 Sampling Sampling errors Lotus 1-2-3 05 08 Recruiting Spreadsheet User's manual 19, ABSTRACT (Continue on reverse if necessary and identify by block number) This report is a user's guide for a prototype spreadsheet program written in Lotus 1-2-3 (Version 3.1) to estimate survey costs and errors. Manuals and Software for Pocket PC, PDA, Handheld PC, HP Palmtop, Smartphone, and more! Manuals & Software. '1-2-3- Tips, Tricks, and Traps' for Lotus 1-2-3 By: Que Corporation. 1-2-3 For Dummies Quick Reference. 2007 lotus 2 eleven service manual.pdf Repair manuals 1.46 MB: English 41 Elan II M100: 1990 1990 elan service manual.pdf Repair manuals 24.6 MB: English 534 Elise I: 1996 - 2001 lotus elise series 1 service manual.zip Repair manuals. 'Microsoft Excel' or 'Lotus 1-2-3'. It is our goal to bring the user accurate, low-cost, easy-to-use data loggers that integrate easily into the user's working environment. To better understand the user's needs and to better serve the user, we welcome and appreciate your feedback.

Veteran users of 1-2-3 are familiar with the power of Lotus macros. They've discovered what great time-savers macros can be. On the other hand, new users take one look at the instructions for creating macros and shake their head in wonderment. Granted, Lotus macros can become quite complex. But that doesn't have to be the case.

In this article, we'll take a look at a few simple macros that you can create. All you'll need is your 95LX and a few minutes.

To show you how easy it is to create a Lotus macro, let's suppose that you wanted to change the format for a range of numbers to the currency format, with two numbers after the decimal point. To do this in 1-2-3, you'd press the following keys: (MENU) Range Format Currency 2 (ENTER), and then type in the range (e.g. A1..D5), or use the arrow keys to highlight the range. Finally you would press (ENTER). You can just as easily create a Lotus macro for this keystroke sequence.

How to Create Lotus Keystroke Macros

The process for creating a Lotus keystroke macro is easier to do than it is to explain.

Lotus stores its macros in empty cells, so the first thing you have to do is move the cursor to a spot in your worksheet that won't be used for anything else. Then type in an apostrophe ('), the keystrokes you want, and then press (ENTER). For example, to create a macro to format a range of cells to display two places after the decimal point in currency (e.g. 25.98), you would move to an empty cell (say, D1), type in '/rfc2~ and press (ENTER). You've created a keystroke macro -- that's all there is to it. (The keystrokes '/rfc2~ are called the 'label.' Note the leading apostrophe. Without this, you'd activate the 1-2-3 menu instead of writing a keystroke macro. Also note that the symbol in the macro language for (MENU) is the foreslash (/) and the symbol for (ENTER) is the tilde (~).)

There is also a macro Learn mode that lets Lotus record your keystrokes into macro instructions. For more on this feature, see page 13-27 of the HP 95LX User's Guide.

You can access this macro by pressing (ALT)-(F3) (Macro to run:), type in the cell where the macro is located (i.e. D1), and press (ENTER). 1-2-3 will read the macro in D1 and play back the keystrokes as if you had just typed them in. The message 'Range to format: A1..A1' will appear on the prompt line. (The A1..A1 part of the message will vary depending on the current location of the cursor.) You would then type in the range and press (ENTER).

You can run a keystroke macro more easily by doing the following. First, give the cell in which the macro is located a special name. To do this, press (MENU) Range Name Create F (ENTER) D1 (ENTER), where F is the name you've assigned to the cell, and D1 is the location of the macro. Note that the backslash () key on the 95LX is the Shifted ()), not (MENU). The backslash stands for (ALT) in 1-2-3 macro language. So to activate the macro located in D1, all you do is press (ALT)-(F).

Lotus 1 2 3 User Manual Free

It's kind of magical to press two keys and watch a large series of keystrokes executed automatically. It's this magic that has hooked a lot of good people into creating large libraries of Lotus keystroke macros.

Creating a Lotus Macro Library

Here's another time and keystroke saver that will keep you from having to type your macros into the next spreadsheet you develop.

Lotus 1 2 3 user manual instructions free

The procedure for doing this is a little more complicated than creating a single macro. It assumes that you've created several such macros and want to gather them together so that you can easily retrieve them.

The process involves creating a separate spreadsheet with all of your keystroke macros in it. After opening a new, blank worksheet, use the following procedure to copy individual keystroke macros to it.

Press (MENU) File Combine Copy Named/Specified-Range. You're then asked to key in the 'Range name or address:'. Reply by typing in the name you've given to your keystroke macro (F in the above example) and press (ENTER). Then you're asked to supply the name of the worksheet file that contains this macro. Highlight the filename and press (ENTER). The macro appears in the new worksheet.

You'll repeat this procedure to copy your other macros to this worksheet. Before you do, here's another tip to organize your macro library and make it look like it was done by a pro.

Copy each of your macros to a separate cell in column B of the spreadsheet. You must leave at least one blank cell between each macro.

In the cell to the left of the macro, type in the name of macro. For example, suppose you have '/rfc2 in cell B1. Then in cell A1, you might type 'F which is the name of the macro. (Don't forget the leading apostrophe.) Do the same for any other macros that you want to put in your macro library.

When you've got all you macros lined up, along with their names, put your cursor on the cell containing the first macro name (A1 contains 'F in this example) and press (MENU) Range Name Labels Right. Move the cursor down to the last macro name in the list (A5 or whatever and press (ENTER). This associates the names you've listed in the A column with the macros in the B column.

Save this new worksheet to a file called MACRLIB.WK1 (press (MENU) File Save macrlib (ENTER)). This is your 'Macro Library Worksheet.'

You can copy individual keystroke macros over from this worksheet to any worksheet you are working on. For example, from within a new worksheet you would put your cursor in an unused cell and press (MENU) File Combine Copy Named/Specified-Range. Next you would type in the name of the macro F or whatever) and press (ENTER). Finally, you would select MACRLIB.WK1 (your macro library file) and press (ENTER). The macro would be copied to the cell.

I'll give some specific examples of Lotus keystroke macros later in the article. All these tips and techniques will work on any PC that runs Lotus 1-2-3.

The 95LX's User Defined Keys

The 95LX's User Keys (system macros) have several advantages over 1-2-3 macros; they don't take up any space in a worksheet, they're easier to launch, and you don't have to search for a blank spot in the worksheet to put the macro. In fact, you can replace many Lotus keystroke macros with user Keys.

Let me give you and example of how to do this and then discuss some of the advantages and limitations of this approach. We'll create a User Key to perform the same currency formatting operation as we did with the '/RFC2~ keystroke macro.

There are two ways to create User Keys. The Learn Mode lets you enter the macro on the fly, recording into a user key each keystroke as you make it. The User Mode lets you enter and edit user key commands individually, much like writing a line of code in any programming language. For more on the Learn Mode, see page 21-17 of the HP 95LX User's Guide. I'll use the User Mode for this example.

Press (<Shift>)-(FILER) (CHAR) to enter the User Key Setup screen. Move your cursor down to an empty User Key slot and press (ENTER) (I'll use F7 in this example). In the Comment field, type in 123 Currency and press (ENTER). In the Contents field type in {MENU}rfc2{ENTER}. (You can key in {MENU} and {ENTER} by pressing (F6) first and then pressing (MENU) or (ENTER).) Press (F10) to leave the macro input screen and press (ESC) to return to the main SET UP screen.

Note the difference between the System Macro and the 1-2-3 macro. {MENU} replaces the foreslash (/) and {ENTER} replaces the tilde (~).

Now press (123) to activate Lotus. Activate the User Key by pressing (CHAR)-(F7) (or whatever F-key you've chosen). The 'Range to format:' message will appear on the prompt line. Use the arrow keys to highlight a range and press (ENTER). (If needed, press (ESC) prior to using the arrow keys to move the cursor to a new location and then press (.) (period key) to start highlighting.)

Transferring Keystroke Macros to User Keys

Here's a process for transferring your favorite Lotus keystroke macros to User Keys.

Open the worksheet that has the keystroke macro you want to transfer. Press (CTRL)-(F2), specify the range that contains the macro and press (ENTER) to copy the macro to the clipboard. The range may be one cell (Z1..Z1) for simple macros, or a large block of cells (Q1..Z10) for complex macros.

Activate MEMO and press (F4) to Paste the macro there. Change all foreslashs (/) to {MENU} and replace tildes (~) with {ENTER}. In addition if you use the DEL or ESC commands in your macro, you'll have to replace the left and right French brackets ({ and }) with {LBRACE} and {RBRACE}, respectively.

When you have made the necessary corrections to your macro, press (F9) (Mark), highlight the macro and press (F2) to copy it to the 95LX's clipboard again. Finally, press (<Shift>)-(FILER) Char, move the cursor to a blank macro, and press (ENTER) (ENTER) (F4) to paste the macro into the Contents field.

What Does All This Get You?

As mentioned, User Keys are easy to find and use, and don't take up space in a worksheet. However, they do have a drawback -- you're limited to ten of them at any one time. A previous Looking Glass column showed how to do this by swapping SETUP.ENV type files (see page 39-40, Mar/Apr 93 issue). However, to use this procedure, you have to leave 1-2-3, swap the SETUP.ENV files and then return to 1-2-3. The macro library file approach described earlier would be better if you have more than 10 Lotus macros you need to use.

Until next time, Happy Porting.

Getting Started: Ten Lotus 1-2-3 Macros

IBM Lotus SmartSuite
Lotus SmartCenter icon and screenshot of the Lotus SmartCenter toolbar in Windows XP
Developer(s)IBM
Initial release1992; 29 years ago
Final release
9.8.6 / 2008; 13 years ago - Discontinued Sep 30 2014[1]
Operating systemMicrosoft Windows, OS/2
TypeOffice suite
LicenseProprietary
Websitewww.ibm.com/software/lotus/products/smartsuite/

SmartSuite is a discontinued office suite from Lotus Software. The company made versions of its office suite for IBM OS/2 and Microsoft Windows.

Status[edit]

SmartSuite is no longer supported and maintained.

SmartSuite used to be in maintenance mode, and supported with fixes and fixpacks on Windows 2000 and Windows XP. SmartSuite is not officially supported by IBM on versions of Windows after XP, but it does work well on both the 32-bit and 64-bit versions of Windows Vista, Windows 7, and early Windows 10 versions if the installer and applications are run with XP compatibility mode set for the executable files. IBM has no plans to release an official Windows 7-compatible version of SmartSuite.[2]

eComStation 1.0 included the OS/2 version of Smartsuite.[3] It was an optional extra in later versions of eComStation.[4]ArcaOS does not include Smartsuite, but is able to run it.[5]

In 2007, IBM introduced a new office suite called IBM Lotus Symphony, unrelated to the Lotus Symphony integrated application suite that Lotus previously released.

In July 2012 the price for a user licence of Lotus SmartSuite 9.8 was US-$342.00 when purchased directly through the IBM website.[6]

In May 2013, IBM announced the withdrawal of SmartSuite. Marketing of the product ended in June 2013, followed by all support ceasing in September 2014. IBM has also announced that there will be no replacement for SmartSuite.[7]

Components[edit]

The following applications are included in SmartSuite for Microsoft Windows:

  • Lotus Word Pro — word processor; previously called Ami Pro; .lwp files
  • Lotus 1-2-3 — spreadsheet; .123, .wk1, .wk3, .wk4 files
  • Lotus Freelance Graphics — presentation software; .prz files
  • Lotus Approach — relational database; .apr (data entry and reports), .dbf (database) files
  • Lotus Organizer — personal information manager; .org, .or2, .or3 files
  • Lotus SmartCenter — a toolbar that let users quickly access programs, calendar, Internet bookmarks, and other resources
  • Lotus FastSite — web design software; .htm files
  • Lotus ScreenCam — screen recording software for demos and tutorials; .scm, .exe, .wav files
  • Lotus vCard & vCalendar Viewer — instant vCard and vCalendar viewer[8]

Version history[edit]

Microsoft Windows[edit]

  • (1994) - SmartSuite 2.1 (Ami Pro 3.0, 1-2-3 4.0, Freelance Graphics 2.0, Approach 2.0 and Organizer 1.1)
  • (1995) - SmartSuite 3.1 (Windows 3.11) — (Lotus 1-2-3 ver. 5, Approach 3.0, Ami Pro 3.1, Freelance Graphics 2.1, Organizer 2.1, ScreenCam 1.1).[9]
  • (1995) - SmartSuite 4.0 (Windows 3.11) - [10]
  • (1996) - SmartSuite 97 — Windows 95 and Windows NT 4.0 (1-2-3 97, Word Pro 97, Approach 97, Freelance Graphics 97, Organizer 97, ScreenCam 4.0 and SmartCenter)
  • (1997) - SmartSuite 4.5 (Windows 3.11) - (Word Pro 97 Edition for Windows 3.1.) [11]
  • (1999) - SmartSuite Millennium Edition (9.5) — (Organizer 5.0, Fastsite release 2, WordPro Millennium Edition, 1-2-3 Millennium Edition, Freelance Graphics Millennium Edition, Approach Millennium Edition, SmartCenter and ScreenCam).
  • (2002) October 2002: Latest version: SmartSuite Millennium Edition 9.8.
    • Fixpack 2 was the last version provided to the general public. All subsequent releases were only available to IBM Passport Advantage subscribers. Fixpack 3 was released in October 2005 and Fixpack 4 in October 2006. A subsequent Fixpack 5 was released in October 2007 followed by Fixpack 6 in December 2008, although these Fixpacks only contained changes to the Lotus Approach database software.[12]

Compatibility[edit]

Most SmartSuite programs are capable of reading and writing the corresponding Microsoft Office files. The Microsoft programs, however, are capable of reading only a few vintage formats of the Lotus programs, such as the older 1-2-3 .wks and .wk1 files. Furthermore, several of the SmartSuite components provide functionality not found in the Microsoft Office suite, for example Lotus FastSite and Lotus SmartCenter.

IBM vs Microsoft[edit]

Lotus 1 2 3 User Manual Instructions

In his finding of facts for United States v. Microsoft, Judge Jackson determined that because of IBM's marketing of Lotus SmartSuite, and other alternatives to Microsoft products (like World Book electronic encyclopedia instead of Microsoft's Encarta[13]), Microsoft 'punished the IBM PC Company with higher prices, a late license for Windows 95, and the withholding of technical and marketing support.'[14]

Microsoft did not grant IBM OEM rights for Windows 95 until 15 minutes prior to the release of Windows 95, August 24, 1995. Because of this uncertainty, IBM machines were sold without Windows 95, while Compaq, HP, and other indulgent companies sold machines with Windows 95 from day one.[15]

See also[edit]

  • Lotus Multi-Byte Character Set (LMBCS)

References[edit]

  1. ^'Software withdrawal and discontinuance of support: Lotus SmartSuite , Lotus Organizer and Lotus 123'. Retrieved 3 February 2020.
  2. ^Information about SmartSuite and Organizer working on the new Microsoft Windows Vista operating system
  3. ^'eComStation 1.0 Manual'(PDF). Retrieved 2020-09-03.
  4. ^'eComStation — OS/2 Renewed'. Retrieved 2020-09-03.
  5. ^'Installing Lotus SmartSuite on ArcaOS'. Retrieved 2020-09-03.
  6. ^IBM Lotus SmartSuite User License + SW Subscription & Support 12 Months (D5CTSLL) per https://www-112.ibm.com/software/howtobuy/buyingtools/paexpress/Express?P0=E1&part_number=D5CTSLL&catalogLocale=en_US&locale=en_US&country=USA&PT=html (31. July 2012))
  7. ^Software withdrawal and discontinuance of support: Lotus SmartSuite , Lotus Organizer and Lotus 123
  8. ^'Lotus vCard & vCalendar Viewer - Filefacts.com'. www.filefacts.com. Retrieved 2021-03-16.
  9. ^LOTUS SHIPS SMARTSUITE 3.1 FOR WINDOWS; NEW RELEASE FEATURES ORGANIZER 2.0, AUTOMATED INSTALLATION AND SMARTCENTER 2.0
  10. ^LOTUS ANNOUNCES SMARTSUITE 4.0 FOR WINDOWS 3.1 FEATURES NEW PRICING; NEW VERSIONS OF WORD PRO, ORGANIZER AND SCREENCAM
  11. ^Lotus Announces Availability of New SmartSuite 4.5 for Windows 3.1 Featuring Internet-enabled Word Pro Word Processor
  12. ^Fix list for SmartSuite for Windows 9.8 and fix packs
  13. ^Court's finding of fact, United States Department of Justice, Sec. 127. November 5, 1999
  14. ^'Full text of Judge Jackson's findings of fact'. CNet., Sec. 116. January 2007
  15. ^'Full text of Judge Jackson's findings of fact'. CNet., Sec. 125. January 2007

External links[edit]

Retrieved from 'https://en.wikipedia.org/w/index.php?title=IBM_Lotus_SmartSuite&oldid=1012414155'