NCDesk
Global | Editor/Word Processor | Database | Spreadsheet | Window Manager | Mail | Multimedia
| Spreadsheet Features Functions Limitations | Fall 2004 | Spring 2005 | Summer 2005 | Fall 2005 | Spring 2006 | Summer 2006 | Fall 2006 |
| Size limited to a maximum of 31 rows and 15 columns. | Yes | match database limit 31 x 15 | Non-test limit increased to 500 x 500 | ||||
| Create a new spreadsheet with empty cells. | Yes ⇒ | ||||||
| Open a spreadsheet file (*.ncsh) or a comma-delimited file (*.csv). | Yes ⇒ | ||||||
| Close the current file and start a new empty file. | Yes ⇒ | ||||||
| Save the current file as a ncsh file. | Yes ⇒ | ||||||
| Save the current file as a ncsh file to a filename specified by the user. | Yes ⇒ | ||||||
| Cut selected cell(s). | Yes ⇒ | Support non-contiguous selections | |||||
| Copy selected cell(s) | Yes ⇒ | Support non-contiguous selections | |||||
| Pastes the cut/copied cell(s) starting at the upper-left most cell of
the selection area. |
Yes ⇒ | Support non-contiguous selections | |||||
| Select all cells. | Yes ⇒ | ||||||
| Delete selected cell(s). | Yes ⇒ | Support non-contiguous selections | |||||
| Remove the currently selected column(s). This is done either by selecting a cell in the column (for removing a single column), a range of cells in the column(s), or selecting the entire column(s). | Yes ⇒ | ||||||
| Remove the currently selected row(s). This is done either by selecting a cell in the row (for removing a single row), a range of cells in the row(s), or selecting the entire row(s). | Yes ⇒ | ||||||
| Insert a row. Rows are inserted above the currently selected row. | Yes ⇒ | ||||||
| Insert a column. Columns are inserted to the left of the currently selected row. | Yes ⇒ | ||||||
| Operators Supported: | |||||||
| + | Yes ⇒ | ||||||
| - | Yes ⇒ | ||||||
| * (multiply) | Yes ⇒ | ||||||
| / (division) | Yes ⇒ | ||||||
| Functions are added to the spread sheet by using the insert function dialog. The user is allow to insert a function into the selected cell by using the tool bar and then pressing the √ (square root sign) button on the tool bar. | Yes ⇒ | ||||||
| Functions Supported: | |||||||
| SUM | Yes ⇒ | ||||||
| AVERAGE (AVG) | Yes ⇒ | ||||||
| MINIMUM (MIN) | Yes ⇒ | ||||||
| MAXIMUM (MAX) | Yes ⇒ | ||||||
| Autosum Toolbar Button | Yes ⇒ | ||||||
| Sort Ascending: if one column is selected, it is sorted ascending. If more than one column is selected, an error message is displayed. | Yes ⇒ | ||||||
| Sort Descending: if one column is selected, it is sorted descending. If more than one column is selected, an error message is displayed. | Yes ⇒ | ||||||
| Chart Menu | Yes ⇒ | All chart data is based on selected cell data | |||||
| Pie Chart | Yes ⇒ | ||||||
| Horizontal Bar Chart | Yes ⇒ | Supports multi-column charts | |||||
| Vertical Bar Chart | Yes ⇒ | Supports multi-column charts | |||||
| Line Chart | Yes ⇒ | Supports multi-column charts | |||||
| Chart titles and edit axis labels | Yes ⇒ | ||||||
| JAWS Integration | TBD ⇒ | ||||||
| Zoom View | TBD ⇒ | ||||||
| Drag and drop cells | TBD ⇒ | ||||||
| Recalculation of formula upon cut/copy/paste actions | Yes ⇒ | ||||||
| Absolute and relative referencing | TBD ⇒ | ||||||
| Cell text formatting | TBD ⇒ | ||||||
This file was modified on Wednesday, August 29, 2007; at 1:36:39 PM