JPH11296596A - List processor and storing medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To simply divide a cell while keeping its attribute before dividing only through designating the required number for dividing by generating divided cells obtained by equally dividing the column width and the row width of a dividing object cell area into a designated numbers of columns and of rows in the object cell area based on cell dividing information inputted to a dividing dialogue. SOLUTION: An automatic row/column dividing dialogue displays a dividing dialogue for inputting cell dividing information to divide a cell set within a list in the directions of a column and of a row. A CPU generates divided cells obtained by equally dividing one or both of the column width and the row width by the designated numbers of columns and of rows in the object cell area set within the list based on cell dividing information inputted to the divided dialogue. In executing automatic dividing processing, a list 51 displays the state of designating an area to be executed and a list 55 displays the processing result of automatic dividing processing. In addition, list 52 to 54 show the process of automatic dividing processing.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table processing apparatus, and more particularly, to a table processing apparatus capable of automatically dividing a table created by the table processing apparatus into various regions. The present invention relates to a storage medium storing a program.

[0002]

2. Description of the Related Art Conventionally, so-called spreadsheet software (software using a tabulation table arranged vertically and horizontally) has been used in office computers and general-purpose computers. Recently, some word processors, electronic devices, and other applications have a spreadsheet function.

When a table is created in such table processing by spreadsheet software, and if it is necessary to divide and change the already created columns and rows of the table, the user is included in the table processing apparatus. Use the editing features to insert, delete,
The table is divided manually by copying and resetting the format.

[0004]

However, as described above, the table dividing process using the editing function in the table processing device is performed manually by the user.
Therefore, in dividing the matrix of the table, the user needs close effort to recreate the table, and when the table to be divided is complicated or has a large number, it requires enormous labor and effort to correct the table. There was a problem of spending time.

[0005] An object of the present invention is to divide the various regions such as columns, rows and cells of a created table by specifying the required number of divisions and to change the attributes (column width, ruled lines, shading, etc.) before the division. It is possible to easily divide while keeping.

[0006]

According to the first aspect of the present invention,
In a table processing apparatus for executing a table editing process for editing a table including a plurality of rows and a plurality of columns, a division dialog for inputting cell division information for dividing a cell set in the table in a column direction and a row direction And, based on the cell division information instructed and input in the division dialog, one or both of the column width and the row width are designated in the division target cell area set in the table. Divided cell generation means for generating divided cells equally divided by the number of columns and the number of rows.

According to the first aspect of the present invention, in a table processing apparatus for executing a table editing process for editing a table composed of a plurality of rows and a plurality of columns, a cell set in the table is arranged in a column direction and a row direction. Display a division dialog for inputting cell division information to be divided into cells, and based on the cell division information instructed and input in the division dialog, in the division target cell area set in the table, its column width and A divided cell is generated by equally dividing one or both of the row widths by the specified number of columns and rows.

Accordingly, a cell area to be divided can be set in a table, cell division information can be set in a division dialog, and cells can be equally divided with a specified number of columns and rows. When the user divides the table, the work load of manual editing can be reduced, and the time spent on the division work can be saved.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an embodiment of a table processing apparatus according to the present invention will be described in detail with reference to FIGS.

First, the configuration will be described. FIG. 1 is a block diagram showing a main configuration inside computer system 1 in the present embodiment. In FIG. 1, a computer system 1 includes a CPU 2, an input device 3, a RAM 4, a display device 5, a printing device 6, a storage device 7, and a storage medium 8.
It is connected to the.

CPU (Central Processing Unit) 2
Is an application program designated from among a system program stored in the storage device 7 and various application programs corresponding to the system,
Various instructions or data input from the input device 3
Various processes are executed in accordance with the application program stored in the storage device 7 in accordance with the input instruction and the input data, and the processing results are stored in the work memory 41 in the RAM 4. , On the display device 5. Then, the processing result stored in the work memory 41 is stored in a storage destination in the storage device 7 which is instructed to be input from the input device 3.

Further, the CPU 2 can store “character data” and “numerical data” in the table created by the spreadsheet processing or the like.
And "ruled lines", "shaded", "font", "layout",
Each data such as “format” is acquired as “attribute information” of each cell (a cell for inputting an item or a numerical value) and stored in the attribute information memory 42 in the RAM 4. Is input from R as "target area information"
When it is stored in the target area information memory 43 in the AM 4 and the number of divisions of the matrix is input from the input device 3, it is stored in the division information memory 44 in the RAM 4 as “division information”.
The PU 2 performs an automatic division process described later according to an automatic division processing program stored in the storage medium 7.

The flow of the automatic dividing process executed by the CPU 2 is roughly divided into a column dividing process and a row dividing process (see FIG. 6). In the flow of the column division processing and the row division processing, the division processing is executed (see FIG. 8), and in this division processing flow, the copy processing (see FIG. 9) and the shaping processing (see FIG. 10) And an editing process such as a column width process (see FIG. 11).

In the column dividing process, the CPU 2
4, the “target column start coordinates” data and the “target column end coordinates” data stored in the target area memory 43 are referenced, and the “target column start coordinates” are used by using the “counter X” of the internal counter 45. For each column from "" to "target column end coordinate", the below-described dividing process is repeatedly executed for each column.

Also in the row division processing, the CPU 2 refers to the “target row start coordinate” data and the “target row end coordinate” data stored in the target area memory 43 in the RAM 4 in the same manner as the column division processing. The dividing process is executed for each row from the “target row start coordinate” to the “target row end coordinate”.

In the dividing process, the CPU 2
Referring to the "number of divided columns" data stored in the divided information memory 44, the required number of increased columns is calculated from the "number of divided columns" data, and the columns corresponding to the number of columns are inserted into the table. By using the “counter Y” of the internal counter 45, copy processing and shaping processing, which will be described later, are executed for each row from the first row to the last row in one column, and thereafter, , A column width process described later is repeatedly executed.

The copy process is a process of copying attribute information (such as "ruled line" and "shaded data") of a cell before division into each of the inserted cells during the division process.
Refers to the attribute information stored in the attribute information memory 42 in the RAM 4 and uses the “counter X2” of the internal counter 45 to copy the attribute information for each cell in the column inserted in the division process. repeat. The contents of the attribute information to be copied are as follows: "ruled line / up / down", "ruled line / right", and "shaded" data are copied to the rightmost cell of the target column. -Copy up / down / shaded data.

In the shaping process, in order to make the shape of the table the same as before the division, a process of erasing unnecessary ruled lines and a process of adjusting an allocation range of data input to each cell are performed. That is, the CPU 2 deletes the “ruled line / right” of the cell before division, and further increases the “allocation / cell range” of the data input to this cell by the number of columns inserted in the division processing. .

The column width process is a process for adjusting the column width changed by inserting a column in the division process to the same width as before the division. In this column width processing, the CPU 2
The “column width” data is referred to from the attribute information stored in the attribute information memory 42 in the RAM 4. Then, using the "counter X2" of the internal counter 45, the process of changing the "column width" data for each cell is repeated. That is,
The CPU 2 calculates the column width of one cell by dividing the “column width” before the division by the “number of divided columns”, and sets the calculated column width as a new column width in each cell.

As described above, during the automatic division processing, the CPU
2 performs an operation by appropriately referring to the above-mentioned “attribute information”, “target area information”, “division information” and the like stored in each area in the RAM 4, and executes the automatic division processing program. Execute various processes.

Further, the CPU 2 stores the result of each processing executed during the automatic division processing in the work memory 4 in the RAM 4.
1 is stored in the work memory 41 in the RAM 4 and the display result is displayed on the display device 5.

The input device 3 includes a keyboard and a mouse provided with a cursor key, a numeric input key, various function keys, and the like, and outputs a pressing signal of a pressed key and a mouse position signal to the CPU 2. Various data may be input to each cell in the table by using a keyboard, and a division target area may be specified by a keyboard or a mouse when designating a division target area. Other input devices may be used as needed.

A RAM (Random Access Memory) 4 is an area for storing processing results and various information referred to during each processing in the automatic table division processing executed by the CPU 2. Work memory 41
, Attribute information memory 42 and target area information memory 43
, A division information memory 44, and an internal counter 45.

The work memory 41 stores a designated application program, an input instruction obtained from the input device 3, input data, a processing result of the automatic division processing, and the like.

The attribute information memory 42 shown in FIG. 2 stores "character data", "numerical data", "ruled lines (left, right, upper, lower)" and "shaded" for each cell in the created table. ,
Stores attribute information such as "numerical format", "font (size / font)", "assignment (cell range / type)" data, and stores attribute information such as "column width" and "display" data for each column. . That is, the attribute information memory 42
Stores the various data of the already created table acquired by the CPU 2 as attribute information, and performs a copy process and a column width process in the automatic division process.
Necessary attribute information is referred to by the CPU 2, and based on the referred attribute information, a copy process and a column width process are performed on the cell inserted in the division process (FIGS. 9 and 11).
reference).

The target area information memory 43 shown in FIG. 3A stores “target column start coordinates”, “target column end coordinates”,
"Number of columns", "target row start coordinates", "target row end coordinates",
Stores "row count" data. The data such as “target column start coordinates” and “target column end coordinates” specify which range of the created table is to be subjected to the automatic division processing, and are specified by the input device 3. Data such as “target column start coordinates” and “target column end coordinates” are acquired by the CPU 2 when input from the input device 3, stored in the target area memory 43, and stored in the column division during the automatic division process. It is referred to when the processing (see FIG. 7) and the division processing (see FIG. 8) are executed.

The division information memory 44 shown in FIG. 3B stores the "number of division columns" and "number of division rows" data input from the input device 3 to the automatic matrix division dialog 50 (see FIG. 4B). Is stored. The data of “number of divided columns” and “number of divided rows” indicate, for example, how many columns are divided into one column in the table. When one column is divided into three columns, the automatic division processing is executed so that the shape of the table does not change and the portion that was one column is displayed across three columns (FIG. 5 ( e)). The data of “number of divided columns” and “number of divided rows” are appropriately referred to by the CPU 2 during the execution of the automatic division processing, and the number of columns to be inserted into the table according to the “number of divided columns” and “number of divided rows”. And the number of rows are determined (see FIG. 8). In the copy process, the value of the counter X2 of the internal counter 45 is compared with the value of the counter, and the data content to be copied is determined according to the comparison result (see FIG. 9).
The allocation range is adjusted according to the value such as “number of divided columns” (see FIG. 10), and the column width is also adjusted in the column width processing (see FIG. 11).

The internal counter 45 shown in FIG. 3 (c) is a counter used in the processing repeatedly executed during the automatic division processing (see FIGS. 6 to 11). Is set to "Counter Y". “Counter X2” and “Counter Y2”
In the process that is sequentially repeated for the new column and row inserted in the “Counter X” column and “Counter Y” row, respectively,
The counter used. During the execution of the automatic division processing, the CPU 2 first substitutes the “target column start coordinates” into the “counter X”, and then terminates the predetermined processing according to the automatic division processing program. Is incremented by one, and it is determined whether or not the “counter X” is equal to or smaller than the “target row end coordinate”, thereby repeating the processing in the specified target area one after another. When the insertion of the column represented by "Counter X" is performed, some more columns will be present in the column of "Counter X". To execute the process. "Counter Y",
Similarly, for the “counter Y2”, the process is repeated using the internal counter 45 for each row.

The display device 5 is a CRT (Cathode Ray Tub).
e) and the like, and displays display data input from the CPU 2.

The printing device 6 prints tables and the like created by various application programs corresponding to the computer system 1.

The storage device 7 has a storage medium 8 in which programs, data and the like are stored in advance, and this storage medium 8 is constituted by a magnetic or optical recording medium or a semiconductor memory. The storage medium 8 is fixedly provided on the storage device 7 or is detachably mounted. The storage medium 8 includes the system program,
It stores various application programs, the above-mentioned processing programs related to table processing, data processed by each processing program, and the like.

The program, data, and the like stored in the storage medium 8 may be configured to be received and stored from another device connected via a communication line or the like. The storage medium 8 is stored in another connected device.
May be provided, and the program and data stored in the storage medium 8 may be used via a communication line.

Next, the computer system of the present embodiment
Operation 1 will be described. FIG. 4 is a diagram for explaining a schematic operation of the automatic division processing. FIG. 4A shows a table before the execution of the division processing. FIG. 4 shows a table for inputting the number of divisions when executing the automatic division processing. 10B is a diagram illustrating an automatic matrix partitioning dialog 50; The table shown in FIG. 4A is displayed on the display device 5, and 1, 2, 3, 4,.
Indicates the row number of this table, and A, B, C,
D,... Indicate the column numbers of the table. The coordinates of each cell in the table can be represented using the row numbers and column numbers.

The table to be processed shown in FIG. 4A is a two-column, four-row table having data of the contents shown in FIG. 2 as attribute information of each cell or column. The column B and the column C are selected as target areas (areas highlighted) by an input instruction. That is, “target column start coordinate” is “column B”, and “target column end coordinate” is “C
Columns and the number of columns are 2
2 and these data are stored in the target area information memory 43 in the RAM 4.

The automatic matrix partitioning dialog 50 shown in FIG. 4B is a sub-window opened on the display device 5 in accordance with an instruction input from the input device 3 when executing the automatic partitioning process. "Rows" and "columns" inside
Enter the number of divisions in the field. Click the "OK" button in the automatic matrix partitioning dialog to proceed to the execution of the automatic partitioning process, or click the "Cancel" button to not execute it. In addition, when a detailed description of the operation of the automatic dividing process is required, a "help" button is clicked. This automatic matrix partitioning dialog 50
Are input to the CPU 2 and stored in the division information memory 44 in the RAM 4 as the “number of divided columns” or “number of divided rows”.

For example, in the automatic matrix partitioning dialog 50 shown in FIG. 4B, since "3" is entered in the "column" column, the "number of divided columns" data is entered. And the division information memory 44 in the RAM 4
When the "OK" button is clicked in this state, the CPU 2 executes the automatic division processing.
As a result of this automatic division processing, the B and C columns specified as the division target areas are divided into three columns without changing the shape of the table.

FIG. 5 is a diagram showing a detailed operation when the automatic division processing is performed on the created table. FIG.
5A shows a table 51 on which a state in which an area for executing the automatic division processing is designated is displayed, and FIG. 5E shows a table 55 on which a processing result of the automatic division processing is displayed. It is. In FIG. 5, tables 52, 53, and 54 shown in (b), (c), and (d) show the processing steps of the automatic division processing, and are not actually displayed on the display device 5.

First, as shown in Table 51 of FIG. 5A, here, column B is designated as the target area. Therefore, the “target column start coordinate” data is “column B”,
“Target row end coordinates” is also “B row”. The CPU 2 acquires target area information such as “target row start coordinates” and “target row end coordinates” and stores the target area information in the target area information memory 43 in the RAM 4.

Next, the CPU 2 acquires the attribute information of the target area specified in the created table and stores it in the attribute information memory 42 in the RAM 4. The contents of the attribute information are as shown in FIG. 2, and specifically, “data”, “ruled lines (left, right, upper, lower)”, “shaded”, “numerical format”, “ Font (size / typeface) "and" assignment (cell range / type) ".

The CPU 2 executes the automatic matrix partitioning dialog 50
The “number of divided columns” and “number of divided rows” input to (see FIG. 4B) are obtained, and the data of “number of divided columns” and “number of divided rows” are used as division information to divide data in the RAM 4. Information memory 4
4 is stored. And this automatic matrix partitioning dialog 5
When the “OK” button of “0” is clicked, the CPU 2
Start the automatic splitting process.

The operation of the automatic dividing process will be described below with reference to the flowcharts of FIGS.

FIG. 6 shows a main routine of the automatic division processing, in which a column division processing routine 70 (step S61) and a row division processing routine (step S62) are performed. FIG.
A column division processing routine 70 is shown, in which division processing is sequentially and repeatedly executed line by line from “target column start coordinates” to “target column end coordinates”, and the division processing for each column is performed by a division processing routine 80 (see FIG. 8). It is processed according to. FIG.
FIG. 8 is a diagram showing a division processing routine 80 called by the column division processing routine 70. 9, 10, and 1.
1 is a subroutine called in the division processing routine 80 in FIG. 8, and FIG.
0, FIG. 10 shows a shaping processing routine 100, and FIG. 11 shows a column width processing routine 110.

When the automatic division process is started, first, the CPU
2 calls the column division processing routine 70 (step S
61). In the column dividing process 70, the CPU 2 executes a dividing process of dividing the target column of the created table into a specified number.

When the column division processing routine 70 is called, the CPU 2 first refers to the “target column start coordinates” in the target area information memory 43 and stores the “target column start coordinates” in the “counter X” of the internal counter 45. (Step S
71). Then, the CPU 2 determines whether the “counter X” is the “target row end coordinate” stored in the target area information memory 43 in order to sequentially repeat the row-by-row division processing (step S72). , If “counter X” is not “target row end coordinate”, “counter X”
The division processing routine 80 (see FIG. 8) for the column is called (step S73).

FIG. 8 shows a division processing routine 80. When the division processing routine 80 is called, the CPU 2 first inserts (“division column number” −1) columns to the right of “counter X” to increase the number of columns (step S8).
1). In the example of this embodiment, two columns are inserted to the right of the column B as shown in a table 52 shown in FIG. next,
In order to repeatedly execute copy processing and shaping processing line by line from the first row to the last row of the “Counter X” column, the CP
U2 uses "counter Y" of the internal counter 45,
First, “0” meaning the first row is substituted for “counter Y” (step S82).

The CPU 2 determines whether or not the "counter Y" is the last line (step S83).
Is the last row, "Counter X" column "Counter Y"
The copy processing routine 90 is called for the cells in the row (step S84). When the copy processing routine 90 is executed and completed, the table becomes the state of the table 53 shown in FIG. (The copy processing routine 90 will be described below.) Next, the shaping processing routine 100 is called for the cell in the “counter X” column and the “counter Y” row (step S8).
5). When the shaping process routine 100 is executed and completed, the table becomes a table 54 shown in FIG. (The shaping process routine 100 will be described below.) When the processes up to this point are completed, the CPU 2 increments the “counter Y” of the internal counter 45 by one (step S8).
6), and return to the determination of step S83. That is, the processing for each row is executed, and each time, the value of “Counter Y” is updated to lower the row, and if “Counter Y” is equal to or less than “Last row”, copy processing and shaping processing are performed. It is.

If the "counter Y" is larger than the last row in the judgment in step S83, the column width processing routine 110 is called and started (step S87).
(The column width processing routine 110 will be described below.) When the column width processing routine 110 ends, the division processing routine 80 ends, and the process proceeds to step S74 in FIG.
2 increments the "counter X" of the internal counter 45 by one, that is, moves the column to be processed to the right by one column, and returns to the determination as to whether the "counter X" is the "target column end coordinate" (step S72). ). If the “counter X” is larger than the “target column end coordinate”, the column division processing 70 ends here, and the process proceeds to the row division processing (step S62). The row division processing is the same operation as the above-described column division processing, and thus the description is omitted.

When the line division processing ends, the automatic division processing ends, and the CPU 2 outputs the result of the automatic division processing to the RA
The processing result is stored in the work memory 41 in the M4, and at the same time, the processing result is displayed on the display device 5. In this case, FIG.
Is displayed on the display device 5.

Next, a copy processing routine 90 which is a subroutine called by the division processing routine 80 will be described. When the copy process is executed, in order to maintain the state of the table before splitting (Table 51), a copy method is determined in advance as an editing rule as follows.

Ruled line / Left not copied Ruled line / Right Only copy rightmost cell Ruled line / Top copied Ruled line / Bottom copied Shaded Copy Numeric format Not copied Font Not copied Assigned Not copied

FIG. 9 shows a copy processing routine 9 for one cell.
In this case, the processing in the "counter X" column "counter Y" row given by the calling side (division processing routine 80) is regarded as the original cell, and the division processing routine 8 is executed.
0, the column inserted in step S81 is moved right by one cell by the number of inserted columns, and the attribute information of the original cell is repeatedly copied. "Counter X2" is used as a counter used at this time.

More specifically, first, the CPU 2 obtains the cell information of the "Counter X" column from the attribute information memory 42 (step S91). Next, the CPU 2 sets “counter X
Substitute the value of "Counter X" into "2" (step S9)
2). Then, “Counter X2” is (“Counter X”
+ “The number of divided columns”) is determined (step S93).

According to this determination, "counter X2"
If it is smaller than ("counter X" + "number of divided columns"),
The cell information of the “Counter X” column “Counter Y” row acquired in step S91 is copied to the “Counter X2” column “Counter Y” row cell. At this time, the content to be copied is
Only the data of “ruled line / up / down” and “shaded” are included (step S94).

Next, the CPU 2 determines whether or not the value of the "counter X2" is equal to ("counter X" + "number of divided columns" -1). That is, it is determined whether the “counter X2” is at the rightmost end (step S95).

If the value of "counter X2" is not the same as ("counter X" + "number of divided columns" -1), the value of "counter X2" is increased by one (step S97), and step S93 is performed. Return to the judgment. If the value of “counter X2” is equal to (“counter X” + “number of divided columns” −1) in the determination of step S95, “counter X2” sets the “counter X” column to the designated number. Since it is in the rightmost column at the time of division, the cell information of the “Counter X” column “Counter Y” row acquired in step S91 is copied. At this time, the content to be copied is only the data of “ruled line / right” (step S96).

Thereafter, the CPU 2 increments the value of the "counter X2" by one, that is, moves the cell to be copied to the right cell (step S97), and returns to the determination of step S93.

If it is determined in step S93 that "counter X2" is equal to or more than ("counter X" + "number of divided columns"), copy processing has been executed for all cells in the "counter X" column. Therefore, the copy processing routine 90 ends here.

That is, in the copy processing routine 90, the contents to be sequentially copied are as follows. In each of the cells in the "Counter X" column obtained in step S91, "ruled line / up / down" and "shaded" , But only for the rightmost cell, "ruled line / vertical", "shaded",
And the data of “ruled line / right” are copied. Therefore, the same attributes (“shaded”, “ruled line / up / down”) as before the division are retained for the column that has been increased by the insertion of the column in step 81 of the division process 80.

More specifically, referring to the example of FIG. 5, "Counter X" indicates the B column before the division, and in this example, the B column increases to three columns by the division. "Is incremented by one each time the processing of steps S94 to S96 is executed, that is, the copy destination cell is sequentially moved from column B to the right by two columns, and the copy source" counter X " Column “counter Y” row (here, cell B
2) The cell information (“ruled line / up / down”, “shaded”) is copied. Then, as a result of sequentially moving the column and processing, if the rightmost column is reached, the cell information “ruled line / up / down”, “shaded” and “ruled line / right” are copied. Thereafter, this copy processing is executed by sequentially lowering the rows (in step S86 of the division processing routine 80, the "counter Y" is incremented), so that finally the table 53 shown in FIG.
State.

Next, according to the flowchart of FIG.
The shaping processing routine 100 will be described. In executing the shaping process, an editing rule is determined in advance so that the cell information is changed as follows in order to maintain the state of the table (Table 51) before the division.

Ruled Line / Left Not Changed Ruled Line / Right Erase Ruled Line / Top Not Changed Ruled Line / Bottom Not Changed Shaded Not Changed Numeric Format Not Changed Font Not Changed Assignment Adds the increased number of columns to the assignment range.

First, the CPU 2 deletes, from the calling side (the division processing routine 80), the ruled line / right of the cell in the given “Counter X” column “Counter Y” row (step S).
101). Further, the CPU 2 reads from the attribute information memory 42
The “allocation / cell range” data is acquired, and “(the number of divided columns) −1” is added to the acquired data to extend the allocation range (step S102). As a result of this processing, the ruled line and right of the original cell are deleted, and the allocation range of the character data and numerical data input to the original cell is included up to the column inserted in step S81 of the division processing 80. The shape of the table is the same as before, except for the column width.

In this shaping processing routine 100,
Further, the row is sequentially lowered and executed (in step S86 of the division processing routine 80, the value of "counter Y" is increased), so that the cell before division is finally obtained as shown in Table 54 of FIG. Is deleted, and B, C,
The data spans column D.

Next, the column width processing routine 11 will be described with reference to FIG.
0 will be explained. In this process, the cell in the “Counter X” column “Counter Y” row given by the calling side (the division processing routine 80) is regarded as the original cell, and the width of the original column is equally divided by the number of divided columns. Set the width for each column. This process is repeated by moving the cell inserted in step S81 of the division processing routine 80 to the right by one cell. "Counter X2" is used as a counter at this time.
Is used.

More specifically, first, the CPU 2 obtains column width information of the “Counter X” column from the attribute information memory 42 (step S111). Further, in order to sequentially move to the right cell and execute the repetition processing, “counter X2”
Is substituted for the value of “Counter X” (step S11).
2). The CPU 2 determines whether or not “counter X2” is smaller than (“counter X” + “number of divided columns”) (step S113).

"Counter X2" is ((Counter X) +
If it is smaller than “the number of divided columns”, (column width / number of divided columns acquired in step S112) is set as the column width of “counter X2” (step S114). In order to move to the right cell, "Counter X
"2" is incremented by one (step S115). That is, since the column width is increased by the number of columns inserted in step S81 of the division process 80, the original column width (the column width acquired in step S112) is divided in order to return to the original column width. It is equally divided by the number of columns and set in each cell.

Thereafter, the flow returns to the determination at step S113.
If the value of “counter X2” is equal to or greater than (“counter X” + “number of divided columns”), this means that the column width processing has been executed for all of the columns inserted in step S81 of the division processing 80. The width processing routine 110 ends. Therefore, the column width is the same as the column width of the table before division.
The column width processing routine 110 ends.

When the column width processing routine 110 is completed, in this example, a table 55 shown in FIG.
The column widths, ruled lines, shading, etc. of the table are in the state before division,
The number of columns is divided into three.

As described above, the automatic dividing process performs the dividing process 80 including the copying process 90, the shaping process 100, and the column width process 110, and performs the column dividing process 70 including the dividing process 80 and the row dividing process. Do. The CPU 2 stores the processing result thus obtained in the work memory 41 of the RAM 4 and displays it on the display device 5.

Therefore, by various processes of the automatic dividing process,
Editing processing such as insertion, attribute copying, column width adjustment, etc. is performed. As a result, the table is divided into the number entered in the automatic matrix division dialog 50 and the table shape (ruled line) after the automatic division processing is performed. , Shading, data allocation, column width, etc.) are the same as the table before the automatic division processing.

In the automatic division processing, not only the column division but also the line division is possible if the number of divisions is input in the row column of the automatic matrix division dialog 50.

As described above, in the computer system 1 according to the present embodiment, the CPU 2 stores the attribute information of the created table in the attribute information memory 42 in the RAM 4.
And data such as “target column start coordinates” and “target column end coordinates” of the division target region specified by the input device 3 are stored in the target region information memory 43 in the RAM 4.
In the automatic matrix partitioning dialog 50 displayed on the display device 5, the “number of divided columns” specified by input from the input device 3.
Is stored in the division information memory 44 in the RAM 4.

Then, the CPU 2 refers to the table attribute information, target area information, division information, and the like stored in the RAM 4 as needed, and inserts columns and rows into the created table, The cell information such as hatching is copied, unnecessary ruled lines are erased, various editing processes such as adjustment of data allocation range and column width are performed, and the processing result is stored in the work memory 41 in the RAM 4. , On the display device 5.

Therefore, according to the computer system 1 of the present embodiment, when dividing various regions such as rows and columns of an already created table, the above-described editing processing is manually performed in the related art. On the other hand, only the operation of designating the area to be divided and specifying the number of divisions in the automatic matrix division dialog 50 automatically executes various processes for division according to the automatic division processing program. As a result, the complexity of the row or column division work that frequently occurs every day is eliminated, the work load on the user is greatly reduced, and the work efficiency can be significantly improved.

[0075]

According to the first and fourth aspects of the present invention, a cell area to be divided is set in a table,
You can set cell division information in the division dialog,
It is possible to divide cells evenly by the specified number of columns and rows, so that when a user divides a table, the work load of manual editing is reduced, and the time spent on the division is reduced. be able to.

According to the second aspect of the invention, when dividing the cell area to be divided, the cell attribute information before the division can be copied to the cell area after the division. It is possible to hold previous cell attribute information, and it is possible to reduce a user's work load and work time for adjusting the table to the shape before the division when the table is divided.

According to the third aspect of the present invention, when there is data input in the cell area to be divided, the allocation range of the data is reset to the cell area after division, and the data is It is possible to output as data spanning the cell area of the table, and it is possible to reduce the work load and time of the user of the table.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a main configuration inside a computer system 1 according to an embodiment to which the present invention is applied.

FIG. 2 is a diagram showing the contents of data stored in an attribute information memory 42 in a RAM 4.

FIG. 3A shows a target area information memory 43 in a RAM 4;
(B) shows data stored in the division information memory 44 in the RAM 4, and (c) shows data stored in R.
FIG. 4 is a diagram showing a counter of an internal counter 45 in AM4.

FIG. 4A is a diagram for explaining a schematic operation of an automatic dividing process in the computer system 1 according to the embodiment to which the present invention is applied, and shows a table before executing the dividing process. (B) shows an automatic matrix division dialog 50 for inputting and instructing the number of divisions when executing the automatic division processing.

FIG. 5 is a diagram showing a detailed operation when an automatic division process is performed on a created table.

FIG. 6 is a flowchart showing a main routine 60 of the automatic division processing.

FIG. 7 is a flowchart showing a column division processing routine 70 called by the automatic division processing routine 60;

FIG. 8 is a flowchart showing a division processing routine 80 called by the column division processing routine 70;

FIG. 9 is a flowchart showing a copy processing routine 90, which is a subroutine called 70 in the division processing routine.

FIG. 10 is a flowchart showing a shaping process routine 100, which is a subroutine called in the division process routine 70;

11 is a flowchart showing a subroutine called by the division processing routine 70, which is a column width processing routine 110. FIG.

[Description of Signs] 1 Computer system 2 CPU 3 Input device 4 RAM 41 Work memory 42 Attribute information memory 43 Target area information memory 44 Division information memory 45 Internal counter 5 Display device 50 Automatic matrix division dialogue 6 Printing device 7 Storage device 8 Storage Medium 9 bus

Claims (4)

[Claims] 1. A table processing device for executing a table editing process for editing a table composed of a plurality of rows and a plurality of columns, wherein a cell division information for dividing a cell set in the table in a column direction and a row direction is input. Display control means for displaying a division dialog for performing the division, and based on the cell division information instructed and input in the division dialog, in the division target cell region set in the table, one of the column width and the row width or A table processing apparatus, comprising: a divided cell generating unit that generates divided cells obtained by equally dividing both of them with a specified number of columns and rows. 2. The apparatus according to claim 1, further comprising an attribute information storage unit configured to store cell attribute information before division of the cell area to be divided, which is set in the table instructed and inputted in the division dialogue, When equally dividing the cell area to be divided by the specified number of columns and rows, the cell attribute information before division stored in the attribute information storage means is copied, thereby dividing the cell after division. 2. The table processing apparatus according to claim 1, wherein cell attribute information before division is reflected in the area. 3. An attribute information storage means for storing cell attribute information before division of the cell area to be divided set in the table designated and inputted in the division dialogue, wherein the cell area to be divided is If the input data is present, the divided cell generation means resets the cell attribute information before division stored in the attribute information storage means, so that the data before division is stored in the cell area after division. 2. The table processing apparatus according to claim 1, wherein the data allocation information is reflected. 4. A storage medium storing a program for executing a table editing process for editing a table composed of a plurality of rows and a plurality of columns, wherein the cells set in the table are divided in a column direction and a row direction. A computer-executable program code for displaying a division dialog for inputting division information; and the cell area to be divided set in the table based on the cell division information input in the division dialog. And a computer-executable program code for generating a divided cell obtained by equally dividing one or both of the column width and the row width by the specified number of columns and rows, and storing a program including A storage medium characterized by the above-mentioned.