Electronic terminal apparatus that provides an improved interface to facilitate the creation of spreadsheet documents and the operating method thereof

Abstract

The electronic terminal device and the method of operation according to the present invention can improve user convenience in creating spreadsheet documents by proposing an interfacing technology that can automatically sort sheets constituting a spreadsheet document according to importance and display them on a list display area.

Description

Technology Field

[0001] The present invention relates to an electronic terminal device and a method of operation thereof that provides an improved interface for facilitating the creation of spreadsheet documents. Background Technology

[0002] Recently, with the widespread adoption of computers, smartphones, and tablet PCs, various types of electronic document editing programs are being released that enable users to view, create, and edit electronic documents using these electronic terminal devices.

[0003] These electronic document editing programs include word processors that support the creation and editing of basic documents, spreadsheet editing programs that assist with data input, arithmetic operations, and data management, and presentation editing programs that assist the presenter's presentation.

[0004] Typically, a spreadsheet document consists of sheets that can be viewed as a type of page. As a result, the user can create sheets in the spreadsheet document and then perform document creation by inserting data into cells for each sheet. In this regard, FIG. 2 is a diagram illustrating an example of a screen in which a spreadsheet document is opened in a spreadsheet editing program. As shown in FIG. 2, when a user opens a spreadsheet document file, a standard spreadsheet editing program creates an interface consisting of a body display area (211) and a list display area (212), then displays the body of a specific sheet in the body display area (211) of the interface, and displays the titles of the sheets constituting the spreadsheet document in an arranged manner in the list display area (212).

[0005] At this time, when the user selects a specific title among the titles of the sheets displayed in the list display area (212), the spreadsheet editing program displays the text corresponding to the sheet selected by the user on the text display area (211).

[0006] In existing spreadsheet programs, the titles of the sheets displayed on the list display area (212) were simply arranged and displayed according to the order of creation of each sheet or the order specified by the user.

[0007] In this regard, if a function is provided to automatically sort and display the titles of the sheets displayed on the list display area (212) according to the importance of each sheet, the user's convenience in using the spreadsheet may be further enhanced.

[0008] Therefore, research is needed on an interfacing technology that can automatically sort and display the titles of the sheets displayed on the list display area (212) according to the importance of each sheet. The problem to be solved

[0009] The electronic terminal device and the method of operation according to the present invention aim to improve user convenience in creating spreadsheet documents by proposing an interfacing technology that can automatically sort sheets constituting a spreadsheet document according to importance and display them on a list display area. means of solving the problem

[0010] An electronic terminal device according to an embodiment of the present invention, when an open command for a spreadsheet document file composed of a plurality of sheets into which data is inserted—each of which has a title for each sheet and a different sequence number for sorting pre-assigned to each of the plurality of sheets—is granted from a user, executes a spreadsheet editing program installed on the electronic terminal device to create an interface comprising a body display area for displaying the body area of ​​the document and a list display area for displaying a list of sheets at the bottom of the body display area, then loads the spreadsheet document file, and simultaneously displays the body of the sheet assigned the earliest sequence number among the plurality of sheets on the body display area of ​​the interface, and displays the titles of each of the plurality of sheets sorted in ascending order according to the sequence number assigned to each sheet on the list display area of ​​the interface, and a document display unit that, when a reordering command is granted from the user instructing to reorder and display the titles of each of the plurality of sheets displayed on the list display area according to importance, for each of the plurality of sheets, the number of cells in which data is inserted It includes an index calculation unit that, at the same time as confirming, checks which type of format among the pre-specified n types of formats (n is a natural number greater than or equal to 2) is used, and then calculates an importance index for each of the plurality of sheets based on the number of cells and the type of format confirmed for each of the plurality of sheets, and a reordering unit that, when the importance index for each of the plurality of sheets is calculated, rearranges and displays the titles of each of the plurality of sheets in descending order according to the importance index of each sheet on the list display area of ​​the interface.

