JPH0535728A - Document processor having automatic field setting table function - Google Patents

Abstract

PURPOSE:To set and change the fields and a format at one time for each column or row or to an entire table by tracing each column/row header from a master header included in the table data and then setting or changing the fields by tracing the column and row cells. CONSTITUTION:A pointer pointing a column header T1 of the head column of a table is assigned to a master header P of the table data together with a pointer pointing the next column header T2 assigned to the header T1, the pointers pointing the head cells S1 and S3 of the same column assigned to both headers T1 and T2, and the pointers pointing the following cells S2 and S4 assigned to the cells S1 and S3 respectively. At the same time, the connection is secured between the header P and the headers T1/T2 as well as between the headers T1/T2 and the cells S1-S4 respectively. Each cell of the corresponding column is traced from a column header Ti in a column designation state and from the headers T1 and T2 connected to the header P in a designation state of an entire table respectively based each pointer. Thus the fields of the same format are set and changed at one time.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a document processing apparatus having table creating / editing and field setting functions.

[0002]

2. Description of the Related Art In recent years, a document processing device such as a dedicated document processing device such as a Japanese word processor, or a workstation capable of using document processing software has a document creation / editing function and a table It generally has a creation / editing function.

Creation of a table in this type of document processing apparatus is performed by designating and inputting the position of the table, the number of columns, the number of rows, the size of cells, and the like. After the table is created, it is necessary to set fields in each cell of the table.

Conventionally, when setting fields having the same format in units of columns, rows of the table or the whole table, one cell in the target column, row or the entire table is set by a mouse or the like. It was necessary to sequentially specify each field and set the field for that cell each time.

It has also been known that instead of setting fields of the same format for each cell one by one, setting fields for each cell by copy and paste (copy & paste).

[0006]

As described above, in the conventional document processing apparatus having the table creating / editing function, the data input format (cell field format) of the table column unit, row unit, or the entire table is the same. Even if it is, it is extremely complicated because it is necessary to set a field for each corresponding cell one by one, or by setting a field having the same format many times by a method such as copy and paste. . Also, when it is desired to change the format, it is necessary to change one by one for each cell or copy and paste.

The present invention has been made in view of the above circumstances, and an object thereof is document processing capable of automatically setting fields having the same format at one time for each column or row of a table or for the entire table. To provide a device.

Another object of the present invention is to provide a document processing apparatus capable of automatically changing the format of a field that has already been set, column by column, row by row, or the entire table at once. It is in.

[0009]

According to the present invention, a parent heading representing the structure of a table and headings of each column / row are connected in the column / row direction by connection information, and each column / row heading and each cell are connected. Storage means for storing table data linked by linking information in the row / column direction, input means for designating and inputting setting / changing in fields / columns of the same format or in the entire table, Depending on the field setting / change designation from the input means, table columns /
Field setting means for setting / changing fields having the same format is provided for each row or for the entire table, and when the field setting / change is designated for each column / row, the designated column / column in the corresponding table data is set. Follow the column / row cell from the row heading to set / change the field of the same format. When specifying the field setting / change for the entire table, follow each column / row heading from the parent heading in the corresponding table data, More rows /
It is characterized in that the cells of a row are traced to set / change fields of the same format.

[0010]

In the above structure, the parent heading of the table data stored in the storage means has a pointer pointing to the heading of the first column / row of the table. The top column / row heading has a pointer to the heading of the next column / row. In this way, all column / row headings up to the last column / row are linked (linked) by the pointer.

Each column / row heading also has a pointer to the next successive cell. The cells are also connected by pointers between cells, such as having a pointer that points to the cell that follows next.

Therefore, for example, when it is desired to set fields of the same format in all one column, if only a pointer pointing to the column heading (column heading) is passed to the field setting means, the field setting means will use the pointer. It is possible to extract the pointers of all cells belonging to the column from the first cell of the column and the pointer of the first cell to the next cell, and set the fields of the same format in all the cells.

Further, when it is desired to set fields having the same format for the entire table, if a pointer pointing to the parent heading is passed to the field setting means, all columns or row headings are traced from the parent heading, and each It is possible to follow all cells of a column or row from a column or row header and set the field of the same format in all the cells. The above is the same when the format of the set field is changed (edited) in units of columns or rows or in the entire table.

[0014]

1 is a block diagram of a document processing apparatus according to an embodiment of the present invention.

In FIG. 1, reference numeral 10 denotes a document processing mechanism for performing various document processes including document creation / editing. The document processing mechanism 10 is a functional block realized by a document processing program and a CPU (not shown) that executes the program.

Reference numeral 11 is a document processing mechanism, and is a tabulation mechanism for creating / editing a table. 12 is a tabulation mechanism 11.
This is a storage unit that stores the table data created and edited in. Reference numeral 13 is provided in the document processing mechanism 10, and the storage unit 1
2 is a field setting mechanism for setting / editing fields for the table data stored in 2.

Reference numeral 20 is a display monitor such as a CRT display or a liquid crystal display used for displaying documents. Two
Reference numeral 1 is a keyboard used for inputting characters by a user operation and various instruction inputs, and 22 is a mouse as a pointing device. The display monitor 20, the keyboard 21, and the mouse 23 form an interface (man-machine interface) between the document processing mechanism 10 and the user.

FIG. 2 is a diagram showing the overall structure of the table data stored in the storage unit 12 of FIG. 1 by taking a 2 × 2 (2 rows and 2 columns) table as an example, and FIG. The case of the horizontal table is shown in FIG.

As shown in the figure, the table data of the vertical table includes a parent heading P which is a parent of the table heading, column headings T1 and T2 having the same number as the number of columns, and 2 × 2 cells S.
1 to S4, and the table data of the horizontal table includes a parent heading P, row headings Y1 and Y2 of the same number as the number of rows, and 2 × 2 cells S1 to S4.

In the case of a vertical table, the parent heading P has a pointer (header pointer indicating the storage destination address of the column heading T1) to the heading column heading T1 (here, the leftmost column is the heading column). In the case of a horizontal table, it has a pointer to the top row heading Y1 (here, the top row is the top row).

The column heading T1 has a pointer to the heading T2 of the next column (the next column on the right side). The column heading T2 does not have a pointer to the next column heading because it is the last column heading and there is no next column. The column heading T1 also has a pointer to the head cell S1 of the same column (cell pointer indicating the storage destination address of the head cell S1). Similarly, the column heading T2 is
It has a pointer to the first cell S3 in the same column. Column heading T
1 and T2 also have a pointer to the parent heading P in common.

The row heading Y1 has a pointer to the heading Y2 of the next row (row next to the bottom). The row heading Y2 has no heading pointer because it is the last heading and there is no next row. The row heading Y1 also has a pointer to the first cell S1 of the same row. Similarly, the row heading Y2 has a pointer to the head cell S2 of the same row. The row headings Y1 and Y2 also have a pointer to the parent heading P in common.

The cell S1 has a pointer to the next cell (cell S2 in the case of a vertical table, cell S3 in the case of a horizontal table), and cell S2 is the next (row) cell S4 in the case of a horizontal table. With a pointer to. Further, the cell S3 has a pointer to the next (column) cell S4 in the case of the vertical table, and the cell S4 (because it is the cell in the last column and the last row).
It has no cell pointer.

The cell S1 also has a pointer to the column heading T1 (for a vertical table) or a pointer to a row heading Y1 (for a horizontal table). Similarly, the cell S2 also has a pointer to the column heading T1 (in the case of the vertical table) or a pointer to the row heading Y2 (in the case of the horizontal table). The cell S3 has a pointer to the column heading T2 (in the case of a vertical table) or a row heading Y1 (in the case of a horizontal table), and the cell S4 has a pointer to the column heading T2 (in the case of a vertical table) or a row. It has a pointer (in the case of a horizontal table) to the heading Y2.

FIG. 3 shows a parent heading P, a column heading Ti or a row heading Yi, and a cell Si which form the table data.
It is a figure which shows the data format of (i = 1, 2 in the example of FIG. 2). First, as shown in FIG. 3A, the parent heading P indicates a table structure such as a table type (T) indicating whether the corresponding table is a vertical table or a horizontal table, the position of the corresponding table, the number of columns, the number of rows, etc. It has information and a pointer to the first column heading T1 (for a vertical table) or row heading Y1 (for a horizontal table).

Next, the column heading Ti or the row heading Yi
Is a header (header data), a pointer to the next column heading or row heading (a null value is set if the next column heading or row heading does not exist), to the first cell of the same column or row It has a pointer, a pointer to the parent heading P, and field format data.

Next, the cell Si is a pointer to the next cell in the same column or row (nu if the next cell does not exist).
ll value is set), column heading Ti or row heading Y
It has a pointer to i, a flag (F) indicating the presence or absence of field data, and actual data set in the field of the corresponding cell Si (when F indicates that there is data).

Here, the operation of the document processing apparatus shown in FIG. 1 will be described by taking the case of creating a 2 × 2 vertical table as shown in FIG. 4 as an example. Now, with the user designating the tabulation mode, the user operates the keyboard 21 and the mouse 22 to input the table position, the number of columns, the number of rows, the cell size, etc. shown in FIG. It is assumed that the tabulation processing is performed by the tabulation mechanism 11 in the processing mechanism 10 and the table data shown in FIG.

The created table data is composed of a parent heading P, column headings T1 and T2, and cells S1 to S4 having the structure shown in FIG. In the parent heading P of the table data, in addition to the table type T indicating a vertical table, information on the position of the table, the number of columns, the number of rows, and the like, the head column (column 41 for inputting the date shown in FIG. 4) of A pointer to the index T1 is set.

In the column heading T1, a heading (heading "Date" in the column 41 shown in FIG. 4), a pointer to the next column (column 42 for inputting data shown in FIG. 4) to the heading T2, and the same column ( A pointer to the head cell S1 of the column 41) and a pointer to the parent heading P are set. Field format data has not been set yet.

In the column heading T2, a heading (heading "Data" in the column 42 for inputting the data shown in FIG. 4), a pointer to the head cell S3 of the same column (column 42), and a parent heading P The pointer is set. Further, the column / row heading pointer has a null value because the next column does not exist. The field format data has not yet been set.

The cells S1 and S3 include the next cell S in the same column.
2, pointers to S4, pointers to column headings T1 and T2, and F indicating no field data (actual data)
The field presence flag of = 0 is set. Further, pointers to the column headings T1 and T2 and a field presence flag of F = 0 are set in the cells S2 and S4. The cell pointers of the cells S2 and S4 are null values because there is no next cell.

The table data created by the table creation mechanism 11 is stored in the storage unit 12. Also,
A 2 × 2 vertical table (a table in which nothing is set in each cell in FIG. 4) represented by the same data is displayed on the display monitor 20.

In this state, the user sets the area of the table for which the field is set (column unit or entire table).
Is designated by the mouse 22 to select the field setting mode.

As a result, for example, if the column 41 shown in FIG. 4 (field setting in units of) is designated, the column 41 is designated.
If the column (shown in FIG. 4) is designated as the pointer (address) pointing to (the storage position in the storage unit 12 of) the header T1 of FIG. ) Is designated, a pointer pointing to the parent heading P is passed from the tabulation mechanism 11 to the field setting mechanism 13, and the field setting function of the field setting mechanism 13 is activated.

The field setting mechanism 13 first displays the menu window of the field format on the monitor 20.
Opens on top and prompts the user to select the field format. Thereby, the user operates the mouse 22 to select a desired field format from the menu window.

When the field setting mechanism 13 performs a field format selection operation by the user, the field setting mechanism 13 may specify, for example, setting fields for date entry in all cells of the column 41 shown in FIG. For example, the column heading T1 in the table data stored in the storage unit 12 is accessed by the pointer pointing to the column heading T1 passed from the tabulation mechanism 11, and the data of the field format selected by the user is added to the end of the column heading T1. Is added.

Next, the field setting mechanism 13 extracts the cell pointer from the accessed column header T1 to the head cell S1 of the column. Then, the field setting mechanism 13 accesses the cell S1 in the table data stored in the storage unit 12 by the fetched cell pointer and turns on the field presence flag F to bring it into the field presence display state. As a result, the field of the format selected by the user is automatically set in the cell S1.

Then, the field setting mechanism 13 extracts the cell pointer from the accessed cell S1 to the next cell S2. Then, the field setting mechanism 13 accesses the cell S2 in the table data stored in the storage unit 12 by the fetched cell pointer and turns on the field presence flag F thereof. As a result, the field having the same format as that set in the cell S1 is automatically set in the cell S2.

In the present embodiment, the cell pointer in the cell S2 has a null value. In this case, since the next cell does not exist, the field setting mechanism 13
It is determined that the same field has been set for all cells in the designated column (column 41 shown in FIG. 4). In the same manner as above, the same field can be automatically set for all the cells in the column 42 shown in FIG.

Next, when the entire table shown in FIG. 4 is designated as an area, that is, when it is required to set the same field for the entire table, the pointer pointing to the parent heading P is set to the field setting mechanism 13. You can pass it to. By doing so, the field setting mechanism 13 sets the same field format data in each of the headings T1 and T2 by sequentially tracing the parent heading P to the column heading T1 and the column heading T2, and setting the cell from each of the headings T1 and T2. By tracing the pointer, cells S1, S
It is possible to set the same field by turning on the field presence flag F of cells 2 and cells S3, S4.

If two or more columns of the m × n table are designated as areas and the same field is set for these two or more columns, all pointers pointing to the headings of these columns are set to the field. It may be passed to the setting mechanism 13.

In order to input data into the fields set in the cells of the table, the target cell Si in the data input mode is specified by the mouse 22, and the keyboard 21 is used to input desired data. Should be done. In this case, the data input from the keyboard 21 is the field presence / absence flag F of the specified cell Si.
It is set by connecting to. FIG. 4 shows the state (display state) of the table after the data is input to the above fields.

