JPH0778210A - Device and method for data processing - Google Patents

Abstract

PURPOSE:To effectively use a table calculation edit device by discriminating whether or not the effective number of digits of detected numeric value data exceeds the prescribed effective number of digits, and making a digit part exceeding the prescribed effective number of digits of numeric value data discriminated that whose effective number of digits exceeds the prescribed effective number of digits coincide with it by applying rounding processing. CONSTITUTION:It is discriminated whether or not the effective number of digits of the numeric data stored in table data to be converted is larger than that of the numeric data generated after conversion i.e., it is discriminated whether or not it is larger by comparing with the effective number of digits that can be handled in a table calculation application to process the table data after conversion. When the former is larger than the latter, the table data converted by rounding off the numeric value of digit larger than the effective number of digits of the numeric data generated after conversion is generated in PMEM3. Conversion table data generated in the PMEM 3 is written on an HD 15 and an FD 16, then, conversion processing is completed. In this way, the table calculation edit device can be effectively used without performing wasteful processing.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to inputting, storing and displaying numerical data or formula data, and performing arithmetic processing using the input numerical data or formula data, or spreadsheets in other formats. The present invention relates to a numerical data processing device such as a spreadsheet device for converting data.

[0002]

2. Description of the Related Art Conventionally, in this type of apparatus, when the number of significant digits of the numerical data to be fetched into the apparatus is larger than the number of significant digits which can be processed by the apparatus itself, this numerical data is not fetched. Alternatively, a value outside the significant digits that can be handled by the device itself is unconditionally truncated, and only a value within the significant digits is fetched.

Conventionally, in this type of apparatus, when the spreadsheet data of another format is converted and input, and when the spreadsheet data is converted to another format and output, the formula data Both the calculation result data of the formula and the formula were targeted for conversion.

Conventionally, in this type of apparatus, table data having only a table sheet and no data in any cell (for example, table data of 2 rows and 2 columns as shown in FIG. 16).
When converting or copying, the table data was created with only the table sheet and no data in any cell.

[0005]

However, of the above-mentioned conventional apparatuses, if a numerical value having a larger number of significant digits than the number of significant digits that can be handled by the present spreadsheet apparatus is input, the numerical value data cannot be accepted. However, there was a problem that the numerical data had to be input again.
In addition, since the values outside the number of significant digits that can be handled by this spreadsheet were unconditionally rounded down and only the values within the number of significant digits were taken in, it was converted to a value that the user did not want, and the numerical data desired by the user There was a problem that you had to re-enter.

Further, in the above-mentioned device, when spreadsheet data created by another spreadsheet device or another spreadsheet application is converted and input, the same formula is used for another spreadsheet device or another spreadsheet application. Since the execution contents are different, when the formula recalculation is executed after the spreadsheet data conversion, the calculation result of the formula will be different, and the user will check the calculation result of each formula and calculate the formula. If the result is different, there was a problem that you had to re-input to obtain the desired result. Similarly, when the spreadsheet data is converted and output, and is displayed or edited by another spreadsheet editing device or other spreadsheet application, the user inspects the calculation result of each equation and calculates the equation in the same manner. There was a problem in that if the results were different, it was necessary to re-enter to obtain the desired result.

For example, as shown in FIG. 9, on a certain spreadsheet application, the formula "weekd" is added to the cell 1A in 2 rows and 2 columns.
It is assumed that there is spreadsheet data in which ay (“1993/06/13”) ”and the calculation result“ 0 ”of the formula are stored.
At this time, the function weekday returns the day of the week given by the parameter with Sunday being 0. When this spreadsheet data is converted, recalculated and displayed on another spreadsheet application, the function weekday in this spreadsheet application returns the day of the week given by the parameter as 0 for Monday. Therefore, there is a problem that 6 is displayed in the cell 1A as shown in FIG.

Further, in the above-mentioned apparatus, since table data whose data is not registered in any cell is copied or converted, there is a problem that a wasteful processing time is required.

[0009]

