公开(公告)号：WO2004092976A3

公开(公告)日：2005-08-18

申请号：PCT/EP2004003035

申请日：2004-02-27

Applicant: IBM ,  CIE IBM FRAMCE ,  AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

CPC classification number: G06F17/246

Abstract: The present invention is directed to a method, system and program for exporting, from a source electronic data table comprising a plurality of objects having parent-child relationships to a destination electronic data table, one or several of objects with their filiation. The method for use in a computer comprises the steps of : defining objects and associating with each object one or a plurality of parent objects or one or a plurality of child objects or both; associating with each object a unique object reference (OR) equal to a prime number; determining for each object whether said object is associated with at least a child object or not : if said object is not associated with at least one child object, defining a filiation reference (FR) equal to 1; if said object is associated with at least one child object, defining a filiation reference (FR) equal to the product of two terms : a first term, equal to the product of each object reference (OR) associated with each child object of said object: a second term equal to the least common multiplier (LCM) of the filiation references of the child objects associated with said object : receiving an export command for exporting one or a plurality of selected objects with associated child objects; associating with each object, a selected children variable (SC) for determining whether or not said object belongs to the set of child objects associated with selected objects, said selected children variable being equal to : a first Boolean value if the least common multiplier (LCM) of the filiation references of the one or plurality of selected objects is a multiple of the own object reference: a second Boolean value if the least common multiplier (LCM) of the filiation references of the one or plurality of selected objects is not a multiple of the own object reference: exporting to the destination data table, the selected objects and the objects with a selected children variable (SC) equal to said first Boolean value.

Abstract translation: 本发明涉及一种用于从包括具有父子关系的多个对象的源电子数据表导出到目的地电子数据表的方法，系统和程序，其中一个或几个具有其归档的对象。 在计算机中使用的方法包括以下步骤：定义对象并且与每个对象相关联一个或多个父对象或一个或多个子对象或两者; 与每个对象关联等于素数的唯一对象引用（OR）; 确定每个对象是否所述对象与至少一个子对象相关联：如果所述对象不与至少一个子对象相关联，则定义等于1的子化参考（FR）; 如果所述对象与至少一个子对象相关联，则定义等于两个项的乘积的子化参考（FR）：第一项，等于与所述对象的每个子对象相关联的每个对象引用（OR）的乘积 ：等于与所述对象相关联的子对象的归档引用的最小公用乘数（LCM）的第二项：接收用于将一个或多个所选对象与相关联的子对象一起导出的导出命令; 与每个对象相关联的所选择的子变量（SC），用于确定所述对象是否属于与所选对象相关联的一组子对象，所述选择的子变量等于：如果最小公倍数（LCM）为第一布尔值 ）所述一个或多个所选择的对象的所述提取引用的倍数是所述自身对象引用的倍数：如果所述一个或多个所选对象的所述归档引用的最小公用乘数（LCM）不是多个，则所述第二布尔值 的自己的对象引用：导出到目标数据表，所选对象和具有等于所述第一布尔值的所选子变量（SC）的对象。

公开(公告)号：WO02069212A3

公开(公告)日：2002-11-07

申请号：PCT/EP0201953

申请日：2002-01-31

Applicant: IBM ,  IBM FRANCE ,  AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC ,  SOLER CATHERINE

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC ,  SOLER CATHERINE

IPC: G06F17/24 ,  G06F17/60

CPC classification number: G06F17/246

Abstract: The present invention discloses a system and method of copying and pasting a source range of cells (405) onto a destination range of cells (425) in a multi-dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, a range of cells comprising one or a plurality of cells, said source range of cells (405) comprising one or a plurality of working ranges of cells (401), and one or a plurality of fastening ranges of cells in which one or a plurality of graphical objects are represented (402, 403, 404), said one or plurality of graphical objects being associated with said one or plurality of working ranges of cells.

Abstract translation: 本发明公开了一种将单元的源范围（405）复制并粘贴到多维电子表格中的单元（425）的目标范围上的系统和方法，所述多维电子表格包括由沿每个维度的单元地址标识的多个单元， 包括一个或多个小区的小区的范围，所述小区的源范围（405）包括一个或多个小区的工作范围（401），以及一个或多个小区的紧固范围，其中一个或多个 图形对象被表示（402,403,404），所述一个或多个图形对象与单元的所述一个或多个工作范围相关联。

公开(公告)号：WO2004092978A2

公开(公告)日：2004-10-28

申请号：PCT/EP2004003049

申请日：2004-02-27

Applicant: IBM ,  IBM FRANCE ,  AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

CPC classification number: G06F17/246

