JP5735823B2 - Spreadsheet control program, spreadsheet control device, and spreadsheet control method - Google Patents

Description

  The present invention relates to a spreadsheet control program, a spreadsheet control device, and a spreadsheet control method for controlling an operation when editing a spreadsheet such as cell range designation on a computer having a touch screen such as a smartphone or a tablet PC. It is about.

  With the spread of PCs (personal computers), spreadsheets created by spreadsheet software are used for various purposes. A common function is provided as a template in order to improve the efficiency of creating and editing such a spreadsheet (see, for example, paragraph 0004 of Patent Document 1).

  On the other hand, in recent years, spreadsheets are used not only for PCs but also for portable devices having computer functions such as smartphones and tablet PCs. Smartphones and tablet PCs often use touch screens for data input / output, but in response to the various documents including spreadsheets being operated on touch screens, An invention for improving operations such as movement and visibility (see, for example, Patent Document 2) is disclosed.

JP 2010-532535 A JP 2010-515978 A

  As in the invention described in Japanese Patent Application Laid-Open No. H10-228707, comfort of operation of a document including a spreadsheet on a touch screen has been pursued, but most of them are operations for displaying a generated document. It is intended to improve sexuality and visibility.

  In order to improve the operability of data input when creating and editing documents, for example, a method of accepting input by touching the keyboard displayed on the touch screen is provided. In the improvement, it is not possible to cope with operations such as editing a table for a spreadsheet, for example, specifying a range of cells and deleting rows and columns. For spreadsheet operations such as cell range specification, there is also a need for a mechanism that takes advantage of the unique visual characteristics of touch screens.

  The present invention has been made in order to cope with such a problem. In a computer having a touch screen such as a smartphone or a tablet PC, touch operation is performed in editing a spreadsheet such as cell range designation. An object of the present invention is to provide a spreadsheet control program, a spreadsheet control device, and a spreadsheet control method that are excellent in operability while taking advantage of the visibility of the screen.

  A first invention for solving the problems according to the present invention is a program for controlling a spreadsheet in a computer having a touch screen, wherein the computer draws lines drawn on the spreadsheet displayed on the touch screen. A line detection step to detect, a selection line determination step to determine whether the line detected in the line detection step corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed; A cell specifying step for specifying the cell selected by the selection line determined as the selection line in the line determining step, and a range specification for recognizing the cell specified in the cell specifying step as a cell whose range is specified in the spreadsheet A spreadsheet control program characterized by causing a recognition step to be executed.

  In the first invention, when a line such as a circle or an ellipse is drawn across two or more cells on the spreadsheet displayed on the touch screen in a state where the spreadsheet is opened in the window, the line is used as a reference. Thus, a cell in an area surrounded by a line is recognized as a cell for which a range is designated for input values, copying, pasting, or the like. This makes it possible for a computer user to specify a range of a part of cells displayed on a spreadsheet simply by drawing a line such as a circle or an ellipse with a fingertip on the touch screen. A spreadsheet editing interface that takes advantage of its functionality and operability is provided.

  In the first invention, a computer equipped with a touch screen corresponds to a smartphone or a tablet PC that can input and output data by operating the touch screen. In the present invention, how a spreadsheet for specifying a range is created is not particularly limited, and may be created by operating a touch screen, or a PC For example, a file created on the touch screen may be displayed.

  In the first aspect of the invention, in the cell specifying step, out of cells including the region surrounded by the selection line, the cell surrounded by the selection line in each cell matches a predetermined condition. The cell selected by the selection line may be specified. The predetermined condition for specifying the cell selected by the selection line in the cell specifying step is that the ratio of the area of the area surrounded by the selection line to the entire cell area exceeds a predetermined threshold. This may be a feature.

  In the first invention, there is no particular limitation as to what line is determined as a selection line and what condition is recognized as a cell for which a range has been specified. As described above, a cell in an area surrounded by a selection line such as a circle or an ellipse may be recognized as a cell for which a range has been specified.

  Note that when determining the area surrounded by the selection line here, even if the selection line has a shape close to a circle or an ellipse, a part of the line is cut and closed like a circle or an ellipse. There may be cases where it is not possible. In that case, it suffices to recognize the area surrounded by the selection line by imagining the selection line in the closed shape by connecting the cut line with a straight line etc. The case recognized as such is also here It is assumed to be included in the “region surrounded by the selection line”.

  In addition, if it is determined whether or not each cell is a cell whose range is specified based on the area of the region surrounded by the selection line, a cell in which the line is slightly applied against the user's intention, etc. Can be excluded from the subject. When the area of the region surrounded by the selection line is used as a reference here, the calculation of the area does not need to be performed by strictly reading the shape of the selection line. For example, the intersection of the selection line and the outer frame of the cell It is also possible to substitute a simple calculation, such as finding the area when connecting the lines with a straight line, and the case of such calculation is also included in the `` area of the area surrounded by the selection line '' here To do. Yes.

  Furthermore, the first invention may be characterized in that, in the cell specifying step, all cells including a region surrounded by the selection line are specified as cells selected by the selection line.

  As described above, if it is determined that all the cells in the region surrounded by the selection line are designated as the range, the cell whose range is designated by a simple calculation can be specified.

  Furthermore, in the first invention, in the cell specifying step, four cells intersecting the uppermost row, the lowermost row, the leftmost column, and the rightmost column in which the selection line is drawn, and a cell surrounded by the four cells are displayed. The cell selected by the selection line may be specified.

  In this way, if the cells at the four corners are determined from the rows and columns at the left and right, upper and lower ends where the selection line is drawn, and the range specified by the rectangle formed from those cells is recognized, A cell for which a range has been specified can be identified by a simple calculation.

  Furthermore, the first invention may be characterized in that, in the cell specifying step, a cell in which the selection line is drawn and a cell surrounded by the cell are specified as a cell selected by the selection line.

  In this way, if all cells in which selection lines are drawn and the cells surrounded by those cells are recognized as range-designated cells, the range-designated cells can be identified by simple calculation. .

  A second invention for solving the problems according to the present invention is a program for controlling a spreadsheet in a computer having a touch screen, wherein the computer draws lines drawn on the spreadsheet displayed on the touch screen. The line detection step to detect, and whether the line detected in the line detection step corresponds to a deletion line that matches a predetermined condition drawn vertically or across the area where the cell is displayed on the spreadsheet A deletion line determination step for determining the cell, and if the line determined to be the deletion line in the deletion line determination step is drawn vertically across the area where the cell is displayed, the cell displays the column to which the cell belongs. And a deletion step of deleting a row to which the cell belongs when drawn across the specified area. It is over door control program.

  In the second invention, the predetermined condition for determining that it corresponds to the deletion line in the deletion line determination step is a line drawn in an area corresponding to a plurality of cells belonging to the same column or row, and the same If it belongs to the same row, it is a wavy line that covers a range that is equal to or greater than the predetermined ratio of the cell width and that is equal to or greater than the predetermined number of cells in the column, and if it belongs to the same row, the predetermined cell height And a wavy line covering a predetermined number or more of the total number of cells in the row.

  As described above, according to the second invention, for example, if a wavy line that traverses a row of a spreadsheet displayed in a touch screen window is drawn, a process for deleting the row is executed. For the function to delete rows and columns, it is possible to provide an interface that takes advantage of the visual and operability of the touch screen.

  A third invention for solving the problems according to the present invention is a program for controlling a spreadsheet in a computer having a touch screen, wherein the computer draws a line drawn on the spreadsheet displayed on the touch screen. The line detection step to detect and whether the line detected in the line detection step corresponds to a dividing line that matches a predetermined condition drawn vertically or across the area where the cell is displayed on the spreadsheet A dividing line determining step for determining the dividing line, and if the dividing line determining step determines that it is a dividing line, a cell in which a dividing line is drawn on a region and a value input to the one cell are inherited And a splitting step for splitting into two cells including the spreadsheet control program.

  In a third aspect of the invention, the predetermined condition for determining that the dividing line corresponds to the dividing line in the dividing line determining step is a line drawn in a region corresponding to a plurality of cells belonging to the same column or row, and the same Is a straight line drawn from the cell where the column is numbered to the cell at the far end on the opposite side, and if it belongs to the same row, it is the farthest end on the opposite side from the cell where the row is numbered It can also be characterized by a straight line drawn to a certain cell.

  Thus, according to the third invention, for example, if a straight line crossing a row of the spreadsheet displayed in the touch screen window is drawn, the process of dividing the row is executed. An interface that takes advantage of the visual and operability of the touch screen can be provided for the function of dividing rows and columns.

  A fourth invention for solving the problems according to the present invention is a program for controlling a spreadsheet in a computer having a touch screen, and the computer uses the ruled lines that divide columns or rows of the spreadsheet displayed on the touch screen. When a ruled line selection step that accepts selection of the first ruled line and the first ruled line that has received the selection in the ruled line selection step is detected to have moved to a position overlapping with the adjacent second ruled line, the first ruled line is divided by the first ruled line. A spreadsheet control program that executes a cell integration step of integrating the two cells into one cell.

  Thus, according to the fourth invention, the user performs an operation of moving the ruled lines separating the rows or columns on the touch screen window, and if the moved ruled lines overlap with the adjacent ruled lines, the displayed table is displayed. If two adjacent cells are integrated as in the case of, the interface that takes advantage of the visual and operability of the touch screen is provided for the function of integrating adjacent rows and columns in the spreadsheet. it can.

  A fifth invention for solving the problems according to the present invention is a program for controlling a spreadsheet in a computer equipped with a touch screen, and the computer uses the ruled lines to divide columns or rows of the spreadsheet displayed on the touch screen. A ruled line selection step that accepts the selection of the first ruled line, and the first ruled line that has been selected in the ruled line selection step is detected to have moved to a position that exceeds the adjacent second ruled line, the first ruled line is a vertical line If the first ruled line is a horizontal line, a cell changing step for changing the cell height and the row numbering is executed. is there.

  As described above, according to the fifth aspect, when the user performs an operation of moving the ruled lines separating the rows or columns on the touch screen window and the ruled lines are moved to a position exceeding the adjacent ruled lines, they are displayed. If you want to change the cell height, width, and numbering as well as the state of the table you are using, the interface that takes advantage of the touchscreen visibility and operability for the function to adjust the row height and column width of the spreadsheet Can be provided.

  A sixth invention for solving the problem according to the present invention is a program for controlling a spreadsheet in a computer having a touch screen, and the computer uses the computer to rule out the rows or rows of the spreadsheet displayed on the touch screen. If the ruled line selection step that accepts the selection of the ruled line and the ruled line that has been selected in the ruled line selection step is a vertical line, if it is detected that the upper end of the ruled line has moved beyond the numbered row of the column, If the numbered row is shifted downward to change the numbering of the row, and the ruled line that has been selected in the ruled line selection step is a horizontal line, the left end of the ruled line is moved beyond the numbered column of the line The numbering of the column is changed by shifting the column with the numbered row to the right. A spreadsheet control program, characterized in that to execute a ring change step.

  As described above, according to the sixth aspect of the invention, the user performs an operation of moving the ruled lines separating the rows or columns on the touch screen window, and the ends of the ruled lines are moved to positions beyond the numbered rows and columns. And if the numbered rows and columns are also moved in the direction of shifting the lines, the function of adjusting the position of the spreadsheet by shifting the position has been made use of the visibility and operability of the touch screen. An interface can be provided.

  The present invention can also be specified as a spreadsheet control device provided with the spreadsheet control program according to the present invention.

  A spreadsheet control apparatus corresponding to the first invention includes a touch screen capable of inputting / outputting data, a line detection unit for detecting a line drawn on a spreadsheet displayed on the touch screen, and the line detection unit Selection line determining means for determining whether the detected line corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed; and the selection line determined by the line determining means as a selection line Spreadsheet control comprising: cell specifying means for specifying a cell selected by the step; and range designation recognition means for recognizing the cell specified by the cell specifying means as a cell whose range is specified in a spreadsheet. Device.

  A spreadsheet control apparatus corresponding to the second invention includes a touch screen capable of inputting / outputting data, a line detection unit for detecting a line drawn on a spreadsheet displayed on the touch screen, and the line detection unit Delete line determination means for determining whether the detected line corresponds to a delete line that matches a predetermined condition drawn vertically or across the area where the cell is displayed on the spreadsheet; and the delete line If the line determined by the determining means as a deletion line is drawn vertically across the area where the cell is displayed, the column to which the cell belongs is drawn across the area where the cell is displayed. A spreadsheet control device comprising: deletion means for deleting a row to which the cell belongs.

  A spreadsheet control apparatus corresponding to a third invention includes a touch screen capable of inputting / outputting data, a line detection unit for detecting a line drawn on a spreadsheet displayed on the touch screen, and the line detection unit Dividing line determining means for determining whether the detected line corresponds to a dividing line that matches a predetermined condition drawn vertically or across the area where the cell is displayed on the spreadsheet; and the dividing line And a dividing unit that divides one cell in which a dividing line is drawn on a region into two cells including a cell that inherits a value input to the one cell when the determining unit determines that the dividing line is present. This is a spreadsheet control device.

  A spreadsheet control apparatus corresponding to a fourth invention includes a touch screen capable of inputting / outputting data, ruled line selection means for receiving selection of ruled lines separating rows or rows of the spreadsheet displayed on the touch screen, and the ruled lines When the selection means detects that the first ruled line for which selection has been received has been moved to a position where it overlaps the adjacent second ruled line, the two cells separated by the first ruled line are integrated into one cell. A spreadsheet control device comprising:

  A spreadsheet control device corresponding to a fifth invention includes a touch screen capable of inputting / outputting data, ruled line selection means for accepting selection of ruled lines separating columns or rows of the spreadsheet displayed on the touch screen, and the ruled lines When the selection means detects that the first ruled line that has received the selection has been moved to a position exceeding the adjacent second ruled line, if the first ruled line is a vertical line, cell width and column numbering are performed. And a cell changing means for changing the cell number and the row numbering if the first ruled line is a horizontal line.

  A spreadsheet control apparatus corresponding to a sixth invention includes a touch screen capable of inputting / outputting data, ruled line selection means for receiving selection of a ruled line separating rows or rows of the spreadsheet displayed on the touch screen, and the ruled line If the ruler that the selection means has accepted is a vertical line, if it is detected that the upper end of the ruled line has moved beyond the column numbered row, the column numbered row is shifted downward. If the numbering of the row is changed and the ruled line selection means accepts the selection, if the ruled line is a horizontal line, the numbering of the row is performed when it is detected that the left end of the ruled line has moved beyond the numbered column of the row. And a numbering changing means for changing the numbering of the column by shifting the column to the right.

  In addition, the spreadsheet control apparatus concerning this invention may be provided with various requirements of the spreadsheet control program concerning this invention demonstrated previously.

  The present invention can also be specified as a spreadsheet control method executed by the spreadsheet control program according to the present invention.

  A spreadsheet control method corresponding to the first invention is a method of controlling a spreadsheet in a computer having a touch screen, wherein the computer draws lines drawn on the spreadsheet displayed on the touch screen. A line detection step to detect, a selection line determination step to determine whether the line detected in the line detection step corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed; The computer specifies a cell selected by the selection line determined as the selection line in the line determination step, and the computer specifies the range of cells specified in the cell specification step in a spreadsheet. A range designation recognition step for recognizing a cell that has been changed. It spreads is a control method of the sheet.

  A spreadsheet control method corresponding to the second invention is a method for controlling a spreadsheet in a computer having a touch screen, wherein the computer draws lines drawn on the spreadsheet displayed on the touch screen. A line detection step to detect, and a deletion line that matches a predetermined condition in which the line detected in the line detection step is drawn vertically or across the area where the cell is displayed on the spreadsheet. A deletion line determination step for determining whether the cell corresponds to the cell, and when the computer determines that the line determined as the deletion line in the deletion line determination step is drawn vertically across the area where the cell is displayed, the cell If the column to which the cell belongs is drawn across the area where the cell is displayed, the deletion step of deleting the row to which the cell belongs Is a control method of the spreadsheet, characterized in that it comprises a.

  A spreadsheet control method corresponding to a third invention is a method for controlling a spreadsheet in a computer having a touch screen, wherein the computer draws lines drawn on the spreadsheet displayed on the touch screen. A line detection step for detecting, and a line that the computer detects in the line detection step matches a predetermined condition drawn vertically or across a region where cells are displayed on the spreadsheet. A dividing line determining step that determines whether the dividing line is true; and when the computer determines that the dividing line is determined to be a dividing line in the dividing line determining step, a cell in which a dividing line is drawn on an area is changed to the one cell. A splitting step for splitting the input value into two cells including a cell that takes over the input value. It is a control method of.

  A spreadsheet control method corresponding to a fourth invention is a method for controlling a spreadsheet in a computer having a touch screen, wherein the computer separates lines or rows of the spreadsheet displayed on the touch screen. A ruled line selection step that accepts the selection of the first ruled line, and the computer detects that the first ruled line that has received the selection in the ruled line selection step has been moved to a position that overlaps the adjacent second ruled line. And a cell integration step of integrating two cells separated by a ruled line into one cell.

  A spreadsheet control method corresponding to a fifth invention is a method for controlling a spreadsheet in a computer having a touch screen, wherein the computer separates the columns or rows of the spreadsheet displayed on the touch screen. A ruled line selection step that accepts the selection of the first ruled line, and the computer detects that the first ruled line that has received the selection in the ruled line selection step has been moved to a position that exceeds the adjacent second ruled line. A cell changing step for changing the cell width and column numbering if the ruled line is a vertical line, and changing the cell height and row numbering if the first ruled line is a horizontal line. This is a control method.

  A spreadsheet control method corresponding to a sixth invention is a method for controlling a spreadsheet in a computer having a touch screen, wherein the computer separates the columns or rows of the spreadsheet displayed on the touch screen. A ruled line selection step that accepts selection, and if the ruled line that has been selected in the ruled line selection step is a vertical line, the computer detects that the upper end of the ruled line has moved beyond the numbered row of the column Then, the numbering of the row is shifted downward to change the numbering of the row, and if the ruled line that has been selected in the ruled line selection step is a horizontal line, the left end of the ruled line indicates the column with the numbered row. When it is detected that the column has been moved beyond, the column with the row numbering is shifted to the right to shift the column number. A method of controlling a spreadsheet and having a a numbering changing step of changing the ring.

  The spreadsheet control method according to the present invention may include various requirements of the spreadsheet control program according to the present invention described above.

  According to the present invention, a spreadsheet having excellent operability while making use of the touch screen's visibility in editing a spreadsheet such as cell range designation on a computer equipped with a touch screen such as a smartphone or tablet PC. An input interface is provided. This makes it possible to easily handle spreadsheets even on smartphones and tablet PCs, and can be expected to improve user convenience.

