公开(公告)号：US20070022128A1

公开(公告)日：2007-01-25

申请号：US11389367

申请日：2006-03-24

申请人： Chad Rothschiller ,  Eoin Burke ,  Noah Chen ,  Robert McCaughey ,  Su-Piao Wu

发明人： Chad Rothschiller ,  Eoin Burke ,  Noah Chen ,  Robert McCaughey ,  Su-Piao Wu

IPC分类号： G06F7/00

CPC分类号： G06F17/246

摘要： 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.

摘要翻译： 打开的文件格式用于表示与文档中的电子表格应用程序相关联的功能和数据。 文件格式简化了电子表格应用程序组织文档特征和数据的方式，并呈现了易于访问的逻辑模型。 文件格式由存储在容器中的模块化部件的集合组成。 模块化部件在逻辑上是分开的，但是通过一个或多个关系彼此相关联。 无论创建文档的应用程序是否正在运行，每个模块化部件都可以单独进行询问。 每个模块部分都能够从中提取信息并复制到另一个文档中并被重用。 信息也可以从每个模块化部件更改，添加和删除。

公开(公告)号：US20060259854A1

公开(公告)日：2006-11-16

申请号：US11125907

申请日：2005-05-10

申请人： Charles Walker ,  Brian Jones ,  Chad Rothschiller ,  Shawn Villaron

发明人： Charles Walker ,  Brian Jones ,  Chad Rothschiller ,  Shawn Villaron

IPC分类号： G06F17/00

CPC分类号： G06F17/2229

摘要： Methods and computer-readable mediums structure an electronic document for identification and use of document parts. A method involves organizing parts of the electronic document as separate parts. The separate parts include resources internal and/or external to where the document is located. The method also involves representing a link between any of the parts as a relationship to be processed listed in a relationship part associated with a source part of the relationship. This relationship part contains a list of relationships for the source part and processing a relationship returns content of a target part of the relationship. Each relationship is also associated with a relationship type. Still further, the method involves representing via the relationship part how one or more parts relate to other separate parts, tracking internal resources, and tracking external resources. Thus, applications can infer the structure of the document by traversing the relationships.

摘要翻译： 方法和计算机可读介质构成用于识别和使用文档部件的电子文档。 一种方法涉及将电子文档的部分组织为单独的部分。 单独的部分包括文档所在的内部和/或外部的资源。 该方法还涉及将任何部分之间的链接表示为与关系的源部分相关联的关系部分中列出的待处理关系。 该关系部分包含源部分的关系列表，并且处理关系返回关系的目标部分的内容。 每个关系也与关系类型相关联。 此外，该方法涉及通过关系部分表示一个或多个部分如何与其他单独部分相关，跟踪内部资源和跟踪外部资源。 因此，应用程序可以通过遍历关系来推断文档的结构。

公开(公告)号：US07096422B2

公开(公告)日：2006-08-22

申请号：US10377256

申请日：2003-02-28

申请人： Chad Rothschiller ,  Robert Collie ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Jianlan Song ,  James Rivera ,  Parul Dalia

发明人： Chad Rothschiller ,  Robert Collie ,  Joseph Chirilov ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Jianlan Song ,  James Rivera ,  Parul Dalia

IPC分类号： G06F15/00

CPC分类号： G06F17/30917 ,  G06F17/2247 ,  G06F17/227 ,  G06F17/246

摘要： 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. Once a cell, column or row in worksheet grid accepts the dropped element or attribute, an association is made between the target location in the worksheet grid, and the definition, data type and rules associated with the dropped element or attribute by setting an XML path language (XPATH) marker to point the target location back to the selected element or attribute in the XML schema file. Having all or partially all desired markup language elements or attributes associated with desired target locations in the spreadsheet grid, a general mapping of marked-up locations in the spreadsheet grid and their associated elements and/or attributes in an associated XML schema file is created.

