KR101999576B1 - Spreadsheet driving apparatus capable of performing fast function operations on selected cell range and operating method thereof - Google Patents

Abstract

Disclosed are a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell range and an operation method thereof. According to the present invention, the spreadsheet driving apparatus and operation method thereof may facilitate the convenience of a user by quickly calculating an operation result according to a frequently used function even if the user does not input a function command by inputting a previously designated first symbol so that the user may select a cell range on a specific cell and calculating a result value automatically having input as data in the cell range designated by the user since a previously designated function is called when a predetermined function key is inputted after the specific cell range is selected.

Description

BACKGROUND OF THE INVENTION 1. Field of the Invention [0001] The present invention relates to a spreadsheet driving apparatus capable of performing a quick function operation on a selected cell region, and a method of operating the spreadsheet driving apparatus.

The present invention relates to a technique for facilitating the use of a user's spreadsheet by performing a fast function operation in a spreadsheet.

2. Description of the Related Art [0002] Recently, various types of electronic document-related programs are being released, such as computers, smart phones, tablet PCs, and the like, which can be used to view, create, and edit electronic documents using such terminal devices.

Examples of such electronic document related programs include a word processor for basic document creation and editing, a data input, an arithmetic operation, a spreadsheet for supporting data management, and presentation programs for assisting presenters.

Of the above-mentioned electronic document related programs, spreadsheets are used for office work by supporting convenience of data management and supporting various function commands.

Normally, when a user desires to perform a mathematical operation through a spreadsheet, he or she inputs functional or formula commands for a plurality of cells constituting the spreadsheet. In this way, when a user inputs a function command or a formula command into a plurality of cells constituting a spreadsheet, the spreadsheet performs a mathematical operation on the basis of the function command or the formula command, and outputs the result of the mathematical operation.

Although spreadsheets support a wide variety of functions, general users tend to use only some functions, such as sum operations, average operations, and counting the number of cells in which data is inserted.

Therefore, when a user intends to perform a predetermined function operation on data inserted in a specific cell area in a spreadsheet, even if the user does not input a specific function operation instruction, It is necessary to study a technique that can facilitate the use of a user's spreadsheet by causing an operation according to frequently used representative functions to be performed quickly.

A spreadsheet driving apparatus capable of performing a fast function operation on a selected cell area according to the present invention and a method of operating the same include the steps of inputting a first symbol designated in advance so that a user can select a cell area on a specific cell, A predetermined function is called and a result value for automatically inputting the data of the cell area designated by the user is computed. Thus, even when the user does not input the function command, So that the result of the operation according to the function can be calculated quickly.

A spreadsheet drive apparatus capable of performing a fast function operation on a selected cell area according to an embodiment of the present invention includes a list of at least one function previously designated as a target of quick function application among a plurality of functions available in a spreadsheet A priority score table storage unit for storing and holding a priority score table in which predetermined different priority scores for each of the at least one function are recorded, a plurality of cells constituting the spreadsheet If a cell area selection command for at least one of the plurality of cells is applied after a first symbol designated in advance so that a cell area can be selected on the first cell by the user, A function list loading unit for loading the list from the list, A support function selection unit for selecting at least one first support function that is confirmed to support a function operation on data inserted in the at least one second cell of the at least one function, An order number assigning unit for assigning a function application order number according to a magnitude order of priority points recorded on the priority score table for each of the support functions; A selection unit for selecting a first function to which a function application sequence number of the highest priority among a first support function is assigned; and a selection unit for selecting data, which is inserted on the at least one second cell, 1 function as an input to calculate a first result value, and a result value calculator for calculating the first result value, And a value and a result value of the input display unit for input on the first cell.

