JP2012027864A - Spreadsheet control program, spreadsheet control device and spreadsheet control method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a spreadsheet control program and the like that can be used by a simple operation, is applicable to a standalone computer as well, and controls inputting of values into cells of a spreadsheet or the like.SOLUTION: In a spreadsheet control program, with respect to some format in formatting cells of a spreadsheet, such as background coloring or halftone dot meshing, values such as a specific color index is defined so that inputting or pasting of the values into cells is prohibited, and values in the cells are defined so that copying of values is prohibited. When an instruction to input a value into a cell or the like is detected, it is determined whether or not a cell is the cell into which inputting od the value or the like is prohibited based on such formatting. The processing is suspended when inputting of the value or the like is prohibited. The suspension of the processing is performed by deleting values on a clipboard when copying or pasting of the value is prohibited.

Description

  The present invention relates to a spreadsheet control program, a spreadsheet control apparatus, and a spreadsheet control method for controlling the input or paste of values into spreadsheet cells or the copying of values in spreadsheet cells.

  An invention relating to a computer system for creating a standard form or the like used in various businesses such as a company, storing a format such as a tabular form in a database, and reading out the form to create a standard form or the like It is disclosed (for example, see Patent Document 1). An invention using a spreadsheet (sheet of spreadsheet software) for data input when creating such a form or the like is disclosed (for example, see Patent Document 2).

  On the other hand, with the enactment of the Financial Instruments and Exchange Law, various documents created in the business of companies are subject to internal control. Among these, when using spreadsheets, there are inherent risks such as tampering and miscalculations, and errors in calculation formulas are easily overlooked, so proper management of documents created using spreadsheets is difficult. It is to be required (see, for example, Non-Patent Document 1).

  For this reason, when creating a form or the like using a spreadsheet, it is necessary to provide a mechanism for dealing with erroneous data input or falsification. In order to prevent incorrect input and falsification to the spreadsheet, it is preferable to set the cell that you want to prevent value changes in the form format to not allow entry or update of values. In addition to prohibiting the input of a value to a predetermined cell using the macro function of the above, an invention is disclosed in which a setting for prohibiting the movement of the cursor to a cell whose input is to be prohibited is disclosed (for example, Patent Document 3). reference).

JP-A-8-202778 JP 2003-15920 A JP-A-8-137659

Glossary of “Spreadsheet Control”, Wikipedia homepage, [Search July 5, 2010], Internet <http://en.wikipedia.org/wiki/Spreadsheet Control>

  As described above, when it is desired to prohibit processing such as value input for some cells of the spreadsheet, the macro function of the spreadsheet software may be used. However, in order to make such settings, specialized knowledge such as macro functions is required. Therefore, in order to improve the convenience of the user, only general knowledge of spreadsheet software is available. Even if it exists, it is preferable that such a setting can be performed.

  In addition, in order to reduce the burden on the user, there is also a method in which spreadsheet software is provided in the so-called cloud format that has become popular in recent years, and settings such as input prohibition are executed on the server side in accordance with instructions from the client. Conceivable. However, since these systems are premised on system usage via a network, there is a problem that the usage mode is limited. In addition, the server-based method has a problem that the processing speed depends on the network speed and the server access status, and the processing speed is inferior to the client-based method.

  The present invention has been made in order to cope with such a problem, and can be used by a user with a simple operation and can be applied to a computer used in a stand-alone manner. It is an object of the present invention to provide a spreadsheet control program, a spreadsheet control device, and a spreadsheet control method for controlling the input or paste of values into the cells of the sheet or the copying of the values of the cells of the spreadsheet.

  The present invention relates to any format in cell formatting of a spreadsheet, such as a background color or shading, for example, a specific color index value, a value input prohibition or a paste prohibition in a cell, or the cell It is characterized in that the problem relating to the present application is solved by determining that the value input is prohibited and determining the cell from which the value input is prohibited from these format settings.

  A first invention for solving the problem according to the present application is a program for controlling input of a value to a cell of a spreadsheet, and the program has a value of any format in the formatting of the cell of the spreadsheet. An input command for detecting an input command for inputting a value into a cell of a spreadsheet on a computer that is defined as a value indicating prohibition of input of a value into the cell and is executing a spreadsheet program for editing the spreadsheet An input for determining whether a value defined as a value indicating prohibition of input is set in a predetermined format of the cell with reference to a detection step and a format setting of the cell in which the input command is detected in the input command detection step When it is determined that a value defined as a value indicating input prohibition is not set in the prohibition determination step and the input prohibition determination step, the input A spreadsheet control program, characterized in that to execute the input permission step of permitting an input to the cell of the input value from the instruction, the.

  According to the first invention, by defining the value of any format in the cell format setting of the spreadsheet as the prohibition of the input of the value to the cell, the value defined as the prohibition of input is set in the predetermined format. Whether or not to allow input of a value to the cell can be determined.

  A second invention for solving the problem of the present application is a program for controlling the paste of a value to a cell of a spreadsheet, wherein the program has a value of any format in the formatting of the spreadsheet cell. , A paste command for detecting a paste command for pasting a value into a spreadsheet cell on a computer that is defined as a value indicating that the value is prohibited from being pasted into the cell and is running a spreadsheet program for editing the spreadsheet A paste for determining whether a value defined as a value indicating paste prohibition is set in a predetermined format of the cell with reference to a detection step and formatting of the cell in which the paste command is detected in the paste command detection step Defined as a value indicating paste prohibition in the prohibition determination step and the pace prohibition determination step When There is judged not to be set, a spreadsheet control program, characterized in that to execute a paste permission step of permitting the paste to the cell of the value stored in the clipboard, a.

  According to the second invention, by defining the value of one of the formats in the cell formatting of the spreadsheet as prohibition of pasting the value to the cell, the value defined as prohibition of pasting is set in the predetermined format. Whether or not to allow pasting of values into cells can be determined.

  A third invention for solving the problem according to the present application is a program for controlling paste of a value to a cell of a spreadsheet, wherein the program has a value of any format in the formatting of the cell of the spreadsheet. , A paste command for detecting a paste command for pasting a value into a spreadsheet cell on a computer that is defined as a value indicating that the value is prohibited from being pasted into the cell and is running a spreadsheet program for editing the spreadsheet A paste for determining whether a value defined as a value indicating paste prohibition is set in a predetermined format of the cell with reference to a detection step and formatting of the cell in which the paste command is detected in the paste command detection step Defined as a value indicating paste prohibition in the prohibition determination step and the pace prohibition determination step When There is judged to be set, a spreadsheet control program, characterized in that to execute a paste prohibiting step of erasing the value stored in the clipboard, a.

  According to the third invention, by defining the value of any format in the cell formatting of the spreadsheet as prohibition of pasting the value to the cell, the value defined as prohibition of pasting is set in the predetermined format. Whether or not to paste the value into the cell can be determined depending on whether or not, and when the paste is prohibited, the paste operation is stopped by executing the process of erasing the clipboard value. It is possible to automatically prohibit the paste without executing the process for making it happen.

  4th invention which solves the subject concerning this application is a program which controls the copy of the value of the cell of a spreadsheet, and the value of any format in the format setting of the cell of a spreadsheet contains the above-mentioned program, A copy command detection step for detecting a copy command for copying a cell value of a spreadsheet to a computer that is defined as a value indicating that copying of the cell value is prohibited and that executes a spreadsheet program for editing the spreadsheet A copy prohibition determination that refers to the format setting of the cell in which the copy command is detected in the copy command detection step and determines whether a value defined as a value indicating copy prohibition is set in the predetermined format of the cell Step and a value defined as a value indicating copy prohibition in the copy prohibition determination step is determined not to be set. Once a spreadsheet control program, characterized in that to execute a copy permission step that allows to store the value of the cell in which the copy instruction is detected in the clipboard.

  According to the fourth invention, whether a value defined as copy prohibition is set in a predetermined format by defining any format value in the cell format setting of the spreadsheet as copy prohibition of the cell value. Whether or not copying of the cell value is permitted can be determined.

  A fifth invention for solving the problem according to the present application is a program for controlling copying of a cell value of a spreadsheet, wherein the program has a value of any format in the cell formatting of the spreadsheet, Copy detection that detects that the value of the cell in the spreadsheet has been copied to the clipboard on a computer running a spreadsheet program that edits the spreadsheet, defined as a value that prohibits copying the cell value A copy prohibition for determining whether a value defined as a value indicating copy prohibition is set in a predetermined format of the cell with reference to the formatting of the cell whose value is copied to the clipboard in the copy detection step A value defined as a value indicating copy prohibition in the determination step and the copy prohibition determination step is set. If it is determined that a spreadsheet control program, characterized in that to execute a copy prohibition step of erasing the copied value to the clipboard, the.

  According to the fifth invention, by defining the value of one of the formats in the cell format setting of the spreadsheet as copy prohibition of the cell value, is a value defined as copy prohibition set in the predetermined format? It is possible to determine whether or not to prohibit copying of cell values, and to monitor the copy to the clipboard, and when copying is prohibited, execute the process of erasing the clipboard value. Copy prohibition can be automatically realized without causing the calculation program to execute a process for stopping the copy.

  Further, the present invention, when detecting an instruction to open a spreadsheet in the computer, determines whether the spreadsheet is a spreadsheet to be controlled by inputting or pasting a value into a cell or copying a cell value. And a copy creation step for creating a copy of the spreadsheet that is opened as an edit target by the command when it is determined that the spreadsheet is a control target in the control target determination step. In the input prohibition determination step, the paste prohibition determination step, or the copy prohibition determination step, whether or not a value defined as a value indicating input prohibition, paste prohibition, or copy prohibition is set is determined by the copy creation A copy of the spreadsheet created in the step It may also be characterized in that is made with reference to the format of the corresponding cell.

  When such processing is executed, by using a copy of the spreadsheet, it is judged that input is prohibited by referring to the formatting when the spreadsheet is opened, so the formatting changes while editing the spreadsheet Even if it is done, the predetermined processing can be prohibited according to the initial setting.

  Further, the present invention provides a save command detecting step for detecting a save command for the spreadsheet being edited, a cell value is extracted from the spreadsheet being edited in which the save command is detected in the save command detecting step, and the copy creating step A spreadsheet saving step of overwriting a cell copy taken from the spreadsheet being edited on the copy of the spreadsheet created in step, and saving the updated data of the spreadsheet being edited. Good.

  When such a process is executed, when the edited spreadsheet is saved, the updated value is overwritten on the copy created when the spreadsheet is opened. The spreadsheet can be saved in the original state.

  Furthermore, the present invention refers to the cell format setting for the cell whose value is extracted from the spreadsheet being edited in which the save command is detected in the save command detection step, and input prohibition or paste to the predetermined format of the cell. An update prohibition determination step for determining whether a value defined as a value indicating prohibition is set, and it is determined that a value defined as a value indicating input prohibition or paste prohibition is set in the update prohibition determination step. Then, in the spreadsheet saving step, an overwrite stop step for stopping overwriting of the value extracted from the cell to the copy of the spreadsheet may be executed.

  When such a process is executed, when the edited spreadsheet is saved, the determination of prohibition of input is performed again, so that a double check can be applied to strengthen countermeasures against erroneous input and falsification.

  The present invention can also be specified as a spreadsheet control device provided with the spreadsheet control program according to the present invention.

  A spreadsheet control device corresponding to the first invention is a device for controlling the input of a value to a cell of a spreadsheet, wherein the value of any format in the formatting of the spreadsheet cell is input to the cell. A prohibition information storage means for defining and storing a value indicating a value input prohibition, an input instruction detection means for detecting an input instruction for inputting a value into a spreadsheet cell, and the input instruction is detected by the input instruction detection means. Input prohibition determining means for referring to the cell format setting and determining whether a value defined as a value indicating input prohibition in the prohibition information storage means is set in the predetermined format of the cell; and the input prohibition determination An input permission means for permitting input of the input value to the cell by the input command when it is determined that a value defined as a value indicating input prohibition is not set by the means A spreadsheet control device, characterized in that it comprises a.

  A spreadsheet control device corresponding to the second invention is a device for controlling the paste of a value to a cell of a spreadsheet, wherein the value of any format in the formatting of the cell of the spreadsheet is transferred to the cell. Prohibition information storage means for defining and storing a value indicating that a value is prohibited to paste, paste instruction detection means for detecting a paste instruction for pasting a value into a cell of a spreadsheet, and a paste instruction is detected by the paste instruction detection means A paste prohibition judging means for judging whether or not a value defined as a value indicating paste prohibition is set in the prohibition information storage means in the predetermined format of the cell with reference to the cell format setting, and the pace prohibition judgment If it is determined by the means that the value defined as a value indicating paste prohibition is not set, it is stored in the clipboard. A paste permitting means for permitting the paste to the cell value, a spreadsheet control device, characterized in that it comprises a.

  A spreadsheet control device corresponding to the third invention is a device for controlling the paste of a value to a cell of a spreadsheet, wherein the value of any format in the formatting of the cell of the spreadsheet is transferred to the cell. Prohibition information storage means for defining and storing a value indicating that a value is prohibited to paste, paste instruction detection means for detecting a paste instruction for pasting a value into a cell of a spreadsheet, and a paste instruction is detected by the paste instruction detection means A paste prohibition judging means for judging whether or not a value defined as a value indicating paste prohibition is set in the prohibition information storage means in the predetermined format of the cell with reference to the cell format setting, and the pace prohibition judgment If it is determined by the means that a value defined as a value indicating paste prohibition is set, it is stored in the clipboard. A paste inhibiting means for erasing the value, a spreadsheet control device, characterized in that it comprises a.

  A spreadsheet control device corresponding to a fourth invention is a device for controlling copying of a cell value of a spreadsheet, wherein the value of any one of the formats of the cell of the spreadsheet is set to the value of the cell. Prohibition information storage means defined and stored as a value indicating copy prohibition, a copy instruction detection means for detecting a copy instruction for copying a value of a spreadsheet cell, and a cell in which a copy instruction is detected by the copy instruction detection means A copy prohibition determining unit that determines whether a value defined as a value indicating copy prohibition is set in the prohibition information storage unit in the predetermined format of the cell, and the copy prohibition determination unit If it is determined that a value defined as a value indicating copy prohibition is not set, the value of the cell in which the copy command is detected is clipped. A copy permission means for permitting be stored in de, a spreadsheet control device, characterized in that it comprises a.

  A spreadsheet control device corresponding to a fifth aspect of the invention is a device for controlling copying of cell values of a spreadsheet, wherein a value of one of the formats in spreadsheet cell formatting is set to the value of the cell. Prohibition information storage means defined and stored as a value indicating copy prohibition, copy detection means for detecting that the value of a spreadsheet cell has been copied to the clipboard, and the copy detection means copied the value to the clipboard A copy prohibition determining unit that refers to cell format setting and determines whether a value defined as a value indicating copy prohibition is set in the prohibition information storage unit in the predetermined format of the cell; and the copy prohibition determination unit If it is determined that the value defined as the value indicating that copying is prohibited is set, the value copied to the clipboard is deleted. And the copy inhibiting means for a spreadsheet control device, characterized in that it comprises a.

  The present invention can also be specified as a spreadsheet control method executed by a spreadsheet control program.

  A spreadsheet control method corresponding to the first invention is a method for controlling the input of a value to a cell of a spreadsheet, and the value of any one of the formatting in the spreadsheet cell is transferred to the cell. A prohibition information storage means that defines and stores a value indicating that input of a value is prohibited is stored, and a computer running a spreadsheet program that edits the spreadsheet detects an input command that inputs a value into a spreadsheet cell. An input command detecting step, and the computer refers to the format setting of the cell in which the input command is detected in the input command detecting step, and sets a predetermined format of the cell as a value indicating input prohibition in the prohibition information storage means An input prohibition determination step for determining whether a defined value is set, and the computer inputs in the input prohibition determination step An input permission step for allowing an input value to be input to the cell by the input command when it is determined that a value defined as a value indicating stop is not set. It is a control method.

  A spreadsheet control method corresponding to the second invention is a method for controlling paste of a value to a cell of a spreadsheet, and the value of any one of the formatting of the spreadsheet cell is transferred to the cell. A computer that is running a spreadsheet program that edits the spreadsheet detects a paste command that pastes the value into a spreadsheet cell. A paste command detection step, and the computer refers to the format setting of the cell in which the paste command is detected in the paste command detection step, and sets a predetermined format of the cell as a value indicating paste prohibition in the prohibition information storage means A paste prohibition determining step for determining whether a defined value is set; However, if it is determined that the value defined as the paste prohibition value is not set in the pace prohibition determination step, a paste permission step for permitting the paste of the value stored in the clipboard to the cell; A spreadsheet control method characterized by comprising:

  A spreadsheet control method corresponding to the third aspect of the invention is a method for controlling the paste of a value into a cell of a spreadsheet, wherein the value of any format in the spreadsheet cell formatting is transferred to the cell. A computer that is running a spreadsheet program that edits the spreadsheet detects a paste command that pastes the value into a spreadsheet cell. A paste command detection step, and the computer refers to the format setting of the cell in which the paste command is detected in the paste command detection step, and sets a predetermined format of the cell as a value indicating paste prohibition in the prohibition information storage means A paste prohibition determining step for determining whether a defined value is set; However, when it is determined in the pace prohibition determining step that a value defined as a value indicating paste prohibition is set, there is a paste prohibiting step for erasing the value stored in the clipboard. This is a spreadsheet control method.

  A spreadsheet control method corresponding to the fourth invention is a method for controlling copying of a cell value of a spreadsheet, wherein the value of any one of the formatting in the spreadsheet cell is set to the value of the cell. A copy having a prohibition information storage means for defining and storing a value indicating copy prohibition of a document, and a computer on which a spreadsheet program for editing the spreadsheet is executed detects a copy command for copying the value of a spreadsheet cell An instruction detecting step, wherein the computer refers to the format setting of the cell in which the copy instruction is detected in the copy instruction detecting step, and is defined as a value indicating copy prohibition in the prohibition information storage means in a predetermined format of the cell; A copy prohibition determining step for determining whether a set value is set; and A copy permission step for permitting the clipboard to store the value of the detected cell in the clipboard when it is determined in the step that a value defined as a value indicating copy prohibition is not set. Is a spreadsheet control method characterized by

  A spreadsheet control method corresponding to a fifth aspect of the invention is a method for controlling copying of a cell value of a spreadsheet, wherein the value of any one of the format values of the cell of the spreadsheet is set to the value of the cell. A computer that runs a spreadsheet program that edits the spreadsheet detects that the value of the spreadsheet cell has been copied to the clipboard. The copy detection step, and the computer refers to the format setting of the cell whose value has been copied to the clipboard in the copy detection step, and is defined as a value indicating copy prohibition in the prohibition information storage means in the predetermined format of the cell A copy prohibition determining step for determining whether the set value is set; and A copy prohibiting step for deleting a value copied to the clipboard when it is determined in the copy prohibition determining step that a value defined as a value indicating copy prohibition is set. It is a control method.

  According to the present invention, even if a user uses a stand-alone computer without using a macro function or the like, a simple operation can be performed by setting a predetermined value defined as input prohibition or the like in a spreadsheet format setting. This makes it possible to perform settings such as prohibition of input to the cell.

