专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20060112329A1 Importing and exporting markup language data in a spreadsheet application document 失效
公开(公告)号：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.

2. 发明申请

US20060190814A1 Importing and exporting markup language data in a spreadsheet application document 失效
公开(公告)号：US20060190814A1
公开(公告)日：2006-08-24
申请号：US11337942
申请日：2006-01-23
申请人： 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.

3. 发明申请

US20060090129A1 Importing and exporting markup language data in a spreadsheet application document 有权
公开(公告)号：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.

4. 发明申请

US20070061751A1 Integrating charts in documents 有权
标题翻译：在图表中集成图表
公开(公告)号：US20070061751A1
公开(公告)日：2007-03-15
申请号：US11227044
申请日：2005-09-15
申请人： Daniel Cory , Kelly Lynch
发明人： Daniel Cory , Kelly Lynch
IPC分类号： G06T11/20
CPC分类号： G06F9/543 , G06Q10/10
摘要： A chart is presented in a host application. The chart is managed by communicating data corresponding to the chart to a separate application and providing functionality for editing the data in the separate application. The presentation of the data in the separate application is distinct from the presentation of the chart in the host application. Changes to the data are communicated the host application when the data is edited in the separate application. The communicated changes to the data are reflected in the presentation of the chart in the host application.
摘要翻译：主机应用程序中显示了一个图表。该图表通过将对应于图表的数据传达给单独的应用程序进行管理，并提供用于在单独应用程序中编辑数据的功能。在单独应用程序中显示数据与主机应用程序中图表的显示不同。在单独应用程序中编辑数据时，对主机应用程序进行的数据传送。所传达的数据更改反映在主机应用程序中的图表显示。

5. 发明申请

US20060101333A1 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：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数据被维护以供随后导入，使用文件。

6. 发明申请

US20060004844A1 Management of markup language data mappings available to a spreadsheet application workbook 有权
公开(公告)号：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.

7. 发明申请

US20060117250A1 Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet 有权
标题翻译：用于从电子表格中使用的分层数据结构推断模式的方法和系统
公开(公告)号：US20060117250A1
公开(公告)日：2006-06-01
申请号：US11326853
申请日：2006-01-06
申请人： Chad Rothschiller , Michael McCormack , Eoin Burke , Kelly Lynch , Roy Dumas
发明人： Chad Rothschiller , Michael McCormack , Eoin Burke , Kelly Lynch , Roy Dumas
IPC分类号： G06F17/00 , G06F15/00
CPC分类号： G06F17/30914
摘要： A method and system are provided for inferring a schema from an electronic document containing hierarchical data for use in a spreadsheet application program. The electronic document containing the hierarchical data is received into an application program. The application program may be a spreadsheet application program. The format of the hierarchical data structure may be XML. The hierarchical data includes a set of nodes making up the structure of the hierarchical data. The nodes may be XML elements and attributes. The hierarchical data is then parsed to discover one of the nodes in the hierarchical data. Once the node has been discovered, content associated with the discovered node is saved to a memory location in the computer system. The content may include data associated with the discovered node and the type of data associated with the node. The hierarchical data is then parsed again to discover subsequent nodes until the content for all of the nodes has been saved to the memory location. Then a schema generator generates schema elements using complex rules based on the particular qualities of each discovered node for each discovered node until a schema is generated for the hierarchical data.
摘要翻译：提供了一种方法和系统，用于从包含用于电子表格应用程序的分层数据的电子文档推断模式。包含分层数据的电子文档被接收到应用程序中。应用程序可以是电子表格应用程序。层次数据结构的格式可以是XML。分层数据包括组成分层数据结构的一组节点。节点可以是XML元素和属性。然后分析分层数据以发现分层数据中的一个节点。一旦节点被发现，与发现的节点相关联的内容被保存到计算机系统中的存储器位置。内容可以包括与所发现的节点相关联的数据和与节点相关联的数据的类型。然后再次分析分层数据以发现后续节点，直到所有节点的内容已经保存到存储器位置。然后，模式生成器根据每个发现节点的每个发现节点的特定质量，使用复杂规则生成模式元素，直到为分层数据生成模式。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式