KR100302306B1 - Table data processing device - Google Patents

Abstract

According to the present invention, as image data is stored as cell data of table data, operations and processes (e.g., image processing of image data or output of image data to designated cells) for processing image data into cell data can be simplified. An apparatus and method for processing a table are provided.

In addition, the table data output processing includes determining whether the type of the designated cell corresponds to a numerical value, a text, an image, or an audio signal, and depending on the type of the cell in which the determined data is determined. And a process of outputting the read data to the output area of the designated cell.

Description

Table data processing unit

In a conventional table processing apparatus having a function of creating a table in a cell unit by merging into a device such as a computer system, the data input forms forming a table cell are limited to two types, numerical data and character data.

Thus, if numerical data and text data (cell data) are mixed with another form of data in the table (eg image or audio data), the final form of the data is cell data in the structure and operation of the data. It is different from the form of. That is, the operation of editing normal cell data is limited to the cell frame. On the other hand, in the case of representing the image data in the table, an arbitrary area irrespective of the cell frame is set as the image data frame and operation of desired image data already existing in the image data frame is required. That is, the image data frame and the image data are processed differently from the operation method and data structure for processing numerical data and character data of a table.

Therefore, the conventional table processing apparatus described above has the following problems. In order to merge data other than numerical data or text data (that is, image or audio data) into a table, it is required to be processed differently from the operation method and data structure which processed numerical data and text data. Therefore, due to this difference between image or audio data and operations for processing numerical or text data, it is not only difficult for the user to understand the operation of editing the cell data when merging the image data or the audio data in the table, but also the operation thereof. The process is complicated. That is, an operation of handling image and audio data in the table processing results in deterioration of the operability of the table processing.

The present invention relates to an apparatus and method for processing a table in units of cells constituting a table, and more particularly, to a table processing apparatus and a method capable of processing image data in units of cells in a data processing apparatus. .

1 is a block diagram of a computer system according to a first embodiment of the present invention.

FIG. 2 shows the data structure of cell data stored in the table data file of FIG.

3 is a flowchart showing an image processing process executed by the computer system of the first embodiment.

4A through 4C show an image input screen displayed through the image processing process of FIG.

FIG. 5 shows the structure of image data stored in the input data area of FIG. 2 by the image processing process of FIG.

6 is a flowchart showing a table data output process executed by the computer system of the first embodiment.

FIG. 7 illustrates an example of display data displayed by the table data output process of FIG.

8 shows the data structure of cell data processed by the computer system according to the second embodiment of the present invention.

9A to 9C show an example of an image corrected by the correction information of the cell characteristics shown in FIG.

10 is a flowchart showing a table data output process executed by the computer system of the second embodiment.

FIG. 11 shows an example of display data displayed by the table data output process of FIG.

Accordingly, it is an object of the present invention to provide at least coordinate positions, data types, and actual data on the table data sheet of individual cells in each cell included in a table data sheet in which a plurality of cells are arranged in a table format in a plurality of horizontal and vertical directions. cell information storage means for storing cell information including real data; Image file storage means for storing an image file storing image image data; When displaying the table data sheet, cell information of each cell included in the table data sheet is obtained from the cell information storage means, and the data type of the cell information for each cell information is a character value type such as a character or a numerical value or Discriminating means for discriminating whether or not it is an image type; First cell display control means for displaying a character and a numerical value stored as actual data of cell information in a cell display area in the table data sheet corresponding to cell information when determined by the discriminating means as the character value type; When it is determined that the image type is determined by the discriminating means, the image image data stored as actual data in the cell information, or the image image data stored in the image file called from the image file storage means by the image call information. There is provided a table data processing apparatus comprising second cell display control means for displaying a display image in a cell display area in the table data sheet corresponding to the cell information.

[ First Embodiment]

Referring to the configuration of the first embodiment according to the present invention with reference to Figures 1 to 7 as follows. 1 shows a block diagram of a computer system according to a first embodiment of the present invention.

In FIG. 1, the computer system 1 includes a CPU (central processing unit) 2, an input device 3, a mouse 4, a ROM 5, and a process execution memory 6 ), Table data file 7, image reader 8, printer device 9, voice converter 10, loudspeaker 11, display device 12, image file 13 And an audio file 14. The constituent means are connected by a bus 15.