Also, a method of operating a spreadsheet driver that can perform a fast function operation on a selected cell area according to an embodiment of the present invention includes: Storing a function list storing unit in which a list of functions of the at least one function is stored, storing and holding a priority score table in which predetermined different priority scores for each of the at least one function are recorded, If a cell selection command for at least one second cell among the plurality of cells is applied after a predetermined first symbol is inputted by the user so that the cell area can be selected on the first cell by the user, Loading the list from the function list storage unit, Selecting at least one first support function that is found to support a function operation on data inserted in the at least one second cell of the at least one first supporting function, Assigning a function application sequence number according to a magnitude order of preference points recorded on the priority score table; and if a predetermined function key for applying a function operation is input by the user, Selecting a first function to which a function application order number of the best order is assigned, when the first function is selected, inputting data inserted on the at least one second cell as input to the first function Calculating a first result value, and when the first result value is calculated, inputting the first result value on the first cell It includes the steps:

A spreadsheet driving apparatus capable of performing a fast function operation on a selected cell area according to the present invention and a method of operating the same include the steps of inputting a first symbol designated in advance so that a user can select a cell area on a specific cell, A predetermined function is called and a result value for automatically inputting the data of the cell area designated by the user is computed. Thus, even when the user does not input the function command, It is possible to quickly calculate the operation result according to the function of the user, thereby facilitating the user's convenience.

1 is a diagram illustrating a structure of a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region according to an embodiment of the present invention.
2 is a view for explaining the operation of a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region according to an embodiment of the present invention.
3 is a flowchart illustrating an operation method of a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region according to an embodiment of the present invention.

Hereinafter, embodiments according to the present invention will be described in detail with reference to the accompanying drawings. It is to be understood that the description is not intended to limit the invention to the specific embodiments, but includes all modifications, equivalents, and alternatives falling within the spirit and scope of the invention. Like reference numerals in the drawings are used for similar elements and, unless otherwise defined, all terms used in the specification, including technical and scientific terms, are to be construed in a manner that is familiar to those skilled in the art. It has the same meaning as commonly understood by those who have it.

1 is a diagram illustrating a structure of a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region according to an embodiment of the present invention.

1, a spreadsheet driving apparatus 110 capable of performing a fast function operation on a selected cell region includes a function list storage unit 111, a priority score table holding unit 112, a function list loading unit 113, A support function selection unit 114, an order assignment unit 115, a selection unit 116, a result value operation unit 117, and a result value input display unit 118.

Here, the spreadsheet driving apparatus 110 capable of performing a fast function operation on a selected cell region according to an exemplary embodiment of the present invention may be a system for viewing, creating, or sending a spreadsheet, such as a desktop PC, a mobile terminal, a PDA, Based on a variety of types of microprocessor-based devices capable of providing editing functions.

The function list storage unit 111 stores a list of at least one function previously designated as a target of quick function application among a plurality of functions available in the spreadsheet.

For example, the at least one function constituting the list may include 'SUM' which is a sum operation function for calculating a sum of data, 'AVERAGE' which is an average operation function for calculating an average value of data, Such as 'COUNT', which is a counting function for counting the number of cells in a spreadsheet.

At this time, the at least one function included in the list may be designated in advance by the developer, or may be designated by a method in which the user directly uses the spreadsheet to select functions that he / .

The priority score table retaining unit 112 stores and maintains a priority score table in which predetermined different priority scores for each of the at least one function are recorded.

For example, in the priority score table, information may be recorded as shown in Table 1 below.

Functions contained in the list Priority score SUM 10 points AVERAGE 8 points COUNT 6 points CONCATENATE 4 points

Here, the priority score assigned to each of the at least one function may be designated in advance by a developer in such a manner that a high score is set in order of functions determined to be important among at least one function included in the list, The user of the spreadsheet may be designated in such a manner that a high score is assigned according to a function order determined to be important among the at least one function.

The function list load unit 113 receives a first symbol from a plurality of cells constituting the spreadsheet so that the user can select a cell area on the first cell, When the cell region selection command for the second cell is applied, the list is loaded from the function list storage unit 111.

In this case, according to an embodiment of the present invention, the first symbol may be '='.

The support function selection unit 114 may include at least one first support function identified as supporting a function operation on data inserted in the at least one second cell of the at least one function included in the list, .

The sequence number assigning unit 115 assigns a function application sequence number to each of the at least one first support function according to the order of magnitude of priority points recorded on the priority score table.

The selection unit 116 selects a first function to which a function application sequence number of the highest priority among the at least one first support function is assigned, when a predetermined function key for application of a function operation is input by the user.

