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

1. 发明授权

US07703007B2 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07703007B2
公开(公告)日：2010-04-20
申请号：US11318688
申请日：2005-12-27
申请人： 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分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： 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.
摘要翻译：以分层格式呈现的数据以允许将数据导入到可以修改数据并可以添加新数据的电子表格文档的形式呈现。选择包含分层格式化数据的数据文件进行导入。访问将分层数据中的多个元素与电子表格文档中的多个相应位置相关联的映射。分层数据根据映射在电子表格文档中呈现。接收到输入以修改电子表格文档中呈现的分层数据。更新映射以包括对分层数据的修改。根据更新的映射，导出对分层数据和更新的映射的修改以在第二电子表格文档中进行后续呈现。

2. 发明授权

US07249316B2 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07249316B2
公开(公告)日：2007-07-24
申请号：US11328042
申请日：2006-01-09
申请人： 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
摘要： 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.
摘要翻译：提供了方法和系统，用于将标记语言格式的数据导入到电子表格文档中，并从电子表格文档导出标记语言格式的数据。 XML数据与定义用于将XML数据应用于文档的XML数据类型和数据类型定义的XML模式文件相关联。准备XML数据映射，将应用于文档的任何XML数据与相关模式文件中定义的相应XML元素或属性相关联。将文档导入电子表格应用程序网格时，将解析数据映射，以在导入的XML数据的电子表格文档中查找XPATH，并输入用户的数据。在导入的文档被编辑之后，可以导出文档，使得应用于文档的XML数据被维护以便随后导入和使用该文档。

3. 发明授权

US07954046B2 Importing and exporting markup language data in a spreadsheet application document 有权
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07954046B2
公开(公告)日：2011-05-31
申请号：US11297978
申请日：2005-12-09
申请人： 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分类号： G06F3/00 , G06F17/30
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： 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.
摘要翻译： XML数据与定义用于将XML数据应用于文档的XML数据类型和数据类型定义的XML模式文件相关联。准备XML数据映射，将应用于该文档的任何XML数据与相关模式文件中定义的相应XML元素或属性相关联。将文档导入电子表格应用程序网格时，将解析数据映射，以在导入的XML数据的电子表格文档中查找XPATH，并输入用户的数据。在导入的文档被编辑之后，或在创建文档以包括与所选XML模式文件相关联的XML数据的应用程序之后，可以导出该文档，使得应用于该文档的XML数据被维护以供随后导入，使用文件。

4. 发明授权

US07640493B2 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：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，以确定与模式文件相关的文档中每个单元格或列表对象的位置，数据类型和用户数据。单元格和列表填充有可扩展标记数据和用户数据，并根据应用于文档的可扩展标记数据指定的格式呈现。可以导出文档，以便维护可扩展标记数据以供以后导入和使用。

5. 发明申请

US20070074130A1 Automated placement of fields in a data summary table 有权
标题翻译：在数据摘要表中自动放置字段
公开(公告)号：US20070074130A1
公开(公告)日：2007-03-29
申请号：US11222660
申请日：2005-09-09
申请人： Allan Folting , Konrad Tupaj , Robert Collie , Anatoly Grabar
发明人： Allan Folting , Konrad Tupaj , Robert Collie , Anatoly Grabar
IPC分类号： G06F17/00 , G06F15/00 , G06F7/00
CPC分类号： G06F17/246 , Y10S707/99943
摘要： A graphical user interface for creating a data summary table includes a pane including a plurality of fields, and a data summary table. Upon selection of a field to include in the data summary table, the user interface is programmed to analyze the field and automatically place the field in the data summary table.
摘要翻译：用于创建数据摘要表的图形用户界面包括包括多个字段的窗格和数据摘要表。在选择要包括在数据摘要表中的字段时，将用户界面编程为分析该字段并将该字段自动放置在数据汇总表中。

6. 发明申请

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.

7. 发明申请

