JPH0474750B2 - - Google Patents

Description

[Detailed description of the invention]

[Summary] When editing tabular data, the method of specifying the range of data to be moved is identified, and the editing process is performed after automatically determining whether to shift or overwrite, thereby eliminating the need to specify shift and overwrite. Simplify editing operations. [Industrial Application Field] The present invention relates to a method for editing tabular data, and in particular, data in a range specified by a row, column, or cell of a table can be edited in any other row, column, or cell. This invention relates to an editing control method for moving (including copying) to a specified area. To move data when editing tabular data,
There are two types of movement: shift-type movement, which shifts the destination data later and inserts the source data, and overwrite-type movement, which rewrites the destination data with the source data.
It is necessary to distinguish between each and control editing. [Prior Art] FIGS. 3 and 4 show examples of moving editing of tabular data. Figure 3 is an example of shift-type movement editing of data by specifying rows. Data in rows 01 and 02 in the table in Figure A is selected as the source data, and row 04 is specified as the destination. When you instruct to move the file, it will be edited as shown in Figure b. Figure 4 is an example of overwriting type movement editing by specifying cells, and the four cells at the intersection of rows 01 and 02 of the table in Figure A, and the blood type and address columns are the source of the movement.

【table】 Select as data and correspond to rows 03 and 04

[Problem that the invention seeks to solve]

In the conventional editing control method for data movement, it is necessary to select a movement command and then select whether the data movement type is overwrite or shift.In addition to specifying the source and destination of the movement data, There was a problem that the amount of operations was large and it was not efficient. [Means for Solving the Problems] The present invention provides that the operation of specifying a row or column in a table and moving the entire data to another location is generally performed to change the arrangement of the table; Operations that involve rearranging data by inserting the source data into the destination and shifting rows or columns, and operations that specify one or more cells in a table and move that data to another location are: Focusing on the fact that this is generally done to copy the data, and the data at the destination is rewritten, it aims to simplify the operation by internally identifying the two. It identifies whether it is specified by a column or a cell, and automatically performs control to distinguish between shift-type movement of rows or columns, or overwrite-type movement. To this end, the configuration of the tabular data editing control method of the present invention is such that the tabular data editing processing method uses commands to specify rows and columns or cells of a table and edits the data. When instructed, check if the data movement area is specified as a line or not.
An area identification unit 6 identifies whether a column is specified or a cell is specified, and whether the data movement area specification format by the command identified by the area identification unit 6 is row specification or column specification. , or a cell specification, a movement method selection unit 9 that selects a corresponding movement method among row shift type movement, column shift type movement, and overwrite type movement, and the movement method selection section 9; It is activated selectively depending on whether the movement method selected by section 9 is row shift type movement, column shift type movement, or overwrite type movement, and the row shift type and column shift type are respectively activated. and a movement editing section 8 having a row shift type movement control section 10, a column shift type movement control section 11, and an overwrite type movement control section 12 that control data movement of the corresponding type among the types and overwrite types, If the movement data area is specified as a row, it will be moved by row, if it is specified by column, it will be moved by column, and if it is specified as a cell, it will be overwritten. It is characterized by this. FIG. 1 shows the basic configuration of the present invention. In FIG. 1, 1 is a processing device. 2 is a display device such as a CRT, on which data such as a table to be processed is displayed. Reference numeral 3 denotes an input device such as a keyboard or a mouse, which is used for inputting commands, specifying source data on a table and destination. 4 is a data storage unit that stores table data and the like. 5 is a display output section. Reference numeral 6 denotes an area identification unit that identifies the movement source and movement destination areas designated by the user with a cursor or the like by row, column, or cell. 7 is a command analysis unit that identifies input movement commands and the like. Reference numeral 8 denotes a movement editing section which particularly performs movement editing processing among editing processing, and is activated by a movement command. 9 is a movement method selection section, which selects row shift type movement when the source data is specified as a row, column shift type movement when the column is specified, and overwrite type movement when the cell is specified. Select and direct its control. Reference numeral 10 denotes a row shifting type movement control unit, which inserts the specified row of movement source data into the movement destination row and controls to shift the subsequent row downward. Reference numeral 11 denotes a column shift type movement control unit, which inserts the column-designated movement source data into the movement destination column and controls to shift the subsequent column to the right. Reference numeral 12 denotes an overwrite type movement control unit, which performs control to overwrite the movement source data designated by the cell onto the movement destination cell. [Operation] In FIG. 1, table data to be edited is read out from the data storage section 4 and displayed on the display device 2 via the display output section 5. First, when the user indicates the range of the source data using, for example, a cursor, the area identification unit 6 identifies the range of the source data by row, column, cell, etc. The movement command is input by the user, for example, by key input from the input device 3 or by displaying a command list on the screen and selecting it with a cursor. The input movement command is processed by the command analysis section 7.
The mobile editing section 8 is activated. The migration source data specified here is temporarily removed from the table data in the data storage unit 4 and stored in the save area. The movement method selection unit 9 identifies whether the range of the identified movement source data is specified by row, column, or cell, and activates the corresponding type of movement control unit. For example, if a line is specified, the line shift type movement control unit 10 is activated. Next, when the user specifies a destination area for the data, the area identification unit 6 identifies the area by row, column, cell, etc. As a result, the movement control unit of the type activated earlier,
For example, the row shifting type movement control unit 10 performs control to insert the evacuated movement source data into a designated movement destination. In this way, the user can easily move and edit any data in the table without being aware of the type of data to be moved. [Embodiment] FIG. 2 shows a flowchart of an editing control system for data movement according to an embodiment of the present invention. : Specify the area to move from on the table to be edited displayed on the screen. Whether specified by row, column, or cell, and location information are stored. : Select and submit a movement command on the screen. : Determine whether the movement source is specified as row/column or cell. : In case of row/column specification, further determine whether it is row or column specification. : When specifying a row, delete (save) the source row data and move the rows below to the top. ′: When specifying a column, delete (save) the source column data and shift the right column to the left. : When specifying a cell, delete (evacuate) the cell data at the source. : Specify the area to move to. : Determine whether the specification method is row/column specification or cell specification. : In case of row/column specification, further determine whether it is row or column specification. : When specifying a row, insert the source data into the destination row and shift the lower row down. ′: When specifying a column, insert in the destination column and shift the right column to the right. : When specifying a cell, overwrite the destination cell. Note that if the movement is by copying, the original data is not deleted, so the following steps are omitted. [Effects of the Invention] According to the present invention, moving and editing tabular data requires only specifying the move source and destination areas and inputting a move (or copy) command, which is more efficient than conventional methods. simplifies operation,
Processing efficiency can be significantly improved.

[Brief explanation of the drawing]

Fig. 1 is a basic configuration diagram of the present invention, Fig. 2 is a flow diagram of one embodiment of the invention, Fig. 3 is an explanatory diagram showing an example of slide-in type movement editing, and Fig. 4 is an overwrite type movement editing. An explanatory diagram showing an example, FIG. 5 is a flow diagram of a conventional method. In FIG. 1, 1...processing device, 2...display device,
3...Input device, 4...Data storage section, 6...Area identification section, 7...Command analysis section, 8...Movement editing section, 9...Movement method selection section.

Claims (1)

[Claims] 1. In a method for editing tabular data in which data is edited by specifying rows and columns or cells of a table using a command, when data movement is instructed by the above command, the data movement Is the area specified by line?
An area identification unit 6 identifies whether a column is specified or a cell is specified, and whether the data movement area specification format by the command identified by the area identification unit 6 is row specification or column specification. , or a cell specification, a movement method selection section 9 that selects a corresponding movement method among row shift type movement, column shift type movement, and writing type movement, respectively, and the movement method. It is activated selectively depending on whether the movement method selected by the selection unit 9 is a row shift type movement, a column shift type movement, or an overwrite type movement. It is provided with a movement editing section 8 having a row shifting type movement control section 10, a column shifting type movement control section 11, and an overwriting type movement control section 12, which perform data movement control of corresponding types among the shifting type and the overwriting type. , If the movement data area is specified as a row, it will be moved by a row, if a column is specified, it will be moved by a column, and if a cell is specified, it will be overwritten. A tabular data editing method characterized by: