KR102466711B1 - Spreadsheet document editing apparatus capable of displaying adjustment controls that match the data notation format of the input data and operating method thereof - Google Patents

Abstract

Disclosed are a spreadsheet document editing device capable of displaying an adjustment control matching a data display format of input data and an operation method thereof. The present invention is a spreadsheet document editing device capable of displaying an adjustment control matching a data display format of data input to a specific cell on a screen when data is input to a specific cell among a plurality of cells constituting a spreadsheet by a user. and its operating method.

Description

A spreadsheet document editing device capable of displaying adjustment controls matching the data notation format of input data and its operating method

The present invention relates to a spreadsheet document editing device capable of displaying an adjustment control matching a data display format of input data and an operation 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 quickly enters data into a specific cell, the problem of entering data incorrectly without the user's knowledge may occur.

In this regard, if the spreadsheet allows the user to display an adjustment control to help the user easily adjust the erroneously entered data when the user inputs data incorrectly into a cell, the user's convenience can be increased. will be.

However, existing spreadsheet programs do not provide a function that analyzes the data display format of the incorrectly entered data and displays an adjustment control matching the analyzed data display format when the user incorrectly inputs data in a specific cell. did not

For example, if a user incorrectly inputs the data '0.05' into a specific cell as '0.005', in the existing spreadsheet program, the data display format of the data '0.005' incorrectly entered into a specific cell is converted to a decimal notation format. After analysis, it did not provide a function to display a decimal point adjustment control that matches the analyzed data display format. As a result, the user needs to check the position of the decimal point one by one in order to adjust data '0.005' incorrectly entered in a specific cell to '0.05'. If a decimal point adjustment control having an interface supporting adjustment of the decimal point position of '0.005' data is displayed at a point adjacent to the specific cell, the user can use the decimal point adjustment control to determine the decimal point position of '0.005' data. can be easily adjusted to '0.05'.

Therefore, it is necessary to study a technique capable of displaying an adjustment control matching the analyzed data display format after analyzing the data display format of data input to a specific cell of the spreadsheet.

The present invention is a spreadsheet document editing device capable of displaying an adjustment control matching a data display format of data input to a specific cell on a screen when data is input to a specific cell among a plurality of cells constituting a spreadsheet by a user. And by presenting an operation method thereof, it is intended to support the user to easily adjust data input to the specific cell through the adjustment control.

According to an embodiment of the present invention, a spreadsheet document editing apparatus capable of displaying an adjustment control matching a data representation format of input data is a regular expression preset to correspond to each of a plurality of predetermined data representation formats. (Regular Expression) set - the regular expression set is a set consisting of a set of at least one regular expression specified as corresponding to each data representation format - a regular expression set storage unit storing each of the plurality of data representation formats an adjustment control storage unit in which interfacing data for preset adjustment controls corresponding to , wherein the interfacing data is data used for rendering each adjustment control and displayed on a screen, is stored; If the first data is input to the first cell, which is one of the plurality of cells, the string of the first data input to the first cell is checked, and the string of the first data is determined by referring to the regular expression set storage unit. A data notation format check unit for selecting a first regular expression set including a regular expression matching a pattern in the set and then checking a first data notation format corresponding to the first regular expression set among the plurality of data notation formats. , If the first data representation format is confirmed, an adjustment control extraction unit extracting interfacing data for the first adjustment control corresponding to the first data representation format from the adjustment control storage unit, and interfacing the first adjustment control and an adjustment control display unit displaying the first adjustment control at an adjacent point of the first cell based on the interfacing data for the first adjustment control when data is extracted.

In addition, an operating method of a spreadsheet document editing apparatus capable of displaying an adjustment control matching a data display format of input data according to an embodiment of the present invention is preset to correspond to each of a plurality of preset data display formats. Maintaining a regular expression set storage unit in which a set of regular expressions is stored, the regular expression set being a set composed of a set of at least one regular expression specified as corresponding to each data representation format; maintaining an adjustment control storage unit in which interfacing data for adjustment controls preset to correspond to each other, wherein the interfacing data is data used to render each adjustment control and display it on a screen, is stored; When first data is input to a first cell, which is one of a plurality of cells constituting a sheet, a character string of the first data input to the first cell is checked, and the first data string is checked by referring to the regular expression set storage unit. After selecting a first regular expression set including a regular expression matching a pattern of a string of data in the set, checking a first data notation format corresponding to the first regular expression set among the plurality of data notation formats If the first data representation format is confirmed, extracting interfacing data for a first adjustment control corresponding to the first data representation format from the adjustment control storage unit, and extracting the interfacing data for the first adjustment control. and displaying the first adjustment control at a location adjacent to the first cell based on the interfacing data for the first adjustment control.

