JP2000348114A - Method and system for display and editing of same data in multiple pictures - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a constitution in which only change information which will be affected at the time of the change of picture data is taken as the object to rewrite all pictures in the case that the same picture data of a spread sheet type are displayed on plural pictures. SOLUTION: A picture data part 31 where picture data of a spread sheet type are stored, a screen 1 on which plural pictures using the same picture data are displayed, and a correspondence data table 2 which manages the relation between data names given to picture data and picture IDs given to pictures are included. When picture data are updated, update information to be the update object of picture data is generated in an update information storage part 33, and picture data in the picture data part 31 are updated on the basis of this update information, and information indicating that update has been performed is set to a change flag part 34, and thereafter, picture IDs requiring update are retrieved from the correspondence data table 2 on the basis of update information in the change information storage part 33, and plural pictures on the screen 1 are updated.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to image processing for displaying spreadsheet type screen data, and more particularly to the same data display editing method and display editing method on multiple screens.

[0002]

2. Description of the Related Art An example of conventional image processing is disclosed in Japanese Patent Laid-Open Publication No. Hei 2-5668. In the image processing described in this publication, data to be displayed when a plurality of identical screens are displayed is centrally managed, and when data is changed, similar change processing is performed on other screens. It comprises a screen data generation unit and storage unit, a screen designation unit and storage unit to be displayed, a screen data distribution unit, a screen data conversion unit, and a display unit. The conventional image processing having such a configuration operates as follows.

That is, when a screen is created, information on screen display is stored in a screen designation unit and a storage unit. Next, the input data is generated by the screen data generation unit and stored in the storage unit. The screen data distribution unit distributes the stored screen data to each screen. The screen data conversion unit converts the data into screen data again, and the display unit displays the data on the screen.

[0004]

However, this prior art has the following problems.

[0005] The first problem is that the screen is rewritten each time data is changed. The reason is that continuous change of screen data is not considered in the program processing, and the screen is rewritten the number of times of data change.

A second problem is that when there are a large number of display screens, the processing speed for changing the entire screen is reduced. The reason for this is that the entire screen is rewritten and rewritten to a range unrelated to the changed data.

An object of the present invention is to solve the above problem by displaying the same screen data of a spreadsheet type (table format) on a plurality of screens, and when the data is changed. It is an object of the present invention to provide a configuration in which the entire screen can be rewritten by focusing only on the change information that has an effect on the information.

[0008]

In order to achieve the above object, the same data display / editing method for multiple screens of the present invention stores input means for receiving user input and spreadsheet type screen data. A screen data storage unit;
A change information storage means for storing update information input by the input means, wherein the change information storage means stores a plurality of screens using the same screen data; and a display unit for displaying a plurality of screens using the same screen data. The present invention is characterized in that there is provided a changing means for changing the screen data stored in the screen data and the plurality of screens displayed on the display unit by using the update information stored by the means.

Further, according to the present invention, there is provided a screen data storage section for storing spreadsheet type screen data, and a display section for displaying a plurality of screens using the same screen data. In the same data display editing method on a multiplex screen, comprising a management table for managing a relationship between a data name assigned to screen data used for the screen and a screen ID assigned to the screen, A first updating step of creating update information to be updated when the displayed screen data is updated and updating the screen data stored in the data storage unit based on the updated information; Means, an update storage means for storing that the screen data has been updated, and, based on the update information, when the first update storage means indicates that the screen data has been updated. It is characterized in that searching screen ID from the serial management table and a second updating means for updating the plurality of screens displayed on the display unit.

Further, the update information includes a screen ID to be updated.
, An operation range indicating an update range of the screen, update data indicating the content of the data to be updated, and an operation content indicating the content of the operation.

Further, when data input information including any of addition, deletion, and change of cell data is input by the input means, an ID of a screen to be updated, an update range, and cell data to be updated are stored. A screen data updating unit that updates screen data stored by the screen data storage unit using the update information stored by the storage unit; and a storage unit that stores the update information stored by the storage unit. Screen updating means for updating a plurality of screens using screen data to be updated.

Further, when update information of data including any of addition, deletion, and change of a row or a column is input by the input means, a screen ID to be updated, an update range, and an operation content are stored. A storage unit that updates the screen data stored by the screen data storage unit using the update information stored by the storage unit; and a screen data update unit that updates the screen data by using the update information stored by the storage unit. Screen updating means for updating a plurality of screens using screen data to be updated on the display unit.

Further, the update range stored by the storage means includes a row to be added or deleted, and a row up to the bottom row shifted by the addition or deletion.