[0011] In addition, a method of operation of an electronic terminal device according to an embodiment of the present invention comprises, when an open command for a spreadsheet document file composed of a plurality of sheets into which data is inserted—each of which has a title for each sheet and a different sequence number for sorting pre-assigned—is granted from a user, executing a spreadsheet editing program installed on the electronic terminal device to create an interface comprising a body display area for displaying the body area of ​​the document and a list display area for displaying a list of sheets at the bottom of the body display area, then loading the spreadsheet document file, and simultaneously displaying the body of the sheet assigned the earliest sequence number among the plurality of sheets on the body display area of ​​the interface, and simultaneously displaying the titles of each of the plurality of sheets sorted in ascending order according to the sequence number assigned to each sheet on the list display area of ​​the interface; and when a reordering command is granted from the user instructing to reorder and display the titles of each of the plurality of sheets displayed on the list display area according to importance, for each of the plurality of sheets, the number of cells in which data is inserted The method includes the steps of verifying, simultaneously verifying which type of format among the pre-specified n types of formats (n is a natural number greater than or equal to 2) has been used, and then calculating an importance index for each of the plurality of sheets based on the number of cells and the type of format verified for each of the plurality of sheets, and when the importance index for each of the plurality of sheets is calculated, rearranging and displaying the titles of each of the plurality of sheets in descending order according to the importance index of each sheet on the list display area of ​​the interface. Effects of the invention

[0012] The electronic terminal device and the method of operation according to the present invention can improve user convenience in creating spreadsheet documents by proposing an interfacing technology that can automatically sort sheets constituting a spreadsheet document according to importance and display them on a list display area. Brief explanation of the drawing

[0013] FIG. 1 is a drawing illustrating the structure of an electronic terminal device according to an embodiment of the present invention. FIGS. 2 to 5 are drawings for explaining an electronic terminal device according to an embodiment of the present invention. FIG. 6 is a flowchart illustrating a method of operation of an electronic terminal device according to an embodiment of the present invention. Specific details for implementing the invention

[0014] Embodiments according to the present invention will be described in detail below with reference to the accompanying drawings. This description is not intended to limit the present invention to specific embodiments and should be understood to include all modifications, equivalents, and substitutions that fall within the spirit and scope of the present invention. Similar reference numerals have been used for similar components in describing each drawing, and unless otherwise defined, all terms used in this specification, including technical or scientific terms, have the same meaning as generally understood by a person skilled in the art to which the present invention pertains.

[0015] In this document, when a part is described as "including" a component, it means that, unless specifically stated otherwise, it does not exclude other components but may include additional components. Furthermore, in various embodiments of the present invention, each component, functional block, or means may be composed of one or more sub-components, and the electrical, electronic, or mechanical functions performed by each component may be implemented by various known devices or mechanical elements, such as electronic circuits, integrated circuits, and ASICs (Application Specific Integrated Circuits), and may be implemented separately or two or more may be integrated into one.

[0016] Meanwhile, the blocks in the attached block diagram or the steps in the flowchart may be interpreted as computer program instructions that perform designated functions by being loaded into the processor or memory of data-processing equipment, such as general-purpose computers, specialized computers, portable notebook computers, and network computers. Since these computer program instructions may be stored in memory provided in a computer device or in memory readable by a computer, the functions described in the blocks in the block diagram or the steps in the flowchart may be produced as manufactured products containing means of instruction to perform them. Furthermore, each block or each step may represent a module, segment, or part of code containing one or more executable instructions for executing a specific logical function(s). Also, it should be noted that in some alternative embodiments, the functions mentioned in the blocks or steps may be executed in a different order than the prescribed order. For example, two blocks or steps shown in succession may be performed substantially simultaneously or in reverse order, and in some cases, some blocks or steps may be omitted.

[0017] FIG. 1 is a drawing illustrating the structure of an electronic terminal device according to an embodiment of the present invention.

[0018] Referring to FIG. 1, the electronic terminal device (110) according to the present invention includes a document display unit (111), an index calculation unit (112), and a reordering unit (113).

[0019] When a document display unit (111) receives an open command from a user for a spreadsheet document file consisting of multiple sheets (each of which has a title and a different sequence number for sorting) into which data is inserted, it executes a spreadsheet editing program installed on an electronic terminal device (110) to create an interface consisting of a body display area for displaying the body area of ​​the document and a list display area for displaying a list of sheets at the bottom of the body display area, and then loads the spreadsheet document file to display the body of the sheet with the earliest sequence number among the multiple sheets on the body display area of ​​the interface, and at the same time displays the titles of each of the multiple sheets on the list display area of ​​the interface, sorted in ascending order according to the sequence number assigned to each sheet.

