JP2940657B2 - Table printing control device - Google Patents

Description

Description: BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table print control apparatus for controlling print output of table data composed of a plurality of rows and a plurality of columns. [0002] With the development of microprocessors,
A stand-alone table processing device that stores a value corresponding to a target item in a ruled line or a range surrounded by the ruled line, and further performs a target operation on the stored value in accordance with the ruled line has become possible. 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 stored in advance, that is, in each column, and storing it in a designated column. For example, when creating a sales table or the like, items such as a purchase price, a profit rate, a selling price, a quantity, and an amount are provided for each product name. Then, the purchase price x profit ratio is set as the selling price, and the selling price x
If such a calculation is stored in advance with the quantity as the amount, the purchase price, the profit margin, and the quantity are input, and the value is automatically stored in the selling price and the amount column. [0003] Due to the function described above, such a table processing device is used in each direction. Naturally, such a device has a display unit and a printing unit, and the display unit creates and prints table data. [0004] On the other hand, in the above-described apparatus, there are cases in which there is data that is not desired to be displayed or printed. For example, when submitting a sales table as described above to another person, the purchase price and profit rate are data that the user does not want to print. Further, for example, when a table including the number of working days, working hours, hourly wages, and even the amount of payment for all the employees is created, all the managers need them. However, hourly wages and even paid amounts are not required when the table for confirming the working days and working hours of each employee is required. [0005] Conventionally, the above-mentioned tables have been changed according to the purpose of use. In the case described above, product name, selling price, quantity, amount, name, working days,
A separate table showing working hours was recreated. For this reason, there is a problem that, for example, the storage capacity of the auxiliary storage device must be increased in order to store a plurality of tables while being substantially the same. Further, there is a problem that unnecessary time is spent for data input for creating another table. An object of the present invention is to provide a table composed of a plurality of rows and a plurality of columns stored in advance, and to print out the entire table as it is and, if necessary, to select a desired row in the table. , And a column can be printed out. According to the present invention, there is provided a table printing control apparatus comprising table data storage means for storing table data comprising a plurality of rows and a plurality of columns of table item data. A setting means for arbitrarily setting a desired print output form in the row and column directions for each row and column, an instruction for setting print output by the print output form set by the setting means, and A print instructing means for selecting and instructing any one of the entire table data irrespective of the set printout form, and a command when the set printout instruction is selected by the print instructing means. Reads each table item data in rows and columns excluding each row and each column excluded from the printout target by the setting means in the table data stored in the table data storage means. And prints out the read table item data in the same order as the table item data in the table data in the vertical and horizontal directions. On the other hand, the print instruction means outputs the entire print output. When the instruction is selected, all of the table item data included in the table data stored in the table data storage unit is read, regardless of whether or not the printout form is set in the setting unit. Print output control means for printing out each read table item data in accordance with the original arrangement order in the vertical and horizontal directions. 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 can be output without changing the storage state of the table data storage means. Can be selectively output as needed. FIG. 1 is a circuit diagram of an embodiment. The key input unit 1 is a circuit for inputting data such as ruled lines, item names, and corresponding items, and is operated by an operator or the like. The data input by the key input unit 1 is applied to the command analysis unit 2, and the command is analyzed. For example, it analyzes a command for creating a table, designating a calculation formula, and further setting prohibited printing, and outputs control data to the table processing control unit 3 and the prohibited printing matrix setting unit 4. Further, table creation data and calculation formula data are applied to the table processing control unit 3 via the command analysis unit 2.
When the control data is analyzed by the command analysis unit 2 and added 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 ruled lines of a table, ruled line designation data and the like to be added from the key input unit 1 via the command analyzing unit 2 are input to the table creating unit 3-1 and converted into ruled line data and stored in 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 the ruled line data generated by the table creation unit 3-1 and the key input unit 1.
It controls the storage and readout of the numerical data of each item input from the above. 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 subsequently input in the calculation formula registration unit 6. When the spreadsheet execution command is added to the command analysis unit 2, the command analysis unit 2 outputs the spreadsheet execution control data to the spreadsheet processing control unit 3. When the table calculation execution control data is added to the table processing control unit 3, the search 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
, The data corresponding to each column is read out, the calculation unit 3-3 performs an operation based on the calculation formula stored in the calculation formula buffer 3-4, and stores the result in 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 if no numerical data is input to the corresponding item, no calculation is performed. 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 applied from the key input unit 1 to the command analysis unit 2, the command analysis unit 2 outputs prohibited print matrix setting control data to the prohibited print matrix setting unit 4. When the prohibition print matrix setting control data is added, the prohibition print matrix setting unit 4 converts the data to be input thereafter into the column registers MCR1 to MCR1 as prohibition print data of a row or a column.
MCR5 is stored in the row registers MRR1 to MRR5.
The storage of these data is used at the time of printing, which will be described later. Further, the column number counter 4-1, the row number counter 4-2, and the comparison circuits 4-3 and 4 of the prohibited print matrix setting section 4 are provided.
-4 operates at the time of printing in the prohibited printing control. When a print command in the prohibited print control is applied to the command analysis unit 2 from the key input unit 1, 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. The table processing control unit 3 operates the table data storage control unit 3-2 based on the 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, Output to
The table processing control unit 3 controls a column number counter 4 of the prohibited print matrix setting unit 4 corresponding to the columns and rows sequentially read from the table data storage unit 5.
1. A clock pulse is output to the row number counter 4-2.
The values of the column number counter 4-1 and the row number counter 4-2 are read out 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 prohibited print control unit 4 compares the values of the column number counter 4-1 and the line number counter 4-2 with the comparison circuit 4
In addition to -3 and 4-4, the comparison circuit also includes the prohibited print data and the column counter 4-
1. The count value added by the row number counter 4-2 is compared. This is done by determining whether the table data applied to the print control unit 7 is prohibited print data, that is, data that is subject to print prohibition.
No. 1 is a comparison for preventing the data from being stored. The fact that the count value added by the column number counter 4-1 and the row number counter 4-2 exists in the column registers MCR1 to MCR5 and the row registers MRR1 to MRR5 is compared with the comparison circuit 4-
When they are detected in 3, 4-4, that is, when they match, the print control unit 7 stores the added table data in the print buffer 7.
-1 is not stored, and subsequently added table data is stored in the print buffer. It should be noted that, when the table data added subsequently is prohibited print data, that is, when the coincidence is detected by the comparison circuits 4-3 and 4-4, the data added subsequently is not stored. By the operation described above, 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. I do. On the other hand, when all print control data for all prints is added to the command analysis unit 2 from a key input, 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. As a result, the table processing control unit 3 operates, but this operation is exactly the same as in the case of the prohibited printing. However, in the case of a printing operation, the prohibited printing matrix setting unit 4 operated in the above-described prohibited printing operation does not operate, and the table data from the table data storage unit 5 is sequentially read out from the storage control unit 3-2. The data is added to the control unit 7 and 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 in the same manner as described above. FIG. 2A is a printing result diagram of the sales table in the full printing operation, and FIG. 2B is a printing result diagram of the sales table when the columns B and C are prohibited printing. In FIG. 2A, the calculation formula, D column = B column × C column, and F column = D column × E column are stored in the calculation formula registration unit 6, and the corresponding result is stored in each term. Then, in FIG. 2B, the prohibited print matrix, B
Column and column C, that is, the purchase price and the profit rate are not printed, but only necessary data (product name, selling price, quantity, amount) are printed. In the embodiment of FIG. 1 described above, prohibited printing in a printer or the like is described. However, the present invention is not limited to a printer, but includes, for example, means for detecting a specific password. It is also possible to configure such that the display on is also prohibited. Further, the present invention is not limited to a table, and can be applied to a system in which unnecessary text is prohibited from being printed. According to the present invention, the printout form of the table data can be easily changed without changing the storage state of the table data composed of a plurality of rows and columns stored in the table data storage means. Printing can be performed differently, and a desired print output form can be set as a print output form in units of rows and columns. Further, as described above, the printing of the table data in a different print output form is performed particularly when an instruction to print the table data in the set print output form is selected, When an instruction to print the entire table is selected as another instruction, the entire table of the original table data itself can be printed, and such an instruction can be performed. The entire table can be printed regardless of the setting of the print output mode, that is, even after the print output mode is set.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a circuit configuration diagram of an embodiment. FIG. 2 is a diagram illustrating a printing result when no prohibited printing is performed according to the embodiment. [Description of Signs] 2 Command analysis unit 4 Prohibited print matrix setting unit 5 Table data storage unit 7 Print control unit 8 Printing unit

Claims (1)

(57) [Claims] A plurality of rows and a surface printing controller with table data storing means for storing the table data comprising a table entry data of a plurality of rows, desired in the row and column of the table data
Setting means for arbitrarily setting the print output form in units of rows and columns, and setting printing by the print output form set by the setting means
Output instruction and print output type set by the setting unit
Finger print output of the entire table data regardless of status
And the print instructing means for selecting and instructing the setting print output by the print instructing means.
When it is done, the above stored in the table data storage means
In the table data, it is excluded from print output by the above setting means.
Table item data in rows and columns excluding each row and column
Data for each table item
In the table data, the order of each table item data in the vertical and horizontal directions and
Print out in the same arrangement order, while printing
When the instruction for the whole print output is selected by the instruction means
Indicates whether or not the printout mode is set by the setting unit.
Regardless of the table stored in the table data storage means.
Read all the table item data included in the data and
Of each read table item data in its original vertical and horizontal direction
And a print output control unit for performing print output in accordance with the order of printing .