| Productivity features : |
| • |
Speech-enabled SmartMaster templates
Voice-activated 1-2-3 SmartMaster templates let users move quickly through common tasks such expense reporting or loan amortization. (Note: IBM ViaVoice is not included.) |
| • |
Improved compatibility with Microsoft Excel
Enhanced filters provide better-than-ever read and write compatibility with Microsoft Excel files up to and including Excel 2000. Lotus 1-2-3 Release 9.8 reads and writes Excel text, numbers, formulas, formatting, drawings and charts. The Excel Menu finder also trains new Lotus 1-2-3 users to navigate Lotus 1-2-3. |
| • |
Copy and move worksheets
Lotus 1-2-3 allows users to move and copy entire worksheets. Users can drag the sheet to the desired destination or use the menu. |
| • |
SmartLabels
In Lotus 1-2-3 Release 9.8, SmartLabels let users summarize a range by typing "Total." Now, Lotus 1-2-3 also recognizes more than a dozen predefined terms such as "Subtotal," "Maximum" and "Average," making formula building faster and easier. Users can also add terms, assign synonyms and customize the list of SmartLabels. |
| • |
Automatic SmartFill
Filling a range with a sequence of text, dates or times is quicker and easier than ever with SmartFill. Lotus 1-2-3 Release 9.8 anticipates what users would like to type and enters suggested text. If "April" is entered in a cell and "M" is typed in the next cell, 1-2-3 automatically adds "ay" and waits for the user to accept it or type different text. |
| • |
More rows
Lotus 1-2-3 Release 9.8 worksheets have 65,536 rows. |
| • |
Ask the Expert
Provides detailed answers to users' questions, even if they are entered in the user's own words. |
| • |
Excel Menu Finder
Makes it easy for Excel users to work in Lotus 1-2-3. Users simply choose an Excel command to display the name of the equivalent Lotus 1-2-3 command. |
| • |
Technology
With Lotus 1-2-3 Release 9.8, workbooks can be launched and edited in Active Document containers such as Internet Explorer or Lotus Notes 4.6. In addition, users can embed and automate Active-X controls directly into Lotus 1-2-3. |
| • |
Euro currency support
Lotus 1-2-3 Release 9.8 supports the Euro currency. Lotus SmartSuite continues to support the ECU as well as the Euro. The currency is supported in cells and charts. |
| • |
Copy/Paste
Lotus 1-2-3 Release 9.8 can copy row heights and column widths to locations in the spreadsheet, saving setup time. |
| • |
Data validation add-in
Lotus 1-2-3 Release 9.8 allows users to set criteria to restrict the type of data they can enter in a cell or range of cells. With the Data Validation Add-in, users restrict cell entries by making sure that the type of data entered meets a particular condition. |
| • |
Auto Save
Lotus 1-2-3 Release 9.8 helps minimize data loss if a computer loses power. Users can have Lotus 1-2-3 automatically save changes to open files at regular intervals. |
| • |
Keyboard switching
Lotus 1-2-3 Release 9.8 allows users to switch to different keyboard layouts while editing a file. This feature is handy for international users. |
| Internet integration |
| • |
Web tables
Lotus 1-2-3 Release 9.8's Web tables enable users to send and pull useful data from any table on any HTML page of the Internet or corporate intranet and deliver it directly into a workbook. Stock quotes, for example, can be extracted live from a Web page and pulled into an investment portfolio spreadsheet. The Web table can be refreshed manually or automatically. |
| • |
Hyperlinking
Hyperlinks can be assigned to any spreadsheet, cell picture or button. They also can be created for Internet locations, spreadsheet ranges or objects and other files. |
| • |
HTML features
Lotus 1-2-3 Release 9.8 includes HTML 3.2 support for opening and converting spreadsheet ranges to HTML documents. Spreadsheet-specific extensions allow 1-2-3 users to share files using HTML as a common file format while preserving important spreadsheet information such as cell colors, formats, actual numbers (e.g., p = 3.14159265, not 3.14), named ranges and number formatting. Lotus 1-2-3 also offers native HTML support with XML support. |
| • |
Publishing Assistant
Lotus 1-2-3 Release 9.8 helps users select an entire workbook, a particular page or a selected range for Web output. The Publishing Assistant also provides options for adding a link to the original file for other users to download. |
| • |
HTML on Clipboard
This feature selects data from browsers or Lotus Notes Release 5 and pastes it into Lotus 1-2-3 as a parsed HTML table. |
| |
*IBM Lotus 1-2-3 Release 9.8 is sold as part of the IBM SmartSuite Release 9.8. |
