JPH0245216B2 - - Google Patents

Description

Detailed Description of the Invention [Field of Industrial Application] The present invention relates to page switching control regarding card calculation items in a data processing device having a card image processing function. This invention relates to a calculation control method by switching card pages, in which a card item located at a relative page position can be specified and embedded as an operational term in a calculation formula.

[Conventional technology]

Conventionally, in general office processing, it has been widely adopted to store information in card format and use it. It is desirable to be able to do this. However, when trying to manage card data using a regular Japanese word processor, etc., the format information of the card, including ruled lines and fixed characters, and the card data, which differs for each individual card, are not distinguished. Since the information is stored in an integrated form, not only is the storage area wasted, but it is also impossible to perform various processes such as search processing and calculation processing regarding the entry fields of the card. Therefore, the present inventors have developed a data processing device that manages common form data and individual card data separately and has card image processing functions such as document processing functions, table creation functions, calculation processing functions, and procedure registration functions. is proposed.

In the data processing device having the above-mentioned card image processing function, a format consisting of fixed information common to cards is first defined by creating a format image of the card on the screen using character keys, etc., and subsequent card creation In this case, data of a predefined format image is called up, and variation data for each card is entered in fields defined by this format to create individual cards. Each card is managed so that one card corresponds to one page. Numerical calculations are now possible for numerical fields specified in the format by providing calculation formulas while looking at the screen. Additionally, a series of processing procedures including calculation formulas can be registered and called up and executed at any time.

[Problem that the invention seeks to solve]

By the way, it is desirable that the numerical calculation described above can be specified not only for fields within one card but also for fields spanning multiple cards. In that case, it is necessary to specify the page by some means. However, in the past, it was possible to specify absolute page numbers and give calculation formulas, but page switching was specified based on the currently displayed page, and items on relative pages from the current page were specified. It was not possible to freely select it and easily embed it in a calculation formula to make it an operational term. Therefore, especially when registering calculation formulas, the number of cards is generally not determined at the time of registration, so there is a problem in that it is not possible to freely specify, for example, a field n pages before the last page.

[Means for solving problems]

The present invention aims to solve the above-mentioned problems, and includes the following means in order to freely switch pages when specifying and executing a calculation formula, and to specify a field and retrieve its contents. There is. That is,
The calculation control method using card page switching according to the present invention is as follows:
A display, a format information storage unit that stores format information of cards including ruled lines or fixed characters, a field definition information storage unit that stores definition information regarding entry fields of cards, and contents entered in entry fields of individual cards. and a card data storage section for storing the format information storage section, and merge the contents of the form information storage section and the card data storage section on the display screen based on the contents of the field definition information storage section to create a format buffer. A data processing device having a card image processing function that generates and displays a card image in correspondence with a page, specifies each field on the card image to give a processing mode, and processes the card contents. A calculation control method using card page switching, comprising: an input means for inputting a calculation formula for the entry field; a procedure execution means for executing a procedure including the calculation formula input by the input means; Means for displaying and storing a predetermined page indicator indicating the relative page position of the card image with respect to the current page in combination with a field name when inputting a calculation formula; means for controlling page switching to the page indicated by the page indicator based on combination information of the indicator and the field name, and specifying page switching in the calculation formula based on the current page. It is characterized by doing. Hereinafter, embodiments will be described with reference to the drawings.

〔Example〕

FIG. 1 is a block diagram of the essential parts of an embodiment of the present invention, FIGS. 2 and 3 are diagrams for explaining the concept of card images and boxes related to the present invention, and FIGS. 4 and 5 are FIG. 6 is a diagram for explaining processing aspects related to the present invention. FIG. 6 is an overall outline diagram of an embodiment to which the present invention is applied. FIG. 7 is an explanatory diagram of information stored in the field definition information storage unit. Figure 8 is a diagram for explaining the correspondence between format buffers and screen code buffers, Figures 9 and 10 are diagrams for explaining calculation processing mode by page switching in an embodiment of the present invention, and Figure 11 is a diagram for explaining the calculation processing mode by page switching in an embodiment of the present invention. 1 is a diagram illustrating a processing overview of an embodiment of the present invention.

In the case of a data processing device having a card image processing function related to the present invention, a card image having a predetermined card format is displayed on a display and processing is executed. That is, for each card image, format data as shown in Figure 2, for example, and field contents (card data) given corresponding to fields (items) such as "product name" on the format image are separated. Both data are memorized separately, and both data are merged and displayed on the display as necessary. And it is considered to represent one card.

The fields on the card image include a character field and a numeric field. Then, on the form data, "..." is given to indicate the character insertion point corresponding to the character field,
Corresponding to the numeric field, "," is given to indicate where to insert the numeric value.

For example, as shown in Figure 2, if fields such as "Product Name", "Quantity", "Unit Price", and "Amount" are consecutive, specify only the first field group and have the same attributes. For the field sequence part, you only need to specify the repetition of the first field group. Such a repetition of a group of fields, as opposed to a single independent field, is called a "table". Of course, procedures such as entering, editing, calculating, and searching data in fields included in a table can be performed in the same way as for independent fields, but for fields with common attributes in a table, It is now possible to perform batch processing.

Since there are generally many cards that share the format data shown in Figure 2, the card images corresponding to these cards are collected and managed by introducing the concept of "box" as shown in Figure 3. . Reference numeral 1 represents a card image, and reference numeral 2 represents a box. In order to manage boxes as a single processing unit, the following information (or storage unit) is prepared corresponding to each box. That is, (i) Box management information (storage unit): profile information such as box number and box name.

(ii) Format data (storage unit)...Data corresponding to the card format (blank card) as shown in Figure 2.

(iii) Field definition information (storage part)...Field start coordinates and attributes (number of digits, number of lines, etc.) for each field.

(iv) Card data (storage unit): Contents of each field corresponding to each card image belonging to the same box, each associated with a page.

FIG. 4 shows an example of the manner in which processing is performed in this embodiment, and it may be considered that the display as shown in the figure is displayed on the display and the processing begins. The screen on the display can simultaneously display a card image in the first frame, a card image in the second frame, and an input image when inputting a processing procedure or the like.

In the case shown in Figure 4, all or part 3 of the card image addressed to Mr. Fujitsu Taro on the 7th page belonging to the box ``Membership Fee Bill'' is placed in the first frame, and the card image 3 belonging to the box ``Membership Fee Deposit Slip'' is placed in the first frame. All or part 4 of the card image of Mr. "Taro Fujitsu" on the 7th page is displayed together in the second frame (split display). Then, input image 5 is displayed,
Instructs to transfer the contents of the second line of the "Billed Amount" field, which is a field on the card image in the second frame, to "Current Billed Amount", which is a field on the card image in the first frame. . In addition, for the display frames of the first frame and the second frame,
The frame in which the input image is displayed is called a procedure frame.

FIG. 5 shows a mode in which the same process is performed for multiple fields on multiple cards. In this example, the process "Quantity x Unit Price = Amount" is executed for items 1 to 30 of the card, from the 1st line to the 10th line of the product name, and the instruction is to calculate the total for each item. . These processing procedures can be registered and stored, and can also be called up and executed at any time. In addition, searching, sorting, card verification, etc. are also possible.

FIG. 6 shows a schematic configuration of an embodiment of a data processing device having a card image processing function related to the present invention.

In the figure, reference numeral 8 is a keyboard, 9 is a keyboard control section, and 10 is a card image processing section, which inputs information about the card, displays the card image on the display screen, and processes the contents of the fields on the card image. 11 is a form creation management section that inputs and manages the card image format corresponding to each box; 12 is a form analysis section that inputs fixed information, item attributes, etc. when creating a form. 13 is a card creation management unit that inputs and manages individual card data;
Reference numeral 14 is a data entry control unit which inputs card data, field names, etc. using a so-called kana-kanji conversion function, and 15 is a list control unit which controls display of a list of specific fields of the card. , 16 is a procedure registration control unit that performs control to register a processing procedure such as the input image shown in FIG. 5, 17 is a procedure storage unit that stores the registration processing procedure, and 18 is a procedure An execution control section 19 controls the execution of specified processing procedures, and a calculation control section 19 controls execution of calculations specified for numerical fields.

Further, 20 is a box management unit that selects a box to be processed for the time being and manages its data, 21 is a storage control unit that controls writing to the data storage device, and 22 is a call control unit. 23 is a page switching section that switches from one card's worth of data to the next card data; 25 is a section for controlling data such as a floppy disk device; Storage device, 26 is a box management information storage unit, 27 is a form data storage unit, 28
29 is a field definition information storage section, and 29 is a card data storage section. Box management information storage section 26
The form data storage section 27, field definition information storage section 28, etc. are stored and managed for each box.

