JP3031002B2 - Coding device, bar code conversion method of table information, and table sheet - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a coding apparatus, a spreadsheet information creating apparatus, and a spreadsheet suitable for application to, for example, a printer, a word processor with a printer, and the like.

[0002]

2. Description of the Related Art Printers are widely used as devices for displaying data on paper, such as word processors and personal computers.

The general use of a printer can be broadly divided into a case where data created on a display is printed on a so-called printer sheet in a blank state, and a case where ruled lines are already printed on a sheet of paper which is set on the printer, and the data is printed on the display. In some cases, the printer carriage may be moved by a keyboard or the like for each item and printed so that the created data can be properly included in the ruled line.

In the former case, there is no problem because the printing is merely performed. However, in the latter case, that is, since data or the like created on the display is printed in the ruled lines of the balance sheet, it is difficult to perform positioning. The schedule itself cannot be displayed above.

As a solution to this, there is a method of setting a margin of a printing position for each item.

[0006] The simplest method is to create a schedule on a display or read the schedule with an image reader, save the schedule data on a floppy disk or a memory card, and use it. When reading, the table data is read out, displayed on the display, and the data is entered into the ruled line of the displayed table,
This is a method of printing a schedule on a display together with data.

[0007]

By the way, setting the margin of the print position for each item has a disadvantage that the user is very troublesome.

[0008] In addition, when a balance sheet is created by keyboard input or when a balance sheet on a balance sheet is read by an image reader, the user is troubled,
There was a disadvantage that the cost was increased (when an image reader was used).

Further, when the table data is stored in a floppy disk, a memory card, or the like, a user who wants to print the data on a table printed on paper should use a storage medium such as a recording medium. It will intervene.

[0010] The present invention has been made in view of the above points, and an object of the present invention is to propose a coding apparatus, a spreadsheet information creating apparatus, and a spreadsheet capable of eliminating the above-mentioned problems.

[0011]

According to the present invention, there is provided an encoding apparatus comprising:
Reading means for reading ruled line information from a table on paper;
Ruled line information storage means for storing information, and the appearance of vertical ruled lines
To generate a line symbol indicating the position interval on the vertical coordinate
Line symbol generation means and the position on the horizontal coordinate where the horizontal ruled line appears
Second line symbol generation means for generating a line symbol indicating the placement interval
And the number of appearances of vertical ruled lines for each horizontal coordinate from the ruled line information.
Vertical ruled line extraction means, and output of horizontal ruled lines from ruled line information
A horizontal ruled line extracting means for extracting the current count for each vertical coordinate;
Multiple tables can be created based on the number of appearances of straight and horizontal rules.
Area division means for dividing into areas and length information of vertical ruled lines
Compressed data based on the appearance position on the horizontal coordinate.
The first compressed data generating means and the length information of the horizontal ruled line.
Compressed data about the report based on the appearance position on the vertical coordinate
Second compressed data generating means for generating the first and second compressed data
The compressed data generated by the compressed data
And bar code conversion means for converting the code into a code .

Further, according to the present invention , barcode conversion of the schedule information is performed.
The method is to read the ruled line information from the balance sheet on the balance sheet
Step and ruled line information storage step for storing ruled line information
And a line that indicates the position interval on the vertical coordinate where the vertical ruled line appeared
A first line symbol generation step for generating a symbol, and a horizontal ruled line
Generates a line symbol indicating the position interval on the horizontal coordinate where
A second line symbol generation step, and a vertical ruled line based on the ruled line information.
Vertical ruled line extraction step to extract the number of appearances of each horizontal coordinate
And the number of occurrences of horizontal ruled lines for each vertical coordinate
Horizontal ruled line extraction step, vertical ruled line and horizontal ruled line
Area to divide the schedule into multiple areas based on the number of line appearances
The area division step and the compressed data
Data based on the appearance position on the horizontal coordinate
Compressed data generation step and horizontal ruled line length information
Compressed data based on the appearance position on the vertical coordinate.
A second compressed data generation step, and first and second compression data
The compressed data generated in the compressed data generation step
A bar code conversion step of converting the code into a code .

[0013] In addition, a total of Table paper of the present invention, the vertical borders and
Total table consisting of horizontal ruled lines and vertical coordinates at which vertical ruled lines appear
And the horizontal coordinate at which the horizontal ruled line appears
The second line symbol shown and the number of appearances of the vertical ruled line from the ruled line information
Ruled line extracting means for extracting the image for each horizontal coordinate, and ruled line information
Horizontal rule to extract the number of occurrences of horizontal rule from vertical coordinate
Appears on the horizontal coordinate with line extraction means and vertical ruled line length information
First bar indicated by compressed data generated based on position
The code and the length information of the horizontal ruled line appear on the vertical coordinate
Bar code represented by compressed data generated based on
And the first line symbol has a large number of appearances among the first line symbols.
The line symbol indicating the mark is displayed in bold, and the second line symbol appears.
A line symbol indicating a horizontal coordinate having a large number of times is displayed thick .

[0014]

According to the present invention described above, the positions of the ruled lines in one and the other directions of the table information stored in the storage means 20 are detected by the detection means 10, 11, 12, 13, 17, and 18. Detecting means 10, 11, 12, 13, 17, 18
Dividing the total table information on the basis of the positions of the ruled lines detected in one and the other directions respectively by the dividing processing means 10, 11, 12, 1
3 and the division processing means 10, 11, 12,
13 and the detecting means 10, 11, 12, 1
Since the ruled line information of one and the other is coded based on the information having a length longer than 3, 17, and 18, the length of the code information can be shortened, and various output devices can be used for various media. For example, when the balance sheet and the code are printed on paper, the balance table information can be displayed in the device by reading the code printed on the paper, and, for example, the monitor of the device can be displayed. The schedule information is displayed as an image on the screen, and after inputting desired data in the frame of the schedule displayed on the screen, the input data is stored in a predetermined form of the paper schedule placed on the device. It is possible to easily print the data input in the frame.