[0020] In this regard, let us assume that the above spreadsheet document file is a file for a spreadsheet document consisting of 5 sheets. And let us assume that each of the 5 sheets is assigned a title such as 'Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5', and that the sequence numbers '1, 2, 3, 4, 5' are assigned in the order of 'Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5'.

[0021] At this time, when an open command for the spreadsheet document file is authorized from the user, the document display unit (111) executes the spreadsheet editing program to create an interface consisting of a body display area (211) for displaying the body area of ​​the document as shown in FIG. 2 and a list display area (212) for displaying a list of sheets at the bottom of the body display area (211), and then loads the spreadsheet document file to display the body of ‘Sheet 1’, which is assigned the earliest sequence number ‘1’ among the plurality of sheets, on the body display area (211) of the interface, and at the same time, on the list display area (212) of the interface, the titles of each of the plurality of sheets, ‘Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5’, can be displayed sorted in ascending order according to the sequence number assigned to each sheet.

[0022] When the index calculation unit (112) receives a reordering command from the user instructing to reorder and display the titles of each of the plurality of sheets displayed on the list display area (212) according to importance, it checks the number of cells in which data is inserted for each of the plurality of sheets, and at the same time checks which type of format among the pre-specified n types of formats (n is a natural number greater than or equal to 2) is used, and then calculates an importance index for each of the plurality of sheets based on the number of cells and the type of format confirmed for each of the plurality of sheets.

[0023] At this time, according to one embodiment of the present invention, when the number of cells and the type of format are confirmed for each of the plurality of sheets, the index calculation unit (112) calculates the sum score for each of the plurality of sheets by referring to a pre-specified score table (the score table is a table in which scores pre-specified as corresponding to each of the n types of formats are recorded) for each of the plurality of sheets and summing all the scores corresponding to the confirmed type of format for each sheet, and then calculates the importance index for each of the plurality of sheets by calculating the weighted average between the number of cells confirmed for each sheet and the sum score calculated for each sheet as the importance index for each sheet.

[0024] Here, the score table is a table in which a pre-specified score corresponding to each of the n types of formats is recorded, and when the n types of formats are 'bold text, apply color to the cell background, add an underline to text, etc.', the score table may be configured as shown in Table 1 below.

[0026] n types of formats Score Make the text bold 10 points Apply color to the cell background 20 points Add an underline to the text 15 points ... ...

[0028] In this regard, let us assume that a spreadsheet document consisting of five sheets, such as ‘Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5’, is open, as in the example of FIG. 2. At this time, when a reordering command is applied to the electronic terminal device (110) of the present invention from the user, instructing the titles of each of the five sheets displayed on the list display area (212) to be reordered and displayed according to importance, the index calculation unit (112) can check the number of cells in which data is inserted for each of the five sheets, and at the same time check which type of format among the pre-specified n types of formats is used.

[0029] In this regard, in the figure illustrated in FIG. 2, since data is inserted into '65' cells for 'Sheet 1', the index calculation unit (112) can confirm that the number of cells for 'Sheet 1' is '65'. Also, since the format 'bold text' and the format 'apply color to cell background' among the n types of formats are applied to 'Sheet 1', the index calculation unit (112) can confirm that the format 'bold text' and the format 'apply color to cell background' are used for 'Sheet 1'. In this way, the index calculation unit (112) can confirm the number of cells and the type of format for each of 'Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5'.

[0030] Then, the index calculation unit (112) can calculate the sum score for each sheet by referring to a score table such as Table 1 for each of the five sheets and summing up all the scores corresponding to the format types identified for each sheet. In this regard, for 'Sheet 1', since it is confirmed that the format 'bold text' and the format 'apply color to cell background' were used, the index calculation unit (112) can calculate the sum score for 'Sheet 1' as '30 points' by referring to a score table such as Table 1 and summing up the score '10 points' corresponding to the format 'bold text' and the score '20 points' corresponding to the format 'apply color to cell background'. In this way, the index calculation unit (112) can calculate the sum score for each of 'Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5'.