In order to solve the above-mentioned problems, in the present invention, a data processing device is provided with a calculating means for calculating numerical data having a predetermined number of significant digits, a reading means for reading table data, Detecting means for detecting numerical data from the table data read by the reading means; judging means for judging whether the number of significant digits of the numerical data detected by the detecting means is larger than the predetermined number of significant digits; The discriminating means includes a converting means for rounding the digit portion of the numerical data determined to be larger than the predetermined effective digit number so as to match the effective digit number of the numerical data with the predetermined effective digit number. .

According to another aspect of the present invention, the data processing device includes an input means for inputting a calculation formula, a calculation means for calculating the calculation formula input by the input means, and the input means. The file includes a storage unit for storing the input calculation formula and a calculation result of the calculation unit by the calculation unit as one file, and a file processing unit for copying or converting the file stored in the storage unit. The processing means excludes the expression in the file from the processing target and performs copying or conversion.

According to another aspect of the present invention, in the data processing device, cell data storage means for storing data corresponding to each cell of the matrix format table, and data stored in the cell data storage means. Table data creating means for creating table data based on the table data, table data storing means for storing the table data created by the table data creating means, and copying or converting the table data stored in the table data storing means Table data processing means, determination means for determining whether or not data is stored in the cell data storage means corresponding to any cell of the table data stored in the table data storage means, and the determination means A control means for prohibiting the processing by the table data processing means when it is determined that no data is stored in the cell data storage means for any cell. That.

According to another aspect of the present invention, in a data processing device for calculating numerical data having a predetermined number of significant digits, table data is read and numerical data is detected from the read table data. Determining whether the number of significant digits of the detected numerical data is greater than the predetermined number of significant digits,
It is characterized in that a digit portion exceeding the predetermined effective digit number of the numerical data determined to be larger than the predetermined digit number is rounded so that the effective digit number of the numerical data coincides with the predetermined effective digit number.

According to another aspect of the present invention, in the data processing method, a calculation formula is input, the calculation of the input calculation formula is executed, and the input calculation formula and the calculation formula The result of the calculation is stored in a memory as one file, and when the file stored in the memory is copied or converted, the expression in the file is excluded from the processing target and the copying or conversion is performed. .

According to another aspect of the present invention, in the data processing method, table data is created based on the data stored in the cell data memory and corresponding to each cell of the matrix table. Stored table data in the table data memory, instructing copying or conversion of the table data stored in the table data memory, and receiving the instruction, any of the table data stored in the table data memory It is determined whether or not data is stored in the cell data memory corresponding to the cell, and when it is determined that the data is not stored in the cell data memory for any of the cells, an instruction is issued. It is characterized in that prohibited copying or conversion is prohibited.

[0015]

In the structure of the present invention, when the detecting means detects the numerical data from the table data read by the reading means, the discriminating means determines that the effective digit number of the detected numerical data is greater than the predetermined effective digit number. It is determined whether or not it is large, and the digit portion exceeding the predetermined effective digit number of the numerical data determined to be large is rounded by the converting means to make the effective digit number of the numerical data coincide with the predetermined effective digit number. .

In another configuration of the present invention, the calculation formula input by the input unit and the calculation result of the calculation formula by the calculation unit are stored as one file in the storage unit, and the file processing unit stores the storage. When copying or converting the file stored in the means, the expression in the file is excluded from the processing target and the copying or conversion is performed.

In another configuration of the present invention, the table data created by the table data creating means based on the data stored in the cell data storage means is stored in the table data storage means, and the table data storage means stores the table data in the table data storage means. When the stored table data is copied or converted to the table data processing means, data is stored in the cell data storage means in correspondence with any cell of the table data stored in the table data storage means. If it is determined that no data is stored in the cell data storage means for any cell, the control means prohibits the processing by the table data processing means.

According to another aspect of the present invention, in a data processing device for calculating numerical data having a predetermined number of significant digits, table data is read and numerical data is detected from the read table data. Determining whether the number of significant digits of the detected numerical data is greater than the predetermined number of significant digits,
A digit portion exceeding the predetermined effective digit number of the numerical data determined to be larger in the determination is rounded to match the effective digit number of the numerical data with the predetermined effective digit number.

