Spreadsheet control program, spreadsheet control apparatus and spreadsheet control method
AssigneeUbiquitous Entertainment Inc.
InventorRyo Shimizu
Life of this patent
Estimating the term…
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.
Claims12
A spreadsheet control program 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.
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.
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.
Dependencies are inferred from the claim text.