公开(公告)号：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）中指定的一个或多个格式和规则。

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

公开(公告)号：JPH1070554A

公开(公告)日：1998-03-10

申请号：JP9595897

申请日：1997-04-14

Applicant: IBM

Inventor： BAUCHOT FREDERIC

IPC: H04Q3/00 ,  H04L12/28 ,  H04L12/56

Abstract: PROBLEM TO BE SOLVED: To attain efficient radio access to an ATM network by providing an ATM adapter, a transceiver adapter and an antenna at an access point and forming a radio link to a mobile terminal equipment. SOLUTION: Access points 18, 20 are connected to ATM links 22, 24 via an ATM adapter 34. Furthermore, an RF transceiver adapter 38 being a printed wiring card is inserted into a bus slot of the access point. The transceiver adapter 38 has an antenna 40 to form a radio link 42 with mobile terminal equipment 10-16. Furthermore, each of the mobile terminal equipments 10-16 has similarly a transceiver adapter 36 and an antenna 44. Moreover, the access point and the mobile terminal equipments have respectively a software to support the transceiver adapter. Thus, the efficient radio access to the ATM network is obtained.

公开(公告)号：JP2001357343A

公开(公告)日：2001-12-26

申请号：JP2001112850

申请日：2001-04-11

Applicant: IBM

Inventor： BAUCHOT FREDERIC ,  HARARI ALBERT

IPC: G06F17/21 ,  G06F17/24 ,  G06Q10/00 ,  G06F19/00

Abstract: PROBLEM TO BE SOLVED: To correctly process the absolute cell references or cell range references which are contained in formulae included in cells when cut off or copy is executed in a certain file and then pasting is executed to another file. SOLUTION: This method includes following steps (1)-(3). That is, (1) the source/cell ranges to be cut off or copied are selected and the contents of cells belonging to the selected source/cell ranges are stored in a work buffer (2). When the stores cell contents includes one or plural absolute references, the relative positions are decided in the source/cell ranges about each cell or cell range belonging to the source/cell ranges indicated by the absolute references and these relative positions are replaced with their corresponding absolute references included in a destination cell range (3). Then the contents of cells stored in the work buffer are copied to their corresponding cells included in the destination cell range.

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

公开(公告)号：JP2001216463A

公开(公告)日：2001-08-10

申请号：JP2000398247

申请日：2000-12-27

Applicant: IBM

Inventor： BAUCHOT FREDERIC ,  HARARI ALBERT

IPC: G06Q10/00 ,  G06F17/24 ,  G06F19/00

Abstract: PROBLEM TO BE SOLVED: To provide a method and a system for adding or removing an element to or from a cell designation range in a spreadsheet. SOLUTION: When adding or removing a spreadsheet element (such as row, column or page) to or from the cell designation range in an electronic spreadsheet, the 'sum' information of the cell designation range is preserved so that the contents of the existent designation range can be automatically amended.

公开(公告)号：JP2001092914A

公开(公告)日：2001-04-06

申请号：JP2000247148

申请日：2000-08-17

Applicant: IBM

Inventor： BAUCHOT FREDERIC ,  HARRARI ALBERT

IPC: G06Q10/00 ,  G06F17/24 ,  G06F19/00

Abstract: PROBLEM TO BE SOLVED: To automatically adjust the limit of a named range for adding a new element (row, column or sheet) within a named range of a spreadsheet. SOLUTION: This method is provided with a step for defining an open named range by designating one or plural open directions to the named range and a step for defining a hidden range with name having a cell address range expanding the open named range just for one address in all the designated open directions. Further, the method is provided with a step for selecting one or plural directions, a step for increasing the cell address range of the hidden named range by inserting a new address in the selected direction between two continuous cell addresses and a step for updating the open named range by shortening the open range with name just for one address in all the designated open directions.

公开(公告)号：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标签读取器执行指示结果的功能。