Spreadsheet control program, spreadsheet control apparatus and spreadsheet control method
First Claim
1. A spreadsheet control program stored on a non-transitory computer readable medium for controlling a spreadsheet in a computer including a touch screen, the program causing the computer to execute:
- a line detecting step of detecting a line drawn on a predetermined window of the touch screen;
a ruled line recognizing step of recognizing the line detected at the line detecting step as a ruled line which is parallel with a transverse or vertical ruled line corresponding to a row or column of the spreadsheet to be displayed on the window;
a cell setting step of setting, to a single cell in the spreadsheet, a region in which a square formed by intersection points of the ruled lines recognized at the ruled line recognizing step is displayed when the square is formed; and
an input value accepting step of accepting data specifying the region set to the cell at the cell setting step as a value input to the cell over the spreadsheet when the data are input;
wherein when a height or width of a square formed newly is different from that of an corresponding to the square formed newly is set to be the same as that of the predetermined range, on the other hand, when a height or width of the square formed newly is different from that of the adjacent cell which is previously set within the predetermined range, a height or width of the cell corresponding to the square formed newly is set to be the same as that of the adjacent cell which is previously set at the cell setting step.
2 Assignments
0 Petitions
Accused Products
Abstract
Lines drawn on a touch screen with an inputting window opened are recognized as ruled lines which are parallel with a row or column of a spreadsheet, and a square formed by the ruled lines is set to a cell in the spreadsheet when the square is formed. Consequently, it is possible to create the spreadsheet when a user of a computer simply draws a line with a fingertip or the like over the touch screen, and furthermore, it is also possible to input a value to the cell by specifying the square part drawn with the lines to carry out an operation for inputting data. Thus, there is provided a spreadsheet creating interface which makes the most of a visibility and an operability of the touch screen.
9 Citations
10 Claims
-
1. A spreadsheet control program stored on a non-transitory computer readable medium for controlling a spreadsheet in a computer including a touch screen, the program causing the computer to execute:
-
a line detecting step of detecting a line drawn on a predetermined window of the touch screen; a ruled line recognizing step of recognizing the line detected at the line detecting step as a ruled line which is parallel with a transverse or vertical ruled line corresponding to a row or column of the spreadsheet to be displayed on the window; a cell setting step of setting, to a single cell in the spreadsheet, a region in which a square formed by intersection points of the ruled lines recognized at the ruled line recognizing step is displayed when the square is formed; and an input value accepting step of accepting data specifying the region set to the cell at the cell setting step as a value input to the cell over the spreadsheet when the data are input; wherein when a height or width of a square formed newly is different from that of an corresponding to the square formed newly is set to be the same as that of the predetermined range, on the other hand, when a height or width of the square formed newly is different from that of the adjacent cell which is previously set within the predetermined range, a height or width of the cell corresponding to the square formed newly is set to be the same as that of the adjacent cell which is previously set at the cell setting step. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A spreadsheet control apparatus comprising:
-
a touch screen capable of inputting/outputting data; line detecting means for detecting a line which is drawn on a predetermined window of the touch screen; ruled line recognizing means for recognizing the line detected by the line detecting means as a ruled line which is parallel with a transverse or vertical ruled line corresponding to a row or column of a spreadsheet to be displayed on the window; cell setting means for setting, to a single cell in the spreadsheet, a region in which a square formed by intersection points of the ruled lines recognized by the ruled line recognizing means is displayed when the square is formed; and input value accepting means for accepting data specifying the region set to the cell by the cell setting means as a value which is input to the cell over the spreadsheet when the data are input; adjacent cell which is previously set beyond a predetermined range, a height or width of a cell corresponding to the square formed newly is set to be the same as that of the predetermined range, on the other hand, when a height or width of the square formed newly is different from that of the adjacent cell which is previously set within the predetermined range, a height or width of the cell corresponding to the square formed newly is set to be the same as that of the adjacent cell which is previously set by the cell setting means.
-
-
10. A method of controlling a spreadsheet through a computer including a touch screen, comprising:
-
a line detecting step of causing the computer to detect a line drawn on a predetermined window of the touch screen; a ruled line recognizing step of causing the computer to recognize the line detected at the line detecting step as a ruled line which is parallel with a transverse or vertical ruled line corresponding to a row or column of a spreadsheet to be displayed on the window; a cell setting step of causing the computer to set, to a single cell in the spreadsheet, a region in which a square formed by intersection points of the ruled lines recognized at the ruled line recognizing step is displayed when the square is formed; and an input value accepting step of causing the computer to accept data specifying the region set to the cell at the cell setting step as a value input to the cell over the spreadsheet when the data are input; wherein when a height or width of a square formed newly is different from that of an adjacent cell which is previously set beyond a predetermined range, a height or width of a cell corresponding to the square formed newly is set to be the same as that of the predetermined that of the adjacent cell which is previously set within the predetermined range, a height or width of the cell corresponding to the square formed newly is set to be the same as that of the adjacent cell which is previously set by the cell setting means.
-
Specification