JPH08180117A - Table processor - Google Patents

Abstract

PURPOSE: To improve the operability at the time of table processing by previously setting a specific range of row and column editing and performing the editing only within the set range. CONSTITUTION: As shown in Figure (a), the inverted cell area (domain) is selected as a start position and a cursor 10 is moved up and down, and right and left to select an object range (Here, the range from a cell position B2 to a D6 is selected as shown in Figure (b)). Then an editing area is set within the range from the cell position B2 to the D6. This setting method is similar to a method which setting the modification (meshing, ruled line, etc.) of cells and similar to a method of holding data (information). Thus, when the attribute of the object range is set in advance, the row and column editing of the specific area is made effect and held until the setting is reset.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a spreadsheet processor, and more particularly to a method of editing cells in spreadsheet software often used in personal computers.

[0002]

2. Description of the Related Art Generally, in a conventional table processing apparatus, there are two types of processing: "cell editing" for editing an arbitrary rectangular area for a cell as an edit target range and "matrix editing" for editing in units of rows or columns. Various types of editing methods are possible.

FIGS. 6 and 7 are diagrams for explaining a method of performing cell editing. First, the user moves the cursor 10 to the start position of the edit target range (FIG. 6A). next,
The cursor 10 is moved up, down, left and right to fix the edit range as shown in FIG. 6 (b). Here, it is assumed that "cell copy" is selected as the editing method. In this case, after the start position of the editing destination is designated (FIG. 7A), the cursor 10 is moved vertically and horizontally to designate the range to be copied, whereby the cell copying is executed and the state shown in FIG. A display screen as shown in is obtained.

Next, a method of editing a matrix will be described with reference to FIGS. Here, it is assumed that "copy line" is selected. First, the cursor 10 is moved to the start position of the edit target range (FIG. 8A). Next, the cursor 10 is moved up and down to fix the editing range (FIG. 8 (b)).
Next, after the start position of the edit destination is designated (FIG. 9A), the cursor 10 is moved up and down to designate the range to be line-copied, whereby line copying is performed and the line copying is performed as shown in FIG. 9B. A display screen as shown is obtained.

[0005]

However, the above two editing methods have the following drawbacks. That is, in cell editing, only a specific rectangular area can be selected as an edit target, but it is necessary to always specify a rectangular area as the edit target range, and the edit destination also needs to specify an arbitrary cell position. .

Further, in the case of matrix editing, the edit range can be edited only by fixing the row or column, but there is a disadvantage that the edit range extends to all columns or all rows.

Therefore, when the user edits a specific rectangular area, the method of matrix editing cannot be used, and the method of cell editing must be performed. The table processing apparatus of the present invention has been made in view of such a problem, and an object thereof is to make it possible to easily edit a specific rectangular area by using matrix editing.

[0008]

The means of the present invention are as follows. The holding unit holds the edit target range when setting the attribute of the cell. The matrix editing means edits a row or a column as an edit target range. The control means determines whether the range to be edited by the matrix editing means is within the range to be edited held by the holding means, and controls the matrix editing means to perform editing according to the determination result. .

[0009]

The operation of the means of the present invention is as follows. When setting the cell attribute, the set editing target range is held by the holding unit. Then, the matrix editing means determines whether or not the edit target range is within the edit target range held by the holding means, and performs editing according to the determination result. For example, if it is outside the edit target range, no processing is performed, and only when it is within the edit target range, matrix editing such as line movement is performed.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail below with reference to FIGS. FIG. 1 is a block diagram showing the configuration of a table processing device to which the present invention is applied. In the figure,
Reference numeral 2 is a CPU, which controls each part described below. An input device 1 is composed of a keyboard, a mouse and the like having input function keys. The operation signal generated when the user operates the input function key of the input device 1 is transferred to the CPU 2 and a predetermined process is executed. A disk device 4 stores table data created by the user. Reference numeral 3 is a RAM, and the table data stored in the disk device 4 is read and expanded at the time of editing. A display memory 5 stores display data in a dot pattern, and stores a display image obtained by converting the table data stored in the RAM 3 under the control of the CPU 2. The data in the display memory 5 is displayed on the display unit 7 via the driver 6.

The outline of this embodiment will be described below. Figure 2
(A), (b) is a figure for demonstrating the method of setting the range used as the edit object of a matrix edit. First, FIG. 2 (a)
As shown in, the cell area “district” highlighted is used as the selection start position, and the cursor 10 is moved up, down, left, and right to select the target range (here, from the cell position B2 as shown in FIG. 2B). D6 range is selected). next,
The attributes of the editing area are set within the range of cell positions B2 to D6.

The above-mentioned setting method is completely the same as the known method of setting the cell decoration (shading, ruled lines, etc.), and is the same as the way of holding data (information). As described above, when the attribute of the target range is set in advance, the matrix editing for the specific region is valid, and the matrix editing for the specific region is valid until this setting is released.

FIGS. 3 (a) and 3 (b) are diagrams for explaining the operation in the case of performing the matrix editing relating to the "row movement" in the edit target range set by the above method. First, "row movement" is selected as the editing method. Next, the edit target range is selected (reverse display area in FIG. 3A). Next, move the cursor 10 up and down to specify the editing destination (see FIG.
(B)), line movement is executed. As a result, FIG.
As shown in (c), even if matrix editing is performed, line movement is actually performed only within the area set as the editing target area in advance, and as a result, the same effect as when cell editing is performed. Bring

The above outline will be described below with reference to the data structure diagram of FIG. 4 and the flowchart of FIG. Here, a case will be described in which matrix editing for "row movement" is performed.

FIG. 4A shows a set area information storage table 11 in which information set by the user as an edit target range is held. As shown in the figure, Xs represents an editing start X coordinate, Ys represents a start Y coordinate, Xe represents an end X coordinate, and Ye represents an end Y coordinate. In addition, FIG.
Is a table 12 for storing edit area information, which has a general data structure as information for matrix editing in the table processing device. In the figure, the Y coordinate includes information in the case of moving the cell information of the row from Yfs to the row of Yfe to the row of Yt.

FIG. 5 is a flow chart showing a specific process when a matrix edit relating to row movement is performed. It is assumed that the "move" command and the lines of the move source and the move destination are specified. First, x is a variable indicating a cell in the same row for internal processing, and 1 is set as its initial value (S2
1). This corresponds to the cell in the first column of the processing start row, and thereafter, the row movement is edited one cell at a time from the beginning to the end of the X coordinate.

Therefore, it is next determined whether or not x is smaller than the maximum value. If x has not reached the maximum value, then
It is determined whether the edit target range is set in advance (S23). In the case of YES here, it is determined whether or not x is smaller than the editing start X coordinate Xs (S24).
Here, if x <Xs, it is determined to be outside the setting area,
Without doing anything, it increments by 1 in S27, returns to S22, and shifts to the processing of the next cell.

If x is larger than Xs in S24, it is further judged whether or not x is larger than the end X coordinate Xe of the set area (S25). If x is larger than Xe, it is similarly determined to be outside the set area, and nothing is performed, and the process proceeds to the next cell. If it is determined in S25 that x is smaller than Xe, it is regarded as a cell in the setting area, and the data of the cell (X, Yf) of the source row is edited to the cell (X) of the destination row. , Yt) (S
26). After that, while incrementing x by 1 (S2
7) The line moving process is executed in the area.

In the above-described embodiment, the case of performing row editing has been described, but the present invention is not limited to this, and column editing can be performed in the same manner by exchanging X and Y in the above processing. Moreover, although the editing example of movement has been described, editing such as copying, cutting, and pasting may be performed.

[0020]

According to the present invention, when performing a matrix edit, if a specific range to be edited is set in advance, the edit is performed only within this set range, so that any edit area can be set. The same effect as specified cell editing can be obtained with only simple operations. This has the effect of greatly improving the operability during table processing.

[Brief description of drawings]

FIG. 1 is a diagram showing a configuration of a table processing device to which the present invention is applied.

FIG. 2 is a diagram for explaining a method of setting a range to be edited in matrix editing.

FIG. 3 is a diagram for explaining an operation when performing a matrix edit regarding row movement.

FIG. 4 is a diagram showing a structure of data used when performing line movement in the present embodiment.

FIG. 5 is a flowchart for explaining the operation of the present embodiment.

FIG. 6 is a diagram for explaining a cell editing operation.

FIG. 7 is a diagram for explaining a cell editing operation.

FIG. 8 is a diagram for explaining a matrix editing operation.

FIG. 9 is a diagram for explaining a matrix editing operation.

[Explanation of symbols]

1 ... Input device, 2 ... CPU, 3 ... RAM, 4 ... Disk device, 5 ... Display memory, 6 ... Driver, 7 ... Display unit.

Claims (1)

[Claims] 1. When setting an attribute of a cell, a holding unit that holds the edit target range, a matrix editing unit that edits a row or a column as the edit target range, and an edit target range by the matrix editing unit are And a control means for controlling the matrix editing means so as to determine whether or not the editing target range is held by the holding means and perform editing according to the determination result. Processing equipment.