JPH08137857A - Document processor - Google Patents

Abstract

PURPOSE: To provide the document processor which can display an ordinary character string and an expression calculation result together in one cell. CONSTITUTION: When a character is inputted at a cursor position by a character input means 4, a CRT display device 1 displays the inputted character at the cursor position under the control of control means 6 and 7. A specifying means 5 specifies a cursor position at an optional position of a character string displayed on the CRT display device 1 and when setting operation is done after an expression is inputted by an expression input means 4, the control means 6 and 7 finds the calculation result of the inputted expression. The display means 1 displays the expression calculation result at the cursor position under the control of the control means 6 and 7. Consequently, the expression calculation result can be displayed in the cell where the character string is inputted. In addition, after the expression calculation result found through the expression input operation and its setting operation is displayed, an optional character string can be inputted before and after the expression calculation result.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a document processing device capable of editing a table.

[0002]

2. Description of the Related Art In table editing in a conventional document processing apparatus, cells are divided into normal cells containing character strings and formula cells containing calculation formulas, and only formulas can be entered in formula cells. Yes, when I typed a character in a formula cell, the formula cell was changed to a normal cell.

[0003]

However, in the conventional document processing device, although the unit and sign of the formula cell can be changed, an arbitrary character string cannot be input, and
There was a problem that formulas could not be entered in ordinary cells.

Therefore, the present invention has been made in view of the above circumstances, and provides a document processing apparatus capable of displaying a normal character string and a formula calculation result character string in a mixture in the same cell. It is intended to be provided.

[0005]

According to a first aspect of the present invention, a document processing apparatus uses a ruled line editing function to create a plurality of cells surrounded by vertical ruled lines and horizontal ruled lines. In a document processing device capable of editing a table set, a display means for displaying the table set, a designating means for designating an input position of a character or an expression in an arbitrary cell, and an input designated by the designating means. A character input means for inputting a character at a position; an expression input means for inputting an expression at the input position specified by the specifying means; and a character input operation for inputting a character based on a character input operation by the character input means. Displayed on the screen, and based on the formula input operation and the setting operation by the formula input means, obtain the calculation result of the input formula,
And a control means for displaying the result of the formula calculation at the input position.

According to a second aspect of the present invention, the control means displays the formula calculation result at each input position when a plurality of input positions are designated for the same formula. It is a thing.

According to a third aspect of the present invention, a document processing apparatus uses a ruled line editing function to create a plurality of cells surrounded by vertical ruled lines and horizontal ruled lines, and then edits a table group for inputting characters or expressions in each cell. In a document processing device capable of performing the above, a display means for displaying the table set, a designating means for designating a character input position in an arbitrary cell, and a character input for inputting a character at the input position designated by the designating means Means, cell selecting means for selecting a cell in which a character is input, formula inputting means for inputting a formula in the cell selected by the cell selecting means, and input based on the character inputting operation by the character inputting means The displayed character is displayed at the input position, and based on the formula input operation by the formula input unit, a formula command for storing the input position is added to the end of the character string in the cell selected by the cell selection unit. After insertion into, and set an expression calculated a result of the input expression, the expression calculation result is characterized in that a control means for displaying on the top.

[0008]

According to the document processing apparatus of the present invention, when a character is input by the character input means to the input position designated by the designating means, the display means controls the input character under the control of the control means. Display at the input position. When the input position is designated at the arbitrary position of the character string displayed by the display unit by the designating unit, the formula is inputted by the formula inputting unit, and then the setting operation is performed, the control unit causes the calculation result of the inputted formula to be calculated. Ask for. The display means displays the formula calculation result at the input position under the control of the control means. As a result, the formula calculation result can be displayed in the cell in which the character string is input. On the contrary,
After displaying the formula calculation result obtained based on the formula input operation and the setting operation, an arbitrary character string can be input before and after the formula calculation result.

According to the second aspect of the present invention, the control means displays the formula calculation result at each input position when a plurality of input positions are designated for the same formula. As a result, a plurality of formula calculation results can be displayed in the same cell.

According to the document processing apparatus of the third aspect, the control means displays the character input based on the character input operation at the input position. When a cell in which a character has been input by the cell selection means is selected and a formula is input by the formula input means, the control means inserts a formula command at the beginning of the character string, sets the formula, and sets the input formula. Obtain the calculation result.
The display means displays the expression calculation result at the beginning of the character string under the control of the control means. This makes it possible to omit the specification of the position for displaying the formula calculation result.

[0011]

Embodiments of the present invention will now be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the document processing apparatus of the present invention.

