CN105122238A - Non-collaborative filters in a collaborative document - Google Patents

Non-collaborative filters in a collaborative document Download PDF

Info

Publication number
CN105122238A
CN105122238A CN201480021515.8A CN201480021515A CN105122238A CN 105122238 A CN105122238 A CN 105122238A CN 201480021515 A CN201480021515 A CN 201480021515A CN 105122238 A CN105122238 A CN 105122238A
Authority
CN
China
Prior art keywords
filtrator
worksheet
client computer
user
order
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201480021515.8A
Other languages
Chinese (zh)
Other versions
CN105122238B (en
Inventor
B·W·西蒙
M·特拉格特
Z·E·劳埃德
J·A·丹齐格
D·冈德拉姆
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Google LLC
Original Assignee
Google LLC
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Priority claimed from US13/900,270 external-priority patent/US9298688B1/en
Priority claimed from US13/900,265 external-priority patent/US8943142B1/en
Priority claimed from US13/900,193 external-priority patent/US9361287B1/en
Application filed by Google LLC filed Critical Google LLC
Priority to CN201811294207.9A priority Critical patent/CN109635258B/en
Publication of CN105122238A publication Critical patent/CN105122238A/en
Application granted granted Critical
Publication of CN105122238B publication Critical patent/CN105122238B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Abstract

Systems and methods for viewing filters on a collaborative spreadsheet stored on a cloud computing service include accessing, from each of a plurality of client computers, a first sheet of a spreadsheet stored on a cloud computing service, where a plurality of filters is associated with the first sheet. A first client computer in the plurality of client computers receives a command by a first user to apply a first filter in the plurality of filters to the first sheet, and applies the first filter to the first sheet on the first client computer. The filtered first sheet is displayed to the first user, and a second client computer in the plurality of client computers concurrently displays an unfiltered first sheet.

Description

Non-cooperating filtrator in collaborative document
the cross reference of related application
This application claims the right of priority of the U.S. Patent Application No. 13/900,193 that on May 22nd, 2013 submits to, by reference its entirety is incorporated into this; The right of priority of the U.S. Patent Application No. 13/900,265 that on May 22nd, 2013 submits to, is incorporated into this by its entirety by reference; And the right of priority of the U.S. Patent Application No. 13/900,270 of submission on May 22nd, 2013, by reference its entirety is incorporated into this.
Background technology
Cloud computing service provides the method for cooperation identical document to multiple people of multiple position.The primary copy of document is stored on one or more data server by cloud computing service, and user visits document by the telecommunication network of such as the Internet and so on.The document that can create on cloud computing service, store and edit comprises word processing document, presentation file and electrical form.When user's access is stored in the document on cloud computing service, the local replica of document is loaded on client computers.User is communicated to cloud computing server with record to the change that document is made.If two or more teamworkers edit identical document just at the same time, then the change that user makes also promptly propagates into other users.
On cloud computing service, addressable cooperation electrical form can have the identical function of many and available on stand-alone computer electrical form.Obtainable function can comprise and uses filtrator to change and how to arrange and to show data.Such as, filtrator can be used to sort to the row or column of data in some way, and can be used to hide some row or column from view.Other variation of inserting as such as cell entry and row/column or delete and so on, filtrator can be regarded as editor to worksheet or variation.When the user editing cooperation electrical form is to spreadsheet application filtrator, filtrator is also sent to other teamworkers and is applied to their electrical form copy.Thus when user's apply filters, the view of the electrical form of teamworker will change automatically.For other teamworkers checking the data affected by filtrator, this may be hinder.In addition, if two or more teamworkers want the different filtrators applying the overlapping data set of impact, two teamworkers have no idea to apply the filtrator expected and do not interfere with each other.Equally, the teamworker of electrical form has no idea to store multiple filtrator and apply filters independently of each other.
Summary of the invention
System and method described herein is provided for the method that multiple teamworker utilizes the filtrator of the electrical form stored on cloud computing service independently.Cloud computing service stores its electronic form file that can comprise one or more worksheets of cell.Cloud computing service also stores the some filtrators for each worksheet.Filtrator can be created by any teamworker had the write access of electrical form and preserved.Filtrator can being for sorting, hiding or the instruction of the row that otherwise arranges in the display of worksheet and cell.User on client computer loads local replica from the worksheet of the electrical form of cloud computing service and the filtrator that is associated thereof.Worksheet is displayed in the user interface at client computer place, such as, in web browser.Available filtrator may be displayed on hurdle, side window.When user selects to be applied to the filtrator of worksheet, filtrator is only applied to the local replica of worksheet and shows to user.Unlike the normal editor of worksheet, filtrator is selected to be communicated to other teamworkers.Cloud computing service can follow the tracks of the current filtrator just used of different teamworker, but the primary copy of the worksheet stored is not by the impact that the user of filtrator selects.User can arrange the acquiescence filtrator for worksheet, can remove all filtrators being applied to worksheet, and can create, edits, rename, copy or delete filtrator.The editor to worksheet after filtration made by user or variation can with reference to non-filterer's tabulation or worksheets and being stored by client computer after filtration.If variation is with reference to non-filterer's tabulation, then variation can be sent straight to cloud computing service for storing and being sent to other teamworker's client computer, before showing variation to teamworker, other teamworker's client computer converts variation according to any filtrator that teamworker's client computer is applied.If variation reference worksheet after filtration, then, before being sent to cloud computing service and teamworker's client computer, according to the inverse of filtrator, they are converted.Thus multiple teamworker can check the multiple filtrators being applied to same worksheet simultaneously.
The open method for checking the filtrator on the cooperation electrical form that cloud computing service stores in an aspect described herein.Method comprises the first worksheet of the electrical form stored from each client computer access cloud computing service multiple client computer, and wherein multiple filtrator is associated with the first worksheet.Method comprises further: the first client computer place in multiple client computer receives the order for applying the first filtrator in multiple filtrator to the first worksheet of first user; And apply the first filtrator to the first worksheet on the first client computer.Method comprises further to filtered first worksheet of first user display, and the second client computer wherein in multiple client computer shows unfiltered first worksheet concomitantly.
The method of the open filtrator for creating the cooperation electrical form stored on cloud computing service of another aspect described herein.Method comprises: from the first worksheet of the electrical form that each client computer access cloud computing service multiple client computer stores; And the first client computer in multiple client computer creates the first filtrator, the user wherein on the first client computer defines the first filtrator.Method comprises further: apply the first filtrator to the first worksheet on the first client computer, and the second client computer wherein in multiple client computer shows unfiltered first worksheet concomitantly; And send the first filtrator to cloud computing service, for storing and being associated with the first worksheet.
The system of the open cooperation spreadsheet application filtrator for storing on cloud computing service of another aspect described herein.System comprises client computer, and client computer is configured to: connected by network and communicate with multiple client computer with cloud computing service; And the first worksheet of the electrical form that loading cloud computing service stores, wherein multiple filtrator is associated with the first worksheet.Client computer is configured to further: receive from user the order being used for applying the first filtrator multiple filtrator to the first worksheet; The first filtrator is applied to the first worksheet on the first client computer; And showing filtered first worksheet to user, the first client computer wherein in multiple client computer shows unfiltered first worksheet concomitantly.
The open graphic user interface for checking the cooperation electrical form that cloud computing service stores on multiple client computer of another aspect described herein.Graphic user interface on each client computer comprises: editor, and multiple cells of the first worksheet of the cooperation electrical form that cloud computing service stores are shown; And hurdle, the side window in editor, at user option multiple filtrator is shown, wherein multiple filtrator is stored on the server.Graphic user interface is designed so that when the user on the first client computer in multiple client computer selects the first filtrator from multiple filtrator further, first filtrator is applied to the first worksheet, and filtered first worksheet is shown in the editor of the first client computer, unfiltered first worksheet of editor display of the second client computer wherein in multiple client computer.
Accompanying drawing explanation
With reference to accompanying drawing, can understanding method and system better from following illustrative description, wherein:
Fig. 1 illustrate according to embodiment as described in this article with the some client computers storing the cloud computing service of one or more electrical form and carry out communicating;
Fig. 2 illustrates the server realizing cloud computing service according to embodiment as described in this article;
Fig. 3 illustrates the client computer for loading the electrical form that cloud computing service stores according to embodiment as described in this article;
Fig. 4 illustrates the worksheet of the cooperation electrical form that the cloud computing service according to embodiment as described in this article stores;
Fig. 5 illustrates the filter option of the worksheet of the cooperation electrical form stored on cloud computing service according to embodiment as described in this article;
Fig. 6 illustrates the filtered worksheet of the cooperation electrical form that the cloud computing service according to embodiment as described in this article stores;
Fig. 7 illustrates hurdle, the side window of the worksheet apply filters of cooperation electrical form for storing on cloud computing service according to embodiment as described in this article;
Fig. 8 illustrates the diagram made a variation for the treatment of the teamworker for the cooperation electrical form that cloud computing service stores according to embodiment as described in this article;
Fig. 9 illustrates another diagram made a variation for the treatment of the teamworker for the cooperation electrical form that cloud computing service stores according to embodiment as described in this article;
Figure 10 illustrates the method for checking the filtrator on the cooperation electrical form that cloud computing service stores according to embodiment as described in this article;
Figure 11 illustrates the method for the filtrator for creating the cooperation electrical form stored on cloud computing service according to embodiment as described in this article;
Figure 12 illustrates the method for the filtrator for being provided for the cooperation electrical form that server stores according to embodiment as described in this article;
Figure 13 illustrates the method for the treatment of the user action about cooperation electrical form according to embodiment as described in this article;
Figure 14 illustrates the method for receiving the teamworker's action about cooperation electrical form according to embodiment as described in this article; And
Figure 15 illustrates the other method for the treatment of the user action about cooperation electrical form according to embodiment as described in this article.
Embodiment
In order to provide, the entirety of system and method described herein be understood, will describe some illustrative embodiment now, comprising the system and method for providing the independent filter of the cooperation electrical form of teamworker to cloud computing service stores to use.But, be to be understood that, words as suitable system and method described herein can be adapted and revise the application for just processing, and adopts system and method described herein in the application that can be applicable at other, and such other adds and amendment can not depart from its scope.Particularly, as in this description the server, service or the system that use can be single computing equipment or teamwork and wherein multiple computing equipments of launching between various computing equipment of the storage of data and the execution of function.
The aspect of system and method described herein relates to the method for the ability providing the filtrator utilizing the cooperation electrical form stored on cloud computing service independently to multiple teamworker.Cloud computing service storage comprises the electronic form file of one or more worksheets of data.Cloud computing service also stores the some filtrators for each worksheet.Filtrator can by any teamworker by creating the write access of electrical form and preserve.Filtrator can be for sorting from the display of worksheet or hiding the instruction of some value.User on client computer uses web browser loads the worksheet of electrical form local replica from cloud computing service and the filtrator be associated thereof.Filtrator is displayed in the filter interface in web browser, such as, on hurdle, side window.When user selects the filtrator to worksheet application, filtrator is only applied to the local replica of worksheet and shows to user.Unlike the normal editor to worksheet, filtrator will be passed on to select to other teamworkers.Thus each teamworker can select independently and check different filtrators.User can use filter interface to arrange for worksheet acquiescence filtrator, remove to worksheet application all filtrators and establishment, editor, rename, copy or delete filtrator.The editor to worksheet after filtration made by user or variation can with reference to non-filterer's tabulation or worksheets and being stored by client computer after filtration.If variation is with reference to non-filterer's tabulation, then variation can be sent straight to cloud computing service for storing and being sent to other teamworker's client computer, before showing variation to teamworker, other teamworker's client computer converts variation according to any filtrator that corresponding teamworker's client computer is applied.If variation reference worksheet after filtration, then, before being sent to cloud computing service and teamworker's client computer, according to the inverse of filtrator, they are converted.
First, describe wherein some client computers and can be connected to the client server system of cloud computing service.Fig. 1 illustrates the client server system 100 comprising cloud computing service 102 and some client computer 104a to 104d.Cloud computing service 102 can comprise the one or more servers providing cloud computing service to multiple client computer collective.Cloud computing service 102 stores by the addressable some files comprising cooperation electrical form 106 of client computer 104a-104d.User can create, edit, copy, share and delete the file that cloud computing service 102 stores.Such as, client computer 104a-104d can use web browser to access electrical form 106 on cloud computing service 102 simultaneously.Cloud computing service 102 provides the local replica of electrical form 106 to each client computer, and the user on client computer can check and edit this local replica.The editor's (being called variation in addition) made by client computer 104a is automatically sent to cloud computing service 102 and is transferred to other client computer 104b-104d.Thus the variation made by a teamworker is seen by other teamworkers immediately.Client computer 104a-104d can be comprised desk-top computer, laptop computer, panel computer, smart phone, mobile electronic device or can be connected to any miscellaneous equipment of cloud computing service 102 by telecommunication network.System 100 can comprise the many client computers be connected with cloud computing service 102.The cloud computing service 102 of system 100 is connected by the telecommunication network of such as the Internet and so on client computer 104a-104d.Can so that network connects by LAN (Local Area Network), wide area network, Ethernet, fiber optic network or any other wired or wireless connection.
Server for providing cloud computing service is described now in more detail.Server 200 in Fig. 2 illustrates the example for the server used in cloud computing service.Cloud computing service can comprise some servers that collective provides cloud computing service.Server 200 comprises CPU (central processing unit) (CPU) 202, ROM (read-only memory) (ROM) 204, random access memory (RAM) 206, communication unit 208, data storage 210 and bus 212.Server 200 can have optional feature not shown in Fig. 2.Bus 212 allows the various parts of server 200 to communicate with one another.Communication unit 208 allows other devices communicatings of server 200 and such as some client computers and so on.Inter alia, data store 210 and can store its file that can accessed by some client computers, view or edit.These files can comprise word processing file, demonstration document, electrical form or multimedia file.Each file that data store in 210 can be associated with Access Control List (ACL) (ACL), Access Control List (ACL) (ACL) determines to attempt to check that data store the access rights (such as, write access, read access, can not access) of the user of the file in 210.User to be connected with server 200 by communication unit 208 and to store with visit data the file stored in 210.
Client computer for accessing the file that cloud computing service stores is described now in more detail.Client computer 300 in Fig. 3 comprises CPU (central processing unit) (CPU) 302, ROM (read-only memory) (ROM) 304, random access memory (RAM) 306, input/output interface 308, web browser 310 and bus 312.Client computer 300 can have optional feature not shown in Fig. 3.Bus 312 allows the various parts of client computer 300 to communicate with one another.Input/output interface 308 allows other devices communicatings of client computer 300 and such as cloud computing service and so on, and comprises for receiving user's input and to the equipment of user's display translation.Inter alia, web browser 310 is for providing user interface to check and to edit the file that cloud computing service stores.Web browser 310 also shows can edit by it variation made with other teamworkers of the same file of the user of client computer 300.Cloud computing service can to determine in web browser 310 display for accessing the layout with the user interface of viewing files.
For non-transient computer-readable medium can be used realize for other data structures in the web browser 310 of client computer 300 and cloud computing service 200 and client computer 300 and software program in the data storage 210 of the file of storage on cloud computing service 200, Fig. 3 in Fig. 2.The example of non-transient computer-readable medium be applicable to comprises the nonvolatile memory of form of ownership, medium and memory devices, comprises by way of example: semiconductor memory devices, such as EPROM, EEPROM and flash memory device; Disk, such as internal hard drive or removable dish; Magneto-optic disk; And CD-ROM and DVD-ROM dish that is readable, writable disposable or that can write again.
Present description is to the operation of the cooperation electrical form that cloud computing service stores.Fig. 4 illustrates the worksheet 400 of the cooperation electrical form that cloud computing service stores.Cooperation electrical form is the electronic form file that it can be accessed simultaneously by a more than user and be edited.Cooperation electrical form can comprise one or more worksheet, and wherein each worksheet comprises the grid of cell.Such as, worksheet 400 is included in the data in several cell, and wherein the data of identical type are listed in the data be associated in row 402 and with same people and are arranged and are expert in 404.Worksheet 400 can comprise the data of any amount arranged with any possible configuration, and is not limited to the layout shown in Fig. 4.Data in worksheet 400 can use client computer to input by the one or more users being connected to cloud computing service as shown in Figure 1.User can carry out write access to worksheet 400 or only can carry out read access, and in read access, but user can check cannot editing data.The ACL be associated with the electrical form that cooperates can determine the access rights of attempting the user accessing electrical form.
Cloud computing service can be provided for user the several functions creating, handle and show the data on electrical form.Such function is called filtration.Filtration can comprise according to one or more criterion (such as, alphabet sequence or by numeral) sort the data, and can comprise from display hide some data value, row or column.Filtrator can be stored as For Regression Transformation Models, the bottom data (such as, for the object be presented on screen, cell data being assigned to the conversion of new cell) of For Regression Transformation Models mapping or conversion electron form before showing it.Fig. 5 illustrates the example of the filter menu of the worksheet 500 of the cooperation electrical form stored on cloud computing service.Worksheet 500 comprises column heading, and column heading comprises " age " and " score ".When user opens filter option, often row can show dropdown arrow 504.When user selects dropdown arrow, the filtrator menu 502 for these row can be shown.Such as, when selecting the filtrator dropdown arrow arranged for " age ", filtrator menu 502 occurs, and provides the some modes for using the criterion to the application of " age " row to carry out the data of filterer's tabulation 502 to user.Filtrator menu 502 comprises it can by the ranking function 506 of particular order to the line ordering of advancing of worksheet 502.Such as, if user selects " sorting from small to large ", according to the numeral in " age " row, row 1-6 can be sorted, first the row with the minimum value age is occurred, and the row with the greatest measure age finally occurs.Filtrator menu 502 also allows user's usage data check box 512 to carry out hiding data.Data check box 512 illustrates the data value of all records in " age " row.When data value is not chosen, any row comprising this data value is hidden from the display of worksheet 500.Filtrator menu 502 can also be provided for selecting all data values or removing the shortcut 508 to the selection of all data values from data check box 512, and can be provided for the search box 510 of the particular data value in the list of search data check box.Filtrator menu 502 can also be provided for apply filters or cancel " determining (OK) " and " cancellation " button of application.Filtration not only can also be applied to row, but is applied to the selection of row or cell.User highlights cell, the row or column that user wants to filter, and then calls filter function.Filtrator menu 502 can comprise other data sorting unshowned and filtering option in Fig. 5.
Cooperate shown in Fig. 6 the example of the worksheet after filtration in electrical form.Such as, the worksheet 400 of Fig. 4 is considered as non-filterer's tabulation.User selects the filtrator menu arranged for " age ", and sorts to the age from small to large, and the data check box of non-selected data value " 18 ".This filtrator is by the row according to age arrangement worksheet 400, and hiding wherein age value is any row of 18.Worksheet 600 in Fig. 6 illustrates the result applying this filtrator to non-filterer's tabulation 400.As can be seen, the row of worksheet 600 is arranged as and makes the minimum age up front, and the maximum age in the end.Further, because the age value be associated with name " Tyrone " is 18, the whole row of " Tyrone " entry is hidden from the display of worksheet 600.By omitting the line number of the hidden rows in linage-counter, worksheet 600 can indication lines be hidden by filtrator.Such as, do not go in figure 6 " 5 ".By selecting the filtrator dropdown arrow of these row, user can edit or cancel the filtrator on " age " row.User can also use suitable filtrator dropdown arrow to create another filtrator.
Usually, when the user of the cooperation electrical form that editor's cloud computing service stores is to worksheet apply filters, filtrator is transferred to cloud computing service and it also checks any other teamworker of worksheet.Thus only have a filtrator to be applied to worksheet in any one moment, and multiple teamworker can not apply filters independently of one another.If multiple teamworker wishes to filter overlapped data collection by different way, then this may be problematic, because worksheet will only show up-to-date filtrator.Further, cloud computing service cannot provide to user and preserves multiple filtrator and allow multiple teamworker to select the ability of these filtrators preserved independently.
The system and method for the application provides independently to the ability of the worksheet apply filters of cooperation electrical form to teamworker.For each worksheet in cooperation electrical form, cloud computing service stores the multiple filtrators be associated with this worksheet.When the user on client computer accesses the worksheet of cooperation electrical form, the copy of multiple filtrators that cloud computing service provides the local replica of worksheet to client computer and is associated with this worksheet.Other teamworkers of access cooperation electrical form also receive the local replica of worksheet and filtrator.When user selects filtrator to be applied to worksheet, the data on the local replica of filtrator conversion worksheet, and show worksheet after filtration to user.Unlike normal variant, user can not be communicated to other teamworkers to the selection of filtrator.Thus filtrator can not be applied to the worksheet shown by teamworker's client computer automatically.The same worksheet of the cooperation electrical form that each teamworker can store independently on cloud computing service applies different filtrators.User can be communicated to cloud computing service to the selection of filtrator, or can not pass on.
Client computer can use web browser to show the cooperation electrical form that cloud computing service stores.Cloud computing service provides the user interface that will show in web browser (UI).UI allows user to check and edits the worksheet of cooperation electrical form and call the electrical form function of such as filtration and so on.Fig. 7 illustrates the example of the UI700 of the worksheet for showing cooperation electrical form.Some cells of the data that the row of going and indicating letter that UI700 illustrates to indicate numeral arrange.UI700 comprises for hurdle, the side window 702 to worksheet apply filters.Hurdle, side window 702 illustrates the filter list that can be applied to worksheet.Such as, filtrator 704 is " without filtrator " options, and when selected, it removes all filtrators from the display of worksheet.The filtrator 706 of called after " more than 20 " can realize the filtrator described about Fig. 6, and namely sequence and any age value equaling 18 remove " age " row from display from small to large.Another filtrator 710 called after " filtrator 2 ".Each filtrator can have it can by the drop-down menu 708 selected.Drop-down menu 708 comprises for replica filter, rename filter, deletion filtrator or the filtrator order making selected filtrator filtrator by default.Filtrator 704,706 or 708 can be marked with the symbol of such as asterisk and so on, to represent which filtrator is acquiescence filtrator.Current filter for the application of forward worksheet can highlighted or overstriking, enlivens to indicate which filtrator.Also there is the filtrator order 712 for creating new filtrator.Select filtrator order 712 can generate the filtrator editor similar to the filtrator menu 502 shown in Fig. 5, make user to be defined filter.User can create filtrator and not preserve filtrator, or can preserve and name filtrator, and filtrator will be added to the filter list shown in hurdle, side window 702 in this case.Hurdle, side window 702 can comprise other filtrator order unshowned in Fig. 7.Such as, drop-down menu 708 can have the option for making filtrator privately owned or public.If make filtrator privately owned, other teamworkers are not had to use filtrator.UI700 can also provide the independent ranking function independent of filter function.When user uses the ranking function relative with filter function to sort to worksheet data, it can be regarded as variation.Thus sequentialize commands is sent to cloud computing service and other teamworkers make their data display be automatically updated.If user uses filter function to sort to worksheet data, order is not sent to other teamworkers.In arbitrary option, when the cell value affected by ranking criteria changes, the display of worksheet can be automatically updated to reflect new order.
When user can occur from hurdle, side window 702 during menu setecting filter option UI700, or hurdle, side window 702 can be called when user's edited filter.As long as exist be applied to worksheet enliven filtrator, hurdle, side window 702 can be opened, and when worksheet not having the filtrator enlivened, hurdle, side window 702 can disappear.When user does not use hurdle, side window a period of time (such as user stops a period of time after edited filter), hurdle, side window 702 can fade away.Hurdle, side window 702 can be minimized by user, trigger (toggle) or closedown, or user can move the position of hurdle, side window 702 in UI700.Close hurdle, side window 702 to remove from the display of worksheet and allly enliven filtrator.Alternatively, hurdle, side window 702 can stay open, and and if only if user stops using time all filtrators (namely selecting " without filtrator " option), can disappear.Only when user selects the cell that affects by filtrator or edited filter, hurdle, side window 702 can occur.Other action by user that it can make hurdle, side window 702 occur or disappear from UI700 can be there is.UI700 can provide the help link with the explanation how offside hurdle window 702 operates.UI700 can use any known web browser programming language comprising HTML and JavaScript to realize.
Filter model can be stored on cloud computing service and client computer as the data structure with some defined attributes.Such as, filter model can comprise unique identifier (such as alphanumeric character string) for filtrator and the title that provided to filtrator by user.Filter model comprises filtrator and is applied in range of cells on it.Filter model can also comprise the list of the row order through sequence, and wherein the row of non-filterer's tabulation is mapped to the row of worksheet after filtration according to filter criteria.Filter model can also comprise boolean's list of hidden rows, and it indicates some to be about to hide from view or keep.Filter model can also comprise the list getting rid of data, and in its tracing figure 5, the user of check box 512 selects.Filter model can also comprise it and create or the last mark revising the user of filtrator.Unlisted out of Memory also can be included in filter model.Each filtrator has the data structure be associated, and when the worksheet of load collaboration electrical form, this data structure is sent to client computer from cloud computing service.Data structure is changed to the editor of filtrator, and is communicated to cloud computing service and other teamworkers.
User action to the input of hurdle, side window 702 can be communicated to cloud computing service.Such as, if the new filtrator that user creates or copies for worksheet, client computer can create filter model and send it to cloud computing service to be stored as the filtrator be associated with worksheet.If user deletes the filtrator be associated with worksheet, client computer can send request to cloud computing service the corresponding primary copy deleting filtrator.If user edits or rename filter, client computer changes its filter model stored, and the filter model through editor is sent to cloud computing service, and then cloud computing service will upgrade the primary copy of filter model.If filtrator is set to give tacit consent to filtrator by user, then client computer can send request to be set to by the primary copy of this filtrator give tacit consent to filtrator to cloud computing service.To the copy of non-filterer's tabulation be received from any teamworker of cloud computing service access worksheet subsequently, and give tacit consent to filtrator and will automatically apply.If user carries out write access (such as, being determined by ACL) to electrical form, then user can create, edits or delete filtrator.If user is to carrying out read access to electrical form, cloud computing service can allow user to use filtrator, but possibility can not allow user to create, edits or delete filtrator.User is to establishment, the editor of filtrator or delete other teamworkers that can be sent to cloud computing service and current accessed electrical form.Although so use filtrator to rearrange data can not be communicated to teamworker, be communicated to teamworker to the change of filtrator itself.
When to the worksheet apply filters of cooperation electrical form, can reference unit lattice in two ways---with reference to non-filterer's tabulation or worksheet after filtration.Such as, in UI700 when applying " more than 20 " filtrator, when with reference to worksheet after filtration, name entries " Ni Ke " appears in cell A4.But when with reference to non-filterer's tabulation shown in figure 4, name " Ni Ke " is in fact in cell A2.Filtrator can be considered to be in mapping between the cell of non-filterer's tabulation and the cell of worksheet after filtration or conversion.By generating worksheet after filtration to non-filterer's tabulation apply filters, and worksheet is shown by client computer after filtration.When user's input is to the editor of worksheet or variation, variation can with reference to the cell of non-filterer's tabulation or can with reference to the cell of worksheet after filtration.In addition, user presents information and can be sent to other teamworkers.Such as, if user highlights cell A1-A5, then the user interface on teamworker's client computer can show user and be highlighted those cells.Variation and user present information and can be referred to as user action.Fig. 8 illustrates the system for the treatment of the user action for cooperation electrical form, wherein makes user's input with reference to non-filterer's tabulation.System 800 comprises the cloud computing service 802 of the primary copy storing cooperation electrical form 804.Cooperation electrical form 804 can comprise one or more worksheet, and each worksheet can be associated with one or more filtrator.Two client computers 806 and 812 are connected to cloud computing service 802 to access cooperation electrical form 804.When each client computer access cooperation electrical form, the local replica of cooperation electrical form 804 is loaded on each client computer, shows for local replica 810 and 816.The copy that local replica comprises at least one worksheet and the filtrator for this worksheet be associated.
User on client computer 806 applies the filtrator 808 of called after " filtrator 1 " to the local replica 810 that it cooperates electrical form.Filtrator converts the cell of non-filterer's tabulation, and rearranges cell to show to user.Similarly, the user on client computer 812 selects to show for " filtrator 2 " of filtrator conversion 814 is to be applied to the local replica 816 of its cooperation electrical form.Each client computer can not be communicated to other client computer to the selection of filtrator, and thus each user can not be subject to the impact of other users to the selection of filtrator.Client computer 806 and 812 can send filtrator to cloud computing service 802 and select information.User on client computer takes user action to local replica 810 and 816.Be with reference to non-filterer's tabulation or worksheet after filtration according to user action, process user action by client computer and cloud computing service 802.
Fig. 8 illustrates when user action is with reference to the example of the user action process of electrical form after filtration during non-filterer's tabulation.In this case, always local replica 810 and 816 that client computer stores store worksheet do not filter copy, and no matter user may to any filtrator 808 or 814 of worksheet application.User initiates the user action 818 of the cell of the non-filterer's tabulation of its reference.Only when showing worksheet to user, filtrator 808 and 814 is applied to not filtering local replica 810 and 816.Such as, filtrator is supposed by the data permutation in the cell A1 of worksheet to cell D5.When user applies this filtrator to worksheet, filtrator can not change the bottom local replica of the worksheet that client computer stores.Or rather, client computer never filters the version after filtration of local replica evaluation work table, and shows worksheet after filtration.This after filtration worksheet be stored in temporary storage, and when worksheet on display screen refreshes, can be recalculated.Although thus data are presented in cell D5 by client computer screen, the local replica of worksheet stores data in cell A1.When user inputs user action, the local replica that do not filter of its reference work table is stored.Such as, when user's compiles user see as the content of cell D5 in display time, in fact client computer makes a variation the cell A1 in its local replica, but not cell D5.Only when the display of worksheet then refreshes, the variation of client computer to local replica apply filters and in Cell display D5.Because store user action with reference to non-filterer's tabulation, user action can be sent straight to cloud computing service and teamworker's client computer, and without the need to any conversion.User action is recorded in the primary copy of its worksheet by cloud computing service, and user action is sent to the every other teamworker of current accessed worksheet.At teamworker's client computer place, what user action was applied to this client computer stores does not filter local replica.If teamworker is to local replica apply filters, then, before showing on the screen of teamworker's client computer, user action is converted by filtrator.Such as, teamworker can receive variation to the cell A1 of the local replica on teamworker's client computer and updating block lattice A1.If teamworker uses the filtrator of the data transformation in cell A1 to cell B3, make a variation and undertaken converting by filtrator and cell B3 on teamworker's computer screen is updated.
Cooperation electrical form can have the computing engines of its computing unit scale value.This engine is discrete with the UI engine showing worksheet to user.When user action is with reference to non-filterer's tabulation, calculating and formula are affected, and only when displayed, filterer's tabulation.Calculating and formula can use the data found in the one or more cells rearranged by filtrator.When formula or calculating are displayed on screen, it can with reference to the cell of non-filterer's tabulation, and worksheet itself rearranges.This may be chaotic for user checks.In order to address this problem, filtrator can also be applied to the cell reference in calculating and formula.Thus when calculating and formula is presented on screen, they are with reference to the cell of worksheet after filtration, and the cell of the actual computation stored in storer or the non-filterer's tabulation of formula reference.The all right limited subscriber of client computer creates the ability of new formula.Such as, if user highlights the sequential cells lattice collection in the view after filtration of the worksheet that will use in formula, in fact cell collection may not be continuous print in non-filtered view.Client computer can not allow such action.
In alternative design, user action can with reference to the cell of the worksheet after filtration on client computer.Fig. 9 illustrates when user action is with reference to the example to the variation process of electrical form after filtration during worksheet after filtration.System 900 comprises the cloud computing service 902 of the primary copy storing cooperation electrical form 904.Cooperation electrical form 904 can comprise one or more worksheet, and each worksheet can be associated with one or more filtrator.Two client computers 906 and 912 are connected to cloud computing service 902 to access cooperation electrical form 904.When each client computer access cooperation electrical form, the local replica of cooperation electrical form 904 is loaded on each client computer, shows for local replica 910 and 916.The copy that local replica comprises at least one worksheet and the filtrator for this worksheet be associated.User on client computer 906 applies " filtrator 1 " to the local replica 910 of its cooperation electrical form.Similarly, the user on client computer 912 applies " filtrator 2 " to the local replica 916 of its cooperation electrical form.
In fig .9, whenever user's selection or modified filter, the local replica 910 and 916 that client computer stores is updated.Thus unlike the situation about Fig. 8, filtrator changes the local replica of worksheet, and then this local replica shows directly to user.918 are made a variation with reference to the cell of worksheet after filtration to the user of worksheet.Thus when receiving user action by client computer, user action is applied to the local replica after filtration of worksheet and shows directly to user.But before user action is sent to cloud computing service, user action is converted by the inverse of filtrator, makes user action with reference to non-filterer's tabulation.When the user on client computer 906 is to worksheet apply filters 1, client computer 906 is determined and is stored the inverse of " filtrator 1 " 908, and the cell of worksheet is after filtration mapped to the cell of non-filterer's tabulation by it.Similarly, client computer 912 is determined and is stored the inverse of " filtrator 2 " 914.Such as, user makes a variation with reference to the cell D5 of the local replica after filtration that client computer stores, and the data wherein in cell D5 correspond to the data in the cell A1 of non-filterer's tabulation.Before variation is sent to cloud computing service, converts variation according to the inverse of filtrator, make the variation reference unit lattice A1 through conversion.This user action is sent to cloud computing service to be recorded in not the filtering in primary copy of worksheet.User action is also sent to other teamworkers of current accessed worksheet by cloud computing service.At teamworker's client computer place, user action is converted by any filtrator used by teamworker, and is then saved as the local replica on this client computer.Such as, if teamworker uses the filtrator of the data transformation in cell A1 to cell B3, then make a variation and undertaken converting by filtrator and be stored in the cell B3 of the local replica of the worksheet on teamworker's client computer.Formula also can convert in the mode identical with user action with calculating, and therefore cell is with reference to having logical meaning for each teamworker.
In another alternative design, client calculation services can follow the tracks of the current filtrator just used of each teamworker.As in Fig. 9, the local replica of worksheet can be changed by filtrator, and user action stores with reference to worksheet after filtration.User action directly can be sent to cloud computing service by client computer, and cloud computing service performs inverse filtrator conversion to obtain the user action with reference to non-filterer's tabulation.Cloud computing service before user action is sent to teamworker's client computer, can also be converted user action by the filtrator used by teamworker.Thus with situation about describing in Fig. 9 by contrast, the calculating of filtrator conversion and inverse transformation is at cloud computing service but not client computer completes.Just using which filtrator by following the tracks of teamworker, cloud computing service can also allow some teamworker's mirror images filtrator each other, and allows other teamworkers to use filtrator independently.Such as, if user A and user B selects mirror images of each other, then any application of user A to filtrator automatically upgrades the worksheet view of user B.Another user C selects to work independently, and so the worksheet view of user C can not be subject to the impact of user A on the selection of filtrator.
Present description is for creating, storing and show the various methods of filtrator of the cooperation electrical form stored on cloud computing service.A kind of method shown in Figure 10 provides the method for the filtrator on the cooperation electrical form checking and cloud computing service stores.Method 1000 comprises the first worksheet of the electrical form stored from each client computer access cloud computing service multiple client computer, and wherein multiple filtrator is associated with the first worksheet.Method the first client computer place be included in further in multiple client computer receives the order of applying the first filtrator in multiple filtrator to the first worksheet of first user.Method comprises further applies the first filtrator and to first user display the first worksheet after filtration to the first worksheet on the first client computer, and the second client computer wherein in multiple client computer shows concomitantly and do not filter the first worksheet.Method 1000 can perform on the client computer that it can be connected to any type of cloud computing service, the client computer described in such as Fig. 3 or any desk-top computer, laptop computer, panel computer, smart phone or such electronic equipment.
1002 places are illustrated, and when the first worksheet of the cooperation electrical form that multiple client computer access cloud computing service stores, method 1000 starts.The primary copy of the electrical form that cloud computing service stores comprises one or more worksheet, and wherein at least one worksheet is associated with multiple filtrator.As described above, filtrator rearranges for the data display on the worksheet of user, and can comprise and to sort to data and from view, to remove some data value.Filtrator can be defined by the user and be stored on cloud computing service.As illustrated in Figure 1 all, cloud computing service allows user concurrent accessing first worksheet on multiple client computer.Electrical form can have ACL, and ACL determines which user can access the access level of electrical form and each user.When the user on client computer accesses the first worksheet, the copy that cloud computing service sends the first worksheet to client computer and the filtrator be associated.This copy is stored as the local replica on client computer and shows (such as, passing through web browser) to user.User interface on Web browser allows user to check and editing table.The editor made by user or variation are recorded in the local replica of worksheet, and are sent to cloud computing service to be recorded in primary copy.
1004 places are illustrated, and after the local replica of the first worksheet is loaded on each client computer, client computer receives the order to the first worksheet apply filters from user.Cloud computing service is provided for the user interface of checking and editing the first worksheet to client computer, all user interfaces as shown in Figure 7.User interface comprises menu or hurdle, the side window of selecting the filtrator of the cell group that will be applied in the first worksheet for user.User highlights the cell group that user expects to filter, and selects filtrator from the multiple filtrators be associated with the first worksheet.1006 places are illustrated, and then client computer is to the selected filtrator of the first worksheet application.Describe in this application as previous, filtrator converts the cell data stored in the local replica of the first worksheet.If user previously applied another filtrator to the first worksheet, then the selection of new filtrator made client computer remove previous filtrator and applied new filtrator to the first worksheet.
1008 places are illustrated, after client computer applies selected filtrator to the first worksheet, to user's display first worksheet after filtration of client computer.The user of the filtrator on a client computer selects to be communicated to other client computer of accessing same worksheet concomitantly.Although thus the user on a client computer can to the first worksheet apply filters, but the second client computer still shows non-filterer's tabulation, or perhaps shows the worksheet filtered the selection of another filtrator based on the user on the second client computer.The user of filtrator selects to be communicated to cloud computing service, and cloud computing service can store each user is current is just using for what filtrator.But cloud computing service can not change the primary copy of the first worksheet, and filtrator selection information can not be sent to other client computer.By this way, method 1000 provides the ability cooperation electrical form that stores on cloud computing service independently utilizing filtrator to multiple concurrent teamworker.
Other method described herein provides the method for the filtrator creating the cooperation electrical form stored on cloud computing service.Method 1100 in Figure 11 comprises the first worksheet of the electrical form stored from each client computer access cloud computing service multiple client computer.Method is included in further on the first client computer in multiple client computer and creates the first filtrator, and the user wherein on the first client computer defines the first filtrator.Method comprises further: apply the first filtrator to the first worksheet on the first client computer, and the second client computer wherein in multiple client computer shows concomitantly and do not filter the first worksheet; And send the first filtrator for storing and being associated with the first worksheet to cloud computing service.Method 1100 can perform on the client computer that it can be connected to any type of cloud computing service, the client computer described in such as Fig. 3 or any desk-top computer, laptop computer, panel computer, smart phone or such electronic equipment.
1102 places are illustrated, and when the first worksheet of the cooperation electrical form that multiple client computer access cloud computing service stores, method 1100 starts.The primary copy of the electrical form that cloud computing service stores comprises one or more worksheet.One or more filtrator can be associated with each worksheet.As illustrated in Figure 1 all, cloud computing service allows user concurrent accessing first worksheet on multiple client computer.Electrical form can have ACL, and ACL determines which user can access the access level of electrical form and each user.When the user on client computer accesses the first worksheet, the copy that cloud computing service sends the first worksheet to client computer and the filtrator be associated.This copy is stored as the local replica on client computer and shows (such as passing through web browser) to user.User interface on Web browser allows user to check and editing table.The editor made by user or variation are recorded in the local replica of worksheet, and are sent to cloud computing service to be recorded in primary copy.
1104 places are illustrated, and after the local replica of the first worksheet is loaded on client computers, the user on the first client computer creates the first filtrator being used for the first worksheet.The ability creating or edit the filtrator being used for electrical form can be limited by the ACL of electrical form.Such as, the user with write access can create or edit the filtrator for worksheet, and but the user with read access can use filtrator cannot create or edit them.As described above, filtrator rearranges for the data display on the worksheet of user, and can comprise and to sort to data and from view, to remove some data value.Cloud computing service is provided for the user interface creating and edit for the filtrator of the first worksheet to client computer, all user interfaces as shown in figure 5 and figure 7.This user interface may be displayed in web browser that client computer performs.Such as, user interface can comprise and to create for user or edited filter and it is applied to menu or hurdle, the side window of the cell group in the first worksheet, all hurdle, side windows as shown in Figure 7.When user selects the option of establishment or edited filter, the menu similar to the menu 502 in Fig. 5 can be there is.In this menu, user is defined filter, some data value that such as definition clooating sequence or selection will show or remove from display.
1106 places are illustrated, and after user's establishment or edited filter, filtrator is applied to the first worksheet of client computer.Describe in this application as previous, filtrator converts the cell data stored in the local replica of the first worksheet.Right rear line shows worksheet after filtration.The filtrator created or edit also is sent to cloud computing service, is stored and is associated with the first worksheet at cloud computing service place filtrator.First worksheet can also have other filtrator associated with it.Have can create each user of the suitable access of electrical form, edit, delete, rename or replica filter.When user's establishment or edited filter, the filtrator created or upgrade can be sent to other client computer of accessing the first worksheet concomitantly by cloud computing service, and therefore other users can use filtrator.When user deletes filtrator, cloud computing service deletes the primary copy of filtrator, and indicates other client computer also to delete their filtrator copy.By this way, method 1100 provides the ability of the filtrator created or on editor's cloud computing service on the cooperation electrical form that stores to multiple concurrent teamworker.
Other method described herein discloses the method for the filtrator of the cooperation electrical form being provided for the server of trustship cloud computing service stores.Method 1200 in Figure 12 comprises: stored on the server by electrical form, wherein electrical form comprises multiple worksheet; And authorize multiple client computer Concurrency Access electrical form.Method comprises further: the multiple filtrators receiving first worksheet that will be applied to multiple worksheet from multiple client computer; And multiple filtrator is stored on the server, wherein multiple filtrator is associated with the first worksheet.Method comprises further provides multiple filtrator to each client computer in multiple client computer, wherein when the user on the first client computer in multiple client computer applies the first filtrator in multiple filtrator to the first worksheet, the display of the first worksheet on the second client computer in multiple client computer is independent of the filtrator application on the first client computer.Method 1200 can in the upper execution of the server of trustship cloud computing service (server described in such as Fig. 2).
1202 places are illustrated, and when on the server that electrical form is stored in trustship cloud computing service, method 1200 starts.Electrical form has one or more worksheet, and wherein each worksheet is made up of the some cells arranged with columns and rows.As illustrated in Figure 1 all, the user on client computer is connected to server to access electrical form.Server is provided for user and checks the user interface with the worksheet of editing electronic form, the user interface that the web browser that such as each client computer performs shows.Example for the user interface of electrical form is shown in Fig. 4 to Fig. 7.Electrical form can be created by the user on client computer and be saved on the server.Electrical form is collaboration type, thus mean a more than user can simultaneously editing electronic form.With it, electrical form can determine that the Access Control List (ACL) of each user to the access level of electrical form is associated.
1204 places are illustrated, after electrical form is stored on the server, and server authorizes one or more client computer Concurrency Access electrical form.User on client computer can cooperate and editing electronic form concomitantly.When client computer be connected to server and request access electrical form time, server can check user whether in the ACL of electrical form.If user is authorized user, server provides the copy of electrical form to client computer.This copy is stored as the local replica on client computer by client computer, and it is presented in web browser.Thus each client computer has the local replica of electrical form, and server keeps primary copy.The variation made by a user is transmitted to server and other users, and therefore all teamworkers have the fresh copy of electrical form.
1206 places are illustrated, and after the authorized access electrical form of client computer, server receives multiple filtrators that will be applied to the first worksheet of electrical form from one or more client computer.The user interface that user on client computer uses server to provide creates filtrator.Such as, user can select " creating new filtrator " option 712 of providing in hurdle, the side window 702 shown in Fig. 7.Then user uses the filtrator menu similar to the menu 502 shown in Fig. 5 to be defined filter.Filtrator can comprise for sorting to some cell or hide the order of some cell value from view.Once user is defined filter, it is just saved on client computers and is sent to server.User can also use user interface to come edited filter, rename filter, replica filter, filtrator is set to acquiescence filtrator or deletion filtrator.Access Control List (ACL) can determine which user can create, edits or delete the filtrator for electrical form.1208 places are illustrated, and server receives the filtrator that created by various user and stores them.Filtrator is associated with the first worksheet by server.If user has edited or rename filter, server has preserved the filtrator of renewal to replace old filtrator.If user deletes filtrator, server deletes the copy of its filtrator.If filtrator is set to give tacit consent to filtrator by user, server can arrange the mark of the copy for its filtrator.
1210 places are illustrated, and after the some filtrators for the first worksheet have been created and have stored on the server, server provides up-to-date multiple filtrators to each client computer.Server sends change that any new filtrator, user make filtrator or the order for deleting filtrator to each client computer, makes all teamworkers have the up-to-date list of the filtrator that can be used for the first worksheet.Because each client computer keeps the independent local replica of the first worksheet, user independently to the local replica apply filters of their the first worksheet, and can not affect the display of the first worksheet on other client computer.The application of filtrator can not be regarded as and make a variation identical, makes a variation and is automatically delivered to other teamworkers.User can be communicated to server to the selection of filtrator, but selects to be communicated to teamworker's client computer.Such as, two users can apply two different filtrators to same data set, and can not be interfering with each other, or user can apply filters, and another user still can check the first worksheet do not filter version.Server can be provided for the option of mirror image filtrator selection each other to user.Such as, if user A and user B selects mirror images of each other, then any application of user A to filtrator automatically upgrades the worksheet view for user B.Another user C selects to work independently, and so the worksheet view of user C can not be subject to the impact of user A on the selection of filtrator.By this way, the server that method 1200 is provided for trustship cloud computing service is provided for cooperating the method for filtrator of electrical form.
Other method described herein discloses when user action is with reference to the method for the user action on process cooperation electrical form during non-filterer's tabulation.Method 1300 shown in Figure 13 comprises non-filterer's tabulation of the electrical form that access services device stores to show on client computers, and wherein multiple filtrator is associated with non-filterer's tabulation.Method comprises further: receive user to the selection of first filtrator that will be applied in multiple filtrators of non-filterer's tabulation; And show worksheet after filtration to user, wherein by applying the first filtrator to obtain worksheet after filtration to non-filterer's tabulation.Method comprises further: receive the user action inputted by the user on client computer, and wherein user action is with reference to the cell of non-filterer's tabulation; User action is sent to server; According to the first filtrator conversion user action; And the display of worksheet is after filtration upgraded based on the user action converted.Method 1300 can perform on the client computer that it can be connected to any type of cloud computing service, the client computer described in such as Fig. 3 or any desk-top computer, laptop computer, panel computer, smart phone or such electronic equipment.
1302 places are illustrated, and when client computer accesses non-filterer's tabulation of the electrical form that the server of trustship cloud computing service stores, method 1300 starts.The primary copy of the electrical form that server stores comprises one or more worksheet.One or more filtrator can be associated with each worksheet.As illustrated in Figure 1, server allows multiple user concurrent accessing first worksheets on client computer.Electrical form can have ACL, and ACL determines which user can access the access level of electrical form and each user.When the user on client computer accesses the first worksheet, the copy that cloud computing service sends the first worksheet to client computer and the filtrator be associated.This copy is stored as the local replica on client computer and shows (such as, passing through web browser) to user.User interface on Web browser allows user to check and editing table, all user interfaces as shown in Figures 4 to 7.
1304 places are illustrated, and after client computer accesses the non-filterer's tabulation from server, client computer receives the selection that will be applied to the first filtrator of non-filterer's tabulation.As illustrated in Figure 7 all, user interface can comprise hurdle, side window, and user can select the filtrator that will be applied to the data segments in non-filterer's tabulation from hurdle, side window.1306 places are illustrated, and then client computer applies the first filtrator to non-filterer's tabulation, and show result worksheet after filtration.First filtrator is mapping between the cell of non-filterer's tabulation and the cell of worksheet after filtration or conversion.Such as, the cell A1 of non-filterer's tabulation can be mapped to the cell B2 of worksheet after filtration by the first filtrator, so make when application the first filtrator, and the data value of the display meeting Cell display A1 of cell B2.The local replica of non-filterer's tabulation that client computer stores can not be subject to the impact of user on the selection of the first filtrator.Namely, client computer can not override non-filterer's tabulation with worksheet after filtration in memory.Or rather, worksheet is temporarily stored and is presented on the display screen of client computer after filtration.
1308 places are illustrated, and showing to user after filtration after worksheet, client computer receives the user action inputted by user.User action can be editor or variation or user present activity (such as, highlight or select one or more cell).User action is with reference to non-filterer's tabulation but not the cell of worksheet after filtration.Such as, if user changes the data value in cell A1 (it is mapped to cell B2 by the first filtrator), user action reference unit lattice A1.Same when user selection unit lattice A1.Thus the cell A1 in the local replica of non-filterer's tabulation that change client computer stores.1310 places are illustrated, and this user action (unaltered) is sent to server.Server stores does not select the primary copy of the first worksheet affected by the user of filtrator, so user action can directly apply to the primary copy of the first worksheet.Then user action can be sent to current also any other teamworker of access electrical form by server.Before showing it, teamworker's client computer converts user action by according to any filtrator of the local replica being applied to them.The conversion of teamworker's user action is discussed about Figure 14.
1312 places are illustrated, also convert user action according to the first filtrator on client computer.After user action converts according to the first filtrator, its is with reference to the cell of worksheet after filtration.Thus the variation of cell A1 is transformed to the variation of cell B2.1314 places are illustrated, and worksheet is upgraded by the user action of conversion after filtration, and so rear line display.By keeping non-filterer's tabulation in memory and only determining worksheet after filtration when showing worksheet to user, user action directly can be sent to server by client computer, and does not need to change them.This allows server and client side's computing machine directly to pass on user action each other, and considers without the need to intermediate conversion layer any filtrator that user applies.By this way, method 1300 provides when user action is with reference to non-filterer's tabulation, the method for the user action on process cooperation electrical form.
Other method described herein discloses when the non-filterer's tabulation of teamworker's action reference, the method for the teamworker's action on process cooperation electrical form.In Figure 14, illustrated method 1400 comprises: non-filterer's tabulation of the electrical form that access services device stores is to show on client computers, and wherein multiple filtrator is associated with non-filterer's tabulation; And receive user to the selection of first filtrator that will be applied in multiple filtrators of non-filterer's tabulation.Method comprises further: show worksheet after filtration to user, wherein obtains worksheet after filtration by applying the first filtrator to non-filterer's tabulation; And receive teamworker's action from server, the wherein cell of the non-filterer's tabulation of teamworker's action reference.Method comprises further: convert teamworker's action according to the first filtrator; And based on the teamworker's action converted, upgrade the display of worksheet after filtration.Method 1400 can perform on the client computer that it can be connected to any type of cloud computing service, the client computer described in such as Fig. 3 or any desk-top computer, laptop computer, panel computer, smart phone or such electronic equipment.
1402 places are illustrated, and when client computer accesses non-filterer's tabulation of the electrical form that the server of trustship cloud computing service stores, method 1400 starts.The primary copy of the electrical form that server stores comprises one or more worksheet.One or more filtrator can be associated with each worksheet.As illustrated in Figure 1, server allows multiple user concurrent accessing first worksheets on client computer.Electrical form can have ACL, and ACL determines which user can access the access level of electrical form and each user.When the user on client computer accesses the first worksheet, the copy that cloud computing service sends the first worksheet to client computer and the filtrator be associated.This copy is stored as the local replica on client computer and shows (such as, passing through web browser) to user.User interface on Web browser allows user to check and editing table, all user interfaces as shown in Figures 4 to 7.
1404 places are illustrated, and after client computer accesses the non-filterer's tabulation from server, client computer receives the selection that will be applied to the first filtrator of non-filterer's tabulation.As illustrated in Figure 7 all, user interface can comprise hurdle, side window, and user can select the filtrator that will be applied to the data segments in non-filterer's tabulation from hurdle, side window.1406 places are illustrated, and then client computer applies the first filtrator to non-filterer's tabulation, and show result worksheet after filtration.First filtrator is mapping between the cell of non-filterer's tabulation and the cell of worksheet after filtration or conversion.Such as, the cell A1 of non-filterer's tabulation can be mapped to the cell B2 of worksheet after filtration by the first filtrator, so make when application the first filtrator, and the data value of the display meeting Cell display A1 of cell B2.The local replica of non-filterer's tabulation that client computer stores can not be subject to the impact of user on the selection of the first filtrator.Namely, client computer can not override non-filterer's tabulation with worksheet after filtration in memory.Or rather, worksheet is temporarily stored and is presented on the display screen of client computer after filtration.
1408 places are illustrated, and showing after filtration after worksheet to user, client computer receives teamworker's action from server.Teamworker's action can be that the variation made the first worksheet of the teamworker of current accessed electrical form or teamworker present activity (such as, highlight or select one or more cell).The non-filterer's tabulation of teamworker's action reference but not the cell of worksheet after filtration.Such as, if teamworker changes the data value in cell A1 (it is mapped to cell B2 by the first filtrator on client computer), from teamworker's action reference cell A1 that server receives.Teamworker's action is applied to the non-filterer's tabulation stored in storer by client computer.Server receives the teamworker's action from teamworker and it is directly applied to the primary copy of the first worksheet of server stores.Then, variation is sent to current also any other teamworker of access electrical form by server.
1410 places are illustrated, and after client computer receives teamworker's action, it converts teamworker's action according to the first filtrator.After teamworker's action converts according to the first filtrator, its is with reference to the cell of worksheet after filtration.Thus the variation of cell A1 is transformed to the variation of cell B2.1412 places are illustrated, and worksheet is upgraded by teamworker's action of conversion after filtration, and so rear line display.Such as, the cell B2 on the display screen of client computer can change into the variation of reflection teamworker.When teamworker presents activity, the user interface in web browser can illustrate that teamworker is current and just highlight cell B2.By this way, method 1400 provides when user action is with reference to non-filterer's tabulation, the method for the teamworker's action on process cooperation electrical form.
Other method described herein discloses when user action is with reference to the method for the user action on process cooperation electrical form during worksheet after filtration.In Figure 15, illustrated method 1500 comprises: non-filterer's tabulation of the electrical form that access services device stores is to show on client computers, and wherein multiple filtrator is associated with non-filterer's tabulation; And receive user to the selection of first filtrator that will be applied in multiple filtrators of non-filterer's tabulation.Method comprises further: show worksheet after filtration to user, wherein by applying the first filtrator to obtain worksheet after filtration to non-filterer's tabulation; And receive the user action inputted by the user on client computer, wherein user action is with reference to the cell of worksheet after filtration.Method comprises further: the display upgrading worksheet after filtration based on user action; User action is converted according to the inverse of the first filtrator; And send the user action through conversion to server.Method 1500 can perform on the client computer that it can be connected to any type of cloud computing service, the client computer described in such as Fig. 3 or any desk-top computer, laptop computer, panel computer, smart phone or such electronic equipment.
1502 places are illustrated, and when client computer accesses non-filterer's tabulation of the electrical form that the server of trustship cloud computing service stores, method 1500 starts.The primary copy of the electrical form that server stores comprises one or more worksheet.One or more filtrator can be associated with each worksheet.As illustrated in Figure 1, server allows multiple user concurrent accessing first worksheets on client computer.Electrical form can have ACL, and ACL determines which user can access the access level of electrical form and each user.When the user on client computer accesses the first worksheet, the copy that cloud computing service sends the first worksheet to client computer and the filtrator be associated.This copy is stored as the local replica on client computer and shows (such as, passing through web browser) to user.User interface on Web browser allows user to check and editing table, all user interfaces as shown in Figures 4 to 7.
1504 places are illustrated, and after client computer accesses the non-filterer's tabulation from server, client computer receives the selection that will be applied to the first filtrator of non-filterer's tabulation.As illustrated in Figure 7 all, user interface can comprise hurdle, side window, and user can select the filtrator that will be applied to the data segments in non-filterer's tabulation from hurdle, side window.1406 places are illustrated, and then client computer applies the first filtrator to non-filterer's tabulation, and show result worksheet after filtration.First filtrator is mapping between the cell of non-filterer's tabulation and the cell of worksheet after filtration or conversion.Such as, the cell A1 of non-filterer's tabulation can be mapped to the cell B2 of worksheet after filtration by the first filtrator, so make when application the first filtrator, and the data value of the display meeting Cell display A1 of cell B2.Can not to be coated to the situation being written as worksheet after filtration contrary with the wherein non-filterer's tabulation in method 1300, and the local replica of non-filterer's tabulation that client computer stores is coating is written as worksheet after filtration.
1508 places are illustrated, and showing to user after filtration after worksheet, client computer receives the user action inputted by user.User action can be editor or variation or user present activity (such as, highlight or select one or more cell).User action is with reference to worksheet after filtration but not the cell of non-filterer's tabulation.Such as, if user changes the data value in non-filter element lattice A1 (it is mapped to cell B2 by the first filtrator), user action reference unit lattice B2.Same when user selects non-filter element lattice A1.Thus the cell B2 in the local replica of the first worksheet that change client computer stores.1510 places are illustrated, and worksheet is directly upgraded by user action after filtration, and so rear line display.
1512 places are illustrated, also convert user action according to the inverse of the first filtrator on client computer.After user action converts according to the first filtrator inverse, it is with reference to the cell of non-filterer's tabulation.Thus the variation of the cell B2 of worksheet is after filtration transformed to the variation of the cell A1 to non-filterer's tabulation.1514 places are illustrated, and this user action once conversion is sent to server.Server stores does not select the primary copy of the first worksheet affected by the user of filtrator, so the user action sent to server should with reference to the cell of non-filterer's tabulation instead of worksheet after filtration.Otherwise, the error unit lattice that server will change in its primary copy.Then user action can be sent to current also any other teamworker of access electrical form by server.Before showing it, teamworker's client computer converts user action by according to any filtrator of the local replica being applied to them.The conversion of teamworker's action is discussed about Figure 14.By keeping worksheet after filtration in memory, client computer can show user action, and without the need to any intermediate steps.This causes ratio method 1300 displaying time faster.But before being sent to server, user action converts according to the inverse of filtrator, to keep the consistance with the server copy of the first worksheet.By this way, method 1500 provides when user action is with reference to worksheet after filtration, the method for the user action on process cooperation electrical form.
In the alternative approach of method 1500, client computer can send the user action that do not convert together with the information about which filtrator of the current use of client computer to server.Then server can convert user action according to the inverse of the first filtrator.Then user action can be stored in server memory.Server before sending user action to teamworker, can also convert the user action through conversion according to the filtrator of teamworker's use.
Should be appreciated that in the illustrated in the drawings embodiment in the aspect of system and method described herein and can be implemented in much multi-form software, firmware and hardware.Not restrictive for realizing software code or the special control hardware of the reality of the aspect of the principle meeting system and method described herein.Thus the operation of the aspect of system and method and behavior be not when being described with reference to when concrete software code---should be appreciated that those of ordinary skill in the art can be designed for the software in realizing and control hardware based on description herein.
Similarly, although describe operation with particular order in the accompanying drawings, this should not be understood to require with shown particular order or with sequence order to perform such operation, or require perform all illustrated operations, to realize expected result.In some cases, multitasking and parallel processing can be favourable.

Claims (100)

1., for checking a method for the filtrator on the cooperation electrical form that cloud computing service stores, described method comprises:
From each client computer multiple client computer, the first worksheet of the electrical form that access cloud computing service stores, wherein multiple filtrator is associated with described first worksheet;
The first client computer place in described multiple client computer receives the order for applying the first filtrator in described multiple filtrator to described first worksheet of first user;
To described first filtrator of described first worksheet application on described first client computer; And
To filtered first worksheet of described first user display, the second client computer in wherein said multiple client computer shows unfiltered first worksheet concomitantly.
2. method according to claim 1, wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
3. method according to claim 1, wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
4. method according to claim 1, wherein accesses described first worksheet and comprises and the copy of described first worksheet and described multiple filtrator being loaded on described first client computer.
5. method according to claim 4, wherein applies described first filtrator and comprises the local replica converting described first worksheet according to described first filtrator.
6. method according to claim 1, wherein said filtered first worksheet is displayed in web browser that described client computer performs.
7. method according to claim 1, wherein said order is selected option by described user and generates from the user interface that described client computer shows.
8. method according to claim 1, described method comprises further and sends described order to described cloud computing service.
9. method according to claim 1, the 3rd client computer display in wherein said multiple client computer is by the copy of described first worksheet of the second metre filter in described multiple filtrator.
10. method according to claim 1, the second filtrator in wherein said multiple filtrator is designated as acquiescence filtrator, and access described first worksheet comprise further on described first client computer described first worksheet application described second filtrator.
11. 1 kinds for creating the method for the filtrator of the cooperation electrical form stored on cloud computing service, described method comprises:
From each client computer multiple client computer, the first worksheet of the electrical form that access cloud computing service stores;
The first client computer in described multiple client computer creates the first filtrator, and the user on wherein said first client computer defines described first filtrator;
To described first filtrator of described first worksheet application on described first client computer, the second client computer in wherein said multiple client computer shows unfiltered first worksheet concomitantly; And
Described first filtrator is sent, for storing and being associated with described first worksheet to described cloud computing service.
12. methods according to claim 11, wherein define described first filtrator and comprise order for sorting to one or more cells of described first worksheet.
13. methods according to claim 11, wherein define the order that described first filtrator comprises the one or more cells for hiding described first worksheet.
14. methods according to claim 11, wherein access described first worksheet and comprise and being loaded on described first client computer by the copy of described first worksheet.
15. methods according to claim 11, wherein said first worksheet is displayed in web browser that described client computer performs.
16. methods according to claim 11, the user interface that the web browser that wherein said client computer performs shows is provided for described user the option creating described first filtrator.
17. methods according to claim 11, the described electrical form that wherein said cloud computing service stores has the Access Control List (ACL) allowing described user to create described first filtrator.
18. methods according to claim 11, wherein access described first worksheet and comprise further and send to each client computer in described multiple client computer the multiple filtrators be associated with described first worksheet.
19. methods according to claim 11, described method comprises further:
The editor to described first filtrator is received from described user;
To first filtrator of described first worksheet application through editing on described first client computer, wherein said second client computer shows described unfiltered first worksheet concomitantly; And
Described the first filtrator through editor is sent, for storing and being associated with described first worksheet to described cloud computing service.
20. methods according to claim 11, described method comprises further:
The order for deleting described first filtrator is received from described user;
Described first client computer shows described unfiltered first worksheet; And
The described order for deleting described first filtrator is sent to described cloud computing service.
21. 1 kinds of systems of cooperation spreadsheet application filtrator for storing on cloud computing service, described system comprises:
Client computer, is configured to:
Connected by network and communicate with multiple client computer with cloud computing service;
Load the first worksheet of the electrical form that described cloud computing service stores, wherein multiple filtrator is associated with described first worksheet;
The order be used for the first filtrator the described multiple filtrator of described first worksheet application is received from user;
To described first filtrator of described first worksheet application on described first client computer; And
Show filtered first worksheet to described user, the first client computer in wherein said multiple client computer shows unfiltered first worksheet concomitantly.
22. systems according to claim 21, wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
23. systems according to claim 21, wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
24. systems according to claim 21, wherein said filtered first worksheet is displayed in web browser that described client computer performs.
25. systems according to claim 24, wherein said web browser display is used for the user interface that described user generates described order.
26. systems according to claim 21, wherein said client computer is configured to send described order to described cloud computing service further.
27. systems according to claim 21, wherein said client computer is configured to further:
Create the second filtrator, wherein said user defines described second filtrator;
To described second filtrator of described first worksheet application, wherein said second client computer shows described unfiltered first worksheet concomitantly; And
Described second filtrator is sent, for storing and being associated with described first worksheet to described cloud computing service.
28. systems according to claim 27, wherein said client computer is configured to further:
The editor to described second filtrator is received from described user;
To second filtrator of described first worksheet application through editing, wherein said second client computer shows described unfiltered first worksheet concomitantly; And
Described the second filtrator through editor is sent, for storing and being associated with described first worksheet to described cloud computing service.
29. systems according to claim 27, wherein said client computer is configured to further:
The order for deleting described second filtrator is received from described user;
Show described unfiltered first worksheet; And
The described order for deleting described second filtrator is sent to described cloud computing service.
30. 1 kinds of graphic user interfaces of cooperation electrical form for checking cloud computing service stores on multiple client computer, the described graphic user interface on each client computer comprises:
Editor, illustrates multiple cells of the first worksheet of the cooperation electrical form that cloud computing service stores; And
Hurdle, side window in described editor, illustrates at user option multiple filtrator, and wherein said multiple filtrator is stored on the server; And
Wherein when the user on the first client computer in described multiple client computer selects the first filtrator from described multiple filtrator, described first filtrator is applied to described first worksheet and filtered first worksheet is shown in the described editor of described first client computer, unfiltered first worksheet of described editor display of the second client computer in wherein said multiple client computer.
31. graphic user interfaces according to claim 30, hurdle, wherein said side window allows the order of described user's apply filters, wherein said order from by edit commands, copy command, without filtrator order, rename order, create order, group that default command and delete command form is set select.
32. graphic user interfaces according to claim 30, wherein when described user selects filtrator order, hurdle, described side window appears in described editor.
33. graphic user interfaces according to claim 30, the described appearance of hurdle, wherein said side window can be triggered by described user.
34. graphic user interfaces according to claim 30, wherein over time, become, hurdle, described side window disappears from described editor.
35. graphic user interfaces according to claim 30, described graphic user interface is included in the filtrator menu for defining described first filtrator in described editor further.
36. 1 kinds for being provided for the method for the filtrator of the cooperation electrical form that cloud computing service stores, described method comprises:
Stored on the server by electrical form, wherein said electrical form comprises multiple worksheet;
Multiple client computer is authorized to access described electrical form concomitantly;
Multiple filtrators of first worksheet that will be applied to described multiple worksheet are received from described multiple client computer;
Be stored on described server by described multiple filtrator, wherein said multiple filtrator is associated with described first worksheet; And
Described multiple filtrator is provided to each client computer in described multiple client computer, wherein when the user on the first client computer in described multiple client computer applies the first filtrator in described multiple filtrator to described first worksheet, the display of described first worksheet on the second client computer in described multiple client computer is independent of the filtrator application on described first client computer.
37. methods according to claim 36, wherein authorize described multiple client computer to access described electrical form and are included in the copy each client computer loading described first worksheet.
38. methods according to claim 36, wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
39. methods according to claim 36, wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
40. methods according to claim 36, the second filtrator in wherein said multiple filtrator is designated as acquiescence filtrator.
41. methods according to claim 36, wherein said electrical form has determines which user can edit the Access Control List (ACL) of described multiple filtrator.
42. methods according to claim 36, wherein said server is provided for each client computer the user interface showing described first worksheet.
43. methods according to claim 42, wherein said user interface is displayed in web browser that each client computer performs.
44. methods according to claim 42, wherein said user interface allows the order of described user's apply filters, wherein said order from by edit commands, copy command, without filtrator order, rename order, create order, group that default command and delete command form is set select.
45. methods according to claim 36, described method comprises the message being applied to described first worksheet from described first filtrator of described first client computer reception further.
46. methods according to claim 45, described method comprises further and sends described message to the 3rd client computer in described multiple client computer, makes described 3rd client computer to described first filtrator of described first worksheet application.
47. methods according to claim 36, described method comprises further:
The first filtrator through editor is received from described first client computer;
Preserve described the first filtrator through editor; And
Described the first filtrator through editor is provided to each client computer.
48. methods according to claim 36, described method comprises further:
The order for deleting described first filtrator is received from described first client computer;
Delete described first filtrator on described server; And
The described order for deleting described first filtrator is sent to each client computer.
49. 1 kinds for being provided for the system of the filtrator of the cooperation electrical form that cloud computing service stores, described system comprises:
Server, is configured to:
Connected by network and communicate with multiple client computer;
Store electrons form, wherein said electrical form comprises multiple worksheet;
Described multiple client computer is authorized to access described electrical form concomitantly;
Multiple filtrators of first worksheet that will be applied to described multiple worksheet are received from described multiple client computer;
Described server stores described multiple filtrator, and wherein said multiple filtrator is associated with described first worksheet; And
Described multiple filtrator is provided to each client computer in described multiple client computer, wherein when the user on the first client computer in described multiple client computer applies the first filtrator in described multiple filtrator to described first worksheet, the display of described first worksheet on the second client computer in described multiple client computer is independent of the filtrator application on described first client computer.
50. systems according to claim 49, wherein said server is configured to, when authorizing described multiple client computer to access described electrical form, each client computer load the copy of described first worksheet further.
51. systems according to claim 49, wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
52. systems according to claim 49, wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
53. systems according to claim 49, wherein said server is configured to the user interface being provided for showing described first worksheet to each client computer.
54. systems according to claim 53, wherein said user interface is displayed in web browser that each client computer performs.
55. systems according to claim 53, wherein said user interface allows the order of described user's apply filters, wherein said order from by edit commands, copy command, without filtrator order, rename order, create order, group that default command and delete command form is set select.
56. systems according to claim 49, wherein said server is configured to further:
The first filtrator through editor is received from described first client computer;
Preserve described the first filtrator through editor; And
Described the first filtrator through editor is provided to each client computer.
57. systems according to claim 49, wherein said server is configured to further:
The order for deleting described first filtrator is received from described first client computer;
Delete described first filtrator on described server; And
The described order for deleting described first filtrator is sent to each client computer.
58. 1 kinds of non-transient computer-readable mediums storing computer executable instructions, described computer executable instructions makes described processor perform the method for the filtrator for being provided for the cooperation electrical form that cloud computing service stores when being executed by a processor, and wherein said instruction comprises:
For electrical form being stored instruction on the server, wherein said electrical form comprises multiple worksheet;
For the instruction of authorizing multiple client computer to access described electrical form concomitantly;
For receiving the instruction of multiple filtrators of first worksheet that will be applied in described multiple worksheet from described multiple client computer;
For described multiple filtrator being stored in the instruction on described server, wherein said multiple filtrator is associated with described first worksheet; And
For providing the instruction of described multiple filtrator to each client computer in described multiple client computer, wherein when the user on the first client computer in described multiple client computer applies the first filtrator in described multiple filtrator to described first worksheet, the display of described first worksheet on the second client computer in described multiple client computer is independent of the filtrator application on described first client computer.
59. non-transient computer-readable medium according to claim 58, the described instruction of wherein authorizing described multiple client computer to access described electrical form comprises the instruction of the copy for loading described first worksheet on each client computer.
60. non-transient computer-readable mediums according to claim 58, wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
61. non-transient computer-readable mediums according to claim 58, wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
62. non-transient computer-readable mediums according to claim 58, described instruction comprises the instruction for being provided for the user interface showing described first worksheet to each client computer further.
63. non-transient computer-readable mediums according to claim 62, wherein said user interface allows the order of described user's apply filters, wherein said order from by edit commands, copy command, without filtrator order, rename order, create order, group that default command and delete command form is set select.
64. non-transient computer-readable mediums according to claim 58, described instruction comprises further:
For receiving the instruction of the first filtrator through editor from described first client computer;
For preserving the instruction of described the first filtrator through editor; And
For providing the instruction of described the first filtrator through editor to each client computer.
65. non-transient computer-readable mediums according to claim 58, described instruction comprises further:
For receiving the instruction of the order for deleting described first filtrator from described first client computer;
For deleting the instruction of described first filtrator on described server; And
For sending the instruction of the described order for deleting described first filtrator to each client computer.
66. 1 kinds of methods for the treatment of the user action on cooperation electrical form, described method comprises:
With display on client computers, wherein multiple filtrator is associated with described non-filterer's tabulation non-filterer's tabulation of the electrical form that access services device stores;
Receive the selection to the first filtrator in described multiple filtrator of non-filterer's tabulation described in will being applied to of user;
Worksheet is after filtration shown, wherein by worksheet after filtration described in obtaining to described non-filterer's tabulation described first filtrator of application to described user;
Receive the user action inputted by the user on described client computer, wherein said user action is with reference to the cell of described non-filterer's tabulation;
Described user action is sent to described server;
Described user action is converted according to described first filtrator; And
Based on the user action of conversion, the display of worksheet after filtration described in renewal.
67. methods according to claim 66, wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
68. methods according to claim 66, wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
69. methods according to claim 66, wherein non-filterer's tabulation described in access comprises and the copy of described first worksheet and described multiple filtrator being loaded on described client computer.
70. methods according to claim 69, wherein described in display after filtration worksheet comprise to convert according to described first filtrator described in non-filterer's tabulation.
71. methods according to claim 66, wherein said worksheet is after filtration displayed in web browser that described client computer performs.
72. according to the method described in claim 71, and wherein said web browser display is used for the user interface that described user inputs described user action.
73. methods according to claim 66, wherein said user action is cell variation.
74. methods according to claim 66, wherein said user action is that cell presents activity.
75. 1 kinds for receiving the method for teamworker's action on cooperation electrical form, described method comprises:
With display on client computers, wherein multiple filtrator is associated with described non-filterer's tabulation non-filterer's tabulation of the electrical form that access services device stores;
Receive the selection to the first filtrator in described multiple filtrator of non-filterer's tabulation described in will being applied to of user;
Worksheet is after filtration shown, wherein by worksheet after filtration described in obtaining to described non-filterer's tabulation described first filtrator of application to described user;
Teamworker's action is received, the cell of non-filterer's tabulation described in wherein said teamworker's action reference from described server;
Described teamworker's action is converted according to described first filtrator; And
Based on teamworker's action of conversion, the display of worksheet after filtration described in renewal.
76. according to the method described in claim 75, and wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
77. according to the method described in claim 75, and wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
78. according to the method described in claim 75, and wherein non-filterer's tabulation described in access comprises and the copy of described first worksheet and described multiple filtrator being loaded on described client computer.
79. according to the method described in claim 78, wherein described in display after filtration worksheet comprise to convert according to described first filtrator described in non-filterer's tabulation.
80. according to the method described in claim 75, and wherein said worksheet is after filtration displayed in web browser that described client computer performs.
81. methods according to Claim 8 described in 0, wherein said web browser display is used for the user interface that described user inputs described user action.
82. according to the method described in claim 75, and wherein said teamworker's action is cell variation.
83. according to the method described in claim 75, and wherein said teamworker's action is that cell presents activity.
84. according to the method described in claim 75, described method comprise further to be upgraded on described client computer by described teamworker's action described in non-filterer's tabulation.
85. 1 kinds of methods for the treatment of the user action on cooperation electrical form, described method comprises:
With display on client computers, wherein multiple filtrator is associated with described non-filterer's tabulation non-filterer's tabulation of the electrical form that access services device stores;
Receive the selection to the first filtrator in described multiple filtrator of non-filterer's tabulation described in will being applied to of user;
Worksheet is after filtration shown, wherein by worksheet after filtration described in obtaining to described non-filterer's tabulation described first filtrator of application to described user;
Receive the user action inputted by the user on described client computer, wherein said user action is with reference to the cell of described worksheet after filtration;
Based on described user action, the display of worksheet after filtration described in renewal;
Described user action is converted according to the inverse of described first filtrator; And
The user action of conversion is sent to described server.
86. methods according to Claim 8 described in 5, wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
87. methods according to Claim 8 described in 5, wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
88. methods according to Claim 8 described in 5, wherein non-filterer's tabulation described in access comprises and the copy of described first worksheet and described multiple filtrator being loaded on described client computer.
89. methods according to Claim 8 described in 8, wherein described in display after filtration worksheet comprise to convert according to described first filtrator described in non-filterer's tabulation.
90. methods according to Claim 8 described in 5, wherein said worksheet is after filtration displayed in web browser that described client computer performs.
91. according to the method described in claim 90, and wherein said web browser display is used for the user interface that described user inputs described user action.
92. methods according to Claim 8 described in 5, wherein said user action is cell variation.
93. methods according to Claim 8 described in 5, wherein said user action is that cell presents activity.
94. 1 kinds of systems for the treatment of the user action on cooperation electrical form, described system comprises:
Client computer, is configured to:
Communicated with the server of trustship cloud computing service by communication connection;
Access non-filterer's tabulation of the electrical form that described server stores, wherein multiple filtrator is associated with described non-filterer's tabulation;
Receive the selection to the first filtrator in described multiple filtrator of non-filterer's tabulation described in will being applied to of user;
Worksheet is after filtration shown, wherein by worksheet after filtration described in obtaining to described non-filterer's tabulation described first filtrator of application to described user;
Receive the user action inputted by the user on described client computer, wherein said user action is with reference to the cell of described non-filterer's tabulation;
Described user action is sent to described server;
Described user action is converted according to described first filtrator; And
Based on the user action of conversion, the display of worksheet after filtration described in renewal.
95. according to the system described in claim 94, and wherein said client computer is configured to further:
Teamworker's action is received, the cell of non-filterer's tabulation described in wherein said teamworker's action reference from described server;
Described teamworker's action is converted according to described first filtrator; And
Based on teamworker's action of conversion, the display of worksheet after filtration described in renewal.
96. according to the system described in claim 94, and wherein said first filtrator comprises the order for sorting to one or more cells of described first worksheet.
97. according to the system described in claim 94, and wherein said first filtrator comprises the order of the one or more cells for hiding described first worksheet.
98. according to the system described in claim 94, wherein said client computer is configured to, when accessing described first worksheet from described server, the copy of described first worksheet and described multiple filtrator are loaded on described client computer further.
99. according to the system described in claim 94, and wherein said client computer has the web browser being configured to worksheet after filtration described in display.
100. according to the system described in claim 99, and wherein said web browser display is used for the user interface that described user inputs described user action.
CN201480021515.8A 2013-05-22 2014-05-21 Non-cooperating filter in collaborative document Active CN105122238B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811294207.9A CN109635258B (en) 2013-05-22 2014-05-21 Non-collaborative filters in collaborative documents

Applications Claiming Priority (7)

Application Number Priority Date Filing Date Title
US13/900,265 2013-05-22
US13/900,270 2013-05-22
US13/900,270 US9298688B1 (en) 2013-05-22 2013-05-22 Non-collaborative filters in a collaborative document
US13/900,193 2013-05-22
US13/900,265 US8943142B1 (en) 2013-05-22 2013-05-22 Non-collaborative filters in a collaborative document
US13/900,193 US9361287B1 (en) 2013-05-22 2013-05-22 Non-collaborative filters in a collaborative document
PCT/US2014/038934 WO2014190031A2 (en) 2013-05-22 2014-05-21 Non-collaborative filters in a collaborative document

Related Child Applications (1)

Application Number Title Priority Date Filing Date
CN201811294207.9A Division CN109635258B (en) 2013-05-22 2014-05-21 Non-collaborative filters in collaborative documents

Publications (2)

Publication Number Publication Date
CN105122238A true CN105122238A (en) 2015-12-02
CN105122238B CN105122238B (en) 2018-11-27

Family

ID=51059555

Family Applications (2)

Application Number Title Priority Date Filing Date
CN201480021515.8A Active CN105122238B (en) 2013-05-22 2014-05-21 Non-cooperating filter in collaborative document
CN201811294207.9A Active CN109635258B (en) 2013-05-22 2014-05-21 Non-collaborative filters in collaborative documents

Family Applications After (1)

Application Number Title Priority Date Filing Date
CN201811294207.9A Active CN109635258B (en) 2013-05-22 2014-05-21 Non-collaborative filters in collaborative documents

Country Status (4)

Country Link
EP (1) EP3000055A4 (en)
CN (2) CN105122238B (en)
DE (1) DE202014010948U1 (en)
WO (1) WO2014190031A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109313656A (en) * 2016-06-17 2019-02-05 皇家飞利浦有限公司 The filtering of data guidance

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10216494B2 (en) 2016-12-03 2019-02-26 Thomas STACHURA Spreadsheet-based software application development
US11726753B2 (en) 2016-12-03 2023-08-15 Thomas STACHURA Spreadsheet-based software application development
US10540153B2 (en) 2016-12-03 2020-01-21 Thomas STACHURA Spreadsheet-based software application development
PL3718000T3 (en) * 2017-12-03 2024-02-05 Thomas Stachura Spreadsheet-based software application development
US20200372210A1 (en) * 2019-05-23 2020-11-26 Sigma Computing, Inc. Using lightweight references to present a worksheet

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6212549B1 (en) * 1997-10-06 2001-04-03 Nexprise, Inc. Trackpoint-based computer-implemented systems and methods for facilitating collaborative project development and communication
US20060129914A1 (en) * 2004-12-15 2006-06-15 Microsoft Corporation Filter and sort by color
US7233951B1 (en) * 2004-02-18 2007-06-19 Microsoft Corporation Spreadsheet grid-like control for a web-based collaboration system
US20090112990A1 (en) * 2007-10-25 2009-04-30 Microsoft Corporation Private views of data and local calculations during real time collaboration
US20100185733A1 (en) * 2006-01-24 2010-07-22 Henry Hon System and method for collaborative web-based multimedia layered platform with recording and selective playback of content
CN101828166A (en) * 2007-10-19 2010-09-08 微软公司 The virtual list view that dynamically updates
US8108779B1 (en) * 2008-12-16 2012-01-31 Adobe Systems Incorporated Collaborative editing operations
US20120192055A1 (en) * 2011-01-21 2012-07-26 Oudi Antebi Distributed document co-authoring and processing
CN102708123A (en) * 2011-02-25 2012-10-03 微软公司 Named object view of electronic data report

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8255791B2 (en) * 2000-11-29 2012-08-28 Dov Koren Collaborative, flexible, interactive real-time displays
US20050114169A1 (en) * 2003-11-24 2005-05-26 Hazim Ansari Systems and methods for evaluating information to identify, and act upon, intellectual property issues
US7849090B2 (en) * 2005-03-30 2010-12-07 Primal Fusion Inc. System, method and computer program for faceted classification synthesis
US9942271B2 (en) * 2005-12-29 2018-04-10 Nextlabs, Inc. Information management system with two or more interactive enforcement points
US8341163B2 (en) * 2008-06-17 2012-12-25 Microsoft Corporation Techniques for filter sharing

Patent Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6212549B1 (en) * 1997-10-06 2001-04-03 Nexprise, Inc. Trackpoint-based computer-implemented systems and methods for facilitating collaborative project development and communication
US7233951B1 (en) * 2004-02-18 2007-06-19 Microsoft Corporation Spreadsheet grid-like control for a web-based collaboration system
US20060129914A1 (en) * 2004-12-15 2006-06-15 Microsoft Corporation Filter and sort by color
US20100185733A1 (en) * 2006-01-24 2010-07-22 Henry Hon System and method for collaborative web-based multimedia layered platform with recording and selective playback of content
CN101828166A (en) * 2007-10-19 2010-09-08 微软公司 The virtual list view that dynamically updates
US20090112990A1 (en) * 2007-10-25 2009-04-30 Microsoft Corporation Private views of data and local calculations during real time collaboration
CN101836198A (en) * 2007-10-25 2010-09-15 微软公司 The private views of data and local calculating during the live collaboration
US8190987B2 (en) * 2007-10-25 2012-05-29 Microsoft Corporation Private views of data and local calculations during real time collaboration
US20120216103A1 (en) * 2007-10-25 2012-08-23 Microsoft Corporation Private views of data and local calculations during real time collaboration
US8108779B1 (en) * 2008-12-16 2012-01-31 Adobe Systems Incorporated Collaborative editing operations
US20120192055A1 (en) * 2011-01-21 2012-07-26 Oudi Antebi Distributed document co-authoring and processing
CN102708123A (en) * 2011-02-25 2012-10-03 微软公司 Named object view of electronic data report

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109313656A (en) * 2016-06-17 2019-02-05 皇家飞利浦有限公司 The filtering of data guidance

Also Published As

Publication number Publication date
CN109635258A (en) 2019-04-16
CN105122238B (en) 2018-11-27
CN109635258B (en) 2020-03-06
DE202014010948U1 (en) 2017-01-27
WO2014190031A2 (en) 2014-11-27
EP3000055A4 (en) 2017-05-17
WO2014190031A3 (en) 2015-04-23
EP3000055A2 (en) 2016-03-30

Similar Documents

Publication Publication Date Title
JP7460689B2 (en) Software application development based on spreadsheets
US11438286B2 (en) Systems and methods for email attachments management including changing attributes
JP5349484B2 (en) Private view of data and local computation during real-time collaboration
CN103907110B (en) A kind of method and system for document collaboration
CN105122238A (en) Non-collaborative filters in a collaborative document
CN102262620B (en) Document cooperation method
CN102508840B (en) Concurrent editing of online drawings
KR101794373B1 (en) Temporary formatting and charting of selected data
CN108345456A (en) Page code generation method, device, computer equipment and storage medium
US20150120823A1 (en) Combining server-side and client-side user interface elements
US20140101635A1 (en) Automated generation of two-tier mobile applications
CN102939584A (en) List integration
CN105190604A (en) Tracking changes in collaborative authoring environment
CN107748740A (en) spreadsheet object without code sharing
CN112464623A (en) RPA flow file generation method and device, computer equipment and storage medium
US20150058282A1 (en) Assigning and managing reviews of a computing file
CN107924391A (en) The method and apparatus of shared collaborative editing document
CN108369577A (en) Content is shared between electronic document
Whiting et al. Creating an iPhone application for collecting continuous ABC data
US11120200B1 (en) Capturing unstructured information in application pages
US10719408B2 (en) Retain locally deleted content at storage service
JP2022508086A (en) Systems and methods for creating and processing configurable applications for website building systems
US8943142B1 (en) Non-collaborative filters in a collaborative document
US10970050B1 (en) User interface engine for miniapp development
US20120317171A1 (en) System and Method for Sharing Web Contents for Building Rich Internet Applications

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information
CB02 Change of applicant information

Address after: American California

Applicant after: Google limited liability company

Address before: American California

Applicant before: Google Inc.

GR01 Patent grant
GR01 Patent grant