JPH09147026A - Change reason display device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily recognize the change reason of past data by preserving a version number and a change reason correspondingly to coordinates (row and column) at the time of changing data in a cell of a table and displaying the change reason correspondingly to the cell in the table in the case that the change reason is added to preserved data at the time of display with respect to a change reason display device which displays the change reason of data. SOLUTION: A means 6 which preserves the change reason, which is inputted at the time of changing data in a cell of the table, together with change data correspondingly to coordinates of the cell of the table and a means 7 which takes out preserved data based on coordinates of the cell of the table to display it in the cell of the table at the time of display and displays the taken-out change reason correspondingly to the cell in the case that the change reason is preserved are provided.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a change reason display device for displaying a reason for changing data.

[0002]

2. Description of the Related Art In a system for inputting, recording, referencing, displaying and printing data, it is desired to know the history of data changes, analyze the data by this, know the tendency of changes, and decide the future correspondence direction. I want to-I want to reproduce the state at a certain point in the past, and I want to restore and reuse it.

In these cases, conventionally, there has been a technique of inserting a symbol representing an annotation line for each line and then inputting an annotation sentence to insert the annotation of the line.

[0004]

As described above, the conventional reason for changing the data of the changed part is to change the reason for changing the data by inputting the comment sentence following the control symbol indicating the comment for each line like a program. Since it was described, there was a problem that the comment text could only be inserted in line units. For this reason, there is a problem that the reason for changing the data put in the cells in the table format cannot be referred to later.

In order to solve these problems, the present invention saves the version number and the reason for change in association with the coordinates (column, row) when the data in the table cell is changed, and saves the saved data at the time of display. When the reason for change is added, the reason for change is displayed in association with the cell in the table, and the reason for change in past data can be easily recognized.

[0006]

Means for solving the problem will be described with reference to FIG. In FIG. 1, screen 1
Indicates data, icons, commands and the like, and here, a tabular data display / input area 2 and the like are provided.

The processing device 4 performs various kinds of processing according to a program, and is composed of a data storage means 6 and a change reason display means 7 here. The data storage means 6 stores the data entered in the cell of the table on the screen 1 in association with the cell coordinates (column, row), the version number, and the input reason for change.

The change reason display means 7 takes out the stored data and displays it in the cell of the table corresponding to the coordinates, or displays the reason for the change. Next, the operation will be described.

When the data storage means 6 inputs or changes data in a table cell on the screen 1, the data and the reason for the input change are indicated in the table cell coordinates (column, column,
Row) and save the data, and the change reason display means 7 takes out the data saved at the time of display and displays the data in the table cell corresponding to the coordinates of the data and also displays the reason when the change reason is added. I am trying to do it.

Further, when the data of the cell of the table on the screen 1 is input or changed, the data storing means 6 associates the data, the version number and the input with the coordinate (column, row) of the cell of the table. The reason for change is stored, and when the reason for change display means 7 indicates the version number specified at the time of display, or when the version number is not specified, the coordinates of the newest version number are reversed in order from the latest version number. It is displayed at the position of the cell in the table and the reason for the change is also displayed.

Further, when inputting a change reason, a list of change reasons registered in advance is displayed, and the change reason is selected and inputted. Therefore, when the data in the table cell is changed, the version number and reason for change are saved in association with the coordinates (column, row), and when the reason for change is added to the data saved at display, the data in the cell is changed. It is possible to register and display the reason for change for each data in the cell in the table by displaying the reason for change in association with.

[0012]

BEST MODE FOR CARRYING OUT THE INVENTION Next, embodiments and operations of the present invention will be sequentially described in detail with reference to FIGS.

FIG. 1 shows a system configuration diagram of the present invention.
In FIG. 1, a screen 1 is used to display various data, commands, icons, etc., and to display an input area. Here, a tabular data display / input area 2 and a change reason display / input area are displayed. 3 and the like are provided.

The tabular data display / input area 2 is provided with an input area for displaying and inputting data in a table cell. The reason for change display / input area 3 is for displaying or inputting the reason for change regarding the data in the cell of the table.

The processing device 4 performs various processes in accordance with a program, and is composed of a screen display control means 5, a data storage means 6, a change reason display means 7, and the like.

