JPH0568736B2 - - Google Patents

Description

[Detailed Description of the Invention] [Summary] Conventionally, in a data processing system having a calculation processing or procedure repetition processing function within a specified range, a user specifies a calculation range or a repetition range by moving a cursor. but the end point of the range is a specific character (including borders)
By specifying the end point character when the end point is specified, the end point character is searched and the target range is automatically determined, improving the operability of range specification.

[Industrial Field of Application] The present invention relates to a data processing system such as a word processor having a calculation function, and is capable of specifying the end point of a total range in a total function, specifying the end point of a calculation range in a spreadsheet, and specifying detailed procedures at the time of procedure registration. This invention relates to a calculation/repetition range automatic search processing method that allows easy specification of the end point of a repeat range.

With the spread of word processors, there is a demand for advanced processing functions, and it is desired to be able to perform total calculations, spreadsheet calculations, etc. as quickly and as easily as possible.

[Conventional technology]

In a word processor or the like, characters, numbers, ruled lines, etc. are entered by moving the cursor on the display screen. There are devices that allow total calculations and spreadsheets to be performed on the array of numerical values entered in this way. In addition, there are systems that allow calculation procedures to be registered, and among them, detailed procedures can be repeated by specifying a range or number of times.

When specifying a range for such total calculations, spreadsheet calculations, or procedure repetitions, it is necessary to specify the range to be processed, but according to the conventional method, the cursor is first placed at the beginning of the specified range. After selecting a function, the user moves the cursor vertically or horizontally one character at a time using the cursor keys, and specifies the end point of the range by the position of the cursor.

For example, when calculating a total, when the user presses the total key while in calculation mode, a ``total~'' guide is displayed at the bottom of the screen, and the user moves the cursor to specify the range for which the user wants to calculate the total. In addition, when using a spreadsheet, if you press the spreadsheet key while in calculation mode, a spreadsheet guide will be displayed at the bottom of the screen, and when the type of spreadsheet is selected, you will be able to specify the range of the spreadsheet and use it. The person specifies the range by moving the cursor using the cursor keys.

In addition, when specifying a repeat range when registering a procedure, after executing one sub-step, the user selects range specification instead of the number of times in the repeat specification, and moves the cursor to specify the range in which the sub-step is to be repeated. .

[Problem that the invention seeks to solve]

In the conventional total function, spreadsheet function range specification or step repeat range specification, when specifying a range, the range is specified by moving the cursor, so the end point of the range is stuck and the user is confused. However, the user had to specify the range by moving the cursor each time, which caused the problem of cumbersome operation.

In particular, if the calculation/repetition range is small, you can specify the range relatively quickly, but if the range is large and its end point is outside the display screen, the screen may There is also the problem that scrolling occurs and it takes time for a human to check the current cursor position.

The present invention aims to solve the above-mentioned problems and provides a means for easily and quickly specifying a calculation/repetition range when the characters indicating the end point of the range are displayed. .

[Means for solving problems]

FIG. 1 shows an example of the basic configuration of the present invention.

In FIG. 1, 10 is a processing unit consisting of a CPU and memory, 11 is a display, 12
13 is a keyboard, 14 is an external storage device such as a floppy disk, 15 is a range specification input processing unit, 16 is a search processing unit, 17 is a search direction determination unit that checks the search direction, 18 is a cursor moving part for moving the cursor; 19 is a character comparison part for comparing the search character with the character at the cursor position; 20 is a text buffer in which a character code corresponding to the display on the display screen is stored; 21 is a designated character code. 22 represents a spreadsheet processing unit that performs spreadsheet calculations for a specified range; and 23 represents a procedure repetition registration processing unit that registers procedure repetition information for the specified range.

The range specification input processing unit 15 performs a process of inputting characters or ruled line information indicating the end point of a range to be subjected to calculation processing such as total calculation or spreadsheet calculation or procedure repetition processing.

