KR101368627B1 - Method for providing function guide based on excel and system there of - Google Patents

Abstract

The present invention relates to an Excel guide technology, the method for providing an Excel function guide according to an embodiment of the present invention is based on an Excel program running in a user terminal. The method of providing an Excel function guide may include (a) extracting a function supported by the Excel program or a parameter set for the corresponding function from data stored in a specific cell, and (b) at least one argument cell is included in the parameter set. If present, extracting an address for the at least one factor cell or a value stored in the factor cell; and (c) generating a graphical interface capable of providing the function or the argument set visually, and generating the graphical interface. And superimposing the data on at least a portion of an Excel screen currently being displayed. According to the present invention, by providing information on a function inputted in a specific cell or arguments of the corresponding function through a separate visual interface, the contents of the specific cell can be provided more conveniently and quickly visually without changing the screen. It works.

Description

How to provide Excel function guide and its system {METHOD FOR PROVIDING FUNCTION GUIDE BASED ON EXCEL AND SYSTEM THERE OF}

The present invention relates to an Excel guide technology, and more particularly, by providing information on a function inputted to a specific cell or a parameter of the corresponding function through a separate visual interface, the contents of a specific cell can be visualized more conveniently and quickly. The present invention relates to an Excel function guide providing method and a system thereof.

The Excel program is a general-purpose office program, and is one of the main programs used in various environments such as being used not only in a personal computer but also in a portable terminal according to the development of the portable terminal.

In the case of the conventional Excel program, in order to obtain information about a function input to a specific cell, it is troublesome to press the specific key (for example, F2) to check the function itself applied to the cell.

Also, in the case of information displayed by pressing a specific key, only the name of the function and the address of the row and column position of the cell applied in the function are output. In order to check the actual parameter value applied to the function, There was an inconvenience of having to check the focus by moving the focus to the cell used.

FIG. 1 is a screen illustrating an example of such a conventional Excel screen, and displays cells applied as factors with respect to a function applied to a specific cell in a different color as shown in the example of FIG. However, in the conventional Excel, as shown in (b), there are limitations in that it is difficult to identify a cell that is an argument of a function when it is invisible or far from one screen.

In particular, when the conventional technologies are applied in a mobile device having a small screen, a lot of input is required, such as switching to or moving a screen to find a cell applied as a corresponding factor to check the contents as a real factor. There are many limitations, including the very low efficiency of the jacket and the inconvenience of use.

The present invention provides an information on a function input to a specific cell or an argument of a corresponding function through a separate visual interface, thereby providing an Excel function that can more conveniently and visually provide the contents of a specific cell without screen switching. We want to provide guided technology.

In addition, the present invention is to extract the function or argument, based on the presence or absence of the operator is essential to apply the function in the Excel program, it is possible to extract the function or argument faster than the simple parsing method To provide an Excel function guide providing technology.

Among the embodiments, the method for providing an Excel function guide is based on an Excel program running in a user terminal. The method of providing an Excel function guide may include (a) extracting a function supported by the Excel program or a parameter set for the corresponding function from data stored in a specific cell, and (b) at least one argument cell is included in the parameter set. If present, extracting an address for the at least one factor cell or a value stored in the factor cell; and (c) generating a graphical interface capable of providing the function or the argument set visually, and generating the graphical interface. And superimposing the data on at least a portion of an Excel screen currently being displayed.

In an embodiment, the step (a) may include checking whether a value corresponding to the first character of the data stored in the specific cell corresponds to the operator '=' and if the result is not '=', storing the stored data. And extracting as a number.

In one embodiment, the step (a) further comprises the step of extracting the function or the argument for the function by parsing the data after the first character of the data, if '=' as a result of the check; can do.

In one embodiment, the step (b) is a step of checking whether a factor cell corresponding to a cell address format exists in the factor set, and if the result of the checking, if present, the step (a) for the address of the factor cell It may include the step of performing.

In one embodiment, the step (b) is a step of checking whether there are a plurality of factor cells corresponding to the cell address format in the factor set and as a result of the check if the present and the plurality of factor cells have a mutually consecutive address, The method may include identifying cells corresponding to the beginning and the end of the addresses consecutively among the plurality of factor cells, respectively.

In an embodiment, the step (c) may include generating the address of the first and last cells or a value stored therein as a predetermined table and visually showing the generated table to generate the graphical interface. It may include.

In an embodiment, the step (c) may include visually generating at least one arrow from the specific cell to at least one factor cell included in the factor set and visually generating the at least one arrow. And generating the graphical interface.

In an embodiment, the step (c) may include checking whether at least one factor cell included in the factor set is included in a screen of an Excel program currently being displayed, and if not, the at least one factor cell is included. And reducing the screen of the currently displayed Excel program to be included.

Among the embodiments, the Excel function guide providing system is based on an Excel program running in the user terminal. The Excel function guide providing system includes a cell information extracting unit, a graphic interface unit, and a control unit. The cell information extractor extracts a function supported by the Excel program or a parameter set for the corresponding function from data stored in a specific cell. The graphic interface unit generates a graphic interface capable of providing the function or argument set visually. The controller checks whether a factor cell exists in a factor set extracted by the cell information extractor, and if so, controls to extract a function or a factor set for the factor cell in the cell information extractor, and Provides a function or a parameter set to the graphic interface unit to display the generated graphic interface by overlapping the generated graphic interface in at least a part of the currently displayed Excel screen.

In one embodiment, the cell information extraction unit checks whether a value corresponding to the first character of the data stored in the specific cell corresponds to the operator '=', and if '=', the data after the first character of the data Parsing may be performed to extract the function or the argument of the corresponding function. If the value is not '=', the stored data may be extracted as a number.

In an embodiment, the graphic interface unit may visually generate at least one arrow from the specific cell to at least one factor cell included in the factor set, and may generate the graphic interface.

Among the embodiments, the recording medium records a program for executing the method for providing an Excel function guide. The program is a program for providing an Excel function guide providing method based on an Excel program driven in a user terminal. (A) From a data stored in a specific cell, a function supported by the Excel program or a parameter set for the corresponding function is provided. (B) extracting an address for the at least one factor cell or a value stored in the factor cell if the factor set includes at least one factor cell; and (c) the function or the factor. And generating a graphic interface capable of providing the set visually and superimposing the generated graphic interface on at least a portion of an Excel screen being displayed.

According to the present invention, by providing information on a function inputted in a specific cell or arguments of the corresponding function through a separate visual interface, the contents of the specific cell can be provided more conveniently and quickly visually without changing the screen. It works.

In addition, according to the present invention, in extracting a function or an argument, the extraction is performed based on the presence or absence of an operator that is essential to apply a function in an Excel program, so that the function or the argument can be extracted faster than a simple parsing method. It can be effective.

1 is a reference diagram illustrating an example of a conventional Excel screen.
2 is a reference diagram for explaining an embodiment of an Excel function guide providing system according to the present invention.
FIG. 3 is a diagram illustrating an example embodiment of the graphic interface unit of FIG. 2.
4 is a flowchart illustrating an embodiment of a method for providing an Excel function guide according to the present invention.
5 to 10 are reference diagrams illustrating an example of an Excel guide providing interface according to the present invention.

The description of the present invention is merely an example for structural or functional explanation, and the scope of the present invention should not be construed as being limited by the embodiments described in the text. That is, the embodiments are to be construed as being variously embodied and having various forms, so that the scope of the present invention should be understood to include equivalents capable of realizing technical ideas.

Meanwhile, the meaning of the terms described in the present invention should be understood as follows.

The terms "first "," second ", and the like are intended to distinguish one element from another, and the scope of the right should not be limited by these terms. For example, the first component may be referred to as a second component, and similarly, the second component may also be referred to as a first component.

It is to be understood that when an element is referred to as being "connected" to another element, it may be directly connected to the other element, but there may be other elements in between. On the other hand, when an element is referred to as being "directly connected" to another element, it should be understood that there are no other elements in between. On the other hand, other expressions describing the relationship between the components, such as "between" and "immediately between" or "neighboring to" and "directly neighboring to", should be interpreted as well.

It should be understood that the singular " include "or" have "are to be construed as including a stated feature, number, step, operation, component, It is to be understood that the combination is intended to specify that it does not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, or combinations thereof.

In each step, the identification code (e.g., a, b, c, etc.) is used for convenience of explanation, the identification code does not describe the order of each step, Unless otherwise stated, it may occur differently from the stated order. That is, each step may occur in the same order as described, may be performed substantially concurrently, or may be performed in reverse order.

The present invention can be embodied as computer-readable code on a computer-readable recording medium, and the computer-readable recording medium includes all kinds of recording devices for storing data that can be read by a computer system . Examples of the computer-readable recording medium include a ROM, a RAM, a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like, and also implemented in the form of a carrier wave (for example, transmission over the Internet) . In addition, the computer-readable recording medium may be distributed over network-connected computer systems so that computer readable codes can be stored and executed in a distributed manner.

All terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs, unless otherwise defined. Commonly used predefined terms should be interpreted to be consistent with the meanings in the context of the related art and can not be interpreted as having ideal or overly formal meaning unless explicitly defined in the present invention.

2 is a reference diagram for explaining an embodiment of an Excel function guide providing system according to the present invention.

An embodiment of the Excel function guide providing system 300 disclosed in FIG. 2 may be operated on the user terminal 100 and may be provided based on the Excel program 200. That is, the Excel function guide providing system 300 may provide an Excel function guide in association with the user terminal 100 or the Excel program 200 while the Excel program 200 is running.

The user terminal 100 is a computing device including both a fixed terminal such as a PC, a mobile terminal such as a tablet PC and a smart phone. The user terminal 100 is a computing device capable of driving an Excel program including an input unit 110, a memory unit 120, a display unit 130, and a terminal control unit 140.

The input unit 110 is a means for receiving input information from a user, and may be implemented as various input means such as a touch screen, a keyboard, a mouse, and the like.

The memory unit 120 is a storage means for storing predetermined data, and may be implemented as various storage means such as a volatile or nonvolatile memory and a hard disk drive.

The display unit 130 is a means for visually displaying information to a user, and may be implemented as various display means such as a touch screen, a monitor, an image transmitting means, and the like.

The terminal controller 140 may control the user terminal 100 to provide various functions to the user. As shown in the illustrated example, the terminal controller 140 may be implemented as an operating system.

The terminal controller 140 may drive the Excel program 200 and provide the same to the user.

The terminal controller 140 may be directly or indirectly linked to the Excel function guide providing system 300. For example, to provide a user input input through the input unit 110 to the Excel function guide providing system 300, or to display the content provided from the Excel function guide providing system 300 to the user through the display unit 130 can do.

3 is a configuration diagram illustrating an embodiment of the graphic interface unit of FIG. 2. Hereinafter, an embodiment of the Excel function guide providing system 300 will be described in detail with reference to FIGS. 2 to 3.

Referring to FIG. 2, the Excel function guide providing system 300 may include a cell information extracting unit 310, a control unit 320, and a graphic interface unit 330.

The cell information extracting unit 310 may extract a function supported by the Excel program 200 or a parameter set for the corresponding function from data stored in a specific cell. Here, the argument set may include arguments for the function if the function exists in a specific cell, and may include data itself stored in the specific cell if the function does not exist in the specific cell. . For example, when '6' is stored in cell A1, the argument set may include '6' as an element. In another example, '= sum (A2: A4)' is stored in cell A1. The argument set may include 'A2' to 'A4' as elements.

In one embodiment, the cell information extractor 310 may extract a function or value stored in a specific cell by checking whether the first character of the data stored in the specific cell is a specific operator. In more detail, the cell information extracting unit 310 checks whether a value corresponding to the first character of data stored in a specific cell corresponds to the operator '=', and if not, extracts the stored data as a number. can do. On the other hand, if '=', the function after the first character of the data can be parsed to extract a function or arguments for the function. Such an embodiment uses a function application rule of the Excel program 200 (that is, a rule in which an operator '=' is first input in a cell to which a function is applied), and more efficiently parsing the content of a specific cell. By doing so, it is possible to extract the contents of a specific cell with fast and low resources.