The CPU 2 controls the constituent means of the computer system 1 and executes various information processing in accordance with the control program stored in the ROM 5. When executing the table processing, the CPU 2 retrieves items, numerical values and formula inputs stored in the table data file 7 by the input device 3 and the mouse 4. When executing the table data output processing, the CPU 2 determines the cell type (that is, whether the cell stores numerical data, text data, image data, or audio data) of the table designation cell. According to the cell type thus determined, the CPU 2 reads the corresponding data from the table data file 7, the image file 13, or the audio file 14, and displays the read data corresponding to the designated cell of the table. Output to the output area of (12). In addition, when executing the table determination process, the CPU 2 displays a sub-window for image determination so that the name of an image file corresponding to a cell can be specified in accordance with image determination. Bring up Further, the CPU 2 reads the image data corresponding to the specified image file name from the image file 13 performing the image data editing process and edits it to the output area of the designated cell to display the edited image in the table. The printed image. The image data determined by the image confirmation in the designated cell is stored in the input data area of the cell data shown in FIG.

The input device 13 includes function keys, numeric keys, text keys and other keys. The input device 13 outputs various command signals corresponding to a user's key input operation to the CPU 2.

The mouse 4 is a designation tool for performing an operation to supplement the input through the input device 13. The mouse 4 outputs an operation signal to the CPU 2.

The ROM 5 stores various control programs, table data output processing programs and image confirmation processing programs executed by the CPU 2.

The process execution memory 6 forms a memory area for editing the image data output from the image file 13 when the CPU 2 executes the table data output processing.

The table data file 7 into which numerical values, characters, or image data are input stores table data composed of a plurality of cell data processed by the CPU 2. The structure of the cell data stored above is shown in FIG. 2.

In FIG. 2, the cell data includes cell position coordinate data (two-dimensional coordinates (X, Y)) indicating a position of a cell in a table; Cell type data (eg, 0: numeric data, 1: text data, 2: image data, 3: voice data) indicating the type of cell data; "Direct" or "indirect" data; Cell characteristic data; And an area for storing real data (i.e., input numerical value, text, image or audio data).

Here, direct data means that image or audio data is stored in the input data area as cell data, while indirect data means that image or audio data is stored in the image file 13 or the audio file 14. . The cell characteristic data includes character size data (eg 0: 8 points, 1: 10 points), character style data (eg 0: Ming-style, 1: Gothic style), batch data. (Eg, 0: left justification, 1: center, 2: right justification) and numeric method data (0: standard, 1: 3-digit punctuation).

The image reader 8 scans the subject to be read, reads the image at a resolution determined, and stores the read image as image data in the image file 13.

The printer apparatus 9 prints the table data output via a table output process executed by the CPU 2 on a preset paper sheet.

The voice conversion device 10 converts the voice data output according to the result of the table data output processing executed by the CPU 2 when the content of the cell data in the designated cell is voice data. In addition, the voice conversion device 10 outputs the voice signal through the loudspeaker 11. A display device 12 including a CRT (cathode ray tube) displays key input and data input via the CPU 2 and displays table data.

The image file 13 is a memory for storing a plurality of image data read by the image reader 8.

The voice file 14 stores a plurality of voice data output to the cell.

Hereinafter, the operation of the first embodiment will be described in detail. First, the image determination processing executed by the computer system 1 will be described with reference to the flowchart shown in FIG.

In the image determination processing shown in FIG. 3, an image determination cell (cell coordinate C3 in this embodiment) is displayed on the display screen of the display device 12 by the determined operation of the input device 3 or the mouse 4 If specified in the table data to be made (step S1), a pull down menu including an item of "confirmation of image" is displayed on the table data as shown in FIG. 4A. When the item " image determination " is selected from the pull-down menu (step S2), a sub window for image determination is added on the table data as shown in FIG. 4B. (Step S3)