In the present embodiment, when the data input to the field of one cell is completed, the data input to the field of the next cell becomes possible automatically. This next cell is designated by the cell pointer of the preceding cell, and if the cell pointer is the null value, it is designated by the cell pointer of the column header pointed to by the column header pointer of the preceding cell.

Next, the case of changing the format of the field once set will be described. When changing the format of the set field, the user specifies the area of the table (column unit or the entire table) to be changed with the mouse 22, selects the field format change mode, and further changes the field format. Select. In this case, from the tabulation mechanism 11 to the field setting mechanism 13, as in the field setting mode,
A pointer pointing to the parent heading P, the column heading T1, or the column heading T2 is passed corresponding to the area designated as the target of the format change.

The field setting mechanism 13 uses the pointer pointing to the column heading T1 to specify the table data stored in the storage unit 12 when the change of the field format in units of the column 41 shown in FIG. 4 is designated. The column heading T1 in the inside is accessed, and the field format data in the heading T1 is rewritten with the changed format data. At this time, since the field presence / absence flag of the cells S1 and S2 of the corresponding column is turned on, the change is automatically reflected in the cells S1 and S2 of the corresponding column only by changing the field format data of the column heading T1. It

The above is the same when the change of the field format in units of the column 42 is designated, and only by changing the field format data of the column heading T2, the change is made to the cells S3 and S4 of the corresponding column. Can be reflected automatically. Further, when a field format change is designated for the entire table, all the changes are made by simply tracing the column headings T1 and T2 from the parent heading P and changing the field format data of each heading T1 and T2. Cells S1 to S4 can be automatically reflected.

In the present embodiment, when actual data is already set in each cell when the field format is changed, the data is converted according to the changed format. For example, the format of the date setting field is "Heisei Era day" before the change,
After the change, if the date is “AD,” the numerical data representing the era will be converted to the numerical data representing the AD.

The field setting / changing for the vertical table has been described above as an example, but similarly for the horizontal table, the setting / changing of the field of the same format can be performed for each row or for the entire table at once. Of course you can do it.

[0050]

As described above in detail, according to the present invention,
Column / column heading of table data and heading of each column / row
Connects in the row direction, further connects each column / row heading and each cell in the row / column direction, and when setting / changing the field in column / row units, the specified column / row in the corresponding table data Follow the cell of the column / row from the heading to set / change the field of the same format, and when setting / changing the field for the entire table, follow each column / row heading from the parent heading in the corresponding table data, and further /
Since the configuration is such that the fields of the same format can be set / changed by tracing the cells of the rows,
Alternatively, the fields of the same format can be set or changed (edited) at once for the entire table.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of a document processing apparatus according to an embodiment of the present invention.

FIG. 2 is a diagram showing an entire structure of table data stored in a storage unit 12 of FIG. 1 by taking a 2 × 2 (2 rows and 2 columns) table as an example.

FIG. 3 is a diagram showing a data format of a parent heading P, a column heading Ti (row heading Yi), and a cell Si that form table data.

FIG. 4 is a diagram showing an example of a 2 × 2 table in which a field is set for each column and data is input in each field.

[Explanation of symbols]

10 ... Document processing mechanism, 11 ... Tabulation mechanism, 12 ... Storage unit,
13 ... Field setting mechanism, 20 ... Display monitor, 21 ...
Keyboard, 22 ... Mouse, P ... Parent heading, Ti ... Column heading, Yi ... Row heading, Si ... Cell.

Claims (3)

[Claims] 1. A document processing apparatus having a table creating / editing function, comprising a parent heading indicating the structure of the table, headings of respective columns / rows of the table, and respective data of respective cells of the table. In the table data, the parent headings and the respective column / row headings are connected by the connecting information in the column / row direction, and the respective column / row headings and the cells are connected by the connecting information in the row / column direction. A storage unit for storing table data, an input unit for inputting designation / setting of setting / changing fields of the same format in column / row units of the table or for the entire table, and this input unit If the field setting / change in units of columns / rows is specified by, the column / row of the corresponding column / row from the heading of the specified column / row in the corresponding table data is specified. When the fields of the same format are set / changed by tracing the cells of a row and the field setting / change of the entire table is specified, each column / row is selected from the parent heading in the corresponding table data by the linking information. A document processing apparatus, comprising: a field setting unit that follows a headline and further follows a column / row cell to set / change a field of the same format. 2. A flag indicating whether or not a field is set in each cell is provided, and the field setting mechanism sets a field only for a column / row heading for which a field is set. 2. The document processing apparatus according to claim 1, wherein for a cell to be set, the field setting is replaced by setting the flag of the cell. 3. The field setting mechanism changes a field format only for a column / row heading targeted for field modification, and with this modification, a format modification is performed for a cell targeted for field modification. The document processing apparatus according to claim 2, wherein the document processing apparatus is treated as a completed document.