It is a figure which shows the structure of the portable device which the spreadsheet control program concerning this invention operate | moves. It is a figure which shows the state by which the cell was set to the spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows the state which inputs data into the cell of a spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows the state by which the range specification of the cell was performed by the spreadsheet control program concerning this invention. It is a figure which shows the 1st example which recognizes the range of the cell selected from the drawn line by the spreadsheet control program concerning this invention. It is a figure which shows the 2nd example which recognizes the range of the cell selected from the drawn line by the spreadsheet control program concerning this invention. It is a figure which shows the 3rd example which recognizes the range of the cell selected from the drawn line by the spreadsheet control program concerning this invention. It is a figure which shows the state by which the wavy line was drawn in order to delete the row | line | column of a spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows the state from which the row | line | column of the spreadsheet was deleted by the spreadsheet control program concerning this invention. It is a figure which shows the state by which the straight line was drawn in order to divide the row | line | column and column of a spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows the state by which the row | line | column and column of the spreadsheet were divided | segmented by the spreadsheet control program concerning this invention. It is a figure which shows the state which moved the ruled line in order to change the column width of a spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows the state which moved the ruled line in order to integrate the row | line | column of a spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows the state which moved the ruled line in order to change the position of the row | line | column of a spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows the state which moved the ruled line in order to change the position of numbering of the row | line | column of a spreadsheet and to shift the position of a spreadsheet by the spreadsheet control program concerning this invention.

  Embodiments for carrying out the present invention will be described below in detail with reference to the drawings. The following description shows an example of an embodiment of the present invention, and the present invention is not limited to such an embodiment.

  FIG. 1 shows a configuration of a portable device in which a spreadsheet control program according to the present invention operates. In the present invention, touch-screen portable devices such as smartphones and tablet PCs are used. However, hardware for carrying out the present invention is not limited to these devices, and data can be input by touch screen. Any computer capable of outputting and creating and editing a spreadsheet may be used.

  Data input / output to / from the portable device body 10 may be provided with another input / output device in addition to the touch screen 20, but is configured to be performed using the touch screen 20. . On the touch screen 20, the calculation result in the portable device body 10 is displayed on the screen, and data is input by tapping the screen with a fingertip or a pen or drawing a line.

  The portable device body 10 is a computer including an auxiliary storage device such as a CPU, a main memory, and an HDD. The input / output control unit 11 and the spreadsheet operation unit 12 provided in the portable device body 10 are both functionally specified, and application programs corresponding to the respective functions are read from the auxiliary storage device into the main memory. The predetermined function is realized by executing the arithmetic processing by the CPU.

  Of these, the spreadsheet calculation unit 12 corresponds to general spreadsheet software having functions such as spreadsheet creation and editing, and the input / output control unit 11 inputs data using the touch screen 20. Output is done.

  The input / output control unit 11 serves as an interface when the spreadsheet operation unit 12 is used, and corresponds to the spreadsheet control program according to the present invention. The input / output controller 11 recognizes and displays points and lines drawn with a fingertip or pen in a window opened on the touch screen 20 for operating a spreadsheet corresponding to a so-called “handwritten memo” application. In addition to the function of performing the calculation, the interface of the spreadsheet calculation unit 12 accepts the cell setting and the input value to the cell and passes it to the spreadsheet calculation unit 12. A function of outputting the processed spreadsheet and displaying it in a window opened on the touch screen 20 is provided.

  A predetermined storage area of the auxiliary storage device is allocated to the data storage unit 13, and data relating to the spreadsheet including the input value to each cell is stored, and when creating or editing the spreadsheet, these data are stored. Data is read into the main memory and the spreadsheet is displayed in a window opened on the touch screen 20.

  Based on the above configuration, the operation of the spreadsheet control program according to the present invention will be described using an example of a spreadsheet displayed in a window opened on the touch screen shown in FIGS.

  When the spreadsheet control program according to the present invention is used to create or edit a spreadsheet or input values, the application corresponding to the input / output control unit 11 is activated to operate the spreadsheet. Is opened on the touch screen 20. In the present invention, a method for creating a new spreadsheet is not particularly limited. Here, the input / output control unit 11 recognizes a line drawn on the touch screen as a ruled line of the spreadsheet, and the spreadsheet is created. An example of automatic generation will be described.

  A user who wants to create a new spreadsheet draws a line to be a ruled line of the spreadsheet in the opened window with a fingertip or a pen. The drawn line is recognized as a ruled line parallel to either the row or the column of the spreadsheet depending on the angle, and is displayed as a horizontal or vertical ruled line in the window.

  FIG. 2 shows a state in which two ruled lines are displayed horizontally and vertically from the line drawn by the user. When at least one rectangle is formed by the intersection of a plurality of ruled lines, a spreadsheet calculation unit is used here. 12 is activated to start creating a new spreadsheet. In the rectangular display area, one cell in the newly created spreadsheet is set, and row and column numbering (first row and A column) corresponding to this cell is performed.

  There are no particular limitations on the values of the height and width of the cell to be set, that is, the height of the row and the width of the column, and the height and width of the formed rectangle may be used as they are. The height and width may be replaced with the standard format of the spreadsheet set in advance in the program. However, it is preferable to set a maximum value and a minimum value for the height and width of the set cell so that the cell size does not become unbalanced in relation to the size of the window.

  Furthermore, when a line newly drawn on the window is recognized as a horizontal or vertical ruled line and a new quadrangle is formed, a cell is set for the quadrangle, and the corresponding row or column numbering is performed. Added. That is, when a new horizontal line is recognized after the creation of the spreadsheet is started, one row is formed by the cells set by the horizontal line, and one row is added to the spreadsheet. . When a new vertical line is recognized, one column is formed by the cells set by the vertical line, and one column is added to the spreadsheet.

  Here, when a new row or column is added, how to set the row height and the column width (cell height and width) is not particularly limited. It may be set to the same value as the height or width of the adjacent cell, or the height or width of the rectangle formed by the newly drawn line exceeds the height and width of the adjacent cell. If they are different from each other, a different height or width from the adjacent cells may be set. For example, if it is more than twice the height or width of an adjacent cell, it is twice the height or width, if it is less than half the height or width of an adjacent cell, or half the height or width Otherwise, the width may be set to the same height or width as the adjacent cells.

  FIG. 3 shows a state where seven horizontal lines and five vertical lines are recognized as ruled lines, and a 6-row × 4-column matrix spreadsheet is created and displayed in a window. Each square constituting this matrix corresponds to a spreadsheet cell, and if one cell is selected in the window by an operation such as tapping the touch screen 20 (the cell at the address “D3” in FIG. 6 is selected). ) A screen such as a calculator, keyboard, or numeric keypad is displayed so that data can be entered into the cell.

  The user can input data into the cell by tapping a screen such as a calculator or a keyboard. The input data is transferred to the spreadsheet unit 12 as an input value to the selected cell and stored in a memory or the like.

  In the present invention, a spreadsheet for performing cell range specification, row or column deletion or division editing is generated by recognizing a line drawn by the user on the touch screen 20 as described above. However, it is not limited to the spreadsheet generated in this way. For example, a spreadsheet template read from the data storage unit 13 or the like may be read into a window for editing a spreadsheet and displayed on the editing window. The spreadsheet is edited by performing a predetermined operation using the touch screen 20 from the state in which the spreadsheet is displayed in the editing window opened at 20.

  When the 6 row x 4 column spreadsheet shown in Fig. 3 is displayed in the window and the user wants to select a range by selecting some cells, specify the range as shown in Fig. 4. The user draws a line on the touch screen 20 with a fingertip or a pen so that the desired cell is surrounded by a circle or an ellipse. The line drawn by the user is displayed on the spreadsheet as shown in FIG.

  A line (selection line) for selecting a cell for which a range is to be specified needs to span two or more cells, but what type of line should be determined as a selection line? There is no particular limitation. Even if it is a straight line or curve that is not closed, it may be determined that it is a target for range specification as long as it is a line that covers two or more cells, but normally a closed line such as a circle, ellipse, or quadrilateral is used. It can be considered as a target. Since the user cannot always accurately draw such a line on the touch screen 20, even if there is a break in a part, the line connecting the break is virtually corrected to a closed line, and a range designation is made. It may be determined as a target.

  The left diagram of FIG. 5 shows an example in which a cell that is a target of range designation is selected from the area of the region surrounded by the selection line. In FIG. 5, the area surrounded by the elliptical selection line covers nine cells. For each cell, the area of the area surrounded by the selection line is calculated and occupies the area of the entire cell. It is determined whether the ratio exceeds a predetermined threshold. For example, when the threshold value is set to ½, the cells A1 and C3 include a region surrounded by the selection line, but are excluded from the range designation target (the right diagram in FIG. 5).

  Here, it is possible to define that the entire area surrounded by the selection line is the target of the range specification and determine that the range specification including the cells of A1 and C3 has been performed. Even cells that have been slightly covered are included in the range specification target. In consideration of such points, it is preferable that the range is specified only when the area surrounded by the selection line satisfies a certain condition.

  Here, when determining whether or not to be a range designation target based on the area of the region surrounded by the selection line, the area calculation is performed by strictly reading the shape of the selection line and calculating an accurate numerical value. It is not always necessary to obtain it. For example, a simple calculation such as obtaining the area of a region surrounded when the intersection of the selection line and the outer frame of the cell is connected by a straight line may be used instead.

  The left diagram of FIG. 6 shows an example of selecting a cell for which a range is designated from the uppermost row, the lowermost row, the leftmost column, and the rightmost column on which selection lines are drawn. In FIG. 6, the top line of the selection line is the first line, the bottom line is the third line, the leftmost column is the A column, and the rightmost column is the C column. Therefore, the intersections of the top row, the bottom row, the leftmost column, and the rightmost column on which the selection line is drawn are four cells (cells indicated by asterisks) of A1, A3, C1, and C3. The cells in the rectangle surrounded by the cells are the target of range designation as shown in the right diagram of FIG.

  The left diagram of FIG. 7 illustrates an example in which cells in which selection lines are drawn and cells surrounded by those cells are selected as cells for which a range is designated. In FIG. 7, the cells to which the selection line is applied are eight cells A1, A2, A3, B1, B3, C1, C2, and C3 (cells indicated by asterisks), and B2 surrounded by these cells. In addition to the cells, nine cells are subject to range designation as shown in the right diagram of FIG.

  6 and FIG. 7 does not require the calculation of the area of the region surrounded by the selection line, so that the ellipse closed with a part of the selection line as shown in FIG. Even if it is not, it is possible to specify a cell for which a range is designated without drawing a virtual line on the selection line.

  In any of the methods shown in FIGS. 5 to 7, it is necessary to specify the positional relationship between the spreadsheet on the window opened on the touch screen 20 and the selection line drawn by the user. The position can be easily identified from the position on the touch screen 20 where the spreadsheet is displayed and the position on the touch screen 20 that the user traces with the fingertip or pen to draw the selection line.

  As in the example described above, when a user designates a range selection target by drawing a predetermined selection line in a window opened on the touch screen 20, the range designated cell is specified. Information relating to this is transferred to the spreadsheet operation unit 12, and processing such as copying, pasting, and deleting of input values executed by specifying a range is performed.

  8 and 9 show examples in which wavy lines are drawn on a spreadsheet and rows are deleted. When deleting a row or column of a spreadsheet displayed in the window, the user draws a line (deletion line) defined as a line for deleting the row or column in the row or column to be deleted. In the example of FIG. 8, the deletion line is defined as a wavy line, and in order to delete the third line, the touch screen 20 is traced with a fingertip or a pen to draw the wavy line.

  When it is detected on the touch screen 20 that a wavy line crossing or traversing a cell constituting the row or column is drawn in an area corresponding to any row or column of the spreadsheet, the cell on which the wavy line is drawn is displayed. A process of deleting the included row or column is executed. That is, the input value of the cell in the deleted row or column is deleted, and if the row is deleted, the row below the deleted row is padded to the top, and if the column is deleted, it is deleted A process is executed in which the column to the right of the column is left-justified, the numbering of the row or column is changed, and the input value is moved to the position after the numbering change so as to correspond to the ID of each cell. These processing results are transferred to the spreadsheet unit 12 and reflected in the spreadsheet file.

  In the example of FIG. 9, all the input values of the deleted cells in the third row are deleted, and the input values in the fourth row are changed to the third row (for example, “500” in “A4” is “A3”. ”), The input value in the sixth line is moved to the fifth line (for example,“ 900 ”in“ B6 ”is moved to“ B5 ”).

  Here, it is not particularly limited to determine a wavy line corresponding to a deletion line if a line corresponding to a condition is detected, but for example, a plurality of cells belonging to the same row or column It is a line drawn in the area corresponding to, and if it belongs to the same row, the range of the cell height is more than a predetermined ratio (for example, more than half of the cell height in that row) ) And over a predetermined number of cells of the total number of cells in the row (for example, over one-half of the number of cells in the row). If they belong to the same column, they are in a range that is equal to or greater than a predetermined ratio of the width of the cells (for example, it is more than half of the width of the cells in the column) and the total number of cells in the column Over a certain number of cells (for example, the number of cells in the column That depends on one or more cells of 2 minutes) may be determined on the condition.

  10 and 11 show examples in which lines and columns are divided by drawing straight lines on a spreadsheet. When the user wants to divide the row or column of the spreadsheet displayed in the window, the user draws a line (dividing line) defined as a line for dividing the row or column in the row or column to be divided. In the example of FIG. 10, the dividing line is defined as a straight line, and the straight line is drawn by tracing the touch screen 20 with a fingertip or a pen in order to divide the third row and the B column.

  When it is detected on the touch screen 20 that a straight line that crosses or crosses the cells constituting the row or column is drawn in an area corresponding to any row or column of the spreadsheet, the cell in which the straight line is drawn is displayed. A process of dividing the included row or column is executed. That is, in the divided rows and columns, when the rows are divided, the row numbering is changed, and the process of moving the input value to the position after the numbering change is performed so as to correspond to the ID of each cell. The These processing results are transferred to the spreadsheet unit 12 and reflected in the spreadsheet file.

  In the example of FIG. 11, the third line is divided into two lines, and the divided lines are numbered with the third and fourth lines, and an input value exists in “A3”. In this case, the input value is taken over by the divided upper cell (new “A3”). If an input value exists in “A4” before the division, the display position of the displayed input value is moved to the cell at the lower “A4” address. The B column is similarly divided into two columns, and the divided columns are numbered with the B column and the C column. If an input value exists in “B1”, the divided left side is divided. The input value is succeeded to the cell (new “B1”). If an input value exists in “C1” before division, the display position of the displayed input value is moved to the cell at the address “C1” on the right side.

  Here, it is not particularly limited to determine a line corresponding to the dividing line if a line corresponding to the condition is detected, but for example, a plurality of cells belonging to the same row or column Lines drawn in the area corresponding to, if they belong to the same row, they are straight lines drawn from the cell in which the row is numbered to the cell on the far right of the opposite side, and belong to the same column In this case, the determination may be made on the condition that the line is drawn from the cell in which the numbering of the column is performed to the cell at the lowest end on the opposite side.

  In addition, if the straight line corresponding to the dividing line is strictly a straight line, it is considered that the operability is hindered. For example, if the line is to be deleted, the maximum and minimum values in the Y coordinate of the line The drawn line is a straight line, provided that the difference is within a certain range, or if the line is to be deleted, the difference between the maximum and minimum values in the X coordinate of the line is within a certain range. Judgment should be made.

  12 to 15 show examples of adjusting the size of rows and columns by moving the ruled lines of the spreadsheet. When you want to adjust the size of the spreadsheet row displayed in the window, such as the row height or column width, the user can change the ruled lines separating the rows and columns you want to adjust the size of An icon is displayed, and the item is selected by touching the ruled line while the icon of the item is selected, and the selected ruled line is moved by dragging on the window.

  In the example of FIGS. 12 to 14, a ruled line separating the B column and the C column is selected, and the ruled line is translated in the right direction. As shown in the example of FIG. 12, when it is detected that the fingertip or the like that is dragging at the position before reaching the ruled line that separates the C column and the D column is separated from the touch screen 20, and the movement is completed Is executed to change the widths of the B and C columns so that the ruled line moves to that position. The processing result is delivered to the spreadsheet unit 12 and reflected in the spreadsheet file.

  When the ruled line is further moved and it is detected that the fingertip or the like dragging at the position overlapping the ruled line separating the C column and the D column is separated from the touch screen 20, and the movement is completed, the example shown in FIG. As shown in Fig. 2, the two columns are integrated into the first column, and the width of the B column is changed according to the position where the ruled line is moved (the width of the B column may be returned to the original width). In accordance with this, the process of deleting or changing the input value of the integrated cell is executed. The processing result is delivered to the spreadsheet unit 12 and reflected in the spreadsheet file.

