Lotus 1-2-3

Features and benefits

IBM Lotus 1-2-3 Release 9.8 offers powerful ways to work with numbers. The Lotus 1-2-3 Web tables allow users to bring live Web-based information into the spreadsheet to perform analysis functions.

Productivity features

• 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.

Internet integration

• 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.

IBM Lotus 1-2-3 Release 9.8 is sold as part of the IBM SmartSuite Release 9.8.

Oracle Fighting to Keep Linux Open and Free 30/08/2023

Oracle has just released a statement by...