New Vision Concepts
EZReader - Grid Help

    

Table of Contents

Return to the EZReader Users Manual top page.

 OverView

Coupled with ease-of-use and a full list of standard features, the EZReader grid provides a much needed office spreadsheet tool for users with visual impairments.

Number and string manipulations, mathematical operations and sorting, formatting and graphing are all supported by the EZReader grid.\

A Grid sheet supports 100 rows and 26 columns.

By default Grid files are saved to a proprietary MLG format, one that can maintain formatting information as well as cell content. Grid also has the option to export files in CSV format, which Excel can read. Note that CSV files do not contain formatting information.

The Grid cannot read, import or export Excel files.

All Grid files are saved into a common folder. Grid does not support the creation of new folders.

At this time, the Grid does not support graphs nor cell equations. Also, Grid cells do not have context menus.

 Basic Navigation

A value is entered by first selecting a cell and then typing alphanumeric content into the cell. The value of the currently selected cell is also displayed in a read-only textbox just below the file name. The file name is located just below the toolbar at the top of the page.

Only a single cell can be selected at a time.

The row and column headers of the selected cell are highlighted.

Grid provides actions that can be taken on a selected cell as well as actions that can apply to the row or column of the selected cell.

The Enter, TAB and arrow and keys are used to navigate the Grid. These actions take place even when a cell is being edited, i.e, pressing one of these keys during editing will save the new value and move to a new cell as described here.

The Ctrl-Hme and Ctrl-End key combinations can be used to jump to the upper left and lower right of a sheet.

The Hme key will select the cell at the top of the current column. The End key will select the cell at the bottom of the current column.

The Grid has a single sheet, whereas applications such as Excel allow multiple sheets.

The Search feature allows you to type in a value and have Grid scroll to the first cell that contains (not equals!) that value. The search is case-insensitive.

 Grid Main Screen

The Grid application does not use the normal Menu icons, which consists of multiple dots corresponding to the number of rows of icons the application uses. Under that system, the Grid would require 9 rows of icons, which would require that the user press the Menu button many times to navigate between the groups of icons provided by the Grid.

Instead, the Grid main screen displays an icon for each group of functions provided by the Grid application, for a total of 10 icons. That violates the EZReader design standard of using only 7 icons on the toolbar, but the signficiant reduction of clicks needed to get to a desired action icon is considered a reasonable trade.

The main row of icons will navigate to file functions, decimal place settings, cell alignment, calculator functions, print options, copy options, sort functions, row/column insertion functions and row/columnn resizing functions.

The secondary row of icons are provided below:

 Save Icons

These icons are displayed when the Save icon is pressed on the Grid Main Screen.

 Files Icons

These icons are displayed when the Files icon is pressed on the Grid Main Screen.

 Decimals Icons

These icons are displayed when the Decimals icon is pressed on the Grid Main Screen.

The Scope icon is quite critical in understanding the action of the 0-3 Dec icons. It has 3 settings - Cell, Column, and Grid. Their effects are as follows:

Note that the column and grid options are used to format cells with content. Cells with no content are not formatted.

The Scope icon is used throughout Grid to define the scope of icon actions. Note that if once changed, the Scope is applied to all rows of icons where the Scope icon is displayed.

 Align Icons

These icons are displayed when the Align icon is pressed on the Grid Main Screen.

 Calculator Icons

These icons are displayed when the Calculator icon is pressed on the Grid Main Screen.

To use one of the arithmetic functions, first click on a cell then press the function to be performed. The function will include all cells from the top of the column or from the left of the row, depending on the direction setting (down or right). Numeric content of cells is treated as a value of zero. Content such as "5d" is evaluated as the left-most numeric characters - "5" in this case.

The subtraction function is peformed as the first cell minus all other cells.

The multiple function multiplies all cells together.

The division function is peformed as the first cell divided by all other cells.

 Copy Icons

These icons are displayed when the Copy icon is pressed on the Grid Main Screen.

Paste takes a single value from the clipboard and puts it in the currently selected cell.

When using Clear and the scope is set to Grid, the user will be prompted to confirm that clearing all cells is intended.

 Sort Icons

These icons are displayed when the Sort icon is pressed on the Grid Main Screen.

 Insert Icons

These icons are displayed when the Insert icon is pressed on the Grid Main Screen.

The cells of inserted columns are left blank.

When a row or column is deleted, Grid moves all remaining rows or columns to fill the delete row or column.

 Resize Icons

These icons are displayed when the Resize icon is pressed on the Grid Main Screen.

Thank you for considering EZReader!