In another configuration of the present invention, in the data processing method, a calculation formula is input, the calculation of the input calculation formula is executed, and the input calculation formula and the calculation of the calculation formula are performed. The result and are stored in a memory as one file, and when the file stored in the memory is copied or converted, the expression in the file is excluded from the processing target and the copy or conversion is performed.

According to another aspect of the present invention, in the data processing method, the table data is created based on the data stored in the cell data memory and corresponding to each cell of the matrix table. Stored table data in the table data memory, instructing copying or conversion of the table data stored in the table data memory, and receiving the instruction, any of the table data stored in the table data memory It is determined whether or not data is stored in the cell data memory corresponding to the cell, and when it is determined that the data is not stored in the cell data memory for any of the cells, an instruction is issued. Prohibited copying or conversion.

[0021]

Embodiments of the present invention will be described below in detail with reference to the accompanying drawings. It should be noted that, as long as the functions of the present invention are executed, it may be a single device, a system composed of a plurality of devices, or a system in which processing is performed via a network such as a LAN. It goes without saying that the present invention is applied.

FIG. 1 is a system block diagram of a spreadsheet system according to an embodiment of the present invention. Reference numeral 1 is a system bus, and the respective constituent blocks described below are connected to this system bus. 2 is a CPU (Centert
Al processing Unit), which controls each part of the apparatus and executes various processes such as calculation and judgment. Three
Is a program memory (hereinafter referred to as PMEM), and various programs for editing processing, including processing corresponding to a flowchart described later, are appropriately selected / read from the hard disk 14. The program of PMEM3 is CP
Execute in U2. Further, the data input from the keyboard 8 is stored as code information in the PMEM 3 which is also a text memory.

Reference numeral 4 is an image memory (hereinafter referred to as IMEM), 5 is an image scanner, 6 is an image input / output control unit, 7 is a printer, and image data read from the image scanner 5 is expanded in the IMEM 4. After that, it is expanded on the VRAM 11 and displayed on the CRT 13.
Also, the print image is IME as bitmap data.
After being expanded to M4, it is output to the printer 7 under the control of the image input / output control unit 6.

An input control unit 8 is connected to an input device such as a keyboard 9 and a pointing device (hereinafter referred to as PD) 10. The operator operates the keyboard 9 to issue a system operation command and the like. Also P
D10 is for selecting and instructing image information, graphic data, character data, and numerical data on the CRT 13, and a mouse is used in this embodiment. This gives C
The mouse cursor on the RT 13 is arbitrarily moved in the X and Y directions to perform menu selection, image data, graphic data, character data, numerical data, formula data, and ruled line data.

11 is a video image memory (hereinafter referred to as V
(Referred to as RAM), 12 is a display output controller, and 13 is a CRT.
Is. The data displayed on the CRT 13 is VRAM11.
It is developed as bitmap data above. For example, in the case of graphic data, a graphic pattern corresponding to the position and attribute information is developed on the VRAM 11, and
By software control, a cursor can be directly generated in the display area of the VRAM 11 for display.

Reference numeral 14 is an external storage device control unit, and 15 and 16 are data file disks for storing image data, graphic data, character data, numerical data, etc. For example, 15 is a hard disk (hereinafter referred to as HD). ) And 1
Reference numeral 6 is a floppy disk (hereinafter referred to as FD).

FIG. 2 is an external view of a spreadsheet system according to an embodiment of the present invention. 20 is a system bus 1 and a CPU
2, the main body of a spreadsheet system including PMEM3, IMEM4, etc. 13 is a CRT, 9 is a keyboard, and 10 is a PD. 21 is an FD drive, F
When D16 is set, image data, graphic data, character data, numerical data, formula data, formula calculation result data and ruled line data are written to the FD16, and graphic data, character data and numerical data stored in the FD16 are stored. Reads formula data, formula calculation result data, and ruled line data. The present invention is, of course, realized in the spreadsheet device of the present invention. Sets the FD 16 in which a program capable of implementing the present invention is stored in the FD drive 21 of another spreadsheet device, and the program is stored in the hard disk 15
The present invention can be implemented in another spreadsheet device by loading the program into the spreadsheet program and executing the loaded program.