It is a block diagram which shows an example of a structure of the spreadsheet control apparatus concerning this invention. It is a figure which shows an example of the spreadsheet output on the display of the spreadsheet control apparatus concerning this invention. It is a figure which shows an example of the setting of input prohibition etc. in the spreadsheet control program concerning this invention. It is a figure which shows an example of the process which copies the spreadsheet by the spreadsheet control program concerning this invention. It is a figure which shows an example of the input prohibition process by the spreadsheet control program concerning this invention. It is a figure which shows an example of the copy prohibition process by the spreadsheet control program concerning this invention. It is a figure which shows an example of the process of paste prohibition by the spreadsheet control program concerning this invention. It is a 4th figure which shows an example of the process which preserve | saves the spreadsheet by the spreadsheet control program concerning this invention. It is a 1st flowchart which shows the processing flow of the spreadsheet control program concerning this invention. It is a 2nd flowchart which shows the processing flow of the spreadsheet control program concerning this invention. It is a 3rd flowchart which shows the processing flow of the spreadsheet control program concerning this invention. It is a 4th flowchart which shows the processing flow of the spreadsheet control program concerning this invention.

  Embodiments for carrying out the present invention will be described below in detail with reference to the drawings. In addition, the following description shows an example of embodiment of this invention, Comprising: This invention is not limited to embodiment shown below.

  FIG. 1 shows an example of the configuration of a spreadsheet control device according to the present invention. In FIG. 1, a computer 10 having a CPU 11, a main memory 12, and a storage device 13 corresponds to the spreadsheet control device according to the present invention. Data is input to the computer 10 from an input device 20 such as a keyboard and a mouse, and a display is displayed. The data calculated by the computer 10 is output to an output device 30 such as a printer.

  The storage device 13 of the computer 10 stores a spreadsheet program 131, a spreadsheet control program 132, and a spreadsheet 133. The spreadsheet program 131 is an application program that creates, edits, and outputs a spreadsheet. The spreadsheet control program 132 corresponds to the spreadsheet control program according to the present invention. The spreadsheet 133 is a file that can be read and written by the spreadsheet program 131.

  When the spreadsheet program 131 receives an activation command from the input device 20, the spreadsheet program 131 is read into the main memory 12 and the CPU 11 executes arithmetic processing. The spreadsheet control program 132 is also read into the main memory 12 together with the spreadsheet program 131, and arithmetic processing is executed by the CPU 11. Upon receiving the designation from the input device 20, the spreadsheet 133 is read into the main memory 12 by the spreadsheet program 131, and processing such as editing is performed by the spreadsheet program 131.

  Although FIG. 1 shows an example in which the present invention is applied to a computer used in a stand-alone manner, the present invention is applied to a computer connected to a network, and a spreadsheet program 131, a spreadsheet control program 132, a spread program is applied. You may comprise so that at least one part of the sheet | seat 133 may be read from the server connected via the network. The physical configuration of the computer 10 is not particularly limited, and the function of the main memory 12 may be realized by a virtual memory such as a hard disk.

  In the present invention, the spreadsheet control program 132 prohibits input of a value such as a specific color index to a cell in any format in the spreadsheet cell formatting, for example, background color or shading. Alternatively, it is defined as paste prohibition or copy prohibition of the cell value.

  Then, when the spreadsheet 133 is opened by the spreadsheet program 131 and the spreadsheet control program 132 detects a command such as inputting a value into a cell, pasting, copying a cell value, or the like, Referring to the format setting, it is determined whether or not a value corresponding to input prohibition is set.

  For example, as shown in FIG. 2, it is assumed that background colors and shading are set in some cells of a form format created using a spreadsheet. Here, when the color index (6 in this example) set as the background color of the cells of the cell addresses A8 and D11 to D16 is defined as input prohibition, as shown in FIG. Since a color index corresponding to input prohibition is set in the address format, it can be determined that input of values into these cells is prohibited.

  If the shaded pattern (18 in this example) set in the cell at the cell address A4 is defined as copy prohibition, the cell address format corresponds to copy prohibition as shown in FIG. Since the pattern is set, it can be determined that copying of the value of this cell is prohibited.

  Furthermore, when the shaded pattern (17 in this example) set in the cell at the cell address D1 is defined as paste prohibition, the cell address format corresponds to paste prohibition as shown in FIG. Since the pattern is set, it can be determined that the paste of the value into this cell is prohibited.

  Subsequently, using the flowcharts of FIGS. 4 to 8 and FIGS. 9 to 12, the spreadsheet control program according to the present invention is used to copy a spreadsheet, input prohibition processing, copy prohibition processing, and paste prohibition. The process of saving and a spreadsheet will be described.

  FIG. 4 shows an example of a process of copying a spreadsheet by the spreadsheet control program according to the present invention, and corresponds to the flowchart of FIG. When the computer 10 receives an instruction to open the spreadsheet 133, the spreadsheet program 131 is activated and a process for opening the spreadsheet 133 is executed. At this time, the spreadsheet control program 132 is also activated.

  The spreadsheet control program 132 started here executes the processing shown in the flowcharts of FIGS. 9 to 12 until the spreadsheet program 131 is terminated. First, it is determined whether or not the spreadsheet 133 to be opened is a file to be controlled such as input (S01). Here, the method for determining whether or not it is a control target is not particularly limited. For example, an identifier or the like for determining whether or not the control target is set in the file or the header of the file. That's fine.

  If it is determined that the spreadsheet 133 is a file to be controlled such as input, a copy of the spreadsheet 133 before editing is created and temporarily stored as shown in FIG. 4 (S02). ). If it is determined that the file is not a control target file, the spreadsheet control program 132 is terminated because there is no need to control input or the like.

  When it is determined that the file is a control target file such as an input, the copy of the spreadsheet 133 is created here in order to maintain the state of the spreadsheet 133 before editing. The copy of the spreadsheet 133 is used to refer to the format setting when determining prohibition of input or the like thereafter. However, if the format setting of the spreadsheet 133 is changed during editing, the correct determination cannot be made. Therefore, it is preferable to create a copy that retains the original state.

  FIG. 5 shows an example of the input prohibition process by the spreadsheet control program according to the present invention, and corresponds to a part of the flowchart of FIG. The spreadsheet control program 132 monitors operations on the spreadsheet 133 received by the spreadsheet program 131 (S03), and when an input command for a value to a cell of the spreadsheet 133 is detected (S04, S10), the input command is With reference to the format setting of the detected cell (S11), it is determined whether a value corresponding to input prohibition is set in a predetermined format (S12).

  Here, when referring to the cell format setting, it is preferable to use the format setting of the copy of the spreadsheet 133 created in S02 instead of the format setting of the spreadsheet 133 being edited for the reason described above.

  If a value corresponding to prohibition of input is set in the format of the cell in which the input command is detected, the function of the spreadsheet program 131 is called to lock the cell so that the input of the value to the cell results in an error. The input process is stopped by a method such as (S13). If the value corresponding to the input prohibition is not set, an input command is returned to the spreadsheet program 131 (S14), and the process of inputting the value to the cell is executed.

  In the example of FIG. 5, when an input command for the value (100) is received at the cell address B2, the format value corresponding to the input prohibition is not set, so the input processing of the value (100) is executed. Is done. When an input command for the value (100) is received at the cell address A3, the value in the format corresponding to the input prohibition is set, and therefore the input process of the value (100) results in an error.

  FIG. 6 shows an example of copy prohibition processing by the spreadsheet control program according to the present invention, and corresponds to the flowchart of FIG. As for the copy prohibition process, the operation on the spreadsheet 133 is monitored and a copy instruction for the cell value of the spreadsheet 133 is detected. Thereafter, the input prohibition described with reference to FIGS. Although it is good also as performing the same process, embodiment which monitors a clipboard is described here.

  The spreadsheet control program 132 monitors the change of the clipboard of the computer 10 (S25), and when it detects that the cell value is copied to the clipboard (S26), it refers to the formatting of the cell to which the value is copied. Then, it is determined whether a value corresponding to copy prohibition is set in a predetermined format (S28).

  Here, when referring to the cell formatting, it is preferable to use the formatting of the copy of the spreadsheet 133 created in S02 instead of the formatting of the spreadsheet 133 being edited. It is the same.

  If a value corresponding to copy prohibition is set in the format of the cell to which the value is copied, the value copied to the clipboard is erased to invalidate the copy of the cell value (S29). If a value corresponding to copy prohibition is not set, the state where the copied value is stored in the clipboard is continued.

  In the example of FIG. 6, when the value (100) of the cell address A1 is copied to the clipboard, the format value corresponding to copy prohibition is not set, so the value copied to the clipboard (100 ) Is stored as it is. When the value (100) of the cell address B2 is copied to the clipboard, the value (100) copied to the clipboard is deleted because the format value corresponding to copy prohibition is set.

  As explained here, the clipboard is monitored for copy prohibition, and when copying is prohibited, a special program for causing the spreadsheet program 132 to stop copying is executed by executing a process of deleting the clipboard value. It is possible to automatically realize the copy prohibition without executing any processing.

  FIG. 7 shows an example of paste prohibiting processing by the spreadsheet control program according to the present invention, and corresponds to a part of the flowchart of FIG. The spreadsheet control program 132 monitors operations on the spreadsheet 133 received by the spreadsheet program 131 (S03), and when a paste command for values to cells in the spreadsheet 133 is detected (S04, S05), the paste command is Referring to the format setting of the detected cell (S06), it is determined whether a value corresponding to paste prohibition is set in a predetermined format (S07).

  Here, when referring to the cell formatting, it is preferable to use the formatting of the copy of the spreadsheet 133 created in S02 instead of the formatting of the spreadsheet 133 being edited. It is the same.

  When a value corresponding to paste prohibition is set in the format of the cell in which the paste command is detected, as in the case of input prohibition, the spreadsheet program 131 is set so that the input of the value to the cell results in an error. The paste processing may be stopped, but here, the value stored in the clipboard is deleted (S08), and a paste command is returned to the spreadsheet program 131 (S09), thereby prohibiting paste. . When the value corresponding to the paste prohibition is not set, a paste command is returned to the spreadsheet program 131 (S09), and the process of inputting the value into the cell is executed.

  As described here, if the paste prohibition is realized by deleting the clipboard value, the paste prohibition is automatically prohibited without causing the spreadsheet program 132 to execute a special process for stopping the paste. Can be realized. As for the timing for confirming whether paste prohibition is set in S04 to S07, the format setting may be referred to at the timing when a cell is selected before the paste command is detected, and there is a paste prohibition setting. In this case, by immediately erasing the clipboard value, it is possible to prevent the cell value from being pasted even if the spreadsheet program 131 executes the paste command as usual.

  In the example of FIG. 7, when a paste command with a value (100) is received at cell address A2, the value of the format (100) corresponding to the prohibition of paste is not set. Is done. When a paste command with a value (100) is received at the cell address C1, since the value of the format corresponding to paste prohibition is set, the clipboard value (100) is erased, so the paste process is executed. Can not do.

  FIG. 8 shows an example of processing for saving a spreadsheet by the spreadsheet control program according to the present invention, and corresponds to the flowchart of FIG. The spreadsheet control program 132 monitors operations on the spreadsheet 133 received by the spreadsheet program 131 (S03), and when a save command for the spreadsheet 133 being edited is detected (S04, S15), the spreadsheet being edited Reference is made to the format setting of each cell whose value is updated in 133 (S19), and it is determined whether a value corresponding to input prohibition or paste prohibition is set in a predetermined format of each cell (S20).

  Here, when referring to the cell formatting, it is preferable to use the formatting of the copy of the spreadsheet 133 created in S02 instead of the formatting of the spreadsheet 133 being edited. It is the same.

  For cells in which values corresponding to input prohibition or paste prohibition are set in the cell format in which the values are updated, the copy data of the spreadsheet 133 created in S02 is stored as update data for the cells (S23). ). For a cell for which a value corresponding to input prohibition or paste prohibition is not set, the value is extracted from the cell of the spreadsheet 133 being edited (S21), and the value is overwritten on the corresponding cell of the copy of the spreadsheet 133 ( S22), and stored as update data of the cell (S23). When the update data is stored for all the cells, the spreadsheet 133 being edited is deleted (S24).

  In the example of FIG. 8, since the value of the format corresponding to input prohibition or paste prohibition is not set in the cell address B1, the value (100) extracted from the cell address B1 of the spreadsheet 133 being edited is It is stored as update data of the cell address B1 of the copy of the spreadsheet 133. Since the value of the format corresponding to the prohibition of input is set in the cell address A3, the value of the cell address B1 of the copy of the spreadsheet 133 is stored as update data as it is.

  Note that if input prohibition or paste prohibition is performed at the time of input or paste operation, it is possible that the processing at the time of saving described above does not necessarily have to be executed, but saving is performed together with the time of input processing or paste processing. Sometimes it is preferable to check again whether there is a prohibition setting. In addition, the spreadsheet 133 being edited is not saved at the time of saving, but only the values of the cells that are permitted to be input and the like are updated and saved in a copy of the spreadsheet 133, so that the spreadsheet 133 before editing is set. It is possible to prevent the format setting for judging the input prohibition etc. being changed.

