JPS60178581A - Ruled line editing system - Google Patents

Abstract

PURPOSE:To minimize the redefinition of rules lines by referring ruled line information on an upper and a lower line to reedit new ruled line information. CONSTITUTION:A keyboard 1 is provided with character number keys for specifying an insertion and a deletion position, insertion specifying key, and deletion specifying key. A storage device 6 is stored with a processing program, and a storage device 7 is stored with table data and ruled line information. A CPU8 is used for total control, and various registers 10-(n) are provided therein. The CPU8 refers to ruled line information on the upper and lower lines of an insertion or deletion line to reedit new ruled line information.

Description

[Detailed Description of the Invention] [Field of Application of the Invention] The present invention provides a method for creating a table or the like on a display screen, etc.
If the table has borders, when inserting a new row or column in the row or column direction, or deleting an existing row or column, the borders will be restored to the natural form as an image of the table. This invention relates to a ruled line editing method that allows editing.

[Summary of the invention]

Conventionally, the following methods have been used to edit ruled lines by inserting or deleting rows or columns, depending on how the ruled line information is held.

(1) When having ruled line information on a cell-by-cell basis or as data itself ■Insert: Insert a completely new row or column with no ruled lines or data.

■Delete: Deletes the specified row or column, regardless of whether it has borders or not.

(2) When having ruled line information as a separate table ■Insert...
When the name of a cell symbol is changed by inserting a row or column, the information of another table is also updated with the changed name.

■Delete...Same as above.Here, the method of having ruled line information for each cell is to display ruled lines on all sides of that cell, or on the edges of two directions such as the top and left side, when displaying the data of that cell. This is a method to have information on whether or not. Also, the method of having the ruled line information as the data itself is a method of using one row and one column (column length is 1 digit) on the table to display the ruled line, instead of the normal data. Use graphic characters.

Also, finally, how to have ruled line information in a separate table.
For example, there is a method of holding information such as that there is a horizontal ruled line from the upper left corner of cell AI (the cell in the first row of column A, the same applies hereinafter) to the upper left corner of cell D1 as a separate table.

However, neither method sets information that matches the surrounding ruled lines in the newly inserted row or column, and it is necessary to define the ruled lines again in the inserted portion. Furthermore, in the case of deletion, although it is possible to delete the inside of the table, if the beginning or end of the ruled line creation area is deleted, a table with the outer frame of the table missing may be created.

[Purpose of the invention]

An object of the present invention is to provide a ruled line editing method that makes it possible to minimize the redefinition of ruled lines by inserting or deleting rows or columns.

[Summary of the invention]

In order to achieve such an objective, the present invention, for example, refers to the border information of the lines above and below the inserted line in the case of inserting a line, and the lines above and below the deleted line in the case of deleting a line, and generates a new line. By re-editing the border information, if inserting within the outer frame of a table, you can create a border that looks like an expanded table, or if you delete a row or column that has a table outer frame. The feature is that automatic editing is performed, such as moving the outer frame to another row or column.

[Embodiments of the invention]

Hereinafter, the present invention will be explained in detail with reference to Examples.

FIG. 1 shows an overview of a display device of the present invention. As shown in the figure, the display device consists of a keyboard 1 and a CR7 display section 2, and the keyboard 1 includes alphanumeric keys 3, 3, 4, and 3 for specifying insertion and deletion positions. Insertion specification key 4. Delete command key 5
is provided.

For keys 4.5, there is no need to have a special key,
The above functions may be provided to the alphanumeric keys.

FIG. 2 illustrates a block diagram of a device that implements the ruled line editing method according to the present invention. The keyboard 1 and CR7 display section 2 are the same as those shown in Figure 1. The storage device 6 stores processing programs, and the storage device 7 stores table data and ruled line information. The CPU 8 is used to control the entire system, and includes various registers 10 to 10.
n is provided.