This document processing device is a device capable of editing a table set in which a plurality of cells surrounded by vertical ruled lines and horizontal ruled lines are created by using a ruled line editing function, and a character or an expression is input in each cell. Yes, between a CRT display device 1 as a display means for displaying a document being edited, various message menus, etc., a video RAM (VRAM) 2 for expanding and storing an image displayed on the screen of the CRT display device 1, and between memories or A bit move unit (BMU) 3 for controlling data transfer between a memory and each device, a keyboard 4 having various keys for editing a document, a pointing device used for pointing an icon on the screen, etc. (PD) 5 and a control program (a program related to document editing and an error processing program, as well as the processing of the present invention described later) CP for controlling each unit of the apparatus based on programs the stored) ROM7 and ROM7 a control program stored in storing for the current
Control means consisting of U6 and the various programs described above
A RAM 8 used as a work area when the PU 6 executes, a temporary save area at the time of error processing, and a hard disk drive (HD) that uses a hard disk (HD) and a floppy disk (FD) for storing application programs, data, libraries, etc. described later.
D) 9 and floppy disk drive (FDD) 10
And data control on the network to transfer data between other document processing devices via the network,
Network interface for diagnosis (Net-I /
F) 11 and an I / O bus 12 including an address bus, a data bus, and a control bus that connect the above-mentioned units.
Is provided.

The keyboard 4 is a cursor (see FIG. 16 etc.) 301 for inputting a character or an expression in an arbitrary cell of a plurality of cells displayed on the display screen of the CRT display device 1.
Specifying means such as "↑" key, "↓" key, "←" key, "→" key, etc., and character input for inputting characters at the input position (cursor position) specified by this specifying means Means, expression input means for inputting an expression at the cursor position, and a setting key for setting the input expression.

The control means controls each part of the apparatus, displays the input character at the cursor position based on the character input operation by the character input means of the keyboard 4, and performs the expression input operation by the expression input means. Based on the operation of the setting key, obtain the calculation result of the input formula,
This formula calculation result is displayed at the cursor position.

The program stored in the ROM 7 in this embodiment may be stored in a storage medium such as a hard disk (HD) or a floppy disk (FD) directly connected to the apparatus, and further. , May be stored on another device connected to the network.
Further, the program of the present invention may be supplied to another system or device via a storage medium such as FD or HD or a network.

Here, the "table set" refers to a form in which a table is expressed as a part of a document in the processing program on the apparatus of FIG. In the table set, a cell can be created by using a ruled line editing function using various line types, and a character can be input into the cell by using a character editing function using a character modification or an emphasized typeface. Further, the character string (character information) in the cell is displayed after typesetting based on the cell attribute (information such as alignment). In this way, the table setting function makes it possible to represent a table that has undergone complicated editing. The "cell" refers to a rectangular area that is completely surrounded by vertical and horizontal ruled lines.

Next, the data structure at the time of editing the table data processed on the apparatus of FIG. 1 will be described with reference to FIGS.

At the time of editing the table set, the data of the table set is divided into two areas, an edit data area 21 and a local data area 22, as shown in FIGS.
Present on M8.

Table setting control information in the edit data area 21 (see FIG. 2)
(Details will be described later.) A portion 24 excluding the area 23 holds temporary data that is created / erased only during editing.

The local data area 22 holds information about each element such as ruled lines and characters that make up the table set,
When saving data after the editing is completed, data in a save format is created from the data in this area and the table control information 23.
In this local data area 22, work area management information 2
5, break information 26, break information free list 27, cell information 28, cell information free list 29, diagonal ruled line information (detailed description in FIG. 6) 30, horizontal ruled line information (detailed description in FIG. 7) 31, vertical ruled lines Information (detailed description in FIG. 8) 32, ruled line record free list 33, cell attribute information 34, cell attribute information free list 35, option cell attribute information 36,
The option cell attribute information free list 37 and the like are held.

Work area management information (detailed description with reference to FIG. 5) 25
Is information for managing each information in the edit data area 21 and the local data area 22.

The break information 26 and the break information free list 27 are the entity of the break information (described in detail in FIG. 13).
A reserved area (same size as the break information) dedicated for creating new break information is a mixed area. Here, each piece of information is division information,
The reserved area has a format in which a pointer to the next information and a pointer to the previous information are held between the reserved areas, and all the information can be traced from the head information. Hereinafter, in this embodiment, this type of data structure is referred to as a “list structure”.

Cell information 28 and cell information free list 2
Reference numeral 9 is an area in which the entity of cell information (described in detail in FIG. 9) and a dedicated reserved area (same size as the cell information) for creating new cell information are mixed together. This part also has a list structure.

The diagonal ruled line information 30, the horizontal ruled line information 31, the vertical ruled line information 32, and the ruled line record free list 33 are composed of the substance of the diagonal ruled line information (described in detail in FIG. 6) and the horizontal ruled line information (described in detail in FIG. 7). The entity, the vertical ruled line information (described in detail in FIG. 8), and the reserved area dedicated to creating new ruled line information (same size as each ruled line information) are mixed and gathered. This part also has a list structure. The diagonal ruled line information 30, the horizontal ruled line information 31, and the vertical ruled line information 32 all have the same size in order to commonly use a dedicated reserved area for creating new ruled line information.

