KR102466701B1 - Electronic device capable of line break in sentence unit on spreadsheet and operating method thereof - Google Patents

Abstract

Disclosed is an electronic device capable of breaking lines in units of sentences on a spreadsheet. According to the present invention, when a line break command is received from a user for a specific cell of a spreadsheet into which text without line breaks is inserted, the text is divided into sentence units based on a pre-built morpheme analyzer to form a plurality of sentences. The present invention relates to an electronic device capable of improving readability of the specific cell by generating lines and breaking the plurality of sentences for each sentence, and an operating method thereof.

Description

Electronic device capable of breaking lines in sentence units on a spreadsheet and its operating method

The present invention relates to an electronic device capable of line breaking in units of sentences on a spreadsheet and an operating method thereof.

Recently, as computers, smart phones, tablet PCs, etc. have been widely spread, various types of electronic document-related programs have been released that enable users to view, create, and edit electronic documents using these electronic devices.

These electronic document-related programs include a word processor supporting basic document creation and editing, a spreadsheet assisting data input, arithmetic operation, and data management, and a presentation program assisting a presenter's presentation.

Among the above-mentioned electronic document-related programs, a spreadsheet provides a plurality of cells into which data can be input, promotes the convenience of data management, and supports various function commands, so it is widely used in office work.

In a spreadsheet, when a user continuously inputs a plurality of sentences in a single line in a specific cell, a problem in readability may occur.

In this regard, when a user continuously inputs a plurality of sentences in a single line in a specific cell, the existing spreadsheet program does not provide a function of line-breaking the plurality of sentences consecutively input in a single line in sentence units.

For example, when a user continuously inputs the sentences 'a', 'b', 'c', 'd', and 'e' in a single line in a specific cell, in an existing spreadsheet program, the user continuously inputs the sentences in a specific cell. Since it did not provide a function to break the sentences 'a, b, c, d, e' in sentence units, the sentences 'a, b, c, d, e' entered consecutively by the user in a specific cell. There was a problem with poor readability when reading them.

Therefore, it is necessary to research a technique that allows a plurality of sentences input in a single line to be line-wrapped in sentence units in a specific cell of the spreadsheet.

According to the present invention, when a line break command is received from a user for a specific cell of a spreadsheet into which text without line breaks is inserted, the text is divided into sentence units based on a pre-built morpheme analyzer to form a plurality of sentences. An electronic device capable of improving the readability of the specific cell by generating lines and breaking the plurality of sentences for each sentence, and an operating method thereof are proposed.

According to an embodiment of the present invention, an electronic device capable of breaking lines in units of sentences on a spreadsheet sends a user to a first cell in which non-linebreaked text is inserted among a plurality of cells constituting a spreadsheet. When a line-breaking command is received, a sentence generation unit that generates a plurality of sentences by dividing the text into sentence units based on a pre-built morphological analyzer, and line-breaking the plurality of sentences for each sentence By doing so, the sentence breakers for vertically arranging the plurality of sentences in the first cell and the horizontal width of the cells constituting the column including the first cell among the plurality of cells are set to each of the plurality of sentences. It includes a horizontal width adjustment unit that adjusts to match the maximum length of the length.

In addition, according to an embodiment of the present invention, in a method of operating an electronic device capable of breaking lines in units of sentences on a spreadsheet, a first cell in which text without line breaks is inserted among a plurality of cells constituting the spreadsheet is inserted by the user. Generating a plurality of sentences by dividing the text into sentence units based on a pre-built morpheme analyzer when a line-breaking command is received for a cell; by breaking the plurality of sentences into lines for each sentence, vertically arranging the plurality of sentences in one cell, and matching the horizontal widths of the cells constituting the column including the first cell among the plurality of cells to the maximum length of each of the plurality of sentences It includes an adjustment step.

According to the present invention, when a line break command is received from a user for a specific cell of a spreadsheet into which text without line breaks is inserted, the text is divided into sentence units based on a pre-built morpheme analyzer to form a plurality of sentences. It is possible to propose an electronic device and an operating method thereof capable of improving readability of the specific cell by generating lines and breaking the plurality of sentences for each sentence.