The sub-window for image confirmation includes confirmation items such as " file name ", " magnification " (XL, YL), and " cyclic " If an item of "file name" is selected here, the name of the image data file stored in the image file 13 is specified. In addition, if the item of "magnification" is selected, the display magnification of the image output to the output area at the designated cell position is specified in the X (horizontal) and Y (vertical) directions. When the item of "circulation" is selected, a fixed direction (e.g., a rotation angle of 90 degrees) of the image output to the output area of the designated cell position is specified. When the above-mentioned confirmation item is input to the sub window for image confirmation (step S4), the image data corresponding to the input file name is read from the image file 13 into the process execution memory 6 (step S5). The image data read above is edited according to the determined items such as the magnification and the cycle input in step S4. (Step S6)

Next, the edited image is output from the process execution memory 6 to the designated cell position and displayed as the output area of the designated cell C3 of the table data displayed on the display device 12 (step S7). Thus, all processing ends.

The image data displayed in the designated cell has a data structure as shown in FIG. The image data is stored in the input data area of the cell data as shown in FIG. 2 corresponding to the designated cell C3 of the table data file 7.

In Fig. 5, the image data is composed of a header information portion and an image entity portion. Here, the header information portion stores control data necessary for displaying an image such as a placement direction, a resolution, and the number of points (size) in the X and Y directions as defined in step S4. The image entity portion stores the actual data of the image data edited in step S6.

The following describes the table data output processing executed by the computer system 1 by referring to the flowchart shown in FIG.

First, when the file name of the table data displayed on the display device 12 is specified by the input device 3 or the determined operation of the mouse 4, the table data corresponding to the specified file name is sent from the table data file 7. It is recovered. By this operation, cell data of each cell constituting the recovered table data is obtained. (Step S11) The cell is included in the preset table data cell area by referring to the cell position coordinates of the cell data obtained above. (Step S12) Therefore, if the corresponding cell is not included in the preset table data cell area, this processing operation ends.

However, if the corresponding cell is included in the preset table data cell area, the type of data stored in the input data area of the cell data (i.e., the data is numerical, text, image or audio data) by referring to the cell type data set in the cell data. Is determined. (Step S13) If the cell type is found to be a numeric or character type, the numerical or character data stored in the input data area of the cell data is read out and displayed in the designated cell. S14) Then, this processing returns to step S11 again.

If the cell form is found to be an image form, it is again determined whether the image data is indirect by referring to "direct / indirect" data. (Step S15) Here, if the image data is direct data (i.e., the image) When data is stored in the input data area), the image data is read from the input data area and output to the output area of the designated cell according to the header information (display magnification, resolution and fixed direction in the X and Y directions) of the image data. (Step S18) Then, this processing returns to step S11 again.

If the image data is indirect data (ie, image data is not stored in the input data area), the image data corresponding to the image file name stored in the input data area is read from the image file 13 into the process execution memory 6. (Step S16) The image data read above is edited according to the image confirmation specified in step S4. (Step S17) The edited image data is output to the output area for display. (Step S18) Then, this The processing returns to step S11 again.

If the corresponding cell is found in the voice form in step S13, it is determined whether the voice data is indirect or not by referring to "direct / indirect" data. (Step S19) Here, if the voice data is direct data (i.e., When the voice data is stored in the input data area), the voice data is read from the input data area and output to the voice converting apparatus 10. In the voice conversion device 10, the voice data is converted into a voice signal and output through the loudspeaker 11. (Step S21) Then, this processing returns to the step S11 again.

If the voice data is indirect data (i.e., the voice data is not stored in the input data area), the voice data corresponding to the voice file name stored in the input data area is read from the voice file 14 (step S20). The audio data read out above is converted into an audio signal and output through the loudspeaker 11. (Step S21) Then, this processing returns to Step S11 again. The processing of steps S13 to S21 is repeated for all cells in the table data to output cell data to the corresponding cell. Then, if no cell exists in the table data area, the table data output process ends.

By repeatedly executing the above-described table data output processing, numerical values, characters, images, and audio data stored in advance are read in accordance with the cell type (value, text, image, or audio) set for each cell forming the table data. It is displayed and output by voice.