The controller 320 may control the other components of the Excel function guide providing system 300 to provide an Excel function guide.

The controller 320 may be linked with the Excel program 200 or the user terminal 100 to provide an Excel function guide to the user.

According to an embodiment, the controller 320 may determine whether a factor cell (a cell designated as a function factor) exists with respect to the factor set extracted by the cell information extractor 310. For example, the controller 320 may check the format in which the cell is displayed in the Excel program 200, and search for a factor set to determine whether an element corresponding to the format exists. If present, the controller 320 may recognize the element as a factor cell and check the address of the factor cell. For example, in the case of an Excel program that classifies cells as alphabets and numbers, such as A11, the controller 320 checks the elements formed by the sum of the alphabets and numbers as argument cells, and displays the corresponding letters and numbers as addresses of the corresponding argument cells. Can be.

In an embodiment, the controller 320 may control the cell information extractor 310 to extract information on the factor cell. When the identification information (address) of the factor cell is described as data stored in a specific cell, the present invention should extract the content of the factor cell in order to display the content of the factor cell. To extract information about.

In one embodiment, if there are a plurality of consecutive factor cells in the factor set, the controller 320 may identify cells corresponding to the first and last of the successive factor cells, respectively. In more detail, as described above, the controller 320 may determine whether there are a plurality of factor cells corresponding to the cell address format in the factor set using the cell address format of the Excel program. As a result of the checking, if there are a plurality of factor cells, the controller 320 may check whether the plurality of factor cells have a contiguous address and identify cells corresponding to the beginning and the end of the contiguous address.

In one embodiment, the controller 320 may determine whether the print cells are displayed on the screen of the Excel program currently being displayed to enlarge or reduce the screen of the Excel program. For example, the controller 320 checks whether at least one factor cell included in the factor set is included in the screen of the Excel program 200 currently being displayed, and if it is not included, the controller 320 currently includes the at least one factor cell. The Excel program 200 may be requested to reduce the screen of the Excel program being displayed.

In one embodiment, the control unit 320 may extract the title information for the print cell. For example, when it is confirmed that a factor cell exists for a specific cell, a value corresponding to an item (title) among a plurality of cells included in the same row or column as the corresponding factor cell (for example, only a character is stored) Character), and the value stored in the cell can be identified as the title (item) of the factor cell.

In an embodiment of the present disclosure, the controller 320 may display the graphic interface generated by the graphic interface 330 overlapping at least a part of an area of the Excel screen currently being displayed. For example, the controller 320 may superimpose and display a table showing information on a factor of the specific cell on the top of the specific cell. This example will be described later in more detail with reference to FIGS. 5 to 10.

The graphic interface unit 330 may generate a graphic interface for visually providing a function or a set of arguments provided from the control unit 320.

The graphic interface unit 330 may provide the generated graphic interface to the controller 320.

In an embodiment, the graphic interface unit 330 may generate a graphic interface including a table or an arrow, and for this purpose, the graphic interface unit 330 may include a table generator 331 or an arrow generator 332. can do.

In one embodiment, the table generator 331 may generate a table using the address of the cell corresponding to the first and last cells or values stored therein for the plurality of successive factor cells provided from the controller 320. The graphic interface unit 330 may generate a visual interface using the generated table, and generate a graphic interface including the visual table.

In an embodiment, the arrow generator 332 may visually generate at least one arrow from a specific cell (start point) to at least one factor cell (end point) included in the factor set. The graphic interface unit 330 may generate a graphic interface including a visually generated arrow.

4 is a flowchart illustrating an embodiment of a method for providing an Excel function guide according to the present invention.