According to the present invention described above, the storage means 2
The positions of the ruled lines in one and the other directions of the table information stored in 0 are detected by detecting means 10, 11, 12, 13, 17, 18 and the detecting means 10, 11, 12, 13, 1, 1
Based on the positions of the ruled lines detected in one and the other directions by means of 7, 18 respectively, the total table information is divided into processing means 10, 11,
12 and 13, the division processing means 10, 1
Division information from 1, 12, 13 and detection means 10, 1
One and the other ruled line information coded based on the information of the lengths from 1, 12, 13, 17, 18 are converted by the converting means 10,
The information is converted into one and the other ruled line information by 11, 12, and 13, and the total table information is created based on the one and the other ruled line information and the division information from the conversion means 10, 11, 12, and 13. For example, when a balance sheet and a code are printed on paper, the balance sheet information is taken into the device by reading the code printed on the paper, and for example, the balance table information is written on the monitor screen of the device. After displaying the image as desired and inputting the desired data in the frame of the table displayed on the screen, the input data is input into the predetermined frame of the paper table placed on the device. Printing can be easily performed.

According to the present invention described above, the storage means 2
The positions of the ruled lines in one and the other directions of the table information stored in 0 are detected by detecting means 10, 11, 12, 13, 17, 18 and the detecting means 10, 11, 12, 13, 1, 1
Based on the positions of the ruled lines detected in one and the other directions by means of 7, 18 respectively, the total table information is divided into processing means 10, 11,
12 and 13, the division processing means 10, 1
Division information from 1, 12, 13 and detection means 10, 1
One and the other ruled line information coded based on information of lengths longer than 1, 12, 13, 17, and 18 are printed together with the schedule, so that the code printed on this paper is read. By taking the table information into the device by, for example, to display the table information as an image on the screen of the monitor of this device, after inputting desired data in the frame of the table displayed on the screen, It is easy to print the input data in a predetermined frame of a paper table placed on the device.

[0017]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Referring to FIG. 1, an example in which a coding apparatus, a spreadsheet information generating apparatus and a spreadsheet according to the present invention are applied to, for example, a word processor with a printer will be described in detail.

In FIG. 1, reference numeral 1 denotes a spreadsheet on which a spreadsheet 1 a is printed. The spreadsheet 1 is guided by a rubber roller 2.

The rubber roller 2 is driven by a y-direction motor 3.

Reference numerals 5 and 7 denote pulleys, respectively, around which a belt 6 is wound as shown in FIG.

The pulley 5 is connected to the x-direction motor 4, and the driving power of the x-direction motor 4 is transmitted to the pulley 5.

When the pulley 5 rotates, its driving power is transmitted to the pulley 7 by the belt 6, and the pulley 7 is rotated in the same direction as the pulley 5.

Thus, the head and the ribbon and the position beam 9 integrally attached to the belt 6
Is moved horizontally.

The position beam 9 has a light emitting unit and a light receiving unit, and is driven by a position beam driving and bar code reading unit 14.

The position beam 9 has three functions.

One is a function that emits light from the light emitting section, makes this light incident on the scale sheet 1, and allows the user to confirm the printing start position by the incident light. Is a function of detecting whether or not there is a ruled line based on the reflected light of the sheet, and obtaining the table information. One of the functions is described later in detail. This function reads the ruled line information from the code.

Reference numeral 10 denotes a table / coordinate conversion unit 10a and a coordinate /
A CPU having a barcode conversion unit 10b;
Reference numeral 10 is connected to each circuit and the like by a bus (composed of an address, data, and control bus) 11.

Reference numeral 12 denotes an RO in which a program is stored.
M and 13 are work RAMs, 15 is a drive circuit for driving the y-direction motor 3 and x-direction motor 4, and 16 is a keyboard.

Reference numeral 17 denotes an x-coordinate detection circuit which detects the x-coordinate by counting its pulses if the x-direction motor 4 has an encoder, and counts driving pulses if the x-direction motor 4 is a stepping motor. Detect the x coordinate.

Reference numeral 18 denotes an x-coordinate detection circuit which detects the y-coordinate by counting its pulses if the y-direction motor 3 has an encoder, and counts the driving pulses if the y-direction motor 3 is a stepping motor. Detect the y coordinate.

Reference numeral 19 denotes an image input unit such as an image scanner for reading information of a total table 1a of a total sheet 1 as shown in FIG.

Reference numeral 20 denotes a read information memory which stores the information of the table 1a read by the image input unit 19 and the keyboard 16;
And the table information created on the LCD display 23 using the position beam 9 and information of the table 1a of the table sheet 1 read by the barcode reading unit 14 using the position beam 9 described later. .

An image output memory 21 supplies the image information stored therein to an LCD display 23 via a bus 11 and an LCD drive circuit 22, and displays the image information on its display surface.

Next, the operation of the above-described word processor with a printer will be described, but the description of the operation as the word processor will be omitted, and the operation unique to this embodiment will be described.

The operations specific to this example are roughly classified as follows.

That is, an operation of obtaining the table information of the existing table sheet 1 such as a commercially available one using the position beam 9, an operation of creating the table information by inputting from the keyboard 16, and an image input unit such as an image scanner. 19, an operation of reading the table information of the table sheet 1 as an image, an operation of converting the obtained table information into a bar code or the like, and printing it at a predetermined position on the table sheet 1, a bar code or the like. This is an operation of reading the table information on the table sheet 1 on which the coded table information is printed, and printing data in the ruled lines based on the table information.

Although the image input unit 19 is described as an image scanner in this embodiment, a floppy disk driver may be used for the purpose of compatibility with various types of devices, such as a memory card reader, an electronic still camera, or the like. It may be.

Now, the above-mentioned operation will be described in detail with reference to the flowcharts of FIGS. 2 to 6 and the explanatory diagrams of FIGS. 7 to 11.

First, a description will be given with reference to the flowchart of FIG.

When the word processor with a printer shown in FIG. 1 is powered on, various functions as a word processor are displayed on the LCD display 23 together with functions capable of performing the above-described operations.

Then, in step 100, it is determined whether or not the schedule entry mode has been selected on this screen. If "YES", the flow shifts to step 500, where "N"
If “O”, the process proceeds to step 110. This selection is made by the user operating the keyboard 16.

In step 500, a subroutine S4 is executed, and thereafter the process ends.

In step 110, it is determined whether or not the schedule creation mode has been selected on the above-mentioned screen.
If "S", the process proceeds to step 120, and if "NO", the process proceeds to step 100 again.

In step 120, a selection screen is further displayed on the LCD display 23. First, it is determined whether or not a keyboard input has been made. If "YES", the flow proceeds to step 200, and if "NO", the flow proceeds to step 130. I do.

In step 200, the subroutine S1 is executed, and thereafter, the process proceeds to step 150.

In step 130, it is determined whether or not an image is input. If "YES", the flow shifts to step 300, where "N" is entered.
If “O”, the process proceeds to step 140.

At step 300, a subroutine S2 is executed, and thereafter, the routine proceeds to step 150.

In step 140, it is determined whether or not the reading is direct. If “YES”, the flow shifts to step 400. If “NO”, the flow shifts to step 120 again.

At step 400, the subroutine S3 is executed, and thereafter, the routine goes to step 150.

Before describing step 150 and subsequent steps, the above-described subroutines S1 to S3 will be described.

First, the subroutine S1 will be described with reference to FIG.

First, at step 210, a total table by keyboard input is displayed. Then, control goes to a step 220.

That is, the user once creates a total table on the LCD display 23 by inputting from the keyboard 16 by the function as a word processor. The table data is stored in the image output memory 21, and the table data is read from the image output memory 21 and supplied to the LCD display 23 via the bus 11 and the LCD drive circuit 22. It is displayed as an image on the surface.

In step 220, it is determined whether or not the mode is the table loading mode. If "YES", the process shifts to the step 240, and if "NO", the process shifts to the step 230.

In step 230, other processing is performed.

In step 240, the state of the memory is scanned, and this is read and stored in the information memory 20. Then, the process exits from the subroutine S1.

That is, the table data written in the image output memory 21 is scanned.

Next, the subroutine S2 will be described with reference to FIG.

In step 310 of this subroutine S2, for example, the total sheet 1a of the total sheet 1 as shown in FIG. 9 is read by the image input section 19 such as an image scanner, and the read information is stored in the read information memory 20, and Write to the output memory 21. Accordingly, a total table 1a as shown in FIG. 9 is displayed as an image on the display surface of the LCD display 23. Then, the process exits from the subroutine S2.

Next, the subroutine S3 will be described with reference to FIG.

In this subroutine S3, the information of the table 1a of the existing table sheet 1 as shown in FIG. 9 is set in the printer and read by the position beam 9 and the position beam drive and bar code reading section 14 as shown in FIG. The operation is performed.

First, at step 410, the paper size is set. For example, the user specifies the paper size by inputting from the keyboard 16 (designation of A4 or B5).

In step 415, a total sheet setting operation is performed. Then, control goes to step 420.

That is, as shown in FIG. 1, the balance sheet 1 shown in FIG.
Is operated by operating a y-direction key (not shown).
Is driven by a drive circuit 15 to rotate the rubber roller 2, and an x-direction key of a keyboard 16 (not shown) is operated to drive the x-direction motor 4 by the drive circuit 15 to rotate the pulley 5 to rotate the position beam 9. To move.

Then, the position beam 9 on the balance sheet 1
Is set to overlap the ruled line starting point c on the left side of the total table 1a shown in FIG.

After that, the x-direction key is operated to drive the x-direction motor 4 by the drive circuit 15 to rotate the pulley 5 so that the position beam 9 overlaps the right end point d of the table 1a.

In step 420, it is determined whether or not the level is horizontal. If "YES", the flow shifts to step 425, where "N"
If "O", the process returns to step 415 again.

That is, when the position beam spot does not overlap the end point d on the right side of the table 1a, a message indicating that the table sheet 1 is not set horizontally is displayed on the LCD display 23, for example.

At step 425, one line is read horizontally from left to right. Then, control goes to a step 430.

That is, the x-direction motor 4 is moved by driving the drive circuit 15 so that the spot of the position beam 9 overlaps the start point c shown in FIG. 9, and the position beam is automatically or manually moved from the start point c. Move 9 to the right.

In the case of manual operation, up and down cursor keys (not shown) on the keyboard 16 are used as y-direction keys.
Left and right cursor keys (not shown) on the keyboard 16 are x-direction keys, and the operation of these keys drives the rubber roller 2 and the position beam 9.

Then, from the position beam 9,
If there is a ruled line, a signal of low level "0" is supplied to the position beam drive and bar code reading unit 14,
If there is no ruled line, a signal of high level “1” is supplied to the position beam drive and bar code reading unit 14.

The ruled line information from the position beam drive and bar code reading unit 14 is supplied to the read information memory 20 via the bus 11 and written into the read information memory 20.

In parallel with the scanning operation, the x-coordinate detection circuit 17 obtains x-coordinate data by counting the pulses from the x-direction motor 4 and stores the data in the work RAM 13, for example.

At step 430, it is determined whether or not it is an x dot. If "YES", the flow shifts to step 435, where "N"
If "O", the process returns to step 425.

That is, it is determined whether or not a predetermined number of dots in the x direction has been reached.

In step 435, 1 is added to the y coordinate to start a line feed. Then, control goes to a step 440. This y-coordinate data is stored in, for example, the work RAM 13.

That is, the Y-direction motor 3
To rotate the rubber roller 2 by one step (for example, by one dot).

At the same time, the y-coordinate detection circuit 18 obtains y-coordinate data by counting the pulses from the y-direction motor 3, and stores this in the work RAM 13.

At step 440, one line is read horizontally from right to left. Then, control goes to a step 430.

That is, the position beam is moved by driving the driving circuit 15 of the x-direction motor 4 so that the spot of the position beam 9 overlaps the end point d shown in FIG. 9 is moved to the left.

Thus, from the position beam 9,
If there is a ruled line, a signal of low level "0" is supplied to the position beam drive and bar code reading unit 14,
If there is no ruled line, a signal of high level “1” is supplied to the position beam drive and bar code reading unit 14.

The ruled line information from the position beam drive and bar code reading unit 14 is supplied to the read information memory 20 via the bus 11 and written into the read information memory 20.

In parallel with the scanning operation, the x-coordinate detection circuit 17 obtains x-coordinate data by counting the pulses from the x-direction motor 4 and stores the data in the work RAM 13, for example.

At step 445, it is determined whether or not it is an x dot. If "YES", the flow shifts to step 450, where "N"
If "O", the process returns to step 425.

That is, it is determined whether or not a predetermined number of dots in the x direction has been reached.

At step 450, 1 is added to the y coordinate to start a line feed. Then, control goes to a step 455. This y-coordinate data is stored in, for example, the work RAM 13.

That is, the y-direction motor 3
To rotate the rubber roller 2 by one step (for example, by one dot).

In parallel with this operation, the y-coordinate detection circuit 1
8 obtains y-coordinate data by counting the pulses from the y-direction motor 3 and stores it in, for example, the work RAM 13.

In step 455, it is determined whether or not the prescribed number of dots matches the numerical value of the y coordinate data. If "YES", the process exits from the subroutine S3. If "NO", the process returns to step 425 again.

That is, it is determined whether or not the number of dots in the vertical direction is the same as the value of the y coordinate. Then, similarly, as shown in FIG.
The ruled line a is scanned in the direction of i in units of dots h to obtain ruled line information.

As shown in FIG. 1, the read total table data is converted into coordinate information by a total table / coordinate conversion unit 10a which is one of the functions of the CPU 10.

Now, such subroutines S1 to S3
After that, the process proceeds to step 150 of the flowchart as the main routine shown in FIG.

In this example, each of the above-described subroutines S
The ruled line information obtained in 1 to S3 is converted into a barcode, and the barcode information is printed, for example, on the upper part of the schedule.

In this way, the bar code printed on the balance sheet 1 is read by the position beam 9 and the position beam drive and bar code reading unit 14 of the printer, and the read bar code information is replaced with the original ruled line information. Is displayed on the LCD display 23, for example, as an image of a total table, and after inputting data with the keyboard 16 in the frame formed by the ruled lines of the total table, the data is displayed in the frame of the total table 1a set in the printer. The data input on the display surface can be printed accurately.

FIG. 10 shows a spreadsheet 1 on which the information of the spreadsheet 1a is printed as a barcode.

As described above, if the ruled line information of the total table 1a is converted into a barcode bc in the barcode display area e and printed, the information can be read by a word processor equipped with a printer to set a troublesome margin. The data is not printed out of the frame for each item in the total table 1a.

Further, as shown in FIG. 10, the start point of the left corner of the total table 1a is read so that the bar code bc can be read accurately and the data can be accurately printed in the frame for each item of the total table 1a. After the spot of the position beam 9 is adjusted to the position c, the position beam 9 is automatically moved (integrated with the head and the ribbon 8) by, for example, pressing a return key (not shown) from the keyboard 16 or the like. As shown in FIG. 10, the starting point c
You may make it confirm whether there is a line from to the end point d.

In the case of manual operation, the position of the position beam 9 is adjusted to the starting point c in the same manner as described above.
By operating the x-direction key described above, the position beam 9 may be moved to the end point d to detect whether or not there are continuous lines.

However, as described above, if the ruled line information in the x and y directions is simply converted into a bar code and printed, the information other than the ruled lines is also included. Thus, the information amount of the barcode bc becomes large.

Therefore, in the present embodiment, the ruled line information is not simply converted into a bar code, but the information obtained by compressing the ruled line information including information other than the ruled line is converted into a bar code.

That is, the total table 1a is divided into regions, and a bar code is formed for each of the divided regions. As an auxiliary means, information on only the ruled lines in the x direction and the y direction is obtained for each divided region.

