JPH07220009A - Method and device for table processing - Google Patents

Abstract

PURPOSE:To easily discriminate formula cells and normal cells on display by discriminating whether a formula is defined for each cell of the table stored in the storage means where the table including plural cells is stored or not by a discriminating means and displaying cells, for which formulas are defined, distinguishably from the other cells by a display control means at the time or displaying the table. CONSTITUTION:A cell is a rectangular area completely enclosed by vertical ruled lines and horizontal lines, and cells are divided into normal cells where character strings are entered and formula cells where calculation formulas are entered. After the end of the display processing of all cells, it is checked whether a current cell is a formula cell or not. If it is a formula cell, a formula symbol is displayed in the cell. Though a dark grey square is displayed as the formula symbol in the figure, a circular, starry, or triangular formula symbol may be used. Especially, the inside color of the symbol is made different from the color of the outline to easily discriminate the symbol even in the case of the background and the symbol of the same color.

Description

Detailed Description of the Invention

[0001]

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

[0002]

2. Description of the Related Art In table editing in a conventional document processing apparatus, a formula cell in which a formula is defined and a normal cell are displayed on the display.
I didn't make a distinction.

[0003]

However, in the above-mentioned conventional document processing apparatus, since the formula cell and the normal cell are indistinguishable from each other in display, an error occurs when the formula cell is processed as a normal cell, and There was a problem that you tried to edit the formula for a normal cell.

[0004]

In order to solve the above-mentioned problems, a table processing apparatus of the present invention has a storage means for storing a table including a plurality of cells, and a cell for each table of the table stored in the storage means. A discriminating means for discriminating whether or not a formula is defined, and, when displaying a table stored in the storage means, a cell for which a discriminant is discriminated by the discriminating device is defined as another cell. Display control means for displaying in a distinguishable manner.

According to another aspect of the present invention, the table processing device is provided with a display control means for displaying a table including a plurality of cells and a cell for the table displayed by the display control means. Cursor display means for displaying a cursor, discriminating means for discriminating whether or not an expression is defined in a cell designated by the cursor displayed by the cursor display means, and an equation is defined by the discriminating means. And a changing means for changing the display form of the cursor when determined.

According to another aspect of the present invention, in the table processing method, a storing step of storing a table including a plurality of cells, and an expression is defined for each cell of the table stored in the storing step. When displaying the table stored in the determining step and the determining step of determining whether or not there is a cell, a cell for which an expression is defined by the determining step is displayed in a distinguishable manner from other cells. And a display control step.

According to another aspect of the present invention, the table processing method includes a display control step of displaying a table including a plurality of cells and a cell of the table displayed by the display control step. A cursor display step of displaying a cursor, a determination step of determining whether or not a formula is defined in a cell designated by the cursor displayed in the cursor display step, and an equation is defined by the determination step. And a changing step of changing the display form of the cursor when determined.

[0008]

In the table processing device, when the formula is defined in each cell of the table stored in the storage unit that stores the table including a plurality of cells, the determining unit determines whether the table is displayed. In addition, the display control means displays the cell for which the formula is defined so as to be distinguishable from other cells.

According to another aspect of the table processing apparatus, a cursor for designating a cell of a table including a plurality of cells displayed by the display control means is displayed by the cursor display means and designated by the displayed cursor. Whether or not a formula is defined in the cell is discriminated by the discriminating unit, and when the discriminating unit discriminates that the formula is defined, the display form of the cursor is changed by the changing unit.

According to another aspect of the table processing method, it is determined whether or not an expression is defined in each cell of the table stored in the storing step of storing the table including a plurality of cells, and the table is stored. At the time of display, the display control step displays the cell for which the formula is defined so as to be distinguishable from other cells.

According to another aspect of the table processing method, a cursor for designating a cell of a table including a plurality of cells displayed by the display control step is displayed by the cursor display step and designated by the displayed cursor. Whether or not a formula is defined in the cell is discriminated in the discriminating step, and when it is discriminated that the formula is defined in the discriminating step, the display form of the cursor is changed in the changing step.

[0012]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described in detail below with reference to the drawings.

<Description of Apparatus> FIG. 1 is a block diagram showing the arrangement of a document processing apparatus according to an embodiment of the present invention.

In FIG. 1, reference numeral 1 denotes a CRT display device, which displays a document being edited, various message menus, and the like. 2 is a video RAM (VRAM), a CRT
The image displayed on the screen of the display device 1 is expanded and stored. A bit move unit (BMU) 3 controls data transfer between a plurality of memories or between a memory and each device. Reference numeral 4 is a keyboard having various keys for inputting or instructing when editing a document, and reference numeral 5 is a pointing device (PD) for pointing an icon on the screen.

Reference numeral 6 denotes a CPU, which performs various calculations and judgments based on a control program stored in the ROM 7 to control each section of the apparatus. Reference numeral 7 denotes a ROM, which stores a program corresponding to each processing procedure of the present embodiment, which will be described later with reference to a document editing process, an error process, and a flowchart. Reference numeral 8 denotes a RAM, which is used as a work area when the CPU executes the above-described programs and a temporary save area when error processing is performed.

Reference numeral 9 denotes a hard disk drive (HDD),
Reference numeral 10 denotes a floppy disk drive (FDD), and each disk is used for storing application programs, data, libraries, etc. described later.
11 is a network interface (Net-I /
F) shows the data control and diagnosis on the network in order to transfer the data to and from another document processing apparatus via the network. Reference numeral 12 denotes an I / O bus (comprising an address bus, a data bus, and a control bus) that connects the units described above.

In this embodiment, the control program is RO
Although it is supposed to be stored in M7, HDD9 and FDD1
It is also possible to read out from a storage medium such as a hard disk (HD) or a floppy disk (FD) via 0 and use it. Alternatively, the stored program may be supplied from another device connected to the network using Net-I / F.
On the contrary, these programs can be supplied to other systems or devices via a storage medium such as FD or HD or a network.

<Outline of Table Set> The table set is a form in which a table is expressed as a part of a document in the processing program on the apparatus as in this embodiment. 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 in the cell is displayed after typesetting based on the cell attribute (information such as character alignment in the cell). With such a table grouping function, it is possible to represent a table that has undergone complicated editing.

<Structure of Table Set Data> FIG. 2 shows the data structure when the table set data processed on the apparatus of this embodiment is edited.
This will be described with reference to FIG.

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, on the RAM 8 for convenience of processing, as shown in FIG. A portion 24 of the edit data area 21 excluding the table control information portion 23 (which will be described in detail with reference to FIG. 3) holds temporary data to be 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 the data after the editing is completed, the data in the save format is created from the data in the area 22 and the table setting control information 23. The work area management information 25 (which will be described in detail with reference to FIG. 4) is information for managing each information in the edit data area 21 and the local data area 22. 26 and 27 are areas in which the entity of the break information (which will be described in detail with reference to FIG. 12) and a dedicated reserved area (same size as the break information) for creating new break information are mixed and gathered. is there. Here, each piece of information has a format in which the delimiter information is the delimiter information, the reserved area is the reserved areas, and the pointer to the next information and the pointer to the previous information are held. All information is traceable. Hereinafter, in this embodiment, this type of data structure is referred to as a “list structure”.

Reference numerals 28 and 29 are areas where the substance of cell information (which will be described in detail with reference to FIG. 8) and a reserved area (the same size as the cell information) dedicated for creating new cell information are mixed and collected. is there. This part also has a list structure. 30,
Reference numerals 31, 32, and 33 are the entities of the diagonal ruled line information (which will be described in detail with reference to FIG. 5), the horizontal ruled line information (which will be described in detail with reference to FIG. 6), and the vertical ruled line information (which will be described in detail with reference to FIG. 7). ) And a 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. Note that the diagonal ruled line information, the horizontal ruled line information, and the vertical ruled line information have the same size because a dedicated reserved area for creating new ruled line information is commonly used.

