JP2002358297A - Generation program for listing, specifying method for listing and layout apparatus for editing - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method for specifying listing with easy operations and a generation means for listing to generate document data automatically listed according to character data and listing specifications. SOLUTION: A load on an operator in the listing specifications is reduced by specifying a complex listing while checking on a screen interactively by using spreadsheet software. Document data formed as a list is generated automatically by inputting three kinds of data files such as first text data of arranged cell character strings, document data of formed text parts with a final appearance by using editing layout software and text data composed of flag characters meaning combination specifications or background color specifications of cells.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a table composition creating program used to create a table composition in a so-called DTP edit layout operation of a printed material, a table composition designating method, and an editing layout apparatus equipped with these.

[0002]

2. Description of the Related Art Conventionally, when creating a table using DTP layout software, it was necessary to manually create the table.

[0003]

When manually compiling a table, it is necessary to combine cells constituting the table and to specify a background color of the cell. Worker load was high. SUMMARY OF THE INVENTION The present invention has been made in view of such a problem, and a method of designating a table by a simple operation, a table for automatically generating table data according to character data and a table designation, and a table. It is an object to provide a means for creating a set. The document data is a native format data file of the editing layout software to be used, and includes a character box object representing a character, various graphic objects representing various graphics, and the like.

[0004]

According to a first aspect of the present invention, there is provided a first invention in which a delimiter is inserted between cell character strings which are character strings to be displayed in one cell in a table.
Using text data and character editing layout software, place some dummy characters with finished formatting in cells and draw the necessary ruled lines to correspond to part or all of the typeset table created. And a value set pattern which is document data to be input. The table set creation program automatically creates document data formatted as a table by inputting two types of data files. The first text data is usually created as a group of a plurality of groups each consisting of a predetermined number of cell character strings, for example, by using two types of delimiters distinguishably. At this time, the number of cell character strings forming one group is called the number of columns, and the number of groups is called the number of rows. The table composition program draws a ruled line of a table according to the value combination pattern and the number of columns of the first text data, and converts a cell character string of the first text data according to a format setting specified in a dummy character box object. Typeset. Format settings are attributes of characters such as typeface, font size, character color, style, character decoration, and the like.

[0005] A more desirable second aspect of the table creation program is that the first text data and a cell character string in the first text data are replaced with a flag character designating connection between cells. 2 text data,
Document data that corresponds to part or the entirety of a typeset table created by placing some dummy characters in the cell using the text editing layout software and finishing the required formatting and drawing the necessary ruled lines Value pair pattern,
Is a table composition creation program for automatically creating document data formatted as a table with the cell combination specified for the second text data by inputting the three types of data files.

[0006] The worker given the first text data performs only two simple tasks of preparing text data for designating cell combination and editing layout work for preparing a value set pattern. Work load is reduced. It should be noted that the first text data and the second text data are expressed as text data synthesized in a fixed parallel manner so as not to confuse the relationship between a cell character string and a flag designating the connection of the corresponding cell. The program may be input to a set creation program.

[0007] A third mode of the table creation program is that the first text data created by inserting a delimiter between cell strings which are strings to be displayed in one cell of the table, 3 types of data files: the second text data in which the cell character string in the text data of (1) is replaced with a flag character designating the background color of the cell, and the value set pattern created using the editing layout software. Then, the program is a table composition creating program for creating document data formatted as a table in which the cells designated by color are designated in the second text data.

The worker given the first text data performs only two simple tasks of preparing text data for designating the background color of a cell and editing layout work for preparing a value set pattern. Work load can be reduced because it is sufficient. It should be noted that the first text data and the second text data are converted into text data synthesized in a fixed parallel manner so that the relationship between a cell character string and a flag designating a background color of a corresponding cell is not confused. It may be input to a table creation program.

A fourth mode of the table creation program is that the first text data created by inserting a delimiter between cell strings which are strings to be displayed in one cell of the table, The second text data in which the cell character string in the text data is replaced with a flag character that specifies the connection between cells, and the cell character string in the first text data are converted into a flag character that specifies the color of the cell. The four types of data files of the replaced third text data and the value set pattern created using the editing layout software are input, and the cell combination indicated by the second text data and the third text data are input. Is a table composition creating program for creating typeset document data as a color-coded table instructed.

The worker given the first text data prepares the text data for designating the table,
Since only two simple tasks of editing layout work for preparing a value set pattern need to be performed, the work load is reduced. The first, second, and third text data are converted into text data synthesized in a fixed parallel manner so that the relationship between the cell character string and the corresponding two types of flags is not confused. It may be input.

A fifth aspect of the table composition creating program is that, in the table composition creating program according to the second aspect or the fourth aspect, a row joining priority designation or a column joining priority designation is specified in advance. This is a table composition creating program that can create document data formatted as a table to which cell combining with priority or column combination has been performed.

According to a second aspect of the present invention, there is provided an editing layout apparatus having the table creation program according to the first aspect.

According to a third aspect of the present invention, there is provided a spreadsheet creating program according to the first aspect, wherein the first text data to be input to the spreadsheet creating program is read into spreadsheet software and a cell on a sheet of the spreadsheet software is read. To display the cell string,
Using the interactive cell coloring provided in the spreadsheet software and the character input function to the cell, specify the color for the cell displaying the cell character string, and use the color and its color Is set on the same sheet to specify the flag for cell combination or color coding of the cells, and furthermore, the macro definition function provided in the spreadsheet software is used to set the flag on the sheet. Defines macros that automatically process cell data, and uses this to make use of text data consisting of flag characters that indicate cell combination designation and text data consisting of flag characters that designate cell background color designation Alternatively, it is a table designating method of creating text data by combining them.

By using commercially available spreadsheet software, cell combination and cell background color flag designation can be performed interactively on the screen, thereby facilitating the task of designating a table. In addition, using the macro definition function provided in the spreadsheet software, a series of simple procedures for handling the data set in the cells on the sheet are defined and used as macros to automatically specify the table format. It is possible to make the output.

According to a second aspect of the second invention for solving the problems, a table creation program according to the first invention,
An editing layout apparatus comprising: a spreadsheet software having a macro function for realizing the table composition specifying method according to the third invention.

[0016]

FIG. 1 is a block diagram showing the configuration of an editing layout apparatus 1 according to an embodiment of the present invention. Reference numeral 10 denotes a computer main body to which a graphic display 11, a keyboard and a mouse 12, and a hard disk 20 are connected. In the computer body 10,
Editing layout software 100, table creation means 1
10 and a table designating means 120 are provided. The table layout creating means 110 is installed in a form incorporated in the editing layout software 100, and operates by being called from a menu of the editing layout software 100. Reference numeral 200 denotes an original data (tab-separated text) file.

FIG. 2 is a flow chart for explaining the flow of a tabulation operation using the editing layout apparatus 1 of the present invention. The flow of the tabulation work will be described below with reference to FIG. First, the original data 200 is obtained or created (S
01). The original data is text data in which a cell character string displayed for each cell of a table to be created is tab-delimited text data on a line-by-line basis (a line feed character is inserted for each unit of data in one line). Next, the operator creates one document file by performing typesetting editing of a part of the table using dummy characters and ruled lines using editing layout software (S02). FIG. 11 is a diagram showing an image of a part of the table that has undergone such typesetting and editing. In FIG. 11, the cell characters "A", "B",... Are dummy characters. One line composed of three cells in which characters "A", "B", and "C" are arranged is composed of a title line and three cells in which characters "D", "E", and "F" are arranged. One row to be executed is called a data row. In a later step, this document file is a value set pattern 201 that specifies the basic layout of cell strings appearing in the table.
Use as That is, the format setting set for the dummy characters on this pattern is applied to the cell characters in the table. The layout shape of the value set pattern 201 (the height of one row of each of the title row and the data row, the width of each column, and the like) is used as a reference for the size of a cell of a table created later.

If there is no cell combination or cell color designation in the table to be created, the operator creates the table using the table combination creating means 110 (S03). This is output (S04) and the operation ends. If the table to be created includes a cell color specification and / or a cell combination specification, steps S13 to S17 are performed. First, the original data 200 is assigned to the table designating means 1
The cell character string included in the original data 200 is displayed in the cells on the plurality of sheets displayed by the table designating means 120 (S13). The cell character string included in the original data 200 is stored in the table
0 is read and displayed on an original data sheet for displaying the original data provided by 0, a color designation sheet for color designation, and a combination designation sheet for joint designation.

FIG. 3 shows that the cell character string is stored in the table designating means 12.
It shows the place displayed at 0. Next, when it is necessary to specify a color, a color is specified for each cell on the color specification sheet in cell units, and this color is specified as a color specification flag (S14). FIG. 4 shows a color designation sheet of the table designating means 120 after the color designation is completed. If it is necessary to specify the combination, a specific color is given to the cells to be combined on the combination designation sheet, and this color is designated as a flag for the combination designation (S15). FIG. 5 shows a connection specification sheet of the table specification unit 120 after the connection specification has been completed.

Next, the table designating means 120 activates a table designating creation macro in which a processing procedure is set in advance, and records the color designating flag and / or the combination designating flag as a text file. Output (S16). The table specification creation macro reads the data or attribute value (cell character or cell color or flag character) set for each cell from the original data sheet, color specification sheet, and combination specification sheet, and sets the cell color to the corresponding flag character. Then, the original sheet is copied to a cell of another sheet while maintaining the arrangement order, thereby forming a writing sheet shown in FIG. The contents output as a tab-separated text file are the table specification 202.

Next, the table creation means 110 is activated,
As preparation, setting of color designation and combination designation are performed (S17). The setting of the color designation means the table creation means 110
Name of the color specification flag used for
This is to specify the yk halftone dot area ratio. The setting of the join designation is to designate the name of the join designation flag used for the table creation unit 110.

When all preparations have been completed, the table creation unit 110 is activated, and a table combination is created based on the table combination designation 202, the color designation setting, the combination designation setting, and the value combination pattern 201. The created table is document data of the editing layout software 100 (S03). This is output to an output device such as an imagesetter to obtain a table original (S04).

FIG. 7 shows the form of a table created from the table specification 202 obtained from the writing sheet shown in FIG. Actually, each cell character string appearing in FIG. 7 is tabulated according to the value set pattern 201 created in step S02.

In the foregoing, the flow of the work for creating a table using the editing layout apparatus 1 has been described. Table designating means 120
Provides one or more table-shaped sheets, allows you to manually input characters and specify colors in each cell on each sheet, and reads a tab-delimited text file to convert a character string delimited by tabs. The program can be set as data in a plurality of cells of the sheet, or can output a table-shaped cell character on the sheet as a tab-separated text file along the rows and columns of the table. Accordingly, commercially available spreadsheet software may be used as the table designating means 120. In this case, using the macro definition function provided in the spreadsheet software, a series of simple procedures for handling the data set in the cells on the sheet is defined as a macro, and the table specification designation creation macro is created. Can be easily prepared.

FIG. 8 is a flow chart for explaining the operation of the table creating means 110 of the present invention. Hereinafter, the operation of the table creation unit 110 will be described in detail with reference to FIGS. The most important thing in creating a table is how to handle cell merging. Here, as an example, processing is performed using a connection array describing the connection state of cells. The combined array (i, j, k) is a three-dimensional array, and i and j indicate the positions (rows and columns) of the cells of the sheet (the cells before being combined). k has a depth of 3, (i, j, $ FLAG) indicates whether the cell is the first cell (upper left corner), and (i, j, $ END column) indicates that the cell is the first cell. The rightmost column of the merged cell starting with the cell, (i, j, $ END row) indicates the lowermost row of the merged cell starting with the cell when the cell is at the top. In the initial stage, all the cells (i, j) are (i, j) at the beginning.
(j, $ END column) = j, (i, j, $ END row) = i. When the cells are merged and are no longer at the beginning, an invalid flag is set at (i, j, $ FLAG).

In step S40, the above-described connection array is initialized. That is, all cells are first at the beginning. If there is no connection designation, the process jumps to step S52. If there is a join designation, the join flag is read from the table specification 202 into a two-dimensional array Flag (i, j) (S4).
4). Flag (i, j) is the cell (i, j) before being combined
Holds the value of the merge flag specified for that cell in response to Next, in the case of row priority designation, the associative array creation processing by row priority designation (S48) is executed, and in the case of the column priority designation, the associative array creation processing by column priority designation (S50) is executed.

The meaning of the row connection priority and the column connection priority is as shown in FIG. L-shape and T-shape joins are not performed in ordinary tables handled in commercial prints. To avoid this, it is necessary to specify either row join priority or column join priority in advance. There is. The details of the associative array creation processing (S48) with the row combination priority will be described with reference to the flowchart in FIG.

When the combined array is completed, the individual cell character string data existing in the original data 200 is subjected to the format setting set in the dummy character corresponding to the value set pattern 201, and Arrange them in the desired position and draw the necessary ruled lines to format the table. First, the title lines are typeset, and data lines are repeatedly created according to the number of lines of the original data. At this time, the value set pattern 201
, The actual cell size of the table is determined based on the height of one row, the width of each column, and the ruled line. If no binding is specified, the tables are arranged according to the binding sequence in the initial state. If there is a combination designation, the cell character string data is arranged at the position of the combination cell derived from the value set pattern 201 in accordance with the combination arrangement, and a necessary ruled line corresponding to the combination cell is drawn (S5).
2). In this step and the subsequent step S56, the document data generated by the editing layout software 100, that is, the character / graphic object data handled by the editing layout software 100 is directly handled. That is, copying of the object data, setting of property values, and the like are performed.

Next, it is checked whether or not there is a color designation (S54). If there is a color designation, the background color setting of the cell is added to the tabulated document data (S56).
In this way, the document data of the table in which the combination is specified and the color is specified is obtained. The above is the outline of the table creation processing shown in FIG.

Referring to FIG. 9, a description will be given of the algorithm of the row combination priority processing. Steps S70 to S76 are repetitive processes performed for each row (each horizontal row of the table). From the start line to the last line, if there are adjacent cells having the same combination flag and the same cell character string in the lines, these are combined (S72). That is, with respect to such cells that can be combined, one end (for example, the left end, that is, the cell with the smallest column number) is set as the head cell, and all other cells to be combined are set as non-head cells. Then, for the first cell (i, j), the combination array (i, j, $ END column)
Set the rightmost column number of the cell to be merged.

Steps S78 to S88 are repetitive processes performed for each column (each vertical column of the table). In step S82, it is determined whether or not there is an adjacent cell or cell band in the column (column j) that satisfies the combination condition. The joining conditions are as follows: 1) Associative array (i, j, $ FLAG) = associative array (i + 1,
j, $ FLAG) = head 2) Associative array (i, j, $ END column) = associative array (i + 1,
j, $ END column) 3) FLAG (i, j) = FLAG (i + 1, j) 4) Cell strings corresponding to respective cells are equal. In step S84, a pair of vertically adjacent cells or a set of three or more cells that are continuous in the vertical direction that satisfies the combination condition is determined by dividing the cell band starting with the cell (k, j) into a cell in step S84. (I, j) is coupled to the cell band starting with (i, j). For example, if it is possible to join from the i-th row to the q-th row in the j column, the associating array (k, j,
LAG) is updated to a non-head cell, and the associative array (i,
j, $ END line) = q. Where i + 1 <= k <
= Q.

The connection array creation processing by column connection priority designation (S50) in FIG. 8 may be similar to the connection array creation processing by row connection priority designation shown in FIG. 9 except that the rows and columns are replaced. That is, the same processing as in steps S70 to S76 in FIG. 9 is repeated for each column (each vertical column in the table), and thereafter, the same processing as in steps S78 to S88 is repeated for each row (each horizontal row in the table). I do.

The procedure of the cell merging process shown in the flow charts of FIGS. 8 and 9 is an example of a realizing method. If the desired table document data can be obtained from the table combination specification 202 and the value combination pattern 201 in accordance with the designation of the row connection priority or the column connection priority, the connection array shown in the flowcharts of FIGS. The procedure to be performed may be different.

The editing layout apparatus 1 provided with the table composition creating means 110 and the table composition designating means 120 has been described in detail. The text data input to the table creation unit 110 as the table specification may be integrated into one file, or the original data, the flag data for the combination specification, and the flag data for the cell background color specification may be stored in separate text files. May be input to the table creation unit 110.

[0035]

When spreadsheet software is used as the table designating means, a complicated table design can be specified while confirming it interactively on the screen, so that the load on the operator is significantly reduced. It works. In addition, the table forming means automatically generates the table data in the desired format from the value specification pattern in which only the format of the cell characters is specified and the table specification specifying the cell combination and the background color of the cell. Can be generated. The operator only needs to perform two simple tasks: preparing text data for specifying a table structure and editing and layout work using only cell strings to prepare a value set pattern. It has a remarkable effect of being reduced.

[Brief description of the drawings]

FIG. 1 is an overall configuration diagram of an editing layout apparatus equipped with a table composition creating unit and a table composition designating unit of the present invention.

FIG. 2 is a flowchart illustrating an operation procedure of the editing layout apparatus 1.

FIG. 3 shows a state in which original data is read into a table designating means 120;

FIG. 4 shows a state in which a color is designated by the table designating means 120;

FIG. 5 shows a state in which the combination designation is performed by the table designating means 120;

FIG. 6 shows a state in which the contents of table specification are confirmed by the table specification means 120;

FIG. 7 is a diagram showing an image of a table to be created.

FIG. 8 is a flowchart for explaining the operation of the table creation means 110.

FIG. 9 is a flowchart for explaining in detail the processing of a line combination priority processing part;

FIG. 10 is a view for explaining row sign priority and column join priority;

FIG. 11 is a diagram showing a typesetting image of a value set pattern file.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Editing layout apparatus 10 Computer main body 11 Graphic display 12 Keyboard and mouse 20 Hard disk 100 Editing layout software 110 Table composition creating means 120 Table composition specifying means 200 Original data file 201 Value group pattern file 202 Table composition text file

Claims (8)

[Claims] A first text data created by inserting a delimiter between cell strings, which is a character string to be displayed in one cell in a table, and editing layout software for table composition. Document data corresponding to part or all of a typeset table created by placing some dummy characters in the cell with the finished formatting and drawing the necessary ruled lines. Enter
A table creation program that creates document data formatted as tables. 2. A first text data created by inserting a delimiter between cell strings, which are character strings to be displayed in one cell in a table, and a first text data for a table. The second text data in which the cell character string in the inside is replaced with a flag character designating the combination of the cells, and some dummy characters that have been subjected to finish formatting using editing layout software are placed in the cell. Document data corresponding to part or all of a typeset table created by drawing necessary ruled lines is input, and the specified cell combination is applied to the second text data. A table creation program that creates document data formatted as tables. 3. A first text data created by inserting a delimiter between cell character strings which are character strings to be displayed in one cell in a table, and a first text data for a table. The second text data in which the cell character string in the inside is replaced with a flag character that specifies the background color of the cell, and some dummy characters that have been subjected to finish formatting using editing layout software are placed in the cell. Document data corresponding to part or all of a typeset table created by drawing necessary ruled lines is input, and the cells designated in the second text data are color-coded. A table creation program that creates formatted document data as a formatted table. 4. A first text data created by inserting a delimiter between cell character strings which are character strings to be displayed in one cell in a table, and a first text data for a table. A second text data in which a cell character string in the middle is replaced with a flag character designating the combination of cells,
The third text data in which the cell character string in the text data of the above is replaced with a flag character that specifies the color of the cell, and some dummy characters that have been subjected to finish formatting using editing layout software are stored in the cell. And input the document data corresponding to part or all of the formatted table created by drawing the necessary ruled lines, and enter the cell combination designated by the second text data. A table composition creating program for creating document data formatted as a table in which the third text data is color-coded as specified. 5. The table creation program according to claim 2 or 4, wherein a row connection priority or a column connection priority is specified in advance to specify a row connection priority or a column connection priority cell. A table creation program that can create typeset document data as a joined table. 6. An editing layout apparatus on which the table creation program according to claim 1 is installed. 7. For a table, read first text data created by inserting a delimiter between cell character strings, which are character strings to be displayed in one cell in the table, into spreadsheet software. Instead, a cell string is displayed in the cell on the spreadsheet software sheet, and the cell coloring function and the character input function to the cell provided in the spreadsheet software are used. By specifying the color for the cell displaying the character string and setting the used color and the flag character corresponding to that color on the same sheet, specify the flag for cell combination or cell color classification, Using the macro definition function provided in the spreadsheet software, define a macro that automatically processes the cell data set on the sheet. Structure A table design method for creating text data composed of text data and flag data indicating a background color of a cell or text data obtained by combining them. 8. A spreadsheet software having a macro for realizing the table designating method according to claim 7.
3. The editing layout device according to 1.