Hereinafter, this will be described with reference to the flowchart of FIG.

In step 150, the totalized table data is compressed and written into the memory. Then, control goes to a step 160.

In step 160, two points are selected for the outer frame of the total table and the values with the highest number of appearances of the x and y coordinates. Then, control goes to a step 170.

This will be described with reference to FIG. FIG. 7A shows the balance sheet 1 on which the total table 1a is printed.
Line symbols indicating the presence / absence of a line in the x direction and the presence / absence of a line in the y direction of the total sheet 1a of the total sheet 1 are shown.

First, as shown in step 160, as shown at the top of the total table 1a, only the ruled line information in the vertical direction of this total table 1a is extracted.

As shown in FIG. 10, for example, the outer frame of the total table 1a (the left and right binding ruled lines of the total table 1a) and the ruled line information extracted for the position where the number of appearances of the x coordinate is large are as follows. Make it thicker than the line symbols of other ruled line information.

On the other hand, similarly, as shown in step 160, as shown on the left side of the total table 1a, only the horizontal ruled line information of this total table 1a is extracted.

As shown in FIG. 10, for example, the outer frame of the total table 1a (the left and right binding ruled lines of the total table 1a) and the ruled line information extracted for the position where the number of appearances of the y coordinate is large are as follows. Make it thicker than the line symbols of other ruled line information.

These pieces of information are stored, for example, in the work RAM 13.

By this processing, the total table 1a is divided into regions z1 to z9 by thick line symbols as shown in FIG. 7B.

At step 170, the x-coordinate data is converted into a bar code and printed at a predetermined position together with a line symbol. Then, control goes to a step 180.

In step 180, the y-coordinate data is converted into a bar code and printed at a predetermined position together with a line symbol. And it ends.

The process of converting the coordinate data into a barcode is performed by a coordinate / barcode conversion unit 10b which is one of the functions of the CPU 10.

That is, compression information is obtained for the line symbol obtained in step 160, ie, the x coordinate data.

This compression method is performed as follows.

For example, the region z1 (the x direction is the second thick line from the first thick line from the upper left of the total table 1a, and the y direction is the second thick line from the first thick line from the upper left of the total table 1a 7A, there are four line symbols indicating the x coordinate and four line symbols indicating the y coordinate.

At the top of the line symbol indicating the y coordinate (the smallest value in this area), the ruled line is present in the x direction in the entire area.

Therefore, the ruled line is set to "14" on the x coordinate of the y coordinate indicated by the top line symbol.

"1" of "14" indicates the position of the uppermost line symbol (y coordinate) and the leftmost line symbol (x coordinate), and "4" indicates the position of this line symbol (x coordinate). The ruled line is drawn up to the fourth line symbol including the indicated line symbol.

Similarly, in the area z1, in the second line symbol from the top indicating the y coordinate (the second smallest value in this area), the ruled line is one line from the leftmost line symbol in the x direction. The rightmost line symbol (in this area z1) is drawn.

Therefore, the ruled line on the x coordinate at the y coordinate indicated by the second line symbol from the top is set to “14”.

Similarly, in the third line symbol indicating the y coordinate (the third smallest value in this area),
A ruled line is drawn from the leftmost line symbol in the x direction to the rightmost line symbol (in this area z1).

Therefore, the ruled line on the x coordinate at the y coordinate indicated by the third line symbol from the top is set to “14”.

Similarly, at the fourth line symbol indicating the y coordinate (the fourth smallest value in this area)
Ruled lines are drawn from the second line symbol from the left in the x direction to the rightmost line symbol (in this area z1).

Accordingly, the ruled line on the x coordinate at the y coordinate indicated by the fourth line symbol from the top is set to “24”.

That is, the x-axis ruled line information of the area z1 is "14, 14, 14, 24".

The y-axis of the area z1 is as follows.

First, in the leftmost line symbol indicating the x coordinate (the smallest value in this region z1), the fourth line symbol from the top line symbol indicating the y coordinate (the lowest in this region) A ruled line is drawn up to the line symbol.

Therefore, the ruled line on the y coordinate at the x coordinate indicated by the leftmost line symbol is set to “14”.

Next, in the second line symbol from the left indicating the x coordinate (the second smallest value in this region), the fourth line symbol indicating the y coordinate is the fourth (from this region) A ruled line is drawn up to the line symbol (bottom).

Therefore, the ruled line on the y-coordinate at the x-coordinate indicated by the second line symbol from the left is “14”.

Next, in the third line symbol from the left indicating the x coordinate (the third smallest value in this region), the fourth from the third line symbol from the top indicating the y coordinate (one in this region) A ruled line is drawn up to the line symbol (bottom).

Accordingly, the ruled line on the y-coordinate at the x-coordinate indicated by the third line symbol from the left is “34”.

Next, the fourth line symbol from the left indicating the x coordinate (the end point in this area, which has the largest value) is the fourth from the top line symbol indicating the y coordinate (in this area). There is no ruled line up to the line symbol at the bottom).

Therefore, for the ruled line on the y-coordinate of the x-coordinate indicated by the fourth line symbol from the left, for example, “00”
Or "11" or "44" is a value indicating that no ruled line is drawn.

That is, "14, 14, 34, 00 or 11 or 44" is used as the ruled line information on the y-axis of the area z1.
Becomes

In this manner, similarly, in this example, numerical values are obtained for the x- and y-axis ruled line information in the regions z2 to z9.

Then, the numerical value of each area is converted into bar code information.

For the bar code, the well-known ITF (I
interleaved Format), so-called “2
of 5 "or CODE39.