The screen display control means 5 is for displaying commands, icons, tables, data on the screen 1, displaying an input area of data, and the like. Data storage means 6
Displays the data entered in tabular data display / input area 2 and change reason display / input area 3 on screen 1,
The data is stored in the data table 9 in association with the coordinates (column, row) of the cells of the table and saved.

The change reason display means 7 includes a data table 9
If the specified version number that is saved or the version number is not specified, it is displayed backward from the latest version number and displayed at the coordinate position of the data of the latest version number, and the reason for change is displayed and entered. It is displayed on the area 3 or the like (Fig. 2
Will be described later).

The input control means 8 controls input such as inputting from the keyboard 11 or the mouse 12. The data table 9 summarizes the version number (user version number assigned by the user and sequential system version number uniquely assigned in the order of storage) of the data input to the cell in the table format or the changed data, and the reason for the change. It is stored as a file (see FIG. 3).

The reason for change is registered in advance in the reason for change table 10 (see FIG. 4). The keyboard 11 and mouse 12 are for inputting data and instructions. Next, the operation of the configuration of FIG. 1 will be described in detail according to the order shown in the flowchart of FIG.

In FIG. 2, S1 restores data. This is the coordinates (column, row) that are uniquely determined by the column number and row number of the cell position on the table of the data for the data entered in the cell on the table displayed on the screen 1 of FIG.
And the version number for managing the change state (the user version number assigned by the user and the sequential system version number uniquely assigned in the order of storage) and the reason for the change are added and stored in the data table 9. From the data table 9, the specified version number or the latest version number is sequentially reversed, and the newest data is restored in each cell on the table.

In step S2, it is determined whether the input is completed. this is,
It is determined whether or not the user has input data or input various instructions. If YES, the process ends. In the case of NO, the process proceeds to S3.

In S3, whether the processed data is a data table,
Determine if it is a change reason table. When the processed data is the data table 9, the processes of S4 to S16 are performed. When the processing data is the change reason table 10, the processing from S17 to S19 is performed.

In step S4, since the processed data is found to be the data table 9 in step S3, it is further determined whether it is a change reason display.
In the case of YES, the reason for change is searched by coordinates, the corresponding record is extracted, and the reason for change is displayed on the screen (change reason display / input area 3 in FIG. 1 or another window associated with the data displayed in the cell in S6). Display), and the process proceeds to S7. On the other hand, if NO in S4, the process proceeds to S7.

In step S7, it is determined whether or not the data has been changed. YE
In the case of S, it is found that the data displayed in the table cell has been changed, so the operator is requested to input the reason for the change in S8, and the process proceeds to S9. On the other hand, if NO in S7, the process proceeds to S15.

In step S9, it is determined whether there is an instruction to modify the change reason table. In the case of YES, the change reason table 10, for example, FIG. 4 described later is displayed in S10, the change reason is selected in S11, the content of the change reason is displayed in S12, and the process proceeds to S13. On the other hand, if NO in S9, S1
Proceed to 3.

In step S13, the reason for change is saved. S14
Saves the data. As a result, the data is restored and displayed in the table cell on the screen, and when this data is modified, the reason for change is also selected from the list of the reason for change table and entered. The reason and data are stored in the data table 9 in association with the coordinates of the table together with the version number.

In step S15, it is determined whether the change reason is deleted. Y
In the case of ES, the reason for change is deleted in S16 and the process returns to S2 and is repeated. On the other hand, if NO, the process returns to S2 and repeats. As a result, the data is displayed in the restored table cell on screen 1, and when you change this data, select the reason for change from the list and enter the changed data, the reason for change, and the version number. And is stored in the data table 9 in association with. This saves the reason for changing the data for each cell when changing the data in the table cell, restores it based on the coordinates if necessary, and displays the data in the table cell and the reason for the change. It is possible for the operator to recognize the history of changes in past data and display it.

In S17, it is determined in S3 that the processing data is for the change reason table, so it is determined whether the change reason table 10 has been changed. In the case of YES, the change reason table 10 is displayed, and the change reason table 10 is corrected, added, or deleted in S19, and the process returns to S2 and is repeated.
On the other hand, in the case of NO in S17, the change reason table 10
Since it was found that there was no change, the procedure returns to S2 and is repeated.

FIG. 3 shows an example of the data table of the present invention. This is for cells in the table on screen 1 of FIG. 1, A, B, C, D, E, F in the column direction, 1, 2, 3, in the row direction.
There are 4 and 5, and the state in which the data is stored in the data table 9 when the cell coordinates are expressed by (column, row) is shown. For example, the coordinate “A1” in the table indicates that the data “arithmetic unit” is displayed in the cell at the intersection of “A” in the column direction and “1” in the row direction. The ascending order version number) “1”, the system version number (the version number uniquely assigned sequentially in the order in which the data is actually stored in the data table 9), the reason for the change, etc. are saved as records as shown in the figure. It is a thing.

The first edition represents the edition number when the data is first input to the cell of the table on the screen 1 of FIG. 1 (Because this first edition is the first data input, the reason for change is Not). The additional sentence is, as shown in the drawing, the attribute, the user version number, the system version number, the data, and the reason for the change, which are associated with the coordinates, of the changed data in the cell data of the first version, and are stored. For example, for the coordinate "B2", the original data "B001" is changed to the data "B010", and the reason for the change is stored as "part change by customer instruction".

As described above, in the first version, all the cells of the table are stored in correspondence with the coordinates, and when the data after that are changed, the addition shown in the figure is made in correspondence with the coordinates of the changed data. Save attributes, user version, system version, data, and reason for change, as shown in. This allows
When you change the data, save the changed data, attributes, user version, system version, reason for change for each cell in the table, and read and display them when you want to know the history of changes at a later date, It is possible to know the process easily.

FIG. 4 shows an example of the change reason table of the present invention. This is the content (reason for change) previously registered in association with the reason for change as shown in the figure.
This is for displaying a list of the change reason table 10 when selecting the reason for changing the data in the cell in the above table and selecting and inputting one of them. By providing this change reason table 10 and displaying the list and selecting and inputting it, it is possible to save the trouble of deciding the reason for each change one by one and entering the key, and registering the standard change reason. This is for making it possible to input the reason for change by a simple operation, for example, by selectively inputting and then overwriting and correcting the reason for change that has been selected and input.

[0033]

As described above, according to the present invention,
When the data in the table cell is changed, the version number and the reason for change are saved in association with the coordinates (column, row), and when the reason for change is added to the data saved at display, the data in the cell is applied. Since the configuration that additionally displays the reason for change is adopted, it is possible to register and display the reason for change for each cell data in the table, and to easily display and recognize the history of changes in past data. it can.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of the present invention.

FIG. 2 is a process flowchart of a registration reason update process according to the present invention.

FIG. 3 is an example of a data table of the present invention.

FIG. 4 is an example of a change reason table according to the present invention.

[Explanation of symbols]

 1: Screen 2: Tabular data display / input area 3: Change reason display / input area 4: Processing device 5: Screen display control means 6: Data storage means 7: Change reason display means 8: Input control means 9: Data table 10: Reason for change 11: Keyboard 12: Mouse

Claims (3)

[Claims] 1. In a change reason display device for displaying a reason for changing data, the reason for changing the data entered when changing the data in the table cell is stored together with the changed data in association with the coordinates of the cell in the table. And the data saved based on the coordinates of the table cell at the time of display and displayed in the table cell, and the reason for change that was taken out when the reason for change was saved is displayed in association with the cell. A change reason display device comprising means. 2. A change reason display device for displaying a reason for changing data, wherein the change reason, version number, and the change reason for the change reason of the data inputted when changing the data of the table cell are associated with the coordinates of the table cell. The means to save the reason for change and the specified version number of the saved data based on the coordinates of the table cell at the time of display or, if not specified, go up sequentially from the latest version number and retrieve the newest data. A change reason display device comprising: means for displaying in a cell of a table and displaying the reason for change taken out when the reason for change is stored in association with the cell. 3. The change reason display device according to claim 1 or 2, wherein when the change reason is input, a list of change reasons registered in advance is displayed, and the change reason list is selected and input.