Spreadsheet-calculating system and method

A spreadsheet-calculating apparatus for storing data in correlation to each cell in a table frame in which a plurality of cells are arrayed in the directions of rows and columns and displaying information based on said stored data at a display position of said each cell comprising:

• a specifying means for specifying an arbitrary fixed column from said table frame while said table frame is displayed;
• a storage means for storing therein the arbitrary fixed column specified by said specifying means as a fixed display column and also each column located on the left side from said arbitrary fixed column as a variable display column;
• a determining means for determining, when said table frame is to be displayed by using the fixed display column stored and variable display columns stored in said storage means, whether the variable display columns stored in said storage means can be accommodated in a prespecified display area or not;
• an allocating means for allocating a display area from the variable display columns stored in said storage means according to a size of said prespecified display area only when it is determined by said determining means that the variable display columns cannot be accommodated;
• a partially displaying means for displaying a portion of said table frame by using the fixed display column stored in said storage means and the variable display columns allocated as an display object column by said allocating means when it is determined by said determining means that a portion of the variable display columns cannot be accommodated;
• and
• a display control means for providing controls to move said variable display columns displayed in said prespecified display area in the row direction in a case where, during display by said partially displaying means, the variable display columns recognized by said allocating means as outside said prespecified display area are to be displayed.

A spreadsheet-calculating apparatus for storing data in correlation to each cell in a table frame in which a plurality of cells are arrayed in the directions of rows and columns and displaying information based on said stored data at a display position of said each cell comprising:

• a specifying means for specifying an arbitrary fixed row and an arbitrary fixed column from said table frame while said table frame is displayed;
• a storage means for storing therein the arbitrary fixed row and arbitrary fixed column specified by said specifying means as a fixed display row and a fixed display column respectively, and each row located on the upper side from said arbitrary fixed row as a variable display row, and also each column on the left side from said arbitrary fixed column as a variable display column;
• a determining means for determining, when said table frame is to be displayed by using a fixed display row and variable display rows as well as a fixed display column and variable display columns stored in said stored means, whether either one or both the variable display rows and variable display columns storage in said storage means can be accommodated in a prespecified display area or not;
• an allocating means for allocating a display area from the variable display rows stored in said storage means according to a size of said prespecified display area only when it is determined by said determining means that a portion of the variable display rows can not be accommodated, allocating a display area from the variable display columns stored in said storage means according to a size of said prespecified display area only when it is determined by said determining means that a portion of the variable display columns can not be accommodated, and allocating a display area from the variable display rows and variable display columns stored in said storage means according to a size of said prespecified display area only when it is determined by said determining means that both the variable display rows and variable display columns can not be accommodated;
• a partially displaying means for displaying a portion of said table frame according to a result of allocation by said allocating means when it is determined by said determining means that a portion of the variable display rows can not be accommodated, when it is determined by said determining means that a portion of the variable display columns can not be accommodated, or when it is determined by said determining means that both the variable display rows and variable display columns cannot be accommodated;
• and
• a display control means for providing controls during display by said partially display means so that said variable display rows displayed in said prespecified display area are moved in the column direction when the variable display rows recognized by said allocating means as outside said prespecified display area are to be displayed, whereby said variable display columns displayed in said prespecified display area are moved in the row direction when the variable display columns recognized by said allocating means as outside said prespecified display area are to be displayed, or whereby said variable display rows and said variable display columns displayed in said prespecified display area are moved in the column direction and row direction respectively when the variable display rows and variable display columns recognized by said allocating means as outside said prespecified display area are to be displayed.

A spreadsheet-calculating method in which data is stored in correlation to each cell in a table frame in which a plurality of cells are arrayed in the directions of row and column and information is displayed based on data stored at a display position for said each cell comprising:

• a first step of specifying an arbitrary fixed row in the table frame while said table frame is displayed;
• a second step of determining, when said table frame is to be displayed by using the fixed display row which is a row specified in said first step and variable display rows not specified in said first step, whether the variable display rows specified in said first step can be accommodated in a prespecified display area or not;
• a third step of allocating a display range from the variable display rows specified in said first step according to a size of said prespecified display area only when it is determined in said second step that the variable display rows specified in said first step can not be accommodated in said prespecified display area,
• a fourth step of displaying a portion of said table frame by using the fixed display row specified in said first step and the variable display rows allocated as a display range in said third step when it is determined in said second step that the variable display rows specified in said first step can not be accommodated in said prespecified display area;
• and
• a fifth step of providing controls to more said variable display rows displayed in said prespecified display area in the column direction in a case where, during display in said fourth step, the variable display rows recognized in said third step for allocation as outside said prespecified display area are to be displayed.

