JPH02288950A - Data processing system in table format data - Google Patents

Abstract

PURPOSE:To facilitate an operation by displaying a cursor underneath the last row of table format data generated by an interactive format, and adding data in row unit afterwards when entry omission is recognized or the input of the data is interrupted temporarily. CONSTITUTION:A table format data display part 17 comprises one page of M rows and N columns, and displays it on a screen in page unit. When a message (Input a command, please) is displayed on a message row part 15, the function of a menu bar 11 is selected. The function of the menu bar 11 is moved on reverse display with an arrow head key, and performs selection and execution by depressing an execution key. When the reverse display is moved to a desired function and the execution key is depressed, a pull-down menu 18 is displayed, and function selection is performed by performing the selection and execution by depressing the execution key. Also, when either right or left directional arrow head key is typed at a state where the pull-down menu 18 is displayed, an instructed side pull-down menu 18 is displayed. Thereby, it is possible to easily perform the addition and deletion of the data in the table format data with the interactive format.

Description

DETAILED DESCRIPTION OF THE INVENTION (Industry - Field of Application) The present invention relates to a data processing apparatus that uses an interactive system between a computer and a person, and particularly relates to the processing of tabular data created by a computer in an arbitrary format.

(Prior art and problems) It is possible to create tables interactively, without having to acquire specialized computer programming skills, by simply inputting commands and other marks etc. in an interactive manner according to the messages displayed on the screen. A simple method that can process table data synergy, table data calculations, etc. ',! , IF is attached to Azusa. With the spread of such simple languages, the number of people using computer special computers (personal computers) is also increasing, and the current situation is that they are being used in various fields. Aggregation and reports for file management, patent business management, sales performance management, inventory management, report card management, etc., are now processed and submitted by computers1. Copying, deleting, and adding tabular data. about,
Although it is possible to carry out actual processing through complicated processing, there is a problem in that it cannot be easily processed by displaying the Purgran menu or other messages displayed on the screen.

(Summary of the Invention) It is an object of the present invention to solve such conventional problems and provide a processing method that can easily copy, delete, add data, etc. in tabular data created in an interactive manner with a computer. , move the cursor to be displayed on the menu bar displayed on screen I-, highlight "Input" and press the execution key, then move the cursor to [Additional input-1 in the line displayed] and select " Highlight "Enter additional row" and press the execute key to display the cursor under the last row of the tabular data, and then enter the tabular data created on the screen.
If there is 't or - when data input is interrupted] - If there is a large knee, data is added line by line later.

(2) Move the cursor to highlight "Edit one line" on the menu bar displayed on the tabular data on the screen, and highlight "Insert row" on the next menu screen by moving the cursor. Then, move the cursor to highlight "Create Space Line" on the menu screen that appears, then highlight "Line Data Manually" on the menu screen that appears, and press the Run key. By pressing the button and inputting the row number to be inserted from the keyboard, data that has been left out can be inserted row by row into the table once created.

(3) Highlight "Edit one line" on the menu bar displayed on the screen and press the execution key, then highlight "Insert line" on the menu screen that appears, press the execution key, and press the execution key. The feature is that line data can be moved by inputting the line number of the desired movement destination. (4) In the case of consecutive or discontinuous rows in tabular data, if numbers are separated by commas ",", those numbers can be separated by multiple consecutive rows such as "first row number, last row number". A simplified data input processing method for tabular data, which is characterized in that it determines that there is a data file and performs processing such as data movement.