[0031] Thereafter, the index calculation unit (112) can calculate the importance index for each of the five sheets by calculating the weighted average between the number of cells confirmed for each sheet and the sum score calculated for each sheet for each of the five sheets as the importance index for each sheet. Here, the weighted average can be calculated according to the following mathematical formula 1.

[0033]

[0035] In the above mathematical formula 1, X represents the number of cells, Y represents the sum score, and α and β represent pre-specified weights for weighted average calculation, and the sum of α and β is 1.

[0036] In this regard, as in the example above, for ‘Sheet 1’, since the number of cells was confirmed to be ‘65’ and the sum score was calculated to be ‘30 points’, if we assume that α is ‘0.4’ and β is ‘0.6’, the index calculation unit (112) can calculate the importance index for ‘Sheet 1’ as ‘44’. In this way, the index calculation unit (112) can calculate the importance index for each of ‘Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5’.

[0037] When the importance index for each of the plurality of sheets is calculated, the reordering unit (113) displays the titles of each of the plurality of sheets on the list display area (212) of the interface, reordering them in descending order according to the importance index of each sheet.

[0038] In this regard, as in the example described above, if the plurality of sheets are referred to as 'Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5' and the importance index of 'Sheet 1' is calculated to be '44', the importance index of 'Sheet 2' is '22', the importance index of 'Sheet 3' is '30', the importance index of 'Sheet 4' is '38', and the importance index of 'Sheet 5' is '50', the reordering unit (113) can rearrange and display the titles of each of the five sheets in descending order with respect to the importance index of each sheet on the list display area (212) of the interface, as shown in the figure illustrated in FIG. 3. That is, the reordering unit (113) can rearrange and display them on the list display area (212) in the order of 'Sheet 5, Sheet 1, Sheet 4, Sheet 3, Sheet 2', as shown in the figure illustrated in FIG. 3.

[0039] At this time, according to one embodiment of the present invention, the electronic terminal device (110) may further include a switching display unit (114).

[0040] When the title of the first sheet, which is one of the titles of the plurality of sheets displayed on the list display area (212), is selected by the user, the switching display unit (114) switches the text of the sheet displayed on the text display area (211) to the text of the first sheet.

[0041] In this regard, as shown in the figure illustrated in FIG. 3, when the titles of five sheets are displayed on the list display area (212) and the text of 'Sheet 1' is displayed on the text display area (211), if 'Sheet 4' is selected by the user among the titles of the five sheets displayed on the list display area (212), the switching display unit (114) can switch the text of 'Sheet 1' displayed on the text display area (211) to the text of 'Sheet 4', as shown in the figure illustrated in FIG. 4.

[0042] At this time, according to one embodiment of the present invention, the electronic terminal device (110) may further include a character database (115), a frequency checking unit (116), a set generating unit (117), a selection unit (118), and an emphasis application unit (119).

[0043] The character database (115) stores multiple pre-specified characters.

[0044] Here, multiple characters refer to combined characters composed of initial consonant / vowel or initial consonant / vowel / final consonant in the case of Hangul, and Roman characters in the case of English. At this time, multiple characters may be stored in the character database (115) as shown in Table 2 below.

[0046] turn Multiple characters 1 go 2 me 3 all 4 a 5 b 6 c ... ...

[0048] The frequency checking unit (116) checks the frequency of occurrence of each of the plurality of characters in the text inserted on each sheet for each of the plurality of sheets when a command is issued from the user instructing to display similar sheet information similar to the first sheet among the plurality of sheets, as the title of the first sheet, which is one of the titles of the plurality of sheets displayed on the list display area (212), is selected by the user.

[0049] In this regard, as shown in the figure illustrated in FIG. 4, when the text of 'Sheet 4' is displayed on the text display area (211), and a command instructing the user to display similar sheet information similar to 'Sheet 4' is applied to the electronic terminal device (110) of the present invention, the frequency checking unit (116) can check the frequency of appearance of each of the multiple characters indicated in Table 2 in the text inserted on each sheet for each of 'Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5'.

[0050] For example, in ‘Sheet 4’, if the character ‘ga’ appears ‘14 times’, the character ‘na’ appears ‘5 times’, the character ‘da’ appears ‘7 times’, the character ‘a’ appears ‘2 times’, the character ‘b’ appears ‘0 times’, and the character ‘c’ appears ‘6 times’ in the text, the frequency check unit (116) can check the frequency of appearance of each character for ‘Sheet 4’ as shown in Table 3 below.

