JPH0696104A - Table editing system provided with calculating formula defining function - Google Patents

Abstract

PURPOSE:To reduce operations for preparing a table by enabling to have a clear calculating formula definition using item names and eliminating limit for the form of the table to be prepared as well, even in the case of a complicated table in which items conventionally impossible calculating formula definition are formed in plural steps. CONSTITUTION:A means for preparing the table of an editing object, means for editing the table, means for performing the calculating formula definition and means for performing defined calculation are provided on a hardware system. The means for performing the calculating formula definition is provided with an item setting means for setting the frame of the prepared table as an item corresponding to designation inputted from an input device 4a, item name/ data corresponding relation preparing means for preparing and preserving corresponding relation data showing corresponding relation between item name data expressing the item name inputted in the frame set as the item and data belonging to the item so as to be the object of calculation, and means to define the calculating formula while defining the item name data of the set item as formula elements as they are.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table editing system for editing a table, and more particularly to a table editing system having a calculation formula defining function.

[0002]

2. Description of the Related Art In a conventional system of this kind, there is a system in which numerical values arranged in items of a created table can be calculated by defining a formula for designating the items. In this case, the system gives a system name, for example, a number indicating each item of the created table, and displays this. In this system, the user can define the calculation formula for the items in the table by using the displayed system name, and the user defines the name corresponding to the system name. be able to. Then, the defined name is used to enable the expression definition. For example, Japanese Patent Laid-Open No. 3-2
In the spreadsheet device disclosed in Japanese Patent No. 86362,
When the user sets an arbitrary name for the system name, it is displayed as an item name in the item frame, and it is possible to define an expression using it.

[0003]

The conventional method has the following problems. Since the item name is an arbitrary name set by the user for the system name, the user must always be aware of the system name and set the item name. Also, because the name is defined for the system name,
When calculating the definition formula, the system needs to perform conversion in three stages of item name ⇒ system name ⇒ data.

Further, in the conventional method, in the case of a complicated table having a plurality of items, it was not possible to define a calculation formula using the item. For this reason, conventionally, there has been a problem that the table format to be created is limited and the table creating operation is burdened.

An object of the present invention is to allow an arbitrary frame in a table to be an item, to enable the calculation formula definition by using the data in the frame of the item as a formula element, and the item can be a plurality of stages. Even in such a complicated table, it is possible to define an easy-to-understand calculation formula using item names, and there is no restriction on the format of the created table, and a table editing system that reduces the load of table creation operations is provided. Especially.

[0006]

To achieve the above object, according to the present invention, an input device for inputting data, instructions, etc., a display device for displaying various data including a table, and a program A hardware system having a central processing unit for executing processing of data according to the above, and a storage device for storing programs and data, and means for creating a table to be edited on this hardware system, In the table editing system for realizing the means for editing, the means for defining the calculation formula, and the means for performing the defined calculation, the means for defining the calculation formula is
An item setting means for setting the frame of the created table as an item according to the designation input from the input device, and item name data representing the item name input in the frame set as the item, Item name / data correspondence creating means for creating and saving correspondence data indicating correspondence with data to be calculated, which belongs to the item, and item name data of the set item are directly used as expression elements. There is provided a table editing system having a means for defining a calculation formula.

The means for performing the above-described calculation corresponds to the formula element of the defined calculation formula by referring to the item name / data correspondence data for each item name data constituting the formula element. It may have a function of acquiring data and performing calculation.

The item setting means can perform item setting for horizontal items arranged in the row direction of the table and vertical items arranged in the column direction. Further, the item setting means receives a designation from the input device regarding a frame of the table displayed on the display device, recognizes an item for the designated frame, and inputs the item within the frame. It can have the function of obtaining a name.

The item name / data correspondence creating means is
It is possible to create an item name / data conversion table showing the correspondence between the horizontal items and vertical items set by the item setting means and the data to be calculated and the calculation result.

The means for creating the table to be edited may further have a function of attaching a unique identifier to each frame constituting the table and storing the identifier in correspondence with the frame. In this case, the means for defining the calculation formula may further include means for defining the calculation formula using the identifier attached to the item frame.

The means for defining the formula is defined by using the item name data of the set item as a formula element to define the formula and the identifier attached to the frame of the item. The configuration may further include means for accepting a selection of whether to define a calculation formula by any of the means for executing the definition of the calculation formula and executing the definition of the calculation formula by the selected means.

