Microsoft KB Archive/26861

Works: Spreadsheet Specifications for Versions 1.x and 2.00

PSS ID Number: Q26861 Article last modified on 06-10-1996

1.00 1.10 2.00

MACINTOSH

Summary:

The following specifications and limitations are common to Microsoft Works versions 1.00, 1.10, and 2.00 spreadsheets:

  Maximum file size: Approximately 7,500 filled cells (512K Mac – Works 1.x only) Approximately 22,500 filled cells (Mac Plus, SE, Mac II); actual limit depends on specific file contents and will increase proportionately with expanded RAM.   Maximum number of decimal places in a value: 15   Calculating precision: 15 decimal places   Maximum column width: 40 characters   Minimum column width: 1 character   Maximum length of text or value: 238 characters   Maximum length of formula: 200 characters   Maximum number of chart definitions per spreadsheet: 8 </li>  Number of chart types available: 5 </li>  Maximum paper length: 273 inches (with Custom Size paper option) </li>  Minimum paper length: 1 inch </li>  Maximum paper width: 273 inches </li>  Minimum paper width: 1 inch </li>  Default paper size: US Letter (8.5 x 11 inches) </li>  Default top, bottom, left, and right margins: 1 inch </li>  Default font: 9-point Geneva </li>  Maximum length of search/replace strings: 80 characters </li>  Maximum length of headers or footers: 99 characters </li>  Range of numbered pages in a document: 1 through 9,999 </li>  Number of sort columns: 3 </li></ol>

The following items changed from versions 1.x to 2.00:

Item Versions 1.x Version 2.00 —- ———— ————

Maximum worksheet size 9,999 by 256 16,382 by 256

Total number of built-in functions 56 64

The following features were added to Works version 2.00:


 * Select All command
 * Date and Time functions
 * Support of serial date
 * Cell notes support
 * Cell bordering
 * Cell Attributes command
 * Freeze Titles commands

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: 1.00 1.10 2.00 mswksmisc mswksss =

Copyright Microsoft Corporation 1996.