JPH0661982B2 - Table printing method - Google Patents

Description

The present invention relates to a table printing method for printing out table data having a plurality of rows and a plurality of columns.

[Conventional technology]

With the development of microprocessors, a table processing unit that stores a value corresponding to a target term in a ruled line or a range surrounded by the ruled line, and further performs a target operation on the stored value corresponding to the ruled line is a stand-alone device. It became possible with.
This table processing device has a function of executing a calculation in a vertical direction or a horizontal direction in a range surrounded by ruled lines, which is stored in advance, that is, each column, and storing it in a designated column.
For example, when creating a sales table, items such as purchase price, profit margin, selling price, quantity, and amount are provided for each product name. Then, if such a calculation is stored in advance with the purchase price × profit rate as the selling price and the selling price × quantity as the money amount, the purchase price, the profit rate, and the quantity are automatically entered to automatically enter the selling price and amount fields. The value is stored in.

Due to the functions described above, such a table processing device is used in various fields. As a matter of course, such an apparatus has a display unit and a printing unit, and is configured to create and print table data by the display unit.

On the other hand, there are cases where the above-mentioned device has data that is not desired to be displayed or printed. For example, when the sales table as described above is submitted to another person, the purchase price and the profit rate are the data that should not be printed. In addition, for example, when a table including the number of working days, working hours, hourly wages, and the amount of payment for all employees is created, the manager needs all of them. However, in the case of the table for confirming the number of working days and working hours of each employee, hourly wages and payments are not required.

[Problems to be Solved by the Invention] Conventionally, the above-described table has been recreated according to the purpose of use. In the above-mentioned case, a table showing the product name, selling price, quantity, amount, name, working days, working hours was prepared separately. Therefore, there is a problem that the storage capacity of the auxiliary storage device must be increased in order to store a plurality of tables, although they are almost the same. Furthermore, there is a problem that unnecessary time is spent for data input to create another table.

An object of the present invention is to make it possible to easily print out a table having a plurality of rows and a plurality of columns stored in advance, the table having desired rows and columns in the table.

[Means for Solving the Problems] Means of the present invention are as follows.

A table printing method at the time of printing out table data composed of a plurality of rows and a plurality of columns stored in a table data storage means, wherein a desired printout form in the row and column directions of the table data is expressed in line units, A desired print output form in the row and column directions when the table data stored in the table data storage means is stored in the print buffer for print output. If not, each row excluded from printing is not stored in the print buffer, and in each row targeted for print output, only the table item data in each column excluding the columns excluded from printing is stored. The table item data stored in the table data storage means is stored in the print buffer in the same order as that of the table item data stored in the table data storage means, and the table item data stored in the print buffer is stored in the print buffer. Out look, characterized in that the row and column that is the print-excluded with respect to the table data is to be output in tabular deleted form.

[Operation] The operation of the means of the present invention is as follows.

First, the desired printout form in the row and column directions for table data consisting of a plurality of rows and a plurality of columns is set in units of rows.
And set arbitrarily for each column. In this household,
When the table data stored in the table data storage unit is stored in the print buffer for print output, if the desired print output form in the row and column directions is set, it is not printed. Further, each row is not stored in the print buffer, and only the table item data in each column excluding the columns excluded from the print is stored in the above-mentioned table data storage means in each row targeted for print output. The table items are stored in the print buffer in the same order as the order of the table item data. Then, each table item data stored in the print buffer is read out, and the table data is output in the table format in which the rows and columns excluded from the print target are deleted from the table data.

Therefore, even if the storage state of the table data stored in the table data storage means is not changed, the table data can be easily printed in different printout modes.

〔Example〕

