KR102076552B1 - Apparatus for registering and performing macro, macro registration method - Google Patents

Abstract

An apparatus for registering a macro of a document editing program according to the present invention includes at least one processor, an I / O interface, and a memory, wherein the I / O interface is a start signal for registering a macro for storing an operation group of the document editing program. Receive an operation signal indicating at least one operation corresponding to an editing function of the document editing program and an end signal for terminating the registration of the macro, and the processor is configured to respond to the start signal with an identifier and the identifier to the macro; Allocating a storage space in a memory, storing the at least one operation in the allocated storage space, terminating registration of the macro in response to the end signal, and the memory operating an editing function of the document editing program. Command to execute and start and end the registration of the macro Stores command.

Description

Macro registration and execution device, macro registration method {APPARATUS FOR REGISTERING AND PERFORMING MACRO, MACRO REGISTRATION METHOD}

The present invention relates to a technique for registering and executing macros in a document editing program.

Recently, as computers, smartphones, tablet PCs, and the like are widely used, various kinds of electronic document-related programs for reading, creating, and editing electronic documents using such terminal devices have been released.

Such electronic document related programs include word processors that support the creation and editing of basic documents, data entry, arithmetic operations, spreadsheets to assist data management, and presentation programs to assist presenters.

A macro command is a sequence of instructions that tells a computer program or programming language (Visual Basic, C, assembler, PHP, etc.) to perform a series of tasks centered on repetitive tasks that are vulnerable to errors or mistakes.

Typically, you use macro recorders to create application macros. The logger records keystrokes during the repetitive task, and repeats this keystroke each time you execute a macro name or shortcut key.

It also provides a macro function that allows you to record various tasks in a text editing program. In the existing macro function, the user needs to know the scripting language for recording the macro, which makes it difficult for general users to use the macro function.

 Therefore, it is possible to easily perform macro recording in consideration of the user's repetitive working pattern in the document editing program and to easily modify the macro even if the user does not know a separate scripting language. Introduction is necessary.

According to the present invention, it is possible to record a pattern frequently used for document creation using a macro record, and through this, a user can recommend a macro that can help a user to write a document when creating a similar document. We want to provide a technique that can help users modify macros intuitively.

In the macro registration apparatus of a document editing program according to an embodiment of the present invention, the macro registration apparatus includes at least one processor, an I / O interface, and a memory, wherein the I / O interface is a device of the document editing program. Receiving a start signal for registering a macro storing an action group, an operation signal indicating at least one operation corresponding to an editing function of the document editing program, and an end signal for terminating the registration of the macro, Assign an identifier and a storage space in the memory to the macro in response to the start signal, store the at least one operation in the allocated storage space, terminate registration of the macro in response to the end signal, and The memory is an instruction for executing an operation of an editing function of the document editing program. And a command to start and end registration of the macro.

The macro registration apparatus may further include a display, the processor may generate a flowchart corresponding to the at least one operation, and the display may output the flowchart.

The I / O interface receives a signal to modify the flowchart, the processor modifies the flowchart in response to a signal to modify the flowchart, modifies the at least one operation in response to the modified flowchart, The memory may store the modified at least one operation.

The processor may modify the type or order of the at least one operation included in the flowchart in response to a signal for modifying the flowchart, and the memory may store the type or order of the modified operation.

In addition, in the apparatus for executing a macro of a document editing program according to an embodiment of the present invention, the apparatus for executing a macro may include at least one processor, an I / O interface, a display, an identifier of at least one macro, and the macro; A memory storing at least one operation, wherein the I / O interface receives an operation signal indicative of the at least one operation, and wherein the processor is configured to use the macro in response to receiving the operation signal; Output a selection request to the display, the I / O interface receives a selection signal corresponding to the selection request, and wherein the processor configures the macro when the selection signal indicates to use the macro And select that the selection signal does not use the macro If that may end the display of the selected request.

In addition, the macro registration method according to an embodiment of the present invention, the start signal for registering the macro for storing the operation group of the document editing program, the operation signal indicating at least one operation corresponding to the editing function of the document editing program And receiving an end signal for terminating registration of the macro, allocating an identifier and storage space in the memory to the macro in response to the start signal, and storing the at least one operation in the allocated storage space. The method may include terminating the registration of the macro in response to the end signal, generating a flowchart corresponding to the at least one operation, and outputting the flowchart by a display.

In this case, the method for registering a macro may include: receiving a signal for modifying the flowchart, modifying the flowchart in response to the signal for modifying the flowchart, and correcting the at least one operation in response to the modified flowchart; And storing the modified at least one operation on the storage space of the memory.