The information in which the ruled line information in the x-axis direction and the ruled line information in the y-axis direction are converted into line symbols and the bar-coded information of the ruled line information are printed as shown in FIG.

That is, as shown in FIG. 8, a line symbol as x-coordinate data is printed on the x-coordinate data print area e1 at the top of the total table 1a of the balance sheet 1, and a line symbol as y-coordinate data is printed. For example, it is compressed by 70% (depending on the vertical and horizontal relations of the table), printed on the y-coordinate data print area e2 at the top of the table 1a of the table sheet 1, and the bar as the x-axis ruled line information is printed. The code is printed on the x-axis barcode printing area e3 at the top of the total sheet 1a of the total sheet 1, and the barcode as the ruled line information of the y-axis is printed at the top of the total table 1a of the total sheet 1. Printing is performed in the area e4.

In this way, the total table 1a of the total sheet 1 on which the barcode and the coordinate data are printed is used as shown in the flowchart of FIG.

Hereinafter, the subroutine S4 will be described with reference to the flowchart of FIG.

This subroutine S4 is a routine for accurately printing data input from the keyboard 16 on the total sheet 1a of the total sheet 1 on which the barcode and coordinate data are printed, in a frame for each item.

At step 510, the setting operation of the total sheet 1 is performed. Then, control goes to a step 515.

That is, the meter cover sheet 1 as shown in FIG. 8 is set in the printer, and in the case of manual operation, the y-direction motor 3 is driven by the drive circuit 15 by operating the y-direction key (not shown) of the keyboard 16, for example. Then, the rubber roller 2 is rotated, and the x-direction key of the keyboard 16 (not shown) is operated to drive the x-direction motor 4 by the drive circuit 15 to rotate the pulley 5 to move the position beam 9.

The position beam 9 on the balance sheet 1
Is made to overlap the reference point a on the left side of the table 1a shown in FIG.

After that, the x-direction key is operated to drive the x-direction motor 4 by the drive circuit 15 to rotate the pulley 5 so that the position beam 9 overlaps the reference point b on the right side.

At step 515, it is determined whether or not the screen is horizontal. If "YES", the flow shifts to step 520, where "N"
If "O", the process returns to step 510 again.

That is, if the position beam spot does not overlap the reference point b on the right side of the spreadsheet 1, for example, LC
A message or the like is displayed on the D display 23 indicating that the balance sheet 1 is not set horizontally.

On the other hand, in the case of performing the automatic operation, the spot of the position beam 9 is made to overlap the reference point a on the left side of the spreadsheet 1 as described above, and then, for example, the return key of the keyboard 16 not shown is pressed. Press.

Thus, under the control of the CPU 10, the x-direction motor 4 is driven via the drive circuit 15, and the position beam 9 moves to the right in the state shown in FIG.

At the same time, an electric signal indicating light receiving information by the position beam 9 is supplied to the position beam drive and bar code reading unit 14, and coordinate data from the x coordinate detection circuit 17 is supplied to the CPU 10,
Thereby, for example, it is determined whether or not the number of dots in the horizontal direction is equal to or greater than a specified value and whether or not the reference point b is detected.

If detected, the CPU 10 determines that the CPU 10 is horizontal as shown in step 515, and if not, determines that the CPU 10 is not horizontal. For example, in this case, an error message or the like is displayed on the LCD display 23. To be displayed.

At step 520, a bar code is read. Then, control goes to a step 525.

That is, the y-direction motor is driven via the drive circuit 15 so that the spot of the position beam 9 is located at the leftmost position of the x-coordinate data print area e1 by a predetermined dot below the position of the reference point a. Thereafter, the x-direction motor 4 is driven via the drive circuit 15 to move the position beam 9 to the right.

Thus, the x-coordinate data print area e1
Are read by the position beam drive and bar code reading unit 14.

Next, after the position of the position beam 9 reaches the rightmost position of the x-coordinate data printing area e1, the y-direction motor 3 is driven via the drive circuit 15 to drive a predetermined number of dots of the spreadsheet 1. The spot of the position beam 9 is positioned at the rightmost edge of the lower y-coordinate data print area e2.

Then, by driving the x-direction motor 4 via the drive circuit 15, the position beam 9 is moved to the left, and at the same time, the line symbol printed on the y-coordinate data print area e2 is shifted to the position. It is read by the beam drive and bar code reading unit 14.

Next, after the position of the position beam 9 reaches the leftmost position of the y-coordinate data print area e2, the y-direction motor 3 is driven via the drive circuit 15 so that the predetermined number of dots The spot of the position beam 9 is positioned at the leftmost edge of the lower x-axis barcode print area e3.

Thereafter, the x-axis motor 4 is driven via the drive circuit 15 to move the position beam 9 rightward, and at the same time, the x-axis bar printed on the x-axis bar code print area e3. The code is read by the position beam drive and bar code reading unit 14.

Next, after the position of the position beam 9 reaches the rightmost position of the x-axis barcode printing area e3, the y-direction motor 3 is driven via the drive circuit 15 so that the predetermined position on the balance sheet 1 is determined. The spot of the position beam 9 is positioned at the rightmost edge of the y-axis barcode printing area e4 divided by dots.

Thereafter, the x-direction motor 4 is driven via the drive circuit 15 so that the position beam 9 is
Is moved to the left, and at the same time, the y-axis barcode printed in the y-axis barcode print area e4 is read by the position beam drive and barcode reading unit 14.

At step 525, the bar code is converted into coordinates. Then, control goes to a step 530.

