Method and system in an office application for providing content dependent help information

• US 7,363,348 B2
• Filed: 05/23/2002
• Issued: 04/22/2008
• Est. Priority Date: 05/29/2001
• Status: Active Grant

• Current Assignee: Meta Platforms, Inc. (f/k/a Facebook, Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Bauchot, Frederic, Soler, Catherine, Harari, Albert, Etorre, Yves-Nicolas
• Primary Examiner(s): Najjar; Saleh
• Assistant Examiner(s): HUQ, FARZANA B
• Application Number:
  US10/478,120
• Publication Number:
  US 20040139073A1
• Time in Patent Office: 2,161 Days
• Field of Search: 709/217, 709/218, 709/219, 709/201, 709/202, 709/203, 707/1, 707/3, 707/4, 707/5, 707/100
• US Class Current: 709/217
• CPC Class Codes: G06F 9/453 Help systems
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

Method, system and program product for providing 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 a 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.

Claims

1. A computer-implemented method for providing on-line help information in an application comprising at least one object, the on-line help information being dependent on content of a selected object, the method comprising:

detecting an on-line help command as a result of a user action, the user employing the application;

identifying the selected object;

determining if the selected object comprises a user entry field of the application; and

if the selected object comprises a user entry field;

parsing the content of the user entry field to identify whether a predefined keyword is present, the predefined keyword being characterized by a character string;

for the predefined keyword identified in the content of the user entry field;

identifying predefined help information associated with the identified predefined keyword, the predefined help information specifying at least one parameter associated with the predefined keyword and at least one format and rule related to the at least one parameter;

parsing content of the user entry field to identify therein the at least one parameter specified in the predefined help information;

verifying that a format of the identified at least one parameter within the user entry filed satisfies the at least one format specified in the predefined help information;

verifying that the identified at least one parameter within the user entry field satisfies the at least one rule specified in the predefined help information; and

if the content of the user entry field does not satisfy the at least one format and/or rule specified in the predefined help information of the predefined keyword identified in the content of the user entry field;

correcting content of the user entry field according to the at least one format or the at least one rule specified in the predefined help information, and displaying the corrected content to a user; and

wherein the on-line help information comprises at least one predefined keyword recorded in a table, the table comprising for each predefined keyword;

a character string identifying the predefined keyword; and

help information, comprising;

a parameter template specifying at least one parameter associated with the predefined keyword, and at least one format and rule related to the at least one parameter; and

help text or a reference pointing to a location where the help text is recorded.

2. The method according to claim 1, further comprising:

for the predefined keyword identified in the content of the user entry field;

identifying a predefined help text in the help information associated with the identified keyword; and

displaying the identified predefined help text.

3. The method according to claim 2, wherein displaying the identified predefined help text, comprises:

copying the corrected content of the user entry field in the predefined help text.

4. The method according to claim 1, wherein identifying the content of the user entry field further comprises:

copying the content of the user entry field to a working buffer.

5. The method according to claim 1, wherein correcting the content of the user entry field, further comprises:

storing the corrected content in a working buffer.

6. The method according to claim 5, further comprising:

copying onto the selected object, the corrected content of the working buffer as a result of a user action.

7. The method according to claim 5, further comprising:

automatically copying onto the selected object, the corrected content of the working buffer.

8. The method according to claim 1, wherein the application is a multi-dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, the on-line help information being dependent on the content of a selected cell.

9. A computer-implemented method for providing on-line help information in an application comprising at least one object, the on-line help information being dependent on content of a selected object, the method comprising:

detecting an on-line help command as a result of a user action, the user employing the application;

identifying the selected object;

determining if the selected object comprises a user entry field of the application; and

if the selected object comprises a user entry field;

parsing the content of the user entry field to identify whether a predefined keyword is present, the predefined keyword being characterized by a character string;

for the predefined keyword identified in the content of the user entry field;

identifying predefined help information associated with the identified predefined keyword, the predefined help information specifying at least one parameter associated with the predefined keyword and at least one format and rule related to the at least one parameter;

parsing content of the user entry field to identify therein the at least one parameter specified in the predefined help information;

verifying that a format of the identified at least one parameter within the user entry filed satisfies the at least one format specified in the predefined help information;

verifying that the identified at least one parameter within the user entry field satisfies the at least one rule specified in the predefined help information; and

if the content of the user entry field does not satisfy the at least one format and/or rule specified in the predefined help information of the predefined keyword identified in the content of the user entry field;

correcting content of the user entry field according to the at least one format or the at least one rule specified in the predefined help information, and displaying the corrected content to a user;

predefining at least one keyword; and

recording the at least one predefined keyword in a table, the table comprising for each predefined keyword;

a character string identifying the predefined keyword; and

help information, comprising;

a parameter template for specifying at least one parameter associated with the predefined keyword, and at least one format and rule related to the at least one parameter; and

help text or a reference point to a location where the help text is recorded.