10 Computer 11 CPU
12 Main memory 13 Storage device 131 Spreadsheet program 132 Spreadsheet control program 133 Spreadsheet 20 Input device 30 Output device

Claims (18)

A program that controls the input of values into spreadsheet cells,
In the program, the value of one of the formats in the cell formatting of the spreadsheet is defined as a value indicating that a value cannot be input to the cell,
On a computer running a spreadsheet program that edits the spreadsheet,
An input instruction detection step for detecting an input instruction for inputting a value into a cell of the spreadsheet;
An input prohibition determining step of referring to the format setting of the cell in which the input command is detected in the input command detecting step and determining whether a value defined as a value indicating input prohibition is set in the predetermined format of the cell; ,
When it is determined that a value defined as a value indicating input prohibition is not set in the input prohibition determination step, an input permission step for permitting input of the input value to the cell by the input command;
A spreadsheet control program characterized in that A program that controls the pasting of values into cells in a spreadsheet,
In the program, the value of any format in the cell formatting of the spreadsheet is defined as a value indicating that the value cannot be pasted into the cell,
On a computer running a spreadsheet program that edits the spreadsheet,
A paste command detection step for detecting a paste command for pasting a value into a spreadsheet cell;
A paste prohibition determination step that refers to the format setting of the cell in which the paste command is detected in the paste command detection step and determines whether a value defined as a value indicating paste prohibition is set in the predetermined format of the cell; ,
When it is determined that the value defined as the value indicating paste prohibition is not set in the pace prohibition determination step, a paste permission step for allowing the paste of the value stored in the clipboard to the cell;
A spreadsheet control program characterized in that A program that controls the pasting of values into cells in a spreadsheet,
In the program, the value of any format in the cell formatting of the spreadsheet is defined as a value indicating that the value cannot be pasted into the cell,
On a computer running a spreadsheet program that edits the spreadsheet,
A paste command detection step for detecting a paste command for pasting a value into a spreadsheet cell;
A paste prohibition determination step that refers to the format setting of the cell in which the paste command is detected in the paste command detection step and determines whether a value defined as a value indicating paste prohibition is set in the predetermined format of the cell; ,
When it is determined that a value defined as a value indicating paste prohibition is set in the pace prohibition determination step, a paste prohibition step of erasing a value stored in the clipboard;
A spreadsheet control program characterized in that A program that controls the copying of spreadsheet cell values,
In the program, the value of any format in the cell formatting of the spreadsheet is defined as a value indicating that the cell value is prohibited to be copied,
On a computer running a spreadsheet program that edits the spreadsheet,
A copy instruction detection step for detecting a copy instruction for copying a value of a cell in a spreadsheet;
A copy prohibition determining step of referring to the format setting of the cell in which the copy command is detected in the copy command detecting step and determining whether a value defined as a value indicating copy prohibition is set in the predetermined format of the cell; ,
A copy permission step for permitting the clipboard to store the value of the detected cell in the clipboard when it is determined in the copy prohibition determination step that a value defined as a value indicating copy prohibition is not set; ,
A spreadsheet control program characterized in that A program that controls the copying of spreadsheet cell values,
In the program, the value of any format in the cell formatting of the spreadsheet is defined as a value indicating that the cell value is prohibited to be copied,
On a computer running a spreadsheet program that edits the spreadsheet,
A copy detection step that detects that the value of a cell in the spreadsheet has been copied to the clipboard;
A copy prohibition determination step of referring to the format setting of the cell whose value is copied to the clipboard in the copy detection step and determining whether a value defined as a value indicating copy prohibition is set in the predetermined format of the cell; ,
When it is determined that a value defined as a value indicating copy prohibition is set in the copy prohibition determination step, a copy prohibition step of erasing the value copied to the clipboard;
A spreadsheet control program characterized in that In the computer,
When a command to open a spreadsheet is detected, a control target determination step for determining whether the spreadsheet is a spreadsheet to be controlled by inputting or pasting a value into a cell or copying a cell value;
When it is determined in the control object determination step that it is a spreadsheet to be controlled, a copy creation step of creating a copy of the spreadsheet that is opened as an edit object by the command is executed, and
In the input prohibition determination step, the paste prohibition determination step, or the copy prohibition determination step, determination as to whether a value defined as a value indicating input prohibition, paste prohibition, or copy prohibition is set is the copy creation step. The spreadsheet control program according to claim 1, wherein the spreadsheet control program is executed with reference to formatting of a corresponding cell in a copy of the spreadsheet created in step 1. In the computer,
A save command detection step for detecting a save command for the spreadsheet being edited;
The cell value is taken out from the spreadsheet being edited in which the save command is detected in the save command detection step, and the cell value taken out from the spreadsheet being edited is overwritten on the copy of the spreadsheet created in the copy creation step. , A spreadsheet saving step for saving as update data of the spreadsheet being edited,
The spreadsheet control program according to claim 6, wherein the spreadsheet control program is executed. In the computer,
For a cell whose value is extracted from the spreadsheet being edited in which the save command is detected in the save command detection step, the cell format setting is referred to and defined as a value indicating prohibition of input or paste in the predetermined format of the cell. An update prohibition determination step for determining whether the set value is set,
When it is determined in the update prohibition determination step that a value defined as a value indicating input prohibition or paste prohibition is set, in the spreadsheet saving step, the value extracted from the cell is copied to the spreadsheet An overwriting stop step to stop overwriting,
The spreadsheet control program according to claim 7, wherein: A device that controls the input of values into spreadsheet cells,
A prohibition information storage means for defining and storing a value of any format in the cell format setting of the spreadsheet as a value indicating prohibition of input of a value to the cell;
An input command detecting means for detecting an input command for inputting a value into a cell of the spreadsheet;
Referring to the format setting of the cell in which the input command is detected by the input command detection means, it is determined whether a value defined as a value indicating input prohibition is set in the prohibition information storage means in the predetermined format of the cell Input prohibition judging means to
When it is determined by the input prohibition determination unit that a value defined as a value indicating input prohibition is not set, an input permission unit that allows input of the input value to the cell by the input command;
A spreadsheet control device comprising: A device that controls the pasting of values into cells in a spreadsheet,
A prohibition information storage means for defining and storing a value of any format in the format setting of the cell of the spreadsheet as a value indicating prohibition of pasting the value into the cell;
A paste command detecting means for detecting a paste command for pasting a value into a cell of a spreadsheet;
Reference is made to the format setting of the cell in which the paste command is detected by the paste command detection means, and it is determined whether or not a value defined as a value indicating paste prohibition is set in the prohibition information storage means in the predetermined format of the cell Paste prohibition determination means,
If it is determined by the pace prohibition determination means that the value defined as a value indicating paste prohibition is not set, paste permission means for permitting the paste of the value stored in the clipboard to the cell;
A spreadsheet control device comprising: A device that controls the pasting of values into cells in a spreadsheet,
A prohibition information storage means for defining and storing a value of any format in the format setting of the cell of the spreadsheet as a value indicating prohibition of pasting the value into the cell;
A paste command detecting means for detecting a paste command for pasting a value into a cell of a spreadsheet;
Reference is made to the format setting of the cell in which the paste command is detected by the paste command detection means, and it is determined whether or not a value defined as a value indicating paste prohibition is set in the prohibition information storage means in the predetermined format of the cell Paste prohibition determination means,
When it is determined by the pace prohibition determination means that a value defined as a value indicating paste prohibition is set, paste prohibition means for erasing the value stored in the clipboard;
A spreadsheet control device comprising: A device that controls the copying of spreadsheet cell values,
A prohibition information storage means for defining and storing a value of any format in the cell formatting of the spreadsheet as a value indicating that the cell value is prohibited to be copied;
A copy instruction detecting means for detecting a copy instruction for copying a value of a cell in a spreadsheet;
Referring to the format setting of the cell in which the copy command is detected by the copy command detection means, it is determined whether a value defined as a value indicating copy prohibition is set in the prohibition information storage means in the predetermined format of the cell Copy prohibition judging means to
Copy permission means for permitting the clipboard to store the value of the cell in which the copy command is detected when it is determined by the copy prohibition determination means that a value defined as a value indicating copy prohibition is not set; ,
A spreadsheet control device comprising: A device that controls the copying of spreadsheet cell values,
A prohibition information storage means for defining and storing a value of any format in the cell formatting of the spreadsheet as a value indicating that the cell value is prohibited to be copied;
A copy detection means for detecting that the value of the cell in the spreadsheet has been copied to the clipboard;
Reference is made to the format setting of the cell whose value has been copied to the clipboard by the copy detection means, and it is determined whether a value defined as a value indicating copy prohibition is set in the prohibition information storage means in the predetermined format of the cell Copy prohibition judging means to
When it is determined by the copy prohibition determination means that a value defined as a value indicating copy prohibition is set, copy prohibition means for erasing the value copied to the clipboard;
A spreadsheet control device comprising: A method for controlling the entry of values into spreadsheet cells,
A spreadsheet program that edits the spreadsheet is provided with prohibition information storage means for defining and storing any format value in the cell format setting of the spreadsheet as a value indicating prohibition of input of a value to the cell. An input instruction detecting step for detecting an input instruction for inputting a value into a cell of the spreadsheet;
The computer refers to the format setting of the cell in which the input command is detected in the input command detection step, and a value defined as a value indicating input prohibition is set in the prohibition information storage means in the predetermined format of the cell. An input prohibition determination step for determining whether or not
When the computer determines that the value defined as the value indicating input prohibition is not set in the input prohibition determination step, the input permission step permits the input of the input value to the cell by the input command; ,
A method for controlling a spreadsheet, comprising: A method for controlling the pasting of values into cells in a spreadsheet,
A spreadsheet program that edits the spreadsheet is provided with prohibition information storage means for defining and storing any format value in the cell format setting of the spreadsheet as a value indicating prohibition of pasting the value into the cell. A paste command detecting step for detecting a paste command for pasting a value into a spreadsheet cell;
The computer refers to the cell format setting in which the paste command is detected in the paste command detection step, and a value defined as a value indicating paste prohibition is set in the prohibition information storage means in the predetermined format of the cell. Paste prohibition judging step for judging whether or not,
When the computer determines that the value defined as the value indicating paste prohibition is not set in the pace prohibition determination step, a paste permission step for permitting the paste of the value stored in the clipboard to the cell; ,
A method for controlling a spreadsheet, comprising: A method for controlling the pasting of values into cells in a spreadsheet,
A spreadsheet program that edits the spreadsheet is provided with prohibition information storage means for defining and storing any format value in the cell format setting of the spreadsheet as a value indicating prohibition of pasting the value into the cell. A paste command detecting step for detecting a paste command for pasting a value into a spreadsheet cell;
The computer refers to the cell format setting in which the paste command is detected in the paste command detection step, and a value defined as a value indicating paste prohibition is set in the prohibition information storage means in the predetermined format of the cell. Paste prohibition judging step for judging whether or not,
When the computer determines that a value defined as a value indicating paste prohibition is set in the pace prohibition determination step, a paste prohibition step of erasing a value stored in the clipboard;
A method for controlling a spreadsheet, comprising: A method of controlling the copying of spreadsheet cell values,
A spreadsheet program for editing a spreadsheet is provided, comprising prohibition information storage means for defining and storing a value of any format in the cell format setting of the spreadsheet as a value indicating copy prohibition of the cell value. A copy instruction detecting step for detecting a copy instruction for copying a value of a spreadsheet cell;
The computer refers to the format setting of the cell in which the copy command is detected in the copy command detection step, and a value defined as a value indicating copy prohibition is set in the prohibition information storage means in the predetermined format of the cell. A copy prohibition determination step for determining whether or not
When the computer determines that a value defined as a value indicating copy prohibition is not set in the copy prohibition determination step, the computer allows the value of the cell in which the copy command is detected to be stored in the clipboard. A copy permission step;
A method for controlling a spreadsheet, comprising: A method of controlling the copying of spreadsheet cell values,
A spreadsheet program for editing a spreadsheet is provided, comprising prohibition information storage means for defining and storing a value of any format in the cell format setting of the spreadsheet as a value indicating copy prohibition of the cell value. A copy detection step for detecting that a spreadsheet cell value has been copied to the clipboard;
The computer refers to the format setting of the cell whose value is copied to the clipboard in the copy detection step, and a value defined as a value indicating copy prohibition is set in the prohibition information storage means in the predetermined format of the cell. A copy prohibition determination step for determining whether or not
When the computer determines that a value defined as a value indicating copy prohibition in the copy prohibition determination step is set, a copy prohibition step of erasing the value copied to the clipboard;
A method for controlling a spreadsheet, comprising: