JPH0743706B2 - Table data creation method and table display method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Overview] Regarding a method of creating table data, the object is to create a table with a small memory capacity, and the same ruled line attribute that is continuous in every second direction position in the first direction position of the table is provided. It has a ruled line information area for storing ruled line information consisting of position coordinates of start and end points and ruled line attributes for an array of vertical or horizontal ruled lines and a control information area for managing the number of ruled line information in the ruled line information area for each first direction. A two-way management table means, a first direction management table means having a pointer for pointing the position of each control information area on the second direction management table means, and a first direction of a ruled line represented by the inputted ruled line data. The position in the second direction is determined, the corresponding pointer is read from the first direction management table means according to the first direction position of the ruled line data, and the control information of the second direction management table means is read. The information area and the ruled line information area are accessed, and the ruled line information and the control information created based on the position of the ruled line data in the second direction are written.

[Industrial application field]

The present invention relates to a method of creating table data by ruled lines and a method of displaying the created table on a display device.

[Prior art]

In the conventional table creating apparatus, all ruled line data is stored in the memory in units of one character area on the screen.

A conventional ruled line data management method in tabulation processing will be described with reference to FIG.

In the figure, (a) shows a table creation sheet for creating a table in which one section (cell) corresponds to one character area on the display screen.

In the figure, (b) shows a ruled line data memory storing ruled line data of each cell.

The cells of a table sheet for creating a table are usually 256 rows wide and 819 length.
It consists of two lines. Then, for each ruled line data of one cell,
The ruled line information of the cell is stored in the memory.

For example, as shown in the figure, when cell numbers are expressed as a matrix of column numbers and row numbers, a table with a maximum of 256 columns in the horizontal direction is created. Each ruled line data is stored as shown in FIG. 7B corresponding to each cell of -1, 1-2, ..., 1-256.
Similarly, the ruled line data from the second row to the last row of the table is stored in the memory for each cell. When creating a table with a maximum of 8192 rows x 256 columns, 1-1 in the first row, the first row
It was necessary to store the ruled line data for all the cells from the cell to the 8192th to 256th cells in the 256th column in the 8192th row in the memory.

[Problems to be Solved by the Invention]

Since the length of the ruled line data of one cell is usually composed of 2 bytes, a memory area of 2 × 256 × 8192 = 4194304 bytes (about 4MB) is required to create a table with a maximum of 256 columns × 8192 rows. I was trying. Since a table area for managing other data is also required, a memory area larger than that is actually required in the past.

[Means for Solving the Problems]

In the present invention, one of the columns and rows of the table is in the first direction
When the direction is set, for a continuous array of vertical or horizontal ruled lines that have the same ruled line attribute such as the same ruled line type that is continuous for each line position in the second direction in the first direction of the table, the position coordinates of only the start point and end point are used. The number of ruled line data stored in the memory is actually provided by providing the row management table means for compressing and storing the ruled line data and the first direction management table means having the pointer for designating the ruled line information on the second direction management table means. The number of ruled lines displayed on the screen is reduced.

The present invention provides a table creating method and a table displaying method capable of creating a large table within a limited memory capacity by improving the method of storing ruled line data in the memory in the table creating process as described above. Aim to achieve.

The present invention will be described with reference to the basic configuration of the present invention shown in FIG.

Hereinafter, a case where the first direction is a column and the second direction is a row will be described.

In the figure, 1 is a table sheet in which cells (cells) each have 256 columns and 8192 rows, and one cell corresponds to one character area on the screen. 2 is a ruled line with the same ruled line type and color at the table column position. For an array of continuous vertical or horizontal ruled lines with attributes, manages the ruled line information area by storing the ruled line information area that stores the ruled line information consisting of the position coordinates of the start and end points and the number of consecutive ruled lines in one column. A row management table having a control information area for each column, 3 is a column management table having a pointer for indicating the position of the control information area of each column on the row management table, 4
Is an input means for inputting ruled line data, 5 determines the position of the input ruled line and row, reads the corresponding pointer from the column management table according to the column position of the ruled line data,
Access the control information area and the ruled line information area of the row management table and write the ruled line information and control information based on the row position of the ruled line data, or refer to the ruled line information number data of the control information area on the row management table, Table control means for reading attributes such as ruled line type, start coordinate and end coordinate data of continuous vertical ruled line or horizontal ruled line from the ruled line information in the ruled line information area and displaying the prepared table on the display means, 6 is a table made up of ruled lines Is a display means for displaying, and 10 is a cell in the front sheet corresponding to one character area on the display screen,
11 is a pointer that points to the control information area in the row management table of the column management table; 12 is a data type indicating that the control information format in the row management table is ruled line data or table format data; The number of the management column name in, the management column indicating each name such as A, B, and the number of ruled line information of the managed column when the data type is ruled line data, 13 is the ruled line in the row management table Start line number and end line number of continuous vertical ruled line and horizontal ruled line that have ruled line attributes such as line type, color, etc. determined by vertical ruled line and horizontal ruled line in the information format, and ruled line data with the same attribute continuously at the column position 14 is for determining the position of the input ruled line and row, and reads the corresponding pointer from the column management table according to the position of the ruled line data. Access the control information area and the ruled line information area of the row management table and write the ruled line information and control information based on the row position of the ruled line data, or refer to the ruled line information number data of the control information area on the row management table, A table that reads attributes such as ruled line type, start coordinate and end coordinate data of continuous vertical ruled lines or horizontal ruled lines from the ruled line information in the ruled line information area, and displays the created table on the display means The control unit 15 is a display control unit for displaying the ruled line data on the display means 6 by the output of the table control unit.

[Action]

 The operation of the basic configuration of FIG. 1 will be described below.

First, the case of writing ruled line data in the row management table will be described.

With respect to the ruled line data input from the input means 4, the table control unit 14 reads the column coordinates and the row coordinates on the screen, and reads the pointer on the column management table according to the column coordinates. Next, in accordance with the instruction of the pointer, the table control unit 14 accesses the control information area and the ruled line information area on the row management table and sets the ruled line data input on the row management table to the vertical ruled line or the horizontal ruled line at the column position. The attribute data such as the ruled line type is written in the ruled line information area for each of the start and end coordinates, the vertical ruled line, and the horizontal ruled line.

Next, the number of ruled line information is written in the control information area in accordance with the illustrated control information format 12.

For example, in the figure, in the first column, N rows, N−1 rows, N
Since the same line type of the vertical ruled line continues to the +1 line in the vertical direction at the position of the first column, the data is compressed in the ruled line information area of the first column of the illustrated row management table 2 by the ruled line data of the start line and the end line. To store.

Similarly, regarding the M column, since the data of the same line type continues in the vertical direction for the horizontal ruled lines up to the 1st row and the (N + 1) th row, the start line 1 is indicated in the ruled line information area shown in the line management table 2 as shown in the figure. The compressed data consisting of only the end row N + 1 is stored.

Next, the operation of reading the ruled line data on the row management table and displaying the created table on the display means 6 will be described.

The table control unit 14 refers to the column management table 3, reads out the pointer of the column for which the ruled line is to be displayed, and accesses the control information area on the row management table according to the instruction.
Therefore, the number of ruled line data in the column is read, and the number of read ruled line data stored in the subsequent memory area on the row management table is read. Then, based on the ruled line information, the attribute such as the ruled line type of the column to be displayed, the start coordinate and the end coordinate data of continuous vertical ruled lines or horizontal ruled lines are read, and the creation table is displayed on the display means.

Next, the table control unit 14 sends the read data to the display control unit 15, and the display control unit 15 causes the display means 6 to display a ruled line.

In the present invention, when one vertical ruled line having the same ruled line attribute or a horizontal ruled line sequence position having the same ruled line attribute is arranged in the most effective column, one example of the conventional memory management method and the present invention is described. Comparing the memory capacities required to create a table with the case, the results are as follows.

Conventional method, column management table 4 × 256 = 1024 (bytes) Ruled line information 2 × 256 × 8192 = 4194304 (bytes) Total 4195328 (bytes) In the case of the present invention Column management table 4 × 256 = 1024 (bytes) Row management table 6 × 256 = 1536 (bytes) Ruled line information 6 × 256 = 1536 (bytes) Total 4096 (bytes) In tabulation processing, the same ruled line is often present continuously in one column. According to this, the tabulation processing can be performed with a small memory capacity.

〔Example〕

 An embodiment of the present invention will be described with reference to FIGS.

FIG. 2A shows an embodiment of the column management table of the present invention.

The column management table has a pointer for each column on the control information area of the row management table.

Each pointer is composed of 4 bytes. The table has 256 rows, so the column management table consists of 1024 bytes.

FIG. 2B shows an embodiment of the format of the control information on the control information area of the column management table.

The control information consists of 6 bytes.

If the data type indicating table format information or ruled line data, etc., the number of the managed column, and the management column name indicating the name are configured in 2 bytes, and the data type is ruled line data, the number of ruled line information is set. It consists of 4 bytes.

The data type is composed of 4 bits, and the type of data such as "table data", "format information", "process definition", and "ruled line data" is set by 4 bits.

The management column is composed of 12 bits and indicates the number of the column managed by the data and the name such as A.

FIG. 3 shows an embodiment of the format of ruled line information in the row management table.

Ruled line information consists of 6 bytes.

The upper 2 bytes set the ruled line attribute data of the vertical ruled line, and the next 2 bytes set the ruled line attribute data of the horizontal ruled line. The starting line of the ruled line arranged in the column position consecutively in the following 2 bytes,
Set the end row data in the next 2 bytes.

In the vertical ruled line attribute data area, the presence / absence of vertical ruled lines is set to 0.
The vertical ruled line setting state is set by 1 bit of 1 and 1, and the vertical ruled line type such as thin line, dotted line, medium line, and thick line is set by another 5 bits.

Similarly, in the horizontal ruled line attribute area, the horizontal ruled line setting state is set to 1 bit and the horizontal ruled line type is set to 5 bits.

FIG. 4 shows a flow of processing for writing ruled line data in the row table.

In the figure, "1 new creation process" is a process for writing a new ruled line in a column where no ruled line exists. Data is set in the control information area and the ruled line information area of the row management table, and the beginning of the area is set. This is a process of setting an address in the pointer area of the column management table.

Further, the "2 ruled line information adding process" in the figure is a process when ruled line data has already been set at the column position and a new independent ruled line is added. Set the ruled line data to be added to the ruled line information area of the line management table,
Update the number of ruled line information in the existing control information area.

Further, the “3 ruled line information updating process” is a process in which the ruled lines are connected to the already existing ruled lines at the column position and written. Update the data of the start line and end line of the existing ruled line information.

The flow will be described according to the numbers.

Whether or not there is data in the column for which the ruled line is to be set is determined. If there is no data, it is a new creation, so "1 New creation processing" is performed.

If there is data in the column for which you want to set ruled lines,
Determine whether there is ruled line information that includes the line you are trying to set. If there is, it is judged whether they are the same ruled line (), and if it is the same ruled line attribute, there is no need to change the data, so the ruled line setting process is completed. If it is not the same ruled line, a new ruled line is added, so "2 ruled line information addition processing" is performed.

If there is no ruled line information including the line set in step 1, it is determined whether there is ruled line information including one line higher or one line lower than the set line. If not, you will add an independent rule line that is not continuous with other rule lines in that column.
Perform "2 ruled line information addition processing".

If there is ruled line information that includes a line that is one line higher or one line lower than the line to be set, it means that a ruled line that is continuous with the upper or lower ruled line is being set.
The start line or the end line is updated by "3 ruled line information update processing".

In the above description, the case where the first direction is the column and the second direction is the row is described, but the first direction may be the row and the second direction may be the column.

〔The invention's effect〕

According to the present invention, when the same ruled line is continuously arranged at the column position of the table, the table creation processing is performed by compressing the data according to the start line and the end line of the ruled line and storing it in the memory. Therefore, a large table can be created with a small memory capacity. Therefore, in the table creation process, the degree of freedom in using the memory such as the writing of characters in the table and the calculation process of numerical values written in the table is increased, and the table can be efficiently used.

[Brief description of drawings]

FIG. 1 is a basic configuration diagram of the present invention. FIG. 2 (a) is an embodiment of the column management table. FIG. 2 (b) is an example of the format of the control information in the column management table. FIG. 3 shows an example of the format of ruled line information. FIG. 4 is a flow chart of an embodiment of ruled line data setting processing. FIG. 5 is an explanatory diagram of a conventional ruled line data management method. In the figure, 1: table sheet, 2: row management table, 3: column management table, 4:
Input means, 5: table control means, 6: display means, 10: cell, 11: pointer area, 12: control information format, 13:
Ruled line information format, 14: table control unit, 15: display control unit.

Claims (2)

[Claims] 1. A display means for displaying a table composed of ruled lines, and one of a column and a row of the table is a first direction and the other is a second direction, and the table is continuous at every second direction position in the first direction position of the table. A control information area that manages the number of ruled line information in the ruled line information area and the ruled line information area that stores the ruled line information consisting of the position coordinates of the start and end points and the ruled line attribute for the array of vertical or horizontal ruled lines that have the same ruled line attribute An input means for inputting ruled line data, which comprises a second direction management table means for each direction and a first direction management table means for holding a pointer indicating the position of each control information area on the second direction management table means. And determining the position of the ruled line represented by the input ruled line data in the first direction and the second direction, and reading the corresponding pointer from the first direction management table means according to the first direction position of the ruled line data. Then, by accessing the control information area and the ruled line information area of the second direction management table means and writing the ruled line information and the control information created based on the second direction position of the ruled line data, the first direction management table means And a method of creating table data on the second direction management table means. 2. The table data configured on the first direction management table means and the second direction management table means according to claim 1 is used as an input, and the pointer is read from the first direction management table means to indicate the pointer. Number of ruled line information in the first direction stored in the second direction control information area of the second direction management table,
Directional ruled line information is sequentially read, and vertical ruled lines are continuously arranged according to the ruled line attribute data for each ruled line information, vertical ruled line, horizontal ruled line, ruled line attribute, and start point and end point position coordinate data. Alternatively, the table display method is characterized in that the start line and the end line of the horizontal ruled line are recognized, and the table composed of the ruled line is displayed on the display control means.