Structuring data for spreadsheet documents
    1.
    发明申请
    Structuring data for spreadsheet documents 审中-公开
    构建电子表格文档的数据

    公开(公告)号:US20070022128A1

    公开(公告)日:2007-01-25

    申请号:US11389367

    申请日:2006-03-24

    IPC分类号: G06F7/00

    CPC分类号: G06F17/246

    摘要: An open file format is used to represent the features and data associated with a spreadsheet application within a document. The file format simplifies the way a spreadsheet application organizes document features and data, and presents a logical model that is easily accessible. The file format is made up of a collection of modular parts that are stored within a container. The modular parts are logically separate but are associated with one another by one or more relationships. Each of the modular parts is capable of being interrogated separately regardless of whether or not the application that created the document is running. Each modular part is capable of having information extracted from it and copied into another document and reused. Information may also be changed, added, and deleted from each of the modular parts.

    摘要翻译: 打开的文件格式用于表示与文档中的电子表格应用程序相关联的功能和数据。 文件格式简化了电子表格应用程序组织文档特征和数据的方式,并呈现了易于访问的逻辑模型。 文件格式由存储在容器中的模块化部件的集合组成。 模块化部件在逻辑上是分开的,但是通过一个或多个关系彼此相关联。 无论创建文档的应用程序是否正在运行,每个模块化部件都可以单独进行询问。 每个模块部分都能够从中提取信息并复制到另一个文档中并被重用。 信息也可以从每个模块化部件更改,添加和删除。

    Method and computer-readable medium for verifying and saving an electronic document
    3.
    发明申请
    Method and computer-readable medium for verifying and saving an electronic document 有权
    用于验证和保存电子文档的方法和计算机可读介质

    公开(公告)号:US20060143542A1

    公开(公告)日:2006-06-29

    申请号:US11018916

    申请日:2004-12-20

    IPC分类号: G06F11/00

    CPC分类号: G06F11/1402 Y10S707/99943

    摘要: A method and computer-readable medium are provided for saving the contents of a memory structure stored in a volatile memory. According to the method, corrupted portions of the memory structure are identified and an attempt is made to repair these portions. If the corrupted portions cannot be repaired, the saving of these portions is skipped. The uncorrupted and repaired portions of the memory structure are then saved to a data file stored on a mass storage device. If portions of the memory structure cannot be repaired or skipped, an attempt is made to save only the user data contained in the memory structure to the data file. In this manner, the user data contained in the memory structure may be saved to a data file even in cases of severe corruption.

    摘要翻译: 提供了一种用于保存存储在易失性存储器中的存储结构的内容的方法和计算机可读介质。 根据该方法,识别存储器结构的损坏部分,并尝试修复这些部分。 如果损坏部分无法修复,则省略这些部分。 然后将存储器结构的未损坏和修复的部分保存到存储在大容量存储设备上的数据文件。 如果存储器结构的部分不能被修复或跳过,则尝试仅将包含在存储器结构中的用户数据保存到数据文件。 以这种方式,即使在严重腐败的情况下,包含在存储器结构中的用户数据也可以被保存到数据文件。

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

    公开(公告)号:US20060271574A1

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

    申请号:US11431931

    申请日:2006-05-10

    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.

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

    File formats, methods, and computer program products for representing workbooks

    公开(公告)号:US20060136433A1

    公开(公告)日:2006-06-22

    申请号:US11018912

    申请日:2004-12-20

    IPC分类号: G06F7/00 G06F17/24

    CPC分类号: G06F17/246 G06F17/2247

    摘要: File formats, methods, and computer program products are provided for representing a workbook in a modular content framework. The modular content framework may include a file format container associated with modular parts. A file format includes logically separate modular parts that are associated with each other by one or more relationships where each modular part is associated with a relationship type. The modular parts include a workbook part operative as a guide for properties of the workbook and a worksheet part associated with the workbook part and operative to specify a definition of cells within a worksheet associated with the worksheet part. The modular parts may also include a document properties part containing built-in properties associated with the file format and a thumbnail part containing associated thumbnails. Each modular part is capable of being interrogated separately, extracted from the workbook, and/or reused in a different workbook.

    Method and computer-readable medium for loading the contents of a data file
    6.
    发明申请
    Method and computer-readable medium for loading the contents of a data file 有权
    用于加载数据文件内容的方法和计算机可读介质

    公开(公告)号:US20060136476A1

    公开(公告)日:2006-06-22

    申请号:US11018914

    申请日:2004-12-20

    IPC分类号: G06F17/00

    摘要: A method and computer-readable medium are provided for loading the contents of an electronic data file. According to the method, corrupted portions of a data file are identified and an attempt is made to repair these portions. If the corrupted portions cannot be repaired, the loading of these portions is skipped. The uncorrupted and repaired portions of the data file are then loaded into memory. If portions of the data file cannot be repaired or skipped, an attempt is made to load only the user data contained in the data file. In this manner, the user data contained in the data file may be loaded even in cases of severe corruption.

    摘要翻译: 提供了一种用于加载电子数据文件的内容的方法和计算机可读介质。 根据该方法,识别数据文件的损坏部分,并尝试修复这些部分。 如果损坏的部分无法修复,则会跳过这些部分的装载。 然后将数据文件的未损坏和修复的部分加载到内存中。 如果数据文件的部分不能被修复或跳过,则尝试只加载包含在数据文件中的用户数据。 以这种方式,即使在严重腐败的情况下,也可以加载包含在数据文件中的用户数据。

    Multi-Threaded Sort of Data Items in Spreadsheet Tables
    7.
    发明申请
    Multi-Threaded Sort of Data Items in Spreadsheet Tables 审中-公开
    电子表格中多线程数据项的分类

    公开(公告)号:US20110264993A1

    公开(公告)日:2011-10-27

    申请号:US12766629

    申请日:2010-04-23

    IPC分类号: G06F17/00 G06F9/46

    摘要: To perform a sort operation on a spreadsheet table, data items in the spreadsheet table are divided into a plurality of blocks. Multiple threads are then used to sort the data items in the blocks. After the data items in the blocks are sorted, multiple threads are used to merge the blocks into a final block. The final block contains each of the data items in the spreadsheet table. A sorted version of the spreadsheet table is then displayed. Data items in the sorted version of the spreadsheet table have the same order as an order of data items in the final block.

    摘要翻译: 为了在电子表格表上执行分类操作,电子表格表中的数据项被分成多个块。 然后使用多个线程对块中的数据项进行排序。 在块中的数据项被排序之后,使用多个线程将块合并到最终块中。 最后一个块包含电子表格表中的每个数据项。 然后显示电子表格表的排序版本。 电子表格表的排序版本中的数据项与最终块中数据项的顺序具有相同的顺序。

    CONFIDENT ITEM SELECTION USING DIRECT MANIPULATION
    8.
    发明申请
    CONFIDENT ITEM SELECTION USING DIRECT MANIPULATION 审中-公开
    使用直接操作进行信任项目选择

    公开(公告)号:US20130191785A1

    公开(公告)日:2013-07-25

    申请号:US13356502

    申请日:2012-01-23

    IPC分类号: G06F3/048 G06F3/041

    摘要: A user interface element and a visual indicator are displayed to show both a current selected area that tracks a user's touch input and an indication of any items that are considered to be selected (the potential selection). The user interface element (e.g. a border) is displayed whose size may be adjusted by a user using touch input to select more/fewer items. An item visual indicator is displayed for items that are considered to be a potential selection (e.g. items that would be selected if the touch input were to end at the current time). The item visual indicator is configured to show the user an indication of currently selected items without the border appearing to jump in response to another item being selected/deselected. The item visual indicator helps to avoid the need for a user to re-adjust the selection or get unexpected results.

    摘要翻译: 显示用户界面元素和视觉指示符以示出跟踪用户的触摸输入的当前选择的区域和被认为被选择的任何项目的指示(潜在选择)。 显示用户界面元素(例如边框),其尺寸可以由用户使用触摸输入来调整以选择更多/更少的项目。 对于被认为是潜在选择的项目(例如,如果触摸输入在当前时间结束时将被选择的项目),则显示项目视觉指示符。 项目视觉指示器被配置为向用户显示当前选择的项目的指示,而不显示边框,以响应于另一项目被选择/取消选择而跳跃。 项目视觉指示器有助于避免用户重新调整选择或获得意想不到的结果。

    Multi-Threaded Adjustment of Column Widths or Row Heights
    9.
    发明申请
    Multi-Threaded Adjustment of Column Widths or Row Heights 审中-公开
    列宽或行高的多线程调整

    公开(公告)号:US20110276868A1

    公开(公告)日:2011-11-10

    申请号:US12774035

    申请日:2010-05-05

    IPC分类号: G06F17/00

    CPC分类号: G06F17/211 G06F17/246

    摘要: A computing system performs a column adjustment process. The column adjustment process uses multiple threads to determine overall maximum column widths for each column in a set of target columns in a spreadsheet table. For each of the target columns, the overall maximum column width for the target column is based on the width of the widest textual representation of a value in any cell in the column. The set of target columns includes at least one column. The computing system then reflows the spreadsheet table such that each column in the set of target columns has a width based on the overall maximum column width for the column. A similar process is performed to adjust the height of rows.

    摘要翻译: 计算系统执行列调整过程。 列调整过程使用多个线程来确定电子表格表中一组目标列中每列的总体最大列宽。 对于每个目标列,目标列的总体最大列宽基于列中任何单元格中最宽的文本表示的宽度。 目标列集合至少包含一列。 计算系统然后重新打开电子表格表,使得目标列集合中的每个列都具有基于列的总体最大列宽度的宽度。 执行类似的过程来调整行的高度。