Method and system in an electronic spreadsheet for introducing new elements in a cell named range according to different modes

The method according to the preceding claim wherein the step of specifying at least one direction comprises the step of:

• specifying at least one of the following:
• a right direction along a row axis;
• a left direction along a column axis;
• a down direction along a column axis;
• a forward direction along a sheet axis;
• and
• a backward direction along a sheet axis.

A 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, said method comprising the steps of:

• defining an open named range by specifying to the named range at least one open direction;
• 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 a user action, selecting at least one direction;
• in response to a user action, increasing the cell address range of the hidden named range by inserting between two consecutive cell addresses, a new address in selected directions;
• in response to a user action, 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;
• wherein the step of specifying at least one direction comprises the step of:
• specifying at least one of the following:
• a right direction along a row axis;
• a left direction along a column axis;
• a down direction along a column axis;
• a forward direction along a sheet axis;
• and
• a backward direction along a sheet axis, associating with the open named range a table comprising:
• a name for the open named range;
• a cell address range for the open named range;
• an identification of open directions;
• a name for the hidden named range;
• and
• a cell address range for the hidden named range;
• and
• maintaining said table each time the open named range is updated.

A spreadsheet system for 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, said system comprising:

• means for defining an open named range by specifying to the named range at least one open direction;
• means for 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 a user action, means for selecting at least one direction;
• in response to a user action, means for increasing the cell address range of the hidden named range by inserting between two consecutive cell addresses, a new address in selected directions;
• and
• in response to a user action, means for 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.

A computer readable medium for 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, said computer readable medium comprising:

• computer readable means for defining an open named range by specifying to the named range at least one open direction;
• computer readable means for 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 a user action, computer readable means for selecting at least one direction;
• in response to a user action, computer readable means for increasing the cell address range of the hidden named range by inserting between two consecutive cell addresses, a new address in selected directions;
• and
• in response to a user action, computer readable means for 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.