Lotus 1-2-3

Speech-enabled SmartMaster templates: Voice-activated 1-2-3 SmartMaster templates let users move quickly through common tasks, such as 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.

@Functions provide analytical power and improved Microsoft Excel compatibility.

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.

Web tables: Lotus 1-2-3 Release 9.8 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 (for example, 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.