3 to 8 are views for explaining the operation contents of this embodiment.

FIG. 3 is an example of converted table data, and shows a state diagram when it is displayed on the CRT 13 or printed on the printer 7. Reference numeral 30 indicates a tabular data sheet, 31 indicates a row number in the tabular data sheet of 30, and 32 indicates a column number in the tabular data sheet of 30. Reference numeral 33 indicates a cell in the front sheet of 30, and in FIG. 3, it is indicated that numerical data “123456789” is stored in the cell 1A.

FIG. 4 shows an example of the tabular data after the tabular data of FIG. 3 has been converted. In this case, the tabular data is converted to a spreadsheet application in which the number of significant digits of the numerical data is 7, and the digit is 10 or less. Is rounded down to "1234
56700 ”is shown. The numerical data 40 is numerical data obtained by converting the numerical data 33 of FIG. 3 up to the number of significant digits 7 and truncating numerical values exceeding the number of significant digits.

FIG. 5 shows an example of the tabular data after the tabular data of FIG. 3 has been converted. In this case, the tabular data is converted to a spreadsheet application in which the number of significant digits of the numerical data is 7, and the digit is 10 or less. Shows a state diagram in which the numerical value of is rounded up or rounded to be "123456800". The numerical data 50 is numerical data obtained by converting the numerical data 33 of FIG. 3 up to the effective digit number 7 and rounding up or rounding off the numerical value exceeding the effective digit number.

FIG. 6 is a display screen of the CRT 13 when the user specifies what to do with the rounding processing of the numerical data having the number of significant digits or more when converting the numerical data. Reference numeral 60 is a numerical conversion method designation window, 61 is a truncation mode field indicating that a numerical value having a different number of significant digits is converted by truncation when this field is highlighted, and 62 indicates conversion by rounding up. A round-up mode field 63 is a round-off mode field indicating that the conversion is performed by rounding.

FIG. 7 is a flow chart for explaining the operation of automatically truncating and converting the numerical values of the digits greater than the effective digit number when converting the numerical data having a large effective digit number in the present embodiment.

First, in step S1, the FD 16 in which the table data to be converted is registered is
It is set in the drive 21, and it is determined in step S2 whether or not an instruction to start conversion processing of table data is given from the keyboard 9. If no instruction is given, the process loops at step S2, and if there is an instruction, step S3 Proceed to. In step S3, the table data is read from the FD 16 and is expanded and stored in the PMEM 3 and stored in step S4.
At, it is determined whether there is numerical data in the table data. If there is no numerical data, the process proceeds to step S7 to perform normal table data conversion processing. If there is numerical data, the process proceeds to step S5 and the effective digit number of the numerical data stored in the table data to be converted is created after conversion. Is determined to be larger than the number of significant digits of the numerical data (that is, is larger than the number of significant digits that can be handled by the spreadsheet application that processes the converted table data). Is converted, and if it is larger, step S6.
Proceed to. In step S6, the table data converted by truncating the numerical values of the significant digits or more of the numerical data created after the conversion is created in PMEM3, and the step S8
Proceed to. In step S7, the table data created by performing the normal conversion process is created in PMEM3, and the process proceeds to step S8. In step S8, the conversion table data created in PMEM3 is written in the HD 15 or the FD 16 and the conversion process ends.

An example of converting the table data by performing the above processing is shown in FIGS. 3 and 4, and FIG. 3 is a diagram showing the table data in which the numerical data of 9 significant digits is input. FIG. 4 is a diagram showing a result of converting the table data having 7 significant digits.

Although FIG. 7 has been described with respect to the process of automatically rounding down and converting the numerical values of the significant digits or more, similarly, the process of automatically rounding up the numerical values of the significant digits or more, or The process of rounding off to step S
At the time of 6, the numerical data may be rounded up or rounded instead of being rounded down, and the other steps can be realized by executing exactly the same.

FIG. 8 shows a mode (rounding up, rounding down, rounding) of converting (rounding) a numerical value having a number of significant digits or more when converting numerical data having a large number of significant digits in this embodiment. 5 is a flow chart for explaining an operation of conversion designated by a user.

Steps S10 to S14 are the same as steps S1 to S5 in FIG. When it is determined in step S14 that the number of significant digits of the numerical data stored in the table data to be converted is larger than the number of significant digits of the numerical data created after the conversion, the process proceeds to step S15, and the numerical conversion mode is set. Display the window that specifies, and specify how to process numbers with significant digits. FIG. 6 shows the conversion mode designation window displayed on the CRT 13 at this time. In this embodiment, three methods of rounding down, rounding up, and rounding off can be designated as numerical conversion methods. The three conversion method designation methods use a mouse cursor that operates in conjunction with the PD10. For example, when designating a truncation mode, the mouse cursor is moved to the truncation mode field 61 and attached to the PD10. This is done by depressing the button for displaying the truncation mode field 61 in reverse video.

Then, the process proceeds to step S16, and step S
Numerical data is converted in accordance with the conversion mode designated by 15, and converted table data is created in PMEM3. Further, step S17 is the same as step S7 in FIG. 7, and the table data created by performing the normal conversion process is created in PMEM3. When the conversion table data is created in the PMEM 3 in step S16 or step S17, the conversion table data is written in the HD 15 or the FD 16 in step S18, and the conversion process ends.

FIGS. 3 and 5 show examples of converting the table data by performing the above processing in the conversion mode rounding, and FIG. 3 is a diagram showing the table data in which the numerical data of 9 significant digits is input. FIG. 5 is a diagram showing a result of converting the table data into table data having 7 significant digits.

As described above, according to this embodiment,
Even if a numerical value with a larger number of significant digits than the number of significant digits that can be handled by a spreadsheet device is entered, the numerical data will be accepted, so
The annoyance of the user re-entering numerical data is eliminated. In addition, since the numerical value outside the significant digits that can be handled by the spreadsheet device is not unconditionally rounded down and converted by the method desired by the user, there is no need to re-enter the value desired by the user after conversion of numerical data. .

[Second Embodiment] FIGS. 9 to 15 are views for explaining the operation contents of the second embodiment.

FIG. 9 shows an example of spreadsheet data. Reference numeral 30 is a spreadsheet data sheet.
3 is displayed or is printed from the printer 7.
Reference numeral 31 is a field indicating the row number of the spreadsheet data sheet. 32 is a field indicating the column number of the spreadsheet data sheet. 33 is the data displayed in the cell of the spreadsheet data sheet. In this case, the formula of 34 is registered in the cell 1A, and the formula "weekday (" 1993
0 which is the calculation result of / 06/13 ") is displayed.

FIG. 10 shows an example of the data format of the spreadsheet data. In the present embodiment, during the display and editing of the spreadsheet data, the data is expanded in the PMEM3 according to the spreadsheet data format. Even when the spreadsheet data is stored in the HD 15 or the FD 16, it is assumed that the spreadsheet data is stored according to the spreadsheet data format. Reference numeral 40 denotes a spreadsheet data header section, in which the number of rows and columns of the spreadsheet data are stored. Reference numeral 41 denotes an area of data stored in each cell, and the information shown in FIG. 11 is stored for one cell, and a plurality of pieces of information of these cells are stored. In this embodiment, the cell data is arranged in the order in which the data is registered, and if there is no data in the cell, nothing is stored in the cell data area. Reference numeral 42 stores end-of-file information indicating the end of spreadsheet data.

FIG. 11 shows an example of the format of each cell data, and the number of pieces of cell data is stored in the data area 41 of each cell. Reference numeral 50 stores the number in which this cell data is stored, for example, "1 row A column".
, Are numbered by row and column. Reference numeral 51 stores the formula data stored in the present cell, for example, formula data such as "weekday (" 1993/06/13 ")". 52 is the value of the calculation result of the formula data stored in 51, or, if no formula data is stored in 51, the value displayed in this cell is directly stored.

FIG. 12 shows the spreadsheet data shown in FIG. 9 based on the data format of the spreadsheet data of FIG. 10 and the format of each cell data of FIG. Reference numeral 60 denotes a header portion of 40, which indicates that the spreadsheet data is data in 2 rows and 2 columns. 61
From 63 to 63 are 41 cell data areas, and 61 is a cell number of 50, indicating that this cell data is data of 1st row and A column. 62 is a formula corresponding to 51 formula data "
"weekday (" 1993/06/13 ")" is stored. 63 is the calculation result of the formula of 52 and is 62
“0”, which is the calculation result of the formula stored in the above table, is stored. Reference numeral 64 denotes an end-of-file information portion of 42, and a code indicating the end of the file such as 0xFF is stored.

FIG. 13 shows that when the spreadsheet data of FIG. 9 is converted into another spreadsheet application and recalculated, the function of the function weekday reads "Sunday is 0, ...
Displayed in cell 1A because it changed from "Saturday is set to 6 and returns the day of the given parameter" to "Monday is 0, ..., Sunday is set to 6 and the day of the given parameter is returned" It is a figure which shows the state in which the value to be changed changed from 0 to 6.

FIG. 14 is a diagram showing the state of the spreadsheet data when the spreadsheet data shown in FIG. 12 is not converted into the formula data according to the present invention, but only the calculation result data of the formula is converted. . The same information as in FIG. 12 is set in 60, 61, 63 and 64, and the information that the formula data is not registered is set in the formula data part of 62 (for example, all fields of 62 are filled with NULL code).

FIG. 15 is a flow chart showing an embodiment of the present invention, and the operation of the present invention will be described below with reference to the flow chart.

First, in step S21, the F stored with spreadsheet data created by another spreadsheet application is stored.
Set D16 in the FD drive 21. Then, in step S22, it is determined whether or not an instruction to convert the spreadsheet data stored in the FD 16 into the spreadsheet application is given from the keyboard 9. If so, the process proceeds to step S23. If not, the process loops at step S22 until an instruction is given. When the conversion is instructed, the spreadsheet data is read from the FD 16 in step S23 and temporarily stored in the PMEM3 or the like, and only the formula data of the original spreadsheet data is not stored based on the spreadsheet data stored in the PMEM3 in step S24. Set it,
Spreadsheet data is newly created in the HD 15 or the FD 16.
An example of the spreadsheet data before the conversion at this time is shown in FIG. 12, and an example of the spreadsheet data after the conversion is shown in FIG.

As described above, according to this embodiment,
When copying or converting spreadsheet data, formula data is copied or converted as unset, and only the calculation result of the formula is copied or converted, so the copied or converted spreadsheet data created the spreadsheet data. Even if it is recalculated on a different spreadsheet application, the calculation result of the formula does not change or the display does not change, that is, the user confirms whether the data displayed in the cell has changed after executing the recalculation. The effect is that there is no need.

[Third Embodiment] FIG. 16 is a diagram showing an example of table data. A table data sheet 30 is displayed on the CRT 13 or printed by the printer 7 in such a format. Reference numeral 31 is a field indicating the row number of the table data sheet. 32 is a field indicating the column number of the table data sheet.

FIG. 10, FIG. 11 and FIG. 17 described above are diagrams for explaining the operation contents of the embodiment of the present invention.

FIG. 10 shows an example of the data format of the table data. In this embodiment, during the display and editing of the table data, the data is expanded in the PMEM3 according to this table data format, and the table data is HD15. And F
It is assumed that the data is also stored according to this table data format when it is stored in D16. Reference numeral 40 is a table data header section in which the version number of the table data is stored. Details are shown in FIG. Reference numeral 41 denotes an area of data stored in each cell, and the information shown in FIG. 11 is stored for one cell, and a plurality of pieces of information of these cells are stored. In this embodiment, the cell data is arranged in the order in which the data is registered, and if there is no data in the cell, nothing is stored in the cell data area. 42 is an end indicating the end of the spreadsheet data.
The information of the file is stored.

FIG. 11 shows the format 1 of each cell data.
This is an example, and the number of cell data is stored in the data area stored in each cell of 41. The number 50 in which the cell data is stored is stored in 50, for example, "
Row and column numbers, such as "1 row, A column" 51
Stores the data of the formula stored in this cell. For example, "weekday (" 1993/06/1
Expression data such as 3 ")" is stored. 52 is 5
The value of the calculation result of the formula data stored in 1 or the value displayed in this cell is directly stored if there is no formula data stored in 51.

FIG. 17 is a diagram for explaining the information stored in the table data header portion of 40, where 70 indicates the version number of this table data and 71 indicates the size of the sheet of this table data. For example, in the case of table data as shown in FIG. 16, “2 rows and 2 columns” is stored. Reference numeral 72 stores a number indicating how many cells of data are stored in the data area stored in each cell of 41. For example, in the case of table data as shown in FIG. 16, “0” is stored.

FIG. 18 is a flow chart showing an embodiment of the present invention. The operation of the present invention will be described below with reference to the flow chart.

First, in step S31, the FD1 in which the table data created by another spreadsheet application is stored.
6 is set in the FD drive 21. And step S
At 32, an instruction to convert the tabular data stored in the FD 16 into this spreadsheet application is given by the keyboard 9
Determine if more done. If so, the process proceeds to step S33. If not, the process loops at step S32 until an instruction is given. When the conversion is instructed, the table data is read from the FD 16 in step S33 and temporarily stored in the PMEM 3 or the like, and it is determined in step S34 whether or not any data is stored in at least one cell. The method of this judgment is
For example, it is performed depending on whether the number indicating how many cells of data is stored in the data area stored in each cell of 72 in the table data header section 40 is 0 or not. If it is determined that some data is stored, the process proceeds to step S35 to convert the table data, and if it is determined that no data is stored, the conversion process is not performed and the process ends. To do.

As described above, according to this embodiment,
When copying or converting the table data, since the table data in which nothing is registered in any cell is not converted, there is an effect that the spreadsheet calculation apparatus can be effectively used without performing unnecessary processing.

[0060]

As described above, according to the present invention,
When a numerical value having a larger number of significant digits than the number of significant digits that can be handled by this spreadsheet device is input, the numerical value data is accepted, so that the user does not have to input the numerical data again. Also, unconditionally converting the numerical value outside the number of significant digits that can be handled by this spreadsheet device by the method desired by the user, there is no need for the user to re-enter numerical data into the desired value after conversion. There is an effect.

As explained above, according to the present invention,
Even if the copied or converted spreadsheet data is recalculated on a different spreadsheet application that created the spreadsheet data, the calculation result of the formula does not change or the display does not change. This has the effect of eliminating the need for the user to check whether or not the data displayed in the cell has changed.

As described above, according to the present invention, when the table data is copied or converted, the table data in which nothing is registered in any cell is not converted. The device can be effectively used.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of a spreadsheet system in an example.

FIG. 2 is an external view of a spreadsheet processing apparatus according to an embodiment.

FIG. 3 is a diagram showing an example of converted table data.

FIG. 4 is a diagram showing an example of table data after being converted.

FIG. 5 is a diagram showing an example of table data after being converted.

FIG. 6 is a diagram showing a display screen when a numerical conversion method is designated.

FIG. 7 is a flowchart of an example.

FIG. 8 is a flowchart of an example.

FIG. 9 is a diagram showing a display example of spreadsheet data.

FIG. 10 is a diagram showing an example of a format of spreadsheet data.

FIG. 11 is a diagram showing an example of a format of cell data.

FIG. 12 is a diagram showing a specific example of spreadsheet data.

FIG. 13 is a diagram showing a display example of spreadsheet data converted by a conventional method.

FIG. 14 is a diagram showing an example of spreadsheet data converted according to an embodiment.

FIG. 15 is a flowchart of an example.

FIG. 16 is a diagram showing an example of converted table data.

FIG. 17 is a diagram showing an example of a format of a table data header part.

FIG. 18 is a flowchart of an example.

[Explanation of symbols]

 1 System Bus 2 CPU 3 Program Memory 4 Image Memory 5 Image Scanner 6 Image Input / Output Control Unit 7 Printer 8 Input / Output Control Unit 9 Keyboard 10 Pointing Device 11 VRAM 12 Display Output Control Unit 13 CRT 14 External Storage Control Unit 15 Hard disk 16 Floppy disk

Claims (11)

[Claims] 1. A calculation means for calculating numerical data having a predetermined number of significant digits, a reading means for reading table data, a detection means for detecting numerical data from the table data read by the reading means, and the detection. Discriminating means for discriminating whether or not the number of significant digits of the numerical data detected by the means is larger than the predetermined number of significant digits, and a digit portion exceeding the predetermined number of significant digits of the numerical data discriminated by the discriminating means. And a conversion means for matching the number of significant digits of the numerical data with the predetermined number of significant digits. 2. The data processing according to claim 1, wherein the rounding process is a process of rounding off a digit of one digit lower than the predetermined number of significant digits of the numerical data, counting from an upper digit. apparatus. 3. The data processing apparatus according to claim 1, wherein the rounding process is a process of discarding digits lower than the predetermined significant digit number counted from the upper digits of the numerical data. 4. The data processing apparatus according to claim 1, wherein the rounding process is a process of rounding up the digits of the numerical data that are one digit lower than the predetermined number of significant digits counted from the upper digits. . 5. The data according to claim 1, further comprising selection means for selecting a processing format of the rounding processing, wherein the conversion means performs the rounding processing of the processing format selected by the selection means. Processing equipment. 6. An input unit for inputting a calculation formula, a calculation unit for calculating the calculation formula input by the input unit, a calculation formula input by the input unit, and the calculation unit for the calculation formula. The storage unit stores the calculation result as one file, and the file processing unit that copies or converts the file stored in the storage unit. The file processing unit excludes the expression in the file from the processing target. A data processing device characterized by performing copying or converting. 7. Cell data storage means for storing data corresponding to each cell of a matrix format table, table data creation means for creating table data based on the data stored in the cell data storage means, Table data storage means for storing the table data created by the table data creation means, table data processing means for copying or converting the table data stored in the table data storage means, and table data storage means stored in the table data storage means Discrimination means for discriminating whether data is stored in the cell data storage means corresponding to any cell of the table data, and data is stored in the cell data storage means for any cell by the discrimination means. A data processing apparatus comprising: a control unit that prohibits processing by the table data processing unit when it is determined that the data is not stored. 8. The data number storage means for storing the number of data stored in the cell data storage means, wherein the discriminating means determines when the number of data stored in the data number storage means is zero. 8. The data processing apparatus according to claim 7, wherein it is determined that no data is stored in the cell data storage means even for the cell. 9. A data processing device for calculating numerical data of a predetermined number of significant digits, reading table data, detecting numerical data from the read table data, and detecting the number of significant digits of the numerical data. Is greater than the predetermined number of significant digits, and the digit portion exceeding the predetermined number of significant digits of the numerical data determined to be greater than that is rounded to determine the number of significant digits of the numerical data. A data processing method characterized by matching a predetermined number of significant digits. 10. A calculation formula is input, the calculation of the input calculation formula is executed, the input calculation formula and the calculation result of the calculation formula are stored in a memory as one file, A data processing method, wherein when copying or converting a file stored in the memory, an expression in the file is excluded from a processing target and copying or conversion is performed. 11. The table data is created based on the data corresponding to each cell of the matrix format table stored in the cell data memory, and the created table data is stored in the table data memory. Instructing to copy or convert the table data stored in the memory, and in response to the instruction, the data is stored in the cell data memory corresponding to any cell of the table data stored in the table data memory. Data processing, characterized in that when it is determined that no data is stored in the cell data memory for any of the cells, the instructed copying or converting is prohibited. Method.