|
|
Track Changes
|
MS 2000
|
SO 5.1
|
|
|
|
Highlight modifications
|
+
|
+
|
|
|
|
Accept refuse/modifications
|
+
|
+
|
|
|
|
Modification log
|
+
|
+
|
|
|
|
Sort modifications by author
|
—
|
+
|
|
|
|
Sort modifications by date
|
—
|
+
|
|
|
|
Accept more than one modification at a time
|
+
|
+
|
|
|
|
Merge documents
|
+
|
+
|
|
|
|
Compare documents
|
—
|
+
|
|
|
|
Comments
|
+
|
+
|
|
|
|
Check comments continuously
|
—
|
+
|
|
|
|
|
|
|
|
|
|
Versioning
|
MS 2000
|
SO 5.1
|
|
|
|
Create new version
|
+
|
+
|
|
|
|
Create new version automatically
|
+
|
+
|
|
|
|
Switch between versions
|
+
|
+
|
|
|
|
Delete versions
|
+
|
+
|
|
|
|
Insert note
|
+
|
+
|
|
|
|
Compare versions
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Filter Functions
|
MS 2000
|
SO 5.1
|
|
|
|
AutoFilter
|
+
|
+
|
|
|
|
Top Ten filter
|
+
|
+
|
|
|
|
Standard filter
|
+
|
+
|
|
|
|
Special filter
|
+
|
+
|
|
|
|
Continuous filter
|
—
|
+
|
|
|
|
Maintain format after update
|
—
|
+
|
|
|
|
Insert/delete rows after update
|
—
|
+
|
|
|
|
|
|
|
|
|
|
Auditing Features
|
MS 2000
|
SO 5.1
|
|
|
|
Circular reference (single occurrence)
|
+
|
+
|
|
|
|
Circular reference (multiple occurrence)
|
+
|
+
|
|
|
|
Display preceding cell dependency graphically
|
+
|
+
|
|
|
|
Display succeeding cell dependency graphically
|
+
|
+
|
|
|
|
Update detective traces
|
—
|
+
|
|
|
|
Automatic update of detective traces
|
—
|
+
|
|
|
|
Find invalid values
|
—
|
+
|
|
|
|
Select cells containing only text, value or formula
|
+
|
+
|
|
|
|
Find cells containing file links or DDE links
|
+
|
+
|
|
|
|
Number of different error type cells
|
7
|
7
|
|
|
|
|
|
|
|
|
|
What-If Analysis
|
MS 2000
|
SO 5.1
|
|
|
|
Number of entries for data table
|
+
|
+
|
|
|
|
Frequency distribution
|
+
|
+
|
|
|
|
Goal seeking
|
+
|
+
|
|
|
|
Drag & drop fields for viewing
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Security Features
|
MS 2000
|
SO 5.1
|
|
|
|
Password-protect spreadsheet from display
|
+
|
+
|
|
|
|
Password-protect spreadsheet against changes
|
+
|
+
|
|
|
|
Password-protect range of cells from display
|
+
|
+
|
|
|
|
Password-protect range of cells against changes
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Consolidation Features
|
MS 2000
|
SO 5.1
|
|
|
|
Consolidate sheets-number of functions
|
11
|
11
|
|
|
|
Consolidate dissimilar sheets
|
+
|
+
|
|
|
|
Consolidate across rows or columns
|
+
|
+
|
|
|
|
Consolidate with links to source files
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Report Generation
|
MS 2000
|
SO 5.1
|
|
|
|
Save named report format
|
+
|
+
|
|
|
|
Scale worksheet at print time
|
+
|
+
|
|
|
|
Print fit-to-page
|
+
|
+
|
|
|
|
Specify number of pages to fit to
|
+
|
+
|
|
|
|
Print a spreadsheet chart only
|
+
|
+
|
|
|
|
Select page range
|
+
|
+
|
|
|
|
Print grid lines
|
+
|
+
|
|
|
|
Center print range on the page
|
+
|
+
|
|
|
|
Control direction of printing
|
+
|
+
|
|
|
|
Print/don't print graphic objects
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Multi-Sheet Capability
|
MS 2000
|
SO 5.1
|
|
|
|
User-selected 3D range for commands
|
+
|
+
|
|
|
|
User-selected 3D range for functions
|
+
|
+
|
|
|
|
User-selected non-contiguous 3D ranges
|
+
|
+
|
|
|
|
Enter data simultaneously in multiple sheets
|
+
|
+
|
|
|
|
Group worksheet for identical settings
|
+
|
+
|
|
|
|
Change order of spreadsheets by dragging
|
+
|
+
|
|
|
|
Link to active or inactive file
|
+
|
+
|
|
|
|
Link to range names
|
+
|
+
|
|
|
|
Cell moves update references in dependent sheets
|
+
|
+
|
|
|
|
DDE links
|
+
|
+
|
|
|
|
OLE support
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Charting Options
|
MS 2000
|
SO 5.1
|
|
|
|
Maximum data sets per graph
|
256
|
65K
|
|
|
|
Chart templates
|
+
|
+
|
|
|
|
Place/resize chart
|
+
|
+
|
|
|
|
Graph a range of data in one step
|
+
|
+
|
|
|
|
In-place chart editing
|
+
|
+
|
|
|
|
Graph by row or column
|
+
|
+
|
|
|
|
Name charts
|
+
|
+
|
|
|
|
Incorporate free form drawing/symbols
|
+
|
+
|
|
|
|
Chart preview
|
+
|
+
|
|
|
|
Chart as shown
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Chart Types
|
MS 2000
|
SO 5.1
|
|
|
|
3-D charts with OpenGL support
|
—
|
+
|
|
|
|
Area graphs
|
+
|
+
|
|
|
|
Doughnut graphs
|
+
|
+
|
|
|
|
Grouped (clustered or comparative) bars
|
+
|
+
|
|
|
|
High/low/close bars
|
+
|
+
|
|
|
|
Horizontal bars
|
+
|
+
|
|
|
|
Line graphs
|
+
|
+
|
|
|
|
Pie charts
|
+
|
+
|
|
|
|
Radar graphs
|
+
|
+
|
|
|
|
Scatter plots
|
+
|
+
|
|
|
|
Surface graphs
|
+
|
+
|
|
|
|
|
|
|
|
|
|
Titles, Legends and Axis
|
MS 2000
|
SO 5.1
|
|
|
|
Move chart title or legend position
|
+
|
+
|
|
|
|
Shadow boxes around any title
|
+
|
+
|
|
|
|
Skip factor
|
+
|
+
|
|
|
|
Angle axis labels
|
+
|
+
|
|
|
|
User-specified formatting of axis numbers
|
+
|
+
|
|
|
|
Scales can be logarithmic
|
+
|
+
|
|
|
|
User can set division factor for scaling
|
+
|
+
|
|
|
|
Major/minor grid options
|
+
|
+
|
|
Copyright 1994-2001 Sun Microsystems, Inc., 901 San Antonio
Road, Palo Alto, CA 94303 USA. All rights reserved.
