公开(公告)号：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），所述一个或多个图形对象与单元的所述一个或多个工作范围相关联。

公开(公告)号：WO02097608A2

公开(公告)日：2002-12-05

申请号：PCT/EP0206926

申请日：2002-05-23

Applicant: IBM ,  IBM FRANCE ,  BAUCHOT FREDERIC ,  ETORRE YVES-NICOLAS ,  HARARI ALBERT ,  SOLER CATHERINE

Inventor： BAUCHOT FREDERIC ,  ETORRE YVES-NICOLAS ,  HARARI ALBERT ,  SOLER CATHERINE

IPC: G06F3/14 ,  G06F9/44 ,  G06F9/00

CPC classification number: G06F9/4446 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

Abstract: The present invention discloses a system, method and computer program for providing on-line help information in an office application comprising one or a plurality of objects, said on-line help information (624, 642, 643) being dependent on the content (504) of a selected object (503). The method comprises the steps of: detecting (402) an on-line help command as a result of a user action; identifying a selected object (503); determining (403) if the selected object (503) comprises a user entry field; if the selected object (503) comprises a user entry field: identifying the content (504) of said user entry field; parsing (405) the content (504) of the user entry field to identify if any predefined keyword (301) is present, a keyword (302) being characterized by a character string (302); for each predefined keyword (301) identified in the content (504) of the user entry field: identifying (407) a predefined help information (303), if any, associated with the identified keyword (301), said help information specifying one or a plurality of parameters associated with said keyword; and one or plurality of formats and rules related to said one or plurality of parameters; parsing (408) the content (504) of the user entry field to identify the one or plurality of parameters specified in said predefined help information (303); verifying (410) that formats of the one of plurality of parameters within the user entry field satisfy formats specified in the predefined help information (303); verifying (409) that the one or plurality of parameters within the user entry field satisfy the rules specified in the predefined help information (303); if the content (504) of the user entry field does not satisfy a format or a rule specified in the help information of a predefined keyword identified in the content of the user entry field: correcting (409, 410) the content of the user entry field according to the one or plurality of formats and rules specified in the help information (303).

Abstract translation: 本发明公开了一种用于在包括一个或多个对象的办公应用中提供在线帮助信息的系统，方法和计算机程序，所述在线帮助信息（624,642,643）依赖于内容（504 ）选择对象（503）。 该方法包括以下步骤：作为用户动作的结果检测（402）在线帮助命令; 识别所选择的对象（503）; 确定（403）如果所选择的对象（503）包括用户输入字段; 如果所选择的对象（503）包括用户输入字段：识别所述用户输入字段的内容（504）; 解析（405）用户输入字段的内容（504）以识别是否存在任何预定义的关键字（301），由字符串（302）表征的关键字（302）; 对于在用户输入字段的内容（504）中标识的每个预定义关键字（301）：识别（407）与所识别的关键字（301）相关联的预定义帮助信息（303）（如果有的话），所述帮助信息指定一个或 与所述关键字相关联的多个参数; 以及与所述一个或多个参数相关的一个或多个格式和规则; 解析（408）用户输入字段的内容（504）以识别在所述预定义帮助信息（303）中指定的一个或多个参数; 验证（410）所述用户输入字段内的多个参数中的一个的格式满足在所述预定义帮助信息（303）中指定的格式; 验证（409）所述用户输入字段内的一个或多个参数满足在所述预定义帮助信息（303）中指定的规则; 如果用户输入字段的内容（504）不满足在用户输入字段的内容中标识的预定关键字的帮助信息中指定的格式或规则：校正（409,410）用户条目的内容 字段，其根据在帮助信息（303）中指定的一个或多个格式和规则。

公开(公告)号：WO2007000375A3

公开(公告)日：2007-03-08

申请号：PCT/EP2006062330

申请日：2006-05-16

Applicant: IBM ,  IBM FRANCE ,  BAUCHOT FREDERIC

Inventor： BAUCHOT FREDERIC

IPC: G06F17/24 ,  G06F21/62

CPC classification number: G06F17/246 ,  G06F21/6227

Abstract: A system, method and computer program for hiding sensitive data of a model in an electronic spreadsheet, the method comprising the steps of identifying a model in a spreadsheet, this model comprising: one or plurality of cells comprising input data; one or a plurality of cells comprising intermediary results, each intermediary result being defined as the result of an equation comprising as arguments, one or a plurality of input data and/or one or a plurality of intermediary results; a cell comprising output data defined as the result of an equation comprising as arguments, one or a plurality of input data and/or one or a plurality of intermediary results; establishing equations for intermediary results comprising only input data as arguments; establishing an equation for output data comprising only input data as arguments; removing the content of cells comprising intermediary results, so that the resulting model only comprises: one or plurality of cells comprising input data; a cell comprising output data defined as the result of an equation comprising only input data as arguments.

Abstract translation: 一种用于在电子表格中隐藏模型的敏感数据的系统，方法和计算机程序，所述方法包括以下步骤：识别电子表格中的模型，该模型包括：一个或多个单元，包括输入数据; 一个或多个单元包括中间结果，每个中间结果被定义为包括作为参数的一个或多个输入数据和/或一个或多个中间结果的方程式的结果; 包括作为包括作为参数的一个或多个输入数据和/或一个或多个中间结果的方程式的结果定义的输出数据的单元; 建立仅包含输入数据作为参数的中间结果方程; 建立仅包含输入数据作为参数的输出数据的方程; 去除包含中间结果的单元格的内容，使得所得到的模型仅包括：包括输入数据的一个或多个单元; 包括作为仅包含输入数据作为参数的方程式的结果定义的输出数据的单元。

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

公开(公告)号：WO2010052149A3

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

申请号：PCT/EP2009064087

申请日：2009-10-26

Applicant: IBM ,  IBM FRANCE ,  TRUNTSCHKA CAROLE ,  MARMIGERE GERARD ,  BAUCHOT FREDERIC ,  CLEMENT JEAN-YVES

Inventor： TRUNTSCHKA CAROLE ,  MARMIGERE GERARD ,  BAUCHOT FREDERIC ,  CLEMENT JEAN-YVES

IPC: G06Q10/00

CPC classification number: G06Q10/06

Abstract: An expiration management method and system. The method includes transmitting by an RFID tag reader within an enclosure, a plurality of continuous timing signals. The enclosure comprises a container comprising a product and an RFID tag. The RFID tag comprises data indicating a first state for the RFID tag and a first time period. The RFID tag reader receives the data and generates a first time stamp. The RFID tag reader transmits a first message commanding the RFID tag to enter a second state. The RFID tag reader transmits the first time stamp and generates a second time stamp. The RFID tag reader transmits the second time stamp. The RFID tag reader receives results from a comparing process performed by the RFID tag. The RFID tag reader performs a function indicating the results.

Abstract translation: 过期管理方法和系统。 该方法包括通过机箱内的RFID标签读取器发送多个连续定时信号。 外壳包括容器，其包括产品和RFID标签。 RFID标签包括指示RFID标签的第一状态和第一时间段的数据。 RFID标签读取器接收数据并生成第一时间戳。 RFID标签读取器发送指示RFID标签进入第二状态的第一消息。 RFID标签读取器发送第一时间戳并生成第二时间戳。 RFID标签读取器传送第二个时间戳。 RFID标签读取器从RFID标签执行的比较处理接收结果。 RFID标签读取器执行指示结果的功能。

公开(公告)号：WO2009015979A2

公开(公告)日：2009-02-05

申请号：PCT/EP2008058572

申请日：2008-07-03

Applicant: IBM ,  IBM FRANCE ,  BAUCHOT FREDERIC

Inventor： BAUCHOT FREDERIC

IPC: H04L9/22

CPC classification number: H04L9/0662 ,  H04L2209/26

Abstract: The present invention relates to the field of computer data encrypting and decrypting, especially for mobile equipments like PDA, mobile phones, smart cards and the like, which need a good trade-off between computing speed, power consumption and security strength. The invention provides an encrypting/decrypting method implementing simple data operation. This method is based on generating a pseudo-random sequence through a function of the Collatz (or Syracuse) family from a starting number used as a secret key. Binary words of a secret length, extracted from the plain data, are encrypted into a sequence of encrypted numbers representing the offsets of these words whithin the binary form of the pseudo-random sequence.

Abstract translation: 本发明涉及计算机数据加密和解密领域，特别是对于诸如PDA，移动电话，智能卡等的移动设备，其需要在计算速度，功耗和安全强度之间进行良好的权衡。 本发明提供一种实现简单数据操作的加密/解密方法。 该方法基于从用作密钥的起始号码通过Collat​​z（或Syracuse）族的函数生成伪随机序列。 从普通数据提取的秘密长度的二进制字被加密成代表伪随机序列的二进制形式的这些字的偏移量的加密数字序列。

公开(公告)号：WO2007068519A3

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

申请号：PCT/EP2006067458

申请日：2006-10-16

Applicant: IBM ,  IBM FRANCE ,  BAUCHOT FREDERIC ,  CLEMENT JEAN-YVES ,  MARMIGERE GERARD ,  SECONDO PIERRE

Inventor： BAUCHOT FREDERIC ,  CLEMENT JEAN-YVES ,  MARMIGERE GERARD ,  SECONDO PIERRE

IPC: G06K19/00 ,  H04L9/32

CPC classification number: H04L9/3271 ,  G06Q20/3674 ,  H04L2209/805

Abstract: A method for authenticating an item comprising an RFID having a memory for storing an identifier and a secret key, and a built-in hashing function, is disclosed. According to the method of the invention, the output of the RFID of the item to be authenticated is compared with the output of the RFID of a genuine item. To that end, a random number is transmitted to the item to be authenticated with zero as parameters. The RFID 's identifier, the random number, and the secret key are concatenated and use as input of the built-in hashing function that result is output with the RFID identifier. The RFID 's identifier and the random number are then transmitted to the RFID of the genuine item that returns its identifier and the output of the built-in hashing function computed with the RFID 's identifier of the item to be authenticated, the random number, and the secret key. If the results of both built-in hashing functions are identical, the item is authenticated else, it is counterfeiting.

Abstract translation: 公开了一种用于认证包括具有用于存储标识符和秘密密钥的存储器的RFID和内置散列函数的物品的方法。 根据本发明的方法，将要认证的物品的RFID的输出与真品的RFID的输出进行比较。 为此，将一个随机数字作为参数发送给要被认证的零件。 RFID的标识符，随机数和密钥被连接在一起并用作内置散列函数的输入，该结果与RFID标识符一起输出。 RFID的标识符和随机数然后被传送到真品的RFID中，该真品返回其标识符和内容散列函数的输出，该函数使用待鉴别物品的RFID标识符计算，随机数 ，和密钥。 如果两个内置哈希函数的结果都是相同的，则该项目会被验证，否则它是伪造的。

公开(公告)号：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电子数据表中的方法，系统和程序，优选地是包括多个数据的电子表格，用于管理递归可伸缩模板实​​例中的插入操作; 递归可伸缩模板实​​例，包括沿着第一数据表维度排序和对齐的可变数量的连续递归元素实体，并且根据递归可缩放模板来构造; 所述递归可伸缩模板包括包括一个或多个可缩放模板的递归元素; 每个递归元素实例沿着所述第一数据表维度具有可变大小，并且沿着第二数据表维度具有相同的大小; 包括一个或多个可缩放模板实例的递归元素实例; 每个递归元素实例的每个可缩放模板实例沿着所述第一数据表维度对准; 每个递归元素实例内的每个可伸缩模板实​​例沿着第二数据表维度对齐; 可扩展的模板实例，包括根据可伸缩模板构造的可变数量的元素; 元素被定义为数据范围; 包括一个或多个数据的数据范围。

公开(公告)号：WO02097608A8

公开(公告)日：2003-12-24

申请号：PCT/EP0206926

申请日：2002-05-23

Applicant: IBM ,  IBM FRANCE ,  BAUCHOT FREDERIC ,  ETORRE YVES-NICOLAS ,  HARARI ALBERT ,  SOLER CATHERINE

Inventor： BAUCHOT FREDERIC ,  ETORRE YVES-NICOLAS ,  HARARI ALBERT ,  SOLER CATHERINE

IPC: G06F3/14 ,  G06F9/44

CPC classification number: G06F9/4446 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

Abstract: The present invention discloses a system, method and computer program for providing on-line help information in an office application comprising one or a plurality of objects, said on-line help information (624, 642, 643) being dependent on the content (504) of a selected object (503). The method comprises the steps of: detecting (402) an on-line help command as a result of a user action; identifying a selected object (503); determining (403) if the selected object (503) comprises a user entry field; if the selected object (503) comprises a user entry field: identifying the content (504) of said user entry field; parsing (405) the content (504) of the user entry field to identify if any predefined keyword (301) is present, a keyword (302) being characterized by a character string (302); for each predefined keyword (301) identified in the content (504) of the user entry field: identifying (407) a predefined help information (303), if any, associated with the identified keyword (301), said help information specifying one or a plurality of parameters associated with said keyword; and one or plurality of formats and rules related to said one or plurality of parameters; parsing (408) the content (504) of the user entry field to identify the one or plurality of parameters specified in said predefined help information (303); verifying (410) that formats of the one of plurality of parameters within the user entry field satisfy formats specified in the predefined help information (303); verifying (409) that the one or plurality of parameters within the user entry field satisfy the rules specified in the predefined help information (303); if the content (504) of the user entry field does not satisfy a format or a rule specified in the help information of a predefined keyword identified in the content of the user entry field: correcting (409, 410) the content of the user entry field according to the one or plurality of formats and rules specified in the help information (303).

Abstract translation: 本发明公开了一种用于在包括一个或多个对象的办公应用中提供在线帮助信息的系统，方法和计算机程序，所述在线帮助信息（624,642,643）依赖于内容（504 ）选择对象（503）。 该方法包括以下步骤：作为用户动作的结果检测（402）在线帮助命令; 识别所选择的对象（503）; 确定（403）如果所选择的对象（503）包括用户输入字段; 如果所选择的对象（503）包括用户输入字段：识别所述用户输入字段的内容（504）; 解析（405）用户输入字段的内容（504）以识别是否存在任何预定义的关键字（301），由字符串（302）表征的关键字（302）; 对于在用户输入字段的内容（504）中标识的每个预定义关键字（301）：识别（407）与所识别的关键字（301）相关联的预定义帮助信息（303）（如果有的话），所述帮助信息指定一个或 与所述关键字相关联的多个参数; 以及与所述一个或多个参数相关的一个或多个格式和规则; 解析（408）用户输入字段的内容（504）以识别在所述预定义帮助信息（303）中指定的一个或多个参数; 验证（410）所述用户输入字段内的多个参数中的一个的格式满足在所述预定义帮助信息（303）中指定的格式; 验证（409）所述用户输入字段内的一个或多个参数满足在所述预定义帮助信息（303）中指定的规则; 如果用户输入字段的内容（504）不满足在用户输入字段的内容中标识的预定关键字的帮助信息中指定的格式或规则：校正（409,410）用户条目的内容 字段，其根据在帮助信息（303）中指定的一个或多个格式和规则。