Spreadsheet control program, spreadsheet control apparatus and spreadsheet control method

摘要

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.

主权项

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.