According to another aspect of the present invention, an input device for inputting data, instructions, etc., a display device for displaying various data including a table, and processing of data according to a program. A hardware system having a central processing unit and a storage device for storing programs and data is provided. Means for creating a table to be edited, means for editing the table, and formulas on this hardware system. In the table editing system that realizes the means for performing the definition and the means for performing the defined calculation, when the table is created, the means for performing the above-mentioned calculation formula definition is arranged in the row direction of the table and in the column direction. Item name / data that shows the correspondence between all non-overlapping combinations of aligned vertical items and the calculation target data and calculation results belonging to that combination A conversion table is created and stored, and an item name / data correspondence creating means and means for defining a calculation formula by directly using the item name data of each item as a formula element are provided. The means for performing is a function for performing calculation by referring to the item name / data conversion table for each item name data forming the formula element of the defined calculation formula, obtaining the corresponding data. There is provided a table editing system characterized by having:

Further, in each of the above aspects of the present invention, when the item name is rewritten by an input from the input device, the item name / data conversion table is searched for the item name before being rewritten, and means for rewriting it. When the item name is rewritten by the input from the input device, the calculation formula defined above is searched for the item name before being rewritten, and a means for rewriting it can be provided.

[0014]

[Function] The item setting means, regarding the frame of the created table,
Set as an item according to the designation input from the input device. This allows the user to specify an arbitrary frame as the item frame.

Further, the item name / data correspondence creating means associates the item name data representing the item name entered in the frame set as the item with the data which belongs to the item and is to be calculated. Create and save the correspondence data that shows the relationship. This allows the frame data to be directly used as an element of the definition formula. Further, the means for defining the calculation formula defines the calculation formula by using the item name data of the set item as it is as the formula element. This allows the system side to directly obtain the data to be calculated from the item name. Therefore, it is possible to calculate the definition formula without using the system name.

Further, since an arbitrary frame can be designated as an item, the conventional name setting operation in consideration of the system name can be omitted, and the data to be calculated can be directly obtained from the item name. Therefore, the operation of item name ⇒ system name ⇒ data conversion is not required, and editing operation and work efficiency can be improved.

According to the present invention, an arbitrary frame in the table can be used as an item, and the data in the frame of the item can be defined as a calculation formula as a formula element. Even in a complicated table with multiple rows of items,
It is possible to define an easy-to-understand calculation formula using item names, and there is no restriction on the format of the table to be created, which is extremely effective in reducing the table creation operation.

[0018]

Embodiments of the present invention will now be described in detail with reference to the drawings.

FIG. 1 shows the configuration of a table editing system according to an embodiment of the present invention, (A) is a block diagram showing the hardware system configuration of the main body, and (B) is a screen configuration diagram of a display.

The table editing system of this embodiment is composed of a computer system. That is, as shown in FIG. 1A, the system according to the present embodiment has an input device 4a for inputting data, instructions, etc., a display device 5a for displaying various data including a table, and a program according to a program. The hardware system has a central processing unit (CPU) 1 that executes data processing and controls the entire system, and a storage device that stores a program and data as main components. The above realizes means for creating a table to be edited, means for editing a table, means for defining a calculation formula, and means for performing a defined calculation. Although not shown, a printer or the like may be provided in addition to this.

The input device 4a includes a keyboard 6 and a mouse 7.
And input / output controller 4 for controlling these.

The display device 5a has a display 8 and a display controller 5 for controlling the display 8.

As the storage device, a main storage device 2 which stores an operation program of the central processing unit 1 and serves as a work area when the central processing unit 1 executes the program.
And an auxiliary storage device 3 for storing programs, data, files and the like. The main storage device 2 stores at least a program for executing procedures shown in various flowcharts described later as an operation program, and at least data of a table to be edited, an item name / data conversion table, etc. as data. To be done. Of course, these are also stored in the auxiliary storage device 3.

In the table editing system of the present embodiment, the means for defining the calculation formula is an item setting means for setting the frame of the created table as an item according to the designation input from the input device 4a. , Item name that creates and saves the correspondence data that shows the correspondence between the item name data that represents the item name entered in the frame set as the item and the data that belongs to the item and that is the calculation target / Data correspondence relation creating means and means for defining a calculation formula using the item name data of the set item as the formula element as it is.

