Method of updating a database created with a spreadsheet program

• US 20050149482A1
• Filed: 11/29/2004
• Published: 07/07/2005
• Est. Priority Date: 12/19/2003
• Status: Abandoned Application

• Current Assignee: Thales SA
• Original Assignee: Thales SA
• Inventors: Dillon, Patrick
• Application Number:
  US10/998,174
• Publication Number:
  US 20050149482A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

The present invention concerns a method of updating a database created with a spreadsheet program, for example with the Excel computer program. The manipulation of databases in a spreadsheet program may be a source of errors and lack user-friendliness to ensure that it is efficiently used. The main object of the invention is to ensure a uniformity and to facilitate the task of a user in the creation and maintenance of such a database. Accordingly, the object of the invention is an updating method. The data of the database are located in a first range of cells, and update parameters are located in a second range of cells. At least one updating function is applied to a determined set of cells of the first range of cells, each updating function using update parameters contained in determined cells of the second range of cells.

Claims

1. A method of updating a database contained in a table that can be processed by a spreadsheet program, the data of the database being located in a first range of cells, update parameters being located in a second range of cells, comprising the steps of:

applying to update function and determine set of cells of the first range of cells, each updating function using update parameters included in determined cells of the second range of cells.

2. The method as claimed in claim 1, wherein the second range of cells is placed above the first range of cells in one and the same table.

3. The method as claimed in claim 1, wherein the first range of cells and the second range of cells each containing a location marker, the position of said first and second ranges of cells is determined by finding said markers, the step of determining the position preceding the application of the updating functions.

4. The method as claimed in claim 1, wherein the parameters of at least one determined updating function being located in one or more determined parameter lines, the parameter lines belonging to the second range of cells, this updating function is applied column by column to the cells of the database, the parameters used for updating a column of the database being included in the cells belonging to a corresponding column of the parameter lines.

5. The method as claimed in claim 4, wherein the updating function uses a parameter line, each cell of the line being able to contain a formula or no formula, the updating function being applied to the database cells located in the columns for which the corresponding cell of the parameter line effectively contains a formula, the application of the updating function, including at least for each of these columns, in copying the formula contained in said corresponding cell of the parameter line into the cells of the database column in question.

6. The method as claimed in claim 4, wherein the updating function uses a parameter line, each cell of the line being able to contain a reference to a validation list, the updating function being applied to the database cells located in the columns for which the corresponding cell of the parameter line effectively contains a reference to a validation list, the application of the updating function, including at least for each of these columns, in assigning the validation list whose name is contained in said corresponding cell of the parameter line into the cells of the database column in question.

7. The method as claimed in claim 4, wherein the updating function uses at least one parameter line, each cell of this line being able to contain a code or no code, the application of the updating function including at least in applying one or more determined attributes to the cells of the corresponding database column, the attributes applied being determined by the code.

8. The method as claimed in claim 7, wherein the attributes applied are formatting and/or protection attributes.

9. The method as claimed in claim 8, wherein, when the attributes applied are formatting attributes, these attributes originate from the cell in question of the parameter line.

10. The method as claimed in claim 1, wherein at least one determined updating function is applied line by line to all the cells of the database.

11. The method as claimed in claim 10, wherein the updating function includes at least in applying an alternative coloration to the lines of the database.

12. The method as claimed in claim 10, wherein the updating function includes at least in sorting the lines of the database according to an order defined by the content of the determined cells of the second range of cells.

13. The method as claimed in claim 10, wherein the updating function includes at feast in numbering the lines of the database if a determined code is present in the second range of cells, the numbering forming a field of the database.

14. The method as claimed in claim 10, wherein the updating function includes at least in allocating a name to the first range of cells based on the content of a determined cell of the second range of cells.

15. The method as claimed in claim 10, wherein the updating function includes at least in allocating a name to columns of the first range of cells, the names being determined based on the content of a determined cell of the second range of cells on the one hand, and on the content of the cell of the first line and of the same column of the first range of cells.