Further, the update range stored by the storage means includes a column to be added or deleted and a column up to the rightmost column to be shifted by the addition or deletion.

Further, the present invention is characterized in that the change means is performed by storing information of a link destination and referring to the information.

Further, the present invention is characterized in that the first update means, the update storage means, and the second update means are performed by storing information of a link destination and referring to the information.

Further, according to the present invention, there is provided a method for displaying and editing the same data on multiple screens, comprising: input means for receiving a user's input;
A method for displaying and editing the same data on a multiplex screen using a screen data storage unit for storing spreadsheet-type screen data and a display unit for displaying a plurality of screens using the same screen data, wherein the input means Using the change information storage unit that stores the update information input by the, when the update of the screen data displayed by the display means,
The update information from the input unit is stored in the change information storage unit, and is displayed on the screen data and the display unit stored in the screen data storage unit by using the update information stored in the change information storage unit. It is characterized in that a plurality of screens are changed.

Also, there is provided a method for displaying and editing the same data of multiple screens using a screen data storage unit for storing spreadsheet type screen data and a display unit for displaying a plurality of screens using the same screen data. A corresponding data table that manages a relationship between a data name assigned to screen data used for the screen and a screen ID assigned to the screen,
Displayed by the display unit using a change information storage unit that stores the update information input by the input unit, and a change flag unit that indicates that the screen data stored in the screen data storage unit has been changed. When the updated screen data is generated, the update information to be stored in the change information storage unit to be updated of the screen data is created, and the update information is stored based on the update information stored in the change information storage unit. The screen to be updated by updating the screen data stored in the screen data section, setting the update flag section of the screen data section, and searching for the screen ID number from the correspondence table using the updated screen data as a key. It is characterized in that it is determined and the screen displayed on the display unit is updated.

Further, the update information includes a screen ID to be updated.
, An operation range indicating an update range of the screen, update data indicating the content of the data to be updated, and an operation content indicating the content of the operation.

[0020]

Next, a first embodiment of the present invention will be described with reference to the drawings. Referring to FIG.
The first embodiment of the present invention comprises a display unit 4 for displaying data and a screen, a control unit 5 operated by a processor (not shown) under program control, a storage unit 6, a keyboard 7, and a mouse 8. Be composed.

FIG. 1 is a block diagram showing the contents displayed on the display unit 4 and the contents managed by the storage unit 5 in FIG. 2, and is a block diagram showing the mutual relationship. Referring to FIG. 1, the display unit 4 includes a screen 1 including a plurality of identical screens for one screen data. The display unit 4 has a storage unit (not shown in the drawing) that can save screen data of each screen so that the screen data can be displayed at a position corresponding to the screen 1. Therefore, in order to change the screen displayed on the display unit, the content written in the storage unit may be changed.

The storage device 6 has a corresponding data table 2 for managing the association between the ID assigned to each screen in the screen 1 and the screen data used in the screen 1, and a screen corresponding to the screen used in the screen 1. And a data storage unit 3 for storing data and the like.

Each time a screen is generated in the screen 1, an ID number (screen ID) is assigned so that each screen can be identified. The ID number is different in each screen, and the same ID number does not exist. A data name is assigned to the screen data used for the screen.

Screen 1 includes screen 1-11 and screen 1-1n.

The corresponding data table 2 is composed of a screen ID storage unit 21 assigned for each data name. That is, if a plurality of screen data exists on the screen 1 of the display unit 4, a plurality of screen ID storage units 21 exist.

The screen ID storage unit 21 manages the screen used in the screen 1 for each data name, and can identify the screen ID using the screen data of the data name.
That is, the ID numbers “GAMEN1” and “GAM1” are stored in the screen ID storage unit 21 assigned with the data name “DATA1”.
If “MEN2” is recorded, the ID number “GAME
This indicates that the screens of “N1” and “GAMEN2” display the contents of the screen data with the data name “DATA1” in the screen 1.

The data storage unit 3 includes a screen data unit 31 and
An internal attribute storage unit 32, a change information storage unit 33, and a change flag unit 34 are provided. Data storage unit 3 for each data name
Exist and a plurality of data names exist, a plurality of data storage units 3 exist.

The screen data section 31 stores values to be displayed on the screen in one-to-one correspondence with the spreadsheet of the screen to be displayed. That is, the same value as the number of cells in the spreadsheet is stored. For example, if the screen is a 10-row, 10-column spreadsheet, the screen data unit 31 has 10 rows, 10 columns.
Screen data for a column is stored.

