DeskWorks®

An Interactive Spreadsheet For The AS/400

Fast Facts Latest Release:  4.50 Last Update:      March 1997 Price:                   $695.00 Source Code:     Not Available

DeskWorks® provides AS/400 users with the ability to use the system for spreadsheet processing, supporting the creation, revision, storage, and printing of spreadsheets.

Highlights

• Full screen interactive spreadsheet display
• Advanced spreadsheet features: variable column widths, titles, multiple windows, sort, cut, paste, search, cell protection, range names, and macros
• 80 functions for use in formulas
• Interfaces to OfficeVision/400, DisplayWrite/36, and Business Graphics Utility
• User interface similar to OfficeVision/400 and DisplayWrite/36
• Ease of operation, with full HELP key support
• Multiple user support

Description

DeskWorks® has the following features:

• Spreadsheet sizes of up to 999 columns by 9,999 rows.
• Full screen spreadsheet display. The entire screen is used to display spreadsheet data. Eighteen rows and a variable number of columns (depending on column widths) are shown.
• Cell formulas of up to 156 characters long. Addition, subtraction, multiplication, division, exponentiation, string combination, and logical operations are supported, as well as the ability to reference other cell values within a formula. Formulas can include up to 10 levels of nested expressions (functions with parameters count as 2 levels).
• 80 functions for use in formulas. Mathematical, logical, special, string, date and time, financial, and statistical functions are provided. Two of the special functions allow interactive retrieval of data from other DeskWorks® spreadsheet members and from system data files.
• Numeric and string results. Numeric results can be up to 10 digits to the left and 7 digits to the right of the decimal. String results can be up to 74 characters long.
• 12 cell display formats. Cell results may be shown in 7 numeric formats (numeric, edited numeric, dollar, percent, date, time, and non-display), 3 string formats (left-justified, right-justified, and centered), and 2 graphic formats (asterisk and plus/minus).
• Spreadsheet cursor movement. The spreadsheet cursor may be moved one cell, an entire page, or to the upper left cell of the display or spreadsheet.
• Change cell location. The spreadsheet cursor may be moved directly to a specified cell and window.
• Change column width. The width of a specified column may be changed. Columns can be 0-74 characters wide.
• Delete row/column. Entire columns or rows of cells may be deleted.
• Edit cell formula. The display format, number of decimal places to display, and formula for the current cell may be entered or changed.
• Print spreadsheet. The spreadsheet cell values or formulas may be printed to a printer, AS/400 disk file, or System/36 library source member. If a cell value listing is requested which exceeds the form width, the additional columns will be continued on the following pages. Cell formula listings are also adjusted to print in the available area. Output which has been placed into a disk file or source member may then be included into an OfficeVision/400, DisplayWrite/36, or other word processing software document, or processed by a user-written program.
• Range options. A cell or range of cells may be copied, moved, formatted, erased, protected, unprotected, copied changing the formulas to values, added or subtracted to destination cells, assigned a name, or searched.
• Insert column/row. Entire columns and rows of blank cells may be inserted.
• Recalculate. The entire spreadsheet may be recalculated. The recalculation is performed in "natural order," which means that a formula is not calculated until all of the other formulas that it depends on have been calculated.
• Global options. The PAGE keys cursor movement option, cursor auto-move direction and scroll option, default cell display format and number of decimal places to display, default column width, cell protection option, and auto-execute macro option and location may be specified.
• Title options. Columns and rows may be fixed in place so that they remain on the display when the spreadsheet is scrolled, or output on each page when the spreadsheet is printed.
• Window options. The spreadsheet area may be split to view up to 4 different sections of the spreadsheet at the same time.
• Sort rows. A range of rows may be sorted by the values contained in one or two columns.
• Run options. A spreadsheet macro may be executed, a graphics chart may be displayed (using BGU), or a user-written AS/400 program or System/36 procedure may be executed. After a chart has been displayed or a user-written program has been run, control will be returned to the spreadsheet.
• Cut section. A section of the spreadsheet may be copied to the DeskWorks® clipboard, to be included elsewhere in the same spreadsheet or copied to another spreadsheet.
• Paste section. A member section previously copied to the DeskWorks® clipboard may be copied to the spreadsheet. An option provides the ability to copy entire cells, copy cell values, add or subtract cell values to the destination cells, or copy cell formats.
• File to spreadsheet download. A batch command is provided to create a DeskWorks® spreadsheet member from a system data file when large amounts of data are to be downloaded. Up to 100 data fields from the file may be selected for inclusion in the spreadsheet.
• Conversion from Lotus® worksheets. A batch command is provided to convert a Lotus® worksheet file to a DeskWorks® spreadsheet, including conversion of cell values, formulas, and range names.
• User interface similar to OfficeVistion/400 and DisplayWrite/36. A work with spreadsheets interface provides functions to manage DeskWorks® members, using commands and displays similar to those used in OfficeVision/400 and DisplayWrite/36.
• Ease of operation. DeskWorks® has been designed to be easy to learn and use by the display station user, with a minimum of training required. The user may press HELP on any display for an explanation of the various functions and options available.
• Library storage. DeskWorks® members are stored as AS/400 compressed file members or System/36 library source members, enabling the use of system utilities for off-line storage of members, and the use of system resource security for security considerations.
• Multiple user support. DeskWorks® may be used by any number of users concurrently.

Technical Information

Specified Operating Environment

Hardware Requirements: DeskWorks® requires the following minimum system configuration:

• AS/400 (any model)
• One display station
• One printer
• 3.0Mb of auxiliary storage

• Operating System/400 (5728-SS1), Version 1 Release 3.0 or later
• Business Graphics Utility (5728-DS1), required only for displaying and printing graphics
   

DeskWorks® is a registered trademark of System Support Products, Inc.

Please contact our Webmaster with questions or comments.
© Copyright 2001 Generic Software, Inc.  All rights reserved.