JP3229372B2 - Graph processing apparatus and method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph processing apparatus and a graph processing method capable of graphing tabular data.

[0002]

2. Description of the Related Art Conventionally, when displaying or printing tabular data created by a document processing apparatus, a text created as tabular data can be graphed as it is or a specific range table data in a table created in a document. Was to be graphed.

[0003]

However, in the above conventional example, the amount of tabular data created as tabular data and the range specification of the table in the document specified by the operator are enormous, such as exceeding the ability to express graphs. In the case of, the output result of printing or display becomes unreadable. For example, there are problems such as a line graph having a large number of line types that cannot be read, a pie chart having a large number of divisions, and a bar graph having a large number of bars, and being unable to determine a paint pattern for identifying the number. For this reason, the operator has to repeat the process of specifying the range of the table data by trial and error and execute the process, and the conventional apparatus has a point to be improved in that the operability for outputting the graph is poor.

[0004] In view of the above, an object of the present invention is to provide:
It is an object of the present invention to provide a graph processing apparatus and a method thereof that cannot output visual data when table data whose range is specified is multiplexed.

[0005]

In order to achieve the above object, an object of the present invention is to provide a graph processing apparatus for converting table data having a specified range into a graph and outputting the graph in a visible manner. allowable range storage means for storing information indicating an allowable range of the size of the table data to be,
Each time you move the indicated position on the displayed table data,
From the fixed start position to the current designated position,
A range designating means for designating an update as a target range;
The range of table data that is specified to be updated each time the table is moved
Of whether the magnitude is within an acceptable range, based on the information of the allowable range Symbol <br/>憶means, comparison determination unit, when the determination result is negative judgment of said judging means, wherein range specified hand
A system that prohibits the specification of updating the range of graph conversion by columns
And means of control .

The invention according to claim 2 is characterized by further comprising a range display means for updating and displaying the range specified by updating each time the range specified for the graph conversion is updated. According to a third aspect of the present invention, in the graph processing method of converting tabulated table data into a graph and visually outputting the same, a predetermined start position is set every time a designated position on the table data being displayed on the display unit is moved. The range specification process of updating and specifying the range from to the current designated position as the graph conversion target range, and the size of the table data to be graph converted
Memory for storing tolerance data indicating the tolerance
Each time the moving operation of the designated position is performed by taking in the permissible range data, the permissible range indicated by the permissible range data is
By comparing the size with the size of the range of the table data to be updated and specified in the range specifying step , the table to be updated and specified
A judging step of comparing and judging whether or not the data range is within an allowable range; and a prohibition of prohibiting the update designation of the target range of the graph conversion by the range designation step when the judgment result of the judging step is a negative judgment. And a process. The invention according to claim 4 further comprises a range display step of updating and displaying the range specified by the update on the display unit so as to be identifiable from the others each time the range of the graph conversion is specified to be updated. .

[0007]

According to the present invention, the designated position on the displayed table data is determined.
Each time you perform a move operation, the current indicated position from the predetermined start position
Updating is specified as the range of graph conversion
And the size of the table data range specified for update is within the allowable range
Prohibit the update specification of the target range when it is not within
If the display or printing capacity is limited,
Display and marking without excessive data
Wasteful output of characters that the operator does not intend
And set the range again to get more normal results.
Is effective in eliminating wasted time.
You.

When the specified range of the table data exceeds the limit, the specified range is not updated and displayed, so that the operator can know the allowable range of the table data.

[0009]

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

FIG. 1 shows an example of a circuit configuration according to an embodiment of the present invention.

In the figure, a central processing unit (CPU) 10,
Program memory 20, work memory 30, keyboard input device 40, floppy disk storage device (FDD)
50, a printing device 60, and a display device 70 are connected to a common bus.

The CPU 10 reads out various programs stored in the program memory 20 and performs a calculation to execute a graph creation process, a printing of the created graph, and a display process.

As will be described later, the CPU 10 operates as the determination means, the graph conversion permission means, and the update display permission means of the present invention.

The functions of the program stored in the program memory 20 are as follows.

The program 1 is a program for executing text editing or table data creation / editing.

Program 2 is a program for setting a range to be graphed from the table data created by program 1.

The program 3 is a program for designating the shape of the graph to be displayed or printed, for example, as a bar graph or a pie graph.

Program 4 is a program for determining whether or not the output result is legible when the table data to be graphed is set and the table data is visualized and output as a graph. is there.

The program 5 is a program for displaying the result of the judgment executed by the program 4 on the display device 70.

Programs 6 and 7 are programs for displaying and printing the created graphs, respectively.

The program memory 20 further stores reference format data 8 indicating the size of table data allowed for graph conversion.

The program memory 20 operates as storage means of the present invention.

The work memory 30 stores table data and a dot pattern of a graph to be created.

From the keyboard input device 40, the CPU 10
, And input data used when executing the various programs described above.

The FDD 50 saves and stores a document text including table data to be graphed.

FIG. 2 shows an example of table data created by the table data editing program 1.

In the figure, C1, C2, C3, etc. represent column divisions, and R1, R2, R3, etc. represent line divisions. This tabulation example is tabulation data indicating sales of products of companies A to P.

Such tabulation data is converted from FDD50 to C
After reading by the PU 10 and displaying it on the display device 70, the operator instructs the CPU 10 to execute the range designation program 2 from the keyboard input device 40. The operator sets the range of table data to be graphed from the keyboard input device 40. In the CPU 10, the range designation program 2
, The range specified by the operator is identified, and the specified range is displayed in a block form as shown in FIG. As a method of specifying a range, there is a method of specifying a block using a cursor or the like, and a method of specifying a column value and a line value.

After the range is specified, the CPU 10 executes the graph selection program 3 and receives information such as a graph shape instruction and a graph title print size input from the operator via the keyboard input device 40. After the designation of the range and the selection of the graph are completed, the CPU 10 determines the appropriateness of the print prediction for the table data by the range determination program 4 in FIG. At this time, the CPU 10 operates as the determination means of the present invention.

If the entire specified range cannot be graphed due to the capability (number of vertical / horizontal dots) of the display device 70 or the printing device 60 or the design of the graph, it is internally changed to the maximum outputable range. At this time, the CPU 10 notifies the tabular creator of the display error by using the notification program 6 using a buzzer, a display message, or both.

The information data in the determined range is stored in a specified range storage area in the work memory 30. The stored data may be range information consisting of character codes or graph image data obtained by converting numerical data in table data for display / print based on the information.

Based on the data, the CPU 10 executes display or printing by the display or printing program 6 or 7.

In the present embodiment, when graphing table data that can be merged into a table data portion or table data in a document created by a table creation function, as shown in FIG.
When the type of graph is determined by the graph selection function program 3, the range specification is restricted by the key operation of the creator according to the graph format selected by the data range specification program 2 and according to the expression ability of the display and the printing device. Is determined.

A specific example will be described. It is assumed that table data as shown in FIG. 2 is created in a document or dedicated table data created by a table creation function. FIG. 2 shows sales of electric products of companies A to P.

When graphing this tabular data, it is impossible to graph all tabular data because of the display or printing ability, and a range must be specified to graph the part that the author wants to emphasize. Must.

After the tabulation data is completed by the editing function, the operator performs a key operation for graphing with the keyboard 9. The graph selection program 3 is activated, and a menu for selecting the type of graph and the like is displayed. FIG. 3 shows a menu display example. When an operator's desired graph is designated on the menu screen by the keyboard 9, the execution procedure of the CPU 10 shifts to the range designation program 2 in FIG. CP
U10 refers to the reference data format in the memory 20, that is, the restriction table in FIG. 4, and fetches the specified element (step S10).

When the operator converts a part of the table data of FIG. 2 into a pie chart, the number of columns of the table data permitted for printing is 1 = 6, and the number of lines is m = 5. Note that the number of columns corresponds to the number of divisions of a circle, and the number of lines corresponds to the number of circles in a multiplex pie graph.

The operator instructs the start position (see FIG. 5) of the specified range by using the movement keys (cursor key, TAB key, backspace key, etc.) of the keyboard 9 (step S20).

Next, when the end position of the designated range is moved by the above-mentioned movement key, the CPU 10 uses the range judgment program 4 to determine the size of the designated range from the end position of the currently designated range and the start position of the designated range. (Number of columns, number of lines) is calculated (step S40).

Next, the calculated size of the specified range is compared with the size of the allowable range indicated by the specified element (step S50). The CPU 10 at this time operates as the determination means of the present invention. While the size of the specified range is included in the size of the allowable range, the currently specified range is updated and displayed on the display screen (steps S50 → S65).

Each time the operator presses the move key, the operation shown in FIG.
The loop processing of steps S30 to S50 → S65 → S30 is executed, and the designated range is expanded. If this specified range exceeds l = 6 columns or m = 5 lines, it is detected by the determination processing in step S50 that the specified range is exceeded.

The CPU 10 generates an error buzzer by the user notification program 6 and displays an error message on a display screen. Further, the permission flag is turned off (step S60). As a result, the operator can know an excessive block expansion error. At this time, the display of the specified range on the display screen is not updated, and is kept at the maximum allowable range. At this time, the CPU 10 operates as the display control means of the present invention.

When the operator reduces the designated range using the move key in response to the warning, the procedure proceeds to step S30.
The process proceeds from S50 to S65, and the warning display disappears. Also,
When the operator presses the designation end key in the display state of FIG. 7, the CPU 10 confirms that the permission flag is on, sets and stores the designated range start and end positions in the work memory 20, and terminates the range designation process ( Step S100 →
S110). By setting this range information, a graph conversion process can be performed.