The cell attribute information 34 and the cell attribute information free list 35 are the substance of the cell attribute information (described in detail in FIG. 11) and a dedicated reserved area (same size as the cell attribute information) for creating new cell information. ) Is a mixed area. This part also has a list structure.

The option cell attribute information 36 and the option cell attribute information free list 37 are the substance of the option cell attribute information (described in detail in FIG. 12) and a dedicated reserved area (option cell attribute) for creating new cell information. The same size as the information 36) is a mixed area. This part also has a list structure. The option cell attribute information 36 is the new option cell attribute information 36.
All have the same size regardless of the type of option attribute in order to commonly use the dedicated reserved area for creating.

FIG. 4 is a diagram showing a detailed structure of the table group control information 23. The table group control information 23, as shown in FIG.
A command 41 indicating the start of table group data, a flag 42 for editing the entire table group such as information indicating whether or not to automatically expand cells at the time of character input, and each process when the table group data is created Information 43 to 46 indicating the version of the program, the final address 47 of the cell, the final number 48 of the group used in the table data, and the reserved area for the data format change due to future function expansion. 49, a flag 50 indicating the grid display / non-display and the grid designation unit regarding the measure (grid),
It is composed of values 51 and 52 indicating grid intervals, a reserve area 53 prepared for a data format change due to future function expansion, and an upper line width 54, a line interval 55, and an underline width 56 related to a designated parent-child rule. .

FIG. 5 is a diagram showing a detailed structure of the work management information 25. The work management information 25, as shown in FIG.
ID 61 for identifying data and edit data area 2
1 start address 62 and secured edit data area 2
1 overall size 63 and effective size 64 of edited data
A pointer 65 to a table group control information edit data area (area in which the table group control information 23 of FIG. 2 is stored), and a vacant portion of the edit data area 21 (effective edit data of 24 in FIG. 2). Management information 66 of a portion other than the portion occupied by
A pointer 67 to the first record of the list of diagonal ruled line information existing in the information area (30 to 33 in FIG. 3) related to ruled lines in the local data area 22, a pointer 68 to the first record of the horizontal ruled line, and a vertical Pointer 69 to each head record of the ruled line, management information 7 of cell information holding the number of cells, points to cell information of the current cell, etc.
0, a pointer 71 to the first record of the cell information list existing in the area of information about cells in the local data area 22 (28 and 29 in FIG. 3), and an area of information about cell attributes in the local data area 22 (34 in FIG. 3,
35) a pointer 72 to the first record of the list of cell attribute information and a list of reserved areas for break information existing in the break information areas (26 and 27 in FIG. 3) in the local data area 2. 73 to the first record of
, A pointer 74 to the first record of the list of reserved areas for cell information, a pointer 75 to the first record of the list of reserved areas for character data, and a pointer to the first record of the list of reserved areas for ruled line information. 76, a pointer 77 to the first record of the list of reserved areas for cell attribute information, and option cell attribute information existing in the option cell attribute information areas (36 and 37 in FIG. 3) in the local data area 22. A pointer 78 to the first record in the list of reserved areas and an Un for canceling processing during table group editing.
do control information 79, table operation information 80 indicating current information being edited (menu type being processed, etc.), selected ruled line information header (detailed description in FIG. 14) 81 indicating the selected ruled line, and selection From a selected cell information header (detailed description with reference to FIG. 15) 82 indicating a cell inside, a work area 83, and local data area free space management information 84 that manages a free space (38 in FIG. 3) in the local data area 22. It is configured.

FIG. 6 is a diagram showing the detailed structure of the diagonal ruled line record. As shown in the figure, the diagonal ruled line record includes the coordinates 91 of the starting point of the diagonal ruled line (here, the starting point is the end point having the smaller y coordinate), the solid line, the dotted line, the one-dot chain line, the two-dot chain line, and the broken line. , A long broken line, a hidden line, a line type 92, a line width 93, a flag 94 indicating information such as ruled line lock, information about a rounded corner 95, and information about a line color 96 and 97. , The vertical length 98 of the line, the horizontal length 99 of the line that can take a negative value, and NULL if the next record does not exist. Pointer 100 to the next diagonal ruled line record. And NU for the first record
Pointer 1 to the previous diagonal ruled line record that is LL
01, a list structure is formed by the information of the pointers 100 and 101, and the list structure exists in the area of information regarding ruled lines (30 to 33 in FIG. 3).