The internal attribute storage unit 32 stores attribute values that are not displayed on the screen and correspond one-to-one with the spreadsheet of the screen to be displayed. For example, there are an error message for an error cell generated as a result of the check and a comment for the cell. Like the screen data section 31, the same range as the number of cells in the spreadsheet is stored.

The change information storage section 33 stores an operation screen ID, an operation range, and a change value when the screen data is changed. The operation screen ID stores the ID number of the operated screen. The operation range stores the range in which the screen is changed. The operation range to be stored when multiple ranges are changed is
It is stored as a rectangle from the minimum value to the maximum value of the range. The changed value stores the changed value.

The change flag section 34 is a flag set when the screen data section 31 is changed. When the screen is updated, the screen using the data name in which the change flag section 34 is set is processed.

FIG. 3 is a flowchart showing the operation of the control unit 5 of FIG. 2 when the user changes the screen data while looking at the display unit 4.

FIG. 4 is a flowchart showing the operation of the control unit 5 of FIG. 2 when the screen data is changed programmatically.

Next, the overall operation of the first embodiment will be described with reference to FIGS. 1, 2, 3 and 4.

Referring to FIG. 3, the user inputs the screen data of the screen 1-11 displayed on the display unit 4 to the keyboard 7.
Alternatively, update is performed based on input information from an input from the mouse 8. The input information in this case is a screen ID to be updated,
An operation range and a change value, and there is also data for instructing an operation. The data at this time includes adding cell data, changing cell data, deleting cell data, adding rows, deleting rows,
It refers to data that instructs addition of a column, deletion of a column, and the like.
Assuming that the operation content is a change related to cell data, the user inputs update information related to cell data (step A1). Then, the control unit 5 sets the screen ID storage unit 21
The target data name is determined by using the screen ID operated from (1) as a key (step A2). Further, the control unit 5 stores the operated screen ID, operation range, and change value in the change information storage unit 33 corresponding to the determined data name (step A3). Then, the control unit 5 rewrites the cell data of the change value to the corresponding range of the screen data unit 31 based on the operation range and the change value of the change information storage unit 33 corresponding to the created data name (step A4). When the cell data is updated, the control unit 5 sets the data storage unit 3 of the corresponding data name.
Is set (steps A5 and A5).
6). At this time, if there is a change in the internal attribute, the control unit 5 rewrites the corresponding range in the internal information storage unit 32 based on the operation range and the change value of the change information storage unit 33 (Steps A7 and A8). Next, when the change flag section 34 is set (step A9), the control section 5 searches for a screen ID from the screen ID storage section 21 of the corresponding data name,
The screen to be updated is determined (step A10). Then
The control unit 5 rewrites the screen based on the operation screen, the operation range, and the change value of the change information storage unit 33 of the data storage unit 3 of the corresponding data name (step A11). Further, the control unit 5
When there is still a screen ID to be changed in the screen ID storage unit 21 of the corresponding data name, the screen updating process is repeated from step A9 (step A12). The control unit 5
When the update process for all the screen IDs (updates the displayed screen by changing the content of the screen corresponding to the screen ID stored in the storage unit in the display unit 4) is completed, the data of the corresponding data name Change flag section 34 of storage section 3
Is reset (step A13).

Next, referring to FIG. 4, the control unit 5 is caused to read input information containing information to be changed, which is stored in an external device (not shown), from the keyboard 7 in FIG. To change the screen data of the screen 11.
Then, the control unit 5 stores the screen ID, the operation range, and the change value in the change information storage unit 33 corresponding to the data name to be changed from the input information based on the information to be changed (step A3). . The control unit 5 rewrites the data of the change value to the corresponding range of the screen data unit 31 based on the operation range and the change value of the change information storage unit 33 corresponding to the created data name, and stores the data of the corresponding data name. The change flag section 34 of the section 3 is set (steps A4, A5, A
6). At this time, if there is a change in the internal attribute, the control unit 5 rewrites the corresponding range in the internal information storage unit 32 based on the operation range and the change value of the change information storage unit 33 (Steps A7 and A8). Subsequently, when the program changes the screen data corresponding to another data name, the control unit 5 repeats the process from step A3 to the corresponding screen data (step B1). When the program repeatedly changes the same data name, the operation range may overlap. As the operation range at that time, the existing operation range in the change information storage unit 33 and the latest operation range are combined and stored as a rectangle from the minimum value to the maximum value. Further, as the change value of the range where the operation range overlaps, the control unit 5 deletes the existing change value of the corresponding range and stores the latest value. Control unit 5
Performs a screen rewriting process when all screen data changes are completed. Next, when the change flag unit 34 of the data storage unit 3 of the corresponding data name is set (step A9), the control unit 5 searches for the screen ID from the screen ID storage unit 21 of the corresponding data name, The screen to be updated is determined (step A10). Then, the control unit 5 rewrites the screen based on the operation screen, the operation range, and the change value of the change information storage unit 33 of the data storage unit 3 of the corresponding data name (step A11). Further, when there is still a screen ID to be changed in the screen ID storage unit 21 of the corresponding data name, the control unit 5 repeats the screen updating process from step A9 (step A12). When the update processing for all the screen IDs is completed, the change flag unit 34 of the data storage unit 3 of the corresponding data name is reset (Step A13). continue,
When updating the screen of another data name, the control unit 5 repeats the processing from step A9 (step B2).