On the display 8, as shown in FIG. 1B, an edit screen 9 for displaying a table to be edited and an edit command 10 for giving a table edit operation instruction are displayed. By using the edit command 10 in the edit screen 9, the character 11a, the numerical value 11b, and the table 11c can be freely arranged. Further, the characters 11a and the numerical values 11b can be similarly arranged in the frame of the displayed table 11c.

The edit command 10 includes, for example, delete 10
a, copy 10b, move 10c, attribute 10d, ruled line addition 1
0e, division 10f, extension 10g, calculation formula definition 10h, and item setting 10i command designation areas are provided. By instructing any command, for example, the calculation formula definition 10h by the mouse 7, the corresponding edit command "calculation formula definition" is activated, and the CPU 1 executes the processing to execute the calculation formula definition means. To be realized. Although the command processing will be described later, the CPU 1 displays necessary characters, figures, etc. on the display when executing the instructed commands, and performs the processing. Also, among the edit commands 10, the one picked with the mouse indicates that it can be processed, and therefore the display mode is changed as shown in FIG. 4 (A). The display mode can be changed, for example, by shading, highlighting, changing display color, changing brightness, blinking, and the like.

Next, the operation of this embodiment will be described with reference to the drawings.

FIG. 2 is a flow chart showing the outline of an example of the processing procedure of the table editing system of this embodiment. Also,
FIG. 3 shows an example of a table created by the table editing system of this embodiment and an example of a table of items and data corresponding to the table.

In the calculation formula defining process of the present embodiment, it is not necessary to perform the setting operation of the item name for the system name which has been conventionally performed, and the user can specify any frame of the created table as the item frame. The data in the frame can be used for formula definition. Therefore, even in the case of a complicated table in which the horizontal items 33 extend over one copy and two rows as shown in FIG. 3, the user can arbitrarily set the frame to be the item in the present embodiment, and thus the setting is performed. The formula can be defined by the item name in the item frame.

First, the system is shown in FIG.
Of the editing commands 10 shown in (B), item setting 10i
When is picked up, start “Item setting” and move the mouse 7
In response to the operation of, the specification of the item frame is accepted (step 2
01), as shown in FIG.
i is shaded.

To specify the item frame, for example, first, January,
.., deposit, ..., The balance is picked up with the mouse 7 in this order. the system,
In response to this designation operation, the picked (designated) frame is recognized as an item frame, the frame is highlighted on the display screen, and the item frame flag is set for the designated frame ( Step 202). This flag is set in the flag area of the main storage device 2 in correspondence with the data indicating the frame.

On the basis of this flag, the system acquires the data in the item frame to which the flag is added as the item name, and uses the "item name / data conversion table" 35
After creating the "item name / data conversion table" 35, the shaded display of the item setting 10i is canceled (step 203). In this table, as shown in FIG. 3, the item frame is divided into a row direction 33 and a column direction 34, and the row direction 33 is a horizontal item 38 and the column direction 34 is a vertical item 39. It is a structure that can extract the data inside.

Next, the system is operated by the mouse 7 as shown in FIG.
Of the editing commands 10 shown in (A), the calculation formula definition 10
When h is picked, the calculation formula definition 10h on the display screen is shaded as shown in FIG. In addition, the system accepts the definition of the calculation formula in which the data in the frame designated as the item is input by the user from the keyboard 6 as the formula element, and the execution instruction from the user (step 204). Here, the calculation formula 36 defined is
As shown in FIG. 4B, the expression element 37 and the operator are included. The expression element 37 has a horizontal item 38 at the beginning and a vertical item 3 next.
Definitions are made in the order of 9.

When the execution is instructed, the system analyzes each element of the definitional expression (step 205), obtains data directly from the item name of the expression element (step 206), and performs calculation based on that (step 206). In step 207), the result is displayed on the screen and the shaded display of the calculation formula definition 10h is canceled (step 208).

Next, the creation of the "item name / data conversion table" will be described in more detail with reference to the drawings.

First, an outline of table creation will be described with reference to FIG. Here, FIG. 5A is a flowchart showing the process of creating the “item name / data conversion table”, and FIG. 5B shows an example of the data table created there.

When the item frame is designated by the user, the system first takes out horizontal items, which are frame data in the row direction, and sets them in the table 45 (step 501).
Next, it is confirmed whether or not there is a vertical item frame which is a frame in the column direction (step 502). If there is a vertical item frame, the vertical item is taken out and set in the table 45 (step 503). If the horizontal items and vertical items are complete, No. 2
The in-frame data of the part where the two frames intersect is set in the table 45 (step 504). Then, when there is no vertical item for the horizontal item, it is determined whether there is a next horizontal item, and if there is, the above operation is repeated (step 5).
05). In this way, this operation is repeated for all horizontal items for the number of vertical items, and the "item name / data conversion table" is displayed.
Create 45.

