JPH0660097A - Data processing method and apparatus thereof - Google Patents

Abstract

PURPOSE:To plot a graph by changing a graph attribute to the desired graph attribute during the execution of a processing program by preserving and registering the graph attribute data of each plotted graph in a storage medium, and changing the graph attribute of the graph to be plotted while replacing the arbitrary graph attribute data to be referred to by the processing program with the preserved and registered desired graph attribute data. CONSTITUTION:A graph plotting means(function means to be executed based on the graph processing program stored in a PMEM 3 by a CPU 2) plots the graph corresponding to prescribed data on a screen according to the set graph attribute data. At that time, the graph attribute data of the graph plotted by the preserving means CPU 2 are preserved and registered in the storage medium PMEM 3. Then, the arbitrary graph attribute data referred to by the graph plotting means are replaced with the preserved and registered desired graph attribute data by the replacing means CPU 2.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing method and apparatus for drawing a graph based on data of a spreadsheet or a database.

[0002]

2. Description of the Related Art Conventionally, when this type of graph display processing is executed, a graph drawing program is started as a subroutine from a data processing program such as a spreadsheet or a database, and the surface type, line type, etc. to be displayed as a graph The graph attribute data of was managed by the data processing program together with the data such as the numerical value of the data processing program.

[0003]

Therefore, in the above-described conventional example, when performing graph processing, graph attribute data such as the type, size, color and face type of the displayed graph is set for each data such as spreadsheet. Since it is necessary to repeat the same operation for multiple graphs when creating graphs with the same attributes from different spreadsheet data,
There is a problem that the graph display processing efficiency is extremely low.

The present invention has been made in order to solve the above-mentioned problems. The graph attribute data of a drawn graph is stored and managed, and the graph attribute data of the graph being drawn is stored and registered. An object of the present invention is to provide a graph processing method and a device thereof which can very easily create a graph having a plurality of same attributes by substituting desired graph attribute data.

[0005]

According to a data processing method of the present invention, a graph for a predetermined data is drawn on a screen while a graph processing program is set in accordance with set graph attribute data, The graph attribute data of each graph drawn on the screen is stored and registered in a storage medium, and any graph attribute data referred to by the graph processing program is replaced with desired graph attribute data stored and registered in the storage medium. While changing the graph attribute of the graph drawn on the screen.

The data processing apparatus according to the present invention includes a graph drawing means for drawing a graph for predetermined data on the screen according to the set graph attribute data, and a graph for each graph drawn by the graph drawing means on the screen. It has a storage means for storing and registering the attribute data in a storage medium, and a replacing means for replacing arbitrary graph attribute data referenced by the graph drawing means with desired stored and registered graph attribute data.

[0007]

In the data processing method according to the present invention, the graph for the predetermined data is drawn on the screen while the graph processing program follows the set graph attribute data.
While the graph processing program is running, the graph attribute data of each graph drawn on the screen is stored and registered in a storage medium,
By changing the graph attribute of the graph drawn on the screen while replacing any graph attribute data referenced by the graph processing program with desired graph attribute data stored and registered in the storage medium, It is possible to change the graph attribute of the graph drawn on the screen to a desired graph attribute and draw the graph while the graph processing program is being executed.

In the data processing device according to the present invention,
When the graph drawing means draws a graph for predetermined data on the screen according to the set graph attribute data, the graph attribute data of the graph drawn by the storing means is stored and registered in the storage medium. Draws a graph while changing the graph attribute of the graph drawn on the screen to the desired graph attribute by replacing the referenced graph attribute data with the desired graph attribute data stored and registered by the replacing means. It is possible to do.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a block diagram for explaining the configuration of a data processing apparatus showing an embodiment of the present invention, which corresponds to, for example, a system capable of executing document processing, spreadsheet processing and graph processing.

