Method and system in an electronic spreadsheet for handling user-defined options in a copy/cut-paste operation
    1.
    发明公开
    Method and system in an electronic spreadsheet for handling user-defined options in a copy/cut-paste operation 有权
    在被剪切 - 复制 - 粘贴功能处理用户定义的选项的电子表格的方法和系统

    公开(公告)号:EP1172751A1

    公开(公告)日:2002-01-16

    申请号:EP01480035.3

    申请日:2001-05-10

    IPC分类号: G06F17/60

    CPC分类号: G06F17/246

    摘要: The present invention relates to the field of information processing by digital computers, and more particularly to a method and system, in an electronic spreadsheet, for handling user-defined options during a copy/cut - paste operation when the source range of cells comprises one or a plurality of cells with user-defined options and when the destination environment does not necessarily defines the same user-defined options as the ones defined in the source environment. The method of handling user-defined options during a copy and paste or a cut and paste operation comprises the steps of:

    defining one or a plurality of combinations, each combination comprising one or a plurality of options;
    defining a source cell range and a destination cell range;
    defining an operation to execute, either copy and paste, or cut and paste;
    for each defined option combination comprising one or a plurality of options, if at least one cell in the source cell range comprises a reference to said one or plurality of options,

    computing the content of each cell within the source cell range according to said one or plurality of options;
    creating a version instance of the destination cell range;
    copying the source range of cells into said version instance.
    when the last option combination is copied,

    clearing the source cell range if the operation is cut and paste.

    摘要翻译: 本发明通过数字计算机涉及信息处理领域,并且更具体地涉及一种方法和系统,在电子表格,对于一个复制/剪切期间处理用户定义的选项 - 粘贴操作。当细胞的来源范围包括一个 或与用户定义的选项细胞的多元化,并且当目标环境不一定定义相同的用户定义的选项,在源环境中定义的值。 的拷贝期间处理用户定义的选项和粘贴或剪切和粘贴操作的方法,包括以下步骤: - 定义一个或组合,每个组合包括一个或选项的多个A多元性; - 定义源小区范围和目的地小区范围; 上限定的操作来执行,无论是复制和粘贴,或剪切并粘贴; 为每个定义的选项组合包含一种或选项复数,如果在源小区范围内的至少一个小区包括向所述一个或选项多个参考,每个单元的源极小区范围雅丁内的内容计算所述一个或 选项多个; 创建目的地小区范围的版本实例; 复制细胞进入所述版本实例的源范围。 当负载选项组合被复制,清除所述源小区范围,如果手术剪切和粘贴。