KR20190135700A - Apparatus for protecting contents of spread sheet type electric document and operating method thereof - Google Patents

Abstract

According to the present invention, provided are an object protecting apparatus of a spread sheet electronic document and an operating method thereof. When an object protection request is input by a plurality of cells selected by an input device of a user among a plurality of cells of a spread sheet electronic document, first concatenation data is generated by concatenating the object of the plurality of selected cells based on location information of the plurality of selected cells, and a private key of the user is used and encrypted to generate encryption data to be stored, after the first concatenation data is hash-encrypted, so that the object for the plurality of cells selected by the input device of the user may be protected and the user can freely edit other cells.

Description

FIELD OF PROTECTING CONTENTS OF SPREAD SHEET TYPE ELECTRIC DOCUMENT AND OPERATING METHOD THEREOF

The present invention relates to a device for protecting a spreadsheet electronic document and a method of operating the same.

Electronic documents are unit information bodies that are made up of electronically written information, and are often created and distributed in file units. In addition, digital content, such as pictures, music, and videos, as well as text documents consisting solely of letters, is broadly an electronic document. Unlike paper documents, electronic documents are characterized by the ability to securely store information and greatly increase the document lifecycle (creation, utilization, storage, and disposal). Electronic documents are easier to edit than paper documents. The advantage of being easy to distribute is that it is advantageous to work collaboratively by multiple authors.

However, compared to paper documents, when an electronic document is modified, it is difficult to identify the difference between the original and the modified version, and does not have a physical substance. Therefore, there is a security problem that can be easily replicated, and can be modified and redistributed for the replica.

Therefore, in order to solve this security problem, various encryption technologies have been introduced in the case of electronic documents. However, despite the application of encryption technology, the security of the electronic document cannot be reliably guaranteed since the access to the electronic document can be obtained when a password is acquired.

In particular, when an electronic document is created by a plurality of authors and each of the plurality of authors owns the electronic document, there is a risk that the electronic document is edited or distributed without the consent of the entire author. In order to solve this risk, there is a technology that allows a user to view and edit a document only when a plurality of passwords are set and all passwords match, but there is still a possibility that the password can be solved by hacking.

In addition, when a plurality of passwords are set in the electronic document before the writing is completed, there is a inconvenience in that the user who edits the electronic document has to release the password and edit the electronic document. In addition, there is an inconvenience in using the password of the set password must be shared among co-editors.

Therefore, there has been a continuous demand for a technology that can facilitate the editing of electronic documents while protecting the modification, modification, and deletion of desired objects.

The apparatus for protecting an object of a spreadsheet electronic document and a method of operating the same according to the present invention, when the object protection request is input to a plurality of cells selected by a user input device among a plurality of cells of a spreadsheet electronic document, the selected plurality of cells Concatenates an entity of the plurality of cells in a concatenated order determined based on location information of the selected plurality of cells, generates first concatenated data, hash-encrypts the first concatenated data, and then encrypts it using the user's private key. By generating and storing encrypted data, the object can be protected for a plurality of cells selected by the user's input device, and the user wishes to support editing freely for other cells.

According to an embodiment of the present invention, when the object protection request is input to a plurality of cells selected by a user's input device among a plurality of cells of a spreadsheet electronic document, an object protection request is inputted. Concatenates an entity of the plurality of cells in a concatenated order determined based on location information of the selected plurality of cells, generates first concatenated data, hash-encrypts the first concatenated data, and then encrypts it using the user's private key. An encryption unit for generating encrypted data, a cell position data generation unit for generating cell position data by concatenating position information of the selected plurality of cells in the concatenated order, and concatenating the encrypted data and the cell position data to the spreadsheet Includes a metadata recorder for recording in the metadata area of the electronic document The.

In addition, if the object protection request is input to a plurality of cells selected by the user's input device of the plurality of cells of the spreadsheet electronic document according to an embodiment of the present invention, Concatenating the selected plurality of cells according to the concatenated order determined based on the location information of the selected plurality of cells to generate first concatenated data, hash encrypting the first concatenated data, and then storing the private key of the user. Generating encrypted data by encrypting using; concatenating position information of the selected plurality of cells in the concatenated order to generate cell position data; and concatenating the encrypted data and the cell position data by the spreadsheet; Recording in the metadata area of the electronic document.

The apparatus for protecting an object of a spreadsheet electronic document and a method of operating the same according to the present invention, when the object protection request is input to a plurality of cells selected by a user input device among a plurality of cells of a spreadsheet electronic document, the selected plurality of cells Concatenates an entity of the plurality of cells in a concatenated order determined based on location information of the selected plurality of cells, generates first concatenated data, hash-encrypts the first concatenated data, and then encrypts it using the user's private key. By generating and storing encrypted data, the object can be protected for a plurality of cells selected by the user's input device, and the user can freely edit other cells.

1 is a diagram illustrating a configuration of an object protection apparatus for a spreadsheet electronic document according to an embodiment of the present invention.
2 is a flowchart illustrating a method of operating an object protection apparatus of a spreadsheet electronic document according to an embodiment of the present invention.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings. This description is not intended to limit the invention to the specific embodiments, it should be understood to include all changes, equivalents, and substitutes included in the spirit and scope of the invention. In describing the drawings, similar reference numerals are used for similar components, and unless otherwise defined, all terms used in the present specification, including technical or scientific terms, may be used in the art to which the present invention pertains. It has the same meaning as is commonly understood by someone who has it.

1 is a diagram illustrating a configuration of an object protection apparatus 100 for a spreadsheet electronic document according to an embodiment of the present invention.

As shown in FIG. 1, the apparatus 100 for protecting a spreadsheet electronic document according to an embodiment of the present invention may include an encryption unit 110, a cell position data generation unit 120, and a metadata recording unit 130. It may include.

First, the encryption unit 110 requests an object protection request for a plurality of cells selected by the user's input device 115 among a plurality of cells of a spreadsheet electronic document stored in the storage unit 111 as shown in Table 1 below. When input, the object of the plurality of selected cells is concatenated according to a first concatenated order determined based on the location information of the selected plurality of cells to generate first concatenated data, and hash-encrypts the first concatenated data. The encrypted data may be generated by encrypting the private key of the user. Herein, the object refers to data (eg, an expression) recorded in a cell such as text.

turn Location information Equation Formula result Cell 1 A1 3 3 Cell 2 A2 = sum (B1, B2) 22 Cell 3 B1 4 4 Cell 4 B2 = sum (C1, C2) 18 Cell 5 C1 5 5 Cell 6 C2 = sum (D1, D2) 13 Cell 7 D1 6 6 Cell 8 D2 7 7 ... ... ... ...

Here, the position information may be composed of an alpha-numeric structure indicating the position of the row and column of the cell at the same time, such as A1, A2, B1, and B2, and the alphabet, such as A and B, indicates the position of the column. The same number can indicate the position of a row. In addition, the concatenation order may be determined according to the ascending order of the alphabet representing the column of the location information, and may be determined according to the ascending order of the numbers representing the row between the alphabets representing the same column. For example, when the plurality of cells selected by the user's input device 115 are A1, A2, B1, and B2, the concatenated order may be determined in the order of A1, A2, B1, and B2. When the object protection request is input to the cells 1 to 4 by the user's input device 115 of the plurality of cells of the sheet electronic document, the cell 1 according to the first concatenated order determined based on the location information of the cells 1 to 4. Concatenates 4 to 4 to generate first concatenated data such as 3 = sum (B1, B2) 4 = sum (C1, C2), hash encrypts the first concatenated data, and then uses the user's private key. Can be encrypted to generate encrypted data.

In addition, when there are a plurality of reference cells to which the selected plurality of cells directly and / or indirectly refer, the encryption unit 110 includes a plurality of first cells that are not included in the selected plurality of cells among the plurality of reference cells. Selecting reference cells, and generating the second concatenated data by concatenating objects of the plurality of first reference cells according to a second concatenated order determined based on location information of the plurality of first reference cells. The concatenated data may be concatenated to the first concatenated entity data, hash encrypted the concatenated first and second concatenated data, and then encrypted using the private key of the user to generate encrypted data. Here, the reference cell refers to a cell in which the formula result of another cell fluctuates according to the change of its formula result, the direct reference cell is a cell having a reference distance of 1, and an indirect reference cell may be a cell having a reference distance of 2 or more. have. On the other hand, when the cell A refers to the cell B, the reference distance is 1, and when the cell B refers to the cell C, the reference distance between the cells A and C is 1. For example, referring to Table 1, cells 3 and 4 are direct reference cells with a reference distance of 1 for cell 2, cells 5 and 6 are direct reference cells with a reference distance of 1 for cell 4, and cell 6 For cells 7 and 8 are direct reference cells with a reference distance of 1, for cells 2 cells 5 and 6 are indirect reference cells with a reference distance of 2, and cells 7 and 8 are indirect reference cells with a reference distance of 3. .

For example, if an object protection request is input for cells 1 to 4 by a user's input device 115 of a plurality of cells of a spreadsheet electronic document, the cells 2 and 4 are the reference cells that are directly and / or indirectly referenced. Cells 5 to 8 that are not included in cells 1 to 4, which are selected cells of 3 to 8, are selected, and the individuals of cells 5 to 8 (ie, 5, = sum (D1, D2), 6, and = sum (E1, E2)). ) Is concatenated according to the second concatenation order determined based on the position information of the reference cells to generate second concatenated data such as 5 = sum (D1, D2) 6 = sum (E1, E2), and the first concatenation. The second concatenated data may be concatenated and hash encrypted at the end of the entity data, and then encrypted using the private key of the user to generate encrypted data.

If the number of the plurality of first reference cells exceeds a preset number according to the document size of the spreadsheet electronic document, the encryption unit 110 may refer to the reference distance based on the reference distance of each of the plurality of first reference cells. Extracts a plurality of second reference cells up to the predetermined number of the plurality of first reference cells in a low order, and based on location information of the plurality of second reference cells Concatenate according to the third concatenated order determined to generate third concatenated data, concatenate the third concatenated data to the first concatenated entity data, and hash-encrypt the first and third concatenated data. Afterwards, the encrypted data may be generated by using the private key of the user. On the other hand, the encryption unit 110, the number of first reference cells having a reference distance of 1 to N exceeds the preset number, the number of first reference cells having a reference distance of 1 to N-1 is When not exceeding a preset number, first reference cells having a reference distance of 1 to N-1 may be extracted as the plurality of second reference cells. Here, N is an integer of 2 or more.

Here, the preset number corresponds to a value obtained by dividing a conversion value (data size assigned to cell position information) by a data size according to a preset ratio (eg, 1%) of the data size of the spreadsheet electronic document. It can be determined by the number. In addition, the encryption unit 110 may assign a predetermined weight according to the ratio of the selected plurality of cells of the plurality of cells of the spreadsheet electronic document to a data size according to a preset ratio of the data size of the spreadsheet electronic document. The corresponding number can be increased by multiplying the converted value by the divided value. For example, when the ratio of the selected plurality of cells among the plurality of cells is 0 or more and less than 0.3, the preset weight is 1, and when 0.3 or more and less than 0.6, the preset weight is 1.3, and when 0.6 or more, the preset weight is 1.6 Can be.

For example, the ratio of the selected plurality of cells of the plurality of cells of the spreadsheet electronic document is less than 0.3 (ie, the weight is 1), the data size of the spreadsheet electronic document is 1500 bytes, and the preset ratio is 1%, and when the converted value, that is, the data size allocated to the cell location information is 4 bytes, the preset number may be predetermined as 3.75. In this case, when the number of the plurality of first reference cells (ie, cells 5 to 8) is four, the number of first reference cells (that is, cells 5 to 8) having a reference distance of 1 to 2 is set in advance. Since the number (ie, 2) of the first reference cells (ie, cells 5 and 6) exceeding the number (ie, 3.75) and having a reference distance of 1 does not exceed the preset number, the encryption unit 110 ) May extract cells 5 and 6 having a reference distance of 1 into the plurality of third reference cells.

Next, the cell position data generation unit 120 may generate first cell position data by concatenating position information of the selected plurality of cells in the first concatenation order.

In this case, when the first reference cells exist, the cell position data generation unit 120 concatenates the position information of the plurality of first reference cells to the first cell position data according to the second concatenated order to perform second concatenation. Cell position data can be generated.

