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:
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:
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:
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.
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.