7 shows an example of display data displayed on the display device 12 through a table data output process. In FIG. 7, numerical or character data is displayed in cell coordinates A1 to A3 and B1 to B3, and image data is displayed in cell coordinates C1 to C3. According to the table processing function incorporated in the computer system 1 of the first embodiment, not only numerical and text data but also image data and audio data can be processed as cell data of table data. Thus, in processing the table, operations and procedures for handling image data and audio data are simplified more than in the prior art. In addition, the method of representing the cell data becomes more diversified, thereby improving the table processing function and increasing convenience.

In the above-described first embodiment, the image data or audio data is displayed or outputted as an image or audio in the output area at the designated cell position. In addition, if the animation data is previously stored in the image file 13, this can also be displayed as cell data. Furthermore, image data, audio data and animation data are processed not only individually but also in combination with each other so that the combination of these data is displayed or output as voice or image. As such, the ways of representing cell data are much more diversified.

Second Embodiment

Looking at the configuration of the second preferred embodiment according to the present invention with reference to Figures 8 to 11 as follows. Here, since the block diagram of the computer system of the second embodiment is the same as the block diagram of the computer system 1 of the first embodiment, the description of the structure and function is omitted below.

FIG. 8 shows a data structure of cell data stored in the table data file 7 of the computer system 1 shown in FIG. In FIG. 8, cell data includes cell position coordinate data (two-dimensional coordinates (X, Y)) indicating a position of a cell in a table; Cell type data (eg, 0: numeric data, 1: text data, 2: image data, 3: voice data, 4: animation data) indicating the type of cell data; Cell characteristic data; Input data (ie, input numeric, text, image or audio data); And an area for storing mathematical data for indicating how to combine numerical, image and audio data.

Herein, the cell characteristic data may include character size data (eg, 0: 8 points, 1: 10 points), character style data (eg, 0: Ming-style, 1: Gothic style), Batch data (eg, 0: left justification, 1: center, 2: right justification) and correction information (0: standard, 1: inversion, 2: mirror reflection, 3: enclosed). 9A to 9C show an example of an image based on correction information. FIG. 9A shows a case where the correction information is set to "1: inversion", where the image is inverted and displayed. 9B shows a case where the correction information is set to "2: mirror reflection", where the image is displayed as a mirror image (symmetrically). 9C shows a case where the correction information is set to "3: enclosed", where the image is displayed as enclosed (frame highlighted).

The modification data shown in FIG. 8 represents the content of data obtained by combining image data and audio data with a simple expression. For example, the operator " + " means one bit OR processing of the synthesized picture and continuous generation of left and right cell voices. The operator "*" means one-bit AND processing of the combined picture.

Hereinafter, the operation of the second embodiment will be described in detail.

Referring to the flowchart shown in FIG. 10, the table data output processing executed by the computer system of the second embodiment is as follows.

First, when the file name of the table data displayed on the display device 12 is specified by the input device 3 or the determined operation of the mouse 4, the table data corresponding to the specified file name is sent from the table data file 7. It is recovered. By this operation, cell data of each cell constituting the recovered table data is obtained. (Step S31) The cell is included in the preset table data cell area by referring to the cell position coordinates of the cell data obtained above. (Step S32) Thus, if the corresponding cell is not included in the preset table data cell area, this processing operation ends.

However, if the corresponding cell is included in the preset table data cell area, the type of data stored in the input data area of the cell data (i.e., the data is numerical, text, image or audio data) by referring to the cell type data set in the cell data. Which type is it?) (Step S33).

If the cell type is found to be a character type, the character data stored in the input data area of the cell data is read out to the output area of the designated cell according to the item set in the cell characteristics (character size, character style, arrangement and correction information). Is displayed. Then, this processing returns to step S31 again.

If the cell type is found to be a numerical value, it is determined whether or not the formula data is set in the designated cell. (Step S34) If the formula data is not set in the cell, go to step S38 to enter the input data area of the cell. The stored numerical data is read and displayed as an output area of the designated cell in the item set in the cell characteristics (text size, text style, layout and correction information). Then, this processing returns to step S31 again.

If the above formula data is set in the designated cell, the numerical data in each cell included in the above formula is read (step S35), and the calculation of the numerical data of each cell is performed according to the above formula (step S36). The result obtained by the operation is stored as numerical data in the input data area of the corresponding cell. (Step S37) The numerical data stored in the input data area is read and the cell characteristics (character size, character style, arrangement and correction information) are read. In accordance with the item set in step 1), the display area is displayed as an output area of the designated cell. (Step S38) Then, this processing returns to Step S31 again.

