JPS62248064A - Calculating method for business form - Google Patents

Abstract

PURPOSE:To optionally lay out a layout of a business form, and to execute a calculation of each optional cell and a calculation of plural business forms, by holding text information, and table information in the business form by two independent formats, and managing it by an overlay managing part. CONSTITUTION:A main memory 2 is connected to a CPU 1 of a business form calculating device, and an image memory 4 in which ruled line information has been stored in advance through a system bus 3, and an image memory 5 in which table generating and calculating information has been stored in advance are connected to the main memory 2. Also, a scanner 30, a keyboard 9, a laser beam printer 31, etc., are connected through an image bus 7. In this state, a ruled line of an optional business form is laid out by a scanner 30 and displayed on a display 8. Subsequently, based on a program of a table generating and table calculating part 24 of the memory 2, the data from the board 9 and an editing command from a mouse 10 are analyzed, and a ruled line which has been read in advance, the data of a business form and a sentence are superposed by an overlay managing part 26, and brought to a boundary adjustment by a boundary adjusting part 25.

Description

DETAILED DESCRIPTION OF THE INVENTION Field of the Invention The present invention relates to a form calculation method that allows ruled lines to be laid out at any location and forms that can be edited and calculated.

Conventional technology When setting screen frames in conventional form calculations,
Frames and ruled lines for any display screen were set in advance, and the screen frames and ruled lines were output after the input data was calculated, edited, and printed. In this case, there was no function to freely specify the layout of the form or any cell, enter data or characters across several rows within a single cell, and edit or calculate the data.

Additionally, some conventional word processors have the ability to set boundaries and draw ruled lines along those boundaries for editing and calculations, but they do not have the ability to freely draw ruled lines at any specified location. It wasn't.

Furthermore, conventional form calculation methods do not allow aggregation of data from multiple worksheets.

Problems to be Solved by the Invention As described above, in the conventional form calculation method, it is not possible to arbitrarily set a screen frame, or to edit or calculate functions within a specified cell, Calculations between were limited.

The present invention has been made in view of the above-mentioned problems, and it is possible to set an arbitrary screen frame without drawing ruled lines or frames along the boundaries guided on the display screen, and it is possible to set a form on one screen. The purpose of the present invention is to provide a form calculation method that can perform calculations using a mixture of two characters and graphs.

Means for Solving the Problems In order to achieve the above object, the present invention stores text information such as character formulas and table information in a form (data structure in a table) in two independent formats. It also includes an overlay management section that overlays text on the ruled lines of the form.

Function: The text information and two table information which are held independently are superimposed in an arbitrary state by the overlay management section.

Embodiment FIG. 1 is a block diagram showing a form calculation device to which a form calculation method according to an embodiment of the present invention is applied.

This form calculation device includes a CPU, a main memory 2 connected to the CPUI, an image memory 4 which stores ruled line information in advance, and which is connected to the main memory 2 via a system bus 3. An image memory 5 that stores creation and geocalculation information in advance, and a scanner 3
0. A control circuit 6 that controls a laser beam printer (hereinafter referred to as LBP) 31, a display 8 connected to these image memories 4 and 5° control circuit 6 via an image bus 7, a keyboard (KB) 9, and a mouse 10. , a scanner 30 connected to the image bus 7, and a printer 31.
It is equipped with

The main memory 2 includes a table creation/spreadsheet calculation unit 24 consisting of a ruled line recognition unit 21 equipped with a ruled line recognition program, a table creation unit 221 and a spreadsheet calculation unit 23 each having a table creation function 2 and a spreadsheet function.
, a boundary adjustment unit 25 that adjusts boundaries, a ruled line recognition unit 21, a table creation/spreadsheet calculation unit 24. The overlay management section 26 is connected to the boundary adjustment section 25 and superimposes ruled lines and form data.

Part 2 about the form calculation method in this form calculation device.
This will be explained with reference to the flowchart shown in the figure.

First, the scanner 30 arbitrarily lays out the ruled lines of the form (hereinafter referred to as ST) (step 1), the ruled line recognition routine recognizes the image of the ruled lines (5T2), and displays this on the display 8 (see Fig. 3). a) #sho).

Next, data input from the keyboard 9 and editing commands from the mouse 10 are analyzed by a table creation routine and a spreadsheet routine based on the program of the table creation/spreadsheet calculation unit 24 (ST3° ST4, FIG. b) see)
. Then, the previously read ruled lines and the data/text of the form (not limited to data/text) are superimposed by the overlay routine of the overlay management unit 26 (ST5
．． (See Figure 3(c)). After this, the boundary adjustment section 2
The boundary is adjusted by 5 (STY). Then, the overlaid ruled lines and data/text are further edited and recalculated between cells within the ruled lines by a table creation/spreadsheet calculation routine (ST7).

This result is output by LBP31 (ST8)
.

FIGS. 4 and 5 are conceptual diagrams and flowcharts showing other embodiments of the present invention. In this embodiment, data on a plurality of worksheets 41 are mutually aggregated.

First, select multiple worksheets 41 that you want to aggregate from the files of worksheet 41, and
1 data is read (S T 61).

Next, a portion of data to be aggregated is specified from the data on the worksheet 41 and linked (ST62).

Then, the data of the plurality of worksheets 41 are superimposed by the overlay routine of the overlay management section 26 (ST
63). This makes it possible to perform so-called skew calculation in which multiple pieces of data on multiple worksheets are aggregated.

Further, after the overlay is executed, spreadsheet calculation and table editing are executed again, and the results are displayed on the display 8 (ST64, 5T65).

Effects of the Invention As is clear from the above explanation, the present invention retains text information and table information in a form in two independent formats, and manages these in an overlay management section. , you can arbitrarily lay out the ruled lines of a form, overlay text on the ruled lines, and perform calculations between arbitrary cells and data aggregation for multiple forms.

[Brief explanation of drawings]

Fig. 1 is a block diagram showing a form calculation device to which a form calculation method according to an embodiment of the present invention is applied, Fig. 2 is a flowchart showing an example of the operation of the device, and Fig. 3 is a screen transition of the display of the device. FIG. 4 is a conceptual diagram showing a worksheet to which another embodiment of the present invention is applied, and FIG. 5 is a flowchart showing a form calculation method using the same worksheet. 2... Main memory, 4, 5... Image memory, 21... Ruled line recognition unit, 22...
・Table creation section, 23... Spreadsheet section, 24...
...Table creation/spreadsheet calculation section, 25...Handary adjustment section, 26...Overlay management section. Name of agent: Patent attorney Toshio Nakao and 1 other person M
l Figure 2 'If 3 v! ILQ)

Claims (1)

[Claims] Ruled line information and table creation/spreadsheet information are each stored separately in memory in advance, and the stored ruled line information and table creation/spreadsheet information are superimposed by the overlay management unit, and any cell within the formed ruled line is created. A form calculation method that uses cells as targets for editing and calculations, and performs calculations that span multiple cells.