The present invention is a spreadsheet document editing device capable of displaying an adjustment control matching a data display format of data input to a specific cell on a screen when data is input to a specific cell among a plurality of cells constituting a spreadsheet by a user. And by presenting an operation method thereof, it is possible to support a user to easily adjust data input to the specific cell through the adjustment control.

1 is a diagram showing the structure of a spreadsheet document editing device according to an embodiment of the present invention.
2 to 7 are diagrams for explaining the operation of a spreadsheet document editing apparatus according to an embodiment of the present invention.
8 is a flowchart illustrating an operating method of a spreadsheet document editing device 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 a spreadsheet document editing device according to an embodiment of the present invention.

A spreadsheet document editing device 110 according to the present invention is a device capable of displaying an adjustment control matching a data display format of input data, and includes a regular expression set storage unit 111, an adjustment control storage unit 112, data It includes a notation format confirmation unit 113, an adjustment control extraction unit 114 and an adjustment control display unit 115.

In the regular expression set storage unit 111, a set of regular expressions preset to correspond to each of a plurality of data representation formats (the regular expression set is at least designated as corresponding to each data representation format) A set consisting of a set of regular expressions) is stored.

In this case, according to an embodiment of the present invention, the plurality of data display formats may include a date display format, a decimal point display format, and a percentage display format.

Here, the regular expression means a formal language used to express a set of character strings having specific rules, such as '111-222-333' or '12345-67890'.

For example, information as shown in Table 1 below may be stored in the regular expression set storage unit 111 .

data representation formats regular expression set Data notation format 1
(date notation format) regular expression set 1 ^\d{4} \- \d{2} \- \d{2}$ ^\d{4} \. \d{2} \. \d{2}$ ^\d{2} \. \d{2} \. \d{4}$ Data notation format 2
(decimal point notation format) regular expression set 2 ^\d \. \d$ Data notation format 3
(percentage format) regular expression set 3 ^\d \%$ ^\d \. \d \%$

In the adjustment control storage unit 112, interfacing data for adjustment controls preset as corresponding to each of the plurality of data display formats (the interfacing data is data used to render each adjustment control and display it on the screen) is stored

At this time, the adjustment control storage unit 112 stores interfacing data for a calendar control enabling date adjustment with an adjustment control corresponding to the date notation format, and a position of a decimal point with an adjustment control corresponding to the decimal point notation format. Interfacing data for a decimal point adjustment control enabling adjustment may be stored, and interfacing data for a percentage adjustment control enabling adjustment of the size of a number with an adjustment control corresponding to the percentage notation format may be stored.

In this regard, information as shown in Table 2 below may be stored in the adjustment control storage unit 112 .

data representation formats Interfacing data for coordination controls Data notation format 1
(date notation format) adjustment control 1
(calendar control) interfacing data 1 Data notation format 2
(decimal point notation format) Tuning Control 2
(decimal point adjustment control) interfacing data 2 Data notation format 3
(percentage format) adjustment control 3
(percentage adjustment control) interfacing data 3

At this time, according to one embodiment of the present invention, the calendar control may be a control having an interface that enables date adjustment, as shown at reference numeral 211 in FIG. 2 , and the decimal point adjustment control is shown in FIG. As shown in the figure shown at reference numeral 212, it may be a control having an interface that allows position adjustment of the decimal point, and the percentage adjustment control, as shown in the figure shown at reference numeral 213 in FIG. 2, allows adjustment of the size of the number. It can be a control that has an interface that allows

The data notation format checking unit 113 checks a character string of the first data input in the first cell when the user inputs first data into a first cell, which is any one of a plurality of cells constituting the spreadsheet, and After selecting the first regular expression set including the regular expression matching the pattern of the string of the first data in the set with reference to the regular expression set storage unit 111, the first among the plurality of data representation formats A first data notation format corresponding to the regular expression set is checked.