(5) Enter the numerical value of the human power data related to the present invention with a slash “/”
”, the numbers are separated into independent and discontinuous [
It is characterized in that the data is processed by determining that it is a line specification of ``line number/line number/...''.

(6) When the numerical values of the input data according to the present invention are separated by a mixture of commas "," and slashes "/", the data is processed by determining that these numerical values are continuous or discontinuous line designations. It is characterized by

(7) Move the cursor to "Edit Row" displayed on the menu bar displayed on the tabular data screen, highlight "Edit Row", and select "Copy Row" on the menu screen that appears next. is highlighted and the execution key is pressed, and by specifying the target line number to be copied and the copy destination line number from the keyboard, data with the same content is copied to another target line. (
8) A feature of the present invention is that multiple lines of data can be copied at once by specifying multiple lines from the keyboard to copy the tabular data. (9
) Move the cursor to "Edit Line" on the menu bar displayed on the screen to highlight "Edit Line", move the cursor to "Delete Line" on the menu screen that appears next, and select "Edit Line". If you highlight "Delete" and press the execution key, and then specify the line number to be deleted from the keyboard on the menu screen that appears, the menu screen will prompt you to confirm the deletion with "Yes" or "No." Characterize.

(Space below) (Example) Figure 1 is a block diagram showing the configuration of the present invention, Figure 2 is a diagram showing the configuration of the display screen according to the present invention, and Figure 3 is an example of the screen according to the present invention. FIG.

In the figure, 1 is an input section, 2 is an input data analysis section, 3 is a command control section, 4 is a part of a menu, 5 is a command group, 6 is a menu screen control section, 7 is a display section, 8 is a printer, and 9 is an external device A storage device, 10 a data transfer unit, 11 a part of a menu bar,
12 is a scale part, 13 is a window number part, 14 is a line number part,
15 is a message line section, 16 is an input line section, 17 is a tabular data display section, 18 is a pull-down menu, and 19 is a help menu window.

The input unit 1 is an input device such as a mouse or a keyboard.

The input data analysis section 2 analyzes the data input from the input section 1 to determine whether the input is from an arrow key or a mouse, or whether it is an input of a command name meaning an execution command. If the input is via a window menu displayed on the screen instead of inputting a command name from the input unit 1, it instructs the selection operation of menu data in the menu part 4, and inputs the command via the command control unit 3. Instructs the calling operation of group 5 commands. By operating the input unit 1, the cursor is moved in the pull-down menu to select a command or highlight the function of the selected item, and if it is an execution command, the command is searched from the command group 5 via the command control unit 3. .

The command control unit 3 searches the command group 5 for a command corresponding to the menu data selected from the b-menu part 4 based on the analysis instruction by the input data analysis unit 2, and executes the function of the command. It controls the operation until the menu display selected in the menu section 4 is displayed on the display section 7 via the menu table control section 6.

Menu part 4 includes menu bar, pull-down menu,
This memory stores items to be displayed on the display screen 4, such as a selection item pull-down menu, a help menu, an error menu, a calculator menu, and a title menu.

Command group; 3 is a memory that stores commands for controlling execution, and based on the substitute fm of command ``common command group'' input command group - old line editing command group'' ``column editing command group'' [table editing command Group Old - Calculation and aggregation command group'', ``Search classification command group Old - Display command group'', ``Administration command group'' [Setting command group Old transfer communication command group Old print graph command group Old - Data conversion command selection, etc. ( (Please refer to the attached table for the contents of the command group)
.

The menu screen control section 6 controls data for executing the commands of the command group 5 selected by the command control section 3 and displaying the menu data of the menu part 4 as a display section 7\menu screen.

Based on the search control command, control 12 the table data corresponding to the command with the search control command from the table group 5.
, displays the table data on the display screen 4.

The display unit 7 is a display device such as liquid crystal, plasma, or CRT (I), and the screen is capable of split-screen display, and
Menu part 4 system menu 1] /2v3 i2y% Menu bar part 11, scale part 12, window number part 13, line number part 14, message input part 15, input line part 16, tabular data display The section 17 is displayed, and a pull-down menu window 18 and a help menu window are also displayed. In addition, part of the menu 4
Menu data such as error menu, calculator menu, title menu, etc. stored in is displayed.

The printer 8 is a printer that prints the execution processing result of the command selected by the command control unit 3.

The storage unit 9 is an external storage device that stores tabular data whose processing is controlled by executing commands in a hierarchical manner like pages, bins, and cabinets.

SI○ (serial input/output) 10 is a processing unit for transferring tabular data to and from an external device through command execution processing.

Menu bar part 11 is a display area on the screen that categorizes the computer's processing functions according to your thoughts. By moving the arrow keys, the cursor moves on the display screen, and the menu item at the corresponding location of the cursor is highlighted. do. When the user specifies the highlighted item 1 on the menu bar and presses the execution key, a pull-down menu with contents corresponding to the highlighted item is displayed on the screen, and a help menu is also displayed at the same time.

The menu bars according to the present invention are classified into four types, and each menu bar is selected by using arrow keys and displayed on the screen.

The scale section 12 displays the title name, column number, and column number of the table to be displayed.
This is a display area on the screen that displays the number of column digits, item names, number of character digits, etc.

The window number section 13 is an area for identifying the screen displayed on the display screen. There are cases where the main screen to be displayed and the tabular data of the main screen are temporarily transferred to memory and saved, and then the sub screen is displayed. In this case, this is an area for identifying whether the currently displayed screen is the "main screen" or the "sub screen." Furthermore, since the display screen according to the present invention can be divided into four screens, it becomes easy to identify whether the displayed data is the main screen or the sub screen.

Normally, the tabular data on the sub-screen cannot be seen, but it can be seen by dividing the display screen using the screen splitting function. Assign a number to each divided screen. This number is called the window number. You can work while simultaneously displaying tabular data from different parts of the main screen or sub-screens.

In this case, commands can only process data on the table displayed on the main screen.

For this reason, the main screen is also called a work screen. The identification notation for the main screen and sub screen is [The window number surrounded by 1 means the main screen, and the window number surrounded by () means the →knob screen. !If it is not possible to tell them apart, distinguish between the two screens by displaying different identification marks and different frame designs.

The line number section 14 is an area on the screen that displays the line number of the table of tabular data, and is an area that identifies which line the tabular data called up on the screen is.

The message input section 15 is an area on the screen where commands and selection items in the pull-down menu 1 are displayed in response to commands from the input section 1 or with the mouse. etc. (also called prompt area). The message input unit 15 prompts for selection items or operation instructions when executing a command, and if a command or the like is input from the keyboard in response to the message, data processing is executed in an interactive manner.

The input line section 16 is an area on the screen-L in which contents entered manually from the keyboard according to instructions from the message input section 15 are temporarily displayed. When the operator confirms the contents displayed in the input line section 16 and presses the execution key, one of the desired tabular data (also called "cell") is sent and its contents are displayed.Message input section 15 In response to the instructions, input commands, characters, numbers '-f, etc. from the keyboard.After inputting characters, etc., press the execution key to enter the entered contents. Since processing can be executed in combination with selection of commands listed in the pull-down menu window 18, commands and the like can be input directly into the input line section 16 and executed.

The tabular data display section 17 has M rows and N columns as 1 page',
Display on the screen page by page. If the data consists of multiple pages, it is possible to organize and save the data as a pie and expand the data processing unit to a pie. Data processing η11 based on commands can process multiple vanes. That is, when performing editing and processing such as increasing or deleting tabular data items, data items across multiple pages can be increased or deleted by executing one command.

On the display screen, as shown in FIG. 3, a pull-down menu window 18 and a help menu window 19 are displayed along with tabular data, as well as an error window, a calculator window, a cabinet window, and a pain window (not shown). . When "Please input command" is displayed on the message input section 15, you can select a function on the menu bar. 1. Select and execute menu bar functions by moving the highlighted display (reverse display) using the arrow keys and pressing the execution key.

Move the highlighted display to the desired function and press the execution key to display a pull-down menu. When selecting a function, press the execution key to execute the selection. If you type the left or right arrow key while the pull-down menu is displayed, a pull-down menu with the specified force will appear. For example, [→1 i73] Currently, the menu bar pull-down menu of the functions on the right side is displayed.

The pull-down menu window 18 is part of the menu bar 1
This is an area for displaying each function group corresponding to the processing function of the thoughts displayed in 1. The pull-down menu window 18 displays functions for controlling the computer, classified into a group of higher-level functions and then a lower-level function group. To execute each function displayed in the pull-down menu window 18, move the blank key to highlight item 1, select the desired location, and press the execute key to execute the process.

The help menu window 19 is an area for explaining each function of the upper and lower function groups displayed on the menu bar section 11 and the pull-down menu window 18. The operator can operate by referring to the help menu displayed on the display screen without referring to the manual.

There are four types of menus displayed on the menu bar part 11: Menu (1), Menu (2), Menu (3),
Consists of menu (4). Menu (1) is “Commonly Used 1”
Input], L row edit], column edit], menu (2
) consists of L-Table Edit], "Calculation Total", "Search Classification", and "Display", and menu (3) consists of "Management", "Setting 1", "Transfer Communication".
``Print Graphs'' and the menu (4) is categorized into the respective functions of ``Data Exchange''``Options''. A pull-down menu is displayed for each function classified in each menu bar. That is, pull-down menus are displayed individually for each function [Common], [Input], [Row Edit], and [Column Edit 1] of the menu bar (1) (see "Appendix").

And furthermore, the lower pull-down menu window 1
8 is displayed, and a pull-down menu listing further selection items for each function of the menu bar (1), (2), (3), and (4) is displayed. The tabular data on the computer is processed by interactively selecting the selection items displayed in this pull-down menu window 18.

(The following is a blank space.) A help menu window 19 is displayed that provides explanations and operations for each of the functions listed in the menu bar portion 11 and the pull-down menu window 18. If you are unable to understand the operations when processing the computer interactively, explanations of functions or operation guides corresponding to the highlighted display position of the menu or command execution status are displayed in a single help menu window. becomes easier to operate.

(1) Next, each embodiment of the present invention will be described.

■When copying the data immediately above while inputting data.

Pressing the @execute key or @U execute key copies the data immediately above.

■When copying the data immediately below @Press the D execution key.

■When copying the data immediately to the left @Press the L execution key.

■When copying the data immediately to the right @Press the R execution key.

■To copy the data of the specified row number in the same column, press the @Row number execution key. For example, if you want to copy the data in the 15th row of the same column, enter l'@15J and press the "Execute" key.

■To copy multiple lines starting from the specified line in the same column, press the @N number of lines execution key. For example, if you want to copy data from the 5th row to the 10th row in the same column, use r@5. After inputting IOJ, press the execution key.