In addition, when the number of the plurality of first reference cells exceeds a preset number and the second reference cells are extracted, the cell position data generator 120 may add the plurality of first reference cells to the first cell position data. The third cell position data may be generated by concatenating position information of two reference cells in the third concatenation order.

The metadata recording unit 130 may concatenate the encrypted data and the first cell position data and record the metadata in the metadata area of the spreadsheet electronic document.

Meanwhile, when the first reference cells exist, the metadata recording unit 130 may concatenate the encrypted data and the second cell location data and record the metadata in the metadata area of the spreadsheet electronic document.

In addition, when the number of the plurality of first reference cells exceeds a preset number, and the second reference cells are extracted, the metadata recording unit 130 concatenates the encrypted data and the third cell position data so that the second reference cells are extracted. You can write to the metadata area of a spreadsheet electronic document.

After the encrypted data and the cell position data are recorded in the metadata area of the spreadsheet electronic document, an editing command for the first cell having the position information included in the cell position data is received through the input device 115. When input, the change check unit 140 confirms whether the object of the first cell is changed by the editing command, and after the target cell of the editing command is made, the object of the first cell by the editing command. If is confirmed to be changed, the pop-up generating unit 141 is notified that the object of the first cell is changed by the editing command, the pop-up generating unit 141 to the user through the display unit 145 the editing The display may display a pop-up screen inquiring whether the object of the first cell is changed by the command and whether the corresponding editing command is in progress. Accordingly, the user may select whether to proceed with the corresponding editing command through the input device 115.

On the other hand, after the encrypted data and the cell position data are recorded in the metadata area of the spreadsheet electronic document, editing of the spreadsheet electronic document is completed, and thereafter, the spreadsheet electronic document is transmitted through the input device 115. When a view request for a document is input, the change whether checking unit 140 selects cells according to a concatenating order of position information included in the cell position data of the meta data area of the spreadsheet electronic document and selects the concatenating order. Compare the hashed value of the object of the selected cells with the encrypted data of the metadata area of the spreadsheet electronic document with a value decrypted using the public key of the user to determine whether the object of the cells has changed. Can be. Then, when it is confirmed that the object of the cells has been changed, the pop-up generating unit 141 is notified that the object of the cells has been changed by the editing command, the pop-up generating unit 141 through the display unit 145 The user may display a pop-up screen indicating that the object of the cells has been changed and that the object is released from protection. Thereafter, the metadata recording unit 130 may delete the encrypted data and the cell position data in the metadata area of the spreadsheet electronic document.

2 is a flowchart illustrating a method of operating an object protection apparatus 100 of a spreadsheet electronic document according to an embodiment of the present invention.

Referring to FIG. 2, in step S210, when an object protection request is input to a plurality of cells selected by a user's input device among a plurality of cells of a spreadsheet electronic document, an object of the selected plurality of cells is selected. The first concatenated data may be generated by concatenating according to the concatenated order determined based on the location information of the cells of the cell, and the first concatenated data may be hash-encrypted and then encrypted by using the user's private key to generate encrypted data. have.

In step S210, when there are a plurality of reference cells referenced by the selected plurality of cells, a plurality of first reference cells that are not included in the selected plurality of cells among the plurality of reference cells are selected, and the plurality of reference cells are selected. Generating second concatenated data by concatenating the entities of the first reference cells of the second reference cells according to a second concatenated order determined based on the positional information of the plurality of first reference cells, and generating the second concatenated data to the first concatenated entity data. The data may be concatenated, the first and second concatenated data may be hash-encrypted, and then encrypted using the private key of the user to generate encrypted data.

In the step S210, if the number of the plurality of first reference cells exceeds a preset number, the preset number of the plurality of first reference cells is less than or equal to the reference number of each of the plurality of first reference cells. Extracts a plurality of second reference cells of the plurality of second reference cells, and generates the third concatenated data by concatenating the entities of the plurality of second reference cells according to a third concatenated order determined based on location information of the plurality of second reference cells; The third concatenated data may be concatenated to the first concatenated entity data, and the first and third concatenated data may be hash-encrypted and then encrypted using the private key of the user to generate encrypted data.