When the first data display format is identified, the adjustment control extractor 114 extracts interfacing data for the first adjustment control corresponding to the first data display format from the adjustment control storage unit 112 .

When interfacing data for the first adjustment control is extracted, the adjustment control display unit 115 displays the first adjustment control at a location adjacent to the first cell based on the interfacing data for the first adjustment control.

In this regard, operations of the data notation format confirmation unit 113, the adjustment control extraction unit 114, and the adjustment control display unit 115 will be described with reference to the figure shown in FIG. 3 as follows.

First, assuming that the first data '2020.05.15' is input from the user to the first cell 311, which is one of a plurality of cells constituting the spreadsheet, the data notation format check unit 113 checks the first cell The string of '2020.05.15', which is the first data entered in (311), can be confirmed.

Then, the data notation format confirmation unit 113 refers to the regular expression set storage unit 111 as shown in Table 1 above, and the regular expression '^' matching the pattern of the string of the first data '2020.05.15' \d{4} \. \d{2} \. After selecting 'Regular Expression Set 1', which is the first regular expression set including '\d{2}$' in the set, 'Data Notation Format 1 (Date Format), Data Notation Format 2', which are the plurality of data notation formats. (decimal point notation format), data notation format 3 (percentage notation format)', which is the first data notation format corresponding to 'regular expression set 1', which is the first regular expression set, 'data notation format 1 (date notation format)' can confirm.

At this time, when the first data notation format 'data notation format 1 (date notation format)' is confirmed by the data notation format check unit 113, the adjustment control extractor 114 stores the adjustment controls as shown in Table 2 above. From the unit 112, 'interfacing data' for 'adjustment control 1 (calendar control) 211', which is the first adjustment control corresponding to the first data notation format 'data notation format 1 (date notation format)' Data 1' can be extracted.

In this way, when 'interfacing data 1', which is interfacing data for the first adjustment control 'adjustment control 1 (calendar control) 211' is extracted by the adjustment control extractor 114, the adjustment control display unit 115 Based on 'interfacing data 1', which is interfacing data for 'adjustment control 1 (calendar control) 211', which is the first adjustment control, 'adjustment control', which is the first adjustment control, is placed adjacent to the first cell 311. 1 (calendar control) 211' may be displayed.

That is, the spreadsheet document editing device 110 stores a preset regular expression set corresponding to each of a plurality of preset data display formats in the regular expression set storage unit 111, and stores the regular expression set in the adjustment control storage unit 112. In a state in which interfacing data for an adjustment control preset to correspond to each of the plurality of data display formats is stored, when first data is input to a first cell, which is one of a plurality of cells constituting a spreadsheet, from a user , Checking the string of the first data input in the first cell, and referring to the regular expression set storage unit 111 to include a regular expression matching the pattern of the string of the first data in the set. After selecting a regular expression set, a first data notation format corresponding to the first regular expression set among the plurality of data notation formats is checked, and a first data notation format corresponding to the first data notation format is received from the adjustment control storage unit 112. By extracting interfacing data for one adjustment control, the first adjustment control may be displayed at an adjacent point of the first cell based on the interfacing data for the first adjustment control.

According to one embodiment of the present invention, the spreadsheet document editing device 110 may further include an adjustment control display point table holding unit 116 .

The adjustment control display point table holding unit 116 stores and maintains an adjustment control display point table in which information on different predetermined control display points corresponding to each of the plurality of data display formats is recorded.

Here, the adjustment control display point means any one point selected from eight points corresponding to the upper left, upper, upper right, right, lower right, lower, lower left, and left sides of the cell. In addition, when it is assumed that there is a cell 410 as indicated by reference numeral 410 in FIG. 4, the eight points are the upper left 411, upper 412, upper right 413, right 414, and right of the cell 410. Bottom 415, bottom 416, bottom left 417, and left 418.

At this time, according to an embodiment of the present invention, the adjustment control display point table maintaining unit 116 may store and maintain the adjustment control display point table as shown in Table 3 below.

data representation formats Information about adjustment control display points Data notation format 1
(date notation format) point corresponding to the lower right corner of the cell Data notation format 2
(decimal point notation format) point corresponding to the left side of the cell Data notation format 3
(percentage format) point corresponding to the top of the cell

