CN109635258A - Non-cooperating filter in collaborative document - Google Patents
Non-cooperating filter in collaborative document Download PDFInfo
- Publication number
- CN109635258A CN109635258A CN201811294207.9A CN201811294207A CN109635258A CN 109635258 A CN109635258 A CN 109635258A CN 201811294207 A CN201811294207 A CN 201811294207A CN 109635258 A CN109635258 A CN 109635258A
- Authority
- CN
- China
- Prior art keywords
- filter
- worksheet
- user
- client computer
- teamworker
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- User Interface Of Digital Computer (AREA)
- Information Transfer Between Computers (AREA)
- Document Processing Apparatus (AREA)
- Stored Programmes (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The system and method for filter for checking on the cooperation electrical form stored on cloud computing service include the first worksheet of the electrical form stored from each client computer access cloud computing service in multiple client computer, and plurality of filter is associated with the first worksheet.The first client computer in multiple client computer receives the order to the first worksheet using the first filter in multiple filters of the first user, and the first worksheet on the first client computer applies the first filter.Filtered first worksheet is shown to the first user, and the second client computer in multiple client computer concomitantly shows unfiltered first worksheet.
Description
The application be the applying date be on May 21st, 2014, application No. is 201480021515.8, entitled " cooperation
The divisional application of the application for a patent for invention of non-cooperating filter in document ".
Cross reference to related applications
This application claims the priority for the U.S. Patent Application No. 13/900,193 that on May 22nd, 2013 submits, by drawing
It is integrally incorporated with mode in this;The priority for the U.S. Patent Application No. 13/900,265 that on May 22nd, 2013 submits is led to
Way of reference is crossed to be integrally incorporated in this;And the U.S. Patent Application No. 13/900,270 submitted on May 22nd, 2013
Priority is integrally incorporated by reference in this.
Technical field
This application involves the non-cooperating filters in collaborative document.
Background technique
Cloud computing service provides the method for cooperation identical document to multiple people at multiple positions.Cloud computing service will be literary
Shelves primary copy be stored on one or more data servers, and user by the telecommunication network of such as internet etc come
Access document.The document that can be created, store and edit on cloud computing service includes word processing document, presentation file and electronics
Table.When user's access stores the document on cloud computing service, the local replica of document is loaded in client computer
On.User is communicated to cloud computing server to the change that document is made to record.If two or more teamworkers are same
When edit identical document, then the change that a user makes also promptly travels to other users.
Addressable cooperation electrical form can have available electronics on many and stand-alone computer on cloud computing service
The identical function of table.Obtainable function may include changing how to arrange and show data using filter.For example, mistake
Filter can be used in some way being ranked up the row or column of data, and can be used for hiding from view certain rows or
Column.As other variations of such as unit table entry and row/column insertion or deletion etc, filter can be considered as to work
The editor of table or variation.When the user of editor's cooperation electrical form is to spreadsheet application filter, filter is also sent
To other teamworkers and it is applied to their electrical form copy.Thus when user applies filter, the electricity of teamworker
The view of sub-table will change automatically.For other teamworkers for checking the data influenced by filter, this may
It is to interfere.In addition, if two or more teamworkers want the different filters that application influences the data set of overlapping, two cooperations
Person has no idea using desired filter without interfering with each other.Equally, the teamworker of electrical form has no idea to store multiple
Filter and independently of each other apply filter.
Summary of the invention
The method that one aspect described herein is openly used to handle the user action on cooperation electrical form, this method
It include: not filtering for the electrical form stored from each client computer access server in multiple client computer
Worksheet is to be shown on the first client computer, and plurality of filter is associated with non-filtration table, and wherein
Each filter in multiple filters is by each client computer simultaneous selection in multiple client computer;From first
Client computer receive the first user to the first filter in the multiple filters that be applied to non-filtration table
Selection, wherein first filter is created on the second client computer by second user;It shows to the first user through filterer
Make table, wherein being obtained and to non-filtration table application first filter through filtering worksheet;Reception is existed by the first user
The user action inputted on first client computer, wherein user action refers to the cell of non-filtration table;To service
Device sends user action;User action is converted according to first filter;And it based on transformed user action, updates and passes through
Filter the display of worksheet.
The method that one aspect described herein is openly used to receive teamworker's movement on cooperation electrical form, the party
Method includes: to access the non-filtration table of the electrical form stored on server to be shown on the first client computer,
In each filter in multiple filters filter associated and plurality of with non-filtration table by multiple client
Each client computer simultaneous selection in computer;From the first client computer receive the first user to being applied to
The selection of first filter in multiple filters of non-filtration table, wherein first filter is by second user in the second visitor
It is created on the computer of family end;It shows to the first user through filtering worksheet, wherein by applying the first mistake to non-filtration table
Filter and obtain through filter worksheet;Teamworker's movement is received from server, wherein the non-filtration table of teamworker's action reference
Cell;Teamworker's movement is converted according to first filter;And acted based on transformed teamworker, it updates through filtering
The display of worksheet.
The system that one aspect described herein is openly used to handle the user action on cooperation electrical form, the system
Include: the first client computer, be configured as: by communicating to connect the server communication with trustship cloud computing service;Access
The non-filtration table of the electrical form stored on server, plurality of filter is associated with non-filtration table, and
Each filter in plurality of filter is by each client computer simultaneous selection in multiple client computer;It connects
The selection to the first filter in the multiple filters that be applied to non-filtration table for receiving the first user, wherein the first mistake
Filter is created on the second client computer by second user;To the first user show through filter worksheet, wherein pass through to
Non- filtration table application first filter and obtain through filter worksheet;It receives defeated on client computers by the first user
The user action entered, wherein user action refers to the cell of non-filtration table;User action is sent to server;According to
One filter converts user action;And based on transformed user action, update the display through filtering worksheet.
System and method described herein are provided for multiple teamworkers independently using for depositing on cloud computing service
The method of the filter of the electrical form of storage.Cloud computing service stores its one or more worksheet that may include cell
Electronic form file.Cloud computing service also stores several filters for each worksheet.Filter can be by having to electricity
Any teamworker of the write access of sub-table creates and saves.Filter can be for sorting, hiding or with other sides
Formula arranges the instruction of row and cell in the display of worksheet.User's load on client computer comes from cloud computing service
Electrical form worksheet local replica and its associated filter.Worksheet is displayed at client computer
In user interface, such as in web browser.Available filter may be displayed on sidebar window.When user's selection will answer
When filter for worksheet, filter is only applied to the local replica of worksheet and shows to user.Unlike worksheet
Normal editor, filter selection will not be communicated to other teamworkers.It is current that cloud computing service can track different teamworkers
The filter just used, but the primary copy of the worksheet stored is not influenced by user's selection of filter.User can be with
Default filter for worksheet is set, all filters applied to worksheet can be removed, and can create, compile
It collects, renaming, replicate or delete filter.By user make to through filter worksheet editor or variation can refer to non-mistake
Filter worksheet is stored through filtering worksheet by client computer.If variation refers to non-filtration table, make a variation
Cloud computing service can be sent straight to for storage and be sent to other teamworker's client computers, in Xiang Xiezuo
Before person shows variation, other teamworker's client computers are according to any filter applied on teamworker's client computer
Variation is converted.If variation is being sent to cloud computing service and teamworker's client with reference to through filtering worksheet
Before computer, inverse according to filter converts them.To which multiple teamworkers can check simultaneously applied to same
Multiple filters of worksheet.
One aspect described herein discloses the mistake for checking on the cooperation electrical form stored on cloud computing service
The method of filter.Method includes storing from each client computer access cloud computing service in multiple client computer
Electrical form the first worksheet, plurality of filter is associated with the first worksheet.Method further comprises: multiple
Being used for the first worksheet using multiple filterings for the first user is received at the first client computer in client computer
The order of first filter in device;And the first worksheet application first filter on the first client computer.Side
Method further comprises that filtered first worksheet is shown to the first user, the second client in plurality of client computer
End computer concomitantly shows unfiltered first worksheet.
Another aspect described herein is openly used to create the cooperation electrical form for storing on cloud computing service
The method of filter.Method includes: from each client computer access cloud computing service in multiple client computer
First worksheet of the electrical form of storage;And is created on the first client computer in multiple client computer
One filter, wherein the user on the first client computer defines first filter.Method further comprises: to the first client
Hold the first worksheet application first filter on computer, the second client computer in plurality of client computer
Concomitantly show unfiltered first worksheet;And first filter is sent to cloud computing service, for storage and with the
One worksheet is associated.
Another aspect described herein discloses the filtering of the cooperation spreadsheet application for storing on cloud computing service
The system of device.System includes client computer, and client computer is configured as: by network connection with cloud computing service and
Multiple client computer is communicated;And the first worksheet of the electrical form stored on load cloud computing service, wherein
Multiple filters are associated with the first worksheet.Client computer is configured to: being received from user for first
Worksheet applies the order of the first filter in multiple filters;The first worksheet application on the first client computer
First filter;And filtered first worksheet is shown to user, the first client in plurality of client computer
End computer concomitantly shows unfiltered first worksheet.
Another aspect described herein is disclosed to be stored on cloud computing service for checking on multiple client computer
Cooperation electrical form graphic user interface.Graphic user interface on each client computer includes: editor, is shown
Multiple cells of first worksheet of the cooperation electrical form stored on cloud computing service out;And the side in editor
Column window, shows at user option multiple filters, and plurality of filter is stored on server.Graphic user interface
It is further designed to so that user on the first client computer in the multiple client computer is from multiple filters
When middle selection first filter, first filter is applied to the first worksheet, and filtered first worksheet is shown in
In the editor of first client computer, editor's window of the second client computer in plurality of client computer
Mouth shows unfiltered first worksheet.
Detailed description of the invention
Referring to attached drawing, method and system may be better understood from following illustrative description, in which:
Fig. 1 shows taking with the cloud computing for storing one or more electrical forms according to embodiment as described in this article
Several client computers that business is communicated;
Fig. 2 shows the servers of the realization cloud computing service according to embodiment as described in this article;
Fig. 3 is shown according to embodiment as described in this article for loading the electrical form stored on cloud computing service
Client computer;
Fig. 4 shows the work of the cooperation electrical form stored on the cloud computing service according to embodiment as described in this article
Make table;
Fig. 5 shows the cooperation electrical form for storing on cloud computing service according to embodiment as described in this article
Worksheet filter option;
Fig. 6 shows the warp of the cooperation electrical form stored on the cloud computing service according to embodiment as described in this article
The worksheet of filtering;
Fig. 7 shows the cooperation electronic watch for storing on cloud computing service according to embodiment as described in this article
The sidebar window of the worksheet application filter of lattice;
Fig. 8 is shown according to embodiment as described in this article for handling for the cooperation stored on cloud computing service
The diagram of teamworker's variation of electrical form;
Fig. 9 is shown according to embodiment as described in this article for handling for the cooperation stored on cloud computing service
Another diagram of teamworker's variation of electrical form;
Figure 10 is shown according to embodiment as described in this article for checking the cooperation stored on cloud computing service electricity
The method of filter in sub-table;
Figure 11 is shown according to embodiment as described in this article for creating the association for storing on cloud computing service
Make the method for the filter of electrical form;
Figure 12 is shown according to embodiment as described in this article for providing the cooperation electricity for storing on server
The method of the filter of sub-table;
Figure 13 is shown according to the dynamic about the user of cooperation electrical form for handling of embodiment as described in this article
The method of work;
Figure 14 is shown according to embodiment as described in this article for receiving the teamworker about cooperation electrical form
The method of movement;And
Figure 15 is shown according to the dynamic about the user of cooperation electrical form for handling of embodiment as described in this article
The another method of work.
Specific embodiment
In order to provide the entirety understanding to system and method described herein, certain illustrative implementations will now be described
Example, including the independent filter of the cooperation electrical form stored on cloud computing service is used for providing teamworker system with
Method.It will be appreciated, however, that as words system and method described herein appropriate can be adapted and be modified for just handling
Application, and system and method described herein can be used in other suitable application, and such other add
Adduction modification is without departing from its range.Specifically, server as used in this description, service or system can be single meter
Calculation equipment or teamwork and the wherein storage of data and the execution of function are unfolded multiple between various calculating equipment
Calculate equipment.
It is related to providing to multiple teamworkers in terms of system and method described herein and independently utilizes for cloud computing
The method of the ability of the filter of the cooperation electrical form stored in service.Cloud computing service storage includes one or more of data
The electronic form file of a worksheet.Cloud computing service also stores several filters for each worksheet.Filter can be with
It is created and is saved by the write access to electrical form by any teamworker.Filter can be for the display from worksheet
It sorts or hides the instructions of certain values.User on client computer loads electronics from cloud computing service using web browser
The local replica of the worksheet of table and its associated filter.Filter is displayed on filter circle in web browser
On face, such as on sidebar window.When user selects the filter applied to worksheet, filter is applied only to worksheet
Local replica and shown to user.Unlike the normal editor to worksheet, filter will not be conveyed to select to other teamworkers
It selects.To which each teamworker can be selected independently and check different filters.Filter interface can be used to set in user
The default filter for worksheet is set, all filters applied to worksheet is removed and creates, editor, rename, is multiple
System deletes filter.By user make to through filtering worksheet editor or variation can with reference to non-filtration table or
It is stored through filtering worksheet by client computer.If variation refers to non-filtration table, variation can directly be sent out
It is sent to cloud computing service for storage and is sent to other teamworker's client computers, showing variation to teamworker
Before, other teamworker's client computers according to any filter applied on corresponding teamworker's client computer to make a variation into
Row transformation.If variation with reference to through filtering worksheet, be sent to cloud computing service and teamworker's client computer it
Before, inverse according to filter converts them.
Firstly, describing wherein several client computers may be coupled to the client server system of cloud computing service.
Fig. 1 shows the client server system 100 including cloud computing service 102 and several client computer 104a to 104d.
Cloud computing service 102 may include providing one or more servers of cloud computing service to multiple client computer collective.
The storage of cloud computing service 102 is by the addressable several texts including cooperation electrical form 106 of client computer 104a-104d
Part.User can create, edit, copy, share and delete the file stored on cloud computing service 102.For example, client calculates
Machine 104a-104d can be used web browser while access the electrical form 106 on cloud computing service 102.Cloud computing service
102 provide the local replica of electrical form 106 to each client computer, the user on client computer can check and
Edit the local replica.The editor's (further referred to as making a variation) made by client computer 104a is automatically sent to cloud computing clothes
Business 102 and is transferred to other client computer 104b-104d.Variation to be made by a teamworker is immediately by it
His teamworker sees.Client computer 104a-104d may include desktop computer, laptop computer, tablet computer, intelligence
It can phone, mobile electronic device or any other equipment that cloud computing service 102 can be connected to by telecommunication network.System
System 100 may include many client computers connecting with cloud computing service 102.The cloud computing service 102 of system 100 and visitor
Family end computer 104a-104d is connected by the telecommunication network of such as internet etc.By local area network, wide area network, Ethernet,
Fiber optic network or any other wired or wireless connection can be in order to being connected to the network.
It is more fully described now for providing the server of cloud computing service.Server 200 in Fig. 2 show for
The example of server used in cloud computing service.Cloud computing service may include that collective provides several services of cloud computing service
Device.Server 200 includes central processing unit (CPU) 202, read-only memory (ROM) 204, random access memory (RAM)
206, communication unit 208, data storage 210 and bus 212.Server 200 can have additional component (not shown) in Fig. 2.
Bus 212 allows the various parts of server 200 to communicate with one another.Communication unit 208 allows server 200 and such as several clients
Hold the other equipment communication of computer etc.Inter alia, data storage 210 can store it can be by several clients
The file that computer is accessed, viewed or edited.These files may include word processing file, demonstration document, electrical form or more
Media file.Each file in data storage 210 can be associated with accesses control list (ACL), accesses control list
(ACL) determine attempt to check the user of the file in data storage 210 access authority (for example, write access, read access, cannot
Access).User is connect to access the file stored in data storage 210 with server 200 by communication unit 208.
The client computer for accessing the file stored on cloud computing service is more fully described now.In Fig. 3
Client computer 300 includes central processing unit (CPU) 302, 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 in Fig. 3
Additional component (not shown).Bus 312 allows the various parts of client computer 300 to communicate with one another.Input/output interface
308 permission client computers 300 are communicated with the other equipment of such as cloud computing service etc, and further include using for receiving
Equipment family input and show output to user.Inter alia, web browser 310 is for providing user interface to look into
See and edit the file stored on cloud computing service.Web browser 310 also shows and can be edited by it and client computer
The variation that other teamworkers of the same file of 300 user make.Cloud computing service can be determined and be shown in web browser 310
The layout for the user interface for accessing and checking file shown.
The data of file in Fig. 2 for storing on cloud computing service 200 store in 210, Fig. 3 for client computer
Other data structures and software journey in 300 web browser 310 and cloud computing service 200 and client computer 300
Non-transient computer-readable media can be used to realize in sequence.The example of suitable non-transient computer-readable media includes all
Nonvolatile memory, medium and the memory devices of form include: semiconductor memory devices, example by way of example
Such as EPROM, EEPROM and flash memory device;Disk, such as internal hard drive or removable disk;Magneto-optic disk;And readable,
Writable disposable or re-writable CD-ROM and DVD-ROM disk.
The operation to the cooperation electrical form stored on cloud computing service will now be described.Fig. 4 shows and deposits on cloud computing service
The worksheet 400 of the cooperation electrical form of storage.Cooperation electrical form is that it can be by more than one user while access and editor
Electronic form file.Cooperation electrical form may include one or more worksheets, wherein each worksheet includes cell
Grid.For example, worksheet 400 includes the data in several cells, wherein the data of same type are listed in column 402
And data associated with same people, which are arranged, is expert in 404.Worksheet 400 may include with the arrangement of any possible configuration
The data of any amount, and it is not limited to layout shown in Fig. 4.Data in worksheet 400 can be as shown in Figure 1 by being connected to
One or more users of cloud computing service are inputted using client computer.User can carry out write access to worksheet 400
Or read access can be only carried out, user can check but cannot edit data in read access.With the electrical form that cooperates
Associated ACL can determine the access authority for attempting to access that the user of electrical form.
Cloud computing service can provide a user a variety of function for creating, manipulating and showing the data on electrical form
Energy.One such function is known as filtering.Filtering may include according to one or more criterion (for example, alphabet sequence or pressing
Number) it sorts the data, and may include and hide certain data values, row or column from display.Filter can be stored as several
According to transformation model, Regression Transformation Models map before showing it or the bottom data of conversion electron table is (for example, for display
Cell data are assigned to the transformation of new cell by purpose on the screen).Fig. 5, which is shown, to be stored on cloud computing service
The example of the filter menu of the worksheet 500 of cooperation electrical form.Worksheet 500 includes column heading, and column heading includes " age "
" score ".When user opens filter option, each column can show dropdown arrow 504.When user selects dropdown arrow,
It can show the filter menu 502 for the column.For example, when selection is used for the filter dropdown arrow of " age " column, mistake
Filter menu 502 occurs, and gives the user for using the number for carrying out filtration table 502 to the criterion of " age " column application
According to several modes.Filter menu 502 includes the sequence function that it can be ranked up by row of the particular order to worksheet 502
Energy 506.For example, can be arranged according to the number in " age " column row 1-6 if user's selection " sorting from small to large "
Sequence, so that the row with the minimum value age occurs first, and the row with the greatest measure age finally occurs.Filter dish
Single 502, which also allow the user to use data check box 512, carrys out hiding data.Data check box 512 shows all in " age " column
The data value of record.When data value is unselected, any row comprising the data value is hidden from the display of worksheet 500.
Filter menu 502 can be provided for selecting all data values or remove from data check box 512 to all data values
Selection shortcut key 508, and the search box of the particular data value for searching in data check box list can be provided
510.Filter menu 502 can be provided for using filter or cancel " determining (OK) " and the " Cancel " button of application.
Filtering can not also be only applied to arrange, but be applied to capable or cell selection.User highlights user and wants filtering
Cell, row or column, and then call filter function.Filter menu 502 may include unshowned other numbers in Fig. 5
According to sequence and filtering option.
The example through filtering worksheet in cooperation electrical form is shown in Fig. 6.For example, the worksheet 400 of Fig. 4 is considered as
Non- filtration table.Filter menu of user's selection for " age " column, and the age is ranked up from small to large, and
The data check box of non-selected data value " 18 ".This filter will arrange the row of worksheet 400 according to the age, and hide it
Middle age value is 18 any row.Worksheet 600 in Fig. 6 shows the knot to this filter of non-filtration table 400 application
Fruit.As can be seen, the row of worksheet 600 be arranged as so that the smallest age up front, and the maximum age exists
Finally.In addition, because age value associated with name " Tyrone " is 18, the entire row of " Tyrone " entry is from worksheet 600
It is hidden in display.By omitting the row number of the hidden rows in linage-counter, worksheet 600 can indicate that row is filtered
Device is hidden.For example, there is no row " 5 " in Fig. 6.By selecting the filter dropdown arrow of the column, user can edit or cancel
Filter on " age " column.User can also create another filter using filter dropdown arrow appropriate.
In general, when editing the user of the cooperation electrical form stored on cloud computing service to worksheet application filter,
Filter be transferred to cloud computing service and its also in any other teamworker for checking worksheet.To at any one
Worksheet can be applied to by carving only one filter, and multiple teamworkers cannot apply filter independently of one another.Such as
The multiple teamworkers of fruit wish to filter overlapped data collection in different ways, then this may be problematic, because worksheet will be only aobvious
Show newest filter.It saves multiple filters in addition, cloud computing service can not provide a user and allows multiple teamworkers only
The ability of these filters saved of habitat location.
The system and method for the application provide independently to teamworker to the worksheet application filter of cooperation electrical form
Ability.For each worksheet in cooperation electrical form, cloud computing service stores multiple mistakes associated with the worksheet
Filter.When the user on client computer accesses the worksheet of cooperation electrical form, cloud computing service is calculated to client
Machine provides the local replica of worksheet and the copy of multiple filters associated with the worksheet.Access cooperation electrical form
Other teamworkers also receive the local replica of worksheet and filter.When user selects filter to be applied to worksheet,
Filter converts the data on the local replica of worksheet, and shows to user through filtering worksheet.Unlike normal variant, use
Family will not be communicated to other teamworkers to the selection of filter.To which filter will not be automatically applied to teamworker's client meter
Worksheet shown by calculation machine.Each teamworker can independently be stored on cloud computing service cooperation electrical form it is same
Worksheet applies different filters.User can be communicated to cloud computing service to the selection of filter, or can be basic
It does not convey.
Web browser can be used to show the cooperation electrical form stored on cloud computing service in client computer.Cloud
The service of calculating provides the user interface (UI) to show in web browser.UI allows user to check and edit cooperation electronic watch
The worksheet of lattice and the electrical form function of calling such as filtering etc.Fig. 7 shows the work for showing cooperation electrical form
Make the example of the UI 700 of table.UI 700 is shown to indicate several units of the data of the column arrangement for going and indicating letter of number
Lattice.UI 700 includes for the sidebar window 702 to worksheet application filter.Sidebar window 702, which is shown, can be applied to work
Make the filter list of table.For example, filter 704 is " no filter " option, when selected, moved from the display of worksheet
Except all filters.Being named as the filter 706 " more than 20 " may be implemented the filter described about Fig. 6, i.e. " age " column
It sorts from small to large and any age value equal to 18 is removed from display.Another filter 710 is named as " filter 2 ".
Each filter can have its drop-down menu 708 that can be selected.Drop-down menu 708 includes for replica filter, again
Name filter deletes filter or makes filter order of the selected filter as default filter.Filter 704,
706 or 708 can mark the symbol of asterisk etc, to indicate which filter is default filter.For positive work
The current filter for making table application can be highlighted or overstriking, to indicate which filter is active.There is also for creating
The filter order 712 of new filter.Selection filter order 712 can be generated similar to filter menu 502 shown in fig. 5
Filter editor, allow user to define filter.User can create filter without saving filter, or
Filter can be saved and name, filter will be added to filter list shown in sidebar window 702 in this case.
Sidebar window 702 may include unshowned other filter orders in Fig. 7.For example, drop-down menu 708 can have for making
Filter is privately owned or common option.If keeping filter privately owned, filter can be used without other teamworkers.UI 700 is also
Independent ranking function independently of filter function can be provided.When user uses the ranking function pair opposite with filter function
When worksheet data is ranked up, it can be considered as making a variation.To sequentialize commands be sent to cloud computing service and other
Teamworker shows their data to be automatically updated.If user arranges worksheet data using filter function
Sequence, order are not sent to other teamworkers.In any option, when the cell value influenced by ranking criteria changes, work
The display for making table can be automatically updated to reflect new sequence.
When user is from menu selection filter option on UI 700, sidebar window 702 can occur, or work as user
Sidebar window 702 can be called when editing filter.Filter, sidebar window are enlivened simply by the presence of applied to worksheet
702 can open, and when not having active filter on worksheet, sidebar window 702 can disappear.When user does not use
Sidebar window for a period of time (such as user stop editor filter after a period of time) when, sidebar window 702 can gradually disappear
It loses.Sidebar window 702 can be minimized, triggers (toggle) or be closed by user or user can move sidebar window 702
Position in UI 700.Filter can be enlivened from the display of worksheet removal is all by closing sidebar window 702.Alternatively,
Sidebar window 702 can stay open, and and if only if when user deactivates all filters (i.e. selection " no filter " option), can
To disappear.Only when the cell or editor's filter that user's selection is influenced by filter, sidebar window 702 can occur.
There may be other movements by user that it can make sidebar window 702 occur or disappear from UI 700.UI 700 can
To provide the help link with the explanation how operated to sidebar window 702.UI 700 can be used including HTML and
Any known web browser programming language of JavaScript is realized.
Filter model can be stored on cloud computing service and client computer as with several defined attributes
Data structure.For example, filter model may include the unique identifier (such as alphanumeric character string) for filter
And the title provided from user to filter.Filter model includes the range of cells of filter application above.It crosses
Filter model can also include the list of ranked row sequence, wherein the row of non-filtration table is reflected according to filter criteria
It is mapped to the row through filtering worksheet.Filter model can also include boolean's list of hidden rows, indicate certain be about to from view
In figure hide also be to maintain it is visible.Filter model can also include the list for excluding data, check box 512 in tracing figure 5
User selection.Filter model can also include the mark of the user of its creation or last modification filter.Unlisted its
Its information may also be included in that in filter model.Each associated data structure of filter, and when load association
When making the worksheet of electrical form, this data structure is sent to client computer from cloud computing service.To filter
Editor changes data structure, and is communicated to cloud computing service and other teamworkers.
The user action inputted to sidebar window 702 can be communicated to cloud computing service.For example, if user creation or
Duplication is used for the new filter of worksheet, and client computer can create filter model and send it to cloud computing clothes
Business is to be stored as filter associated with worksheet.If user deletes filter associated with worksheet, client meter
Calculation machine can send request to cloud computing service to delete the correspondence primary copy of filter.If user edits or renames filtering
Device, client computer changes the filter model of its storage, and sends cloud computing clothes for compiled filter model
Business, then cloud computing service will update the primary copy of filter model.If filter is set default filter by user,
Client computer can send request to cloud computing service to set default filter for the primary copy of the filter.Then
The copy of non-filtration table will be received from any teamworker of cloud computing service access worksheet, and defaulting filter will be certainly
Dynamic application.If user carries out write access (for example, pass through ACL determine) electrical form, user can be created, Bian Jihuo
Delete filter.If user carries out read access to electrical form, cloud computing service can permit user using filter, but
It is that may not allow user's creation, editor or delete filter.User is to the creation of filter, editor or deletes and can be sent
To other teamworkers of cloud computing service and current accessed electrical form.So while rearranging data not using filter
It can be communicated to teamworker, but teamworker is communicated to the change of filter itself.
It, can reference unit lattice --- reference in two ways when to the worksheet application filter of cooperation electrical form
Non- filtration table or through filter worksheet.For example, working as ginseng in the case where application " more than 20 " filter in UI 700
When examining through filtering worksheet, name entries " Ni Ke " are appeared in cell A4.However, when referring to non-filterer shown in Fig. 4
When making table, name " Ni Ke " is actually in cell A2.Filter is considered the cell in non-filtration table
Mapping or transformation between the cell through filtering worksheet.Process is generated and to non-filtration table application filter
Worksheet is filtered, and is shown through filtering worksheet by client computer.When editor or variation of user's input to worksheet,
Variation can refer to the cell of non-filtration table or can refer to the cell through filtering worksheet.In addition, user is in
Existing information can be sent to other teamworkers.For example, if user highlights cell A1-A5, teamworker's client
User interface on computer can show that user has been highlighted those cells.Information is presented in variation and user can be with
It is referred to as user action.Fig. 8 shows the system for handling the user action for being directed to cooperation electrical form, wherein with reference to not filtering
Worksheet makes user's input.System 800 includes the cloud computing service 802 of the primary copy of storage cooperation electrical form 804.Cooperation
Electrical form 804 may include one or more worksheets, and each worksheet can be related to one or more filters
Connection.Two client computers 806 and 812 are connected to cloud computing service 802 to access the electrical form 804 that cooperates.As each visitor
When family end computer access cooperation electrical form, the local replica of cooperation electrical form 804 is loaded into each client and calculates
On machine, it is shown as local replica 810 and 816.Local replica includes the copy of at least one worksheet and associated for the work
Make the filter of table.
Local replica 810 application of the user to its electrical form that cooperates on client computer 806 is named as " filter
1 " filter 808.Filter converts the cell of non-filtration table, and rearrangement unit lattice to user to show.
Similarly, user's selection on client computer 812 is shown as " filter 2 " of filter transformation 814 to be applied to its cooperation
The local replica 816 of electrical form.Each client computer will not be communicated to other client meters to the selection of filter
Calculation machine, and so that each user not will receive the influence of other users to the selection of filter.806 He of client computer
812, which can send filter to cloud computing service 802, selects information.User on client computer is to 810 He of local replica
816 take user action.It is with reference to non-filtration table or through filtering worksheet, by client computer according to user action
User action is handled with cloud computing service 802.
Fig. 8 is shown when user action is with reference to non-filtration table through filtering showing for the user action processing of electrical form
Example.In this case, what the local replica 810 and 816 stored on client computer always stored worksheet does not filter pair
This, any filter 808 or 814 that may be applied to worksheet but regardless of user.User initiates it and refers to non-filtration table
Cell user action 818.Only when showing worksheet to user, filter 808 and 814 is applied to not filter local
Copy 810 and 816.For example, it is assumed that filter is by the data permutation in the cell A1 of worksheet to cell D5.When with
When the filter is applied to worksheet in family, the bottom that filter will not change the worksheet stored on client computer is local secondary
This.More precisely, client computer never filter local replica calculate worksheet through filtering version, and show process
Filter worksheet.This is stored in temporary storage through filtering worksheet, and whenever showing that the worksheet on screen refreshes,
It can be recalculated.To which although client computer screen shows data in cell D5, the local pair of worksheet
Originally it stores data in cell A1.When user inputs user action, reference work table does not filter local replica quilt
Storage.For example, client computer is actually when user edits the content as the cell D5 in display that user sees
The cell A1 to make a variation in its local replica, rather than cell D5.Only when the display of worksheet then refreshes, client is calculated
Variation of the machine into local replica application filter and Cell display D5.Because storage user is dynamic with reference to non-filtration table
Make, user action can be sent straight to cloud computing service and teamworker's client computer, without any transformation.Cloud meter
User action is recorded in the primary copy of its worksheet by the service of calculation, and sends current accessed worksheet for user action
Every other teamworker.At teamworker's client computer, what user action was applied to store on the client computer
Local replica is not filtered.If teamworker is to local replica application filter, in the screen of teamworker's client computer
Before showing on curtain, user action is converted by filter.Teamworker's client is calculated for example, teamworker can receive
The variation of the cell A1 of local replica on machine and updating unit lattice A1.If teamworker uses the number in cell A1
According to the filter for transforming to cell B3, variation carries out the cell in transformation and teamworker's computer screen by filter
B3 is updated.
Cooperation electrical form can have the computing engines of its computing unit lattice value.This engine shows work with to user
The UI engine of table is discrete.It when user action is with reference to non-filtration table, calculates and formula is affected, and and if only if display
When, filtration table.It calculates and the number found in the one or more cells rearranged by filter can be used in formula
According to.It when formula or calculates when it is displayed on the screen, it can refer to the cell of non-filtration table, and worksheet itself is
It is rearranged.This may be chaotic for user checks.In order to solve this problem, filter can also be applied
It is referred in calculating with the cell in formula.To which when calculating and formula is displayed on the screen, they are with reference to through filtration
The cell of table, and the cell of the practical calculating stored in memory or the non-filtration table of formula reference.Client calculates
Machine can also limit the ability that user creates new formula.For example, if user highlight will be in worksheet used in formula
Through the sequential cells lattice collection in filtered view, cell collection may not be continuous actually in unfiltered view.Client
End computer can not allow such movement.
In alternative design, user action can be with reference to the cell through filtering worksheet on client computer.Fig. 9
The example to the variation processing through filtering electrical form when user action is referred to through filtering worksheet is shown.System 900 is wrapped
Include the cloud computing service 902 of the primary copy of storage cooperation electrical form 904.The electrical form 904 that cooperates may include one or more
A worksheet, and each worksheet can be associated with one or more filters.Two client computers 906 and 912
Cloud computing service 902 is connected to access the electrical form 904 that cooperates.When each client computer accesses cooperation electrical form
When, the local replica of cooperation electrical form 904 is loaded on each client computer, is shown as local replica 910 and 916.
Local replica includes the copy and the associated filter for the worksheet of at least one worksheet.Client computer
User on 906 applies " filter 1 " to the local replica 910 of its electrical form that cooperates.Similarly, client computer 912
On user to its cooperate electrical form local replica 916 apply " filter 2 ".
In Fig. 9,910 He of local replica that is stored when selecting user or changes filter, on client computer
916 are updated.To which unlike the case where Fig. 8, filter changes the local replica of worksheet, and the local replica is then straight
It connects to user and shows.To 918 cell of the reference through filtering worksheet of user's variation of worksheet.It is calculated to work as by client
When machine receives user action, user action is applied to being filtered local replica and directly being shown to user for worksheet.So
And before user action is sent to cloud computing service, user action is converted by the inverse of filter, so that user is dynamic
Make to refer to non-filtration table.When the user on client computer 906 is to worksheet application filter 1, client is calculated
Machine 906 determines and stores the inverse of " filter 1 " 908, and the cell through filtering worksheet is mapped to non-filtration table
Cell.Similarly, client computer 912 determines and stores the inverse of " filter 2 " 914.For example, user's variation refers to client
The cell D5 through filtering local replica stored on the computer of end, wherein the data in cell D5 correspond to non-filtration
Data in the cell A1 of table.Before variation is sent to cloud computing service, inverse according to filter makes a variation to convert, and makes
Obtain transformed variation reference unit lattice A1.This user action is sent to cloud computing service to be recorded in the non-mistake of worksheet
It filters in primary copy.Cloud computing service also sends user action to other teamworkers of current accessed worksheet.In teamworker visitor
At the computer of family end, user action is converted by any filter used by teamworker, and is then saved as this
Local replica on client computer.For example, if teamworker transforms to cell B3 using by the data in cell A1
Filter, then variation passes through the sheet of the worksheet that filter is converted and is stored on teamworker's client computer
In the cell B3 of ground copy.Formula and calculating can also be converted in a manner of identical with user action, therefore cell
There is logical meaning with reference to for each teamworker.
In another alternative design, client calculate service can track each teamworker currently using filter.
In Fig. 9, the local replica of worksheet can be changed by filter, and user action is referred to and deposited through filtering worksheet
Storage.User action can be sent directly to cloud computing service by client computer, and cloud computing service executes inverse filter and converts
To obtain the user action with reference to non-filtration table.Cloud computing service can also send teamworker client for user action
Before holding computer, user action is converted by the filter used by teamworker.Thus with situation described in Fig. 9
In contrast, the calculating of filter transformation and inverse transformation is completed in cloud computing service rather than on client computer.Pass through tracking
Which filter teamworker is just using, and cloud computing service can also allow for some mutual filters of teamworker's mirror image, and allow
Filter is used independently in other teamworkers.For example, user A is to filter if user A and user B selects mirror images of each other
Any application the worksheet view of user B is automatically updated.Another user C selection independently works, and so user C
Worksheet view not will receive the influence of selection of the user A to filter.
The filter for creating, storing and showing the cooperation electrical form for being used to store on cloud computing service will now be described
Various methods.A kind of method shown in Fig. 10 provides the filter checked on the cooperation electrical form stored on cloud computing service
Method.Method 1000 includes storing from each client computer access cloud computing service in multiple client computer
Electrical form the first worksheet, plurality of filter is associated with the first worksheet.Method further comprises multiple
Applying in multiple filters to the first worksheet for the first user is received at the first client computer in client computer
First filter order.Method further comprises that the first worksheet on the first client computer is filtered using first
It device and is shown to the first user and is filtered the first worksheet, the second client in plurality of client computer calculates
Machine, which is concomitantly shown, does not filter the first worksheet.Method 1000 can may be coupled to any kind of of cloud computing service at it
It is executed on client computer, client computer described in such as Fig. 3 or any desktop computer, calculating on knee
Machine, tablet computer, smart phone or such electronic equipment.
It is illustrated at 1002, when the of the cooperation electrical form stored on multiple client computer access cloud computing service
When one worksheet, method 1000 starts.The primary copy of the electrical form stored on cloud computing service includes one or more work
Table, wherein at least one worksheet are associated with multiple filters.As described above, filter is rearranged for user's
Data on worksheet show, and may include that data are ranked up and removed from view with certain data values.Filtering
Device can be defined by the user and be stored on cloud computing service.All as illustrated in Figure 1, cloud computing service allows multiple clients
Access the first worksheet with holding the user concurrent on computer.Electrical form can have ACL, and ACL determines which user can be with
Access electrical form and the access level of each user.When the user on client computer accesses the first worksheet, cloud
Calculate copy from the first worksheet to client computer and associated filter that service sends.This copy is stored as
Local replica on client computer and (for example, passing through web browser) is shown to user.User on Web browser
Interface allows user to check and editing table.The editor or variation that are made by user are recorded in the local replica of worksheet
In, and cloud computing service is sent to be recorded in primary copy.
It is illustrated at 1004, after the local replica of the first worksheet is loaded on each client computer, visitor
Family end computer receives the order from the user to the first worksheet application filter.Cloud computing service is to client computer
User interface for checking and editing the first worksheet, user interface such as shown in Fig. 7 are provided.User interface includes being used for
User's selection will be applied to the menu or sidebar window of the filter of the cell group in the first worksheet.User highlights use
The cell group of family expectation filtering, and filter is selected from multiple filters associated with the first worksheet.At 1006
Diagram, then client computer applies selected filter to the first worksheet.As previously described in this application, mistake
The cell data stored in the local replica of filter the first worksheet of transformation.If user has previously answered to the first worksheet
With another filter, then the selection of new filter is so that client computer removes previous filter and to the first worksheet
Using new filter.
It is illustrated at 1008, after client computer applies selected filter to the first worksheet, to client meter
The user of calculation machine, which shows, is filtered the first worksheet.User's selection of filter on one client computer will not be communicated
To the other client computers for concomitantly accessing same worksheet.Although to which the user on client computer can be with
To the first worksheet application filter, but the second client computer still shows non-filtration table, or perhaps shows
The worksheet that the selection of another filter is filtered based on the user on the second client computer.The user of filter selects
It can be communicated to cloud computing service, what filter cloud computing service can store each user currently using.However, cloud
The service of calculating will not change the primary copy of the first worksheet, and filter selection letter will not be sent to other client computers
Breath.In this way, method 1000 provides the cooperation electronics independently stored on cloud computing service to multiple concurrent teamworkers
The ability of filter is utilized on table.
Another method described herein provides the filtering of cooperation electrical form of the creation for storing on cloud computing service
The method of device.Method 1100 in Figure 11 includes each client computer access cloud computing from multiple client computer
First worksheet of the electrical form stored in service.Method further comprises the first client in multiple client computer
First filter is created on the computer of end, wherein the user on the first client computer defines first filter.Method is into one
Step includes: the first worksheet application first filter on the first client computer, in plurality of client computer
The second client computer concomitantly show and do not filter the first worksheet;And to cloud computing service send first filter with
For store and it is associated with the first worksheet.Method 1100 can may be coupled to any kind of of cloud computing service at it
It is executed on client computer, client computer described in such as Fig. 3 or any desktop computer, calculating on knee
Machine, tablet computer, smart phone or such electronic equipment.
It is illustrated at 1102, when the of the cooperation electrical form stored on multiple client computer access cloud computing service
When one worksheet, method 1100 starts.The primary copy of the electrical form stored on cloud computing service includes one or more work
Table.One or more filters can be associated with each worksheet.All as illustrated in Figure 1, cloud computing service allows multiple
Access the first worksheet to user concurrent on client computer.Electrical form can have ACL, which user ACL determines
Accessible electrical form and the access level of each user.When the user on client computer accesses the first worksheet
When, cloud computing service sends the copy and associated filter of the first worksheet to client computer.This copy quilt
The local replica that is stored as on client computer and (such as passing through web browser) is shown to user.On Web browser
User interface allows user to check and editing table.The editor or variation made by user is recorded in the local secondary of worksheet
In this, and cloud computing service is sent to be recorded in primary copy.
It is illustrated at 1104, after the local replica of the first worksheet is loaded on client computers, the first visitor
User's creation on the computer of family end is used for the first filter of the first worksheet.Creation or editor are used for the filtering of electrical form
The ability of device can be limited by the ACL of electrical form.For example, the user with write access can create or edit for work
The filter of table, and the user with read access can be used filter but cannot create or edit them.As retouched above
State, the data that filter rearranges on the worksheet for user are shown, and may include data are ranked up with
And certain data values are removed from view.Cloud computing service is provided to client computer for creating and editing for the first work
Make the user interface of the filter of table, such as Fig. 5 and user interface shown in Fig. 7.This user interface may be displayed on client
In the web browser executed on the computer of end.For example, user interface may include for user create or edit filter and
It is applied to the menu or sidebar window of the cell group in the first worksheet, sidebar window such as shown in Fig. 7.Work as user
When the option of selection creation or editor's filter, menu similar with the menu 502 in Fig. 5 can occur.In this menu,
User defines filter, such as defines collating sequence or selects the certain data values that show or remove from display.
It is illustrated at 1106, after user creates or edits filter, filter is applied to client computer
First worksheet.As previously described in this application, filter converts the list stored in the local replica of the first worksheet
First lattice data.Right rear line is shown through filtering worksheet.The filter of creation or editor are also delivered to cloud computing service,
Filter is stored and associated with the first worksheet at cloud computing service.First worksheet can also have associated with it
Other filters.It can create, edit with each user suitably accessed to electrical form, deleting, renaming or is multiple
Filter processed.When user creates or edits filter, cloud computing service can be sent creation or the filter updated to simultaneously
Other client computers of the first worksheet of hair ground access, therefore filter can be used in other users.When user deleted
When filter, cloud computing service deletes the primary copy of filter, and indicates that other client computers also delete their filtering
Device copy.In this way, method 1100 provides the association stored in creation or editor's cloud computing service to multiple concurrent teamworkers
Make the ability of the filter on electrical form.
Another method described herein discloses the cooperation for providing and storing on the server for trustship cloud computing service
The method of the filter of electrical form.Method 1200 in Figure 12 includes: to store electrical form on the server, wherein electronics
Table includes multiple worksheets;And authorization multiple client computer concurrently accesses electrical form.Method further comprises: from
Multiple client computer receives the multiple filters for the first worksheet that be applied in multiple worksheets;And by multiple mistakes
Filter stores on the server, and plurality of filter is associated with the first worksheet.Method further comprises to multiple clients
Each client computer in computer is held to provide multiple filters, wherein as the first client in multiple client computer
When the user on computer being held to apply the first filter in multiple filters to the first worksheet, in multiple client computer
The second client computer on the first worksheet display independently of the filter application on the first client computer.Side
Method 1200 can execute on the server (server described in such as Fig. 2) of trustship cloud computing service.
It is illustrated at 1202, when electrical form is stored on the server of trustship cloud computing service, method 1200 is opened
Begin.Electrical form has one or more worksheets, wherein each worksheet is made of several cells being arranged in columns and rows.
All as illustrated in Figure 1, the user on client computer is connected to server to access electrical form.Server offer is used for
User checks the user interface with the worksheet of editing electronic table, the web-browsing executed on such as each client computer
The user interface shown on device.The example of user interface for electrical form is shown in Fig. 4 into Fig. 7.Electrical form can be with
It creates and is saved on the server via the user on client computer.Electrical form is collaborative, to anticipate
Refer to more than one user can simultaneously editing electronic table.Electrical form can determine visit of each user to electrical form with it
Ask that the accesses control list of rank is associated.
It is illustrated at 1204, after electrical form is stored on server, server authorization one or more client
End computer concurrently accesses electrical form.User on client computer can concomitantly cooperate and editing electronic table.When
When client computer is connected to server and requests access to electrical form, whether server can check user in electronic watch
In the ACL of lattice.If user is authorized user, server provides the copy of electrical form to client computer.Client meter
This copy is stored as the local replica on client computer by calculation machine, and it is shown in web browser.To every
A client computer possesses the local replica of electrical form, and server keeps primary copy.The variation made by a user
It is transmitted to server and other users, therefore all teamworkers have the fresh copy of electrical form.
It is illustrated at 1206, after client computer has been authorized to electrical form, server is from one or more
A client computer receives the multiple filters that be applied to the first worksheet of electrical form.Use on client computer
Family creates filter using the user interface that server provides.For example, user can choose in sidebar window 702 shown in Fig. 7
" creating new filter " option 712 provided.Then user is come using filter menu similar with menu 502 shown in fig. 5
Define filter.Filter may include for certain cells to be ranked up or hidden from view with certain cell values
Order.Once user defines filter, it is just saved on client computers and is sent to server.User is also
User interface can be used to edit filter, renaming filter, replica filter, set filter to default filtering
Device or deletion filter.Accesses control list can determine which user can create, edits or delete and be used for electrical form
Filter.It is illustrated at 1208, server receives the filter created by various users and stores them.Server was incited somebody to action
Filter is associated with the first worksheet.If user is compiled or renaming filter, server save the filter updated
To replace old filter.If user has deleted filter, server deletes the copy of its filter.If user will filter
Device is set as default filter, and the mark of the copy for its filter can be set in server.
At 1210 illustrate, several filters for the first worksheet be created and store on the server it
Afterwards, server provides newest multiple filters to each client computer.Server is sent to each client computer
The change that any new filter, user make filter or the order for deleting filter, so that all teamworkers have
There is the newest list for the filter that can be used for the first worksheet.Because each client computer keeps the independent of the first worksheet
Local replica, user can be independently to the local replica application filters of their the first worksheet, without influencing the first work
Make display of the table on other client computers.Filter application be not to be regarded as it is identical with variation, variation by automatically
It is transmitted to other teamworkers.User can be communicated to server to the selection of filter, but selection will not be communicated to association
Author's client computer.For example, two users can apply two different filters to same data set, and it will not that
This interference or user can apply filter, and what another user can still check the first worksheet does not filter version
This.Server can provide a user the option for the mutual filter selection of mirror image.For example, if user A and user B choosing
Mirror images of each other are selected, then user A any application of filter is automatically updated the worksheet view for user B.Another user C
Selection independently works, and so the worksheet view of user C not will receive the influence of selection of the user A to filter.With
This mode, method 1200, which is provided, provides the filter for the electrical form that cooperates for the server of trustship cloud computing service
Method.
Another method described herein discloses the processing cooperation electronic watch when user action is with reference to non-filtration table
The method of user action on lattice.Method 1300 shown in Figure 13 includes not filtering for the electrical form stored on access server
For worksheet to show on client computers, plurality of filter is associated with non-filtration table.Method is further wrapped
It includes: receiving selection of the user to the first filter in the multiple filters that be applied to non-filtration table;And to user
Display is through filtering worksheet, wherein by being obtained to non-filtration table application first filter through filtering worksheet.Method
Further comprise: receiving by the user action of user's input on client computer, wherein user action refers to non-filterer
Make the cell of table;User action is sent to server;User action is converted according to first filter;And the use based on transformation
Family acts to update the display through filtering worksheet.Method 1300 can may be coupled to any type of cloud computing service at it
Client computer on execute, client computer described in such as Fig. 3 or any desktop computer, calculating on knee
Machine, tablet computer, smart phone or such electronic equipment.
It is illustrated at 1302, when the electrical form stored on the server of client computer access trustship cloud computing service
Non- filtration table when, method 1300 start.The primary copy of the electrical form stored on server includes one or more works
Make table.One or more filters can be associated with each worksheet.As illustrated in Figure 1, server allows client meter
Access the first worksheet to multiple user concurrents on calculation machine.Electrical form can have ACL, and ACL determines which user can be with
Access electrical form and the access level of each user.When the user on client computer accesses the first worksheet, cloud
Calculate copy from the first worksheet to client computer and associated filter that service sends.This copy is stored as
Local replica on client computer and (for example, passing through web browser) is shown to user.User on Web browser
Interface allows user to check and editing table, such as Fig. 4 to user interface shown in Fig. 7.
It is illustrated at 1304, after client computer accesses the non-filtration table from server, client meter
Calculation machine receives the selection that be applied to the first filter of non-filtration table.All as illustrated in Figure 7, user interface can wrap
Sidebar window is included, user can will be applied to the filter of the data segments in non-filtration table from selection in sidebar window.
It is illustrated at 1306, then client computer is to non-filtration table application first filter, and shows result through filtering
Worksheet.First filter is the mapping or change between the cell of non-filtration table and the cell through filtering worksheet
It changes.For example, the cell A1 of non-filtration table can be mapped to the cell B2 through filtering worksheet by first filter, in
It is so that the data value of Cell display A1 is understood in the display of cell B2 when applying first filter.On client computer
The local replica of the non-filtration table of storage not will receive the influence of selection of the user to first filter.It is, depositing
Client computer will not override non-filtration table with through filtering worksheet in reservoir.More precisely, through filtering worksheet
It is temporarily stored and is shown on the display screen of client computer.
It illustrates, is being shown to user after filtering worksheet, client computer reception is inputted by user at 1308
User action.User action can be editor or variation, and perhaps user's presentation activity (such as highlights or selects one
Or multiple cells).User action refers to non-filtration table rather than the cell through filtering worksheet.For example, if user
Change the data value in cell A1 (it is mapped to cell B2 by first filter), user action reference unit lattice
A1.It is same in the case where user selection unit lattice A1.To change the non-filtration stored on client computer
Cell A1 in the local replica of table.It is illustrated at 1310, this user action (unchanged) is sent to server.Clothes
The primary copy for the first worksheet that business device storage is not influenced by user's selection of filter, so user action can be applied directly
In the primary copy of the first worksheet.Then server can send user action to current also in any of access electrical form
Other teamworkers.Before showing it, teamworker's client computer will be according to times for the local replica for being applied to them
What filter converts user action.The transformation of teamworker's user action is discussed about Figure 14.
It is illustrated at 1312, converts user action also according to the first filter on client computer.It is dynamic in user
After work is converted according to first filter, it is with reference to the cell through filtering worksheet.To the variation to cell A1
It is transformed to the variation of cell B2.It illustrates at 1314, is updated through filtering worksheet by the user action converted, and
Right rear line is shown.By keeping non-filtration table in memory and only being determined when showing worksheet to user
Through filtering worksheet, user action can be sent directly to server by client computer, without carrying out more to them
Change.This allows server and client computers to convey user action directly with one another, considers user without intermediate conversion layer
Any filter of application.In this way, method 1300 provides the processing cooperation when user action is with reference to non-filtration table
The method of user action on electrical form.
Another method described herein is disclosed when the non-filtration table of teamworker's action reference, processing cooperation electronics
The method of teamworker's movement on table.The method 1400 illustrated in Figure 14 includes: the electrical form for accessing and storing on server
Non- filtration table to show on client computers, plurality of filter is associated with non-filtration table;And
Receive selection of the user to the first filter in the multiple filters that be applied to non-filtration table.Method is further wrapped
It includes: showing to user through filtering worksheet, wherein obtaining and to non-filtration table application first filter through filterer
Make table;And teamworker's movement, the wherein cell of the non-filtration table of teamworker's action reference are received from server.Method into
One step includes: that teamworker's movement is converted according to first filter;And teamworker's movement based on transformation, it updates through filterer
Make the display of table.Method 1400 can be held on any kind of client computer that it may be coupled to cloud computing service
It goes, client computer described in such as Fig. 3 or any desktop computer, laptop computer, tablet computer, intelligence electricity
Words or such electronic equipment.
It is illustrated at 1402, when the electrical form stored on the server of client computer access trustship cloud computing service
Non- filtration table when, method 1400 start.The primary copy of the electrical form stored on server includes one or more works
Make table.One or more filters can be associated with each worksheet.As illustrated in Figure 1, server allows client meter
Access the first worksheet to multiple user concurrents on calculation machine.Electrical form can have ACL, and ACL determines which user can be with
Access electrical form and the access level of each user.When the user on client computer accesses the first worksheet, cloud
Calculate copy from the first worksheet to client computer and associated filter that service sends.This copy is stored as
Local replica on client computer and (for example, passing through web browser) is shown to user.User on Web browser
Interface allows user to check and editing table, such as Fig. 4 to user interface shown in Fig. 7.
It is illustrated at 1404, after client computer accesses the non-filtration table from server, client meter
Calculation machine receives the selection that be applied to the first filter of non-filtration table.All as illustrated in Figure 7, user interface can wrap
Sidebar window is included, user can will be applied to the filter of the data segments in non-filtration table from selection in sidebar window.
It is illustrated at 1406, then client computer is to non-filtration table application first filter, and shows result through filtering
Worksheet.First filter is the mapping or change between the cell of non-filtration table and the cell through filtering worksheet
It changes.For example, the cell A1 of non-filtration table can be mapped to the cell B2 through filtering worksheet by first filter, in
It is so that the data value of Cell display A1 is understood in the display of cell B2 when applying first filter.On client computer
The local replica of the non-filtration table of storage not will receive the influence of selection of the user to first filter.It is, depositing
Client computer will not override non-filtration table with through filtering worksheet in reservoir.More precisely, through filtering worksheet
It is temporarily stored and is shown on the display screen of client computer.
It illustrates, is being shown to user after filtering worksheet, client computer is received from server and assisted at 1408
Author actions.Teamworker's movement can be the variation or association that the teamworker of current accessed electrical form makes the first worksheet
Author's presentation activity (such as, highlights or selects one or more cells).The non-filtration of teamworker's action reference
Table rather than through filter worksheet cell.For example, if teamworker changes cell A1, (it passes through on client computer
First filter is mapped to cell B2) in data value, from the received teamworker's action reference cell A1 of server.Visitor
Teamworker's movement is applied to the non-filtration table stored in memory by family end computer.Server is received from teamworker's
Teamworker's movement and the primary copy that it is directly applied to the first worksheet that server stores.Then, server will make a variation
It is sent to current also in any other teamworker of access electrical form.
It is illustrated at 1410, after client computer receives teamworker's movement, it is converted according to first filter
Teamworker's movement.After teamworker's movement is converted according to first filter, it is with reference to the cell through filtering worksheet.
To be transformed to the variation of cell B2 to the variation of cell A1.It is illustrated at 1412, is filtered worksheet and pass through transformation
Teamworker's movement and updates, and right rear line is shown.For example, the cell B2 on the display screen of client computer
It can change the variation to reflect teamworker.In the case where movable situation is presented in teamworker, user interface in web browser can be with
Teamworker is shown and is currently just highlighting cell B2.In this way, method 1400 is provided when user action reference is not filtered
When worksheet, the method for teamworker's movement on processing cooperation electrical form.
Another method described herein discloses the processing cooperation electronic watch when user action is referred to through filtering worksheet
The method of user action on lattice.The method 1500 illustrated in Figure 15 includes: to access the electrical form stored on server not
For filtration table to show on client computers, plurality of filter is associated with non-filtration table;And it receives
Selection of the user to the first filter in the multiple filters that be applied to non-filtration table.Method further comprises: to
User shows through filtering worksheet, wherein by being obtained to non-filtration table application first filter through filtering worksheet;
And receive by the user action of user's input on client computer, wherein user action refers to the list through filtering worksheet
First lattice.Method further comprises: the display through filtering worksheet is updated based on user action;According to the inverse next of first filter
Convert user action;And transformed user action is sent to server.Method 1500 can may be coupled to cloud meter at it
It calculates and is executed on any kind of client computer of service, client computer described in such as Fig. 3 or any desk-top
Computer, laptop computer, tablet computer, smart phone or such electronic equipment.
It is illustrated at 1502, when the electrical form stored on the server of client computer access trustship cloud computing service
Non- filtration table when, method 1500 start.The primary copy of the electrical form stored on server includes one or more works
Make table.One or more filters can be associated with each worksheet.As illustrated in Figure 1, server allows client meter
Access the first worksheet to multiple user concurrents on calculation machine.Electrical form can have ACL, and ACL determines which user can be with
Access electrical form and the access level of each user.When the user on client computer accesses the first worksheet, cloud
Calculate copy from the first worksheet to client computer and associated filter that service sends.This copy is stored as
Local replica on client computer and (for example, passing through web browser) is shown to user.User on Web browser
Interface allows user to check and editing table, such as Fig. 4 to user interface shown in Fig. 7.
It is illustrated at 1504, after client computer accesses the non-filtration table from server, client meter
Calculation machine receives the selection that be applied to the first filter of non-filtration table.All as illustrated in Figure 7, user interface can wrap
Sidebar window is included, user can will be applied to the filter of the data segments in non-filtration table from selection in sidebar window.
It is illustrated at 1406, then client computer is to non-filtration table application first filter, and shows result through filtering
Worksheet.First filter is the mapping or change between the cell of non-filtration table and the cell through filtering worksheet
It changes.For example, the cell A1 of non-filtration table can be mapped to the cell B2 through filtering worksheet by first filter, in
It is so that the data value of Cell display A1 is understood in the display of cell B2 when applying first filter.In method 1300
Wherein non-filtration table will not be coated the case where being written as through filtering worksheet on the contrary, what is stored on client computer does not filter
The local replica of worksheet is coating to be written as through filtering worksheet.
It illustrates, is being shown to user after filtering worksheet, client computer reception is inputted by user at 1508
User action.User action can be editor or variation, and perhaps user's presentation activity (such as highlights or selects one
Or multiple cells).User action is referred to through filtering worksheet rather than the cell of non-filtration table.For example, if user
Change the data value in non-filter element lattice A1 (it is mapped to cell B2 by first filter), user action is with reference to single
First lattice B2.It is same in the case where user selects non-filter element lattice A1.It is stored on client computer to change
Cell B2 in the local replica of first worksheet.It illustrates at 1510, is directly updated through filtering worksheet by user action,
And right rear line is shown.
It illustrates at 1512, inverse also according to the first filter on client computer converts user action.With
Family is acted according to first filter against after being converted, the cell of its non-filtration table of reference.To through filtering
The variation of the cell B2 of worksheet is transformed to the variation of the cell A1 to non-filtration table.It is illustrated at 1514, this
One transformed user action is sent to server.The first work that server storage is not influenced by user's selection of filter
The primary copy of table, so the user action sent to server should be with reference to non-filtration table rather than through filtering worksheet
Cell.Otherwise, the error unit lattice that server will change in its primary copy.Then server can send user action to
Currently also in any other teamworker of access electrical form.Before showing it, teamworker's client computer will be according to
User action is converted through being applied to any filter of their local replica.The change of teamworker's movement is discussed about Figure 14
It changes.By keeping being filtered worksheet in memory, client computer can show user action, without any centre
Step.This causes ratio method 1300 to show the time faster.However, user action is according to mistake before being sent to server
The inverse of filter is converted, to keep the consistency with the server copy of the first worksheet.In this way, method 1500 mentions
Method for handling the user action on cooperation electrical form when user action is referred to through filtering worksheet.
In the alternative approach of method 1500, client computer can send non-transformed user action to server and connect
With the information about which currently used filter of client computer.Then server can be according to the inverse next of first filter
Convert user action.Then user action can be stored in server memory.Server can also be sent out to teamworker
Before sending user action, transformed user action is converted according to the filter that teamworker uses.
It should be appreciated that the aspect of system and method described herein may be implemented in embodiment illustrated in figure
In many various forms of softwares, firmware and hardware.For realizing the side for the principle for meeting system and method described herein
The actual software code in face or dedicated control hardware are not limiting.To the operation of the aspect of system and method and row
To be described in the case where not referring to specific software code --- it should be appreciated that those of ordinary skill in the art will base
The software for describing to be designed in terms of realizing and control hardware in this article.
Similarly, although describing to operate with particular order in the accompanying drawings, this is not construed as requiring shown in
Particular order perhaps to execute such operation or requires the operation of all diagrams of execution with sequence order, to realize expectation
As a result.In some cases, multitasking and parallel processing can be advantageous.
Claims (26)
1. a kind of method for handling the user action on cooperation electrical form, which comprises
The electrical form stored from each client computer access server in multiple client computer does not filter
For worksheet to be shown on the first client computer, plurality of filter is associated with the non-filtration table, and
Wherein each filter in the multiple filter is same by each client computer in the multiple client computer
When select;
From first client computer receive the first user to being applied to the multiple of the non-filtration table
The selection of first filter in filter, wherein the first filter is created on the second client computer by second user
It builds;
It shows to first user through filtering worksheet, wherein by being filtered to the non-filtration table using described first
Device and obtain it is described through filter worksheet;
The user action inputted on first client computer by first user is received, wherein the user action
With reference to the cell of the non-filtration table;
The user action is sent to the server;
The user action is converted according to the first filter;And
Based on transformed user action, the display through filtering worksheet is updated.
2. according to the method described in claim 1, wherein the first filter include for one to the first worksheet or
The order that multiple cells are ranked up.
3. according to the method described in claim 1, wherein the first filter includes for hiding the one of the first worksheet
Or the order of multiple cells.
4. according to the method described in claim 1, wherein accessing the non-filtration table includes by the copy of the first worksheet
It is loaded on first client computer with the multiple filter.
5. according to the method described in claim 4, wherein show it is described through filtering worksheet include according to the first filter
To convert the non-filtration table.
6. according to the method described in claim 1, wherein described be displayed on the first client calculating by filter worksheet
In the web browser executed on machine.
7. according to the method described in claim 6, wherein the web browser is shown for first user input use
The user interface of family movement.
8. according to the method described in claim 1, wherein the user action is cell variation.
9. according to the method described in claim 1, wherein the user action is cell presentation activity.
10. a kind of method for receiving teamworker's movement on cooperation electrical form, which comprises
The non-filtration table of the electrical form stored on access server is to be shown on the first client computer, wherein more
A filter is associated with the non-filtration table, and wherein each filter in the multiple filter by multiple visitors
Each client computer simultaneous selection in the computer of family end;
From first client computer receive the first user to being applied to the multiple of the non-filtration table
The selection of first filter in filter, wherein the first filter is created on the second client computer by second user
It builds;
It shows to first user through filtering worksheet, wherein by being filtered to the non-filtration table using described first
Device and obtain it is described through filter worksheet;
Teamworker's movement is received from the server, wherein the unit of non-filtration table described in teamworker's action reference
Lattice;
Teamworker's movement is converted according to the first filter;And
It is acted based on transformed teamworker, updates the display through filtering worksheet.
11. according to the method described in claim 10, wherein the first filter includes for one to the first worksheet
Or the order that multiple cells are ranked up.
12. according to the method described in claim 10, wherein the first filter includes one for hiding the first worksheet
The order of a or multiple cells.
13. according to the method described in claim 10, wherein accessing the non-filtration table includes by the pair of the first worksheet
This and the multiple filter are loaded on first client computer.
14. according to the method for claim 13, wherein showing that the worksheet that filtered includes according to first filtering
Device converts the non-filtration table.
15. according to the method described in claim 10, wherein described be displayed on the first client meter by filter worksheet
In the web browser executed on calculation machine.
16. according to the method for claim 15, wherein the web browser is shown for described in first user input
The user interface of user action.
17. according to the method described in claim 10, wherein teamworker's movement is cell variation.
18. according to the method described in claim 10, wherein teamworker's movement is cell presentation activity.
19. according to the method described in claim 10, the method further includes being acted by the teamworker to update
State the non-filtration table on the first client computer.
20. a kind of system for handling the user action on cooperation electrical form, the system comprises:
First client computer, is configured as:
By communicating to connect the server communication with trustship cloud computing service;
Access the non-filtration table of the electrical form stored on the server, plurality of filter and the non-filterer
It is associated to make table, and wherein each filter in the multiple filter by each client in multiple client computer
Hold computer simultaneous selection;
Receive the first user to the first filter in the multiple filter that be applied to the non-filtration table
Selection, wherein the first filter is created on the second client computer by second user;
It shows to first user through filtering worksheet, wherein by being filtered to the non-filtration table using described first
Device and obtain it is described through filter worksheet;
The user action inputted on the client computer by first user is received, wherein the user action refers to
The cell of the non-filtration table;
The user action is sent to the server;
The user action is converted according to the first filter;And
Based on transformed user action, the display through filtering worksheet is updated.
21. according to the method for claim 20, wherein the client computer is configured to:
Teamworker's movement is received from the server, wherein the unit of non-filtration table described in teamworker's action reference
Lattice;
Teamworker's movement is converted according to the first filter;And
It is acted based on transformed teamworker, updates the display through filtering worksheet.
22. according to the method for claim 20, wherein the first filter includes for one to the first worksheet
Or the order that multiple cells are ranked up.
23. according to the method for claim 20, wherein the first filter includes one for hiding the first worksheet
The order of a or multiple cells.
24. according to the method for claim 20, wherein the client computer is further configured to: when from the clothes
When business device accesses the first worksheet, the copy of the first worksheet and the multiple filter are loaded into the first client meter
On calculation machine.
25. according to the method for claim 20, wherein first client computer is explicit described with being configured as
Through the web browser for filtering worksheet.
26. according to the method for claim 25, wherein the web browser is shown for described in first user input
The user interface of user action.
Applications Claiming Priority (7)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
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,193 US9361287B1 (en) | 2013-05-22 | 2013-05-22 | Non-collaborative filters in a collaborative document |
US13/900,265 | 2013-05-22 | ||
US13/900,265 US8943142B1 (en) | 2013-05-22 | 2013-05-22 | Non-collaborative filters in a collaborative document |
US13/900,270 | 2013-05-22 | ||
CN201480021515.8A CN105122238B (en) | 2013-05-22 | 2014-05-21 | Non-cooperating filter in collaborative document |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201480021515.8A Division CN105122238B (en) | 2013-05-22 | 2014-05-21 | Non-cooperating filter in collaborative document |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109635258A true CN109635258A (en) | 2019-04-16 |
CN109635258B CN109635258B (en) | 2020-03-06 |
Family
ID=51059555
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811294207.9A Active CN109635258B (en) | 2013-05-22 | 2014-05-21 | Non-collaborative filters in collaborative documents |
CN201480021515.8A Active CN105122238B (en) | 2013-05-22 | 2014-05-21 | Non-cooperating filter in collaborative document |
Family Applications After (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201480021515.8A Active CN105122238B (en) | 2013-05-22 | 2014-05-21 | Non-cooperating filter in collaborative document |
Country Status (4)
Country | Link |
---|---|
EP (1) | EP3000055A4 (en) |
CN (2) | CN109635258B (en) |
DE (1) | DE202014010948U1 (en) |
WO (1) | WO2014190031A2 (en) |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11409762B2 (en) * | 2016-06-17 | 2022-08-09 | Koninklijke Philips N.V. | Interactively constructing a query against a dataset |
US10540153B2 (en) | 2016-12-03 | 2020-01-21 | Thomas STACHURA | Spreadsheet-based software application development |
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 |
JP7153725B2 (en) * | 2017-12-03 | 2022-10-14 | スタフラ,トーマス | Development of software applications based on spreadsheets |
US20200372210A1 (en) * | 2019-05-23 | 2020-11-26 | Sigma Computing, Inc. | Using lightweight references to present a worksheet |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070208992A1 (en) * | 2000-11-29 | 2007-09-06 | Dov Koren | Collaborative, flexible, interactive real-time displays |
US20090313250A1 (en) * | 2008-06-17 | 2009-12-17 | Microsoft Corporation | Techniques for filter sharing |
CN101836198A (en) * | 2007-10-25 | 2010-09-15 | 微软公司 | The private views of data and local calculating during the live collaboration |
US8108779B1 (en) * | 2008-12-16 | 2012-01-31 | Adobe Systems Incorporated | Collaborative editing operations |
Family Cites Families (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU9783098A (en) * | 1997-10-06 | 1999-04-27 | Nexprise, Inc. | Trackpoint-based computer-implemented systems and methods for facilitating collaborative project development and communication |
US20050114169A1 (en) * | 2003-11-24 | 2005-05-26 | Hazim Ansari | Systems and methods for evaluating information to identify, and act upon, intellectual property issues |
US7233951B1 (en) * | 2004-02-18 | 2007-06-19 | Microsoft Corporation | Spreadsheet grid-like control for a web-based collaboration system |
US7849395B2 (en) * | 2004-12-15 | 2010-12-07 | Microsoft Corporation | Filter and sort by color |
US7849090B2 (en) * | 2005-03-30 | 2010-12-07 | Primal Fusion Inc. | System, method and computer program for faceted classification synthesis |
US20110145689A1 (en) * | 2005-09-09 | 2011-06-16 | Microsoft Corporation | Named object view over multiple files |
US9942271B2 (en) * | 2005-12-29 | 2018-04-10 | Nextlabs, Inc. | Information management system with two or more interactive enforcement points |
US8266214B2 (en) * | 2006-01-24 | 2012-09-11 | Simulat, Inc. | System and method for collaborative web-based multimedia layered platform with recording and selective playback of content |
US7930646B2 (en) * | 2007-10-19 | 2011-04-19 | Microsoft Corporation | Dynamically updated virtual list view |
US9367530B2 (en) * | 2011-01-21 | 2016-06-14 | Jive Software | Distributed document co-authoring and processing |
-
2014
- 2014-05-21 WO PCT/US2014/038934 patent/WO2014190031A2/en active Application Filing
- 2014-05-21 CN CN201811294207.9A patent/CN109635258B/en active Active
- 2014-05-21 EP EP14734605.0A patent/EP3000055A4/en not_active Withdrawn
- 2014-05-21 CN CN201480021515.8A patent/CN105122238B/en active Active
- 2014-05-21 DE DE202014010948.6U patent/DE202014010948U1/en not_active Expired - Lifetime
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070208992A1 (en) * | 2000-11-29 | 2007-09-06 | Dov Koren | Collaborative, flexible, interactive real-time displays |
US8255791B2 (en) * | 2000-11-29 | 2012-08-28 | Dov Koren | Collaborative, flexible, interactive real-time displays |
CN101836198A (en) * | 2007-10-25 | 2010-09-15 | 微软公司 | The private views of data and local calculating during the live collaboration |
US20090313250A1 (en) * | 2008-06-17 | 2009-12-17 | Microsoft Corporation | Techniques for filter sharing |
US8108779B1 (en) * | 2008-12-16 | 2012-01-31 | Adobe Systems Incorporated | Collaborative editing operations |
Also Published As
Publication number | Publication date |
---|---|
EP3000055A2 (en) | 2016-03-30 |
EP3000055A4 (en) | 2017-05-17 |
CN105122238B (en) | 2018-11-27 |
WO2014190031A3 (en) | 2015-04-23 |
CN109635258B (en) | 2020-03-06 |
CN105122238A (en) | 2015-12-02 |
WO2014190031A2 (en) | 2014-11-27 |
DE202014010948U1 (en) | 2017-01-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105122238B (en) | Non-cooperating filter in collaborative document | |
US9635105B2 (en) | Non-collaborative filters in a collaborative document | |
US8204847B2 (en) | Idea page system and method | |
Mark | Conventions and commitments in distributed CSCW groups | |
US9756002B2 (en) | Systems and methods for email attachments management | |
US8407075B2 (en) | Merging calendar entries | |
US20050289524A1 (en) | Systems and methods for software based on business concepts | |
JP2006510133A (en) | Modeling system for graphic user interface to cross-reference with related applications | |
US8943142B1 (en) | Non-collaborative filters in a collaborative document | |
US7836457B2 (en) | Hybrid contextual floor plans for object instances | |
CN103841178B (en) | The method and system of the in-band management of network-attached storage environment | |
Gault et al. | Beginning Oracle Application Express 4.2 | |
Kühn et al. | Contextual and relational role-based modeling framework | |
Bai | Practical database programming with Visual Basic. NET | |
Hermon et al. | Deconstructing the VR-data transparency, quantified uncertainty and reliability of 3D models | |
Serra | Deciphering Data Architectures | |
CN106020801A (en) | Graphic fourth-generation language (4GL) and application generation system thereof | |
JP6202653B1 (en) | Computer system, management method and program | |
US9298688B1 (en) | Non-collaborative filters in a collaborative document | |
Chen | The integration of organization and information system modeling: a metasystem approach to the generation of group decision support systems and computer-aided software engineering | |
Jilek et al. | Towards Self-organizing Personal Knowledge Assistants in Evolving Corporate Memories | |
Solis et al. | A spatial hypertext wiki for architectural knowledge management | |
Lunzer | Benefits of subjunctive interface support for exploratory access to online resources | |
Marshall | Mastering Drupal 8 Views | |
Anderson et al. | Seven Hypertexts |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |