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: Data presented in a hierarchical format is rendered in a form allowing the data to be imported into a spreadsheet document where the data can be modified and new data can be added. A data file containing the hierarchically formatted data is selected for importing. A mapping relating a plurality of elements within the hierarchical data to a plurality of respective locations in the spreadsheet document is accessed. The hierarchical data is rendered in the spreadsheet document according to the mapping. Input is received to modify the hierarchical data rendered in the spreadsheet document. The mapping is updated to include the modifications to the hierarchical data. The modifications to the hierarchical data and the updated mapping are exported for subsequent rendering in a second spreadsheet document according to the updated mapping.

Abstract: Extensible markup language data in an extensible markup language (such as XML) is associated with a schema file for defining data types and data type definitions for applying data to the document. A map is prepared that relates that any extensible markup data applied to the document back to corresponding 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 which determine the location, data types and user data for each cell or list object in the document related to the schema file. The cells and lists are populated with the extensible markup data and user data, and rendered according to formatting dictated by the extensible markup data applied to the document. The document may be exported such that the extensible markup data is maintained for subsequent import and use.

Abstract: Method and system for verifying and storing documents during a failure in a program module. Once a failure is detected in the program module, control passes to an exception handler that determines whether the open files have been modified. If so, a crash handler is executed, which verifies and stores the documents by detecting and repairing any discovered corruption. The program module is then terminated and restarted. Upon restarting the program module, the repaired document is opened and displayed to the user with a list of repairs.

Abstract: 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.

Abstract: An ergonomic pointing device, such as a mouse, is coupled to a computer having a visual display device. As a user rotates a roller associated with the mouse, the mouse generates computer signals that are interpreted by an operating system and software applications running on the computer. The signals generated by the roller, together with a given software application, can be used for spatial navigation. In spatial navigation, a user rotates the roller to cause the computer and the visual display to increase or decrease magnification levels of the document on the display. Other models of spatial navigation allow the user to activate a roller switch, depress special function keys on a keyboard and/or move the mouse to pant, automatically scroll or manually scroll through the document.

Abstract: 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 the XML data to the document. An XML data map is prepared that relates 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, 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: 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.

Abstract: Methods and systems are provided for mapping markup language data and schema, such as eXtensible Markup Language (XML) data and XML schema, to selected fields (cells, columns, rows) of a spreadsheet application document. An XML schema file is associated with a spreadsheet application document by providing a mechanism of adding the schema definitions to the spreadsheet application document. Furthermore, XML schema constructs such as elements, attributes, and simple content are associated to regions in the spreadsheet application document by providing a tree view structure of a generalized instance of a given XML schema file. A user may drag and drop markup language nodes representing elements, attributes and simple data content, from the tree view structure of the generalized instance of the XML schema file onto a spreadsheet worksheet grid.

Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: The present invention provides several database formulas that can manipulate large sets of data. Each database formula is customizable and repeatable without user intervention. Thus, users may enter numerous options that can cover the user's desire for data output in certain forms or formats, select a set of input data, and consistently receive a set of output data. In some embodiments, the user may refer to the set of data semantically instead of specifying a range of cells to use in the database formula. Referring to the data semantically allows the database formulas to adjust to changes in the range of cells new data may occupy.

Abstract: The present invention relates to a new type of structured name within a spreadsheet program that allows users to refer to tables, columns of data within tables, headers of tables, totals from tables, PivotTables®, and portions of PivotTable® data by the data's headers. Embodiments of the present invention comprise a method for referring to a set of data that comprises receiving one or more semantic designations, wherein the one or more semantic designations name a set of context information that describes one or more items of data in a data structure, automatically creating a structural reference, and associating the context information with the structural reference.

Abstract: Methods and systems are provided for importing and exporting markup language formatted data into a spreadsheet document. XML data is associated with a schema file defining data types and data type definitions for applying the XML data to the document. A map is prepared that relates any XML data applied to the document back to corresponding elements or attributes defined in the schema file. When the document is imported into a spreadsheet application grid, the map is parsed to find XPATHs which determine the location, data types and user data for each cell or list object in the document related to the schema file. The cells and lists are populated with the XML data and user data and rendered according to formatting dictated by the XML data applied to the document. The document may be exported such that the XML data is maintained for subsequent import and use.

Abstract: 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.

Abstract: 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.

Abstract: An ergonomic pointing device, such as a mouse, includes a wheel to provide an input signal in addition to X and Y position signals provided by a rotatable ball of a standard mouse. The wheel extends from an upper surface of the pointing device and may be rotated and depressed by the finger of the user, the wheel being positioned and configured to allow a user to activate the wheel while maintaining a finger in a biomechanically neutral position. The mouse is coupled to a computer having a visual display device capable of displaying a data file having adjustable display characteristics. As a user rotates the roller, the mouse generates computer signals that are interpreted by an operating system and software applications running on the computer. The signals generated by the roller, together with a given software application, can be used in spatial navigation.

Abstract: An ergonomic pointing device, such as a mouse, includes a wheel to provide an input signal in addition to X and Y position signals provided by a rotatable ball of a standard mouse. The wheel extends from an upper surface of the pointing device and may be rotated and depressed by the finger of the user, the wheel being positioned and configured to allow a user to activate the wheel while maintaining a finger in a biomechanically neutral position. The wheel and associated structure, as well as the forces required to rotate and depress the wheel, are configured to reduce inadvertent actuation and to provide a user with tactile feedback, thereby allowing the user to accurately and intuitively activate the pointing device without exceeding an acceptable extension and range of motion for the user's finger and wrist. The mouse is coupled to a computer having a visual display device.