Next, a specific description will be given with reference to FIGS.

As shown in FIG. 5, as program processing, cell data "SIGNAL1" is applied to a range B2 of data name "DATA1", and then cell data "SIGNAL2" and cell data "SIGNAL3" are applied to ranges B2 and B3.
And change it. Then, the control unit 5 stores the operation range “B2” and the change value “SIGNAL1” in the change information storage unit 33.
Is created (step A3 in FIG. 4), and the screen data
Is rewritten to "SIGNAL1" and the change flag unit 34 is set (step A4).
A5, A6). Since the data change process by the control unit 5 is performed twice (step B1), the process of step A3 (in this case, the process for the same data name) is continued. Control unit 5
Rewrites the storage contents in the change information storage section 33 as the operation ranges “B2, B3” and the change values “SIGNAL2, SIGNAL3”, and sets the ranges B2, B3 of the screen data section 31 to “SI”.
GNAL2 ”,“ SIGNAL3 ”and set the change flag unit 34 (steps A4, A5, A
6). At this time, the operation range B2 held in the first change processing overlaps, but the changed value of B2 is set to “SIGNA”.
L1 is rewritten to "SIGNAL2" so that the latest value is always held. Since the change flag unit 34 of the data storage unit 3 corresponding to DATA1 is set (step A9), the control unit 5 displays the screen. “GAMEN1” is determined from the ID storage unit 21 and the range “B2, B3” is changed from the operation range of the change information storage unit 33 to “SIG” from the change value.
NAL2, SIGNAL3 based on "to B2" SIGN
AL2 is rewritten to B3 as "SIGNAL3" (steps A10 and A11) The control unit 5 also performs a screen update process of "GAMEN2" from the screen ID storage unit 21 (step A12). The operation range “B2, B3” of the storage unit 33 is changed to the changed value “SIGNAL2, S
"SIGNAL2", B to B2 based on "IGNAL3"
3 to "SIGNAL3" (step A1
0, A11). Since the control unit 5 has performed all the processes on the screen to be updated, the control unit 5 resets the change flag unit 34 and ends the screen update process (Steps A12 and A13).

As described above, when the update of the screen data occurs, the update information of the screen data is stored in the change information storage unit 33, so that the screen data is rewritten based on the update information. , A plurality of displayed screens are changed. Therefore, it is not necessary to replace the screen data all at once for a plurality of screens using the updated screen data, and it is only necessary to focus on the update information, and the screen update process is smooth (extra time is required for reading the screen data). Has no effect). Furthermore, when the screen data is repeatedly changed (for example, as described with reference to FIG. 5), the screen data and the display screen need only be updated once, so that the effect of minimizing the number of update processing is obtained. is there. Further, by referring to the corresponding data table 2, it is possible to easily grasp the screen using the screen data. In addition, since the operation range is provided in the change information storage unit 33, only the range necessary for rewriting is performed, and unnecessary rewriting processing can be omitted.

Next, the operation of the control unit 5 of FIG. 2 in the case where the information of the operation content is managed in the change information storage unit 33 of FIG. 1 will be described.

1 and 2, the control unit 5 stores the operation screen ID, the operation content, the operation range, and the changed value when the screen data is changed in the change information storage unit 33. The operation content stores the type of operation performed on the screen. For example, a flag for each operation is determined in advance, such as "ADD" when data is added to the spreadsheet and "DELETE" when data is deleted.

Referring to FIG. 3, steps A1, A2,
The operations indicated by A5 to A9, A11, and A12 are the same as the operations in steps A1, A2, A5 to A9, A11, and A12 described above, and a description thereof will not be repeated. In FIG. 1 described above, the processing for adding and deleting data to the spreadsheet screen has been described. This explanation also describes the processing for adding and deleting rows and columns on the spreadsheet screen.