34 and 35 are a mixture of the substance of cell attribute information (which will be described in detail with reference to FIG. 10) and a reserved area (the same size as the cell attribute information) dedicated for creating new cell information. It is a gathered area. This part also has a list structure. 36 and 37 are option cell attribute information (see FIG. 11).
And a reserved area dedicated to creating new cell information (having the same size as the optional cell attribute information) are mixed and gathered. This part also has a list structure. The option cell attribute information has the same size regardless of the type of the option attribute because the dedicated reserved area for creating new option cell attribute information is commonly used.

FIG. 3 shows the detailed structure of the table control information section 23 of FIG. 41 is a command indicating the start of table group data,
Reference numeral 42 is a flag relating to the editing of the entire table set, such as information indicating whether or not the cell is automatically expanded when a character is input. Four
3, 44, 45, and 46 are information indicating the version of each processing program when the table data is created. Four
7 is the final address of the cell, and 48 is the final number of the group used in the table data. Reference numeral 49 is a reserve area to prepare for a change in the data format due to future function expansion.

Numerals 50 to 53 are information related to the measure (grid), and numeral 50 is a flag indicating display / non-display of the grid and a grid designation unit. 52 and 53 are values indicating the grid interval. Reference numeral 53 is a reserved area in preparation for a change in data format due to future function expansion.

Reference numerals 54 to 56 are information relating to the designated parent-child rule, and are composed of an upper line width 54, a line interval 55, and an underline width 56.

The detailed structure of the work management information 25 shown in FIG.
As shown in FIG.

Reference numeral 61 is an ID for identifying data. 62 is the start address of the edit data area 21, 63
Indicates the size of the entire secured edit data area 21, and 64 indicates the effective size of the edit data. Reference numeral 65 is a pointer to the table control information edit data area 23, and 66 is management information of an empty portion of the edit data area 24 (a portion of the portion of the area 24 other than the portion occupied by the valid edit data).

67 is present in the information area (30 to 33 in FIG. 2) related to the ruled line in the local data area 22.
This is a pointer to the first record in the list of diagonal ruled line information. Similarly, 68 is a horizontal ruled line, and 69 is a pointer to each top record of a vertical ruled line. Reference numeral 76 is a pointer to the first record of the list of reserved areas for ruled line information.

Reference numeral 70 is cell information management information, which holds the number of cells, a pointer to the cell information of the current cell, and the like. Reference numeral 71 is a pointer to the first record of the cell information list existing in the cell information area (28 to 29 in FIG. 2) in the local data area 22. Also,
Reference numeral 74 is a pointer to the first record of the list of reserved areas for cell information.

Reference numeral 72 is a pointer to the first record of the list of cell attribute information, which exists in the area (34 to 35 in FIG. 2) of information on cell attributes in the local data area 22. Reference numeral 77 is a pointer to the first record of the list of reserved areas for cell attribute information.

Reference numeral 73 is a pointer to the first record of the list of reserved areas for break information existing in the break information areas (26 to 27 in FIG. 2) in the local data area 22. Reference numeral 75 is a pointer to the first record in the list of reserved areas for character data.

Reference numeral 78 is a pointer to the first record of the list of the reserved area for option cell attribute information existing in the option cell attribute information area (36 to 37 in FIG. 2) in the local data area 22. Reference numeral 79 is Undo control information for cancellation processing during table group editing, and 80 is table group operation information indicating current information being edited (menu type being processed, etc.). Reference numeral 81 denotes a selected ruled line information header indicating a selected ruled line (described in detail with reference to FIG. 13), 8
2 is a selected cell information header (FIG. 14) showing the cell being selected.
Will be described in detail). 83 is a work area, 8
4 is an empty area in the local data area 22 (3 in FIG. 2).
8) Free space management information for local data area for managing 8).