31 is a format buffer from which the contents of the format data storage section 27 are read and card data is embedded thereon to generate a card image; 32 is a record buffer from which card data is read; 33 is a field definition. information battle,
34 is a list format buffer that corresponds to the format buffer 31 for the list; 35 is a list record buffer that corresponds to the record buffer 32 for the list; 36 is a list field definition. Represents information buffer.

Further, 40 is a window control unit that controls cutting out data from format buffers 31, 31', etc. according to predetermined display frame (window) information, and 41 is a screen code buffer that stores code information to be displayed on the display. what is done, 4
2 is a display control unit that controls displaying the contents of the screen code buffer 41 on the display; 43 is a display such as a CRT;
Reference numeral 44 represents a print control unit that controls outputting information regarding the card to a printer, and 45 represents a printer.

As explained in connection with Figure 3, the box is
It consists of an entire series of card images having common format data, and includes at least format data, field definition information, and individual card data. The format of each box is determined by the operator using the data entry control section 14 on the screen of the display 43.
It is created according to the results of entering characters etc. using the kana-kanji conversion function in . Form creation management department 1
1, the format analysis section 12 determines definition information and field names for each field, and the box management section 20 stores the results in the format data storage section 2.
7. Store in the field definition information storage unit 28 or the like.

The form data storage section 27 stores, for example, a form as shown in FIG. The field definition information storage unit 28 stores information 50 as shown in FIG. 7, for example.
have. That is, the field includes an independent item 50A and a table item 50B, and the number of items and each item attribute are stored as independent items. Further, as table items, vertical attributes (number of rows, each Y coordinate) and horizontal attributes (number of items, each item attribute) are stored.
Each of the item attributes described above includes information such as the record buffer address, the starting coordinates of the item within the card, the number of digits and lines, and the type of character field/numeric field.

The card creation management unit 13 stores the data entered in the form image determined by the form card and field definition information in the card data storage unit 29.
be stored and managed. For example, when calling a box to display a card image, the contents of the form data storage section 27 are loaded into the form buffer 31, the contents of the field definition information storage section 28 are read into the field definition information buffer 33, and then the The contents of the card data storage section 29 read into the buffer 32 are merged with the contents of the field definition information buffer 33 on the format buffer 31, and this is transferred to the screen code buffer 41.

As explained in connection with FIG. 4, a plurality of display frames can be provided on the display screen to display parts of a plurality of card images. That is,
As shown in FIG. 8, the window control unit 40 extracts data 51 and 51' that are requested to be displayed from the plural format buffers 31 and 31', respectively, according to the contents of the window control table 52, and stores them in the screen code buffer 41. Controls posting. Therefore, the window control table 52 holds information such as addresses and sizes of data 51 and the like in the format buffer 31 and the like.

The present invention primarily relates to the control of calculation specifications for cards displayed on a display screen in the manner described above.

FIGS. 9 and 10 show the designation of calculation formulas and the results of their execution in one embodiment of the present invention. In particular, FIG. 9 shows an example of specifying immediate execution of a calculation formula, and FIG. 10 shows an example of specifying execution of a calculation formula by procedure registration. In the figure, reference numeral 55 represents a card image displayed on the display screen.

In the case of the present invention, in order to express a calculation formula that spans different pages for card data, a page indicator is introduced that indicates the page position of the card where the item to be processed exists in the calculation formula, and a page indicator is introduced that indicates the page position of the card where the item to be processed exists. It is used for control during extraction. Examples of page indicators include the following:

"Next page" / "Previous page" / "Last page" / "Page 0001" / "Page +0006" / "Page -0010" / "Last page -0003
``page'', ``additional page'', ``current page''... The combination of this page indicator and field name becomes the calculation item name in the calculation formula, and the item name when calculating between pages is made more clear. That is, when you press a page switching key such as the "previous page" key or "next page" key while inputting a calculation formula, the above page indicator will be displayed in the title line, and the page indicator displayed at that time will be displayed by pressing the calculation instruction key. The item name, which is a combination of the page indicator and the field name where the cursor is located, is displayed in the procedure frame. Note that if the page indicator is omitted, the item on the current page is the target.

For example, if each page of the card has a field for total sales and a field for growth rate for each period, and you want to calculate the growth rate of the current period's total sales relative to the previous period's total sales, the Give the calculation formula.
This calculation formula can be easily created as follows.

First, press the "calculate" key while the card image of the current page (page 0005) is displayed. As a result, a procedure frame for specifying the calculation formula will be displayed at the bottom of the screen.

After entering the character "(", move the cursor to the total sales field and press the "-" key.

Next, use the "previous page" key to display page 0004, move the cursor to the total sales column, and select the characters ")".
Enter and press the "÷" key.

While keeping the cursor on the total sales field, select "%"
Press the key (same meaning as ×100=).

Next, use the "Next Page" key to return the display to the current page, and then
Move the cursor to the elongation rate column and press the "Execute" key.

Through the above operations, calculation formulas as shown in Figure 9 A will be displayed one after another in the procedure frame, and with the execution instruction, the calculation (1500-1000) ÷ 1000 x 100 = 50 will be performed. As shown in FIG. 9B, 50 (%) is substituted for the elongation rate of the current page. In addition to the above operations, calculation formulas may be directly included in the procedure frame.

The same applies to the case where a calculation formula is specified by procedure registration, and FIG. 10A shows the registration procedure, and FIG. 10B shows an example of the execution result. The total sales from page 0001 to the current page is substituted for the cumulative sales of the actual page. Then, "card repetition" is performed from page 0001 to the last page.

Note that the method of specifying calculation items is the same when registering procedures and when registering non-procedures.
Page switching control when inputting calculation formulas is different. In calculations during non-procedural registration, the page is actually changed by pressing the page change key, and the page indicator in the calculation formula is the actual page number displayed in the upper right corner or the next page from the current page. Expressed as previous page, last page, and additional pages. On the other hand, in the calculation formula when registering the procedure, the page indicator is a relative page from the current page (+XXXX page, -XXXX page,
next page, last page, additional page, last page - page XXXX, etc.).

FIG. 1 shows the configuration of main parts for realizing the processing explained in FIGS. 9 and 10.
In the figure, the same symbols as in Fig. 6 correspond to Fig. 6,
60 is a calculation instruction control unit, 61 is a calculation execution control unit,
62 is a calculation procedure creation unit, 63 is a field information extraction control unit, 64 is a field name extraction control unit, 65
66 is a buffer section, 67 is a field name buffer, and 68 is a relative page switching control section.

When the "calculation" key is pressed during card creation, the calculation control section 19 is activated from the card creation management section 13, and the calculation control section 19 activates the calculation instruction control section 60 to input a calculation formula. The calculation instruction control unit 60
Determine the operand from the page indicator and field name,
An input image such as that shown in FIG. 9A or FIG. 10A is displayed in the procedure frame to instruct calculation contents. When the page switching key is input while inputting a calculation formula, the relative page switching control section 68 processes a page relative to the current page.

The relative page switching control unit 68 is the calculation instruction control unit 60
It is started by , and manages page information in calculation formulas. It notifies the calculation instruction control unit 60 of relative page information, starts the page switching control unit 65 to read new card data, and displays the new page number in the title line.

The calculation execution control unit 61 is activated when a calculation formula is input and the "execute" key is pressed, or when a calculation formula appears during the execution process of the registration procedure, and controls the execution of calculations using the calculation formula. It is. During execution, the page switching control unit 65 is controlled according to instructions by the page indicator, and if necessary, the card data stored in the data storage device 25 is read out to the record buffer 32, and field information is extracted. Based on the information regarding the field notified from the control unit 63, the value of each operational term is determined. Similarly, the calculation results are stored in designated fields by switching pages as necessary.

When a procedure registration instruction is received from the keyboard 8, the calculation procedure creation section 62 is activated by the procedure registration control section 16. The calculation procedure creation unit 62 secures an area for the procedure storage unit 17 in the buffer unit 66,
It is used to create processing procedures. When the “calculation” key is pressed during procedure registration, the calculation instruction control unit 60
Now you can register the calculation. The calculation formula instructed by the calculation instruction control section 60 is stored in the procedure storage section 17 and registered in the data storage device 25 along with other procedures and the like. This registration procedure can be executed at any time by pressing the "work selection" key to instruct execution of the procedure. When a calculation formula appears during the execution of a procedure, it is executed by the calculation execution control unit 61.

FIG. 11 shows an outline of the processing of the embodiment shown in FIG. Designation of calculation formulas between different pages is mainly controlled by a calculation instruction control section 60 and a relative page switching control section 68 related to screen control. For example, when the "calculation" key is pressed during card creation or procedure registration, the calculation instruction control section 60 requests the relative page switching control section 68 to initialize page information.
The relative page switching control unit 68 clears the relative page information and sets the currently displayed page number as the initial page.

Next, the calculation instruction control section 60 requests the keyboard control section 9 to read data from the keyboard. If there is a key input and it is a page switching key, control is passed to the relative page switching control section 68. The relative page switching control unit 68 updates the relative page information and controls page switching to a page determined by the initial page information and the relative page information.
A request is made to the page switching control unit 65. Page switching control section 65
If a card is being created, the call control section 22 reads the card data of the target page from the data storage device 25 onto the record buffer 32, merges it onto the format buffer 31, and displays it. If the procedure is being registered, the card data may not be prepared yet, so actual page switching is not performed. The relative page switching control unit 68 displays new relative page information in the title line of the display frame.

If the information read from the keyboard 8 is an item specification, that is, an operation symbol, etc., the calculation instruction control unit 60 obtains the target field name by calling the field name extraction control unit 64 based on the cursor coordinates at that time. Then, it is combined with the image of the current relative page and displayed as the item name of the calculation. If procedure registration is necessary, control is performed to transfer it to the procedure storage section 17.

As described above, since page switching control is performed by combining a page indicator and a field name, calculation formulas that span different pages can be easily specified.

〔Effect of the invention〕

As explained above, according to the present invention, in calculation control in card image processing, it is possible to specify a calculation formula that specifies page switching based on the current page, and by registering a procedure, it is possible to specify a calculation formula that specifies page switching based on the current page. Since it is possible to specify a card item at a certain page position and embed it in the calculation formula, the degree of freedom in specifying the calculation formula is increased and the creation of the calculation formula is also facilitated.

[Brief explanation of drawings]

FIG. 1 is a block diagram of the essential parts of an embodiment of the present invention, FIGS. 2 and 3 are diagrams for explaining the concept of card images and boxes related to the present invention, and FIGS. 4 and 5 are FIG. 6 is a diagram for explaining processing aspects related to the present invention. FIG. 6 is an overall outline diagram of an embodiment to which the present invention is applied. FIG. 7 is an explanatory diagram of information stored in the field definition information storage unit. Figure 8 is a diagram for explaining the correspondence between format buffers and screen code buffers, Figures 9 and 10 are diagrams for explaining calculation processing mode by page switching in an embodiment of the present invention, and Figure 11 is a diagram for explaining the calculation processing mode by page switching in an embodiment of the present invention. 1 is a diagram illustrating a processing overview of an embodiment of the present invention. In the figure, 1 is a card image, 2 is a box, 8
is the keyboard, 10 is the card image processing section, 1
3 is a card creation management section, 16 is a procedure registration control section,
17 is a procedure storage section, 19 is a calculation control section, 27 is a format data storage section, 28 is a field definition information storage section, 29 is a card data storage section, 31 is a format buffer, 32 is a record buffer, and 40 is a window control section. , 41 is a screen code buffer, 44 is a print control unit, 60 is a calculation instruction control unit, 61 is a calculation execution control unit, 62 is a calculation procedure creation unit, 64 is a field name extraction control unit, 65 is a page switching control unit, and 68 is a Represents a relative page switching control section.

Claims (1)

[Claims] 1. A display, a format information storage unit that stores format information of cards including ruled lines or fixed characters,
The format information storage section includes at least a field definition information storage section that stores definition information regarding the entry fields of the card, and a card data storage section that stores the contents entered in the entry fields of each card. and the contents of the card data storage section are merged based on the contents of the field definition information storage section, card images are generated and displayed in the form buffer in correspondence with the pages, and each individual card image on the card image is A calculation control method by switching card pages in a data processing device having a card image processing function for processing card contents by specifying a processing mode by specifying a field, and inputting a calculation formula for the above entry field. an input means for executing a procedure including a calculation formula inputted by the input means; and a calculation formula for inputting a predetermined page indicator indicating the page position of the card image relative to the current page means for displaying and storing the information in combination with the field name, and a means for displaying and storing information in combination with the field name; 1. A calculation control method using card page switching, characterized in that the page switching is specified in a calculation formula based on the current page.