[0052] Multiple characters Frequency of appearance go 14th episode me 5th time all Episode 7 a 2nd time b 0 times c Episode 6 ... ...

[0054] In this way, the frequency check unit (116) can check the frequency of occurrence of each character for each of ‘sheet 1, sheet 2, sheet 3, sheet 4, sheet 5’.

[0055] The set generation unit (117) generates a set of selected characters corresponding to each of the plurality of sheets by arranging the frequency of occurrence of the plurality of characters in ascending order for each of the plurality of sheets to calculate the quartiles, and then selecting only the characters having a frequency of occurrence of the third quartile or higher to form a set.

[0056] Here, quartiles are data sorted in ascending order divided into four equal parts, where the first quartile is the variable value corresponding to the 1 / 4 place and the third quartile is the variable value corresponding to the 3 / 4 place.

[0057] In this regard, as in the example above, when the frequency of occurrence of the plurality of characters for each of the five sheets called ‘Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5’ is confirmed, the set generating unit (117) can generate a set of selected characters corresponding to each sheet by arranging the frequency of occurrence of the plurality of characters in ascending order for each of ‘Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5’ to calculate the quartiles, and then selecting only the characters that have a frequency of occurrence of the third quartile or higher to form a set. For example, if, for 'Sheet 1', the frequency of occurrence of multiple characters as shown in Table 3 is calculated and only a total of '30' characters have a frequency of occurrence of at least the third quartile, the set generating unit (117) can generate a set of selected characters consisting of '30' characters for 'Sheet 1' by selecting only '30' characters from the multiple characters as shown in Table 3 and forming them into a set. In this way, the set generating unit (117) can generate a set of selected characters for each of 'Sheet 1, Sheet 2, Sheet 3, Sheet 4, and Sheet 5'.

[0058] The selection unit (118) calculates a Jaccard index between a selection character set corresponding to the first sheet and a selection character set corresponding to each of the remaining sheets excluding the first sheet among the plurality of sheets, and then selects the sheet among the remaining sheets for which the Jaccard index with the first sheet is calculated to be the maximum as a similar sheet similar to the first sheet.

[0059] Here, the Jaccard index refers to the similarity between two sets when two sets exist, and can be calculated according to the following mathematical formula 2.

[0061]

[0063] In the above mathematical formula 2, JI is the Jaccard index, is the size of the intersection of two sets A and B, Jaccard represents the size of the union of two sets A and B. Generally, the smaller the Jaccard index between two sets, the more dissimilar the two sets are considered to be, and the larger the Jaccard index between two sets, the more similar the two sets are considered to be.

[0064] In this regard, as in the example of FIG. 4 described above, when the first sheet is referred to as 'Sheet 4', the selection unit (118) calculates the Jaccard index between the selection character set corresponding to 'Sheet 4' and the selection character set corresponding to each of the remaining 'Sheet 1, Sheet 2, Sheet 3, Sheet 5', and then selects the sheet among 'Sheet 1, Sheet 2, Sheet 3, Sheet 5' that has the maximum calculated Jaccard index with 'Sheet 4' as a similar sheet similar to 'Sheet 4'. In this regard, when the sheet among 'Sheet 1, Sheet 2, Sheet 3, Sheet 5' that has the maximum calculated Jaccard index with 'Sheet 4' is referred to as 'Sheet 2', the selection unit (118) can select 'Sheet 2' as a similar sheet to 'Sheet 4'.

[0065] When the selection of the similar sheets is completed, the emphasis application unit (119) applies a pre-specified emphasis format to the title of the first sheet and the title of the similar sheet among the titles of each of the plurality of sheets displayed on the list display area (212).

[0066] In this regard, as in the example of FIG. 4 described above, if the first sheet is called 'Sheet 4' and a similar sheet to 'Sheet 4' is selected as 'Sheet 2', the highlight application unit (119) can apply a pre-specified highlight format to the title of 'Sheet 4' and the title of 'Sheet 2' among the titles of each of the five sheets displayed on the list display area (212), as shown in FIG. 5. In this regard, in the embodiment of FIG. 4, an example is shown in which a yellow highlight format is applied to the title of each sheet as the highlight format.