Next, details of creating the item name / data conversion table will be described with reference to FIGS. 6 to 8.

FIG. 6 is a flowchart showing the procedure for creating the item name / data conversion table, and FIG. 7 is an explanatory diagram showing an example of the coordinates of the table used when setting the item frame.

In the system, first, the upper left coordinates (X1, Y) of the frame (designated frame) in the area designated by the user with the mouse 7 are set.
1) is acquired (step 601). Further, the system takes the upper left coordinate of the other designated frame, for example, (X2, Y2) (step 602). Here, the coordinates of the frame are defined as shown in FIG. That is, as shown in FIG. 7, with respect to the table, the upper left of the table is the origin (0, 0), and the positive direction of the X axis is rightward and the negative direction of the Y axis is downward. Then, the coordinates of the frame of each item are determined based on this coordinate system. Also for each frame, the upper left coordinates of each frame are taken.

Then, the upper left coordinates of the designated frames acquired in steps 601 and 602 are compared to determine whether or not the frames are in different matrixes (step 603). As a result, when these frames have the same row or column, there is no frame at the intersection, so the frame to be processed is changed to another designated frame without performing the data set process (step 604).
Compare again.

If the row and the column are different, it is determined whether or not the combination of the vertical item and the horizontal item already has an item of the same combination (step 605). If it already exists, step 613 is performed without performing the data set processing.
Then, it is determined whether or not there is a frame to be processed. If there is a frame to be processed, the frame to be processed is changed to another designated frame (step 614) and the process is repeated.

If there is no combination of the same items, the in-frame data of a frame having a small Y coordinate is acquired and set in the item name / data conversion table as a horizontal item. On the other hand, the data in the frame having a large Y coordinate is acquired and set in the item name / data conversion table as a vertical item (step 606). Then, the width W1 of the frame having a small Y coordinate, for example, the "payment" frame in FIG. 7 is acquired (step 607). The height H1 of a frame having a large Y coordinate, for example, the “January” frame in FIG. 7 is acquired (step 608). Further, a frame serving as an intersection, that is, a frame having (X1, Y2) as an origin, “5” in the example of FIG.
The width W2 and the height H2 of the "00" frame are acquired (step 609).

Next, the system sets the widths W1 and H1 obtained in steps 607 and 608 and step 6
The width W2 and the height H2 acquired in 09 are compared to determine whether or not the intersection frame is the intersection frame of only the vertical item frame and the horizontal item frame (step 610). If the intersection frame is an intersection frame of only vertical items and horizontal items, the data in the relevant frame, for example, "500" is set in the data portion of the item name / data conversion table (step 611). If the intersection frame is not an intersection frame of only vertical items and horizontal items, invalid (-) data is set in the data portion of the item name / data conversion table (step 612).

Next, the system determines whether or not there is a designated frame other than the frame targeted in step 602, excluding the frame targeted in step 601 (step 61).
3). In this case, the frame to be processed is changed to another designated frame (step 614). Then, the processes from step 602 are repeated. In this iterative process, the order of the designated frames selected by the user is assumed to be, for example, as shown in FIG. If the target frame in step 601 is, the other designated frames in step 602 are ,,, and. Therefore, in the processing from step 602 to step 614, the target frame is compared with each of the other designated frames ,.

Next, the system determines whether or not there is a frame specified next to the frame targeted in step 601 (step 615). If it exists, the target frame is changed to the next frame (step 616), and the processing from step 601 onward is repeated. Here, in this iterative process, the order of the designated frames selected by the user is assumed to be performed as shown in FIG. 8B, for example. If the target frame of step 601 is, then the target frame of step 601 is
Becomes Then, from then on, it becomes a target in the order of.

Next, another embodiment of the present invention will be described with reference to the drawings. In this embodiment, an arbitrary frame can be used as an item without designating an item frame, and calculation formula definition and calculation are performed. Other configurations can be similar to those of the above-described embodiment. Here, the difference will be mainly described.