A spreadsheet-calculating method in which data is stored in correlation to each cell of a table frame in which a plurality of cells are arrayed in the row and column directions and information is displayed based on data stored at a display position for each cell comprising:

• a first step of specifying an arbitrary fixed column in said table frame while said table frame is displayed;
• a second step of determining, when said table frame is to be displayed by using the fixed display column which is a column specified in said first step and the variable display columns which are columns not specified in said first step, whether the variable display columns specified in said first step can be accommodated in said prespecified display area or not;
• a third step of allocating a display range from the variable display columns specified in said first step according to a size of said prespecified display area only when it is determined in said second step that the variable display columns can not be accommodated;
• a fourth step of displaying a portion of said table frame by using the fixed display column specified in said first step and the variable display columns allocated as a display range in said third step when it is determined in said second step that the variable display columns can not be accommodated;
• and
• a fifth step of providing controls so that said variable display columns displayed in said prespecified display area are moved in the row direction when, during display in said fourth step, the variable display columns recognized in said third step for allocation as outside said prespecified display area.

A spreadsheet-calculating method in which data is stored in correlation to each cell of a table frame in which a plurality of cells are arrayed in the row and column directions and information is displayed based on data stored at a display position for said each cell comprising:

• a first step of specifying an arbitrary fixed row and an arbitrary fixed column in said table frame while said table frame is displayed;
• a second step of determining, when said table frame is to be displayed by using the fixed display row which is a row specified in said first step and the variable display rows which are rows not specified in said first step as well as the fixed display column which is a column specified in said first step and the variable display columns which are columns not specified in said first step, whether either one or both said variable display rows and said variable display columns can be accommodated in the prespecified display area or not;
• a third step of allocating a display range from said variable display rows according to a size of said prespecified display area only when it is determined in said second step that a portion of the variable display rows can not be accommodated, allocating a display range from the variable display columns stored in said storage means according to a size of said prespecified display area only when it is determined in said second step that a portion of the variable display columns can not be accommodated, or allocating a display range from said variable display rows and variable display columns according to a size of said prespecified display area only when it is determined by said determining means that both the variable display rows and variable display columns can not be accommodated;
• a fourth step of displaying a portion of said table frame according to a result of allocation in said third step in a case where it is determined in said second step that the variable display rows can not be accommodated, when it is determined in said second step that the variable display columns can not be accommodated, or when it is determined in said second step that both the variable display rows and variable display columns cannot be accommodated;
• and
• a fifth step of providing controls so that the variable display rows displayed in said prespecified display area are moved in the column direction when, during display in said fourth step, the variable display rows recognized in said third step for allocation as outside said prespecified display area are to be displayed, so that said variable display columns displayed in said prespecified display area are moved in the row direction when, during display in said fourth step, the variable display rows recognized in said third step for allocation as outside said prespecified display area are to be displayed, or so that said variable display rows and said variable display columns displayed in said prespecified display area are moved in the column direction and in the row direction respectively, when, during display in said fourth step, the variable display rows and variable display columns recognized in said third step for allocation as outside said prespecified display area are to be displayed.

A computer-readable medium having stored thereon sequences of instructions for having a computer execute a spreadsheet-calculating sequence on data stored in correlation to each cell of a table frame in which a plurality of cells are arrayed in the row and column direction for displaying information based on said stored data at a display position for each cell is recorded, said sequences of instructions comprising:

• first sequences of instructions for specifying an arbitrary fixed row in said table frame while said table frame is displayed;
• second sequences of instructions for determining, when said table frame is to be displayed by using the fixed display row which is a row specified in said sequences of instructions and variable display rows which are rows not specified in said first sequences of instructions, whether the variable display rows specified in said first sequences of instructions can be accommodated in a prespecified display area or not;
• third sequences of instructions for allocating a display range from the variable display rows specified in said first sequences of instructions according to a size of said prespecified display area only when it is determined in said second sequences of instructions that the variable display rows cannot be accommodated;
• fourth sequences of instructions for displaying a portion of said table frame by using the fixed display row specified in said first sequences of instructions and the variable display rows allocated as a display range in said third sequences of instructions when it is determined in said second sequences of instructions that the variable display rows can not be accommodated;
• and
• fifth sequences of instructions for providing controls so that said variable display rows displayed in said prespecified area are moved in the column direction in a case where, during display in said fourth sequences of instructions, the variable display rows recognized in said third sequences of instructions for allocation as outside said prespecified display area are to be displayed.

