CN1774710A

CN1774710A - System and method in a data table for exporting and importing recursive scalable templates

Info

Publication number: CN1774710A
Application number: CNA2004800103924A
Authority: CN
Inventors: 让－雅克·奥里格利亚; 弗雷德里克·鲍肖特
Original assignee: International Business Machines Corp
Current assignee: International Business Machines Corp
Priority date: 2003-04-18
Filing date: 2004-02-27
Publication date: 2006-05-17
Also published as: EP1618490A2; WO2004092976A2; WO2004092976A3

Abstract

The present invention is directed to a method, system and program for exporting, from a source electronic data table comprising a plurality of objects having parent-child relationships to a destination electronic data table, one or several of objects with their filiation. The method for use in a computer comprises the steps of : defining objects and associating with each object one or a plurality of parent objects or one or a plurality of child objects or both; associating with each object a unique object reference (OR) equal to a prime number; determining for each object whether said object is associated with at least a child object or not : if said object is not associated with at least one child object, defining a filiation reference (FR) equal to 1; if said object is associated with at least one child object, defining a filiation reference (FR) equal to the product of two terms : a first term, equal to the product of each object reference (OR) associated with each child object of said object: a second term equal to the least common multiplier (LCM) of the filiation references of the child objects associated with said object : receiving an export command for exporting one or a plurality of selected objects with associated child objects; associating with each object, a selected children variable (SC) for determining whether or not said object belongs to the set of child objects associated with selected objects, said selected children variable being equal to : a first Boolean value if the least common multiplier (LCM) of the filiation references of the one or plurality of selected objects is a multiple of the own object reference: a second Boolean value if the least common multiplier (LCM) of the filiation references of the one or plurality of selected objects is not a multiple of the own object reference: exporting to the destination data table, the selected objects and the objects with a selected children variable (SC) equal to said first Boolean value.

Description

Be used for deriving and import the system and method for the tables of data of recursive scalable template

Technical field

The present invention relates to the field of information processing by digital machine, particularly a kind of tables of data is the method and system in the electrical form preferably, and it is used for deriving and importing recursive scalable template.

Background technology

A kind of basic value of electrical form is to organize data into row and column, the loaded down with trivial details calculating of robotization simultaneously.Be organized into the typical case of such one group of data of row and column, common and valuable example is a range of cells.Even range of cells receives formal and strict definition in spreadsheet environment, but it is enough flexible, the information that makes can be included in the set of individual unit lattice scope or some range of cells.Therefore, range of cells is quite useful object.Range of cells can be used as whole entity and defines and handle.For example, it can be in electrical form be copied into another place from one, perhaps is copied into another electronic form file from an electronic form file.Range of cells is widely used in the application of exploitation in the electrical form field.Very continually, range of cells is arranged according to certain structure, becomes the structuring range of cells like this.The content of each cell is defined within the element, and wherein element is defined as delegation's structuring range of cells, repeats the element specific times of identical type then, so that the pieces of information of stores/processes variable number.Usually, use some examples of similar structures range of cells.Do not having under the in fact available current background of other instrument, creating the example of such similar structures range of cells by the operation of shearing/copy and paste continually.For the ever-increasing information of quantity being kept high level Based Intelligent Control, human needs's tissue or this information of structuring.Hierarchy model often is used owing to allow nested structure.The typical case and the known example of this hierarchy are the directory trees of computer operating system such as DOS or the Windows of Microsoft (form).Root directory can include file and/or a plurality of catalogue, and these catalogues itself also can include file and/or a plurality of catalogues or the like.Recursiveness help structured message and maintenance are to its Based Intelligent Control.Recursiveness this need in spreadsheet environment, also be applicable to the structuring range of cells.When definition and some examples of utilization structure range of cells in electronic form file, frequently according to can between the different electronic form files or even the specific superstructure layout of in single electronic form file, duplicating or " structuring range of cells array " come structuring they self.In such structuring range of cells array, commonly, some other structuring range of cells of searching some structuring range of cells of following identical middle superstructure and following other middle superstructure.Then, can bar structure range of cells array regard the set of the middle superstructure of gathering of structuring range of cells as.Under the current background of conditional electronic form, create the example of this structuring range of cells array continually by the operation of shearing/copy and paste.

The new example of creating the structuring range of cells is complicated and time-consuming, and this is particularly because traditional range of cells has shown stronger restriction:

(i) structural information (as columns, line number), format information (as font style, color or frame) and content information (for example, formula or original-or information-data) mixed,

(ii) the size of range of cells is fixed at given time.

Therefore, when the electrical form user wanted to create another range of cells with same structure, he needed to carry out continuously several operations.He needs:

1. copy-paste existing structured range of cells,

2. distinguish zone that comprises original or information data and the zone that comprises Versatile content such as formula,

3. empty the structuring range of cells that is copied of the raw data that is copied, attempt to keep structure, form and Versatile content simultaneously,

4. according to his new needs, adjust the size of the structuring range of cells that is copied.

5. final, fill original data region with default value, so that alleviate data input subsequently.

In addition, before copy and paste structuring range of cells, the user is necessary for the structuring range of cells that is copied and prepares the place, exists like this to override so be lost in the risk that purpose is located in the information that is pre-existing in.When especially working as the structuring range of cells handled and increasing on size and complicacy, this operational chain becomes loaded down with trivial details, time-consuming soon and is easy to make mistakes.

Upgrading the structuring range of cells also is complicated, time-consuming and error-prone extremely frequently.This renewal comprises to be added new element and revises existing element.In spreadsheet environment, can carry out several modifications and without any particular problem.Yet, be not this situation as just inserting for some modification.For example, if increase row by means of traditional function such as the capable insertion method of electrical form, that is then created is about to be sky.This means the value of each cell that needs each element of input.Input data or the operation of execution copy/paste mean bigger workload for the user, and the content of each element is known to a certain extent, but should follow the general structure of structuring range of cells.And, insert the content that the normal electrical sub-table function of function may jeopardize some adjacent elements such as row.The better example that jeopardizes the insertion of adjacent element is that row is inserted in the range of cells, wherein on each row, such as C17 or more generally the cell of (Cn) points to cell in the previous row by the formula of (Cn-1)+(Bn) such as C16+B17 or more generally.After the going between 16 and 17 of being expert at inserted, formula among the cell C18 becomes C16+B18 but not general formula C17+B18, perhaps more generally, be expert at (n-1) and (n) between row insert after, the formula in the cell (Cn+1) becomes (Cn-1)+(Bn+1) but not general formula (Cn)+(Bn+1).As second example, existence must run through the situation that the structuring range of cells is as one man made amendment.Now, this can only finish by the specific copy-paste operation that puts on the definite zone that will be modified.When especially working as the structuring range of cells handled and increasing on size and complicacy, it be very difficult for this can to confirm.