FIG. 1 is a circuit configuration diagram of an embodiment of the present invention. The key input unit 1 is a circuit for inputting ruled lines, item names, data of corresponding items, etc., and is operated by an operator or the like. The data input by the key input unit 1 is added to the command analysis unit 2 for command analysis. For example, a table is created, a calculation formula is specified, and a command for printing prohibition setting is analyzed, and control data is output to the table processing control unit 3 and the printing prohibition matrix setting unit 4. Further, the data for creating the table and the calculation formula data are added to the table processing control unit 3 via the command analysis unit 2.
When the command analysis unit 2 analyzes the control data and adds the control data to the table processing control unit 3, the table processing control unit 3 performs an operation corresponding to the control data. If the input control data is for creating a ruled line of a table, the ruled line designation data or the like added via the command analysis unit 2 from the key input unit 1 is input to the table creation unit 3-1 and converted into ruled line data and the table data is stored. The data is stored in the section 5 via the table data storage control section 3-2. The table data storage control unit 3-2 controls the storage and reading of the ruled line data generated by the table creation unit 3-1 and the numerical value data of each item input from the key input unit. On the other hand, if the control data added from the command analysis unit 2 is calculation formula designation control data, the table processing control unit 3
Registers the subsequently input calculation formula data in the calculation formula registration unit. When the spreadsheet calculation command is added to the command analysis unit 2, the command analysis unit 2 outputs the spreadsheet calculation control data to the table processing control unit 3. When the spreadsheet calculation control data is added to the spreadsheet processing control unit 3, the retrieval unit 3-5 temporarily stores the calculation formula data registered in the calculation formula registration unit 6 in the calculation formula buffer 3-4. Then, each item stored in the table data storage unit 5, that is, the data corresponding to each column is read out, and the calculation unit 3-3 performs an operation based on the calculation formula stored in the calculation formula buffer 3-4. The result is stored in the table data storage unit 5 via the table data storage control unit 3-2. This calculation process is performed for all the corresponding items, but the calculation is not executed if numerical data is not input to the corresponding items. Data is stored in the table data storage unit 5 by the above operation.

On the other hand, when a prohibited print designation command is input to the command analysis unit 2 from the key input unit, the command analysis unit 2 outputs the prohibited print matrix setting control data to the prohibited print matrix setting unit 4. When the print inhibition matrix setting control data is added, the print inhibition matrix setting unit 4 stores the data to be inputted subsequently in the column registers MCR1 to MCR5 and the row registers MRR1 to MRR5 as the print inhibition data of the rows or columns. The storage of these data is used at the time of printing which will be described later, and further, the column number counters 4-1 and 4-1 included in the printing prohibition matrix setting unit 4 are provided.
The line number counter 4-2, the comparison circuits 4-3 and 4-4 operate at the time of printing in the prohibited print control.

When the print command in the prohibited print control is added to the command analysis unit 2 from the key input unit 1, the command analysis unit 2
The control data for outputting the table data stored in the table data storage unit 5 to the print control unit 7 is output to the table processing control unit 3. The table processing control unit operates the table data storage control unit 3-2 by this control data, and the table data storage control unit 3-2 sequentially reads the table data to be printed from the table data storage unit 5 and causes the printing control unit 7 to perform the printing. Output. Table processing control unit 5
Outputs a clock pulse to the column number counter 4-1 and the row number counter 4-2 of the prohibited-print matrix setting unit 4 corresponding to the columns and rows sequentially read from the table data storage unit. The values of the column number counter 4-1 and the row number counter 4-2 are read by the table data storage control unit 3-2 from the table data storage unit 5 and the row and column positions of the table data to be added to the print control unit 7 are set. It represents. The print inhibition control unit 4 adds the values of the column number counter 4-1 and the matrix counter 4-2 to the comparison circuits 4-3 and 4-4, respectively, and the comparison circuit outputs the print inhibition data stored in advance by the above operation. The count values added by the column number counter 4-1 and the row number counter 4-2 are compared. This is to determine whether the table data added to the print control unit 7 is prohibited print data, that is, data for which printing is prohibited. When the table data is prohibited print data, the data is not stored in the print buffer 7-1. It is a comparison to make. The count values added by the column number counter 4-1 and the row number counter 4-2 are the column registers MCR1 to MCR5 and the row registers MRR1 to M.
When the presence in the RR5 is detected by the comparison circuits 4-3 and 4-4, that is, when they match, the print control unit 7 does not store the additional table data in the print buffer 7-1, but adds it. Store table data in print buffer.
In addition, the above-mentioned table data added subsequently is prohibited printing data,
That is, when coincidence is detected by the comparison circuits 4-3 and 4-4, it goes without saying that the above-mentioned data added subsequently is not stored. By the above operation, only the table data to be printed is stored in the print buffer 7-1 of the print control unit 7,
The print control unit outputs the stored data to the print unit 8, and the print unit 8 prints the data.

