CN113761855A - Method, device, computer storage medium and terminal for realizing information processing - Google Patents
Method, device, computer storage medium and terminal for realizing information processing Download PDFInfo
- Publication number
- CN113761855A CN113761855A CN202010483783.9A CN202010483783A CN113761855A CN 113761855 A CN113761855 A CN 113761855A CN 202010483783 A CN202010483783 A CN 202010483783A CN 113761855 A CN113761855 A CN 113761855A
- Authority
- CN
- China
- Prior art keywords
- type
- parameter
- data
- cell
- determining
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
- G06F40/226—Validation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- User Interface Of Digital Computer (AREA)
- Stored Programmes (AREA)
Abstract
The embodiment of the invention provides a method, a device, a computer storage medium and a terminal for realizing information processing, wherein in a calculation formula for calculating a cell, when the definition type of a parameter is different from the actual type of data quoted by the parameter, the type error of the cell data is determined, and technical support is provided for monitoring the type error of the cell data in real time; furthermore, when the type of the cell data is wrong, the data quoted by the parameters is converted into the defined type from the actual type, so that the error correction of the cell data type is realized, the influence of the data type error on the statistical analysis function of the spreadsheet is reduced, and the statistical analysis quality of the spreadsheet is improved.
Description
Technical Field
The present disclosure relates to, but not limited to, office application technologies, and in particular, to a method, an apparatus, a computer storage medium, and a terminal for implementing information processing.
Background
Currently, in the process of applying the spreadsheet, cell calculation is performed through a set calculation formula, which becomes a main function for performing statistical analysis on data in the spreadsheet.
Generally, after finding that the operation result is wrong, a user checks the spreadsheet and the calculation formula for calculating the cells. When the calculation formula is checked to be correct, it is generally considered that the cause of the error in the operation result may be that the data displayed in the table is not a numerical value, but text or other types of information. Table 1 is a schematic table in the related art, such as: the weight column and the amount column in the totaling row in table 1 are summation operation, and when the types of data in the data column with the weight as the data item in table 1 are all texts, the output result of the totaling item obtained by solving through a summation function is 0; the following steps are repeated: when the types of data in the data column of which the data item is money are all text, the output result of the summation item obtained by solving the summation function is also 0.
| Name of commodity | Weight (D) | Unit of | Amount of money | |
| 1 | Apple (Malus pumila) | 100 | Kilogram (kilogram) | 800 |
| 2 | |
20 | Kilogram (kilogram) | 200 |
| 3 | Hami |
80 | Kilogram (kilogram) | 1600 |
| 4 | Total up to | 0 | 0 |
TABLE 1
In this case, the data types of the cells need to be analyzed manually, and after the data types are found to be incorrect manually, the user needs to manually adjust the data types in the cells one by one to the correct data types to ensure the correctness of the calculation result. Obviously, this treatment is cumbersome, inefficient and prone to leaks.
How to reduce the influence on the statistical analysis function of the spreadsheet due to the data type error of the cell becomes a problem to be solved.
Disclosure of Invention
The following is a summary of the subject matter described in detail herein. This summary is not intended to limit the scope of the claims.
Embodiments of the present invention provide a method, an apparatus, a computer storage medium, and a terminal for implementing information processing, which can reduce an influence on a statistical analysis function of an electronic form caused by a data type error, and improve statistical quality of the electronic form.
The embodiment of the invention provides a method for realizing information processing, which comprises the following steps:
determining the definition type of each parameter in a calculation formula for calculating the cells, and determining the actual type of data quoted by each parameter in the calculation formula;
and for the data quoted by each parameter, determining that the data type of the cell is wrong when the actual type of the data quoted by the parameter is different from the defined type of the parameter.
On the other hand, the embodiment of the present invention further provides a computer storage medium, in which a computer program is stored, and the computer program, when executed by a processor, implements the above method for implementing information processing.
In another aspect, an embodiment of the present invention further provides a terminal, including: a memory and a processor, the memory having a computer program stored therein; wherein,
the processor is configured to execute the computer program in the memory;
the computer program, when executed by the processor, implements a method of implementing information processing as described above.
In another aspect, an embodiment of the present invention further provides an apparatus for implementing information processing, where the apparatus includes: a first determination unit and a second determination unit; wherein,
the first determination unit is configured to: determining the definition type of each parameter in a calculation formula for calculating the cells, and determining the actual type of data quoted by each parameter in the calculation formula;
the second determination unit is configured to: and for the data quoted by each parameter, determining that the data type of the cell is wrong when the actual type of the data quoted by the parameter is different from the defined type of the parameter.
The application includes: determining the definition type of each parameter in a calculation formula for calculating the cells, and determining the actual type of data quoted by each parameter in the calculation formula; and for the data quoted by each parameter, determining that the data type of the cell is wrong when the actual type of the data quoted by the parameter is different from the defined type of the parameter. According to the calculation formula for calculating the cells, when the definition type of the parameters is different from the actual type of the data quoted by the parameters, the type error of the cell data is determined, and technical support is provided for monitoring the type error of the cell data in real time; furthermore, when the type of the cell data is wrong, the data quoted by the parameters is converted into the defined type from the actual type, so that the error correction of the cell data type is realized, the influence of the data type error on the statistical analysis function of the spreadsheet is reduced, and the statistical analysis quality of the spreadsheet is improved.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the example serve to explain the principles of the invention and not to limit the invention.
FIG. 1 is a flow chart of a method for implementing information processing according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a pop-up window according to an embodiment of the present invention;
fig. 3 is a block diagram of an apparatus for implementing information processing according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Also, while a logical order is shown in the flow diagrams, in some cases, the steps shown or described may be performed in an order different than here.
Fig. 1 is a flowchart of a method for implementing information processing according to an embodiment of the present invention, as shown in fig. 1, including:
In one illustrative example, determining the type of definition of each parameter in the calculation formula for a cell includes:
and determining the definition type of each parameter in the calculation formula through the formula definition specification.
In one illustrative example, determining the actual type of data referenced by parameters in a computational formula includes:
extracting a cell where data quoted by the parameters are located from the calculation formula aiming at each parameter in the calculation formula;
and determining the type of the data in the cell where the data referred by the parameter is positioned as the actual type of the data referred by the parameter.
In the embodiment of the invention, the cell where the data quoted by the parameters is located can be extracted from the calculation formula of the cell calculation through a preset extraction instruction or an extraction function; the type of the data in the cell where the data referred by the parameter is located can be read from the attribute information of the cell through a preset reading instruction or a preset reading function. The instruction fetch, function fetch, instruction fetch or function fetch may be designed and implemented according to the relevant principle, and will not be described herein.
And 102, determining that the data type of the cell is wrong when the actual type of the data quoted by the parameters is different from the defined type of the parameters for the data quoted by each parameter.
According to the calculation formula for calculating the cells, when the definition type of the parameters is different from the actual type of the data quoted by the parameters, the type error of the cell data is determined, and technical support is provided for monitoring the type error of the cell data in real time;
in an exemplary embodiment, after determining that the data type of the cell is incorrect, the method in the embodiment of the present invention further includes:
for each parameter with different actual type and defined type, converting the data referenced by the parameter from the actual type to the defined type.
When the data type of the cell is wrong, the data quoted by the parameters is converted into the definition type from the actual type, so that the error correction of the data type of the cell is realized, the influence of the data type error on the statistical analysis function of the spreadsheet is reduced, and the statistical analysis quality of the spreadsheet is improved. In an exemplary embodiment, after determining that the actual type of the data referred by the parameter is different from the defined type of the parameter, the method in the embodiment of the present invention further includes:
displaying a judgment result that the actual type of the data quoted by the parameters is different from the defined type of the parameters through a preset window;
wherein, the judgment result includes: the defined type of parameter and the actual type of data referenced by the parameter are different for each parameter: the actual types of the types and the data to which they refer are defined.
According to the embodiment of the invention, through the display of the judgment result, a user can quickly determine the specific errors of the data type, and information support is provided for the error correction of the data type.
In an exemplary example, before the determination result is displayed through the window, the differentiated display may be performed by adjusting the display format of the cell, for example, by adjusting the color of the display cell to prompt, or by adding a color corner mark to prompt.
In one illustrative example, the preset window comprises a pop-up window configured in a spreadsheet.
According to the embodiment of the invention, through the pop-up window configured in the electronic form, a user can conveniently look up the cell type error; the embodiment of the invention can realize the correction function of the cell type errors when the pop-up window is designed, and is realized by arranging the functional key with the conversion function on the pop-up window, and the data with the type errors is converted into the defined type by triggering the cells by clicking the functional key, wherein the actual type of the data quoted from the parameters. Fig. 2 is a schematic diagram of a pop-up window according to an embodiment of the present invention, as shown in fig. 2, when it is determined that the definition type of the parameter is different from the actual type of the data referred by the parameter, a data type in a cell is displayed to be incorrect by a new corner mark added in the spreadsheet, and a user pops up a preset pop-up window by clicking the corner mark and displays the incorrect type of the data in the cell by the pop-up window; after the popup window is provided with the function key, the data with the wrong type is converted into the defined type from the actual type of the data quoted by the parameters by clicking the function key to trigger the cell. Through the processing of the embodiment of the invention, the determination and correction of the data type errors in the cells can be realized, and the accuracy of cell calculation and the statistical analysis efficiency of the spreadsheet are improved.
The embodiment of the invention also provides a computer storage medium, wherein a computer program is stored in the computer storage medium, and when being executed by a processor, the computer program realizes the method for realizing the information processing.
An embodiment of the present invention further provides a terminal, including: a memory and a processor, the memory having stored therein a computer program; wherein,
the processor is configured to execute the computer program in the memory;
the computer program, when executed by a processor, implements a method of implementing information processing as described above.
Fig. 3 is a block diagram of an apparatus for implementing information processing according to an embodiment of the present invention, as shown in fig. 3, including: a first determination unit and a second determination unit; wherein,
the first determination unit is configured to: determining the definition type of each parameter in a calculation formula for calculating the cells, and determining the actual type of data quoted by each parameter in the calculation formula;
the second determination unit is configured to: and for the data quoted by each parameter, determining that the data type of the cell is wrong when the actual type of the data quoted by the parameter is different from the defined type of the parameter. According to the calculation formula for calculating the cells, when the definition type of the parameters is different from the actual type of the data quoted by the parameters, the type error of the cell data is determined, and technical support is provided for monitoring the type error of the cell data in real time;
in an exemplary embodiment, the first determining unit is configured to determine an actual type of data referenced by each parameter in the calculation formula, and includes:
extracting a cell where data quoted by the parameters are located from the calculation formula aiming at each parameter in the calculation formula;
and determining the type of the data in the cell where the data referred by the parameter is positioned as the actual type of the data referred by the parameter.
The first determination unit is configured to determine a definition type of each parameter in a calculation formula for cell calculation, and includes:
the definition type of each parameter in the calculation formula for calculating the cell is determined through the formula definition specification.
In an exemplary embodiment, the apparatus of the present invention further includes a conversion unit, configured to:
for each parameter with different actual type and defined type, converting the data referenced by the parameter from the actual type to the defined type.
When the data type of the cell is wrong, the data quoted by the parameters is converted into the definition type from the actual type, so that the error correction of the data type of the cell is realized, the influence of the data type error on the statistical analysis function of the spreadsheet is reduced, and the statistical analysis quality of the spreadsheet is improved.
In an exemplary embodiment, the apparatus of the present invention further includes a feedback unit configured to:
displaying a judgment result that the actual type of the data quoted by the parameters is different from the defined type of the parameters through a preset window;
wherein, the judgment result includes: the defined type of parameter and the actual type of data referenced by the parameter are different for each parameter: the actual types of the types and the data to which they refer are defined.
According to the embodiment of the invention, through the display of the judgment result, a user can quickly determine the specific errors of the data type, and information support is provided for the error correction of the data type.
"one of ordinary skill in the art will appreciate that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media "as is well known to those of ordinary skill in the art.
Claims (10)
1. A method of implementing information processing, comprising:
determining the definition type of each parameter in a calculation formula for calculating the cells, and determining the actual type of data quoted by each parameter in the calculation formula;
and for the data quoted by each parameter, determining that the data type of the cell is wrong when the actual type of the data quoted by the parameter is different from the defined type of the parameter.
2. The method of claim 1, wherein determining the type of definition of each parameter in the calculation formula for cell calculation comprises:
determining the definition type of each parameter in the calculation formula for cell calculation through formula definition specifications.
3. The method of claim 1, wherein determining the actual type of data referenced by each parameter in the computational formula comprises:
extracting a cell in which data quoted by the parameters are positioned from the calculation formula aiming at each parameter in the calculation formula;
and determining the type of the data in the cell where the data referred by the parameter is positioned as the actual type of the data referred by the parameter.
4. The method according to any one of claims 1 to 3, wherein after determining that the data type of the cell is wrong, the method further comprises:
for each parameter with different actual type and defined type, converting the data referenced by the parameter from the actual type to the defined type.
5. The method according to any one of claims 1 to 3, wherein after determining that the actual type of the data referred by the parameter is different from the defined type of the parameter, the method further comprises:
displaying a judgment result that the actual type of the data quoted by the parameters is different from the defined type of the parameters through a preset window;
wherein the judgment result comprises: the defined type of parameter and the actual type of data referenced by the parameter are different for each parameter: the actual types of the types and the data to which they refer are defined.
6. A computer storage medium having stored therein a computer program which, when executed by a processor, implements a method of implementing information processing according to any one of claims 1 to 5.
7. A terminal, comprising: a memory and a processor, the memory having a computer program stored therein; wherein,
the processor is configured to execute the computer program in the memory;
the computer program, when executed by the processor, implements a method of implementing information processing as recited in any of claims 1-5.
8. An apparatus for implementing information processing, comprising: a first determination unit and a second determination unit; wherein,
the first determination unit is configured to: determining the definition type of each parameter in a calculation formula for calculating the cells, and determining the actual type of data quoted by each parameter in the calculation formula;
the second determination unit is configured to: and for the data quoted by each parameter, determining that the data type of the cell is wrong when the actual type of the data quoted by the parameter is different from the defined type of the parameter.
9. The apparatus of claim 8, wherein the first determining unit is configured to determine the actual type of data referenced by each parameter in the calculation formula, and comprises:
extracting a cell in which data quoted by the parameters are positioned from the calculation formula aiming at each parameter in the calculation formula;
and determining the type of the data in the cell where the data referred by the parameter is positioned as the actual type of the data referred by the parameter.
10. The apparatus according to claim 8 or 9, further comprising a conversion unit for:
for each parameter with different actual type and defined type, converting the data referenced by the parameter from the actual type to the defined type.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010483783.9A CN113761855B (en) | 2020-06-01 | 2020-06-01 | Method, device, computer storage medium and terminal for realizing information processing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010483783.9A CN113761855B (en) | 2020-06-01 | 2020-06-01 | Method, device, computer storage medium and terminal for realizing information processing |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113761855A true CN113761855A (en) | 2021-12-07 |
| CN113761855B CN113761855B (en) | 2024-08-13 |
Family
ID=78782468
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010483783.9A Active CN113761855B (en) | 2020-06-01 | 2020-06-01 | Method, device, computer storage medium and terminal for realizing information processing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113761855B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5842180A (en) * | 1996-03-28 | 1998-11-24 | Microsoft Corporation | Method and system for detecting and correcting errors in a spreadsheet formula |
| JP2007052469A (en) * | 2005-08-12 | 2007-03-01 | Nsk Ltd | Data format conversion system |
| CN106227773A (en) * | 2016-07-14 | 2016-12-14 | 广州视睿电子科技有限公司 | Data processing method and system |
| CN107451112A (en) * | 2017-07-24 | 2017-12-08 | 网易（杭州）网络有限公司 | Form tool data inspection method, device, terminal device and storage medium |
| US20170357628A1 (en) * | 2016-06-08 | 2017-12-14 | j5 International IP Corporation | Spreadsheet-Based Form Design and Data Input |
-
2020
- 2020-06-01 CN CN202010483783.9A patent/CN113761855B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5842180A (en) * | 1996-03-28 | 1998-11-24 | Microsoft Corporation | Method and system for detecting and correcting errors in a spreadsheet formula |
| JP2007052469A (en) * | 2005-08-12 | 2007-03-01 | Nsk Ltd | Data format conversion system |
| US20170357628A1 (en) * | 2016-06-08 | 2017-12-14 | j5 International IP Corporation | Spreadsheet-Based Form Design and Data Input |
| CN106227773A (en) * | 2016-07-14 | 2016-12-14 | 广州视睿电子科技有限公司 | Data processing method and system |
| CN107451112A (en) * | 2017-07-24 | 2017-12-08 | 网易（杭州）网络有限公司 | Form tool data inspection method, device, terminal device and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 胡玉洋: "【POI框架实战】——POI导出Excel时设置单元格类型为数值类型", Retrieved from the Internet <URL:https://blog.csdn.net/huyuyang6688/article/details/49786227> * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113761855B (en) | 2024-08-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108734089B (en) | Method, device, equipment and storage medium for identifying table content in picture file | |
| CN109344831A (en) | A kind of tables of data recognition methods, device and terminal device | |
| US20160260030A1 (en) | Transductive lasso for high-dimensional data regression problems | |
| CN113158988B (en) | Financial statement processing method, device and computer readable storage medium | |
| WO2019085466A1 (en) | Association test method and system, application server, and computer readable storage medium | |
| CN108734304B (en) | Training method and device of data model and computer equipment | |
| CN107870827B (en) | Data quality control method and device based on verification | |
| CN110826494A (en) | Annotated data quality evaluation method, device, computer equipment and storage medium | |
| CN105224542A (en) | A kind of method and apparatus business object data being imported platform | |
| CN113220594A (en) | Automatic testing method, device, equipment and storage medium | |
| CN111966600B (en) | Webpage testing method, webpage testing device, computer equipment and computer readable storage medium | |
| CN113450077A (en) | Foreign exchange voucher processing method and device | |
| CN115391439A (en) | Document data export method, device, electronic equipment and storage medium | |
| CN113761855A (en) | Method, device, computer storage medium and terminal for realizing information processing | |
| CN110827261B (en) | Image quality detection method and device, storage medium and electronic equipment | |
| CN106294115A (en) | The method of testing of a kind of application system animal migration and device | |
| CN115221037A (en) | Interactive page testing method and device, computer equipment and program product | |
| CN109857816B (en) | Test sample selection method and device, storage medium and electronic equipment | |
| US12229114B2 (en) | Data anomaly detection | |
| CN114564477B (en) | Data storage method and device, electronic equipment and storage medium | |
| CN111277465A (en) | Abnormal data message detection method and device and electronic equipment | |
| KR20210050202A (en) | Automatic sentence correction device using correction database built on text with correction code inserted and operating method thereof | |
| CN117171030A (en) | Method, device, equipment and storage medium for detecting software running environment | |
| CN112364630B (en) | License content error correction method, device and system | |
| CN114444453B (en) | A method, device, computer storage medium and terminal for realizing data processing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |