CN102456013A - Processing method and device for computational formula in data table - Google Patents
Processing method and device for computational formula in data table Download PDFInfo
- Publication number
- CN102456013A CN102456013A CN201010515044XA CN201010515044A CN102456013A CN 102456013 A CN102456013 A CN 102456013A CN 201010515044X A CN201010515044X A CN 201010515044XA CN 201010515044 A CN201010515044 A CN 201010515044A CN 102456013 A CN102456013 A CN 102456013A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- project
- computing formula
- compute type
- 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.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Processing Of Solid Wastes (AREA)
Abstract
The invention discloses a processing method for a computational formula in a data table. The processing method comprises the following steps of: judging the computation type of the data table; and reading the computational formula for items which correspond to the computation type of the data table for computation. By the processing method for the computational formula in the data table, the items can be automatically selected for the current computation of the data table, and the computation of the data table is more flexible, simpler and more convenient. The invention also provides a processing device for the computational formula in the data table.
Description
[technical field]
The present invention relates to data processing technique, relate in particular to the disposal route and the device of computing formula in a kind of tables of data.
[background technology]
Tables of data is to organize the instrument of data and information with form, and project is the basic constituent element in the tables of data, and computing formula is used for the numerical value of computational item in tables of data.In the calculating of tables of data, different tables of data compute type is participated in the project difference of calculating.The disposal route of computing formula needs the artificial computing formula of going to judge which project of employing in the traditional data table, and complicated operation does not possess convenience.And when project does not meet current tables of data compute type, then empty the computing formula of project, cause to carry out in the follow-up identical flow process multiplexing.
[summary of the invention]
Based on this, be necessary to provide a kind of computing formula of option automatically, it is simple more flexibly that tables of data is calculated, the disposal route of computing formula in the tables of data of more convenient operation.
The disposal route of computing formula in a kind of tables of data may further comprise the steps:
Judgment data table compute type;
Reading the computing formula of the project corresponding with said tables of data compute type calculates.
Preferably, said method also comprises:
Be said project setting and the corresponding mark of said tables of data compute type.
Preferably,
The step that the said computing formula that reads the project corresponding with the tables of data compute type is calculated comprises:
Obtain the mark of said project;
Label screening according to said project goes out and the corresponding project of said tables of data compute type, reads the computing formula of the said project that filters out and calculates.
Preferably, the compute type of said setting comprises that the global data table calculates and local tables of data is calculated.
Preferably, said step for the project setting mark corresponding with the tables of data compute type is:
Be provided with the global data table and calculate corresponding global mark and show to calculate corresponding local flag with local data.
In addition, also be necessary to provide a kind of computing formula of option automatically, it is simple more flexibly that tables of data is calculated, the treating apparatus of computing formula in the tables of data of more convenient operation.
The treating apparatus of computing formula in a kind of tables of data comprises:
Judge module is used for judgment data table compute type;
Computing module reads the computing formula of the project corresponding with said tables of data compute type and calculates.
Preferably, also be included as the module that is provided with of the said project setting mark corresponding with said tables of data compute type.
Preferably, said computing module comprises:
The mark acquisition module is used to obtain the mark of said project;
Screening module is used for going out and the corresponding project of said tables of data compute type according to the label screening of said project;
The formula computing module, the computing formula that is used to read the said project that filters out is calculated.
Preferably, the compute type of said setting comprises that the global data table calculates and local tables of data is calculated.
Preferably, the said module that is provided with is used to be provided with the global mark corresponding with the calculating of global data table and shows to calculate corresponding local flag with local data.
The disposal route of computing formula and device in the above-mentioned tables of data; Through judgment data table compute type, read the computing formula of the project corresponding and calculate with the tables of data compute type, realize automatic option participation calculating; Make the calculating of tables of data simple more flexibly, more convenient operation.
[description of drawings]
Fig. 1 is the process flow diagram of the disposal route of computing formula in the tables of data among the embodiment;
Fig. 2 is the process flow diagram of the disposal route of computing formula in the tables of data among another embodiment;
Fig. 3 is the structured flowchart of the treating apparatus of computing formula in the tables of data among the embodiment;
Fig. 4 is the structured flowchart of the treating apparatus of computing formula in the tables of data among another embodiment.
[embodiment]
As shown in Figure 1, in one embodiment, the disposal route of computing formula in a kind of tables of data may further comprise the steps:
Among the step S110, judgment data table compute type.
Among the step S120, read the computing formula of the project corresponding and calculate with the tables of data compute type.The project that different pieces of information table compute type should participate in calculating can be different, but preliminary setting data table compute type reads the computing formula of the project corresponding with current tables of data compute type then and calculates in requisition for which project participating in calculating.Realized automatic option participation calculating, the calculating of tables of data is simple more flexibly, more convenient operation.
As shown in Figure 2, in another embodiment, the disposal route of computing formula is following in the above-mentioned tables of data:
Among the step S210, be the project setting mark corresponding with the tables of data compute type.The tables of data compute type comprises that the global data table calculates and local tables of data compute type.During the global data table calculated, current tables of data calculating needed project and the data in other tables of data to participate in calculating; During local data's table calculated, current tables of data was calculated the project and the data that only need self and is participated in calculating.To participating in the project that the global data table calculates, be provided with the global data table and calculate corresponding global mark, to the project that participation local data table calculates, be provided with and the corresponding local flag of local data's table calculating.
Among the step S220, obtain the mark of project.For controlled attribute one hurdle of the be marked at project corresponding with the tables of data compute type of project setting has sign, global mark is provided with different signs with local flag.Can obtain the mark of project through the scan-data table, also can from storer, read the mark of project.
Among the step S230, go out and the corresponding project of tables of data compute type according to the label screening of project.Because for project is provided with the mark corresponding with the tables of data compute type, obtain the mark of project after, the project of tape label is then participated in tables of data calculating.
Among the step S240, read the computing formula of the project that filters out and calculate.Because the project of tape label is corresponding with current tables of data compute type, the project of tape label should participate in calculating.
Among this embodiment, the computing formula of projects sets in advance and is stored in the storer in the tables of data, therefore can from storer, read the computing formula of the project of tape label and calculate.The interface of the computing formula of User Defined project can be provided, and when new projects, the user also can revise the computing formula of project, and is easy to operate simple.
After getting access to the computing formula of project of tape label, can store the project of these tape labels and the computing formula of project,, realize multiplexing so that when condition subsequent meets, participate in again calculating in this locality.
Should be noted that; The disposal route of computing formula can be used in general or special purpose numerous computing system environments or the configuration in the above-mentioned tables of data, for example personal computer, personal digital assistant, server computer, handheld device, multicomputer system or comprise said system or the DCE of equipment or the like.The disposal route of computing formula can be described in the general context through the computer executable instructions carried out on the computing machine in the above-mentioned tables of data, comprises the program carrying out particular task or realize particular abstract, object, assembly, data structure etc.
As shown in Figure 3, in one embodiment, the treating apparatus of computing formula in a kind of tables of data comprises with lower component:
As shown in Figure 4, in another embodiment, the treating apparatus of computing formula also comprises except comprising judge module 100, computing module 200 in the above-mentioned tables of data:
To participating in the project that the global data table calculates, module 300 is set is used to be provided with and the corresponding global mark of global data table calculating, to participating in the project that local data's table calculates, module 300 is set is used to be provided with and the corresponding local flag of local data's table calculating.
Among this embodiment, computing module 200 comprises:
Should be noted that; The treating apparatus of computing formula can be applicable in various general or special purpose numerous computing system environments or the configuration in the above-mentioned tables of data, for example personal computer, personal digital assistant, server computer, handheld device, multicomputer system or comprise said system or the DCE of equipment or the like.Wherein each functional module can be arranged in the Local or Remote computer-readable storage medium that comprises memory device.
The above embodiment has only expressed several kinds of embodiments of the present invention, and it describes comparatively concrete and detailed, but can not therefore be interpreted as the restriction to claim of the present invention.Should be pointed out that for the person of ordinary skill of the art under the prerequisite that does not break away from the present invention's design, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with accompanying claims.
Claims (10)
1. the disposal route of computing formula in the tables of data may further comprise the steps:
Judgment data table compute type;
Reading the computing formula of the project corresponding with said tables of data compute type calculates.
2. the disposal route of computing formula is characterized in that in the tables of data according to claim 1, and said method also comprises:
Be said project setting and the corresponding mark of said tables of data compute type.
3. the disposal route of computing formula is characterized in that in the tables of data according to claim 2, and the step that the said computing formula that reads the project corresponding with the tables of data compute type is calculated comprises:
Obtain the mark of said project;
Label screening according to said project goes out and the corresponding project of said tables of data compute type, reads the computing formula of the said project that filters out and calculates.
4. the disposal route of computing formula is characterized in that in the tables of data according to claim 2, and the compute type of said setting comprises that the global data table calculates and local tables of data is calculated.
5. the disposal route of computing formula is characterized in that in the tables of data according to claim 4, and said step for the project setting mark corresponding with the tables of data compute type is:
Be provided with the global data table and calculate corresponding global mark and show to calculate corresponding local flag with local data.
6. the treating apparatus of computing formula in the tables of data is characterized in that, comprising:
Judge module is used for judgment data table compute type;
Computing module reads the computing formula of the project corresponding with said tables of data compute type and calculates.
7. the treating apparatus of computing formula is characterized in that in the tables of data according to claim 6, also is included as the module that is provided with of the said project setting mark corresponding with said tables of data compute type.
8. the treating apparatus of computing formula is characterized in that in the tables of data according to claim 7, and said computing module comprises:
The mark acquisition module is used to obtain the mark of said project;
Screening module is used for going out and the corresponding project of said tables of data compute type according to the label screening of said project;
The formula computing module calculates with the computing formula that reads the said project that filters out.
9. the disposal route of computing formula is characterized in that in the tables of data according to claim 7, and the compute type of said setting comprises that the global data table calculates and local tables of data is calculated.
10. the disposal route of computing formula is characterized in that in the tables of data according to claim 9, and the said module that is provided with is used to be provided with the global mark corresponding with the calculating of global data table and shows to calculate corresponding local flag with local data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010515044XA CN102456013A (en) | 2010-10-20 | 2010-10-20 | Processing method and device for computational formula in data table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010515044XA CN102456013A (en) | 2010-10-20 | 2010-10-20 | Processing method and device for computational formula in data table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102456013A true CN102456013A (en) | 2012-05-16 |
Family
ID=46039211
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010515044XA Pending CN102456013A (en) | 2010-10-20 | 2010-10-20 | Processing method and device for computational formula in data table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102456013A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111240637A (en) * | 2020-02-16 | 2020-06-05 | 苏州浪潮智能科技有限公司 | Formula calculation method and system under cloud management platform |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
| WO2009111116A1 (en) * | 2008-03-05 | 2009-09-11 | Microsoft Corporation | Dynamic formulas for spreadsheet cells |
| CN101710347A (en) * | 2009-12-23 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and device for processing data in data table |
-
2010
- 2010-10-20 CN CN201010515044XA patent/CN102456013A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1755668A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Design of spreadsheet functions for working with tables of data |
| WO2009111116A1 (en) * | 2008-03-05 | 2009-09-11 | Microsoft Corporation | Dynamic formulas for spreadsheet cells |
| CN101710347A (en) * | 2009-12-23 | 2010-05-19 | 金蝶软件（中国）有限公司 | Method and device for processing data in data table |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111240637A (en) * | 2020-02-16 | 2020-06-05 | 苏州浪潮智能科技有限公司 | Formula calculation method and system under cloud management platform |
| CN111240637B (en) * | 2020-02-16 | 2023-01-10 | 苏州浪潮智能科技有限公司 | Formula calculation method and system under cloud management platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10546005B2 (en) | Perspective data analysis and management | |
| US20120239642A1 (en) | Method and system for gesture based searching | |
| CN106255965A (en) | Automatic opinion for electrical form | |
| CN104636142B (en) | A kind of information processing method and electronic equipment | |
| CN114595343B (en) | Map display method and device, storage medium and electronic equipment | |
| CN103428071A (en) | Terminal and information processing method | |
| CN103854166A (en) | Information processing method and electronic equipment | |
| US10042913B2 (en) | Perspective data analysis and management | |
| CN104517168A (en) | Engineering project construction cost schedule management system | |
| CN104915359A (en) | Theme label recommending method and device | |
| CN103198071B (en) | Datagram table generating method and device thereof | |
| CN104268607A (en) | Textile fabric management system and method based on RFID technology | |
| CN107133365A (en) | A kind of sequential image dynamic Service method and device of subdivision coding | |
| CN110008445A (en) | Event extraction method and device, electronic equipment | |
| CN106156274A (en) | Page content loading method and device and electronic equipment | |
| CN105247501A (en) | Systems and methods for processing input streams of calendar applications | |
| CN103605521A (en) | Method and device for realizing interface apposition | |
| CN102456013A (en) | Processing method and device for computational formula in data table | |
| US8538487B2 (en) | System and method for managing local time of contact person of mobile phone | |
| CN112099703B (en) | Desktop pendant display method and device and electronic equipment | |
| CN115174823A (en) | Checkpoint special effect video generation method and device and storage medium | |
| CN103559302A (en) | Method, device and system for monitoring state of network media data | |
| CN104143000A (en) | Information displaying method and device | |
| CN111182354B (en) | Video scoring recommendation method, device and equipment and computer readable storage medium | |
| CN105868191B (en) | Data processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120516 |