JP5650564B2 - 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 spreadsheet creation, editing, and data input / output in a computer having a touch screen such as a smartphone or a tablet PC. is there.

  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 handle operations such as creating and editing tables for spreadsheets. For creating and editing spreadsheets, there is 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 the creation and editing of spreadsheets and input / output of data in a computer having a touch screen such as a smartphone and a tablet PC, the visibility of the touch screen is provided. 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.

  The present invention for solving such a problem is a program for controlling a spreadsheet in a computer having a touch screen, wherein the computer detects a line drawn in a predetermined window of the touch screen; A ruled line recognition step for recognizing the line detected in the line detection step as a ruled line parallel to either a horizontal or vertical ruled line corresponding to a row or column of a spreadsheet displayed in the window; and the ruled line recognition When a rectangle is formed by the intersection of a plurality of ruled lines recognized in the step, a cell setting step for setting the displayed area of the rectangle to one cell in the spreadsheet, and a cell set in the cell setting step When data specifying an area is input, the data is A spreadsheet control program, characterized in that to execute the input value receiving step of receiving a value entered in a cell, a.

  In the present invention, a line drawn on the touch screen in a state where the input window is opened is recognized as a ruled line parallel to the row or column of the spreadsheet. Set to cell in spreadsheet. As a result, a computer user can create a spreadsheet simply by drawing a line on the touch screen with a fingertip or the like, and can also specify a square part drawn by the line and perform data input operation to the cell. It is also possible to input the value of, and an interface for creating a spreadsheet that takes advantage of the visual and operability of the touch screen is provided.

  In the present 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. Further, in the present invention, in order to form at least one quadrangle, it is necessary to recognize two or more ruled lines in each of the horizontal and vertical directions, and the stage in which the first quadrangle is formed and the cell is set. This will start creating a new spreadsheet.

  In the cell setting step, when the height or width of a newly formed rectangle is different from the height or width of an adjacent cell set in advance, The height or width of the cell corresponding to the newly formed rectangle may be set so that the different height or width is the same as the height or width of the other adjacent cells. it can.

  If the cell height or width is set as described above, even if the line spacing between the lines drawn on the touch screen varies, the spreadsheet will have a uniform row height and column width. Can be created automatically.

  Further, in the cell setting step, when the height or width of a newly formed quadrangle is different from a predetermined range, the height or width of the adjacent cell is different from the predetermined range. The height or width of the cell corresponding to the newly formed rectangle is set so that the height or width different from that of the other adjacent cells is different from the height or width of the other adjacent cells. It is good.

  As described above, for example, if the height of a newly formed rectangle exceeds twice the height of an adjacent cell, a cell whose height is doubled is set. If you set a cell that is half the height if it is less than or equal to 1, the user wants to intentionally create a row or column that is different in height or width from other rows and columns Even in this case, this can be realized by a simple operation of drawing a new line by changing the interval between lines.

  Furthermore, the present invention provides a deletion line detection step for detecting a deletion line that matches a predetermined condition drawn by traversing or vertically crossing a region set as a cell in a spreadsheet displayed in the window. When the deletion line detected in the deletion line detection step is drawn across the area set as the cell, the row to which the cell belongs is drawn vertically across the area set as the cell. If so, a deletion step of deleting the column to which the cell belongs may be executed. The predetermined condition of the deletion line detected in the deletion line detection step is a line drawn in an area corresponding to a plurality of cells belonging to the same row or column, and if it belongs to the same row, the cell height A wavy line covering a predetermined number of cells in the row and a predetermined number or more of the total number of cells in the row, and if belonging to the same column, a range exceeding the predetermined ratio of the cell width and the column It is good also as a wavy line concerning a predetermined number or more cells of the total number of cells.

  As described above, for example, if you draw a wavy line that crosses a spreadsheet row displayed in the touch screen window, you can also delete the row or column by executing the processing to delete that row. An interface that takes advantage of the visual and operability of the screen can be provided.

  Furthermore, the present invention provides a dividing line detecting step for detecting a dividing line that matches a predetermined condition drawn by traversing or vertically crossing a region set as a cell in a spreadsheet displayed in the window. And a cell dividing step of dividing one cell in which the dividing line is drawn on the area in the dividing line detecting step into two cells including a cell that inherits a value input to the one cell. It is good also as making it feature. The predetermined condition of the dividing line detected in the dividing line detection step is a line drawn in an area corresponding to a plurality of cells belonging to the same row or column, and if it belongs to the same row, the row numbering It is a straight line drawn from the marked cell to the cell at the far end on the opposite side, and if it belongs to the same column, it is a straight line drawn from the cell numbered to the cell at the far end on the reverse side It may be characterized by being.

  As described above, for example, if you draw a straight line that crosses a spreadsheet row displayed in a touch screen window, the function that splits the row and column by executing the process of splitting the row also touches. An interface that takes advantage of the visual and operability of the screen can be provided.

  Further, according to the present invention, a ruled line selection step for accepting selection of a ruled line for separating a row or a column of the spreadsheet displayed in the window and a first ruled line for which selection has been accepted in the ruled line selection step are adjacent to the computer. And a cell integration step of integrating the two cells delimited by the first ruled line into one cell when it is detected that the second ruled line is moved to a position overlapping with the second ruled line. Good.

  As described above, if the user moves the ruled lines separating the rows or columns on the touch screen window and the moved ruled lines overlap with the adjacent ruled lines, they are adjacent as in the displayed table. If the two cells are integrated, an interface utilizing the visual and operability of the touch screen can be provided for the function of integrating adjacent rows and columns.

  Further, according to the present invention, a ruled line selection step for accepting selection of a ruled line for separating a row or a column of the spreadsheet displayed in the window and a first ruled line for which selection has been accepted in the ruled line selection step are adjacent to the computer. If the first ruled line is detected as a horizontal line, cell height and row numbering are detected. If the first ruled line is a vertical line, the cell width is detected. And a cell changing step for changing the numbering of the columns.

  As described above, when the user moves 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, the state of the displayed table is the same as If the cell height, width, and numbering are changed, it is possible to provide an interface that takes advantage of the visibility and operability of the touch screen for the function of adjusting the row height and column width.

  Further, the present invention provides the computer with a ruled line selection step that accepts selection of ruled lines that divide rows or columns of the spreadsheet displayed in the window, and if the ruled line that has been selected in the ruled line selection step is a horizontal line, When it is detected that the left edge of the ruled line has been moved beyond the column with the row numbering, the column numbering is shifted to the right to change the column numbering, and the selection is accepted at the ruled line selection step. If the ruled line is a vertical line, if it is detected that the upper end of the ruled line has been moved beyond the column numbered row, the numbered row is shifted downward to change the row numbering. A numbering change step may be executed.

  As described above, when the user moves the ruled lines separating the rows or columns on the touch screen window and the edge of the ruled line is moved to a position beyond the numbered row or column, the numbering is performed. An interface that takes advantage of the visual and operability of the touch screen to adjust the position of the rows and columns in the spreadsheet by moving the rows and columns in the direction of the lines. 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.

  That is, the spreadsheet control device according to the present invention includes a touch screen capable of inputting / outputting data, a line detection unit for detecting a line drawn in a predetermined window of the touch screen, and a line detected by the line detection unit. A ruled line recognition means for recognizing a ruled line parallel to either a horizontal or vertical ruled line corresponding to a row or column of the spreadsheet displayed in the window, and an intersection of a plurality of ruled lines recognized by the ruled line recognition means When a rectangle is formed, cell setting means for setting the area in which the rectangle is displayed to one cell in the spreadsheet, and data specifying the area set in the cell by the cell setting means are input. Input value receiving means for receiving the data as a value input to the cell on the spreadsheet. It is a spreadsheet control device.

  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.

  In other words, the spreadsheet control method according to the present invention is a method of controlling a spreadsheet by a computer having a touch screen, wherein the computer detects a line drawn in a predetermined window of the touch screen. And a ruled line recognition in which the computer recognizes the line detected in the line detecting step as a ruled line parallel to either a horizontal or vertical ruled line corresponding to a row or column of a spreadsheet displayed in the window A cell setting step for setting a region in which the rectangle is displayed to one cell in a spreadsheet when the computer forms a rectangle by the intersection of a plurality of ruled lines recognized in the ruled line recognition step; The computer is set to a cell in the cell setting step. When the data specifying the area is input, a control method of the spreadsheet, characterized in that it has a an input value receiving step of receiving the data as the value entered in the cell of the spreadsheet.

  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.

  The present invention makes it possible to create and edit spreadsheets on computers equipped with touch screens such as smartphones and tablet PCs, and to input and output spreadsheets while making use of the touch screen's visual properties for data input / output. 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 1st figure which shows the procedure which recognizes the line drawn on the window as a ruled line by the spreadsheet control program concerning this invention. It is a 2nd figure which shows the procedure which recognizes the line drawn on the window as a ruled line by the spreadsheet control program concerning this invention. It is a 3rd figure which shows the procedure which recognizes the line drawn on the window as a ruled line by the spreadsheet control program concerning this invention. 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 after data were input into the spreadsheet 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 examples such as ruled lines and spreadsheets displayed in windows opened on the touch screen shown in FIGS. To do.

  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. Here, as shown in the example of FIG. 2, a user who wants to create a spreadsheet draws a line to be a ruled line of the spreadsheet on the window with a fingertip or a pen.

  In the example of FIG. 2, a slightly bent line is drawn in the window, but the drawn line is recognized as a ruled line parallel to either the horizontal or vertical ruled line corresponding to the row or column of the spreadsheet. Therefore, processing for correcting the line is performed.

  FIG. 3 shows an example of a process for correcting a drawn line. First, both ends (A and B) of the drawn line are connected by a straight line (a line indicated by a dotted line in FIG. 3). In the open window, the X and Y axes are defined as the coordinate axes for setting rows and columns when creating a spreadsheet (these coordinate axes are not displayed in the window) For the straight line connecting both ends of the drawn line, calculate the angle with the X-axis and Y-axis to check which slope is close (for example, whether it is within 45 ° with respect to the X-axis) Determines whether the drawn line is a ruled line parallel to the horizontal or vertical ruled line corresponding to the row or column of the spreadsheet (for example, if the line is within 45 ° with respect to the X axis, the horizontal line, 45 ° If it exceeds, it will be a vertical line).

  As shown in the example of FIG. 4, when it is determined that the drawn line is a ruled line parallel to the horizontal ruled line corresponding to the spreadsheet row, the drawn line is started from A at the left end. (Dotted line connecting A and B) is recognized by correcting the ruled line (practice starting from A) parallel to the horizontal ruled line corresponding to the row of the spreadsheet. In this way, the line drawn in the window is recognized as a ruled line parallel to either the horizontal or vertical ruled line corresponding to the row or column of the spreadsheet, and the corrected line is displayed in the window.

  The above-described method is an example of a ruled line recognition method. In the present invention, the method of recognizing a line drawn with a fingertip or a pen as a ruled line is limited to the above method. is not. Also, all lines drawn in the window are not recognized as ruled lines, and are recognized as horizontal or vertical ruled lines when the slope is more than a certain value or the length of the line is less than a certain value. It may be handled as an input error.

  Subsequently, when a plurality of ruled lines are recognized and at least one quadrangle is formed by the intersection of the plurality of ruled lines as shown in FIG. 5, the spreadsheet operation unit 12 is activated here to create a new spreadsheet. To start. 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. 6 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.

  FIG. 7 shows a state after data is input to a plurality of cells of the spreadsheet. Each input value is associated with the cell ID (cell address) and stored in the cell in which the numerical value is displayed (for example, the input value “100” is associated with the cell ID “A1”). ) When the user performs an operation to save the spreadsheet, the spreadsheet stores data in a file format in which input values are associated with each cell ID (cell address) and the row height and column width are specified. Stored in the unit 13.

  8 and 9 show examples in which wavy lines are drawn on a spreadsheet and rows are deleted. When the user wants to delete a row or column in the created spreadsheet, 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 that traverses 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 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 a row or column of the created spreadsheet, 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, and 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 created spreadsheet, such as the row height and column width, the user can select the ruled line that separates the row or column whose size you want to adjust, and display the icon for the item that moves the ruled line in the window. The selected ruled line is moved by dragging on the window by touching the ruled line while the icon of the item is selected.

  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 in FIG. 13, the input value of the cell in the C column before integration may be erased, or the input value of the cell in the C column may be erased. 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 (12)