Here, the function key refers to a predetermined key that is set in advance for application of a function operation such as an 'F7' button or a 'shift' button in an input device such as a keyboard.

When the first function is selected, the result value operation unit 117 applies the data inserted on the at least one second cell as an input to the first function to calculate a first result value.

The result value input display unit 118 inputs the first result value on the first cell when the first result value is calculated.

In this case, according to an embodiment of the present invention, the selector 116 may further select the function key by the user within a predetermined reference time after the calculated first result value is input on the first cell A second function having a function application sequence number assigned to an order of a function application sequence assigned to the first function among the at least one first support function may be selected.

At this time, when the second function is selected, the result value operation unit 117 can input the data inserted in the at least one second cell as an input to the second function to calculate the second result value.

When the second result value is calculated, the result value input display unit 118 may re-input the second result value on the first cell.

Also, according to an embodiment of the present invention, the spreadsheet driving apparatus 110 capable of performing a fast function operation on a selected cell region may further include a priority score updating processing unit 119. [

Each time the at least one function is used once on the spreadsheet, the preference score updating processing unit 119 updates the priority score for each of the at least one function recorded on the priority score table corresponding to each function use For each of the at least one function, by an upward weight that is predetermined in order to raise the priority score.

In addition, according to an embodiment of the present invention, the spreadsheet driving apparatus 110 capable of performing a fast function operation on a selected cell region may further include a support attribute table holding unit 120.

The support attribute table storage unit 120 stores and maintains a support attribute table in which at least one data attribute information previously designated as being capable of being supported by each of the plurality of functions is recorded for each of the plurality of functions.

Here, the data attribute information means information that reveals the attribute of data inserted in a specific cell. When data called " patent " is inserted in a specific cell, the attribute of the data is 'text' If the data '12' is inserted in a specific cell, the attribute of the corresponding data may be 'number'.

In this regard, information may be recorded in the support attribute table as shown in Table 2 below.

A plurality of functions Supportable data attribute information SUM number COUNTIF Text, number AVERAGE number COUNT Text, number CONCATENATE text IF Text, number ... ...

At this time, the support function selection unit 114 may include an attribute confirmation unit 121, a non-support confirmation unit 122, and a support function selection completion unit 123.

When the list is loaded, the attribute checking unit 121 checks the attributes of the data inserted in the at least one second cell.

The unsupported confirmation unit 122 determines whether or not a function designated as not supporting the attribute of the data inserted in the at least one second cell on the support attribute table among the at least one function included in the list exists .

The support function selection completion unit 123 is a function designated as not supporting the attribute of the data inserted in the at least one second cell on the support attribute table among the at least one function, If the function is found to be present, the selection of the at least one first support function is completed by excluding the at least one first unsupported function of the at least one function.

According to an embodiment of the present invention, the spreadsheet driving apparatus 110 capable of performing a fast function operation on a selected cell region may further include a list box display unit 124.

If the display command for the list is applied by the user after the first result value is input on the first cell, the list box display unit 124 displays a predetermined neighbor And a list box in which the at least one function is listed in a predetermined direction.

In this case, when the selection input for the third function among the at least one function is applied by the user through the list box, the result value operation unit 117 outputs the third function to the at least one first support function The third result value can be calculated by applying the data inserted in the at least one second cell as an input to the third function, and the result value input display unit 118 can calculate the third result When the value is computed, the third result value can be re-entered on the first cell.

According to an embodiment of the present invention, if the list box display unit 124 determines that the at least one first unsupported function among the at least one function exists, To indicate that the functional operation is not supported for the at least one first unsupported function.

Hereinafter, an operation of the spreadsheet driving apparatus 110 capable of performing a quick function operation on a selected cell region according to an embodiment of the present invention will be described in detail with reference to FIG.

2 is a diagram for explaining the operation of the spreadsheet driving apparatus 110 capable of performing a fast function operation on a selected cell region according to an embodiment of the present invention.

First, since the functions 'SUM, AVERAGE, COUNT, CONCATENATE' are designated on the function list storage unit 111 as a target of quick function application, it is assumed that a list of the functions is stored, It is assumed that a priority score is recorded on the table as shown in Table 1 above, and information is recorded on the support attribute table as shown in Table 2 above.

As indicated by reference numeral 210 in FIG. 2, among a plurality of cells constituting the spreadsheet, a first symbol '=' (a first symbol designated in advance so that a user can select a cell region on the first cell 211) If the cell list selection command 214 for at least one second cell 213 among the plurality of cells is inputted after the input of the cell list selection command 214 from the function list storage unit 111, And the support function selection unit 114 supports a function operation on data inserted in at least one second cell 213 of 'SUM, AVERAGE, COUNT, CONCATENATE' included in the list At least one first support function that is identified as having the second support function.

At this time, the support function selection unit 114 includes an attribute confirmation unit 121, a non-support confirmation unit 122, and a support function selection completion unit 123 as a specific configuration for selecting the at least one first support function .

In this regard, when the list is loaded, the attribute checking unit 121 can check the attribute of the data inserted in the at least one second cell 213. If the data inserted in the at least one second cell 213 has the 'number' attribute in the embodiment of FIG. 2, the attribute checking unit 121 may determine that the data stored in the at least one second cell 213 The attribute of the inserted data can be confirmed by 'number'.

Then, the unsupported verification unit 122 supports the attribute of the data inserted in the at least one second cell 213 on the support attribute table of 'SUM, AVERAGE, COUNT, CONCATENATE' included in the list Check whether the function specified as not exists.

Since the information is recorded as supporting only 'text' attribute on 'CONCATENATE' on the support attribute table as shown in Table 2, the support function selection completion unit 123 'CONCATENATE' among 'SUM, AVERAGE, COUNT, CONCATENATE' Only the SUM, AVERAGE, and COUNT ', which are excluded, can be selected as the at least one first support function.

When 'SUM, AVERAGE, COUNT' is selected as the at least one first supporting function, the order assigning unit 115 assigns priority scores to each of 'SUM, AVERAGE, COUNT' The sequence number of the function can be assigned according to the order of magnitude of the function.

In the priority score table as shown in Table 1, since the priority score is assigned in the order of 'SUM, AVERAGE, COUNT', the order assigning unit 115 assigns 'SUM', 'AVERAGE' '2 sequence number' for 'COUNT', and '3 sequence number' for 'COUNT'.

Then, when a predetermined function key for application of a functional operation is input by the user, the selection unit 116 can select 'SUM' to which a function application sequence number of 'SUM, AVERAGE, COUNT' have.

For example, if the function key is a key input according to the 'F7' button existing on the keyboard, if the user inputs the 'F7' button, the selection unit 116 can select 'SUM'.

When 'SUM' is selected, the result operation unit 117 receives data inserted in at least one second cell 213 as an input to 'SUM', as indicated by reference numeral 220 , And '21' (221).

Then, the result value input display unit 118 can input '21' 221, which is the calculated result value, on the first cell 211 as shown in the figure 220.

As a result, the spreadsheet driving apparatus 110 capable of performing a fast function operation on the selected cell region according to the present invention can be configured such that the user can select a cell region on a specific cell If a predetermined function key is input after a first symbol is input and a specific cell region is selected, a predefined predetermined function is called to automatically calculate a result value for inputting data of a cell region designated by the user, Even if the user does not input the function command, the operation result according to the frequently used function can be calculated quickly, and the convenience of the user can be improved.

21 'is calculated and input on the first cell 211 corresponding to the user's function key input according to the above-described process, the function key is further input by the user within a predetermined reference time The selection unit 116 can select 'AVERAGE' which is a function to which a function application sequence number corresponding to the order of function application sequence assigned to 'SUM' among 'SUM, AVERAGE, COUNT' is allocated.

In this case, when 'AVERAGE', which is an average value calculation function, is selected according to the additional input of the function key, the result value operation unit 117 inputs data inserted in at least one second cell 213 into 'AVERAGE' , It is possible to calculate a result value of " 3.5 ".

Then, the result input display unit 118 can re-input the calculated result value '3.5' on the first cell 211.

Thereafter, when the user further inputs the function key again within the predetermined reference time, the selection unit 116 can select 'COUNT' to which the next function application sequence number is assigned, and the result calculation unit 117 ) Can perform a function operation on at least one second cell 213 using 'COUNT', and the result input display unit 118 re-inputs the calculated result value on the first cell 211 can do.