FIG. 3 shows an example of a device for displaying ruled lines on a cell. In this embodiment, as shown in the figure, vertical ruled lines 20 and 21 are displayed above the cell, and horizontal ruled lines 22 and 23 are displayed on the left side of the cell. Therefore, to surround one cell with ruled lines, three cells (24, 2
5, 26), the ruled line information is set to 1-.

FIG. 4 shows an example of setting the ruled line information of the cell 24 shown in FIG.
1- indicates the presence or absence of a vertical ruled line with 0 and 1, and similarly, the presence or absence of a horizontal ruled line on the 21st bit is indicated with 0 and 1. As actual ruled line information, information such as the presence or absence of each ruled line, the thickness of the line, and the type of line such as a solid line or a dotted line is also required, but this is not necessary in the description of the embodiment, and will therefore be omitted. Therefore, the border information for a certain cell is
It is indicated by the value of the storage area 30, and as shown in the figure, when it is 3'', it indicates that both vertical and horizontal ruled lines are defined.

FIG. 5 shows 5 of the table exemplified on the display section 2 of FIG.
This figure shows the state before a new line is added between the 6th line and the 6th line and the ruled line editing process is performed. If you do not edit the ruled lines, the inserted line 31 surrounded by dotted lines will have no ruled lines, and in order to format the table, you must redefine the ruled lines in this inserted line 31. must be done.

FIG. 6 shows a desirable form of ruled line for the insertion line 31 in FIG. 5, considering the relationship between the upper and lower lines. That is, cell A6. B6. Add vertical ruled line to D6°H6, cell E6. F6. This is G6 with vertical and horizontal ruled lines set. In order to automatically edit the ruled line information as shown in FIG. 6 from the upper and lower ruled line information, the following relational expression is used in the present invention.

(For row insertion) [, IJ = (I, 1'' + 10R] ) AND
L + J-8... (Formula 1) (For column insertion) L+ J = (L, + ++t OR, 2) ΔNr)
L, □.

・(Equation 2) Here, 1″′ represents the column arrangement illustrated in Figure 5 etc. as a number, and indicates column A when i=], column B when i=2, etc. In addition, 11 j H indicates the row number. Also, ■, 1. indicates the ruled line information of cell ij. If the row 1 column number is outside the table range, l12. is regarded as 0.

FIG. 7 shows an example of inappropriate ruled line editing when only Equations 1 and 2 are used. As shown on the left side of the figure,
When inserted between two tables 32 and 33 surrounded by an outer frame, that is, between row j-1 and row j, as shown on the right side of the figure,
A new horizontal ruled line 35 is generated between the two tables 34° and 36.

FIG. 8 is an example similar to FIG. 7, except that a row is inserted between the j-] row and the j row of the table 37 with only horizontal ruled lines shown on the left.

When comparing Fig. 7 and Fig. 8, the horizontal ruled line 35 in Fig. 7 is outside the range surrounded by the table outer frame, so it is considered unnecessary, and the horizontal ruled line 39 in Fig. 8・I think this is necessary because horizontal ruled lines are inserted during pull. In the present invention, the following method is used as a correction method for erasing the above-mentioned unnecessary ruled lines.

Figure 9 shows the decision factors for deleting unnecessary horizontal ruled lines when inserting a line. As shown on the left side of the figure, the point (A) that intersects with the vertical ruled line is The point (B) where the horizontal ruled line breaks without intersecting the vertical ruled line, as shown on the right side of the figure, will be referred to as the open end of the horizontal ruled line (hereinafter simply referred to as the open end).

FIG. 10 shows a diagram of the principle of this correction method.

First, to explain insertion line j, by using equations 1 and 2, horizontal ruled line CF and vertical ruled line DH, E-1 shown by dotted lines in the figure are edited. In this correction method, in the case of line insertion, only the horizontal ruled lines are corrected, so that only the horizontal ruled lines C-F are subject to correction. If this horizontal ruled line is divided according to the factors of open end and closed end shown in Fig. 9, three horizontal ruled lines C-11
.

Divided into D-E and E-F. Of these, those with both ends closed are not subject to correction, so they are edited as is.

For those that include an open end on at least one side, the following checks are further performed. That is, it is based on the idea that when a column is inserted between horizontal ruled lines with open ends, horizontal ruled lines with open ends are created. Therefore, the state of the upper and lower columns is checked for the open ends C and F of the horizontal ruled lines CD and EF with open ends shown in FIG. In the case of open end C, the upper side is the closed end (
A), but since the lower side is an open end (G), this is also not subject to correction. Next, regarding the open end F, since both the upper and lower ends are closed ends (B, J), the horizontal ruled line E-F is not created as a correction target.

The above correction method is shown in flowcharts in Figs.
As shown in Figure 15.

Figure 11 searches for the 0 point in Figure 10 and converts the result to FL.
This figure shows the means for setting the GI. Similarly, the first
In Figures 2 to 14, point [], point E, and point F are searched, and the results are applied to FLG2. FT, , G3°F LG 4 is shown.

FIG. 15 shows the starting point (Sl, S2) and end point (El.

E2) is shown. Here NS, N
E indicates the first column number and last row number to be checked.

Next, correction for row or column deletion will be explained using the case of row deletion as an example. The basic method for deletion is to move the horizontal ruled line to the next row to be deleted using the following formula when there is a horizontal ruled line in the column to be deleted.

L+ J +1=Ll J +l OR2...(
Formula 3) However, if the column to be deleted is the last row of the table, it is moved not to the next row but to the previous row as shown in the following formula.

I-1+j-+'=I, 1. (Formula 4) FIG. 16 shows flowchart 1 of the correction method in the case of deletion. Here, NS and NE are as described above, and ME indicates the last row number of the table.

〔Effect of the invention〕

According to the present invention described above, when creating and editing a table of any form or a figure similar to this, the desired figure can be created with minimal attention from the operator, and it is possible to create the desired figure from the created figure. The unnaturalness is automatically removed and a figure with excellent legibility can be obtained.

[BRIEF DESCRIPTION OF THE DRAWINGS] FIG. 1 is an overview diagram of a display device according to the present invention, and FIG.
FIG. 3 is a block diagram of an apparatus for realizing the present invention, and FIG. 4 is a diagram showing an example of displaying ruled lines on cells according to the present invention.
FIG. 3 shows an example of setting the ruled lines to be stored in the memory L. FIGS. - Figure 16 shows details of the program processing of the CPU when implementing the present invention. iH cabinet engineer 2] 2 JI ■ 1, r = "put 2" 222] 7th
Figure 9 Figure l \ Scream. A'I Y'Ile Eye'f111 Country'f112 Figure yf113 Continuation of figure 1 page 0 Inventor Tsuyoshi Hamaguchi Inside Ozenjimu Development Research Institute, Asao Ward, Kawasaki City

Claims (1)

[Claims] 1. In a table created by adding a border to any end of any cell of the output table, a new row in the row direction or column direction,
Alternatively, in the method of inserting or deleting columns, when inserting the first line of either a row or a column, refer to the ruled line information of each of the adjacent lines aligned with the inserted first line and The step of automatically creating ruled line information with the shape closest to the ruled line information, and the step of automatically creating ruled line information of the newly created inserted line, in which both ends of the continuous ruled line part are not connected to any adjacent ruled line. In this case, the step of checking the adjacent ruled line part and, if both ends of the adjacent ruled line part are connected to another ruled line in the same direction by a ruled line in a direction that intersects this, the step of checking the inserted line part. the first of the corresponding cells
A ruled line editing method characterized by having a step of deleting only ruled lines parallel to the lines of. 2. The ruled line editing method according to item 1, wherein the first line is a horizontal ruled line, and the ruled line in the intersecting direction is a vertical ruled line.