JPH0768889A - Table printing method - Google Patents

Abstract

PURPOSE:To output a table, which comprises a plurality of columns and a plurality of ranks memorized in advance, as it is as a whole in print and, at the same time, when necessary, output a table, which consists of only the desired columns and ranks in the above-mentioned table, in print. CONSTITUTION:When the whole printing controlling data are added by a command analyzing part 2, all the table item data stored in a table data storing part 5 is read out and stored in a printing buffer 7-1. When printing inhibiting specification command is added by the command analyzing part 2, the transferring of the table item data of the columns and ranks, the inhibition of the printing of which is specified, is inhibited and only the table item data of the columns and ranks, the inhibition of the printing of which is not specified, is stored in the printing buffer 7-1 and printed at a printing part 8.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table printing method for printing out table data consisting of a plurality of rows and a plurality of columns stored in table data storage means.

[0002]

2. Description of the Related Art With the development of microprocessors,
A table processing device, which 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 calculation corresponding to the ruled line, has become possible as a stand-alone device. This table processing device has a function of performing a calculation in a vertical direction or a horizontal direction in a range surrounded by ruled lines 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. The purchase price x profit rate is the selling price, and the selling price x
If such an operation is stored in advance with the quantity as the amount of money, by inputting the purchase price, the profit rate, and the quantity, the value is automatically stored in the selling price and the amount of money column.

Due to the above-mentioned functions, such a table processing device is used in each direction. As a matter of course, such a device 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 is a case where the above-mentioned device has data which 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 payment amount of all employees is created, it is necessary for the manager. However, hourly wages and payments are not required when using the table to confirm the number of working days and working hours of each employee.

[0005]

Conventionally, the above-mentioned table has been recreated according to the purpose of use. In the above case, product name, selling price, quantity, amount, name, working days,
A separate table showing working hours was created again. For this reason, 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. Further, there is a problem that an unnecessary time is spent for inputting data for creating another table.

An object of the present invention is to store in advance a table consisting of a plurality of rows and a plurality of columns. The table is printed out as it is, and if necessary, a desired row in the table is output. , And a table consisting of only columns can be printed out.

[0007]

The means of the present invention are as follows. A table printing method for printing out table data consisting of a plurality of rows and a plurality of columns stored in a table data storage means, wherein a print buffer for printing out the table data stored in the table data storage means When the entire output for the table data is designated when storing the table data, all the table item data stored in the table data storage means are all stored in the print buffer and stored in the table data storage means. When storing the stored table data in the print buffer for print output, if the desired print output form in the row and column directions for the table data is set in row units and column units, The table item data in each column excluding the columns excluded from printing is not stored in the above print buffer for each line excluded from printing Are stored in the print buffer, and each table item data stored in the print buffer is read out and printed out. By this, the whole table data is output in a table format, or It is characterized in that it is possible to perform either output in a tabular format in which rows and columns excluded from printing are deleted.

[0008]

The operation of the means of the present invention is as follows. When the table data stored in the table data storage means is stored in the print buffer for print output, if the entire output for the table data is specified, each of the table data storage means All table item data is stored in the print buffer. On the other hand, when the table data stored in the table data storage unit is stored in the print buffer for print output, the desired print output form in the row and column directions for the table data is row unit and column unit. If set to, the rows that are not subject to printing are not stored in the print buffer, and the rows in the rows that are subject to print output are displayed in columns other than the columns that are not subject to printing. Only item data is stored in the print buffer.
Then, each table item data stored in the print buffer is read out and printed out. As a result, either the tabular output of the entire tabular data or the tabular output in which the rows and columns excluded from the print target are deleted from the tabular data can be performed.

Therefore, the table data stored in the table data storage means can be output as it is, and the table data consisting of only the desired rows and columns is required without changing the storage state of the table data storage means. It can be selectively output depending on the situation.

[0010]

FIG. 1 is a circuit diagram of the embodiment. The key input unit 1 is a circuit for inputting ruled lines, item names, and data of corresponding items, 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 print prohibition setting is analyzed, and control data is output to the table processing control unit 3 and print 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 the table, the ruled line designation data or the like added from the key input unit 1 via the command analysis unit 2 is input to the table creation unit 3-1 and converted into ruled line data to store the table data. 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 includes ruled line data generated by the table creation unit 3-1 and the key input unit 1
The storage / reading control of the numerical data of each item input by the above is performed. On the other hand, if the control data added by the command analysis unit 2 is calculation formula designation control data, the table processing control unit 3 registers the calculation formula data to be input subsequently in the calculation formula registration unit 6. When the spreadsheet calculation execution command is added to the command analysis unit 2, the command analysis unit 2 outputs the spreadsheet calculation execution control data to the spreadsheet 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, the table data storage unit 5
Data corresponding to each item, that is, each column, stored in the calculation formula 3-3 is calculated based on the calculation formula stored in the calculation formula buffer 3-4, and the result is stored in the table data. The data is stored in the section 5 via the table data storage control section 3-2. This calculation process is performed for all the corresponding items, but the calculation is not executed when the 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 from the key input unit 1 to the command analysis unit 2, the command analysis unit 2 outputs the prohibited print matrix setting control data to the prohibited print matrix setting unit 4. When this print inhibition matrix setting control data is added, the print inhibition matrix setting unit 4 uses the data to be input later as column or row prohibition data to register the column registers MCR1 to MCR1.
The data is stored in MCR5 and row registers MRR1 to MRR5.
The storage of these data is used at the time of printing which will be described later, and further, the column number counter 4-1, the row number counter 4-2, the comparison circuits 4-3, 4 included in the print inhibition matrix setting unit 4.
-4 operates during printing in the print prohibition control.

