摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
Methods and systems are provided for controlling elements of computing systems including operating systems, software applications and different versions of software applications to better facilitate cross-application and cross-version collaboration of files. Elements within a computing system, for example, operating systems, applications, or particular versions of an application, are reconfigured at application start time or document start time so that individual elements may interact with existing files of an otherwise different computing system or such that individual elements may generate or edit files targeted at otherwise different computing systems.
摘要:
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. Then a schema generator generates schema elements using complex rules based on the particular qualities of each discovered node for each discovered node until a schema is generated for the hierarchical data.
摘要:
Methods and systems are provided for managing the application of one or more XML data mappings or one or more XML schema files to a spreadsheet application workbook. One or more XML schema files for associating to the spreadsheet workbook are obtained. Each schema file is iterated to determine if one or more additional schema files are identified in each of the obtained schema files. Each obtained schema is parsed to determine data definitions, elements, attributes, structure, and simple data content required by each schema file for valid XML data. All obtained schema files are combined to create a unified schema definition. A single root element is selected to serve as a root element for the generalized instance structure. A generalized instance structure of the unified schema definition is built representing all available elements, attributes or simple data content of the unified schema definition that may be applied to the spreadsheet application workbook. A tree view of the generalized instance structure is displayed for providing a visual representation of the instance structure of the unified schema definition representing elements, attributes, structure, and simple data content of the XML defined by the unified schema definition that may be validly applied to the spreadsheet workbook according to the generalized instance structure. Writing pointers to the XML map object expresses a relationship between workbook locations and XML elements.
摘要:
Methods and systems are provided for importing markup language formatted data into a spreadsheet document and for exporting markup language formatted data from a spreadsheet document. 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. Each XPATH is executed to determine the location, data types and user data for each cell or list object in the document that is related back to the associated schema file. The cells and lists are populated with the XML data and user data, and the data is rendered in the spreadsheet according to the formatting dictated by the XML data applied to the spreadsheet in association with the XML schema file. 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.
摘要:
Methods and systems are provided for managing personally identifiable and/or sensitive information (PII/SI) in a manner that is independent of a software application that is used for creating or editing a document containing the PII/SI. PII/SI in a document is marked or flagged in an application-independent manner so that a solution application programmed to discover and process marked PII/SI may readily discover the marked information for redacting the information, editing the information, or otherwise disposing of the information as desired. PII/SI in documents may be annotated according to the Extensible Markup Language (XML). A separate XML namespace may be used to distinguish the annotated PII/SI from other content in the document. An application-independent solution may be built for scanning a given document for all annotated information belonging to the namespace associated with the PII/SI. Once the annotated information is located in a given document, it may be redacted, edited, or otherwise processed or disposed of as desired.
摘要:
Methods and systems provide for breaking a computer-generated document into a number of components where the components have explicit relationships with each other. A relationship representation is generated for the components of the document. A user may then navigate the relationships between the components to quickly understand the nature of the document and its components and to locate particular portions of the document that are important to the user. In addition, the user may open, edit and reuse particular components of the document apart from the rest of the document and without having to open or edit the document.