A computer-readable medium having stored thereon sequences of instructions for having a computer execute a spreadsheet-calculation on data stored in correlation to each cell of a table frame in which a plurality of cells are arrayed in the row and column direction and for displaying information based on said stored data at a display position for said each cell is recorded, said sequences of instructions comprising:

• first sequences of instructions for specifying an arbitrary fixed column in said table frame while said table frame is displayed;
• second sequences of instructions for determining, in a case where said table frame is to be displayed by using the fixed display column which is a column specified in said first sequences of instructions and the variable display columns which are columns not specified in said first sequences of instructions, whether the variable display columns specified in said first sequences of instructions can be accommodated in a prespecified display area or not;
• third sequences of instructions for allocating a display range from the variable display columns specified in said first sequences of instructions according to a size of said prespecified display area only when it is determined in said second sequences of instructions that the variable display columns can not be accommodated;
• fourth sequences of instructions for displaying a portion of said table frame by using the fixed display column specified in said first sequences of instructions and the variable display columns allocated as a display range in said third sequences of instructions when it is determined in said second sequences of instructions that the variable display columns cannot be accommodated;
• and
• fifth sequences of instructions for providing controls so that said variable display columns displayed in said prespecified display area are moved in the row direction when, during display in said fourth sequences of instructions, the variable display columns recognized in said third sequences of instructions for allocation as outside said prespecified display area are to be displayed.

A computer-readable medium having stored thereon sequences of instructions for having a computer execute a spreadsheet-calculating sequence on data stored in correlation to each cell of a table frame in which a plurality of cells are arrayed in the row and column direction and for displaying information based on said stored data at a display position for said each cell is recorded, said sequences of instructions comprising:

• first sequences of instructions for specifying an arbitrary fixed row and an arbitrary fixed column in said table frame while said table frame is displayed;
• second sequences of instructions for determining, when said table frame by using the fixed display row which is a row specified in said first sequences of instructions and the variable display rows which are rows not specified in said first sequences of instructions as well as the fixed display column which is a column specified in said first sequence and the variable display columns which are columns not specified in said first sequences of instructions is to be displayed, whether either one or both said variable display rows and variable display columns can be accommodated in a prespecified display area or not;
• third sequences of instructions for allocating a display range from said variable display rows according to a size of said prespecified display area only when it is determined in said second sequences of instructions that the variable display rows cannot be accommodated, allocating a display range from the variable display columns stored in said storage means according to a size of said prespecified display area only when it is determined in said second sequences of instructions that the variable display columns cannot be accommodated, or allocating a display range from said variable display rows and variable display columns according to a size of said prespecified display area only when it is determined in said second sequences of instructions that both the variable display rows and said variable display columns cannot be accommodated;
• fourth sequences of instructions for displaying a portion of said table frame by according to a result of allocation in said third sequences of instructions when it is determined in said second sequences of instructions that the variable display rows cannot be accommodated, when it is determined in said second sequences of instructions that the variable display columns cannot be accommodated, or when it is determined in said second sequences of instructions that both the variable display rows and said display columns cannot be accommodated;
• and
• fifth sequences of instructions for providing controls so that said variable display rows displayed in said prespecified display area are moved in the column direction when, during display in said fourth sequences of instructions, the variable display rows as recognized in said third sequences of instructions for allocation as outside said prespecified display area are to be displayed, so that said variable display columns displayed in said prespecified display area are moved in the row direction when, during display in said fourth sequences of instructions, the variable display columns recognized in said third sequences of instructions for allocation as outside said prespecified display area are to be displayed, or so that said variable display rows and said variable display columns displayed in said prespecified display area are moved in the column direction and in the row direction respectively when, during display in said fourth sequences of instructions, the variable display rows and variable display columns recognized in said third sequences of instructions for allocation as outside said prespecified display area are to be displayed.