CN102004613A - Dendriform display method of expression and evaluation method - Google Patents
Dendriform display method of expression and evaluation method Download PDFInfo
- Publication number
- CN102004613A CN102004613A CN2010105776699A CN201010577669A CN102004613A CN 102004613 A CN102004613 A CN 102004613A CN 2010105776699 A CN2010105776699 A CN 2010105776699A CN 201010577669 A CN201010577669 A CN 201010577669A CN 102004613 A CN102004613 A CN 102004613A
- Authority
- CN
- China
- Prior art keywords
- tree
- operational symbol
- function
- expression formula
- node
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a dendriform display method of an expression, wherein, the expression contains a plurality of operational symbols and original data types. The method comprises the following steps: the operational symbol with the lowest priority in the expression is displayed as a root node; a processing object of the operational symbol is displayed as a child node or a subtree; if the processing object of the operational symbol is the original data type, the processing object is displayed as a child node; if the processing object of the operational symbol is a subexpression, the processing object is displayed as a child node in case of no expansion and is displayed as a subtree in case of expansion, that is, the operational symbol with the lowest priority in the expression is displayed as a root node of the subtree; and the processing object of the operational symbol with the lowest priority in the expression is continuously displayed as a child node or the subtree. In the invention, hierarchical dendriform display is realized according to the operation priority of the expression or a formula and the relation between the operational symbols and data so that a user can more easily understand the meaning of the expression.
Description
[technical field]
The present invention relates to user interface and show field, the particularly tree-shaped demonstration of expression formula and the application in electrical form thereof.
[background technology]
The acceptance on of various application programs, operation and displaying contents such as the graphical user interfaces such as Mac OS operating system of the Android operating system of the Windows operating system of Microsoft, Google and Apple.Such as the spreadsheet program in the OFFICE application program of Wuxi Yongzhong science and technology is exactly a kind of application program that shows the data of various forms on graphic user interface.Spreadsheet applications or title application program are to be widely known by the people and useful instrument comparatively speaking.Usually spreadsheet applications are by catching, show and operate the tables of data that the data of being arranged in the row and column are simulated type.The row and column that intersects forms many cells in electrical form.Usually, each cell will comprise a data item and/or a mathematical formulae.
Generally speaking, formula in certain cell in the spreadsheet applications is the processing to the data in other cells, data in described other cells may be numerical value, text and Boolean or the like, and described formula may comprise arithmetic operator, comparison operator, text operational symbol and function or the like.Described formula is normally linearly aligned when showing.Such as formula D1=1.2*A1+ (B1-C1)/3, wherein A1, B1, C1 and D1 represent first cell, second cell, the 3rd cell and the 4th cell in first row of worksheet of described formula place electrical form respectively, spreadsheet applications then show in the 4th cell of first row "=1.2*A1+ (B1-C1)/3 " when showing this formula so.Obviously, because the daily formula that reads all is that infix expression is represented, when described formula only was made of simple arithmetic operator etc., this formula was understandable for the reader.But when described formula has comprised that a plurality of cell data, a plurality of operational symbol and/or a plurality of function and function are nested, the content of so described formula representative will be not easy to be understood.Such as:
{=IF (ISERR (SMALL (IF (Data＜〉" ", ROW (INDIRECT (" 1: " ﹠amp; ROWS (Data))) ROW (INDIRECT (" 1): " ﹠amp; ROWS (Data))))), " ", INDEX (Data, SMALL (IF (Data＜〉" ", ROW (INDIRECT (" 1: " ﹠amp; ROWS (Data))) ROW (INDIRECT (" 1): " ﹠amp; ROWS (Data)))--------formula 1))) },
Believe the complicated formulas that is similar to formula 1 for the author's of non-formula user own all be do not allow intelligible, even the author of this formula itself when after after a while, consulting this formula again all will be do not allow intelligible.
But in real-life program, an electrical form is transferred to the another one user through regular meeting via a user and checks, perhaps this electrical form is checked in a fixed-line subscriber not timing.If comprised comparatively complicated formula in the described electrical form, it is inconvenient understanding this formula for the user so.In addition, also there is this type of problem in some such as formula in tutorial application or the engineering calculation application program or expression formula, have caused the user experience of these application programs relatively poor.
Therefore, be necessary to propose a kind of new technical scheme and solve above-mentioned shortcoming.
[summary of the invention]
The purpose of this part is to summarize some aspects of embodiments of the invention and briefly introduces some preferred embodiments.In this part and the application's specification digest and denomination of invention, may do a little simplification or omit avoiding the making purpose of this part, specification digest and denomination of invention fuzzy, and this simplification or omit and can not be used to limit the scope of the invention.
One object of the present invention is to provide a kind of tree-shaped display packing of expression formula, can make the user more easily understand the implication of described expression formula.
Another object of the present invention is to provide a kind of evaluation technique of expression formula, utilize the tree-shaped demonstration evaluation of described expression formula, make the user more easily understand the calculating process and the result of described expression formula.
In order to reach purpose of the present invention, according to an aspect of the present invention, the invention provides a kind of tree-shaped display packing of expression formula, described expression formula comprises some operational symbols and original data type, and described method comprises: the operational symbol of lowest priority in the expression formula is shown as root node; Show as child nodes or subtree with process object described operational symbol.
Further, if the process object of described operational symbol is an original data type, then show as child nodes; If the process object of described operational symbol is subexpression, then show that as subtree described subtree is shown as: the operational symbol of lowest priority in the subexpression root node as subtree is shown; Continue to show with process object as child nodes or subtree with the operational symbol of lowest priority in the described subexpression.
Further, described original data type comprises one or more in numerical value, text, Boolean, improper value and the function parameter.
Further, described operational symbol comprises one or more in arithmetic operator, comparison operator, text concatenation operator, reference operators and the function.
Further, described function comprise text function, date and time function, search with referencing function, logical function, engineering function, mathematics and trigonometric function, financial function, statistical function, information function, loading is grand and robotization function, database functions and multidimensional data set function in one or more.
Further, the priority of operations of described operational symbol order is pre-defined by the user.
Further, when described original data type showed as child nodes, described child nodes showed the data message of original data type representative; And/or described operational symbol is when showing as father's node, and described father's node shows the computing information of described operational symbol representative.
Further, described original data type comprises numerical value, text, Boolean or the improper value that is positioned at cell; The data message of described original data type representative comprises the address information of the affiliated row and column of described original data type corresponding unit lattice, the title of the affiliated row of described original data type corresponding unit lattice or the title of affiliated row.
Further, the computing information of described operational symbol representative comprises the operation result of mathematical notation, function representation, self implication explain information and the active operator of operational symbol.
Further, described node is a kind of and multiple in square, circle and the three-dimensional shape, connects by linear, flechette-type or columniform figure between the described node, and described node utilizes predetermined symbol to represent whether can launch.
According to a further aspect in the invention, the invention provides a kind of evaluation of expression method, described method comprises: a certain node viewing area in the tree-shaped demonstration of described expression formula receives prearranged signals; Calculating is the result of calculation of the subexpression of the tree of root node or subtree representative with described node; With show described result of calculation according to predetermined way.
Further, described prearranged signals is that the user utilizes input equipment to select signal at the frame of described node viewing area, clicks signal, double-clicks signal or stops the scheduled duration signal, and described predetermined way is to eject new dialog box mode, annotations and comments mode or in the present node display mode.
Compared with prior art, the tree-shaped demonstration that the present invention carries out classification according to the priority of operations and the relation between operational symbol and the data of expression formula or formula makes the user be more readily understood the implication of described expression formula.Simultaneously, based on the tree-shaped demonstration evaluation of described expression formula, can make the user be more readily understood the evaluation process of described expression formula and obtain result of calculation more intuitively.
[description of drawings]
In conjunction with reaching ensuing detailed description with reference to the accompanying drawings, the present invention will be more readily understood, the structure member that wherein same Reference numeral is corresponding same, wherein:
Fig. 1 is the illustrative Computer Architecture of the computing machine that uses in one embodiment of the present of invention;
Fig. 2 is the method flow diagram of the tree-shaped display packing of the expression formula in one embodiment of the present of invention;
Fig. 3 is the part method flow diagram of the tree-shaped display packing of the expression formula in one embodiment of the present of invention;
Fig. 4 A-Fig. 4 I is the some synoptic diagram when utilizing the tree-shaped display packing of described expression formula that formula D=1.2*A+ (B-C)/3 is shown in one embodiment of the present of invention;
Fig. 5 is the method flow diagram of the evaluation technique of the expression formula in one embodiment of the present of invention;
Fig. 6 A-Fig. 6 F is the some synoptic diagram when utilizing the tree-shaped display packing of described formula to carry out publicity in one embodiment of the present of invention to show; With
Interface synoptic diagram when Fig. 7 shows publicity 1 for the tree-shaped display packing of utilizing described formula in one embodiment of the present of invention.
[embodiment]
Detailed description of the present invention is mainly come the running of direct or indirect simulation technical solution of the present invention by program, step, logical block, process or other symbolistic descriptions.Be the thorough the present invention that understands, in ensuing description, stated a lot of specific detail.And when not having these specific detail, the present invention then may still can realize.Affiliated those of skill in the art use these descriptions herein and state that the others skilled in the art in affiliated field effectively introduce their work essence.In other words, be the purpose of the present invention of avoiding confusion, owing to method, program and the composition known are readily appreciated that, so they are not described in detail.
Alleged herein " embodiment " or " embodiment " are meant special characteristic, structure or the characteristic that can be contained at least one implementation of the present invention.Different in this manual local " in one embodiment " that occur not are all to refer to same embodiment, neither be independent or optionally mutually exclusive with other embodiment embodiment.In addition, represent the sequence of modules in method, process flow diagram or the functional block diagram of one or more embodiment and revocablely refer to any particular order, also be not construed as limiting the invention.
In an embodiment of the present invention, the tree-shaped display packing of described expression formula and evaluation technique can be implemented to become the part of a module, a system or a system by software, hardware and both combinations thereof.Described expression formula is carried out the tree-shaped demonstration of classification according to the relation between priority of operations and operational symbol and the original data type, the processed original data type of leaf node ordinary representation wherein, such as numerical value and text or the like, wherein non-leaf node ordinary representation operational symbol.Especially, the present invention for convenience of description, operational symbol is herein not only represented arithmetic operator, comparison operator, text concatenation operator and the reference operators etc. of traditional sense, also contain simultaneously and represented multiple function, such as text function, date and time function, search and referencing function, logical function, engineering function, mathematics and trigonometric function or the like, promptly described herein operational symbol has more wide significance.
Since embodiments of the invention usually in conjunction with certain computing environment, computer system in other words hardware realize.So Fig. 1 and corresponding the description aim to provide realizing that the suitable computing environment in the embodiments of the invention carries out description simple and that summarize.As general environment the present invention is described although utilize the computing environment of on server or personal computer system, carrying out among Fig. 1, the program module of also can unifying in conjunction with the department of computer science of other type realizes but those skilled in the art should be appreciated that the present invention.
Generally speaking, program module comprises the structure of carrying out particular task or realizing routine, program, assembly, data structure and the other types of specific abstract data type.And, those skilled in the art will appreciate that the present invention can with such as comprise portable equipment, multicomputer system, based on microprocessor or computer system configurations such as programmable consumer electronics, small-size computer, mainframe computer implement.And the present invention also can implement in distributed computing environment, and it can be executed the task with the teleprocessing equipment that connects by network, and in distributed computing environment, program module can be arranged in both optional positions of local and remote memory device.
Please refer to Fig. 1, it shows the illustrative Computer Architecture of the computing machine 100 that uses in one embodiment of the present of invention.Described computing machine 100 is conventional desk-top computer or laptop, described computing machine 100 comprises CPU (central processing unit) (CPU) 101, comprises the system storage 104 of random-access memory (ram) 102 and ROM (read-only memory) (ROM) 103, and the system bus 105 of connected system storer 104 and CPU (central processing unit) 101.Described computing machine 100 also comprises the basic input/output (I/O system) 106 of transmission information between each device that helps in the computing machine and is used for the mass-memory unit 107 of storage operating system, application program and other program modules.
Described basic input/output 106 includes display 108 that is used for display message and the input equipment such as mouse, keyboard 109 that is used for user's input information.Wherein said display 108 and input equipment 109 all are connected to CPU (central processing unit) 101 by the input/output control unit 110 that is connected to system bus 105.Described basic input/output 106 can also comprise that input/output control unit 110 is to be used to receive and handle the input from a plurality of other equipment such as keyboard, mouse or electronic touch pens.Similarly, input/output control unit 110 also provides the output device that outputs to display screen, printer or other types.
Described mass-memory unit 107 is connected to CPU (central processing unit) 101 by the bulk memory controller (not shown) that is connected to system bus 105.Described mass-memory unit 107 and the computer-readable medium that is associated thereof provide non-volatile memories for computing machine 100.That is to say that described mass-memory unit 107 can comprise the computer-readable medium (not shown) such as hard disk or CD-ROM drive.
Be without loss of generality, described computer-readable medium can comprise computer-readable storage medium and communication media.Computer-readable storage medium comprises the volatibility that realizes with any method or the technology that is used to store such as information such as computer-readable instruction, data structure, program module or other data and non-volatile, removable and removable medium not.Computer-readable storage medium comprises RAM, ROM, EPROM, EEPROM, flash memory or its technology of other solid-state storage, CD-ROM, DVD or other optical memory, tape cassete, tape, disk storage or other magnetic storage apparatus.Certainly, the described as can be known computer-readable storage medium of those skilled in the art is not limited to above-mentioned several.
According to various embodiments of the present invention, described computing machine 100 can also be by being connected to the remote computer operation on the network such as networks such as the Internets.Also be that computing machine 100 can be connected to network 112 by the network interface unit 111 that is connected on the described system bus 105, in other words, also can use network interface unit 111 to be connected to the network or the remote computer system (not shown) of other types.
A plurality of program modules and data file can be stored in the mass-memory unit 107 and RAM of computing machine 100, and this can comprise the operating system 113 that is applicable to the control networked personal computer.Mass-memory unit 107 and RAM also can store one or more program modules simultaneously.Especially, can store electrons form application program 114 among described mass-memory unit 107 and the RAM.And spreadsheet applications 114 can be used for generation, visit and modification such as workbook 115.
According to one embodiment of present invention, spreadsheet applications 114 comprise the spreadsheet applications from Wuxi Yongzhong softcom limited.Yet should recognize, also can be used to the various aspects that other spreadsheet applications or other application programs that comprises expression formula from other manufacturers are embodied in this description or expection.Hereinafter, based on computing environment shown in Figure 1 to the present invention comprise the application program of expression formula, concrete enforcement in spreadsheet applications is done respectively further and is described.
Should understand, an expression formula is made of several original data types and operational symbol.Such as expression formula D=1.2*A+ (B-C)/3, wherein " * " is exactly the operational symbol of an expression multiplication, and 1.2 is exactly an original data type of representing constant.According to the priority of operations of expression formula and operational symbol that is comprised and original data type number, described expression formula can also comprise a subexpression, can certainly comprise a plurality of subexpressions, can regard subexpression " 1.2*A " and " (B-C)/3 " as such as expression formula D=1.2*A+ (B-C)/3, and operational symbol "+" formation.Described subexpression is again to be made of some operational symbols and original data type.Also be that operational symbol and original data type all are the elementary cells that constitutes expression formula or subexpression.
Described original data type can be one or more in numerical value, text, Boolean, improper value and the function parameter.Decide on different applied environments, wherein numerical value can be such as " 5621 " of decimal representation " 1864 ", octal representation or " 2009/10/12 " of express time; Described text can be such as character string " hello world ", " this is an apple "; Described Boolean can be such as expression correct " TRUE " and wrong " FALSE " of expression; Described function parameter can be that wherein the PROPER function is the text-processing function with the capitalization of the initial character in the word such as the exponential " 3 " of asking exponential function in 2 the cube, also such as being " this is an example " in "=PROPER (" this is an example ") ". ", " #N/A " etc.As seen, aspect some of this just original data type of listing.
Described operational symbol can be in arithmetic operator, comparison operator, text concatenation operator, reference operators and the function one or more, decides on different applied environments.Described function can for text function, date and time function, search with referencing function, logical function, engineering function, mathematics and trigonometric function, financial function, statistical function, information function, loading is grand and robotization function, database functions and multidimensional data set function in one or more.The priority of operations order of described operational symbol can be pre-defined by user or program module.In order to show the structure of described expression formula better, the inventor creatively is shown as tree structure with expression formula.
Please refer to Fig. 2, it shows the method flow diagram of the tree-shaped display packing 200 of the expression formula in one embodiment of the present of invention.The tree-shaped display packing 200 of described expression formula can be implemented in the program module that comprises expression formula such as tutorial application, engineering calculation application program and bank statistics analysis application etc.The tree-shaped display packing 200 of described expression formula comprises:
Because among the different embodiment, described expression formula can be different.No matter but described expression formula comprises what operational symbols and original data type, the operational symbol in the described expression formula all has the certain calculation priority orders, and at first the operational symbol with the lowest priority in the expression formula shows as root node.
For the operational symbol of the lowest priority in the expression formula, if described expression formula is comparatively simple, then the operand of this operational symbol may directly be original data type, can not split again.If described expression formula is comparatively complicated certainly, then the operand of this operational symbol may be a subexpression.When described operand is subexpression, it can be shown as stalk tree.
In one embodiment, for the process object of the operational symbol of lowest priority described in the described step 220, judging at first whether it is subexpression, also is step 242.
If the process object of described operational symbol is an original data type, then step 244 shows it as child nodes;
When if the process object of described operational symbol is subexpression, then step 246 shows it as a subtree, is specially at first the operational symbol of lowest priority in the subexpression root node as subtree is shown; Step 248 then continues the process object of the operational symbol of lowest priority in the subexpression to show as child nodes or subtree.Obviously for step 248, its essence still is step 240, promptly for an analysis procedure for displaying that comprises the expression formula of subexpression, can be considered as a recurring problem.For different expression formulas or subexpression, those skilled in the art can utilize above-mentioned analysis that it is shown as one tree.
In conjunction with a specific embodiment, suppose that described expression formula is D=1.2*A+ (B-C)/3, by analysis as can be known, the operational symbol of lowest priority is "+" in the described expression formula, the process object of described operational symbol "+" is subexpression " 1.2*A " and subexpression " (B-C)/3 ", then at first operational symbol "+" is shown as root node, shown in Fig. 4 A.
Then subexpression " 1.2*A " and subexpression " (B-C)/3 " are shown as subtree, the operational symbol of lowest priority is " * " in the wherein subexpression " 1.2*A ", the process object of described operational symbol " * " is original data type " 1.2 " and " A ", described operational symbol " * " is continued to show as the root node of first subtree, and original data type " 1.2 " and " A " shown as child nodes, shown in Fig. 4 C.
The operational symbol of lowest priority is "/" in the wherein subexpression " (B-C)/3 ", and the process object of described operational symbol "/" is subexpression " B-C " and original data type " 3 ".The root node of described operational symbol "/" as second subtree shown, and original data type " 3 " is shown as child nodes, shown in Fig. 4 D.And the operational symbol for lowest priority in the subexpression " B-C " is "-", and the process object of described operational symbol "-" is original data type " B " and " C ".Described operational symbol "-" is continued to show as the root node of lumbang, and original data type " B " and " C " are shown as child nodes, shown in Fig. 4 E.So far, described expression formula D=1.2*A+ (B-C)/3 is shown as one tree.
In certain embodiments, described subexpression can temporarily be shown as a node, and a node that can launch or similar expression in other words is as the node 402 that shows among Fig. 4 B, Fig. 4 C, Fig. 4 D.Described then node 402 is being chosen, is clicking, is being double-clicked or staying for some time or the like by the user, after also promptly importing a certain signal, can launch to show, such as the node 402 of representing subexpression " 1.2*A " among the 4B by after the user click, be shown as the tree structure shown in Fig. 4 C.In other embodiment, " D=" also can also be shown as a node, place the upper strata of the root node of expression formula, show as Fig. 4 F.
Apparently, for different expression formulas, according to the type of what and the operational symbol that embody the operator precedence order that comprises in the formula, operational symbol, the recurrence processing procedure in the tree-shaped display packing 200 of described expression formula may corresponding increase and minimizing.On the other hand, for different embodiment, because technician's difference of implementing, that the profile of described leaf node can be shown as is square, a kind of and multiple in circle and the three-dimensional shape, shown in Fig. 4 G; The displaying contents of described leaf node can show described data itself, also can show the data message of described data representative, shown in Fig. 4 H.In Fig. 4 H illustrated embodiment, described leaf node is represented weight, unit is that kilogram and concrete numerical value are 88, so described leaf node can show " weight " respectively, " 88 kilograms ", " kilogram ", in " 88 " or " 88 kilograms of weight " one or several, the display mode of described leaf node can be to automatically switch every the schedule time, also can be to switch (such as the left click on described leaf node of user's mouse) after receiving user's respective input signals, can also be to show (mouse such as the user rests on the schedule time on the described leaf node) with annotations and comments or ejection dialog box mode.Correspondingly, when described operational symbol showed as father's node or " root " node, described father's node also can show described operational symbol itself, also can show the computing information or the operation result of described operational symbol representative, shown in Fig. 4 I.In Fig. 4 I illustrated embodiment, described father's node represent addition+, so described father's node can be shown as "+", " SUM ", " adding ", " SUM: return all digital sums in the designating unit lattice zone respectively." and operation result " 16 " in one or several; and; the display mode of described father's node can be to automatically switch every the schedule time, also can be to switch after receiving user's respective input signals, can also be with annotations and comments or ejects the dialog box mode and show.Can show relation between each node by curve, broken line, strip, column or other connected modes between the nodes at different levels in addition.Described node also can utilize the symbol such as "+" and "-" to represent whether it can continue to launch.
In sum, the tree-shaped display packing of expression formula of the present invention the expression formula of complexity can be converted into that layer of structure is clear, operation relation clearly tree structure show.The tree-shaped display packing of described expression formula may be embodied to and is an expression formula display module or an expression parsing auditing module in tutorial application, engineering calculation application program, bank statistics analysis application and the spreadsheet applications.When the user utilizes this module that the expression formula of complexity is analyzed, can get a thorough understanding of the implication of expression formula fast.
Based on the tree-shaped demonstration of above-mentioned expression formula, the present invention also provides a kind of evaluation technique of expression formula, can continue with reference to figure 5, and it shows the method flow diagram of the evaluation technique 500 of the expression formula in one embodiment of the present of invention.The evaluation technique 500 of described expression formula comprises:
Step 506 shows described result of calculation according to predetermined way.Described predetermined way can be to eject new dialog box mode, annotations and comments mode or in the present node display mode.
Obviously, utilize the evaluation technique 500 of expression formula shown in Figure 5 can make the user intuitively, clearly check the operation result of each node and the evaluation process of whole expression formula in the tree-shaped demonstration.Mistake in the easier discovery computing or logic or the like information.
Because when in different program modules, implementing, on the one hand, because the characteristics that described program module self is implemented, the tree-shaped display packing of described expression formula may need to be converted to technological means such as the tree-shaped conversion of postfix expression, postfix expression and evaluation of expression according to infix expression and implement, these technological means all are contents well-known to those skilled in the art, and this paper is not repeated.On the other hand, the tree-shaped display packing of described expression formula can also be optimized further according to the characteristics of different program modules, so the present invention provides the application scheme of tree-shaped display packing in spreadsheet applications of described expression formula simultaneously.
Usually, the object of the formula manipulation in the spreadsheet applications all is the set of cell or cell.Data in the cell can be one or more (function parameter or constant also may be that the user manually is input in the formula) in numerical value, text, Boolean, improper value and the function parameter.Wherein numerical value can be such as " 5621 " of decimal representation " 1864 ", octal representation or " 2009/10/12 " of express time; Described text can be such as character string " hello world ", " this is an apple "; Described Boolean can be such as expression correct " TRUE " and wrong " FALSE " of expression; Described function parameter can be such as the exponential " 3 " of asking exponential function in 2 the cube, can also be " this is an example " in "=PROPER (" this is an example ") " that wherein the PROPER function is the text-processing function with the capitalization of the initial character in the word. ", " #N/A " etc.That is to say that in electrical form embodiment, described original data type comprises numerical value, text, Boolean, improper value or the function parameter that is positioned at cell.Certainly comprise that also the user manually is input to constant or the variable in the formula.And preferably, described original data type can also show the data message of described original data type corresponding unit lattice representative when showing as node.Such as the title of row or the title of affiliated row under the address information of row and column under the described original data type corresponding unit lattice, the described original data type corresponding unit lattice.In a specific embodiment, the address is called " unit price " for the name of H row under the cell of " H5 ", the numerical value of described cell is " 10 ", can be shown as in " H5 ", " unit price " and " 10 " any one when then it shows as leaf node.
Based on same principle, when described operational symbol shows as node, also can show the computing information of described operational symbol representative.The computing information of described operational symbol can be mathematical notation, textual representation or the function representation etc. of described operational symbol self; The computing information of described operational symbol can also be self implication explain information and current operation result of described operational symbol.
In a specific embodiment, suppose that Zhang San is the three grades teachers form master of a primary school of just having taken up an official post, when checking the classmate's of class last term school report, from spreadsheet applications, obtain the student performance table 600 of former form master's record as shown in Figure 6A.Write down the achievement of final examination last term Chinese language, mathematics and moral education three subjects of classmate A, classmate B, classmate C, classmate D and classmate E in the described student performance 600 respectively, and also comprised the evaluation result that the former teacher form master gives in the described student performance table 600.Mr. Zhang recognizes that Chinese language and mathematics all are 100 full marks, and moral education is 60 full marks, obtains following formula simultaneously in the evaluation result hurdle in the E2 cell:
=IF (AVERAGE (B2:C2, D2*100/60)＞85, CONCATENATE (A2, " outstanding
"), ((B2:C2, D2*100/60)＜60, (A2's CONCATENATE " fails AVERAGE IF
"), CONCATENATE (A2, " common "))),--------formula 2
Mr. Zhang just needs the implication of this formula of concrete analysis when analyzing the former teacher's form master assessment method so now, but obvious described formula 2 be do not allow intelligible.Mr. Zhang's formula of utilizing the tree-shaped display packing of described formula to implement to become is checked after module shows described formula again so, obtains the formula display result shown in Fig. 6 B.Obviously, understand at an easy rate by the tree structure shown in Fig. 6 B as described in formula 2.
More particularly, Mr. Zhang checks after module shows described formula again at the formula that the tree-shaped display packing of utilizing described formula implements to become, and what at first obtain is formula display result shown in Fig. 6 C, according to described formula display result, judge described formula easily
JudgeCondition "
Average "Whether
Greater than " 85 ", if, then
Connect text"
Classmate A" and "
Outstanding"; If not, then continue "
Judge".Described "
Average "Be the average of what data, can continue to know by expanding node 601, described continuation "
Judge" judging any content, can also continue to continue to know by expanding node 602.
For this reason, Mr. Zhang continues to click described node 601, continues to obtain the formula display result shown in Fig. 6 D, according to described formula display result, judges easily, and is described
AverageBe
Chinese language,
Number Learn With
Moral education 100/60The average of three contents just will
Moral educationMark be converted to after 100 fens full marks values with
Chinese language,
MathematicsAverage, also be student's average achievement.So far, can learn that the former form master is assessed as outstanding the student more than 85 minutes average achievement.
Simultaneously, Mr. Zhang continues to click described node 602, continues to obtain the formula display result shown in Fig. 6 E, according to described formula display result, judge easily, when student's average achievement below 85 minutes the time, continue "
Judge"
AverageWhether less than
60If, less than, then
Connect text"
The classmate A" and "
Fail"; If greater than, then
Connect text"
Classmate A" and "
Common".So far, can learn that the former form master is assessed as average achievement common 60 minutes-85 minutes student, fail and average achievement is assessed as the student below 60 minutes.
Obviously, the tree-shaped display packing by formula of the present invention can be readily appreciated that complicated formula, compares the formula 2 that shows with the prior art neutral line, utilizes the tree-shaped display result such as the formula that shows among Fig. 6 F, and the user can obtain better experience.Certainly, in further embodiments, the displaying contents of each father's node can be the operation result of operational symbol, unit of operation result or the like, can also help the user in computation process, to understand each the step operation result of computing and the unit of operation result, and then whether can judge calculating process wrong etc.Again or, show successively according to priority orders the operation result of each father's node, can to help the user to view whole computing flow process up to final operation result.Usually, after described expression formula is expressed as one tree, can receive subscriber signal or make by oneself strategy with nodes at different levels from top to bottom, from left to right launch successively, to meet user's visual custom.
Certainly, just the present invention is described among Fig. 6 A-Fig. 6 F by an example, can not represent whole aspect of the present invention, for example, in another embodiment, the tree-shaped display result of aforementioned formula 1 as shown in Figure 7, it has utilized the cell in the spreadsheet applications to show the tree-shaped display result of described formula 1.
Obviously, above-mentioned explanation has fully disclosed the specific embodiment of the present invention.It is pointed out that and be familiar with the scope that any change that the person skilled in art does the specific embodiment of the present invention does not all break away from claims of the present invention.Correspondingly, the scope of claim of the present invention also is not limited only to described embodiment.
Claims (12)
1. the tree-shaped display packing of an expression formula, described expression formula comprises some operational symbols and original data type, it is characterized in that, and it comprises:
The operational symbol of lowest priority in the expression formula is shown as root node; With
The process object of described operational symbol is shown as child nodes or subtree,
Wherein, the process object of described operational symbol is that subexpression is or/and original data type.
2. the tree-shaped display packing of expression formula according to claim 1 is characterized in that,
If the process object of described operational symbol is an original data type, then show as child nodes;
If the process object of described operational symbol is subexpression, do not show as child nodes when then not launching that show as subtree during expansion, described subtree is shown as:
The operational symbol of lowest priority in the subexpression root node as subtree is shown; With
The process object of the operational symbol of lowest priority in the described subexpression is continued to show as child nodes or subtree.
3. the tree-shaped display packing of expression formula according to claim 1 is characterized in that, described original data type comprises one or more in numerical value, text, Boolean, improper value and the function parameter.
4. the tree-shaped display packing of expression formula according to claim 1 is characterized in that, described operational symbol comprises one or more in arithmetic operator, comparison operator, text concatenation operator, reference operators and the function.
5. the tree-shaped display packing of expression formula according to claim 4, it is characterized in that, described function comprises text function, date and time function, search with referencing function, logical function, engineering function, mathematics and trigonometric function, financial function, statistical function, information function, loading is grand and robotization function, database functions and multidimensional data set function in one or more.
6. according to the tree-shaped display packing of the arbitrary described expression formula of claim 1 to 5, it is characterized in that the priority of operations order of described operational symbol is pre-defined by the user.
7. according to the tree-shaped display packing of the arbitrary described expression formula of claim 1 to 5, it is characterized in that when described original data type showed as node, described node showed the data message of original data type representative; And/or described operational symbol is when showing as node, and described node shows the computing information of described operational symbol representative.
8. the tree-shaped display packing of expression formula according to claim 7 is characterized in that, described original data type comprises numerical value, text, Boolean or the improper value that is positioned at cell; The data message of described original data type representative comprises the address information of the affiliated row and column of described original data type corresponding unit lattice, the title of the affiliated row of described original data type corresponding unit lattice or the title of affiliated row.
9. the tree-shaped display packing of expression formula according to claim 7 is characterized in that, the computing information of described operational symbol representative comprises the operation result of mathematical notation, function representation, self implication explain information and the active operator of operational symbol.
10. the tree-shaped display packing of expression formula according to claim 1, it is characterized in that, described node is a kind of and multiple in square, circle and the three-dimensional shape, connect by linear, flechette-type or columniform figure between the described node, described node utilizes predetermined symbol to represent whether can launch.
11. an evaluation of expression method is applied to it is characterized in that it comprises in the tree-shaped demonstration of claim 1 or 2 described expression formulas:
A certain node viewing area in the tree-shaped demonstration of described expression formula receives prearranged signals;
Calculating is the result of calculation of the subexpression of the tree of root node or subtree representative with described node; With
Show described result of calculation according to predetermined way.
12. evaluation of expression method according to claim 11, described prearranged signals is that the user utilizes input equipment to select signal at the frame of described node viewing area, clicks signal, double-clicks signal or stops the scheduled duration signal, and described predetermined way is to eject new dialog box mode, annotations and comments mode or in the present node display mode.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010577669.9A CN102004613B (en) | 2010-12-07 | 2010-12-07 | The tree-shaped display packing of expression formula and evaluation technique |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010577669.9A CN102004613B (en) | 2010-12-07 | 2010-12-07 | The tree-shaped display packing of expression formula and evaluation technique |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102004613A true CN102004613A (en) | 2011-04-06 |
| CN102004613B CN102004613B (en) | 2015-12-09 |
Family
ID=43812001
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010577669.9A Active CN102004613B (en) | 2010-12-07 | 2010-12-07 | The tree-shaped display packing of expression formula and evaluation technique |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102004613B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104166588A (en) * | 2013-05-16 | 2014-11-26 | 腾讯科技（深圳）有限公司 | Information processing method and device for read content |
| CN104615737A (en) * | 2015-02-10 | 2015-05-13 | 百度在线网络技术（北京）有限公司 | Search box based computing method and device |
| CN105431789A (en) * | 2014-07-14 | 2016-03-23 | 三菱电机株式会社 | Plc system and arithmetic expression data creation assistance device |
| CN105574032A (en) * | 2014-10-15 | 2016-05-11 | 阿里巴巴集团控股有限公司 | Rule matching operation method and device |
| CN107741922A (en) * | 2017-10-18 | 2018-02-27 | 山东浪潮通软信息科技有限公司 | A kind of operational formula treating method and apparatus |
| CN108304177A (en) * | 2017-01-13 | 2018-07-20 | 辉达公司 | Calculate the execution of figure |
| CN110795526A (en) * | 2019-10-29 | 2020-02-14 | 北京林业大学 | Mathematical formula index creating method and system for retrieval system |
| CN113220299A (en) * | 2021-05-28 | 2021-08-06 | 北京达佳互联信息技术有限公司 | Graphical display method and device |
| CN114140091A (en) * | 2021-12-07 | 2022-03-04 | 中国建设银行股份有限公司 | Operation record display method, device, equipment and medium |
| CN115169290A (en) * | 2022-07-19 | 2022-10-11 | 上海中汇亿达金融信息技术有限公司 | Method for identifying expression computation paths |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1832419A (en) * | 2005-03-08 | 2006-09-13 | 华为技术有限公司 | Analytic method of expression type |
| CN101425007A (en) * | 2007-10-29 | 2009-05-06 | 珠海金山软件股份有限公司 | Apparatus and method capable of structuredly displaying electronic table function cue |
-
2010
- 2010-12-07 CN CN201010577669.9A patent/CN102004613B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1832419A (en) * | 2005-03-08 | 2006-09-13 | 华为技术有限公司 | Analytic method of expression type |
| CN101425007A (en) * | 2007-10-29 | 2009-05-06 | 珠海金山软件股份有限公司 | Apparatus and method capable of structuredly displaying electronic table function cue |
Non-Patent Citations (1)
| Title |
|---|
| 何志宏等: "《表达式与二叉树的相互转换》", 《电脑知识与技术》, vol. 6, no. 5, 15 February 2010 (2010-02-15) * |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104166588A (en) * | 2013-05-16 | 2014-11-26 | 腾讯科技（深圳）有限公司 | Information processing method and device for read content |
| CN105431789A (en) * | 2014-07-14 | 2016-03-23 | 三菱电机株式会社 | Plc system and arithmetic expression data creation assistance device |
| US10018983B2 (en) | 2014-07-14 | 2018-07-10 | Mitsubishi Electric Corporation | PLC system and arithmetic-expression-data-creation supporting apparatus |
| CN105574032A (en) * | 2014-10-15 | 2016-05-11 | 阿里巴巴集团控股有限公司 | Rule matching operation method and device |
| CN104615737A (en) * | 2015-02-10 | 2015-05-13 | 百度在线网络技术（北京）有限公司 | Search box based computing method and device |
| CN108304177A (en) * | 2017-01-13 | 2018-07-20 | 辉达公司 | Calculate the execution of figure |
| CN107741922A (en) * | 2017-10-18 | 2018-02-27 | 山东浪潮通软信息科技有限公司 | A kind of operational formula treating method and apparatus |
| CN110795526A (en) * | 2019-10-29 | 2020-02-14 | 北京林业大学 | Mathematical formula index creating method and system for retrieval system |
| CN110795526B (en) * | 2019-10-29 | 2022-08-12 | 北京林业大学 | Mathematical formula index creating method and system for retrieval system |
| CN113220299A (en) * | 2021-05-28 | 2021-08-06 | 北京达佳互联信息技术有限公司 | Graphical display method and device |
| CN114140091A (en) * | 2021-12-07 | 2022-03-04 | 中国建设银行股份有限公司 | Operation record display method, device, equipment and medium |
| CN115169290A (en) * | 2022-07-19 | 2022-10-11 | 上海中汇亿达金融信息技术有限公司 | Method for identifying expression computation paths |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102004613B (en) | 2015-12-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102004613B (en) | The tree-shaped display packing of expression formula and evaluation technique | |
| Hofmann et al. | Text mining and visualization: Case studies using open-source tools | |
| US10515145B2 (en) | Parameterizing and working with math equations in a spreadsheet application | |
| Fowler et al. | Web application design handbook: Best practices for web-based software | |
| CN109923535B (en) | Insight object as portable user application object | |
| CN108292295B (en) | Parameterization and processing of mathematical equations in spreadsheet applications | |
| Cho et al. | Statistics in MATLAB: A primer | |
| Nolan et al. | Dynamic, interactive documents for teaching statistical practice | |
| US20170199862A1 (en) | Systems and Methods for Creating an N-dimensional Model Table in a Spreadsheet | |
| Almgerbi et al. | A systematic review of data analytics job requirements and online-courses | |
| Buttrey et al. | A Data Scientist's Guide to Acquiring, Cleaning, and Managing Data in R | |
| Pollock III et al. | An R companion to political analysis | |
| Tsoni et al. | Incorporating Data Warehouses into Data Pipelines for Deploying Learning Analytics Dashboards | |
| Tyrrell | SPSS: Stats practically short and simple | |
| Ahlersten | An introduction to MATLAB | |
| Frost et al. | A model curriculum for K-12 computer science: Level I objectives and outlines | |
| Savelyev et al. | Augmenting geovisual analytics of social media data with heterogeneous information network mining—cognitive plausibility assessment | |
| WO2022150114A1 (en) | Simulated thumbnail previews for files | |
| Brooks | Problem solving with Fortran 90: for scientists and engineers | |
| Gaubatz | A Survivor's Guide to R: An Introduction for the Uninitiated and the Unnerved | |
| Moody | Basic econometrics with STATA | |
| Tsoni et al. | Data pipelines for educational data mining in distance education | |
| Baldwin | Mastering Tableau | |
| Dotkulova et al. | Search Optimization of Tutorial Web-Service Architecture for Cognitive Mathermatical Education | |
| US20230342383A1 (en) | Method and system for managing workflows for authoring data documents |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP03 | Change of name, title or address |
Address after: 224100 Jiangsu Province, Wuxi City District Zhenze Wuxi Road No. 18 (National) fish Software Park building D block Patentee after: Evermore software Limited by Share Ltd Address before: A road of national hi tech Industrial Development Zone, Wuxi City, Jiangsu province 214135 No. 18 Wuxi (National) software park D District 5, 6 layers of Taurus Patentee before: Wuxi Evermore Software Co., Ltd. |