In step S220, when the first concatenated data is hash-encrypted in step S210, and then encrypted using the user's private key to generate encrypted data, the location information of the selected plurality of cells is stored in the concatenated order. Accordingly, the first cell position data may be generated by concatenating them.

In step S220, if the second concatenated data is concatenated to the first concatenated entity data in step S210, and then encrypted using the private key of the user to generate encrypted data, the first cell position The second cell position data may be generated by concatenating position information of the plurality of first reference cells with data in the second concatenation order.

In the step S220, when the number of the plurality of first reference cells exceeds a preset number, and the second reference cells are extracted, that is, in the step S210, the first concatenated entity data is added to the first connection entity data. When the concatenated data is concatenated and encrypted data is generated using the private key of the user, the encrypted data is generated by concatenating the position information of the plurality of second reference cells to the first cell position data according to the third concatenated order. To generate the third cell position data.

In operation S230, when the first cell location data is generated in step S220, the encrypted data and the first cell location data may be concatenated and recorded in the metadata area of the spreadsheet electronic document.

In operation S230, when the second cell position data is generated in operation S220, the encrypted data and the second cell position data may be concatenated and recorded in the metadata area of the spreadsheet electronic document.

In operation S230, when the third cell location data is generated in operation S220, the encrypted data and the third cell location data may be concatenated and recorded in the metadata area of the spreadsheet electronic document.

The operating method of the apparatus for preventing forgery of a spreadsheet electronic document according to an embodiment of the present invention has been described above with reference to FIG. 2. Here, the operation method of the anti-counterfeiting apparatus of the spreadsheet electronic document according to an embodiment of the present invention may correspond to the configuration of the operation of the anti-counterfeiting apparatus of the spreadsheet electronic document described with reference to FIG. Detailed description will be omitted.

The method of operating the apparatus for preventing forgery of a spreadsheet electronic document according to an embodiment of the present invention may be implemented as a computer program stored in a storage medium for execution by combining with a computer.

In addition, the method of operating the apparatus for preventing forgery of a spreadsheet electronic document according to an embodiment of the present invention may be implemented in the form of program instructions that can be executed by various computer means and recorded in a computer readable medium. The computer readable medium may include program instructions, data files, data structures, etc. alone or in combination. Program instructions recorded on the media may be those specially designed and constructed for the purposes of the present invention, or they may be of the kind well-known and available to those having skill in the computer software arts. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tape, optical media such as CD-ROMs, DVDs, and magnetic disks, such as floppy disks. Magneto-optical media, and hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, flash memory, and the like. Examples of program instructions include not only machine code generated by a compiler, but also high-level language code that can be executed by a computer using an interpreter or the like.

In the present invention as described above has been described by the specific embodiments, such as specific components and limited embodiments and drawings, but this is provided to help a more general understanding of the present invention, the present invention is not limited to the above embodiments. For those skilled in the art, various modifications and variations are possible from these descriptions.

Therefore, the spirit of the present invention should not be limited to the described embodiments, and all of the equivalents and equivalents of the claims as well as the claims to be described later belong to the scope of the present invention. .

Claims (10)