[0067] Through this, the user can identify at a glance that the sheet similar to ‘Sheet 4’ displayed on the text display area (211) is ‘Sheet 2’.

[0068] FIG. 6 is a flowchart illustrating a method of operation of an electronic terminal device according to an embodiment of the present invention.

[0069] In step (S610), when a command to open a spreadsheet document file consisting of multiple sheets with data inserted (each of the multiple sheets has a title for each sheet and a different sequence number for sorting pre-assigned to it) is granted by a user, a spreadsheet editing program installed on the electronic terminal device is executed to create an interface consisting of a body display area for displaying the body area of ​​the document and a list display area for displaying a list of sheets at the bottom of the body display area, and then the spreadsheet document file is loaded to display the body of the sheet with the earliest sequence number assigned among the multiple sheets on the body display area of ​​the interface, and at the same time, on the list display area of ​​the interface, the titles of each of the multiple sheets are displayed sorted in ascending order according to the sequence number assigned to each sheet.

[0070] In step (S620), when a reordering command is issued from the user instructing to reorder and display the titles of each of the plurality of sheets displayed on the list display area according to importance, the number of cells in which data is inserted is checked for each of the plurality of sheets, and at the same time, the type of format among the pre-specified n types of formats (n is a natural number greater than or equal to 2) is checked, and then an importance index for each of the plurality of sheets is calculated based on the number of cells and the type of format checked for each of the plurality of sheets.

[0071] In step (S630), when an importance index for each of the plurality of sheets is calculated, the titles of each of the plurality of sheets are displayed on the list display area of ​​the interface, rearranged in descending order according to the importance index of each sheet.

[0072] At this time, according to one embodiment of the present invention, in step (S620), when the number of cells and the type of format are confirmed for each of the plurality of sheets, a sum score for each of the plurality of sheets is calculated by referring to a pre-specified score table (the score table is a table in which scores pre-specified as corresponding to each of the n types of formats are recorded) for each of the plurality of sheets and summing all the scores corresponding to the confirmed type of format for each sheet, and then calculating the weighted average between the number of cells confirmed for each sheet and the sum score calculated for each sheet as the importance index for each sheet for each of the plurality of sheets, thereby calculating the importance index for each of the plurality of sheets.

[0073] In addition, according to one embodiment of the present invention, the method of operation of the electronic terminal device may further include the step of switching and displaying the body of the sheet displayed on the body text display area to the body of the first sheet when the title of the first sheet, which is one of the titles of the plurality of sheets displayed on the list display area, is selected by the user.

[0074] At this time, according to one embodiment of the present invention, the method of operation of the electronic terminal device comprises: maintaining a character database in which a plurality of pre-specified characters are stored; when the title of the first sheet, which is one of the titles of the plurality of sheets displayed on the list display area, is selected by the user, and the body of the first sheet is displayed on the body display area, and when a command is applied from the user instructing to display similar sheet information similar to the first sheet among the plurality of sheets, the method comprises: checking the frequency of occurrence of each of the plurality of characters in the text inserted on each sheet for each of the plurality of sheets; generating a set of selected characters corresponding to each of the plurality of sheets by selecting only the characters having a frequency of occurrence of the third quartile or higher when the frequency of occurrence of the plurality of characters is sorted in ascending order and the quartiles are calculated for each of the plurality of sheets; and calculating a Jaccard index between the set of selected characters corresponding to the first sheet and the set of selected characters corresponding to each of the remaining sheets excluding the first sheet among the plurality of sheets, and then the remainder The method may further include the step of selecting a sheet among the sheets that has the maximum calculated Jaccard index with the first sheet as a similar sheet similar to the first sheet, and when the selection of the similar sheet is completed, applying a pre-specified highlight format to the title of the first sheet and the title of the similar sheet among the titles of each of the plurality of sheets displayed on the list display area.

[0075] Hereinafter, a method of operation of an electronic terminal device according to an embodiment of the present invention has been described with reference to FIG. 6. Here, since the method of operation of an electronic terminal device according to an embodiment of the present invention may correspond to the configuration of the operation of the electronic terminal device (110) described using FIG. 1 to 5, a more detailed description thereof will be omitted.

[0076] A method of operation of an electronic terminal device according to one embodiment of the present invention can be implemented as a computer program stored in a storage medium for execution through combination with a computer.

[0077] In addition, the method of operation of an electronic terminal device according to one embodiment of the present invention may be implemented in the form of computer program instructions for execution through combination with a computer and recorded on a computer-readable medium. The computer-readable medium may include program instructions, data files, data structures, etc., either individually or in combination. The program instructions recorded on the medium may be those specifically designed and configured for the present invention, or they may be those known and available to those skilled in the art of computer software. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tapes; optical recording media such as CD-ROMs and DVDs; magneto-optical media such as floptical disks; and hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, and flash memory. Examples of program instructions include machine code, such as that generated by a compiler, as well as high-level language code that can be executed by a computer using an interpreter, etc.

[0078] As described above, the present invention has been explained by specific details such as specific components, limited embodiments, and drawings; however, this is provided merely to aid in a more comprehensive understanding of the invention, and the invention is not limited to the above embodiments. A person skilled in the art can make various modifications and variations from this description.

[0079] Accordingly, the scope of the present invention is not limited to the described embodiments, and all things equivalent to or having equivalent variations to the claims set forth below, as well as the claims set forth below, shall be considered to fall within the scope of the concept of the present invention. Explanation of the symbols

[0080] 110: Electronic terminal device 111: Document display unit 112: Index calculation unit 113: Reordering section 114: Transition indicator section 115: Character database 116: Frequency check section 117: Set generation unit 118: Selection unit 119: Emphasis application section

Claims

