Creating and managing structured data in an electronic spreadsheet
    4.
    发明授权
    Creating and managing structured data in an electronic spreadsheet 有权
    在电子电子表格中创建和管理结构化数据

    公开(公告)号:US07127672B1

    公开(公告)日:2006-10-24

    申请号:US10646131

    申请日:2003-08-22

    IPC分类号: G06N3/00

    CPC分类号: G06F17/246 G06F17/2725

    摘要: An electronic spreadsheet is provided for automatically creating, expanding, and validating lists of cells. A list is created by receiving a user request for selecting a cell range, identifying a list range for the selected cell range, determining a header row for the list range, and generating a border for surrounding the list range. A list is expanded by determining that one or more cells are adjacent to the list and automatically expanding the list to include the new cells. A list is validated by determining a data type of data entered into the list and comparing the data type of the data entered into the list to a list data type. If, as a result of the comparison, the data type of the data entered into the list does not match the list data type, then the data type of the data entered into the list is invalid.

    摘要翻译: 提供电子电子表格,用于自动创建,扩展和验证单元格列表。 通过接收用于选择单元格范围的用户请求,识别所选单元格范围的列表范围,确定列表范围的标题行,以及生成围绕列表范围的边框来创建列表。 通过确定一个或多个单元格与列表相邻并自动扩展列表以包括新单元格来扩展列表。 通过确定输入到列表中的数据的数据类型并将输入到列表中的数据的数据类型与列表数据类型进行比较来验证列表。 如果作为比较的结果,输入到列表中的数据的数据类型与列表数据类型不匹配,则输入到列表中的数据的数据类型是无效的。

    Exposing embedded data in a computer-generated document
    5.
    发明授权
    Exposing embedded data in a computer-generated document 有权
    将嵌入式数据暴露在计算机生成的文档中

    公开(公告)号:US07770180B2

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

    申请号:US11431931

    申请日:2006-05-10

    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.

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

    Data source write back and offline data editing and storage in a spreadsheet
    6.
    发明授权
    Data source write back and offline data editing and storage in a spreadsheet 有权
    数据源在电子表格中回写和离线数据编辑和存储

    公开(公告)号:US07225189B1

    公开(公告)日:2007-05-29

    申请号:US10782074

    申请日:2004-02-19

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/246

    摘要: Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user's data changes and other data changes made to the same source data contained in the database data source.

    摘要翻译: 方法和系统提供电子表格应用程序工作表和数据库数据源之间的双向通信,该数据库数据源允许从电子表格应用程序写入修改的数据,以便从中获取原始预修改数据的数据库数据源中的源数据。 电子表格应用程序中的脱机数据更改由数据提供程序应用程序缓存,并在电子表格应用程序与数据源同步时发布到远程数据源。 从电子表格应用程序工作表发布到数据库数据源的新的或修改后的数据导致的错误条件和数据冲突将通过数据提供程序应用程序向用户提供电子表格应用程序工作表,以允许用户解决错误条件和数据冲突 在用户的数据更改和对数据库数据源中包含的相同源数据进行的其他数据更改之间。