When an object protection request is input to a plurality of cells selected by a user's input device among a plurality of cells of a spreadsheet electronic document, an object of the selected plurality of cells is determined based on location information of the selected plurality of cells. An encryption unit for generating first concatenated data by concatenating according to a concatenated order, and encrypting the first concatenated data by encrypting it using a private key of the user;
A cell position data generation unit configured to generate first cell position data by concatenating position information of the selected plurality of cells in the first concatenation order; And
A metadata recording unit which concatenates the encrypted data and the first cell position data and records the metadata in the metadata area of the spreadsheet electronic document.
Object protection device of the spreadsheet electronic document. The method of claim 1,
If there are a plurality of reference cells referenced by the selected plurality of cells, the encryption unit selects a plurality of first reference cells that are not included in the selected plurality of cells among the plurality of reference cells, and the plurality of first cells. Concatenating objects of reference cells according to a second concatenation order determined based on location information of the plurality of first reference cells to generate second concatenated data, and concatenating the second concatenated data to the first concatenated entity data. And hash encrypting the first and second concatenated data and then encrypting the data using the private key of the user to generate encrypted data.
The cell position data generator generates second cell position data by concatenating the position information of the plurality of first reference cells with the first cell position data in the second concatenated order.
The metadata recording unit concatenates the encrypted data and the second cell position data and records the metadata in the metadata area of the spreadsheet electronic document.
Object protector in spreadsheet electronic documents. The method of claim 2,
If the number of the plurality of first reference cells exceeds a preset number, the encryption unit may include a plurality of the plurality of first reference cells less than or equal to the preset number based on a reference distance of each of the plurality of first reference cells. Extracting second reference cells and concatenating the entities of the plurality of second reference cells according to a third concatenating order determined based on location information of the plurality of second reference cells to generate third concatenated data; Concatenating the third concatenated data to first concatenated entity data, hash encrypting the first and third concatenated data, and encrypting using the private key of the user to generate encrypted data;
The cell position data generation unit, when the number of the plurality of first reference cells exceeds a preset number and the second reference cells are extracted, the position information of the plurality of second reference cells in the first cell position data. Concatenate according to the third concatenation order to generate third cell position data,
The metadata recording unit concatenates the encrypted data and the third cell location data and records the metadata in the metadata area of the spreadsheet electronic document.
Object protector in spreadsheet electronic documents. The method of claim 3,
The preset number is a number corresponding to a preset ratio of the data size of the spreadsheet electronic document.
Object protector in spreadsheet electronic documents. When an object protection request is input for a plurality of cells selected by a user's input device among a plurality of cells of a spreadsheet electronic document, a concatenation for determining an object of the selected plurality of cells based on location information of the selected plurality of cells. Generating first concatenated data by concatenating according to a sequence, and encrypting the first concatenated data by using a private key of the user to generate encrypted data;
Generating first cell position data by concatenating position information of the selected plurality of cells in the concatenation order; And
Concatenating the encrypted data and the first cell location data and writing them to a metadata area of the spreadsheet electronic document
Operating method of the object protector of the electronic document in the spreadsheet. The method of claim 5,
The generating of the encrypted data may select a plurality of first reference cells that are not included in the selected plurality of cells among the plurality of reference cells when there are a plurality of reference cells referenced by the selected plurality of cells. Generating second concatenated data by concatenating the entities of the first reference cells of the second reference cells according to a second concatenated order determined based on the positional information of the plurality of first reference cells and generating the second concatenated data. Concatenate data, hash-encrypt the first and second concatenated data, and then encrypt the data using the private key of the user to generate encrypted data,
In the generating of the cell position data, second cell position data is generated by concatenating position information of the plurality of first reference cells with the first cell position data in the second concatenated order.
In the recording of the metadata, the encrypted data and the second cell position data are concatenated and recorded in the metadata area of the spreadsheet electronic document.
How object protectors work in spreadsheet electronic documents. The method of claim 6,
The generating of the encrypted data may be performed when the number of the plurality of first reference cells exceeds a preset number, based on a reference distance of each of the plurality of first reference cells. Extracts a plurality of second reference cells of the plurality of second reference cells, and generates the third concatenated data by concatenating the entities of the plurality of second reference cells according to a third concatenated order determined based on location information of the plurality of second reference cells; And concatenate the third concatenated data to the first concatenated entity data, hash encrypt the first and third concatenated data, and then encrypt the data using the private key of the user to generate encrypted data.
The generating of the cell position data may include: when the second reference cells are extracted because the number of the plurality of first reference cells exceeds a preset number, the positions of the plurality of second reference cells in the first cell position data. Concatenate information according to the third concatenation order to generate third cell position data,
In the metadata recording step, the encrypted data and the third cell location data are concatenated and recorded in the metadata area of the spreadsheet electronic document.
How object protectors work in spreadsheet electronic documents. The method of claim 7, wherein
The preset number is a number corresponding to a preset ratio of the data size of the spreadsheet electronic document.
How object protectors work in spreadsheet electronic documents. A computer readable recording medium having recorded thereon a program for causing a computer to perform the method of any one of claims 5 to 8. A computer program stored in a storage medium for executing the method of any one of claims 5 to 8 in combination with a computer.

Images