There is no particular limitation on how the input values of the cells are handled by integrating two columns into one column, that is, integrating two cells into one cell. For example, in the case of the example of FIG. 13, the input value of the cell in the B column before integration may be deleted, or the input value of the cell in the C column may be deleted. If the input value is not an arithmetic expression, the input value in the B column and the input value in the C column may be displayed in two columns and displayed in a two-line format.

  When the ruled line is further moved and it is detected that the fingertip or the like dragging at a position exceeding the ruled line separating the C and D columns is separated from the touch screen 20, and the movement is completed, the example shown in FIG. As shown in FIG. 5, the process of changing the widths of the B and C columns so that the ruled line moves to the position is executed. In this case, the position of the C column moves to a part of the original position of the D column, and accordingly, the numbering and the display position of the input value of the cell are also changed. The processing result is delivered to the spreadsheet unit 12 and reflected in the spreadsheet file.

  In FIGS. 12 to 14, the case where the selected ruled line is a vertical line and the ruled line is translated in the horizontal direction has been described. However, the selected ruled line is a horizontal line and the ruled line is translated in the vertical direction. In the case, row height changes, row integration, etc. are performed in the same way as for columns.

  FIG. 15 shows a state in which the selected ruled line is not translated as shown in FIGS. 12 to 14, but the ruled line is moved obliquely or along the ruled line. If the selected ruled line is a vertical line, it is detected that the fingertip or the like that is dragging at the position where the upper end of the ruled line is moved beyond the row in which the column is numbered is separated from the touch screen 20 and moved. Is completed, the row numbering is shifted downward to change the row numbering, and the display position of the input value of the cell is changed as shown in the example of FIG. The The processing result is delivered to the spreadsheet unit 12 and reflected in the spreadsheet file.

  Similarly, in the case where the selected ruled line is a horizontal line, it is detected that the fingertip or the like that is dragging at the position where the left end of the ruled line is moved beyond the row numbered column is separated from the touch screen 20. When the movement is completed, a process of changing the column numbering by shifting the column in which the row is numbered to the right and changing the display position of the input value of the cell is executed. The processing result is delivered to the spreadsheet unit 12 and reflected in the spreadsheet file.

