Marise M Chan

7007033, Feb 28, 2006

Apr 28, 2003

10/425189

Chad Rothschiller - Edmonds WA, US
Kelly J. Lynch - Redmond WA, US
Ramakrishnan Natarajan - Redmond WA, US
Juha Niemisto - Mercer Island WA, US
Marise Chan - Redmond WA, US
Thibaut Vial - Seattle WA, US

Microsoft Corporation - Redmond WA

G06F 7/00

707101, 707 1, 707100, 715705

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.

7017112, Mar 21, 2006

Feb 28, 2003

10/377145

Robert Collie - Kirkland WA, US
Chad Rothschiller - Edmonds WA, US
Ulrich Homann - Kirkland WA, US
Joseph Chirilov - Kirkland WA, US
Kelly J. Lynch - Redmond WA, US
Ramakrishnan Natarajan - Redmond WA, US
Eoin Burke - Seattle WA, US
Juha Niemisto - Mercer Island WA, US
Michael J. McCormack - Snohomish WA, US
Parul Dalia - Kirkland WA, US
Marise Chan - Redmond WA, US
James Rivera - Bellevue WA, US

Microsoft Corporation - Redmond WA

G06F 15/00

715513, 715503, 715526

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.

7249316, Jul 24, 2007

Jan 9, 2006

11/328042

Robert Collie - Kirkland WA, US
Chad Rothschiller - Edmonds WA, US
Ulrich Homann - Kirkland WA, US
Joseph Chirilov - Kirkland WA, US
Kelly J. Lynch - Redmond WA, US
Ramakrishnan Natarajan - Redmond WA, US
Eoin Burke - Seattle WA, US
Juha Niemisto - Mercer Island WA, US
Michael J. McCormack - Snohomish WA, US
Parul Dalia - Kirkland WA, US
Marise Chan - Redmond WA, US
James Rivera - Bellevue WA, US

Microsoft Corporation - Redmond WA

G06F 15/00
G06F 17/21
G06F 17/24

715513, 715503, 715517, 715526, 707 1, 707100

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.

7337182, Feb 26, 2008

Aug 29, 2005

11/214222

Chad Rothschiller - Edmonds WA, US
Kelly J. Lynch - Redmond WA, US
Ramakrishnan Natarajan - Redmond WA, US
Juha Niemisto - Mercer Island WA, US
Marise Chan - Redmond WA, US
Thibaut Vial - Seattle WA, US

Microsoft Corporation - Redmond WA

G06F 17/30

707101, 7071041, 707100, 707 3

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.

7549117, Jun 16, 2009

Jul 22, 2005

11/187573

Marise Chan - Redmond WA, US
Barry C. McCord - Bellevue WA, US
Kenneth E. Schmidt - Mercer Island WA, US
James Sukhabut - Redmond WA, US
Christopher C. Yu - Redmond WA, US

Microsoft Corporation - Redmond WA

G06F 17/00

715217, 715220

A worldwide number format for use with a spreadsheet program module is disclosed. The worldwide number format includes a locale specifier comprising a number shape, a calendar type and a locale identification (LCID). The worldwide number format also includes a base number format and a value. The LCID is used to categorize different parts of the world. Primarily, the LCID categorizes different parts of the world by language such as English, German, French, Thai, Arabic, etc. The LCID is used to determine what language to display month names, month abbreviations, weekday names, weekday abbreviations, time designations such as AM/PM, etc. The calendar type supports both Gregorian and non-Gregorian calendars. Calendar type is a value to indicate which calendar should be used to calculate the date from the value. The number shape is a value that indicates what shape in which to represent the number.

7640493, Dec 29, 2009

Jan 23, 2006

11/337942

Robert Collie - Kirkland WA, US
Chad Rothschiller - Edmonds WA, US
Ulrich Homann - Kirkland WA, US
Joseph Chirilov - Kirkland WA, US
Kelly J. Lynch - Redmond WA, US
Ramakrishnan Natarajan - Redmond WA, US
Eoin Burke - Seattle WA, US
Juha Niemisto - Mercer Island WA, US
Michael J. McCormack - Snohomish WA, US
Parul Dalia - Kirkland WA, US
Marise Chan - Redmond WA, US
James Rivera - Bellevue WA, US

Microsoft Corporation - Redmond WA

G06F 15/00
G06F 17/21
G06F 17/24

715234, 715212, 715249, 707 1, 707100

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.

7703007, Apr 20, 2010

Dec 27, 2005

11/318688

Robert Collie - Kirkland WA, US
Chad Rothschiller - Edmonds WA, US
Ulrich Homann - Kirkland WA, US
Joseph Chirilov - Kirkland WA, US
Kelly J. Lynch - Redmond WA, US
Ramakrishnan Natarajan - Redmond WA, US
Eoin Burke - Seattle WA, US
Juha Niemisto - Mercer Island WA, US
Michael J. McCormack - Snohomish WA, US
Parul Dalia - Kirkland WA, US
Marise Chan - Redmond WA, US
James Rivera - Bellevue WA, US

Microsoft Corporation - Redmond WA

G06F 17/00
G06F 17/30

715234, 715212, 715249, 707 3, 707100

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.

7954046, May 31, 2011

Dec 9, 2005

11/297978

Robert Collie - Kirkland WA, US
Chad Rothschiller - Edmonds WA, US
Ulrich Homann - Kirkland WA, US
Joseph Chirilov - Kirkland WA, US
Kelly J. Lynch - Redmond WA, US
Ramakrishnan Natarajan - Redmond WA, US
Eoin Burke - Seattle WA, US
Juha Niemisto - Mercer Island WA, US
Michael J. McCormack - Snohomish WA, US
Parul Dalia - Kirkland WA, US
Marise Chan - Redmond WA, US
James Rivera - Bellevue WA, US

Microsoft Corporation - Redmond WA

G06F 3/00
G06F 17/30

715212, 715234, 715255, 715760, 7079991, 707999102

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.