9-2
Restrictions on the Use of Spreadsheet Strips in the eActivity Mode
Main Memory data storage capacity is approximately 60KB. Approximately half of that (a little
less than 30KB) is the maximum amount of data storage available in the eActivity mode.
Approximately half of the eActivity mode storage memory (a little less than 15KB) is the
maximum allowable Spreadsheet file size in the eActivity mode.
Because of this, inserting a Spreadsheet strip into an eActivity and performing a spreadsheet
operation can cause limitations due to insufficient memory capacity. The following are
examples of conditions that would cause the maximum file size to be exceeded.
(1) Inputting numeric data into spreadsheet cells A1 through A999, B1 through B999, and C1
through C520
In this case, the Spreadsheet strip of the eActivity will show only A1 through A999 and B1
through B80.
(2) Without inputting any data into the spreadsheet, assigning the conditional formatting shown
below to all of the cells from A1 through A999 and B1 through B430
- For “Type”, select “Expression”.
- Input the following expression: B1=2 A1^3+3 A1^2+4 A1+5.
In this case, the Spreadsheet strip of the eActivity will show only A1 through A999 and B1
through B410.
k Spreadsheet Screen Function Menu
• { FILE } ... Displays the following FILE submenu.
• { NEW } / { OPEN } / { SAVE
•
AS } / { RECALCS }/{CSV}
• { EDIT } ... Displays the following EDIT submenu.
• { CUT } / { PASTE } / { COPY } / { CELL } / { JUMP } / { SEQ } / { FILL } / { SORTASC } / { SORTDES }
• PASTE is displayed only immediately after CUT or COPY is executed.
• { DELETE } ... Displays the following DELETE submenu.
• { ROW } / { COLUMN } / { ALL }
• { INSERT } ... Displays the following INSERT submenu.
• { ROW } / { COLUMN }
• {CLEAR} ... Displays the following CLEAR submenu.
• {CONTENT}/{FORMAT}/{ALL}
• { GRAPH } ... Displays the following GRAPH menu. (Same as in the Statistics mode.)
• { GRAPH1 } / { GRAPH2 } / { GRAPH3 } / { SELECT } / { SET }
• { CALC } ... Displays the following CALC (statistical calculation) menu. (Same as in the
Statistics mode.)
• { 1-VAR } / { 2-V
AR } / { REG } / { SET }
• { STORE } ... Displays the following STORE submenu.
• { VAR } / { LIST } / { FILE } / { MAT }/{VCT}
• { RECALL } ... Displays the following RECALL submenu.
• { LIST } / { FILE } / { MAT }/{VCT}
• {CONDIT} ... Displays the conditional formatting setting screen.
• {COND1}/{COND2} ... Displays the {Condition1}/{Condition2} screens.
To Next Page
Loading...
Need help?
General