摘要翻译： 提供了方法和系统，用于将标记语言数据和模式（如可扩展标记语言（XML）数据和XML模式）映射到电子表格应用程序文档的选定字段（单元格，列，行）。 通过提供将模式定义添加到电子表格应用程序文档的机制，将XML模式文件与电子表格应用程序文档相关联。 此外，XML模式构造（如元素，属性和简单内容）通过提供给定XML模式文件的通用实例的树视图结构与电子表格应用程序文档中的区域相关联。 用户可以将表示元素，属性和简单数据内容的标记语言节点从XML模式文件的广义实例的树状视图结构拖放到电子表格工作表网格上。 一旦工作表网格中的单元格，列或行接受删除的元素或属性，就会通过设置XML路径在工作表网格中的目标位置与与删除的元素或属性相关联的定义，数据类型和规则之间进行关联 语言（XPATH）标记将目标位置指向XML模式文件中所选的元素或属性。 具有与电子表格网格中的期望目标位置相关联的全部或部分所有期望的标记语言元素或属性，创建电子表格网格中的标记位置及其相关联的元素和/或相关联的XML模式文件中的属性的一般映射。

公开(公告)号：US20060143542A1

公开(公告)日：2006-06-29

申请号：US11018916

申请日：2004-12-20

申请人： Brian Jones ,  Carol Liu ,  Chad Rothschiller ,  Robert McCaughey ,  Shawn Villaron ,  Su-Piao Wu

发明人： Brian Jones ,  Carol Liu ,  Chad Rothschiller ,  Robert McCaughey ,  Shawn Villaron ,  Su-Piao Wu

IPC分类号： G06F11/00

CPC分类号： G06F11/1402 ,  Y10S707/99943

摘要： A method and computer-readable medium are provided for saving the contents of a memory structure stored in a volatile memory. According to the method, corrupted portions of the memory structure are identified and an attempt is made to repair these portions. If the corrupted portions cannot be repaired, the saving of these portions is skipped. The uncorrupted and repaired portions of the memory structure are then saved to a data file stored on a mass storage device. If portions of the memory structure cannot be repaired or skipped, an attempt is made to save only the user data contained in the memory structure to the data file. In this manner, the user data contained in the memory structure may be saved to a data file even in cases of severe corruption.

摘要翻译： 提供了一种用于保存存储在易失性存储器中的存储结构的内容的方法和计算机可读介质。 根据该方法，识别存储器结构的损坏部分，并尝试修复这些部分。 如果损坏部分无法修复，则省略这些部分。 然后将存储器结构的未损坏和修复的部分保存到存储在大容量存储设备上的数据文件。 如果存储器结构的部分不能被修复或跳过，则尝试仅将包含在存储器结构中的用户数据保存到数据文件。 以这种方式，即使在严重腐败的情况下，包含在存储器结构中的用户数据也可以被保存到数据文件。

公开(公告)号：US20060136433A1

公开(公告)日：2006-06-22

申请号：US11018912

申请日：2004-12-20

申请人： Chad Rothschiller ,  Su-Piao Wu

发明人： Chad Rothschiller ,  Su-Piao Wu

IPC分类号： G06F7/00 ,  G06F17/24

CPC分类号： G06F17/246 ,  G06F17/2247

摘要： File formats, methods, and computer program products are provided for representing a workbook in a modular content framework. The modular content framework may include a file format container associated with modular parts. A file format includes logically separate modular parts that are associated with each other by one or more relationships where each modular part is associated with a relationship type. The modular parts include a workbook part operative as a guide for properties of the workbook and a worksheet part associated with the workbook part and operative to specify a definition of cells within a worksheet associated with the worksheet part. The modular parts may also include a document properties part containing built-in properties associated with the file format and a thumbnail part containing associated thumbnails. Each modular part is capable of being interrogated separately, extracted from the workbook, and/or reused in a different workbook.

公开(公告)号：US20060117251A1

公开(公告)日：2006-06-01

申请号：US11326892

申请日：2006-01-06

申请人： Chad Rothschiller ,  Michael McCormack ,  Ramakrishnan Natarajan

发明人： Chad Rothschiller ,  Michael McCormack ,  Ramakrishnan Natarajan

IPC分类号： G06F17/00

CPC分类号： G06F17/227 ,  G06F17/2247 ,  G06F17/24 ,  Y10S707/99943

摘要： 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. After the layout rules have been applied to the hierarchical data, the hierarchical data is rendered into a spreadsheet by inserting the data in rows and columns.