Abstract: The present invention is directed to a method, system and program in a multi-dimensional electronic data table comprising a plurality of data, for managing deletion operations in a recursive scalable template instance; a recursive scalable template instance comprising a variable number of contiguous recursive element instances ordered and aligned along a first data table dimension and structured according to a recursive scalable template; said recursive scalable template comprising a recursive element including one or a plurality of scalable templates; each recursive element instance having a variable size along said first data table dimension and a same size along a second data table dimension; a recursive element instance comprising one or a plurality of scalable template instances; each scalable template instance of each recursive element instance being aligned along said first data table dimension; each scalable template instance within each recursive element instance being aligned along a second data table dimension; a scalable template instance comprising a variable number of elements structured according to a scalable template; an element being defined as a range of data; a range of data comprising one or a plurality of data.

Abstract translation: 本发明涉及一种包括多个数据的多维电子数据表中的方法，系统和程序，用于管理递归可缩放模板实例中的删除操作; 递归可伸缩模板实​​例，包括沿着第一数据表维度排序和对齐的可变数量的连续递归元素实体，并且根据递归可缩放模板来构造; 所述递归可伸缩模板包括包括一个或多个可缩放模板的递归元素; 每个递归元素实例沿着所述第一数据表维度具有可变大小，并且沿着第二数据表维度具有相同的大小; 包括一个或多个可缩放模板实例的递归元素实例; 每个递归元素实例的每个可缩放模板实例沿着所述第一数据表维度对准; 每个递归元素实例内的每个可伸缩模板实​​例沿着第二数据表维度对齐; 可扩展的模板实例，包括根据可伸缩模板构造的可变数量的元素; 元素被定义为数据范围; 包括一个或多个数据的数据范围。

公开(公告)号：WO2004092977A3

公开(公告)日：2005-08-18

申请号：PCT/EP2004003048

申请日：2004-02-27

Applicant: IBM ,  IBM FRANCE ,  AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

CPC classification number: G06F17/246

Abstract: The present invention is directed to a method, system and program, in a multi-dimensional electronic data table comprising a plurality of data, for creating one or plurality of recursive scalable template instances; a recursive scalable template instance comprising a variable number of contiguous recursive element instances ordered and aligned along a first data table dimension and structured according to a recursive scalable template; a recursive element instance being defined as comprising one or a plurality of scalable template instances; a scalable template instance comprising a variable number of elements structured according to a scalable template; an element being defined as a range of data; a range of data comprising one or a plurality of data; a recursive scalable template comprising a recursive element comprising one or a plurality of scalable templates. The method comprises for each recursive scalable template instance to create, the steps of: . Selecting a recursive scalable template; . Defining a location for creating a recursive scalable template instance; . Creating at the defined location one or a plurality of contiguous recursive element instances ordered and aligned along a first data table dimension; each recursive element instance having a variable size along said first data table dimension and a same size along a second data table dimension; . Structuring each recursive element instance according to the recursive element defined for the recursive scalable template; . Aligning each scalable template instance of each recursive element instance along said first data table dimension; . Aligning within each recursive element instance, each scalable template instance along said second data table dimension.

Abstract translation: 本发明涉及一种包括多个数据的多维电子数据表中的方法，系统和程序，用于创建一个或多个递归可缩放模板实例; 递归可伸缩模板实​​例，包括沿着第一数据表维度排序和对齐的可变数量的连续递归元素实体，并且根据递归可缩放模板来构造; 定义为包括一个或多个可缩放模板实例的递归元素实例; 可扩展的模板实例，包括根据可伸缩模板构造的可变数量的元素; 元素被定义为数据范围; 包括一个或多个数据的数据范围; 递归可缩放模板，其包括包括一个或多个可缩放模板的递归元素。 该方法包括为每个递归可扩展模板实例创建，步骤如下： 选择递归可缩放模板; 。 定义创建递归可伸缩模板实​​例的位置; 。 在所定义的位置处创建沿着第一数据表维度排序和对齐的一个或多个连续的递归元素实例; 每个递归元素实例沿着所述第一数据表维度具有可变大小，并且沿着第二数据表维度具有相同的大小; 。 根据为递归可缩放模板定义的递归元素，构建每个递归元素实例; 。 沿着所述第一数据表维度对准每个递归元素实例的每个可缩放模板实例; 。 在每个递归元素实例内对齐沿着所述第二数据表维度的每个可缩放模板实例。

公开(公告)号：WO2004092974A2

公开(公告)日：2004-10-28

申请号：PCT/EP2004003034

申请日：2004-02-27

Applicant: IBM ,  IBM FRANCE ,  AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24 ,  G06F17/20

CPC classification number: G06F17/246

Abstract: The present invention is directed to a method, system and program, in a multi-dimensional 5 electronic data table, preferably a spreadsheet, comprising a plurality of data, for managing insertion operations in a recursive scalable template instance; a recursive scalable template instance comprising a variable number of contiguous recursive element instances ordered and aligned along a first data table dimension and structured according to a recursive scalable template; said recursive scalable template comprising a recursive element including one or a plurality of scalable templates; each recursive element instance having a variable size along said first data table dimension and a same size along a second data table dimension; a recursive element instance comprising one or a plurality of scalable template instances; each scalable template instance of each recursive element instance being aligned along said first data table dimension; each scalable template instance within each recursive element instance being aligned along a second data table dimension; a scalable template instance comprising a variable number of elements structured according to a scalable template; an element being defined as a range of data; a range of data comprising one or a plurality of data.

Abstract translation: 本发明涉及一种多维5电子数据表中的方法，系统和程序，优选地是包括多个数据的电子表格，用于管理递归可伸缩模板实​​例中的插入操作; 递归可伸缩模板实​​例，包括沿着第一数据表维度排序和对齐的可变数量的连续递归元素实体，并且根据递归可缩放模板来构造; 所述递归可伸缩模板包括包括一个或多个可缩放模板的递归元素; 每个递归元素实例沿着所述第一数据表维度具有可变大小，并且沿着第二数据表维度具有相同的大小; 包括一个或多个可缩放模板实例的递归元素实例; 每个递归元素实例的每个可缩放模板实例沿着所述第一数据表维度对准; 每个递归元素实例内的每个可伸缩模板实​​例沿着第二数据表维度对齐; 可扩展的模板实例，包括根据可伸缩模板构造的可变数量的元素; 元素被定义为数据范围; 包括一个或多个数据的数据范围。

公开(公告)号：DE602004003140D1

公开(公告)日：2006-12-21

申请号：DE602004003140

申请日：2004-02-27

Applicant: IBM

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

Abstract: A method and system for managing deletion operations in a recursive scalable template instance (RSTI) of an electronic data table having dimensions D1 and D2. The RSTI includes contiguous recursive element instances (REIs) ordered and aligned along D1. The REIs include scalable template instances (STIs). Contiguous elements are deleted, upon satisfying consistency condition(s), in a first STI. The RSTI is structured according to an associated recursive scalable template (RST) that includes a recursive element (RE) including at least one scalable template (ST). Each STI is structured according to an associated ST. The contiguous elements are structured according to a first ST associated with the first STI. A size of the first REI along dimension D1 is adjusted according to a size of a largest STI in the first REI. All REIs of the RSTI remain contiguous after the deleting and adjusting.

公开(公告)号：DE602004003140T2

公开(公告)日：2007-04-19

申请号：DE602004003140

申请日：2004-02-27

Applicant: IBM

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

Abstract: A method and system for managing deletion operations in a recursive scalable template instance (RSTI) of an electronic data table having dimensions D1 and D2. The RSTI includes contiguous recursive element instances (REIs) ordered and aligned along D1. The REIs include scalable template instances (STIs). Contiguous elements are deleted, upon satisfying consistency condition(s), in a first STI. The RSTI is structured according to an associated recursive scalable template (RST) that includes a recursive element (RE) including at least one scalable template (ST). Each STI is structured according to an associated ST. The contiguous elements are structured according to a first ST associated with the first STI. A size of the first REI along dimension D1 is adjusted according to a size of a largest STI in the first REI. All REIs of the RSTI remain contiguous after the deleting and adjusting.

公开(公告)号：DE602004003139D1

公开(公告)日：2006-12-21

申请号：DE602004003139

申请日：2004-02-27

Applicant: IBM

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

公开(公告)号：AT345533T

公开(公告)日：2006-12-15

申请号：AT04715322

申请日：2004-02-27

Applicant: IBM

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

Abstract: A method and system for creating a recursive scalable template instance (RSTI) in an electronic data table having dimensions D1 and D2. A recursive scalable template (RST) associated with the RSTI is selected such that the RSTI is to be structured in accordance with the RST. A plurality of contiguous recursive element instances (REIs) of the RSTI is created in a memory of a computer system. The REIs are ordered and aligned along the dimension D1. Each REI has a same size along the dimension D2. Each RET includes at least one scalable template instance (STI). Each REI is structured according to a recursive element (RE) defined for the RST such that the RE includes at least one scalable template (ST). Each ST of the RE is instanced to generate an associated scalable template instance (STI) of an REI of the plurality of REIs.

公开(公告)号：DE602004003230T2

公开(公告)日：2007-09-06

申请号：DE602004003230

申请日：2004-02-27

Applicant: IBM

Inventor： AUREGLIA JEAN-JACQUES ,  BAUCHOT FREDERIC

IPC: G06F17/24

Abstract: A method and system for creating a recursive scalable template instance (RSTI) in an electronic data table having dimensions D1 and D2. A recursive scalable template (RST) associated with the RSTI is selected such that the RSTI is to be structured in accordance with the RST. A plurality of contiguous recursive element instances (REIs) of the RSTI is created in a memory of a computer system. The REIs are ordered and aligned along the dimension D1. Each REI has a same size along the dimension D2. Each RET includes at least one scalable template instance (STI). Each REI is structured according to a recursive element (RE) defined for the RST such that the RE includes at least one scalable template (ST). Each ST of the RE is instanced to generate an associated scalable template instance (STI) of an REI of the plurality of REIs.