1 is a diagram showing the structure of an electronic device capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention.
2 and 3 are diagrams for explaining the operation of an electronic device capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention.
4 is a flowchart illustrating an operating method of an electronic device capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention.

Hereinafter, embodiments according to the present invention will be described in detail with reference to the accompanying drawings. This description is not intended to limit the present invention to specific embodiments, but should be understood to include all modifications, equivalents, and substitutes included in the spirit and scope of the present invention. While describing each drawing, similar reference numerals have been used for similar components, and unless otherwise defined, all terms used in this specification, including technical or scientific terms, are common knowledge in the art to which the present invention belongs. has the same meaning as commonly understood by the person who has it.

In this document, when a certain component is said to "include", it means that it may further include other components without excluding other components unless otherwise stated. In addition, 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, and mechanical functions performed by each component are electronic It may be implemented with various known elements or mechanical elements such as circuits, integrated circuits, ASICs (Application Specific Integrated Circuits), and may be implemented separately or two or more may be integrated into one.

On the other hand, the blocks of the accompanying block diagram or the steps of the flowchart are computer program instructions that perform designated functions by being loaded into a processor or memory of a device capable of data processing, such as a general-purpose computer, a special purpose computer, a portable notebook computer, and a network computer. can be interpreted as meaning Since these computer program instructions may be stored in a memory included in a computer device or in a computer readable memory, the functions described in blocks of a block diagram or steps of a flowchart are produced as a product containing instruction means for performing them. It could be. Further, each block or each step may represent a module, segment or portion of code that includes one or more executable instructions for executing specified logical function(s). Also, it should be noted that in some alternative embodiments, functions mentioned in blocks or steps may be executed out of a predetermined 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.

1 is a diagram showing the structure of an electronic device capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention.

Referring to FIG. 1 , an electronic device 110 capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention includes a sentence generator 111, a sentence line breaker 112, and a horizontal width adjuster 113. ).

The sentence generation unit 111 receives a line break command for a first cell in which text that is not line broken among a plurality of cells constituting the spreadsheet is inserted from the user, the morpheme analyzer built in advance A plurality of sentences are generated by dividing the text into sentence units based on a (Morphological Analyzer).

The sentence line breaking unit 112 vertically aligns the plurality of sentences within the first cell by line breaking the plurality of sentences for each sentence.

In this regard, FIG. 2 is a diagram for explaining the operation of the sentence generator 111 and the sentence line breaker 112 .

First, when a line break command is received from the user for the first cell 211 into which non-line-wrapped text 'Hello, management team, Kanada, thank you' is inserted, as shown by reference numeral 210, the sentence generation unit (111) separates the above text, 'Hello, this is Kanada, the management team', into sentence units based on the pre-built morpheme analyzer, You can create multiple sentences of the same type.

Then, as shown in reference numeral 220, the sentence break unit 112 breaks the plurality of sentences 'Hello', 'Management Team Kanada', and 'Thank you in advance' for each sentence, so that the first cell ( 211), 'Hello', 'This is Kanada from the management team', and 'Thank you', which are the above sentences, can be vertically aligned.

The horizontal width adjusting unit 113 adjusts the horizontal width of the cells constituting the column including the first cell among the plurality of cells to match the maximum length of each of the plurality of sentences.

In this case, according to an embodiment of the present invention, the electronic device 110 may further include a vertical width adjusting unit 114 .

The vertical width adjusting unit 114 adjusts the vertical width of the cells constituting the row including the first cell among the plurality of cells to match the product of the number of sentences and a predetermined standard vertical width. .

In this regard, FIG. 3 is a diagram for explaining operations of the horizontal width adjusting unit 113 and the vertical width adjusting unit 114 .