In this case, the modifying may include modifying the type or order of the at least one operation included in the flowchart in response to a signal for modifying the flowchart, and the storing process may include the modification on the storage space of the memory. The type or order of the operations can be stored.

A computer readable recording medium according to an embodiment of the present invention may record a program for causing a computer to perform the method.

A computer program according to an embodiment of the present invention may be stored in a storage medium for executing the method in combination with a computer.

According to the present invention, it is possible to record a pattern frequently used for document creation using a macro record, and through this, a user can recommend a macro that can help a user to create a document when a user creates a similar document. It can provide a mechanism to help users modify macros intuitively.

1 is a diagram showing the overall configuration of a macro registration device according to an embodiment of the present invention.
2 is a flowchart illustrating the overall operation of the macro registration device according to an embodiment of the present invention.
3 is a diagram illustrating an example for explaining an operation of a macro registration device according to an embodiment of the present invention.
4 is a diagram showing the overall configuration of a macro execution apparatus according to an embodiment of the present invention.
5 is a flowchart illustrating a macro registration method according to an embodiment of the present invention.

Hereinafter, exemplary embodiments will be described in detail with reference to the accompanying drawings. However, various changes may be made to the embodiments so that the scope of the patent application is not limited or limited by these embodiments. It is to be understood that all changes, equivalents, and substitutes for the embodiments are included in the scope of rights.

The terminology used herein is for the purpose of description and should not be construed as limiting. Singular expressions include plural expressions unless the context clearly indicates otherwise. In this specification, terms such as "comprise" or "have" are intended to indicate that there is a feature, number, step, operation, component, part, or combination thereof described on the specification, and one or more other features. It is to be understood that the present invention does not exclude the possibility of the presence or the addition of numbers, steps, operations, components, components, or a combination thereof.

Unless defined otherwise, all terms used herein, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art. Terms such as those defined in the commonly used dictionaries should be construed as having meanings consistent with the meanings in the context of the related art, and shall not be construed in ideal or excessively formal meanings unless expressly defined in this application. Do not.

In addition, in the description with reference to the accompanying drawings, the same components will be given the same reference numerals regardless of the reference numerals and duplicate description thereof will be omitted. In the following description of the embodiment, if it is determined that the detailed description of the related known technology may unnecessarily obscure the gist of the embodiment, the detailed description thereof will be omitted.

The document editing program for the implementation of the present invention is applied to a spreadsheet containing a macro or Visual Basic for Applications (VBA) function for editing processing of information, but the present invention includes a case where such information editing processing function is included. Of course, any text editing program can be applied.

1 is a diagram showing the overall configuration of a macro registration device according to an embodiment of the present invention.

According to an embodiment of the present invention, the macro registration apparatus 110 may visually display the macros in a flowchart in the process of registering the macros of the document editing program. The macro registration apparatus 110 may provide a function of editing a flowchart of a macro. The macro registration device 110 may edit a macro in response to the edited flowchart. As such, the macro registration apparatus 110 may facilitate the modification of the macro by visually providing the operation sequence of the macro through a flowchart.

According to an embodiment of the present invention, the macro registration device 110 includes an I / O interface 101, a memory 102, and a processor 103. The macro registration device 110 may further include a display 104.

The I / O interface 101 is a start signal for registering a macro that stores an operation group of a document editing program, an operation signal representing at least one operation corresponding to an editing function of the document editing program, and for terminating registration of a macro. An end signal may be received.

The processor 103 may allocate an identifier and storage space in the memory to the macro in response to the start signal, store at least one operation in the allocated storage space, and terminate registration of the macro in response to the end signal.

The memory 102 may store instructions for executing an operation of an editing function of a document editing program and instructions for starting and ending registration of a macro.

The macro registration device 110 may register an operation pattern that is repeatedly used to create a document. The registered macro can be stored in the memory 102 with a unique identifier. The macro registration device 110 may provide a macro auto registration mode. When the macro auto registration mode is activated, the macro registration device 110 may automatically register an operation pattern used for document creation.

The macro registration device 110 may further include a display 104. The macro registration device 110 may optionally provide a macro automatic registration mode when an operation pattern used two or more times for document creation is input. Display 104 may display a message box asking whether to use the macro auto-registration mode.

For example, the macro registration device 110 may activate the macro auto registration mode. The macro registration device 110 may store a selection command of a specific cell. The macro registration device 110 may store a modification command for the text attribute of the selected cell. The macro registration apparatus 110 may register a selection command of a specific cell and a modification command of a text attribute of the selected cell as one macro and designate an identifier.

The processor 103 may generate a flowchart representing the operation pattern. Display 104 may display a flowchart. The display 104 may display an operation during macro registration in a flowchart, or may display an operation of a registered macro in a flowchart.

I / O interface 101 may receive a signal to modify the flowchart. The processor 103 may modify the flowchart in response to the signal for modifying the flowchart. The processor 103 may modify at least one operation in response to the modified flowchart. The memory 102 may store the modified operation. The memory 102 may store an operation pattern including the modified operation.

The processor 103 may modify the type or order of at least one operation included in the flowchart in response to the signal for modifying the flowchart, and the memory 102 may store the type or order of the modified operation.

For example, the macro registration apparatus 110 may modify a registered macro including a selection command of a specific cell and a modification command for a text attribute of the selected cell. The macro registration apparatus 110 may display, on the display 104, a flowchart corresponding to a selection command of a specific cell and a modification command for a text attribute of the selected cell. Through the I / O interface 101, a signal for modifying a modification command for a text attribute of a selected cell may be received. The macro registration device 110 may correct the registered macro by reflecting a signal to be corrected.

2 is a flowchart illustrating the overall operation of the macro registration device according to an embodiment of the present invention.

The macro registration device 110 may visually display a flowchart corresponding to a registered macro. The user can easily modify the desired action in the flowchart. The macro registration apparatus 110 may modify the corresponding operation of the macro in response to the operation modified in the flowchart. As such, the macro registration apparatus 110 may provide an opportunity for a user to easily register or modify a macro by providing an intuitive interface for the macro.

According to an embodiment of the present invention, in operation 201, the macro registration device 110 may output a flowchart corresponding to the macro. For example, a flowchart may be generated in which a box including a command for selecting a specific cell and a box including a command for modifying a text attribute of the selected cell are connected. The macro registration device 110 may provide an intuitive interface to the user by outputting the corresponding flowchart on the display 104.

According to one embodiment of the invention, in step 203, the macro registration device 110 may modify the flowchart according to the user input. When the user selects an operation to be modified in the flowchart, the modification mode may be activated. With the modify mode activated, the user can execute a new action. The macro registration apparatus 110 may replace the operation selected in the flowchart with the new operation.

According to an embodiment of the present invention, in step 205, the macro registration device 110 may modify the macro according to the modified flowchart. The macro registration device 110 may register a macro by modifying the macro to an operation pattern including the replaced operation.

3 is a view showing an example for explaining the operation of the macro registration device according to an embodiment of the present invention.

According to an embodiment of the present invention, the registered macro may be stored in a script language.

Referring to FIG. 3, a macro “change color of text” may be registered. The "change text color" macro may include a selection command of a text font, a text color selection command, and a gradient / shading selection command. The selection command of the text font may be displayed as "Selection.Font", the text color selection command may be displayed as ".Color = -16776961", and the tilt / shading selection command may be displayed as ".TintAndShade = 0".

To use the scripting language, you need to have expert knowledge. The macro registration apparatus 110 may visually display a flowchart of registered macros, thereby facilitating modification of the macro without knowledge of the script language. The macro registration device 110 may provide a user with such an intuitive interface.

The user can modify the "selection command of the character font" displayed in the flowchart. For example, the user can modify the "selection command of the character font" to "select a name font". The macro registration device 110 may modify the macro in response to the modified flowchart. Accordingly, the "change text color" macro may include a Myeongjo font selection command, a text color selection command, and a gradient / shadow selection command.

4 is a diagram showing the overall configuration of a macro execution apparatus according to an embodiment of the present invention.

According to an embodiment of the present invention, the macro execution apparatus 410 of the document editing program includes at least one processor 403, an I / O interface 401, a display 404, and a memory 402.

The memory 402 stores identifiers of at least one macro and at least one operation constituting the macro. For example, the memory 402 may store a macro corresponding to macro 1 including a selection command of a specific cell and a modification command for a text attribute of the selected cell. Here, macro 1 may represent an identifier.

The I / O interface 401 may receive an operation signal indicating at least one operation. The user can perform the start operation registered in Macro 1 while using the document editing program.

The processor 403 may output a selection request on whether to use a macro in response to receiving the operation signal. In response to the start operation registered with macro 1, a selection request whether to use macro 1 may be displayed on display 404.

The I / O interface 401 may receive a selection signal corresponding to the selection request. The processor 403 may execute an operation of constructing the macro when the selection signal indicates to use the macro, and terminate the display of the selection request when the selection signal indicates not to use the macro. For example, when the selection signal indicates that the macro is used, the selection command of the specific cell registered in the macro 1 and the correction command for the text attribute of the selected cell may be executed.

5 is a flowchart illustrating a macro registration method according to an embodiment of the present invention.

In step 510, a start signal for registering a macro storing an operation group of the document editing program, an operation signal indicating at least one operation corresponding to the editing function of the document editing program, and an end signal for terminating the registration of the macro Can be received.

In operation 520, an identifier and a storage space in a memory may be allocated to the macro in response to the start signal, and at least one operation may be stored in the allocated storage space.

In operation 530, the registration of the macro may be terminated in response to the termination signal.

In operation 540, a flowchart corresponding to at least one operation may be generated.

In operation 550, a flowchart may be output by the display.

In this case, according to an embodiment of the present invention, the method for registering a macro may include receiving a signal for modifying the flowchart, modifying the flowchart in response to the signal for modifying the flowchart, and in response to the modified flowchart. Modifying at least one operation and storing the modified at least one operation in the storage space of the memory.

In this case, according to an embodiment of the present disclosure, the modifying may modify the type or order of the at least one operation included in the flowchart in response to the signal for modifying the flowchart, and the storing may include: The type or order of the modified operation may be stored and processed on the storage space of the memory.

The macro registration method 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 macro registration method according to an embodiment of the present invention is implemented in the form of program instructions that can be executed by various computer means may be recorded in a computer readable medium. The computer readable medium may include program instructions, data files, data structures, and the like, 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.

As described above, the present invention has been described by specific embodiments such as specific components and the like, but the embodiments and drawings are provided only to help a more general understanding of the present invention, and 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.

Accordingly, 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 appended claims, will fall within the scope of the present invention. .

Claims (10)

In the macro registration device of the document editing program,
The macro registration device,
At least one processor;
I / O interface;
Memory; And
Including a display,
The I / O interface may include a start signal for registering a macro storing an operation group of the document editing program, an operation signal indicating at least one operation corresponding to an editing function of the document editing program, and terminating registration of the macro. Receive an end signal for
The processor,
In response to the start signal, allocate an identifier and storage space in the memory to the macro, store the at least one operation in the allocated storage space, and connect a box containing instructions corresponding to the at least one operation. Thereby generating a flowchart corresponding to the at least one operation, terminating registration of the macro in response to the end signal,
The memory,
Instructions for executing an operation of an editing function of the document editing program and instructions for starting and ending registration of the macro;
The display outputs the flowchart,
The I / O interface receives a signal for modifying the flowchart,
The processor may modify the flowchart by modifying a type or order of instructions corresponding to the at least one operation included in the flowchart in response to a signal for modifying the flowchart, and assigning the allocated flowchart in response to the modified flowchart. Modify the at least one operation stored in the storage space,
When the operation pattern that has been used more than two times for writing a document is input, the processor activates the macro auto registration mode to store an operation according to the operation pattern and an identifier of a macro corresponding to the operation pattern in the memory. To perform macro auto-registration,
Macro registration device. delete delete delete delete A start signal for registering a macro storing an operation group of a document editing program, an operation signal indicating at least one operation corresponding to an editing function of the document editing program, and an end of registration of the macro; Receiving an end signal;
A processor, in response to the start signal, allocating an identifier and storage space in memory to the macro, and storing the at least one operation in the allocated storage space;
Terminating, by the processor, registration of the macro in response to the end signal;
Generating, by the processor, a flowchart corresponding to the at least one operation by connecting a box containing an instruction corresponding to the at least one operation;
Displaying, by the display, the flowchart;
Receiving, by the I / O interface, a signal to modify the flowchart; And
The processor modifies the flowchart by modifying a type or order of instructions corresponding to the at least one operation included in the flowchart in response to a signal for modifying the flowchart, and assigns the allocated flowchart in response to the modified flowchart. Modifying the at least one operation stored in a storage space
Including,
When the operation pattern that has been used more than two times for writing a document is input, the processor activates the macro auto registration mode to store an operation according to the operation pattern and an identifier of a macro corresponding to the operation pattern in the memory. To perform macro auto-registration,
How to register a macro. delete delete A computer-readable recording medium having recorded thereon a program for performing the method of claim 6. A computer program stored in a storage medium for executing the method of claim 6 in combination with a computer.

Images