JP2004127059A - Information processing method and device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a business form format definition method capable of performing an automatic data input and output, for a business form format having a derivative area that is a second data entry section in one cell, with another business form format or data file by a simple business form format defining operation with high visible confirmability. <P>SOLUTION: This method comprises the step of performing an item definition for conforming data or a data field to an item name in the business form format; and the step of designating a differential condition that is the entry condition naturally possessed by the derivative area to a main area that is the first entry section in one cell to the data file provided in the derivative area that is the second data entry area in the same cell. Based on the designated item definition and differential condition, the data to be simultaneously referred in the data input and output of a business form, or a record that is an assembly of data entry sections is identified with respect to each derivative area. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an information processing method and apparatus for performing data processing on a book table format.
[0002]
[Prior art]
Conventionally, for various book table formats freely created by the user, items to be associated with corresponding item names for data fields or data constituting the book table format should be defined and simultaneously referred to in data input / output of the book table. A book table format definition method for automatically transcribing data to or from another book table or data file by routinely identifying data or a record that is a set of data entry areas is known. ing.
[0003]
For example, the present inventor has proposed in Japanese Patent Laid-Open No. 09-134349 a method in which this method can be performed with good man-machine characteristics by adding a minimum of characters and symbols familiar to the user on a book table format. ing.
[0004]
[Problems to be solved by the invention]
However, in a form format actually used in the world, as shown in FIG. 10 described later, another entry area (derived area) is provided in one cell, and the original area is provided therein. The entry area (main area) is often a composite format in which data under different conditions is entered.
[0005]
The book table format handled by the book table format definition method proposed so far is limited to a format in which only one data is entered in each cell constituting the book table, and has a derived area of this kind. For a composite format, automatic data input / output based on the book table definition described above could not be performed.
If the user wishes to obtain data output on a composite format with derived areas, for example, a separate book is created in which each constituent cell is equivalent to each derived area in the target format, and the resulting table is obtained. There was no alternative but to copy the data one by one to the derived area of the target format.
[0006]
The present invention has been made in view of such a problem of the related art, and also for a form format provided with this kind of derived area, a simple operation at the same level as a designation operation performed for a normal form format, It is an object of the present invention to propose an information processing method and apparatus capable of defining a form format and automatically inputting and outputting data.
[0007]
Another object of the present invention is to provide an information processing method and apparatus which can define a form format in which a derived area is provided, and which has visibility and readability that anyone can understand and understand.
[0008]
In order to achieve the above object, an information processing method according to claim 1 of the present invention is a method of inputting / outputting data in a book table format. A step of defining an item for associating a data field with an item name; and, for a data field provided with a derived area as a second data entry area in one cell, a first entry in the same cell as the derived area. With the step of specifying the difference condition, which is an entry condition that is unique to the main area that is the area, and simultaneously refers to each derived area based on the specified item definition and the difference condition when inputting and outputting data in the book table Automatically identifying a record to be created or a set of data entry areas.
[0009]
The information processing method according to claim 2 is a data input / output method in a book format according to score request 1, wherein the information input / output method in the cell is performed by recognizing a symbol that divides an example of a derived area. And a data entry area of the main area.
[0010]
An information processing apparatus according to claim 3 is a data input / output device in a book table format, wherein means for defining an item that associates a data or a data field with an item name in a table is provided. For the data field provided with the derived area which is the second data entry area, a difference condition which is an entry condition inherent to the main area which is the first entry area in the same cell in the same cell is designated. A means is provided to automatically identify, for each derived area, data that should be referred to at the same time when inputting / outputting data from a book or a record that is a set of data entry areas, based on the specified item definition and difference conditions It is characterized by doing.
[0011]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, the present invention will be described with reference to the accompanying drawings.
[0012]
【Example】
FIG. 1 shows a hardware system configuration of an information processing apparatus according to an embodiment of the present invention. In this system, the color image scanner 10, the keyboard 12, the mouse 14, and the digitizer 15 are suitable as input devices, the internal memory 16 and the external memory 18 are suitable as storage devices, and the display device 20 and the stamp device 22 are suitable as output devices. It is connected to the CPU 24 via an interface circuit (not shown). Further, the CPU 24 is also connected to a telephone line or a communication line 27 via a communication device 26.
[0013]
The color image scanner 10 reads characters, symbols, and figures in a document written on a sheet as color image information. The internal memory 16 and the external memory 18 store various electronic dictionaries, character fonts, files, and the like, in addition to various programs that define processing or control operations of the CPU 24. The communication device 26 has a facsimile communication function.
[0014]
FIG. 2 shows a list of operation modes related to book creation in the system of the present embodiment. Main modes such as "document creation", "definition", and "environment setting" are set, and these main modes are "retrieve" ..., "definition interpretation" ..., "definition information setting", etc. The sub mode is branched.
[0015]
FIG. 3 shows a “main mode-view menu” displayed on the display screen 20 a of the display device 20. When the "mode" button, which is always displayed in the lower left corner of the display screen 20a, is selected and displayed, this "main mode list menu" appears on the screen, and "document creation", "definition", "environment" A main mode selection button such as "setting" is displayed.
[0016]
When the "environment setting" button is clicked in the "main mode list menu", the environment setting mode is selected. When the mode is switched to the environment setting mode, a screen as shown in FIG. 4 is displayed on the display screen 20a, and sub-mode selection buttons such as “definition setting” and “definition information setting” are displayed at the lower right of the screen. Here, when the "definition information setting" button is clicked, the screen enters a definition information setting mode, and is displayed on a "definition element / entry information comparison table" screen as shown in FIG.
[0017]
In FIG. 5, in this embodiment, a plurality of definition systems such as “common” and “book table definition” are prepared, and a plurality of definition elements are set in each definition system. Of these, "book table definition" and each definition element of the system are used to set the format for data management on the book table, and each "common" definition element is also used for the definition of other definition systems. Is done.
As shown in FIG. 5, one or more kinds of predetermined characters (character strings), symbols or figures are associated with each definition element. Some of the definition elements, such as “round-up” corresponding to the definition element “rounding”, indicate the target definition content only by the entry information. As in the case of <>, another definition information on a document is designated as a component of the definition content. In addition, as in the case of “○” corresponding to the definition element “registration word designation”, the character, symbol, etc. designated thereby indicate that the definition content should be interpreted with reference to the applied term dictionary. is there.
[0019]
The association between the definition element and the entry information as described above may be prepared by the system from the beginning, or the user may be allowed to set and register at any time by screen input. In any case, in the data format shown in FIG. 6, for example, the definition element identification data having a variable data length corresponding to the comparison table in FIG. 5 is set for each definition element. Each definition element identification data is held in a definition element identification data storage unit 48 (FIG. 21) of a definition information recognition unit described later.
[0020]
In the data format of “definition element identification data” in FIG. 6, the code of the definition system (book table definition) to which the relevant definition element (for example, “round up”) belongs is set in the data field of “definition system code”. , The code of the definition element (rounded up) is set in the data field of the "definition element type", and the character string corresponding to the definition element (rounded up) is set in each data field of the "configuration character string / symbol string" A code of (rounding up, rounding up ...) is set with predetermined delimiter identification data interposed therebetween, and predetermined end identification data indicating the end of this data is added to the last field.
[0021]
As described above, in the present embodiment, the definition elements for performing various definitions on a document are associated with characters, symbols, or graphics that can also be used as normal entry information representing the contents of a normal document. However, as described later, when used as a defining element, the entry information is provided with special decoration information (for example, color information) so as to be distinguished from normal entry information representing the contents of a document. In other words, the user can not only use the commonly used entry information as normal entry information to represent the contents of the document, but also add special modifier information to this to indicate the definition contents. It can be used as information.
[0022]
When the sub-mode selection button of “definition distinction setting” is selected on the “environment setting mode screen” of FIG. 4, a “definition information distinction instruction screen” as shown in FIG. 7 appears on the display screen 20a.
In FIG. 7, a column of [definition system] lists definition systems such as "form definition". The user only needs to input modification information or identification information of [color], [line modification], [line thickness], [handwriting / printing] used for the entry information of each definition system at each position.
In the example of FIG. 7, for example, (blue) is entered in the [Color] column for the definition system of “book table definition”, and (red) is designated for the definition system of “format definition”. Since each “common” definition element is shared by all definition systems, there is no need to set “common” unique modification information.
[0023]
When the above specification is completed, when the "end" button on the "definition information distinction instruction screen" is designated, in response to the input operation of the definition information distinction instruction, the data format in the system is, for example, as shown in FIG. Sets definition information discrimination data for each definition system. This definition information distinction data is stored in the definition information distinction data storage unit 50 (FIG. 21) of the definition information recognition unit described later.
[0024]
Next, an example will be described in which data is totaled and output on a totaling table freely created by a user on paper using this system.
The user has, for example, the format of the table shown in FIG. 9 as a sheet, and a use example in which the user wants to obtain a total output of data as shown in FIG. 10 on this format will be described.
[0025]
In the table of FIG. 9, a data entry column (field) of the item name “branch” is provided on the uppermost row, and a data entry column of the item name “product name” is provided in the leftmost column. In the matrix of cells in the second to fourth rows from the top and the second to fourth columns from the left in the table, a data entry column for the item name "sales" is provided. In the upper right part outside the table, the data name “2001” of the item name “year” is described as a common entry condition for each data entry column in the table.
[0026]
The user reads the above from the entries in the table on the premise of some dictionary (for example, a product name master file ...) that describes the association between each item name and its data name. For example, the item name “branch” is read from the entry data sequence “Tokyo”, “Osaka”, and “Nagoya”, and the item name “product” is entry data sequence “TV”, “Radio” , "Car navigation" and the headword "product name" written in the upper position adjacent thereto are read with the help of the headword. The correspondence between the item name "sales" and its data entry column (field) is mainly read from the title of the table.
[0027]
In the table format of the target data output result (FIG. 10), in each cell constituting the data entry column (field) of the item name “sales”, another symbol “[]” is added by another symbol. A data entry area is provided.
In the original entry area of the data entry column (field), data of the year "2001" is entered, whereas in the newly provided entry area,
The data of "2000", which is the previous year, is entered.
That is, in FIG. 40 to be described later, the data entry conditions of the two entry areas provided in the hatched cells in the data entry column (field) of this item name “sales” are the conditions entered in the table. Are the same as each other (in each case, “branch” is “Osaka” and “product” is “radio”), but the data of the common entry condition “year” outside the table is “2001” in the original entry area. And the newly provided entry area side is "2000", so that data is totaled under different conditions.
[0028]
The user reads the entry in the data entry column (field) of the item name “sales” from the commentary sentence “[] in 2000] written below the title of the table.
[0029]
As described above, in each of the constituent cells of a certain data entry column (field), another entry area is provided, in which data having conditions different from those of the original entry area is entered. In this specification, the entry area newly provided in this cell is referred to as a "derivation area", and the entry area on which data of the original entry conditions is entered is referred to as a "main area". The different conditions specified for are referred to as “difference conditions”. In the case of this example, the “difference condition” means that the data name of the item name “year” is “2000”.
Also, an entry element that is entered in a cell and generates a “derived area”, such as the symbol “[]” in this example, is called a “derived area generating element”.
A cell provided with the new entry area “derived area” is particularly called a “composite cell”, while a cell in which only one data is entered is called a “normal cell”.
[0030]
In this system, the “define” operation shown in FIG. 11 is performed so that the system can routinely recognize the contents of the definition as recognized by the user as described above without intent. This “define” operation is performed by additionally writing definition support entry information that can be distinguished from the normal entry information that is the original entry content of the summary table. In the case of this example, the definition support entry information is distinguished from the ordinary entry information by being entered using the (blue) color assigned to the definition system of “common” and “book table definition” as shown in FIG. I will do it.
[0031]
As a basis of “defining” in the summary table, first, “item definition” for associating the item names of all data fields and data names on the summary table is performed. As for the item names used in the “item definition”, if there is something originally entered as a headword on the tabulation table, from the purpose of this system that the user freely uses the items freely entered on the paper as much as possible , Use it as is.
[0032]
First, for each set (cell column) of cells having the same item name and adjacent to each other, a data field is specified using a definition element symbol """" or "[]" of "field specification". That is, the definition element symbol ““ ”of“ field specification ”, or“ [”and“] ”or“ [”and“] ”, which are constituent symbols of“ [] ”, are respectively added to the corresponding cell column. Fill in both end cells.
[0033]
As an item name to be associated with this data field, if there is one originally written as a headword adjacent to the upper side or left side of the data field, it is specified as the item name. The designation of the item name is performed by adding each constituent symbol “<” and “>” of the definition element symbol “<>” to both sides of the corresponding character string. In the case of this example, the headword "product" is defined as the item name of the data field adjacent to the lower side by this designation method.
[0034]
If the name of the item to be associated is not originally entered as a headword of the entry content-usually entered information, enter the name in the blank space near the relevant data field, specify the item name, and further define the definition element Is connected to the corresponding data field by using the connection line "-". In the case of this example, the item names "branch" and "year" are associated with the corresponding data fields or data names, respectively, by this method.
[0035]
For a data field composed of a composite cell (hereinafter, referred to as a "composite field"), the field range is specified in the same manner as in a normal data field. In the case of this example, for the data field with the item name "sales", the constituent symbols "" and "" of the definition element symbol of "field designation" are written in the upper left cell and the lower right cell, respectively. (Because this field forms a matrix of cells, use "".) Next, the corresponding item name "sales" is used as the (blue) color definition support entry information. , And the above-mentioned item name designation is added, and a connecting line "-" is drawn out to an arbitrary position of the corresponding data field.
In addition, in order to specify that the "summary category" is "numerical value" in the item name "sales", the definition element "summary category designation" is added to the right shoulder of the item name "sales" character string. Add the “” ”symbol in (blue) color.
[0036]
Next, the symbol “[]” of “derived area generation element” is additionally written in an arbitrary cell of this data field. Further, the commentary "2000 in []" is also written in an appropriate position outside the table so that anyone can understand the definition of the "derived area" that is being made. Although these entries are additional entries, they are ordinary entry information output on the target output table (FIG. 10), and are entered in the output color (black).
[0037]
In addition, a character string indicating “difference condition” is entered in a predetermined format described below. In the case of this example, the item name and the data name are specified for the character strings representing the item name “year” and the data name “2000”, respectively, and then the paired character string “<year> [2000]” is obtained. Fill out the appropriate blanks outside the table. The information is entered using the (blue) color definition support entry information, and is connected to the data field of the corresponding item name “sales” by a connection line “−”.
[0038]
Finally, the “sum field” is specified on the bottom row and the rightmost column of the table. The cell column of the total column in which the total value of each data field is entered is specified using the definition element symbol “[]” of “field specification” in the same manner as the specification of the data field. That is, for each “sum field”, the definition element symbol “[]” and the constituent symbols “[” and “]” of “field specification” are written in the sum column cells at both ends. The cell at the lower right corner of the table may be included in the “sum field” defined on the bottom row, or may be included in the “sum field” defined on the rightmost column.
[0039]
In the case of this example, each cell of the two total fields specified on the bottom row and the rightmost column of the table has the data of the item name “sales” aggregated, so the item “sales” Is a composite cell having the same “difference condition” and “derivative area” as the data field, but the specification method may be performed in the same manner as in a normal total field.
[0040]
Also, in the cell adjacent to the left end of the total field in the bottom row and in the cell adjacent to the top of the total field in the rightmost column, the `` total '' character which is originally written as the written content-usually After confirming that it is a “registered word” registered in the applied term dictionary 52, it is surrounded by a “registered word designation” definition element symbol “O”.
[0041]
In the present system, the user registers a specific term that is used daily (normally as entry information) in a book table in the application term dictionary 52 (FIG. 26), and registers it. By enclosing “registered word designation” definition element symbol “記号”, each is converted into definition information having a specific meaning. That is, the “total” character surrounded by the “registration word designation” definition element symbol “O” is integrated with the field designated by “[]” to constitute one definition information for data management, and the definition element “ Each column (cell) in the total field designated by [] "defines that a value obtained by summing up the numerical data entered in other specific fields is to be entered.
[0042]
The specific field to be subjected to the sum calculation here is a data field with the item name "sales" set in a direction perpendicular to the sum field in this example. For example, the specific field of the total column cell in the second column from the left of the bottom row is a data field portion of the item name "sales" defined in the vertical direction in the same column.
[0043]
Next, a description will be given of various functions for inputting the table format entry sheet defined by adding the definition support entry information to the present system as described above and obtaining a desired data output.
[0044]
FIG. 12 shows a configuration of a document input and document element data generation unit in the system of the present embodiment. The document image input unit 30 includes an input device such as a color image scanner 10, a keyboard 12, and a mouse 14, a CPU 24 for executing an input routine, an internal memory 16 or an external memory 18 for temporarily receiving an input color screen, and It is constituted by. The document image storage unit 32, the character / graphic pattern dictionary 36, and the document element data storage unit 38 use the storage area of the internal memory 16 or the external memory 18. The character / graphics element recognition unit 34 is configured by the CPU 24 that executes a character / graphics recognition processing program. The document image output unit 40 mainly includes a CPU 24 that executes a display control program, and a display device 20 that outputs a document image under the control of the CPU 24 or a communication device 26 that transmits and outputs a document image. You.
[0045]
The user sets the book cover on the color image scanner 10, selects the "document creation" mode on the display screen 20a, and clicks the "character / graphic recognition" button.
In response to this click operation, first, a reading operation is performed by the image scanner 10, and a color image signal representing an image of the book document (all entries) shown in FIG. 11 is taken into the image storage unit of the input unit 30. . The color image signal taken into the input unit 30 is decomposed into each color image signal of (black), (blue), and (red) in the form of a signal. A blue image signal of (blue) and an image signal of (red) are stored in the black image storage section 32a, the blue image storage section 32b, and the red image storage section 32c, respectively.
[0046]
Next, the character / graphic element recognition unit 34 recognizes individual characters and graphic elements in the document for each color (black, blue, red) for the pixel data for each document stored in the document image storage unit 32. I do. Here, the graphic element is a group of simple figures, such as line segments, rectangles, and circles, whose shapes can be easily recognized as images.
[0047]
At the time of image recognition in the present embodiment, for example, “image management data” preset in a data format as shown in FIG. 13 is referred to. In this “image management data”, as shown in FIG. 14, it is assumed that an input image is constituted by a large number of pixels PX arranged on a matrix, and data indicating the number, size, pitch, etc. of the pixels PX is set. ing.
[0048]
The recognition of characters and figures in the character / graphics element recognition unit 34 is basically performed by recognizing line elements constituting individual characters and graphic elements. Various known methods may be used to identify the line elements. For example, first, a set of dots having a specific color is found, and then a search is made in or around the adjacent inertia to determine the direction in which the set of dots extends. By repeating this process, the trajectory drawn by the set of dots is traced until it disappears (ends). If there is a location where the direction of the trajectory changes rapidly during the tracking, the location is identified as a bending point or a cusp.
[0049]
The line element thus extracted can be identified as one of the line element patterns set in advance by its shape and size. In this embodiment, the character / figure pattern dictionary 36 stores in advance a type of a line element constituting each character and a figure and a significant positional relationship between the constituent line elements in a predetermined electronic dictionary method ( Settings have been registered). The character / graphic element recognizing unit 34 repeats the process of combining the line elements extracted as described above with adjacent ones and comparing the line elements with the character / graphic pattern dictionary 36, thereby obtaining individual characters, symbols, Recognize figures.
[0050]
For example, ruled lines forming a table such as a list are recognized as follows. That is, a line element extracted as a straight line in recognition of a line element as described above is orders of magnitude longer than other line elements, and the direction of the straight line is in relation to a horizontal line (X axis) or a vertical line (Y axis). If the angle falls within a certain angle, the straight line is regarded as a horizontal ruled line or a vertical ruled line, and the position information is corrected so as to be parallel to the horizontal line or the vertical line. If the distance between the end points of two extracted ruled lines or the distance between the end point of one ruled line and the other ruled line is within a certain value, the end points of both ruled lines are overlapped with each other, or It is considered that the end point of the ruled line overlaps the other ruled line, and the respective position information is corrected so that the two ruled lines overlap in such a manner.
[0051]
The character / graphic element recognizing unit 34 performs the above-described character / graphic recognition processing on each color (black, blue, red) image of the image-inputted document, so that each character, each graphic element, and each symbol Document element data is generated in a data format as shown in FIGS.
[0052]
FIG. 15 shows a data format example of document element data (character data) corresponding to one character. As shown in the figure, the code, typeface, color, line thickness, line modification (solid line, dotted line, chain line, etc.) of the character, handwriting / printing (discrimination as a handwritten character or a printed character), entry position and size Data (character size) is sequentially set in a predetermined data field, and end identification data indicating the end of the document element data is added to the end.
[0053]
FIG. 16 shows a data format example of document element data (character string data) corresponding to one character string. As shown in the figure, the “start character position” and “end line position” indicating the arrangement position of the character string, the “line pitch” and “character pitch” indicating the format of the character string are set, and the character string Are set in the order of arrangement.
[0054]
FIGS. 17, 18 and 19 show data format examples of document element data (graphic element data) corresponding to one graphic element or symbol, respectively. As shown in FIG. 17, the data of the start position and the end position is incorporated into the line segment. As shown in FIG. 18, the data of the center position (X and Y directions) and the diameter size (X and Y directions) are incorporated in the ellipse. As shown in FIG. 19, for a rectangle or “<”, data indicating the position of a bending point or a cusp (a point where the direction of a line segment changes sharply) is incorporated in addition to the start and end positions.
[0055]
When a table is composed of ruled lines, cells constituting the table are detected, and "cell data" is created for each detected cell. (FIG. 20) A cell refers to a rectangular area surrounded by ruled lines in the table and serving as a unit for writing data.
Cell detection can be performed, for example, as follows. The ruled line data of the ruled lines constituting the table are sequentially taken out, and ruled lines or ruled line positions separated by extensions thereof are obtained in both the vertical and horizontal directions of the document. Next, for each square of the matrix generated based on the ruled line position, a search is performed to determine whether each of the four sides is a ruled line portion. Adjacent squares are merged, and the same determination is repeated for the merged squares, thereby identifying the boundaries of the four sides of the cell.
At this stage, only the position information (for example, the position of the upper left corner point and the lower right corner point) is set in the created “cell data” at this stage.
[0056]
As described above, all the entry information in each document input as an image is decomposed into individual characters, symbols, and figures, and is converted into document element data by the character / graphic element recognition unit 34. These document element data are stored in the document element data storage unit 38 for each document. Note that the image information corresponding to the entry information that has been converted into the document element data after the character / graphic recognition processing may be deleted from the document image storage unit 32.
[0057]
The document image output unit 40 not only outputs a document image based on the image signal held in the document image storage unit 32, but also outputs the document image data from the document element data stored in the document element data storage unit 38 as characters / It is configured so that a document image can be output after being converted into an image signal via the graphic pattern dictionary 36.
[0058]
When the above-described document input and document element data generation processing are completed, a message to that effect is given to the user from the system, for example, through the display screen 20a.
Next, the user clicks the "mode" button which is always displayed at the lower right of the display 20a, selects the "definition" mode, and instructs the "definition interpretation" button on the screen. In response to this instruction, the following processing is performed in the system.
[0059]
FIG. 21 shows the configuration of the definition information recognition and format setting unit in the system of this embodiment. The definition element data generation unit 42 and the definition data generation unit 46 are configured by the CPU 24 that executes a definition element data and definition data generation process. The definition information identification data storage unit 48, the definition information distinction data storage unit 50, the application term dictionary 52, the definition data storage unit 54, and the sheet group definition data storage unit 56 are provided in a predetermined storage area of the internal memory 16 or the external memory 18. Expanded above.
[0060]
In the definition information recognition and format setting section, first, the definition element generation section 42 executes the definition element identification data (FIG. 6) and the definition stored in the definition element identification data storage section 48 and the definition information distinction data storage section 50, respectively. Referring to the information discrimination data (FIG. 8), each definition element entry information written in each document based on the document element data (FIGS. 15 to 20) stored in the document element data storage unit 38. Generate data (definition element data).
[0061]
FIG. 22 shows a data format example of the definition element data. A "definition code" and a "definition element code" for identifying the definition element entry information are set, and a pointer for referring to document element data corresponding to characters, graphics, and symbols constituting the definition element entry information Is set. For example, in the case of "[]" of "field specification", a pointer for specifying the address of the document element data corresponding to the constituent symbol "[", "]" is set.
[0062]
In order to generate the definition element data, a search is made for document element data having modification information assigned to the corresponding definition system, for example, color information of (blue). When the definition element is composed of a pair of two symbols, such as the definition element ““ ”of“ field specification ”, first, one constituent symbol is searched and detected, and the other symbol forming the pair is determined. .
If a plurality of this symbol pair is detected, the selection is made as follows. For example, in the case of the definition element "", a combination which does not include the constituent symbol "" or "" of the same definition element in the rectangle specified by the pair is selected.
[0063]
The "definition code" and "definition element code" are determined for each one definition element by the above method, and the addresses of the document element data (graphic element data) of the symbols constituting the definition element entry information are specified. The pointer can also be determined.
Each definition element data obtained from the definition element data generation unit 42 as described above is stored in the definition element data storage unit 44.
[0064]
Next, the definition data generation unit 46 refers to the definition information distinction data (FIG. 8) held in the definition information distinction data storage unit 50 and defines the definition element data ( Referring to the document element data (FIGS. 15 to 20) stored in the document element data storage unit 38, definition data is generated for each piece of definition information written in a document.
[0065]
FIG. 23 shows a procedure for creating the entire definition data in this example. First, “item definition data” (FIG. 24) and “total definition data” (FIG. 25) are created for all data fields in the summary table. (Steps Al and A2) In this creation, the data field composed of the composite cell and the sum field are created in the same way as the normal data field and the sum field (with the derived area ignored).
Next, regarding the item definition data and the total definition data of the composite field in which the “derived area” is defined, “composite field definition processing” for adding definition contents for enabling data input / output on the “derived area” Perform (Step A3)
[0066]
Creation of “item definition data” (FIG. 24) is performed according to the following procedure. First, the definition element symbol “[]” or ““ ”” of “field specification” that has already been extracted as the definition element data is identified one by one, and the cell or cell which is designated as the data field is identified. The column is identified as “field candidate” and “field candidate definition data” is created. The field candidate definition data is created in the format of the item definition data (FIG. 24), but the "item name character string data address" in it is left blank because the corresponding item name has not yet been determined. .
[0067]
The cell string of the field candidate is detected by detecting a cell including each of the defining element symbols of “field specification”, for example, the constituent symbols “[” and “]” of “[]”, as cells at both ends. This can be performed by sequentially detecting cells connecting the cells at both ends.
In the detected cell row, a "cell data chain" (not shown) in which the cell data is sequentially connected from the first cell by "pointer data" in the cell data is created, and the cell data of the first cell is created. The address is set to the “first cell data address” in the field candidate definition data.
[0068]
When the cell configuration forms a matrix like the data field of the item name “sales”, for example, first, the cells in the first row are connected in order from the left, and the rightmost cell is set in the next second row. , And the procedure of connecting the cells in the second row sequentially is repeated.
[0069]
Further, a character string specified as a data name by the definition element symbol of “field specification” is also identified as “data name candidate”, and “data name candidate definition data” is created. Similarly, a character string data address of the character string created in the format of the item definition data (see FIG. 24 described later) is set in the “head cell data address” portion.
[0070]
Next, for each “field candidate” or “data name candidate” detected above, a corresponding item name is obtained, and “field candidate definition data” or “data name candidate definition data” is replaced with “item definition data”. (FIG. 24).
[0071]
First, a "joining line""-" extracted from a cell string of a field candidate or a character string of a data name candidate is searched. If there is a “joining line” drawn from within the corresponding cell column and a character string with “item name specification” adjacent to the other end, this “item name specification character string” Judgment as "item name" of "data field candidate" or "data name candidate", and "item name character" in already created "field candidate definition data" or "data name candidate definition data" The character string data address of the corresponding character string is set in the column data address.
In the case of this example, the item definition data is created as described above for the item name “branch”, the item name “sales” added outside the table, and the item name “year”.
[0072]
If “field candidate” or “data name candidate” does not have “item name specification character string” connected by “joining line”, “field candidate” or “data name character string” Create the item definition data by regarding the character string at the “specific adjacent position” and designated as “item name” as the item name associated with the corresponding “field candidate” or “data name candidate” . Here, the “specific adjacent position” is a position adjacent to the left side of the data field when the data field is defined in the horizontal direction, and the data field is defined in the vertical direction. In this case, it means a position adjacent to the upper side of the field.
The item name detected in this manner is similarly set to the item string data address of “field name definition data” and “data name candidate definition data”, and the character string data address of the corresponding character string is set. Definition data ". In the case of this example, “item definition data” having the item name “product” as the “item name” is created by this method.
[0073]
Next, the following “classification” is determined for the item definition data created above. First, it is determined whether each item definition is defined as a common condition “outside the table” or defined on a field “inside the table”.
When the data field is composed of cells detected from one table, it is regarded as a field of “in the table”, and the corresponding code “0” is set in the “common section” column in the “item definition data”. . The corresponding code "1" is set in the "item definition data" defined for the "outside table" field and data name. In the case of this example, “1” is set in “item definition data” of the item name “year”, and “0” is set in “item definition data” of another item name.
[0074]
Next, for each item definition whose data field is determined to be "in the table", it is determined whether or not "total item" is used as the item name. For the item name character string, it is detected whether or not the (blue) color definition element symbol “の” of “designation of aggregation category” is additionally written in a predetermined position in the upper right adjacent part of the character string, and If this detection is obtained, the corresponding item name is determined to be “total item name”, and the corresponding code “1” is set in the “total category” column of the item definition data. For an item name other than “total item name”, the corresponding code “0” is set in the “total category” column. In the case of this example, the specification of the “total item name” is performed for the item definition of the item name “sales”.
[0075]
When all the “item definition data” have been created, a search is made for the definition element symbol “O” of “designation of registered word” in the document. Search in.
FIG. 26 shows an example of terms included in the applied English dictionary 52. FIG. 27 shows a data format of term data included in the applied term dictionary. The code of each sub-definition system is set in the data field of the processing system type of the header, and the corresponding character code string is set in the data field of "character code string" following this header. “Separation identification data” in FIG. 26 corresponds to a comma separating each term.
[0076]
In the case of this example, in the applied English dictionary 52, it is identified that the "total" character surrounded by the definition element symbol "o" is a "total field designation word", and the creation of "total definition data" is started.
First, among the field candidates that have already been extracted, those that are connected by the "total field designation word" and the "connection line" are searched. If there is nothing connected by the "total field designation word" and the "joining line", the field candidate in which the "total field designation word" is at the "specific adjacent position" is identified as in this example, and the "total field designation word" And create "Total field definition data". (The “specific adjacent position” of the field has been described above.) The format of “total field definition data” is shown in FIG.
[0077]
Next, the cells constituting the "total field" are sequentially taken out, and the "totaling target field" corresponding to each cell is detected. The “totaled field” refers to a set of cells in which data to be totaled is entered in “total cell” in which a total value is entered.
When the "sum field" is defined in the horizontal direction, the item definition data field of the "total category" is searched upward in the same column as the constituent cell. If the "sum field" is defined in the vertical direction, a search is made on the left side of the constituent cell on the same row.
[0078]
If an item definition data field that satisfies the above conditions can be detected for a cell in the “total field”, that cell is added to the corresponding item definition data field in the same column and row as its own. It can be regarded as a “total field cell” to be a “target field”.
In the total field, as described above, for the "total column cell" in which the "total field" is detected, the cell data is sequentially connected again with "pointer data" to create a "cell data chain". Then, the address of the head cell data is set to the “head cell data address” of the “total definition field data”. (FIG. 25) FIG. 28 shows the relationship between the “total field”, “total field” and “total cell” described above.
[0079]
In the case of this example, a “sum field” is defined at the bottom row and the rightmost column of the table, and each of its constituent cells is in the same column as its own cell in the data field of the item name “sales”. Or a “sum total column cell” in which a portion on the same column is a “total field”.
[0080]
When “item definition data” and “total field definition data” have been created for all data fields and total fields, “composite field definition processing” is performed for “composite fields” in which “composite cells” are defined. (FIG. 29) The "composite field definition process" is performed by adding contents for defining a composite cell to the corresponding "item definition data" already created.
[0081]
First, the item definition data that has already been created is taken out one by one, and it is determined whether or not the corresponding field is a “composite field”. (Step B1) This determination is made by identifying whether or not a “difference condition” that satisfies the following condition is defined in association with a predetermined method for the extracted data field of the item definition.
[0082]
In the present system, as the difference condition, first, a format of (a) “item name” or (b) a pair of “item name and data name” is taken as a format. In this specification, in particular, as the format of the difference condition, (a) “item name” is “item name type”, and (b) “item name and data name pair” is “data name”. Name type ".
[0083]
Next, the difference condition is as follows: (a) In the case of “item name type”, it must be different from the “item name” originally defined in the corresponding field (“sales” in this example). When the difference condition is (b) “data name type”, the corresponding “item name” is the “item name” (item name) of the item definition defined outside the table as a common condition for the entire table. In the case of the example, it is the same as “year”, and at the same time, the corresponding “data name” (“2000”) must be different from the common condition “data name” “2001”.
[0084]
In this system, one of the methods for making the above determination is when a character string written on a format document satisfies the above conditions and has a specific association with a certain data field. Is a "composite field", and the character string is determined to be a "difference condition designation character string" representing the difference condition.
[0085]
In the case of this example, the character string “<Year>” 2000 added outside the table in (blue) color is connected to the data field of the item name “sales” by a connecting line, and the item name portion “ Since “year” is also the item name of the common condition item definition of the entire table, and the data name portion “2000” therein is different from the data name “2001” of the item definition of the out-of-line common condition, this character is used. The column is “difference condition designation character string”, and the corresponding data field is determined to be a “composite field” in which a difference condition of “item name type” is defined.
[0086]
For a data field determined to be a “composite field”, a code “1” indicating that it is a “composite field” is set in the “composite category” column in the corresponding item definition data, and then (step B2). ), “Difference condition definition data” is created, and its address is set in “difference condition definition data pointer” in the corresponding item definition data. (Step B4)
If it is determined that it is a "normal field" which is not a "composite field", a code "0" indicating "normal field" is set in the "composite category" column of the corresponding item definition data (step B3). ), Exit from the “composite definition process”.
[0087]
FIG. 30 shows the format of “difference condition definition data”. In the case of this example, the item name part “year” and the data part “2000” are extracted from the character string added as the difference condition, and the corresponding text data is created. Set in “Item name part” and “Data part”.
[0088]
Next, for the data field determined as a “composite field” for which the “difference condition” has been defined, the “composite cell format”, which is the format format of the “composite cell”, is identified, and is identified as “derived area definition data”. (Step B5).
[0089]
First, by paying attention to an arbitrary cell in the corresponding “composite field”, the “composite cell format” is detected on a hypothetical basis. In general, in the form format, each constituent cell in one data field must be in the same format format (cell shape / dimensions, entry text entry format ...), and it must be a "composite cell". ”Must have the same“ composite cell format ”.
From the above, if the "composite cell format" can be detected from one cell, it is confirmed that the remaining cells in the same data field have the same "composite cell format" and the "composite cell format" Is determined.
However, as in this example, the "composite cell format" may be described in only some of the cells by way of example, so the "derived cell generation element" configuration detected in other cells This determination is not hindered unless a different kind of character / symbol is overlapped at the entry position of the symbol.
[0090]
As a “composite cell format”, in the present system, one set of symbols (“derived cell generation element”) forms one character string entry area, and the entry entry area is the lower half or right half of the cell. Take up the case that occupies. "Derived cell generation element" can be detected by the following procedure
[0091]
In the system, a combination of symbols that can be a “derived cell generation element” is registered as much as possible in advance. For each combination of individual symbols, determine the "type", define the symbol code that constitutes it, and register the entry order between them, define the "derived area generation element data", and collectively define it as a "derived area generation element dictionary" register. (Not shown) The format of the “derived area generation element dictionary” is the same as the format of the “definition information identification data” (FIG. 6).
[0092]
First, each cell of the corresponding data field is searched to detect a combination of symbols registered in the “derived area generation element dictionary”.
If a pair of registered symbols in the “derived area generation element dictionary” can be detected, a rectangle circumscribing the pair of symbols is determined. If it can be confirmed that the three sides in the downward direction are drawn within a certain threshold from the boundary of the corresponding cell, this pair of symbols defines the “derived area” in the lower part of the corresponding cell. Area generation element. "
Also, as shown in FIG. 31 (b), if it can be confirmed that the three sides in the up-down direction and the right direction are drawn within the boundary of the corresponding cell and within a certain threshold value, this pair of symbols is determined by It is regarded as a "derived area generation element" that defines the "derived area" in the part. Here, a rectangle circumscribing a pair of symbols can be obtained from the data of the "position", "height", and "width" as the character by referring to the character data of the symbol.
[0093]
If a "derived area generation element" is detected, an appropriate margin is added to this circumscribed rectangle to determine a "division position" that separates the main area and the derived area. And the width, the margins on both sides of the derived area can be obtained. (FIG. 32)
[0094]
As described above, if the “derived area generation element” can be detected in one cell, it is confirmed that no different symbols or characters overlapping with the cell are detected in the remaining cells of the corresponding data field. Definition data ". In the “derived area definition data”, the “derived area generating element type”, which is the type of the corresponding “derived area generating element”, and the “derived area” are set in the “direction distinction” (downward or rightward). Direction), a "division position" for separating the main area and the derived area, and a "left and right margin" of the derived area entry range are registered. (FIG. 33)
[0095]
In the present system, when a “derived area generating element” is not entered by the user, a predetermined default derived area generating element is automatically generated.
First, the vertical / horizontal dimension ratio of the constituent cell of the relevant composite data field is obtained, and the calculated ratio is compared with a predetermined reference value. As a direction (“direction distinction”) in which the derived area is set in the relevant cell, “ Decide either "lower" or "right".
The "division position" and "left and right margins" are determined in advance for each "direction distinction" by setting a reference value of the ratio of the "division position" to the cell dimension in the division direction and the ratio of the "left and right margin" to the cell lateral dimension in advance. Can be determined. The type of the “derived area generation element” is also determined in advance by default, and “derived area definition data” can be created from the above data.
The address of the “derived area definition data” created above is set in the “derived area definition data pointer” of the corresponding item definition data.
[0096]
Finally, the cell data of each cell constituting the data field in which the "composite cell" is defined is taken out one by one in the corresponding "cell data chain" and replaced with the corresponding "composite cell data". (Step B6) The format of the "composite cell data" is shown in FIG. For the position information and pointer information of the newly created "composite cell data", the relevant data in the original cell data is copied, and in the "cell data chain", the relevant Set the address where "composite cell data" is placed.
[0097]
When the “composite field definition processing” is completed for the data field in which the “composite cell” is defined, the “composite field definition processing” is performed for the “total column cell” of the “composite cell”.
The “composite cell” in the sum field can be determined as follows. The "total field definition data" is extracted one by one, and for each "total column cell" constituting the "total field definition data", the "totaling field" (the field in which the data to be totaled is entered) is identified, and the Field "or not. As described above, the “totaling target field” can be identified as a cell row set adjacent to the corresponding total column cell and in a direction perpendicular to the total field.
[0098]
As in the data field of the item name “sales” in this example, when each cell constituting the “summary field” is a composite cell, the “sum total cell” is the same composite cell (from the basic characteristics of the table) It must have the same “Difference condition definition data” and “Derived area definition data”). For a certain “Total column cell”, if the “Total field” is “Composite cell”, this “Total cell” The cell data of the "column cell" is switched to "composite cell cell data" (FIG. 34) in the same manner as the "totaled field".
In the case of this example, the cell data of each “total column cell” in the bottom row and the rightmost column of the table is switched to “composite cell cell data”. In the "cell data chain", the original cell data may be replaced with "composite cell data" as in the case of each composite cell constituting the data field of "item name" and "sales".
[0099]
As described above, when all the definition data has been generated for the document containing the definition information input to the system, the processing performed by the present system, particularly the recognition processing (character / graphic recognition, position / size, etc.) The results of the correction of the definition, etc., and the definition contents) are displayed and output, and the confirmation of the user side is obtained.
[0100]
In this display output, the document content of each document recognized by the system is sequentially displayed on the display screen 20a by, for example, a toggle method. In order to display this document image, the document image output unit 40 refers to the character / graphic pattern dictionary 36 for the document element data for each document stored in the document element data storage unit 38 and determines the pattern of each document element. After identifying, each pattern is converted into bitmap image data by a development program to generate a video signal.
[0101]
When the document contents of the book according to the recognition processing result of the system are displayed on the display screen 20a, the user can use the keyboard 12, the mouse 14, or the digitizer 15 to make corrections on each document from the screen. New entry information can be entered.
[0102]
With respect to the entry information input from the keyboard 12, the character / graphic element input unit 37 (FIG. 12) can generate the document element data without performing the character / graphic recognition processing. With respect to the entry information input from the mouse 14 or the digitizer 15, the entry information is input by the character / graphic element input unit 37, and the character / graphic element recognition unit 34 sequentially performs character / graphic recognition processing (for each input entry information). To generate document element data.
[0103]
When inputting the definition information using the screen input type input devices 12, 14, and 15, the modification information of each definition system is set and input in the "definition information discrimination" mode of the "environment setting" (FIG. 7).
If the entry information is entered on the screen under the desired definition sub-mode, the system adds the definition distinction specified in the sub-mode to the entered entry information, and displays it on the screen. It can also be displayed. In this case, the definition information is recognized from the entry information provided with the definition distinction modification.
[0104]
When the entry information is input on the screen as described above, every time the entry information is input, the character / graphic element input unit 37 (FIG. 12) based on the input data causes the document element corresponding to each entry information to be input. You will generate or modify data.
The entry information (character strings, symbols, figures) input from the screen is expressed in the form of document element data (FIGS. 15 to 20) in the system, similarly to the case where the image is input from a sheet.
[0105]
Because the entry information entered as an image from a form and the entry information entered using a command from the screen are managed in the system as the same document element data, the original entry information (normal entry information) in the book table or its Irrespective of the definition entry information added above, any entry information can be entered by either image input or screen input.
[0106]
As described above, the user confirms the document contents or definition contents of each document in the output display stage for confirmation as described above after inputting the document in which the document contents are described in advance by the image scanner 10. However, it is possible to additionally write arbitrary entry information, particularly definition support information, using the keyboard 12, the mouse 14, or the digitizer 15, and it is also possible to perform change, cancellation, and the like.
[0107]
As described above, the method of defining the book table format having the derived area according to the present embodiment has been described, but various modifications are possible. For example, FIG. 35 shows an example in which definition contents are specified from the screen. As shown in FIG. 35, the document contents of the input book table document are displayed on the display screen 20a, and while the input document contents are being checked, a predetermined specification is made using the keyboard 12, the mouse 14, or the like, so that a desired definition is obtained. You can enter information.
[0108]
In FIG. 35, the "screen designation" button is designated under the "definition" mode, and when the "screen designation" sub-mode is entered, "1. field", "2. data" are placed at appropriate positions in the display screen 20a. A sub-screen 94 appears, listing various definition items such as "item" and "3. data name". Here, the "entry number" of the normal entry information is clicked and instructed, and "2. data item" is selected and instructed on the sub-screen 94, and the normal entry information "sales number" is changed to the "sales number" of the data item. At the same time, the part of the click display changes to the special display assigned to “2. Data item”.
Similarly, by clicking and instructing the area 92 below the "sales number" column and specifying "1. field" on the sub-screen 94 for this area 2, the area 92 is filled with "sales number" data. A field is defined, and at the same time, the clicked portion changes to a special display assigned to “1. Field”. Here, the specific display assigned to the data item, field,... Appears in advance in the “definition element / entry information comparison table” shown in FIG.
In FIG. 35, for the sake of convenience of explanation, a state where the “data item” location 90 and the “field” area 92 are simultaneously selected and instructed is shown. However, in practice, one location is provided for each click. Selection is instructed.
[0109]
In the system, in response to the user operation as described above, the click position on the screen is repeatedly compared with the "position" information of the document element data held in the document element data storage unit 38, and the corresponding document element data Identify. Then, necessary definition data is generated from the identified document element data and the instruction content on the sub-screen.
[0110]
In the case of a book table including a compound field, the user first specifies “data item” and “field” for each data field by the above-described method on the screen, and then specifies “difference condition”. Writes the "difference condition designation character string" on the document through the screen, and draws the connection line from the corresponding data field. This "difference condition designation character string" and the connection line are entered by a known input means on the screen.
Next, after specifying the item name part (“year” in this example) in the “difference condition specification character string”, select and specify “2. data item” from the sub-screen, and (In this example, "2000"), and then select and specify "3. Data name" from the sub-screen. The same designation is made for the connection line on the sub-screen.
[0111]
Here, when the "define interpretation" button on the screen is instructed, difference condition definition data and derived area definition data are generated in addition to the item definition data of each data field that has already been created according to the above-mentioned instruction contents. .
[0112]
Further, the following method is also possible as a method of defining from the screen. After designating a certain data field on the screen, when "1. field" is designated on the sub-screen 94, an "item name designation menu" shown in FIG. 36 is displayed. In the “item name designation menu”, in addition to the “item name entry column”, a column for entering the “item name” and “data name” of the derived area is provided as a “difference condition entry column”. .
If the specified data field is a normal data field, enter the relevant item name only in the “item name entry field” above. If the specified data field is a composite field, enter the In the corresponding fields, enter the item name and data name of the difference condition. In the case of this example, "year" may be entered in the entry column of the item name in the "different condition entry column", and "2000" may be entered in the entry column of the data name.
[0113]
After making the above entry and clicking the "End" button on the "Item name specification menu", the "Item name specification menu" disappears, and then the corresponding "Difference condition definition data" and "Derived area definition data" are displayed. Created. In addition, a “difference condition character string” is generated and displayed in an appropriate blank portion outside the table in order to leave the specified content on a document.
[0114]
In the generated “difference condition character string”, whether the item name character string and the data name character string are enclosed by definition element symbols “<>” and “[]” for specifying the item name and Alternatively, a special display corresponding to each definition item is given and connected to the corresponding data field by a connection line.
Add the code of the definition element constituent symbol (“<” and “>” in the case of item name) to both sides of each character code string of the item name and data name of “difference condition definition data”, and add the item name code By connecting the column and the data name code column and giving appropriate written position information and format information (character size, pitch, etc.), one character string data is created.
Subsequently, a circumscribed rectangle of the difference condition character string is obtained, a side facing the data field side in the character string direction is obtained, and a side of the data field facing in parallel with this side is obtained. It is sufficient to generate a line segment connecting the sides of.
[0115]
Next, an example will be described in which data is actually output and tabulated on the tabulated table that has been defined as described above.
In this example, as the data file of the data output source, for example, a file having the configuration shown in FIG. 37 is considered. As shown in FIG. 37, the records which are the units constituting the data file have the item names “branch name”, “product category”, “product code”, “number of sales”, “sales amount”, “unit price”, “ Divided into division fields of “profit”, and each stores the corresponding data.
[0116]
In the apparatus of the embodiment, the data output process is performed in the “data output mode”. When the "mode" button on the display screen 20a is clicked and "data output" is selected from the mode list menu, the system is switched to the "data output" mode, and the "output source" as shown in FIG. The file list screen is displayed. The user may select the desired output source “1. sales file” from the displayed plurality of data files, and click the “output execution” button.
[0117]
In the system of the present embodiment, the data output unit in charge of the “data output process” is configured by the CPU 24 that executes a predetermined conversion or processing program, and the internal memory 16 or the external memory 18 that stores the program and related data. .
[0118]
When the output source data file is specified, an “item name association screen” (not shown) is displayed on the screen. On the "item name association screen", the item name defined on the output destination summary table and the definition item name of the output source data file are displayed in two columns, and the user can display the output destination and the output on the screen. The item names corresponding to the original can be associated by an operation of connecting the two with a mouse, for example.
[0119]
When the above-mentioned item name association operation is completed, when an "end" button on the screen is instructed, an "item name association table", which is a pair of columns in which the corresponding item names of the output destination and the output source are arranged, is displayed in the system. (Not shown), and the “data output entire process” starts.
[0120]
FIG. 39 is a flowchart showing the procedure of the “data output entire process”. First, the data of the output source file is output and totaled in cells other than the total column on the totaling table as the output destination. ("Data output processing"-Step F1)
Next, on the tabulation table, the data in each cell that has been output and entered is tabulated in a total column. (Total processing in table-Step F2)
Finally, all data output and entered on the tabulation table are converted into corresponding character string data. (Character string data processing-Step F3)
[0121]
The "data output process" (step F1) is performed in such a manner that records are extracted one by one from the output destination totaling table and the output source data file, and are repeatedly matched and matched. In this specification, a set of cells in which data constituting one record is written on a table is particularly called a “record cell column”. On the table, the “record cell column” can be extracted as follows.
[0122]
In the system of the present embodiment, the matching of data is performed as described above. Therefore, as a prerequisite for use of the system of the present embodiment, the notation of data is unified on the output destination summary table and the output source data file. Shall be.
[0123]
First, from among the cells constituting each “item definition data field” on the table, a set of cells on the same row and having different item names is identified as a parent of the “record cell column”. Next, for each cell within the identified “record cell column” matrix, a search is performed on the right-angle column including the cell. If there is a cell on the searched column that belongs to the data field of the new item name that is different from each item name of the “record cell column” parent, this cell is added to the cell set of the “record cell column” parent. In addition, if there is a set “item definition” as a common condition outside the table, a “record cell column” can be obtained in addition to the contained cells.
[0124]
In the case of this example, a combination of cells having the item names “product name” and “sales” is detected as the “record cell column” from the second row and lower rows of the table, and the cell name of the item name “sales” is detected. A cell with the item name “branch” is added on the column at right angles to the cell. Also, from outside the table, a cell with the item name “year” is added to the “record cell column”.
[0125]
In the case where a derived area is set in one cell as in this example, a record is obtained for each of the main area and the derived area from one “record cell column” extracted as described above. The data is then matched with the record retrieved from the output source data file. In this specification, a record obtained for the main area is called a "main record", and a record obtained for the derived area is called a "sub-record".
[0126]
The “sub-record” is obtained by referring to the “difference condition definition data” and making a change corresponding to the “main record”. For example, in the case of this example, the difference condition is that the item name “year” is “2000”, so the “sub-record” changes the data of the item name “year” in the “main record” from “2000” to “2000”. 2001 ".
[0127]
In the case of the aggregation table of this example, as shown in FIG. 40, for example, first, from the third row on the table, the third column on the table and the common condition outside the table, first,
The data "null" for the item name "sales",
The item name “Product” data is “Radio”,
For the item name "Branch", the data is "Osaka",
Data for item name "Year" is "2001"
The main record is obtained,
The data "null" for the item name "sales",
The item name “Product” data is “Radio”,
For the item name "Branch", the data is "Osaka",
Data for item name "Year" is "2000"
Will be obtained.
This sub-record is obtained by replacing the data of the item name “year” with “2001” in the main record and “2000”.
[0128]
Data output to a table in which such a “composite cell” is set is actually performed, for example, by extracting one “record cell column” from the table as described later and obtaining it from there. In the main record, all the records of the output source are output and aggregated, and then in the "sub-record" obtained from the same record, the data of all the records of the output source are output and aggregated. This is done in a repetitive manner for all records that can be retrieved from.
[0129]
Further, from the table, the “record cell column” can be extracted, for example, in the following order. Taking each row of the table from the upper side, if a row in which two or more “item definition data fields” are found is found, this row is used as a start row for taking out “record cell columns”, and The extracted "record cell column" is extracted.
[0130]
If the cell with the same item name is repeated on one line as in the data field of the item name "sales" in this example, the cells are taken out sequentially from the left cell, and for each cell taken out, "record cell" Column ”. That is, for the extracted cells, a search is performed on the column in the perpendicular direction, cells with other item names are added, and cells detected outside the table are also added to obtain a “record cell column”. repeat.
For the rows after the start row, the above procedure can be repeated to extract all the “record cell columns” on the table.
Note that the order of record retrieval from the output source data file may also be determined for convenience of processing, for example, in the order of file storage.
[0131]
Hereinafter, the “data output processing” processing will be described according to the procedure shown in FIG. When entering the "data output process", first, a record taken out from a data output destination and a data output source are set, and a total management table for performing mutual verification is created (step G1). FIG. 42 shows the format of the aggregation management table.
[0132]
In each column of the first line on the total management table, an item name is written. Enter the defined item name on the output summary table. The order of entry may be in any order. In the case of this example, the item names “sales”, “product name”, “branch”, and “year” are entered.
[0133]
In the second line, enter the “total category” of the item name. In the case of this example, a code “1” indicating “total item” is entered in a column corresponding to the item name “sales” (a column in the same column as the column in which the item name “sales” is entered). In the other column of the second row, a code “0” indicating “non-totaled item” is entered.
[0134]
In the third row, a cell data address of each cell constituting a “record cell column” extracted from the output destination summary table is set. If the output destination is a data file, the address in the record of the data file may be entered.
[0135]
In the fourth row, entry data in each cell of the output destination summary table is set. Numerical data is entered in the column of the item “summary category”, and text data representing the entered data is set in the column of the item “non-aggregate category”.
The corresponding character string data is extracted from the corresponding cell data, the text data is read as the code string, and, when the item is “total division”, the text data consisting of numbers is converted into numerical data. The distinction between numerical data and text data is set in the first predetermined bit in the same column.
[0136]
In the fifth row, when the output source is a table, a cell data address of each cell constituting the table is set. When the output source table is a data file as in this example, the address in the record of the data file may be entered. Refer to the "item name correspondence table" and set in the same column where the corresponding item name of the output destination is set.
[0137]
In the sixth row, entry data in each cell constituting the output source table or each data in a record extracted from the output source data file is set. As in the fourth row, the distinction between the numerical data and the text data is set in the first predetermined bit in the same column. As in the case of the fifth row, reference is made to the "item name correspondence table", and set in the same column where the corresponding item name of the output destination is set.
[0138]
The aggregation management table can be actually implemented, for example, as follows. List data (not shown) is provided for each entry column on the aggregation management table. Each list data stores data entered in each entry column and has row direction pointer data and column direction pointer data. , Data in each data entry column adjacent in the row direction or the column direction can be sequentially traced.
[0139]
In addition, a “main / sub flag” is provided in the tabulation management table. When a main record is set therein, the flag is set to “0”. When a sub record is set, “1” is set. The state of use may be determined.
[0140]
When the creation of the summary management table is completed, the take-out position of the "record cell column" is set to the start position from the output destination table (step G2), and the main record is taken out of the head "record cell column" to perform the summary management. Set in the relevant part of the table. (Step G3) That is, the cell data address of each cell constituting the corresponding “record cell column” is set in the column of the corresponding item on the third row, and the “entry data in the cell” is set in the third row. Set in the corresponding item column on four lines. (Step G4)
[0141]
If data has already been entered in the cell with the item “Aggregation category” on the output destination table, the corresponding character string is converted into numerical data by the above-described method, and then the corresponding column on the fourth line is entered. Set to. In the case of a cell in which no data is entered, as in the field of the item “sales” in this example, the start value “0” of the aggregation is set in the corresponding column of the fourth row.
[0142]
Next, all data in the output source data file is output and totaled for the main record taken out of the output destination totaling table and set on the totaling management table. (Step G5) Hereinafter, this procedure will be described with reference to FIG.
[0143]
Records are fetched one by one from the output source data file, one by one, and set on the fifth row in the total management table. (Step H2) Each data of the retrieved file record has a “numeric / text distinguishing flag” indicating whether it is “text data” or “numerical data” at the beginning, and is further on the fifth line. Is set in each column.
[0144]
The order of record retrieval from the output source data file may be determined for convenience of processing, for example, in the order of file storage. Refer to the item name corresponding data (created at the beginning of the entire output process) and set each component data of the record extracted from the output source data file in the entry column on the same column as the corresponding item name on the output destination summary table I do.
[0145]
Next, comparison and collation between the output destination data and the output source data having the same item name on the total management table are performed. (Step H3) The collation between the data is not performed when the data is not entered in the output destination and when the item is the “totaling category”. This comparison and collation is performed by comparing the data on the sixth row in the aggregation management table with the data on the fourth row on each corresponding column.
[0146]
In the above collation, if the output destination data and the output source data are the same for all the compared items, the following addition processing is performed. That is, the output source data of the item whose “category” is “total item” is added to the data of the output destination record. (Step H4)
In this example, if the data of the items "product", "branch", and "year" other than the item "sales" are the same, the data of the output source record of the item "sales" is added to the data of the output destination record Will do. This addition is performed by adding the data on the sixth row to the data on the fourth row in the corresponding column on the aggregation management table.
If at least one item of data that has been compared and collated between the output destination data and the output source data is not the same, this addition is not performed, and the process exits to the step of extracting the next record from the output source file. (Step H5)
[0147]
When all record data of the output source data file has been totaled for the “main record” extracted from one record extracted from the output destination table, the data is aggregated on this output destination record in the aggregation management table. Is transferred to the "cell data storage unit" of the corresponding cell in the output destination table. (Step G6)
[0148]
That is, the data on the fourth row of the aggregation management table is transcribed to the "cell data storage" of the cell data pointed to by the cell data address on the third row. If the corresponding cell is a “composite cell” as in this example, the data to be aggregated and posted is the data of the “main record”. It is transcribed to “In-cell data storage section” on the “information section” side. At this time, each data to be transcribed is stored in the "in-cell data storage" with the "numeric / text distinction flag" attached.
[0149]
As described above, when the summary posting to the “main record” obtained from one “record cell column” of the output destination table is completed, a “sub-record” is created from the same “record cell column”, and the Post up the output source data. The creation of the “sub-record” and its setting in the aggregation management table are performed as follows.
[0150]
As described above, the “sub-record” is pointed to from the corresponding “item definition data” when the “sub-record” is a “composite classification” by looking at the “item definition data” constituting the output destination table one by one. The "difference definition condition data" is taken out, and the "main record" taken out from the same "record cell column" is changed with reference to the "difference condition data".
[0151]
Since the corresponding “main record” has already been set on the aggregation management table, the “sub-record” can be obtained by replacing the set contents by “difference condition”. (Step G7) In this example, the “difference condition” is “2001” in the case where the data of “item name” and “year” is the main record, and “2000” is the “sub record” In the fourth row of the tabulation management table, the data with the item "year" may be replaced with "2000" from "2001" already set.
[0152]
As described above, all the data in the output source data file is totaled and transferred to the “sub record” extracted on the total management table, as in the case of the “main record”. (Step G8). As in the case of the “main record”, the records are fetched one by one from the output data file into the sixth row of the total management table, and the process of performing comparison and comparison with the data on the fourth row is repeated. Post it.
[0153]
When all the records of the output source file have been transferred and totaled in the “sub record” (on the fourth row of the total management table) of the output destination table, they are taken out in the same manner as in the case of the “main record”. To the cell data of (Step G9) That is, the data on the fourth row of the aggregation management table is stored in the “cell data storage section” on the “derived area entry information section” side of the cell data pointed to by the cell data address on the third row. Set to.
[0154]
When the above processing is completed for one “record cell column” extracted from the output destination table, the “next record cell column” is extracted from the output destination table, and the same processing is repeated. From the output destination table, for example, the “record cell row” can be sequentially extracted by the method performed in the above example.
[0155]
When the above totaling is completed for all “record cell columns” taken out from the output destination, next, “in-table total processing” for totaling these output data into a total column defined in the table is performed. (Step F2)
In the “total processing in table”, a predetermined total is performed for each “total column cell” in the data field to which the above “total definition” is applied. In the case of this example, the processing is performed on the “total column cell” set in the bottom row and the rightmost column of the table.
[0156]
In the “in-table total processing”, first, the cell data chain of the corresponding total field definition data is sequentially traced, each “total column cell” is extracted, and the “totaling target field” is identified. As described above, the “total field” is defined in a direction perpendicular to the corresponding total definition data field, and is detected as the item definition data field in the same column and the same row of the corresponding “total cell”.
[0157]
Next, with respect to all the constituent cells in the “total field”, the entry data therein is taken out, added, and the added result is entered in the “total cell”. Each cell in the “totaled field” sequentially follows the cell data chain created for the data field of the corresponding item definition data, and is on the same row or the same column as the corresponding “total column cell”. It can be retrieved by detecting things. The reading of the entry data in the cell may be performed from the in-cell data section storage of the corresponding cell data.
[0158]
As in this example, when each cell constituting the “total field” is a composite cell, as described above, the “total cell” also has the same “difference condition” and “derived area definition data”. Cell, and its cell data has already been switched to "composite cell data".
[0159]
First, the data stored in the "data storage unit in the cell" on the "main area entry information section" side in each compound cell data in the corresponding field to be counted is read and added, and the result is added to the "total column cell". Similarly, it is stored in the "cell data storage" on the "main area entry information section" side of the cell data.
Next, the data stored in the "cell data storage section" on the "derived area entry information section" side in each composite cell data in the corresponding aggregation target field is read and added, and the result is added to the "total column cell". "In the" cell data storage section "on the" derived area entry information section "side of the composite cell data.
[0160]
When the "in-table total processing" is completed, "character string data conversion processing" is performed (step F3), and this processing is not performed for non-totaled items originally entered in the output destination table.
From the cells in the table, for the cell of the summary item or the cell whose address data is not stored in the "cell character string data address storage" of the corresponding cell data, the "cell data" The data stored in the "storage section" is taken out, corresponding character string data is created, and the address is set in the "cell data character string data address section".
[0161]
If the data extracted from the "cell data storage unit" is numeric data, this numeric data is converted to text data by a known method. As a result, for example, in the file record, the data that simply represents the size of the numerical value “396” is converted to text data in which the characters “3”, “9”, and “6” are arranged.
[0162]
The corresponding character string data (position information is also defined) is created as follows from the text data. The entry destination (position information) of the corresponding character string data can be determined from the position information of the corresponding cell and the cell layout format. The cell layout format can be read from the field format information attached to the item definition data to which the cell belongs. The information includes a character size, a character pitch, an arrangement position (for example, designation of right justification, centering, and the like), a color of an input character, and the like. If the layout format is not specified by the user as in this example, it is determined by the device default.
[0163]
First, a rectangle circumscribing a character string is determined from the size and pitch of each character registered in the cell format information. Subsequently, the in-cell position of the circumscribed rectangle is obtained by referring to the arrangement position information in the cell of the character string (for example, designation of right justification, centering, etc.). Next, by referring to the document position of the corresponding cell (set in the corresponding cell data), the document position of the corresponding circumscribed rectangle can be obtained, and the document position of the corresponding character string can be obtained. . Corresponding character string data is created from the text data and position information thus obtained, and the address is set in the cell character string data address of the corresponding cell data (FIG. 20).
[0164]
In the case of a composite cell, conversion and creation of two data entered therein into character string data are performed as follows. Reads the "division position" information and "left and right margin values" extracted from the "derived area definition data" defined for the composite cell, and derives the main area from both the information and the position information of the entire composite cell. A “data character string entry range” is obtained for each of the areas. FIG. 32 shows the relationship between the “data character string entry range”, the “division position” information, and the “left and right margin values” of the main area and the derived area.
[0165]
For each of the main area and the derived area, the position information is obtained from both the corresponding "data character string entry range" and the data extracted from the corresponding cell data storage unit in the same manner as in the case of the normal cell described above, and the character is obtained. Column data can be obtained. The character string data created for each of the main area and the sub area is the same as the case of the normal cell, and the main area side “character string data address storage unit” and “derived cell side” in the corresponding composite cell data, respectively. The address is set in the “internal character string data address storage section”.
[0166]
At this time, it is checked whether or not the corresponding "derived cell generation element" for generating the derived area is entered in each derived cell, and if not, the corresponding symbol is newly added. Generate and fill out.
Take out the compound cells of the corresponding data field one by one, take out all the characters, symbols, etc. written on the derived area side of the "division position", and from that, select the "derived area generation element" of the corresponding "type". It is determined whether a combination is obtained. The "type" of the corresponding "derived area generation element" is known from the corresponding "derived area definition data", and the symbol codes constituting the "derived area generation element" and the order of entry are obtained from the "type" obtained now. Through the "derived area generation element dictionary".
[0167]
If the "derived area generating element" is not entered in the cell, a "derived area generating element" is generated and entered as follows. As described above, for the symbols that make up the "derived area generation element" to be filled in, know the code and mutual entry order, and "divide position" and "left and right margin" information registered in the derived area definition data , The arrangement position in the cell can be obtained. Next, referring to the written position information of the entire cell (registered in the cell data), the written position information of the constituent symbol of this "derived area generation element" is obtained, and the corresponding document element data (character string data ) Can be obtained.
[0168]
The character string data generated as described above is stored in the document element data storage unit 38 together with other document element data originally written in the book table.
[0169]
Therefore, the document image output unit 40 reads out all the document element data corresponding to the (black) normal entry information from the document element data storage unit 38, and stores the read document element data in the character / graphic pattern dictionary 36. The target document table output document as shown in FIG. 10 is displayed on the display screen 20a, for example, by inquiring to identify the pattern of each document element and converting each pattern into bitmap image data by a development program. can do. Further, it is also possible to print out by the printing device 22 or to perform facsimile transmission by the communication device 24.
[0170]
Next, handling of the tallying format shown in FIG. 44 in the present system will be described. In this format, a "derivative area" is provided in each of the data fields of the item name "sales", and data of the item name "profit" is entered therein. The "definition" for this format is performed by designating the item name "profit" as the "difference condition" for the data field of the item name "sales" provided with the "derived area".
In other words, for the same format, except for the "difference condition", perform the same "definition" as in the above example, enter the character string "profit" in an appropriate margin outside the table, and enter the relevant definition element. The item name can be specified by a symbol, and then connected to the corresponding data field by a “connection line”. Since the item name “profit” is a tabulated item, a definition element symbol “O” is added to the right shoulder thereof, as in the case of the item name “sales”. (FIG. 45)
[0171]
With the above specification, in the case of this format, the definition data other than “Difference condition definition data” will be the same as the above example, and “Difference condition definition data” will be the “Item name” in which only the item name is set Format "in which item name text" profit "is entered.
[0172]
Considering the case where data output is instructed from the same data file as in the above example for this format, the following procedure is performed. First, refer to the item name "difference condition definition data", and if the difference condition is "item name type" as in this example, the applicable item of the item definition data to which "difference condition definition data" is linked The row position in the management table where the name (“sales” in this example) is set is stored as a “difference condition replacement item position” at a specific address in the work area set for this output processing in the memory. deep.
[0173]
From the summary table, first, as in the above case, the "record cell column" is taken out, and from there, the "main record" is taken out as in the above case and set on the management table, The data of the data output source is transcribed and aggregated in the same manner as in the above case. The data tabulated in the table is transcribed to the "cell data storage section" on the "main area entry information section" side of the corresponding cell data, as in the above example.
[0174]
The “sub-record” of the same “record cell column” is based on the “main record” previously set on the aggregation management table, and is based on the entry data of the “difference condition replacement item position” on the first row thereof ( In the case of this example, it is set by replacing "sales" with the item name "profit" entered in "difference condition definition data".
From then on, the “sub-record” set on the management table is subjected to the matching transfer with the output source record in the same manner as described above. That is, on the column in which the item name “profit” is set, the data of the item name “profit” of the output source record is totaled. The data tabulated on the tabulation management table is transcribed to the “cell data storage section” on the “derived area entry information section” side of the corresponding cell data, as in the case of the above example.
[0175]
After the above posting and aggregation of the “sub-record” is performed, the next “record cell column” is taken out, and the “main area” item is again placed in the “difference condition replacement item position” in the first row on the management table. The name “sales” (defined in the item definition data in which the composite cell is defined) is set, and the same procedure is repeated thereafter.
The data stored in the "main area area entry information section" and the "derived area entry information section" of the cell data, "in-cell data storage section", is converted to character string data in the same manner as described above.
[0176]
The present invention uses a program or software for realizing the functions of the present invention described above. Such software can be installed in the system of the present invention via an arbitrary medium, for example, a storage medium or online. Therefore, an act of transferring a storage medium storing software for implementing the present invention as a business, an act of installing the software on a system online, and the like are one embodiment of the present invention.
[0177]
【The invention's effect】
As described above, a complex form format with a derived area can be completed by the same item definition operation and simple difference condition specification as a normal form format without a derived area. Batch input / output of data can be performed by a simple operation at the same level as the specification operation performed on the form format.
[0178]
In addition, since predetermined definition support information consisting of characters, symbols, and figures that are familiar in daily life can be additionally written, designation of a difference condition can be performed mainly by writing a character string that anyone can understand. Anyone can do it with simple tasks or operations, and the definition is highly visible so that everyone can understand it at a glance.
[0179]
In addition, the above definition requires minimal additional input of the above-mentioned symbols, and can be performed efficiently and with less errors.
[Brief description of the drawings]
FIG. 1 is a block diagram illustrating an example of a system configuration on hardware of an information processing apparatus according to an embodiment of the present invention.
FIG. 2 is a diagram showing a list of main modes in the system according to the embodiment.
FIG. 3 is a diagram showing a “main mode-view menu screen” in the system according to the embodiment.
FIG. 4 is a diagram showing an “environment setting mode screen” in the system according to the embodiment.
FIG. 5 is a diagram showing a “definition element / entry information comparison table” in the system according to the embodiment.
FIG. 6 is a diagram illustrating a data format example of “definition element identification data” in the system according to the embodiment.
FIG. 7 is a diagram illustrating a “definition information distinction instruction screen” in the system according to the embodiment.
FIG. 8 is a diagram illustrating a data format example of “definition information distinction data” in the system according to the embodiment.
FIG. 9 is a diagram illustrating an example of a book table format in the system according to the embodiment.
FIG. 10 is a diagram showing an example of data output to a book table format in the system according to the embodiment. Example of a book table with data
11 is a diagram showing an example in which definition support entry information is additionally entered in the book table format of FIG. 9 in the system of the embodiment.
FIG. 12 is a block diagram illustrating a configuration of a document input and document element data generation unit in the system according to the embodiment.
FIG. 13 is a diagram illustrating a data format example of “image management data” in the system according to the embodiment.
FIG. 14 is a diagram illustrating a configuration of an input image that is a target of “image management data” in the system according to the embodiment.
FIG. 15 is a diagram illustrating a data format example of “character data” in the system according to the embodiment.
FIG. 16 is a diagram illustrating an example of a data format of “character string data” in the system according to the embodiment.
FIG. 17 is a diagram illustrating a data format example of “graphic element data” corresponding to a line segment in the system according to the embodiment.
FIG. 18 is a diagram illustrating a data format example of “graphic element data” corresponding to an ellipse in the system according to the embodiment.
FIG. 19 is a diagram illustrating a data format example of “graphic element data” corresponding to a rectangle or the like in the system according to the embodiment.
FIG. 20 is a diagram illustrating a data format example of “cell data” in the system according to the embodiment.
FIG. 21 is a block diagram illustrating a configuration of a definition information recognition and format setting unit and a definition execution processing unit in the system according to the embodiment.
FIG. 22 is a diagram illustrating a data format example of “definition element data” in the system according to the embodiment.
FIG. 23 is a diagram illustrating an example of an overall procedure for creating definition data in the system according to the embodiment.
FIG. 24 is a diagram illustrating a data format example of “item definition data” in the system according to the embodiment.
FIG. 25 is a diagram showing a data format of “total definition data” in the system according to the embodiment.
FIG. 26 is a diagram illustrating an example of terms included in an applied term dictionary in the system according to the embodiment.
FIG. 27 is a diagram illustrating a data format example of “dictionary term data” in the system according to the embodiment.
FIG. 28 is a diagram illustrating a relationship between a total field, a total column cell, and a field to be counted in the system according to the embodiment.
FIG. 29 is a diagram showing a flowchart of a composite field definition process in the system of the embodiment.
FIG. 30 is a diagram illustrating a data format example of “difference condition definition data” in the system according to the embodiment.
FIG. 31 is a diagram showing a position direction in a cell of a derived area in the system according to the embodiment.
FIG. 32 is a diagram showing the entry range of a derived area in the system according to the embodiment.
FIG. 33 is a diagram illustrating a data format example of “derived area definition data” in the system according to the embodiment.
FIG. 34 is a diagram illustrating a data format example of “composite cell data” in the system of the embodiment.
FIG. 35 is a diagram showing a definition screen based on an instruction from the screen in the system according to the embodiment.
FIG. 36 is a diagram illustrating an example of an “item name designation menu” in the system according to the embodiment.
FIG. 37 is a diagram illustrating a configuration example of an output source file in the system according to the embodiment.
FIG. 38 is a diagram showing an example of a data output mode screen in the system according to the embodiment.
FIG. 39 is a diagram showing a flowchart of “whole data output processing” in the system of the embodiment.
FIG. 40 is a diagram showing an image of “record cell string” extraction in the system according to the embodiment.
FIG. 41 is a diagram illustrating a flowchart of “data output processing” in the system of the embodiment.
FIG. 42 is a diagram showing an image of a “total management table” in the system according to the embodiment.
FIG. 43 is a diagram showing a flowchart of “main record (sub record) data output processing” in the system of the embodiment.
FIG. 44 is a diagram illustrating an example of a second book table format in the system according to the embodiment.
45 is a diagram showing an example in which definition support entry information is additionally entered in the book table format of FIG. 44 in the system of the embodiment.
[Explanation of symbols]
10. Color image scanner
12 Keyboard
14 mouse
15 Digitizer
16 Internal memory
18 External memory
20 Display device
24 CPU
27 Communication equipment
30 Document image input unit
32 Document image storage
34 Character / graphic element recognition unit
36 character / graphic pattern dictionary
37 Character / graphic element input section
38 Document element data storage
40 Document image display output unit
42 Definition element data generator
44 Definition element data storage
46 Definition data generator
48 Definition Element Identification Data Storage Unit
50 Definition information distinction data storage unit
52 Application Term Dictionary
54 Book table definition data storage
90 Data item name
92 fields
94 Designated menu

Claims (3)

A data input / output method in a book table format, comprising the steps of: defining an item in a table to associate data or a data field with an item name; and providing a derived area as a second data entry area in one cell. Specifying a difference condition, which is an entry condition inherent to the main area whose derived area is the first entry area in the same cell, for the specified data field, wherein the designated item definition and the difference condition A book table format comprising a step of routinely identifying data to be referred to at the time of inputting / outputting the book table data or a record which is a set of data entry areas for each derived area based on the Data input / output method. 2. The data input / output method of a book table format according to claim 1, wherein a data entry area of a main area and a data entry area in a cell is identified by recognizing a symbol that divides an exemplary entry area. A data input / output method in a book format. A data input / output device in a book table format, comprising means for defining an item in a table for associating data or a data field with an item name, and a derived area which is a second data entry area in one cell. Means for designating a difference condition, which is an entry condition unique to the main area whose derived area is the first entry area in the same cell, for the specified data field, the designated item definition and the difference condition For each derived area, the data to be referred to at the same time when inputting / outputting the data in the book table, or the data input in the book table format characterized by the standard identification of the record which is a set of data entry areas. Output device.

Images