FIG. 7 is a diagram showing the detailed structure of a horizontal ruled line record. The horizontal ruled line is expressed by one record as one ruled line as long as it is continuous. In the screen operation, the unit divided at the intersection of the vertical ruled line and the diagonal ruled line is treated as one ruled line, but it is the information of the intersection with other ruled lines held by each horizontal ruled line record (“break information”). 26,
The detailed determination will be made with reference to FIG. 13). However, if the line type or color is changed even with continuous horizontal ruled lines, or if a rounded corner is specified at the intersection with another ruled line, it is regarded as another ruled line from that part and managed by another record. The horizontal ruled line record includes the coordinates 111 of the start point of the horizontal ruled line (here, the start point is the end point of the smaller x coordinate), the solid line, the dotted line, the one-dot chain line, the two-dot chain line, the broken line, the long broken line, the hidden line, and the double line. A line type 112 in which any one of column rule, parent-child rule 1, parent-child rule 2, designated parent-child rule 1, and designated parent-child rule 2 is designated, a line width 113, a flag 114 indicating information such as ruled line lock, and a corner. Circle information 115, line color information 116 and 117, line length 118, and NU if no next record exists
Pointer 1 to the next horizontal ruled line record that is LL
19 and NULL for the first record,
The pointer 120 to the previous horizontal ruled line record, the pointer 121 to the leading delimiter information of the horizontal ruled line, and the serial number 122 assigned in ascending order of the y coordinate of the horizontal ruled line, and the information of the pointers 119 and 120. A list structure is formed by using the area (30 to 3 in FIG. 3) related to ruled line information.
It exists in 3). Therefore, the same number is assigned to all horizontal ruled line records having the same y coordinate.

FIG. 8 shows the detailed structure of the vertical ruled line record. The vertical ruled line is expressed by one record as one ruled line as long as it is continuous. In the screen operation, the unit divided at the intersection with the horizontal ruled line and the diagonal ruled line is treated as one ruled line, but it is the information of the intersection with other ruled lines held by each horizontal ruled line record (“break information”). 26,
The detailed determination will be made with reference to FIG. 13). However, if the line type or color has changed even with continuous vertical ruled lines, or if a rounded corner is specified at the intersection with another ruled line, that part is regarded as another ruled line and is managed in another record. The vertical ruled line record includes coordinates 131 of the start point of the vertical ruled line (here, the start point is the end point of the smaller y coordinate) and the solid line, the dotted line, the one-dot chain line, the two-dot chain line, the broken line, the long broken line, the hidden line, and the double line. A line type 132 in which any of the pillar ruled line, the parent-child ruled line 1, the parent-child ruled line 2, the designated parent-child ruled line 1, and the designated parent-child ruled line 2 is designated, the line width 133, the flag 134 indicating information such as ruled line lock, and the corner. Circle information 135, line color information 136, 137, line length 138, and NU if no next record exists
Pointer 1 to the next vertical ruled line record that is LL
39, and NULL for the first record,
The pointer 140 to the previous vertical ruled line record, the pointer 141 to the leading delimiter information of the vertical ruled line, and the serial number 142 sequentially assigned from the x coordinate of the horizontal ruled line in the ascending order. A list structure is formed by and exists in the information area (30 to 33 in FIG. 3) related to ruled lines. Therefore, the same number is assigned to all vertical ruled line records having the same x coordinate.

FIG. 9 is a diagram showing a detailed structure of cell information. The number of ruled lines forming cells may be any number as long as it is four or more. One cell is managed by one cell information 28. There are two types of cells: normal cells containing character strings and formula cells containing calculation formulas. The cell information 28 includes a pointer 151 to the horizontal ruled line record of the leftmost horizontal ruled line of the horizontal ruled lines forming the upper side of the cell, and the vertical ruled line at the top of the vertical ruled lines forming the left side of the cell. A pointer 152 to the vertical ruled line record and the upper left coordinate 153 of the cell
, The cell size 154, the number of horizontal ruled lines 155 constituting the upper side of the cell, and rounded corner information 156 for each of the four corners of the cell
Information 157 in which the maximum line width of each side is obtained based on the information of the ruled lines forming each of the four sides of the cell, and a character record (detailed description in FIG. 10) 158 that is information regarding the characters belonging to the cell, A pointer 159 to information such as the character position of the result of formatting the character string in the cell, and is valid only when the cell is a normal cell, and the value of the cell to be passed to the calculation processing program when the cell becomes the calculation target at the time of calculation. Pointer 160 to information indicating the value, and NU if the next information does not exist
Pointer 161 to the next cell information, which is LL
And a pointer 162 to the previous cell information, which is NULL in the case of the information at the beginning.
A list structure is formed by the information 61 and 162, and the list structure exists in the information area (34 and 35 in FIG. 3) regarding the cell attribute.