If the cell form is found to be an image form in step S33, it is determined whether or not the formula data is set in the designated cell. Image data stored in the area is read into the process execution memory 6. Then, the read image data undergoes a correction process in accordance with the correction information set in the cell characteristics of the cell, and the thus modified image pattern is stored in the process execution memory 6 (step S42).

Next, it is checked whether numerical data or text data is stored in the input data area. (Step S43) If numerical data or text data is not stored in the input data area, go to step S47 to execute the corrected image pattern process. It reads from the memory 6 and stores it as input data in the data input area of the corresponding cell.

The corrected image stored in the input data area is read out and displayed in the output area of the corresponding cell. (Step S45) Then, this processing returns to Step S31 again.

If numerical or text data is stored in the input data area, the numerical or text data is synthesized on the modified image pattern and the synthesized data is stored as input data in the input data area of the cell. (Step S44) The input The composite data stored in the data area is read out and displayed on the output area of the cell. Then, this processing returns to step S31 again.

When the formula data is set in the specified cell in step S39, the image data in each cell included in the formula is read (step S40) and the image data of the corresponding cell is patterned (step S41). The image undergoes a correction process in accordance with the correction information set in the cell characteristics of the cell, and the corrected image pattern is stored in the process execution memory 6. (Step S42) Then, numerical or text data is stored in the input data area of the cell. It is checked whether or not it is stored (step S43).

If no numerical or character data is stored, the flow advances to step S47 where the corrected image pattern is stored as input data in the input data area of the corresponding cell. The corrected image is read out from the input data area and displayed in the cell's output area. (Step S45) Then, this processing returns to Step S31 again.

An example of an image data synthesizing process using an equation will now be described in detail by referring to the table data shown in FIG. 11. In the example of the table data shown in FIG. 11, the image data is displayed at cell coordinates A1 and B1, respectively.

When the formula " D1 = A1 + B1 " is set by using the cell coordinates A1 and B1 as variables as shown in FIG. It is indicated at the coordinate D1. Further, when the formula " D3 = A1 + (2 × B1) " is set as shown in Fig. 11, the image of the cell coordinate A1 is added (combined) to the B1 image enlarged twice and the synthesized image It is displayed in cell coordinate D3. The following is an example when another formula is set. When the expression "D3 = A1 x (-2)" is set, the 1/2 A1 image is displayed in the cell coordinate D3. When the expression "D3 = A1 + 10" is set, the A1 image shifted to the right of 10-dot is displayed in the cell coordinate D3. When the expression "D3 = A1-10" is set, the A1 image shifted to the left of 10-dots is displayed in the cell coordinate D3. When the expression "D3 = INV (A1)" is set, the pattern-inverted A1 image is displayed in the cell coordinate D3.

Voice data in cells can also be synthesized using equations in the same way. As described above, as the table data output process is repeatedly executed, a cell type (numerical, text, image or audio) in which previously stored numerical, text, image and audio cell data is set for each cell constituting the table data. It is read according to the audio output or displayed.

According to the table processing function incorporated in the computer system of the second embodiment, not only numerical and text data but also image data and audio data can be processed as cell data of table data, and various composition patterns of cell data can be presented and set. Thus, in processing the table, operations and procedures for handling image data and audio data are simplified more than in the prior art. In addition, the method of representing the cell data becomes more diversified, thereby improving the table processing function and increasing convenience.

In the second embodiment described above, the image data, the audio data or the composite data thereof is output or displayed as an image or audio in the output area of the designated cell position. In addition, if the animation data is previously stored in the image file 13, it can also be synthesized and displayed as cell data. In the first and second embodiments, image data is output as display data in table data displayed on the display device 12. Further, the image data can be output as printer data through the printer apparatus 9.

In the above embodiments, various control programs, table data output processing programs and image confirmation processing programs are stored in the ROM 5 shown in FIG. However, these programs can be stored in another memory device having a memory medium in which programs and data are stored in advance. The memory medium may include a magnetic or optical memory medium or a semiconductor memory. The memory medium may be fixedly coupled to the memory device or coupled to or separated from each other. The program or data is supplied to and stored in a memory medium from another device connected to the memory device via a communication line or the like. Since a memory device including a memory medium is included in another device connected to the memory device via a communication line, programs and data stored in the memory medium may be used through the device of the present invention by passing through a communication line. The memory medium is a program for achieving the function indicated in the flowcharts shown in the attached drawings 3, 6 and 10 showing the operation of the first and second embodiments of the present invention in the form of a program readable by the CPU. Save it.

Claims (5)

A table data processing apparatus for displaying a table data sheet in which a plurality of cells are arranged in a horizontal and vertical direction in a table form, Cell information storage means for storing cell information including at least coordinate positions, data types, and real data on the table data sheet of each cell in each cell included in the table data sheet; Image file storage means for storing an image file storing image image data; When the table data sheet is to be displayed, the cell information of each cell included in the table data sheet is obtained from the cell information storage means, and the data type of the cell information is a character value type such as a character or a numerical value for each cell information. Or discriminating means for discriminating whether or not it is an image type; First cell display control means for displaying a character and a numerical value stored as actual data of cell information in a cell display area in the table data sheet corresponding to cell information when it is determined by the discriminating means as the character value type; When it is determined that the image type is determined by the discriminating means, the image image data stored as actual data in the cell information, or the image image data stored in the image file called from the image file storage means by the image call information. And second cell display control means for displaying a display image in a cell display area in the table data sheet corresponding to the cell information. The method of claim 1, The cell information whose data type is image type further includes image editing information such as image output magnification or image rotation at the time of image output, The second cell display control means includes means for displaying a display image subjected to image output magnification or image rotation according to the image editing information when displaying the display image based on the image image data in the cell display area; Table data processing device characterized in that. The method of claim 1, The cell information of which the data type is an image type further includes image formula information such as inversion and current image about the image, The second cell display control means includes means for displaying a display image subjected to image modification on the original display image according to the image modification information when displaying the display image based on the image image data in the cell display area; Table data processing apparatus, characterized in that. A table data processing apparatus for displaying a table data sheet in which a plurality of cells are arranged in a horizontal and vertical direction in a table form, Cell information storage means for storing cell information including at least coordinate positions on the table sheet of individual cells and output data to be output in a cell in each cell included in the table data sheet; Image file storage means for storing an image file storing image image data; Setting means for arbitrarily setting the correspondence of the image image data of the image file stored in the image file storage means to a cell arbitrarily designated among a plurality of cells included in the table data sheet; By the correspondence setting of the image image data by the setting means, the image call information for calling the image file storing the image image data or image image data of the setting is stored in the cell information corresponding to the designated cell. Cell information updating means for updating information; When displaying the table data sheet, the cell information of each cell included in the table data sheet is obtained from the cell information storage means, and when the image image data or the image call information is stored in the cell information, the image in the cell information. A cell for displaying a display image by image data or image image data stored in an image file called out from the image file storage means by the image call information in a cell display area in the table data sheet corresponding to the cell information. Table data processing apparatus comprising a display control means. A table data processing apparatus for displaying a table data sheet in which a plurality of cells are arranged in a horizontal and vertical direction in a table form, Cell information storage means for storing cell information including at least coordinate positions on the table data sheet of individual cells and output data to be outputted in a cell in each cell included in the table data sheet; File storage means for storing an image file storing image image data or an audio file storing an audio file; Setting means for arbitrarily setting the correspondence of the image file or the audio file stored in the file storage means for a cell arbitrarily designated among a plurality of cells included in the table data sheet; A cell for updating the cell information by storing the file call information for calling the image file or the audio file of the setting in the cell information corresponding to the designated cell by the corresponding setting of the image file or the audio file by the setting means Information updating means, When the cell information of the cell designated by the cell designation in the table data sheet is obtained from the cell information storage means, and the file call information is stored in cell information, the file corresponding to the file storage means by the file call information. And cell control means for displaying a display image by the image image data stored in the called image file or outputting the audio by the voice data stored in the called audio file. Device.

Images