That is, the bar code read by the position beam drive and bar code reading unit 14 is
Coordinate / barcode converter 10 which is one of the functions of U10
b is converted into coordinate information.

At this time, the y coordinate data print area e
The entire line symbol printed on 2 is expanded, for example, to the length of the original information.

In step 530, data as an image of the total table 1a is obtained from the bar code as the coordinate information of x and y and the line symbol of the x and y coordinate data. Write to the output memory 21. Then, control goes to a step 535.

At step 535, the data in the display memory is output. Then, control goes to a step 540.

That is, the table data written in the image output memory 21 is read, and the read table data is supplied to the LCD display 23 via the bus 11 and the LCD drive circuit 22, and the table 1a is displayed on its display surface. Is displayed as an image.

At step 540, an input from the keyboard 16 is accepted. Then, control goes to a step 545.

That is, here, the user can use the keyboard 16 to input desired data into the frame for each item formed by the ruled line of the table 1a displayed on the LCD display 23. As a result, the data input by the user is written at a predetermined position in the image output memory 21.

Step 545 displays keyboard input characters. Then, control goes to a step 550.

That is, the characters input by the user through the keyboard 16 are displayed in the frame for each item formed by the ruled lines of the total table 1a displayed on the LCD display 23.

When the return key or the like is pressed after inputting one item with the keyboard 16, the cursor may be moved to the frame where the next item is input.

In step 550, it is determined whether or not printing is to be performed.
If “YES”, the flow shifts to step 555, and “NO”
If so, the process returns to step 540.

Here, the spot of the position beam 9 is positioned at the start point c of the left corner of the table 1a of the table 1 as shown in FIG. 8 by operating the x and y direction keys or automatically by the user. To

Further, the x-direction motor 4 is driven by the driving circuit 15.
, And the confirmation of the horizontal position and the alignment may be performed in the same manner as described above.

That is, when the user inputs data in the frame corresponding to all items, or when the user presses a key (not shown) indicating the end, for example, printing on the LCD display 23 is performed. Display whether or not to perform,
Here, when the user presses, for example, an execution key (not shown), the spot of the position beam 9 is positioned at the starting point c at the left corner of the total table 1a as described above, and thereafter, the image output memory Only the data inputted by the user from the keyboard 16 from the keyboard 21 or the image output memory 21 is temporarily stored in a print memory (not shown) of the printer.
Only the data entered by the user through the keyboard 16 is supplied to the data of the user, and the data is accurately specified within the frame for each item formed by the ruled line of the total table 1a of the total sheet 1 set on the printer as shown in FIG. Is printed.

As described above, in this example, an existing schedule is read as data using the position beam of the printer, or a schedule entered by the image input unit 19 or a schedule created by keyboard input is coded. Since it was printed on the balance sheet, for example, if there is only a balance sheet made in this way, just read the code, display the balance sheet on the display unit, enter the data with the keyboard, and then It is possible to print the data accurately within the frame of the table, and it is not necessary to save the data of the total table itself, so it is not only cost-effective but also widely and widely used by the general public. Can be provided.

In addition to the bar code, the total table is divided into regions and the bar code is printed together with the data of the x and y coordinates, so that the amount of information can be minimized.

FIGS. 12 to 14 show various usage examples.

FIG. 12 shows a case in which, for example, a bar code bc is printed in a bar code display area e below the totaling sheet 1. FIG. This shows a so-called total table data stock method in which data is printed as a bar code bc in a bar code display area e on the left side, respectively, in the total table.

FIG. 14 shows a stock of so-called illustration data obtained by converting the data of the illustration g corresponding to the illustration g as shown in FIG. It shows the method.

In both FIGS. 13 and 14, such data need not be recorded on a relatively expensive medium such as a floppy disk, so that the cost advantage is great. Can be widely applied to important information.

In the above-described example, the case where a barcode is used has been described. However, any code may be used as long as it is a readable code when coding the tabulation information.

In addition, the present invention is not limited to the above-described embodiments, and may take various other configurations without departing from the gist of the present invention.

[0189]

According to the present invention described above, the positions of the ruled lines in one and the other directions of the table information stored in the storage means are detected by the detection means, and the detection means detects the positions of the ruled lines in the one and other directions, respectively. The total table information is divided by the division processing means on the basis of the position of the detected ruled line, and one and the other ruled line information are encoded based on the division information from the division processing means and the length information from the detection means. So,
The length of the code information can be shortened, and the schedule information can be displayed on various media by various output devices. For example, when the schedule and the code are printed on paper, the total is printed on the paper. By reading the code, the table information is taken into the device, for example, the table information is displayed as an image on the screen of the monitor of the device, and the desired table information is displayed in the frame of the table displayed on the screen. After the data is input, there is an advantage that the input data can be easily printed in a predetermined frame of a paper table placed on the device and the like.

Further, according to the present invention described above, the positions of the ruled lines in one and the other directions of the table information stored in the storage means are detected by the detection means, and the positions of the ruled lines are detected in the one and other directions by the detection means. The total table information is divided by the division processing means based on the position of the ruled line, and one and the other ruled line information coded based on the division information from the division processing means and the length information from the detection means are converted. Means to convert the information into one and the other ruled line information, and create the table information based on the one and the other ruled line information and the division information from the conversion means. For example, the table and code are printed on paper. If this is the case, the code printed on this paper is read to capture the table information into the device, for example, the table information is displayed as an image on the screen of the monitor of this device, After inputting desired data in the frame of the schedule displayed above, it is easy to print the input data in a predetermined frame of the paper schedule placed on the device. There are benefits that can be.