Claim 1 In an electronic terminal device, a character database in which a plurality of pre-specified characters are stored; when an open command for a spreadsheet document file composed of a plurality of sheets into which data is inserted—each of which has a title and a different sequence number for sorting pre-assigned—is granted from a user, a spreadsheet editing program installed on the electronic terminal device is executed to create an interface consisting of a body display area for displaying the body area of ​​the document and a list display area for displaying a list of sheets at the bottom of the body display area, and then the spreadsheet document file is loaded to display the body of the sheet assigned the earliest sequence number among the plurality of sheets on the body display area of ​​the interface, and simultaneously display the titles of each of the plurality of sheets sorted in ascending order according to the sequence number assigned to each sheet on the list display area of ​​the interface; and when a reordering command is granted from the user instructing to reorder and display the titles of each of the plurality of sheets displayed on the list display area according to importance, for each of the plurality of sheets, data is inserted An index calculation unit that checks the number of existing cells and simultaneously checks which type of format among a pre-specified n (n is a natural number greater than or equal to 2) types of formats is used, and then calculates an importance index for each of the plurality of sheets based on the number of cells and the type of format checked for each of the plurality of sheets; and a reordering unit that, when the importance index for each of the plurality of sheets is calculated, rearranges and displays the titles of each of the plurality of sheets in descending order according to the importance index of each sheet on the list display area of ​​the interface.When the title of a first sheet, which is one of the titles of the plurality of sheets displayed on the list display area, is selected by the user, the switching display unit switches the body of the sheet displayed on the body display area to the body of the first sheet; when the body of the first sheet is displayed on the body display area as a result of the title of the first sheet, which is one of the titles of the plurality of sheets displayed on the list display area, and a command is issued from the user instructing to display similar sheet information similar to the first sheet among the plurality of sheets, for each of the plurality of sheets, a frequency checking unit checks the frequency of occurrence of each of the plurality of characters in the text inserted on each sheet; for each of the plurality of sheets, when the frequency of occurrence of the plurality of characters is sorted in ascending order and the quartiles are calculated, a set generating unit generates a set of selected characters corresponding to each of the plurality of sheets by selecting only the characters having a frequency of occurrence of the third quartile or higher and configuring them into a set; the set of selected characters corresponding to the first sheet and the An electronic terminal device comprising: a selection unit that calculates a Jaccard index between selected character sets corresponding to each of the remaining sheets excluding the first sheet among a plurality of sheets, and then selects the sheet among the remaining sheets for which the calculated Jaccard index with the first sheet is maximum as a similar sheet similar to the first sheet; and an emphasis application unit that, when the selection of the similar sheet is completed, applies a pre-specified emphasis format to the title of the first sheet and the title of the similar sheet among the titles of each of the plurality of sheets displayed on the list display area. Claim 2 An electronic terminal device according to claim 1, wherein the index calculation unit, when the number of cells and the type of format are confirmed for each of the plurality of sheets, calculates a sum score for each of the plurality of sheets by summing all scores corresponding to the confirmed type of format for each sheet by referring to a pre-specified score table—the score table is a table in which scores pre-specified as corresponding to each of the n types of formats are recorded—and then calculates a importance index for each of the plurality of sheets by calculating the weighted average between the number of cells confirmed for each sheet and the sum score calculated for each sheet as an importance index for each sheet. Claim 3 delete Claim 4 delete Claim 5 A method of operating an electronic terminal device, comprising: maintaining a character database in which a plurality of pre-specified characters are stored; when an open command for a spreadsheet document file composed of a plurality of sheets into which data is inserted—each of which has a title and a different sequence number for sorting pre-assigned—is granted from a user, executing a spreadsheet editing program installed on the electronic terminal device to create an interface comprising a body display area for displaying the body area of ​​the document and a list display area for displaying a list of sheets at the bottom of the body display area, and then loading the spreadsheet document file to display the body of the sheet assigned the earliest sequence number among the plurality of sheets on the body display area of ​​the interface, and simultaneously displaying the titles of each of the plurality of sheets sorted in ascending order according to the sequence number assigned to each sheet on the list display area of ​​the interface; when a reordering command is granted from the user instructing to reorder and display the titles of each of the plurality of sheets displayed on the list display area according to importance, for each of the plurality of sheets, data A step of checking the number of inserted cells and simultaneously checking which type of format among a pre-specified n (n is a natural number greater than or equal to 2) types of formats is used, and then calculating an importance index for each of the plurality of sheets based on the number of cells and the type of format confirmed for each of the plurality of sheets; and a step of, when the importance index for each of the plurality of sheets is calculated, rearranging and displaying the titles of each of the plurality of sheets in descending order according to the importance index of each sheet on the list display area of ​​the interface.A step of switching and displaying the body of a sheet displayed in the body text display area to the body of the first sheet when the title of the first sheet, which is one of the titles of the plurality of sheets displayed in the list display area, is selected by the user; a step of checking the frequency of occurrence of each of the plurality of characters in the text inserted on each sheet for each of the plurality of sheets when a command is issued from the user instructing to display similar sheet information similar to the first sheet among the plurality of sheets, while the body of the first sheet is displayed in the body text display area as a result of the title of the first sheet, which is one of the titles of the plurality of sheets displayed in the list display area, is selected by the user; a step of generating a set of selected characters corresponding to each of the plurality of sheets by selecting only the characters having a frequency of occurrence of the third quartile or higher when the frequency of occurrence of the plurality of characters is sorted in ascending order and the quartiles are calculated for each of the plurality of sheets; and a set of selected characters corresponding to the first sheet and the first among the plurality of sheets A method of operation of an electronic terminal device comprising: a step of calculating a Jaccard index between selected character sets corresponding to each of the remaining sheets excluding the sheet, and then selecting, among the remaining sheets, the sheet with the maximum calculated Jaccard index with respect to the first sheet as a similar sheet similar to the first sheet; and a step of, when the selection of the similar sheet is completed, applying a pre-specified highlight format to the title of the first sheet and the title of the similar sheet among the titles of each of the plurality of sheets displayed on the list display area. Claim 6 In claim 5, the step of calculating the importance index is characterized by calculating the importance index for each of the plurality of sheets by summing up all scores corresponding to the confirmed format types for each sheet by referring to a pre-specified score table—the score table is a table in which scores pre-specified as corresponding to each of the n types of formats are recorded—for each of the plurality of sheets, and then calculating the importance index for each of the plurality of sheets by calculating the weighted average between the number of cells confirmed for each sheet and the sum score calculated for each sheet as the importance index for each sheet. Claim 7 delete Claim 8 delete Claim 9 A computer-readable recording medium having a computer program for executing the method of either paragraph 5 or 6 through combination with a computer. Claim 10 A computer program stored on a storage medium for executing the method of either paragraph 5 or 6 through combination with a computer.

Images