EP3000055A2 - Non-collaborative filters in a collaborative document - Google Patents
Non-collaborative filters in a collaborative documentInfo
- Publication number
- EP3000055A2 EP3000055A2 EP14734605.0A EP14734605A EP3000055A2 EP 3000055 A2 EP3000055 A2 EP 3000055A2 EP 14734605 A EP14734605 A EP 14734605A EP 3000055 A2 EP3000055 A2 EP 3000055A2
- Authority
- EP
- European Patent Office
- Prior art keywords
- sheet
- filter
- client computer
- user
- command
- 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.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 claims abstract description 153
- 230000009471 action Effects 0.000 claims description 145
- 230000035772 mutation Effects 0.000 claims description 51
- 238000012545 processing Methods 0.000 claims description 15
- 230000001131 transforming effect Effects 0.000 claims description 10
- 230000000694 effects Effects 0.000 claims description 7
- 238000004891 communication Methods 0.000 claims description 5
- 230000006870 function Effects 0.000 description 13
- 230000009466 transformation Effects 0.000 description 12
- 238000004364 calculation method Methods 0.000 description 8
- 238000001914 filtration Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 230000008859 change Effects 0.000 description 4
- 238000013507 mapping Methods 0.000 description 4
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 241001550206 Colla Species 0.000 description 1
- 238000007792 addition Methods 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 238000013501 data transformation Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000037435 normal mutation Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000000844 transformation Methods 0.000 description 1
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
Definitions
- Cloud computing services provide a way for multiple people at multiple locations to collaborate on the same document.
- the cloud computing service stores a master copy of documents on one or more data servers and users access the documents over a remote network, such as the Internet.
- Documents thai may be created, stored, and edited on a cloud computing service include word processing documents, presentation documents, and spreadsheets.
- a user accesses a document stored on the cloud computing service, a local copy of the document is loaded on the client computer. Changes to the document made by the user are communicated to the cloud computing serv er for recordation. If two or more collaborators are editing the same document at the same time, changes made by one user are quickly propagated to the other users as well.
- Collaborative spreadsheets accessible on cloud computing services may have many of the same functions as spreadsheets a v ailable on stand-alone computers.
- Available functions may include the use of filters to alter how data is arranged and displayed.
- filters may be used to order rows or columns of data in a certain fashion and may be used to hide certain rows or columns from view.
- a filter may be considered an edit, or mutation, to the sheet just as other mutations, such as cell entries, and row/column insertions or deletions.
- the filter is also sent to other collaborators and applied to their copy of the spreadsheet. Thus a collaborator's vie of the spreadsheet will automatically change when the user applies a filter.
- the systems and methods described herein provide a way for multiple collaborators to independently utilize filters for spreadsheets stored on a cloud computing service.
- the cloud computing service stores a spreadsheet file, which may contain one or more sheets of cells.
- the cloud computing service also stores a number of filters for each sheet.
- the filters may be created and saved by any collaborator with write access to the spreadsheet.
- the filters may be instructions to sort, hide, or otherwise arrange rows and cells from the display of the sheet.
- a user on a client computer loads a local copy of a sheet of the spreadsheet and its associated filters from (he cloud computing service.
- the sheet is displayed on a user interface at the client computer, for example on a web browser.
- the available filters may be displayed on a sidebar window.
- the filter When the user selects a filter to apply to the sheet, the filter is applied to the local copy of the sheet only and displayed to the user.
- the filter selection is not communicated to the other collaborators, unlike normal edits to the sheet.
- the cloud computing service may keep track of the filters that different col laborators are currently using, but the master copy of the sheet that is stored is not affected by user selection of filters. Users may set a default filter for the sheet, may remove all filters applied to a sheet, and may create, edit, rename, duplicate, or delete filters. Edits, or mutations, to a filtered sheet made by the user may be stored by the client computer either in reference to the unfiltered sheet or the filtered sheet.
- mutations may be sent directly to the cloud computing service for storage and to other collaborator client computers, which transform the mutations against any filters applied on the collaborator client computer before displaying the mutation to the collaborator. If mutations are referenced to the filtered sheet, they are transformed against the inverse of the filter before being sent to the cloud computing service and the collaborator client computers. Thus multiple collaborators may view multiple filters applied to the same sheet at the same time.
- One aspect described herein discloses a method for viewing filters on a collaborative spreadsheet stored on a cloud computing service.
- the method includes accessing, from each of a plurality of client computers, a first sheet of a spreadsheet stored on a cloud computing service, where a pluralit of filters is associated with the first sheet.
- the method further includes receiving at a first client computer in the plurality of client computers a command by a first user to apply a first filter in the plurality of filters to the first sheet, and applying the first filter to the first sheet on the first client computer.
- the method further includes displaying the filtered first sheet to the first user, where a second client computer in the plurality of client computers concurrently displays an unfiltered first sheet.
- Another aspect described herein discloses a method for creating filters for collaborative spreadsheets stored on a cloud computing service.
- the method includes accessing, from each of a plurality of client computers, a first sheet of a spreadsheet stored on a cloud computing service, and creating a first filter on a first client computer in the plurality of client computers, where a user on the first client computer defines the first filter.
- the method further includes applying the first filter to the first sheet on the first client computer, where a second client computer in the plurality of client computers concurrently displays an unfiltered first sheet, and sending the first filter to the cloud computing service to be stored and associated with the first sheet.
- the system includes a client computer configured to communicate with a cloud computing service and a plurality of clieni computers through a network connection, and load a first sheet of a spreadsheet stored on the cloud computing sendee, where a plurality of filters is associated with the first sheet.
- the client computer is further configured to receive a command from a user to apply a first filter in the plurality of filters to the first sheet, apply the first filter to the first sheet on the first client computer, and display the filtered first sheet to the user, where a first client computer in the plurality of client computers concurrently displays an unfiltered first sheet.
- FIG. 8008 Another aspect described herein discloses a graphical user interface for viewing on a plurality of client computers a collaborative spreadsheet stored on a cloud computing sendee.
- the graphical user interface on each client computer includes an editing window showing a plurality of cells of a first sheet of a collaborative spreadsheet stored on a cloud computing senice, and a sidebar window within the editing window sho wing a plurality of filters selectable by a user, where the plurality of filters are stored on the server.
- the graphical user interface is further designed so that when a user on a first client computer in the plurality of client computers selects a first filter from the plurality of filters, the first filter is applied to the first sheet and the filtered first sheet is shown in the editing windo w of the first client computer, wherein the editing window of a second client computer in the plurality of client computers displays an unfiltered first sheet,
- FIG. 1 shows a number of client computers in communication with a cloud computing service storing one or more spreadsheets in accordance with an implementation as described herein;
- FIG. 2 show ⁇ s a server implementing a cloud computing service in accordance with an implementation as described herein;
- FIG. 3 shows a client computer for loading a spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 4 shows a sheet of a collaborative spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 5 shows filter options for a sheet of a collaborative spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 6 shows a filtered sheet of a collaborative spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 7 shows a sidebar window for applying filters to a sheet of a collaborative spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 8 shows a diagram for processing collaborator mutations for a collaborative spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 9 shows another diagram for processing collaborator mutations for a collaborative spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 10 shows a method for viewing filters on a collaborative spreadsheet stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 1 1 shows a method for creating filters for collaborative spreadsheets stored on a cloud computing service in accordance with an implementation as described herein;
- FIG. 12 shows a method for providing filters for collaborative spreadsheets stored on a server in accordance with an implementation as described herein;
- FIG. 13 shows a method for processing user actions on a collaborative spreadsheet in accordance with an implementation as described herein;
- FIG. 14 shows a method for receiving collaborator actions on a collaborative spreadsheet in accordance with an implementation as described herein;
- FIG. 15 shows another method for processing user actions on a collaborative spreadsheet in accordance with an implementation as described herein. Detailed Description
- a server, service, or system as used in this description may be a single computing device or multiple computing devices working collectively and in which the storage of data and the execution of functions are spread out amongst the various computing devices.
- the cloud computing service stores a spreadsheet file containing one or more sheets of data.
- the cloud computing service also stores a number of filters for each sheet.
- the filters may be created and saved by any collaborator with write access to the spreadsheet.
- the filters may be instructions to sort or hide certain values from the display of the sheet.
- a user on a client computer uses a web bro wser to load a local copy of a sheet of the spreadsheet and its associated filters from the cloud computing sendee.
- the filters are displayed on a filter interface within the web browser, for example on a sidebar window.
- the filter When the user selects a filter to apply to the sheet, the filter is applied to the local copy of the sheet only and displayed to the user.
- the filter selection is not communicated to the other collaborators, unlike normal edits to the sheet.
- each collaborator may independently select and view different filters.
- Users may use the filter interface to set a default filter for the sheet, remove all filters applied to a sheet, and create, edit, rename, duplicate, or delete filters. Edits, or mutations, to a filtered sheet made by the user may be stored by the client computer either in reference to the unfiltered sheet or the filtered sheet.
- FIG. 1 shows a client-server system 100 that includes cloud computing service 102. and a number of client computers 104a through 104d.
- Cloud computing service 102 may include one or more servers that collectively provide cloud computing services for a multitude of client computers.
- Cloud computing service 102 stores a number of files accessible by client computers 104a-104d, including collaborative spreadsheet 106. Users may create, edit, copy, share, and delete files stored on cloud computing service 102. For example, client computers 104a-104d may simultaneously access spreadsheet 106 on cloud computing service 102 using a web browser. Cloud computing service 102 provides each client computer with a local copy of spreadsheet 106, which users on the client computers may view and edit. Edits, otherwise termed mutations, made by client computer 104a are automatically sent to cloud computing service 102 and transmitted to the other client computers 104b- 104d. Thus mutations made by one collaborator are immediately seen by other collaborators.
- Client computers 104a-104d may include desktop computers, laptop computers, tablets, smart phones, mobile electronic devices, or any other device that may connect to cloud computing service 102 through a remote network.
- System 100 may include many client computers that connect with cloud computing service 102.
- Cloud computing service 102 and client computers 104a-104d of system 100 are connected through a remote network, such as the Internet.
- the network connection may be facilitated through a local area network, wide area network, Ethernet, fiber optic network, or any other wired or wireless connection.
- Server 200 in FIG. 2 shows an example of a. server for use in a cloud computing service.
- a cloud computing service may include a number of servers that collectively provide the cloud computing service.
- Server 200 includes a central processing unit (CPU) 202, read only memory (ROM) 204, random access memory (RAM) 206, communications unit 208, data store 210, and bus 212.
- Server 200 may have additional components that are not illustrated in FIG. 2.
- Bus 212 allows the various components of server 200 to communicate with each other.
- Communications unit 208 allows server 200 to communicate with other devices, such as a number of client computers.
- Data store 210 may store, among other things, files that may be accessed, viewed, or edited by a number of client comp uters. These files may include word processing files, presentation files, spreadsheets, or multimedia files. Each file in data store 210 may be associated with an access control list (ACL), which determines the access rights of users attempting to view files in data store 210 (e.g. write access, read access, no access). Users connect with server 200 through communications unit 208 to access files stored in data store 210.
- ACL access control list
- Client computer 300 in FIG. 3 includes a 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 may have additional components that are not illustrated in FIG. 3.
- Bus 312 allows the various components of client computer 300 to communicate with each other.
- Input/output interface 308 allows client computer 300 to communicate with other devices, such as a cloud computing service, and also includes devices for taking in user inputs and displaying outputs to a user.
- Web browser 310 is used, among other things, to provide a user interface to view and edit files stored on a cloud computing service. Web browser 310 also displays mutations made by other collaborators who may be editing the same file as the user of client computer 300.
- the cloud computing service may determine the layout of the user interface displ ayed on web browser 310 for accessing and viewing files.
- Data store 210 for files stored on cloud computing service 200 in FIG. 2, web browser 310 for client computer 300 in F G. 3, and other data structures and software programs on cloud computing service 200 and client computer 300 may be implemented using non-transitory computer-readable media.
- suitable non-transitory computer-readable media include all forms of non-volatile memory , media and memory devices, including by way of example semiconductor memory devices, e.g., EPROM, EEPROM, and flash memory devices; magnetic disks, e.g., internal hard disks or removable disks; magneto-optical disks; and readable, once-writable, or rewriteable CD-ROM and DVD-ROM disks.
- FIG. 4 shows a sheet 400 of a collaborative spreadsheet stored on a cloud computing service.
- a collaborative spreadsheet is a spreadsheet file that may be accessed and edited by more than one user simultaneously.
- A. collaborative spreadsheet may contain one or more sheets, with each sheet containing a grid of cells.
- sheet 400 contains data in several cells, with data of the same type listed in columns 402 and data associated with the same person arranged in rows 404.
- Sheet 400 may contain any amount of data arranged in any possible configuration and is not limited to the layout shown in FIG. 4.
- the data in sheet 400 may be entered by one or more users connecting to the cloud computing service using client computers, as shown in FIG. 1. Users may have write access to sheet 400, or may only have read access, in which the user may view but may not edit the data.
- An ACL associated with the collaborative spreadsheet may determine the access rights of users attempting to access the spreadsheet.
- the cloud computing service may offer users a multitude of functions for creating, manipulating, and displaying data on a spreadsheet.
- One such function is called filtering.
- Filtering may encompass the sorting of data according to one or more criteria (e.g.
- FIG. 5 shows an example of a filtering menu for a sheet 500 of a collaborative spreadsheet stored on a cloud computing service.
- Sheet 500 includes column headers including "Age" and "Score.”
- each column may display a drop-down arrow 504.
- a filter menu 502 may be displayed for that column.
- filter menu 502 when the filter drop-down arrow is selected for the "Age" column, filter menu 502 appears and gives the user a number of ways to filter the data of sheet 502. using criteria applied to the "Age" column.
- Filter menu 502 includes sort functions 506, which may sort the rows of sheet 502 by a specific ordering. For example, if "Sort smallest- >largest" is selected by the user, rows 1 -6 may be sorted according to the numbers in the "Age" coiumn so that the row with the smallest numerical age appears first and the row with the largest numerical age appears last.
- Filter menu 502 also allows users to hide data using data checkboxes 512. Data checkboxes 512 show all the recorded data values in the "Age" coiumn.
- Filter menu 502. may also provide shortcuts 508 to select all data values or to clear the selection of all data values from data checkboxes 512, and may provide a search box 510 to search for particular data values in the list of data checkboxes.
- Filter menu 502 may also provide "OK" and "Cancel” buttons to apply a filter or cancel the filter. Filtering may also be applied not, just to columns, but to rows or selections of cells. A user highlights the cells, rows, or columns that the user wants to filter and then invokes the filter function.
- Filter menu 502 may include other data sorting and filtering options not shown in FIG. 5.
- FIG. 6 An example of a filtered sheet in a collaborative spreadsheet is shown in FIG. 6.
- a user selects the filter menu for the "Age" coiumn and sorts the ages from smallest to largest, and unselects the data checkbox for data value "18.”
- This filter will arrange the rows of sheet 400 according to age and hide any rows in which the age value is 18.
- Sheet 600 in FIG. 6 shows the result of applying this filter to unfiltered sheet 400. As can be seen, the rows of sheet 600 are arranged so that the smallest age is first and the largest age is last.
- Sheet 600 may indicate that rows have been hidden by a filter by omitting the row number of hidden rows in the row counter. For example, in FIG. 6 there is no row "5.”
- the user may edit or cancel the filter on the "Age" column by selecting the filter drop-down arrow for that column.
- the user may also create another filter using the appropriate filter drop-down arrows.
- the systems and methods of the present application provide collaborators with the ability to independently apply filters to sheets of a collaborative spreadsheet.
- the cloud computing service stores a plurality of filters associated with that sheet.
- the cloud computing service provides the client computer with a local copy of the sh eet and a copy of th e plurality of filters associated with that sheet.
- Other collaborators who access the collaborative spreadsheet also receive local copies of the sheet and the filters.
- the filter transforms the data on the local copy of the sheet and displays the filtered sheet to the user.
- the user's selection of the filter is not communicated to other colla borators, unlike normal mutations.
- the filter is not automatically applied to the sheets displayed by the collaborator client computers.
- Each collaborator could independently apply different filters to the same sheet of a collaborative spreadsheet stored on a cloud computing service.
- the user's selection of a filter may be communicated with the cloud computing sendees, or may not be communicated at all.
- Client computer may use web browsers to display collaborative spreadsheets stored on a cloud computing service.
- the cloud computing service provides a user interface (UI) to be displayed on the web browser.
- the UI allows the user to view arid edit the sheets of a collaborative spreadsheet, as well as invoke spreadsheet functions such as filtering.
- UI 700 shows an example of a UI 700 for displaying a sheet of a collaborative spreadsheet.
- UI 700 shows a number of cells of data arranged in numbered rows and lettered columns.
- UI 700 includes a sidebar window 702 for applying filters to the sheet.
- Sidebar window 702 shows a list of filters that may be applied to the sheet.
- filter 704 is a "No Filter” option, which when selected removes all filters from the display of the sheet.
- Filter 706, named "Over 2.0,” may implement the filter described in relation to FIG. 6, i.e. the "Age" column is sorted from smallest to largest and any age value that equals 18 is removed from the display.
- Each filter may have a drop-down menu 708 that may ⁇ be selected.
- Drop-down menu 708 includes filter commands to duplicate the filter, rename the filter, delete the filter, or make the selected filter the default filter.
- the filters 704, 706, or 708 may be marked with a symbol, such as a star, to denote which filter is the default filter.
- the current filter that the user is applying to the sheet may be highlighted or boided to indicate which filter is active.
- a user may create a filter without saving the filter, or may save and name the filter, in which case the filter will be added to the list of filter shown in sidebar window 702.
- Sidebar window 702 may include other filter commands not shown in FIG. 7.
- drop-down menu 70S may have an option to make the filter private or public. If a filter is made priv ate, no other collaborators may use the filter.
- UI 700 may also provide a separate sort function independent of the filter function. When a user sorts the sheet data using the sort function as opposed to the filter function, it may be treated as a mutation. Thus the sort command is sent to the cloud compitting service and to the other collaborators so that their display of the data is automatically updated. If the user sorts the sheet data using the filter function, the command is not sent to other collaborators. In either option, when a cell value that is affected by the sort criteria is changed, the display of the sheet may be automatically updated to reflect the new order.
- Sidebar window 702 may appear when the user selects a filter option from a menu on UI 700, or sidebar window 702 may be invoked when a user edits the filter. Sidebar window 702 may be open as long as there is an active filter applied to the sheet and disappears when there are no active filters on the sheet. Sidebar window 702 may fade away when the user does not use the sidebar windo for a period of time, such as a period of time after the user stops editing a filter. Sidebar window 702 may be minimized, toggled, or closed by the user, or the user may move the location of sidebar window 702 within Ul 700. Closing sidebar window 702 may remove all active filters from the display of the sheet.
- sidebar window 702 may remain open and may only disappear when the user deactivates ail filters (i.e. selects the "No Filter” option). Sidebar window 702 may only appear when the user selects a cell affected by a filter or edits a filter. There may be other actions by the user that may cause sidebar window 702 to appear or disappear from UI 700.
- UI 700 may provide a help link with an explanation of how sidebar window 702 operates. Ul 700 may be implemented using any known web browser programming language, including HTML and JavaScript.
- a filter model may be stored on the cloud computing service and client computers as a data structure with several defined attributes.
- a filter model may include a unique identifier for the filter (such as a string of alphanumeric characters) and a name that is given to the filter by a user.
- the filter model includes a range of cells over which the filter applies.
- the filter model may also include a list of the sorted row order, where the rows of the unfsltered sheet are mapped to the rows of the filtered sheet according to the filter criteria.
- the filter model may also include a Boolean list of hidden rows, which indicates whether certain rows will be hidden from view or remain visible.
- the filter model may also include a list of excluded data which track the user's selection of checkboxes 512 in FIG. 5,
- the filter model may also include identification of the user who created or l ast modifi ed the filter. Other information not listed may also be included in the filter model.
- Each filter has an associated data structure, and this data structure is sent from the cloud computing service to the client computer when loading a sheet of the collaborative spreadsheet. Edits to the filter change the data structure and are communicated to the cloud computing service and other collaborators.
- User actions inputted to sidebar window 702 may be communicated with the cloud computing service. For example, if the user creates or duplicates a new filter for a sheet, the client computer may create the filter model and send it to the cloud computing service for storage as a filter associated with the sheet. If the user deletes a filter associated with a sheet, the client computer may send a request to the cloud computing service to delete the corresponding master copy of the filter. If the user edits or renames a filter, the client computer changes the filter model that it stores and sends the edited filter model to the cloud computing serv ice, which will then update the master copy of the filter model.
- the client computer may send a request to the cloud computing service to set the master copy of that filter as the default filter. Any subsequent collaborator who accesses the sheet fro the cloud computing service will receive a copy of the uiifiitered sheet and the default filter will be automatically applied, if the user has write access to the spreadsheet (determined, for example, by an ACL), then the user may create, edit, or delete filters. If the user only has read access to the spreadsheet, the cloud computing sendee may allow the user to use filters but may not allow the user to create, edit, or delete filters. The creation, editing, or deletion of filters by a user may be sent to the cloud computing service and the other collaborators currently accessing the spreadsheet. So although the use of a filter to rearrange data is not communicated to collaborators, changes to the filters themselves are communicated to the collaborators.
- cells may be referenced into two ways - either to the unfiltered sheet or to the filtered sheet.
- the name entry "Nick" appears in cell A4 when referencing the filtered sheet.
- the name "Nick” is actually in cell A2.
- a filter may be considered a mapping, or transformation, between the cells of the unfiltered sheet and the cells of the filtered sheet. The filtered sheet is generated by applying the filter to the unfiltered sheet, and the filtered sheet is displayed by the client computer.
- FIG. 8 shows a system for processing user actions for a collaborative spreadsheet where user inputs are made in reference to the unfiltered sheet.
- System 800 includes a cloud computing service 802 storing a master copy of collaborative spreadsheet 804.
- Collaborative spreadsheet 804 may include one or more sheets, and each sheet may be associated with one or more filters.
- Two client computers, 806 and 812 connect to cloud computing sendee 802 to access collaborative spreadsheet 804.
- a local copy of the collaborative spreadsheet 804 is loaded onto each client computer, shown as local copies 810 and 816,
- the focal copies include a copy of at least one sheet and the associated filters for that sheet.
- the user on client computer 806 applies a filter 808, named "Filter 1" to its local copy 810 of the collaborative spreadsheet.
- the filter transforms the cells of the unfiltered sheet and rearranges the cells for display to the user.
- a user on client computer 812. selects "Filter 2", shown as filter transform 814, to apply to its local copy 816 of the collaborative spreadsheet.
- the selection of filters by each client computer is not
- Client computers 806 and 8 2 may send filter selection information to cloud computing service 802.
- the users on the client computers take user actions to local copies 810 and 816.
- User actions are processed by the client computers and by cloud computing service 802 depending on whether the user actions reference the unfiltered sheet or the filtered sheet.
- FIG. 8 shows an example of user action processing of a filtered spreadsheet when user actions are referenced to the unfiltered sheet.
- local copies 810 and 816 stored on the client computers always store the unfiltered copy of sheets regardless of any filters 808 or 814 that a user may apply to the sheet.
- the user initiates user action 818 which references the ceils of the unfiltered sheet. Only when the sheet is displayed to the user are filters 808 and 814 applied to the unfiltered local copies 810 and 816. For example, let a filter rearrange the data in cell A I of a sheet to cell D5. When a user applies the filter to the sheet, the filter does not alter the underlying local copy of the sheet stored on the client computer.
- the client computer calculates a filtered version of the sheet from the unfiltered local copy and displays the filtered sheet.
- This filtered sheet is stored in temporary memory and may be recalculated whenever the sheet is refreshed on the display screen.
- the client computer screen displays the data in cell D5
- the local copy of the sheet stores the data in cell A 1.
- it is stored in reference to the unfiltered local copy of the sheet. For example, when the user edits what the user sees as cell D5 on the display, the client computer actually mutates cell A1 in its local copy, not cell D5. Only when the display of the sheet is next refreshed does the client computer apply the filter to the local copy and display the mutation in cell D5.
- the user actions can be sent directly to the cloud computing service and collaborator client computers without any transformations.
- the cloud computing service records user actions in its master copy of the sheet and sends the user actions to ail other collaborators currently accessing the sheet.
- the user action is applied to the unfiltered local copy stored on that client computer. If the collaborator has applied a filter to the local copy, the user actions are transformed through the filter before being displayed on the screen of the collaborator client computer. For example, the collaborator may receive the mutation to cell Al and update cell Al of the local copy on the collaborator client computer. If the collaborator uses a filter that transforms the data in cell A 1 to cell B3, the mutation is transformed through the filter and cell 133 on the collaborator computer screen is updated.
- Collaborative spreadsheets may have a calculation engine that calculates cell values. This engine is separate from the Ul engine that d splays the sheet to the user. Calculations and formulae are affected when user actions reference the unfiltered sheet and the sheet is only filtered when displayed. Calculations and formulae may use data found in one or more cells that are rearranged by the filter. When a formula or calculation is displayed on the screen, it may reference cells of the unfiltered sheet while the sheet itself has been rearranged. This may be confusing for a user to view. To solve this problem, the filter may also be applied to cell references in calculations and formulae.
- the client computer may also restrict the user's ability create new formulae. For example, if a user highlights a contiguous set of cells in the filtered view of the sheet to use in a formula, the set of cells may not actually be contiguous in the unfiltered view. The client computer may disallow such an action.
- FIG. 9 shows an example of mutation processing of a filtered spreadsheet when user actions are referenced to the filtered sheet.
- System 900 includes a cloud computing service 902. storing a master copy of collaborative spreadsheet 904.
- Collaborative spreadsheet 904 may include one or more sheets, and each sheet, may be associated with one or more filters.
- Two client computers, 906 and 912, connect to cloud computing sendee 902 to access collaborative spreadsheet 904.
- a loca l copy of the collaborative spreadsheet 904 is loaded onto each client computer, shown as local copies 910 and 916.
- the local copies include a copy of at least one sheet and the associated filters for that sheet.
- the user on client compuier 906 applies "Filter 1 " to its local copy 910 of the collaborative spreadsheet.
- a user on client computer 912 applies "Filter 2" to its local copy 916 of the collaborative spreadsheet.
- client computer 906 determines and stores the inverse of "Filter 1" 908 which maps the cells of the filtered sheet to the cells of the unfiltered sheet.
- client computer 912 determines and stores the inverse of "Filter 2" 914.
- a user mutation references cell D5 of the filtered local copy stored on a client computer, where the data in cell D5 corresponds to the data in cel l A 1 of th e unfiltered sheet.
- the mutation is transformed against the inverse of the filter so that the transformed mutation references cell Al . This user action is sent to the cloud computing services for recordation in the unfiltered master copy of the sheet.
- the cloud computing service also sends the user action to other collaborators who are currently accessing the sheet.
- the user action is transformed through any filters used by the collaborator and then saved to the local copy on that client computer. For example, if the collaborator uses a filter that transforms the data in cell A 1 to cell B3, then the mutation is transformed through the filter and stored in cell B3 of the local copy of the sheet on the collaborator client computer.
- Formulae and calculations may also be transformed in the same manner as user actions so that ceil references make logical sense to each collaborator.
- the client computing service may track the filters that each collaborator is currently using. As in FIG, 9, the local copies of sheets may be altered by filters and user actions are stored in reference to the filtered sheet.
- the client computers may send the user actions directly to the cloud computing service, which performs the inverse filter transformation to obtain user actions referencing the unfiltered sheet.
- the cloud computing service may also transform user actions by filters used by collaborators before sending the user action to the collaborator client computers. Thus in contrast to the situation described in FIG. 9, the computation of the filter transformation and inverse transformation is done on the cloud computing service rather than the client computers.
- the cloud computing service may also allow some
- any application of a filter by user A automatically updates the view of the sheet for user B.
- Another user, C chooses to work independently and so user C's view of the sheet is not affected by user A's choice of filter.
- Method 1000 includes accessing, from each of a plurality of client computers, a fsrst sheet of a spreadsheet stored on a cloud computing service, where a plurality of filters is associated with the first sheet.
- the method further includes receiving at a first client computer in the plura lity of client computers a command by a first user to apply a first filter in the plurality of filters to the first sheet.
- the method further includes applying the first filter to the first sheet on the first client computer, and displaying the filtered first sheet to the first user, where a second client computer in the plurality of client computers concurrently displays an unfiltered first sheet.
- Method 1000 may be performed on any type of client computer that may connect to a cloud computing service, such as the client computer described in FIG. 3 or any desktop computer, laptop computer, tablet, smartphone, or such electronic device.
- Method 1000 begins when a plurality of client computers access a first sheet of a collaborative spreadsheet stored on a cloud computing service, illustrated at 1002.
- the master copy of the spreadsheet stored on the cloud computing service contains one or more sheets, where at least one sheet is associated with a plurality of filters. Filters, as described above, rearrange the display of data on the sheet for the user, and may include sorting data and removing certain data values from view. Filters may be defined by users and stored on the cloud computing service.
- the cloud computing service allows users on the plurality of client computers concurrent access to the first sheet, such as illustrated in FIG. 1.
- the spreadsheet may have an ACL that determines which users may access the spreadsheet, and each user's access level.
- the cloud computing service When a user on a client computer accesses the first sheet, the cloud computing service sends a. copy of the first sheet and the associated filters to the client computer.
- This copy is stored as a local copy on the client computer and is displayed to the user, for example through a web browser.
- a user interface on the web browser allows the user to view and edit the sheet. Edits, or mutations, made by the user are recorded in the local copy of the sheet and sent to the cloud computing service for recordation in the master copy.
- the client computer receives a command from a. user to apply a. filter to apply to the first sheet, illustrated at 1004.
- the cloud computing service provides the client computer with a user interface to view and edit the first sheet, such as the user interface shown in FIG. 7.
- the user interface includes a menu or sidebar window for a user to select a filter to apply to a group of cells in the first sheet.
- the user highlights the group of cells that the user desires to filter, and selects a filter from the plurality of filters associated with the first sheet.
- the client computer then applies the selected filter to the first sheet, illustrated at 1006.
- the filter transforms the cell data stored in the local copy of the first sheet, as described previously in this application. If the user has previously applied another filter to the first sheet, the selection of a new filter causes the client computer to remove the previous filter and apply the new filter to the first sheet,
- the client computer applies the selected filter to the first sheet
- the filtered first sheet is displayed to the user of the client computer, illustrated at 1008.
- a user selection of a filter on one client computer is not communicated to other client computers that are concurrently accessing the same sheet.
- a user on one client computer may apply a filter to the first sheet
- a second client computer still displays the unfiltered sheet, or perhaps a sheet that is filtered based on the selection of another filter by a user on the second client computer.
- the user selection of a filter may be communicated to the cloud computing service, which may store what filters each user is currently using.
- the cloud computing service does not alter the master copy of the first sheet and does not send filter selection information to other client computers. In this manner, method 1000 pro vides multiple concurrent collaborators with the ability to independently utilize filters on collaborative spreadsheets stored on a cloud computing service.
- Method 1 100 in FIG. 1 1 includes accessing, from each of a plurality of client computers, a first sheet of a spreadsheet stored on a cloud computing service.
- the method further includes creating a first filter on a first client computer in the plurality of client computers, where a user on the first client computer defines the first filter.
- the method further includes applying the first filter to the first sheet on the first client computer, where a second client compu ter in the plurality of client computers concurrently displays an unfiltered first sheet, and sending the first filter to the cloud computing service to be stored and associated with the first sheet.
- Method 1100 may be performed on any type of client computer that may connect to a cloud computing sendee, such as the client computer described in FIG. 3 or any desktop computer, laptop computer, tablet, smartphone, or such electronic device.
- Method 1 100 begins when a plurality of client computers access a first sheet of a collaborative spreadsheet stored on a cloud computing service, illustrated at 1 102.
- the master copy of the spreadsheet stored on the cloud computing se dee contains one or more sheets.
- One or more filters may be associated with each sheet.
- the cloud computing service allows users on the plurality of client compitters concurrent access to the first sheet, such as illustrated in FIG, 1.
- the spreadsheet may have an ACL that determines which users may access the spreadsheet, and each user's access level.
- the cloud computing service When a user on a client computer accesses the first sheet, the cloud computing service sends a copy of the first sheet and the associated filters to the client computer.
- This copy is stored as a local copy on the client computer and is displayed to the user, for example through a web browser.
- A. user interface on the web browser allows the user to view and edit the sheet. Edits, or mutations, made by the user are recorded in the local copy of the sheet and sent to the cloud computing service for recordation in the master copy.
- a user on a first client computer creates a first filter for the first sheet, illustrated at 1 104.
- the ability to create or edit filters for the spreadsheet may be limited by the ACL of the spreadsheet. For example, users with write access may create or edit a filter for the sheet while users with read access may use filters but may not create or edit them. Filters, as described above, rearrange the display of data on the sheet for the user, and may include sorting data and removing certain data values from view.
- the cloud computing service provides the client computer with a user interface to create and edit filters for the first sheet, such as the user interfaces shown in FIGS. 5 and 7. This user interface may be displayed on a web browser executing on the client computer.
- the user interface may include a menu or sidebar window for a user to create or edit a filter and apply it to a group of cells in the first sheet, such as the sidebar window shown in FIG, 7.
- a menu or sidebar window for a user to create or edit a filter and apply it to a group of cells in the first sheet, such as the sidebar window shown in FIG, 7.
- a menu similar to menu 502 in FIG. 5 may appear.
- the user defines the filter, such as defining a sort order or selecting certain data values to be displayed or removed from display.
- the filter is applied to the first sheet of the client computer, illustrated at 1 106.
- the filter transforms the cell data stored in the local copy of the first sheet, as described previously in this application.
- the filtered sheet is then displayed to the user.
- the created or edited filter is also sent to the cloud computing sendee, where the filter is stored and associated with the first sheet.
- the first sheet may also have other filters associated with it.
- Each user with appropriate access to the spreadsheet may create, edit, delete, rename, or duplicate the filters.
- the cloud computing sendee may send the created or updated filter to the other client computers currently accessing the first sheet so that other users may use the filters.
- method 1100 provides multiple concurrent collaborators with the ability to create or edit filters on collaborative spreadsheets stored on a cloud computing sendee.
- Method 1200 in FIG. 12 includes storing a spreadsheet on a server, where the spreadsheet comprises a plurality of sheets, and granting a plurality of client computers concurrent access to the spreadsheet.
- the method further includes receiving from the plurality of client computers a plurality of filters to be applied to a first sheet in the plurality of sheets, and storing the plurality of filters on the server, where the plurality of filters is associated with the first sheet.
- the method further includes providing the plurality of filters to each client computer in the plurality of client computers, where when a user on a first client computer in the plurality of client computers applies a first fi lter in the plurality of filters to the first sheet, the displ ay of the first sheet on a second client computer in the plurality of client computers is independent of the filter application on the first client computer.
- Method 1200 may be performed on a server that hosts a cloud computing service, such as the server described in FIG. 2,
- Method 1200 begins when a spreadsheet is stored on a server hosting a cloud computing sendee, illustrated at 1202.
- the spreadsheet has one or more sheets, where each sheet is composed of a number of ceils arranged in columns and rows. Users on client computers connect to the server to access the spreadsheet, such as illustrated in FIG. 1.
- the server provides a user interface for users to view and edit sheets of the spreadsheet, such as a user interface displayed on a web browser executing on each client computer. Examples of user interfaces for spreadsheets are shown in FIGS. 4-7.
- the spreadsheet may have been created by a user on a client computer and saved on the server.
- the spreadsheet is collaborative, meaning that more than one user may edit the spreadsheet at the same time.
- the spreadsheet may be associated with an access control list, which determines each user's level of access to the spreadsheet.
- the server grants one or more client computers concurrent access to the spreadsheet, illustrated at 1204.
- the users on the client computers may concurrently collaborate and edit the spreadsheet.
- the server may check whether the user is in the ACL of the spreadsheet. If the user is an authorized user, the server provides a copy of the spreadsheet to the client computer.
- the client computer stores this copy as a local copy on the client computer and displays it within a web browser.
- each client computer possesses a local copy of the spreadsheet, while the server maintains a master copy . Mutations made by one user are propagated to the server and to the other users so that all collaborators have up-to-date copies of the spreadsheet.
- the server receives from one or more client computers a plurality of filters to be applied to a first sheet of the spreadsheet, illustrated at 1206.
- the filters are created by users on the client computers using the user interface provided by the server. For example, a user may select the "Create New Filter" option 712 provided in sidebar window 702 shown in FIG. 7.
- the user then defines the filter using a filter menu similar to menu 502 shown in FIG. 5.
- the filter may include commands to sort certain cells or hide certain cell values from view. Once the user defines the filter, it is saved on the client computer and sent to the server.
- the user may also edit a filter, rename a filter, duplicate a filter, set a filter to be the default filter, or delete a filter using the user interface.
- the access control list may determine which users may create, edit, or delete filters for the spreadsheet.
- the server receives the filters created by various users and stores them, illustrated at 1208. The server associates the filters with the first sheet. If a user has edited or renamed a filter, the server saves the updated filter in place of the old filter. If a user has deleted a filter, the server deletes its copy of the filter. If a user sets a filter to be the default filter, the server may set a flag for its copy of the filter.
- the server After a number of filters for the first sheet have been created and stored on the server, the server provides the up-to-date plurality of filters to each client computer, illustrated at 1210.
- the server sends any new filters, changes made by a user to a filter, or commands to delete filters to each client computer so that all collaborators have an up-to-date list of filters available for the first sheet.
- each client computer maintains separate local copies of the first sheet, users may independently apply filters to their local copies of the first sheet without affecting the display of the first sheet on other client computers.
- the application of the filter is not treated the same as mutations, which are automatically passed to other collaborators, A user's selection of a filter may be communicated to the server, but the selection is not communicated to collaborator client computers.
- the server may provide users with an option to mirror each other's filter selections. For example, if user A and user B choose to mirror each other, any applica tion of a filter by user A automatically updates the view of the sheet for user B. Another user, C, chooses to work independently and so user Cs view of the sheet is not affected by user A's choice of filter.
- method 1200 provides a way for a server hosting a cloud computing service to provide filters for collaborative spreadsheets.
- Method 1300 shown in FIG. 13 includes accessing an unfiltered sheet of a spreadsheet stored on a server to display on a client computer, where a plurality of filters is associated with the unfiltered sheet. The method further includes receiving a selection by a user of a first filter in the plurality of filters to be applied to the unfiltered sheet, and displaying a filtered sheet to the user, where the filtered sheet is obtained by applying the first filter to the unfiltered sheet.
- the method further includes receiving a user action inputted by a user on the client computer, where the user action references cells of the unfiltered sheet, sending the user action to the server, transforming the user action against the first filter, and updating the display of the filtered sheet based on the transformed user action.
- Method 1300 may be performed on any type of client computer that may connect to a cloud computing service, such as the client compuier described in FIG. 3 or any desktop computer, laptop computer, tablet, smartphone, or such electronic device.
- Method 1300 begins when a client computer accesses an unfiltered sheet of a spreadsheet stored on a server hosting a cloud computing service, illustrated at 1302.
- the master copy of the spreadsheet stored on the server contains one or more sheets.
- One or more filters may be associated with each sheet.
- the server allows multiple users on client computers concurrent access to the first sheet, as illustrated in FIG. 1.
- the spreadsheet may have an ACL that determines which users may access the spreadsheet, and each user's access level.
- the cloud computing service sends a copy of the first sheet and the associated filters to the client computer.
- This copy is stored as a local copy on the client computer and is displayed to the user, for example through a web browser.
- a user interface on the web browser allows the user to view and edit the sheet, such as the user interfaces shown in FIGS. 4-7.
- the client computer After the client computer accesses the unfiltered sheet from the server, the client computer receives a selection of a first filter to be applied to the unfiltered sheet, illustrated at 1304,
- the user interface may include a sidebar window, such as illustrated in FIG. 7, from which the user may select a filter to apply to a segment of data in the unfiltered sheet.
- the client computer then applies the first filter to the unfiltered sheet and displays the resultant filtered sheet, illustrated at 1306.
- the first filter is a mapping, or a transformation, between the cells of the unfiltered sheet and the cells of the filtered sheet.
- the first filter may map cell Al of the unfiltered sheet to cell B2 of the filtered sheet such then when the first filter is applied, the display of cell B2 displays the data value of cell Al .
- the local copy of the unfiltered sheet stored on the client computer is unaffected by the user's selection of the first filter. That is, the client computer does not overwrite the unfiltered sheet with the filtered sheet in memory. Rather, the filtered sheet is temporarily stored and displayed on the display screen of the client computer.
- the client compuier receives a user action inputted by the user, illustrated at 1308.
- the user action may be an edit, or mutation, or a user presence activity, such as highlighting or selecting one or more cells.
- the user action references the cells of the unfiltered sheet, not the filtered sheet. For example, if the user changes the data value in ceil A! (which is mapped to ceil B2 by the first filter), the user action references ceil Al . Likewise if the user selected cell Al . Thus cell Al is changed in the local copy of the unfiltered sheet stored on the client computer. This user action, unchanged, is sent to the server, illustrated at 1310.
- the server stores a master copy of the first sheet that is unaffected by user selection of filters, so the user action may be directly applied to the master copy of the first sheet.
- the server may then send the user action to any other collaborators who are also currently accessing the spreadsheet.
- the collaborator client computers would transform the user action against any filters that has been applied to their local copies before displaying it. Transformation of collaborator user actions is discussed in relation to FIG. 14.
- the user action is also transformed against the first filter on the client computer, illustrated at 1312. After the user action is transformed against the first filter, it references the cells of the filtered sheet. Thus a mutation to cell Al is transformed to a mutation of cell B2.
- the filtered sheet is updated by the transformed user action and is then displayed to the user, illustrated at 1314.
- the client computer may send user actions directly to the server without the need to alter them. This allows the server and the client computer to communicate user actions directly to each other without an intervening layer of transformation to account for any filters applied by the user. In this manner method 1300 provides a way to process user actions on a collaborative spreadsheet when the user actions reference the unfiltered sheet.
- Method 1400 illustrated in FIG. 14 includes accessing an unfiltered sheet of a spreadsheet stored on a server to display on a client computer, where a plurality of filters is associated with the unfiltered sheet, and receiving a selection by a user of a first filter in the plurality of filters to be applied to the unfiltered sheet.
- the method further includes displaying a filtered sheet to the user, where the filtered sheet is obtained by applying the first filter to the unfiltered sheet, and receiving a collaborator action from the server, where the collaborator action references cells of the unfiltered sheet.
- the method further includes transforming the collaborator action against the first filter, and updating the display of the filtered sheet based on the transformed collaborator action.
- Method 1400 may be performed on any type of client computer that may connect to a cloud computing se dee, such as the client computer described in FIG. 3 or any desktop computer, laptop computer, tablet, smartphone, or such electronic device.
- Method 1400 begins when a client computer accesses an unfiltered sheet of a spreadsheet stored on a server hosting a cloud computing service, illustrated at 1402.
- the master copy of the spreadsheet stored on the server contains one or more sheets.
- One or more filters may be associated with each sheet.
- the server allows multiple users on client computers concurrent access to the first sheet, as illustrated in FIG. 1.
- the spreadsheet may have an ACL that determines which users may access the spreadsheet, and each user's access level.
- the cloud computing service sends a copy of the first sheet and the associated filters to the client computer.
- This copy is stored as a local copy on the client computer and is displayed to the user, for example through a web browser.
- a user interface on the web browser allows the user to view and edit the sheet, such as the user interfaces shown in FIGS, 4-7.
- the client computer After the client computer accesses the unfiltered sheet from the server, the client computer receives a selection of a first filter to be applied to the unfiltered sheet, illustrated at 1404.
- the user interface may include a sidebar window, such as illustrated in FIG. 7, from which the user may select a filter to apply to a segment of data in the unfiltered sheet.
- the client computer then applies the first filter to the unfiltered sheet and displays the resultant filtered sheet, illustrated at 1406.
- the first filter is a mapping, or a transformation, between the cells of the unfiltered sheet and the ceils of the filtered sheet.
- the first filter may map cell Al of the unfiltered sheet to cell B2 of the filtered sheet such then when the first filter is applied, the display of cell B2. displays the data value of cell Al.
- the local copy of the unfiltered sheet stored on the client computer is unaffected by the user's selection of the first filter. That is, the client computer does not overwrite the unfiltered sheet with the filtered sheet in memoiy. Rather, the filtered sheet is temporarily stored and displayed on the display screen of the client computer,
- the client computer receives a collaborator action from the server, illustrated at 1408.
- the collaborator action may be a mutation or a collaborator presence activity, such as highlighting or selecting one or more cells, which a collaborator currently accessing the spreadsheet has made to the first sheet.
- the collaborator action references the cells of the unfiltered sheet, not the filtered sheet. For example, if the collaborator changes the data value in cell Al (which is mapped to cell B2 by the first filter on the client computer), the collaborator action received from the server references cell Al.
- the client computer applies the collaborator action to the unfiltered sheet stored in memory.
- the server received the collaborator action from the collaborator and directly applied it to the master copy of the first sheet that the server stores.
- the server then sends the mutation to any other collaborators who are also currently accessing the spreadsheet.
- the client computer After the client computer receives the collaborator action, it transforms the collaborator action against the first filter, illustrated at 1410, After the coiiaborator action is transformed against the first filter, it references the cells of the filtered sheet. Thus a mutation to cell Al is transformed to a mutation of ceil B2.
- the filtered sheet is updated by the transformed coiiaborator action and is then displayed to the user, iliusiraied at 1412. For example, cell B2 on the display screen of the client computer may be changed to reflect the collaborator's mutation.
- the user interface on the web browser may show that the coiiaborator is currently highlighting cell B2. In this manner method 1400 provides a way to process coiiaborator actions on a collaborative spreadsheet when the user actions reference the unfiltered sheet.
- Method 1500 illustrated in FIG. 15 includes accessing an unfiltered sheet of a spreadsheet stored on a server to display on a client computer, where a plurality of filters is associated with the unfiltered sheet, and receiving a selection by a user of a first filter in the plurality of filters to be applied to the unfiltered sheet.
- the method further includes displaying a filtered sheet to the user, where the filtered sheet is obtained by applying the first filter to the unfiltered sheet, and receiving a user action inputted by a user on the client computer, where the user action references cells of the filtered sheet.
- the method further includes updating the display of the filtered sheet based on the user action, transforming the user action against an inverse of the first filter, and sending the transformed user action to the server.
- Method 1500 may be performed on any type of client computer that may connect to a cloud computing service, such as the client computer described in F G. 3 or any desktop computer, laptop computer, tablet, smartphone, or such electronic device.
- Method 1500 begins when a client computer accesses an unfiltered sheet of a spreadsheet stored on a server hosting a cloud computing service, illustrated at 1502.
- the master copy of the spreadsheet stored on the server contains one or more sheets.
- One or more filters may be associated with each sheet.
- the server allows multiple users on client computers concurrent access to the first sheet, as illustrated in FIG, 1.
- the spreadsheet may have an ACL that determines which users may access the spreadsheet, and each user's access level.
- the cloud computing service sends a copy of the first sheet and the associated filters to the client computer.
- This copy is stored as a local copy on the client computer and is displayed to the user, for example through a web browser.
- a user interface on the web browser allows the user to view and edit the sheet, such as the user interfaces shown in FIGS. 4-7.
- the client computer After the client computer accesses the unfiltered sheet from the server, the client computer receives a selection of a first filter to be applied to the unfiltered sheet, illustrated at 1504.
- the user interface may include a sidebar window, such as illustrated in FIG. 7, from which the user ma select a filter to apply to a segment of data in the unfiltered sheet.
- the client computer then applies the first filter to the unfiltered sheet and displays the resultant filtered sheet, illustrated at 1406.
- the first filter is a mapping, or a transformation, between the cells of the unfiltered sheet and the cells of the filtered sheet.
- the first filter may map cell Al of the unfiltered sheet to cell B2 of the filtered sheet such then when the first filter is applied, the display of cell B2 displays the data value of cell Al .
- the local copy of the unfiltered sheet stored on the client computer is overwritten by the filtered sheet, as opposed to the situation in method 1300 where the unfiltered sheet is not overwritten by the filtered sheet.
- the client computer receives a user action inputted by the user, illustrated at 1508.
- the user action may be an edit, or mutation, or a user presence activity, such as highlighting or selecting one or more cells.
- the user action references the cells of the filtered sheet, not the unfiltered sheet. For example, if the user changes the data value in unfiltered cell Al (which is mapped to cell B2 by the first filter), the user action references cell B2. Likewise if the user selected unfiltered cell Al . Thus cell B2 is changed in the local copy of the first sheet stored on the client computer.
- the filtered sheet is updated directly by the user action and is then displayed to the user, illustrated at 1510,
- the user action is also transformed against the inverse of first filter on the client computer, illustrated at 1512.
- the user action After the user action is transformed against the inverse of the first filter, it references the cells of the unfiltered sheet.
- a mutation to cell B2 of the filtered sheet is transformed to a mutation of cell A l of the unfiltered sheet.
- This transformed user action is sent to the server, illustrated at 1514.
- the server stores a master copy of the first sheet that is unaffected by user selection of filters, so the user action sent to the server should reference the ceils of the unfiltered sheet rather than the filtered sheet. Otherwise, the server will change the wrong cell in its master copy.
- the server may then send the user action to any other collaborators who are also currently accessing the spreadsheet.
- the collaborator client computers would transform the user actions against any filters that have been applied to their local copies before displaying it. Transformation of collaborator actions is discussed in relation to FIG. 14.
- the client computer may display user actions without any intervening steps. This leads to a quicker time to display than method 1300.
- the user actions are transformed against the inverse of the filter before being sent to the server to maintain consistency with the server copy of the first sheet. In this manner method 1500 provides a way to process user actions on a collaborative spreadsheet when the user actions reference the filtered sheet.
- the client computer may send the untransformed user action to the server along with information about which filter the client computer is currently using.
- the server may then transform the user action against the inverse of the first filter.
- the user action may then be stored in server memory.
- the server may also transform the transformed user action against filters used by collaborators before sending the user action to the collaborators.
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)
- Document Processing Apparatus (AREA)
- Information Transfer Between Computers (AREA)
- User Interface Of Digital Computer (AREA)
- Stored Programmes (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
Claims
Applications Claiming Priority (4)
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,265 US8943142B1 (en) | 2013-05-22 | 2013-05-22 | Non-collaborative filters in a collaborative document |
US13/900,193 US9361287B1 (en) | 2013-05-22 | 2013-05-22 | Non-collaborative filters in a collaborative document |
PCT/US2014/038934 WO2014190031A2 (en) | 2013-05-22 | 2014-05-21 | Non-collaborative filters in a collaborative document |
Publications (2)
Publication Number | Publication Date |
---|---|
EP3000055A2 true EP3000055A2 (en) | 2016-03-30 |
EP3000055A4 EP3000055A4 (en) | 2017-05-17 |
Family
ID=51059555
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
EP14734605.0A Withdrawn EP3000055A4 (en) | 2013-05-22 | 2014-05-21 | Non-collaborative filters in a collaborative document |
Country Status (4)
Country | Link |
---|---|
EP (1) | EP3000055A4 (en) |
CN (2) | CN105122238B (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 |
US10216494B2 (en) | 2016-12-03 | 2019-02-26 | Thomas STACHURA | Spreadsheet-based software application development |
US10540153B2 (en) | 2016-12-03 | 2020-01-21 | Thomas STACHURA | Spreadsheet-based software application development |
US11726753B2 (en) | 2016-12-03 | 2023-08-15 | Thomas STACHURA | Spreadsheet-based software application development |
CA3216654A1 (en) * | 2017-12-03 | 2019-06-06 | Thomas Stachura | Spreadsheet-based software application development |
US20200372210A1 (en) * | 2019-05-23 | 2020-11-26 | Sigma Computing, Inc. | Using lightweight references to present a worksheet |
Family Cites Families (14)
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 |
US8255791B2 (en) * | 2000-11-29 | 2012-08-28 | Dov Koren | Collaborative, flexible, interactive real-time displays |
US20050114169A1 (en) * | 2003-11-24 | 2005-05-26 | Hazim Ansari | Systems and methods for evaluating information to identify, and act upon, intellectual property issues |
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 |
US8190987B2 (en) * | 2007-10-25 | 2012-05-29 | Microsoft Corporation | Private views of data and local calculations during real time collaboration |
US8341163B2 (en) * | 2008-06-17 | 2012-12-25 | Microsoft Corporation | Techniques for filter sharing |
US8108779B1 (en) * | 2008-12-16 | 2012-01-31 | Adobe Systems Incorporated | Collaborative editing operations |
US9367530B2 (en) * | 2011-01-21 | 2016-06-14 | Jive Software | Distributed document co-authoring and processing |
-
2014
- 2014-05-21 CN CN201480021515.8A patent/CN105122238B/en active Active
- 2014-05-21 WO PCT/US2014/038934 patent/WO2014190031A2/en active Application Filing
- 2014-05-21 DE DE202014010948.6U patent/DE202014010948U1/en not_active Expired - Lifetime
- 2014-05-21 CN CN201811294207.9A patent/CN109635258B/en active Active
- 2014-05-21 EP EP14734605.0A patent/EP3000055A4/en not_active Withdrawn
Non-Patent Citations (1)
Title |
---|
See references of WO2014190031A3 * |
Also Published As
Publication number | Publication date |
---|---|
DE202014010948U1 (en) | 2017-01-27 |
CN109635258B (en) | 2020-03-06 |
WO2014190031A2 (en) | 2014-11-27 |
CN109635258A (en) | 2019-04-16 |
EP3000055A4 (en) | 2017-05-17 |
CN105122238A (en) | 2015-12-02 |
WO2014190031A3 (en) | 2015-04-23 |
CN105122238B (en) | 2018-11-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9635105B2 (en) | Non-collaborative filters in a collaborative document | |
US8943142B1 (en) | Non-collaborative filters in a collaborative document | |
CN109635258B (en) | Non-collaborative filters in collaborative documents | |
AU2019246901B2 (en) | Graphical user interface that simplifies user creation of custom calculations for data visualizations | |
US10169401B1 (en) | System and method for providing online data management services | |
US20190303406A1 (en) | Systems and Methods for Optimizing Performance of Graph Operations | |
US10783198B2 (en) | Row-based data filtering at a database level | |
US11030334B2 (en) | Compartment-based data security | |
US8788463B2 (en) | Flexible electronic records management | |
JP6078437B2 (en) | Personal information anonymization system | |
WO2012116355A2 (en) | Named object view over multiple files | |
CN109983431A (en) | System and method for storing the list retrieval in equipment | |
CN111512328A (en) | Collaborative document access recording and management | |
US20150058363A1 (en) | Cloud-based enterprise content management system | |
US20120117121A1 (en) | Browser-Based Database Manipulation | |
US9298688B1 (en) | Non-collaborative filters in a collaborative document | |
US20190294659A1 (en) | Embedding a portion of a source content item | |
DE112022000886T5 (en) | DATA PROCESSING SYSTEM WITH MANIPULATION OF LOGICAL DATA RECORD GROUPS | |
KR20230171986A (en) | Dynamic graphics containers | |
US11328263B2 (en) | User interfaces for filtering electronic calendar data sets | |
Györödi et al. | Web 2.0 technologies with jquery and ajax | |
US20200210436A1 (en) | Systems, methods, storage media, and computing platforms for context-based data retrieval | |
Yin et al. | Research of access control based on form component in workflow system | |
Tateosian et al. | Reading and Writing with Cursors | |
JP2013029957A (en) | Integrated management device, document management method, and computer program |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PUAI | Public reference made under article 153(3) epc to a published international application that has entered the european phase |
Free format text: ORIGINAL CODE: 0009012 |
|
17P | Request for examination filed |
Effective date: 20151209 |
|
AK | Designated contracting states |
Kind code of ref document: A2 Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR |
|
AX | Request for extension of the european patent |
Extension state: BA ME |
|
DAX | Request for extension of the european patent (deleted) | ||
A4 | Supplementary search report drawn up and despatched |
Effective date: 20170419 |
|
RIC1 | Information provided on ipc code assigned before grant |
Ipc: G06F 15/16 20060101ALI20170411BHEP Ipc: G06F 17/24 20060101ALI20170411BHEP Ipc: G06F 17/21 20060101AFI20170411BHEP |
|
RAP1 | Party data changed (applicant data changed or rights of an application transferred) |
Owner name: GOOGLE LLC |
|
17Q | First examination report despatched |
Effective date: 20191128 |
|
STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: EXAMINATION IS IN PROGRESS |
|
STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: THE APPLICATION HAS BEEN WITHDRAWN |
|
18W | Application withdrawn |
Effective date: 20210324 |
|
P01 | Opt-out of the competence of the unified patent court (upc) registered |
Effective date: 20230519 |