DESCRIPTION OF SYMBOLS 10 Portable device main body 11 Input / output control part 12 Spreadsheet calculation part 13 Data storage part 20 Touch screen

Claims (24)

A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A line detection step for detecting lines drawn on a spreadsheet displayed on the touch screen;
A selection line determination step for determining whether the line detected in the line detection step corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
Among the cells including the area surrounded by the selection line determined as the selection line in the line determination step, the cell surrounded by the selection line in each cell matches a predetermined condition by the selection line. a cell identifying step of identifying a selected cell,
A range designation recognition step for recognizing the cell identified in the cell identification step as a cell whose range is designated in a spreadsheet;
A spreadsheet control program characterized in that The predetermined condition for specifying the cell selected by the selection line in the cell specifying step is that the ratio of the area of the area surrounded by the selection line to the entire cell area exceeds a predetermined threshold. The spreadsheet control program according to claim 1 . A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A line detection step for detecting lines drawn on a spreadsheet displayed on the touch screen;
A selection line determination step for determining whether the line detected in the line detection step corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
All cells containing a region surrounded by the selection line determines the selected line in the line determination step, a cell identifying step of identifying a selected cell by the selection line,
A range designation recognition step for recognizing the cell identified in the cell identification step as a cell whose range is designated in a spreadsheet;
A spreadsheet control program characterized in that A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A line detection step for detecting lines drawn on a spreadsheet displayed on the touch screen;
A selection line determination step for determining whether the line detected in the line detection step corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
A cell surrounded by the four cells and the four cells intersecting the uppermost row, the lowermost row, the leftmost column, and the rightmost column in which the selection line determined to be the selection line in the line determination step is drawn. a cell identifying step of identifying a selected cell by,
A range designation recognition step for recognizing the cell identified in the cell identification step as a cell whose range is designated in a spreadsheet;
A spreadsheet control program characterized in that A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A line detection step for detecting lines drawn on a spreadsheet displayed on the touch screen;
A selection line determination step for determining whether the line detected in the line detection step corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
A cell identifying step of the cell surrounded, identifies the selected cell by the selection line by the selectivity line determines that select line and drawn cell by the line determination step cell,
A range designation recognition step for recognizing the cell identified in the cell identification step as a cell whose range is designated in a spreadsheet;
A spreadsheet control program characterized in that A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A line detection step for detecting lines drawn on a spreadsheet displayed on the touch screen;
The line detected in the line detection step matches a predetermined condition drawn in a region corresponding to any column or row of the spreadsheet by vertically or horizontally traversing a plurality of cells constituting the column or row. A deletion line determination step for determining whether the line corresponds to a deletion line;
If the line determined as the deletion line in the deletion line determination step is drawn vertically across the area where the cell is displayed, the column to which the cell belongs is drawn across the area where the cell is displayed. A delete step for deleting the row to which the cell belongs,
A spreadsheet control program characterized in that The predetermined condition for determining that it corresponds to the deletion line in the deletion line determination step is a line drawn in an area corresponding to a plurality of cells belonging to the same column or row, and belongs to the same column A wavy line extending over a predetermined ratio of the cell width and a predetermined number of cells of the total number of cells in the column, and when belonging to the same row, a range of a predetermined ratio of the cell height or more, 7. The spreadsheet control program according to claim 6 , wherein the spreadsheet control line is a wavy line covering a predetermined number or more of the total number of cells in the row. A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A line detection step for detecting lines drawn on a spreadsheet displayed on the touch screen;
A dividing line that matches a predetermined condition drawn in a line vertically or across a cell constituting the column or row in an area corresponding to any column or row of the spreadsheet in which the line detected in the line detecting step corresponds to A dividing line judging step for judging whether or not
When the dividing line is determined to be a dividing line in the dividing line determining step, for all the cells constituting the column or row in which the dividing line is drawn on the region , 1 cell is set to the value input to the 1 cell. A division step of dividing the cell into two cells including the cell to be taken over;
A spreadsheet control program characterized in that In the dividing line determining step, the predetermined condition for determining that it corresponds to the dividing line is a line drawn in an area corresponding to a plurality of cells belonging to the same column or row, and belongs to the same column It is a straight line drawn from the cell where the column is numbered to the cell at the opposite end, and if it belongs to the same row, it is drawn from the cell where the row is numbered to the cell at the opposite end. The spreadsheet control program according to claim 8 , wherein the spreadsheet control program is a straight line. A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A ruled line selection step for accepting selection of a ruled line separating the columns or rows of the spreadsheet displayed on the touch screen;
When it is detected that the first ruled line that has been selected in the ruled line selection step has been moved to a position where it overlaps with the adjacent second ruled line, two columns or rows separated by the first ruled line are formed. A cell integration step of integrating the two cells separated by the first ruled line into one cell for all the cells to be performed;
A spreadsheet control program characterized in that A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A ruled line selection step for accepting selection of a ruled line separating the columns or rows of the spreadsheet displayed on the touch screen;
When it is detected that the first ruled line that has been selected in the ruled line selection step has been moved to a position beyond the adjacent second ruled line, if the first ruled line is a vertical line, the cell width and column A cell change step for changing the cell number and row numbering if the first ruled line is a horizontal line;
A spreadsheet control program characterized in that A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A ruled line selection step for accepting selection of a ruled line separating the columns or rows of the spreadsheet displayed on the touch screen;
If the ruled line that has been selected in the ruled line selection step is a vertical line, when it is detected that the upper end of the ruled line has moved beyond the numbered row of the column, the row with the numbered column is moved downward. If the line numbering is shifted to change the ruled line selected in the ruled line selection step and the ruled line is a horizontal line, the numbering of the line is detected when it is detected that the left end of the ruled line has moved beyond the numbered column of the line. A numbering change step for changing the numbering of the column by shifting the marked column to the right,
A spreadsheet control program characterized in that A touch screen that can input and output data,
A line detection means for detecting a line drawn on a spreadsheet displayed on the touch screen;
Selection line determination means for determining whether the line detected by the line detection means corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
Among the cells including the area surrounded by the selection line determined by the line determination means as the selection line, the cell in which the area surrounded by the selection line satisfies a predetermined condition is selected by the selection line. a cell identification means for identifying a cell,
Range designation recognition means for recognizing the cell identified by the cell identification means as a cell whose range is designated in a spreadsheet;
A spreadsheet control device comprising: The predetermined condition for the cell specifying means to specify the cell selected by the selection line is such that the ratio of the area of the region surrounded by the selection line to the entire cell area exceeds a predetermined threshold. about
The spreadsheet control device according to claim 13. A touch screen that can input and output data,
A line detection means for detecting a line drawn on a spreadsheet displayed on the touch screen;
Selection line determination means for determining whether the line detected by the line detection means corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
All cells including the region surrounded by the selection line, wherein the line determination unit determines that select line, and a cell identification means for identifying a selected cell by the selection line,
Range designation recognition means for recognizing the cell identified by the cell identification means as a cell whose range is designated in a spreadsheet;
A spreadsheet control device comprising: A touch screen that can input and output data,
A line detection means for detecting a line drawn on a spreadsheet displayed on the touch screen;
Selection line determination means for determining whether the line detected by the line detection means corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
The cell surrounded by the four cells and the four cells intersecting the uppermost row, the lowermost row, the leftmost column, and the rightmost column on which the selection line determined to be the selection line by the line determining means is drawn by the selection line. a cell identification means for identifying a selected cell,
Range designation recognition means for recognizing the cell identified by the cell identification means as a cell whose range is designated in a spreadsheet;
A spreadsheet control device comprising: A touch screen that can input and output data,
A line detection means for detecting a line drawn on a spreadsheet displayed on the touch screen;
Selection line determination means for determining whether the line detected by the line detection means corresponds to a predetermined selection line straddling an area where two or more cells of the spreadsheet are displayed;
A cell identification means that a cell surrounded, identifies the selected cell by the selection lines by the selection and line the line determination unit determines that select line is drawn cell cell,
Range designation recognition means for recognizing the cell identified by the cell identification means as a cell whose range is designated in a spreadsheet;
A spreadsheet control device comprising: A touch screen that can input and output data,
A line detection means for detecting a line drawn on a spreadsheet displayed on the touch screen;
Deletion in which the line detected by the line detection means matches a predetermined condition drawn vertically or across a plurality of cells constituting the column or row in an area corresponding to any column or row of the spreadsheet A deletion line judging means for judging whether it corresponds to a line;
When the deletion line determining means determines that the line is a deletion line, the line to which the cell belongs is drawn across the area where the cell is displayed. Delete means for deleting the row to which the cell belongs,
A spreadsheet control device comprising: The predetermined condition for determining that the deletion line determination means corresponds to the deletion line is a line drawn in an area corresponding to a plurality of cells belonging to the same column or row, and belongs to the same column A wavy line extending over a predetermined ratio of the cell width and a predetermined number of cells of the total number of cells in the column, and when belonging to the same row, a range of a predetermined ratio of the cell height or more, And a wavy line covering a predetermined number or more of the total number of cells in the row.
The spreadsheet control device according to claim 18. A touch screen that can input and output data,
A line detection means for detecting a line drawn on a spreadsheet displayed on the touch screen;
The line detected by the line detection means is a dividing line that matches a predetermined condition drawn vertically or across a cell constituting the column or row in an area corresponding to any column or row of the spreadsheet. Dividing line judging means for judging whether or not,
When the dividing line determining means determines that it is a dividing line, for all the cells constituting the column or row in which the dividing line is drawn on the area , the cell that takes over the value input to the one cell as one cell Dividing means for dividing into two cells including:
A spreadsheet control device comprising: The predetermined condition for determining that the dividing line determination means corresponds to the dividing line is a line drawn in an area corresponding to a plurality of cells belonging to the same column or row, and belongs to the same column It is a straight line drawn from the cell where the column is numbered to the cell at the opposite end, and if it belongs to the same row, it is drawn from the cell where the row is numbered to the cell at the opposite end. Be a straight line
The spreadsheet control device according to claim 20. A touch screen that can input and output data,
Ruled line selection means for accepting selection of ruled lines separating columns or rows of the spreadsheet displayed on the touch screen;
When it is detected that the first ruled line selected by the ruled line selection means has been moved to a position overlapping with the adjacent second ruled line, two columns or rows delimited by the first ruled line are formed. Cell integration means for integrating two cells separated by the first ruled line into one cell for all the cells to be
A spreadsheet control device comprising: A touch screen that can input and output data,
Ruled line selection means for accepting selection of ruled lines separating columns or rows of the spreadsheet displayed on the touch screen;
When it is detected that the first ruled line selected by the ruled line selection means has been moved to a position exceeding the adjacent second ruled line, if the first ruled line is a vertical line, the cell width and the column Cell changing means for changing the numbering of the cell and the numbering of the row if the first ruled line is a horizontal line;
A spreadsheet control device comprising: A touch screen that can input and output data,
Ruled line selection means for accepting selection of ruled lines separating columns or rows of the spreadsheet displayed on the touch screen;
If the ruled line selecting means accepts the selection, if the ruled line is a vertical line, when it is detected that the upper end of the ruled line has moved beyond the numbered row of the column, the numbered row is moved downward. If the numbering of the row is changed and the ruled line selection means accepts the selection, if the ruled line is a horizontal line, the numbering of the row is detected when it is detected that the left end of the ruled line has moved beyond the numbered column of the row. Numbering change means for changing the numbering of the column by shifting the marked column to the right,
A spreadsheet control device comprising: