-
1.发明申请METHOD AND SYSTEM IN AN OFFICE APPLICATION FOR PROVIDING CONTENT DEPENDENT HELP INFORMATION 审中-公开办公室申请中提供内容相关帮助信息的方法和系统
公开(公告)号：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
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）中指定的一个或多个格式和规则。
-
2.发明申请METHOD AND SYSTEM IN AN OFFICE APPLICATION FOR PROVIDING CONTENT DEPENDENT HELP INFORMATION 审中-公开办公室申请中提供内容相关帮助信息的方法和系统
公开(公告)号：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
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）中指定的一个或多个格式和规则。
-
公开(公告)号：JP2001357343A
公开(公告)日：2001-12-26
申请号：JP2001112850
申请日：2001-04-11
Applicant: IBM
Inventor： BAUCHOT FREDERIC , HARARI ALBERT
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.
-
4.发明专利
公开(公告)号：JP2001216463A
公开(公告)日：2001-08-10
申请号：JP2000398247
申请日：2000-12-27
Applicant: IBM
Inventor： BAUCHOT FREDERIC , HARARI ALBERT
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.
-
公开(公告)号：CA2311866A1
公开(公告)日：2001-07-06
申请号：CA2311866
申请日：2000-06-15
Applicant: IBM
Inventor： BAUCHOT FREDERIC , HARARI ALBERT
Abstract: 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 preserving some "summary" information of a cell named range when some spreadsheet elements (like rows, or columns, or pages) are added or removed from said cell named range. The meth od of processing a range summary cell in a multi dimensional spreadsheet comprising a plurali ty of cells identified by a cell address, comprises the steps of: ~ defining (509) a range summary cell (410) by specifying in a table (400): ~ a range summary cell address (411, 412, 413); ~ a cell range address (414) identifying an associated cell range; said range summary cell address (411, 412, 413) being function of the specified cell range address (414); In response to an user request (602) for adding or deleting a spreadsheet element sharing a common cell address along at least one dimension with the cell range associated with the range summary cell: ~ updating (604) in the table (400), the cell range address (414) of the cel l range associated with the range summary cell according to the user request; ~ updating (605) in the table, the range summary cell address (411, 412, 413 ) according to the updated cell range address (414); ~ moving (611) in the spreadsheet, the range summary cell according to the updated range summary cell address (411, 412, 413); ~ adding or deleting the spreadsheet element according to the user request; ~ updating in the table (400), the cell range address (414) after the additi on or the deletion of the spreadsheet element; ~ updating in the table, the range summary cell address (411, 412, 413) according to the updated cell range address (414).
-
Patent Agency Ranking
公开(公告)号：DE60203525T2
公开(公告)日：2006-03-16
申请号：DE60203525
申请日：2002-05-23
Applicant: IBM
Inventor： BAUCHOT FREDERIC , ETORRE YVES-NICOLAS , HARARI ALBERT , SOLER CATHERINE
Abstract: System and program product are provided for facilitating on-line help information in an office application which includes one or more objects. The on-line help information is dependent on content of a selected object of the office application. A user of the office application is provided with help information setting forth an example directly derived from content of the currently selected object or cell. Content of a user entry field within the object is parsed to determine whether a predefined keyword is present, and if so, at least one parameter associated with the keyword and at least one format or rule related to the at least one parameter are identified. The at least one format and rule specified in the help information are employed in correcting content of the user entry field, for example, for display to the user.
-
公开(公告)号：DE60008498T2
公开(公告)日：2004-12-02
申请号：DE60008498
申请日：2000-12-07
Applicant: IBM
Inventor： HARARI ALBERT , BAUCHOT FREDERIC
Abstract: Some "summary" information in a spreadsheet of a cell named range is preserved when some spreadsheet elements (like rows, or columns, or pages) are added or removed from the cell named range. A plurality of cells are identified by a cell address. A range summary cell is defined by specifying in a table a range summary cell address; a cell range address identifying an associated cell range; the range summary cell address is a function of the specified cell range address. In response to a user request for adding or deleting a spreadsheet element sharing a common cell address along at least one dimension with the cell range associated with the range summary cell updating in the table, the cell range address of the cell range associated with the range summary cell according to the user request; updating in the table, the range summary cell address according to the updated cell range address; moving in the spreadsheet, the range summary cell according to the updated range summary cell address; adding or deleting the spreadsheet element according to the user request; updating in the table, the cell range address after the addition or the deletion of the spreadsheet element; and updating in the table, the range summary cell address according to the updated cell range address.
-
公开(公告)号：DE60008498D1
公开(公告)日：2004-04-01
申请号：DE60008498
申请日：2000-12-07
Applicant: IBM
Inventor： HARARI ALBERT , BAUCHOT FREDERIC
Abstract: Some "summary" information in a spreadsheet of a cell named range is preserved when some spreadsheet elements (like rows, or columns, or pages) are added or removed from the cell named range. A plurality of cells are identified by a cell address. A range summary cell is defined by specifying in a table a range summary cell address; a cell range address identifying an associated cell range; the range summary cell address is a function of the specified cell range address. In response to a user request for adding or deleting a spreadsheet element sharing a common cell address along at least one dimension with the cell range associated with the range summary cell updating in the table, the cell range address of the cell range associated with the range summary cell according to the user request; updating in the table, the range summary cell address according to the updated cell range address; moving in the spreadsheet, the range summary cell according to the updated range summary cell address; adding or deleting the spreadsheet element according to the user request; updating in the table, the cell range address after the addition or the deletion of the spreadsheet element; and updating in the table, the range summary cell address according to the updated cell range address.
-
公开(公告)号：CA2305968A1
公开(公告)日：2001-02-20
申请号：CA2305968
申请日：2000-04-19
Applicant: IBM
Inventor： HARARI ALBERT , BAUCHOT FREDERIC
Abstract: The present invention discloses a system and method of processing a named range defined by a cell address range in a spreadsheet comprising a plurality of cells identified in each dimension by an address, each dimension comprising two directions. The method comprises the steps of defining an open named range by specifying to the named range at least one open directio n; defining a hidden named range with the cell address range of the open named range expanded by one address in every direction specified as open. In response to an user action, the method comprises the further steps of selecting at least one direction; increasing the cell address range of th e hidden named range by inserting between two consecutive cell addresses, a new address in selected directions; updating the open named range with the cell address range of the hidden named range shortened by one address in every direction specified as open.
-
公开(公告)号：DE60133343T2
公开(公告)日：2009-04-23
申请号：DE60133343
申请日：2001-05-10
Applicant: IBM
Inventor： BAUCHOT FREDERIC , MAUDUIT DANIEL , HARARI ALBERT , SIROT BENOIT
-
-
-
-
-
-
-
-
-
Search Results
17
records
(took 0.017 seconds)
