KR102030582B1 - Method for editing spreadsheet and apparatus using the same - Google Patents

Abstract

The present invention relates to a method for editing a script, comprising: executing a user interface (UI) for editing various scripts or executing various commands to be provided in a main window in spreadsheet editing; Selecting a kind of task possible with the user interface, including an automation task, a function execution task, and a function creation task; Performing the selected task through an operation of an input device; And terminating execution of the direct execution UI. According to the present invention, a user interface suitable for keyboard operation can be provided.

Description

Spreadsheet editing method and device using the same {METHOD FOR EDITING SPREADSHEET AND APPARATUS USING THE SAME}

The present invention relates to a spreadsheet editing method and an apparatus using the same. More particularly, the present invention relates to a spreadsheet that can efficiently process repetitive tasks through a keyboard operation using a user interface provided with a direct command window, which is a single or unit command edit window. The present invention relates to a sheet editing method and an apparatus using the same.

Various applications accept content from a graphical user interface (GUI), manipulate it, and display it. Spreadsheets correspond to applications that display data in various formats in the GUI.

Spreadsheet application is a generic term for programs that perform calculation functions on numeric tables. Spreadsheet applications have been widely used as personal or business programs, from the time they were developed to provide a wide variety of practical uses.

Previously, there was a math program for large computers, but the world's first PC spreadsheet application was VisiCalc, developed for the Apple II.

Typical spreadsheet applications simulate realistic spreadsheets by capturing, displaying, and manipulating data arranged in rows and columns. The intersecting rows and columns produce many cells in the spreadsheet. Typically each cell contains data items and / or equations.

In a GUI environment, a user primarily uses a mouse as an input device to edit cells in the sheet through a spreadsheet application. The user also uses the keyboard with the mouse as another input device. By the way, the keyboard and the mouse may be used at the same time, when the input of the command using the mouse or typing using two hands formally, any one of the keyboard and the mouse is inevitably used.

For professional applications, including spreadsheet applications, such as design tools, professional users often use keyboard shortcuts rather than the mouse to streamline their work.

In working with spreadsheets, a user may enter the contents of a cell using a keyboard or input a command to perform various commands. However, since the GUI environment of the spreadsheet application according to the related art provides a user interface suitable for using a mouse, it is not suitable for repetitive work processing using a keyboard.

Spreadsheet editing method and an apparatus using the same according to an embodiment of the present invention is to solve the problems according to the prior art, characterized in that to provide a direct execution UI corresponding to a user environment suitable for a task using a keyboard. do.

Korea Patent Publication No. 10-1319638 (2013.10.11.)

An object of the present invention is to provide a spreadsheet editing method and a device using the same, provided with a user interface suitable for keyboard operation.

Another object of the present invention is to provide a spreadsheet editing method and an apparatus using the same, wherein a direct execution UI is basically included in a cell edit screen without executing an application.

Spreadsheet editing method according to an embodiment of the present invention, the step of executing a direct user interface (UI) that can be provided in the main window in the spreadsheet editing, edit various scripts or execute various commands; Selecting a kind of task possible with the user interface, including an automation task, a function execution task, and a function creation task; Performing the selected task through an operation of an input device; And terminating execution of the direct execution UI.

The direct execution UI may include a code window for editing various scripts, a property window indicating property of an object, and a direct command window for executing various commands.

Herein, the step of terminating the direct execution UI is characterized in that the direct command window is automatically terminated when a preset time elapses when the active caret is not detected in the direct execution window.

Here, the spreadsheet editing method further comprises the step of executing a spreadsheet program before the execution of the direct execution UI, wherein the direct execution UI is activated by default in the execution of the spreadsheet program according to the setting do.

Here, the direct command window is characterized by providing a history function that stores the command used and calls the command again according to a user's instruction.

Spreadsheet editing apparatus according to an embodiment of the present invention, a direct execution for executing a user interface (UI) that can be provided in the main window in the spreadsheet editing, edit various scripts or execute various commands A UI execution module; And a task selection module for selecting a kind of tasks available through the user interface, including an automation task, a function execution task, and a function generation task.

The direct execution UI may include a code window for editing various scripts, a property window indicating a property of an object, and a direct command window for executing various commands.

In this case, the direct UI execution module, characterized in that the direct command window automatically terminates when a predetermined time elapses, in which no active caret is detected in the direct execution window.

The spreadsheet editing apparatus may further include a history module that stores a command used in the direct command window and provides a history function of calling the command again according to a user's instruction.

According to the present invention, there is provided a spreadsheet editing method provided with a user interface suitable for keyboard operation and an apparatus using the same.

In addition, the present invention provides a spreadsheet editing method and a device using the same, which are provided with a direct execution UI that is basically included in a cell editing screen without executing an application.

1 is an exemplary diagram of a network environment including a spreadsheet editing apparatus according to an embodiment of the present invention.
2 is a block diagram of a spreadsheet editing apparatus according to an embodiment of the present invention.
3 is a block diagram showing in detail the control unit of FIG. 2.
4 is a block diagram of a computing device corresponding to a spreadsheet editing apparatus according to an embodiment of the present invention.
5 is a flowchart illustrating a spreadsheet editing method according to an embodiment of the present invention.
6 is an exemplary view of a spreadsheet editing screen according to an embodiment of the present invention.
7 is an exemplary view of a direct execution UI according to an embodiment of the present invention.

Hereinafter, an embodiment of a spreadsheet editing method and a spreadsheet editing apparatus using the same will be described in detail with reference to the accompanying drawings.

Like reference numerals in the drawings denote like elements. In addition, specific structural to functional descriptions of one embodiment of the present invention are only illustrated for the purpose of describing the embodiment according to the present invention, and unless otherwise defined, all terms used herein including technical or scientific terms are used. The 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 are not construed in ideal or excessively formal meanings unless expressly defined herein. It is preferable not to.

The document referred to in the present invention includes a spreadsheet that can be read by the spreadsheet editing application module according to an embodiment of the present invention and stored in an electronic file.

Hereinafter, a network environment 1 including a spreadsheet editing apparatus according to an embodiment of the present invention will be described.

1 is an exemplary diagram of a network environment including a spreadsheet editing apparatus according to an embodiment of the present invention.

Referring to FIG. 1, a network environment 1 including a spreadsheet editing apparatus 100 according to an embodiment of the present invention may include a user terminal 100, a server 200, a database 300, and a network 400. It includes. The user terminal 100 corresponds to the spreadsheet editing apparatus 100.

The user terminal 100 is a device capable of creating and / or reading documents and performing data backup. That is, the user terminal 100 is a device for creating a document, which is a viewer dedicated to reading electronic documents, a device for creating and editing electronic documents, a document editor, a document editing device, and an electronic typewriter. It may include a computing device, a terminal, and a wireless terminal capable of performing general purpose operations in addition to writing and editing a type writer or document.

Various embodiments of the wireless terminal include a cellular telephone, a smart phone having a wireless communication function, a personal digital assistant (PDA) having a wireless communication function, a wireless modem, a portable computer having a wireless communication function, a digital camera having a wireless communication function, and the like. Portable units incorporating combinations of such functions as well as photographing devices, gaming devices with wireless communication capabilities, music storage and playback appliances with wireless communication capabilities, internet appliances with wireless internet access and browsing, or It may include terminals, but is not limited thereto.

Spreadsheet editing apparatus 100 according to an embodiment of the present invention corresponding to the user terminal 100 is a spreadsheet encoded with a computer instruction set to perform the spreadsheet editing method (S100) according to an embodiment of the present invention The editing application module 175 stores the file containing the.

The user terminal 100 may read the media in which the spreadsheet editing application module 175 which is not installed is stored and install it in the user terminal 100. The media includes optical storage media such as CD-ROMs and DVD-ROMs. In addition, the spreadsheet editing application module 175 may be provided in the form of a binary file downloaded from the server 200. The user terminal 100 may download various files from the server 200 via the network 400 and update the spreadsheet editing application module 175.

The spreadsheet editing application module 175 driven in the user terminal 100 may operate without the server 200 or in conjunction with the server 200. For example, the server 200 may correspond to a web server and / or a cloud server that drives the spreadsheet editing server module linked to the spreadsheet editing application module 175. In addition, the server 200 may include a file server for storing a file provided to the user terminal 100, an update server, an FTP server, and a database server, but is not limited thereto. The file server 200, the FTP server 200, and / or the update server 200 storing the spreadsheet editing application module 175 may be various files required by the user terminal 100, for example, a spreadsheet editing application module. A file, an extended application module file, and a service pack file are stored, and the user terminal 100 is connected to provide a reception / transmission or update of the files by file downloading.

In addition, the cloud server 200 may store all or part of the spreadsheet editing application module 175 in the cloud server 200 and provide the user terminal 100 to the user terminal 100 through the web server 200. Therefore, the user terminal 100 may receive all or a part of functions provided by the spreadsheet editing application module 175 through the remote cloud server 200 and / or the web server 200.

The backup server 200 storing the document stores the electronic document at the request of the user terminal 100, and enables the user terminal 100 to edit or view the document at any time.

In addition, the database server 200 stores document data, data for cloud services, web application data, and the like, and provides them to the user terminal 100 requesting them.

Network 400 may be a wired and wireless network, such as the Internet, intranet and extranet, cellular, such as a wireless telephone network, a local area network, a wide area network. ), A WiFi network, an ad hoc network, and a combination thereof.

Network 400 may include a connection of network elements such as hubs, bridges, routers, switches, and gateways. Network 400 may include one or more connected networks, such as a multi-network environment, including a public network such as the Internet and a private network such as a secure corporate private network. Access to network 400 may be provided through one or more wired or wireless access networks.

2 is a block diagram of a spreadsheet editing apparatus according to an embodiment of the present invention.

Referring to FIG. 2, the input device 110 may include a keyboard, a touch screen, a mouse, an electronic pen, and a voice input device, for example, a microphone, which inputs data for creating a document and information for setting various parameters of a user working environment. Including, but not limited to. Through substantially user input, input device 110 inputs text and objects into a document. Here, the character is a concept including numbers, symbols, and spaces, and the object includes various kinds of form objects such as icons, pictures, shapes, tables, and charts.

The display device 120 includes a cathode-ray tube (CRT), a liquid crystal display (LCD), a plasma display panel (PDP), and a light emitting device that perform frame output of an edit screen for document creation. Light emitting diode (LED) displays and organic light emitting diode (OLED) displays include, but are not limited to.

The output device 130 includes, but is not limited to, a printer, a plotter, a beam projector, a text to sound (TTS) device, a speaker, and an earphone.

The storage device 140 may be any type of removable / non-separable form of the spreadsheet editing device 100. The storage device 140 may be a magnetic type such as a magnetic tape, a magnetic drum, a floppy disk, a ZIP drive, and a hard disk drive (HDD). Electrical storage and CD-ROM drives, DVD-ROM drives, blu-ray discs using flash memory such as storage devices, SD cards, USB memory and solid state drives (SSDs) Optical storage devices, such as drives, include, but are not limited to.

The communication device 150 includes, but is not limited to, a communication module corresponding to various communication networks of the network 400, for example, a Bluetooth module, a WiFi module, an Ethernet interface card, a USB module, a cellular wireless communication module, a modem, and a wireless router. It doesn't happen. The communication device 150 includes a transmitter 151 and a receiver 152 therein.

The power supply unit 160 includes, but is not limited to, power supplies, adapters for converting AC to DC, secondary batteries such as SMPS and lithium ion batteries, lead acid batteries, fuel cells, and bioethanol batteries, and other primary batteries. It is not.

The controller 170 includes a processor, an operating system, and a memory region in which the spreadsheet editing application module 175 is loaded. The controller 170 executes a command set included in the spreadsheet editing application module 175 according to a user selection or setting. Hereinafter, the control unit 170 will be described in detail.

3 is a block diagram showing in detail the control unit of FIG. 2.

Referring to FIG. 3, the controller 170 may include a processor (Central Processing Unit, CPU) 178, an operating system 177, and a spreadsheet editing application module 175 related to a spreadsheet editing method according to an embodiment of the present invention. Includes a loaded memory 177. In more detail, the controller 170 may include a direct execution UI execution module 171 and a task selection module 172 including a computer instruction set for performing a spreadsheet editing method according to an embodiment of the present disclosure. , History module 173 and autocomplete module 174. The controller 170 controls each component and modules in the user terminal 100 to implement a spreadsheet editing method according to an embodiment of the present invention.

In detail, the control unit 170 receives a user input through the input device 110, a document creation process according to a spreadsheet editing method, an output process of a screen frame through the display 120 indicating a created document, Documents created through the output device 130, for example, a process of outputting a report or a drawing on paper or by voice, a process of storing the created document in the storage device 140, receiving or creating various data necessary for document creation The processor (CPU) configured in the controller 170 is a process for transmitting a document to the server 200 or an external terminal through the network 400 using the communication device 150 and the power supply process through the power supply 160 ( 178), an operating system (OS) 176, and a computer instruction set relating to a spreadsheet editing method according to an embodiment of the present invention. It is controlled by the memory 177 a spreadsheet editing application module 175 is loaded.

The operating system 176 is a computer operating program for managing a file system, various interfaces, and controlling operations of components of the user terminal 100. Operating system 176 includes, but is not limited to, operating systems of wired and mobile devices, for example, MS Windows, Unix, Linux, XOS, Android, iOS operating systems.

Spreadsheet editing application module 175 is an executable program configured to run on operating system 176 to provide various functionality as described herein. The spreadsheet editing application module 175 includes an office program capable of editing and / or viewing a document as described above.

The input device 110 included in the spreadsheet editing apparatus 100 may be a command for selecting an object to be copied, a copy or cut command, an object, in particular, in connection with the present invention, through a window provided by a user interface (UI). Enter the Select command and the Paste command of the place you want to paste.

A direct user interface (UI) according to an embodiment of the present invention provides a user interface optimized for keyboard operation. Specifically, the direct execution UI 14 includes a property window 15 indicating the property of an object, a code window 16 for editing various scripts, and a direct command window 17 for executing various commands.

The direct execution UI execution module 171 performs a function of executing and terminating the direct execution UI.

The job selection module 172 receives a user input to select a type of a job provided by the executed direct execution UI. In more detail, the user may select a macro menu or a script editing menu through the job selection module.

The history module 173 stores a command used in the direct command window 17 and provides a history function of calling a command again according to a user's instruction. The user can select and enter frequently used commands by using the keyboard direction keys through the history function.

The autocomplete module 174 provides a function to autocomplete a command when there is a reference available among the command keystrokes in the direct command window 17. The user can select and enter the referenced command only with keyboard arrow keys.

In addition, the direct command window 17 detects the caret of the keyboard and closes the open direct command window 17 and adds the code window 16 when the caret is not detected within the direct command window 17 for a predetermined time. Resize the code window 16 to make it wider.

In the configuration of the user terminal 100 illustrated in FIGS. 2 and 3, the configuration within the spreadsheet editing application module 175 is a functionally divided configuration for convenience of description, and is logically processed by one processor in hardware. It can be configured as a phosphorus function, it does not limit the invention by the presented division.

In addition, although the connection relationship between each configuration is shown as a connection line, or the connection relationship between each other is not expressed individually, communication or transmission for control or data exchange may occur even between the configuration where the connection line is not shown, and only as shown. It does not limit the invention.

The spreadsheet editing apparatus 100 according to an embodiment of the present invention may correspond to the computing device 500. Hereinafter, the spreadsheet editing apparatus 100 according to an embodiment of the present invention corresponding to the computing device 500 may be described in more detail.

The spreadsheet editing apparatus 100 may include a computing system composed of one or more central processing units (CPUs), memory, mass storage, an input interface device, and an output interface device. The elements of the computing system can communicate with each other via a bus.

The hardware platform of the computing device may be a distributed computing environment, such as a cloud based computing system, including any of a personal computer, handheld or laptop device, a multiprocessor system, a microprocessor based system, a program appliance, and any of the above systems or devices. It can be implemented in many forms, including.

4 is a block diagram of a computing device corresponding to a spreadsheet editing apparatus according to an embodiment of the present invention.

Referring to FIG. 4, the computing device 500 includes an input interface device 510, an output interface device 520, a memory 531, a storage device 532, a power supply 540, a processor 550, and a network interface. Device 560, wireless communication device 570, and bus 580.

The input interface device 510 inputs a character or an object necessary for editing a document according to a user's input. The input interface device 510 includes, but is not limited to, a keyboard, a touch screen, a mouse, a stylus pen, and a pen tablet.

The output interface device 520 includes a display for displaying a user interface related to the spreadsheet editing application module 175 and the like, and a printer for printing out a document. In addition, the output interface device 520 includes a speaker, a head-phone, and a headset for outputting text in a document as a speech using a text to speech (TTS) engine. do.

The processor 550 executes a computer instruction set included in the spreadsheet editing application module 175 relating to the spreadsheet editing method according to an embodiment of the present invention stored in the memory 531 and / or the storage device 532. Can be. The processor 550 may refer to a central processing unit (CPU), a graphics processing unit (GPU), or a dedicated processor on which the methods according to the present invention are performed. The memory 531 and the storage device 532 may be configured of a volatile storage medium and / or a nonvolatile storage medium. For example, the memory 531 may be configured as read only memory (ROM) and / or random access memory (RAM).

The wireless communication device 570 includes a device for short range wireless communication, wireless data communication, and wireless voice communication.

Each component included in the computing device 500 is connected by a bus 580 to communicate with each other.

2 and 3 illustrate a method for editing a spreadsheet according to an embodiment of the present invention performed by the spreadsheet editing apparatus 100 described above by performing computation of a computer instruction set included in the spreadsheet editing application module 175. This will be described with reference to FIGS. 5 to 7.

5 is a flowchart illustrating a spreadsheet editing method according to an embodiment of the present invention.

Each step included in the spreadsheet editing method S100 according to an embodiment of the present invention includes operations of an input device 110, for example, a mouse and a keyboard, by a user's manipulation.

Referring to FIG. 5, the spreadsheet editing method S100 according to an embodiment of the present invention includes steps S110 to S150.

First, the spreadsheet application module 175 may be executed according to a user input using the input device 11 (S110).

Next, in a spreadsheet edit, a direct user interface (UI) for editing various scripts or executing various commands to be provided in the main window is executed (S120). Here, the spreadsheet application module 175 may be executed with the direct execution module 175 activated by default according to the setting.

Next, a type of a job possible through the user interface, including an automation job, a function execution job, and a function generation job is selected (S130). The immediate UI can be used for macro tasks, script editing tasks, and other tasks. Thus, the user selects the kind of work to be performed in the execution step.

6 is an exemplary view of a spreadsheet editing screen according to an embodiment of the present invention.

Referring to FIG. 6, the direct execution UI 14 according to an embodiment of the present invention is located at the bottom of the main screen 10 on which the spreadsheet application module 175 is executed. It is not limited to this. The menu bar 11 and the menu icon 12 are positioned at the top of the main screen 10, and the cell 13 region is located at the middle of the main screen 10. In addition, a direct execution UI 14 according to an embodiment of the present invention is located under the cell 13 region.

7 is an exemplary view of a direct execution UI according to an embodiment of the present invention.

Referring to FIG. 7, the direct execution UI 14 includes a property window 15, a code window 16, and a direct command window 17. Each window has been described above.

Next, the user performs the selected task through the operation of the input device 110 (S140). For example, a user who chooses to work with a macro can run a previously created macro or record a new macro. Alternatively, the user who selects to edit the script may edit and execute the script using the property window 15, the code window 16, and the direct command window 17. In the editing process, the user may use the above-described history function and the autocomplete function. Referring to FIG. 7, a case where a command that has already been used by using the history function is selected is illustrated.

Finally, when the operation using the direct execution UI is terminated, the user may end the execution of the direct execution UI (S150).

Here, when the user does not use the direct command window 17 for a predetermined time, the direct command window 17 may be automatically terminated. That is, when a preset time elapses in which the active caret is not detected in the direct execution window, the direct execution UI execution module 171 automatically terminates the direct command window. The user can restore the direct command window 17 through an execution command as necessary.

Spreadsheet editing method (S1000) according to an embodiment described through the drawings may be implemented in the form of a recording medium including a command set executable by a computer, such as a program module executed by a computer. . Computer readable media can be any available media that can be accessed by a computer and includes both volatile and nonvolatile media, removable and non-removable media. In addition, computer readable media may include both computer storage media and communication media. Computer storage media includes both volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Communication media typically includes computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave, or other transmission mechanism, and includes any information delivery media.

As such, according to an embodiment of the present invention, a user interface suitable for keyboard operation is provided.

In addition, a direct execution UI is basically included in the cell edit screen without executing an application.

The foregoing description of the present invention is intended for illustration, and it will be understood by those skilled in the art that the present invention may be easily modified in other specific forms without changing the technical spirit or essential features of the present invention. will be. Therefore, it should be understood that the embodiments described above are exemplary in all respects and not restrictive. For example, each component described as a single type may be implemented in a distributed manner, and similarly, components described as distributed may be implemented in a combined form.

The scope of the present invention is shown by the following claims rather than the above description, and all changes or modifications derived from the meaning and scope of the claims and their equivalents should be construed as being included in the scope of the present invention. do.

100: user terminal, spreadsheet editing device
110: input device
120: display device
170: control unit
171: Immediate UI execution module
172: task selection module
173: history module
174: autocomplete module
175: Spreadsheet Editing Application Module
176: Operating system
177: memory
178: CPU
200: server
300: database
400: network
500: computing device

Claims (9)

In the spreadsheet editing method of the spreadsheet editing apparatus to execute a spreadsheet editing application to perform the edit,
Executing, by the spreadsheet editing apparatus, a direct user interface (UI) for editing various scripts or executing various commands to be provided in the main window in spreadsheet editing;
Selecting, by the user's input, a spreadsheet editing apparatus, a type of work possible through the user interface, including an automation job, a function execution job, and a function generation job;
Performing, by a spreadsheet editing apparatus, the selected operation according to an operation of an input device; And
Terminating, by the spreadsheet editing apparatus, execution of the direct execution UI;
Including,
Terminating the direct execution UI,
A spreadsheet editing device, characterized in that the spreadsheet editing device automatically exits the direct command window when a preset time has elapsed, in which no active caret is detected in the immediate window. The method according to claim 1,
The direct execution UI
A spreadsheet editing method comprising: a code window for editing various scripts, a property window indicating an object's properties, and a direct command window for executing various commands. delete The method according to claim 1,
Wherein the spreadsheet editing device further comprises the step of executing the spreadsheet program before the execution of the direct UI,
And said direct execution UI is activated by default in execution of said spreadsheet program in accordance with a setting. The method according to claim 2,
The direct command window
And a history function that stores the command that was used and recalls the command according to the user's instructions. A direct execution UI execution module for executing a direct user interface (UI) for editing various scripts or executing various commands to be provided in the main window in spreadsheet editing; And
A task selection module for selecting a kind of task available in the user interface, including an automation task, a function execution task, and a function creation task;
Including,
The direct execution UI execution module,
A spreadsheet editing apparatus, characterized in that the direct command window is automatically terminated when a preset time elapses, in which no active caret is detected in the direct execution window. The method according to claim 6,
The direct execution UI,
A spreadsheet editing apparatus, comprising: a code window for editing various scripts, a property window indicating property of an object, and a direct command window for executing various commands. delete The method according to claim 7,
And a history module for storing a command used in the direct command window and providing a history function of re-invoking the command according to a user's instruction.

Images