As described above with reference numeral 220, the plurality of sentences 'Hello', 'This is Management Team Kanada', and 'Thank you' are displayed vertically in the first cell 211 by the sentence break unit 112. Assuming that they are aligned, the horizontal width adjusting unit 113 sets the horizontal width 311 of the cells 212 constituting the column including the first cell 211 among the plurality of cells, as shown by reference numeral 310. Among the plurality of sentences vertically aligned by the line break 112, 'Hello', 'Management Team', and 'Thank you' are adjusted to match the maximum length of 'Management Team's Kanada'. can

After that, the vertical width adjusting unit 114 sets the vertical width 322 of the cells 213 constituting the row including the first cell 211 among the plurality of cells, as shown by reference numeral 320, to the plurality of sentences. It can be adjusted to match the product of '3', which is the number of 'Hello', 'Management Team', and 'Thank you', and the standard vertical width.

In this regard, when the standard vertical width is a width having a size indicated by reference numeral 321, the vertical width adjusting unit 114 determines the vertical width of the cells 213 constituting the row including the first cell 211 ( 322) can be adjusted to match the product of '3', which is the number of the plurality of sentences 'Hello', 'Management Team', and 'Thank you', and the standard vertical width 321.

That is, when the electronic device 110 receives a line break command for a first cell in which text without line breaks is inserted among a plurality of cells constituting the spreadsheet from the user, the electronic device 110 based on a pre-built morpheme analyzer. By dividing the text into sentence units, a plurality of sentences are generated, and the plurality of sentences are vertically aligned in the first cell by line breaking for each sentence, and among the plurality of cells After adjusting the horizontal width of the cells constituting the column including the first cell to match the maximum length of each of the plurality of sentences, the cell constituting the row including the first cell among the plurality of cells By adjusting the vertical width of the text to match the product of the number of the plurality of sentences and a predetermined standard vertical width, line breaks for the text inserted into the first cell may be processed.

According to an embodiment of the present invention, the electronic device 110 includes a character information database 115, a character extractor 116, a character group generator 117, a sum calculator 118, a vector similarity calculator 119, An LCS similarity calculation unit 120 and a similarity measurement value display unit 121 may be further included.

In the character information database 115, a plurality of predetermined characters and different predetermined index numbers for each of the plurality of characters are stored in correspondence with each other.

For example, data as shown in Table 1 below may be stored in the text information database 115 .

multiple characters index number go One he 2 thing 3 chaff 4 ... ...

When a similarity measurement command between the first cell and a second cell, which is another cell into which text is inserted, is received from the user, the character extractor 116 receives a plurality of first cells included in the first cell from the first cell. One character is sequentially extracted in a predetermined first direction, and a plurality of second characters included in the second cell are sequentially extracted from the second cell in the first direction.

Here, the first direction is a direction that can be set in advance by a developer, and may be set from left to right and from top to bottom.

The character group generation unit 117 groups the plurality of first characters in units of a predetermined number of characters to generate a plurality of first character groups, and groups the plurality of second characters in units of the number of characters to create a plurality of first character groups. 2 Create character groups.

For example, as described above, it is assumed that the first cell includes characters such as 'Hello, management team, this is Kanada.

At this time, the character group generation unit 117 groups the characters 'Hello, this is Kana, the management team. Please)' and 'Character group 3(C)' can be created. Similarly, the character group generator 117 may perform the same operation with respect to the second cell, which is another cell into which text is inserted.

Then, the sum operation unit 118 checks index numbers corresponding to the plurality of first characters and the plurality of second characters from the character information database 115, and determines the plurality of first character groups and the plurality of second characters. For each character group constituting the second character groups of , a total sum of index numbers corresponding to characters included in each character group is calculated.

For example, using the example described above, in the case of the first cell, the sum operation unit 118 calculates each of the characters 'Hello, this is Management Team Kanada. After checking the index numbers corresponding to 'character group 1 (Hello Management Team Kana)', the characters included in 'An', 'Nyeong', 'Ha', 'Se', 'Yo', 'Kyung', 'Operation value 1', which is the total sum of index numbers corresponding to 'zero', 'team', 'ga', and 'me', can be calculated, and is included in the 'character group 2 (thank you)' The total sum of the index numbers corresponding to the characters 'Da', 'Ip', 'Ni', 'Da', 'Jal', 'Bu', 'Tak', 'De', 'Lip', and 'Ni'. 'Calculation value 2' can be calculated, and 'calculation value 3', which is the total sum of index numbers corresponding to 'C', which is the characters included in the 'character group 3 (C)', can be calculated. Similarly, the sum calculation unit 118 may perform the same operation with respect to the second cell.

