Editing Cell Contents
uTo use drag and drop to obtain the data points of a graph
Example: To obtain the data points of the bar graph shown below
(1)Input data and draw a bar graph.
•See “Other Graph Window Operations” on page
(2)Tap the Graph window to make it active.
(3)Tap the top of any bar within the Graph window, and then drag to the cell you want in the Spreadsheet window.
•This will cause the bar graph’s data to appear beginning at the cell you tapped.
Recalculating Spreadsheet ExpressionsYou can use the Recalculate command to recalculate the cells in a spreadsheet. You should use Recalculate as described below.
•Let’s say there is a calculation expression (like = a + 1) that includes a variable input in a
spreadsheet cell. When you assign a new value to the variable in the calculation expression (“a” in this example), the new value is not immediately reflected in calculation result that
is displayed as the cell’s value. After assigning a value to a variable in a calculation expression, you need to execute the Recalculate command to update the calculation result.
•While the Spreadsheet application is being accessed from the Main application, changes you make to values assigned to variables on the Main application window are not reflected immediately on the Spreadsheet application window. In this case, you need to make the Spreadsheet application window active and execute the Recalculate command to update its contents.
Tip
•Recalculate is executed automatically whenever you switch to the Spreadsheet application from another application, and whenever you open a spreadsheet file.
•For information about accessing the Spreadsheet application or another application from the Main application, see
20060301