KR101742099B1 - Method and apparatus for searching function inputted in spread sheet document - Google Patents

Method and apparatus for searching function inputted in spread sheet document Download PDF

Info

Publication number
KR101742099B1
KR101742099B1 KR1020150121683A KR20150121683A KR101742099B1 KR 101742099 B1 KR101742099 B1 KR 101742099B1 KR 1020150121683 A KR1020150121683 A KR 1020150121683A KR 20150121683 A KR20150121683 A KR 20150121683A KR 101742099 B1 KR101742099 B1 KR 101742099B1
Authority
KR
South Korea
Prior art keywords
function
spreadsheet document
data
function data
search
Prior art date
Application number
KR1020150121683A
Other languages
Korean (ko)
Other versions
KR20170025344A (en
Inventor
손승우
Original Assignee
주식회사 인프라웨어
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 주식회사 인프라웨어 filed Critical 주식회사 인프라웨어
Priority to KR1020150121683A priority Critical patent/KR101742099B1/en
Publication of KR20170025344A publication Critical patent/KR20170025344A/en
Application granted granted Critical
Publication of KR101742099B1 publication Critical patent/KR101742099B1/en

Links

Images

Classifications

    • G06F17/30011—
    • G06F17/21—
    • G06F17/246—

Landscapes

  • Document Processing Apparatus (AREA)

Abstract

The present invention relates to a function search method and apparatus input in a spreadsheet document, and a function search method input in a spreadsheet document according to an embodiment of the present invention includes: Extracting function data from the function data; generating a database storing function data according to a predetermined rule; receiving a search word for retrieving function data; sequentially comparing characters constituting the search word and the characters constituting the function data; And generating a function output list including function data whose similarity between the search term and the function data is equal to or greater than a predetermined level, wherein the function output list includes a spread sheet file including a function input to the spreadsheet document stored in the storage medium, Run the document and find the function without looking at the spreadsheet There is an effect that it is possible to provide a function search method and apparatus input in a spreadsheet document that can be directly searched in a document application and a spreadsheet document file browser.

Description

METHOD AND APPARATUS FOR SEARCHING FUNCTION INPUTTED IN SPREAD SHEET DOCUMENT

The present invention relates to a function search method and apparatus input to a spreadsheet document, and more particularly, to a spreadsheet document application and a spreadsheet document file browser. And an input function search method and apparatus.

Recently, as the use of computers becomes more and more common, various document works are mainly carried out using computers. For example, a document creation application such as Microsoft's Word for creating documents or Polaris® Word for infraware®, Microsoft's PowerPoint A slide document creation application such as Infraware ® 'Polaris ® Slide', Microsoft 'Excel' or Infraware ® 'Polaris ® Sheet' Using the same spreadsheet document creation application, not only the completeness of the document work but also the work efficiency is improved.

In particular, spreadsheet document creation applications such as Microsoft's Excel or Polaris® Sheet from Infraware® offer a number of features that make it easy to organize and easily calculate large amounts of numeric data. It is used in accounting, statistics, and trade fields.

In the spreadsheet document creation application, various functions are used to calculate a large number of numerical data and quickly process various logical operations. You can use the functions provided by the spreadsheet document creation application basically, or you can create a custom function to match the expression you need and get the result.

However, in the conventional case, in order to reuse a function that a user used in another spreadsheet document in a new spreadsheet document, there is a cumbersome process of executing a spreadsheet document using the function and finding a cell in which the function is inputted. In addition, it sometimes happens that it is difficult for the user to know which spreadsheet document the function is used for.

In addition, as the internet environment is improved and mobile devices are developed, the number of cases of document work on the move increases, and the number of cases of document work using a smart phone is also increasing. However, if the user does not save the spreadsheet document using the function to the smartphone due to the limitation of the smartphone capacity, the user can hardly reuse the function in the spreadsheet document, and each cell of the spreadsheet document It may be inconvenient to check.

Therefore, in order to utilize a large number of numerical data calculation functions through a function in a spreadsheet document creation application, a function that is inputted in a spreadsheet document which automatically informs a user about a function used in a spreadsheet document The need to provide methods has increased.

[Related Technical Literature]

A method and system for supporting a custom spreadsheet function (Korean Patent Laid-Open No. 10-2006-0046217)

It is an object of the present invention to allow a user to search a spreadsheet document application and a spreadsheet document file browser for functions entered in a spreadsheet document so that a user can quickly find a function entered in the spreadsheet document And to provide a function search method and apparatus input in a spreadsheet document.

Another problem to be solved by the present invention is to provide functions and functions related to a function inputted in a spreadsheet document as search results, thereby enabling a user to quickly and accurately recognize information related to a function, And to provide a search method and apparatus.

The problems of the present invention are not limited to the above-mentioned problems, and other problems not mentioned can be clearly understood by those skilled in the art from the following description.

According to an aspect of the present invention, there is provided a method for searching a function input into a spreadsheet document, the method comprising: extracting function data input to a spreadsheet stored in a storage medium; A step of receiving a search word for retrieving function data, a step of sequentially comparing the characters constituting the search word and the characters constituting the function data to judge the degree of similarity, And generating a function output list including function data whose similarity is equal to or higher than a predetermined level.

According to another aspect of the present invention, the function data extracted from the spreadsheet includes function configuration information, and the function configuration information includes a function, a result value calculated from a function, a file name of a spreadsheet, a storage path, And contents.

According to another aspect of the present invention, a storage medium includes a personal terminal and a cloud server.

According to another aspect of the present invention, the step of receiving a search term for retrieving function data is a step of receiving a search term through at least one of a spreadsheet file browser search window and a newly executed spreadsheet document application .

According to another aspect of the present invention, the step of determining the degree of similarity includes the step of extracting from the database function data having a degree of similarity between the search term and the function data equal to or higher than a predetermined level.

According to another aspect of the present invention, the step of generating a function output list is a step of outputting the generated function output list at least one of a file browser and a spreadsheet document application.

According to another aspect of the present invention, the step of outputting the function output list includes the steps of outputting the selected function to at least one of the spreadsheet file browser and the spreadsheet application when the function output to the function output list is selected, And automatically displaying the cursor in the data range of the function specified by the user in the spreadsheet document.

According to an aspect of the present invention, there is provided a function retrieval apparatus for retrieving function data input to a spreadsheet document stored in a storage medium, A function of determining a degree of similarity by sequentially comparing characters constituting a character string and function data of a query word; A similarity determination module, and a function output list generation module for generating a function output list including function data whose similarity between the search word and the function data is equal to or higher than a predetermined level.

According to another aspect of the present invention, in the function data extraction module, the function data extracted from the spreadsheet document includes function configuration information, the function configuration information includes a result value calculated from a function, a file name of a spreadsheet document, An update date, and a use purpose memo content.

According to still another aspect of the present invention, the function similarity determination module includes a database function data extraction module that extracts function data having a similarity degree between a search word and function data that is equal to or higher than a predetermined level from a database.

According to another aspect of the present invention, the function output list generation module includes a function output list output module that outputs the generated function output list in at least one of a file browser and a spreadsheet document application.

According to another aspect of the present invention, a function output list output module outputs a selected function to at least one of a file browser search window and a spreadsheet document application search window when a function output to the function output list is selected, And automatically displays the cursor in the data range of the function specified by the user in the spreadsheet document.

According to an aspect of the present invention, there is provided a computer readable recording medium storing instructions for providing a function search method input into a spreadsheet document, Extracts data, creates a database storing function data according to a predetermined rule, receives a search word for searching for function data, sequentially compares the characters constituting the search word with the characters constituting the function data, and judges the similarity And generating a function output list including function data whose similarity between the search word and the function data is equal to or higher than a predetermined level.

The details of other embodiments are included in the detailed description and drawings.

The present invention allows a user to search a spreadsheet document application and a spreadsheet document file browser for functions entered in a spreadsheet document so that the user can enter a spreadsheet document in which the user can quickly find a function entered in the spreadsheet document There is an effect that a function search method and apparatus can be provided.

The present invention provides a function search method and apparatus input in a spreadsheet document that enables a user to quickly and accurately recognize information related to a function by providing various information related to functions and functions input in a spreadsheet document as search results There is an effect that can be done.

The effects according to the present invention are not limited by the contents exemplified above, and more various effects are included in the specification.

1 illustrates a schematic configuration of a function retrieval module input in a spreadsheet document according to an embodiment of the present invention.
FIG. 2 illustrates a procedure of a function search method according to a function search method input in a spreadsheet document according to an embodiment of the present invention.
FIGS. 3A through 3C illustrate exemplary function retrieval methods entered into a spreadsheet document in a spreadsheet document application in accordance with an embodiment of the present invention.
4A and 4B illustrate a function retrieval method input in a spreadsheet document in a spreadsheet document file browser according to another embodiment of the present invention.

BRIEF DESCRIPTION OF THE DRAWINGS The advantages and features of the present invention and the manner of achieving them will become apparent with reference to the embodiments described in detail below with reference to the accompanying drawings. The present invention may, however, be embodied in many different forms and should not be construed as being limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art. Is provided to fully convey the scope of the invention to those skilled in the art, and the invention is only defined by the scope of the claims.

The shapes, sizes, ratios, angles, numbers, and the like disclosed in the drawings for describing the embodiments of the present invention are illustrative, and thus the present invention is not limited thereto. In the following description, well-known functions or constructions are not described in detail since they would obscure the invention in unnecessary detail. Where the terms 'comprises', 'having', 'done', and the like are used herein, other parts may be added as long as '~ only' is not used. Unless the context clearly dictates otherwise, including the plural unless the context clearly dictates otherwise.

In interpreting the constituent elements, it is construed to include the error range even if there is no separate description.

Like reference numerals refer to like elements throughout the specification unless otherwise specified.

It is to be understood that each of the features of the various embodiments of the present invention may be combined or combined with each other partially or entirely and technically various interlocking and driving is possible as will be appreciated by those skilled in the art, It may be possible to cooperate with each other in association.

Hereinafter, the terms used in this specification are defined.

As used herein, the term " function data " means information about a function and a spreadsheet document containing the function. For example, the function data includes the result of a function and a function, a file name of a spreadsheet document containing a function, a storage path, an update date, and a content of a usage note.

As used herein, the term " function output list " means a list including information on the result of a search by a user, and includes a function data corresponding to a search term. Function output lists can be output from the spreadsheet and spreadsheet document file browsers.

1 illustrates a schematic configuration of a function retrieval module input in a spreadsheet document according to an embodiment of the present invention.

Referring to FIG. 1, the functional data retrieval module 100 input in the spreadsheet document includes a functional data extraction module 110, a database generation module 120, a query retrieval module 130, a functional similarity determination module 140, And a function output list generation module 150.

The function data extraction module 110 extracts the function data input to the spreadsheet document stored in the storage medium. Here, the storage medium includes a cloud server capable of sharing spreadsheet documents with personal terminals such as a computer, a notebook, a smart phone, and a tablet PC. The function data extraction module 110 can extract the function data from the storage medium regardless of the type of the storage medium storing the function data.

In addition, the function data extraction module 110 may be present in the storage medium or may be connected to the storage medium without being present in the storage medium. When the function data extraction module 110 and the storage medium are connected to each other, the function data extraction module 110 can extract the function data from the storage medium through communication such as the Internet. Accordingly, the function data extraction module 110 transmits the extracted function data to the database generation module 120.

The database generation module 120 generates a database storing function data extracted from the function data extraction module 110. Specifically, the database generated by the database generation module 120 may include function data input to all the spreadsheet documents stored in the storage medium.

The search word receiving module 130 receives a search word for searching for a function data desired by the user. Specifically, the search word receiving module 130 receives a search word input through an input device such as a keyboard, a mouse, a pressure sensitive touch recognition display, and a capacitive touch recognition display. The search word receiving module 130 transmits the received search word to the function similarity determination module 140.

The function similarity determination module 140 determines the similarity between the query sent from the query receiving module 130 and the function data stored in the database. Specifically, the function similarity determination module 140 can sequentially determine the similarity by comparing the characters constituting the search word with the characters constituting the function data stored in the database.

The function similarity determination module 140 may further include a database function data extraction module that extracts function data having a degree of similarity with a search word from a database generated by the database generation module 120 to a predetermined level or higher. The database function data extraction module may transmit the function data extracted from the database generated by the database generation module 120 to the function output list generation module 150. Accordingly, the function output list generation module 150 generates a function output list including the function data transmitted from the database function data extraction module.

The function output list generation module 150 may further include a function output list output module for outputting the generated function output list. The function output list generation module 150 or the function output list output module may be connected to the output unit of the user terminal to show the generated function output list to the user. Accordingly, the function output list can be output through the output unit. Here, the output device includes a monitor of the user's computer and a display of the portable terminal.

Accordingly, the function data retrieval module 100 inputted in the spreadsheet document extracts the function data inputted to the spreadsheet document to generate a database, and after receiving the retrieval word for the function data from the user, Extracts functional data similar to those of the search word, and outputs it through a user terminal in a list format. Accordingly, the function data retrieval module 100 input in the spreadsheet document enables the user to quickly find a desired function among the functions input in the spreadsheet document.

Each component of the function data retrieval module 100 input to the spreadsheet document is shown as an individual component for convenience of description, and may be implemented in one module or separated into two or more components according to an implementation method .

FIG. 2 illustrates a procedure of a function search method according to a function search method input in a spreadsheet document according to an embodiment of the present invention. Will be described with reference to Fig. 1 for convenience of explanation.

The function search according to the present invention is started by extracting the function data input to the spreadsheet document stored in the storage medium by the function data extraction module 110 (S210).

The function data extraction module 110 extracts the function data input to the spreadsheet document. Here, the function data extracted by the function data extraction module 110 includes function configuration information, and the function configuration information includes a function, a result value calculated from the function, a file name of the spreadsheet document, a storage path, And a target memo content. That is, the function data extraction module 110 extracts function data including at least one of a function, a result value calculated from a function, a file name of a spreadsheet document to which the function is input, a storage path, an update date, .

The function data extraction module 110 can extract function data from a spreadsheet document including function data among spreadsheet documents stored in a storage medium regardless of a search word input by a user. Further, when a new spreadsheet document is stored in the storage medium, the function data extraction module 110 determines whether or not the function data exists in the new spreadsheet document. If the function data exists in the new spreadsheet document It is also possible to extract function data.

The function data extraction module 110 may extract the function data at the time when the spreadsheet document is stored in the storage medium. The term " storage " includes a case where the data is stored by the user's intention and a case where the data is stored at predetermined intervals according to the automatic storage setting. In addition, the function data extraction module 110 may extract the function data at a time when the user continuously stores a modified version of the spreadsheet document.

In addition, the function data extraction module 110 can extract the functions in the order in which the functions are entered in the spreadsheet document, and can finally extract the file name, storage path, update date, have.

 Then, the database generation module 120 generates a database storing function data according to a predetermined rule (S220).

The database generation module 120 collects the function data received from the function data extraction module 110 and generates a database according to a predetermined rule. From the time when the spreadsheet is stored in the storage medium and the function data extraction module 110 completes the extraction of the function data, the database generation module 120 collects the function data and creates the database. Then, the collected function data can be grouped by spreadsheet and function data types and stored. That is, the database generation module 120 determines whether or not the function similarity determination module 140 and the function output list generation module 150 determine the function data corresponding to the user's query more quickly, Create the database that stores the data.

Then, the search word receiving module 130 receives a search word for searching for function data (S230).

The search query receiving module 130 is input to a spreadsheet document application or a spreadsheet document file browser, and receives a search word for searching function data. Specifically, when a user inputs a search word for function data entered in a spreadsheet document into a search window of a spreadsheet document application or a spreadsheet document file browser, the search word receiving module 130 receives the search word input by the user do.

Here, the search term is composed of one or more characters. For example, if the search term is a function, the function name is '= function name', if the file name is 'filename.xlsx', if it is a storage path, '\ folder name' In the form of at least one character. If the search word receiving module 130 includes a '=' in the search word, the function includes a file name including '.xlsx', a storage path including a '\' It can be determined that the date is a storage date. If the search word includes characters such as '=' and '\' and is input to determine the type of a search word such as a function, a file name, a storage path, and a save date, the search word receiving module 130 determines And transmits the type of the determined search word to the function similarity determination module 140 together with the search term. An exemplary screen of a search window for receiving a search word will be described later with reference to FIGS. 3A and 4A.

Then, the function similarity determination module 140 sequentially compares the characters constituting the search term with the characters constituting the function data to determine similarity (S240).

Specifically, the function similarity determination module 140 determines whether or not at least the first character out of the characters constituting the search word and the data constituting the function data coincide with each other, and at least two or more of the consecutive characters are sequentially matched And determines the degree of similarity.

When the user inputs a search term so that the user can determine the type of the search term in the search word receiving module 130, the function similarity determination module 140 can receive the search term and the type of the search term from the search word receiving module 130. Then, the function similarity determination module 140 determines the similarity between the search word and the function data included in the database, after receiving the search word received by the search word receiving module 130. Since the function similarity determination module 140 receives the type of the search word together with the search word from the search word receiving module 130, the function similarity determination module 140 determines that the function similarity determination module 140 has received the type of the search word, Can more quickly determine the similarity between the search word and the function data stored in the database.

The function similarity determination module 140 may further include a database function data extraction module. The database function data extraction module may extract function data having a similarity level higher than or equal to a predetermined level from the database and transmit the extracted function data to the function output list generation module 150.

Then, the function output list generation module 150 generates the function output list including the function data whose similarity degree between the search term and the function data is equal to or higher than a predetermined level (S250).

When a search word is received from the spreadsheet document file browser search window, the function output list generation module 150 generates a function output list including the function data retrieved by the user and other function data related to the spreadsheet. For example, when the function output list generation module 150 receives a search word for a function input in a spreadsheet, the function output list generation module 150 may include at least one of a file name, a storage path, an update date, Create function output list. An exemplary screen of a function output list including function data retrieved by the user and other function data associated with the spreadsheet is described below with reference to FIG. 3D.

The function output list generation module 150 may include a function output list output module. The function output list output module may output the function output list generated from the function output list generating module 150 to at least one of a spreadsheet document file browser search window and a spreadsheet document application search window. Specifically, the function output list output module outputs a function output list at the bottom of the spreadsheet document application search window and the spreadsheet document file browser search window in which the search word is received. An exemplary screen in which the function output list is output will be described later with reference to Figs. 3B, 3D, and 4B.

Here, the function output list output module automatically displays a cursor in the data range of the corresponding function in the spreadsheet document application search window when the user selects a function among the function data outputted to the function output list and inputs the function into a new spreadsheet document do. Let the function output list output module perform the action of the user to display the block in the data range to readjust the data range. An exemplary screen operative to automatically assign a cursor and block to the data range of the function will be described below with reference to FIG. 3D.

Accordingly, when the user searches for a function input in the spreadsheet document stored in the storage medium, the function data retrieval module 100 inputted into the spreadsheet document does not need to execute the corresponding spreadsheet document, Allows you to search in the sheet document file browser.

FIGS. 3A through 3C illustrate exemplary function retrieval methods entered into a spreadsheet document in a spreadsheet document application in accordance with an embodiment of the present invention.

Referring to FIGS. 3A to 3C, the functional data retrieval module input in the spreadsheet document according to an embodiment of the present invention receives the retrieval word through the spreadsheet document application 300. The spreadsheet document application 300 includes a spreadsheet document application search window 310 and a spreadsheet document application function output list 320 displayed at the bottom of the spreadsheet document application search window 310. [

Referring to FIG. 3A, a spreadsheet document application 300 receives a search word through a spreadsheet document application search window 310. FIG. For example, the function data search module input in the spreadsheet document can receive a search word for searching a function including the character 'su' in the spreadsheet document application search window 310, Su " through < / RTI >

Referring to FIG. 3B, when the spreadsheet document application search window 310 receives characters of a search word for searching a function among function data, the function data search module input in the spreadsheet document searches the similarity between the search word and the function data To the spreadsheet document application function output list 320, the function data having a predetermined level or higher.

Referring to FIG. 3B, the spreadsheet document application search window 310 may receive a search word for searching function data composed of a character 'su'. The spreadsheet document application function output list 320 may output the function 'SUMPRODUCT' including the character 'su'. Here, the 'SUMPRODUCT' function is one of the functions input to the spreadsheet document stored in the storage medium, and 'A1: A8' outputted to the spreadsheet document application function output list 320 indicates that the user has designated The range of the function data.

3C, when the user selects one of the functions output to the spreadsheet document application function output list 320, the function is input to the spreadsheet document application search window 310, 330 are displayed. The function data range block 330 is shaded to the first character 'A' and the last character '2' of the range in which the function performed the operation.

Since the function data range block 330 is displayed in the function data range, the user does not need an operation for modifying the function data range. When a function is searched and used, frequently the function data range is changed. When the user copies the function and pastes the function into the cell of the spreadsheet document, the cursor and the block specifying operation for changing the data range must be performed There is an inconvenience. The function data range block 330, which is automatically displayed in the spreadsheet document application search window 310 in FIG. 3C, can reduce the inconvenience.

Accordingly, the user can more quickly retrieve the function data entered into the spreadsheet document in the spreadsheet document file browser 400, and can also retrieve the file name 431 of the spreadsheet document, the update date 432, The file storage path 433, and the usage note contents 434 at a time.

4A and 4B illustrate a function retrieval method input in a spreadsheet document in a spreadsheet document file browser according to another embodiment of the present invention. Only the configurations of the spreadsheet document file browser 400, the spreadsheet document file browser search window 410 and the spreadsheet document file browser function output list 420 of FIGS. 3A to 3C are different, Therefore, redundant description of the components described with reference to FIGS. 3A to 3C will be omitted.

4A and 4B, the spreadsheet document file browser 400 includes a spreadsheet document file browser search window 410 and a spreadsheet document file browser function output list 420 located at the lower end thereof.

The function search module entered into the spreadsheet document receives the search query in the spreadsheet document file browser 400.

Referring to FIG. 4A, the spreadsheet document file browser 400 can receive a user's search word through a spreadsheet document file browser search window 410. For example, the spreadsheet document file browser search window 410 may receive a search term for searching for a function including the character 'sumproduct'. The spreadsheet document file browser search window 410 corresponds to a function of receiving a search word of the spreadsheet document application search window 310 in the spreadsheet document application 300.

Referring to FIG. 4B, when a search word is input from a user in the spreadsheet document file browser search window 410, the function data search module input in the spreadsheet document searches the function data in which the similarity between the search word and the function data is greater than or equal to a predetermined level And additional function data related to the spreadsheet in the spreadsheet document file browser function output list 420. [ For example, the function data search module input in the spreadsheet document receives a search word 'my house.xlsx' in the spreadsheet document file browser search window 410. The function data retrieval module input in the spreadsheet document displays the file name 431 of the spreadsheet document including the character " My House " and the additional function data related to the spreadsheet document in the spreadsheet document file browser function output list 420, . The additional function data includes a spreadsheet document file update date 432, a file storage path 433, a usage note 434, and a function 435. When the function copy icon 440 is input, the function data retrieval module input in the spreadsheet document automatically copies the function 435, allowing the user to paste in a new spreadsheet document. The function copy icon 440 reduces the inconvenience of the user copying the function 435 and copying it.

Accordingly, the user can more quickly retrieve the function data entered into the spreadsheet document in the spreadsheet document file browser 400, and can also retrieve the file name 431 of the spreadsheet document, the update date 432, The file storage path 433, and the usage note contents 434 at a time.

Accordingly, the function search module input in the spreadsheet document allows the user to more easily search the function entered in the spreadsheet document stored in the storage medium in the spreadsheet document file browser 400. [

The function search module input in the spreadsheet document is a function that allows the user to directly search the spreadsheet document containing the function data if the user intends to use the function data entered in the spreadsheet document stored in the storage medium in the new spreadsheet document Provides a list of function outputs to allow. Accordingly, even if the user does not execute the spreadsheet document individually, the user can access the spreadsheet document application or the spreadsheet document file browser through the function search module input in the spreadsheet document, It is possible to easily search through.

In this specification, each block or each step may represent a part of a module, segment or code that includes one or more executable instructions for executing the specified logical function (s). It should also be noted that in some alternative embodiments, the functions mentioned in the blocks or steps may occur out of order. For example, two blocks or steps shown in succession may in fact be performed substantially concurrently, or the blocks or steps may sometimes be performed in reverse order according to the corresponding function.

The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. The software module may reside in a RAM memory, a flash memory, a ROM memory, an EPROM memory, an EEPROM memory, a register, a hard disk, a removable disk, a CD-ROM or any other form of storage medium known in the art. An exemplary storage medium is coupled to the processor, which is capable of reading information from, and writing information to, the storage medium. Alternatively, the storage medium may be integral with the processor.

 The processor and the storage medium may reside within an application specific integrated circuit (ASIC). The ASIC may reside within the user terminal. Alternatively, the processor and the storage medium may reside as discrete components in a user terminal.

Although the embodiments of the present invention have been described in detail with reference to the accompanying drawings, it is to be understood that the present invention is not limited to those embodiments and various changes and modifications may be made without departing from the scope of the present invention. . Therefore, the embodiments disclosed in the present invention are intended to illustrate rather than limit the scope of the present invention, and the scope of the technical idea of the present invention is not limited by these embodiments. Therefore, it should be understood that the above-described embodiments are illustrative in all aspects and not restrictive. The scope of protection of the present invention should be construed according to the following claims, and all technical ideas within the scope of equivalents should be construed as falling within the scope of the present invention.

100 Functions entered in the spreadsheet document Data retrieval module
110 Function Data Extraction Module
120 Database Creation Module
130 query receiving module
140 Function similarity determination module
150 Function Output List Generation Module
300 spreadsheet document application
310 Spreadsheet Documents Application Search Window
320 Spreadsheet Documents Application Function Output List
330 function data range block
400 Spreadsheet Document File Browser
410 Spreadsheet Document File Browser Search Box
420 Spreadsheet Document File Browser Function Output List
431 File name
432 File update date
433 File storage path
434 Usage notes
435 Functions
440 Function Copy Icon

Claims (13)

Extracting function data input to a spreadsheet document stored in a storage medium;
Generating a database storing the function data according to a predetermined rule;
Receiving a search word for searching the function data;
Recognizing a format of the search word;
Determining a type of the search term based on a format of the search term;
Sequentially comparing characters constituting the search word with characters constituting the function data to determine similarity; And
And generating a function output list including function data in which the degree of similarity between the search term and the function data is a predetermined level or higher. The method according to claim 1,
Wherein the function data extracted from the spreadsheet document includes function configuration information,
Wherein the function configuration information includes at least one of a function, a result value calculated from a function, a file name of the spreadsheet document, a storage path, an update date, and a content of a usage purpose memo. Way. The method according to claim 1,
Wherein the storage medium comprises a personal terminal and a cloud server. The method according to claim 1,
Wherein the step of receiving a search term for retrieving the function data comprises:
A spreadsheet file browser search window, and a spreadsheet document application search window newly executed by the user. The method according to claim 1,
Wherein the step of determining the degree of similarity comprises extracting from the database the function data whose degree of similarity between the search term and the function data is equal to or greater than a predetermined level, . The method according to claim 1,
The step of generating the function output list includes:
And outputting the generated function output list to at least one of a spreadsheet file browser and a spreadsheet document application. The method according to claim 6,
The step of outputting the function output list includes:
Outputting the selected function in at least one of the spreadsheet document file browser and the spreadsheet document application when the function output in the function output list is selected; And
And automatically displaying a cursor in a data range of the function specified by the user in the spreadsheet document. A function data extraction module for extracting function data input to a spreadsheet document stored in a storage medium;
A database generation module for generating a database storing the function data according to a predetermined rule;
A search word receiving module for receiving a search word for searching for the function data;
A function similarity determination module that sequentially compares characters constituting the search word with characters constituting the function data to determine similarity; And
And a function output list generation module for generating a function output list including function data in which the degree of similarity between the search word and the function data is equal to or higher than a predetermined level,
The search word receiving module includes:
Recognizing a format of the search word and determining a type of the search word based on a format of the search word. 9. The method of claim 8,
Wherein the function data extraction module comprises:
Wherein the function data extracted from the spreadsheet document includes function configuration information, the function configuration information includes a function, a result value calculated from the function, a file name of the spreadsheet document, a storage path, an update date, Wherein the function extracting unit extracts at least one of the input data and the output data from the input unit. 9. The method of claim 8,
Wherein the function similarity determination module comprises:
And a database function data extraction module for extracting the function data having the similarity degree between the search word and the function data at a predetermined level or more from the database. 9. The method of claim 8,
The function output list generation module includes:
And a function output list output module for outputting the generated function output list from at least one of the spreadsheet document file browser and the spreadsheet document application. 12. The method of claim 11,
The function output list output module, which outputs the function output list,
And outputting the selected function to at least one of a spreadsheet document file browser search window and a spreadsheet document application search window when the function output from the function output list is selected,
And the cursor is automatically displayed in the data range of the function designated by the user in the spreadsheet document. Extracts function data input to a spreadsheet document stored in a storage medium,
Generating a database storing the function data according to a predetermined rule,
Receiving a search word for retrieving the function data,
Recognizing a format of the search word,
Determining a type of the search term based on a format of the search term,
Sequentially comparing the characters constituting the search word with the characters constituting the function data to judge the degree of similarity,
And a function output list is generated by including function data whose degree of similarity between the search term and the function data is equal to or greater than a predetermined level, characterized in that the function output list is generated by a computer readable medium storing instructions for providing a function search method input into a spreadsheet document Possible recording medium.
KR1020150121683A 2015-08-28 2015-08-28 Method and apparatus for searching function inputted in spread sheet document KR101742099B1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
KR1020150121683A KR101742099B1 (en) 2015-08-28 2015-08-28 Method and apparatus for searching function inputted in spread sheet document

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
KR1020150121683A KR101742099B1 (en) 2015-08-28 2015-08-28 Method and apparatus for searching function inputted in spread sheet document

Publications (2)

Publication Number Publication Date
KR20170025344A KR20170025344A (en) 2017-03-08
KR101742099B1 true KR101742099B1 (en) 2017-05-31

Family

ID=58404295

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020150121683A KR101742099B1 (en) 2015-08-28 2015-08-28 Method and apparatus for searching function inputted in spread sheet document

Country Status (1)

Country Link
KR (1) KR101742099B1 (en)

Also Published As

Publication number Publication date
KR20170025344A (en) 2017-03-08

Similar Documents

Publication Publication Date Title
US9256653B2 (en) Faceted search results
KR101955732B1 (en) Associating captured image data with a spreadsheet
US9342233B1 (en) Dynamic dictionary based on context
US20240143904A1 (en) Human-Computer Interaction Method And Apparatus Thereof
WO2016095689A1 (en) Recognition and searching method and system based on repeated touch-control operations on terminal interface
US9965495B2 (en) Method and apparatus for saving search query as metadata with an image
JP2008257444A (en) Similar file management device, method therefor and program therefor
WO2010008488A1 (en) Method and system for dynamically generating a search result
US20170123606A1 (en) Electronic device and method for searching data
JP2014130547A (en) File management program, file management device and file management method
JP2005107597A (en) Device and method for searching for similar sentence and program
JP2015076064A (en) Information processing device, information processing method, program, and storage medium
US20150178289A1 (en) Identifying Semantically-Meaningful Text Selections
CN114297143A (en) File searching method, file displaying device and mobile terminal
CN105069175A (en) Information retrieval method and server based on version control system
US20140280050A1 (en) Term searching based on context
JP2014130546A (en) File management program, file management device and file management method
KR101742099B1 (en) Method and apparatus for searching function inputted in spread sheet document
CN113672154B (en) Page interaction method, medium, device and computing equipment
CN104123378A (en) Information processing method and electronic device
US20120079404A1 (en) Method for creating and searching a folder in a computer system
CN113468110A (en) File management method and device, electronic equipment and storage medium
US10108468B2 (en) Information processing apparatus, non-transitory storage medium, and information processing method
JP6707410B2 (en) Document search device, document search method, and computer program
US9990420B2 (en) Method of searching and generating a relevant search string

Legal Events

Date Code Title Description
A201 Request for examination
E902 Notification of reason for refusal
E701 Decision to grant or registration of patent right
GRNT Written decision to grant