FIG. 5 shows the detailed structure of the diagonal ruled line record.

Reference numeral 91 is the coordinates of the start point of the diagonal ruled line. Here, the starting point is the end point having the smaller y coordinate. Reference numeral 92 indicates a line type, and any one of a solid line, a dotted line, a one-dot chain line, a two-dot chain line, a broken line, a long broken line, and a hidden line is designated. Reference numeral 93 is a line width, and 94 is a flag indicating information such as ruled line lock.
Reference numeral 95 is information regarding rounded corners. 96 and 97 are information regarding the color of the line. 98 is the vertical length of the line, 99 is the horizontal length of the line, and only the horizontal length 99 can take a negative value. Reference numeral 100 is a pointer to the next diagonal ruled line record, which is NULL when the next record does not exist. Reference numeral 101 is a pointer to the preceding diagonal ruled line record, which is NULL for the first record. The diagonal ruled line record forms a list structure by the information of 100 and 101, and exists in the portions indicated by 30 to 33 in FIG.

FIG. 6 shows the detailed structure of the horizontal ruled line record.

The horizontal ruled line is represented 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”). Fig. 12
This will be explained in detail). However, even with continuous horizontal ruled lines, if the line type or color changes, 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 in another record. .

Reference numeral 111 is the coordinates of the starting point of the horizontal ruled line. Here, the starting point is the end point of the smaller x coordinate. Reference numeral 112 denotes a line type, which is one of a solid line, a dotted line, a one-dot chain line, a two-dot chain line, a broken line, a long dashed line, a hidden line, a double-column rule, a parent-child rule 1, a parent-child rule 2, a designated parent-child rule 1, and a designated parent-child rule 2. It is specified. 11
Reference numeral 3 is a line width, and 114 is a flag indicating information such as ruled line lock. Reference numeral 115 is information regarding rounded corners. 116, 1
Reference numeral 17 is information regarding the color of the line. 118 is the length of the line. Reference numeral 119 is a pointer to the next horizontal ruled line record, which is NULL when the next record does not exist. Reference numeral 120 is a pointer to the previous horizontal ruled line record, which is NULL for the first record. The horizontal ruled line record forms a list structure by the information of 119 and 120, and exists in the portions indicated by 30 to 33 in FIG. 12
Reference numeral 1 is a pointer to information on the beginning of the horizontal ruled line. Reference numeral 122 is a serial number sequentially assigned from the smallest y-coordinate of the horizontal ruled line. Therefore, the same number is assigned to all horizontal ruled line records having the same y coordinate.

FIG. 7 shows the detailed structure of the vertical ruled line record.

The vertical ruled line is represented 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”). Figure 1
2 will be described in detail). However, even with continuous vertical ruled lines, if the line type or color changes, 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.

Reference numeral 131 is the coordinates of the starting point of the vertical ruled line. Here, the starting point is the end point having the smaller y coordinate. A line type 132 indicates a solid line, a dotted line, a dash-dotted line, a dash-dotted line, a broken line, a long broken line, a hidden line, a double-column ruled line, a parent-child ruled line 1, a parent-child ruled line 2, a designated parent-child ruled line 1, or a designated parent-child ruled line 2. It is specified. Thirteen
3 is a line width, and 134 is a flag indicating information such as ruled line lock. Reference numeral 135 is information regarding rounded corners. 136, 1
37 is information regarding the color of the line. 138 is the length of the line. Reference numeral 139 is a pointer to the next vertical ruled line record, which is NULL when the next record does not exist.

Reference numeral 140 is a pointer to the previous vertical ruled line record, which is NULL for the first record. The vertical ruled line record forms a list structure by the information of 139 and 140, and exists in the portions indicated by 30 to 33 in FIG. Reference numeral 141 is a pointer to the leading delimiter information of this vertical ruled line. Reference numeral 142 is a serial number sequentially assigned from the smallest x-coordinate of the horizontal ruled line. Therefore, the same number is assigned to all vertical ruled line records having the same x coordinate.