At this time, when the interfacing data for the first adjustment control is extracted, the adjustment control display unit 115 checks the first adjustment control display point corresponding to the first data display format from the adjustment control display point table, and then the first adjustment control display point 115 Based on the interfacing data for the adjustment control, the first adjustment control may be positioned and displayed at a display point of the first adjustment control in the first cell.

In this regard, the operation of the adjustment control display unit 115 will be described with reference to the figure shown in FIG. 5 as follows.

First, the first adjustment control is referred to as 'adjustment control 1 (calendar control) 211', and interfacing data for 'adjustment control 1 (calendar control) 211' is referred to as 'interfacing data 1'. 1 Assume that the data notation format is 'data notation format 1 (date notation format)'.

At this time, when 'interfacing data 1', which is interfacing data for the first adjustment control 'adjustment control 1 (calendar control) 211' is extracted by the adjustment control extractor 114, the adjustment control display unit 115 From the adjustment control display point table as shown in Table 3, the lower right corner of the 'first cell 311', which is the first adjustment control display point corresponding to 'data notation format 1 (date notation format)', which is the first data display format. A point 511 'corresponding to can be identified.

Thereafter, the adjustment control display unit 115 displays the first adjustment control display point 'adjustment control 1 (calendar control) 211' based on 'interfacing data 1' which is interfacing data for 'adjustment control 1 (calendar control) 211'. The first adjustment control 'adjustment control 1 (calendar control) 211' may be positioned and displayed at the point 511 corresponding to the lower right corner of the first cell 311 .

According to an embodiment of the present invention, a preset order of importance may be assigned to each of the eight points, i.e., the upper left, upper, upper right, right, lower right, lower, lower left, and left points of the cell. For example, '5, 6, 7, 8, 1, 3, 2, 4' may be assigned to each of the upper left, upper, upper right, right, lower right, lower, lower left, and left points of the cell in order of importance. have.

At this time, the adjustment control display unit 115 may include a confirmation unit 117 , an alternative point selection unit 118 and an alternative adjustment control display unit 119 .

The check unit 117 is adjacent to each of the 8 points in the first cell when data is inserted in a neighboring cell positioned adjacent to the first adjustment control display point in the first cell. At least one point where data is not inserted in the neighboring cell is identified.

The alternative point selector 118 selects a second adjustment control display point having the earliest priority in the order of importance among the at least one point.

Substitute adjustment control display unit 119, when the second adjustment control display point is selected, displays the first adjustment control display point at the second adjustment control display point in the first cell based on the interfacing data for the first adjustment control. position and display

In this regard, operations of the confirmation unit 117, the alternative point selection unit 118, and the alternative adjustment control display unit 119 will be described with reference to the figure shown in FIG. 6 as follows.

First, the first adjustment control is referred to as 'adjustment control 1 (calendar control) 211', and interfacing data for 'adjustment control 1 (calendar control) 211' is referred to as 'interfacing data 1'. Assume that 1 data notation format is 'data notation format 1 (date notation format)' and that the first adjustment control display point is 'the point 511 corresponding to the lower right corner of the first cell 311'.

At this time, if data '1985.05.14' is inserted in a neighboring cell located adjacent to the 'point 511 corresponding to the lower right corner of the first cell 311', which is the first adjustment control display point, it is checked. The part 117 is a point corresponding to the top left of the first cell 311, a point corresponding to the top of the first cell 311, a point corresponding to the top right of the first cell 311, A point corresponding to the right side of the first cell 311, a point corresponding to the lower right end of the first cell 311, a point corresponding to the lower end of the first cell 311, a point corresponding to the lower left end of the first cell 311 Corresponds to the upper left corner of the first cell 311, which is at least one point where data is not inserted in a neighboring cell located adjacent to each point among the corresponding point and the point corresponding to the left side of the first cell 311. A point corresponding to the upper end of the first cell 311, a point corresponding to the upper right of the first cell 311, a point corresponding to the right side of the first cell 311, a lower end of the first cell 311 A point corresponding to , a point corresponding to the bottom left of the first cell 311 , and a point corresponding to the left side of the first cell 311 'can be checked.

