CN101393549A - Method and system for modifying table element displaying attribute - Google Patents
Method and system for modifying table element displaying attribute Download PDFInfo
- Publication number
- CN101393549A CN101393549A CNA2007101534504A CN200710153450A CN101393549A CN 101393549 A CN101393549 A CN 101393549A CN A2007101534504 A CNA2007101534504 A CN A2007101534504A CN 200710153450 A CN200710153450 A CN 200710153450A CN 101393549 A CN101393549 A CN 101393549A
- Authority
- CN
- China
- Prior art keywords
- table element
- size
- attribute
- server
- new
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention relates to a method for modifying a display attribute of a table element and a system thereof. The method for modifying the display attribute of the table element comprises the following steps: a command for modifying the display attribute of at least one table element is received; a table element relevant to the element is searched; and the display attributes of the table element and the relevant table element are modified. The method and the system thereof improve the operations of adjusting the display attribute of the table and increase the efficiency and accessibility of operations.
Description
Technical field
The present invention relates generally to computer realm, particularly revise the method and system of the display properties of table element.
Background technology
Multidimensional data table and zooming table are the data analysis tools of using always.Data in multidimensional data table and the zooming table are interrelated usually.For example, the member of multidimensional data table can be used as a lot of examples (have the row of same names or implication/OK) and shows when it is expanded.The user browses in the data of multidimensional data table and zooming table, thus the data of analysis.
When multidimensional data table and zooming table displaying data, the display format of its element not necessarily meets user's requirement.The user will adjust each attribute of an element according to the requirement of oneself usually.For example, when data presented was very big, the size of data cell was big inadequately, can not show whole data.Like this, the size of data cell needs to adjust, thereby total data can be shown.Be of a size of example to adjust form, the adjustment mode of existing multidimensional data table and zooming table is as follows:
1. the form among the Microsoft Excel is adjusted size
In zooming table application program (for example excel), adjusting the form size is to adjust the size of row or column separately, rather than adjusts size according to the member.In addition, in most applications, current Microsoft Excel as based on the application of web or as the Activex assembly, does not distribute on network, does not use the client/server technology in network environment.
2. in multidimensional data table, adjust size based on web
In most of web form solutions (or even using the AJAX technology), it is that column or row are set size individually that the adjustment size is based on, and it also is not used in the person's of being adjusted to size, and is not used in processing multidimensional level or father member.
There is the defective of some in prior art.Adjust the solution of size for the column or row that do not use the member, owing to do not utilize the incidence relation between the member, being adjusted into the such operation of same size for all row/row that will have identical member Name carries out respectively, identical operations need repeat repeatedly, and such operating efficiency is lower and inconvenient.In addition, the size of various level data cell is not carried out respective handling afterwards at browsing data (for example go up and bore (drill up), brill (drill down), rotation (pivot) down).As be provided with the size of father's hierarchical data lattice, should not have influence on the size of child level data lattice after last the boring.Under bore similar.Just might interact at size setting processing method based on the ranks position.The adjusted size that great majority are used for form can not be used for the multidimensional form, and it can not solve adjusted size in the multidimensional level, and can not handle father member's size.
In large-scale analytical statement, certain data analysis table as certain bank, the loaning bill situation that the site is showed in requirement per year, column heading has two row, first row is organizational structure's dimension, second row is time dimension (year), the corresponding row of the combination in each site and a certain year, because this bank is provided with hundreds and thousands of sites, promptly words of launching on this dimension of organizational structure have hundreds and thousands of members, and promptly form shows to have hundreds and thousands of row at least, if desired with a certain year (as 2002) representative the width unification of row adjust to a certain width (as 200 pixels), if adjust by row, this is unusual poor efficiency and very inconvenient.Therefore, need a kind of row adjusting form and/display properties of row, all related column and/display properties of row all adjusts to the method for same parameter automatically.
Summary of the invention
Can not satisfy final user's needs are adjusted attribute efficiently and easily on form demand at current solution, an object of the present invention is to improve the operation of adjusting the form display properties, improve the efficient and the ease for use of operation.
According to an aspect of the present invention, provide a kind of method of revising the display properties of table element, comprise the order that reception is made amendment to the attribute of a table element; Search the table element that is associated with described element; Revise the attribute of this table element and the described table element that is associated.
According to another aspect of the present invention, provide a kind of system of revising the display properties of table element, comprising: receiving trap is used to receive the order that the attribute of at least one table element is made amendment; Search device, be used to search the table element that is associated with described element; Modifier is revised the attribute of this table element and the described table element that is associated.
According to the present invention, when the user need adjust the display properties of table element, in the form not only the display properties of the element of user's appointment adjust, also carry out identical adjustment with other elements that designed element is associated.For the user, the present invention adjusts display properties in multidimensional form and zooming table be very efficient with easily.
For based on the multidimensional form of web (its client normally DHTML (dynamic HTML)), the user wishes and can like the size of coming definition tables element (ranks or cell) according to it, this is carrying out data manipulation and is for example boring down/on particularly useful when brill, rotation etc.In the present invention, handle adjusted size, all examples of dimension member are adjusted size with the relevance of dimension level.The present invention can also handle simultaneously in the tuple level member or with the adjusted size of the father member in the one dimension layer.
In addition, the server among the present invention is optimized the performance of adjusting, and for example server is added up adjusting the data cell that is influenced, and what decision send to client (whole form, part form or the like) to obtain superperformance with.
In addition, the present invention adjusts scroll bar after the size of adjusting table element, keeps user's current window invariant position, further improves convenience.
Description of drawings
By shown embodiment in conjunction with the accompanying drawings is elaborated, above-mentioned and other features of the present invention will be more obvious, and identical label is represented same or analogous parts in the accompanying drawing of the present invention.In the accompanying drawings,
Fig. 1 illustrates the synoptic diagram of adjusting the preceding multidimensional form of size;
Fig. 2 illustrates the synoptic diagram of the dialog box of importing the size of revising table element;
Fig. 3 illustrates the synoptic diagram of the multidimensional form after the adjustment size;
Fig. 4 illustrates the process flow diagram of method of the display properties of modification table element according to an embodiment of the invention;
Fig. 5 a and 5b are illustrated in and search the unit that will revise and the detail flowchart of revising unit size on the server.
Fig. 6 illustrates the block diagram of system of the display properties of modification table element according to an embodiment of the invention;
Fig. 7 illustrates the block diagram of system of the display properties of modification table element according to another embodiment of the invention;
Fig. 8 illustrates the block diagram that is suitable for implementing computer system of the present invention.
Tool is stopped embodiment
In the present invention, form is the multidimensional form that uses in data analysis application.The multidimensional form is a kind of a plurality of title column or row that show in the level mode that have.Each title column or row is regarded as a dimension (dimension), and the element in the dimension is member (member).The member can have a lot of examples (have the row of same names/OK) to show when it is expanded.Tuple (tuple) is the unique combination from a plurality of members of different dimensions.
Fig. 1 illustrates the synoptic diagram of adjusting the preceding multidimensional data table of size, and wherein member's " All AllProducts:All Has Nuts:All Time (Fiscal) " current size is 100.The unit of width that relates to herein or height is pixel (px).With reference to figure 1, this form has dimension Product, Has Nuts, Time (Fiscal), Date Opened and Chocolate Type.Wherein tieing up Time (Fiscal) has 4 member All Time (Fiscal), 2000,2001 and 2002, and dimension Chocolate Type has 5 member All Chocolate Type, Dark, Milk, NotChocolate and White.All All Products:All Has Nuts:AllTime (Fiscal) constitutes a tuple in this table, and All All Products:false:All Time (Fiscal) constitutes another tuple.
Fig. 2 illustrates the synoptic diagram of dialog box that the size of table element is revised in input, and wherein the modification of dimension that provides member " All All Products:All Has Nuts:All Time (Fiscal) " of user is " 150 ".
Fig. 3 illustrates the synoptic diagram of the multidimensional data table after the adjustment size, and the size of wherein tieing up all members " All Time (Fiscal) " of Time (Fiscal) has been revised as 150.For example " All AllProducts:All Has Nuts:All Time (Fiscal) " place row and " All All Products:false:All Time (Fiscal) " row at place.Fig. 1-3 has shown the demonstration effect of the method for the display properties of revising table element.
Fig. 4 illustrates the process flow diagram of method of the display properties of modification table element according to an embodiment of the invention.
In step 401, in browser, open the page with multidimensional form.This multidimensional form video data, and can carry out that various operational example are as above bored, bored down to data, rotation and show/hide or the like.When should be appreciated that the multidimensional form that shows in the browser, all information of preserving the multidimensional form on the server that the data analysis service is provided comprise each dimension, member, tuple, data or the like.
In step 402, receive the order that the size of a table element is made amendment.The user is with defining new size with the border that mouse pulls header cell or data cell.Perhaps, the user can import new size value in dialog box as shown in Figure 2.Should be appreciated that the user can give a plurality of members (for example a plurality of row or column) definition new size simultaneously.
In step 403, the order that browser will receive is sent to server.This step can realize in the following ways:
Interpolation incident " modification of dimension incident " is to send message from user end to server.Use JavaScript, HttpRequest and XML request between client and server, to send message.
Adjust the size order and be included among the XML, and send to server from client by using HttpRequest.It is also resolved and be assigned to suitable event handler (for example controller), is somebody's turn to do to handle " size changes action ".The request of modification can be following structure:
Component: drag the cell ID that carries out adjusted size, this ID is kept at server end being generated by server end, and is sent to client when generating the demonstration form
Direction: show row or row carries out adjusted size, 0 expression row, 1 expression row is not if specify then the cell of judging the Component representative is expert at or is listed as.
Sizechanged-UIDS: sizes of memory is with the UID (a plurality of UID are with CSV) of the header cell UID that is adjusted
Sizechanged-sizes: the target size (a plurality of sizes with CSV, corresponding) of storage column or row with Sizechanged-UIDS.
Sizedcell_position_info: the positional information before sizes of memory is adjusted, to recover its position, this positional information should be the character string of being separated by comma, for example:
Arr[1]: the line pointer of unit, pointer were counted from start of header, first behavior 0
Arr[2]: the column pointer of unit, pointer was counted from start of header, and first classifies 0 as
Arr[3]: the horizontal-shift position (offsetLeft) of cell in data cells view (not comprising the gauge outfit ranks), if the unit is a row headers, then value should be-1
Arr[4]: the vertical shift position (offsetTop) of cell in data cells view (not comprising the gauge outfit ranks), if the unit is a column heading, its value should be-1
Arr[5]: the deviation post of HScrollBar in the active sheet view
Arr[6]: the deviation post of vertical scroll bar in the active sheet view
If enlarge its width to 150 pixels as the right margin that drags header cell lattice All All Product:All Has Nuts:All Time (Fiscal) (ID of this cell is 1010) in Fig. 1, the modification size request command of generation can be following example:
<request>
<Component>1010</Component>
<Direction>0</Direction>
<Sizechanged-UIDS>1010</Sizechanged-UIDS>
<Sizechanged-sizes>150</Sizechanged-sizes>
<Sizedcell_position_info>-1，2，0，-1，0，0</Sizedcell_position_info
>
</request>
The structure of above-mentioned modification request is preferred embodiment a kind of, and those skilled in the art can define other analog structure according to said structure, thereby finish identical functions.
In step 404, after server received the request revised, analysis request message obtained the modification order of user's appointment, for example the scope of appointment, new modification value or the like.Afterwards, the table element that is associated with the element of specified modification of whois lookup.For example, search the tuple that the member who is adjusted is had other members of same names with size.After finding relevant tuple, the size of header cell in the tuple and data cell is set at new size.Simultaneously, correspondingly the size of the header cell in the level is adjusted.And handle the member's of last layer in the member's who will revise the same tuple time size.This respect content will be described in detail in conjunction with the accompanying drawings.
In step 405, preserve the record of revising size.For example, preserve original size and new size, revise the scope of using, revise the form of attribute etc.During form before the user wishes to repeat identical modification or returns, the record that can click modification is to carry out the operation of using.When creating or rebuild form, also the attribute of preserving can be applied to form in addition.Preserving form can be following structure:
Preserving form is the character string of following form:
group＝”name1”，width＝”100”，scope＝”{Product：coke}”
1. keeping records title group can not establish, and perhaps can generate according to scope (scope) yet
2. width (width): the new width of appointment.Cell in only being applied to be listed as.Can adopt the information specific hidden unit lattice of indicating.
The height (height): the new high degree of appointment.Only be applied to cell in the row.Can adopt the information specific hidden unit lattice of indicating.
4. scope (scope): the size range of application of appointment
Scope is appointed as follows:
Scope＝{d0:m00[，m01，...m0n]}{d1:m10[，m11，...m1n]}...]
D0 wherein, d1 represents dimension, m00, m01, m0n, m11, m1n represent the member in this dimension
For example, for Essbase (a kind of multidimensional data management software products) data source:
Scope＝{Product:coke}{Scenario:Acutal，budget}
Wherein Product and Scenario are dimension name.Coke is the member of Product, and Actual and budget are the members of Scenario.
For Microsoft's Analysis Service (the multidimensional data management software products of Microsoft Analysis Microsoft) or SAP BW (another kind of multidimensional data management software products) data source, use unique name, as follows:
Scope＝{[Product]:[Product].[code]}{[Scenario]:[Scenario].[Actual]，[Scenario].[Budget]}
Above multidimensional data management software products provide the function of the data of storage and inquiry multidimensional form.
As the command record after the adjusted size among Fig. 1-3 should be following form:
group＝”All?Time(Fiscal)”，width＝”150”，scope＝”{Time(Fiscal):AllTime(Fiscal)}”
In step 406, described server is sent to client with amended table element.When unit size changes, register this change in the variation register office of form.When creating response message, generate the unit that the size that will present changes with td in the html language (cell) or th (header cell lattice) label for XML request.These changes are included in the text string, to be sent to client by the AJAX technology.
In step 407, browser is revised the list cell of user's appointment and the size of correlation unit after receiving new size.In client, browser is assigned this response message, and the sub-district of finding all to upgrade.For each unit that need upgrade, utilize new each td or the th of substituting.Adjust a little then and the form that aligns.
Like this, in the present invention, when a member's of user's specified modification size, not only the member's of user's appointment size is modified, and the member relevant with the member of appointment also revises simultaneously.Make the user when carrying out data analysis, needn't repeat identical operations like this to the member who is associated.
In step 408, calculate the new position of scroll bar according to new size.The proportionate relationship of the overall height/width of scroll bar indication active sheet unit and form.When the user had changed the size of data list element, the overall height/width of form also changed thereupon.The position of scroll bar also should change thereupon, and with corresponding with new size, the position that makes the form size change front and back user's current window remains unchanged.
Fig. 5 a and 5b are illustrated in and search the unit that will revise and the detail flowchart of revising unit size on the server.Should be appreciated that the flow process shown in Fig. 5 a and the 5b is the embodiment of step 404-406 among Fig. 4.Server receive revise message after, searching the table element that is associated with described element and the modification of the table element size that is associated is sent to client to have multiple mode to realize.
In step 501, at first the HttpRequest that browser in the modification of dimension incident is sent resolves and utilizes the class of control form property operations on server to upgrade.
In step 502, initializing variable particularly will be adjusted size and all handle successful sign Sizing_Completed and be made as very.
In step 503, because user's size of the many members of specified modification simultaneously, therefore be circulated to the step of step 512 for each header cell that will revise size.
In the multidimensional form, header cell can be in a plurality of tuples.Like this, in step 504, obtain its all tuples.
In step 505, in all tuples, search the tuple that has identical member Name with the header cell that is modified size.
In step 506, circulation beginning: write operation to step 511 for each tuple circulation with identical member Name.
In step 507, has identical member Name's tuple for each, with its title and the data cell number that is set at new size and the statistics unit that will upgrade.
In step 508, will be added to counter by varying sized element count.
In step 509, judge that whether counter is greater than threshold value.Threshold value for example can be made as 500 according to the response time factor of browser.Whether the element number that judgement will change surpasses threshold value is in order to improve system performance.Because there is too many unit to need when varying sized, browser updating block lattice can be very slow or be occurred dying or phenomenon that internal memory overflows.When the speed of upgrading was too slow, its performance was not as refreshing the performance of whole form.
If the cell that changes outnumbers threshold value,, Sizing_Completed is changed to vacation then in step 510.
In step 511, for the loop ends of each tuple.
In step 512, will change the loop ends of the header cell of size for each.
Next, judge that in step 513 Sizing_Completed is true.
If Sizing_Completed is true,, the size of the header cell of the row or column of being crossed over is set then in step 514.
If Sizing_Completed is false, then direct execution in step 515.
In step 515, generate the record of adjusting size attribute, store memory storage into.
Do you in step 516, judge that Sizing_Completed is true? if Sizing_Completed is true, then process finishes.
If Sizing_Completed is false, then carries out following steps and upgrade whole form.
In step 517, scroll bar information is saved in form in will ordering.
In step 518, call method that form creates again to activate the reconstruction of form.
More than be of a size of example method of the present invention be described to change list cell.Should be appreciated that the present invention is not limited to change the size of unit.The present invention can be used to change other display properties of list cell equally, for example, and font, font size, font color, foreground/background color, lines attribute or the like.
In addition, in the foregoing description, judge that the member who is associated carries out at server end.In client (browser), realize judging that related member also is possible.For example, if the content of the header cell in the tuple is identical, judge that then they are the members that are associated.Certainly, this mode may be inaccurate.Because have the member of same title content may not be related.Provide the information that the member that is associated is arranged in the server of multidimensional form service, thereby the judgement of server end is accurately.Another method is brought in the client and is judged that related member can be placed on the identifier (id) of server end information about firms in the client header cell, can should identically judge related member according to identical member's identifier (id).
More than the present invention is described in the implementation under the client/server environment.The zooming table that the present invention equally also can be applicable to unit or cooperates in network.In addition, a plurality of row or column that can set the zooming table are the title row or column, with simulation multidimensional data table.Below to realizing that in the zooming table the present invention describes.
Existing each row/row of zooming table or unit directly there is no incidence relation.In the present invention, can in each row/row of zooming table or unit, increase an attribute, to indicate other elements that are associated with this table element.Certainly, also can judge the content of header line/row,, judge that then they are the row/row that are associated if content is identical.
In having revised the zooming table, behind the display properties of an element, obtain other elements that are associated with this element.The attribute of an element that is associated is carried out same modification, the process of attribute of an element thereby the simplification user's modification is associated.
Fig. 6 illustrates the block diagram of system of the display properties of modification table element according to an embodiment of the invention.System shown in Figure 6 comprises client 610 and server 620.Client 610 comprises receiving trap 611, client network interface 612 and modifier 613.Server 620 comprises server network interface 621, and updating device 622 is searched device 623 and memory storage 624.
Behind multidimensional form of the browser display of client 610, receiving trap 611 receives the order that the display properties of a multidimensional table element is made amendment.Client network interface 612 order that will receive afterwards is sent to server network interface 621 by HttpRequest.The updating device 622 of server 620 is at first with the command analysis that receives, and searches with the member who is modified form and the member of same names is arranged as the table element that is associated by searching device 623.Updating device 622 upgrades that users specify the table element of renewal and the attribute of the table element that is associated.Afterwards, updating device 622 is included in the change of all elements in the text string, to be sent to client network interface 612 by for example AJAX technology.The modifier 613 of client 610 is according to the modification order that receives, the table element that finds all to upgrade.For each table element that need upgrade, thereby utilize the new attribute that each td or th revise this table element and the described table element that is associated that substitutes.
In addition, the updating device 622 of described server 620 is further judged the number of the table element that is associated; If the number of the table element that is associated surpasses predetermined value, the whole table that then will have new attribute is sent to client 610.The modifier 613 of client 610 upgrades whole table.
In addition, when described form is multidimensional form and described attribute when being the size of table element, described updating device 622 further calculates the new sizes of going up the member place table element of one dimension layer in the tuples; Correspondingly revise the size that goes up the member place table element of one dimension layer in the tuple with modifier 613.
In addition, when described attribute was the size of table element, described updating device 622 calculated the new position of scroll bar according to new size; With modifier 613 according to new position renewal scroll bar, with the invariant position of user's current window before and after keep upgrading.
Fig. 7 illustrates the block diagram of system of the display properties of modification table element according to another embodiment of the invention.This embodiment illustrates the situation that the present invention is applied to the zooming table.
Zooming meter apparatus 700 can be a unit zooming table or the zooming table of cooperating in network environment.Be that example describes only in the present embodiment with unit zooming table.Zooming meter apparatus 700 comprises associated apparatus 711, receiving trap 712, searches device 713, modifier 714 and memory storage 715.
Associated apparatus 711, specifying row/row or unit in the form is the element that is associated.Receiving trap 712 receives the order that the attribute of a table element is made amendment.Search device 713 and search the table element that is associated with described element according to associated apparatus 711 specified incidence relations.Modifier 714 is revised the attribute of this table element and the described table element that is associated afterwards.Memory storage 715 is used to preserve the record of revising attribute.When creating or rebuild form, modifier 714 is applied to form with the attribute of preserving.
Fig. 8 has schematically shown and can realize the block diagram of computing equipment according to an embodiment of the invention.
Computer system shown in Fig. 8 comprises CPU (CPU (central processing unit)) 801, RAM (random access memory) 802, ROM (ROM (read-only memory)) 803, system bus 804, hard disk controller 805, keyboard controller 806, serial interface controller 807, parallel interface controller 808, display controller 809, hard disk 810, keyboard 811, serial external unit 812, parallel external unit 813 and display 814.In these parts, what link to each other with system bus 804 has CPU 801, RAM 802, ROM 803, hard disk controller 805, keyboard controller 806, serial interface controller 807, parallel interface controller 808 and a display controller 809.Hard disk 810 links to each other with hard disk controller 805, keyboard 811 links to each other with keyboard controller 806, serial external unit 812 links to each other with serial interface controller 807, and parallel external unit 813 links to each other with parallel interface controller 808, and display 814 links to each other with display controller 809.
Each functions of components all is well-known in the present technique field among Fig. 6, and structure shown in Figure 6 also is conventional.This structure not only is used for personal computer, and is used for handheld device, as Palm PC, PDA (personal digital assistant), mobile phone or the like.In different application, for example be used to realize to include according to the user terminal of client modules of the present invention or when including server host according to network application server of the present invention, can add some parts to the structure shown in Fig. 6, perhaps some parts among Fig. 6 can be omitted.Total system shown in Fig. 6 by usually be stored in the hard disk 810 as software or be stored in EPROM or other nonvolatile memory in computer-readable instruction control.Software also can be downloaded from the network (not shown).Perhaps be stored in the hard disk 810, perhaps the software from network download can be loaded into the RAM 802, and is carried out by CPU801, so that finish the function of being determined by software.
Although the computer system of describing among Fig. 6 can support that this computer system is an example of computer system according to the scheme of Web content for the off line use that provide of the present invention.It will be apparent to those skilled in the art that many other Computer System Design also can realize embodiments of the invention.
The present invention for example can also be embodied as by the employed computer program of computer system shown in Figure 6, and it can include and be used to realize the code that provides the network application server that Web content uses for off line according to of the present invention; It can also include and be used to realize the code that is used to obtain the client modules that Web content uses for off line according to of the present invention.Before using, can code storage in the storer of other computer system, for example, be stored in hard disk or the movably storer such as CD or floppy disk, perhaps download via the Internet or other computer network.
Disclosed method of the present invention can realize in the combination of software, hardware or software and hardware.Hardware components can utilize special logic to realize; Software section can be stored in the storer, and by suitable instruction execution system, for example microprocessor, personal computer (PC) or large scale computer are carried out.
Though described the present invention, should be appreciated that to the invention is not restricted to the disclosed embodiments with reference to the embodiment that considers at present.On the contrary, the present invention is intended to contain various modifications and equivalent arrangements included within the spirit and scope of claims.The scope of following claim meets broad interpretation, so that comprise all such modifications and equivalent structure and function.
Claims (16)
1. method of revising the display properties of table element comprises:
The order that reception is made amendment to the display properties of at least one table element;
Search the table element that is associated with described element;
Revise the display properties of this table element and the described table element that is associated.
2. method as claimed in claim 1 further comprises:
The order that receives is sent to server;
The table element that described whois lookup is associated with described element;
Described server is sent to client with the modification of the table element attribute that is associated.
3. method as claimed in claim 2, wherein
The number of the table element of the further statistical dependence connection of described server;
If the number of the table element that is associated surpasses predetermined value, the whole form that then will have new attribute is sent to client;
Client is upgraded whole form.
4. method as claimed in claim 1 further comprises:
When described form was the multidimensional form, what search was with the member of same names or implication being arranged as the table element that is associated with the member who is modified the table element representative in the one dimension level.
5. method as claimed in claim 1 further comprises:
When described attribute is the size of table element, calculate the new position of scroll bar according to new size;
According to new position renewal scroll bar, make the position of user's current window of the scroll bar indication before and after the attribute changes to remain unchanged.
6. according to the method for claim 1, further comprise:
When described form is multidimensional form and described attribute when being the size of table element, further calculate with the new size of going up the member place table element of one dimension layer in the tuple;
Correspondingly revise with the size that goes up the member place table element of one dimension layer in the tuple.
7. according to the method for claim 1, further comprise:
Preserve the record of revising attribute;
When creating or rebuild form, the attribute of preserving is applied to form.
8. according to the method for claim 1, further comprise:
Specifying the element in the form is the element that is associated.
9. system of revising the display properties of table element comprises:
Receiving trap is used to receive the order that the display properties of at least one table element is made amendment;
Search device, be used to search the table element that is associated with described element;
Modifier is revised the display properties of this table element and the described table element that is associated.
10. system as claimed in claim 9 further comprises:
Network Interface Unit, the order that is used for receiving is sent to server;
The device of searching in the described server is further searched the table element that is associated with described element;
Updating device in the server is with the table element attribute modification that is associated and be sent to client.
11. as the system of claim 10, wherein
Described updating device is further judged the number of the table element that is associated;
If the number of the table element that is associated surpasses predetermined value, the whole form that then will have new attribute is sent to client;
Modifier upgrades whole form.
12. system as claimed in claim 9 further comprises:
When described form was the multidimensional form, described what search that device searches was the table element of identical member Name or implication to be arranged as the table element that is associated with the dimension member who is modified the table element representative.
13. system as claimed in claim 9 further comprises:
When described attribute was the size of table element, described updating device calculated the new position of scroll bar according to new size; With modifier according to new position renewal scroll bar.
14. the system according to claim 9 further comprises:
When described form is multidimensional form and described attribute when being the size of table element, described updating device further calculates with the new size of going up the member place table element of one dimension layer in the tuple; Described modifier is correspondingly revised with the size that goes up the member place table element of one dimension layer in the tuple.
15. the system according to claim 9 further comprises:
Memory storage is used to preserve the record of revising attribute; With
When creating or rebuild form, modifier is applied to form with the attribute of preserving.
16. the system according to claim 9 further comprises:
Associated apparatus, the element that is used to specify in the form is the element that is associated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007101534504A CN101393549A (en) | 2007-09-19 | 2007-09-19 | Method and system for modifying table element displaying attribute |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007101534504A CN101393549A (en) | 2007-09-19 | 2007-09-19 | Method and system for modifying table element displaying attribute |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101393549A true CN101393549A (en) | 2009-03-25 |
Family
ID=40493847
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007101534504A Pending CN101393549A (en) | 2007-09-19 | 2007-09-19 | Method and system for modifying table element displaying attribute |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101393549A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104657430A (en) * | 2015-01-28 | 2015-05-27 | 武汉烽火众智数字技术有限责任公司 | Method and system for data acquisition |
| CN106570045A (en) * | 2015-10-13 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Data operation control method and system and user terminals |
| CN106886511A (en) * | 2016-06-21 | 2017-06-23 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of network form |
| CN108388462A (en) * | 2018-02-28 | 2018-08-10 | 武汉斗鱼网络科技有限公司 | Element alteration notification method, device and terminal device |
| CN109716330A (en) * | 2016-09-16 | 2019-05-03 | 甲骨文国际公司 | For managing the technology of the display on the head in electronic document |
| CN114463766A (en) * | 2021-07-16 | 2022-05-10 | 荣耀终端有限公司 | Form processing method and electronic equipment |
-
2007
- 2007-09-19 CN CNA2007101534504A patent/CN101393549A/en active Pending
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104657430A (en) * | 2015-01-28 | 2015-05-27 | 武汉烽火众智数字技术有限责任公司 | Method and system for data acquisition |
| CN106570045A (en) * | 2015-10-13 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Data operation control method and system and user terminals |
| CN106886511A (en) * | 2016-06-21 | 2017-06-23 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of network form |
| CN106886511B (en) * | 2016-06-21 | 2020-03-31 | 阿里巴巴集团控股有限公司 | Network table processing method and device |
| CN109716330A (en) * | 2016-09-16 | 2019-05-03 | 甲骨文国际公司 | For managing the technology of the display on the head in electronic document |
| CN109716330B (en) * | 2016-09-16 | 2023-07-18 | 甲骨文国际公司 | Method, system and apparatus for managing display of headers in electronic documents |
| CN108388462A (en) * | 2018-02-28 | 2018-08-10 | 武汉斗鱼网络科技有限公司 | Element alteration notification method, device and terminal device |
| CN114463766A (en) * | 2021-07-16 | 2022-05-10 | 荣耀终端有限公司 | Form processing method and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106796578B (en) | Autoknowledge system and method and memory | |
| US7251776B2 (en) | System and method for efficiently and flexibly utilizing spreadsheet information | |
| US10540434B2 (en) | Dynamic disaggregation and aggregation of spreadsheet data | |
| US7613688B2 (en) | Generating business warehouse reports | |
| TWI591496B (en) | Generate, update the the pages of methods and equipment | |
| US8798969B2 (en) | Machine learning for a memory-based database | |
| US20030195873A1 (en) | Identifier vocabulary data access method and system | |
| JP5570608B2 (en) | Excel-based analysis report creation system and method | |
| CN111259303A (en) | System and method for automatically generating front-end page of WEB information system | |
| WO2002061622A9 (en) | Technique for encapsulating a query definition | |
| US10613841B2 (en) | Task UI layout representing semantical relations | |
| WO2008070240A2 (en) | Data charting with adaptive learning | |
| ZA200503578B (en) | Adaptively interfacing with a data repository | |
| JP2013077246A (en) | Method, apparatus, and program for supporting creation and management of metadata for correcting problem in dynamic web application | |
| CN101393549A (en) | Method and system for modifying table element displaying attribute | |
| US20070294631A1 (en) | Apparatus and method for embedding and utilizing report controls within an online report | |
| US7587416B2 (en) | Advanced desktop reporting | |
| US20050234886A1 (en) | Report designer tool and method | |
| US20090199158A1 (en) | Apparatus and method for building a component to display documents relevant to the content of a website | |
| US20110184975A1 (en) | Incorporated web page content | |
| CN110737432A (en) | script aided design method and device based on root list | |
| US20080263018A1 (en) | Method and System for Mapping Business Objects to Relational Database Tables | |
| US7185002B1 (en) | Systems and methods for data retrieval, manipulation, and delivery | |
| Verbruggen et al. | Automatically wrangling spreadsheets into machine learning data formats | |
| US7349918B2 (en) | Method and system for searching binary files |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20090325 |