When a print command in the prohibited print control is input from the key input unit 1 to the command analysis unit 2, the command analysis unit 2 sends the table data stored in the table data storage unit 5 to the table processing control unit 3. Is output to the print control unit 7 to output control data. The table processing control unit 3 operates the table data storage control unit 3-2 based on this control data. The table data storage control unit 3-2 sequentially reads the table data to be printed from the table data storage unit 5, and the printing control unit 7 Output to.
The table processing control unit 3 corresponds to the columns and rows sequentially read from the table data storage unit 5 and the column number counter 4-of the prohibited print matrix setting unit 4.
1. Output a clock pulse to the row counter 4-2.
The values of the column number counter 4-1 and the row number counter 4-2 are read from the table data storage unit 5 by the table data storage control unit 3-2, and the row and column positions of the table data to be added to the print control unit 7 are determined. It represents. The print inhibition control unit 4 compares the values of the column number counter 4-1 and the row number counter 4-2 with the comparison circuit 4.
In addition to −3 and 4−4, the comparison circuit is provided with the prohibition print data and the column number counter 4-stored in advance by the above operation.
1, the count value added from the row number counter 4-2 is 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, and when it is prohibited print data, the print buffer 7-
This is a comparison for not storing the data in 1. It is determined that the count values added by the column number counter 4-1 and the row number counter 4-2 exist in the column registers MCR1 to MCR5 and the row registers MRR1 to MRR5.
When detected in 3, 4-4, that is, when they match, the print control unit 7 adds the added table data to the print buffer 7.
-1 is not stored, but table data to be added subsequently is stored in the print buffer. It should be noted that the above-mentioned data to be added subsequently is prohibited print data, that is, when the comparison circuits 4-3 and 4-4 detect the coincidence, the above-mentioned data to be 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 7 outputs the stored data to the print unit 8, and the print unit 8 prints the data. To do.

On the other hand, when all print control data for all print is added to the command analysis section 2 by key input, the command analysis section 2 sends the table data stored in the table data storage section 5 to the table processing control section 3. Is output to the print control unit 7 to output control data. As a result, the table processing control unit 3 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 table data from the table data storage unit 5 is sequentially read from the storage control unit 3-2. In addition to being added to the control unit 7, all are stored in the print buffer 7-1. All of the table data stored in the print buffer 7-1 is output to the printing unit 8 and printed as described above.

FIG. 2A is a print result diagram of the sales table in the entire printing operation, and FIG. 2B is a print result diagram of the sales table when columns B and C are prohibited. In FIG. 2A, the calculation formulas, D column = B column × C column, F column = D column × E column are stored in the calculation formula registration unit 6, and the corresponding results are stored in each term. Then, in FIG. 2B, the print prohibition matrix, B
The columns C and C, that is, the purchase price and the profit rate are not printed, but only the necessary data (name of item, selling price, quantity, amount of money) are printed.

Although the above-described embodiment of FIG. 1 describes the prohibited printing in the printer or the like, the present invention is not limited to the printer, but for example, means for detecting a specific password is provided, and when the password is not detected, printing and CRT are performed. It is also possible to configure such that the display on the is prohibited. Further, the present invention is not limited to the table, and can be applied to a system in which unnecessary text is prohibited.

[0016]

According to the present invention, the tabular data stored in the tabular data storage means can be output as it is, and even if the storage state of the tabular data storage means is not changed, only the desired rows and columns can be output. The table data can be selectively output as needed.

[Brief description of drawings]

FIG. 1 is a circuit configuration diagram of an embodiment.

FIG. 2 is a diagram showing a printing result when printing is not prohibited in the embodiment.

[Explanation of symbols]

 2 Command analysis section 4 Prohibited print matrix setting section 5 Table data storage section 7 Printing control section 8 Printing section

Claims (1)

[Claims] 1. A table printing method for printing out table data consisting of a plurality of rows and a plurality of columns stored in a table data storage means, wherein the table data stored in the table data storage means is printed. When the entire output for the table data is specified when the table data is stored in the output print buffer, each table item data stored in the table data storage unit is stored in the print buffer, When the table data stored in the data storage means is stored in the print buffer for print output, the desired print output form in the row and column directions for the table data is set in row units and column units. If not, each row that is not subject to printing is not stored in the print buffer, and each row that is subject to print output is stored in each column except the columns that are not subject to printing. Only the table item data is stored in the print buffer, and each table item data stored in the print buffer is read out and printed out, whereby the entire table data is output in the table format or the table data is output. On the other hand, a table printing method is characterized in that it is possible to perform either one of a table format output in which the rows and columns excluded from the printing are deleted.