When the line addition is changed on the screen corresponding to a certain screen ID in FIG. 1, the control unit 5 in FIG. 2 sends the change information storage unit 33 in the data storage unit 3 corresponding to the data name.
The screen ID, the operation range, the operation content, and the changed value that have been operated are passed to. Then, the control unit 5 determines the screen data unit 3 from the operation range, operation content, and change value of the created change information storage unit 33.
1 is rewritten to the changed value, and the change flag unit 3
Set 4 When the internal attribute is changed, the corresponding range in the internal attribute storage unit 32 is rewritten from the operation range, the operation content, and the change value in the change information storage unit 33. When updating the screen, the control unit 5 determines the update screen from the operation screen, the operation range, the operation content, and the change value of the change information storage unit 33 and rewrites the screen.

Next, the line addition will be specifically described.
As shown in FIG. 6, the keyboard 7 and the mouse 8 of FIG.
Is used to add one line to the C line of the data name "DATA1" displayed on the screen 1 of the display unit 4 (FIG. 3).
Steps A1 and A2). Then, the control unit 5 sets the DAT
"GAMEN" is displayed on the operation screen of the change information storage unit 33 of A1.
"1", "ROWADD" as the operation content, and "C1, C2, C
3, C4 ”, because the display position of the data is shifted, the row“ D1, D2, D3,
D4 "and add" C1, C2, C3, C4, D1, D
2, D3, D4 "(step A3). Next, the control unit 5 sets the operation content, the operation range,
It is determined from the change value that a line has been added to the C line, the content of the screen data unit 31 is updated by adding one line to the last line and rewriting the operation range, and the change flag unit 34 is set (step A4 to A6). Next, the control unit 5 updates the screen. First, the control unit 5 determines the screen of DATA1 from the screen ID storage unit 21 (step A10), and adds one line to the last line based on the operation content, operation range, and change value of the change information storage unit 33, and sets the operation range. Is transferred (step A11). Finally, the change flag unit 34 is reset (step A13).

Next, a specific description will be given of row deletion. As shown in FIG. 7, the C line of “DATA1” is deleted using the keyboard 7 and the mouse 8 of FIG.
Then, the control unit 5 sets the change information storage unit 33 of DATA1.
"GAMEN1" on the operation screen and "ROW" on the operation content.
DEL ”is set, and further, in the operation range,“ D1, D2, C2, C3, C4 ”to the line to be deleted is displayed.
D3, D4, E1, E2, E3, E4 "and" C
1, C2, C3, C4, D1, D2, D3, D4, E
1, E2, E3, E4 "are created (step A3).
The control unit 5 determines that the C line has been deleted from the operation content, the operation range, and the change value of the change information storage unit 33, and transfers the data of the D line and the E line to the C line and the D line, respectively. Then, the contents of the screen data section 31 are updated by deleting the last line, and the change flag section 34 is set (A4 to A6).
Next, the screen is updated. First, the control unit 5 determines that DATA1
Is determined from the screen ID storage unit 21 (step A1).
1) Based on the operation contents, the operation range, and the change value of the change information storage unit 33, the data of the D line and the E line are transferred to the C line and the D line, respectively, and then the last line is deleted (step A12), and the change is performed. The flag unit 34 is reset (step A13).

Next, the column addition will be specifically described.
As shown in FIG. 8, the keyboard 7 and the mouse 8 shown in FIG.
Is used to add one column to three columns of the data name "DATA1" displayed on the screen 1 of the display unit 4 (FIG. 3).
Steps A1 and A2). Then, the control unit 5 sets the DAT
"GAMEN" is displayed on the operation screen of the change information storage unit 33 of A1.
"1", "COLUMNSADD" in the operation content, and columns "A3, B" added to the operation range.
3, C3, D3 ”, because the display position of the data is shifted,“ A4, B
4, C4, D4 "and" A3, B3, C3, D
3, A4, B4, C4, D4 "are created (step A
3). Next, the control unit 5 determines that a column has been added to three columns based on the operation content, the operation range, and the change value of the change information storage unit 33, and adds one column to the last column to rewrite the operation range. The contents of the screen data section 31 are updated, and the change flag section 34 is set (steps A4 to A6). Next, the control unit 5 updates the screen. First, the control unit 5
The screen of A1 is determined from the screen ID storage unit 21 (step A10), and the operation content, operation range,
One line is added to the last column based on the changed value, and the data of the operation range is transferred (step A11). Finally, the change flag section 34
Is reset (step A13).

Next, a specific description will be given of column deletion. As shown in FIG. 7, three columns of "DATA1" are deleted using the keyboard 7 and the mouse 8 of FIG.
Then, the control unit 5 sets the change information storage unit 33 of DATA1.
"GAMEN1" on the operation screen and "COL
UMNSDEL "is set, and further, the operation range is changed to the deleted columns" A3, B3, C3, D3 "and" A4, "up to the rightmost column of the data range because the display position is shifted.
"B4, C4, D4, A5, B5, C5, D5" and "A3, B3, C3, D3, A4, B4, C4, D
4, A5, B5, C5, D5 "(Step A
3). The control unit 5 determines that three columns have been deleted from the operation content, the operation range, and the change value of the change information storage unit 33, and
After transferring the data in columns 4 and 5 to columns 3 and 4, respectively, the contents of the screen data portion 31 are updated by deleting the last column, and the change flag portion 34 is set (A4 to A).
6). Next, the screen is updated. First, the control unit 5 sets the DA
The screen of TA1 is determined from the screen ID storage unit 21 (step A11), and the data of four columns and five columns are transferred to three columns and four columns, respectively, based on the operation content, operation range, and change value of the change information storage unit 33. Thereafter, the last line is deleted (step A12),
The change flag unit 34 is reset (step A13).

As described above with reference to the addition and deletion of rows and columns, the control unit 5 can change the screen data and each screen by referring to the operation contents and the operation range of the change information storage unit 33. it can.

Next, a second embodiment of the present invention will be described with reference to the drawings. The second embodiment of the present invention corresponds to the display unit 4 of FIG. 2 according to the first embodiment of the present invention.
FIG. 1 shows a case where a drawing ID corresponding to a plurality of data names exists on the screen 1 in FIG.

The schematic block diagram used in the second embodiment is the same as the block diagram of FIG. 2 used in the first embodiment.

FIG. 10 is a block diagram showing the contents displayed on the display unit 4 and the contents managed by the storage unit 5 in FIG. 2, and is a block diagram showing the relationship between them.

Referring to FIG. 10, display unit 4 includes a screen 1 for displaying data, and storage unit 6 includes a corresponding data table unit 2 for storing an association between a screen ID and data.
And a data storage unit 3 for storing data.

Screen 1 includes screen 1-11 and screen 1-12.
, ..., screen 1-n1, and screen 1-n2 (n is an integer of 1 or more).

The data table unit 2 has a plurality of screen ID storage units 21, and the screen ID storage units 21-1 to 2-n (n
Is an integer of 1 or more).

The screen ID storage unit 21-1 stores the screen 1-11.
And one data name used on screen 1-12 (hereinafter,
Screen 1-).
11 and a screen 1-12, a screen ID corresponding to one-to-one is stored. That is, the data names used on the screens 1-11 and 1-12 can be understood. Similarly, in the screen ID storage unit 21-n, one data name used in the screen 1-n1 and the screen 1-n2 (hereinafter, referred to as data name n) is allocated, and the screen 1-n1 and the screen 1-n2 and a screen ID corresponding to one-to-one are stored. That is, the data names used in the screen 1-n1 and the screen 1-n2 can be understood.

There are a plurality of data storage units 3 and has data storage units 3-1 to 3-n (n is an integer of 1 or more). Each data storage unit 3 is managed by a data name, and includes a screen data unit 31, an internal attribute storage unit 32, a change information storage unit 33, a change flag 34, and a common data designation unit 35. That is, the data storage unit 3-1 corresponding to the data name 1 includes the screen data unit 31-1, the internal attribute storage unit 32-1, the change information storage unit 33-1 and the change flag 3
4-1 and a common data specifying unit 35-1.
Similarly, the data storage unit 3-n corresponding to the data name n is
It has a screen data section 31-n, an internal attribute storage section 32-n, a change information storage section 33-n, a change flag section 34-n, and a common data designation section 35-n.

The screen data section 31, the internal attribute storage section 32,
The function of the change flag 34 is the same as that described in the first embodiment, and a description thereof will be omitted.

The change information storage unit 33 stores an operation screen ID, an operation range, and a change value when the screen data is changed.

The common data specifying section 35 stores the data name of the sharing destination and the cell data position when sharing the changed value with other screen data.

Next, the overall operation of the second embodiment will be described with reference to the flowchart of FIG.

Steps A1, A2, A4 to A in FIG.
8, A9 to A13, and B2 in the second embodiment correspond to steps A1, A2, A4 to A8, A9 to A9 in the first embodiment shown in FIGS.
Since the operation is the same as that of A13 and B2, the description is omitted. In the first embodiment shown in FIG. 1, the screen data is independent, but in the present embodiment, a part of the screen data is common to a part of the other screen data. The screen data change in the case will be described. The control unit 5
When the linked screen data is changed (determined by referring to the common data specifying unit 35-1) (step C1 in FIG. 11), the common data specifying unit 35-1 sends the change information as the link destination screen data. An operation screen, an operation range, and a change value of the storage unit 33-n are created (step C).
2). Next, the control unit 5 rewrites the corresponding range of the screen data unit 31-n, which is the link destination screen data, from the operation range and the change value of the change information storage unit 33-n to the change value, and changes the change flag unit 34-n. Set (steps C3 to C5).
When there is a change in the internal attribute, the control unit 5 determines the corresponding range of the internal attribute storage unit 32-n that is the link destination screen data based on the operation range and the change value of the change information storage unit 33-n. Rewrite (steps C6 and C7). Next, a specific description will be given with reference to FIG.

As shown in FIG. 12, the data name "DATA
It is assumed that the range B2 of “1” and the range B2 of data name “DATA2” are linked to each other, and the cell data “SIGNAL1” has been added to the range B2 of DATA1 using the keyboard 7 and the mouse 8 in FIG. In this case, the control unit 5
An operation screen, an operation range, and a change value of the change information storage unit 33-1 of the ATA1 are created (Steps A1 to A in FIG. 11).
3). The control unit 5 changes the screen data unit 31-1 and the internal attribute storage unit 32-1 and sets the change flag unit 34-1 (steps A4 to A8). Next, the control unit 5 transmits the link destination data name “DATA” of the common data instruction unit 35-1.
The control unit 5 creates an operation screen, an operation range, and a change value of the change information storage unit 33-n of DATA2 from “2” and the link destination screen data “B2” (step C2). The internal attribute storage unit 32-n is changed, and the change flag unit 34-n is set (steps C3 to C7).
Next, the screen is updated. First, the control unit 5 sets the DATA
1 is determined from the screen ID storage unit 21 (step A).
10) Update the screen (step A11). Control unit 5
Resets the change flag unit 34-1 after updating all the display screens of DATA1 (step A12). Next, the control unit 5 determines the screen of DATA2 from the screen ID storage unit 2n (step A10), and updates the screen (step A11). Finally, the control unit resets the change flag unit 34-n after updating the entire display screen of DATA2, and ends the process (step B2).

As described in the second embodiment, when the update of the screen data occurs, the control unit 5 stores the information of the link destination in the common data designating unit 35, and the common data designating unit 35 By referring to the screen data, the screen data and screen of the link destination can be easily changed.

[0064]

As described above, the effect of the present invention is as follows.
Another object of the present invention is to minimize the number of times the screen is updated when the screen is repeatedly changed. The reason is that the input screen data change information is temporarily stored, and based on that, the screen update timing is set to once after the data rewrite processing ends, and the screen update processing for each rewrite processing is omitted. Because it is.

Another advantage of the present invention is that the range of data rewriting can be minimized by specifying the range of data to be updated. The reason is that when updating data, only the range necessary for rewriting can be performed, and unnecessary rewriting processing can be omitted.

[Brief description of the drawings]

FIG. 1 is a block diagram of a first embodiment relating to contents displayed on a display unit of FIG. 1 and contents managed by a storage unit.

FIG. 2 is a block diagram showing first and second embodiments of the present invention.

FIG. 3 is a flowchart in which the control unit of FIG. 2 operates with the configuration of FIG. 1 when the user changes data while looking at the display unit 4;

FIG. 4 is a flowchart illustrating the operation of the control unit in FIG. 2 when data relating to the change is input from an external device and the data is automatically changed.

FIG. 5 is a state diagram of screen data when cell data on the screen data is updated.

FIG. 6 is a state diagram of screen data when a line on the screen data is added.

FIG. 6 is a state diagram of screen data when a line on the screen data is deleted.

FIG. 8 is a state diagram of screen data when a column on the screen data is added.

FIG. 9 is a state diagram of screen data when a column on the screen data is deleted.

FIG. 10 is a block diagram of a second embodiment relating to contents displayed on the display unit of FIG. 1 and contents managed by a storage unit.

FIG. 11 is a flowchart in which the control unit of FIG. 2 operates with the configuration of FIG. 10;

FIG. 12 is a state diagram of screen data when updating cell data on linked screen data.

[Explanation of symbols]

 1 screen 2 corresponding data table 3 data storage unit 4 display unit 5 control unit 6 storage device 7 keyboard 8 mouse 21 screen ID storage unit 31 screen data unit 32 internal attribute storage unit 33 change information storage unit 34 change flag unit 35 common data designation Department