In FIG. 1, reference numeral 1 is a system bus, and each constituent block to be described below is connected to the system bus 1. 2 is a CPU, which is a program memory (P
Access to devices connected to the system bus 1 is comprehensively controlled according to various document processing programs stored in the MEM 3 (including control procedures described in the following flowcharts). The program memory 3 has an IP
The system program read from the hard disk 15 at the time of L and the hard disk 15 along with the execution of the functional processing
The function processing program read from is resident. Further, the text data input from the keyboard 9 is also encoded and stored in the program memory 3. An image memory (IMEM) 4 stores a bit image of image information read by the image scanner 5 or the like. An image input / output control unit 6 is an image scanner 5
The input of the image from the printer 1 and the output of the print image developed into the bitmap image in the image memory 4 to the printer 7 are controlled. An input control unit 8 is connected with an input device such as a keyboard 9 and a pointing device 10 (PD). The operator operates the keyboard 9 to issue system operation commands and the like. The pointing device 10 is for selecting image information on the CRT display device (CRT) 13 and giving an instruction for processing, and a mouse is used in this embodiment. As a result, the mouse cursor on the CRT 13 is arbitrarily moved in the X and Y directions to select menus and select / edit character data, graphic data, image data and the like. A video image memory (VRAM) 11 reads the display data expanded in the VRAM 11 to the display output control unit 12 to display the CRT1.
Display on the screen of 3. If the data to be displayed is character data, the font pattern corresponding to the position and the attribute information is developed as an image on the VRAM 11, and the cursor can be directly generated and displayed in the display area of the VRAM 11 by software control. Is. An external storage device control unit 14 controls access to a hard disk 15 and a floppy disk 16 which are disks for data files. The CRT 13 can display a character image and the like in color.

In the thus configured data processing device, the graph drawing means (the functional means executed by the CPU 2 based on the graph processing program stored in the PMEM 3) is set for the predetermined data according to the set graph attribute data. When the graph is drawn on the screen, the graph attribute data of the graph drawn by the storage means (CPU2) is stored and registered in the storage medium (PMEM3), and the arbitrary graph attribute data referenced by the graph drawing means is stored. By replacing the desired graph attribute data stored and registered by the replacement unit (CPU 2), it is possible to draw the graph while changing the graph attribute of the graph drawn on the screen to the desired graph attribute.

FIG. 2 is a diagram showing an example of the data structure of the document file in the data processing apparatus shown in FIG.

As shown in this figure, the text data 10
D, two graph data 11D, 12D and two table data 13D, 14D are included. The data processing device in this embodiment manages data of different processing programs such as sentences, figures, graphs, and spreadsheets as one data file.

FIG. 3 is a diagram showing an example of the editing screen displayed on the CRT 13 shown in FIG. 1, which corresponds to the display based on the data of the document file shown in FIG.

As shown in this figure, at the top of the document being edited, there is a menu 26 for instructing commands,
A status display area 27 for displaying a simple message is provided at the bottom. On this edit page, a background frame (paper) 28
2, the text data 10 shown in FIG. 2 is displayed as a text 31, the graph data D11 is displayed as a graph 32 in the graph frame 29, and the graph data 12D is displayed as a graph 33 in the graph frame 30. Has been done. In addition,
Editing of "text", "figure", "graph", etc. is performed for each frame (editing area), and switching of the process of text-graph etc. is instructed by the pointing device 10 for the frame to be edited. Alternatively, the process to be executed is selected from the "process" menu in the menu 26. When the background frame 28 is designated, the text editing process is started, and when the graph frame 29 or the graph frame 30 is designated, the graph editing process is automatically started. Also, the frame being edited is changed to a thick gray line and displayed.

FIG. 4 is a diagram showing a table data file corresponding to the graphs 32 and 33 shown in FIG. 3, in which (a) corresponds to the graph 32 and (b) corresponds to the graph 33.

In the figure, reference numeral 40 is a table data display window, which is automatically read from the hard disk 15 when the graph 32 is selected as an editing target and is displayed on the CRT 13.
Is displayed in the window. Reference numeral 41 is a table data display window, which is automatically read from the hard disk 15 when the graph 33 is selected as an editing target and is displayed on the CRT 13
Is displayed in the window.

The graph processing method according to the present invention will be described below with reference to FIGS.

FIG. 5 is a flow chart for explaining an example of a main processing procedure in the graph processing method showing an embodiment of the present invention. Note that S1 to S12 indicate each step.

First, in the initialization process of step S1, the edit screen including the edit frame 25, the menu 26, the state display area 27, and the background frame (paper) 28 shown in FIG. 3 is displayed on the CRT1.
3 and read the document data as shown in FIG. 4 from the hard disk 15 or floppy disk 16 to create a graph frame 29 and a graph frame 30 on the screen, and then a sentence 31, a graph 32, and a graph 33 in order. indicate. As a result, the display screen state of the CRT 13 becomes the display screen shown in FIG. Then, in step S2,
It waits for a command input from the keyboard 9 or the pointing device 10. In step S3, it is determined whether or not the input is the "graph processing" command in the "processing" menu, and if YES, in step S4, "please specify a frame when processing with an existing frame." If a new graph is to be created, please open a frame. "Is displayed and an edit frame is designated, or a new edit frame is created, and the process proceeds to step S6 and thereafter.

On the other hand, if NO in step S3,
That is, when it is confirmed in step S5 that the input in step S2 is “designation of graph frame”, the process proceeds to step S6 and subsequent steps.

In step S6, the display of the frame line of the graph frame is changed from the black thin line to the gray thick line, the edit area is specified, and then the graph processing described later (see FIG. 6) is performed. The graph process ends when another process is selected in the graph process or when the outside of the frame which is the editing area is designated. When the graph processing is completed, the display of the graph frame line is returned to the black thin line in step S8, the process returns to step S3, the input at the end of the graph processing is analyzed, and the processing is continued.

In step S9, if it is other processing such as "text" or "graphic", the other processing of step S10 is performed. Other processing is similar to graph processing,
When a process other than editing is designated or a region other than the editing region is designated, the process proceeds to step S3.

When it is confirmed in step S11 that "end" is selected, the document data is updated and the edit window is erased as the end processing in step S12, and the processing is ended.

FIG. 6 is a flow chart showing the detailed procedure of the graph processing routine shown in FIG. Note that S20
-S29 shows each step.

First, the process of copying the attribute data of the graph data 11D shown in FIG. 2 to the attribute data of the graph data 12D and changing the graph 33 to the graph 33A shown in FIG. 9 as shown in FIG. Will be described.

First, when the graph processing is started, the graph initialization processing of step S20 is executed, and step S21
The command input standby status is entered. Then, step S22
In, the CPU 2 determines whether or not the input command is a "save attribute" command. If YES, the process proceeds to step S23, executes an attribute save processing routine described later, and returns to step S21.

On the other hand, if the determination in step S22 is NO, then in step S24 the CPU 2 determines whether the "attribute replacement" command has been designated for the input command.
If YES, the attribute replacement process routine described later is executed in step S25, and the process returns to step S21.

On the other hand, if NO in the determination in step S24, the CPU 2 determines in step S26 whether or not another command is designated by the pointing device 10. If YES, the other command processing is performed in step S27. Execute, step S21
Return to. On the other hand, if NO in the determination in step S26, it is determined in step S28 whether another process or the outside of the frame is designated by the pointing device 10. If NO, the process returns to step S21, and YE
If S, the graph end process is executed in step S29, and the process proceeds to step S8 shown in FIG.

In this way, the graph processing program (CP
U2 executes) and draws a graph for the specified data on the screen according to the set graph attribute data.
A storage medium (PMEM3) for storing the graph attribute data of each graph drawn on the screen while the graph processing program is running.
The graph of the graph drawn on the screen while being stored and registered in the graph processing program, and any graph attribute data referenced by the graph processing program is replaced with desired graph attribute data stored and registered in the storage medium (PMEM3). By changing the attribute, it is possible to change the graph attribute of the graph drawn on the screen to a desired graph attribute and draw the graph while the graph processing program is being executed.

FIG. 7 is a flow chart showing an example of a detailed procedure of the attribute storage processing routine shown in FIG. Note that S30 to S33 indicate each step.

First, in step S30, a clipboard to be described later is displayed on the CRT 13 as a window, in step S31, a copy of the graph attribute data is created from the graph data 11D shown in FIG. Enter a name to distinguish it from. Next, in step S33, the clipboard window is erased, that is, the clipboard is erased from the screen of the CRT 13, and the process ends.

FIG. 8 is a flow chart showing an example of a detailed procedure of the attribute replacement processing routine shown in FIG. Note that S40 to S44 indicate each step.

First, in step S40, a clipboard, which will be described later, is displayed on the CRT 13 as a window, and in step S41, attribute data in the clipboard is designated. Then, in step S42,
Delete the clipboard from the CRT 13 and step S4
In step 3, only the graph attribute data is replaced with the specified attribute data, and in step S44, the graph is redisplayed on the CRT 13 based on the replaced graph attribute data, and the process ends. [Process of Changing Graph 33 to Graph 33A] By the above process, for example, when changing the graph 33 shown in FIG. 3 to the graph 33A shown in FIG.
Since the graph 32 is in the edited state, the graph 32 is displayed using the graph data 11D shown in FIG. 2 using the table data 13D. Further, during the display state of the graph frame 29 shown in FIG. 3, step S21 of the flowchart shown in FIG.
In the command input standby state in step S22, when the "save attribute" command is selected from the "edit" menu in the menu 26 in step S22, the attribute storage process of step S23 is started, and step S30 is performed.
At, the clipboard window W1 as shown in FIG. 10 is displayed.

The clipboard always functions as a buffer for storing a plurality of data created at a fixed position, and since it does not have a data processing means, it can be arbitrarily selected according to a plurality of systems and their processing. It is possible to use. Each piece of data has as its header the name of the processing system that stored it. Therefore, each processing system can determine whether the data can be used by itself by reading the header.

On the other hand, in step S30, only the graph data is displayed from the plurality of data registered in the clipboard, and the list is displayed in the clipboard window W1. The clipboard window W1 shown in FIG. 10 shows a state in which "graph attribute data of sales record of '89" is currently registered in the clipboard.
In step S31, the graph data 11D shown in FIG.
Make a copy of the graph attribute data from and save it to the clipboard, then display the icon on the clipboard. In this state, "undefined" for this data
Is named. Currently registered data is
As shown in FIG. 11, the icon is displayed in reverse video in distinction from other data. Next, in step S32, a name input window W2 as shown in FIG. 12 is displayed, and a name for distinguishing this data from other data is input. In step S33, when the clipboard window is closed, "save attribute" The process ends.

Then, the graph attributes stored in the "attribute storage" process are applied to the graph 33 shown in FIG. 3, and the graph attribute data of the graph data 12D shown in FIG. 2 and the data on the clipboard will be described later. Replace with. [Graph Attribute Data Replacement Process] In the flowchart shown in FIG. 6, while the graph 32 is being edited, the graph 33
When the graph frame 30 in which is displayed is specified by the pointing device 10, the graph 3 is displayed in step S28.
The graph processing in 2 ends. In step S29, the data held by the graph 32 is written to a file, and as a result, the graph attribute data 1 shown in FIG.
Update 1D. At this time, as shown in FIG. 4, the table data display window 40 is closed and the spreadsheet calculation process is ended.

When the processing of the graph 32 is completed, the graph frame 2 is displayed in step S8 of the flowchart shown in FIG.
The display of 9 is returned to the black thin line, and the input analysis of step S3 is performed. Since the input that triggered the end of editing the graph 32 is a click instruction by the pointing device 10 for the frame line of the graph 30, the process proceeds from step S5 to step S6, and the frame line of the graph frame 30 is changed in step S6. Change to a thick gray line and move to the graph processing shown in FIG. 6 again.

When the graph processing is started, step S2
In the graph initialization process of 0, the graph data 12D shown in FIG. 2 is read from the frame number, and the table calculation data shown in FIG. Start the process. In the graph processing, the spreadsheet data 14D shown in FIG.
Is read out and the graph data 12D is applied to this table data to display the graph 33 shown in FIG. Thus, the initialization process ends and the command input state of step S21 is entered. When the "attribute replacement" command is selected in step S21, the attribute replacement process of step S25 is performed.

In the attribute replacement process, the clipboard is displayed in step S40, as in step S30. At this time, the last registered data is highlighted as shown in FIG. When the attribute data in the clipboard is specified in step S41, the clipboard is erased in step S42, and then only the graph attribute data of the graph data held by the graph process is specified in step S43. Replace with. In step S44, the graph is redisplayed using the graph management data in the table data 14 and the graph management data in the graph data 2 and the graph attribute data replaced by the attribute replacement, and the attribute replacement processing ends. as a result,
The display state of FIG. 3 is changed to the display shown in FIG. 9, and the graph 33 is changed to the graph 33A. When the graph processing in the graph 33A ends, in step S29, the graph data is written to a file and the graph data 12D shown in FIG. 2 is updated, so that the graph attribute data is also updated on the file.

In the above embodiment, within one document,
Although the process of copying the attribute of a certain graph to another graph attribute in a document has been described as an example, the clipboard in the embodiment of the present invention has a structure of only the intermediate file on the PMEM3 and the management file of the intermediate file. From, it is possible to access from multiple programs,
The same applies to copying of attributes between different documents without departing from the scope of the present invention.

In the above embodiment, the case where the clipboard is used as a data storage common area accessible by a plurality of graph processing programs has been described. However, the data stored as a file is directly designated and the graph attribute The present invention can be applied to a method of fetching data as a graph attribute currently being processed or a method of fetching the attribute of the instructed graph by directly instructing the graph displayed on the CRT 13.

Further, in the above embodiment, the case where the above-mentioned graph processing is executed during the execution of the spreadsheet program has been described, but the data processing program may be replaced with another data processing program such as a database or a table group. It goes without saying that it is possible.

[0044]

As described above, the method according to the present invention draws a graph for predetermined data on the screen according to the graph attribute data set by the graph processing program, and while the graph processing program is running, The graph attribute data of each graph drawn on the screen is stored and registered in a storage medium, and any graph attribute data referred to by the graph processing program is replaced with desired graph attribute data stored and registered in the storage medium. However, since the graph attribute of the graph drawn on the screen is changed, it is possible to change the graph attribute of the graph drawn on the screen to a desired graph attribute while the graph processing program is being executed.

In the device according to the present invention, when the graph drawing means draws the graph for the predetermined data on the screen according to the set graph attribute data, the graph attribute data of the graph drawn by the storage means is stored in the storage medium. The graph of the graph drawn on the screen is stored because the graph is stored and registered, and the replacement graph replaces any graph attribute data referenced by the graph drawing device with the desired graph attribute data stored and registered. A graph can be drawn while changing the attribute to a desired graph attribute.

Therefore, it is possible to create a graph having the same size, the type of graph to be displayed, and the graph attributes such as the line type from a plurality of display data by a very simple operation. A complicated attribute setting process such as repeating the same editing process every time is unnecessary, and a graph can be efficiently created. In addition, there is an excellent effect that a plurality of graphs have the same appearance, that is, a document including a graph having a unified layout such as a graph size and a display position can be edited with good operability.

[Brief description of drawings]

FIG. 1 is a block diagram illustrating a configuration of a data processing device according to an embodiment of the present invention.

FIG. 2 is a diagram showing an example of a data structure of a document file in the data processing device shown in FIG.

3 is a diagram showing an example of an edit screen displayed on the CRT shown in FIG.

4 is a diagram showing a table data file corresponding to the graph shown in FIG.

FIG. 5 is a flowchart illustrating an example of a main processing procedure in the graph processing method according to the embodiment of the present invention.

6 is a flowchart showing a detailed procedure of the graph processing routine shown in FIG.

FIG. 7 is a flowchart showing an example of a detailed procedure of an attribute storage processing routine shown in FIG.

8 is a flowchart showing an example of a detailed procedure of an attribute replacement processing routine shown in FIG.

FIG. 9 is a diagram illustrating a graph processing state in the data processing device according to the present invention.

FIG. 10 is a diagram illustrating a graph processing state in the data processing device according to the present invention.

FIG. 11 is a diagram illustrating a graph processing state in the data processing device according to the present invention.

FIG. 12 is a diagram illustrating a graph processing state in the data processing device according to the present invention.

FIG. 13 is a diagram illustrating a graph processing state in the data processing device according to the present invention.

[Explanation of symbols]

 2 CPU 3 PMEM 9 keyboard 10 pointing device 13 CRT

Claims (2)

[Claims] 1. A graph processing program draws a graph for predetermined data on a screen according to set graph attribute data, and stores the graph attribute data of each graph drawn on the screen while the graph processing program is running. A graph attribute of a graph drawn on the screen while being stored and registered in a medium, and any graph attribute data referenced by the graph processing program is replaced with desired graph attribute data stored and registered in the storage medium. A method for processing data, characterized by: 2. A graph drawing means for drawing a graph for predetermined data on a screen according to set graph attribute data, and graph attribute data of each graph drawn on the screen by the graph drawing means is stored in a storage medium. A data processing device comprising: a storage unit for registering and a replacement unit for replacing arbitrary graph attribute data referred to by the graph drawing unit with desired graph attribute data stored and registered.