Referring to FIG. 4, the Excel function guide providing method will be described in more detail. The Excel function guide providing system 300 may include a function supported by the Excel program 200 or a set of arguments for the corresponding function from data stored in a specific cell. Can be extracted (step S410).

If at least one argument cell is included in the argument set (step S420, YES), the Excel function guide providing system 300 may extract an address of at least one argument cell or a value stored in the corresponding argument cell (step S420). S430).

The Excel function guide providing system 300 generates a graphic interface capable of visually providing a function or the set of arguments (step S440), and displays the generated graphic interface by superimposing the generated graphic interface on at least a part of the currently displayed Excel screen. Can be done (step S440).

In one embodiment for step S410, the Excel function guide providing system 300 checks whether the value corresponding to the first character of the data stored in the particular cell corresponds to the operator '=', Data can be extracted as numbers. If '=', the Excel function guide providing system 300 may parse the data after the first character of the data to extract a function or an argument for the function.

In one embodiment of steps S420 to S430, the Excel function guide providing system 300 checks whether a factor cell corresponding to the cell address format exists in the factor set, and if present, performs step S410 on the address of the factor cell. Can be done.

In an embodiment of steps S420 to S430, the Excel function guide providing system 300 may check whether a plurality of factor cells corresponding to a cell address format exist in the factor set. If there exists and the plurality of factor cells have mutually consecutive addresses, the Excel function guide providing system 300 may identify cells corresponding to the beginning and the end of the mutual consecutive addresses among the plurality of factor cells, respectively.

In one embodiment for steps S440 to S450, the Excel function guide providing system 300 generates, as a predetermined table, the addresses or stored values of cells corresponding to the first and last cells identified by the above-described embodiment, This can be illustrated visually to create a graphical interface.

In one embodiment for steps S440 to S450, the Excel function guide providing system 300 visually generates at least one arrow from a particular cell to at least one factor cell included in the factor set, and visually generated The graphical interface may be generated by including at least one arrow.

5 to 10 are reference diagrams illustrating an example of an Excel guide providing interface according to the present invention. Hereinafter, the graphic interface provided by the present invention will be described with reference to the examples illustrated in FIGS. 5 to 10.

5 illustrates an example of a value stored in a corresponding factor cell on a factor cell. That is, the cell where the cursor is located has the SUM function, and has B3, C6, B8, and B5 as argument cells for it. The Excel function guide providing system 300 may extract the values 6, 7, 14, and 16 stored in the factor cells B3, C6, B8, and B5, respectively, and display them on a screen as a separate display 510. .

6 is an example showing an arrow 610 from the selected cell to the printing cell. That is, the Excel function guide providing system 300 generates an arrow 610 from a specific cell to the argument cells B3, C6, B8, and B5 of the function SUM to generate a graphic interface, and displays the current Excel screen. Can be displayed by overlapping

FIG. 7 relates to an example of providing the address of the corresponding factor cell and the contents of the factor cell as a table 710 with respect to the example of FIG. 6. The first row of the table shows the address (B3, C6, B8, B5) of the argument cell, and the second row shows the values (7,8,98,0) stored in the corresponding argument cell.

8 shows an example of providing a function guide for two selected cells. In the example shown, it can be seen that the total 1 cell has A2 to C2 cells as factors, and the total 2 cells have A4 to A8 as factor cells. That is, as shown in the table 810, the information of the factor cells for the plurality of selected cells and values thereof may be generated and displayed as one table. Here, N is a symbol for omitting and indicating a value included in a predetermined number of factor cells. That is, a total of 1 cells have A2, B2, and C2 as factor cells, but when all of them are displayed, the displayed information increases. Therefore, the present invention denotes this as A2: C2. It can be displayed by indicating that a predetermined value is omitted as N in between.

FIG. 9 illustrates an example in which information about a function used is further described with respect to the example of FIG. 8. This is an example in which a function applied to a specific cell is provided in front of the second column of the table 910 representing the value of the argument cell.

FIG. 10 illustrates an example in which titles of corresponding factor cells are further indicated in the example of FIG. 8.

It will be apparent to those skilled in the art that various modifications and variations can be made in the present invention without departing from the spirit or scope of the present invention as defined by the following claims It can be understood that

100: the user terminal 100
110: input unit 120: memory unit
130: display unit 140: terminal control unit
200: Excel program
300: Excel function guide providing system
310: cell information extracting unit 320: control unit 320
330: graphical interface
331: table generation unit 332: arrow generation unit

Claims (11)

In the Excel function guide providing method based on the Excel program running in the user terminal,
(a) extracting a function supported by the Excel program or a parameter set for the function from data stored in a specific cell;
(b) extracting an address for the at least one factor cell or a value stored in the factor cell if the factor set includes at least one factor cell; And
(c) generating a graphic interface for visually providing the function or the set of arguments, and displaying the generated graphic interface by overlapping the generated graphic interface on at least a portion of an Excel screen currently being displayed;
Excel function guide providing method comprising a.
The method of claim 1, wherein step (a)
Checking whether a value corresponding to a first character of data stored in the specific cell corresponds to an operator '='; And
Extracting the stored data as a number if it is not '=';
Excel function guide providing method comprising a.
3. The method of claim 2, wherein step (a)
If the result is '=', parsing the data after the first character of the data to extract the function or an argument for the function;
Excel function guide providing method comprising a further.
2. The method of claim 1, wherein step (b)
Checking whether a factor cell corresponding to a cell address format exists in the factor set; And
If it exists, performing step (a) on the address of the corresponding factor cell;
Excel function guide providing method comprising a.
2. The method of claim 1, wherein step (b)
Checking whether a plurality of factor cells corresponding to a cell address format exist in the factor set; And
If the check result exists and the plurality of factor cells have mutually contiguous addresses, identifying cells corresponding to the beginning and the end of the mutual consecutive addresses among the plurality of factor cells, respectively;
Excel function guide providing method comprising a.
The method of claim 5, wherein step (c)
Generating an address of a cell corresponding to the first and last cell or a value stored therein as a predetermined table; And
Visually depicting the generated table to generate the graphical interface;
Excel function guide providing method comprising a.
2. The method of claim 1, wherein step (c)
Visually generating at least one arrow from the particular cell to at least one factor cell included in the factor set; And
Generating the graphical interface including the visually generated at least one arrow;
Excel function guide providing method comprising a.
In the Excel function guide providing apparatus based on an Excel program driven in a user terminal,
A cell information extracting unit for extracting a function supported by the Excel program or a parameter set for the function from data stored in a specific cell;
A graphic interface unit for generating a graphic interface capable of providing the function or argument set visually; And
Check whether a factor cell exists in the factor set extracted by the cell information extractor, and if present, control to extract a function or a factor set for the factor cell in the cell information extractor; A controller configured to provide a set of arguments to the graphic interface unit to display the generated graphic interface on at least a portion of an Excel screen currently being displayed;
Excel function guide providing device comprising a.
The method of claim 8, wherein the cell information extracting unit
Check whether the value corresponding to the first character of the data stored in the specific cell corresponds to the operator '=', and if '=', parse the data after the first character of the data to perform the function or the corresponding. Extracting arguments to functions, and extracting stored data as numbers if not '='
Excel function guide providing apparatus, characterized in that.
The method of claim 8, wherein the graphic interface unit
Visually generating at least one arrow from the particular cell to at least one factor cell included in the factor set and including the same to generate the graphical interface
Excel function guide providing apparatus, characterized in that.
In a computer-readable recording medium that records a program for executing an Excel function guide providing method,
The program is a program for providing an Excel function guide providing method based on an Excel program driven in a user terminal.
(a) extracting a function supported by the Excel program or a parameter set for the function from data stored in a specific cell;
(b) extracting an address for the at least one factor cell or a value stored in the factor cell if the factor set includes at least one factor cell; And
(c) generating a graphic interface capable of providing the function or the argument set visually, and displaying the generated graphic interface on at least a portion of an Excel screen currently being displayed;
And a computer-readable recording medium storing the program.

Images