Structuring data for spreadsheet documents

• US 20070022128A1
• Filed: 03/24/2006
• Published: 01/25/2007
• Est. Priority Date: 06/03/2005
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Burke, Eoin, Rothschiller, Chad, Wu, Su-Piao, McCaughey, Robert, Chen, Noah
• Application Number:
  US11/389,367
• Publication Number:
  US 20070022128A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

An open file format is used to represent the features and data associated with a spreadsheet application within a document. The file format simplifies the way a spreadsheet application organizes document features and data, and presents a logical model that is easily accessible. The file format is made up of a collection of modular parts that are stored within a container. The modular parts are logically separate but are associated with one another by one or more relationships. Each of the modular parts is capable of being interrogated separately regardless of whether or not the application that created the document is running. Each modular part is capable of having information extracted from it and copied into another document and reused. Information may also be changed, added, and deleted from each of the modular parts.

Claims

1. A computer-readable medium having stored thereon an open file format for representing a document that is associated with a spreadsheet application, the open file format representing the document in a modular content framework implemented within a computing apparatus, comprising:

modular parts that are logically separate from one another but are associated by one or more relationships;

wherein each modular part is associated with a relationship type and is capable of being interrogated separately without other modular parts being interrogated; and

wherein the modular parts include;

a document properties part operative as a guide for properties of the document;

a sheet part for each sheet within a workbook; and

a markup language part that includes information for the modular parts.

2. The computer-readable medium of claim 1, wherein the modular content framework includes a container that encloses the modular parts within a single file.

3. The computer-readable medium of claim 2, wherein each modular part within the container is capable of being one of extracted from and copied from the document and reused in a different document along with associated modular parts identified by traversing relationships of the modular part reused.

4. The computer-readable medium of claim 3, wherein the modular parts further include a personal information part that may be removed for security reasons.

5. The computer-readable medium of claim 4, wherein the modular parts further include a user data part containing customized data capable of being read into the document.

6. The computer-readable medium of claim 4, wherein the modular parts further include at least one of the following:

a code part that includes code associated with the document and a strings part that includes common strings.

7. The computer-readable medium of claim 4, wherein the functions part includes functions that are expressed as text and are associated with at least one sheet within a workbook.

8. The computer-readable medium of claim 3, where the relationship types associated with the modular parts comprises at least one of a code file relationship capable of identifying potentially harmful code files, a string relationship;

a pivot table relationship;

a user data relationship, a hyperlink relationship, a comments relationship, an embedded object relationship, a personal information relationship;

a drawing object relationship, an image relationship, a document properties relationship, a thumbnail relationship, and a sheet relationship.

9. The computer-readable medium of claim 3, wherein the modular parts may include a future storage area such that previous versions of an application and future versions of the application may work without corrupting data.

10. The computer-readable medium of claim 9, wherein when content within a modular part is declared incorrectly, a spreadsheet application is configured to either fail to open the modular part or try to repair the modular part.

11. A computer-implemented method for representing a spreadsheet document in a file format wherein modular parts associated with the spreadsheet document include each part written into the file format, comprising:

writing sheet parts of the file format that are included within a workbook;

querying the spreadsheet document for relationship types to be associated with modular parts logically separate from the sheet parts but associated with the sheet parts by one or more relationships;

writing a second part of the file format separate from the sheet parts; and

establishing a relationship between the sheet parts and the second part;

wherein each of the spreadsheet parts and the second part may be interrogated individually.

12. The computer-implemented method of claim 11, further comprising:

writing other modular parts associated with relationship types wherein the other modular parts that are to be shared are written only once; and

establishing relationships to the other modular parts written.

13. The computer-implemented method of claim 12, wherein writing the other modular parts associated with the relationship types, comprises:

examining data associated with the document;

determining whether the data examined has been written to a modular part;

writing the modular part to include the data examined when the data examined has not been written to the modular part;

determining whether other data associated with the document has been examined; and

examining the other data associated with the document in response to determining that the other data has not been examined.

14. The computer-implemented method of claim 12, further comprising writing a shared strings part that includes common strings utilized within one or more the sheet parts.

15. The computer-implemented method of claim 14, further comprising:

writing other modular parts associated with relationship types wherein the other modular parts that are to be shared are written only once; and

establishing relationships to the other modular parts written.

16. The computer-implemented method of claim 13, further comprising ignoring the code from the document when the modular part is written.

17. The computer-implemented method of claim 13, further comprising stripping out personal information from the document before the modular part is written.

18. The computer-implemented method of claim 12, further comprising encapsulating the sheet parts and the second modular part within a container and storing the container as a single file.

19. The computer-implemented method of claim 13, further comprising validating the modular parts with an associated schema.

20. A computer program product comprising a computer-readable medium having control logic stored therein for causing a computer to represent a spreadsheet document in a file format comprising modular parts wherein the modular parts of the file format include each part written into the file format, the control logic comprising computer-readable program code for causing the computer to:

write a document part of the file format;

write a sheet part for each sheet within a workbook;

write a personal information part;

write a shared strings part;

write a code part; and

establish and write relationships between the parts.