The search processing unit 16 searches for the characters or ruled lines input by the range specification input processing unit 15 on the text buffer 20 in which codes corresponding to the display on the display screen are stored, and determines the position of the searched characters. This process determines the range to be subjected to calculation processing or procedure repetition processing as the end point of the specified range. In the search processing unit 16, the search direction determination unit 17 determines in which direction, such as up and down or left and right, the end point of the specified range is located. The cursor moving unit 18 automatically advances the cursor position when searching for characters.
The character comparison unit 19 compares the character at the advanced cursor position with the specified character (including ruled lines). When the characters match, search processing unit 1
6 recognizes that position as the end point of the range, and the determined range is processed by, for example, the total calculation processing unit 21, the spreadsheet processing unit 22, the procedure repetition registration processing unit 23, etc. by inputting a subsequent execution key. Notify.

The keyboard 13 includes function keys for selecting each processing function by the total calculation processing section 21, spreadsheet processing section 22, procedure repetition registration processing section 23, etc., as well as function keys for specifying character search in range specification. For example, a calculation search key is provided. By pressing this calculation search key, the range specification input processing unit 15
is starting to be started.

[Effect]

The present invention focuses on the fact that a specific character or ruled line pattern that is different from vertical is generally used at the last position of a total range, a spreadsheet range, a procedure repetition range, etc., and by inputting that character or ruled line. , which allows you to specify the end point of a range without moving the cursor.

When a calculation search key is input from the keyboard 13, the range specification input processing unit 15 inputs information such as search characters (ruled lines) and search direction to the keyboard 13.
3 and notifies the search processing unit 16. The search processing section 16 uses the cursor moving section 18 to automatically move the cursor according to the determination result of the search direction determining section 17, and the character comparison section 19 compares the search characters. This automatically searches for the end week of the range.

〔Example〕

FIG. 2 is an explanatory diagram of a search range according to an embodiment of the present invention, FIG. 3 is an explanatory diagram of spreadsheet range specification according to an embodiment of the present invention, and FIG. 4 is a repeating range according to an embodiment of the present invention. 5 is a block diagram of an embodiment of the present invention, FIG. 6 is a diagram illustrating range designation input processing in an embodiment of the present invention, and FIG. 7 is a diagram illustrating search processing in an embodiment of the present invention. , FIG. 8 shows a display example according to an embodiment of the present invention.

For example, when calculating a total, it is possible to specify the total for the left and right horizontal directions, the vertical total for the bottom left, or the total up to the end of the sentence.

As shown in Figure 2A, the display screen 3
0, if you want to perform horizontal totals from the current cursor 12 position to the end point E, specify "‖" at the end point E as the search character, and set the search direction to "→", which indicates the right direction. shall be. This results in
The shaded range in the diagram can be specified as the range for total calculation without the user having to move the cursor.

If you want to perform a total in the vertical direction, specify the ruled line "=" at the end point E, as shown in Figure 2B.
The search direction is set to "↓" indicating downward. As a result, a character search is performed in the direction indicated by the dotted arrow, the end point E is detected, and the diagonally shaded area from the current position of the cursor 12 to the end point E becomes the range for total calculation.

It is also possible to instruct that all numerical values appearing from the current cursor 12 position to the end of the sentence are to be summed. In this case, as shown in FIG. 〓'' and specify ``to the end of the sentence'' as the search direction. As a result, a character search is performed in the direction indicated by the dotted arrow, and finally "〓" is detected, and the entire range of the diagonally shaded part shown in the figure is determined to be the range for total calculation.

In the case of spreadsheet calculation, for example, as shown in FIG. 3, the cursor 12 is placed at the beginning of the table and the spreadsheet key is pressed. Next, select the vertical/horizontal calculation, for example, and specify the range you want to calculate. In this case, the end point E may be specified by moving the cursor 12 using the cursor keys as in the past, but in the present invention, the end point E can be specified without moving the cursor 12 as follows. I can do it.

After selecting the vertical and horizontal calculation, press the calculation search key.
Then, focusing on the character "〓" at the end point E, "〓" is designated as the search character. This allows the end point E
The search up to this point is performed, the cursor 12 is automatically positioned at the end point E, and the hatched area in the figure becomes the target of the spreadsheet calculation.

Next, the designation of the repetition range when registering the calculation procedure will be explained with reference to FIG.

Press the repeat key when registering the calculation procedure. after that,
Execute the single operation you want to repeat. With this, for example, the cursor becomes cursor 1
2a to the cursor 12b. If you press the repeat key again, "Repeat specification 1 (1: range specification, 2: number of times specification)"
A guide will be displayed. Therefore, select the range designation "1" and designate the end point E of the repeating range.
At this time, if the character (including the ruled line) at the end point E has been clarified, the character is input after pressing the calculation search key to specify the range. As a result, the cursor is automatically moved to the end point E, and the repetition range is determined.