摘要翻译： 提供了一种基于模式将层次数据结构转换为平面数据结构的方法和系统。 层次数据结构的格式可以是XML。 符合模式的分层数据结构被加载到应用程序中。 数据结构包括在父子关系中链接在一起的元素和属性。 该模式定义了分层数据结构中的元素和属性之间的分层关系。 在已经加载了符合模式的分层数据结构之后，基于模式将多个布局规则应用于分层数据，以创建平面数据结构。 布局规则确定分层数据将如何插入平面数据结构中。 可以通过标识模式中的属性来识别布局规则，以识别模式中定义的元素的出现要求。 在将布局规则应用于层次数据之后，通过以数据行和列的形式插入数据，将分层数据呈现为电子表格。

公开(公告)号：US20060101333A1

公开(公告)日：2006-05-11

申请号：US11318688

申请日：2005-12-27

申请人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

发明人： Robert Collie ,  Chad Rothschiller ,  Ulrich Homann ,  Joseph Chirilov ,  Kelly Lynch ,  Ramakrishnan Natarajan ,  Eoin Burke ,  Juha Niemisto ,  Michael McCormack ,  Parul Dalia ,  Marise Chan ,  James Rivera

IPC分类号： G06F17/21 ,  G06F17/24 ,  G06F7/00

CPC分类号： G06F17/2229 ,  Y10S707/99931 ,  Y10S707/99943

摘要： 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.

摘要翻译： 提供了方法和系统，用于将标记语言格式的数据导入到电子表格文档中，并从电子表格文档导出标记语言格式的数据。 XML数据与定义用于将XML数据应用于文档的XML数据类型和数据类型定义的XML模式文件相关联。 准备XML数据映射，将应用于该文档的任何XML数据与相关模式文件中定义的相应XML元素或属性相关联。 将文档导入电子表格应用程序网格时，将解析数据映射，以在导入的XML数据的电子表格文档中查找XPATH，并输入用户的数据。 执行每个XPATH以确定文档中与关联模式文件相关的每个单元格或列表对象的位置，数据类型和用户数据。 单元格和列表填充有XML数据和用户数据，并且根据应用于与XML模式文件相关联的电子表格的XML数据指定的格式，在电子表格中呈现数据。 在导入的文档被编辑之后，或在创建文档以包括与所选XML模式文件相关联的XML数据的应用程序之后，可以导出该文档，使得应用于该文档的XML数据被维护以供随后导入， 使用文件。

公开(公告)号：US07007033B1

公开(公告)日：2006-02-28

申请号：US10425189

申请日：2003-04-28

申请人： Chad Rothschiller ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

发明人： Chad Rothschiller ,  Kelly J. Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

IPC分类号： G06F7/00

CPC分类号： G06F17/272 ,  G06F17/2247 ,  G06F17/246 ,  G06F17/2725 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99945

摘要： 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.

摘要翻译： 提供了用于管理一个或多个XML数据映射或一个或多个XML模式文件到电子表格应用程序工作簿的应用的方法和系统。 获得用于关联到电子表格工作簿的一个或多个XML模式文件。 迭代每个模式文件以确定在每个获取的模式文件中是否识别到一个或多个附加模式文件。 解析每个获取的模式以确定每个模式文件为有效的XML数据所需的数据定义，元素，属性，结构和简单数据内容。 所有获取的模式文件都被组合以创建统一的模式定义。 选择单个根元素作为广义实例结构的根元素。 构建统一模式定义的通用实例结构，代表可应用于电子表格应用程序工作簿的统一模式定义的所有可用元素，属性或简单数据内容。 显示广义实例结构的树视图，用于提供表示由统一模式定义定义的XML的元素，属性，结构和简单数据内容的统一模式定义的实例结构的可视化表示，可以有效地应用于 电子表格工作簿根据广义实例结构。 写入XML映射对象的指针表示工作簿位置和XML元素之间的关系。

公开(公告)号：US20060004844A1

公开(公告)日：2006-01-05

申请号：US11214222

申请日：2005-08-29

申请人： Chad Rothschiller ,  Kelly Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

发明人： Chad Rothschiller ,  Kelly Lynch ,  Ramakrishnan Natarajan ,  Juha Niemisto ,  Marise Chan ,  Thibaut Vial

IPC分类号： G06F17/00

CPC分类号： G06F17/272 ,  G06F17/2247 ,  G06F17/246 ,  G06F17/2725 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99945

摘要： 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.