In this control procedure, when the designated range exceeds the allowable range, the permission flag is turned off even if the designated end key is pressed. It is not accepted and table data beyond the allowable range is not set by mistake.

The CPU 10 at the time of executing the process of step S100 operates as a means for permitting the graph conversion of the present invention. FIG. 7 shows an example of the block range determined in this way, and FIG. 8 shows a print example.

In addition to the present embodiment, the following example is given.

1) In this embodiment, after the operator determines the graph format, the range specification program 2 specifies the range of the table data. However, the maximum number of columns and the maximum number of lines are determined from the restriction table of FIG. It is also possible to inform the operator of the limit position by previously displaying a block range that can be designated from the designated start position (l ₀ column, m ₀ line) when the range is designated by shading, halftone, or the like.

2) After the designation of the range is completed, the editing program shown in FIG. 1 is started to exchange the required line data outside the range with the data within the range. Obtained graph.
For this purpose, it is only necessary to determine an operation for graphing execution after the range is specified, and shift the execution procedure to the editing program until the operation is input.

3) Further, after the range designation, the function of shifting the entire block range right, left, up and down by changing the position of the start position (l ₀ , m ₀ ) may be provided. When returning to the range designation screen, it is possible to make a graph in which only the data is changed without changing the size of the range, so that not only the same effect but also a graph according to the intention of the operator can be obtained.

4) In this embodiment, even if a range exceeding the allowable range is specified, the display is not made beyond the allowable range. However, if the operator wants to be informed of the size of the specified range, the specified range is set. What is necessary is just to update and display the range area correspondingly.

[0051]

As described above , according to the present invention,
Each time you move the indicated position on the displayed table data,
From the fixed start position to the current designated position,
Table to be updated and specified as a target range
If the size of the data range is not within the
Since the update specification of the box has been prohibited, display or mark
Excessive range specified by the operator when character ability is limited
Display and print results without operator
Eliminate unnecessary output of unintended items
Time setting such as re-setting the range to obtain the result
This has the effect of eliminating unnecessary waste.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a circuit configuration of an embodiment of the present invention.

FIG. 2 is an explanatory diagram showing an example of table data according to the embodiment of the present invention.

FIG. 3 is an explanatory diagram showing a graph selection display screen according to the embodiment of the present invention.

FIG. 4 is an explanatory diagram showing an allowable range of the embodiment of the present invention.

FIG. 5 is an explanatory diagram showing table data and a range designation area according to the embodiment of the present invention.

FIG. 6 is a flowchart illustrating a processing procedure of a range designation process executed by a CPU 10 according to the embodiment of the present invention.

FIG. 7 is an explanatory diagram showing a table data area finally specified according to the embodiment of the present invention;

FIG. 8 is an explanatory diagram showing a printing result according to the embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 CPU 20 Program memory 30 Work memory 40 Keyboard input device 50 FDD 60 Printing device 70 Display device

──────────────────────────────────────────────────続 き Continued on front page (58) Field surveyed (Int.Cl. ⁷ , DB name) G06T 11/20 120

Claims (4)

(57) [Claims] 1. A graph processing apparatus for converting table data having a specified range into a graph and visually outputting the graph data, wherein a permissible range storage means for storing information indicating a permissible range of the size of the table data to be converted. A range designating means for designating the update from a predetermined start position to the current designated position as a target range of the graph conversion every time the designated position on the displayed table data is moved; and moving the designated position For each time, whether or not the size of the range of the table data to be updated is within the allowable range is determined based on the information in the allowable range storage means, and a determination is made. A control unit for prohibiting the update specification of the target range of the graph conversion by the range specification unit in the case of the determination. 2. The apparatus according to claim 1, further comprising: a range display means for updating and displaying the range specified for updating each time the range specified for the graph conversion is updated. Graph processing device. 3. A graph processing method for converting table data having a specified range into a graph and visually outputting the graph data, wherein each time a designated position on the table data being displayed on the display unit is moved, a predetermined start position is changed to a current position. Range specification process for updating and specifying up to the indicated position as the graph conversion target range, and the permission for the size of the table data to be graph converted.
From the memory that stores the tolerance data indicating the tolerance range.
Each time the operation of moving the designated position is performed by capturing the allowable range data, the size of the allowable range indicated by the allowable range data is determined.
And the size of the range of the table data to be updated and specified in the range specifying step, and the table data to be updated and specified
A determining step of comparing and determining whether the range is within an allowable range; and a prohibiting step of prohibiting the update specification of the target range of the graph conversion by the range specifying step when the determination result of the determining step is a negative determination. And a graph processing method. 4. The method according to claim 1, further comprising the step of: displaying the range specified by the update on the display unit so as to be distinguishable from the others each time the range specified by the graph conversion is updated. 3. The graph processing method according to 3.