公开(公告)号：US20060090129A1

公开(公告)日：2006-04-27

申请号：US11297978

申请日：2005-12-09

申请人： 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/30

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.

公开(公告)号：US20060069993A1

公开(公告)日：2006-03-30

申请号：US10951576

申请日：2004-09-27

申请人： Bruce Jones ,  Chad Rothschiller ,  David Gainer ,  Jeffrey Duzak ,  Matthew Androski

发明人： Bruce Jones ,  Chad Rothschiller ,  David Gainer ,  Jeffrey Duzak ,  Matthew Androski

IPC分类号： G06F17/24

CPC分类号： G06F9/505 ,  G06F17/246

摘要： Embodiments of the invention involve a method of concurrent processing of chain calculations using multiple processors each having a separate recalculation engine in a spreadsheet program. The operations basically include first determining a number of available processors, then allocating a recalculation engine to each available processor, distributing the formulas between the recalculation engines, and then concurrently evaluating the formulas distributed to each recalculation engine when a recalc operation is called for in the spreadsheet program.

公开(公告)号：US07017112B2

公开(公告)日：2006-03-21

申请号：US10377145

申请日：2003-02-28

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

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

IPC分类号： G06F15/00

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

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

摘要翻译： 提供了方法和系统，用于将标记语言格式的数据导入和导出到电子表格文档中。 XML数据与定义用于将XML数据应用于文档的数据类型和数据类型定义的模式文件相关联。 准备了将应用于该文档的任何XML数据返回到模式文件中定义的相应元素或属性的映射。 将文档导入到电子表格应用程序网格中时，将解析该映射以找到XPATH，以确定与模式文件相关的文档中每个单元格或列表对象的位置，数据类型和用户数据。 单元格和列表填充有XML数据和用户数据，并根据应用于文档的XML数据指定的格式进行渲染。 可以导出文档，以便维护XML数据以供以后导入和使用。

公开(公告)号：US08051373B2

公开(公告)日：2011-11-01

申请号：US11326892

申请日：2006-01-06

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

发明人： Chad Rothschiller ,  Michael J. 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。 符合模式的分层数据结构被加载到应用程序中。 数据结构包括在父子关系中链接在一起的元素和属性。 该模式定义了分层数据结构中的元素和属性之间的分层关系。 在已经加载了符合模式的分层数据结构之后，基于模式将多个布局规则应用于分层数据，以创建平面数据结构。 布局规则确定分层数据将如何插入平面数据结构中。 可以通过标识模式中的属性来识别布局规则，以识别模式中定义的元素的出现要求。 在将布局规则应用于层次数据之后，通过以数据行和列的形式插入数据，将分层数据呈现为电子表格。

公开(公告)号：US07770180B2

公开(公告)日：2010-08-03

申请号：US11431931

申请日：2006-05-10

申请人： Shawn Villaron ,  Brian Jones ,  Chad Rothschiller ,  Robert Little ,  Sharad Garg ,  Su-Piao Bill Wu ,  Josh Pollock ,  Andrew Bishop ,  Dan Jump

发明人： Shawn Villaron ,  Brian Jones ,  Chad Rothschiller ,  Robert Little ,  Sharad Garg ,  Su-Piao Bill Wu ,  Josh Pollock ,  Andrew Bishop ,  Dan Jump

IPC分类号： G06F3/00 ,  G06F9/44 ,  G06F9/46 ,  G06F13/00

CPC分类号： G06F9/465 ,  G06F9/541

摘要： A mechanism is provided for embedding an object in a receiving or client document such that a client application may operate on the embedded object to include interrogation and modification of data contained in the embedded object. When a given document object is embedded into a receiving document, data representing the embedded object is saved to a data stream storage for the receiving document. When the embedded object in the receiving document is subsequently requested in response to an operation executed on the embedded object, the receiving application obtains the data representation of the embedded object from the data stream storage. Once the receiving application obtains the data representation of the embedded object, the receiving application may perform operations on the embedded object by accessing the embedded object via its data representation.

摘要翻译： 提供了一种用于将对象嵌入在接收或客户端文档中的机制，使得客户端应用可以对嵌入对象进行操作，以包括对包含在嵌入对象中的数据的询问和修改。 当将给定文档对象嵌入到接收文档中时，表示嵌入对象的数据被保存到接收文档的数据流存储器中。 当响应于对嵌入对象执行的操作而随后请求接收文档中的嵌入对象时，接收应用从数据流存储器获取嵌入对象的数据表示。 一旦接收应用程序获得嵌入对象的数据表示，接收应用程序可以通过其嵌入对象经由其数据表示访问对嵌入对象执行操作。

公开(公告)号：US07752632B2

公开(公告)日：2010-07-06

申请号：US11019095

申请日：2004-12-21

申请人： Shawn Alan Villaron ,  Brian Jones ,  Chad Rothschiller

发明人： Shawn Alan Villaron ,  Brian Jones ,  Chad Rothschiller

IPC分类号： G06F3/00 ,  G06F9/44 ,  G06F9/46 ,  G06F13/00

CPC分类号： G06F17/24

摘要： Methods and systems are provided for exposing nested data in computer-generated documents in a transparent manner. A mechanism is provided for a client application to query a server application for a list of available file formats after an object is requested from a server application document for embedding into a client application document. Another mechanism is provided for the client application to request a particular format associated with the embedded object from the server application document. Once the client application obtains file format information available to the server application or associated with the particular object, the client application may utilize the obtained file formats for utilizing or operating on the embedded object according to the native file formats associated with the embedded object.

摘要翻译： 提供了以透明的方式将计算机生成的文档中的嵌套数据暴露的方法和系统。 提供了一种机制，用于客户端应用程序在从服务器应用程序文档请求对象以嵌入客户端应用程序文档之后，向服务器应用程序查询可用文件格式的列表。 提供了另一种机制，用于客户端应用程序从服务器应用程序文档请求与嵌入对象相关联的特定格式。 一旦客户端应用程序获得可用于服务器应用程序或与特定对象相关联的文件格式信息，客户端应用程序可以根据与嵌入对象相关联的本机文件格式利用所获得的文件格式来利用或操作嵌入对象。

公开(公告)号：US07640493B2

公开(公告)日：2009-12-29

申请号：US11337942

申请日：2006-01-23

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

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

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

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

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

摘要翻译： 可扩展标记语言（例如XML）中的可扩展标记语言数据与用于定义用于将数据应用于文档的数据类型和数据类型定义的模式文件相关联。 准备了将应用于文档的任何可扩展标记数据返回到相关模式文件中定义的相应元素或属性的映射。 当文档导入到电子表格应用程序网格中时，将解析数据映射以查找XPATH，以确定与模式文件相关的文档中每个单元格或列表对象的位置，数据类型和用户数据。 单元格和列表填充有可扩展标记数据和用户数据，并根据应用于文档的可扩展标记数据指定的格式呈现。 可以导出文档，以便维护可扩展标记数据以供以后导入和使用。

公开(公告)号：US07464330B2

公开(公告)日：2008-12-09

申请号：US11018405

申请日：2004-12-20

申请人： Andrew Bishop ,  Brian Jones ,  Chad Rothschiller ,  Robert Little ,  Shawn Alan Villaron ,  Charles S. Walker

发明人： Andrew Bishop ,  Brian Jones ,  Chad Rothschiller ,  Robert Little ,  Shawn Alan Villaron ,  Charles S. Walker

IPC分类号： G06F17/00

CPC分类号： G06F17/2247 ,  G06F9/543 ,  G06F17/211 ,  G06F17/2229

摘要： Self-describing portions of text or data are provided for associating with or inserting in a computer-generated document. Portions of a document, such as individual paragraphs or groups of paragraphs or fragments of text, are provided self-describing properties, such as file format type associated with the portion, style, font, list type, and the like. If such a portion of a document is subsequently linked to or copied or moved to a second document or to a different location in a first document, the self-describing properties provided for the portion travel with the portion to the second document or to the different location in the first document. An application receiving the content portion may consume and display the portion according to the properties provided for the portion.

摘要翻译： 文本或数据的自描述部分被提供用于与计算机生成的文档相关联或插入到计算机生成的文档中。 提供文档的一些部分，例如单个段落或段落组或文本片段，提供了自描述属性，例如与部分，样式，字体，列表类型等相关联的文件格式类型。 如果文档的这种部分随后被链接到或复制或移动到第二文档或第一文档中的不同位置，则为部分行进提供的自描述属性与第二文档的部分或不同的 位置在第一个文件。 接收内容部分的应用可以根据为该部分提供的属性消耗并显示该部分。

公开(公告)号：US20060271574A1

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

申请号：US11431931

申请日：2006-05-10

申请人： Shawn Villaron ,  Brian Jones ,  Chad Rothschiller ,  Robert Little ,  Sharad Garg ,  Su-Piao Wu ,  Josh Pollock ,  Andrew Bishop ,  Dan Jump

发明人： Shawn Villaron ,  Brian Jones ,  Chad Rothschiller ,  Robert Little ,  Sharad Garg ,  Su-Piao Wu ,  Josh Pollock ,  Andrew Bishop ,  Dan Jump

IPC分类号： G06F7/00

CPC分类号： G06F9/465 ,  G06F9/541

摘要： A mechanism is provided for embedding an object in a receiving or client document such that a client application may operate on the embedded object to include interrogation and modification of data contained in the embedded object. When a given document object is embedded into a receiving document, data representing the embedded object is saved to a data stream storage for the receiving document. When the embedded object in the receiving document is subsequently requested in response to an operation executed on the embedded object, the receiving application obtains the data representation of the embedded object from the data stream storage. Once the receiving application obtains the data representation of the embedded object, the receiving application may perform operations on the embedded object by accessing the embedded object via its data representation.

摘要翻译： 提供了一种用于将对象嵌入在接收或客户端文档中的机制，使得客户端应用可以对嵌入对象进行操作，以包括对包含在嵌入对象中的数据的询问和修改。 当将给定文档对象嵌入到接收文档中时，表示嵌入对象的数据被保存到接收文档的数据流存储器中。 当响应于对嵌入对象执行的操作而随后请求接收文档中的嵌入对象时，接收应用从数据流存储器获取嵌入对象的数据表示。 一旦接收应用程序获得嵌入对象的数据表示，接收应用程序可以通过其嵌入对象经由其数据表示访问对嵌入对象执行操作。

公开(公告)号：US20060112329A1

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

申请号：US11328042

申请日：2006-01-09

申请人： 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

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.