JPS62219068A - Control system for attribute of cell - Google Patents

Abstract

PURPOSE:To allow plural users to simultaneously handle spread sheet data and to prevent data that one user does not want to modify from being mistakenly modified by giving access attributes to rows and columns in each cell of the spread sheet data. CONSTITUTION:The access attribute of eight bits is given to each cell: first 0-3 bits for an owner's number, bits 4 and 5 for permitting an owner to read and write data, and bits 6 and 7 for permitting users apart from an owner to read and write. When a user request the use of a spread sheet, the access attribute is referred to blank a read failure cell and the spread sheet is displayed on a display 4. When a user wants to enter data in a cell, he specifies the cell corresponding to a cursor, and enters data in it. When cell data is inputted, a data input part 6 refers to the access attribute, etc. If it shows that writing is possible, the part 6 writes data in the cell concerned: otherwise, the part 6 displays an message showing the effect in the lower area of the display 4.

Description

[Detailed Description of the Invention] [Summary] By assigning access attributes to each cell, row, and column of a spreadsheet, data can be protected even when the sheet is used by multiple users. .

[Industrial application field]

In a spreadsheet system that can be accessed simultaneously by multiple users, the present invention provides spreadsheet data for each cell, row, and column by giving access attributes to each cell, row, and column of shared spreadsheet data. The present invention relates to a cell attribute management method that enables data protection of sheet data.

[Conventional technology]

When a table (spreadsheet) is displayed on the display and data is entered in grids (called cells) determined by the rows and columns of the table, subtotals, totals, etc. are automatically calculated, and the calculation results are displayed in the corresponding cells. Systems for displaying information are known. Such systems are called spreadsheet systems.

[Problem to be solved]

Traditional data protection for spreadsheet data was not necessary because the same spreadsheet data could not be shared simultaneously. If a conventional spreadsheet system is allowed to be used by multiple users at the same time, data protection for individual data in the spreadsheet system becomes necessary. For example, consider the case where the spreadsheet data consisting of the following data is used as a conference room reservation table.

Then, the data of the person who originally reserved the conference room could easily be overwritten by another person without data protection features. This makes it impossible to actually use it as a reservation system.

The present invention was created in view of this point, and it is an object of the present invention to provide a cell attribute management method that can prevent data, etc. that you do not want others to change from being changed by mistake.

[Means for solving problems]

FIG. 1 shows the configuration of one embodiment of the present invention. 1st
In the figure, 1 is a processor, 2 is a keyboard, and 3 is an R
AM, 4 is a display, 5 is a magnetic disk device, 6 is a data processing section, 7 is a display section, and 8 is a calculation section. A data input section 6 and a display section 7 are included in the processor 1.
, calculation unit 8, etc. are shown, but these are realized by executing a program in a ROM (not shown) by the processor 1. The keyboard 2 is used to input cell data and commands. RAM3 is used as a work area. A spreadsheet (synonymous with a table) is displayed on the display 4. The magnetic disk device 5 stores various spreadsheets. The data input unit 6 writes and updates data in cells of a spreadsheet in RAMa. Calculation part 8
calculates subtotals, totals, etc. based on data entered in a spreadsheet. The display section 7 is a RAM
The spreadsheet in a is displayed on the display 4.

FIG. 2 shows the data structure of the cell.

An 8-bit (1 byte) access attribute as shown in FIG. 2 is given to each cell. The contents of 1 byte are as follows. Bits o-3 are the owner number, bits 4-5 are the owner's read/write permission, and bits 6-7 are the read/write permission for anyone other than the owner. When the owner number is O, the owner of the cell is undetermined. Registering and deleting the owner number to the cell can be done at the same time as manually inputting data to the cell. That is, ■ Specify the address of the cell.

■ Select a command.

■ Execute the command.

This can be done by following the steps below. Commands include changing the owner, changing read/write permissions for the owner, and changing read/write permissions for people other than the owner. The initial value of the access attribute of spreadsheet data is the owner number 0, and the access attribute of the owner and others is read/write. Regarding the access attribute of each column and each row, an 8-bit access attribute is assigned to each column and each row, similar to the cell attribute. The owner number of each column and each row can also be registered in the same way as the owner number of a cell. The priority order among cells, rows, and columns is from the highest priority to the cell, row, and column.

FIG. 3 is a diagram explaining the structure of the user registration table. Up to 31 users can use the same spreadsheet data at the same time. Enter spreadsheet data and username when using the spreadsheet system. The system registers user names along with spreadsheet data and assigns user numbers starting from 1 to the user names in the order of registration. From now on, the system will use this user number. This is shown in FIG.

When a user requests the use of a spreadsheet, the display unit 7 refers to the user name, cell access attributes, row access attributes, and column access attributes, and displays the spreadsheet on the display 4 with unreadable cells blank. to be displayed. When a user wants to write data into a cell, he or she specifies the corresponding cell with the cursor and writes the data into the cell. When cell data is input, the data input unit 6 refers to the user name, cell access attribute, row access attribute, column access attribute, etc., and writes data to the cell only if writing is possible. If it is not possible, a message to that effect is displayed in the lower area of the display 4.

〔Effect of the invention〕

As is clear from the above explanation, according to the present invention,
Access attributes can be given to each cell, row, and column of spreadsheet data, which has the effect of simultaneous processing where multiple users can handle spreadsheet data at the same time.

[Brief explanation of drawings]

FIG. 1 is a diagram showing the configuration of an embodiment of the present invention, FIG. 2 is a diagram showing the data structure of a cell, and FIG. 3 is a diagram showing the structure of a user registration table. 1...Processor, 2...Keyboard, 3...R
A.M.

Claims (1)

[Claims] In a spreadsheet system that can be accessed simultaneously by multiple users, a cell attribute management method characterized in that each cell, row, and column of shared spreadsheet data has an access attribute for each user. .