A program for controlling a spreadsheet in a computer having a touch screen, the computer comprising:
A line detection step for detecting a line drawn in a predetermined window of the touch screen;
A ruled line recognition step for recognizing the line detected in the line detection step as a ruled line parallel to either a horizontal or vertical ruled line corresponding to a row or column of a spreadsheet displayed in the window;
When a quadrangle is formed by the intersection of a plurality of ruled lines recognized in the ruled line recognition step, a cell setting step for setting the area in which the square is displayed to one cell in a spreadsheet;
When data specifying an area set in a cell in the cell setting step is input, an input value receiving step for receiving the data as a value input in the cell on a spreadsheet;
A spreadsheet control program characterized in that In the cell setting step, when the height or width of the newly formed rectangle is different from the previously set height or width of the adjacent cell, the height or width different from the other adjacent cells is set. 2. The spreadsheet control according to claim 1, wherein the height or width of the cell corresponding to the newly formed quadrangle is set to be the same as the height or width of the other adjacent cells. program. In the cell setting step, when the height or width of a newly formed rectangle differs from the previously set adjacent cell beyond a predetermined range, The height or width of a cell corresponding to the newly formed square is set so that a different height or width is different from the height or width of the other adjacent cells. 2. The spreadsheet control program according to 2. In the computer,
A deletion line detection step of detecting a deletion line that matches a predetermined condition drawn by traversing or vertically crossing an area set as a cell in the spreadsheet displayed in the window;
If the deletion line detected in the deletion line detection step is drawn across the area set as a cell, the line to which the cell belongs is drawn vertically across the area set as a cell. A deletion step of deleting the column to which the cell belongs,
The spreadsheet control program according to claim 1, wherein the spreadsheet control program is executed. The predetermined condition of the deletion line detected in the deletion line detection step is a line drawn in an area corresponding to a plurality of cells belonging to the same row or column, and if it belongs to the same row, the cell height A wavy line covering a predetermined number of cells in the row and a predetermined number or more of the total number of cells in the row. The spreadsheet control program according to claim 4, wherein the spreadsheet control lines are wavy lines covering a predetermined number or more of the total number of cells. In the computer,
A dividing line detection step for detecting a dividing line that matches a predetermined condition drawn by traversing or vertically crossing over an area set as a cell in the spreadsheet displayed in the window;
A cell dividing step of dividing one cell in which a dividing line is drawn on a region in the dividing line detecting step into two cells including a cell that inherits a value input to the one cell;
The spreadsheet control program according to claim 1, wherein the spreadsheet control program is executed. The predetermined condition of the dividing line detected in the dividing line detection step is a line drawn in an area corresponding to a plurality of cells belonging to the same row or column, and if it belongs to the same row, the row numbering It is a straight line drawn from the marked cell to the cell at the far end on the opposite side, and if it belongs to the same column, it is a straight line drawn from the cell numbered to the cell at the far end on the reverse side The spreadsheet control program according to claim 6, wherein the spreadsheet control program is provided. In the computer,
A ruled line selection step for accepting selection of a ruled line separating the rows or columns of the spreadsheet displayed in the window;
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, the two cells delimited by the first ruled line are changed to one cell. A cell integration step to integrate with
The spreadsheet control program according to claim 1, wherein the spreadsheet control program is executed. In the computer,
A ruled line selection step for accepting selection of a ruled line separating the rows or columns of the spreadsheet displayed in the window;
When it is detected that the first ruled line, which has been selected in the ruled line selection step, has been moved to a position exceeding the adjacent second ruled line, if the first ruled line is a horizontal line, cell height and row numbering A cell changing step for changing the cell width and column numbering if the first ruled line is a vertical line;
The spreadsheet control program according to claim 1, wherein the spreadsheet control program is executed. In the computer,
A ruled line selection step for accepting selection of a ruled line separating the rows or columns of the spreadsheet displayed in the window;
If the ruled line that has been selected in the ruled line selection step is a horizontal line, if it is detected that the left end of the ruled line has moved beyond the row numbered column, the row numbered column is shifted to the right. If the numbering of the column is changed and the ruled line that has been selected in the ruled line selection step is a vertical line, the numbering of the column is detected when it is detected that the upper end of the ruled line has moved beyond the numbered row of the column. A numbering change step for changing the numbering of the line by shifting the marked line downward,
The spreadsheet control program according to claim 1, wherein the spreadsheet control program is executed. A touch screen that can input and output data,
Line detecting means for detecting a line drawn in a predetermined window of the touch screen;
Ruled line recognition means for recognizing a line detected by the line detection means as a ruled line parallel to either a horizontal or vertical ruled line corresponding to a row or column of a spreadsheet displayed in the window;
A cell setting unit that sets an area in which the rectangle is displayed to one cell in a spreadsheet when a rectangle is formed by intersections of a plurality of ruled lines recognized by the ruled line recognition unit;
When data specifying an area set in a cell by the cell setting unit is input, an input value receiving unit that receives the data as a value input to the cell on a spreadsheet;
A spreadsheet control device comprising: A method of controlling a spreadsheet by a computer with a touch screen,
A line detecting step in which the computer detects a line drawn in a predetermined window of the touch screen;
A ruled line recognition step in which the computer recognizes the line detected in the line detection step as a ruled line parallel to either a horizontal or vertical ruled line corresponding to a row or column of a spreadsheet displayed in the window;
When the computer forms a quadrangle by the intersection of a plurality of ruled lines recognized in the ruled line recognition step, a cell setting step of setting the area where the quadrangle is displayed to one cell in a spreadsheet;
When the computer inputs data specifying the area set in the cell in the cell setting step, an input value receiving step for receiving the data as a value input in the cell on a spreadsheet;
A method for controlling a spreadsheet, comprising: