JPH096765A - Information processor - Google Patents

Abstract

PURPOSE: To improve the workability of table calculation by automatically linking plural tables, handling them as a single table and simultaneously performing the table calculation over plural tables. CONSTITUTION: An input means 2 performs the input of character, numerical value and ruled line or the input of a cursor key, etc. Concerning an output means 3, a display or a printer corresponds to it but it is not limited to them. A control means 1 is provided with a function for performing processing such as editing correction, calling or registration to document information inputted from the input means 2 and outputting the result to the output means 3. A table certifying means 4 executes single table certification repeatedly plural times. Concerning plural partial tables, a table linking means 5 manages the row and column, where each partial table exists, while using table information data 6. Therefore, which row of which partial table an n-th row of an entire linked table corresponds to can be found, the plural tables can be handled as a single table, and the table calculation over the plural tables is simultaneously performed.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information processing device such as a Japanese word processor, and more particularly to an information processing device having a spreadsheet function.

[0002]

2. Description of the Related Art In the conventional table calculation, one independent table is used as a calculation target.

[0003]

However, the above-mentioned conventional technique has only a single table as a range to be calculated, and does not have a function of calculating over a plurality of tables.

In this prior art, when the sum of the numerical values entered in a plurality of tables is to be obtained, first, in each of the plurality of tables, subtotals are first obtained, and these are artificially added using an abacus or a calculator, etc. You are forced to fill in the fields. Therefore, there is a problem that calculation takes time and an error occurs in calculation. In particular, when a plurality of tables do not exist on the same page, calculation errors are likely to occur.

As one of the methods for solving this, an auxiliary key line is drawn between two tables, the two tables are treated as a single table, and the total is obtained by a calculation function provided in the apparatus. However, there was the inconvenience of drawing the auxiliary K-line and deleting it later.

Focusing on the above, an object of the present invention is to automatically connect a plurality of tables and treat them as a single table, and perform table calculations over a plurality of tables at a time to improve the workability of the table calculation. An object of the present invention is to provide an information processing device capable of performing the above.

[0007]

[Means for Solving the Problems] The above-mentioned object is to provide input means for inputting and instructing editing of characters / numerical values / key lines, and document data created based on the character data and the like input by this input means. An information processing apparatus comprising: output means for displaying or printing; table recognizing means for recognizing a table from the position of a key line; and control means for controlling the whole by associating the respective means with each other. And a table certifying means for detecting whether or not there is a second table other than this table that can be treated as the same table as this table, and if the second table is detected by this table certifying means, This is achieved by providing table connecting means for connecting the second table to the first table so that they can be handled as the same table, and performing a spreadsheet calculation over both connected tables.

[0008]

[Function] The table certifying means repeatedly performs single table qualification multiple times.

The table connecting means manages the number of rows and the number of columns of each of a plurality of independent tables. With this, it is possible to determine which nth row of the entire concatenated table corresponds to which row of which partial table, and it is possible to detect a plurality of tables that can be treated as the same table. It works so that it can be calculated in a spreadsheet.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram when the basic control configuration of this embodiment is incorporated in a word processor. In the figure, 1 is control means, 2 is input means, 3 is output means, 4
Is a table recognizing means, and 5 is a table connecting means.

The table certifying means 4 repeatedly carries out a single table qualification a plurality of times.

The table connecting means 5 manages, in each of the plurality of partial tables, the number of rows and columns of the partial table by the table information data 6. With this, it is possible to find which row of which partial table the n-th row of the entire concatenated table corresponds to, and it is possible to treat a plurality of tables as if they were a single table.

The input means 2 is for inputting characters, numerical values, key lines, cursor keys, keys for instructing various editing functions of a word processor, and the like, which corresponds to a keyboard or a mouse. It is not limited.

The output means 3 corresponds to, but is not limited to, a display and a printer.

The control means 1 has a function of performing editing and proofreading, calling, registration, and the like on the document information input from the input means 2 and outputting it to the output means 3.

FIG. 2 is a flow chart showing an outline of the process of performing the single table approval by the table approval means 5 a plurality of times.

In step 400, 0 is substituted for the variable I for managing the number of tables. If it is determined in step 401 that the input key operation is a key indicating continuation of table connection, a single table qualification process is executed (step 40).
2).

In step 403, it is determined whether the format of the table certified so far is the same as the format of the table certified this time. However, in the case of the first table certification, it is meaningless to judge whether they are the same. If the result of determination is that they are the same, in step 404, the variable I for managing the number of tables is incremented by 1. In step 405, the table recognized this time is set as the I-th table, and information indicating that is stored in the table information data 6. Then, in step 401, the input of the next key is awaited.

At step 403, it is judged whether the format of the table certified so far and the format of the table certified this time are the same. If they are not the same, an error indicating that the table formats are different is given at step 406. Display and wait for input of next key in step 401.

If it is determined in step 401 that a key has been input and the key is a key that means the end of table connection,
Up to now, it is assumed that the certified I tables are treated as a concatenation (step 407).

FIG. 3 is a flow chart showing an outline of the processing of the single table qualification processing 402 of FIG.

In step 410, the key line position to the left of the cursor is acquired and this digit position is used as the reference position in the table. This is also the start digit of the first column. Steps
At 411, it is determined whether or not there is a key line to the right of the cursor. If the K-line exists, the position of the K-line is acquired and used as the start position of the row. At this time, the column width is obtained by obtaining the digit difference from the immediately preceding K-line. Then step 41
Return to 1.

When it is determined in step 411 that the next kei line does not exist anymore, in step 413, the kei line is searched downward in the table to find the end position of the table, which is the last row of the table. To do.

By the above processing, the table information data 6 of a single table can be obtained.

FIG. 4 is an example of a table, which is an example in which the cursor is set in the frame “120” of A branch 1992 and the table is certified. By table certification, it is possible to obtain that the table size is 5 rows and 4 columns.

FIG. 5 shows an example of a document including two tables. 1
The page has a title and a first table. On page two,
There is a second table. Each table has a table title,
It includes a heading and a table data section.

FIG. 6 is table information data when a plurality of tables are linked in the document of FIG. 5, and has table size and position information for each table. Further, it has a column width as common information of a plurality of tables.

FIG. 7 shows a state in which the two tables in FIG. 5 are connected. If the head of the table data section of each table is set as the reference position, the total number of rows is 11.

As shown in FIG. 6, the table linking means 5 manages the position information in the document and the table size in each of the plurality of partial tables, and the nth line of the linked table is the number of which line of the partial table. You can ask if it corresponds.

For example, in FIG. 5, the frame “260” of G branch 1993 is 8 rows and 2 columns in the concatenation table of FIG. 7, which corresponds to 3 rows and 2 columns in the second table. This can be easily obtained from the table information data of FIG.

As described above, according to this embodiment,
In FIG. 5, conventionally, when obtaining the subtotal of each branch of ABCD and the subtotal of each branch of EFG, and the total thereof,
In each of the two tables, there was no choice but to obtain subtotals, artificially add them using an abacus or calculator, and enter them in the total column. Subtotals can be calculated using the calculation function for each table, but the total could not be calculated over different tables. Alternatively, if you draw an auxiliary key line between two tables and make the two tables look like one table and certify them as a single table, you can treat them as a single table, but the total value can also be calculated by the calculation function, There was the inconvenience of having to draw the auxiliary key line or delete the auxiliary line later.

According to the present embodiment, by connecting the tables, the two separate tables can be treated as a single table, so that the total can be calculated without drawing an auxiliary line.

[0034]

As described above, according to the present invention,
Multiple tables are automatically concatenated and treated as a single table,
Since it is possible to collectively perform spreadsheets over a plurality of tables, it is possible to provide an information processing apparatus that improves the workability of spreadsheets.

[Brief description of drawings]

FIG. 1 is a block diagram when a basic control configuration according to an embodiment of the present invention is incorporated in a word processor.

FIG. 2 is a flowchart showing a process outline of a table certifying means.

FIG. 3 is a flowchart showing a process outline of a table recognition process.

FIG. 4 is an example of a table.

FIG. 5 is an example of a document including two tables.

FIG. 6 is a diagram showing table information data in which a plurality of tables are linked.

FIG. 7 is a diagram showing a state in which two tables are connected.

[Explanation of symbols]

1 ... control means, 2 ... input means, 3 ... output means, 4 ... table recognizing means, 5 ... table connecting means, 6 ... table information data.

Claims (2)

[Claims] 1. Input means for inputting and instructing editing of characters / numerical values / key lines, and output means for displaying or printing document data created based on the character data or the like input by the input means. , An information processing apparatus comprising a table recognizing means for recognizing a table from the position of the key line, and a control means for associating the respective means with each other to control the whole, in addition to the first table and this table Table recognizing means for detecting whether or not there is a second table that can be treated as the same table, and when the second table is detected by this table recognizing means, this second table is referred to as the first table. An information processing apparatus comprising table connecting means for connecting the above tables so that they can be handled as the same table, and performing table calculation over both connected tables. 2. The table concatenation means manages in-document position information and the number of matrices in each of a plurality of partial tables, and determines which nth row of the concatenated table corresponds to which subtable and which row. The information processing apparatus according to claim 1, wherein the information processing apparatus is requested.