JPH02224175A - Ruled line inserting processing system for table type data - Google Patents

Abstract

PURPOSE:To simplify the insertion and addition of ruled lines by automatically and optionally inserting and drawing vertical or horizontal ruled lines between lines or rows additionally to table type data consisting of the number of rows optionally set up by a conversational format, item names, etc., and optionally formed by the conversational format. CONSTITUTION:A data processor is constituted of an input part 1, an input data analyzing part 2, a command control part 3, a menu part 4, a command group 5, a menu screen control part 6, a display part 7, a printer 8, an external storage device 9, and a data transfer part 10. In the constitution, vertical or horizontal ruled lines are automatically and optionally inserted/down between lines or rows additionally to the table type data consisting of the number of rows optionally set up by the conversational format and optional formed by the conversational format. Consequently, the insertion and addition of ruled lines allowing the insertion and addition of data can be simply executed.

Description

[Detailed description of the invention]

(Industrial application field) In a data processing device that uses an interactive method between a computer and a human, especially when drawing vertical and horizontal lines freely on tabular data created by a computer using any 7-ormat format, it is used to draw ruled lines. This invention relates to tabular data processing that can automatically insert data between columns or rows without erasing it. (Prior art and problems) A simple language that allows users to create tables, edit table data, calculate table data, etc. in an interactive manner without having to acquire specialized computer programming skills by simply inputting symbols, etc. is becoming popular. With the spread of such simple languages, the number of people who use computers, especially personal computers, has also increased, and the current situation is that they are used in various fields.For example, schedule management for business use, patent business management , aggregation and reports of performance management for the next business, inventory management, management of adult wtS, etc. have come to be processed and submitted by computers.When aggregating and reporting these tabular data,
Lines may be drawn on tabular data. Data may be inserted or added to the tabular data that has already been ruled, and 'Ij# lines may also be drawn at the inserted or added locations. In such a case, insert or add data by inserting or adding a row or column, specifying the row number or column number along with the row or column to be inserted or added, and displaying the place to draw borders on the screen. There was the inconvenience of having to specify messages sequentially from the keyboard in an interactive manner. In the past, there were cases in which the insertion of ruled lines and the data on additional points were erased due to an operational error. As described above, in the past, the work of adding ruled lines when inserting and adding data to already created tabular data was complicated, and there was a problem that data could be erased due to operational errors. (Summary of the Invention) The present invention solves such conventional problems, and facilitates the insertion and addition of ruled lines associated with the insertion and addition of data to tabular data created interactively on a computer. (1) Create and edit tables in any format in an interactive manner based on instructions displayed on a computer display screen. In a possible data processing method, an input means such as a keyboard and a mouse;
an input data analysis means for analyzing and processing commands input from the input means and selection items of a menu to be displayed on the screen in place of the command input; a menu group for storing menu data to be displayed on the display section; means for controlling menu data from the menu group by command analysis processing by an input data analysis means, and means for displaying menu data stored in the menu group controlled by the control means. The feature is that vertical or horizontal ruled lines can be automatically inserted and drawn at the II of a row or column at a later time for tabular data created in an interactive format with any number of column digits, item names, etc. shall be. (2)
The menu data is characterized in that it consists of a command selection pull-down menu that substitutes for processing command input from the input means, a selection item pull-down menu that is displayed hierarchically, and a help menu that explains command functions and specified operations. . Furthermore, (3) @help menu is
The commands or command selection pull-down menus that are input manually from the input means and the selection item pull-down menus that are hierarchically displayed are sequentially displayed in accordance with the execution status of those commands and the contents of the selection items. ( Embodiment) 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 screen according to the present invention. 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 entry section, 16 is a manual entry section, 17 is a tabular data display section, 18 is a pull-down menu, and 19 is a help 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 a command group via the command control unit 3. Instructs to call the command in step 5. 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 g3 searches and controls a command corresponding to the menu data selected from the menu part 4 by the input data analysis unit 2 based on the analysis instruction from the command group 5, executes the function of the command, and also executes the function of the command. Controls the operation up to displaying the menu bar selected in step 4 on the display unit 7 via the menu screen control wS6. Menu part 4 is the menu bar pull-down menu,
Selection item pull-down menu Help menu Knee 7
-Menu Calculator Menu F() This is a memory that stores items to be displayed on the display screen 4, such as a menu. The command group 5 is a memory that stores commands that control execution, and is divided into "common command group,""input command group,""line editing command group,""column editing command group,""table editing command group," and "table editing command group" based on the function of the command. ``engi meter command group''
"Search classification command group", "Display command group", "Management command group", "Setting command group", "Transfer communication command group" [
It is classified into ``Print graph command group'' [Data conversion tips 2nd group], etc. (see ``Appendix'' for the contents of the command group). Processing of tabular data is executed based on these commands. The menu screen control section 6 controls the display section 7, controls the display by executing the commands of the command group 5 selected by the command control section m 3, and controls the display of menu data in the menu part 4 on the display g7. The display unit 7 is a display device such as a liquid crystal, plasma or other CRT, and the screen can be displayed in a split screen manner, and also displays a menu bar part 8 which is the contents of the system menu of the menu part 4, a scale part 9,
A window number section 10, a line number section 11, a message input section 12) an input line section 13, and a tabular data display g14 are displayed, as well as a pull-down menu window 16 and a help menu window 17. Furthermore, menu data such as an error menu, calculator menu, title menu, etc. stored in the menu part 4 is displayed. The printer 8 is a printer that prints the execution processing result of the command selected by the command control 81S3. The storage unit 9 is an external storage device that stores tabular data whose processing is controlled by executing commands in a hierarchical manner such as pages, panes, and cabinets. 5IO (serial 7 input/output) 10 is a processing unit for transferring tabular data to and from an external device through command execution processing. The menu bar part 11 is a display area on the screen that categorizes the processing functions of the computer into top categories. By moving the arrow keys, the cursor moves on the display screen, and the menu item at the corresponding location of the cursor is displayed in reverse video. 0 When the highlighted item on the menu bar is designated and the execution key is pressed, a pull-down menu with contents corresponding to the highlighted item is displayed on the screen, and at the same time a help menu is also displayed. 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, and the display screen displays tabular data input from the input section 1 and controlled and processed by the input data analysis section 2 and command control section 3 as is. The main screen and tabular data of the main screen may be temporarily transferred to memory and saved, and a sub screen may be displayed. In this case, this is an area for identifying whether the currently displayed screen is the "main screen" or the "sub screen." Further, since the display screen according to the present invention can be divided into four screens, it becomes easy to identify whether displayed data is a main screen or a 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 heard in 1 means the main screen, and the window number enclosed in parentheses means the sub screen. Furthermore, if the identification notation cannot be used to distinguish between the two screens, both screens are displayed with different identification notations 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 that displays commands in an interactive format from the input section 1 or command selection in a pull-down menu from a single mouse click, and operation instructions for processing selected items, such as [Please enter a command]. (also called prompt area). Message batting section 15
When executing a command, the system ignores selection items or operation instructions, and data processing can be executed interactively by inputting commands from the keyboard in response to this message. The input line section 16 is an area on the screen that temporarily displays contents input from the keyboard according to instructions from the Messeno typing section 15. When the operator confirms the contents displayed in the input line section 16 and presses the execution key, the contents are sent to the desired tabular data (also called "cell") and displayed. In response to instructions from the message input section 15, commands, letters, numbers, etc. are input from the keyboard. When the input of one character, etc. is completed and the execution key is pressed, the entered content is entered. Since processing can be executed in combination with selection of commands listed in the pull-down menu window, commands and the like can be input directly into the input line section 16 and executed. The tabular data display unit 17 has M rows and N columns as 1 base 7, and displays the data on the screen page by page. If the data consists of multiple pages, it is possible to organize and save the data as a buying and expand the data processing unit to a buying. Data processing using commands can process multiple pages. That is, adding or deleting items in tabular data! &! When performing collection and processing, 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 window 19 are displayed together with tabular data.Also, although not shown, an error window, a calculator window, a cabinet window, and a title finder for Bingu are also displayed as windows. displayed individually or in layers. When the message "Please input command" is displayed on the message input unit 15, a function on the menu bar can be selected. Menu bar functions can be highlighted using the arrow keys (
(reverse display) and press the execution key to execute the selection. If you move the highlighted image to the desired rocky shore 118 and press the execution key, a pull-down menu will be displayed. When selecting a function, press the execution key to execute the selection. If you press the left or right arrow key while the pull-down menu is displayed, the pull-down menu for the specified force will be displayed.
For example, in the case of "→", the pull-down menu of the menu bar of 1111 fillfl is displayed.
This is an area for displaying each function group corresponding to the top desired processing function displayed in 1. The pull-down menu window 18 displays functions for controlling the computer classified into a higher-level function group and a lower-level function group. Each function displayed in the pull-down menu window 18 is executed by moving the arrow keys to highlight the item, appropriately selecting the desired location, and pressing the execution key. The help window 19 is an area that explains each R function of the upper and lower function groups displayed on the menu bar part 11 and the pull-down menu window 18. The operator can operate the system by referring to the help menu displayed on the display lf screen without referring to the manual. There are 41 menus displayed on menu bar part 11! [l
Q, Menu (1), Menu (2), /N21 (3)
, consisting of menu (4). Menu (1) is [Commonly used 1]
, [Input], E row m result], E column edit], and menu (2) consists of [Table 11, [Calculation total 1], [Search minute [1,
[Consists of Display 1, Menu (3) consists of [Management 1,

[Consists of Settings 1, [Transfer Communication], and [Print Graph], Menu (4) is [Data Exchange],

It is classified into each function of [Obushi 1]. A pull-down menu is displayed for each function classified in each menu bar. That is,
Each function of the menu bar (1) [Common 1 [Input JE Row Edit] [Column Edit 1] displays individual pull-down menus (see "Appendix"), and further displays a lower-level pull-down menu window 18. Menu bar (1)
A pull-down menu listing further selection items is displayed for each of the functions (2), (3), and (4). The tabular data on the computer is processed by interactively selecting the selection items displayed in this pull-down menu window 18. A help menu window 19 is displayed that provides explanations and operations for each of the functions listed in the menu bar part 11 and the pull-down menu window 18. When processing a computer interactively and you become confused about the operation, explanations or operation guides for functions corresponding to the highlighted display position of the menu or command execution status are displayed in the help menu window 19. Operation becomes easier. Detailed explanation of the present invention 0 The present invention provides a method for automatically drawing ruled lines between columns or rows without erasing the entered data when vertical or horizontal ruled lines are drawn later on tabular data that has already been created. It is characterized by inserting and drawing a ruled line.The operation procedure for drawing a ruled line is executed based on the process displayed on the menu bar and pull-down menu. ■Use the arrow keys to highlight the menu bar part 11. Change to “Menu 2.” ■Use the arrow keys to highlight menu bar part 11 and change it to “Table 11.”
Move to 4 and press the execution key. ■Confirm that the pull-down menu for "Table Edit" is displayed, and confirm that "DRL!mJ" in the pull-down menu is highlighted, and press the execution key. ■The display of window number g13 is displayed as "DRLJ". At the same time, pull-down menus for W and R are displayed, and "All", "Delete all", "Horizontal line", "Delete horizontal line", and "Delete vertical line" are displayed on the pull-down menu window section 18 and the message input section 15. ■Use the arrow keys to highlight the desired location and press the execution key. As an example, a case where vertical lines are drawn on all the lines will be explained. Highlight the vertical line and press the Enter key. ■ In the Metsusafe batting section 15, "What is the target column? (Displayed as the N specified time." If it is a specific column, "column number". If there are multiple consecutive columns, "column number 1 column number". Any multiple columns. , "column number/column number", for continuous and arbitrary column combinations, [column number 1 column number/column number], for the last column of the table, ITJ, for after the last column of the table Input fNJ, rAJ in all cases from the keyboard, and press the execution key.In the case of the operation of drawing ruled lines from the above-mentioned ■ to ■ to the tabular data in the present invention, select
The help menu window 19 is selected in conjunction with the menu selection in the Purgran menu window 18.
Data processing in an interactive format can be made even easier through explanations and other explanations. (Effects of the Invention) Since the present invention has the above-described configuration, it is possible to easily insert and add ruled lines in tabular data in an interactive manner.

[Brief explanation of the drawing]

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 11
...Menu bar H12...Scale section 13...
Window number section 14... Line number section 15... Message line M1 16... Input section 17... Tabular data display section 18... Pull-down menu window 19... Help menu window Patent publication order People Thor and Co., Ltd.

Claims (3)

[Claims] (1) In a data processing method that allows table creation and editing in any format in an interactive manner based on instructions displayed on both sides of the computer display, input means such as a keyboard and mouse, and commands input from the input means and input data analysis means for analyzing and processing menu selections to be displayed on the screen in place of the command input; a menu group for storing menu data to be displayed on the display section; means for controlling menu data from the menu group through processing; and means for displaying menu data stored in the menu group controlled by the control means; Insertion of ruled lines in tabular data, which is characterized in that vertical or horizontal ruled lines are automatically inserted and drawn between rows or columns at a later time in tabular data arbitrarily created in an interactive format consisting of, etc. Processing method. (2) The menu data described in claim 1 includes a command selection pull-down menu that substitutes for processing command input from an input means, a selection item pull-down menu that is hierarchically displayed, and command functions and specifying operations. A method for inserting ruled lines in tabular data, characterized by a help menu that provides explanations. (3) The help menu in claim 3 corresponds to the commands input from the input means or the command selection pull-down menu and the execution status of those commands and the contents of the selection items in the selection item pull-down menu displayed hierarchically. A processing method for inserting ruled lines in tabular data, which is characterized by sequentially displaying ruled lines.