Method for controlling electronic spreadsheet on handheld touch device
First Claim
1. A method for controlling an electronic spreadsheet on a handheld touch device, comprising:
- calculation process;
receiving a selection touch signal for selecting cells, selecting the cells in the electronic spreadsheet according to the selection touch signal, performing calculation based on a preset processing method, and storing a calculation result;
display process;
receiving a first touch signal for moving the electronic spreadsheet from an initial position to an interim position, moving the electronic spreadsheet from the initial position to the interim position according to the first touch signal to display an blank area, and querying whether the calculation result exists and if so, displaying the calculation result in the blank area;
recovery process;
receiving a second touch signal for moving the electronic spreadsheet from the interim position back to the initial position, and moving the electronic spreadsheet back to the initial position according to the second touch signal so that the electronic spreadsheet covers the blank area,wherein, the preset processing method in the calculation process includes;
Step one;
determining whether the selected cells contain data and if no, the calculation result is Null;
if so, proceeding to Step two;
Step two;
determining the count of the data and if the count is 1, determining the data as the calculation result;
if the count is greater than 1, proceeding to Step three;
Step three;
determining whether at least some of the data are calculable and if no, computing with the data according to a non-calculable algorithm;
if so, proceeding to Step four;
Step four;
determining the count of calculable data and if the count is 1, determining the calculable data as the calculation result;
if the count is greater than 1, proceeding to Step five;
Step five;
computing with the calculable data according to a calculable algorithm.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention relates to a method for controlling an electronic spreadsheet on a handheld touch device, comprising an operation procedure, a display procedure and a recovery procedure. The operation procedure comprises: receiving a selection touch control signal for selecting cells, determining selected cells in an electronic spreadsheet according to the selection touch control signal, calculating according to a preset processing method, and storing the calculation result. The display procedure comprises: receiving a first touch control signal for controlling movement of an electronic spreadsheet from an initial position of the electronic spreadsheet to an interim position, moving the electronic spreadsheet from the initial position of the electronic spreadsheet to the interim position according to the first touch control signal to expose a blank area, querying whether the calculation result exists or not, and if yes, displaying the calculation result in the blank area. The recovery procedure comprises: receiving a second touch control signal for controlling movement of the electronic spreadsheet from the interim position to the initial position of the electronic spreadsheet, and moving the electronic spreadsheet to the initial position of the electronic spreadsheet according to the second touch control signal to cover the blank area. The calculation result can be displayed clearly by using the method, thereby facilitating use by users.
24 Citations
7 Claims
-
1. A method for controlling an electronic spreadsheet on a handheld touch device, comprising:
-
calculation process;
receiving a selection touch signal for selecting cells, selecting the cells in the electronic spreadsheet according to the selection touch signal, performing calculation based on a preset processing method, and storing a calculation result;display process;
receiving a first touch signal for moving the electronic spreadsheet from an initial position to an interim position, moving the electronic spreadsheet from the initial position to the interim position according to the first touch signal to display an blank area, and querying whether the calculation result exists and if so, displaying the calculation result in the blank area;recovery process;
receiving a second touch signal for moving the electronic spreadsheet from the interim position back to the initial position, and moving the electronic spreadsheet back to the initial position according to the second touch signal so that the electronic spreadsheet covers the blank area,wherein, the preset processing method in the calculation process includes; Step one;
determining whether the selected cells contain data and if no, the calculation result is Null;
if so, proceeding to Step two;Step two;
determining the count of the data and if the count is 1, determining the data as the calculation result;
if the count is greater than 1, proceeding to Step three;Step three;
determining whether at least some of the data are calculable and if no, computing with the data according to a non-calculable algorithm;
if so, proceeding to Step four;Step four;
determining the count of calculable data and if the count is 1, determining the calculable data as the calculation result;
if the count is greater than 1, proceeding to Step five;Step five;
computing with the calculable data according to a calculable algorithm. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
Specification