公开(公告)号：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数据以供以后导入和使用。

公开(公告)号：US20120180002A1

公开(公告)日：2012-07-12

申请号：US12986473

申请日：2011-01-07

申请人： John Campbell ,  Amy Lin ,  Lawrence Waldman ,  Sherman Der ,  Karen Cheng ,  Christopher Doan ,  Thomas Constantine ,  Chad Rothschiller ,  Yun Ma

发明人： John Campbell ,  Amy Lin ,  Lawrence Waldman ,  Sherman Der ,  Karen Cheng ,  Christopher Doan ,  Thomas Constantine ,  Chad Rothschiller ,  Yun Ma

IPC分类号： G06F3/033

CPC分类号： G06F3/04883 ,  G06F3/0346 ,  G06F3/04845 ,  G06F3/0485 ,  G06F17/246 ,  G06F2200/1614 ,  G06F2203/04806 ,  G06F2203/04808

摘要： Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

摘要翻译： 不同的手势和动作用于与电子表格进行交互。 手势用于操纵电子表格并在电子表格中执行其他操作。 例如，手势可以用于在电子表格中移动，选择数据，过滤，排序，向下/向上，缩放，拆分行/列，执行撤消/重做动作等。 与设备相关联的传感器也可用于与电子表格进行交互。 例如，加速度计可用于在电子表格内移动和执行操作。

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

公开(公告)号：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，以确定与模式文件相关的文档中每个单元格或列表对象的位置，数据类型和用户数据。 单元格和列表填充有可扩展标记数据和用户数据，并根据应用于文档的可扩展标记数据指定的格式呈现。 可以导出文档，以便维护可扩展标记数据以供以后导入和使用。

公开(公告)号：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.

公开(公告)号：US10409892B2

公开(公告)日：2019-09-10

申请号：US13014520

申请日：2011-01-26

申请人： Chad Rothschiller ,  Daniel Battagin ,  Christopher Benedict ,  Rodrigo Moreira-Silveira ,  Dmitri O. Danilov ,  Eric Cohen ,  Sumit Gulwani ,  Dany Rouhana ,  Rishabh Singh ,  Benjamin Goth Zorn ,  Ramarathnam Venkatesan

发明人： Chad Rothschiller ,  Daniel Battagin ,  Christopher Benedict ,  Rodrigo Moreira-Silveira ,  Dmitri O. Danilov ,  Eric Cohen ,  Sumit Gulwani ,  Dany Rouhana ,  Rishabh Singh ,  Benjamin Goth Zorn ,  Ramarathnam Venkatesan

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

摘要： Data formatting rules to convert data from one form to another form are automatically determined based on a user's edits. A machine learning heuristic is applied to a user's edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use.

公开(公告)号：US09747270B2

公开(公告)日：2017-08-29

申请号：US12986473

申请日：2011-01-07

申请人： John Campbell ,  Amy Lin ,  Lawrence Waldman ,  Sherman Der ,  Karen Cheng ,  Christopher Doan ,  Thomas Constantine ,  Chad Rothschiller ,  Yun Ma

发明人： John Campbell ,  Amy Lin ,  Lawrence Waldman ,  Sherman Der ,  Karen Cheng ,  Christopher Doan ,  Thomas Constantine ,  Chad Rothschiller ,  Yun Ma

IPC分类号： G06F3/033 ,  G06F17/24 ,  G06F3/0488

CPC分类号： G06F3/04883 ,  G06F3/0346 ,  G06F3/04845 ,  G06F3/0485 ,  G06F17/246 ,  G06F2200/1614 ,  G06F2203/04806 ,  G06F2203/04808

摘要： Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

公开(公告)号：US20120192051A1

公开(公告)日：2012-07-26

申请号：US13014520

申请日：2011-01-26

申请人： Chad Rothschiller ,  Daniel Battagin ,  Christopher Benedict ,  Rodrigo Moreira-Silveira ,  Dmitri O. Danilov ,  Eric Cohen ,  Sumit Gulwani ,  Dany Rouhana ,  Rishabh Singh ,  Benjamin Goth Zorn ,  Ramarathnam Venkatesan

发明人： Chad Rothschiller ,  Daniel Battagin ,  Christopher Benedict ,  Rodrigo Moreira-Silveira ,  Dmitri O. Danilov ,  Eric Cohen ,  Sumit Gulwani ,  Dany Rouhana ,  Rishabh Singh ,  Benjamin Goth Zorn ,  Ramarathnam Venkatesan

IPC分类号： G06F17/00

CPC分类号： G06F17/211

摘要： Data formatting rules to convert data from one form to another form are automatically determined based on a user's edits. A machine learning heuristic is applied to a user's edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use.

摘要翻译： 根据用户的编辑自动确定将数据从一个表单转换为另一个表单的数据格式化规则。 机器学习启发式应用于用户的编辑以确定可应用于数据的数据格式化规则。 例如，用户可以进行从数据添加/移除字符，连接数据，提取数据，重命名数据等的编辑。 可以响应于事件（例如在对相同类型的数据进行预定数量的编辑）或手动触发（例如，选择用户界面选项）之后，可以自动地触发机器学习启发式。 数据格式规则可以应用于其他数据以及用户可评估的格式的结果。 根据进一步的编辑/评论，可能会更新数据格式规则。 可以存储数据格式化规则供以后使用。

公开(公告)号：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.

摘要翻译： 以分层格式呈现的数据以允许将数据导入到可以修改数据并可以添加新数据的电子表格文档的形式呈现。 选择包含分层格式化数据的数据文件进行导入。 访问将分层数据中的多个元素与电子表格文档中的多个相应位置相关联的映射。 分层数据根据映射在电子表格文档中呈现。 接收到输入以修改电子表格文档中呈现的分层数据。 更新映射以包括对分层数据的修改。 根据更新的映射，导出对分层数据和更新的映射的修改以在第二电子表格文档中进行后续呈现。

公开(公告)号：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数据被维护以便随后导入和使用该文档。