FIG. 5 shows an example in which the present invention is applied to a word processor. In FIG. 5, the same reference numerals as in FIG. 1 correspond to those shown in FIG. 40
41 represents an input control section, 41 represents a short-hand kanji conversion section, 42 represents a document editing processing section, 43 represents a display control section, 44 represents a cursor control section, and 45 represents a calculation processing section.

When the reading of a kanji etc. is input from the keyboard 13 and a conversion key is input, the kana-kanji conversion section 4
1, a kana-kanji conversion process is performed using a predetermined dictionary, and the conversion result is notified to the document editing processing section 42. The document editing processing unit 42 displays the results on the display 11 via the display control unit 43 to create a document, and also edits related information in response to pressing function keys such as insert, delete, copy, and move. Performs document data editing processing. Cursor control section 44
controls the movement of the cursor in response to cursor keystrokes.

When a calculation key is input from the keyboard 13,
The calculation processing unit 45 is activated and enters calculation mode.
Here, the range specification input processing section 1 explained in FIG.
5. The search processing unit 16 determines a calculation/repetition range, and performs total processing, spreadsheet processing, procedure registration/execution processing, etc. for the specified range. The calculation mode is canceled by pressing the end key or the calculation key.

The processing of the range designation input processing section 15 in the total calculation is performed, for example, as shown in FIG. 6. ~ in the following description refers to the process shown in FIG.
corresponds to

When the calculation search key is pressed, the operation guide is displayed and the search direction is input.

Next, input the search character type, that is, whether to search for regular characters or ruled lines.

Determine whether the search character type is "ruled line" or "character". If it is a "character", control is transferred to processing.

If the search type is "ruled line", enter the ruled line.

Next, enter the type of border, such as dotted line, regular line, thick line, double line, etc. After that, control is transferred to processing.

If the search character type is "character", enter the character. In addition, in this embodiment, the so-called Kuten input is possible, taking into account the designation of kanji characters.

Next, it is determined whether or not a search character has been added. When the calculation search key is pressed again, control is returned to the process and the process is repeated in the same way in order to add search characters. In this embodiment, it is thereby possible to specify the end point of a specified range for a plurality of search characters. If any one of the search characters appears,
The position is set as the end point of the processing target range.

Specify the search direction and search characters and call the search processing section.

When the search process is completed, it is determined whether the search was successful, that is, whether the search character was found. If the search is successful, cancel the search function.

If the search fails, return the cursor to the search start position, cancel the search function, and return to the state before entering the first calculation search key.

In each of the above processes, when the end key is input, the search function is canceled in that state as shown by the dotted line in the figure. Furthermore, when the cancel key is pressed again, control is returned to the previous process in principle.

The search process called in the process shown in FIG. 6 is performed, for example, as shown in FIG. ~ in the following description refers to the process shown in FIG.
corresponds to

First, the search direction is determined, and if the direction is left or right, the following steps are executed. If the direction is upward or downward, execute the following steps. If the direction toward the end of the sentence is specified, the following processing is executed.

When the search direction is left/right, one line of text on the line where the cursor is located on the display screen is read.

Next, move the cursor one digit to the left/right of the search direction.

Determine whether the cursor is at the left or right end of a line. If the left or right end is reached, the search is deemed unsuccessful and control is returned to the caller.

Compares the character at the cursor position with the specified search character.

If the character at the cursor position is the same as the search character, the search is considered successful and control is returned to the caller. If they are not the same, return control to processing,
Repeat the search in the same way.

If the search direction is up/down, move the cursor one line up or down.

Reads one line of text at the cursor.

Determine whether the cursor is at the first line or the last line of the document. If the first line or the last line of the sentence is reached, the search is deemed unsuccessful and control is returned to the caller.

Compares the character at the cursor position with the specified search character.

If the character at the cursor position is the same as the search character, the search is considered successful and control is returned to the caller. If they are not the same, return control to processing,
Repeat the search in the same way.

If the search direction is toward the end of the sentence, one line of text on the line where the cursor is located is read.