In this embodiment, as shown in FIG.
The system creates an intersection frame data search table 46 based on the in-frame data in accordance with the table creation. This is a table that has combinations of all frames in the table in vertical items and horizontal items and can acquire data of each intersection frame. As a result, the data can be directly acquired from all the in-frame data in the table. Therefore, the user is in charge of FIG.
As shown in, it is possible to directly define the expression 47 using the data in the frame as an element without designating the item frame used as the formula element.

Next, calculation formula processing using the data search table described with reference to FIG. 9 will be described based on the flowchart of FIG.

First, the horizontal item written at the head of the target calculation formula 47 element is taken out (step 1001). This horizontal item is searched in the data search table 46 (step 1002). The presence or absence of the corresponding item is determined (step 10
03), if there is no applicable item, the calculation cannot be performed, and therefore the processing is moved to the next calculation formula. If there is a corresponding item, then the vertical item of the same expression element is taken out (step 1004). This vertical item is also searched in the data search table 46 (step 1005). If there is no applicable item, it cannot be calculated like the horizontal item, so the process moves to the next formula.

If there is a corresponding item, it is judged whether the target expression element is the right side (step 1006). In the case of the left side, it is the output destination of the result and the acquisition of the intersection frame data is meaningless. Therefore, the target expression element is switched to the next element (step 1011) and the process is repeated from the beginning. In the case of the right side, the intersection frame data is acquired (step 1008) and the data is stacked so that it can be used in the calculation process (step 1009).

Next, it is determined whether or not there are more expression elements (step 1010). In some cases, the target expression element is switched to the next element (step 1011), and the intersection frame data acquisition process is further continued. If not, the intersection frame data acquisition process ends, and calculation is performed based on the stack data (step 1012). After the calculation, the result is displayed on the display 8 (step 1013).

Then, it is determined whether or not there is the following calculation formula (step 1014). If there is the next formula, switch the target formula to the next formula (step 101).
5) Continue processing. If there is no next calculation formula, the process ends.

According to the present embodiment, in the case of the fixed calculation processing in which no special item is designated, the item frame can be automatically set, and the calculation formula processing can be performed based on the setting. There is an advantage.

In each of the above embodiments, the formula definition is performed using the item name in the item frame designated by the user. However, the present invention is not limited to this. For example,
It is also possible to have a configuration in which the user can select whether to use the system name prepared by the system for the expression element used in the expression definition or to specify the item frame and use the item name.

Next, an embodiment capable of such selection will be described with reference to FIGS. 11 and 12. Figure 11
(A) is a flow chart showing a processing procedure of a setting switching method in which the user can select the expression element used in the expression definition by the system name prepared by the system or by specifying the item frame and by the item name, FIG. 6B is an “item name / system name switching sheet” which is a window for the user to make a switching instruction. FIG. 12 shows the table configurations for the system name and the item name.

When creating a table, the item name may not be necessary for the purpose of only the table calculation depending on the form of the table.
In such a case, it is more efficient to use the system names such as a and b prepared by the system as items and to perform the calculation formula definition process without performing the item frame designation operation. The present method handles such a case.

First, the user uses the mouse 7 on the "item name / system name switching sheet" 76,
The selection of whether the expression element name is the item name or the system name is accepted (step 1101). Here, when the item name is designated, as described in FIG. 3, the designation of the user's item frame is accepted (step 1106), and the item frame flag is set in the designated frame on the system side (step 11).
07). Then, based on this, the "item name / data conversion table" 77 shown in FIG. 12 is created (step 110).
8). After that, the definition of the calculation formula definition 71 using the item name by the user is processed, and the calculation is instructed to the system (step 1109). The system analyzes the definitional expression (step 1110) and acquires data from the item name of the expression element using the "item name / data conversion table" 77 (step 1111).

When the system name is specified, the items are fixed. Therefore, the system side creates a "system name / data conversion table" (step 1102), and in the item frame of the table, the system names such as a, b, etc. Is displayed. From the user
When the calculation formula definition 65 is performed with the system names such as a and b, the calculation formula definition 65 is accepted and the calculation is instructed to the system (step 1103). The system analyzes the definitional expression (step 1104) and obtains data from the system name of the expression element using the "system name / data conversion table" 78.

Whether the item name is used or the system name is used, the calculation process is performed after the data acquisition (step 1112), and the calculation result is displayed on the display 8 (step 1113).

Although each of the above embodiments shows an example in which the items in the frame are not changed, the items in the frame can be changed as appropriate. Next, an example in that case will be described.

FIG. 13 is a flow chart showing a processing procedure in which the system automatically changes the item name in the expression element when the user changes the item name in the item frame. FIG. 14 shows the expression element change by changing the item name. Shows an example of and the table state at the time of change.

This process corresponds to the formula definition 1 by specifying the item name.
As a function, when the user changes the item name in the item frame, the system updates the "item name / data conversion table" and also changes the item name in the expression definition.

As shown in FIG. 14, the user changes the item name “receipt 89” in the table frame to a deposit 90 item name 78.
To do this, the item name is input from the keyboard 6. The system accepts this (step 1301) and first searches for a horizontal item (step 1302). It is determined whether or not the change source item name is a horizontal item (step 130).
3), if there is, the corresponding item name 97 in the horizontal item table,
The changed item name 98 is updated (step 1304).
If there is no horizontal item, then a vertical item is searched (step 1305). Then, it is determined whether or not the change source item name is a vertical item (step 1306), and if there is, the corresponding item name in the vertical item table is updated to the changed item name (step 1307). If there is neither a horizontal item nor a vertical item, the process moves to the next change item name search (step 13).
11).

Next, a definitional expression is searched (step 13).
08). It is determined whether or not there is an updated item name 92 in the searched expression 91 (step 1309). If there is, the corresponding calculation formula is updated, and the item name 94 in the formula 93 is updated in the same manner as the table (step 1310).

After the completion of updating, it is determined whether or not there are any further changed items (step 1311). In some cases, the table search, the update process, the formula search, and the update process are repeated for the number of changed items.

According to the above processing, even if the item name is changed, the item name of the corresponding expression element is automatically changed. Therefore, the user can freely change the item name of the table without worrying about the expression element of the definition expression.

[0068]

According to the present invention, an arbitrary frame in the table can be used as an item, and the data in the frame of the item can be defined as a calculation formula, so that the conventional calculation formula can be defined. Even in a complicated table where there are multiple missing items, it is possible to define an easy-to-understand calculation formula using item names, and there is no restriction on the format of the created table, which is extremely effective in reducing table creation operations. There is.

[Brief description of drawings]

FIG. 1 shows a configuration of a table editing system according to an embodiment of the present invention, (A) is a block diagram showing a hardware system configuration of a main body, and (B) is a screen configuration diagram of a display.

FIG. 2 is a flowchart showing an outline of an example of a processing procedure of the table editing system of the present embodiment.

FIG. 3 is an explanatory diagram showing the function of an item setting command in the table editing system of this embodiment.

4A is an explanatory diagram showing the function of a calculation formula definition command in the table editing system of the present embodiment, and FIG. 4B is an explanatory diagram showing a calculation formula definition example in the table editing system of the present embodiment.

FIG. 5A is a flowchart showing a procedure for setting an item frame and creating an item name / data conversion table, and FIG. 5B is an example of a table created in the table editing system of the present embodiment and corresponding items and data. Explanatory drawing which shows an example of a table.

FIG. 6 is a flowchart showing a procedure for setting an item frame and creating an item name / data conversion table.

FIG. 7 is an explanatory diagram showing an example of coordinates of a table used when setting an item frame.

8A and 8B are explanatory views showing an example of an item frame setting order.

9A and 9B are explanatory diagrams showing calculation formula processing by a data table in another embodiment of the present invention, FIG. 9A is an explanatory diagram showing a relation between a table and a data table, and FIG. 9B is a table before and after calculation. Explanatory drawing shown, (C) is explanatory drawing which shows an example of a calculation formula definition.

10 is a flowchart showing a processing procedure for calculating data from a calculation formula element and performing a calculation formula process in the embodiment shown in FIG. 9;

FIG. 11A shows a processing procedure of a setting switching method that allows the user to select whether to use the system name prepared by the system for the expression element used in the expression definition or to specify the item frame and use the item name. The flowchart shown in FIG. 1B is a window for the user to instruct switching, "item name / system name switching sheet".

FIG. 12 is an explanatory diagram showing a table configuration for each of a system name and an item name in the embodiment shown in FIG. 11.

FIG. 13 is a flowchart showing the procedure of a formula element automatic changing process by changing an item name in each embodiment of the present invention.

FIG. 14 is an explanatory diagram showing an example of changing an expression and a table by changing the item name.

[Explanation of symbols]