FIG. 10 is a diagram showing the detailed structure of a character record. The character record 158 is information about characters in a cell that has a one-to-one correspondence with the cell information 28.
8 shows the area 171 that is not used during editing and holds the number of bytes of the entire character record when table data is saved as a file, and cell lock, heading specification, and cell type (normal or formula) A flag 172, a group number 173 when cells are grouped,
The number of group members 174 that is valid only for the first member cell of the group, the member number 175 in the group that is valid only when the cells are grouped, and indicates the number of members in the group, and the calculation process A cell address 176, which is an index for identifying a cell, a pointer 177 to cell attribute information (detailed description in FIG. 11) 34, information 178 for identifying the top horizontal ruled line of the cell to which this character record belongs, and a group Information 179 for managing a character string for each member cell in the case of a converted cell, a character data buffer (normal cell) 183 in the case of a normal cell, and a character data buffer (expression cell) 185 in the case of a formula cell Character data count that indicates the size of the entire area by the number of characters 18
0, a character data buffer size 181 indicating the size of the character data buffer in the same way as the character data count 180, and a pointer 182 to the character data buffer
It consists of and. Here, a group is a processing method unique to a table group in which a plurality of cells are regarded as one cell by grouping, and a character string input thereto is
The cells are displayed in order from the first member of the group according to the group member number. When the cell is a normal cell, the character data buffer is occupied only by the character string (command and character code of character edit processing) 184.
Further, in the case of the formula cell, the character data buffer is divided into the portions indicated by 186 to 191 in FIG. In the character data buffer (formula cell) 185, a character string (command and character code of character editing process) 187 processed with reference to the calculated value display attribute that holds the calculation result as an option cell attribute (detailed description in FIG. 12). Area 188 for storing display character string information including the number of characters and the number of characters 186, and calculation result information
And an area 189 for storing information necessary for calculation to be used at the time of processing by the calculation processing program, and expression information including data 191 in reverse Polish format in the expression body held by the cell and the number of characters 190 thereof. There is.

FIG. 11 is a diagram showing a detailed structure of cell attribute information. As shown in the figure, the cell attribute information 34 is information that each character record always has only one, and one cell attribute information 34 may be referred to by a plurality of character records. The number of bytes 201, a value 202 indicating how many character records refer to the cell information, and a set flag 20 that is information such as a set direction.
3 and a character flag 204, which is information such as character type (full-width, half-width, etc.), and alignment of top, bottom, left, and right, and standard typeface information 20 about the typeface used when Japanese is input in a cell
5, the European typeface information 206 regarding the typeface used when an alphanumeric character is input in the cell, the information 207 regarding the background color of the character, the line spacing 208, the left margin 209, and the right margin 21.
0, an upper margin 211, a lower margin 212, information 213 indicating which type of optional attribute this cell attribute has by using default optional attributes not included here, and cell face information 214
The number of bullet indentation characters 215, the number of paragraph indentation characters 216, the amount of baseline adjustment 217 for displaying Japanese and European mixed sentences neatly, and NULL if no option attribute is held. And a pointer 21 to the option attribute information held by this cell attribute
And 8.

FIG. 12 is a diagram showing a detailed structure of the option attribute information. Option attributes are held in the form of one option attribute list for one cell attribute information. Here, the optional attribute list is an optional attribute flag whose optional attribute information is cell attribute information (see FIG. 1).
1) 224 of FIG. 12 for the type specified in 213
It is connected as shown in. The option attribute information has the same size for each type as the data type 221 of 12 types of optional attributes such as Japanese emphasized typefaces 1 to 5, European emphasized typefaces 1 to 5, formula calculation value display attributes, and tab information. And a pointer 223 to the next option attribute information, which is NULL when there is no next option attribute and which is NULL when there is no next option attribute. .

FIG. 13 shows the detailed structure of the break information.
The break information 26 is NULL when the next information does not exist, as shown in FIG.
6 for pointer 231 and NULL for the first information
232 is a pointer 232 to the previous break information 26.
, A graph 233 indicating the crossing direction, the coordinates 234 of the break position, and a pointer 2 to the ruled line record of the other party to cross.
35, a list structure is formed by the information of the pointers 231, 232, and an area of the break information (2 in FIG. 3).
6, 27).

FIG. 14 is a diagram showing a detailed structure of the selected ruled line information. The selected ruled line information header 81 is information regarding the selected ruled line and is held in the work area management information (81 in FIG. 5) in the local data area. As for the selected ruled line information, how many selected ruled line information can be stored in the upper left coordinate 241 of the entire selected ruled line range, the lower right coordinate 242, and the memory reserved for the arrangement of the selected ruled line information. , The maximum number of selected ruled lines 243 to reallocate a new area when the region is insufficient, the number of selected ruled lines 244, the start address 245 of the array of selected ruled line information, and the vertical, horizontal, and diagonal ruled lines. Of any of the ruled line types 246, a pointer 247 to the ruled line record, and information 248, 249 for specifying the part of the ruled line (in units of breaks) when selected. It is configured.

FIG. 15 shows the detailed structure of the selected cell information. The selected cell information header 82 is information regarding the selected cell and is held in the work area management information (82 in FIG. 5) in the local data area. Selected cell information header 82
On the memory reserved for the array of selected cell information,
A value indicating how many pieces of selection ruled line information can be stored. When the area is insufficient, the maximum number of selected cells 251, the number of selected cells 252, and the start address of the array of selected cell information are newly secured. And 253. Each selected cell information has a work flag 254 used at the time of processing.
And a pointer 255 to cell information.