FIG. 8 shows a detailed structure of cell information.

A cell is a rectangular area completely surrounded by vertical and horizontal ruled lines. 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. In addition, the cell is a normal cell containing a character string,
There are two types of formula cells that contain calculation formulas.

Reference numeral 151 is a pointer to the horizontal ruled line record of the leftmost ruled line among the horizontal ruled lines forming the upper side of the cell. Reference numeral 152 is a pointer to the vertical ruled line record of the uppermost vertical ruled line among the vertical ruled lines forming the left side of the cell. 153 is the upper left coordinate of the cell, and 154 is the cell size. 155 is the number of horizontal ruled lines forming the upper side of the cell, and 156 is rounded corner information of each of the four corners of the cell. 1
57 is information obtained by obtaining the maximum line width of each side based on the information of the ruled lines forming each of the four sides of the cell. Reference numeral 158 is a character record (described in detail with reference to FIG. 9) that is information about characters belonging to the cell. Reference numeral 159 is a pointer to information such as the character position of the result of typesetting the character string in the cell. Reference numeral 160 is a pointer that is valid only when the cell is a normal cell, and that indicates the value of the cell to be passed to the calculation processing program when the cell becomes a calculation target during calculation. Reference numeral 161 is a pointer to the next cell information, which is NULL when the next information does not exist. 162 is a pointer to the previous cell information, which is NULL in the case of the head information. The cell information forms a list structure by the information of 161, 162, and exists in the portions indicated by 34 to 35 in FIG.

FIG. 9 shows the detailed structure of the character record.

The character record is information about the character in the cell which has a one-to-one correspondence with the cell information and is held in the cell information.

Reference numeral 171 is an area for storing the number of bytes of the entire character record when the table data is stored as a file, and is not used during editing. Reference numeral 172 is a flag indicating cell lock, heading designation, and cell type (normal or formula). Reference numeral 173 indicates a group number when cells are grouped. Reference numeral 174 is valid only in the first member cell of the group and indicates the number of group members. 175 is valid only when the cells are grouped, and indicates the number of member in the group. Here, the group is
In a processing mode unique to a table group in which a plurality of cells are regarded as one cell by grouping, the character string input thereto is sequentially assigned to each cell according to the group member number from the head member of the group and displayed.

Reference numeral 176 is a cell address, and the formula serves as an index for identifying the cell during the calculation process. Reference numeral 177 is a pointer to cell attribute information (described in detail with reference to FIG. 10). Reference numeral 179 is information specifying the leading horizontal ruled line of the cell to which this character record belongs. Reference numeral 179 is information for managing a character string for each member cell in the case of grouped cells. Reference numeral 180 denotes a character data count, which indicates the size of the entire area of 183 for a normal cell and 185 for a formula cell by the number of characters. Similarly to 180, 181 indicates the size of the character data buffer by the number of characters. Reference numeral 182 is a pointer to the character data buffer.

When the cell is a normal cell, the character data buffer is a character string (character editing command and character code).
It is occupied by only 184.

When the cell is a formula cell, the character data buffer is divided into parts 186 to 191. 187 shows the calculation result as an option cell attribute (described in detail with reference to FIG. 11).
The character string (command and character code of character editing process) processed by referring to the calculated value display attribute held as 186 is the number of characters. Reference numeral 188 is an area for storing information on calculation results, and 189 is an area for storing information necessary for calculation, which is used by the calculation processing program during processing. 191 is the formula body held by the cell, which is the data in reverse Polish format.
0 is the number of characters.

FIG. 10 shows the detailed structure of the cell attribute information.

The cell attribute information must be 1 for each character record.
There is a case where one cell attribute information is referred to by a plurality of character records with only one piece of information.