■To copy data at any position @Row number 1 Column number 9 Press the execution key. For example, to copy data in the 5th row and 3rd column, enter "@5f3" and then press the execution key.

(2) An example of adding row data in tabular data will be described. - Data is added when adding data row by row to tabular data that has already been created, when restarting input work that was interrupted, when adding data that was left out, etc. .

■Use the arrow keys to highlight the menu bar according to the present invention.
Go to "Input".

■Use the arrow keys to move the highlighted display to rM'r row additional input, and press the execution key.0 A cursor will be displayed below the last row of the table.

■Data can be added to the location where the cursor is displayed.

Data can be easily added by following the steps below.

(3) An example of how to insert data will be explained.

This is a case where the data that has been left out is inserted into a table that has been created at the position of row fit.

■ Use the arrow keys to highlight the menu bar according to the present invention.
゛Move to line edit-1.

■Use the arrow keys to move and check that "Insert LIR row" is highlighted, then press the execution key.

0 A cursor appears below the last row of the table.

■Make sure that the pull-down menu is set to Insert 1 line.

■ Move the arrow keys and confirm that "I-Space Line Creation" is highlighted.

■Move the arrow keys to confirm that "-Line data input" is highlighted, then press the execution key.

■The cursor moves before the row to be inserted, allowing you to insert data.

(4) An example of moving row data will be explained.

○) Use the arrow keys to move the highlighted display of the menu bar according to the present invention to "Line Edit-1" and press the execution key.

■ Move with the arrow keys, confirm that Insert rMR line -1 is highlighted, and press the execution key.

■ Specify the line you want to move 37 For example, if you want to move from line 21 to line 22, manually press "f21.22" on the keyboard.

■Specify the destination. For example, if you want to move to line 19 and line 11, enter "19" from the keyboard and the data will be moved instantly.

(5) A case where tabular data is simplified and manually input will be explained. Explaining the case of specifying continuous, discontinuous, and continuous and discontinuous lines at the same time 3゜
It is determined that there are a plurality of consecutive lines, such as the first line number and the last line number minus 1, and processing such as data movement is performed. For example, if you want to move the data from line 1 to line 14 in line 10 [10, 14j] manually.