The vector similarity calculation unit 119 generates a first feature vector having as a component a total sum of index numbers calculated for each of the plurality of first character groups for the plurality of first character groups, and For the second character groups, after generating a second feature vector having as a component the total sum of the index numbers calculated for each of the plurality of second character groups, Calculate vector similarity.

In this case, according to an embodiment of the present invention, the vector similarity may be calculated according to Equation 1 below.

Here, M is the vector similarity between two vectors, D is the Euclidean distance between the two vectors, and the Euclidean distance D between the two vectors can be calculated according to Equation 2 below.

In Equation 2, D is the Euclidean distance, and A _i and B _i denote i-th components included in the two vectors. In general, the smaller the Euclidean distance between two vectors, the more similar the two vectors are, and the larger the Euclidean distance between the two vectors, the more dissimilar vectors they are.

For example, if the operation of the vector similarity calculating unit 119 is described using the example described above, the vector similarity calculating unit 119 will use the 'character group 1 (Hello Business Team Kana)' and the 'character group 2 (I'm sorry) Dripni)', the 'character group 3 (C)', the 'calculated value 1' calculated from the 'character group 1 (Hello Management Team Gana)', the 'character group 2 (Daily) It is possible to generate a three-dimensional 'feature vector 1' having as components the 'operation value 2' calculated in the 'character group 3 (c)' and the 'operation value 3' calculated in the 'character group 3 (c)'. With respect to the plurality of character groups generated in the second cell, 'feature vector 2' having as a component a total sum of index numbers calculated in each of the plurality of character groups generated in the second cell may be generated. Then, the vector similarity calculation unit 119 may calculate the vector similarity between the 'feature vector 1' and the 'feature vector 2'.

Thereafter, the LCS similarity calculating unit 120 performs, for each of the plurality of first character groups, characters included in each of the plurality of first character groups and characters in the same order among the plurality of second character groups. After calculating the length of the longest common subsequence (LCS) between the characters included in the group, the average value of the lengths of the LCS calculated for the plurality of first character groups is a value of 0 or more and 1 or less. It is normalized to , and the LCS similarity is calculated.

Here, LCS means a continuous string that matches two strings. When there are 'ACAYKP' and 'CAPCAK', the LCS between the two strings is 'ACAK', and the length of the LCS is '4'. .

For example, the plurality of first character groups are composed of the 'character group 1 (Hello Management Team Kana)' and the 'character group 2 (Thank you for your patience)', and the plurality of second character groups are 'character group 2'. Let's assume that it consists of 'character group 4 (Hello greetings team maba)' and 'character group 5 (I'm sorry)'.

At this time, the LCS similarity calculating unit 120 performs the character group 'Hello Management Team Kana' included in the 'character group 1 (Hello Management Team Kana)' and the character group in the same order among the plurality of second character groups. With the length of the LCS between 'Hello Greetings Timmaba', which is the characters included in 'Character Group 4 (Hello Greetings Timmaba)', '6' for 'Hello Team' can be calculated, The characters included in 'I'm sorry' are the characters included in 'I'm sorry' and the characters included in the 'character group 5 (please take care of me)', which is a character group in the same order among the plurality of second character groups. '9' for 'Please' can be calculated as the length of the LCS between 'Please'. Thereafter, the LCS similarity calculation unit 120 calculates '6' for 'Hello Team', which is the length of the LCS calculated for 'Character Group 1 (Hello Business Team Kana)', and After calculating the average value of '9' for 'Please', which is the length of the LCS calculated for 'Please,' as '7.5', the average value of '7.5' is normalized to a value between 0 and 1, and the LCS similarity can be computed.

At this time, according to one embodiment of the present invention, the LCS similarity calculation unit 120 divides the average value of the lengths of the LCS by the number of characters used when grouping the plurality of first characters and the plurality of second characters. , can be normalized to a value between 0 and 1.

According to the previous example, since the number of characters used when grouping the plurality of first characters and the plurality of second characters is '10', the LCS similarity calculation unit 120 sets the average value '7.5' as the number of characters. By dividing by '10' and calculating '0.75', it can be normalized to a value of 0 or more and 1 or less.

The similarity measurement value display unit 121 calculates a similarity measurement value between the first cell and the second cell based on the vector similarity and the LCS similarity, and calculates the similarity measurement value between the first cell and the second cell. display on the screen.

At this time, according to an embodiment of the present invention, the similarity measurement value display unit 121 determines the vector similarity in advance in order to consider the importance or influence of the vector similarity and the LCS similarity in the process of calculating the similarity measurement value. A weighted average value of the vector similarity and the LCS similarity is calculated by multiplying the LCS similarity by a predetermined first weight and by multiplying the LCS similarity by a predetermined second weight, and then calculating the weighted average value as the It can be calculated as a similarity measurement value.

At this time, according to an embodiment of the present invention, the first weight and the second weight may be composed of a value greater than 0 and less than 1, and the sum of the first weight and the second weight may be calculated as 1.

In addition, according to an embodiment of the present invention, the electronic device 110 includes a color table holding unit 122 and a background display unit 123 so that the degree of similarity between the first cell and the second cell can be recognized at a glance on the spreadsheet. may further include.

The color table maintaining unit 122 is a color table in which a plurality of predetermined different colors and a range value to which upper and lower limits are specified for different predetermined similarity measurement values corresponding to each of the plurality of colors are recorded. save and maintain

For example, the color table maintenance unit 122 may store and maintain a color table as shown in Table 2 below.

multiple colors Range values for similarity measures Red 0 to 0.2 Orange 0.2 to 0.4 yellow 0.4 to 0.6 green 0.6 to 0.8 blue 0.8 to 1

When the background display unit 123 receives a background display command according to the similarity measurement value from the user after the similarity measurement value is displayed on the screen, the background display unit 123 sets the first range value to which the similarity measurement value belongs from the color table. After confirming the first color recorded in correspondence, the background of the first cell and the background of the second cell are configured to be filled with the first color and displayed on the screen.

For example, as in the example described above, suppose that the similarity measurement value is calculated as '0.81' by the similarity measurement value display unit 121 . At this time, after the similarity measurement value '0.81' is displayed on the screen, when a background display command according to the similarity measurement value '0.81' is received from the user, the background display unit 123 displays the color table as shown in Table 2 above. After checking the first color 'blue' recorded in correspondence with the first range value '0.8 to 1' to which the similarity measurement value '0.81' belongs, the background of the first cell and the background of the second cell It can be configured to be filled with 'blue', which is the first color, and displayed on the screen.

4 is a flowchart illustrating an operating method of an electronic device capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention.

In step S410, when a line break command is received from the user for a first cell in which text without line breaks is inserted among a plurality of cells constituting the spreadsheet, the text is read based on a pre-built morpheme analyzer. A plurality of sentences are generated by separating the sentence into sentence units.

In step S420, the plurality of sentences are vertically aligned in the first cell by breaking lines for each sentence.

In step S430, the horizontal width of the cells constituting the column including the first cell among the plurality of cells is adjusted to match the maximum length among the lengths of each of the plurality of sentences.

In this case, according to an embodiment of the present invention, the operating method of the electronic device may determine the vertical width of the cells constituting the row including the first cell among the plurality of cells by the number of sentences and a predetermined reference height. A step of adjusting to match the product of the width may be further included.

In addition, according to an embodiment of the present invention, the operating method of the electronic device includes a character information database in which a plurality of predetermined characters and different predetermined index numbers for each of the plurality of characters are stored in correspondence with each other. and maintaining a plurality of first characters included in the first cell from the first cell when a similarity measuring command between the first cell and a second cell, which is another cell into which text is inserted, is received from the user. sequentially extracting a plurality of second characters included in the second cell from the second cell in a predetermined first direction, and sequentially extracting a plurality of second characters included in the second cell in the first direction; generating a plurality of first character groups by grouping the plurality of second characters by number, and generating a plurality of second character groups by grouping the plurality of second characters by the number of characters; After identifying characters and index numbers corresponding to the plurality of second characters, each character group constituting the plurality of first character groups and the plurality of second character groups is included in each character group. calculating a total sum of index numbers corresponding to the selected characters; a first step having, as a component, a total sum of index numbers calculated in each of the plurality of first character groups for the plurality of first character groups; A feature vector is generated, and a second feature vector having as a component a total sum of index numbers calculated for each of the plurality of second character groups for the plurality of second character groups is generated, and then the first feature vector is generated. calculating a vector similarity between the feature vector and the second feature vector; for each of the plurality of first character groups, characters included in each of the plurality of first character groups and the plurality of second character groups After calculating the length of the longest common subsequence among the characters included in the character groups in the same order among them, the average value of the LCS lengths calculated for the plurality of first character groups is 0 Calculating the LCS similarity by normalizing to a value greater than or equal to 1 and calculating a similarity measurement value between the first cell and the second cell based on the vector similarity and the LCS similarity, and calculating the similarity between the first cell and the second cell. The method may further include displaying the similarity measurement value between cells on a screen.

At this time, according to an embodiment of the present invention, the step of displaying the similarity measurement value on the screen is to multiply the vector similarity by a predetermined first weight, and multiply the LCS similarity by a predetermined second weight to determine the vector similarity and After calculating the weighted average value of the LCS similarities, the weighted average value may be calculated as the similarity measurement value between the first cell and the second cell.

At this time, according to an embodiment of the present invention, the first weight and the second weight may be composed of a value greater than 0 and less than 1, and the sum of the first weight and the second weight may be calculated as 1.

In addition, according to an embodiment of the present invention, the operating method of the electronic device provides upper and lower limit values for a plurality of predetermined different colors and different predetermined similarity measurement values corresponding to each of the plurality of colors. After storing and maintaining the color table in which the designated range value is recorded and displaying the similarity measurement value on the screen, when a background display command according to the similarity measurement value is received from the user, the color table displays the color table. After checking the first color recorded in correspondence with the first range value to which the similarity measurement value belongs, the background of the first cell and the background of the second cell are configured to be filled with the first color, and displayed on the screen. A displaying step may be further included.

In the above, with reference to FIG. 4 , the operating method of an electronic device capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention has been described. Here, the operating method of an electronic device capable of breaking lines in sentence units on a spreadsheet according to an embodiment of the present invention relates to the operation of the electronic device 110 capable of breaking lines in sentence units on a spreadsheet described with reference to FIG. 1 . Since it may correspond to the configuration for, a more detailed description thereof will be omitted.

A method of operating an electronic device capable of line breaking in units of sentences on a spreadsheet according to an embodiment of the present invention may be implemented as a computer program stored in a storage medium for execution through a combination with a computer.

In addition, the operating method of an electronic device capable of breaking lines in sentence units on a spreadsheet according to an 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. have. The computer readable medium may include program instructions, data files, data structures, etc. alone or in combination. Program instructions recorded on the medium may be those specially designed and configured for the present invention or those known and usable to those skilled in computer software. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks and magnetic tapes, optical media such as CD-ROMs and DVDs, and magnetic media such as floptical disks. - includes hardware devices specially configured to store and execute program instructions, such as magneto-optical media, and ROM, RAM, flash memory, and the like. Examples of program instructions include high-level language codes that can be executed by a computer using an interpreter, as well as machine language codes such as those produced by a compiler.

As described above, the present invention has been described by specific details such as specific components and limited embodiments and drawings, but these are provided to help a more general understanding of the present invention, and the present invention is not limited to the above embodiments. , Those skilled in the art in the field to which the present invention belongs can make various modifications and variations from these descriptions.

Therefore, the spirit of the present invention should not be limited to the described embodiments, and it will be said that not only the claims to be described later, but also all modifications equivalent or equivalent to these claims belong to the scope of the present invention. .

110: Electronic device capable of breaking lines in sentence units on a spreadsheet
111: sentence generation unit 112: sentence line break unit
113: horizontal width adjustment unit 114: vertical width adjustment unit
115: character information database 116: character extraction unit
117: character group generation unit 118: sum calculation unit
119: vector similarity calculation unit 120: LCS similarity calculation unit
121: similarity measurement value display unit 122: color table maintenance unit
123: background display unit

Claims (14)

a character information database in which a plurality of predetermined characters and different predetermined index numbers for each of the plurality of characters are stored in correspondence with each other;
When a line break command is received from the user for a first cell in which text that is not line-wrapped is inserted among a plurality of cells constituting the spreadsheet, based on a pre-built Morphological Analyzer, a sentence generation unit generating a plurality of sentences by dividing the text into sentence units;
a sentence line breaking unit for vertically arranging the plurality of sentences within the first cell by breaking the plurality of sentences for each sentence;
a horizontal width adjusting unit for adjusting the horizontal width of the cells constituting the column including the first cell among the plurality of cells to match the maximum length of each of the plurality of sentences;
When a similarity measurement command between the first cell and a second cell, which is another cell into which text is inserted, is received from the user, a plurality of first characters included in the first cell is converted from the first cell into a predetermined first cell. a character extraction unit sequentially extracting a plurality of second characters included in the second cell from the second cell in the first direction;
A character group generating a plurality of first character groups by grouping the plurality of first characters in units of a predetermined number of characters, and generating a plurality of second character groups by grouping the plurality of second characters in units of the number of characters. generating unit;
After checking the index numbers corresponding to the plurality of first characters and the plurality of second characters from the character information database, each character constituting the plurality of first character groups and the plurality of second character groups a sum calculation unit for calculating a total sum of index numbers corresponding to characters included in each character group, for each group;
For the plurality of first character groups, a first feature vector having as a component a total sum of index numbers calculated for each of the plurality of first character groups is generated, and for the plurality of second character groups , Vector similarity of generating a second feature vector having as a component the total sum of index numbers calculated from each of the plurality of second character groups, and then calculating a vector similarity between the first feature vector and the second feature vector. calculation unit;
For each of the plurality of first character groups, the longest commonality between characters included in each of the plurality of first character groups and characters included in a character group in the same order among the plurality of second character groups After calculating the length of the longest common sequence (LCS), the LCS similarity is calculated by normalizing the average value of the LCS lengths calculated for the plurality of first character groups to a value of 0 or more and 1 or less. a similarity calculation unit; and
A similarity measurement value for calculating a similarity measurement value between the first cell and the second cell based on the vector similarity and the LCS similarity, and displaying the similarity measurement value between the first cell and the second cell on a screen. display part
including,
The similarity measurement value display unit
A weighted average value of the vector similarity and the LCS similarity is calculated by multiplying the vector similarity by a predetermined first weight and by multiplying the LCS similarity by a predetermined second weight, and then calculating the weighted average value between the first cell and the LCS similarity. An electronic device capable of breaking lines in sentence units on a spreadsheet calculated with the similarity measurement value between second cells. According to claim 1,
A vertical width adjusting unit that adjusts the vertical width of the cells constituting the row including the first cell among the plurality of cells to match the product of the number of sentences and a predetermined standard vertical width.
An electronic device capable of breaking lines in units of sentences on a spreadsheet further comprising. delete delete According to claim 1,
The electronic device capable of breaking lines in sentence units on a spreadsheet in which the first weight and the second weight are composed of values greater than 0 and less than 1, and the sum of the first weight and the second weight is calculated as 1. According to claim 1,
Maintaining a color table that stores and maintains a color table in which a plurality of different predetermined colors and range values in which upper and lower limits are designated for different predetermined similarity measurement values corresponding to each of the plurality of colors are recorded wealth; and
After the similarity measurement value is displayed on the screen, if a command to display a background according to the similarity measurement value is received from the user, the first range value to which the similarity measurement value belongs is recorded from the color table. After confirming one color, the background display unit configures the background of the first cell and the background of the second cell to be filled with the first color and displays the background on the screen.
An electronic device capable of breaking lines in units of sentences on a spreadsheet further comprising. maintaining a character information database in which a plurality of predetermined characters and different predetermined index numbers corresponding to each other are stored;
When a line break command is received from the user for a first cell in which text that is not line-wrapped is inserted among a plurality of cells constituting the spreadsheet, based on a pre-built Morphological Analyzer, generating a plurality of sentences by dividing the text into sentence units;
arranging the plurality of sentences vertically in the first cell by breaking lines for each sentence;
adjusting a horizontal width of cells constituting a column including the first cell among the plurality of cells to match a maximum length among lengths of each of the plurality of sentences;
When a similarity measurement command between the first cell and a second cell, which is another cell into which text is inserted, is received from the user, a plurality of first characters included in the first cell is converted from the first cell into a predetermined first cell. sequentially extracting in the first direction, and sequentially extracting a plurality of second characters included in the second cell from the second cell in the first direction;
generating a plurality of first character groups by grouping the plurality of first characters by a predetermined number of characters, and generating a plurality of second character groups by grouping the plurality of second characters by the number of characters;
After checking the index numbers corresponding to the plurality of first characters and the plurality of second characters from the character information database, each character constituting the plurality of first character groups and the plurality of second character groups calculating a total sum of index numbers corresponding to characters included in each character group, for each group;
For the plurality of first character groups, a first feature vector having as a component a total sum of index numbers calculated for each of the plurality of first character groups is generated, and for the plurality of second character groups After generating a second feature vector having as a component the total sum of index numbers calculated from each of the plurality of second character groups, calculating a vector similarity between the first feature vector and the second feature vector;
For each of the plurality of first character groups, the longest commonality between characters included in each of the plurality of first character groups and characters included in a character group in the same order among the plurality of second character groups After calculating the length of the longest common sequence (LCS), calculating the LCS similarity by normalizing the average value of the lengths of the LCS calculated for the plurality of first character groups to a value greater than or equal to 0 and less than or equal to 1 ; and
Calculating a similarity measurement value between the first cell and the second cell based on the vector similarity and the LCS similarity, and displaying the similarity measurement value between the first cell and the second cell on a screen
including,
Displaying the similarity measurement value on the screen
A weighted average value of the vector similarity and the LCS similarity is calculated by multiplying the vector similarity by a predetermined first weight and by multiplying the LCS similarity by a predetermined second weight, and then calculating the weighted average value between the first cell and the LCS similarity. A method of operating an electronic device capable of breaking lines in sentence units on a spreadsheet calculated with the similarity measurement value between second cells. According to claim 7,
Adjusting the vertical width of cells constituting a row including the first cell among the plurality of cells to match the product of the number of sentences and a predetermined reference vertical width
A method of operating an electronic device capable of line breaking in units of sentences on a spreadsheet further comprising: delete delete According to claim 7,
The first weight and the second weight are composed of values greater than 0 and less than 1, and the sum of the first weight and the second weight is calculated as 1. Operation of an electronic device capable of breaking lines in sentence units on a spreadsheet. Way. According to claim 7,
Storing and maintaining a color table in which a plurality of predetermined different colors and range values to which upper and lower limits are designated for different predetermined similarity measurement values corresponding to each of the plurality of colors are recorded; and
After the similarity measurement value is displayed on the screen, if a command to display a background according to the similarity measurement value is received from the user, the first range value to which the similarity measurement value belongs is recorded from the color table. After confirming 1 color, configuring the background of the first cell and the background of the second cell to be filled with the first color and displaying the background on the screen
A method of operating an electronic device capable of line breaking in units of sentences on a spreadsheet further comprising: Claim 7, claim 8, claim 11 or claim 12 of any one of the method through a combination with a computer to execute a computer program recorded on a computer-readable recording medium. A computer program stored in a storage medium for executing the method of any one of claims 7, 8, 11 or 12 through a combination with a computer.

Images