201 is the number of bytes of the entire cell attribute information, and 202 is a value indicating how many character records refer to the cell information. A set flag 203 is information such as a set direction. Reference numeral 204 is a character flag, which is information such as a character type (full-width, half-width, etc.) and alignment of top, bottom, left, and right. Reference numeral 205 is standard typeface information about a typeface used when Japanese is input in a cell, 206 is European typeface information about a typeface used when inputting alphanumeric characters in a cell, and 207 is information about a background color of a character. Two
Reference numeral 08 denotes a space between lines, 209 a left margin, 210 a right margin, 211 an upper margin, and 212 a lower margin. Reference numeral 213 is information indicating which type of optional attribute this cell attribute has. The option attributes not included here use default option attributes. Reference numeral 214 is cell face type information, 215 is the number of indented characters, 216 is the number of indented characters, and 217 is a baseline adjustment amount for neatly displaying mixed sentences of Japanese and European sentences. Reference numeral 218 is a pointer to the option attribute information held by this cell attribute, and is N if no option attribute is held.
It is ULL.

FIG. 11 shows the detailed structure of the option attribute information.

The option attribute is held in the form of one option attribute list for one cell attribute information. Here, the option attribute list is a list in which the option attribute information is connected as indicated by 224 by the type specified by the option attribute flag 213 of the cell attribute information. In the option attribute information, 221 indicates the data type of the option attribute. The types of the option attributes are Japanese emphasized typefaces 1-5, European emphasized typefaces 1-5,
There are 12 types of formula calculation value display attributes and tab information. 222
Is the data body of the option attribute, in which the data in the format according to the type is stored. The size of the data is the same for each type for convenience of processing. 223 is a pointer to the next option attribute information. Contains NULL if there is no next optional attribute.

FIG. 12 shows the detailed structure of the break information.

Reference numeral 231 is a pointer to the next break information, which is NULL when the next information does not exist. Reference numeral 232 is a pointer to the previous break information, which is NULL in the case of the top information. Cell information is 23
A list structure is formed by the information of 1 and 232.
It exists in the part shown by 6-27. Reference numeral 233 is a flag indicating the crossing direction, 234 is the coordinate of the break position, and 235 is a pointer to the ruled line record of the intersecting partner.

FIG. 13 shows the detailed structure of the selected ruled line information.

The selected ruled line information header is information about the selected ruled line and is held in the work area management information 81 in the local data area. Reference numeral 241 indicates the upper left coordinate of the entire ruled line range being selected, and 242 indicates the lower right coordinate thereof. 243 is
A value indicating how many pieces of selected ruled line information can be stored in the memory reserved for the arrangement of the selected ruled line information. When the area is insufficient, a new area is reserved. 244 is the number of ruled lines being selected, and 245 is the start address of the array of selected ruled line information. Each selected ruled line information is composed of the contents indicated by 246 to 249. A ruled line type 246 is any of vertical, horizontal, and diagonal ruled lines. Reference numeral 247 is a pointer to the ruled line record. 248 and 249 are information for specifying a part of the ruled line (in the unit of division) when the part is selected.

FIG. 14 shows the detailed structure of the selected cell information.

The selected cell information header is information regarding the selected cell and is held in the work area management information 82 in the local data area. 251 is a value indicating how many pieces of selection ruled line information can be stored in the memory reserved for the arrangement of the selected cell information. When the area is insufficient, a new area is reserved. 252 is the number of selected cells, and 253 is the start address of the array of selected cell information. Each selected cell information is composed of the contents shown in 254 to 255. 25
Reference numeral 4 is a work flag used during processing, and 255 is a pointer to cell information.

<Formula Cell Symbol Display Processing> FIG. 15 is a diagram for explaining the formula cell symbol display processing. The formula cell symbol display process will be described with reference to FIG.

In FIG. 15, two cells indicated by formula cells with arrows are formula cells, and the other cells are normal cells. Figure 15
As shown in, the formula cell has a "formula cell symbol" displayed at the upper right of the cell. No equivalent is displayed in a normal cell. This difference allows the operator to determine on the display which cell is the formula cell.

FIG. 16 is a flowchart of the formula cell symbol display process in this embodiment. In FIG.
First, in step S1, it is determined whether or not the display processing of all cells has been completed, and if completed, the formula cell symbol display processing is ended. Otherwise, in step S2 it is checked whether the current cell is a formula cell. If it is a formula cell, a formula cell symbol is displayed in the cell in step S3, and the process returns to step S1. If it is not a formula cell, the formula cell symbol is not displayed and the process returns to step S1.

FIG. 17 is a diagram showing an example of identifying and displaying a formula cell. In FIG. 15, the formula cell symbol is displayed in a dark gray rectangle as shown in (a) of FIG. 17, but (b), (c), (d) -1, It may be a circle such as (d) -2, a star, or a triangle. In particular, by changing the color of the inside of the symbol and the color of the outline as in (d) -2, it becomes possible to easily distinguish even if the background and the symbol have the same color. The display position of the formula cell symbol may be the upper left, the lower left, or the upper right. Further, as in (e), gray display (other colors may be used) inside the rectangular boundary of the cell may indicate that the cell is a formula cell.

Further, a process of designating "display / not display formula cell symbol" can be added to the above embodiment. In this case, if "display the formula cell symbol" is designated, the cell symbol is displayed as in the above embodiment, whereas if "formula cell symbol is not displayed" is designated, the cell symbol is not displayed. FIG. 18 shows an example of an environment setting panel for making such a designation. Here, the button (A) is in the “display” state.

FIG. 19 shows a flowchart in the case where the process of designating "display / not display formula cell symbol" is added. In step S4, it is checked whether or not the mode is a mode in which the formula cell symbol is displayed.
Go to the formula cell symbol display process of 5 and subsequent steps, and if not, end. The formula cell symbol display process after step S5 is the same as step S1 to step S3 in FIG.

In the above embodiment, the formula cell symbol is unconditionally displayed in all formula cells. However, by changing the symbol of the cursor that moves with PD5, the cell in which the cursor exists It is also possible to distinguish between formula cells and ordinary cells. in this case,
When the cursor is on the formula cell, it is possible to distinguish between the formula cell and the normal cell by switching to a cursor having a shape different from the shape of the normal cursor.

FIG. 20 shows an example of the shape of a cursor for identifying a cell. The arrow in (a) of FIG. 20 is a normal cursor shape, and the star shape of (b) in FIG. 20 is a cursor shape when it is on the formula cell. Identification of a formula cell with a cursor will be described with reference to FIG. In the figure, "1
It is assumed that cells in which "1", "100", and "541" are displayed are formula cells. In this case, on cells other than these,
Or the cursor shape when there is a cursor other than the cell,
The shape (arrow) of FIG. 20A is used, and when the cursor is on the above formula cell, the shape is switched to the shape (star) of FIG. 20B. Even in such a case, as shown in (e) of FIG. 20, by displaying in gray inside the boundary of the cell rectangle, the cursor is displayed, and it is determined whether or not the cell is a formula cell depending on the display color and the hatching pattern. It may be possible to distinguish between the two.

FIG. 22 is a flowchart of the cursor display processing when switching the cursor shape. When updating the display of the cursor, such as when the cursor moves, the previous cursor is erased in step S8, and the next cursor position is calculated in step S9. Then, when the coordinates are within the table cell and the cell is a formula cell (step S10), the cursor is displayed with the formula cell cursor having the shape of FIG. 20B (step S11),
finish. If it is not in the formula cell, a normal cursor is displayed in step S12, and the process ends.

The present invention is not limited to a single device, and may be realized by a system composed of a plurality of devices or by supplying a program to the device or system.

[0073]

As described above, according to the present invention,
Formula cells and normal cells can be clearly identified on the display,
It is possible to prevent wrong operation by mistakenly identifying the type of cell,
Further, there is an effect that the user can instruct the processing suitable for the cell type without making a mistake.

[Brief description of drawings]

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

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

FIG. 3 is a diagram showing a detailed configuration of a table control information section.

FIG. 4 is a diagram showing a detailed configuration of work management information.

FIG. 5 is a diagram showing a detailed configuration of a diagonal ruled line record.

FIG. 6 is a diagram showing a detailed configuration of a horizontal ruled line record.

FIG. 7 is a diagram showing a detailed configuration of a vertical ruled line record.

FIG. 8 is a diagram showing a detailed configuration of cell information.

FIG. 9 is a diagram showing a detailed configuration of a character record.

FIG. 10 is a diagram showing a detailed configuration of cell attribute information.

FIG. 11 is a diagram showing a detailed configuration of option attribute information.

FIG. 12 is a diagram showing a detailed configuration of break information.

FIG. 13 is a diagram showing a detailed configuration of selected ruled line information.

FIG. 14 is a diagram showing a detailed configuration of selected cell information.

FIG. 15 is a diagram illustrating a formula cell symbol display process.

FIG. 16 is a flowchart of a formula cell symbol display process.

FIG. 17 is a diagram showing an example of identification display of a formula cell.

FIG. 18 is a diagram showing an example of an environment setting panel.

FIG. 19 is a flowchart of a formula cell symbol display process of another embodiment.

FIG. 20 is a diagram showing an example of a shape of a cursor for identifying a cell.

FIG. 21 is a diagram illustrating identification of a formula cell by a cursor.

FIG. 22 is a flowchart of cursor display processing.

[Explanation of symbols]

 1 CRT display device 2 VRAM 3 BMU 4 keyboard 5 PD 6 CPU 7 ROM 8 RAM 9 search unit 10 FDD 11 Net-I / F 12 bus

Claims (10)

[Claims] 1. Storage means for storing a table including a plurality of cells, determination means for determining whether or not an expression is defined in each cell of the table stored in the storage means, and storage in the storage means A table processing device for displaying a displayed table, the display control device displaying a cell whose expression is defined by the identification device so as to be distinguishable from other cells. . 2. The table according to claim 1, wherein the display control means controls to display a specific symbol in a cell for which the expression is defined by the identification means. Processing equipment. 3. The table processing device according to claim 2, wherein the specific symbol is controlled so that the contour and the interior are displayed in different display colors. 4. The display control means controls the boundary of a cell for which an expression is defined by the identification means to be displayed so as to be distinguished from other cells.
Table processing device described. 5. Display control means for displaying a table including a plurality of cells, cursor display means for displaying a cursor for designating a cell of the table displayed by the display control means, and display by the cursor display means. Discriminating means for discriminating whether or not a formula is defined in the cell designated by the cursor, and changing the display form of the cursor when the formula is defined by the discriminating means. A table processing device comprising: 6. A storage step of storing a table including a plurality of cells, a determination step of determining whether or not an expression is defined in each cell of the table stored in the storage step, and a storage step in the storage step. When displaying the displayed table, the table processing method comprising a display control step of displaying the cell for which the formula is defined by the determination step, so as to be distinguishable from other cells. . 7. The table according to claim 6, wherein the display control step controls so as to display a specific symbol in a cell for which a formula is defined by the discrimination process. Processing method. 8. The table processing method according to claim 7, wherein the specific symbol is controlled so that the contour and the interior are displayed in different display colors. 9. The display control step is controlled so that a boundary of a cell for which a formula is defined by the discrimination step is discriminated and displayed from other cells.
Table processing method described. 10. A display control step of displaying a table including a plurality of cells, a cursor display step of displaying a cursor for designating a cell of the table displayed by the display control step, and a display of the cursor display step. Determining step for determining whether or not a formula is defined in the cell designated by the cursor that has been defined, and changing the display form of the cursor when the formula is defined by the determining step A table processing method comprising: a process.