Next, the operation of this embodiment will be described with reference to FIGS.
Also, referring to FIG. 16 to 19 are diagrams for explaining the operation when a formula is inputted after a normal character string is inputted to an empty cell, and FIG. 23 is a flowchart showing a formula input process by the CPU 6 of the apparatus of this embodiment. 24 is a flowchart showing details of the display process of step S4 in FIG.

First, on the display screen of the CRT display device 1, as shown in FIG. 16, the character cursor 301 is displayed in the center of the cell 300 and the character input of the cell 300 in which nothing has been input is started. Suppose

When the operator operates the character input means of the keyboard 4 to input a normal character string 302 such as "aiueo", the input character string 302 is displayed on the CRT display device 1 as shown in FIG. Is displayed in. Next, the operator operates the designating means of the keyboard 4 to move the character cursor 301 to a position (for example, between the letters "i" and "u") where the formula calculation result is to be displayed as shown in FIG. When an expression is input by the expression input means of the keyboard 4, the CPU 6 checks whether or not the grammar of the input expression is correct, as shown in the flowchart of FIG. 23 (S1). If the grammar of the expression is incorrect, the input processing of the expression ends. If the grammar of the expression is correct, the "expression command" is inserted at the current position of the character cursor 301 (S
2). The “expression command” is a command for storing the position of displaying the expression calculation result in the character string.
The character data buffer (normal cell) 183 is managed together with normal character string data. CPU6
Actually sets the input expression and calculates (S3),
Display processing of the formula calculation result (character string) 303 is performed (S
4, S5 to S8). In this display processing, as shown in the flowchart of FIG. 24, the CPU 6 checks whether the display target is an expression command (S5). When it is an expression command, as shown in FIG. 19, the expression calculation result character string 303 is displayed at the position of the expression command (S6). If it is not an expression command, the normal character string 302 is displayed (S7). Formula calculation result 3 in step S6 or S7
After displaying 03 or the normal character string 302, it is checked whether or not the display of all character strings 302 and 303 is completed (S
8). When the display of all the character strings 302 and 303 is completed, the cell character string display process is ended, and then the formula input process is also ended. If the display of the character strings 302 and 303 has not been completed, the process returns to step S5 and the next expression calculation result 302 or the normal character string 302 is displayed.

16 to 19, the case where the formula is input after the normal character string 302 is input to the empty cell 300 has been described, but in FIGS. 16 and 20 to 22, the formula is input to the empty cell 300. The case of inputting and then the normal character string 302 will be described. When an expression is input to the empty cell 300 in FIG. 16 in which nothing is input, the processes of steps S1 to S8 are performed, and the calculation result 302 of the expression is displayed as shown in FIG. Next, as shown in FIG. 21, the character cursor 301 is moved to an arbitrary position (for example, the head of the calculation result of the formula), and the character string 302 such as “Ai” is displayed.
When is input, it becomes as shown in FIG. Here, when the cursor 301 is moved to another position (the end of the calculation result of the formula) and the character string 302 such as "Kakiku" is input, the result is as shown in FIG. Note that only one formula can be input to one cell 300, but if the same formula is set multiple times to one cell 300, the formula command is inserted at the cursor position each time, so that FIG. As shown in, the calculation result 302 of the formula can be displayed at a plurality of positions.

Next, a second embodiment of the present invention will be described.
In the present embodiment, the input of the formula during the character editing of the cell (character editing mode) has been described. However, the character input means for inputting the character and the character cursor display means are deleted from the present embodiment to replace the cell selecting means and the cell. By adding the judgment means to judge whether the expression command exists in the character string of
It is also possible to carry out in a mode (cell selection mode) in which the cell attribute is set or the cell is locked with the cell as an edit target. When entering a formula in cell selection mode, if no formula command exists, insert it at the beginning of the character string in the selected cell, and if a formula command exists, insert a new formula command. Absent.

The operation of the second embodiment will be described with reference to FIGS.
8 will be described with reference to the flowchart of FIG. 26 to 28 show display examples of the second embodiment. FIG. 29 is a flow chart showing the expression input process of the second embodiment. As shown in FIG. 26, when the operator selects a normal cell in which the character string 302 is input such as “Tachitsuto” by the cell selecting means, as shown in FIG. 27, for example, the character string 302 and the ground portion are displayed. 304 and black and white are displayed in reverse. Here, the operator uses the keyboard 4
When is operated to input an expression, the CPU 6 checks whether or not the grammar of the input expression is correct (S9), and ends if the expression grammar is not correct. If the grammar of the formula is correct, it is checked whether or not a formula command exists in the selected cell 300 (S10). If there is an expression command, expression setting processing is performed (S12). CP if no expression command
U6 inserts an expression command at the beginning of the character string 302 in the selected cell 300 (S11) and performs expression setting processing (S12). As shown in FIG. 28, the expression calculation result 303 is displayed at the beginning of the character string 302 in which the expression command is inserted, such as "0.234%", and the display processing is ended (S1.
3).

Next, a third embodiment of the present invention will be described. In this embodiment, when the expression was set, the expression command was inserted at the cursor position.However, by adding an expression command inserting means for newly inserting the expression command, any cursor position can be edited during character editing. You can insert an expression command into.

The operation of the third embodiment will be described with reference to FIGS.
Referring to FIG. 2, description will be given according to the flowchart of FIG. 30 to 32 are diagrams for explaining the inserting operation of the expression command. FIG. 33 is a flow chart showing the expression command insertion processing of the third embodiment. First, as shown in FIG. 30, it is assumed that the formula calculation result 303 such as “0.234%” is displayed at the position of the formula command of the cell 300 in which the formula and the character string 302 are mixed. Here, as shown in FIG. 31, the operator operates the keyboard 4 to move the character cursor 301 to an arbitrary position where the formula calculation result 303 is to be displayed, and the cursor of the cell 300 during character editing by the formula command inserting means. When the formula command is inserted at the position (S14), the CPU 6 displays the formula calculation result 303 at the position of the cursor 301 (S15), as shown in FIG.

Next, a fourth embodiment of the present invention will be described. Although not mentioned in the present embodiment, a character deleting means for newly deleting one character before the cursor position is added, and the cursor 301 is moved after the expression command to execute the deletion. Can be deleted. As a result, the formula calculation result displayed at the position of the formula command is no longer displayed. Furthermore, by adding a determining means for determining whether or not a formula command exists in the character string of the cell 300, when all the formula commands in the cell 300 are deleted and the editing of the cell 300 ends, the cell 300 It is also possible to delete the expression that was set to. FIG. 34 is a flow chart showing a cell character editing process of the fourth embodiment. When the operator operates the keyboard 4 to move the cursor 301 to the back of the expression command one wants to delete, and when the character deletion means performs the expression deletion operation, the determination means determines that the expression command exists in the character string of the cell 300. It is checked whether or not to execute (S16), and if there is no formula command, the CPU 6 performs a character edit end process of the cell 300 (S19). CPU if there is an expression command
6 checks whether or not the formula is set in the cell 300 (S17), and if the formula is not set, the cell 300 is checked.
A character edit end process is performed (S19). When the expression is set, the CPU 6 deletes the expression (S1
8), end processing of character editing of cell 300 is performed (S1)
9). Subsequently, after displaying the character string of the cell 300 (S20), the process ends.

Next, a fifth embodiment of the present invention will be described. In connection with the fourth embodiment, the means for performing ordinary characters such as cut, copy, paste, etc. is also enabled for the equation command, so that the expression command can be edited as ordinary characters. You can do it with the same feeling.

Next, a sixth embodiment of the present invention will be described. Although not particularly mentioned in the present embodiment, if the character string of the expression command is formatted by a general formatting rule like a normal character string, an automatic line break may occur in the middle of the expression command, so This can be avoided by automatically prohibiting the character string of the expression command from being separated.
35 and 36 are diagrams relating to the sixth embodiment. FIG.
5 shows the case where the formula calculation result 303 is typeset by a general typesetting rule like “¥ 5,000.00”.
An automatic line break has occurred after the. On the other hand, FIG.
Reference numeral 6 shows the result of the formula calculation result 303 being formatted in the prohibition of separation, and the formula calculation result 303 is integrated and added to the next line.

Next, a seventh embodiment of the present invention will be described. The present embodiment further includes a determination unit that determines whether or not an expression command exists in the character string of the cell 300, and a cell 3
By providing a formula command deleting unit that deletes all formula commands in 00, it is possible to collectively delete a plurality of formula commands input in the character string of the cell 300. FIG. 37 is a flow chart showing the formula command deletion processing of the seventh embodiment. The determination means is the cell 300
Check whether there is an expression command in the character string of (S
21). If there is no formula command, the cell character string is displayed (S23) and the process ends. If there is an expression command, the expression command found first in the character string in the cell 300 is deleted by the expression command deleting means (S).
22), and the process again proceeds to step S21. By repeating the processing of steps S21 and S22, the cell 30
Delete all expression commands from the 0 character string.

According to the above-described embodiment, it is possible to input an arbitrary character to the formula cell, and it is possible to display the normal character string and the formula calculation result in a mixed manner in one cell. It is now possible to display multiple formula calculation results in one cell. This makes it possible to cite and use a plurality of calculation results in a document (one cell). Also, it became possible to set the expression during character editing (implementation became easier). In addition, it is now possible to set character decorations and emphasized typefaces for formula calculation results like ordinary characters.

[0053]

According to the present invention described in detail above, the following effects can be obtained.

According to the first aspect of the invention, the formula can be entered in the cell in which the character is entered, and the character can be entered in the cell in which the formula is entered. Therefore, the normal character string and the formula calculation can be performed in the same cell. It is possible to provide a document processing device capable of displaying a mixed result.

According to the second aspect of the invention, a plurality of formula calculation results can be displayed in the same cell.

According to the third aspect of the invention, it is possible to display the normal character string and the formula calculation result in a mixed manner in the same cell without designating the position for displaying the formula calculation result. Becomes

[Brief description of drawings]

FIG. 1 is a block diagram of this embodiment.

FIG. 2 is a diagram showing a data structure of a table set.

FIG. 3 is a diagram showing a data structure of a table group.

FIG. 4 is a diagram showing a detailed structure of table group control information.

FIG. 5 is a diagram showing a detailed structure of work management information.

FIG. 6 is a diagram showing a detailed structure of a diagonal ruled line record.

FIG. 7 is a diagram showing a detailed structure of a horizontal ruled line record.

FIG. 8 is a diagram showing a detailed structure of a vertical ruled line record.

FIG. 9 is a diagram showing a detailed structure of cell information.

FIG. 10 is a diagram showing a detailed structure of a character record.

FIG. 11 is a diagram showing a detailed structure of cell attribute information.

FIG. 12 is a diagram showing a detailed structure of option attribute information.

FIG. 13 is a diagram showing a detailed structure of break information.

FIG. 14 is a diagram showing a detailed structure of selected ruled line information.

FIG. 15 is a diagram showing a detailed structure of selected cell information.

FIG. 16 is a diagram showing a character input start state of an empty cell.

FIG. 17 is a diagram for explaining a case of inputting a formula after inputting a character string in an empty cell.

FIG. 18 is a diagram for explaining a case of inputting a formula after inputting a character string in an empty cell.

FIG. 19 is a diagram for explaining a case of inputting a formula after inputting a character string in an empty cell.

FIG. 20 is a diagram for explaining a case of inputting a character string after inputting a formula in an empty cell.

FIG. 21 is a diagram for explaining a case of inputting a character string after inputting a formula in an empty cell.

FIG. 22 is a diagram for explaining a case of inputting a character string after inputting a formula in an empty cell.

FIG. 23 is a flowchart showing the operation of this embodiment.

FIG. 24 is a flowchart showing the operation of this embodiment.

FIG. 25 is a diagram showing an example of displaying formula calculation results at a plurality of positions.

FIG. 26 is a diagram for explaining the second embodiment.

FIG. 27 is a diagram for explaining the second embodiment.

FIG. 28 is a diagram for explaining the second embodiment.

FIG. 29 is a flowchart showing an expression input process of the second embodiment.

FIG. 30 is a diagram for explaining the third embodiment.

FIG. 31 is a diagram for explaining the third embodiment.

FIG. 32 is a diagram for explaining the third embodiment.

FIG. 33 is a flowchart showing an expression command insertion process of the third embodiment.

FIG. 34 is a flow chart showing a cell character editing process of the fourth embodiment.

FIG. 35 is a diagram for explaining the sixth embodiment.

FIG. 36 is a diagram for explaining the sixth embodiment.

FIG. 37 is a flow chart showing an expression command deletion process of the seventh embodiment.

[Explanation of symbols]

 1 CRT display device (display means) 2 video RAM 3 BMU 4 keyboard 5 pointing device 6 CPU (control means) 7 ROM (control means) 8 working RAM 9 hard disk drive 10 floppy disk drive 11 network interface 12 I / O bus 300 cell 301 cursor 302 ordinary character string 303 formula calculation result

Claims (3)

[Claims] 1. A document processing device capable of editing a table group in which a plurality of cells surrounded by vertical ruled lines and horizontal ruled lines are created using a ruled line editing function, and then a character or an expression is input in each cell, Display means for displaying the table set, designating means for designating an input position of a character or expression in any of the cells, character input means for inputting a character at the input position designated by the designating means, and the designating means Based on the character input operation by the expression input means for inputting an expression to the input position designated by, the input character is displayed at the input position, and the expression input operation by the expression input means and A document processing apparatus comprising: a control unit that obtains a calculation result of an input expression based on the setting operation and displays the calculation result of the expression at the input position. 2. The document processing apparatus according to claim 1, wherein, when a plurality of input positions are designated for the same expression, the control means displays the expression calculation result at each input position. . 3. A document processing device capable of table group editing, wherein a plurality of cells surrounded by vertical ruled lines and horizontal ruled lines are created using a ruled line editing function, and then characters or expressions are input in each cell. Display means for displaying the table set, designating means for designating a character input position in any of the cells, character input means for inputting a character at the input position designated by the designating means, and character input Cell selecting means for selecting cells,
Formula input means for inputting a formula in the cell selected by the cell selection means, and based on the character input operation by the character input means, the input character is displayed at the input position, and at the same time by the formula input means. Based on the formula input operation, after inserting the formula command for storing the input position at the beginning of the character string in the cell selected by the cell selecting means, set the formula and the calculation result of the inputted formula And a control means for displaying the formula calculation result at the head.