1 ... Central processing unit, 2 ... Main storage unit, 3 ... Storage unit, 4
Input / output controller, 5 ... Display controller, 6 ... Keyboard, 7 ... Mouse, 8 ... Display,
35 ... Item name / data conversion table, 76 ... Item name / system name switching sheet.

 ─────────────────────────────────────────────────── ─── Continuation of front page (72) Inventor Yoshimichi Ishikawa 5-2-1 Omika-cho, Hitachi-shi, Ibaraki Hitachi Process Computer Engineering Co., Ltd. (72) Inventor Shuichi Satake 5-chome, Omika-cho, Hitachi-shi, Ibaraki No. 2-1 Hiritsu Process Computer Engineering Co., Ltd. (72) Inventor Yoko Saiki 5-2-1 Omika-cho, Hitachi City, Ibaraki Prefecture Hiritsu Process Computer Engineering Co., Ltd. (72) Inventor Hirotaka Ogoshi Hitachi, Ibaraki Prefecture 5-2-1 Omika-cho, Oita-shi Hitsuru Process Computer Engineering Co., Ltd. (72) Inventor Yosuke Mori 5-2-1 Omika-cho, Hitachi-shi, Ibaraki Hitachi Ltd. Omika Plant

Claims (10)

[Claims] 1. An input device for inputting data, instructions, etc., and a display device for displaying various data including a table,
A hardware system having a central processing unit for executing data processing according to a program and a storage device for storing the program and data, and means for creating a table to be edited on the hardware system, a table In the table editing system that realizes the means for editing, the means for defining the calculation formula, and the means for performing the defined calculation, the means for defining the calculation formula is such that the frame of the created table is input from the input device. Item setting means for setting as an item according to the input specification, item name data representing the item name entered in the frame set as an item, and data that belongs to the item and is a calculation target The item name / data correspondence creating means for creating and saving the correspondence data indicating the correspondence with A table editing system having means for defining a calculation formula as a formula element. 2. The means for performing the above-mentioned calculation according to claim 1, wherein, for an expression element of a defined calculation formula, the item name / item name data for each item name data forming the expression element is set.
A table editing system having a function of referring to data correspondence data, obtaining corresponding data, and performing calculation. 3. The item setting means according to claim 2,
A table editing system that sets items for horizontal items arranged in the row direction of a table and vertical items arranged in the column direction. 4. The item setting means according to claim 3,
Having a function of receiving a designation from the input device for the frame of the table displayed on the display device, recognizing the item in the designated frame, and acquiring the item name input in the frame Is a table editing system. 5. The item name / data correspondence creating means according to claim 4, wherein the correspondence between the horizontal item and the vertical item set by the item setting device and the data to be calculated and the calculation result is set. A table editing system for creating the item name / data conversion table shown. 6. The method according to claim 1, 2, 3, 4 or 5.
The means for creating the table to be edited further has a function of assigning a unique identifier to each frame constituting the table and storing the identifier in correspondence with the frame. 7. The table editing system according to claim 6, wherein the means for defining the calculation formula further comprises means for defining the calculation formula using an identifier attached to the frame of the item. 8. The means for defining the calculation formula as defined in claim 7, wherein the item name data of the set item is used as a formula element to define the calculation formula and an identifier attached to the frame of the item. A table editing system further comprising means for accepting a selection as to whether to define a calculation formula by means of defining a calculation formula by using, and executing the definition of the calculation formula by the selected means. . 9. An input device for inputting data, instructions, etc., and a display device for displaying various data including a table,
A hardware system having a central processing unit for executing data processing according to a program and a storage device for storing the program and data, and means for creating a table to be edited on the hardware system, a table In the table editing system that realizes the means for editing, the means for defining the formula, and the means for performing the defined calculation, the means for defining the formula is the row direction of the table when the table is created. Create an item name / data conversion table that shows the correspondence between all the non-overlapping combinations of the horizontal items lined up in and the vertical items lined up in the column direction, and the calculation target data and calculation results belonging to the combination. Item name / data correspondence creating means to be saved and a method to define the calculation formula using the item name data of each item as it is The means for performing the above-mentioned calculation refers to the above-mentioned item name / data conversion table for each item name data constituting the formula element of the defined calculation formula. , A table editing system having a function of acquiring corresponding data and performing calculation. 10. The means according to claim 5 or 9, wherein when the item name is rewritten by an input from an input device, the item name / data conversion table is searched for the item name before rewriting, and the item name is rewritten. A table editing system having means for rewriting an item name before it is rewritten when the item name is rewritten by an input from an input device.