Next, move the cursor one digit to the right.

Determine whether the cursor is at the end of the sentence.
If the end of the sentence is reached, the search is deemed unsuccessful and control is returned to the caller.

If the cursor is not at the end of the sentence, determine whether the line where the cursor is located has changed. If it is the same as before, skip the next process.

If the line changes, read one line of text from the new line where the cursor is.

Compares the character at the cursor position with the specified search character.

If the character at the cursor position is the same as the search character, the search is considered successful and control is returned to the caller. If they are not the same, return control to processing,
Repeat the search in the same way.

FIG. 8 shows an example of the display on the display screen 30 in the above process.

For example, assume that the total calculation function is used to calculate the total for a table as shown in FIG. 8A.
Press the calculation key to enter calculation mode and move cursor 1
When the total key is pressed at position 2, the guide "Total 10 ~" is displayed as shown in FIG. 8B. next,
Using the search function according to the present invention, when the calculation search key is pressed to specify the total range in the horizontal direction, an inquiry about the search direction is made as shown in FIG. 8C.

Here, since the range is in the right direction, select "1 (→)" and press the execution key, as shown in Figure 8D.
The search direction "→" and a guide for selecting characters to search are displayed. To set "‖" to the right of the number "45" in the table shown in Figure 8 A as the end point of the range, select "1 (ruled line)" as the search character and press the Enter key. As shown, a ruled line selection guide is displayed.

Here, the ruled line "1" indicating a vertical line is selected. As a result, a guide for selecting the type of ruled line is displayed as shown in FIG. Here, select "4" indicating a double line and press the execution key.

By inputting the ruled line type, as shown in Figure 8,
The search character "‖" is displayed, and a selection guide for starting the search/adding the search character is displayed. If you want to include other characters or ruled lines in the search, press the calculation search key again. Here, the search character only needs to be "‖", so just press the execute key.
As a result, the search state is entered as shown in FIG. Ru. Thereafter, the system waits for an execution key input to specify execution of the total calculation. When the execution key is pressed, the horizontal total from "10" on the left to "45" on the right is displayed as the calculation result, and the result is set at the input position of the subsequent specified key.

An example of specifying a range in the total calculation function has been described above, but the end point of the range can be specified using search characters in the same way when specifying a range in a spreadsheet or specifying a procedure repeat range.

〔Effect of the invention〕

As explained above, according to the present invention, when the user knows the end point of a specified range, the search function can be used to search the range without moving the cursor to that position using the cursor keys or the like. You can now directly specify the end point of the area and automatically move the cursor to that position to determine the range. Therefore, it is possible to specify a range quickly and easily.

[Brief explanation of the drawing]

FIG. 1 is an example of the basic configuration of the present invention, FIG. 2 is an explanatory diagram of a search range according to an embodiment of the present invention, FIG. 3 is an explanatory diagram of spreadsheet range specification according to an embodiment of the present invention, and FIG.
5 is a block diagram of an embodiment of the present invention; FIG. 6 is an explanatory diagram of range specification input processing in an embodiment of the present invention; FIG. 8 is an explanatory diagram of search processing in an embodiment of the present invention, and FIG. 8 shows an example of display according to the embodiment of the present invention. In the figure, 10 is a processing device, 11 is a display,
12 is a cursor, 13 is a keyboard, 14 is an external storage device, 15 is a range specification input processing section, 16 is a search processing section, 17 is a search direction determination section, 18 is a cursor movement section, 19 is a character comparison section, and 20 is text・
21 represents a total calculation processing section, 22 represents a spreadsheet processing section, and 23 represents a procedure repetition registration processing section.

Claims (1)

[Scope of Claims] 1. In a data processing system having a calculation processing or procedure repetition processing function within a specified range regarding the sequence of numerical values displayed on a display screen, the end point of the range to be subjected to the calculation processing or procedure repetition processing is A range designation input processing means 15 for inputting characters or ruled line information to be displayed, and searching the characters or ruled lines inputted by the range designation input processing means 15 on a buffer having information corresponding to the display on the display screen, and performing the above calculation process. Alternatively, a calculation/repetition range automatic search processing method characterized by comprising a search processing means 16 for determining a range to be subjected to procedure repetition processing.