The element of deletion structuring range of cells is error-prone operation.In fact, may jeopardize the content of some adjacent elements such as the ordinary electronic form function of row delete function, thereby cause debatable quoting (#REF result), perhaps what is worse, causing may impalpable wrong formula.Addressing this problem needs additional " context intelligence ", and it considers the structure of the structuring range of cells of generation element deletion.When calling traditional delete function when the user selects one or more cells in electrical form after, the another kind of needs appears.If this selection belongs to the structuring range of cells, then what wants to carry out for the user and may produce ambiguity by means of menu or by calling delete function by " deletion " key.Eliminating this ambiguity now can only be by selecting to want deleted definite zone to finish, and especially along with the structuring range of cells of being handled increases on size and complicacy, it be very difficult for this can to confirm.Addressing this problem needs additional " context intelligence ", so that detect this situation, utilizes the structure of structuring range of cells, and provides relevant option to the user.

When relating to recurrence, create the new example of structuring range of cells array even complicated and time-consuming more, this specifically is because structuring range of cells array relates to dual other structure of level:

Than low level, must create a plurality of of structuring range of cells and or even the set of different example.As previously mentioned, this operation itself is with regard to because the restriction of conventional elements lattice scope and complexity, time-consuming and be easy to make mistakes.

In higher level, the establishment of structuring range of cells example will require the electrical form user to carry out some operations:

1. identification is as the existing example of the structuring range of cells array of quoting of creating new example.

2. be located in the square preparatively new example of preserving in purpose, wherein have the risk that may override thereby lose any information that is pre-existing in.

3. quoting example and copy-paste the destination structuring range of cells array.

4. according to his/her new needs, adjustment is the structure of the structuring range of cells array example of establishment newly, and this is to realize by one or several middle superstructure of deleting or introducing structuring range of cells example in this array.

5. remove the content of each example that is included in the structuring range of cells in this array.

6. final, with each example of relevant default value interstitital texture range of cells.

When the size increases of this structuring range of cells array, preserve the required memory space of this structuring range of cells array and may become surprisingly high.On the other hand, the pith of each element of this structuring range of cells array may be made up of and without any customer-furnished data the output field that comprises formula.These fields are similarly for each element, and comprise redundant information.From final user's angle, because this information is useful to a certain extent, so it is not redundant, but owing to can rebuild this information according to the basic structure of structuring range of cells array, so it is redundant.Storage and/or to pass on this redundant information be a kind of waste, if exist a kind of mechanism will allow only to store/pass on information data and with the relevant information of basic structure of structuring range of cells array, then can avoid this waste.

Steven J.Dubnoff is the United States Patent (USP) 5 of " System for generatingworksheet files for electronic spreadsheets (being used to generate the Worksheetfile of electrical form) " in the denomination of invention on March 3rd, 1989,033,009th, interesting prior art document.This invention has proposed can be integrated so that generate the mode data of Worksheetfile and the notion of variable data by the Worksheetfile maker.Yet this invention has shown a lot of restrictions, thereby has stoped it to solve a basket that proposes above, wherein particularly:

It is intended to produce the new electrical form of deriving from two set that import files, needs to create and handle the novel entities in the existing electronic form file that this user is familiar with simultaneously in user's applied environment.

It does not comprise the mechanism that the permission different with conventional electrical form instrument directly upgraded derives electrical form.

It is not included in each the ability of example of variable number of the different structure of handling variable number in the same electronic form file and these structures.Granularity is confined to electronic form file, and desired particle size is the granularity of structuring range of cells.

So-called " file layout standard " be mixed structure information (as the number and the relative position of row and column), performance information (for example, font, color, background etc.), content information (as formula etc.) in fact.

As defined in independent claims, the present invention relates to a kind of being used for exports to method, the system and program of target electronic tables of data with one or several object with its branch from the source spreadsheet, and wherein the source spreadsheet comprises a plurality of objects with classification relationship.This method that is used for computing machine may further comprise the steps:

The definition object;

One or more parent objects or one or more subobject or both are associated with each object;

Unique object reference (OR) that will equal prime number is associated with each object;

At each object, determine whether described object is associated with at least one subobject:

If described object is not associated with at least one subobject:

Definition branch quotes (FR) and equals 1;

If described object is associated with at least one subobject:

Definition branch quotes (FR) and equals following two product:

First, equal the product of each object reference (OR) of being associated with each subobject of described object:

П _{I ∈ F}OR _i, wherein gather the set of F corresponding to the subobject that is associated with described object;

Second, equal the lowest common multiple (LCM) that the branch of the subobject that is associated with described object quotes:

LCM ({ FR _i) _{I ∈ F}, wherein gather the set of F corresponding to the subobject that is associated with described object;

Reception is used to derive one or more export (swf) commands with selected object of correlator object;

To select sub-variable (SC) and be associated with each object, wherein said selected sub-variable (SC) is used for determining whether described object belongs to the set of the subobject that is associated with selected object, and described selected sub-variable equals:

If the lowest common multiple that the branch of these one or more selected objects quotes (LCM) is the multiple from object reference, then be first Boolean:

LCM ({ FR _i) _{I ∈ S}Modulo OR=0, wherein S set is corresponding to the set of selected object;

If the lowest common multiple that the branch of these one or more selected objects quotes (LCM) is not the multiple from object reference, then be second Boolean:

LCM ({ FR _i) _{I ∈ S}Modulo OR ≠ 0, wherein S set is corresponding to the set of selected object.

Selected object and the object that selected sub-variable (SC) equals described first Boolean are exported to target matrix.

According to specific embodiment, one or more parent objects or one or more subobject or both be may further comprise the steps with the step that each object is associated:

In the source data table, define recursive scalable template, recurrence element, scalable template, as object with classification relationship.

The recurrence element that is defined as subobject is associated with the recursive scalable template that each is defined as parent object;

One or more scalable templates that are defined as subobject are associated with the recurrence element that each is defined as parent object.

According to a particular embodiment of the invention, recursive scalable template comprises the recurrence element, and it comprises one or more scalable templates; The recursive scalable template example comprises along the dimension ordering of first tables of data and alignment and according to recursive scalable template and the continuous recurrence element example of structurized variable number; Each recurrence element example has along the variable-size of described first tables of data dimension, and along the identical size of second tables of data dimension; Recurrence element example comprises one or more scalable template instances; Each scalable template instances of each recurrence element example aligns along described first tables of data dimension; Each scalable template instances in each recurrence element example aligns along second tables of data dimension; Scalable template instances comprises according to scalable template and the element of structurized variable number; Element is defined as data area; Data area comprises one or more data.

According to another specific embodiment of the present invention, this method is further comprising the steps of:

Reception is used for one or more selected objects with correlator object are imported to from the source data table importing order of target matrix;

The described one or more selected objects with correlator object that will not be defined in target matrix import to described target matrix from described source data table;

One or more parent objects or one or more subobject or among both each are imported into object to be associated;

Unique object reference (OR) that will equal prime number is associated with the object that each is imported into, and described prime number is unique in the middle of defined all objects in target matrix;

If described object is not associated with at least one subobject:

Definition branch quotes (FR) and equals 1;

If described object is associated with at least one subobject:

Definition branch quotes (FR) and equals following two product:

LCM ({ FR _i) _{I ∈ F}, wherein gather the set of F corresponding to the subobject that is associated with described object.

Other embodiment of the present invention is provided in appended dependent claims.

Acronym

For more for purpose of brevity, will use following acronym.

EF representative element form

EP representative element summary (profile)

MEF representative element element format

MEP representative element element summary

RE represents the recurrence element

RME represents recurrence unit element

RST represents recursive scalable template

RSTI represents the recursive scalable template example

ST represents scalable template

STI represents scalable template instances

Description of drawings

Figure 1A is the synoptic diagram that can implement computer system of the present invention.

Figure 1B is used to realize the synoptic diagram that comprises the software systems of operating system, application software and user interface of the present invention.

Fig. 2 shows the preferred electron form user interface that is used to manage RST according to the preferred embodiment of the invention.

Fig. 3 shows the preferred electron form user interface that is used to edit EF according to the preferred embodiment of the invention.

Fig. 4 shows the preferred electron form user interface that is used to edit EP according to the preferred embodiment of the invention.

Fig. 5 shows the preferred electron form user interface that is used to edit ST according to the preferred embodiment of the invention.

Fig. 6 shows the preferred electron form user interface that is used to edit RST according to the preferred embodiment of the invention.

Fig. 7 A, 7B, 7C, 7D, 7E and 7F show the structure of EF table (EFT), EP table (EPT), ST table (STT), ST descriptor table (STDT), STI table (STIT), RST derivation-importing table (RSTEIT) according to the preferred embodiment of the invention respectively.

Fig. 7 G has provided the diagram of the relation of setting up according to the preferred embodiment of the invention between table EFT, EPT, STT, STDT, STIT, RET, RSTT, RSTDT, RSTIT and RSTIDT.

Fig. 8 is the process flow diagram that the method for optimizing that is used to manage the RST object according to the preferred embodiment of the invention is shown.

Fig. 9 is the process flow diagram that the method for optimizing that is used to edit EF and MEF according to the preferred embodiment of the invention is shown.

Figure 10 is the process flow diagram that the method for optimizing that is used to edit EP and MEP according to the preferred embodiment of the invention is shown.

Figure 11 is the process flow diagram that the method for optimizing that is used to edit ST according to the preferred embodiment of the invention is shown.

Figure 12 is the process flow diagram that the method for optimizing that is used to edit RST according to the preferred embodiment of the invention is shown.

Figure 13 A shows the preferred electron form user interface that is used to create STI according to the preferred embodiment of the invention.

Figure 13 B shows ST instantiation according to the preferred embodiment of the invention.

Figure 14 A is the process flow diagram that the method for optimizing that is used for instantiation ST according to the preferred embodiment of the invention is shown.

Figure 14 B is the process flow diagram that the method for optimizing that is used to create STI according to the preferred embodiment of the invention is shown.

Figure 15 A shows the logical organization of RSTI according to the preferred embodiment of the invention.

Figure 15 B shows the logical organization of RST according to the preferred embodiment of the invention.

Figure 16 A and 16B have formed the process flow diagram that the method for optimizing that is used to create RSTI according to the preferred embodiment of the invention is shown.

Figure 17 A, 17B, 17C, 17D, 17E and 17F show the structure of RE table (RET), RST table (RSTT), RST manager table (RSTMT), RST descriptor table (RSTDT), RSTI table (RSTIT) and RSTI descriptor table (RSTIDT) respectively.

Figure 17 G illustrates the detailed structure of RSTMT table by the example of the son field of expression " REFERENCED (being cited) " attribute.

Figure 18 A shows the preferred electron form user interface that is used to create RSTI according to the preferred embodiment of the invention.

Figure 18 B shows the preferred electron form user interface that is used to edit RE according to the preferred embodiment of the invention.

Figure 18 C is the process flow diagram that the method for optimizing of the element that is used for editing RST according to the preferred embodiment of the invention is shown.

Figure 19 A is the process flow diagram that the method for optimizing that is used for calculating the line number that is included in STI according to the preferred embodiment of the invention is shown.

Figure 19 B is the process flow diagram that the method for optimizing that is used for calculating the columns that is included in STI according to the preferred embodiment of the invention is shown.

Figure 20 A is the process flow diagram that the method for optimizing that is used to derive RST project (EF or MEF or EP or MEP or ST or RE or RME or RST) according to the preferred embodiment of the invention is shown.

Figure 20 B is the process flow diagram that the method for optimizing that is used to import RST project (EF or MEF or EP or MEP or ST or RE or RME or RST) according to the preferred embodiment of the invention is shown.

Figure 21 A shows the preferred electron form user interface that is used to derive RST project (EF or MEF or EP or MEP or ST or RE or RME or RST) according to the preferred embodiment of the invention.

Figure 21 B shows the preferred electron form user interface that is used to import RST project (EF or MEF or EP or MEP or ST or RE or RME or RST) according to the preferred embodiment of the invention.

Figure 21 C shows the logical file structrure of derivation-importing file according to the preferred embodiment of the invention.

Embodiment

System hardware

Shown in Figure 1A, the present invention can be embodied on the computer system 100, wherein computer system 100 (for example comprises central processing unit 101, primary memory 102, i/o controller 103, keyboard 104, pointing device 105, mouse, tracking ball, pen type equipment etc.), display device 106 and mass storage device 107 (for example, hard disk).Additional input-output apparatus such as printing device 108 can be included in the system 100 as required.As shown in the figure, each assembly of system 100 is by system bus 110 or similar framework communication.In a preferred embodiment, computer system 100 comprises the IBM-compatible personal computer that can obtain from some manufacturers (comprising IBM-IBM Corporation, A Mangke, New York).Shown in Figure 1B, provide computer software 150 so that the operation of booting computer system 100.The software systems 150 that are stored in system storage 102 and the disk storage 107 comprise kernel or operating system 151 and shell or interface 153.Can " load " (promptly being transferred to the storer 102) one or more application programs such as application software 152 so that carry out by system 100 from memory storage 107.System 100 receives user command and data by user interface 153; Then, can act on these inputs by system 100 according to instruction from operational module 151 and/or application module 152.Preferably the interface 153 of graphic user interface (GUI) also is used for display result, and the user can provide additional input or stop session thus.In a preferred embodiment, operating system 151 and interface 153 are can be from the Microsft Win95 of Microsoft's (being positioned at Lei Mengde, Washington) acquisition.On the other hand, application module 152 comprises electrical form notebook of the present invention as described in more detail below.

The interface

The following describes and will concentrate on the preferred embodiments of the present invention, its denomination of invention that is implemented in the people such as Aureglia is the user interface of description the International Patent Application PCT/EP 02/09483 (IBM list of references FR920010029) of " System and method in an electronic spreadsheet for exporting-importingthe content ofinput cells from a scalable template instance to another (being used for input block lattice content is derived-import to the system and method for another electrical form from scalable template instances) ".

The recursive scalable template management

A. introduce

The notion of scalable template (ST)

Traditional electrical form comprises the built-in that allows the electrical form user easily to organize data into the loaded down with trivial details calculating of row and column, robotization simultaneously.These data of being organized of group can be included in the individual unit lattice scope or in the set of some range of cells.Range of cells is a quite useful and widely used object in the spreadsheet environment.It can be used as whole entity and defines and handle.According to the invention of describing in International Patent Application PCT/EP 02/09483 (IBM list of references FR9 2,001 0029), permission electrical form user carries out following operated system and method is available:

Be the range of cells definition structure, comprise:

(i) the optional Header Section that constitutes by one or more elements;

The (ii) pressure main part that constitutes by one or more elements;

The (iii) Page selectable foot section that constitutes by one or more elements;

The structure of each of Header Section element can define according to content according to attribute and by MEP by MEF.

The structure of all elements of main part can define according to content according to attribute and by EP by EF.

The structure of each of Footer Section element can define according to content according to attribute and by MEP by MEF.

This structure is known as ST.Generally speaking, ST comes definition structure by the designated word hop count, this is by with reference to definition EF of all main elements and the combination of EP, and realizes by making up with reference to one or several of the MEF of each element of definition Header Section or Footer Section and MEP alternatively.

Management ST and at its undefined object that is known as EF, EP, MEF and MEP.

Create or renewal EF, MEF.

Create or renewal EP, MEP.

Create or renewal ST.

Follow defined ST and create STI.

The above-mentioned functions collection is supported by one group of instrument:

The RSTM method of " RST manager " method or abbreviation;

The EFE method of " EF editing machine " method or abbreviation;

The EPE method of " EP editing machine " method or abbreviation;

The STE method of " ST editing machine " method or abbreviation;

The STI method of " ST instantiation device " method or abbreviation;

The notion of recursive scalable template (RST)

After the notion of having introduced ST and STI, the notion of RST and RSTI becomes and is easier to grasp.In fact, RST can be counted as two-layer configuration.Highest level logically is equivalent to the structure of ST, as can logically being mapped to element and the structuring RE of element (meta-element) and the set of RME.The recursive nature of RST appears at lower structure rank, comprises the object of STI (and non-traditional electronic form unit grid, as the situation of element and element) because RE and RME are itself.In other words, RST is the hierarchy of ST.When instantiation (instanciate) RST, can know and express the structure that identical similarity is described resultant RSTI.In higher level, RSTI be presented on the structure that is equivalent to STI in logic, but by the container scope but not the structure that each cell is formed.In each container scope, more low-level structure exists with the form of STI.As a result, RSTI can be counted as itself comprising the STI that STI replaces the conventional elements lattice.Therefore, such object is at first introduced with the title of " structuring range of cells array ".Referring now to Figure 15 A and 15B, will use the simple case of this RST and RSTI that the application is described.At first with reference to Figure 15 B, name is called RST 2051 definition of " RST_customer (client) " and is followed by Internet Service Provider so that write down the structure of all the various data corresponding with the client who receives networked services.This RST organizes around comprising with the structure of lower part:

Header Section 2052, wherein the structure that is called the ST of " ST_cust_data (ST customer data) " according to name (for example writes down customer data, Business Name, the address, professional, contract timetable etc.), wherein the structure that is called the ST of " ST_contacts (ST contact person) " according to name (for example writes down the trade connection point, CEO, CIO, CFO, manager etc.), wherein the structure that is called the ST of " ST_SLA " according to name is come the contract of record service level agreements, and wherein the structure that is called the ST of " ST_support_team " according to name writes down (for example, the transition manager of customer support team, transport manager, solution manager etc.).

Main part 2053, wherein, structure according to the ST that is called " ST_res_info (ST information on services) ", for the required information of each this resource of customer resources record management of accepting to serve from the service supplier (for example, position, IP address, configuration file etc.) and the current problem daily record of writing down same resource according to the structure of the ST of by name " ST_pb_log (ST problem log) ".

Footer Section 2054 wherein, writes down this client's clearing state and according to the structure of the ST of " ST_stats (ST statistics) " by name, writes down the customer account management problem of resource and add up according to the structure of the ST of by name " ST_billing (ST clearing) ".

Then, with reference to Figure 15 B, RSTI 2001 defers to the structure " RST_customer " of RST 2051.In fact, it is also organized round the structure that comprises Header Section 2002, main part 2003 and Footer Section 2004.Header Section 2002 comprises 4 STI of the structure of " ST_cust_data ", " ST_contacts ", " ST_SLA " and " ST_support_team (ST support team) " that organize and defer to ST according to the structure of RST Header Section 2052 itself.Main part 2003 is made of 3 different recording 2010,2009 and 2008, they each is organized according to the structure of RST main part 2053, and the structure of RST main part 2053 comprises 2 STI of the structure of " ST_res_info " and " ST_cpb_log " that defer to ST.At last, Footer Section 2004 comprises organized and deferred to ST " ST_billing " and " ST_stats " according to the structure of RST Footer Section 2054 2 STI of structure itself.

Often, also use several examples of the range of cells of similar recurrence structure.In the logic of aforesaid and our example shown in Figure 15 A, in new form, create the range of cells that similar recurrence is constructed for each client.

Under the current background that does not have a real available spreadsheet environment of other instrument, often operate the example of creating the range of cells that similar like this recurrence constructs by shearings/copy and paste.We had described the limitation of the conventional tool that is used to create STI.Because the dual structure of RSTI, create RSTI even difficulty and be easier to make mistakes more.In fact, the additional difficulty that occurs when handling such recurrence object is determined exactly and be carried out given operation (for example, copy-paste recurrence object, the zone that comprises line data or structure exclusive data in the identification recurrence object, adjust the size of recurrence object, some fields in the recurrence of the soaring object are corrected by any mistake that former operation caused that acts on the recurrence object, and default value is inserted in some fields in the recurrence object) the structure rank.And, before the range of cells of recurrence structure is carried out the copy and paste operation, the user must be that the range of cells preparation of the recurrence structure that duplicated is local on destination locations, because if do not do like this, just there is the risk of the information of preexist on this position of losing because of overwrite.Above-mentioned operational chain promptly becomes dull, very long and is easy to make mistakes, mainly due to when using conventional tool, and the size of the range of cells of recurrence structure and the limit that complexity can reach the people rapidly.In a preferred embodiment of the invention, carry out following operation by making the electrical form user, the user friendly solution to these problems is provided, these are operating as:

Be range of cells definition superstructure, comprise:

(i) the optional Header Section of forming by one or more RME;

(ii) main part must be arranged by what a RE formed;

The (iii) Page selectable foot section of forming by one or more RME.

The structure of each RME of Header Section is defined by each ordered set (collection) corresponding to the superstructure field of ST.The structure of all RE of main part is defined by each ordered set corresponding to the superstructure field of ST.The structure of each RME of Footer Section is defined by each ordered set corresponding to the superstructure field of ST.This superstructure is called as RST.In a word, RST is by the specific field number, define the RE of main part and alternatively by reference, and one or several RME ' s that defines Header Section or Footer Section by reference defines superstructure.

Management RST ' s and the object that below it, defines that is called RE ' s and RME ' s.

Create or renewal RE ' s.

Create or renewal RME ' s.

Create or renewal RST.

The RSTI of the RST of definition is deferred in establishment.

One group of function above one group of following instrument is supported:

" RST manager " method, or abbreviate the RSTM method as;

" RE editing machine " method, or abbreviate the REE method as;

" RST editing machine " method, or abbreviate the RSTE method as;

" RST instantiation device " method, or abbreviate the RSTI method as.

In following chapters and sections, this group function is described in more detail.

In our example, RST is developed into the universal architecture in definition " NSP customer resources storehouse (repository) ", therefore, is convenient to create several examples in described " NSP customer resources storehouse ".Referring now to Figure 15 B, the RST of the structure of definition " NSP customer resources storehouse ":

(i) specifying the number of superstructure field, in our example, is 2 (two) individual.

(ii) define the Header Section 2052 in " NSP customer resources storehouse " as follows:

Define the structure of a ST " ST_cust_data " and the 2nd ST " ST_contacts ".

Definition comprises the structure of the RME 2058 of preceding two ST ' s.

Define the structure of Three S's T " ST_SLA " and the 4th ST " ST_support_team ".

Definition comprises the structure of the 2nd RME 2057 of preceding two ST ' s.

(iii) define the main part 2053 in " NSP customer resources storehouse " as follows:

Define the structure of the 5th ST " ST_res_info " and the 6th ST " ST_pb_log ".

Definition comprises the structure of the RE 2056 of preceding two ST.

(iv) define the Footer Section 2054 in " NSP customer resources storehouse " as follows:

Define the structure of a ST " ST_billing " and the 2nd ST " ST_stats ".

Definition comprises the structure of the RME 2055 of preceding two ST ' s.

According to top RST 2051, can with for the user very limited cost create one or several RSTI shown in Figure 15 A, and therefore avoided many risks of makeing mistakes.

Derive and import the RST object

When the user defines one group of EF, MEF, EP, MEP, ST, RE, RME and RST (also being known as the RST project) in given electronic form file, he is in fact forming the intellectual property that may produce by important development effort, so their very high value of existence for the user.This organizes formed RST project or its subclass can useful situation be uncommon in another electronic form file.In this case, if the user has to develop once more mutually same group RST project so that use in another electronic form file, then he will waste sizable workload.Certainly, the copy/paste operation is a kind of possibility, itself just may be heavy operation in fact but the independent copy/paste of these RST projects is operated.In addition, (RST can be made up of a plurality of recurrence (unit) element the hierarchy of RST project, in them each also can be made up of a plurality of ST, in them each also can by a plurality of (M) EF and/or (M) EP form) make be difficult to manage this group will be to its project of handling, make them make up the disparity items of the definition of the RST that participation will share together between electronic form file.In a preferred embodiment of the invention, by allowing the electrical form user to carry out following operation a kind of user-friendly solution to this problem is proposed:

Derive RST project (that is, EF, EP, MEF, MEP, ST, RE, RME and RST) from electronic form file,

Automatically derive the RST project that belongs to for the definition of deriving the selected project of operation.

RST project (that is, EF, EP, MEF, MEP, ST, RE, RME and RST) is imported in the electronic form file,

Therefore can in any electronic form file, reuse the set of the RST project that has defined in what its electronic form file in office.

Above-mentioned one group of function is supported by one group of instrument: the RSTIM method of the RSTEM method of " RST derives manager " method or abbreviation and " RST imports manager " method or abbreviation, and in the chapters and sections it is described in more detail below.

B. notion and vocabulary

The purpose of these chapters and sections is some notions (being associated with object) and some vocabulary that formalization defines within the scope of the invention.In following description, suppose that electrical form takes two dimension (2D) form, so that can under the 2D environment, describe form and structure.In addition, suppose form line organization, so that form title (heading) is at the top of form, rather than in its left side.So just can very clearly describe various protonotion, object and method, but this can not be construed as limiting to scope of the present invention as ingredient of the present invention.That is to say that following description can be generalized to the environment of 2D form of level tissue or the environment of 3D form, and does not depart from spirit of the present invention.

B1. basic definition

The structuring range of cells: the structuring range of cells is to defer to the range of cells of certain structure that organizes data into row and column.The row definition is intended to comprise on each row the field of the information of same type.Row definition record (or element).

Form: the word table lattice can be used to specify the structuring range of cells.

Field: field is the tape label row that comprise the same type information of each record (or element) in database or the form.For example, client's table can comprise the field that indicates title, address and telephone number (tel#).

Promote it, in given record (or element), given field refers to the cell on the intersection point that is positioned at record (or element) and given field (tape label row).

Top definition is used for the 2D environment of row define field and row definition record.Can be expert at and change them in the 2D environment of define field and row definition record.Also can in the 3D environment of for example page definition record, change them.

The I/O unit lattice: when hypothesis is used for information that recording user provides, cell is designated as " input " cell.When hypothesis is used for generation information (generally directly or indirectly quoting the formula acquisition of " input " cell by its variable (argument)), cell is designated as " output " cell.

B2. object definition

Be defined as follows object and help to understand the present invention.

Element format: EF is that these attributes are with the electrical form object of the structure of the element in attribute of a configuration definition 2 dimensions or the 3 dimension range of cells:

Background attribute (color, pattern etc.);

Alignment properties (level, vertical, text around, stride column alignment etc.);

Font attribute (size, color etc.);

Line attribute (type, color etc.);

Field protect; With

Any other conventional form attribute.

Unit's element (Meta-Element) form: MEF is that these attributes are according to the electrical form object of the structure of the element in attribute of a configuration definition 2 dimensions or the 3 dimension range of cells:

Background attribute (color, pattern etc.);

Alignment properties (level, vertical, text around, cell merging etc.);

Font attribute (size, color etc.);

Line attribute (type, color etc.);

Field protect; With

Any other conventional form attribute.

The element summary: EP is the electrical form object according to the structure of the element in content and destination definition 2 dimensions or the 3 dimension range of cells:

According in other field that is included in identity element or in other field of another element of same STI or element or even STI outside other field in the formula of field of data computation.

The field default value of appointment when element is created.

The destination of cell (be the data of " input " cell input or be the data of " output " cell generation).

Unit's element summary: MEP is the electrical form object according to the structure of the element in content and destination definition 2 dimensions or the 3 dimension scopes, these contents and destination:

Be used for according to other cell that is included in identity element or in other cell of another element of same STI or element or even other cell outside STI in the formula of cell of data computation.

The cell default value of when element is created, giving.

Scalable template(being also referred to as " template " or " ST "): ST is the electrical form object according to the structure of { element+element } layout definition 2 dimensions or 3 dimension range of cells.Word (word) " scalable " refers to size variable (for example, from the minimum value to the maximal value) range of cells and defines the ability to the ST of fixed structure.ST is definition structure by the following:

The specific field number;

Quote a pair of EF and/or the EP of each main element of definition; With

Alternatively, quote a pair of or several to MEF and/or MEP.

In 2 dimension environment, such MEF ' s/MEP ' s is positioned on the EF/EP that constitutes ST " header " part, or is positioned under the EF/EP that constitutes ST " footer " part.ST " header " part or ST " footer " part, or they the two all might be empty.

When element and element were quoted (reference) and only be made of EP and MEP, so, ST only carried content information, therefore, can be named as scalable summary template.

Quote when only being made of EF and MEF when element and element, so, ST only carries format information, therefore, can be named as scalable format template.

When element and element were quoted any constituting by EP ' s and EF ' s, so, ST carried summary and format information, therefore, can be named as scalable summaryization and format template.

Scalable template instances(being also referred to as " example ", " scalable example " or " STI "): STI defers to the following electrical form object that defines the structure of ST: scalable format template, scalable summary template or scalable summaryization and format template.The succession object (heirobject) that STI can be regarded as ST.It comprises a variable number element (at least one), that these elements are included in is corresponding with father's structure in each field, and constitute information of " main body " part, alternatively, add one or several yuan element of " header " part and " footer " part of and formation STI defined as ST.

Element: element is to belong to STI and by deferring in father's structure EF that (respectively in scalable format template, scalable summary template or scalable summaryization and format template) find or EP or (EF, EP) the electrical form object formed of right elementary field.Do not losing under any general situation, supposing that element always defers to that (EF, EP) right, wherein, EF or EP can be degenerated to the sky object.

Unit's element: element is to belong to STI and by deferring to MEF or MEP or (MEF, MEP) the electrical form object formed of right elementary cell lattice.Do not losing under any general situation, supposing that element always defers to that (MEF, MEP) right, wherein, MEF or MEP can be degenerated to the sky object.

The recurrence element: RE belongs to RST, constitutes the main part of RST and the electrical form object of being made up of the elementary field of the title that is used to write down ST.RE has the structure with the structural similarity of element, but is not changed into range of cells by example, but is changed into the scope of STI ' s by example.

Example: the RE of the RST 2051 shown in Figure 15 B is corresponding to main part 2053 that constitutes this RST and the structure 2056 be made up of two fields of the title of " ST_res_info " that comprise ST respectively and " ST_pb_log ".

Recurrence unit element: RME is the electrical form object that belongs to RST, belongs to the header of RST and/or Footer Section and be made up of the elementary field of the title that is used to write down ST.RME has the structure with the structural similarity of element, but is not changed into range of cells by example, but is changed into the scope of STI by example.

Example: the RME of the RST 2052 shown in Figure 15 B is corresponding to main part 2052 that belongs to this RST and the structure 2058 be made up of two fields of the title of " ST_cust_data " that comprise ST respectively and " ST_contacts ".

Recursive scalable template(being also referred to as " recurrence template " or " RST "): RST is according to { the electrical form object of the superstructure of RE+RME} layout definition 2 dimension or 3 dimension range of cells: glossary " scalable " refers to size variable (for example, from the minimum value to the maximal value) range of cells and defines the ability of the RST of given superstructure.RST defines superstructure by the following:

The specific field number;

Quote the RE of the main part of definition RST; With

Alternatively, quote one or several RME.

In 2 dimension environment, such RME is positioned on the RE that constitutes RST " header " part, or is positioned under the RE that constitutes RST " footer " part." footer " part of RST " header " part or RST, or they the two all might be empty.

Example: RST 2051 is illustrated among Figure 15 B.It is made of Header Section 2052, main part 2053 and Footer Section 2054.Header Section comprises two

RME

2058 and 2057, and the both has two fields and comprises the title of ST " ST_cust_data ", " ST_contacts " and " ST_SLA ", " ST_support_team " respectively.Main part comprises a RE 2056, and it has two fields, comprises " ST_res_info " of ST, the title of " ST_pb_log " respectively.Footer Section comprises a RME2055, and it has two fields, comprises " ST_billing " of ST, the title of " ST_stats " respectively.

The recursive scalable template example(being also referred to as " recurrence example ", " recursive scalable example " or " RSTI "): RSTI is an electrical form object of deferring to the structure of defined RST.The succession object that RSTI can be regarded as RST.It comprises a variable number container capable (container row) (at least one), these containers are capable to be comprised corresponding with father RE structure and formation " main body " one or more STI partly, alternatively, add that " header " part that comprises and formation RSTI corresponding with father RME structure is capable with one or several other container of one or more STI of " footer " part.

Example: RSTI 2001 is illustrated among Figure 15 A.This RSTI defers to the RST2051 shown in Figure 15 B.It is made of Header Section 2002, main part 2003 and Footer Section 2004.Header Section comprises two containers capable 2012 and 2011.Main part comprises three containers capable 2010,2009 and 2008.Footer Section comprises a container capable 2007.Each container is capable to comprise two compensator scopes, for example, can regard the container scope (containerrange) 2014 of the intersection point of top container capable 2012 and right container row 2005 as.Each container scope comprises the STI of structure of the ST of a part of deferring to the RE that is defined as RST 2051 or RME member.For example, be included in STI 2034 in the compensator scope intersection point of container capable 2010 and container row 2005 defer to as definition among the RME 2056 of RST 2051 like that, be called the structure of the ST of " ST_pb_log ", and itself is made of Header Section 2015, main part 2016 and Footer Section 2017.

Container is capable: container is capable be belong to RSTI and with the corresponding electrical form object of range of cells of the STI of the constructing definitions of the RE that comprises the RST that defers to according to RSTI or RME part.The line number that container is capable equals the line number of the highest STI that it comprises.The capable recurrence element example that also can be called of container.The capable element that in RSTI, can be counted as being equivalent in the STI of container. Example: container capable 2012 is illustrated among Figure 15 A, and is corresponding with the range of cells of the STI 2032 that is included in RSTI 2001 interior definition and 2013.The line number that this container is capable equals the line number of the STI 2032 higher than STI 2013.

The container row(container column): container row be belong to RSTI with the corresponding electrical form object of range of cells that occupies the STI of identical superstructure position in the container that is included in RSTI is capable.The columns of the wideest STI that the columns of container row equals that it comprises. Example: container row 2006 are illustrated among Figure 15 A, be included in RSTI 2001 in to occupy the range of cells of STI of leftmost position corresponding.The columns of these container row equals the columns of STI 2030, and STI 2030 is the wideest STI in RSTI 2001 left sides.

The container scope: the container scope is to belong to RSTI and the corresponding electrical form object of intersection point of capable with container of container row.Each container scope comprises the single STI that occupies the upper left corner.Container scope in the RSTI can be counted as being equivalent to the individual unit lattice in the STI.

For example: container scope 2014 is illustrated among Figure 15 A, and the intersection point that belongs to the container capable 2012 of RSTI 2001 and container row 2005 with the both is corresponding.This container scope 2014 comprises STI 2013.

B3. mark

Following mark: П _{I ∈ S}a _iCorresponding to item a _iProduct, subscript i belongs to S set.Following mark: LCM ({ a _i) _{I ∈ S}Corresponding to item a _iLowest common multiple (the least common multiplier), subscript i belongs to S set.If S is made of individual element a, so, LCM ({ a _i) _{I ∈ S}Equal a.Following mark: a Mod b is corresponding to the remainder (Mod be modulus) of a divided by b.

C. be used to manage the form of RST object

As introducing in the chapters and sections in front, the preferred embodiments of the present invention depend on the different object of management RST.With these object record in the different resource storehouse, so that can be by as the distinct methods visit of the part of the preferred embodiment of the present invention with upgrade them.Such resources bank is called as form:

EF table or the EFT that is called for short

EP table or the EPT that is called for short,

ST table or the STT that is called for short,

The STDT of ST descriptor table or abbreviation,

The STIT of ST instantiation device table or abbreviation,

RST derivation-importing table or the RSTEIT that is called for short

RE table or the RET that is called for short,

RST table or the RSTT that is called for short,

The RSTMT of RST manager table or abbreviation,

The RSTDT of RST descriptor table or abbreviation,

RSTI table or the RSTIT that is called for short,

The RSTIDT of RSTI descriptor table or abbreviation.

EFT, EPT, STT, STDT, STIT, RET, RSTT, RSTDT, RSTIT and RSTIDT table are kept on the mass storage 107 as the part of electrical form dish file, and the RSTMT table is kept on the primary memory 102 temporarily, and the RSTEIT table is kept on the electrical form derivation-importing file.

The C1.EF table

Referring now to Fig. 7 A, according to the present invention, EFT table 700 is corresponding to the simple logic structure of being made up of several records 701, and they each is corresponding to EF or MEF.Each record comprises six fields:

" Name (title) " 702 fields are used to write down and identify EF that current record 701 describes or the character string of MEF uniquely.

" Last Change Date (changing the date at last) " 703 fields are used to write down the EF of current record 701 descriptions or the final updating date of MEF.

" Description Ptr (description pointer) " 704 fields are to point to the quoting of memory location that the illustration range of cells of EF that current record 701 describes or MEF described in record.This memory location can be on mass storage 107, and on primary memory 102, or on other legacy memory resources bank device, this does not depart from spirit of the present invention.

" Row# (line number) " 705 fields are used for writing down and appear at EF that current record 701 describes or the line number of MEF.This field is applicable to element or the MEF 3D ST corresponding to the 2D structure.In the preferred embodiment of the present invention that adopts 2D ST, always fill this field with value 1.

" Column# (columns) " 706 fields are used for writing down and appear at EF that current record 701 describes or the columns of MEF.

" Type (type) " 707 fields are used to write down the different attribute that the EF that describes with current record 701 or MEF are associated: this be meant settled before record 701 whether " REFERENCED (being cited) " attribute 709 of " META (the unit) " attribute 708 (having analog value " NO (deny) " and " YES (being) ") of EF or MEF and the relation by special-purpose son field (709a, 709b, 709c, 709d and 709e) appointment and other object is described.These son fields are described as the part of the description of " REFERENCED (being cited) " attribute 2240.Conventional art can be used for encoding these different attributes of this " Type (type) " field, for example, carry out XOR (distance) computing by turn with pre-determined bit integrated mode (bit pattern), but also can use any other traditional means instead and do not depart from spirit of the present invention.

The C2.EP table

Referring now to Fig. 7 B, according to the present invention, EPT table 710 is corresponding to the simple logic structure of being made up of several records 711, and they each is corresponding to EP or MEP.Each record comprises six fields:

" Name (title) " 712 fields are used to write down and identify EP that current record 711 describes or the character string of MEP uniquely.

" Last Change Date (changing the date at last) " 713 fields are used to write down the EP of current record 711 descriptions or the final updating date of MEP.

" Description Ptr (description pointer) " 714 fields are to point to the quoting of memory location that the illustration range of cells of EP that current record 711 describes or MEP described in record.This memory location can be on mass storage 107, and on primary memory 102, or on other legacy memory resources bank device, this does not depart from spirit of the present invention.

" Row# (line number) " 715 fields are used for writing down and appear at EP that current record 711 describes or the line number of MEP.This field is applicable to element or the MEP 3D ST corresponding to the 2D structure.In the preferred embodiment of the present invention that adopts 2D ST, always fill this field with value 1.

" Column# (columns) " 716 fields are used for writing down and appear at EP that current record 711 describes or the columns of MEP.

" Type (type) " 717 fields are used to write down the different attribute that the EP that describes with current record 711 or MEP are associated: this be meant settled before record 711 whether " REFERENCED (being cited) " attribute 719 of " META " attribute 718 (having analog value " NO " and " YES ") of EP or MEP and the relation by special-purpose son field (719a, 719b, 719c, 719d and 719e) appointment and other object is described.These son fields are described as the part of the description of " REFERENCED (being cited) " attribute 2240.Conventional art can be used for encoding these different attributes of this " Type (type) " field for example, carry out XOR computing by turn with the pre-determined bit integrated mode, but also can use any other traditional means instead and do not depart from spirit of the present invention.

The C3.ST table

Referring now to Fig. 7 C, according to the present invention, STT table 720 is corresponding to the simple logic structure of being made up of several records 721, and they each is corresponding to ST.Each record comprises six fields:

" Name (title) " 722 fields are used to write down the character string of the ST that identifies current record 721 descriptions uniquely.

" Last Change Date (changing the date at last) " 723 fields are used to write down the final updating date of the ST that current record 721 describes.

" Description Ptr (description pointer) " 724 fields are to point to the quoting of memory location of the description of the ST that record current record 721 describes.This memory location can be on mass storage 107, and on primary memory 102, or on other legacy memory resources bank device, this does not depart from spirit of the present invention.This description is to construct according to the STDT table 760 that is illustrated among Fig. 7 D, that is to say that be configured to several ordered lists to title, each is to being made up of the title of element or MEF and the title of element or MEP.

" Min Element# (smallest element prime number) " 725 fields are used for being recorded in the smallest element prime number that each STI of deferring to the ST that current record 721 describes finds.

" Max Element# (greastest element prime number) " 726 fields are used for being recorded in the greastest element prime number that each STI of deferring to the ST that current record 721 describes finds.

" Type (type) " 727 fields are used to write down the different attribute that the ST that describes with current record 721 is associated: this is " META " attribute 728 of value " NO " always and specifies and " REFERENCED (being cited) " attribute 729 of the relation of other object by special-purpose son field (729a, 729b, 729c, 729d and 729e).These son fields are described as the part of the description of " REFERENCED (being cited) " attribute 2240.Conventional art can be used for encoding these different attributes of this " Type (type) " field for example, carry out XOR computing by turn with the pre-determined bit integrated mode, but also can use any other traditional means instead and do not depart from spirit of the present invention.

The C4.ST descriptor table

Referring now to Fig. 7 D, STDT table 760 is corresponding to by several simple logic structures that element or MEF 765 and element or MEP 766 are formed, and this structure is organized into three subclass:

Optional ST " header " part 767, by as the top to 761 variable (possible zero) to forming.These right each are made of MEF (row 765) and MEP (row 764).

To what form " main body " part 762 must be arranged by single, this is single to being made of EF (row 765) and EP (row 764).

Optional ST " footer " part 766, by as the end to 763 variable (possible zero) to forming.These right each are made of MEF (row 765) and MEP (row 764).

C5.ST instantiation device table

Referring now to Fig. 7 E, according to a preferred embodiment of the invention, STIT table 750 is corresponding to the simple logic structure of being made up of several records 751, and they each is corresponding to STI.Each record comprises six fields:

" Address (address) " 752 fields are used to locate the STI that current record 751 is described: its value is corresponding to traditional character string of the address that is used to write down any range of cells.

" ST " 753 fields are used to write down the title of the ST of the STI that defers to current record 751 descriptions.

" Element# (number of elements) " 754 fields are used to write down the interior number of elements of STI that current record 751 is described.

" Critical (key) " 755 fields are used to write down whether think that the STI that current record 751 is described is critical.Its content can value " YES " or " NO ".

" Header Size (header size) " 756 fields are used to write down first number of elements of the Header Section of the STI that constitutes current record 751 descriptions.

" Footer Size (footer size) " 757 fields are used to write down the first number of elements of formation by the Footer Section of the STI of current record 751 descriptions.

C6.RST derivation-importing table

Referring now to Fig. 7 F, RSTEIT table 770 is corresponding to the logic simple structure that is made of some records 771, according to a preferred embodiment of the invention, they each is corresponding to derived the quilt derivation RST project (EF or MEF or EP or MEP or ST or RE or RME or RST) that manager or RST import manager administration by RST.Each record comprises seven fields:

" Name (title) " 772 fields are used to write down the character string of unique identification by the object of current record 771 descriptions.

" Last change date (changing the date at last) " 773 fields are used to write down the date of the final updating of the object of being described by current record 771.

" Description Ptr (description pointer) " 774 fields are to point to quoting of the memory location write down the object factory of being described by current record 771.This memory location can be positioned on mass storage device 107 or primary memory 102 or other legacy memory repository device, and does not break away from spirit of the present invention.

" Info Field 1 (information field 1) " 775 fields are used to write down the first information segment that is associated with the object of being described by current record 771.

" Info Field 2 (information field 2) " 776 fields are used to write down second pieces of information that is associated with the object of being described by current record 771.

" Type (type) " 777 fields are used to write down the different attribute that is associated with the object of being described by current record 771, for example attribute " META (unit) " 779, " REFERENCED (being cited) " 780 (by special-purpose son field 780a, 780b, 780c, 780d and the 780e appointment relation with other object), " SELECTED (selecting) " 782 and " NATURE (character) " 781.

Can use conventional art that these different attributes in this " type " field are encoded, for example, carry out step-by-step XOR (XOR) operation with predefined bit patterns, but also can use any other conventional apparatus, and do not break away from spirit of the present invention.

" INDEX (index) " 778 fields are used for importing the performed scanning RSTEIT table of manager method as derive manager and RST by RST.

The C7.RE table

Referring now to Figure 17 A, according to the present invention, RET table 2210 is corresponding to the simple logic structure of being made up of several records 2211, and they each is corresponding to RE or RME.Each record comprises six fields:

" Name (title) " 2212 fields are used to write down and identify RE that current record 2211 describes or the character string of RME uniquely.

" Last Change Date (changing the date at last) " 2213 fields are used to write down the RE of current record 2211 descriptions or the final updating date of RME.

" Description Ptr (description pointer) " 2214 fields are to point to the quoting of memory location that the illustration range of cells of RE that current record 2211 describes or RME described in record.This memory location can be on mass storage 107, and on primary memory 102, or on other legacy memory resources bank device, this does not depart from spirit of the present invention.

" Row# (line number) " 2215 fields are used for writing down and appear at RE that current record 2211 describes or the line number of RME.This field is applicable to RE or the RME 3D RST corresponding to the 2D structure.In the preferred embodiment of the present invention that adopts 2D RST, always fill this field with value 1.

" Column# (columns) " 2216 fields are used for writing down and appear at RE that current record 2211 describes or the columns of RME.

" Type (type) " 2217 fields are used to write down the different attribute that the RE that describes with current record 2211 or RME are associated: this be meant settled before record 2211 whether " REFERENCED (being cited) " attribute 2219 of " META " attribute 2218 (having analog value " NO " and " YES ") of RE or RME and the relation by special-purpose son field (2219a, 2219b, 2219c, 2219d and 2219e) appointment and other object is described.These son fields are described as the part of the description of " REFERENCED (being cited) " attribute 2240.Conventional art can be used for encoding these different attributes of this " Type (type) " field for example, carry out XOR (distance) computing by turn with the pre-determined bit integrated mode, but also can use any other traditional means instead and do not depart from spirit of the present invention.

The C8.RST table

Referring now to Figure 17 B, according to the present invention, RSTT table 2220 is corresponding to the simple logic structure of being made up of several records 2221, and they each is corresponding to RST.Each record comprises six fields:

" Name (title) " 2222 fields are used to write down the character string of the RST that identifies current record 2221 descriptions uniquely.

" Last Change Date (changing the date at last) " 2223 fields are used to write down the final updating date of the RST that current record 2221 describes.

" Description Ptr (description pointer) " 2224 fields are to point to the quoting of memory location of the description of the RST that record current record 2221 describes.This memory location can be on mass storage 107, and on primary memory 102, or on other legacy memory resources bank device, this does not depart from spirit of the present invention.This description is to construct according to the RSTDT table 2250 that is illustrated among Figure 17 D, that is to say, is configured to the ordered list of RME or RE title.

" Min Element# (smallest element prime number) " 2225 fields are used for being recorded in the minimum RE number that each RSTI of deferring to the RST that current record 2221 describes finds.

" Max Element# (greastest element prime number) " 2226 fields are used for being recorded in the maximum RE number that each STI of deferring to the RST that current record 2221 describes finds.

" Type (type) " 2227 fields are used to write down the different attribute that is associated with current record 2221 described RST: this is " META " attribute 2228 of value " NO " always and specifies " REFERENCED (being cited) " attribute 2229 with the relation of other object by special-purpose son field (2229a, 2229b, 2229c, 2229d and 2229e).These son fields are described as the part of the description of " REFERENCED (being cited) " attribute 2240.Conventional art can be used for encoding these different attributes of this " Type " field for example, carry out XOR computing by turn with the pre-determined bit integrated mode, but also can use any other traditional means instead and do not depart from spirit of the present invention.

C9.RST manager table

Referring now to Figure 17 C, according to a preferred embodiment of the invention, RSTMT table 2230 is corresponding to the simple logic structure of being made up of several records 2231, and they each is corresponding to the object of RST manager administration.Each record comprises seven fields:

" Name (title) " 2232 fields are used to write down the character string of the object that identifies current record 2231 descriptions uniquely.

" Last Change Date (changing the date at last) " 2233 fields are used to write down the final updating date of the object that current record 2231 describes.

" Description Ptr (description pointer) " 2234 fields are to point to the quoting of memory location of the description of the object that record current record 2231 describes.This memory location can be on mass storage 107, and on primary memory 102, or on other legacy memory resources bank device, this does not depart from spirit of the present invention.

" Info Field 1 (information field 1) " 2235 fields are used to write down first segment information that is associated with the object of current record 2231 descriptions.

" Info Field 2 (information field 2) " 2236 fields are used to write down second segment information that is associated with the object of current record 2231 descriptions.

" Type (type) " 2237 fields are used to write down the different attribute that is associated with the object of current record 2231 descriptions, for example:

The front is similar " Type (type) " field 707,717,727,777,2217 and 2227 attributes of describing " META (unit) " 2239, and two other attributes:

According to Figure 17 C of the example of illustration RSTMT table 2230, the attribute " REFERENCED (being cited) " 2240 that constitutes by 5 (five) son fields:

" OWN REFERENCE (own quoting) " (or abbreviating OR as) son field 2240a.This son field is unique prime number of appointment when creating the object that writes down 2231 descriptions.When having only the object of describing when deletion record 2231, just discharge this prime number.

" FILIATION REFERENCE (branch quotes) " (or abbreviating FR as) son field 2240b.This son field is assessed according to following formula, and wherein, the F set is corresponding to constituting a group objects that writes down 2231 objects of describing:

FR＝П _i∈FOR _i×LCM({FR _i}) _i∈F

Top formula allows dynamically will write down 2231 described objects and links together with the object that constitutes it, because factor OR _iAnd FR _iOne of any change of value all be reflected on the FR automatically.If F set be empty (for example, when record 2231 describe to as if when EP, MEP, EF or MEF), so, FR son field value of being defaulted as 1 ().

" INSTANCE REFERENCE (example is quoted) " (or abbreviating IR as) son field 2240c.When creating the object of record 2231 descriptions, with this son field value of being initialized to 1 (one).After this, when the new example of this object is deferred in establishment, this field be multiply by 2 (two) and when the existing example of this object is deferred in deletion, with this field divided by 2 (two).

" REFERENCED OBJECT (institute's reference object) " (or abbreviating RO as) son field 2240d.This son field is to specify to write down the Boolean variable whether 2231 objects of describing participate in another definition of object.For example, EF, MEF, EP or MEP can participate in the definition of ST.Similarly, ST can participation itself can participate in the definition of RE of the definition of RST.This son field is assessed according to following formula, and wherein, in the hierarchy of P set corresponding to the RST object, its type is deferred to a group objects of the type that writes down 2231 objects of describing:

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

Top formula allows dynamically will write down 2231 objects of describing and links together with the object that belongs to the P set, because factor FR _iOne of any change of value all be reflected on the RO automatically.If write down 2231 describe to as if EF, MEF, EP or MEP, so, the P set is corresponding to the set of ST.If write down 2231 describe to as if RE, so, the P set is corresponding to the set of RST.If write down 2231 describe to as if RST, so, the P set is empty (having arrived top layer), thus RO son field value of being defaulted as " NO (denying) ".

" SELECTED CHILDREN (selected subsystem) " (or abbreviating SC as) son field 2240e.This son field is to specify to write down the Boolean variable whether 2231 objects of describing participate in selected definition of object.This son field is assessed according to following formula, and wherein, S gathers the set (" SELECTED (the selecting) " attribute 2242 with the value of equaling " YES ") corresponding to selected object:

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#object ∈ S,

SC=" YES (being) " then;

Otherwise, SC=" NO (denying) ".

Top formula allows dynamically will write down 2231 objects of describing and selected object (belonging to the S set) links together, because factor FR _iOne of value or any change of S set all be reflected on the SC automatically.

As the same set of other " REFERENCED (the being cited) " attribute definition in table EFT 700, EPT 710, STT 720, RSTEIT 770, RET 2210 and the RSTT 2220 based on five son fields.

Whether reflection electrical form user has selected " SELECTED (selecting) " attribute 2242 (having analog value " YES " and " NO ") of related object in RST manager dialog frame 2300, and:

Reflection object is (M) EF, (M) EP, ST, R (M) E, still " NATURE " attribute 2241 of RST (has analog value " FORMAT (form) ", " PROFILE (summary) ", " TEMPLATE (template) ", " RECELEMENT (recurrence element) " or " RECTEMPLATE (recurrence template) ").

Conventional art can be used for encoding these different attributes of this " Type (type) " field 2237 for example, carry out XOR computing by turn with the pre-determined bit integrated mode, but also can use any other traditional means instead and do not depart from spirit of the present invention.

" Index (index) " 2238 fields are used for as carry out classification RSTMT table by RST manager method.

The C10.RST descriptor table

Referring now to Figure 17 D, RSTDT table 2250 is corresponding to by several simple logic structures that the title 2254 of RE or RME is formed, and this structure is organized into three subclass:

Optional RST " header " part 2256 is made up of variable (possible zero) RME title as top title 2251.

By what single RE title was formed " main body " part 2252 must be arranged.

Optional RST " footer " part 2255 is made up of variable (possible zero) RME title as bottom title 2253.

The C11.RSTI table

Referring now to Figure 17 E, according to a preferred embodiment of the invention, RSTIT table 2260 is corresponding to the simple logic structure of being made up of several records 2261, and they each is corresponding to RSTI.Each record comprises six fields:

" Address (address) " 2262 fields are used to locate the RSTI that current record 2261 is described: its value is corresponding to traditional character string of the address that is used to write down any range of cells.

" ST " 2263 fields are used to write down the title of the RST of the RSTI that defers to current record 2261 descriptions.

" E1ement# (number of elements) " 2264 fields are used to write down the number of the RE in the RSTI that current record 2261 describes.

Whether " Critical (key) " 2265 fields are used to write down thinks that the RSTI that current record 2261 is described is critical.Its content can value " YES " or " NO ".

" Header Size (header size) " 2266 fields are used to write down the number of the RME of the Header Section that constitutes the RSTI that current record 2261 describes.

" Footer Size (footer size) " 2267 fields are used to write down the number of the RME of the Footer Section that constitutes the RSTI that current record 2261 describes.

The C12.RSTI descriptor table

Referring now to Figure 17 F, according to a preferred embodiment of the invention, RSTIDT table 2270 is corresponding to the simple logic structure of being made up of several records 2271, and they each is made up of plurality of units lattice 2272, and they each is corresponding to the STI member of RSTI.RSTIDT table 2270 is mapped to have by one or several and writes down the 2271 top Header Sections of forming 2275 (the possibility sky), writes down the structure of the relevant RSTI of 2271 bottom Footer Sections 2273 of forming (the possibility sky) by one or several record 2271 intermediate host parts 2274 of forming and by one or several.Each record 2271 comprises one or more independent cells 2272, and their number is corresponding to the number of the STI of each RE.Each record 2272 comprises seven fields of the STI member's who represents RSTI feature:

" Container_range (container scope) " 2276 fields are used to write down the address of the container scope of the STI that put 2272 describes.With reference to Figure 15 A, if write down 2272 STI 2013 is described, the intersection point of the address of this field record container 2014 (container capable 2012 and container row 2005).

" Container_col (container row) " 2277 fields are used to write down the columns of the container scope of the STI that put 2272 describes.With reference to Figure 15 A, if write down 2272 STI 2013 is described, this field record columns 2028.

" STI_col (STI row) " 2278 fields are used to the columns of the STI of record 2272 descriptions.

With reference to Figure 15 A, if write down 2272 STI 2013 is described, this field record columns 2026.

" STI_row (STI is capable) " 2279 fields are used to the line number of the STI of record 2272 descriptions.With reference to Figure 15 A, if write down 2272 STI 2013 is described, this field record line number 2027.

" ST_name (ST title) " 2280 fields are used to write down the title of the ST of the STI that defers to record 2272 descriptions.

" Container_row (container is capable) " 2281 fields are used to write down the line number of the container scope of the STI that put 2272 describes.With reference to Figure 15 A, if write down 2272 STI 2013 is described, this field record line number 2029.

" STIT_rec_ptr (STIT record pointer) " 2282 fields are used in STIT table 750, point to the record of describing by record 2272 described STI 751.

C13. the relation between the form

Referring now to Fig. 7 G, this figure has provided form RSTIT 2260, RSTIDT 2270, RSTT 2220, RSTDT 2250, RET 2210, STIT 750, STT 720, STDT 760, EFT 700 and the EPT 710 that introduce before some together, be illustrated in the relation set up between these forms and with the relation of the STI 797 of the RSTI 730 of RSTI or STI.In this figure, heavy line arrow illustration is pointed to concerning based on pointer of form or record, thick dashed line arrow illustration point to range of cells based on address relationship, fine line arrow illustration point at objects based on title relation and fine dotted line arrow illustration point at objects based on size relationship.In Fig. 7 G, be according to following order based on pointer, based on the address with based on the relation of title, by being illustrated in index sign in the circle:

From the STI 797 of the STI that forms by three parts " STI Header (STI header) ", " STI Body (STI main body) " and " STIFooter (STI footer) ", between the record 751 of the STI 797 of this STI and STIT table 750, set up the 1st the j that concerns based on the address.

Then, between this record 751 and the record 721 of STT table 720, set up the 2nd and concern k based on title.This record 721 is corresponding to the ST that defers to STI 797.

Between the STDT table 760 of structure of this record 721 and description ST, set up the 3rd and concern 1 based on pointer.Each record of STDT table 760 is corresponding to a pair of element or MEF title and a pair of element or MEP title.

Between the record 701 of element or MEF title and EFT table 700, set up the 4th and concern m based on title.

Between the record 711 of element or MEP title and EPT table 710, set up the 5th and concern n based on title.

Between the record 701 and the illustration range of cells 798 of specified format attribute, set up the 6th and concern o based on pointer.

Between the illustration range of cells 799 of record 711 and appointment summary content, set up the 7th and concern p based on pointer.

RSTI 730 from being made up of three parts " RSTI Header ", " RSTI Body " and " RSTI Footer " sets up the 8th based on address relationship q between the record 2261 of this RSTI 730 and RSTIT table 2260 now.

Between the RSTIDT table 2270 of structure of this record 2261 and description RSTI 730, set up the 9th and concern r based on pointer.Each cell 2272 of RSTIDT table 2270 comprises

several fields

2276,2277,2278,2279,2280,2281 and 2282 relevant with given STI (as the STI 797) member of RSTI730.

Therefore in 2276 fields of the cell 2272 of RSTIDT table 2270 and comprise between the container scope of STI797 of STI and set up the 10th based on address relationship s.

Also between 2282 fields of the cell 2272 of RSTIDT table 2270 and record 751, set up the 11st and concern jj based on pointer corresponding to the STIT table 750 of the STI797 of STI.

Then, between the record 2261 and the record 2221 of RSTT table 2220, set up the 12nd and concern jk based on title.This record 2221 is corresponding to the RST that defers to RSTI 730.

Between the RSTDT table 2250 of structure of this record 2221 and description RST, set up the 13rd and concern jl based on pointer.Each record of RSTDT table 2250 is corresponding to RE or RME.

Between the record 2211 of RE or RME title and RET table 2210, set up the 14th and concern jm based on title.

At record 2211 and comprise and set up the 15th between the RE descriptor element lattice scope 731 of title of ST and concern jn based on pointer.

Between the record 721 of RE descriptor element lattice scope 731 and STT table 720, set up the 16th and concern jo based on title.

Between the record 721 of the cell 2272 of RSTIDT table 2270 and STT table 720, set up the similar the 17th and concern jp based on title.

D. scheme

Different with the conventional tool of just having described, the preferred embodiments of the present invention provide more powerful, the user-friendly and interactively approach of definition and management ST with the form of a group method.In a preferred embodiment, the present invention is used in the scheme that clearly is expressed as sequence of operations.

1. first operation: create STI or RSTI

First operation occurs in the electrical form user according to some criterions that do not describe in detail here, when the RSTI of the STI of the structure of deferring to ST or the structure that RST is deferred in establishment is created in decision.In a preferred embodiment of the invention, this operation comprises the steps:

The a.RST manager: the electrical form user is at first by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " RST manager ", so that see any existing EF or MEF or EP or MEP or RE or RME or ST or RST by dedicated user interface.This RST manager provides different selections for further managing these entities.

This can come illustration by means of the described user interface of reference Fig. 2, and Fig. 2 shows the RST manager dialog frame 200 as on being presented at display device 106.In this RST manager dialog frame 200, the user can see the object (EF, MEF, EP, MEP, RE, RME, ST and RST) that has defined in the type of the title of appointed object respectively, object and " list box " 213,214 and 202 on their final updating date.If defined a large amount of objects, so, the user can navigate between them by means of positioning equipment 105 click on scroll bar 203 up or down, so that the objects that are presented in list box 213,214 and 202 move forward between top object and bottom object backward.In a preferred embodiment of the invention, object is classified by the final updating date, but can use any other classification schemes yet, this does not depart from spirit of the present invention.Then, the user can take several action.The user can utilize positioning equipment 105 clicks check box in RST manager dialog frame 200 left sides as check box 212, so that selection or cancellation select its title just in time to be presented at the object on clicked check box the right in list box 213.Can select or cancel the one or more objects of selection.List scrolling can reflect on check box certainly.In case select, if the user wants to remove all selected objects from list box 213,214 and 202, he can utilize positioning equipment 105 to click " Delete (deletion) " button 207.If there is not other object (ST, STI, RE, RME, RST or RSTI) to quote at least one of these objects, so, delete them, at once so that they no longer appear on list box 213,214 and 202.If exist at least one other ST, STI, RE, RME, RST or RSTI to quote at least one of selected object, so, on display device 106, show traditional dialog box, at first tell the user with this situation, next asks his unerase operation or confirm it.If user's decision is the cancellation operation, so, do not take any action, otherwise, delete selected object, so that they no longer appear on list box 213,214 and 202 at once.

Alternately, be unique selected object if the user wants to edit hypothesis, he can utilize positioning equipment 105 to click " Edit (editor) " button 211.

If do not have alternative in the past or selected a plurality of objects, as in RST manager dialog frame 200, check box on the left of being arranged in does not have check mark or exists shown in a plurality of check marks (observable or invisible), so, on display device 106, pass through traditional means, for example, pop-up window, status bar message maybe can be used instead and can not departed from any other similar traditional means of spirit of the present invention, show alert message to the user.

If selected single object in the past, as as check box 212, the check box that is arranged in the left side exists shown in the single check mark (observable or invisible), so, at first close RST manager dialog frame 200, after this, consider this single selected Properties of Objects, with the new dialog box of determining to open.

If selected to as if EF or MEF, so, send the order of EF editing machine, so that EF editing machine method is taked control by at first show EF editing machine dialog box 301 as shown in Figure 3 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If selected to as if EP or MEP, so, send the order of EP editing machine, so that EP editing machine method is taked control by at first show EP editing machine dialog box 301 as shown in Figure 4 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If selected to as if RE or RME, so, send the order of RE editing machine, so that RE editing machine method is taked control by at first show the RE editing machine dialog box 2321 shown in Figure 18 B on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If selected to as if ST, so, send the order of ST editing machine, so that ST editing machine method is taked control by at first show ST editing machine dialog box 501 as shown in Figure 5 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If selected to as if RST, so, send the order of RST editing machine, so that RST editing machine method is taked control by at first show RST editing machine dialog box 601 as shown in Figure 6 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

Alternately, to defer to hypothesis be unique and the STI or the RSTI that are the selected object of ST or RST respectively if the user wants to generate, and he can utilize positioning equipment 105 to click " Instanciate (instantiation) " buttons 204.

If do not have alternative in the past or selected a plurality of objects, as in RST manager dialog frame 200, as check box 212, the check box that is arranged in the left side does not have check mark or exists shown in a plurality of check marks (observable or invisible), so, on display device 106, by traditional means, for example, pop-up window, status bar message, maybe can use instead and can not depart from any other similar traditional means of spirit of the present invention, show alert message to the user.

If selected single object in the past, as check box 212, the check box that is arranged in the left side exists shown in the single check mark (observable or invisible), and so, this method checks whether this object is ST or RST.

If situation is not like this, so, on display device 106, by traditional means, for example, pop-up window, status bar message maybe can be used instead and can not departed from any other similar traditional means of spirit of the present invention, show alert message to the user.

If selected single ST in the past (correspondingly, RST) object, so, at first close RST manager dialog frame 200, after this, send ST instantiation device (correspondingly, RST instantiation device) order is so that ST instantiation device (correspondingly, RST instantiation device) method is by at first showing as Figure 13 A (correspondingly on display device 106, Figure 18 A) the ST instantiation device dialog box 1300 (correspondingly, RST instantiation device dialog box 2300) shown in is taked control.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

Alternately, if the user wants one group of non-NULL object is exported to another electronic form file from current electronic form file, he can utilize positioning equipment 105 to click " Export " button 206.If stamped check mark on the check box " Including child objects (for Export) (comprising subobject (for deriving)) " 220, so, even without passing through as check box 212, the check box that is positioned at the left side is selected all subobjects of selected object, and these subobjects also will be benefited from derive operation.

If there was not alternative in the past, as in RST manager dialog frame 200, as check box 212, the check box that is arranged in the left side is without any shown in the check mark (observable or invisible), so, on display device 106, by traditional means, for example, pop-up window, status bar message, maybe can use instead and can not depart from any other similar traditional means of spirit of the present invention, show alert message to the user.

If selected one or more objects in the past, as as check box 212, the check box that is arranged in the left side exists shown at least one check mark (visible or sightless), so, at first close RST manager dialog frame 200, after this, send RST Export Mananger (RST derives manager) order, so that be presented at and make RST derive the manager method on the display device 106 to take control by at first RST being derived manager dialog box 2600, shown in Figure 21 A.In further part, describe the subsequent step of this scheme situation in detail.

Alternately, if the user wants one or several object is imported to current electronic form file from another electronic form file, he can utilize positioning equipment 105 to click " Import (importing) " button 205.At first close RST manager dialog frame 200, after this, send RST Import Mananger (RST imports manager) order, so that by at first importing manager dialog box 2620 as demonstration RST on Figure 21 display device that B is shown in 106, RST imports the manager method and takes control.The later step of this scene situation is described in detail in detail in follow-up chapters and sections.)

Alternately, the type of the new object that may create after if the user wants to specify, he can utilize positioning equipment 105 to click one of five OptionButtons 217 " Format (form) ", 209 " Profile (summaries) ", 216 " Template (templates) ", 218 " RE " and 219 " Recursive Template (recurrence template) " in the lower-left of RST Mananger (RST manager) dialog box 200 side.The user has the selection of EF, EP, RE, ST or RST being appointed as the type of the new object that after this will create.

Alternately, whether derive the new object that after this will create if the user wants to specify electronic form file from the current range of cells of selecting, he can utilize positioning equipment 105 to click the check box 208 that is called " From current selection (from current selection) ".

Alternately, if the user wants to create the new object of having specified type in the past by means of five OptionButtons as following, he can utilize positioning equipment 105 to click " Create New (the new establishment) " button 210:

" Profile " OptionButton 209;

" Format " OptionButton 217;

" Template " OptionButton 216

" RE " OptionButton 218; Or

" Recursive Template " OptionButton 219.

If selected by the user before these five OptionButton neither ones demonstrate, as in RST manager dialog frame 200, shown in these five OptionButtons 209,216,217,218 and 219 neither ones are got ready, so, on display device 106, pass through traditional means, for example, pop-up window, status bar message maybe can be used instead and can not departed from any other similar traditional means of spirit of the present invention, show alert message to the user.

If one of these five OptionButtons 209,216,217,218 and 219 demonstrate former user and select, so, at first close RST manager dialog frame 200, after this, consider single selected OptionButton, with the new dialog box of determining to open.

If " Format (form) " OptionButton 217 demonstrates selection, so, send the order of EF editing machine, so that EF editing machine method is taked control by at first show EF editing machine dialog box 301 as shown in Figure 3 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If " Profile (summary) " OptionButton 209 demonstrates selection, so, send the order of EP editing machine, so that EP editing machine method is taked control by at first show EP editing machine dialog box 301 as shown in Figure 4 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If " Template (template) " OptionButton 216 demonstrates selection, so, send the order of ST editing machine, so that ST editing machine method is taked control by at first show ST editing machine dialog box 501 as shown in Figure 5 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If " RE " OptionButton 218 demonstrates selection, so, send the order of RE editing machine, so that RE editing machine method is taked control by at first show the RE editing machine dialog box 2321 shown in Figure 18 B on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

If " Recursive Template (recurrence template) " OptionButton 219 demonstrates selection, so, send the order of RST editing machine, so that RST editing machine method is taked control by at first show RST editing machine dialog box 601 as shown in Figure 6 on display device 106.The then step of this scheme example is described in detail in detail in chapters and sections subsequently.

At last, if the user wants to finish RST manager method, he can utilize positioning equipment 105 to click " Done (finishing) " button 201 or close window button 215.Consequently close the RST manager dialog frame 200 on the display device 106.

B.EF editing machine: according to the scheme of front illustration RST manager method, the electrical form user then can be by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " EF editing machine ", so that create new EF; Create new MEF; Upgrade existing EF; Or the existing MEF of renewal.People such as Aureglia are the International Patent Application PCT/EP 02/09483 of " system and method for the content from a scalable schema instance to another scalable schema instance derivation-importing input block lattice in electrical form; (System and method in an electronicspreadsheet for exporting-importing the content of input cells from a scalabletemplate instance to another) " in denomination of invention, in (IBM list of references FR9 2,001 0029) corresponding scheme has been described.

C.EP editing machine: according to the scheme of front illustration RST manager method, the electrical form user then can be by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " EP editing machine ",, create new MEP so that create new EP, upgrade existing EP, or upgrade existing MEP.

People such as Aureglia are the International Patent Application PCT/EP02/09483 of " system and method for the content from a scalable schema instance to another scalable schema instance derivation-importing input block lattice in electrical form; (System andmethod in an electronic spreadsheet for exporting-importing the content of inputcells from a scalable template instance to another) " in denomination of invention, in (IBM list of references FR9 2,001 0029) corresponding scheme has been described.

D.RE editing machine: according to the scheme of front illustration RST manager method, the electrical form user then can be by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " RE editing machine ",, create new RME so that create new RE, upgrade existing RE, or upgrade existing RME.

This can come illustration by means of the described user interface of reference Figure 18 B, and Figure 18 B shows as the RE editing machine dialog box 2321 in the GUI window that is presented at the electrical form office application software on the display device 106.

When showing RE editing machine dialog box 232 on display device 106, it comprises some message segments.

The first, whether be the character that a pair of OptionButton 2330 and 2331 of RE or RME illustrates edit object by specifying.The electrical form user can click one of these two OptionButtons 2330 and 2331 with positioning equipment 105, so that switch RE definition and RME definition.

The second, the Field Count in text box 2326 middle fingers are delimited the organizational structure volume object.(the electrical form user has clicked OptionButton 218 with positioning equipment 105 in the past and will put dozen in the above and clicked button 210 when creating new RE or RME, the RST manager dialog frame 200 that the both is included in as shown in Figure 2 is interior), the value shown in the text box 2326 is corresponding to the default value of being arranged to 3 in a preferred embodiment of the invention.When existing RE of editor or RME, the value shown in the text box 2326 was corresponding to being the Field Count of this object definition in the past.In all situations, the electrical form user can be by clicking knobs 2327 with positioning equipment 105, clicks on the upthrow side or click on the decline side, so that can the value of making increase or reduce (in predetermined threshold), change is presented at the value in the text box 2326.

The 3rd, on mark button 2324, show the title of editing RE or RME.When existing RE of editor or RME, the title shown in the indicia framing 2324 is corresponding to the title that was assigned to this object in the past.When creating new RE or RME, so, be presented at title on the indicia framing 2324 corresponding in a preferred embodiment of the invention, take the default value of " New XX (new XX) " form, wherein, XX is the counting that guarantees the create name uniqueness.

The 4th, text box 2325 and 2334 is specified the ST that constitutes editor RE or RME together.Text box 2325 is specified as usual, is the Far Left field value 1 of editor RE or RME, with get for the rightmost field of editor RE or RME be presented at text box 2326 on the field grade of that identical value.Text box 2324 is the title that text box 2325 specifies the field of its grade to specify ST.

RE editing machine dialog box 2321 comprises the several Drawing Objects that allow the electrical form user to take some actions.

The first, the electrical form user can be assigned to newname RE or the RME when pre-editing.For this purpose, he at first utilizes the traditional means appointment in text box 2325 such as keyboard 104 will edit the newname of RE or RME.Then, he utilizes positioning equipment 105 to click " Saveas (saving as) " button 2332.If the create name in the input text frame 2325 has been assigned to existing object or has not been effective title, so, on display device 106, pass through traditional means, for example, pop-up window, status bar message maybe can be used instead and can not departed from any other similar traditional means of spirit of the present invention, show alert message to the user.This warning message then, reminds him to be confirmed this condition notification electrical form user.Then, remove text box 2325 and do not take further action.If the create names in the input text frame 2325 also are not assigned to existing object and are effective titles, so, remove text box 2325 and edit object is kept under the newname that is also shown on the electronic form file in the indicia framing 2324.

The second, the electrical form user can be by clicking " Save (preservation) " buttons 2333 with positioning equipment 105, and the current definition of edit object is kept on the electronic form file.The consequence of this incident is whether RE or the RME that check is upgraded is quoted by existing RST.If situation is not like this, so, on display device 106, by traditional means, for example, pop-up window, status bar message maybe can be used instead and can not departed from any other similar traditional means of spirit of the present invention, show alert message to the user.This warning message is this condition notification electrical form user, then, reminds him to cancel operation or proceeds.In first kind of situation, do not preserve the RE or the RME definition of renewal, and in second kind of situation, it is kept on the electronic form file.

The 3rd, the electrical form user can change the definition of the ST that constitutes editor RE or RME.For this purpose, he is by clicking knobs 2329 with positioning equipment 105, reduce and improve in being presented at text box 2335 and the ST title be presented at the grade of the field in the text box 2334, at first in the field of edit object, navigate.Value that the field grade is got keep being worth within the range having a lower limit of 1 (one) and on be limited in the interval of value of text box 2326.Then, the electrical form user can select suitable ST title by clicking knob 2328 with positioning equipment 105, is presented at the title of the field renewal ST in the text box 2335 for its grade.

At last, if the user wants to finish RE editing machine method, he can utilize positioning equipment 105 to click " Done (finishing) " button 2323 or close window button 2322.Consequently close the RE editing machine dialog box 2321 on the display device 106.

E.ST editing machine: according to the scheme of front illustration RST manager method, the electrical form user then can be by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " ST editing machine ", so that create new ST or upgrade existing ST.People such as Aureglia have described corresponding scheme in denomination of invention among the International Patent Application PCT/EP 02/09483 (IBM list of references FR9 2,001 0029) of " System and method inan electronic spreadsheet for exporting-importing the content of input cells from ascalable template instance to another ".

F.RST editing machine: according to the scheme of front illustration RST manager method, the electrical form user then can be by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " RST editing machine ", so that create new RST or upgrade existing RST.This can come illustration by means of the described user interface of reference Fig. 6, and Fig. 6 shows as the RST editing machine dialog box 601 in the GUI window 611 that is presented at the electrical form office application software on the display device 106.When showing RST editing machine dialog box 601 on display device 106, active sheet becomes in a preferred embodiment of the invention the appropriate cards that is called " EditorSpace (editing machine space) " 615.In " Editor Space " 615 forms, the RST that edit is shown as a range of cells 614 in the upper left corner, and upper left cell is on the B2 of address.Although editor's RST is corresponding to the conventional range of cells 614 in the form, the conventional tool that is suitable for use in the spreadsheet environment can not be used to upgrade this range of cells 614.The electrical form user can only utilize as the special-purpose means of the part of RST editing machine dialog box 601 and navigate in the range of cells 614 of illustration RST and insertion or deletion row in the range of cells 614 of illustration RST.Row in " Editor Space " form 615 inserts or deletion will be under an embargo.In addition, " Editor Space " form 615 is added write-protect, revised the RE of a part that is defined as range of cells 614 illustrated RST or the setting of RME because of carelessness to prevent the user.When showing RST editing machine dialog box 601 on display device 106, it comprises relevant with range of cells 614 illustrated whole RST, or with current this same range of cells 614 in RE or some relevant message segments of RME of the cell indication of selection.

The first, the RE of the cell indication of current selection or RME are illustrated by " RE " combo box 610.By clicking the arrow that is positioned at these " RE " combo box 610 right sides with positioning equipment 105, the electrical form user can show the RE that defines and RME tabulation and in the tabulation of definition RE and RME, navigate, then, select RE or the RME that he selects and appear at his/her selection on the row on the current selected cell that is positioned at range of cells 614.If the electrical form user is by clicking " Up (on) " button 619 with positioning equipment 105, or " Down (descending) " button 616, change the selected row in the range of cells 614, so, the title of update displayed in combo box 610 is to specify and the new title of selecting corresponding RE of row or RME.If the electrical form user wants new RME is inserted in the Header Section or Footer Section of RST, he had to click " Add (interpolations) " buttons 617 with positioning equipment 105 just now, so that newline is inserted in the required place on the rearmost position of range of cells 614 interior current selected cells.Then, with the newline updating block lattice scope 614 that is presented on the window 611.Then, by being shown, acquiescence is assigned to the title renewal RST editing machine dialog box 601 of introducing RME in combo box 610.If the electrical form user wants to remove RME from the Header Section of RST or Footer Section, he had to click " Delete (deletion) " button 618 with positioning equipment 105 just now, so that remove corresponding line in required place in range of cells 614.Then, the current selected cells in the range of cells 614 become the row that belongs to unique RE that representative defines in RST that and upgrade RST editing machine dialog box 60 by the title that in combo box 610, is illustrated in the unique RE that defines in the RST.

The second, in " MIN (minimum) " text box 606, specify in the minimum RE number that allows in the RSTI that defers to the RST that is edited.Similarly, in " MAX (maximum) " text box 609, specify in the maximum RE number that allows in the RSTI that defers to editor RST.(the electrical form user has clicked OptionButton 219 with positioning equipment 105 in the past and will put dozen in the above and clicked button 210 when creating new RST, the RST manager dialog frame 200 that the both is included in as shown in Figure 2 is interior), value shown in " MIN " text box 606 is corresponding to being arranged to 1 default value and the value shown in " MAX " text box 609 in a preferred embodiment of the invention corresponding to the default value of being arranged to 16 in a preferred embodiment of the invention.When the existing RST of editor, the value shown in the text box 606 and 609 correspond respectively to as electrical form user definition in the past, deferring to the minimum and maximum RE number that in any RSTI of pre-editing RST, allows.In all situations, the electrical form user can be by clicking knob 607 or knob 608 respectively with positioning equipment 105, click is on the upthrow side or click on the decline side, so that when the value that guarantees appointment in " MIN " text box 606 keeps smaller or equal to the value in " MAX " text box 609, can the value of making increase or reduce (in predetermined threshold), change the value that is presented in text box " MIN " 606 or the text box " MAX " 609.Has the element number that drops on outside new " MIN "-" MAX " interval if defer to certain the existing RSTI that upgrades RST, so, this RSTI will not be upgraded by RST will to be influenced, but the RE in any future adds or removes and finish according to the interval redetermination of " MIN (minimum) "-" MAX (maximum) ".

The 3rd, on mark button 604, show the title of editing RST.When editor had RST now, the title shown in the indicia framing 606 was corresponding to the title that was assigned to this object in the past.When creating new RST, so, be presented at title on the indicia framing 604 corresponding in a preferred embodiment of the invention, take the default value of " NewXX " form, wherein, XX is the counting that guarantees the create name uniqueness.

RST editing machine dialog box 601 comprises the several Drawing Objects that allow the electrical form user to take some actions.

The first, form if work as the current RE and the RME of RST of pre-editing by the field that all has same number, the electrical form user can be assigned to newname as this RST.In fact, in this case, enable " Save as (saving as) " button 612, so that its any click all is identified as validity event with positioning equipment 105.The electrical form user at first utilizes the traditional means appointment in text box 605 such as keyboard 104 will edit the newname of RST.Then, he utilizes positioning equipment 105 to click " Save as " button 612.If the create name in the input text frame 605 has been assigned to existing object or has not been effective title, so, on display device 106, pass through traditional means, for example, pop-up window, status bar message maybe can be used instead and can not departed from any other similar traditional means of spirit of the present invention, show alert message to the user.This warning message then, reminds him to be confirmed this condition notification electrical form user.Then, remove text box 605 and do not take further action.If the create names in the input text frame 605 also are not assigned to existing object and are effective titles, so, remove text box 2325 and editor's RST is kept under the newname that is also shown on the electronic form file in the indicia framing 604.

The second, if editor's current RE and the RME by the field that all has same number of RST forms, the electrical form user can be kept at the current definition of this RST on the electronic form file.In fact, in this case, enable " Save " button 613, so that its any click all is identified as validity event with positioning equipment 105.The consequence of this incident is whether the RST that check is upgraded is quoted by existing RSTI.If situation is not like this, so, the more redetermination of RST is kept on the electronic form file.If situation is like this, so, on display device 106, by traditional means, for example, pop-up window, status bar message maybe can be used instead and can not departed from any other similar traditional means of spirit of the present invention, show alert message to the user.This warning message is this condition notification electrical form user, then, reminds him to cancel operation or proceeds.In first kind of situation, do not preserve the RST definition of renewal, and in second kind of situation, it is kept on the electronic form file.

At last, if the user wants to finish RST editing machine method, he can utilize positioning equipment 105 to click " Done (finishing) " button 603 or close window button 602.Consequently close the RST editing machine dialog box 601 on the display device 106 and turn back to the form that activates when calling the order of RST editing machine at first.

G.ST instantiation device: according to the scheme of front illustration RST manager method, the electrical form user then can be by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " ST instantiation device ", so that create the STI that defers to selected ST and locate according to current selected cell.People such as Aureglia have described corresponding scheme in denomination of invention among the International Patent Application PCT/EP 02/09483 (IBM list of references FR9 2,001 0029) of " System and method in an electronic spreadsheet for exporting-importingthe content of input cells from a scalable template instance to another ".

H.RST instantiation device: according to the scheme of front illustration RST manager method, the electrical form user then can be by means of the traditional means that is suitable for use in the spreadsheet environment, for example, positioning equipment 105 or keyboard 104 (but being not limited to these), call the original specific command that is called " RST instantiation device ", so that create the RSTI that defers to selected RST and locate according to current selected cell.This can come illustration by means of the described user interface of reference Figure 18 A, and Figure 18 A shows the RST instantiation device dialog box 2300 as on being presented at display device 106.When showing RST instantiation device dialog box 2300 on display device 106, active sheet is still remained valid, and superincumbent data occur so that the user can see.RST instantiation device dialog box 2300 comprises some message segments relevant with instantiation operation.

The first, the title of deferring to the RST of the RSTI that will create is presented in the indicia framing 2302.

The second, the RE number that when RSTI creates, will occur shown in the text box 2311.This numeral takes to equal the default value as the minimum RE number appointment in the definition of the RST that defers to the RSTI that will create.If the electrical form user wants to create RSTI with another RE number, so, he has to the upside or the downside of positioning equipment 105 click knobs 2303, to increase or to reduce the number of RE.The variation in the scope that defines by the minimum RE number as appointment in the definition at RST and maximum RE number (field " Min Element# (smallest element prime number) " 2225 and " Max Element# (greastest element prime number) " 2226 in the record 2221 of " Name (title) " field 2222 and the RSTT table 2220 that is presented at the name-matches in the indicia framing 2302) of this RE number, and, after possible renewal, be presented in the text box 2311.

The 3rd, button " Cancel (cancellation) " 2308 or close window button 2301 allow the electrical form user to close RST instantiation device dialog box 2300 and do not take further action.By clicking one of these two buttons 2301 and 2308 with positioning equipment 105, RST instantiation device dialog box 2300 is closed with the RST instantiation operation is ended.

The 4th, when at first being enabled, when secondly being clicked with positioning equipment 105 by the electrical form user, button " Create Instance (establishment example) " 2310 becomes the trigger that starts the RST instantiation operation.In the time that instantiation operation can be carried out, enable this button " Create Instance " 2310 (meaning the click event of this method approval positioning equipment 105 on this button " Create Instance " 2310).Whether this RST instantiation can depend on different factors: the size of the position of current selected cell in the active sheet of electrical form, the RSTI that will create, belong to the existence of any existing STI of the form identical with current selected cell.Whether can create size with appointment in text box 2303, defer to the RST of its title by indicia framing 2302 appointments, the upper left corner is positioned at new RSTI on the current selected cell by as the part of RST instantiation device dialog box 2300, several indicia framings of value " YES " or " NO " reflect: reflect the indicia framing 2304 that new RSTI is whether too wide, reflect the indicia framing 2305 that new RSTI is whether too high, be reflected in the indicia framing 2306 that whether has defined any existing STI on the form that comprises current selected cell, whether may cause appearing at the indicia framing 2307 that any available data in one or several electronic form unit grid is lost with the establishment of the new RSTI of reflection.In case indicia framing 2304, indicia framing 2305 or indicia framing 2306 values " YES " so, are just thought and cannot be created RSTI, thereby forbid " Create Instance " button 2310.If displayed value in these three indicia framings " NO (denying) " so, can carry out instantiation operation, thereby enable " Create Instance " button 2310.When the electrical form user clicks with positioning equipment 105, carry out instantiation operation, then, close RST instantiation device dialog box 2300.

The 5th, when at first being enabled, when secondly being clicked with positioning equipment 105 by the electrical form user, button " Create Instance in a new sheet (in new sheet, creating example) " 2309 become the alternative trigger that starts the RST instantiation operation, but, in the form of creating as the part of this instantiation operation.In a preferred embodiment of the invention, after comprising the form of current selected cell, create new form.Can use any other form position instead, this does not depart from spirit of the present invention.In the time can in new form, carrying out instantiation operation, enable this button " Create Instance in a new sheet " 2309 (meaning the click event of this method approval positioning equipment 105 on this button " Create Instance in a new sheet " 2309).Whether this RST instantiation can depend on the size of the RSTI that different factors will be created.Whether can in new form, create size, defer to its title and reflect by several indicia framings: reflect the indicia framing 2304 that new RSTI is whether too wide and reflect the indicia framing 2305 that new RSTI is whether too high as the part of RST instantiation device dialog box 2300, value " YES (being) " or " NO (denying) " by the new RSTI of indicia framing 2302 appointments with appointment in text box 2303.In case indicia framing 2304 or indicia framing 2305 values " YES " so, are just thought and cannot be created RSTI in new form, thereby forbid " Create Instance in a new sheet " button 2309.If displayed value " NO " in these two indicia framings so, can carry out instantiation operation, thereby enable " Create Instance in a new sheet " button 2309 in new form.When the electrical form user clicks with positioning equipment 105, carry out instantiation operation, then, close RST instantiation device dialog box 2300.

Second operation: importing/derivation RST object

When the electrical form user during set of shared one or several EF and/or MEF and/or EP and/or MEP and/or ST and/or RE and/or RME and/or RST, the 6th operation takes place by importings/derivation is machine-processed according to his or she the standard decision of not describing in detail here between source electronic form file and target electronic form document.In a preferred embodiment of the invention, this operation may further comprise the steps:

A. the electrical form user at first passes through conventional apparatus available in spreadsheet environment such as but not limited to pointing device 105 or keyboard 104, call the original particular command that is known as " RST manager ", so that the EF of visual any existence or MEF or EP or MEP or ST or RE or RME or RST.

This initial step is corresponding to the first step of first operation of this scene, and wherein the electrical form user can select one or more EF or MEF or EP or MEP or ST or RE or RME or RST.

B.RST derives manager: then, the electrical form user passes through conventional apparatus available in spreadsheet environment such as but not limited to pointing device 105 or keyboard 104, call the original particular command that is known as " RST derives manager ", so that this group of storage is selected in derivation/importing file EF or MEF or EP or MEP or ST or RE or RME or RST.This can be to be illustrated by the described user interface of Figure 21 A, and wherein Figure 21 A shows as being presented at the RST derivation dialog box 2600 on the display device 106.When beginning to be shown, RST derives dialog box 2600 and comprises three buttons, thereby allows the electrical form user select

Operation (by clicking " cancellation " button 2602 with pointing device 105) is derived in cancellation, perhaps

Begin to export to the operation (by clicking " exporting in the new file " button 2612) in the new derivation-importing file that will be created, perhaps with pointing device 105

Begin to export to the operation of wanting in the selecteed derivation that has existed-importing file (by clicking " exporting in the existing file " button 2613) with pointing device 105.

If click " cancellation " button 2602, then close RST and derive dialog box 2600, and derive EO, and do not take further operation.

If click " exporting in the new file " button 2612, then on display device 106, show traditional document creation dialog box, to allow the electrical form user in existing document directory structure, navigate, in the catalogue that selects files, name and create new file.Also can use any similar traditional means to replace the document creation dialog box, and not break away from spirit of the present invention.

If click " exporting in the existing file " button 2613, then on display device 106, show traditional file selection dialog box, to allow the electrical form user in existing document directory structure, navigate, in file directory, select existing file then.Also can use any similar traditional means to replace file to select dialog box, and not break away from spirit of the present invention.

In case the electrical form user has specified existing file, then carry out test, whether be effective derivation-importing file with inspection this document, and follow this predefined logical file structrure.

If not this situation, then warn this situation to the electrical form user.For this reason, can or can be used and do not break away from any other similar traditional means of spirit of the present invention by traditional means such as pop-up window, status bar message, message gives a warning on display device 106.This alert message invites the electrical form user to confirm this warning by traditional prompting means as " determining " button to electrical form user notification this document situation then.Then, close this alert message, thereby the electrical form user can click one of three

buttons

2602,2612 available in RST derives

manager dialog box

2600 and 2613 with pointing device 105 once more.

If the existing file of user's appointment is correct derivation-importing file, if perhaps user's selection is to create new derivation-importing file, then finishes RST and derive manager dialog box 2600, wherein text box 2603 shows the title of these derivation-importing files.

Then, by moving each member of (from electronic form file to derivations-importings file) selected EF or the set of MEF or EP or MEP or ST or RE or RME or RST seriatim, start derivation and operate.

If the electrical form user did not before put radio check mark in " comprising subobject (at the deriving) " check box 220 on being present in RST manager dialog frame 200, then can define this group selected object by explicitly.In this case, only be chosen in as having the object of radio check mark in 212 the check box deriving operation.

If the electrical form user before put radio check mark in " comprising subobject (at the deriving) " check box 220 on being present in RST manager dialog frame 200, then can also implicitly define this group selected object.In this case, automatically select to belong to any object of the definition of object of (by such as 212 check box) explicit selection for deriving operation implicit expression.This for example allows, and the electrical form user derives all RE, RME, ST, EF, MEF, EP, MEP that the definition of selected RST is made contributions then only by check box 212 selection RST objects.

This situation is shown in Figure 17 G, and wherein Figure 17 G explicit selection of showing single object (its name is called the RST that " RST_customer_light " and its index field 2238 equal 23) causes discerning own " subobjects " of the definition of object that participates in explicit selection.By with the order that descends hierarchy according to the object of explicit selection, implicit expression select to as if " RE_headingl " and " RE_body ", being " ST_cust_data ", " ST_contacts ", " ST_res_info " and " ST_pb_log " under it, is " EPhdr_cust_data_SLA ", " EPhdr_contacts " and " EPhdr_res_pb " under it.As further describing in the chapters and sections below, the formula corresponding with the content of the son field of " being cited " attribute 2240 allows automatically to discern all objects of the definition of object that participates in explicit selection.

The progress that derives operation is by progress bar 2604 reflections, and it translates the part of having finished processing in the whole derivation operation with graphics mode.Deriving operating period, be under the situation of the file that existed at derivation-importing file, discern potential conflicting between the version that can formerly export to the object (EF or MEF or EP or MEP or ST or RE or RME or RST) in this derivation-importing file and the redaction of the same candidate object that will be derived.If this situation is then finished RST with one group of information and derived manager dialog box 2600, wherein these information all are included in the frame 2611.

The first, the title of the object that demonstration clashes in text box 2605.

The second, in text box 2606, show the date that is associated with the object version that in the derivation-importing file of appointment, finds.

The 3rd, in text box 2607, show the date that is associated with the candidate target that is used to derive.

By receiving all these information, the electrical form user can determine how to handle this conflict.

First to select be to click "No" buttons 2608 with pointing device 105, and preventing the derivation operation at this special object, thereby the previous version that writes down in the derivation-importing file of appointment remains unchanged.

Second selection is to click "Yes" buttons 2610 with pointing device 105, to continue derivation operation at this special object, just, replacing the current object version that writes down with the object version definition of the part that is defined as current electronic form file in derivations-importing file defines.

The 3rd selection is to click " all being " buttons 2609 with pointing device 105, to continue the derivation operation at this special object, still for any other object of the conflict situations that also will fall into same type, also will continue the derivation operation.

In case the electrical form user has clicked one of these three

buttons

2608,2609 or 2610 with pointing device 105, then frame 2611 and all Drawing Objects (label, text box and button) that it comprised are derived manager dialog box 2600 from RST and are disappeared.When by all object parts (EF or MEF or EP or MEP or ST or RE or RME or RST) of this group selected object of having derived operational processes, on display device 106, close RST and derive manager dialog box 2600, and (new or upgrade) derivation-importing file is ready, so that be directed to another electronic form file.

C.RST imports manager: then, the electrical form user moves on to another electronic form file, pass through traditional means available in spreadsheet environment then such as but not limited to pointing device 105 or keyboard 104, call the original particular command that is known as " RST imports manager ", so that from derivation-importing file, retrieve one or several EF and/or MEF and/or EP and/or MEP and/or ST and/or RE and/or RME and/or RST.This can be to be illustrated by the described user interface of Figure 21 B, and wherein Figure 21 B shows as being presented at the RST importing manager dialog box 2620 on the display device 106.When beginning to be shown, RST imports dialog box 2620 and comprises two buttons, thereby allows the electrical form user select

Cancellation import operation (by clicking " cancellation " button 2622) with pointing device 105, perhaps

Begin from the import operation (by click " selecting to import file " button 2632 with pointing device 105) of wanting the selecteed derivation that has existed-importing file.

If click " cancellation " button 2622, then close RST and import dialog box 2620, and the import operation end, and do not take further operation.

If click " selecting to import file " button 2632, then on display device 106, show traditional file selection dialog box, to allow the electrical form user in existing document directory structure, navigate, in file directory, select existing file then.Also can use any similar traditional means to replace file to select dialog box, and not break away from spirit of the present invention.

If not this situation, then warn this situation to the electrical form user.For this reason, can or can be used and do not break away from any other similar conventional apparatus of spirit of the present invention by conventional apparatus such as pop-up window, status bar message, message gives a warning on display device 106.This alert message invites the electrical form user to confirm this warning by traditional suggestion device as " determining " button to electrical form user notification this document situation then.Then, close this alert message, thereby the electrical form user can be once more clicks one of available in RST imports manager dialog box 2,620 two buttons 2622 and 2632 with pointing device 105.

If the file of user's appointment is correct derivation-importing file, then finish RST and import manager dialog box 2620, wherein text box 2623 shows the title of this derivation-importing file.Then, by move EF or MEF or EP or MEP or ST or RE or RME or the RST that (from derivations-importing file to electronic form file) writes down, startup import operation seriatim derivation-importing file.The progress of import operation is by progress bar 2624 reflections, and wherein progress bar 2624 is translated the part of having finished processing in the whole import operation with graphics mode.

During this import operation, potential the conflicting of identification between the version of the object that can in electronic form file, define (EF or MEF or EP or MEP or ST or RE or RME or RST) and the version that in this derivation-importing file, writes down.If this situation is then finished RST with one group of information and imported manager dialog box 2620, wherein these information all are included in the frame 2631.

The first, the title of the object that demonstration clashes in text box 2625.

The second, in text box 2626, show the date that is associated with the object version that in electronic form file, finds.

The 3rd, in text box 2627, show the date that is associated with the object version that in derivation-importing file, writes down.

First to select be to click "No" buttons 2628 with pointing device 105, and preventing the import operation at this special object, thereby the previous version that writes down in electronic form file remains unchanged.

Second selection is to click "Yes" buttons 2630 with pointing device 105, to continue import operation at this special object, just, replace the current object version definition of in electronic form file, writing down with the object version definition of the part that is defined as deriving-import file.

The 3rd selection is to click " all being " buttons 2629 with pointing device 105, to continue the import operation at this special object, still for any other object that also will fall into the same type conflict situations, also will continue import operation.

In case the electrical form user has clicked one of these three buttons 2628,2629 or 2630 with pointing device 105, then frame 2631 and all Drawing Objects (label, text box and button) that it comprised import manager dialog box 2620 from RST and disappear.When having handled all object parts (EF or MEF or EP or MEP or ST or RE or RME or RST) of the explicit or object that implicit expression is selected of this group by import operation, on display device 106, close RST and import manager dialog box 2620, and current electronic form file is upgraded by the definition that imports from derivation-importing file.

E. method

E1.RST manager method

The method summary that is used in management EF, MEF, EP, MEP, ST, RE and RST in the preferred embodiment of the present invention is in the process flow diagram 800 of Fig. 8.This method can be regarded as RST manager process of commands.

In step 801, this method is in its default conditions, waits for the incident of this process of startup.

In step 802,, detect the order of RST manager as the result of user action.This action can be, for example:

Particular key combination on the keyboard 104;

The click of positioning equipment 105 on specific button; Or

This paper does not make further any other similar means of regulation.

In step 803, some local variables of initialization:

Local variable RSTM_select (selection) value of being configured to 0 (zero);

Local variable RSTM_new (newly) value of being configured to " NONE (nothing) ";

Local variable RSTM_range (scope) value of being configured to " NO (denying) ";

Local variable RSTM_index (index) value of being configured to 1 (one); With

Local variable RSTM_child (subsystem) value of being configured to " NO ".

In step 804, analyze five tables EFT 700, EPT 710, STT 720, RET 2210 and RSTT 2220, with derived table RSTMT 2230.For each respective record 701,711,721,2211 or 2221 that in one of these five tables, finds, in RSTMT table 2230, create new record 2231.

Referring now to Fig. 7 A, 7B, 7C, 17A, 17B and 17C, this structure is finished as follows: will be defined in record 701 (" Name " fields 702, " Last Change Date " field 703, " Description Ptr " field 704, " Row# " field 705, " Column# " field 706 and " Type " field 707), record 711 (" Name " fields 712, " Last Change Date " field 713, " Description Ptr " field 714, " Row# " field 715, " Column# " field 716 and " Type " field 717), record 721 (" Name " fields 722, " Last Change Date " field 723, " Description Ptr " field 724, " Min Element# " field 725, " Max Element# " field 726 and " Type " field 727), record 2211 (" Name " fields 2212, " Last ChangeDate " field 2213, " Description Ptr " field 2214, " Row# " field 2215, " Column# " field 2216 and " Type " field 2217), or write down 2221 (" Name " fields 2222, " LastChange Date " field 2223, " Description Ptr " field 2224, " Min Element# " field 2225, " Max Element# " field 2226 and " Type " field 2227) in all fields copy to record 2231 (" Name " fields 2232 successively, " Last Change Date " field 2233, " Description Ptr " field 2234, " Info Field 1 " field 2235, " Info Field 2 " field 2236 and " Type " field 2237) respective field, then, if from writing down 701,711,721,2211, or 2221 copy to respectively the record 2231, at Type " " SELECTED " attribute 2242 is initialized to " NO " in the field 2237; and with " NATURE (character) " field 2241 values of being initialized to " FORMAT "; " PROFILE "; " TEMPLATE "; " RECELEMENT "; or " RECTEMPLATE ", then, use all increase progressively for each new record and from be worth 1 (one) beginning the last field of count value initialization " Index " 2238.

In step 805, on display device 106, show RST manager dialog frame 200.

" Name " information that appears at list box 213 tops equals " Name " field 2232 of the record 2231 of local variable RSTM_index corresponding to " Index " field 2238 in the RSTMT table 2230.Following " Name " information in this list box 213 is corresponding to " Name " field 2232 of the trailer record 2231 of RSTMT table 2230.

" Type " information that appears at list box 214 tops is to derive from its " Index " field 2238 equals " Type " field 2237 (attribute " NATURE (character) " 2241 and " META (unit) " 2239) of the record 2231 the RSTMT table 2230 of local variable RSTM_index.Following " Type " information in this list box 213 derives from " Type " field 2237 (attribute " NATURE " 2241 and " META " 2239) of the trailer record 2231 of RSTMT table 2230.

" Modified (the modification) " information that appears at list box 202 tops equals " Last Change Date " field 2233 of the record 2231 in the RSTMT table 2230 of local variable RSTM_index corresponding to its " Index " field 2238.Following " Modified " information in this list box 213 is corresponding to " Last Change Date " field 2233 of the trailer record 2231 of RSTMT table 2230.

Have " SELECTED (the selecting) " attribute 2242 that equals " YES " if its " Index " field 2238 equals " Type " field 2237 of the record 2231 in the RSTMT table 2230 of local variable RSTM_index, on check box 212, stamp check mark.The following check box in list box 213 left sides also is to derive " Type " field 2237 (" SELECTED " attribute 2242) from the trailer record 2231 of RSTMT table 2230.

And if only if, and local variable RSTM_new equals " FORMAT (form) ", and OptionButton " Format " 217 shows stain.And if only if, and local variable RSTM_new equals " PROFILE (summary) ", and OptionButton " Profile " 209 shows stain.And if only if, and local variable RSTM_new equals " TEMPLATE ", and OptionButton " Template (template) " 216 shows stain.And if only if, and local variable RSTM_new equals " RECELEMENT ", and OptionButton " RE " 218 shows stain.And if only if, and local variable RSTM_new equals " RECTEMPLATE (recurrence template) ", and OptionButton " Recursive Template " 219 shows stain.

And if only if, and local variable RSTM_range equals " YES ", and check box " From_currentselection (from current selection) " 208 shows check mark.

And if only if, and local variable RSTM_child equals " YES ", and check box " Includingchild objects (for Export) (comprising subsystem object (being used for deriving)) " 220 shows check mark.

In step 806, this method is waited for the Any user action on the RST manager dialog frame 200.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 807, detect the user action on the RST manager dialog frame 200.

If user action is a button click " Delete (deletion) " 207, so, give step 808 with control;

If user action is a button click " Import (importing) " 205, so, give step 810 with control;

If user action is button click " Done (finishing) " 201 or close window button 201, so, give step 834 with control;

If user action is a button click " Export (derivation) " 206, so, give step 811 with control;

If user action is a click on scroll bar 203, upward to or downward direction, so, give step 814 with control;

If user action is click option button " Format " 217, " Profile " 209, " Template " 216, " RE " 218 or " Recursive Template " 219, so, give step 815 with control;

If user action is to click check box " From current selection " 209, so, give step 816 with control;

If user action is to click check box " Including child objects (for Export) " 220, so, give step 841 with control;

If user action is the top check box of clicking as check box 212, so, give step 817 with control;

If user action is a button click " Instanciate (instantiation) " 204, so, give step 830 with control;

If user action is a button click " Edit (editor) " 211, so, give step 824 with control; With

If user action is a button click " Create New (the new establishment) " 210, so, give step 818 with control.

In step 808, to " Type " field 2237 have son field " REFERENCEDOBJECT (institute's reference object) " (RO) 2240d equal " YES " or son field " INSTANCEREFERENCE " (IR) 2240c test (this test determines whether to exist one of selected object of some object references, or does not exist some objects to defer to one of selected object) greater than each of the record 2231 of the RSTMT table 2230 of " SELECTED " attribute 2242 of 1 (one).

If situation is like this, so, give step 835 (at least one record of the RSTMT table of selecting before meaning 2230 is quoted by ST, STI, RE, RST or RSTI) with control;

Otherwise, give step 809 with control.

In step 809, corresponding if " Name " separately field 702,712,722,2212 and 2222 and " Type " field 2237 have " Name " fields match that equals as the record 2231 of the RSTMT table 2230 of " SELECTED " attribute 2242 of " YES " from step 817, from EFT table 700, EPT table 710, STT table 720, RET table 2210 and RSTT table 2220, remove each and write down 701,711,721,2211 and 2221 separately.Then, with local variable RSTM_select value of being reset to 0 (zero).Then, give step 804, so that rebuild RSTMT table 2230 with control.

In step 810, send the order of RST Import manager, then, give step 834 with control.

In step 811, test to determine whether local variable RSTM_select (selection) equals 0 (zero).

If situation is like this, so, give step 813 with control;

Otherwise, give step 812 with control.

In step 812, send the order of RST Export manager, then, give step 834 with control.

In step 813, the message informing that gives a warning so that notify the user before clicking " Export " button 206, must be selected at least one object.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 805 with control.

In step 814, direction (up or down) according to positioning equipment 105 appointment on scroll bar 203, with as long as its value keeps positive and smaller or equal to the number of the record 2231 that defines RSTMT table 2230 in, local variable RSTM_index is added 1 (one) or subtract 1 (one).Then, give step 805 with control.

In step 815, upgrade local variable RSTM_new, hit OptionButton with the reflection user with positioning equipment 105.

If the user has clicked " Format " OptionButton 217, so, local variable RSTM_new value " FORMAT ".

If the user has clicked " Profile " OptionButton 209, so, local variable RSTM_new value " PROFILE ".

If the user has clicked " Template " OptionButton 216, so, local variable RSTM_new value " TEMPLATE ".

If the user has clicked " RE " OptionButton 218, so, local variable RSTM_new value " RECELEMENT ".

If the user has clicked " Recursive Template " OptionButton 219, so, local variable RSTM_new value " RECTEMPLATE ".

Then, give step 805 with control.

In step 816, upgrade local variable RSTM_range, between " YES " and " NO " so that its value is switched.In addition, if there was not or existed check mark before in check box 206, so, respectively check mark is added in this same check box 206 or from this same check box 206 and remove check mark.Then.Give step 805 with control.

In step 817, this method is upgraded in the RSTMT table 2230, finds that " Name " field 2232 equals to be positioned at just in time the value in " Type " field 2237 of the record 2231 of the character string of the list box 213 on the check box right side that the user has just clicked.

If the old value of this " Type " field 2237 has " SELECTED " attribute 2242 that equals " YES ", so, the value renewal comprises makes this " SELECTED " attribute 2242 be transformed into " NO "; On the contrary, if the old value of " SELECTED " attribute 2242 equals " NO ", so, the value renewal comprises makes this " SELECTED " attribute 2242 be transformed into " YES ".

In first kind of situation, local variable RSTM_select is subtracted 1 and in second kind of situation, RSTM_select adds 1 with local variable.

And, in first kind of situation, be present in before from the check box that the user had just clicked, removing in this check box check mark and in second kind of situation, on the check box that the user had just clicked, show check mark.Then, give step 805 with control.

In step 818, test to determine whether local variable RSTM_new equals " NONE ".If situation is like this, so, give step 819 with control; Otherwise, give step 820 with control.

In step 819, message informing gives a warning, so that notify the user before clicking " CreateNew " button 210, must select at least one object (" Format " OptionButton 217, " Profile " OptionButton 209, " Template " OptionButton 216, " RE " OptionButton 218 or " Recursive Template " OptionButton 219).This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 805 with control.

In step 820, test value to determine that local variable RSTM_new is got.

If find to equal " FORMAT " so, give step 821 with control;

If find to equal " PROFILE ", so, give step 822 with control;

If find to equal " TEMPLATE ", so, give step 823 with control.

If find to equal " RECELEMENT ", so, give step 836 with control.

If find to equal " RECTEMPLATE ", so, give step 837 with control.

In step 821, send the order of EF editing machine, and transmit two parameters (" NEW "; RSTM_range), then, give step 834 with control.

In step 822, send the order of EP editing machine, and transmit two parameters (" NEW "; RSTM_range), then, give step 834 with control.

In step 823, send the order of ST editing machine, and transmit a parameter (" NEW "), then, give step 834 with control.

In step 824, test to determine whether local variable RSTM_select equals 1 (one).If situation is like this, so, give step 825 with control; Otherwise, give step 829 with control.

In step 825, test to determine the selected Properties of Objects as 2237 appointments of " Type " field, that is, and " NATURE " attribute 2241 of the respective record 2231 of RSTMT table 2230.

If find to equal " FORMAT " so, give step 826 with control;

If find to equal " PROFILE ", so, give step 827 with control;

If find to equal " TEMPLATE ", so, give step 828 with control.

If find to equal " RECELEMENT ", so, give step 838 with control.

If find to equal " RECTEMPLATE ", so, give step 839 with control.

In step 826, send the order of EP editing machine, and transmit a parameter, this parameter equals " Name " field 2232 of unique record 2231 that its " Type " field 2237 has the RSTMT table 2230 of " SELECTED " attribute 2242 that equals " YES ", then, give step 834 with control.

In step 827, send the order of EF editing machine, and transmit a parameter, this parameter equals " Name " field 2232 of unique record 2231 that its " Type " field 2237 has the RSTMT table 2230 of " SELECTED " attribute 2242 that equals " YES ", then, give step 834 with control.

In step 828, send the order of ST editing machine, and transmit a parameter, this parameter equals " Name " field 2232 of unique record 2231 that its " Type " field 2237 has the RSTMT table 2230 of " SELECTED " attribute 2242 that equals " YES ", then, give step 834 with control.

In step 829, the message informing that gives a warning so that notify the user before clicking " Edit " button 211 or " Instanciate " button 204, must be selected single object (by means of the check box as 212) in ST manager dialog frame.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 805 with control.

In step 830, test to determine whether local variable RSTM_select equals 1 (one).If situation is like this, so, give step 831 with control; Otherwise, give step 829 with control.

In step 831, test to determine the selected Properties of Objects as 2237 appointments of " Type " field, that is, and " NATURE " attribute 2241 of the respective record 2231 of RSTMT table 2230.

If find to equal " TEMPLATE ", so, give step 832 with control;

If find to equal " RECTEMPLATE ", so, give step 840 with control;

Otherwise make and control to step 833.

In step 832, send the order of ST instantiation device, and transmit a parameter, this parameter equals " Name " field 2232 of unique record 2231 that its " Type " field 2237 has the RSTMT table 2230 of " SELECTED " attribute 2242 that equals " YES ", then, give step 834 with control.

In step 833, the message informing that gives a warning so that notify the user before clicking " Instanciate " button 204, must be selected single ST object or single RST object (by means of the check box as 212) in RST manager dialog frame.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 805 with control.

In step 834, close RST manager dialog frame 200, so that it disappears from display device 106, initial step 801 is given back in control, so that handle the order of any further RST manager.

In step 835, the message informing that gives a warning is so that notify at least one object that the user will delete by another object reference.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.Then, remind the user to cancel current " Delete (deletion) " operation, or proceed " Delete " operation.This can finish by on display device 106 reminder message being presented in the pop-up window usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user passes through traditional means, for example, click " Cancei (cancellation) " or " Continue (the continuation) " button that appears in the reminder message pop-up window with positioning equipment 105, or any other the similar means that do not depart from spirit of the present invention are made his selection, if electrical form user's decision is cancellation " Delete " operation, give step 805 with control, perhaps, if electrical form user's decision is to proceed " Delete " operation, give step 809 with control.

In step 836, send the order of RE editing machine, and transmit a parameter (" NEW "), then, give step 834 with control.

In step 837, send the order of RST editing machine, and transmit a parameter (" NEW "), then, give step 834 with control.

In step 838, send the order of RE editing machine, and transmit a parameter, this parameter equals " Name " field 2232 of unique record 2231 that its " Type " field 2237 has the RSTMT table 2230 of " SELECTED " attribute 2242 that equals " YES ", then, give step 834 with control.

In step 839, send the order of RST editing machine, and transmit a parameter, this parameter equals " Name " field 2232 of unique record 2231 that its " Type " field 2237 has the RSTMT table 2230 of " SELECTED " attribute 2242 that equals " YES ", then, give step 834 with control.

In step 840, send the order of RST instantiation device, and transmit a parameter, this parameter equals " Name " field 2232 of unique record 2231 that its " Type " field 2237 has the RSTMT table 2230 of " SELECTED " attribute 2242 that equals " YES ", then, give step 834 with control.

In step 841, upgrade the value of local variable RSTM_child by switching value " YES " and " NO ".Then, give step 805 with control.

E2.EF editing machine method

Be used in the establishment in the preferred embodiment of the present invention or upgrade EF or the method summary of MEF in the process flow diagram 900 of Fig. 9.This method can be regarded as EF editing machine process of commands.

In step 901, this method is in its default conditions, waits for the incident of this process of startup.

In step 902,, detect the order of EF editing machine as the result of user action.This action can be, for example:

Particular key combination on the keyboard 104;

The click of positioning equipment 105 on specific button; Or

This paper does not make further any other similar means of regulation.

In step 903, the parameter of retrieval command.They corresponding to:

First must have parameter EFE_name, can get retention " NEW ", or with as corresponding another value of string name finding in " Name " of the record in the RSTMT table 2,230 2231 field 2232; With

The second optional parameter EFE_range can only get two predetermined values " YES " and " NO ".When first value that parameter must be arranged and " NEW " not simultaneously, this second optional parameter must exist.

These two reference records are become local variable.

In step 904, some local variables of initialization: with local variable EFE_meta value of being arranged to " NO ", with local variable EFE_size (EFE size) value of being arranged to 8 (eight).

In step 905, test value to determine that local variable EFE_name is got.If find to equal " NEW ", so, give step 909 with control; Otherwise, give step 906 with control.

In step 906, search EFT table 700, find that with the location its " Name " field 702 equals the record 701 of the value that local variable EFE_name got.If find such record, so, give step 908 with control; Otherwise, give step 907 with control.

In step 907, call exception handler, this to handle " should not take place " situation.Such operation is to realize being correlated with, and can take different forms, for example, shows the error message pop-up window on display device 106.Then, give step 925 with control.

In step 908,

According to the value of " META " attribute 708 in " Type " field 707 of the record 701 that in step 906, finds, with local variable EFE_meta (EFE unit) value of being arranged to " YES (being) " or " NO (denying) ";

Local variable EFE_size is arranged in the value that finds among " Column# " 706 of the record 701 that in step 906, finds; With

The memory location of " Description Ptr " field 704 indications of the record 701 that will find in step 906 copies to Clipboard.

Then, give step 912 with control.

In step 909, according to the name character string of taking " New XX " form in a preferred embodiment of the invention, determine the newname of new EF of establishment or MEF, wherein, XX corresponding to for defined in the past and be recorded in form EFT 700, EPT 710, STT 720, RET 2210 and RSST 2220 separately write down all titles in " Name " field 702,712,722,2212 and 2222 that finds in 701,711,721,2211 and 2221 separately, guarantee the counting of title uniqueness.As long as guarantee the new uniqueness of creating title, can use any other similar traditional means instead and non-migration spirit of the present invention.

Then, newname is recorded among the local variable EFE_name.Then, memory allocated space in primary memory 102 is so that write down the illustration range of cells of EF or MEF later on.The storage space of this distribution is and a part when the corresponding storage space of electronic form file of front opening.

Then, in EFT table 700, create new record 701 and by this new record 701 of following initialization:

" Name " field 702 is arranged to the value of local variable EFE_name;

" Last Change Date " field 703 is arranged to quote as the system time known to the central processing unit 101;

The memory location that " Description Ptr " field 704 is arranged to just distribute;

" Row# " field 705 values of being arranged to 1 (because in a preferred embodiment of the invention, are managed ST under the 2D environment; Under the 3D environment, this field will be carried the line number into EF that creates or MEF definition);

" Column# " field 706 is arranged to the value of local variable EFE_size; With

By following setting " Type " field 707: attribute " META " 708 is arranged to equal the value of local variable EFE_meta and by following init attributes " REFERENCED " 709:

With also not being assigned to any other " OWN REFERENCE " (OR) prime number initialization OR son field 709a of son field 709a, 719a, 729a, 780a, 2219a, 2229a or 2240a.Various conventional arts can be used to discern prime number, are not described in further detail here.

With being worth (FR) son field 709b of 1 (one) initialization " FILIATION REFERENCE ".

With being worth (IR) son field 709c of 1 (one) initialization " INSTANCE REFERENCE ".

With (RO) son field 709d of following formula initialization " REFERENCED OBJECT ".

Wherein, P gathers the set corresponding to ST:

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

With (SC) son field 709e of following formula initialization " SELECTED CHILDREN (selected subsystem) ".Wherein, S gathers the set (" SELECTED " attribute 2242 with value of equaling in the RSTMT table 2230 " YES ") corresponding to selected object:

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#EFE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, give step 910 with control.

In step 910, test value to determine that local variable EFE_range is got.If find to equal " YES ", so, give step 911 with control; Otherwise, give step 912 with control.

In step 911, current selected range of cells is copied to Clipboard and local variable EFE_size is arranged to equal the columns of selected scope.

In step 912, make " Editor Space (editing machine space) " form 315 become active sheet, with on this blank form, in fixed cell lattice address 314 (as shown in Figure 3, in a preferred embodiment of the invention, address B2) goes up the content of pasting clipbook, so that the user can see the example of EF or MEF on display device 106.

In step 913, on display device 106, show EF editing machine dialog box 301.

Value initialization's indicia framing 304 with local variable EFE_name.

Equal " NO " (correspondingly, " YES ") if find local variable EFE_mata, stain is inserted in the OptionButton 310 of top (correspondingly, bottom).

The value of local variable EFE_size is inserted text box 306.

Equal " Column# " field 706 of current record 701 if find local variable EFE_size, if or find that the attributes " REFERENCED " 709 in this record " Type " field of 701 707 have son field " REFERENCEDOBJECT " 709d (RO) that equals " NO ", enable button " Save " 312 and " Save﹠amp; Refresh (preserve and refresh) " 308 so that in the future with positioning equipment 105 to this two buttons " Save " 312 and " Save﹠amp; Refresh " any click of 308 all is identified as a validity event.

Otherwise (do not find that local variable EFE_size equals " Column# " field 706 of current record 701, or find that the attributes " REFERENCED " 709 in " Type " field 707 of this same record 701 have son field " REFERENCEDOBJECT " 709d (RO) that equals " YES ", forbid button " Save " 312 and " Save﹠amp; Refresh " 308, so that use positioning equipment 105 in the future to this two buttons " Save " 312 and " Save﹠amp; Refresh " any click of 308 is not identified as a validity event.

In step 914, this method is waited for the Any user action on the EF editing machine dialog box 301.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 915, detect the user action on the EF editing machine dialog box 301.

If user action is button click " Save﹠amp; Refresh " 308, so, give step 916 with control;

If user action is a button click " Save " 312, so, give step 917 with control;

If user action is a button click " Save as " 311, so, give step 918 with control;

If user action is a button click " Clear (removing) " 309, so, give step 919 with control;

If user action is to click knob 307, so, give step 920 with control;

If user action is to click one of two OptionButtons 310, so, give step 921 with control;

If user action is button click " Done " 303 or close window button 302, so, give step 925 with control.

In step 916,, upgrade an EFT table 700 and a part of it being preserved into electronic form file by refreshing the record 701 that " Name " field 702 equals local variable EFE_name.For this purpose,

4 are arranged to the value of local variable EFE_size with " Column# " field 706; With by following setting " Type " field 707: the value of attribute " META " 708 being arranged to equal local variable EFE_meta.

In addition, will be on " Editor Space (editing machine space) " form 315 range of cells 314 of current definition of illustration EF or MEF copy to the memory location of " Description Ptr " field 704 indications.Then, give step 922 with control.

In step 917,, upgrade an EFT table 700 and a part of it being preserved into electronic form file by refreshing the record 701 that " Name " field 702 equals local variable EFE_name.For this purpose,

" Column# " field 706 is arranged to the value of local variable EFE_size; With

By following setting " Type " field 707: the value of attribute " META " 708 being arranged to equal local variable EFE_meta.

In addition, will be on " Editor Space " form 315 range of cells 314 of current definition of illustration EF or MEF copy to the memory location of " Description Ptr " field 704 indications.Then, give step 913 with control.

In step 918, the value that finds in text box 305 is tested, to determine that whether it is corresponding to effective newname.Corresponding criterion be realize relevant, as long as new recommend title with respect to be recorded in " Name " field 702,712,722,2212 and 2222 all define name be unique string, can take various forms and not depart from spirit of the present invention.If validity and uniqueness all obtain proof, so, give step 923 with control; Otherwise, give step 924 with control.

In step 919, be applied to " EditorSpace " form 315 with current at the undefined default property of spreadsheet environment, so that the EF or the MEF example that show are accepted these identical default propertys.Then, give step 913 with control.

In step 920, direction (up or down) according to positioning equipment 105 appointment on knob 307, with if the maintenance of its value positive and smaller or equal to being arranged to equal 254 the upper limit in a preferred embodiment of the invention, local variable EFE_size is added 1 (one) or subtract 1 (one).Then, give step 913 with control.

In step 921, upgrade local variable EFE_meta, if so that clicked bottom (correspondingly, the top) OptionButton 310, its value is become " YES " (correspondingly, " NO ").Then, give step 913 with control.

In step 922, send the order of ST Refresh (ST refreshes) manager, and following parameter: EFE_name, " FORMAT ", then, give step 913 with control.

In step 923, memory allocated space in primary memory 102 is so that write down the illustration range of cells of EF or MEF later on.The storage space of this distribution is and a part when the corresponding storage space of electronic form file of front opening.Then, in the EFT of a part that saves as electronic form file table 700, create new record 701 and by this new record 701 of following initialization:

" Name " field 702 is arranged in the value that finds in the text box 305 and in step 918, obtain examining; Then, this field 702 becomes the new value of EFE_name local variable;

" Column# " field 706 is arranged to the value of local variable EFE_size; With

With also not being assigned to any other " OWN REFERENCE " (OR) prime number initialization OR son field 709a of son field 709a or 719a or 729a or 780a or 2219a or 2229a or 2240a.Various conventional arts can be used to discern prime number, are not described in further detail here.

With (FR) son field 709b of value 1 (one) initialization " FILIATION REFERENCE (branch quotes) ".

With (IR) son field 709c of value 1 (one) initialization " INSTANCE REFERENCE (example is quoted) ".

With (RO) son field 709d of following formula initialization " REFERENCED OBJECT (object is cited) ".Wherein, P gathers the set corresponding to ST:

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#EFE name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, give step 913 with control.

In step 924, the message informing that gives a warning so that notify the user before clicking " Save as " button 311, must be specified effectively unique title in text box 305.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 913 with control.

In step 925, close EF editing machine dialog box 301, so that it disappears from display device 106, then, from window displayed, remove " Editor Space " form 315, so that the original form that occurs when being used in the EF editing machine and calling replaces it.At last, initial step 901 is given back in control, so that handle the order of any further EF editing machine.

E3.EP editing machine method

Be used in the establishment in the preferred embodiment of the present invention or upgrade EP or the method summary of MEP in the process flow diagram 1000 of Figure 10.This method can be regarded as EP editing machine process of commands.

In step 1001, this method is in its default conditions, waits for the incident of this process of startup.

In step 1002,, detect the order of EP editing machine as the result of user action.This action can be, for example:

Particular key combination on the keyboard 104;

The click of positioning equipment 105 on specific button; Or

This paper does not make further any other similar means of regulation.

In step 1003, the parameter of retrieval command.They corresponding to:

First must have parameter EPE_name, can get retention " NEW ", or with as corresponding another value of string name finding in " Name " of the record in the RSTMT table 2,230 2231 field 2232; With

The second optional parameter EPE_range can only get two predetermined values " YES " and " NO ".

When first value that parameter must be arranged and " NEW " not simultaneously, this second optional parameter must exist.

These two reference records are become local variable.

In step 1004, some local variables of initialization: with local variable EFE_meta value of being arranged to " NO ", with local variable EFE_size value of being arranged to 8 (eight).

In step 1005, test value to determine that local variable EFE_name is got.If find to equal " NEW ", so, give step 1009 with control; Otherwise, give step 1006 with control.

In step 1006, search EPT table 710, find that with the location its " Name " field 712 equals the record 711 of the value that local variable EPE_name got.If find such record, so, give step 1008 with control; Otherwise, give step 1007 with control.

In step 1007, call exception handler, this to handle " should not take place " situation.Such operation is to realize being correlated with, and can take different forms, for example, shows the error message pop-up window on display device 106.Then, give step 1025 with control.

In step 1008,

According to the value of " META " attribute 718 in " Type " field 717 of the record 711 that in step 1006, finds, with local variable EFE_meta value of being arranged to " YES " or " NO ";

Local variable EPE_size is arranged in the value that finds among " Column# " 716 of the record 711 that in step 1006, finds; With

The memory location of " Description Ptr " field 714 indications of the record 711 that will in step 1006, find copy to Clipboard and local variable EPE_Desc in.

Then, give step 1012 with control.

In step 1009, according to the name character string of taking " New XX " form in a preferred embodiment of the invention, determine the newname of new EP of establishment or MPF, wherein, XX corresponding to for defined in the past and be recorded in form EFT 700, EPT 710, STT 720, RET 2210 and RSST2220 separately write down all titles in " Name " field 702,712,722,2212 and 2222 that finds in 701,711,721,2211 and 2221 separately, guarantee the counting of title uniqueness.As long as guarantee the new uniqueness of creating title, can use any other similar traditional means instead and non-migration spirit of the present invention.

Then, newname is recorded among the local variable EFE_name.

Then, memory allocated space in primary memory 102 is so that write down the illustration range of cells of EP or MEP later on.The storage space of this distribution is and a part when the corresponding storage space of electronic form file of front opening.Then, in EPT table 710, create new record 711 and by this new record 711 of following initialization:

" Name " field 712 is arranged to the value of local variable EPE_name;

" Last Change Date " field 713 is arranged to quote as the system time known to the central processing unit 101;

The memory location that " Description Ptr " field 714 is arranged to just distribute;

" Row# " field 715 values of being arranged to 1 (because in a preferred embodiment of the invention, are managed ST under the 2D environment; Under the 3D environment, this field will be carried the line number into EP that creates or MEP definition);

" Column# " field 716 is arranged to the value of local variable EPE_size; With

By following setting " Type " field 717: attribute " META " 718 is arranged to equal the value of local variable EPE_meta and by following init attributes " REFERENCED " 719:

With also not being assigned to any other " OWN REFERENCE " (OR) prime number initialization OR son field 719a of son field 709a, 719a, 729a, 780a, 2219a, 2229a or 2240a.Various conventional arts can be used to discern prime number, are not described in further detail here.

With being worth (FR) son field 719b of 1 (one) initialization " FILIATION REFERENCE ".

With being worth (IR) son field 719c of 1 (one) initialization " INSTANCE REFERENCE ".

With (RO) son field 719d of following formula initialization " REFERENCED OBJECT ".Wherein, P gathers the set corresponding to ST:

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

With (SC) son field 719e of following formula initialization " SELECTED CHILDREN ".

Wherein, S gathers the set (" SELECTED " attribute 2242 with value of equaling in the RSTMT table 2230 " YES ") corresponding to selected object:

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#EPE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, give step 1010 with control.

In step 1010, test value to determine that local variable EPE_range is got.If find to equal " YES ", so, give step 1011 with control; Otherwise, give step 1012 with control.

In step 1011, current selected range of cells is copied to Clipboard and local variable EPE_size is arranged to equal the columns of selected scope.

In step 1012, make " Editor Space " form 315 become active sheet, with on this blank form, in fixed cell lattice address 314 (as shown in Figure 3, in a preferred embodiment of the invention, address B2) goes up the content of pasting clipbook, so that the user can see the example of EF or MEF on display device 106.

In step 1013, on display device 106, show EP editing machine dialog box 401.

Value initialization's indicia framing 404 with local variable EPE_name.Equal " NO " (correspondingly, " YES ") if find local variable EPE_mata, stain is inserted in the OptionButton 410 of top (correspondingly, bottom).

The value of local variable EPE_size is inserted text box 406.

Equal " Column# " field 716 of current record 711 if find local variable EPE_size, if or find that the attributes " REFERENCED " 719 in this record " Type " field of 711 717 have son field " REFERENCEDOBJECT " 719d (RO) that equals " NO ", enable button " Save " 412 and " Save﹠amp; Refresh " 408, so that use positioning equipment 105 in the future to this two buttons " Save " 412 and " Save﹠amp; Refresh " any click of 408 all is identified as a validity event.

Otherwise (do not find that local variable EPE_size equals " Column# " field 716 of current record 711, or find that the attributes " REFERENCED " 719 in " Type " field 717 of this same record 711 have son field " REFERENCEDOBJECT " 719d (RO) that equals " YES "), disable button " Save " 412 and " Save﹠amp; Refresh " 408, so that use positioning equipment 105 in the future to this two buttons " Save " 412 and " Save﹠amp; Refresh " any click of 408 is not identified as an incident.

In step 1014, this method is waited for the Any user action on the EP editing machine dialog box 401.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 1015, detect the user action on the EP editing machine dialog box 301.

If user action is button click " Save﹠amp; Refresh " 408, so, give step 1016 with control;

If user action is a button click " Save " 412, so, give step 1017 with control;

If user action is a button click " Save as " 411, so, give step 1018 with control;

If user action is a button click " Clear " 409, so, give step 1019 with control;

If user action is to click knob 407, so, give step 1020 with control;

If user action is to click one of two OptionButtons 410, so, give step 1021 with control;

If user action is button click " Done " 403 or close window button 402, so, give step 1025 with control.

In step 1016,, upgrade an EPT table 710 and a part of it being preserved into electronic form file by refreshing the record 711 that " Name " field 712 equals local variable EPE_name.For this purpose,

" Column# " field 716 is arranged to the value of local variable EPE_size; With

By following setting " Type " field 717: the value of attribute " META " 718 being arranged to equal local variable EPE_meta.

In addition, will be on " Editor Space " form 415 range of cells 414 of current definition of illustration EP or MEP copy to the memory location of " Description Ptr " field 714 indications.Then, give step 1022 with control.

In step 1017,, upgrade an EPT table 710 and a part of it being preserved into electronic form file by refreshing the record 711 that " Name " field 712 equals local variable EPE_name.For this purpose,

" Column# " field 716 is arranged to the value of local variable EPE_size; With

In addition, will be on " Editor Space " form 415 range of cells 414 of current definition of illustration EP or MEP copy to the memory location of " Description Ptr " field 714 indications.

Then, describe renewal local variable EPE_desc and give step 1013 with current EP as in the memory location that is recorded in " Description Ptr " field 714 indications or MEP control.

In step 1018, the value that finds in text box 405 is tested, to determine that whether this value is corresponding to effective newname.Corresponding criterion be realize relevant, as long as new recommend title with respect to be recorded in " Name " field 702,712,722,2212 and 2222 all define name be unique string, can take various forms and not depart from spirit of the present invention.If validity and uniqueness all obtain proof, so, give step 1023 with control; Otherwise, give step 1024 with control.

In step 1019, be applied to " Editor Space " form 415 with current at the undefined default property of spreadsheet environment, so that the EP or the MEP example that show are accepted these identical default propertys.Then, give step 1013 with control.

In step 1020, direction (up or down) according to positioning equipment 105 appointment on knob 407, with if the maintenance of its value positive and smaller or equal to being arranged to equal 254 the upper limit in a preferred embodiment of the invention, local variable EPE_size is added 1 (one) or subtract 1 (one).Then, give step 1013 with control.

In step 1021, upgrade local variable EPE_meta, if so that clicked bottom (correspondingly, the top) OptionButton 410, its value is become " YES " (correspondingly, " NO ").Then, give step 1013 with control.

In step 1022, send the order of ST Refresh (ST refreshes) manager, and following parameter: EPE_name, " PROFILE " and EPE_desc.Then, describe renewal local variable EPE_desc, then, give step 1013 control with current EP as in the memory location that is recorded in " Description Ptr " field 714 indications or MEP.

In step 1023, memory allocated space in primary memory 102 is so that write down the illustration range of cells of EP or MEP later on.The storage space of this distribution is and a part when the corresponding storage space of electronic form file of front opening.Then, in the EPT of a part that saves as electronic form file table 710, create new record 711 and by this new record 711 of following initialization:

" Name " field 712 is arranged in the value that finds in the text box 405 and in step 1018, obtain examining; Then, this field 712 becomes the new value of EPE_name local variable;

" Column# " field 716 is arranged to the value of local variable EPE_size; With

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#EPE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, give step 1013 with control.

In step 1024, the message informing that gives a warning so that notify the user before clicking " Save as (save as " button 411, must be specified effective unique title in text box 405.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 1013 with control.

In step 1025, close EP editing machine dialog box 401, so that it disappears from display device 106, then, from display window, remove " Editor Space " form 415, so that the original form that occurs when being used in the EP editing machine and calling replaces it.At last, initial step 1001 is given back in control, so that handle the order of any further EP editing machine.

E4.ST editing machine method

The method summary that is used in the establishment in the preferred embodiment of the present invention or upgrades ST is in the process flow diagram 1100 of Figure 11.This method can be regarded as ST editing machine process of commands.

In step 1101, this method is in its default conditions, waits for the incident of this process of startup.

In step 1102,, detect the order of ST editing machine as the result of user action.This action can be, for example:

Particular key combination on the keyboard 104;

The click of positioning equipment 105 on specific button; Or

This paper does not make further any other similar means of regulation.

In step 1103, the parameter of retrieval command.It is corresponding to there being parameter S TE_name, and this parameter can be got retention " NEW ", or with as corresponding another value of string name finding in " Name " of the record in the RSTMT table 2,230 2231 field 2232.This reference record is become local variable.

In step 1104, some local variables of initialization: local variable STE_min is arranged to default value 1 (), with local variable STE_max value of being arranged to 255.

In step 1105, test value to determine that local variable STE_name is got.If find to equal " NEW ", so, give step 1109 with control; Otherwise, give step 1106 with control.

In step 1106, search STT table 720, find that with the location its " Name " field 722 equals the record 721 of the value that local variable STE_name got.If find such record, so, give step 1108 with control; Otherwise, give step 1107 with control.

In step 1107, call exception handler, this to handle " should not take place " situation.Such operation is to realize being correlated with, and can take different forms, for example, shows the error message pop-up window on display device 106.Then, give step 1128 with control.

In step 1108,

Local variable STE_min (STE minimum) is arranged in the value that finds in " Min Element# " field 725 of the record 721 that in step 1106, finds;

Local variable STE_max (STE maximum) is arranged in the value that finds in " Max Element# " field 726 of the record 721 that in step 1106, finds.

Then, (wherein, writing down according to the ST of the STDT table 760 shown in Fig. 7 D description) is replicated in the job buffer of also deferring to identical STDT table 760 in the memory location of " Description Ptr " field 724 indications of the record 721 that will find in step 1106.Then, this structure is used for make up on the clipbook in primary memory 102 the electronic form unit grid scope that illustration is replicated in the ST definition of job buffer.This structure is by realizing in the clipbook in the primary memory 102 that a series of orderly range of cells are packed into, and each of these range of cells is deferred to successively and defined since first couple 761 to the last a pair of 763 the every couple of EF and the corresponding EF of EP title (row 765) and EP (row 764).Then, give step 1110 with control.

In step 1109, according to the name character string of taking " New XX " form in a preferred embodiment of the invention, determine the newname of the new ST of establishment, wherein, XX corresponding to for defined in the past and be recorded in form EFT 700, EPT 710, STT 720, RET 2210 and RSST 2220 separately write down all titles in " Name " field 702,712,722,2212 and 2222 that finds in 701,711,721,2211 and 2221 separately, guarantee the counting of title uniqueness.As long as guarantee the new uniqueness of creating title, can use any other similar traditional means instead and non-migration spirit of the present invention.Then, newname is recorded among the local variable STE_name (STE title).Then, memory allocated space in primary memory 102 is so that write down the illustration range of cells of new ST later on.The storage space of this distribution be with when the part of the corresponding storage space of electronic form file of front opening with defer to STDT table 760 shown in Fig. 7 D.Then, in STT table 720, create new record 721 and by this new record 721 of following initialization:

" Name " field 722 is arranged to the value of local variable STE_name;

" Last Change Date " field 723 is arranged to quote as the system time known to the central processing unit 101;

The memory location that " Description Ptr " field 724 is arranged to just distribute;

" Min Element# " field 725 is arranged to the value of local variable STE_min;

" Max Element# " field 726 is arranged to the value of local variable STE_max;

By following setting " Type " field 727: attribute " META " 728 is arranged to equal " NO " and by following init attributes " REFERENCED " 729:

With also not being assigned to any other " OWN REFERENCE " (OR) prime number initialization OR son field 729a of son field 709a, 719a, 729a, 780a, 2219a, 2229a or 2240a.Various conventional arts can be used to discern prime number, are not described in further detail here.

According to (FR) son field 729b of following formula initialization " FILIATION REFERENCE ", wherein, according to the structure that is recorded in " Description Ptr " field 724, the F set is corresponding to the set of EF, the MEF, EP and the MEP that constitute new ST:

FR＝П _i∈FOR _i×LCM({FR _i}) _i∈F

With being worth (IR) son field 729c of 1 (one) initialization " INSTANCE REFERENCE ".

With (RO) son field 729d of following formula initialization " REFERENCED OBJECT ".

Wherein, P gathers the set corresponding to RE and RME:

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

With (SC) son field 729e of following formula initialization " SELECTED CHILDREN ".

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#STE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, in primary memory 102, share out the work buffer zone and use with give tacit consent to EF and the acquiescence EP a pair of 762 corresponding acquiescence ST the initial work buffer zone is described.Then, this acquiescence ST is described by the electronic form unit grid scope that makes up the new ST of illustration on the clipbook that is used in primary memory 102.This structure is as realizing the end explanation of step 1108.Then, give step 1110 with control.

In step 1110, make " Editor Space " form 515 become active sheet and forbid that conventional row inserts and deletion in, this form is changed into the write-protect pattern.Then, the upper left cell of selected cell lattice scope 514.Then, will insert among the local variable STE_format (STE form) with the corresponding EF of row at current selected cell place in the range of cells 514 or the title of MEF.At last, will insert among the local variable STE_profile (STE summary) with the corresponding EP of row at current selected cell place in the range of cells 514 or the title of MEP.

In step 1111, on display device 106, show ST editing machine dialog box 501.

Value initialization's indicia framing 504 with local variable STE_name.

The value of local variable STE_min is inserted text box 506.

The value of local variable STE_max is inserted text box 509.

The value of local variable STE_format is inserted combo box 511.

The value of local variable STE_profile is inserted combo box 510.

Then, according to the description updating block lattice scope 514 that is recorded in the storer clipbook: on this blank form, in fixed cell lattice address 514 (as shown in Figure 5, in a preferred embodiment of the invention, address B2) goes up the content of pasting clipbook, so that the user can see the example of ST in window 500 on display device 106.Then, test with check whether contributive all EF of range of cells 514 illustrated ST definition, EP, MEF are had the identical field of number with MEP.If situation is like this, so, enable two buttons " Save " 513 and " Save as " 512, so that will become a validity event to the click recognition of these two buttons " Save " 513 and one of " Save as " 512 with positioning equipment 105.Otherwise, forbid two buttons " Save " 513 and " Save as " 512, so that will not become a validity event to the click recognition of these two buttons " Save " 513 and one of " Save as " 512 with positioning equipment 105.

In step 1112, this method is waited for the Any user action on the ST editing machine dialog box 501.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 1113, detect the user action on the ST editing machine dialog box 501.

If user action is a button click " Save " 513, so, give step 1116 with control;

If user action is a button click " Save as " 512, so, give step 1119 with control;

If user action is a button click " Add (interpolation) " 517, so, give step 1124 with control;

If user action is a button click " Delete " 518, so, give step 1125 with control;

If user action is button click " Up " 519 or button " Down " 520, so, give step 1126 with control;

If user action is to upgrade combo box 511, so, give step 1114 with control;

If user action is to upgrade combo box 510, so, give step 1115 with control;

If user action is to click knob 507, so, give step 1122 with control;

If user action is to click knob 508, so, give step 1123 with control;

If user action is button click " Done " 503 or close window button 502, so, give step 1128 with control.

In step 1114, by being used in EF or the illustrated element of current selected cell in MEF replacement and the range of cells 514 or corresponding preceding EF of element or the MEF regulation that finds in the text box 511, renewal ST description in job buffer.Then, also local variable STE_format is arranged to equal the title that in text box 511, finds.Then, give step 1111 with control.

In step 1115, by being used in EP or the illustrated element of current selected cell in MEP replacement and the range of cells 514 or corresponding preceding EP of element or the MEP regulation that finds in the text box 511, renewal ST description in job buffer.Then, also local variable STE_profile is arranged to equal the title that in text box 511, finds.Then, give step 1111 with control.

In step 1116, test with the ST of check and whether quoted by existing RE or RME when pre-editing, whether changed into STI by example.For this purpose, consider that " Name " field 722 in the STT table 720 equals " REFERENCED " attribute 729 in " Type " field 727 of record 721 of local variable STE_name." if REFERENCED OBJECT " (RO) value of son field 729d equal " NO " and if " INSTANCE REFERENCE " (IR) value of son field 729c equal 1 (one), so, give step 1117 with control; Otherwise, give step 1118 with control.

In step 1117,, upgrade STT table 720 by refreshing the record 721 that " Name " field 722 equals local variable STE_name.For this purpose,

" Min Element# " field 725 is arranged to the value of local variable STE_min; With

" Max Element# " field 726 is arranged to the value of local variable STE_max.

The current description of will be shown in range of cells 514, as in being recorded in job buffer and deferring to the ST of STDT table 760 copies on the memory location of " Description Ptr " field 724 indications.

Depend on the defined formula of set of EF, MEF, EP and the MEP of the STDT table 760 that belongs to " Description Ptr " field 724 indications by means of it, upgrade " FILIATION REFERENCE " (FR) " Type " field 727 of son field 729b that is updated to " REFERENCED " attribute 729 automatically.

For each the EF title or the MEF title that in the row 765 of this STDT table 760, find, owing to recomputated (RO) 709d (in " REFERENCED " attribute 709) of son field " REFERENCEDOBJECT " according to its defined formula, in the respective record 701 of " Name " field 702 and this element or MEF name-matches, upgraded EFT table 700 automatically.

For each the EP title or the MEP title that in the row 764 of this STDT table 760, find, owing to recomputated (RO) 719d (in " REFERENCED " attribute 719) of son field " REFERENCEDOBJECT " according to its defined formula, in the respective record 711 of " Name " field 712 and this element or MEP name-matches, upgraded EPT table 710 automatically.Then, give step 1111 with control.

In step 1118, the message informing that gives a warning is so that notify ST that the user edits by RE or RME quotes or changed into existing STI by example.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.Then, remind the user to cancel current " Save " and operate or proceed " Save " operation.This can finish by on display device 106 reminder message being presented in the pop-up window usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user passes through traditional means, for example, click " Cancel " or " Continue " button that appears in the reminder message pop-up window with positioning equipment 105, or any other the similar means that do not depart from spirit of the present invention have made his selection, if electrical form user's decision is the cancellation operation, so, give step 1111 with control, perhaps, if electrical form user's decision is to proceed operation, so, give step 1117 with control.

In step 1119, the value that finds in text box 505 is tested, to determine that whether it is corresponding to effective newname.Corresponding criterion be realize relevant, as long as new recommend title with respect to be recorded in " Name " field 702,712,722,2212 and 2222 all define name be unique string, can take various forms and not depart from spirit of the present invention.If validity and uniqueness all obtain proof, so, give step 1120 with control; Otherwise, give step 1121 with control.

In step 1120, memory allocated space in primary memory 102 is so that write down the descriptor of ST later on.The storage space of this distribution is and a part when the corresponding storage space of electronic form file of front opening.Then, in STT table 720, create new record 721 and by this new record 721 of following initialization:

" Name " field 722 is arranged in the value that finds in the text box 505 and in step 1119, obtain examining; Then, this field 722 becomes the new value of STE_name local variable;

" Min Element# " field 725 is arranged to the value of local variable STE_min;

" Max Element# " field 726 is arranged to the value of local variable STE_max;

FR＝П _i∈FOR _i×LCM({FR _i}) _i∈F

Wherein, P gathers the set corresponding to RE and RME:

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#STE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

For each the EP title or the MEP title that in the row 764 of this STDT table 760, find, owing to recomputated (RO) 719d (in " REFERENCED " attribute 719) of son field " REFERENCEDOBJECT " according to its defined formula, in the respective record 711 of " Name " field 712 and this element or MEP name-matches, upgraded EPT table 710 automatically.

Then, give step 1111 with control.

In step 1121, the message informing that gives a warning so that notify the user before clicking " Save as " button 512, must be specified effectively unique title in text box 505.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 1111 with control.

In step 1122, direction (up or down) according to positioning equipment 105 appointment on knob 507, with if the maintenance of its value positive and smaller or equal to being arranged to equal 254 the upper limit and the value shown in text box 509 in a preferred embodiment of the invention, local variable STE_min is added 1 (one) or subtract 1 (one).Then, give step 1111 with control.

In step 1123, direction (up or down) according to positioning equipment 105 appointment on knob 508, its value maintenance is positive with needing only, greater than the value shown in text box 506, with smaller or equal to being arranged to equal 254 the upper limit in a preferred embodiment of the invention, local variable STE_max is added 1 (one) or subtract 1 (one).Then, give step 1111 with control.

In step 1124, in the range of cells 514 of illustration editor's ST, inserted newline above the residing row before the in the end selected cell.

Then, be positioned at leftmost cell lattice on the newline in the selected cell lattice scope 514.

Then, in job buffer, by introducing, give a pair of acquiescence MEF and acquiescence MEP a pair of (MEF 765 by also being assigned to local variable STE_format and STE_profile, silent approvement respectively as other yuan element, MEP 764) the Singapore dollar element described, upgrade the ST definition.The current description of in addition, will be shown in range of cells 514, as in being recorded in job buffer and deferring to the ST of STDT table 760 copies on the memory location of " Deseription Ptr " field 724 indications.Then, give step 1111 with control.

In step 1125, from range of cells 514, remove the row that comprises selected cell.Then, select to be positioned at range of cells 514 and represent leftmost cell lattice on the row of element of the ST that is defined in editor.Then, by removing by a pair of (MEF, the deletion of MEP) describing unit element, renewal ST definition.The current description of in addition, will be shown in range of cells 514, as in being recorded in job buffer and deferring to the ST of STDT table 760 copies on the memory location of " Description Ptr " field 724 indications.Then, give step 1127 with control.

In step 1126, if the electrical form user has clicked " Up " button 519 or " Down " button 520 with positioning equipment 105, and, if this current cell that moves the range of cells 514 that does not move away from illustration ST moves up or down the current cell in " Editor Space " form 515 respectively.

In step 1127, with local variable STE_format and STE_profile be arranged to respectively to equal with range of cells 514 in current selected cell shown in element or the title of corresponding EF of element or MEF and the title of EP or MEP.Then, give step 1111 with control.

In step 1128, close ST editing machine dialog box 501, so that it disappears from display device 106, then, from display window, remove " Editor Space " form 515, so that the original form that occurs when being used in the EP editing machine and calling replaces it.Enable all devices of when showing " Editor Space " form 515, forbidding now once more.At last, initial step 1101 is given back in control, so that handle the order of any further ST editing machine.

E5.RST editing machine method

The method summary that is used in the establishment in the preferred embodiment of the present invention or upgrades RST is in the process flow diagram 1230 of Figure 12.This method can be regarded as RST editing machine process of commands.

In step 1231, this method is in its default conditions, waits for the incident of this process of startup.

In step 1232,, detect the order of RST editing machine as the result of user action.This action can be, for example:

Particular key combination on the keyboard 104;

The click of positioning equipment 105 on specific button; Or

This paper does not make further any other similar means of regulation.

In step 1233, the parameter of retrieval command.It is corresponding to there being parameters R STE_name (RSTE title), and this parameter can be got retention " NEW (newly) ", or with as corresponding another value of string name finding in " Name " of the record in the RSTMT table 2,230 2231 field 2232.This reference record is become local variable.

In step 1234, some local variables of initialization: with local variable RSTE_min (RSTE minimum) value of being arranged to default value 1 (), with local variable RSTE_max (RSTE maximum) value of being arranged to 16.

In step 1235, test value to determine that local variable RSTE_name is got.If find to equal " NEW ", so, give step 1239 with control; Otherwise, give step 1236 with control.

In step 1236, search RSTT table 2220, find that with the location its " Name " field 2222 equals the record 2221 of the value that local variable RSTE_name got.If find such record, so, give step 1238 with control; Otherwise, give step 1237 with control.

In step 1237, call exception handler, this to handle " should not take place " situation.Such operation is to realize being correlated with, and can take different forms, for example, shows the error message pop-up window on display device 106.Then, give initial step 1231, so that handle the order of any further RST editing machine with control.

In step 1238,

Local variable RSTE_min is arranged in the value that finds in " Min Element# " field 2225 of the record 2221 that in step 1236, finds;

Local variable RSTE_max is arranged in the value that finds in " Max Element# " field 2226 of the record 2221 that in step 1236, finds.

Then, (wherein, writing down according to the RST of the RSTDT table 2250 shown in Figure 17 D description) is replicated in the job buffer of also deferring to identical RSTDT table 2250 in the memory location of " Description Ptr " field 2224 indications of the record 2221 that will find in step 1236.Then, this structure is used for making up on the clipbook in primary memory 102 the electronic form unit grid scope that illustration is replicated in the RST definition of job buffer, and each cell is successively with to the last one 2253 RE or RME title is corresponding from first title 2251 beginnings.Then, give step 1240 with control.

In step 1239, according to the name character string of taking " New XX " form in a preferred embodiment of the invention, determine the newname of the new RST of establishment, wherein, XX corresponding to for defined in the past and be recorded in form EFT 700, EPT 710, STT 720, RET 2210 and RSST 2220 separately write down all titles in " Name " field 702,712,722,2212 and 2222 that finds in 701,711,721,2211 and 2221 separately, guarantee the counting of title uniqueness.As long as guarantee the new uniqueness of creating title, can use any other similar traditional means instead and non-migration spirit of the present invention.Then, newname is recorded among the local variable RSTE_name.Then, memory allocated space in primary memory 102 is so that write down the illustration range of cells of new RST later on.The storage space of this distribution be with when the part of the corresponding storage space of electronic form file of front opening with defer to RSTDT table 2250 shown in Figure 17 D.Then, in RSTT table 2220, create new record 2221 and by this new record 2221 of following initialization:

" Name " field 2222 is arranged to the value of local variable RSTE_name;

" Last Change Date " field 2223 is arranged to quote as the system time known to the central processing unit 101;

The memory location that " Description Ptr " field 2224 is arranged to just distribute;

" Min Element# " field 2225 is arranged to the value of local variable RSTE_min;

" Max Element# " field 2226 is arranged to the value of local variable RSTE_max;

By following setting " Type " field 2227: attribute " META " 2228 is arranged to equal " NO " and by following init attributes " REFERENCED " 2229:

With also not being assigned to any other " OWN REFERENCE " (OR) prime number initialization OR son field 2229a of son field 709a, 719a, 729a, 780a, 2219a, 2229a or 2240a.Various conventional arts can be used to discern prime number, are not described in further detail here.

According to (FR) son field 2229b of following formula initialization " FILIATION REFERENCE ", wherein, according to the structure that is recorded in " Description Ptr " field 2224, the F set is corresponding to RE that constitutes new RST and the set of RME:

FR＝П _i∈FOR _i×LCM({FR _i}) _i∈F

With being worth (IR) son field 2229c of 1 (one) initialization " INSTANCE REFERENCE ".

With being worth (RO) son field 2229d of " NO " initialization " REFERENCED OBJECT ".

With (SC) son field 2229e of following formula initialization " SELECTED CHILDREN ".

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#RSTE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, in primary memory 102, share out the work buffer zone and use and give tacit consent to RE 2252 corresponding acquiescence RST and describe the initial work buffer zone.Then, this acquiescence RST is described by the electronic form unit grid scope that makes up the new RST of illustration on the clipbook that is used in primary memory 102.This structure is as realizing the end explanation of step 1238.Then, give step 1240 with control.

In step 1240, make " Editor Space " form 615 become active sheet and forbid that conventional row inserts and deletion in, this form is changed into the write-protect pattern.Then, the upper left cell of selected cell lattice scope 614.Then, will insert among the local variable RE_name (RE title) with the title of the corresponding RE of row at current selected cell place in the range of cells 614.

In step 1241, on display device 106, show RST editing machine dialog box 601.

Value initialization's indicia framing 604 with local variable RSTE_name.

The value of local variable RSTE_min is inserted text box 606.

The value of local variable RSTE_max is inserted text box 609.

The value of local variable RE_name is inserted combo box 610.

Then, according to the description updating block lattice scope 614 that is recorded in the storer clipbook: on this blank form, in fixed cell lattice address 614 (as shown in Figure 6, in a preferred embodiment of the invention, address B2) goes up the content of pasting clipbook, so that the user can see the example of RST in window 611 on display device 106.Then, test with check whether contributive all RE of range of cells 614 illustrated RST definition are had the identical field of number with RME.If situation is like this, so, enable two buttons " Save " 613 and " Save as " 612, so that will become a validity event to the click recognition of one of these two buttons with positioning equipment 105.Otherwise, forbid two buttons " Save " 613 and " Save as " 612, so that will not become a validity event to the click recognition of one of these two buttons with positioning equipment 105.

In step 1242, this method is waited for the Any user action on the RST editing machine dialog box 601.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 1243, detect the user action on the RST editing machine dialog box 601.

If user action is a button click " Save " 613, so, give step 1246 with control;

If user action is a button click " Save as " 612, so, give step 1249 with control;

If user action is a button click " Add " 617, so, give step 1254 with control;

If user action is a button click " Delete " 618, so, give step 1255 with control;

If user action is button click " Up " 619 or button " Down " 616, so, give step 1256 with control;

If user action is to upgrade combo box 610, so, give step 1244 with control;

If user action is to click knob 607, so, give step 1252 with control;

If user action is to click knob 608, so, give step 1253 with control;

If user action is button click " Done " 603 or close window button 602, so, give step 1258 with control.

In step 1244,, in job buffer, upgrade the RST description by being used in RE or the illustrated RE of current selected cell in RME replacement and the range of cells 614 or corresponding preceding RE of RME or the RME title that finds in the combo box 610.Then, also local variable RE_name is arranged to equal the title that in combo box 610, finds.Then, give step 1241 with control.

In step 1246, test with the RST of check and whether quoted by existing RSTI when pre-editing.For this purpose, consider that " Name " field 2222 in the RSTT table 2220 equals the value of " REFERENCED " attribute 2229 in " Type " field 2227 of record 2221 of local variable RSTE_name.If " INSTANCE REFERENCE " (IR) value of son field 2229c equals 1 (one), so, give step 1247 with control; Otherwise, give step 1248 with control.

In step 1247,, upgrade RSTT table 2220 by refreshing the record 2221 that " Name " field 2222 equals local variable RSTE_name.For this purpose,

" Max Element# " field 2226 is arranged to the value of local variable RSTE_max.

The current description of will be shown in range of cells 614, as in being recorded in job buffer and deferring to the RST of RSTDT table 2250 copies on the memory location of " Description Ptr " field 2224 indications.

Depend on the defined formula of the set of the RE of the RSTDT table 2250 that belongs to " Description Ptr " field 2224 indications and RME by means of it, upgrade " FILIATION REFERENCE " (FR) " Type " field 2227 of son field 2229b that is updated to " REFERENCED " attribute 2229 automatically.

For each the RE title or the RME title that in the row 2254 of this RSTDT table 2250, find, owing to recomputated (RO) 2219d (in " REFERENCED " attribute 2219) of son field " REFERENCED OBJECT " according to its defined formula, in the respective record 2211 of " Name " field 2212 and this RE or RME name-matches, upgraded RET table 2210 automatically.

In step 1248, the message informing that gives a warning is so that the RST that notifies the user to edit is changed into RSTI by example.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.Then, remind the user to cancel current " Save " and operate or proceed " Save " operation.This can finish by on display device 106 reminder message being presented in the pop-up window usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user passes through traditional means, for example, click " Cancel (cancellation) " or " Continue (the continuations) " button that appears in the reminder message pop-up window with positioning equipment 105, or any other the similar means that do not depart from spirit of the present invention have made his selection, if electrical form user's decision is to cancel operating, so, give step 1241 with control, perhaps, if electrical form user's decision is to proceed operation, so, give step 1247 with control.

In step 1249, the value that finds in text box 605 is tested, to determine that whether it is corresponding to effective newname.Corresponding criterion be realize relevant, as long as new recommend title with respect to be recorded in " Name " field 702,712,722,2212 and 2222 all define name be unique string, can take various forms and not depart from spirit of the present invention.If validity and uniqueness all obtain proof, so, give step 1250 with control; Otherwise, give step 1251 with control.

In step 1250, memory allocated space in primary memory 102 is so that write down the descriptor of RST later on.The storage space of this distribution is and a part when the corresponding storage space of electronic form file of front opening.Then, in RSTT table 2220, create new record 2221 and by this new record 2221 of following initialization:

" Name " field 2222 is arranged in the value that finds in the text box 605 and in step 1249, obtain examining; Then, this field 2222 becomes the new value of RSTE_name local variable;

FR＝П _i∈FOR _i×LCM({FR _i}) _i∈F

With (SC) son field 2229e of following formula initialization " SELECTED CHILDREN ".Wherein, S gathers the set (" SELECTED " attribute 2242 with value of equaling in the RSTMT table 2230 " YES ") corresponding to selected object:

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#RSTE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

In step 1251, the message informing that gives a warning so that notify the user before clicking " Save as " button 612, must be specified effectively unique title in text box 605.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 1241 with control.

In step 1252, direction (up or down) according to positioning equipment 105 appointment on knob 607, with if the maintenance of its value positive and smaller or equal to being arranged to equal 254 the upper limit and the value shown in text box 609 in a preferred embodiment of the invention, local variable RSTE_min is added 1 (one) or subtract 1 (one).Then, give step 1241 with control.

In step 1253, direction (up or down) according to positioning equipment 105 appointment on knob 608, its value maintenance is positive with needing only, greater than the value shown in text box 606, with smaller or equal to being arranged to equal 254 the upper limit in a preferred embodiment of the invention, local variable RSTE_max is added 1 (one) or subtract 1 (one).Then, give step 1241 with control.

In step 1254, in the range of cells 614 of illustration editor's RST, inserted newline above the residing row before the in the end selected cell.Then, be positioned at leftmost cell lattice on the newline in the selected cell lattice scope 614.Then, in job buffer,,, upgrade the RST definition by the new RME that the title that also is assigned to local variable RE_name is described by introducing as other yuan element.The current description of in addition, will be shown in range of cells 614, as in being recorded in job buffer and deferring to the RST of RSTDT table 2250 copies on the memory location of " Description Ptr " field 2224 indications.Then, give step 1241 with control.

In step 1255, from range of cells 614, remove the row that comprises selected cell, so that select next RE or first element.Then, by removing RME, upgrade the RST definition by the deletion of its title identification.The current description of in addition, will be shown in range of cells 614, as in being recorded in job buffer and deferring to the RST of RSTDT table 2250 copies on the memory location of " Description Ptr " field 2224 indications.Then, give step 1257 with control.

In step 1256, if the electrical form user has clicked " Up " button 619 or " Down " button 616 with positioning equipment 105, and, if this current cell that moves the range of cells 614 that does not move away from illustration RST moves up or down the current cell in " Editor Space " form 615 respectively.

In step 1257, with local variable RE_name be arranged to equal with range of cells 614 in the RE that current selected cell identified or the title of corresponding RE of RME or RME.Then, give step 1241 with control.

In step 1258, close RST editing machine dialog box 601, so that it disappears from display device 106, then, from display window, remove " Editor Space " form 615, so that the original form that occurs when being used in the RST editing machine and calling replaces it.Enable all devices of when showing " Editor Space " form 615, forbidding now once more.At last, initial step 1231 is given back in control, so that handle the order of any further RST editing machine.

E6.ST instantiation device method

Be used in the method summary of STI of ST that establishment in the preferred embodiment of the present invention defers to definition in the process flow diagram 1400 of Figure 14 A and 14B, wherein, the latter is corresponding to CreateSTI (creating STI) routine.This method can be regarded as ST instantiation device process of commands.

In step 1401, this method is in its default conditions, waits for the incident of this process of startup.

In step 1402,, detect the order of ST instantiation device as the result of user action.This action can be, for example, the particular key combination on the keyboard 104, the click of positioning equipment 105 on specific button, or this paper does not make further any other similar means of regulation.

In step 1403, test to check current selected cell whether to be included in the form that has RSTI.This test may be finished corresponding to any record 2261 of the form identical with current selected cell to discern its Address (address) field 2262 by analyzing RSTIT table 2260.If situation is like this, so, give step 1404 with control; Otherwise, give step 1405 with control.

In step 1404, the message informing that gives a warning is so that notify the user can not create STI separately on the form that has RSTI.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 1401 with control.

In step 1405, retrieval command parameter S T_name at first: the title of the ST that it is deferred to corresponding to the STI that will create.This parameter S T_name is used to analyze STT table 720, so that find out the record 721 of its " Name " field 722 and parameter S T_name coupling.In case find this record 721, its field " Min Element# " 725 and " Max Element# " 726 be stored as local variable STI_min and STI_max respectively.Then, its field " Description Ptr " 724 is used for according to the STDT table of quoting 760, determines each element that is defined in the number of the element in the ST and is defined in ST or the number of the cell in the element member.First number is stored as local variable STI_meta and second number is stored as local variable STI_width 1325 (representing the columns of following STI).Then, with another local variable STI_element of value initialization (element) that STI_min got.Then, with default value " YES " initialization another local variable STI_critical (STI is key).Then, with total another local variable of the columns initialization STI_sheet_width (STI worksheet width) 1321 in the active sheet 1320.Then, with total another local variable of the line number initialization STI_sheet_height (STI worksheet height) 1321 in the active sheet 1320.Then, with value OVERLAY (covering) initialization another local variable STI_mode (STI pattern).

In step 1406, at first make up or upgrade some other local variables.At first use the position of local variable STI_offset_width (STI offset width) 1323 and the current selected cell 1327 of STI_offset_height (STI offset height) 1324 expressions, local variable STI_offset_width 1323 and STI_offset_height 1324 correspond respectively to the upper left cell of active sheet 1320 and columns and the line number between the current selected cell 1327.Then, be used as the line number of the following STI of local variable STI_height (STI height) 1326 expressions of local variable STI_meta (STI unit) and STI_element sum calculating.Secondly, determine a few thing range of cells by the address of assessing them.At first will be defined as current selected cell 1327 equals STI_height 1326 and STI_width (STI width) 1325 respectively as upper left cell and line number and columns range of cells with the corresponding range of cells STI_range of following STI (STI scope) 1328.Then, range of cells STI_horizontal_flushed_range (STI horizontal coverage) 1330 is defined as share identical row and occupies the range of cells of 1325 right columns of STI_width of active sheet 1320 with STI_range1328.

Then, range of cells STI_horizontal_kept_range (the horizontal hold in range of STI) 1329 is defined as share identical row and occupies the range of cells of the row between those two STI_range 1328 and STI_horizontal_flushed_range 1330 with STI_range 1328.Then, range of cells STI_vertical_flushed_range (STI vertical coverage) 1332 is defined as share identical row and occupies 1326 of the STI_height of active sheet 1320 with STI_range 1328 at the bottom of the range of cells of row.Then, range of cells STI_vertical_kept_range (the vertical hold in range of STI) 1331 is defined as share identical row and occupies the range of cells of the row between those two STI_range1328 and STI_vertical_flushed_range 1332 with STI_range 1328.

In step 1407, carry out two kinds of summations to check following STI whether lucky within the scope of active sheet 1320.

Greater than local variable STI_sheet_width 1321, so, local variable STI_too_wide (STI is too wide) is arranged to " YES " if find local variable STI_offset_width 1323 and STI_width 1325 sums; Otherwise, it is arranged to " NO ".

Greater than local variable STI_sheet_height 1322, so, local variable STI_too_high (STI is too high) is arranged to " YES " if find local variable STI_offset_height 1324 and STI_height 1326 sums; Otherwise, it is arranged to " NO ".

In step 1408, according to five kinds may instantiation patterns, carry out several tests with the establishment of assessing following STI to any potential impact that has had STI or data.These test requests are analyzed STIT table 750 and are visited each record 751 to grasp each address that has defined STI (" Address " field 752) and importance (" Critical " field 755).Whether two given range of cells of these testing evaluations overlap (mean in first module lattice scope and to exist at least one cell that belongs to second range of cells and at least one not to belong to the cell of second range of cells) or whether the first given range of cells is included in the second given range of cells and (means that each cell that belongs to first module lattice scope also belongs to second range of cells).Different traditional range comparison techniques can be used for that scope of assessment is overlapped or scope comprises, this does not depart from spirit of the present invention; In a preferred embodiment of the invention they will not described.

At first, research OVERLAY (covering) instantiation pattern.

If exist at least one " Critical " field 755 value " YES " and with range of cells STI_range 1328 partly overlapping existing STI, so, local test variable STI_overlay_critical (STI cover key) value " YES "; Otherwise, local test variable STI_overlay_critical value " NO ".

If exist at least one " Critical " field 755 value " NO " and with range of cells STI_range 1328 partly overlapping existing STI, so, local test variable STI_overlay_other (STI covers other) value " YES "; Otherwise, local test variable STI_overlay_other value " NO ".

If all cells in the range of cells STI_range 1328 all are empty (not comprising data), so, local test variable STI_overlay_data (STI cover data) value " NO "; Otherwise, local test variable STI_overlay_data value " YES ".

Secondly, research HORIZONTAL_INSERT (level insertion) instantiation pattern.

If have at least one " Critical " field 755 value " YES " and overlap with the range of cells of forming by the whole row at current selected cell 1327 places or overlap or be included in existing STI in the range of cells that constitutes by bottommost STI_height1326 row with the range of cells that constitutes by 1326 row of bottommost STI_height, so, local test variable STIhorizontal_critical (the STI level is key) value " YES "; Otherwise, local test variable STI_horizontal_critical value " NO ".

If have at least one " Critical " field 755 value " NO " and overlap with the range of cells of forming by the whole row at current selected cell 1327 places or overlap or be included in existing STI in the range of cells that constitutes by bottommost STI_height1326 row with the range of cells that constitutes by 1326 row of bottommost STI_height, so, local test variable STIhorizontal_other (STI level other) value " YES "; Otherwise, local test variable STI_horizontal_other value " NO ".

If all cells in the range of cells that is made of 1326 row of bottommost STI_height all are empty (not comprising data), so, local test variable STI_horizontal_data (STI horizontal data) value " NO "; Otherwise, local test variable STI_horizontal_data value " YES ".

The 3rd, research HORIZONTAL_INSERT_BY_RANGE (inserting) instantiation pattern according to the scope level.

If exist at least one " Critical " field 755 value " YES " and with and put that range of cells that two range of cells STI_range 1328 and STI_vertical_kept_range 1331 constitute is overlapped or overlap with range of cells STI_vertical_flushed_range 1332 or be included in existing STI in the range of cells STI_vertical_flushed_range 1332, so, local test variable STI_horizontal_range_critical (the STI horizontal extent is key) value " YES "; Otherwise, local test variable STI_horizontal_range_critical value " NO ".

If exist at least one " Critical " field 755 value " NO " and with and put that range of cells that two range of cells STI_range 1328 and STI_vertical_kept_range 1331 constitute is overlapped or overlap with range of cells STI_vertical_flushed_range 1332 or be included in existing STI in the range of cells STI_vertical_flushed_range 1332, so, local test variable STI_horizontal_range_other (STI horizontal extent other) value " YES "; Otherwise, local test variable STI_horizontal_range_other value " NO ".

If all cells in the range of cells STI_vertical_flushed_range 1332 all are empty (not comprising data), so, local test variable STI_horizontal_range_data value " NO "; Otherwise, local test variable STI_horizontal_range_data value " YES ".

The 4th, research VERTICAL_INSERT (the vertical insertion) instantiation pattern.

If have at least one " Critical " field 755 value " YES " and overlap with the range of cells of forming by the whole row at current selected cell 1327 places or overlap or be included in existing STI in the range of cells that constitutes by rightmost side STI_width1325 row with the range of cells that constitutes by 1325 row of rightmost side STI_width, so, local test variable STI_vertical_critical (STI is vertically key) value " YES "; Otherwise, local test variable STI_vertical_critical value " NO ".

If exist at least one " Critical " field 755 value " NO " and with overlap by all range of cells of forming of row at current selected cell 1327 places or overlap or be included in the existing STI that is listed as in the range of cells that constitutes by rightmost side STI_width1325 with the range of cells that constitutes by 1325 row of rightmost side STI_width, so, local test variable STI_vertical_other (STI vertical other) value " YES "; Otherwise, local test variable STI_vertical_other value " NO ".

If all cells in the range of cells that is made of 1325 row of rightmost side STI_width all are empty (not comprising data), so, local test variable STI_vertical_data (STI vertical data) value " NO "; Otherwise, local test variable STI_vertical_data value " YES ".

The 5th, research VERTICAL_INSERT_BY_RANGE (vertically inserting) instantiation pattern according to scope.

If exist at least one " Critical " field 755 value " YES " and with and put that range of cells that two range of cells STI_range 1328 and STI_horizontal_kept_range 1329 constitute is overlapped or overlap with range of cells STI_horizontal_flushed_range 1330 or be included in existing STI in the range of cells STI_horizontal_flushed_range 1330, so, local test variable STI_vertical_range_critical (the STI vertical range is key) value " YES "; Otherwise, local test variable STI_vertical_range_critical value " NO ".

If exist at least one " Critical " field 755 value " NO " and with and put that range of cells that two range of cells STI_range 1328 and STI_horizontal_kept_range 1329 constitute is overlapped or overlap with range of cells STI_horizontal_flushed_range 1330 or be included in existing STI in the range of cells STI_horizontal_flushed_range 1330, so, local test variable STI_vertical_range_other (STI vertical range other) value " YES "; Otherwise, local test variable STI_vertical_range_other value " NO ".

If all cells in the range of cells STI_horizontal_flushed_range 1330 all are empty (not comprising data), so, local test variable STI_vertical_range_data (STI vertical range data) value " NO "; Otherwise, local test variable STI_vertical_range_data value " YES ".

In step 1409, on display device 106, show ST instantiation device dialog box 1300.If local variable STI_critical value " YES ", " Critical " check box 1314 shows check mark; Otherwise (value " NO (denying) "), Critical " the blank demonstration of check box 1314 maintenances.With local variable ST_name initialization tag frame 1315.The value of local variable STI_element is inserted text box 1312.In the following order from left to right with the value of following local variable, begin to insert line by line 15 indicia framing 1304:STI_overlay_critical from top line, STI_overlay_other, STI_overlay_data, STI_hori-zontal_critical, STI_horizontal_other, STI_horizontal_data, STI_ho-rizontal_range_citical, STI_horizontal_range_other, STI_horizontal_range_data, STI_vertical_critical, STI_vertical_other, STI_vertical_data, STI_vertical_range_citical, STI_vertical_range_other, and STI_vertical_range_data.

Then, if local variable STI_mode gets analog value OVERLAY, HORIZONTAL_INSERT, HORIZONTAL_INSERT_BY_RANGE, VERTICAL_INSERT or VERTICAL_INSERT_BY_RANGE, so, OptionButton " Overlay " 1309, " Horizontal Insert " 1308, " Horizontal Insert by Range " 1307, " Vertical Insert " 1306 or " Vertical Insert by Range " 1305 show stain alone.At last, in case one of following local variable value " YES (being) ": STI_too_wide, STI_too_high, STI_overlay_critical (only considering whether local variable STI_mode equals OVERLAY), STI_horizontal_critical (only considering whether local variable STI_mode equals HORIZONTAL_INSERT), STI_vertical_critical (only considering whether local variable STI_mode equals VERTICAL_INSERT), STI_horizontal_range_critical (only considering whether local variable STI_mode equals HORIZONTAL_INSERT_BY_RANGE), and STI_vertical_range_critical (only considering whether local variable STI_mode equals VERTICAL_INSERT_BY_RANGE), forbidding " Create (establishment) " button 1303; Otherwise, enable " Create " button 1303.

In step 1410, this method is waited on the ST instantiation device dialog box 1300 or the Any user action of any change of relevant current selected cell.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 1411, detect on the ST instantiation device dialog box 1300 or the user action of the change of relevant current selected cell.

If user action is to click " Create " button 1303, so, give step 1416 with control;

If user action is the top of clicking knob 1313, so, give step 1415 with control;

If user action is the bottom of clicking knob 1313, so, give step 1414 with control;

If user action is to click " Critical (key) " button 1314, so, give step 1413 with control;

If user action is one of

click option button

1309,1308,1307,1306 and 1305, so, give step 1412 with control;

If user action is to click " Cancel " button 1302 or close window button 1301, so, give step 1418 with control;

At last, if user action is the position that changes current selected cell, so, give step 1406 with control.

In step 1412, if the electrical form user uses positioning equipment 105

click option buttons

1309,1308,1307,1306 or 1305 respectively, local variable STI_mode value OVERLAY, HORIZONTAL_INSERT, HORIZONTAL_INSERT_BY_RANGE, VERTICAL_INSERT or VERTICAL_INSERT_BY_RANGE.Then, give step 1406 with control.

In step 1413, upgrade local variable STI_critical, so that between value " YES " and " NO ", switch.Then, give step 1406 with control.

In step 1414,, local variable STI_element is subtracted 1 (one) as long as its value keeps the value more than or equal to local variable STI_min.Then, give step 1406 with control.

In step 1415,, local variable STI_element is added 1 (one) as long as its value keeps the value smaller or equal to local variable STI_max.Then, give step 1406 with control.

In step 1416, visit STIT table 750 so that therefrom remove with as such during in step 1408 to the insertion pattern-recognition of local variable STI_mode representative, the STI of the introducing destruction of new example corresponding each write down 751.

Then, upgrade STT table 720, to reflect removing of each STI.For each STI that removes, with its " Name " field 722 equal with remove the corresponding STIT of STI table 750 record 751 " ST " field 753 record 721 " REFERENCED " attribute 729 " INSTANCEREFERENCE " (IR) field 729c divided by 2 (two).

In step 1417, calling routine CreateSTI (creating STI).

In step 1418, close ST instantiation device dialog box 1300, so that it disappears from display device 106.At last, initial step 1401 is given back in control, so that handle the order of any further ST instantiation device.

Following steps, that is, all parts of Figure 14 B are corresponding to the execution of the CreateSTI routine in being used in the preferred embodiment of the present invention.

In step 1419, in STIT table 750, introduce new record 751.In this record 751, address initialization " Address (address) " field 752 with range of cells STI_range 1328, value initialization " ST " field 753 with local variable ST_name, value initialization " Element# " field 754 with local variable STI_element, value initialization " Critical " field 755 with local variable STI_critical, with the number of the element of the Header Section that constitutes new STI (in the Header Section 767 of the STDT table 760 that the ST that this numeral equals to defer to new STI is associated to (pair) number) initialization " Header Size (header size) " field 756 with the number of the element of the Footer Section of the new STI of formation (logarithm in the Footer Section 766 of the STDT table 760 that the ST that this numeral equals with new STI defers to is associated) initialization " Footer Size (footer size) " field 757.Then, scanning STT table 720 equals the record 721 of local variable ST_name so that its " Name " field is found in identification.In case find,, upgrade " REFERENCED " attribute 729 in this record " Type " field of 721 727 by " INSTANCE REFERENCE " son field 729c be multiply by 2 (two).

In step 1420, test value with check local variable STI_mode.

Equal OVERLAY if find this value, so, give step 1425 control;

Equal HORIZONTAL_INSERT if find this value, so, give step 1424 control;

Equal HORIZONTAL_INSERT_BY_RANGE if find this value, so, give step 14244 control;

Equal VERTICAL_INSERT if find this value, so, give step 1423 control;

Equal VERTICAL_INSERT_BY_RANGE if find this value.Then, give step 1421 with control.

In step 1421, selected cell lattice scope STI_range 1328 is so that become current selected range of cells, and this current selected range of cells remains on its former position 1327, then, carries out the routine operation of " will be listed as and insert in the selected scope ".

In step 1422, selected cell lattice scope STI_range 1328 is so that become current selected range of cells, and this current selected range of cells remains on its former position 1327, then, carries out the routine operation of " will go and insert in the selected scope ".

In step 1423, selected cell lattice scope STI_range 1328 is so that become current selected range of cells, and this current selected range of cells remains on its former position 1327, then, carries out the routine operation of " row insert ".Then, give step 1425 with control.

In step 1424, selected cell lattice scope STI_range 1328 is so that become current selected range of cells, and this current selected range of cells remains on its former position 1327, then, carries out the routine operation of " row inserts ".Then, give step 1425 with control.

In step 1425, local variable STI_index is initialized to the value that local variable STI_element is got.Then, analyze STT table 720, so that discern the record 721 of the value coupling of its " Name " field 722 and local variable ST_name." Description Ptr " field 724 of the STDT table 760 that the ST that the retrieval permission is located in storer with the new STI that will create defers in this record 721 is associated.Then, the first couple 761 of element that will find in this STDT table 760 or MEF title and element or MEP title is arranged to current title to (EF or MEF title, EP or MEP title).

In step 1426, analyze EPT table 710, find that its " Name " field 712 equals the current internal EP or the record 711 of MEP title so that find out.In case find this record 711, retrieve its " Description Ptr " field 714, so that in storer, locate the range of cells of illustration EP or MEP.Only by value with the description copy-paste of this EP or MEP to current selected cell, so that the corresponding line in the STI_range is accepted EP or MEP initial value.Then, analyze EFT table 700, find that its " Name " field 702 equals the current internal EF or the record 701 of MEF title so that find out.In case find this record 701, retrieve its " Description Ptr " field 704, so that in storer, locate the range of cells of illustration EF or MEF.Only by attribute with the description copy-paste of this EF or MEF to current selected cell, so that the corresponding line in the STI_range is accepted EF or MEF attribute.

In step 1427, testing to check current still is first element to (EF or MEF title, EP or MEP title) corresponding to element.Under first kind of situation, control is given step 1428 and under second kind of situation, given step 1429 with control.

In step 1428, local variable STI_index is subtracted 1 (one).Then, give step 1430 with control.

In step 1429, test with check current to (EF or MEF title, EP or MEP title) whether be in the STDT table 760 last 763.If situation is like this, finish the execution of CreateSTI by causing the control return to the routine call program; Otherwise, give step 1431 with control.

In step 1430, test with check local variable STI_index whether equal 0 (zero).If situation is like this, give step 1429 with control; Otherwise, give step 1432 with control.

In step 1431, make to be connected on current title after a pair of in the STDT table 760 that (EF or MEF title, EP or MEP title) become current title is right.

In step 1432, current selected cell is moved down delegation.Then, give step 1426 with control.

E7.RST instantiation device method

The method summary that is used in the instantiation RST in the preferred embodiment of the present invention is in the process flow diagram 2100 of Figure 16 A and 16B.This method can be regarded as RST instantiation device process of commands.

In step 2101, this method is in its default conditions, waits for the incident of this process of startup.

In step 2102,, detect the order of RST instantiation device as the result of user action.This action can be, for example, the particular key combination on the keyboard 104, the click of positioning equipment 105 on specific button, or this paper does not make further any other similar means of regulation.

In step 2103, some local variables of retrieval command parameter and initialization:

Command parameter is recorded in RST_name (RST title) variable.

With value 0 (zero) initialization local variable Element# (number of elements).

With default value FLASE (vacation) initialization local variable too_wide (too wide).

With the local variable too_high of default value FLASE value initialization (too high).

Go up maximum available columns initialization local variable Max_col (maximum column) with form (worksheet).

With the maximum available line number initialization local variable Max_row (maximum row) on the form.

With the local variable STI_present of default value FLASE value initialization.

With the local variable RSTI_busy of default value FLASE value initialization (RSTI is busy).

Local variable RSTI_top_1eft_cell (the upper left cell of RSTI) is initialized to current selected cell.

In step 2104, analyze RSTT table 2220, so that identification " Name " field 2222 equals the record 2221 (by local variable Curr_RSTT_rec sign) of command parameter RST_name.Then, local variable RSTI_E# is arranged to equal the value that this writes down " MinElement# " field 2225 of Curr_RSTT_rec 2221.

In step 2105, local variable Curr_RSTDT is arranged to equal write down the RSTDT table 2250 of " Description Ptr " field 2224 indications of Curr_RSTT_rec 2221.Then, local variable Curr_RSTDT_rec is arranged to equal the 1st single cell record 2251 of Curr_RSTDT table 2250.Then, local variable Curr_RET_rec is arranged to equal the record 2211 that " Name " field 2212 equals local variable Curr_RSTDT_rec, RET table 2210.Then, local variable Curr_RED_RoC is arranged to equal write down the range of cells of " Description Ptr " field 2214 indications of Curr_RET_rec 2211.

In step 2106, the neutralization of RSTIDT table 2270 load memory is named it by local variable Curr_RSTIDT.This form has the value that the line number that equals Curr_RSTDT table 2250 adds local variable RSTI_E# and subtracts 1 (one) line number.This form has the columns of the columns that equals Curr_RED_RoC.Then, local variable Curr_RSTIDT_rec is initialized to the 1st record 2271 of Curr_RSTIDT table 2270.

In step 2107, local variable Curr_RSTIDT_cell is initialized to the 1st cell 2280 of Curr_RSTIDT_rec 2271.Then, local variable Curr_REC_Roc_cell is initialized to the 1st cell of Curr_REC_Roc range of cells.

In step 2108, " STI_col " field 2278 of Curr_RSTIDT_cell 2280 is arranged to equal when with unique parameter call of the value that equals local variable Curr_REC_Roc_cell the value that function S TI_col returns.Then, " STI_row " field 2279 of Curr_RSTIDT_cell 2280 is arranged to equal when with two parameter calls of the value that equals local variable Curr_REC_Roc_cell respectively and 0 (zero) the value that function S TI_row returns.Then, " ST_name " field 2280 of Curr_RSTIDT_cell 2280 is arranged to equal the value of local variable Curr_REC_Roc_cell.

In step 2109, whether the cell of testing with check local variable Curr_RSTIDT_cell 2280 representatives is last cell of the record of local variable Curr_RSTIDT_rec 2271 representatives.If situation is like this, so, give step 2111 with control; Otherwise, give step 21l0 with control.

In step 2110, make the cell on the cell the right that is positioned at local variable Curr_RSTIDT_cell 2280 representatives become new Curr_RSTIDT_cell 2280.Then, make the cell on the cell the right that is positioned at local variable Curr_RET_RoC_cell representative become new Curr_RET_RoC_cell.Then, give step 2108 with control.

In step 2111, whether the record of testing with check local variable Curr_RET_rec 2211 representatives is the local variable Curr_RET_rec 2211 that describes RE.If " META " attribute 2218 values of equaling " NO " of " Type " field 2217 of Curr_RET_rec record 2211 just can be determined it.If situation is like this, so, give step 2112 with control; Otherwise, give step 2114 with control.

In step 2112, local variable Element# is added 1 (one).

In step 2113, test to determine whether local variable Element# equals local variable RSTI_E#.If situation is like this, so, give step 2114 with control; Otherwise, give step 2115 with control.

In step 2114, whether the cell of testing with check local variable Curr_RSTIDT_cell 2280 representatives is last cell of the record of Curr_RSTIDT_rec 2271 representatives.If situation is like this, so, give step 2116 with control; Otherwise, give step 2117 with control.

In step 2115, make the record that is connected in the Curr_RSTIDT table 2270 after the Curr_RSTIDT_rec record 2271 become new Curr_RSTIDT_rec record 2271.So, give step 2107 with control.

In step 2116, make the record that is connected in the Curr_RSTIDT table 2270 after the Curr_RSTIDT_rec record become new Curr_RSTIDT_rec record.So, give step 2115 with control.

In step 2117, for each the cell Curr_RSTIDT_cell 2280 that belongs to Curr_RSTIDT table 2270, " container_row " attribute 2281 is arranged to equal to be positioned at Curr_RSTIDT table 2270 and the maximal value of Curr_RSTIDT_cell with " STI_row " attribute 2279 of the cell Same_row_cell in the delegation.Then, for each the cell Curr_RSTIDT_cell 2280 that belongs to Curr_RSTIDT table 2270, " container_col " attribute 2277 is arranged to equal to be positioned at the maximal value of Curr_RSTIDT table 2270 and " STI_col " attribute 2278 of the same cell Same_col_cell that lists of Curr_RSTIDT_cell.

In step 2118, local variable RSTI_col is arranged to equal to belong to " contaiher_col " attribute 2277 sums of cell of the 1st row of Curr_RSTIDT table 2270.Then, local variable RSTI_row is arranged to equal to belong to " container_row " attribute 2281 sums of cell of the 1st row of Curr_RSTIDT table 2270.

In step 2119, test to determine that local variable RSTI_col and the column index sum of cell RSTI_top_left_cell separately deduct 1 (one) whether strict greater than local variable Max_col.If situation is like this, so, give step 2120 with control; Otherwise, give step 2121 with control.

In step 2120, local variable too_wide is arranged to the value of equaling TRUE.

In step 2121, test to determine that local variable RSTI_row and the line index sum of cell RSTI_top_let_cell separately deduct 1 (one) whether strict greater than local variable Max_row.If situation is like this, so, give step 2122 with control; Otherwise, give step 2123 with control.

In step 2122, local variable too_high is arranged to the value of equaling TRUE.

In step 2123, test to determine whether to exist and appear at existing STI on the identical form with cell RSTI_top_left_cell separately.This test can be simply by analyzing STIT table 750, so that finish with pointing to any record 751 of " Address " field 752 identifications of the form that cell RSTI_top_1eft_cell is identical separately.If situation is like this, so, give step 2124 with control; Otherwise, give step 2125 with control.

In step 2124, local variable STI_present is arranged to the value of equaling TRUE.

In step 2125, local variable STI_range is initialized to RSTI_top_left_cell equals the value of local variable RSTI_row and the range of cells that columns equals the value of local variable RSTI_col as upper left cell, line number.

In step 2126, test with check whether have the data that appear in the range of cells RSTI_range.If situation is like this, give step 2127 with control; Otherwise, give step 2128 with control.

In step 2127, local variable RSTI_busy is arranged to the value of equaling TRUE.

In step 2128, on display device 106, show RST instantiation device dialog box 2300.In this dialog box 2300, the value of local variable RST_name is inserted the text field 2302, the value of local variable RSTI_E# is inserted the text field 2311, the value of local variable too_wide is inserted the text field 2304, the value of local variable too_high is inserted the text field 2305, the value of local variable STI_present is inserted the text field 2306 and the value of local variable RSTI_busy is inserted the text field 2307.And if only if, and three local variable too_wide, too_high get identical value FALSE (vacation) with STI_present, enable " Create Instance (establishment example) " button 2310.And if only if, and two local variable too_wide get identical value FALSE with too_high, enable " Create Instance in a newsheet (creating example in new sheet) " button 2309.

In step 2129, this method equals the Any user action on the RST instantiation device dialog box 2300.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 2130, detect the user action on the RST instantiation device dialog box 2300.

If user action is clicked on knob 2303 " Up " arrow with positioning equipment 105, so, give step 2133 with control.

If user action is clicked on knob 2303 " Down " arrow with positioning equipment 105, so, give step 2134 with control.

If user action is to click " Create Instance " button 2310 with positioning equipment 105, so, give step 2138 with control.

If user action is to click " Create Instance in a newsheet " button 2309 with positioning equipment 105, so, give step 2136 with control.

If user action is to click " Cancel " button 2308 or close window button 2301 with positioning equipment 105, so, give step 2131 with control.

In step 2131, releasing unit lattice scope Curr_RSTIDT from storer.

In step 2132, on display device 106, close RST instantiation device dialog box 2300, then, initial step 2101 is given back in control, so that handle the RST instantiation device order in any future.

In step 2133, local variable RSTI_E# is added 1 (one).

In step 2134, local variable RSTI_E# is subtracted 1 (one).

In step 2135, releasing unit lattice scope Curr_RSTIDT from storer.So, give step 2105 with control.

In step 2136, create new form and with its called after curr_sheet.

In step 2137, make the upper left cell of form curr_sheet become new cell RSTI_top_left_cell separately.

In step 2138, with value OVERLAY initialization local variable STI_mode.Then, with value YES initialization local variable STI_critical.Then, local variable Curr_RSTIDT_rec is initialized to the 1st record 2271 of Curr_RSTIDT table 2270.Then, local variable Curr_RSTIDT_cell is initialized to the 1st cell 2280 of record Curr_RSTIDT_rec 2271.Then, local variable Curr_cell is initialized to equals RSTI_top_left_cell.

In step 2139, " container_range " attribute 2276 of Curr_RSTIDT_cell 2280 is initialized to independent cell Curr_cell equals the value of " container_col (container row) " attribute 2277 as value, the columns that upper left cell, line number equal " con-tainer_row " attribute 2281 range of cells.

In step 2140, local variable STI_range is arranged to equal " container_range " attribute 2276 of Curr_RSTIDT_cell2280.Then, local variable ST_name is arranged to equal " ST_name " attribute 2280 of Curr_RSTIDT_cell 2280.Then, local variable ST_element is arranged to equal " Min Element# " attribute 2225 of record 721 that " Name " field 722 equals the STT table 720 of ST_name.

In step 2141, call CreateSTI order (as a subroutine).When this order has been finished and caused the control return to current process, give next step 2142 with control.

In step 2142, " STIT_rec_ptr " of Curr_RSTIDT_cell 2280 is arranged to point to the STIT record of just during previous step 2141, having created 751.

In step 2143, whether the cell of testing with check local variable Curr_RSTIDT_cell 2280 representatives is last cell of the record of local variable Curr_RSTIDT_rec 2271 representatives.If situation is like this, so, give step 2143 with control; Otherwise, give step 2144 with control.

In step 2144, with the move right columns of value of " container_col " attribute 2277 of equaling Curr_RSTIDT_cell 2280 of independent cell curr_cell.Then, make the cell that is positioned at independent cell Curr_RSTIDT_cell 2280 the right become new Curr_RSTIDT_cell 2280.

In step 2145, whether the record of testing with check local variable Curr_RSTIDT_rec 2271 representatives is last record of the RSTIDT table of local variable Curr_RSTIDT 2270 representatives.If situation is like this, so, give step 2147 with control; Otherwise, give step 2146 with control.

In step 2146, independent cell RSTI_top_left_cell is moved down the line number of the value of " container_row " attribute 2281 that equals Curr_RSTIDT_cell 2280.Then, independent cell curr_cell is arranged to equal independent cell RSTI_top_left_cell.Then, make the record 2271 that is connected among the Curr_RSTIDT 2270 after the Curr_RSTIDT_rec become new Curr_RSTIDT_rec 2271.Then, make the 1st cell of Curr_RSTIDT_rec 2271 become new cell Curr_RSTIDT_cell 2280 separately.

In step 2147, in RSTIT table 2260, create new record 2261, so that describe the RSTI that has just created." Address " field 2262 is inserted in the address of rir range of cells 2001.Local variable RST_name is inserted " RST " field 2263.Local variable Element# is inserted " Element# " field 2264.Local variable Curr_RSTIDT is inserted " RSTIDT Ptr " field 2265.The capable line number of container that constitutes RSTI header 2002 is inserted " Header Size " field 2266.The capable line number of container that constitutes RSTI footer 2204 is inserted " Footer Size " field 2267.Then, scanning RSTT table 2220 equals the record 2221 of local variable RST_name so that " Name " field 2222 is found in identification.In case find,, upgrade " REFERENCED " attribute 2229 in this record " Type " field of 2,221 2227 by " INSTANCE REFERENCE " son field 2229c be multiply by 2 (two).Then, give step 2132 with control.

E8.RE editing machine method

Be used in the establishment in the preferred embodiment of the present invention or upgrade RE or the method summary of element in the process flow diagram 2340 of Figure 18 C.This method can be regarded as RE editing machine process of commands.

In step 234l, this method is in its default conditions, waits for the incident of this process of startup.

In step 2342,, detect the order of RE editing machine as the result of user action.This action can be, for example:

Particular key combination on the keyboard 104;

The click of positioning equipment 105 on specific button; Or

Do not make further any other similar means of regulation at this this paper.

In step 2343, the parameter of retrieval command.It is corresponding to there being parameters R E_name, and this parameter can be got retention " NEW ", or with as corresponding another value of string name finding in " Name " of the record in the RSTMT table 2,230 2231 field 2232.This reference record is become local variable.

In step 2344, some local variables of initialization: with local variable RE_meta value of being arranged to " NO ", with local variable RE_size value of being arranged to 3 (three) with local variable RE_rank (RE ordering) value of being arranged to 1 (one).

In step 2345, test value to determine that local variable RE_name is got.If find to equal " NEW ", so, give step 2349 with control; Otherwise, give step 2346 with control.

In step 2346, search RET table 2210, find that with the location its " Name " field 2223 equals the record 2211 of the value that local variable RE_name got.If find such record, so, give step 2348 with control; Otherwise, give step 2347 with control.

In step 2347, call exception handler, this to handle " should not take place " situation.Such operation is to realize being correlated with, and can take different forms, for example, shows the error message pop-up window on display device 106.Then, give step 2341 with control.

In step 2348,

According to the value of " META " attribute 2218 in " Type " field 2217 of the record 2211 that in step 2346, finds, with local variable RE_meta value of being arranged to " YES " or " NO ";

Local variable RE_size is arranged in the value that finds in " Column# " field 2216 of the record 2211 that in step 2346, finds; With

The memory location of " Description Ptr " field 2214 indications of the record 2211 that will find in step 2346 copies on the extra buffer that is recorded as local variable RE_buffer (RE impact damper).

Then, give step 2350 with control.

In step 2349, according to the name character string of taking " New XX " form in a preferred embodiment of the invention, determine the newname of the new RE of establishment, wherein, XX corresponding to for defined in the past and be recorded in form EFT 700, EPT 710, STT 720, RET 2210 and RSST 2220 separately write down all titles in " Name " field 702,712,722,2212 and 2222 that finds in 701,711,721,2211 and 2221 separately, guarantee the counting of title uniqueness.As long as guarantee the new uniqueness of creating title, can use any other similar traditional means instead and non-migration spirit of the present invention.Then, newname is recorded among the local variable RE_name.Then, memory allocated space in primary memory 102 is so that write down the illustration range of cells of new RE or RME later on.This memory allocated space that is recorded as local variable RE_buffer is and a part when the corresponding storage space of electronic form file of front opening.Then, in RET table 2210, create new record 2211 and by this new record 2211 of following initialization:

" Name " field 2212 is arranged to the value of local variable RE_name;

" Last Change Date " field 2213 is arranged to quote as the system time known to the central processing unit 101;

The memory location RE_buffer that " Description Ptr " field 2214 is arranged to just distribute;

" Row# " field 2215 values of being arranged to 1 (because in a preferred embodiment of the invention, are managed RST under the 2D environment; Under the 3D environment, this field will be carried the line number into the RE definition of creating);

" Column# " field 2216 is arranged to the value of local variable RE_size; With

By following setting " Type " field 2217: attribute " META " 2218 is arranged to equal the value of local variable RE_meta and by following init attributes " REFERENCED " 2219:

With also not being assigned to any other " OWN REFERENCE " (OR) prime number initialization OR son field 2219a of son field 709a, 719a, 729a, 780a, 2219a, 2229a or 2240a.Various conventional arts can be used to discern prime number, are not described in further detail here.

According to (FR) son field 2219b of following formula initialization " FILIATION REFERENCE ", wherein, according to the structure that is recorded in " Description Ptr " field 2214, the F set is corresponding to the set of the ST that constitutes new RE or element:

FR＝П _i∈FOR _i×LCM({FR _i}) _i∈F

With being worth (IR) son field 2219c of 1 (one) initialization " INSTANCE REFERENCE ".

With (RO) son field 2219d of following formula initialization " REFERENCED OBJECT ".Wherein, P gathers the set corresponding to RST:

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then; Otherwise, RO=" NO ".

With (SC) son field 2219e of following formula initialization " SELECTED CHILDREN ".

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#RE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, give step 2350 with control.

In step 2350, on display device 106, show RE editing machine dialog box 2321.

Value initialization's indicia framing 2324 with local variable RE_name.

Equal " NO " (correspondingly, " YES ") if find local variable RE_meta, stain is inserted top OptionButton 2331 (correspondingly, the bottom OptionButton 2330).

The value of local variable RE_size is inserted text box 2326.

Equal " Column# " field 2216 of current record 2211 if find local variable RE_size, if or " Type " field 2217 interior attributes " REFERENCED " 2219 of finding this record 2211 have son field " REFERENCEDOBJECT " 2219d (RO) that equals " NO ", enable button " Save " 2333 is so that in the future all be identified as a validity event with positioning equipment 105 to any click of this button " Save " 2333.

Otherwise (do not find that local variable RE_size (RE size) equals " Column# " field 2216 of current record 2211, or " Type " field 2217 interior attributes " REFERENCED " 2219 of finding this same record 2211 have son field " REFERENCED OBJECT " 2219d (RO) that equals " YES ", forbid button " Save " 2333, so that in the future any click of this button " Save " 2333 is not identified as a validity event with positioning equipment 105.

Value initialization's text box 2335 with local variable RE_rank.

With belonging to the content initialization list frame 2334 that RE_buffer and its skew equal the cell of RE_rank.The tabulation of available title in this list box 2334 (by clicking knob 2328) is made of the title that is recorded in the ST in the STT table 720.

In step 2351, this method is waited for the Any user action on the RE editing machine dialog box 2321.The click of positioning equipment 105 that comes usually to use by oneself of such user action, but also can take other similar type, for example, the particular key combination (but being not limited thereto) on the keyboard 104, or this paper does not make further any other similar means of regulation.

In step 2352, detect the user action on the RE editing machine dialog box 2321.

If user action is to click knob 2328,, so, give step 2353 with control so that select the ST title;

If user action is a button click " Save " 2333, so, give step 2354 with control;

If user action is a button click " Save as " 2332, so, give step 2355 with control;

If user action is to click knob 2329, so, give step 2358 with control;

If user action is to click knob 2327, so, give step 2359 with control;

If user action is to click one of two OptionButtons 2330 or 2331, so, give step 2360 with control;

If user action is button click " Done " 2323 or close window button 2322, so, give step 2361 with control.

In step 2353, the content of the cell of the value by skew being equaled local variable RE_rank is arranged to equal the content of list box 2334, upgrades local variable RE_buffer.Then, give step 2350 with control.

In step 2354,, upgrade SET table 2210, with a part of it being preserved into electronic form file by refreshing the record 2211 that " Name " field 2212 equals local variable RE_name.For this purpose,

" Column# " field 2216 is arranged to the value of local variable RE_size; With

By following setting " Type " field 2217: the value of attribute " META " 2218 being arranged to equal local variable RE_meta.

In addition, the range of cells RE_buffer with the current definition of illustration RE or element copies on the memory location of " Description Ptr " field 2214 indications.Then, give step 2350 with control.

In step 2355, the value that finds in text box 2325 is tested, to determine that whether it is corresponding to effective newname.Corresponding criterion be realize relevant, as long as new recommend title with respect to be recorded in " Name " field 702,712,722,2212 and 2222 all define name be unique string, can take various forms and not depart from spirit of the present invention.If validity and uniqueness all obtain proof, so, give step 2356 with control; Otherwise, give step 2357 with control.

In step 2356, memory allocated space in primary memory 102 is so that write down the illustration range of cells of EF or MEF later on.The storage space of this distribution is and a part when the corresponding storage space of electronic form file of front opening.Then, in the RET of a part of preserving into electronic form file table 2210, create new record 2211 and by this new record 2211 of following initialization:

" Name " field 2212 is arranged in the value that finds in the text box 2325 and in step 2355, obtain examining;

" Column# " field 2216 is arranged to the value of local variable RE_size; With

FR＝П _i∈FOR _i×LCM({FR _i}) _i∈F

If LCM is ({ FR _i) _{I ∈ P}Mod OR=0,

RO=" YES " then;

Otherwise, RO=" NO ".

With (SC) son field 2219e of following formula initialization " SELECTED CHILDREN ".Wherein, S gathers the set (" SELECTED " attribute 2242 with value of equaling in the RSTMT table 2230 " YES ") corresponding to selected object:

If LCM is ({ FR _i) _{I ∈ S}Mod OR=0#OR#RE_name ∈ S,

SC=" YES " then;

Otherwise, SC=" NO ".

Then, give step 2350 with control.

In step 2357, the message informing that gives a warning so that notify the user before clicking " Save as " button 2332, must be specified effectively unique title in text box 2325.This can finish by on display device 106 alert message being presented in the pop-up window or being presented in the status bar region usually, but also can use any other similar means instead and do not depart from spirit of the present invention.In case the user is by traditional means, for example, click with positioning equipment 105 and to appear at interior " OK " button of alert message pop-up window, or any other the similar means that do not depart from spirit of the present invention have confirmed this notification message, give step 2350 with control.

In step 2358, if the user has clicked downward this side of knob 2329 with positioning equipment 106, keep positive as long as local variable RE_rank is strict, it is subtracted 1 (one), if clicked upwards this side of knob 2329 with positioning equipment 106 with the user, as long as local variable RE_rank adds 1 (one) smaller or equal to the value of local variable RE_size with it.Then, give step 2350 with control.

In step 2359, direction (up or down) according to positioning equipment 105 appointment on knob 2359, with as long as its value keeps positive and smaller or equal to being arranged to equal 254 the upper limit in a preferred embodiment of the invention, local variable RE_size is added 1 (one) or subtract 1 (one).Then, give step 2350 with control.

In step 2360, upgrade local variable RE_meta, if so that clicked bottom OptionButton 2330 (correspondingly, top OptionButton 2331), its value is become " YES " (correspondingly, " NO ").Then, give step 2350 with control.

In step 2361, close RE editing machine dialog box 2321, so that it disappears from display device 106.At last, initial step 2341 is given back in control, so that handle the ST editing machine order in any future.

E9.STI row/linage-counter method

The method summary that is used in columns in the counting STI in the preferred embodiment of the present invention or line number is in the process flow diagram 2400 and 2420 of Figure 19 A and 19B.These methods can be regarded as the processing of STI_Row and STI_col function.

In step 2401, first method is in its default conditions, waits for the STI_Row function calls.

In step 2402,, detect the STI_Row function call as the result of user action.Two parameter calls of ST_Name by name and STI_Element of this function.

In step 2403, Curr_Record be arranged in the 1st record 721 of STT table 720.

In step 2404, field Name 722, Min Element# and the Max Element# that writes down Curr_Record 721 is arranged to local variable Curr_Name, Curr_Min and Curr_Max respectively.

In step 2405, test to detect local variable Curr_Name whether equal function parameter ST_Name.If situation is like this, so, give step 2409 with control; Otherwise, give step 2406 with control.

Whether in step 2406, testing with detection record Curr_Record 721 is last record of STT table 720.If situation is like this, so, give step 2408 with control; Otherwise, give step 2407 with control.

In step 2407, make the record that is connected in the STT table 720 after the Curr_Record become new record Curr_Record 721.Then, give step 2404 with control.

In step 2408, local variable STI_Row is arranged to equal 0 (zero).Then, give step 2412 with control.

In step 2409, the range of cells that writes down description Ptr 724 indications of Curr_Record 721 is arranged to STDT_address (STDT address).

In step 2410, local variable Element_Nbr is arranged to equal be the upper bound, be the input parameter STI_Element of lower bound with local variable Curr_Min with local variable CurrMax.

In step 2411, the value that the line number that local variable STI_row is arranged to equal range of cells STDT_adress adds local variable STI_Element subtracts 1 (one).

In step 2412, along with control turns back to the execution that the function call program is finished the STI_row function.

In step 2421, second method is in its default conditions, waits for the STI_Col function calls.

In step 2422,, detect the STI_Col function call as the result of user action.The parameter call of ST_Name by name of this function.

In step 2423, Curr_Record be arranged in the 1st record 721 of STT table 720.

In step 2424, the field Name 722 that writes down Curr_Record 721 is arranged to local variable Curr_Name.

In step 2425, test to detect local variable Curr_Name whether equal function parameter ST_Name.If situation is like this, so, give step 2429 with control; Otherwise, give step 2426 with control.

Whether in step 2426, testing with detection record Curr_Record 721 is last record of STT table 720.If situation is like this, so, give step 2428 with control; Otherwise, give step 2427 with control.

In step 2427, make the record that is connected in the STT table 720 after the Curr_Record become new record Curr_Record 721.Then, give step 2424 with control.

In step 2428, local variable STI_Col is arranged to equal 0 (zero).Then, give step 2431 with control.

In step 2429, the range of cells that writes down description Ptr 724 indications of Curr_Record 721 is arranged to STDT_address.

In step 2430, local variable STI_Col is arranged to equal the columns of range of cells STDT_adress.

In step 2431,, finish the execution of STI_col function along with control turns back to the function call program.

E10.RST derives the manager method

The process flow diagram 2500 of Figure 20 A has been summarized the method for using in a preferred embodiment of the invention that is used for the definition of RST object (EF or EP or MEF or MEP or ST or RE or RME or RST) is exported to from the source electronic form file target derivation-importing electronic form file.This method can be counted as RST and derive the manager process of commands.

In step 2501, this method is in its default setting, waits for the incident that starts this processing.

In step 2502,, detect RST and derive the manager order as the result of user's operation.This operation can for example be particular key combination on the keyboard 104 or pointing device 105 on specific button click or not in any other similar means of this concrete appointment.

In step 2503, show that on display device 106 RST derives manager dialog box 2600.In this stage that RST derives the manager method, RST derives manager dialog box 2600 and only comprises three buttons: button " exports in the new file " 2612, button " exports in the existing file " 2613 and button " cancellation " 2602.

In step 2504, this method waits for that RST derives the Any user operation on the manager dialog box 2600.Such user's operate typical ground produces by clicking with pointing device 105, but also can take other similar type, makes up such as but not limited to the particular key on the keyboard 104, perhaps not at any other similar device of this concrete appointment.

In step 2505, the user that detecting RST derives on the manager dialog box 2600 operates.

If user operation is button " to be exported in the new file " 2612 click, then control forwards step 2507 to;

If user operation is button " to be exported in the existing file " 2613 click, then control forwards step 2508 to;

If user's operation is the click to button " cancellation " 2602 or close window button 2601, then control forwards step 2506 to.

In step 2506, close RST and derive manager dialog box 2600, control turns back to initial step 2501 then, derives the manager order so that handle the RST in any future.

In step 2507, use traditional device and electrical form user interactions, so that create the new electrical form derivation-importing file that will be created.In a preferred embodiment of the invention, these devices are created dialog box corresponding to the traditional file that shows on display device 106, but also can use any other similar conventional apparatus, and do not break away from spirit of the present invention.In addition, do not influence spirit of the present invention, therefore do not do ad hoc hypothesis for the file structure of in the environment of operation spreadsheet application, using owing to can use any traditional file structure.Then, control forwards step 2512 to.

In step 2508, use traditional device and electrical form user interactions, so that the existing electrical form derivation-importing file that retrieval will be updated.In a preferred embodiment of the invention, these devices are selected dialog box corresponding to the traditional file that shows on display device 106, but also can use any other similar conventional apparatus, and do not break away from spirit of the present invention.In addition, do not influence spirit of the present invention, therefore do not do ad hoc hypothesis for the file structure of in the environment of operation spreadsheet application, using owing to can use any traditional file structure.

In step 2509, carry out test, to check whether the file in step 2508 identification is effective electrical form derivation-importing file.The electronic form file that this validity test is discerned corresponding to checking is followed the logical file structrure 2640 shown in Figure 21 C, and wherein logical file structrure 2640 is made of following three parts:

First 2641 is the electrical form derivation-importing file heads that comprise unique signature of sign electrical form derivation-importing file.

Second portion 2642 is made of the table of the structure of following the RSTEIT table 770 shown in Fig. 7 F.

The 3rd and last part 2643 are descriptor region, wherein write down in the second portion 2642 of electrical form derivation-importing file the description of " description pointer " field 774 in the record 771 of table of similar RSTEIT of record RST project (EF or EP or MEF or MEP or ST or RE or RME or RST) pointed.

If electronic form file is followed this logical file structrure 2640, then control forwards step 2511 to; Otherwise control forwards step 2510 to.

In step 2510, the message informing that gives a warning is not so that follow the structure of electrical form derivation-importing file to the selected electronic form file of user notification.This typically can finish by show alert message in the pop-up window of display device 106 or status bar region, but also can use any other similar device, and does not break away from spirit of the present invention.Confirmed this notification message in case the user for example clicks any other similar device that is present in " determining " button in the alert message pop-up window or does not break away from spirit of the present invention with pointing device 105 by conventional apparatus, then controlled and forward step 2503 to.

In step 2511, second and the

third part

2642 and 2643 that selects files is loaded in the storer, to form RSTEIT table 770 and relevant object factory.

Then, some local variables of initialization:

With local variable RSTEM_index1 value of being initialized as 1 ();

With the local variable RSTEM_replace_all value of being initialized as "No";

Local variable RSTEM_RSTMT_size is initialized as the number of the record 2231 in the RSTMT table 2230;

Local variable RSTEM_STEIT_size is initialized as the number of the record 771 in the RSTEIT table 770.

Then, control forwards step 2513 to.

In step 2512, in storer, create empty RSTEIT table 770, and be used to write down relational storage space by the description of writing down the 771 RST projects of describing.Then, some local variables of initialization: with local variable RSTEM_index1 value of being initialized as 1 (); With local variable RSTEM_replace all values of being initialized as "No"; Local variable RSTEM_RSTMT_size is initialized as the number of the record 2231 in the RSTMT table 2230; Local variable RSTEM_STEI_size is initialized as 0 (zero).

In step 2513, when text box 2603 is specified when it derives the title of file of ST project, and when progress displaying bar 2604 be that size is when ordering is the situation of record of RSTEM_index1 in the middle of the set of RSTEM_RSTMT_size, refreshes RST and derive manager dialog box 2600 on display device 106 with the current processed record of reflection RSTMT table 2230.

In step 2514, in RSTMT table 2230, the record 2231 that the value of its " index " field 2238 equals the value of local variable RSTEM_index1 becomes the current record RSTEM_RSTMT_rec 2231 of RSTMT table 2230.

In step 2515, test carried out in RSTEM_RSTMT_rec record 2231, to determine that whether it is corresponding to selected object.The value (referring to step 841) of the RSTM_child local variable of a part that is set to the order of RST manager is depended in this test.

If local variable RSTM_child equals "No", and if the value of " select " attribute 2242 in " type " field 2237 equal "Yes", think that then this object is selected, and control and forward step 2517 to.

If local variable RSTM_child equals "Yes", if and the value of " selected subsystem (SELECTED CHILDERN) " son field 2240e of " being cited " attribute 2240 in " type " field 2237 equals "Yes", think that then this object is selected, and control forwards step 2517 to.

Under all other situations, do not think that this object is selected, and control forwards step 2516 to.

In step 2516, carry out test, with the value of checking local variable R STEM_index1 whether more than or equal to the value of local variable RSTEM_RSTMT_size.If then control forwards step 2528 to; Otherwise control forwards step 2527 to.

In step 2517, with local variable RSTEM_index2 value of being initialized as 1 ().

In step 2518, in RSTEIT table 770, the record 771 that the value of its " index " field 778 equals the value of local variable RSTEM_index2 becomes the current record RSTEM_STEIT_rec 771 of RSTEIT table 770.

In step 2519, carry out test, whether equal the value of " title " field 772 of RSTEM_STEIT_rec record 771 with the value of " title " field 2232 of checking RSTEM_RSTMT_rec record 2231.If then control forwards step 2521 to; Otherwise control forwards step 2520 to.

In step 2520, carry out test, with the value of checking local variable R STEM_index2 whether more than or equal to the value of local variable RSTEM_STEIT_size.If then control forwards step 2523 to; Otherwise control forwards step 2522 to.

In step 2521, carry out test, to check the whether value of equaling "Yes" of local variable R STEM_replace_all.If then control forwards step 2525 to; Otherwise control forwards step 2524 to.

In step 2522, local variable RSTEM_index2 is increased progressively 1 (one), control forwards step 2518 to then.

In step 2523, in RSTEIT table 770, create new record 771.In each field 772,773,775,776,777 and 778 with each

field

2232,2233,2235,2236,2237 in the RSTEM_RSTMT_rec record 2231 and this new record of content initialization of 2238.In addition, " description pointer " field 2234 RST item descriptions pointed are copied in the descriptor region 2643, and " description pointer " field 774 of RSTEM_STEIT_rec record 2231 is made as the storage address of the descriptor that is duplicated.Then, control forwards step 2516 to.

In step 2524, by in frame 2611, show with RSTEIT table 770 Already in record and some the relevant information of conflict between the record of from RSTMT table 2230, deriving, upgrade RST derivation manager dialog box 2600.These records are presented at identical RST project in the text box 2605 corresponding to its title.RSTEIT record 771 is coupled with timestamp with the date that is presented in the text box 2606, and RSTMT record 2231 is coupled with timestamp with the date that is presented in the text box 2607.The electrical form user carries out following three kinds and one of selects:

If he wants at all RST projects, to replace the existing definition based on RSTEIT table 770 based on the definition of RSTMT table 2230, then he clicks " all being " button 2609 with pointing device 105, and control forwards step 2526 to;

If he wants at current RST project, to replace the existing definition based on RSTEIT table 770 based on the definition of RSTMT table 2230, then he clicks "Yes" button 2610 with pointing device 105, and control forwards step 2525 to;

If he does not want that at current RST project to replace the existing definition based on RSTEIT table 770 based on the definition of RSTMT table 2230, then he clicks "No" buttons 2608 with pointing device 105, and control forwards step 2516 to.

Under these three kinds of situations, in case the electrical form user clicks one of these three

buttons

2608,2609 and 2610 with pointing device 105, the object that frame 2611 and it are comprised just no longer is presented on the display device 106 at all.

In step 2525, word for word RSTEM_STEIT_rec record 771 in the RSTEIT tables 770 is replaced with RSTEM_RSTMT_rec record 2231 in section ground: to replace the content of each field 772,773,775,776,777 and 778 from the content of each

field

2232,2233,2235,2236,2237 of RSTEM_RSTMT_rec record 2231 and 2238.In addition, " description pointer " field 2234 RST item descriptions pointed are copied to the descriptor region 2643 at " description pointer " field 774 of being positioned at RSTEM_RSTMT_rec record 2231 place, addresses pointed.Then, control forwards step 2516 to.

In step 2526, local variable RSTEM_replace_all is set as the value of equaling "Yes", control forwards step 2525 to then.

In step 2527, local variable RSTEM_index1 is increased progressively 1 (one), control forwards step 2513 to then.

In step 2528, RSTEIT table 770 and associated description are kept on current derivation-importing file, so that form the second portion (table of similar RSTEIT) 2642 and the third part of upgrading (descriptor region) 2643 of the renewal of this derivation-logical organization 2640 that the importing file is followed respectively.Then, control forwards step 2506 to.

E11.RST imports the manager method

The process flow diagram 2530 of Figure 20 B has been summarized the method for using in a preferred embodiment of the invention that is used for the definition of RST object (EF or EP or MEF or MEP or ST or RE or RME or RST) is imported to from source importing-derivation electronic form file the target electronic form document.This method can be counted as RST and import the manager process of commands.

In step 2531, this method is in its default setting, waits for the incident that starts this processing.

In step 2532,, detect RST and import the manager order as the result of user's operation.This operation can for example be particular key combination on the keyboard 104 or pointing device 105 on specific button click or not at any other similar device of this concrete appointment.

In step 2533, show that on display device 106 RST imports manager dialog box 2620.In this stage of RST importing manager method, RST imports manager dialog box 2620 and only comprises two buttons: button " selection imports file " 2632 and button " cancellation " 2622.

In step 2534, this method waits for that RST imports the Any user operation on the manager dialog box 2620.Such user's operate typical ground produces by clicking with pointing device 105, but also can take other similar type, makes up such as but not limited to the particular key on the keyboard 104, perhaps not at any other similar device of this concrete appointment.

In step 2535, detect user's operation of leading on the RST importing manager dialog box 2620.If user's operation is that then control forwards step 2537 to the click of button " selection imports file " 2632.If user's operation is the click to button " cancellation " 2622 or close window button 2621, then control forwards step 2536 to.

In step 2536, close RST and import manager dialog box 2620, control turns back to initial step 2531 then, imports the manager order so that handle the RST in any future.

In step 2537, use traditional device and electrical form user interactions, so that accessed existing electrical form derivation-importing file is wanted in retrieval.In a preferred embodiment of the invention, these devices are selected dialog box corresponding to the traditional file that shows on display device 106, but also can use any other similar conventional apparatus, and do not break away from spirit of the present invention.In addition, do not influence spirit of the present invention, therefore do not do ad hoc hypothesis for the file structure of in the environment of operation spreadsheet application, using owing to can use any traditional file structure.

In step 2538, carry out test, to check whether the file in step 2537 identification is effective electrical form derivation-importing file.This validity test is followed the logical file structrure 2640 shown in Figure 21 C corresponding to this electronic form file of checking, and wherein logical file structrure 2640 is made of three parts.First 2641 is the electrical form derivation-importing file heads that comprise unique signature of sign electrical form derivation-importing file.Second portion 2642 is made of the table of the structure of following the RSTEIT table 770 shown in Fig. 7 F.The 3rd and last part be descriptor region, wherein write down in the second portion 2642 of derivation-importing file the description of " description pointer " field 774 in the record 771 of table of similar RSTEIT of record RST project (EF or EP or MEF or MEP or ST or RE or RME or RST) pointed.If this document is followed this logical file structrure 2640, then control forwards step 2540 to; Otherwise control forwards step 2539 to.

In step 2539, the message informing that gives a warning is not so that follow the structure of electrical form derivation-importing file to the selected electronic form file of user notification.This typically can finish by show alert message in the pop-up window of display device 106 or status bar region, but also can use any other similar device, and does not break away from spirit of the present invention.Confirmed this notification message in case the user for example clicks any other similar device that is present in " determining " button in the alert message pop-up window or does not break away from spirit of the present invention with pointing device 105 by conventional apparatus, then controlled and forward step 2533 to.

In step 2540, second and the

third part

2642 and 2643 that selects files is loaded in the storer, so that form RSTEIT table 770 and relevant object factory.Then, some local variables of initialization:

With local variable RSTIM_index1 value of being initialized as 1 ();

With the local variable RSTIM_replace_all value of being initialized as "No";

Local variable RSTIM_RSTMT_size is initialized as the number of the record 2231 in the RSTMT table 2230;

Local variable RSTIM_STEIT_size is initialized as the number of the record 771 in the RSTEIT table 770.

In step 2541, when text box 2623 is specified when it imports the title of file of ST project, and when progress displaying bar 2624 be that size is when ordering is the situation of record of RSTIM_index1 in the middle of the set of RSTIM_STEIT_size, refreshes RST and import manager dialog box 2620 on display device 106 with the current processed record of reflection RSTEIT table 770.

In step 2542, in RSTEIT table 770, the record 771 that the value of its " index " field 778 equals the value of local variable RSTIM_index1 becomes the current record RSTIM_RSTMT_rec 771 of RSTEIT table 770.

In step 2543, with local variable RSTIM_index2 value of being initialized as 1 ().

In step 2544, in RSTMT table 2230, the record 2231 that the value of its " index " field 2238 equals the value of local variable RSTIM_index2 becomes the current record RSTIM_RSTMT_rec 2231 of RSTMT table 2230.

In step 2545, carry out test, whether equal the value of " title " field 772 of RSTIM_STEIT_rec record 771 with the value of " title " field 2232 of checking RSTIM_RSTMT_rec record 2231.If then control forwards step 2555 to; Otherwise control forwards step 2546 to.

In step 2546, carry out test, with the value of checking local variable R STIM_index2 whether more than or equal to the value of local variable RSTIM_RSTMT_size.If then control forwards step 2549 to; Otherwise control forwards step 2548 to.

In step 2547, carry out test, to check the whether value of equaling "Yes" of local variable R STIM_replace_all.If not, then control forwards step 2550 to; Otherwise control forwards step 2551 to.

In step 2548, local variable RSTIM_index2 is increased progressively 1 (one), control forwards step 2544 to then.

In step 2549, in RSTMT table 2230, create new record 2231.In each field 2232,2233,2235,2236,2237 and 2238 with each field 772,773,775,776,777 in the RSTIM_STEIT_rec record 771 and this new record of content initialization of 778.In addition, " description pointer " field 774 RST item descriptions pointed are copied in the storer, and " description pointer " field 2234 of new record 2231 is made as the storage address of the descriptor that is duplicated.Then, " character " attribute 2241 of " type " field 2237 of retrieving novel record 2231 is so that determine also must show at which to create in (EFT 700 or EPT 710 or STT 720 or RET 2210 or RSTT 2220) new record.If being found, this " character " attribute equals " form " (correspondingly, " template " or " summary " or " recurrence element " or " recurrence template "), then (correspondingly at EFT table 700, EPT table 710 or STT table 720 or RET table 2210 or RSTT table 2220) middle establishment new record 701 is (correspondingly, 711 or 721 or 2211 or 2221), wherein with the field 2232 of new record 2231,2233,2234,2235,2236,2239,2240 content initialization field 702,703,704,705,706,708,709 (correspondingly, 712,713,714,715,716,718,719, perhaps 722,723,724,725,726,728,729, perhaps 2212,2213,2214,2215,2216,2217,2218,2219, perhaps 2222,2223,2224,2225,2226,2227,2228,2229).In field 709 (correspondingly, 719,729,2219,2240), fill " self reference " (OR) son field 709a (correspondingly, 719a, 729a, 2219a, 2240a) with the prime number of the OR son field that is not assigned to previous definition.In field 709 (correspondingly, 719,729,2219,2240), fill " example is quoted " (IR) son field 709c (correspondingly, 719c, 729c, 2219c, 2240c) to be worth 1.Then, control forwards step 2553 to.

In step 2550, word for word RSTIM_RSTMT_rec record 2231 in the RSTMT tables 2230 is replaced with RSTIM_STEIT_rec record 771 in section ground: to replace the content of each field 2232,2233,2235,2236,2237 and 2238 from the content of each field 772,773,775,776,777 of RSTIM_STEIT_rec record 771 and 778.In addition, duplicate " description pointer " field 774 ST item description pointed from the descriptor region 2643 of " description pointer " field 2234 that is positioned at RSTIM_RSTMT_rec record 2231 address pointed.Then, " character " attribute 2241 of " type " field 2237 of the record 2231 that retrieval is upgraded is so that determine also must show at which in (EFT 700 or EPT 710 or STT 720 or RET 2210 or RSTT 2220) more new record.If being found, this " character " attribute equals " form " (correspondingly, " template " or " summary " or " recurrence element " or " recurrence template "), then upgrade EFT table 700 (correspondingly, EPT table 710 or STT table 720 or RET table 2210 or RSTT table 2220) in its " title " field 702 (correspondingly, 712 or 722 or 2212 or 2222) be found equal " title " field 2232 record 701 (correspondingly, 711 or 721 or 2211 or 2221), while is with the field 2233 of the record 2231 of renewal, 2234,2235,2236,2239,2240 content is replaced field 703,704,705,706,708,709 (correspondingly, 713,714,715,716,718,719, perhaps 723,724,725,726,728,729729, perhaps 2212,2213,2214,2215,2216,2217,2218,2219, perhaps 2222,2223,2224,2225,2226,2227,2228,2229).Then, control forwards step 2553 to.

In step 2551, by in frame 2631, show with RSTMT table 2230 Already in record and some the relevant information of conflict between the record that imports from RSTEIT table 770, upgrade RST importing manager dialog box 2620.These records are presented at identical RST project in the text box 2625 corresponding to its title.RSTEIT record 771 is coupled with timestamp with the date that is presented in the text box 2627, and RSTMT record 2231 is coupled with timestamp with the date that is presented in the text box 2626.The electrical form user carries out following three kinds and one of selects:

If he wants at all RST projects, to replace the existing definition based on RSTMT table 2230 based on the definition of RSTEIT table 770, then he clicks " all being " button 2629 with pointing device 105, and control forwards step 2552 to;

If he wants at current RST project, to replace the existing definition based on RSTMT table 2230 based on the definition of RSTEIT table 770, then he clicks "Yes" button 2630 with pointing device 105, and control forwards step 2550 to;

If he does not want that at current RST project to replace the existing definition based on RSTMT table 2230 based on the definition of RSTEIT table 770, then he clicks "No" buttons 2628 with pointing device 105, and control forwards step 2553 to.

Under these three kinds of situations, in case the electrical form user clicks one of these three buttons 2628,2629 and 2630 with pointing device 105, the object that frame 2631 and it are comprised just no longer is presented on the display device 106 at all.

In step 2552, local variable RSTIM_replace_all is set as the value of equaling "Yes", control forwards step 2550 to then.

In step 2553, carry out test, with the value of checking local variable R STIM_index1 whether more than or equal to the value of local variable RSTIM_STEIT_size.If then control forwards step 2536 to; Otherwise control forwards step 2554 to.

In step 2554, with local variable RSTIM_index1 value of being initialized as 1 (), control forwards step 2541 to then.

In step 2555, carry out test, whether have greater than 1 (one) " example is quoted " (IR) son field 2240c with the value of " being cited " attribute 2240 of " type " field 2237 of checking RSTIM_RSTMT_rec record 2231, " object is cited " that perhaps has the "Yes" of equaling be son field 2240d (RO).If then control forwards step 2556 to; Otherwise control forwards step 2547 to.

In step 2556, carry out test, whether equal " template " or " recurrence element " or " recurrence template " with the value of " character " attribute 2241 of " type " field 2237 of checking RSTIM_RSTMT_rec record 2231.If then control forwards step 2558 to; Otherwise control forwards step 2557 to.

In step 2557, carry out test, with " unit " attribute 2239 of " type " field 2237 of checking RSTIM_RSTMT_rec record 2231, " character " attribute 2241 of " type " field 2237 of RSTIM_RSTMT_rec record 2231, " information field 2 " field 2236 of RSTIM_RSTMT_rec record 2231, each value whether equal " unit " attribute 779 of " type " field 777 of RSTIM_STEIT_rec record 771, " character " attribute 771 of " type " field 777 of RSTIM_STEIT_rec record 771, " information field 2 " field 776 of RSTIM_STEIT_rec record 771, value.If then control forwards step 2547 to; Otherwise control forwards step 2558 to.

In step 2558, message informing gives a warning, so that owing to exist when in the future the existing STI that follows this RST definition of object or existing RSTI being carried out any renewal and will destroy the risk of these STI or these RSTI, so can not import current processed RST object (the RST object of replacement current definition under same names) to user notification.This typically can finish by show alert message in the pop-up window of display device 106 or status bar region, but also can use any other similar device, and does not break away from spirit of the present invention.Confirmed this notification message in case the user for example clicks any other similar device that is present in " determining " button in the alert message pop-up window or does not break away from spirit of the present invention with pointing device 105 by conventional apparatus, then controlled and forward step 2553 to.

Alternate embodiments

The method according to this invention and system can advantageously be applied in information element is organized in those environment of bidimensional table of vertical configuration.The method according to this invention and system can advantageously be applied in information element is organized in those environment more than the multidimensional table of bidimensional.Though by specifically showing with reference to preferred embodiment and described the present invention, those of ordinary skill in the art should be understood that and can make various changes in form with in detail and without departing from the spirit and scope of the present invention.

Claims

1. method that is used for computing machine, the object that is used for one or several is had its branch exports to the target electronic tables of data from the source spreadsheet, and described source spreadsheet comprises a plurality of objects with classification relationship; Said method comprising the steps of:

The definition object;

If described object is not associated with at least one subobject:

Definition branch quotes (FR) and equals 1;

If described object is associated with at least one subobject:

Definition branch quotes (FR) and equals following two product:

II _{I ∈ F}OR _i, wherein gather the set of F corresponding to the subobject that is associated with described object;

LCM ({ FR _i} _{) i ∈ S}Modulo OR=0, wherein S set is corresponding to the set of selected object;

LCM ({ FR _i} _{) i ∈ S}Modulo OR ≠ 0, wherein S set is corresponding to the set of selected object;

To select object and the selected object that sub-variable (SC) equals described first Boolean and export to target matrix.

2. according to the described method of last claim, wherein one or more parent objects or one or more subobject or both be may further comprise the steps with the step that each object is associated:

In the source data table, define recursive scalable template, recurrence element, scalable template, as object with classification relationship;

3. according to the described method of last claim, wherein recursive scalable template comprises the recurrence element, and it comprises one or more scalable templates; The recursive scalable template example comprises along the dimension ordering of first tables of data and alignment and according to recursive scalable template and the continuous recurrence element example of structurized variable number; Each recurrence element example has along the variable-size of described first tables of data dimension, and along the identical size of second tables of data dimension; Recurrence element example comprises one or more scalable template instances; Each scalable template instances of each recurrence element example aligns along described first tables of data dimension; Each scalable template instances in each recurrence element example aligns along second tables of data dimension; Scalable template instances comprises according to scalable template and the element of structurized variable number; Element is defined as data area; Data area comprises one or more data.

4. according to the described method of last claim, wherein recursive scalable template also comprises Header Section and/or Footer Section; The Header Section of recursive scalable template comprises the recurrence unit element of predefine number; The Footer Section of scalable template comprises the recurrence unit element of predefine number; Recurrence unit element comprises one or more scalable templates.

5. according to the described method of last claim, wherein that one or more parent objects or one or more subobject or both is further comprising the steps of with the step that each object is associated:

The one or more recurrence of definition unit element in the source data table;

One or more recurrence unit elements that are defined as subobject separately are associated with one or more recursive scalable templates that are defined as parent object separately;

One or more scalable templates that are defined as subobject separately are associated with the recurrence unit element that each is defined as parent object.

6. according to the described method of last claim, wherein that one or more parent objects or one or more subobject or both is further comprising the steps of with the step that each object is associated:

One or more element format of definition or element summary in the source data table;

The element format of subobject will be defined as or/and be defined as the element summary of subobject and be associated with the scalable template that each is defined as parent object.

7. according to each the described method in the aforementioned claim, further comprising the steps of:

Reception is used for one or more selected objects with its branch are imported to from the source data table importing order of target matrix;

Described one or more selected objects that will have the correlator object that is not defined in target matrix import to described target matrix from described source data table;

One or more parent objects or one or more subobject or each object that is imported among both are associated;

If described object is not associated with at least one subobject:

Definition branch quotes (FR) and equals 1;

If described object is associated with at least one subobject:

Definition branch quotes (FR) and equals following two product:

8. according to each the described method in the aforementioned claim, wherein spreadsheet is to comprise along each dimension, by the electrical form of a plurality of cells of cell address designation.

9. according to the described method of last claim, wherein scalable template comprises element format and/or element summary; Described scalable template comprises element format and/or element summary; Element format is the one or more attributes of a configuration of each cell definition in each element; The element summary is each cell definition cell content and the cell target in each element; Described cell target designating unit lattice are used to receive the input block lattice of input or the output unit lattice that are used to bear results; Element is defined as range of cells; Scalable template instances comprises the continuous element of variable number, and described continuous element has identical size, along given electrical form dimension and ordering and alignment, and according to described scalable template and structuring.

10. a system comprises being adapted to the device of execution according to each step of each the described method in the aforementioned claim.

11. a computer program comprises the instruction that is used for carrying out according to each step of each described method of claim 1 to 9 when carrying out described computer program.