On the other hand, when all print control data for all printing is added to the command analysis unit by key input, the command analysis unit 2 sends the table data stored in the table data storage unit 5 to the print processing unit 3 to the table processing control unit 3. The control data output to 7 is output. As a result, the table processing control unit operates, but this operation is exactly the same as in the case of prohibited printing. However, in the case of the printing operation, the printing prohibition matrix setting unit 4 operated in the above-described printing prohibition operation does not operate, and the printing of the table data from the table data storage unit 5 is sequentially read from the storage control unit 3-2. It is added to the control unit and is all stored in the print buffer 7-1. All the table data stored in the print buffer 7-1 is output to the printing unit 8 and printed, as in the above.

Fig. 2 (a) is a print result diagram of the sales table in all print operations,
FIG. 2 (b) is a print result diagram of the sales table when the columns B and C are prohibited. Calculation formula, column D = B in FIG. 2 (a)
Column × C column, F column = D column × E column are stored in the calculation formula registration unit 6, and the corresponding result is stored in each term. In FIG. 2 (b), the print prohibition matrix, columns B and C, that is, the purchase price and the profit margin are not printed, but only the necessary data (name of product, selling price, quantity, amount of money) is printed. ing.

In the embodiment of the present invention shown in FIG. 1 described above, the printing prohibition in the printer or the like is described. However, the present invention is not limited to the printer, and for example, means for detecting a specific password is provided,
It is also possible to prevent printing and display on a CRT or the like when the password is not detected. Furthermore, the present invention is not limited to a table, and can be applied to a system in which unnecessary text is prohibited.

〔The invention's effect〕

According to the present invention, it is possible to easily print by changing the printout form of the table data without changing the storage state of the table data stored in the table data storage means. Moreover, the printout form of the table data described above can set a desired printout form on a row-by-row and column-by-column basis. As a result, the table data including only the rows and columns desired to be printed out can be printed out. You can

[Brief description of drawings]

FIG. 1 is a circuit configuration diagram of an embodiment of the present invention, FIG. 2 (a) is a print result diagram of a sales table in the case of non-prohibited printing, FIG. 2 (b) is a column B in FIG. 2 (a), FIG. 9 is a print result diagram when the print prohibition is performed on the column C. 1 ... Key input unit, 3 ... Table processing, 3-2 ... Table data storage control unit, 4 ... Prohibition print matrix setting unit 4-1 ... Column number counter, 4-2 ... Matrix counter, 4 -3, 4-4 ... Comparison circuit, 5 ... Table data storage section, 7 ... Print control section, 7-1 ... Print buffer, 8 ... Print section.

Claims (1)

[Claims] 1. A table printing method for printing out table data composed of a plurality of rows and a plurality of columns stored in a table data storage means, wherein a desired printout form in the row and column directions of the table data is provided. Is arbitrarily set in row units and column units, and when the table data stored in the table data storage unit is stored in the print buffer for print output, desired print output in the row and column directions is performed. When the form is set, each row excluded from printing is not stored in the print buffer, and in each row targeted for print output, in each column except the column excluded from printing. Only the table item data is stored in the print buffer in the same order as the order of the table item data stored in the table data storage means, and the table items are stored in the print buffer. Reads the item data, surface printing method being characterized in that as the printing medium outside the row and column outputs in tabular form of the deleted form with respect to the table data.