That is, each time the user inputs a function key, the spreadsheet driving apparatus 110 capable of performing a quick function operation on the selected cell area according to the present invention is configured to execute 'SUM, AVERAGE, COUNT' So that the user can quickly obtain the result of various function operations by supporting the input of the operation result value according to the function of the function in the order of the function application order number assigned to each function.

In this case, the spreadsheet driving apparatus 110 capable of performing a quick function operation on a selected cell region according to an embodiment of the present invention can change the priority of a function to be automatically operated according to a function usage pattern of a user The priority score update processing unit 119 may be further included.

Each time the 'SUM, AVERAGE, COUNT, CONCATENATE' is used once on the spreadsheet, the priority score updating processing unit 119 updates the priority score table 'SUM , AVERAGE, COUNT, and CONCATENATE ', by multiplying the priority score of each of' AVERAGE, COUNT, CONCATENATE 'by a predetermined weight, which is predetermined in order to increase the priority score, .

For example, when the user uses the function 'SUM' on the spreadsheet when the upward weight is' 1.1 ', the priority score update processing unit 119 updates the priority score table' SUM Quot; 11 " by multiplying the upward weighting value with the " 10 points "

In addition, according to an embodiment of the present invention, after a result value of '21' (221) is inputted on the first cell 211 as shown in a reference numeral 220, 'SUM', AVERAGE, COUNT, and CONCATENATE ', the list box display unit 124 displays a list of the first cell 211 on the basis of the first cell 211 as shown in FIG. SUM, AVERAGE, COUNT, CONCATENATE 'are displayed in the selected direction.

At this time, when a selection input for a specific function among 'SUM, AVERAGE, COUNT, CONCATENATE' is applied by the user through the list box 231, the result operation unit 117 outputs the selected input function to the at least one If the function is included in the first supporting function 'SUM, AVERAGE, COUNT', data inserted in at least one second cell 213 can be input to the selected input function to calculate a new result value have.

For example, if the user selects 'AVERAGE' which is a function for performing an average value operation among 'SUM, AVERAGE, COUNT, CONCATENATE' through the list box 231, 'AVERAGE' SUM ',' AVERAGE ', and' COUNT ', the result value operation unit 117 applies data inserted in at least one second cell 213 to' AVERAGE ' The result value can be calculated.

When the calculation of the new result value is performed, the result input display unit 118 can re-input the calculated new result value on the first cell 211.

As described above, the spreadsheet driving apparatus 110 capable of performing the fast function operation on the selected cell area according to the present invention automatically selects the highest priority It is possible to calculate the calculation result according to the function of the rank and at the same time to give the user the option of selecting the calculation result according to the specific function, so that the convenience of the user's spreadsheet can be further enhanced.

According to one embodiment of the present invention, a 'CONCATENATE' function among 'SUM, AVERAGE, COUNT, and CONCATENATE' is a function of receiving data inserted in at least one second cell 213 through the non- The list box display unit 124 displays a list box 231 in the list box 231 in order to induce the user to select 'CONCATENATE' among 'SUM, AVERAGE, COUNT, CONCATENATE' The selected highlighting effect can be displayed to indicate that the function operation is not supported for 'CONCATENATE' among 'SUM, AVERAGE, COUNT, CONCATENATE'.

For example, the list box display unit 124 can display the selected highlighting effect in such a manner that the character 'CONCATENATE' is displayed in a color different from the color of the letters of other functions, or the size of the character is made large or small have.

3 is a flowchart illustrating an operation method of a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region according to an embodiment of the present invention.

In step S310, a function list storing unit stores a list of at least one function that is designated as a target of quick function application among a plurality of functions available in the spreadsheet.

In step S320, a priority score table in which predetermined different priority scores are recorded for each of the at least one function is stored and maintained.

In step S330, a first symbol, which is designated in advance so that the user can select a cell area on the first cell, is inputted by a user among a plurality of cells constituting the spreadsheet, The list is loaded from the function list storage unit.