Claims (12)

[Claims] 1. An input means for receiving a user's input;
In the same data display editing method on a multiplex screen, comprising a screen data storage unit for storing spreadsheet type screen data, and a display unit for displaying a plurality of screens using the same screen data, input by the input means. Change information storing means for storing updated update information, and a change for changing screen data stored in the screen data and a plurality of screens displayed on the display unit by using the update information stored in the change means. Means for displaying and editing the same data on multiple screens. 2. A multi-screen same data display editing system comprising: a screen data storage section for storing spreadsheet type screen data; and a display section for displaying a plurality of screens using the same screen data. A management table that manages a relationship between a data name given to screen data used for the screen and a screen ID given to the screen, and when updating of the screen data displayed by the display unit occurs, First updating means for creating update information to be updated of screen data and updating the screen data stored in the data storage unit based on the update information; and updating for storing that the screen data has been updated. A storage means for searching a screen ID from the management table based on the update information when the first update storage means indicates an update, and displaying the screen ID on the display unit And a second updating means for updating the plurality of screens, wherein the same data is displayed and edited on multiple screens. 3. The update information includes a screen ID indicating a screen ID to be updated, an operation range indicating an update range of the screen, update data indicating the content of data to be updated, and an operation content indicating the content of the operation. 3. A method for displaying and editing the same data on multiple screens according to claim 1. 4. The method according to claim 1, wherein said input means adds cell data,
Storage means for storing an ID of a screen to be updated, an update range, and cell data to be updated when update information of data including any of deletion and change is input; Screen data updating means for updating screen data stored by the screen data storage means using update information, and a screen using screen data to be updated using the update information stored by the storage means 2. A method for displaying and editing the same data on multiple screens according to claim 1, further comprising a screen updating means for updating a plurality of data. 5. The method according to claim 5, wherein the input means adds a row or a column,
A storage unit for storing a screen ID to be updated, an update range, and an operation content when update information of data including one of deletion and change is input; and updating the update information stored by the storage unit. Screen data updating means for updating the screen data stored by the screen data storage unit using the screen data to be updated on the display unit using the update information stored by the storage means. 2. The method according to claim 1, further comprising screen updating means for updating a plurality of screens. 6. The update range stored by the storage unit includes a row to be added or deleted, and a row up to a bottom row shifted by the addition or deletion.
The same data display and editing method on multiple screens described. 7. The update range stored by the storage unit includes a column to be added or deleted and a column up to the rightmost column to be shifted by addition or deletion.
The same data display and editing method on multiple screens described. 8. The same data display method on a multiplex screen according to claim 1, wherein said change means is performed by storing information of a link destination and referring to the information. 9. The method according to claim 2, wherein the first update means, the update storage means, and the second update means are performed by storing information of a link destination and referring to the information. The same data display method on multiple screens. 10. A multiplex screen using input means for receiving a user's input, a screen data storage unit for storing spreadsheet-type screen data, and a display unit for displaying a plurality of screens using the same screen data. The same data display editing method as described above, wherein when the update of the screen data displayed by the display means occurs using a change information storage unit for storing the update information input by the input means, Storing the update information from the means in the change information storage unit, and using the update information stored in the change information storage unit to store the screen data stored in the screen data storage unit and the plurality of display data displayed on the display unit. A method for editing and displaying the same data on multiple screens, characterized by changing screens. 11. A multi-screen same data display / editing method using a screen data storage unit for storing spreadsheet type screen data and a display unit for displaying a plurality of screens using the same screen data. A correspondence data table that manages a relationship between a data name assigned to screen data used for the screen and a screen ID assigned to the screen, and a change information storage unit that stores update information input by the input unit. And updating the screen data when the screen data displayed by the display unit is updated using a change flag unit that indicates that the screen data stored in the screen data storage unit has been changed. Creating update information to be stored in the change information storage unit that is to be processed, and storing a screen stored in the screen data unit based on the update information stored in the change information storage unit Update the data, set the update flag section of the screen data section, determine the screen to be updated by searching for the screen ID number from the correspondence table using the updated screen data as a key, and display on the display section And editing the same data on multiple screens, characterized by updating the selected screen. 12. The update information includes a screen ID indicating a screen ID to be updated, an operation range indicating an update range of the screen, update data indicating the contents of data to be updated, and operation contents indicating the contents of the operation. A feature according to claim 10 or claim 11.
How to edit and display the same data on multiple screens described.