If the eight points, 'a point corresponding to the top left of the first cell 311, a point corresponding to the top of the first cell 311, a point corresponding to the top right of the first cell 311, the first cell A point corresponding to the right side of 311, a point corresponding to the lower right end of the first cell 311, a point corresponding to the lower end of the first cell 311, a point corresponding to the lower left end of the first cell 311 and a point corresponding to the left side of the first cell 311', if it is assumed that the preset order of importance is designated as '5, 6, 7, 8, 1, 3, 2, 4', an alternative point selector 118 denotes the at least one point, 'a point corresponding to the top left of the first cell 311, a point corresponding to the top of the first cell 311, a point corresponding to the top right of the first cell 311, A point corresponding to the right side of the first cell 311, a point corresponding to the bottom of the first cell 311, a point corresponding to the bottom left of the first cell 311, and a point corresponding to the left side of the first cell 311 A 'point 611 corresponding to the lower left corner of the first cell 311' having the earliest order of importance among the 'points 611 corresponding to the lower left of the first cell 311' may be selected as the second adjustment control display point.

In this way, when the 'point 611 corresponding to the lower left of the first cell 311' is selected as the second adjustment control display point by the alternative point selector 118, the alternative adjustment control display unit 119 displays the Based on 'interfacing data 1', which is interfacing data for 'adjustment control 1 (calendar control) 211', which is the first adjustment control, it corresponds to the lower left corner of the 'first cell 311', which is the second adjustment control display point. The 'adjustment control 1 (calendar control) 211', which is the first adjustment control, may be positioned and displayed at the point 611 of

That is, when the spreadsheet document editing device 110 determines that data is inserted in a neighboring cell positioned adjacent to the first adjustment control display point, the data inserted into the neighboring cell may not be visible by the adjustment control. Therefore, the adjustment control can be displayed at an alternative position to the first adjustment control display position.

According to one embodiment of the present invention, the spreadsheet document editing device 110 may further include a paste processing unit 120 and a data synchronization processing unit 121 .

When a copy command for the first data is applied from the user and a paste command for the first data is applied to a second cell among the plurality of cells, the paste processing unit 120 copies the first data to the second cell. Second data identical to the first data is inserted, and the first adjustment control is displayed at an adjacent point of the second cell based on interfacing data for the first adjustment control.

After the second data is inserted into the second cell and the first adjustment control is displayed at a point adjacent to the second cell, the data synchronization processing unit 121 is configured to display the user at the point adjacent to the second cell. When the second data inserted into the second cell is changed to third data as the second data is adjusted through the first adjustment control, the first data input into the first cell is changed. Change to the third data.

In this regard, operations of the paste processing unit 120 and the data synchronization processing unit 121 will be described with reference to figures 710 and 720 of FIG. 7 .

First, the first data input in the first cell 711 is set to '0.005', the first adjustment control is set to 'adjustment control 2 (decimal point adjustment control) 212', and 'adjustment control 2 ( Assume that the interfacing data for the decimal point adjustment control) 212' is 'interfacing data 2'.

At this time, after a copy command for the first data '0.005' input to the first cell 711 is applied from the user, the second cell 721 of the plurality of cells receives the first data '0.005' input. When a paste command for ' is applied to the spreadsheet document editing device 110, the paste processing unit 120, as indicated by reference numeral 710, stores the same as '0.005', which is the first data, in the second cell 721. Second data '0.005' is inserted, and the second cell 721 is formed based on 'interfacing data 2' which is interfacing data for 'adjustment control 2 (decimal point adjustment control) 212' which is the first adjustment control. 'Adjustment control 2 (decimal point adjustment control) 212', which is the first adjustment control, may be displayed at an adjacent point.

In this way, the second data '0.005' is inserted into the second cell 721 by the paste processing unit 120, and the first adjustment control 'adjustment control 2 ( After the decimal point adjustment control) 212' is displayed, the user selects the second adjustment control through the 'adjustment control 2 (decimal point adjustment control) 212', which is the first adjustment control displayed at an adjacent point of the second cell 721. As the data '0.005' is adjusted, when the second data '0.005' inserted into the second cell 721 is changed to the third data '0.05', the data synchronization processing unit 121 As shown in the figure 720, the first data '0.005' input to the first cell 711 may be changed to '0.05' the third data.

That is, when the second data is changed in the second cell 721, the spreadsheet document editing device 110 changes the first data in the first cell 711 in response to the change in the first cell 711 and the first cell 711. Synchronization of data change between the second cells 721 may be processed.

8 is a flowchart illustrating an operating method of an apparatus for editing a spreadsheet document capable of displaying an adjustment control matching a data display format of input data according to an embodiment of the present invention.

In step S810, a preset regular expression set corresponding to each of a plurality of preset data representation formats (the regular expression set is a set consisting of a set of at least one regular expression designated as corresponding to each data representation format) Maintains a regular expression set store where is stored.

In step S820, interfacing data for preset adjustment controls corresponding to each of the plurality of data display formats (the interfacing data is data used to render each adjustment control and display it on the screen) is stored. Maintains a storage of adjustment controls.

In step S830, when first data is input from the user to a first cell, which is any one of a plurality of cells constituting the spreadsheet, a character string of the first data input to the first cell is checked, and the regular expression After selecting a first regular expression set including a regular expression matching the string pattern of the first data with reference to the set storage unit, the first regular expression set corresponding to the first regular expression set among the plurality of data representation formats is selected. 1 Check the data notation format.

In step S840, if the first data display format is confirmed, interfacing data for a first adjustment control corresponding to the first data display format is extracted from the adjustment control storage unit.

In step S850, when interfacing data for the first adjustment control is extracted, the first adjustment control is displayed at a location adjacent to the first cell based on the interfacing data for the first adjustment control.

In this case, according to an embodiment of the present invention, the plurality of data display formats may include a date display format, a decimal point display format, and a percentage display format.

At this time, the adjustment control storage unit stores interfacing data for a calendar control enabling date adjustment with an adjustment control corresponding to the date notation format, and position adjustment of a decimal point with an adjustment control corresponding to the decimal point format. Interfacing data for a decimal point adjustment control that enables adjustment of numbers may be stored, and interfacing data for a percentage adjustment control that enables adjustment of the size of a number with an adjustment control corresponding to the percentage notation format may be stored.

In addition, according to one embodiment of the present invention, the operating method of the spreadsheet document editing device may include predetermined different adjustment control display points corresponding to each of the plurality of data display formats (the adjustment control display point is the upper left corner of the cell). , top, top right, bottom right, bottom right, bottom, bottom left, and any one point selected from among eight points corresponding to the left) is stored and maintained to store and maintain the adjustment control display point table in which information on It may further include steps to do.

At this time, in step S850, when interfacing data for the first adjustment control is extracted, a first adjustment control display point corresponding to the first data display format is checked from the adjustment control display point table, and then the first adjustment control display point is checked. The first adjustment control may be positioned and displayed at a display point of the first adjustment control in the first cell based on interfacing data for .

In this case, according to an embodiment of the present invention, each of the eight points may be assigned a preset order of importance.

At this time, in step S850, if data is inserted in a neighboring cell located adjacent to the first adjustment control display point in the first cell, each of the eight points in the first cell identifying at least one point at which data is not inserted in adjacent cells; selecting a second adjustment control display point having the earliest priority among the at least one point; and and if a display point is selected, positioning and displaying the first adjustment control at a display point of the second adjustment control in the first cell based on the interfacing data for the first adjustment control.

Further, according to one embodiment of the present invention, the operating method of the spreadsheet document editing device may include copying the first data to a second cell among the plurality of cells after a copy command for the first data is applied from the user. When a paste command for is applied, second data identical to the first data is inserted into the second cell, and the first adjustment is placed at a point adjacent to the second cell based on interfacing data for the first adjustment control. After the step of displaying a control and the second data is inserted into the second cell, and the first adjustment control is displayed at a point adjacent to the second cell, the user views the first adjustment control displayed at a point adjacent to the second cell. 1 When the second data inserted into the second cell is changed to third data as the second data is adjusted through the adjustment control, the first data input into the first cell is changed to the third data. A step of changing to third data may be further included.

In the above, the operating method of the spreadsheet document editing apparatus according to an embodiment of the present invention has been described with reference to FIG. 8 . Here, since the operation method of the spreadsheet document editing apparatus according to an embodiment of the present invention may correspond to the configuration of the operation of the spreadsheet document editing apparatus 110 described with reference to FIGS. A detailed description will be omitted.

The operating method of the spreadsheet document editing device 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 the spreadsheet document editing device according to an embodiment of the present invention may be implemented in the form of computer program instructions to be executed through a combination with a computer and recorded on a computer readable medium. 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: spreadsheet document editing device
111: regular expression set storage unit 112: adjustment control storage unit
113: data notation format confirmation unit 114: adjustment control extraction unit
115: adjustment control display
116: adjustment control display point table holding part
117: confirmation unit 118: alternative point selection unit
119: alternative adjustment control display unit 120: paste processing unit
121: data synchronization processing unit

Claims (12)

A set of regular expressions preset as corresponding to each of a plurality of predetermined data representation formats - the regular expression set is a set consisting of a set of at least one regular expression designated as corresponding to each data representation format a regular expression set storage unit in which Lim - is stored;
an adjustment control storage unit in which interfacing data for preset adjustment controls corresponding to each of the plurality of data display formats is stored, wherein the interfacing data is data used to render each adjustment control and display the adjustment control on a screen; ;
When the first data is input from the user to the first cell, which is one of a plurality of cells constituting the spreadsheet, the character string of the first data input to the first cell is checked, and the regular expression set storage unit is referred to. After selecting a first regular expression set including a regular expression matching the pattern of the character string of the first data in the set, a first data notation format corresponding to the first regular expression set among the plurality of data notation formats Data notation format confirmation unit to be checked;
an adjustment control extraction unit extracting interfacing data for a first adjustment control corresponding to the first data representation format from the adjustment control storage unit when the first data representation format is identified;
an adjustment control display unit displaying the first adjustment control at a point adjacent to the first cell based on the interfacing data for the first adjustment control when interfacing data for the first adjustment control is extracted;
If a copy command for the first data is applied from the user and then a paste command for the first data is applied to a second cell among the plurality of cells, the second cell has the same second data as the first data. a paste processing unit that inserts data and displays the first adjustment control at an adjacent point of the second cell based on the interfacing data for the first adjustment control; and
After the second data is inserted into the second cell and the first adjustment control is displayed at a point adjacent to the second cell, the user may perform the adjustment through the first adjustment control displayed at a point adjacent to the second cell. As the second data is adjusted, if the second data inserted into the second cell is changed into third data, the first data input into the first cell is changed into the third data. Data Synchronization Processing Unit
A spreadsheet document editing device capable of displaying adjustment controls that match the data notation format of input data that includes. According to claim 1,
The plurality of data display formats include a date display format, a decimal point display format, and a percentage display format,
The adjustment control storage unit has
Interfacing data for a calendar control enabling date adjustment with an adjustment control corresponding to the date notation format is stored, and a decimal point adjustment control enabling adjustment of the position of a decimal point with an adjustment control corresponding to the decimal point format Interfacing data is stored, and an adjustment control matching the data representation format of the input data in which the interfacing data for the percentage adjustment control that enables the size of the number can be adjusted with the adjustment control corresponding to the percentage display format is displayed. A device capable of editing spreadsheet documents. According to claim 1,
Different predetermined adjustment control display points corresponding to each of the plurality of data display formats - The adjustment control display points include eight control display points corresponding to the upper left, upper, upper right, right, lower right, lower, lower left, and left sides of the cell. Refers to any one point selected among the points - Adjustment control display point table maintenance unit that stores and maintains the adjustment control display point table in which information about it is recorded
Including more,
The adjustment control display unit
When the interfacing data for the first adjustment control is extracted, a first adjustment control display point corresponding to the first data display format is identified from the adjustment control display point table, and based on the interfacing data for the first adjustment control, A spreadsheet document editing device capable of displaying an adjustment control matching a data display format of input data to be displayed by positioning the first adjustment control at a display point of the first adjustment control in the first cell. According to claim 3,
Each of the eight points is assigned a preset order of importance,
The adjustment control display unit
When data is inserted into a neighboring cell positioned adjacent to the first adjustment control display point in the first cell, in a neighboring cell positioned adjacent to each of the eight points in the first cell. a checking unit for checking at least one point where data is not inserted;
an alternative point selector selecting a second adjustment control display point having the earliest priority among the at least one point; and
If the second adjustment control display point is selected, an alternate adjustment control is positioned and displayed at the second adjustment control display point in the first cell based on the interfacing data for the first adjustment control. display part
A spreadsheet document editing device capable of displaying adjustment controls that match the data notation format of input data that includes. delete A set of regular expressions preset as corresponding to each of a plurality of predetermined data representation formats - the regular expression set is a set consisting of a set of at least one regular expression designated as corresponding to each data representation format Lim - maintaining a regular expression set storage unit in which is stored;
an adjustment control storage unit in which interfacing data for preset adjustment controls corresponding to each of the plurality of data display formats is stored, wherein the interfacing data is data used to render each adjustment control and display it on a screen; maintaining;
When the first data is input from the user to the first cell, which is one of a plurality of cells constituting the spreadsheet, the character string of the first data input to the first cell is checked, and the regular expression set storage unit is referred to. After selecting a first regular expression set including a regular expression matching the pattern of the character string of the first data in the set, a first data notation format corresponding to the first regular expression set among the plurality of data notation formats checking;
extracting interfacing data for a first adjustment control corresponding to the first data representation format from the adjustment control storage unit when the first data representation format is confirmed;
displaying the first adjustment control at an adjacent point of the first cell based on the interfacing data for the first adjustment control when the interfacing data for the first adjustment control is extracted;
If a copy command for the first data is applied from the user and then a paste command for the first data is applied to a second cell among the plurality of cells, the second cell has the same second data as the first data. inserting data and displaying the first adjustment control at an adjacent point of the second cell based on the interfacing data for the first adjustment control; and
After the second data is inserted into the second cell and the first adjustment control is displayed at a point adjacent to the second cell, the user may perform the adjustment through the first adjustment control displayed at a point adjacent to the second cell. As the second data is adjusted, when the second data inserted into the second cell is changed into third data, the first data input into the first cell is changed into the third data. step
A method of operating a spreadsheet document editing device capable of displaying an adjustment control matching a data notation format of input data including. According to claim 6,
The plurality of data display formats include a date display format, a decimal point display format, and a percentage display format,
The adjustment control storage unit has
Interfacing data for a calendar control enabling date adjustment with an adjustment control corresponding to the date notation format is stored, and a decimal point adjustment control enabling adjustment of the position of a decimal point with an adjustment control corresponding to the decimal point format Interfacing data is stored, and an adjustment control matching the data representation format of the input data in which the interfacing data for the percentage adjustment control that enables the size of the number can be adjusted with the adjustment control corresponding to the percentage display format is displayed. A method of operation of a spreadsheet document editing device that can be used. According to claim 6,
Different predetermined adjustment control display points corresponding to each of the plurality of data display formats - The adjustment control display points include eight control display points corresponding to the upper left, upper, upper right, right, lower right, lower, lower left, and left sides of the cell. A step of storing and maintaining an adjustment control display point table in which information on - refers to any one point selected among points
Including more,
Displaying the first adjustment control
When the interfacing data for the first adjustment control is extracted, a first adjustment control display point corresponding to the first data display format is identified from the adjustment control display point table, and based on the interfacing data for the first adjustment control, The method of operating a spreadsheet document editing device capable of displaying an adjustment control matching a data display format of input data to be displayed by positioning the first adjustment control at a display point of the first adjustment control in the first cell. According to claim 8,
Each of the eight points is assigned a preset order of importance,
Displaying the first adjustment control
When data is inserted into a neighboring cell positioned adjacent to the first adjustment control display point in the first cell, in a neighboring cell positioned adjacent to each of the eight points in the first cell. checking at least one point where data is not inserted;
selecting a second adjustment control display point having the earliest order of importance among the at least one point; and
If the second adjustment control display point is selected, positioning and displaying the first adjustment control at the second adjustment control display point in the first cell based on the interfacing data for the first adjustment control.
A method of operating a spreadsheet document editing device capable of displaying an adjustment control matching a data notation format of input data including. delete A computer-readable recording medium recording a computer program for executing the method of any one of claims 6, 7, 8 or 9 through a combination with a computer. A computer program stored in a storage medium for executing the method of any one of claims 6, 7, 8 or 9 through a combination with a computer.

Images