In operation S340, at least one first support function that is confirmed to support a function operation on data inserted in the at least one second cell among the at least one function included in the list is selected .

In step S350, a function application sequence number is assigned to each of the at least one first support function according to the order of magnitude of priority points recorded on the priority score table.

In step S360, when a predetermined function key for application of a functional operation is input by the user, a first function to which a function application sequence number of the highest priority among the at least one first support function is assigned is selected.

In step S370, when the first function is selected, data inserted on the at least one second cell is input to the first function to calculate a first result value.

In operation S380, when the first result value is calculated, the first result value is input on the first cell.

According to another aspect of the present invention, there is provided a method of operating a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region, the method comprising: after the calculated first result value is input on the first cell, When the function key is additionally input by the user within a predetermined reference time, a function application sequence number corresponding to the order of the function application sequence assigned to the first function among the at least one first support function is allocated Selecting a second function, when the second function is selected, applying data inserted on the at least one second cell to the second function as an input to calculate a second result value, 2 < / RTI > result is computed, re-inputting the second result value on the first cell.

According to another aspect of the present invention, there is provided a method of operating a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region, the method comprising: A priority score for each of the at least one function recorded on the priority score table in response to a function use is multiplied by an upward weight designated in advance in order to raise the priority score, And processing the update of the score.

According to another aspect of the present invention, there is provided a method of operating a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region, the method comprising: And a step of storing and maintaining a support attribute table in which at least one data attribute information designated in advance is recorded.

At this time, in step S340, when the list is loaded, it is checked whether the attribute of the data inserted in the at least one second cell is confirmed. If the list of the at least one function included in the list Determining whether there is a function designated to not support the attribute of the data inserted in the at least one second cell, and determining whether the at least one second cell If at least one first unsupported function is found to exist in the function designated to not support the attribute of the data inserted in the at least one function, And completing the selection of the at least one first support function.

In this case, according to an embodiment of the present invention, a method of operating a spreadsheet driving apparatus capable of performing a quick function operation on the selected cell region includes: after the first result value is input on the first cell, Displaying a list box where the at least one function is arranged in a selected direction at a neighboring point selected on the basis of the first cell when a display command for the list is applied by the user, Box if a selection input for a third function of the at least one function is applied and if the third function is a function included in the at least one first support function is inserted on the at least one second cell Calculating a third result value by applying data having the third result as an input to the third function, and when the third result value is calculated, The may further comprise the step of the first input member in the first cell.

According to an embodiment of the present invention, the step of displaying the list box may include the step of, when it is determined that the at least one first unsupported function among the at least one function exists, And display a selected highlighting effect indicating that the function operation is not supported for the at least one first unsupported function among the functions.

3, a description has been given of a method of operating a spreadsheet driving apparatus capable of performing a fast function operation on a selected cell region according to an embodiment of the present invention. Here, the operation method of the spreadsheet driving apparatus capable of performing the fast function operation on the selected cell region according to an embodiment of the present invention is as follows. That is, the fast function operation on the selected cell region described with reference to FIG. 1 and FIG. The operation of the spreadsheet driving apparatus 110 can be matched with the configuration of the spreadsheet driving apparatus 110, so that a detailed description thereof will be omitted.

The operation method of the spreadsheet driving apparatus capable of performing the fast function operation on the selected cell area according to an embodiment of the present invention can be implemented by a computer program stored in a storage medium for execution through a combination with a computer.

In addition, the method of operating the spreadsheet driving apparatus capable of performing a quick function operation on a selected cell region according to an exemplary embodiment of the present invention may be implemented in the form of a program command that can be executed through various computer means, Lt; / RTI > The computer-readable medium may include program instructions, data files, data structures, and the like, alone or in combination. The program instructions recorded on the medium may be those specially designed and constructed for the present invention or may be available to those skilled in the art of computer software. Examples of computer-readable media include magnetic media such as hard disks, floppy disks and magnetic tape; optical media such as CD-ROMs and DVDs; magnetic media 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 machine language code such as those produced by a compiler, as well as 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 with reference to particular embodiments, such as specific elements, and specific embodiments and drawings. However, it should be understood that the present invention is not limited to the above- And various modifications and changes may be made thereto by those skilled in the art to which the present invention pertains.

Accordingly, the spirit of the present invention should not be construed as being limited to the embodiments described, and all of the equivalents or equivalents of the claims, as well as the following claims, belong to the scope of the present invention .

110: Spreadsheet driver capable of performing fast function operation on selected cell area
111: function list storage unit 112: priority score table storage unit
113: Function list load unit 114: Support function selection unit
115: order number assignment unit 116: selection unit
117: Result value operation unit 118: Result value input display unit
119: priority score update processing unit 120: support attribute table maintenance unit
121: Attribute checking unit 122:
123: Support function selection completion unit 124: List box display unit

Claims (14)

A function list storage unit storing a list of at least one function preliminarily designated as a target of quick function application among a plurality of functions available in the spreadsheet;
A priority score table holding unit for storing and holding a priority score table in which predetermined different priority scores for each of the at least one function are recorded;
After a predetermined first symbol is inputted by the user so that the cell area can be selected on the first cell among the plurality of cells constituting the spreadsheet, the cell area selection for at least one of the plurality of cells A function list load unit loading the list from the function list storage unit when the command is given;
A support function selection unit that selects at least one first support function that is confirmed to support a function operation on data inserted in the at least one second cell among the at least one function included in the list;
An order assigning unit for assigning a function application order number according to a magnitude order of priority points recorded on the priority score table for each of the at least one first support function;
A selection unit for selecting a first function to which a function application sequence number of the highest priority among the at least one first support function is assigned, when a predetermined function key for application of a function operation is input by the user;
A result computation unit operable to apply the data inserted on the at least one second cell to the first function and to calculate a first result value when the first function is selected; And
A result input display unit for inputting the first result value on the first cell when the first result value is calculated,
And performing a fast function operation on a selected cell region including the selected cell region. The method according to claim 1,
The selection unit
If the function key is further input by the user within a predetermined reference time after the computed first result value is input on the first cell, then the first function of the at least one first support function Selecting a second function to which a function application sequence number corresponding to an order of the allocated function application sequence is assigned,
The result value calculation unit
If the second function is selected, applying data inserted on the at least one second cell to the second function as an input to calculate a second result value,
The result value input display unit
Wherein the fast function operation for the selected cell area in which the second result value is re-input on the first cell is performed when the second result value is calculated. The method according to claim 1,
Incrementing the priority score for each priority score for each of the at least one function recorded on the priority score table in response to each use of the function each time the at least one function is used once on the spreadsheet A priority score updating processing unit for updating the priority score of each of the at least one function by multiplying a predetermined weight
And performing a fast function operation on the selected cell area. The method according to claim 1,
For each of the plurality of functions, a support attribute table in which at least one data attribute information previously designated as being capable of being supported by each of the plurality of functions is recorded,
Further comprising:
The support function selection unit
An attribute verifying unit for verifying an attribute of data inserted in the at least one second cell when the list is loaded;
Checking whether or not a function specified as not supporting the attribute of data inserted in the at least one second cell on the support attribute table among the at least one function included in the list exists part; And
If it is determined that at least one first non-resource function exists in the function designated as not supporting the attribute of the data inserted in the at least one second cell on the support attribute table among the at least one function, A support function selection completion unit which completes selection of the at least one first support function by excluding the at least one first unsupported function among the at least one function,
And performing a fast function operation on a selected cell region including the selected cell region. 5. The method of claim 4,
Wherein when the display command for the list is applied by the user after the first result value is input on the first cell, the at least one function is added to a predetermined neighboring point based on the first cell, A list box display section for displaying a list box listed in a predetermined direction
Further comprising:
The result value calculation unit
If the selection input for the third function of the at least one function is applied by the user through the list box and the third function is a function included in the at least one first support function, A third result value is calculated by applying data inserted in two cells to the third function as an input,
The result value input display unit
Wherein the fast function operation for the selected cell area in which the third result value is re-input on the first cell is performed when the third result value is calculated. 6. The method of claim 5,
The list box display section
If the at least one first unsupported function of the at least one function is found to exist, then it does not support function operations on the at least one first unsupported function of the at least one function in the list box And performing a fast function operation on the selected cell area indicating the selected highlighting effect indicating the selected highlight area. Maintaining a function list storage unit in which a list of at least one function previously designated as a target of quick function application among a plurality of functions available in the spreadsheet is stored;
Storing a priority score table holding and storing a priority score table in which predetermined different priority scores for each of said at least one function are recorded;
A function list loading unit is provided for inputting a predetermined first symbol so that a user can select a cell area on the first cell among a plurality of cells constituting the spreadsheet, Loading the list from the function list storage unit when a cell region selection command for the function list is granted;
The support function selector selects at least one first support function identified as supporting a function operation on data inserted in the at least one second cell of the at least one function included on the list step;
Assigning a function application sequence number according to a magnitude order of priority points recorded on the priority score table for each of the at least one first support function;
Selecting a first function to which a function application sequence number of the highest priority among the at least one first support function is assigned if a predefined function key for applying a function operation is input by the user;
If the first function is selected, the result value operation unit applies data inserted on the at least one second cell to the first function as an input to calculate a first result value; And
When the first result value is calculated, the result input display unit inputs the first result value on the first cell
And performing a fast function operation on a selected cell area including the selected cell area. 8. The method of claim 7,
Wherein the selection unit is configured to determine whether the function key is further input by the user within a predetermined reference time after the calculated first result value is input on the first cell, Selecting a second function to which a function application sequence number assigned to the order of function application sequence assigned to the first function is assigned;
When the second function is selected, applying the data inserted on the at least one second cell to the second function as an input to calculate a second result value; And
The result input display unit may further include a step of re-inputting the second result value on the first cell when the second result value is calculated
And performing a quick function operation on a selected cell region further including a second cell region and a second cell region. 8. The method of claim 7,
A preference score updating unit for calculating a preference score for each of the at least one function recorded on the priority score table corresponding to each function usage each time the at least one function is used once on the spreadsheet And processing an update of the priority score for each of the at least one function by multiplying the upward weight,
And performing a quick function operation on a selected cell region further including a second cell region and a second cell region. 8. The method of claim 7,
Storing a support attribute table in which at least one data attribute information previously designated as being capable of being supported by each of the plurality of functions is recorded for each of the plurality of functions,
Further comprising:
Wherein selecting the at least one first assistance function comprises:
Confirming an attribute of data inserted in the at least one second cell when the list is loaded;
Wherein the non-support confirmation unit determines whether or not there is a function designated as not supporting the attribute of the data inserted in the at least one second cell on the support attribute table among the at least one function included in the list Checking; And
Wherein at least one of the at least one function is designated as not supporting the attribute of data inserted in the at least one second cell on the support attribute table, and at least one first unsupported function exists Completing the selection of the at least one first support function by excluding the at least one first unsupported function of the at least one function,
And performing a fast function operation on a selected cell area including the selected cell area. 11. The method of claim 10,
If a display command for the list is applied by the user after the first result value is input on the first cell, the list box display unit displays a list of the predetermined cells on a predetermined adjacent point based on the first cell Displaying a list box in which the at least one function is listed in a predetermined direction;
Wherein the result computation unit is operable, when a selection input for a third function of the at least one function is applied by the user through the list box, the third function being a function included in the at least one first support function Computing a third result by applying data inserted on the at least one second cell to the third function as an input; And
The result input display unit may include a step of re-inputting the third result value on the first cell when the third result value is calculated
And performing a quick function operation on a selected cell region further including a second cell region and a second cell region. 12. The method of claim 11,
The step of displaying the list box
Wherein if the at least one first unsupported function of the at least one function is found to be present, then the list box display unit displays, for the at least one first unsupported function of the at least one function in the list box, Wherein a fast function operation is performed on a selected cell area indicating a selected highlighting effect indicating that the operation is not supported. 13. A computer-readable recording medium recording a computer program for executing the method according to any one of claims 7 to 12 through a combination with a computer. 13. A computer program stored in a storage medium for executing the method of any one of claims 7 to 12 through a combination with a computer.

Images