■If input data numbers are separated by slashes "/", they can be separated into independent, non-consecutive [line number/line number/...
...Determines that 10 lines are specified and processes the data. For example, if you want to move the data on the 8th and 12th lines, enter 8/12j manually from the keyboard.

■ Enter the numerical value of the input data with a comma "l" and a slash "/"
If mu separated by a mixture of those numbers consecutively,
It is determined that the row specification is discontinuous and the data is processed ρ1! Do this. For example, if you want to move the data from line 7 ``1 and line 9 to line 11, enter ``7/9.IIJ'' from the keyboard.

(6) An example of copying rows of data in tabular data will be described. is almost the same within′,゛γ
When filling in ζ data, a multi-line butaf, (,
It is possible to make good copies.

■Use the arrows to -1 to move the highlighted display on the menu bar according to the present invention (r) to 1 line edit -1.

■ ICPR to highlight the pull-down menu using the arrow keys.
Move to ``Copy Row'' and press the Execute key ■Specify the line you want to copy. For example, if you want to copy lines 18 and 19 from line 16 (line 1), use the keyboard to manually copy lines 16.18/19J.

■Specify the copy destination. For example, to copy to line 22, enter l-22j from the keyboard.

(7) An example of erasing row data in tabular data will be described. This is a case where the data in the table can be easily deleted when the data is inputted incorrectly or when the data is no longer needed.

■Use the arrow keys to highlight the menu bar according to the present invention.
Go to "Edit Row".

■Use the arrow keys to highlight the pull-down menu 11)R
``Delete a line''・\Move and press the execution key ■Specify the line you want to delete. When you specify the row you want to delete, the specified 7 in the table
The selected line is highlighted, and the pull-down menu for ``Confirm deletion'' displays ``Yes-1'' or ``No,'' and ``Yes-1'' is displayed in reverse video. .

For example, to delete lines 22 to 24, [2
If you enter 2, 24J from the keyboard, the lines from 22nd to 24th in the table will be highlighted. ■If there is no mistake in the deletion, press the execution key, and if there is a mistake in the specification, use the arrow keys to select " Move the highlighted display to "No" and press the Enter key.

For example, to copy lines 16 to 18 and 19, enter rl 6,18/1.9J from the keyboard.

■Specify the copy destination. For example, to copy on the 22nd line, enter "22" from the keyboard.

■Make sure the pull-down menu is set to "Insert row."

■Move the arrow keys and confirm that "Create Space Line" is highlighted.

(Effects of the Invention) Since the present invention has the above-described configuration, it is possible to easily add, delete, move data, etc. in tabular data in an interactive manner.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of the present invention, FIG. 2 is a diagram showing the configuration of a display screen according to the present invention, and FIG. 3 is a diagram showing an embodiment of the display screen according to the present invention. 1... Input section 2... Input data analysis section 3...
Command control unit 4... Menu part 5... Command group 6... Menu screen control unit 7... Display unit 8... Printer 9... External storage device 10... Data transfer unit・Menu bar part 12 ・Scale part 13 ・・
・Window number section 14... Line number section 15... Messeno entry section 16... Input line section 17... Tabular data display section 18... One pull-down menu... Help menu window Patent Hatake Ganjin Sword Co., Ltd.

Claims (9)

[Claims] (1) In a data processing method that allows the creation and editing of tables in any format in an interactive manner based on instructions displayed on a computer display screen, data input from input means such as a keyboard or mouse, etc. an input analysis means for processing commands and menu selections to be displayed on the screen in place of the command input, and for analyzing data to be stored in the storage device; and a menu group for storing menu data to be displayed on the display unit; means for controlling menu data from the menu group by command analysis processing by the input data analysis means; and means for displaying menu data stored in the menu group controlled by the control means; Display the created tabular data on the menu bar displayed on the screen. Move the cursor to highlight "Input" and press the Enter key. Move the cursor to "Add row input" that is displayed next. If there are any omissions in the tabular data created on the screen, or A data processing method for tabular data that is characterized by adding data row by row after temporary data input is interrupted. (2) Move the cursor to highlight "Row Edit" on the menu bar displayed on the tabular data on the screen, and highlight "Insert Row" on the next menu screen by moving the cursor. Then, move the cursor to highlight "Create Space Line" on the menu screen that appears, then highlight "Input Line Data" on the menu screen that appears, and press the Enter key. A data processing method for tabular data, which is characterized in that data that has been left out is later inserted row by row into a table that has been created by pressing the button and inputting the row number to be inserted from the keyboard. (3) Highlight "Edit Line" on the menu bar that appears on the screen, press the execution key, then highlight "Insert Line" on the menu screen that appears, press the execution key, and press the execution key. A data processing method for tabular data, characterized in that row data can be moved by inputting a desired destination row number. (4) For consecutive or discontinuous rows in tabular data, if numbers are separated by a comma ",", those numbers can be separated into multiple consecutive rows, such as "first row number, last row number". A data processing method for tabular data, characterized in that processing such as data movement is performed by determining that (5) If the numerical values of input data in tabular data are separated by slashes "/", those numerical values are treated as independent and discontinuous row specifications of "line number/line number/..." and the data is A tabular data processing method characterized by processing. (6) If the numerical values of input data in tabular data are separated by a mixture of commas "," and slashes "/", these numerical values are treated as continuous or discontinuous row specifications and the data is processed. A tabular data processing method characterized by: (7) Move the cursor to "Edit Row" on the menu bar displayed on the tabular data screen, highlight "Edit Row", and highlight "Copy Row" on the menu screen that appears next. A data processing method for tabular data characterized in that data with the same content is copied to other target rows by pressing the execution key and specifying the target row number to be copied and the copy destination row number from the keyboard. (8) A data processing method for tabular data that is characterized by being able to copy multiple rows of data at once by specifying multiple rows of data to be copied from the keyboard using the keyboard. . (9) Move the cursor to "Edit Line" on the menu bar displayed on the screen to highlight "Edit Line", then move the cursor to "Delete Line" on the menu screen that will be displayed next. Highlight the corresponding "Delete line" and press the execution key, then specify the line number to be deleted from the keyboard on the menu screen that appears, and the menu screen will display "Yes" or "No" to confirm deletion. A data processing method for tabular data that is characterized by: