Abstract: A data processing system implements displaying a tabbed user interface comprising a plurality of tabs for navigating among a plurality of electronic documents; determining a first tab of the plurality of tabs is associated with a first tab group according to a first grouping criterion; and causing a first tab group control element to be displayed proximate to the first tab, the first tab group control element providing a set of tools for accessing content associated with the first tab group and for creating new tabs associated with the first tab group

Abstract: A data processing system implements displaying a tabbed user interface comprising a plurality of tabs for navigating among a plurality of electronic documents; determining a first tab of the plurality of tabs is associated with a first tab group according to a first grouping criterion; and causing a first tab group control element to be displayed proximate to the first tab, the first tab group control element providing a set of tools for accessing content associated with the first tab group and for creating new tabs associated with the first tab group.

Abstract: Dynamic collaborative presence information is provided. A plurality of users may access a document concurrently. Presence information associated with each of the users may be communicated to a server, collected, and communicated to a client application running on each user's client device. The client application may dynamically show where other users are editing a cell or a range of cells to help avoid collisions of edits in the document. Various interface elements may be provided for indicating presence and for indicating whether a single user or multiple users have selected or are editing the cell or range of cells.

Abstract: Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

Abstract: Data formatting rules to convert data from one form to another form are automatically determined based on a user's edits. A machine learning heuristic is applied to a user's edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use.

Abstract: Dynamic collaborative presence information is provided. A plurality of users may access a document concurrently. Presence information associated with each of the users may be communicated to a server, collected, and communicated to a client application running on each user's client device. The client application may dynamically show where other users are editing a cell or a range of cells to help avoid collisions of edits in the document. Various interface elements may be provided for indicating presence and for indicating whether a single user or multiple users have selected or are editing the cell or range of cells.

Abstract: Dynamic collaborative presence information is provided. A plurality of users may access a document concurrently. Presence information associated with each of the users may be communicated to a server, collected, and communicated to a client application running on each user's client device. The client application may dynamically show where other users are editing a cell or a range of cells to help avoid collisions of edits in the document. Various interface elements may be provided for indicating presence and for indicating whether a single user or multiple users have selected or are editing the cell or range of cells.

Abstract: Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

Abstract: Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

Abstract: Dynamic collaborative presence information is provided. A plurality of users may access a document concurrently. Presence information associated with each of the users may be communicated to a server, collected, and communicated to a client application running on each user's client device. The client application may dynamically show where other users are editing a cell or a range of cells to help avoid collisions of edits in the document. Various interface elements may be provided for indicating presence and for indicating whether a single user or multiple users have selected or are editing the cell or range of cells.

Abstract: Animation and visuals are displayed when automatically filling/changing values within a document. A scan animation may be displayed to assist a user in understanding that an action is about to occur using their recent edit(s). A fill animation may be displayed while the suggested values are automatically filled within the document. For example, the suggested values may be displayed according to an uncommitted state (e.g. light grey text) as compared to a committed state (e.g. black text) of related values. The suggested values may be accepted/rejected while they are displayed according to the uncommitted state. When the suggested values are rejected, the suggested values are removed from the display. When the suggested values are accepted, the suggested values are transitioned to the committed state. When a user performs an edit on one or more of the suggested values, a change animation may be displayed.

Abstract: Data formatting rules to convert data from one form to another form are automatically determined based on a user's edits. A machine learning heuristic is applied to a user's edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use.

Abstract: Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

Abstract: A method and system are provided for inferring a schema from an electronic document containing hierarchical data for use in a spreadsheet application program. The electronic document containing the hierarchical data is received into an application program. The application program may be a spreadsheet application program. The format of the hierarchical data structure may be XML. The hierarchical data includes a set of nodes making up the structure of the hierarchical data. The nodes may be XML elements and attributes. The hierarchical data is then parsed to discover one of the nodes in the hierarchical data. Once the node has been discovered, content associated with the discovered node is saved to a memory location in the computer system. The content may include data associated with the discovered node and the type of data associated with the node. The hierarchical data is then parsed again to discover subsequent nodes until the content for all of the nodes has been saved to the memory location.

Abstract: A method and system are provided for converting a hierarchical data structure into a flat data structure based on a schema. The format of the hierarchical data structure may be XML. A hierarchical data structure conforming to a schema is loaded into an application program. The data structure includes elements and attributes linked together in a parent-child relationship. The schema defines the hierarchical relationships between the elements and attributes in the hierarchical data structure. After the hierarchical data structure conforming to the schema has been loaded, a plurality of layout rules is applied to the hierarchical data based on the schema to create a flat data structure. The layout rules determine how the hierarchical data will be inserted in the flat data structure. The layout rules may be applied by identifying properties in the schema which identify occurrence requirements for elements defined in the schema.

Abstract: XML data is associated with an XML schema file defining XML data types and data type definitions for applying XML data to the document. An XML data map is prepared that relates that any XML data applied to the document back to corresponding XML elements or attributes defined in the associated schema file. When the document is imported into a spreadsheet application grid, the data map is parsed to find XPATHs in the imported spreadsheet document of XML data and the user entered data. After an imported document has been edited, or after a document is created to include the application of XML data in association with a selected XML schema file, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.

Abstract: A mechanism is provided for embedding an object in a receiving or client document such that a client application may operate on the embedded object to include interrogation and modification of data contained in the embedded object. When a given document object is embedded into a receiving document, data representing the embedded object is saved to a data stream storage for the receiving document. When the embedded object in the receiving document is subsequently requested in response to an operation executed on the embedded object, the receiving application obtains the data representation of the embedded object from the data stream storage. Once the receiving application obtains the data representation of the embedded object, the receiving application may perform operations on the embedded object by accessing the embedded object via its data representation.

Abstract: Methods and systems are provided for exposing nested data in computer-generated documents in a transparent manner. A mechanism is provided for a client application to query a server application for a list of available file formats after an object is requested from a server application document for embedding into a client application document. Another mechanism is provided for the client application to request a particular format associated with the embedded object from the server application document. Once the client application obtains file format information available to the server application or associated with the particular object, the client application may utilize the obtained file formats for utilizing or operating on the embedded object according to the native file formats associated with the embedded object.