US20060075328A1 Design of spreadsheet functions for working with tables of data 有权
标题翻译：设计用于处理数据表的电子表格功能
公开(公告)号：US20060075328A1
公开(公告)日：2006-04-06
申请号：US10957502
申请日：2004-09-30
申请人： Andrew Becker , Charles Ellis , Joseph Chirilov , Juha Niemisto , Matthew Androski , Robert Collie , Robert Hawking , Simon Peyton-Jones
发明人： Andrew Becker , Charles Ellis , Joseph Chirilov , Juha Niemisto , Matthew Androski , Robert Collie , Robert Hawking , Simon Peyton-Jones
IPC分类号： G06F17/24 , G06F7/00 , G06F17/30
CPC分类号： G06F17/246 , Y10S707/99942
摘要： The present invention provides several database formulas that can manipulate large sets of data. Each database formula is customizable and repeatable without user intervention. Thus, users may enter numerous options that can cover the user's desire for data output in certain forms or formats, select a set of input data, and consistently receive a set of output data. In some embodiments, the user may refer to the set of data semantically instead of specifying a range of cells to use in the database formula. Referring to the data semantically allows the database formulas to adjust to changes in the range of cells new data may occupy.
摘要翻译：本发明提供了可以操纵大量数据的几种数据库公式。每个数据库公式是可自定义和可重复的，无需用户干预。因此，用户可以输入许多选项，其可以覆盖用户对某些形式或格式的数据输出的期望，选择一组输入数据，并且一致地接收一组输出数据。在一些实施例中，用户可以在语义上引用该组数据，而不是指定要在数据库公式中使用的单元格的范围。参考数据语义上允许数据库公式适应新数据可能占用的单元格范围内的变化。

8. 发明申请

US20070174228A1 Graphical representation of key performance indicators 审中-公开
标题翻译：关键绩效指标的图形表示
公开(公告)号：US20070174228A1
公开(公告)日：2007-07-26
申请号：US11333895
申请日：2006-01-17
申请人： Allan Folting , Amir Netz , Konrad Tupaj , Robert Collie
发明人： Allan Folting , Amir Netz , Konrad Tupaj , Robert Collie
IPC分类号： G06F17/30
CPC分类号： G06F16/2423
摘要： According to one aspect, key performance indicators and the accompanying key performance indicator elements may be displayed in a task pane to enable a user to select one or more the key performance indicator elements for use in generating a data summary table. In one example, the key performance indicators of a dataset are identified, and each of the associated key performance indicator elements associated with that key performance indicator is also identified. A key performance indicator may be obtained from any source, including the dataset to which it pertains. Additionally, a name of the identified key performance indicator is determined. The determined name and each of the identified key performance indicator elements are displayed in an organized manner as to enable a user easy selection of the key performance indicator and/or the key performance indicator elements.
摘要翻译：根据一个方面，可以在任务窗格中显示关键性能指示符和伴随的关键性能指标元素，以使用户能够选择用于生成数据摘要表的一个或多个关键性能指标元素。在一个示例中，识别数据集的关键性能指标，并且还识别与该关键性能指标相关联的每个相关联的关键性能指标元素。可以从任何来源（包括其所属的数据集）获得关键绩效指标。另外，确定所识别的关键性能指标的名称。所确定的名称和每个所识别的关键性能指标元素以有组织的方式显示，以使得用户能够容易地选择关键性能指示符和/或关键性能指标元素。

9. 发明申请

US20070050322A1 Associating conditions to summary table data 有权
标题翻译：将条件与汇总表数据相关联
公开(公告)号：US20070050322A1
公开(公告)日：2007-03-01
申请号：US11215634
申请日：2005-08-29
申请人： Eric Vigesaa , Allan Folting , Bruce Jones , Robert Collie
发明人： Eric Vigesaa , Allan Folting , Bruce Jones , Robert Collie
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06F3/04842 , G06F17/211 , G06F17/30489 , G06F17/30504
摘要： A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.
摘要翻译：方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。在一个实施例中，基于摘要表中当前突出显示的单元确定相关的数据组。然后，用户从组中选择并识别与指定数据点相关联的条件格式。条件格式与摘要表中的当前显示以及未显示的数据相关联。相关条件相对于数据点而不是原始单元位置被保存，使得条件在重组汇总表之后保持与数据点相关联。

10. 发明授权

US07096422B2 Markup language visual mapping 失效
标题翻译：标记语言视觉映射
公开(公告)号：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模式文件中的属性的一般映射。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式