According to the present invention described above, the positions of the ruled lines in one and the other directions of the table information stored in the storage means are detected by the detection means, and the detection means detects the positions of the ruled lines in the one and other directions, respectively. The total table information is divided by the division processing means based on the position of the ruled line, and one and the other ruled line information coded based on the division information from the division processing means and the length information from the detection means are divided. Since it was made to be printed together with the schedule, by reading the code printed on this paper, the schedule information was taken into the device, for example, the schedule information was displayed as an image on the screen of the monitor of this device, and this After inputting the desired data in the frame of the table displayed on the screen, it is easy to print the input data in the predetermined frame of the paper table placed on the device. To do It can be beneficial.

[Brief description of the drawings]

FIG. 1 is a block diagram for explaining an example of a word processor with a printer to which the present invention is applied.

FIG. 2 is a main flowchart for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 3 is a flowchart of a subroutine S1 for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 4 is a flowchart of a subroutine S2 for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 5 is a flowchart of a subroutine S3 for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 6 is a flowchart of a subroutine S4 for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 7 is an explanatory diagram for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 8 is an explanatory diagram for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 9 is an explanatory diagram for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 10 is an explanatory diagram provided for describing an example of a word processor with a printer to which the present invention is applied;

FIG. 11 is an explanatory diagram for describing an example of a word processor with a printer to which the present invention is applied;

FIG. 12 is an explanatory diagram for explaining an example of a word processor with a printer to which the present invention is applied;

FIG. 13 is an explanatory diagram for explaining another usage example of the word processor with a printer to which the present invention is applied;

FIG. 14 is an explanatory diagram for explaining another usage example of the word processor with a printer to which the present invention is applied;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Summary sheet 1a Summary table 2 Rubber roller 3 Y direction motor 4 X direction motor 5, 7 Pulley 6 Belt 8 Head and ribbon 9 Position beam 10 CPU 11 Bus 12 ROM 13 RAM 14 Position beam drive and bar code reading section 15 Drive circuit Reference Signs List 16 keyboard 17 x-coordinate detection circuit 18 y-coordinate detection circuit 19 image input unit 20 read information memory 21 image output memory 22 LCD drive circuit 23 LCD display

Continuation of the front page (58) Field surveyed (Int. Cl. ⁷ , DB name) B41J 21/16 B41J 3/01 B41J 21/00 B41J 29/26 G06F 19/00

Claims (3)

(57) [Claims] 1. Reading ruled line information from a total table on a total sheet
Reading means, a ruled line information storing means for storing the ruled line information, and a line symbol indicating a position interval on a vertical coordinate at which the vertical ruled line appears.
And a line symbol indicating a position interval on a horizontal coordinate at which the horizontal ruled line appears
And a second line symbol generation unit for generating the number of appearances of the vertical ruled line for each horizontal coordinate from the ruled line information.
Means for extracting vertical ruled lines, and the number of appearances of horizontal ruled lines for each vertical coordinate from the ruled line information.
The horizontal ruled line extracting means, and the total number based on the number of appearances of the vertical ruled line and the horizontal ruled line.
Area dividing means for dividing a table into a plurality of areas; and compressing data relating to vertical ruled line length information on a horizontal coordinate.
First compressed data generating means for generating based on the appearance position
And compressed data on the vertical ruled line
Second compressed data generating means for generating based on the appearance position
When, after being generated by the first and second compressed data generating means
A barcode converter that converts compressed data to barcodes
Encoding apparatus; and a stage. 2. Reading ruled line information from a total sheet on a total sheet
Reading step; A ruled line information storing step of storing the ruled line information; Line symbol indicating the position interval on the vertical coordinate where the vertical ruled line appeared
A first line symbol generation step of generating Line symbol indicating the position interval on the horizontal coordinate where the horizontal ruled line appeared
Generating a second line symbol; From the above ruled line information, the number of appearances of vertical ruled lines is obtained for each horizontal coordinate.
Vertical ruled line extraction step From the above ruled line information, the number of occurrences of horizontal ruled lines is obtained for each vertical coordinate.
Horizontal ruled line Tep, Based on the number of appearances of the vertical and horizontal lines, the total
An area dividing step of dividing the table into a plurality of areas; Compressed data on vertical ruled line length information
First compressed data generation step for generating based on the appearance position
And The compressed data related to the horizontal ruled line length information is
Second compressed data generation step for generating based on the appearance position
And Generated in the first and second compressed data generation steps.
Barcode conversion to convert the compressed data
Exchange step Barcode conversion method of total table information provided with: 3. A total table including a vertical ruled line and a horizontal ruled line, and a first line symbol indicating a vertical coordinate at which the vertical ruled line appears.
And a second line symbol indicating the horizontal coordinate at which the horizontal ruled line appears
And the number of occurrences of vertical ruled lines for each horizontal coordinate from the ruled line information.
Means for extracting vertical ruled lines, and the number of appearances of horizontal ruled lines for each vertical coordinate from the ruled line information.
Horizontal ruled line extracting means, and length information of the vertical ruled line based on the appearance position on the horizontal coordinate.
The first barcode represented by the compressed data generated and the length information of the horizontal ruled line are based on the appearance position on the vertical coordinate.
And a second barcode indicated by the generated compressed data.
Has a vertical coordinate having a large number of appearances among the first line symbols
The line symbol is displayed in bold, and indicates the horizontal coordinate having a large number of appearances among the second line symbols.
A spreadsheet characterized by a thick line symbol .