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.

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.

Abstract: In an electronic spreadsheet, an example of a solution provided here comprises defining boolean variables in a table, referencing the boolean variables in one or more cells, and determining the content of the cells. Such a solution may involve managing the boolean variables (also referred to as options) by creating a new option, renaming an existing option, or changing the status of an existing option, for example.

Abstract: An example of a solution provided here comprises defining one or more combinations of options, defining an operation to execute (e.g. copy and paste, or cut and paste), computing the content of each cell within the source cell range according to the options, creating a version instance of the destination cell range, and copying the source range of cells into the version instance. Each of the options is defined as a boolean variable, which can be set as “True” or “False,” and impact the content of a cell within an electronic spreadsheet.

Abstract: In an electronic spreadsheet, if an absolute cell or absolute cell range reference does not comprise the same information in a source environment and in a destination environment, errors may occur. Therefore, a buffer is created for temporarily storing a source cell range. Any material in the buffer not needed, is cleared. Any absolute reference content remaining that points to a source cell range, has a relative position within the source cell range determined. Then, a corresponding absolute reference within the destination cell range is determined. Prior to copying the buffer content into corresponding cells within a destination cell range, each absolute reference pointing to a source is replaced by a corresponding absolute reference with the destination cell range.

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

Abstract: Some “summary” information in a cell named range is preserved when some spreadsheet elements rows, columns, or pages are added or removed from the cell named range. A range summary cell is defined by specifying in a table a range summary cell address. A range summary cell address is updated in the table according to the updated cell range address, and the range summary cell is moved according to the updated range summary cell address. The cell range address is updated in the table after the addition or the deletion of the spreadsheet element, and the range summary cell address is updated in the table according to the updated cell range address.

Abstract: A named range defined by a cell address range in a spreadsheet comprises a plurality of cells identified in each dimension by an address, each dimension comprising two directions. An open named range is specifyed to the named range in at least one open direction. A hidden named range with the cell address range of the open named range is expanded by one address in every direction specified as open. In response to user action, at least one direction is selected, the cell address range of the hidden named range is increased by inserting between two consecutive cell addresses, a new address in selected directions, the open named range is updated with the cell address range of the hidden named range shortened by one address in every direction specified as open.

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 easily swapping the protection mode of a cell between a protected mode and an unprotected mode, while preserving the mathematical formulas used in the protected mode The electronic spreadsheet includes a cell content manager with an interface for handling the content of user specified cells according to the read-only, protected mode where a cell is usually filled by a formula, and the read-write, unprotected mode with a free update of the cell by the spreadsheet user. Preferred display methodology is also described for representing the current mode of a given cell.

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, of applying one or a plurality of user-defined options within one or a plurality of cells.

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 handling user-defined options during a copy/cut-paste operation when the source range of cells comprises one or a plurality of cells with user-defined options and when the destination environment does not necessarily defines the same user-defined options as the ones defined in the source environment.

Abstract: The present invention relates to the field of information processing by digital computers, and more particularly to a method and system of processing user defined boolean variables in a multi dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, said method comprising the steps of:

Abstract: In an electronic spreadsheet, if an absolute cell or absolute cell range reference does not comprise the same information in a source environment and in a destination environment, errors may occur. Therefore, a buffer is created for temporarily storing a source cell range. Any material in the buffer not needed, is cleared. Any absolute reference content remaining that points to a source cell range, has a relative position within the source cell range determined. Then, a corresponding absolute reference within the destination cell range is determined. Prior to copying the buffer content into corresponding cells within a destination cell range, each absolute reference pointing to a source is replaced by a corresponding absolute reference with the destination cell range.

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.