WO2013187590A1

WO2013187590A1 - Method for providing gui for searching for data in data sheet and electronic device to which same is applied

Info

Publication number: WO2013187590A1
Application number: PCT/KR2013/002865
Authority: WO
Inventors: 허원진
Original assignee: 에스케이씨앤씨 주식회사
Priority date: 2012-06-13
Filing date: 2013-04-05
Publication date: 2013-12-19
Also published as: KR101361256B1; KR20130139583A

Abstract

A method for providing a GUI for searching for data in a data sheet and an electronic device to which the same is applied are provided. The method for providing a GUI for searching for data, according to one embodiment of the present invention, enables a GUI for searching for data in a selected column to be automatically displayed, when one of the columns constituting a data sheet in the form of rows and columns is selected. Accordingly, the GUI for searching for data in a selected column can be automatically provided through only one operation, that is, selection of a column in a data sheet, and thus a column in a data sheet can be searched for by a relatively simple procedure.

Description

Method of providing Wi-Fi for data retrieval in data sheet

The present invention relates to a method for providing a graphical user interface (GUI), and more particularly to a method for providing a GUI used to search for desired data in a data sheet.

In using a data sheet that can efficiently manage large amounts of data, it is not uncommon to search for desired data. In this case, the search is often limited to a specific column rather than the entire data sheet.

To do this, first select a column to search for data, and then enter a command to call the search box. Given the high frequency of data retrieval in data sheet operations, this multi-step search window call is very inconvenient for the user.

In addition, the called search box may cover a part of the data sheet, which may interfere with the user's understanding of the data.

SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and an object of the present invention is to enable a column search of a data sheet by a simpler procedure. A method of providing a data retrieval GUI for automatically displaying a retrieval GUI for retrieval, and an electronic device to which the retrieval GUI is applied are provided.

According to an embodiment of the present invention for achieving the above object, a method for providing a GUI for data retrieval comprises the steps of: displaying a data sheet in a row x column format; Selecting one of the columns constituting the data sheet; And automatically displaying a search GUI for searching for data in the selected column if there is a column selection in the selecting step.

In addition, the display step may be performed even if there is no additional operation for a data retrieval command from the user after the selection step.

In addition, the selecting step may be selected in such a manner that one of the headers of the columns constituting the data sheet is selected.

The display step may display a search GUI between the 'rows in which headers are listed' and the 'first row of the data area constituting the data sheet'.

In the display step, the selected header and the search GUI can be displayed in the same color.

When the inside of the search GUI is selected by the user, the search GUI may not disappear even after the pointer is moved out of the search GUI.

In addition, when the inside of the search GUI is selected by the user, a specific mark appears in the inside of the search GUI, and when a specific mark is selected by the user, the search GUI may disappear after the pointer is moved out of the search GUI. have.

The method for providing a data retrieval GUI according to an embodiment of the present invention may further include automatically sorting data of the selected column according to a subsequent operation after the column selection operation.

Further, the sorting step may automatically sort the data of the selected column in ascending or descending order according to the direction of the subsequent operation.

On the other hand, according to another embodiment of the present invention, a method for providing a data retrieval GUI comprises: displaying a data sheet in a row x column format; Selecting one of the rows constituting the data sheet; And automatically displaying a search GUI for data retrieval within the selected row if there is a row selection in the selection step.

On the other hand, the electronic device according to another embodiment of the present invention, a display that displays a data sheet of a row × column format; And a controller for automatically displaying, on a display, a GUI for searching for data search within the selected column if one of the columns constituting the data sheet is selected.

On the other hand, according to another embodiment of the present invention, the electronic device includes a display on which a data sheet in a row x column format is displayed; And a controller for automatically displaying, on the display, a GUI for searching for data search within the selected row when there is a selection of one of the rows constituting the data sheet.

As described above, according to the present invention, a single operation of selecting a column in the data sheet allows the user to automatically be provided with a GUI for searching for data in the selected column, thereby making it easier to search the column of the data sheet. Is made possible by

In addition, the column search window does not obstruct the contents of the data sheet, so that the user's data grasp is not disturbed. In addition, the pin function can be set for the column search window by a simple operation, thereby further increasing user convenience.

1 is a diagram illustrating a data sheet;

2 is a diagram illustrating a situation in which a specific header of a data sheet is selected with a mouse pointer;

3 is a diagram illustrating a state in which a column search window is automatically displayed between a header area and a data area;

4 is a view for explaining the change of the column search window by the pointer movement;

5 is a diagram provided in the description of the pin function setting method for the column search window;

6 to 8 are views illustrating a heat search result using a heat search window;

9 is a flowchart provided to explain a search GUI providing method according to an embodiment of the present invention;

FIG. 10 is a block diagram of an electronic device capable of performing the search GUI providing method shown in FIG. 9, and

FIG. 11 is a block diagram of another electronic device capable of performing the search GUI providing method shown in FIG. 9.

Hereinafter, with reference to the drawings will be described the present invention in more detail.

1 to 8 are diagrams provided to explain a method for providing a graphical user interface (GUI) for searching according to a preferred embodiment of the present invention. In the method for providing a search GUI according to the present embodiment, a GUI for searching for a column in a row x column data sheet is provided.

The column search refers to a search that limits the data search range to a specific column rather than the entire data sheet. In FIG. 1, a data sheet including human data is illustrated. In the case of searching for "exaggeration" in the data sheet, the search range is limited to the "class" column.

Meanwhile, as shown in FIG. 1, the data sheet may be divided into a header area and a data area. To visually distinguish both, the header area is displayed in a different color than the data area.

The header area is the first row of the data sheet, in which the headers for each column are listed. The header refers to a name / item that defines / displays the type / content of data contained in the column containing the header. The data area is the remaining rows of the data sheet except for the header area, and is an area in which actual data is stored.

In order to perform a column search, the user simply needs to position the mouse pointer in the header of the column to be searched, and no further operation for the data search command is necessary later.

That is, when the mouse pointer P is positioned in the "class" header by the user as shown in FIG. 2, the column search window CSW is automatically opened between the header area and the data area as shown in FIG. appear.

The column search window CSW shown in FIG. 3 is a GUI for inputting a search word for data search in a column whose header is "class". It can be seen from FIG. 3 that the column search window (CSW) and the "class" header are displayed in the same color to inform the user that the search range of the illustrated column search window (CSW) is within the "class" column.

When the pointer P moves to the "telephone number" header as shown in FIG. 4 from the state shown in FIG. 3, the column search window CSW and the "telephone number" header are displayed in the same color. The column search window (CSW) shown in FIG. 4 is identical in appearance to the column search window (CSW) shown in FIG. 3, but is substantially different in that it is a "telephone number" column search window rather than "class".

If the pointer P moves out of the "class" header or the column search window (CSW) in the state shown in FIG. 3, the column search window (CSW) is removed to switch to the state shown in FIG.

However, when the pointer P is clicked after being moved into the column search window (CSW) as shown in FIG. 5 from the state shown in FIG. 3, the pin function is set for the column search window (CSW). do.

The pin function is a function in which the column search window CSW does not disappear even when the pointer P is moved out of the selected header and the column search window CSW.

Note that by the pin function, the search column range by the column search window CSW is also fixed. That is, when the pin function is set for the column search window (CSW) as shown in FIG. 5, even if the pointer P moves to another header, the column search window (CSW) belongs to the header to which the pointer P is moved. Do not convert to a window for retrieving data from the column.

For example, in the state where the pin function is set, even if the pointer P moves to the "phone number" header, as shown in FIG. 4, the column search window CSW is a window for data search in the "phone number" column. It is not converted to, but is kept as a window for retrieving data from the "class" column.

When the pin function is set, the pin mark M is displayed on the upper left side of the column search window CSW as shown in FIG. 5 to inform the user that the pin function is set. On the other hand, the pin mark M is also used to input a release command for pin function setting.

That is, when the user selects the pin mark M using the pointer P, the column search window CSW disappears when the pointer P is moved out of the selected header and the column search window CSW. If the pointer P moves to another header after the pin mark M is clicked, a column search window for searching for data in the column to which the moved header belongs is displayed.

For example, when the pin function is released and the pointer P moves to the "phone number" header, the column search window CSW is used to search for data in the "phone number" column as shown in FIG. Will be converted to a window.

6 shows a result of searching for "Exaggeration" in the "Title" column using the column search window CSW. As shown in FIG. 6, as a result of the search, it may be confirmed that data including “exaggeration” among data included in the “rank” column is displayed in a different color from other data.

In addition, the data contained in the foremost row among the retrieved data is displayed darker than other retrieved data, and on the right side of the column search window (CSW), "1 /" which is an indication for guiding the number of retrieved data and the order of the data displayed in bold is displayed. 3 "is shown.

In addition, as shown in FIG. 6, when a large number of data are searched for, a "▲" icon and a "▼" icon appear in the upper left corner of the column search window CSW. The "▲" icon is a command for displaying the data one order earlier than the currently displayed data in bold, and the "▼" icon is a command for displaying the data one order later than the data currently displayed in bold.

Therefore, when the "▼" icon is clicked with the pointer P as shown in Fig. 7, the second turn of the searched data is displayed in bold and the turn guide display is changed to "2/3".

In this state, when the "▲" icon is clicked with the pointer P as shown in FIG. 8, the data of the first order is displayed in dark color, and the order guide display is changed back to "1/3".

9 is a flowchart provided to explain a search GUI providing method according to a preferred embodiment of the present invention. As shown in FIG. 9, a data sheet is first displayed on a screen (S110). The execution result of step S110 is illustrated in FIG. 1.

Subsequently, when the pointer P is located in the header area in the data sheet displayed in step S110 (S120-Y), a column search window (CSW) for retrieving data from the column including the header in which the pointer P is located is displayed. (130). The result of the step S120 is illustrated in FIG. 2, and the result of the step S130 is illustrated in FIGS. 3 and 4.

Subsequently, when a search word is input through the column search window (CSW) (S140-Y), data in which the search word is displayed in the search column of the data sheet is displayed in dark (S150). The results of performing steps S140 and S150 are illustrated through FIGS. 6 to 8.

On the other hand, if the pointer P is moved out of the selected header and the column search window (CSW) (S160-Y), it is determined whether the pin function is set (S170).

If it is determined in step S170 that the pin function is set (S170-Y), the process returns to step S130 and the column search window (CSW) does not disappear from the screen. On the other hand, if it is determined in step S170 that the pin function is not set or is set and released (S170-N), the column search window (CSW) is removed from the screen (S180).

FIG. 10 is a block diagram of an electronic device capable of performing the search GUI providing method shown in FIG. 9. As shown in FIG. 10, the electronic device 200 capable of performing the above-described search GUI providing method includes a communication unit 210, a display 220, a control unit 230, an operation unit 240, and a storage unit ( 250).

The communication unit 210 is a means for communicating with an external device and an external communication network in a wired / wireless manner, and the display 220 is a means for displaying the above-described data sheet, a column search window CSW, a pointer P, and the like.

The operation unit 240 is a means for receiving a user command, such as a keyboard and a mouse, and the storage unit 250 is a means for storing programs and data necessary for the electronic device 200.

The controller 230 controls the operation of the electronic device 200 according to a user command input through the manipulation unit 240. In particular, the controller 230 performs the algorithm illustrated in FIG. 9.

FIG. 11 is a block diagram of another electronic device capable of performing the search GUI providing method shown in FIG. 9. The electronic device 300 illustrated in FIG. 11 includes a communication unit 310, a touch screen 320, a control unit 330, and a storage unit 340.

The communication unit 310 is a means for communicating with external devices and an external communication network in a wired / wireless manner, and the storage unit 350 is a means for storing programs and data necessary for the electronic device 300.

The touch screen 320 functions as a display means for displaying the aforementioned data sheet and column search window CSW, and as a user interface means for receiving a user command through touch.

As illustrated in FIG. 11, when the user input means of the electronic device 300 is the touch screen 320, the header selection listed in the header area of the data sheet is made by the user's touch operation, not the pointer P. The internal selection of the column search window (CSW) for pin function setting is also made by a user's touch manipulation.

On the other hand, according to the flickering operation following the header touch, it is possible to implement so that the data of the column including the touched header is automatically aligned. For example, if a user touches a specific header upwards and then flickers upwards, the data in the column containing the touched headers is sorted in ascending order. It is possible to implement so that the data of the contained columns are sorted in descending order.

The controller 330 controls the operation of the electronic device 300 according to a user command input through the touch screen 320. In particular, the controller 330 performs the algorithm illustrated in FIG. 9.

So far, a preferred embodiment is described in detail with respect to a method for automatically providing a column search window for column search in a data sheet only by selecting the headers listed in the header area of the data sheet, and to electronic devices capable of performing the method. It was.

In the above embodiment, it is assumed that column selection to search for data is performed through header selection. However, this is merely an example for convenience of description, and the column selection may be performed in a different manner. For example, it is possible to operate by inputting or selecting column numbers / symbols or by assigning the upper row of the header area to a row for column selection.

In addition, in the above embodiment, the column search window (CSW) is assumed to be displayed between the header area that is 'rows listed with headers' and the 'first row of the data area constituting the data sheet', which is also merely exemplary. Do. It is possible to implement so that the column search window (CSW) appears in another location. For example, the column search window (CSW) may be displayed above the header area.

In addition, the column search presented in the above embodiment may be applied to the row search. However, for row retrieval it is necessary to include the headers of the rows in the first column of the data sheet (i.e. to provide a header area for the rows).

On the other hand, it is possible to automatically provide a GUI other than a search window when selecting a header. GUIs that can replace the search window include sort windows, replace data windows, calculation windows, and edit windows.

On the other hand, the technical idea of the present invention can be applied to a computer-readable recording medium containing a computer program for performing the functions of the apparatus and method according to the present embodiment. In addition, the technical idea according to various embodiments of the present disclosure may be implemented in the form of computer readable codes recorded on a computer readable recording medium. The computer-readable recording medium can be any data storage device that can be read by a computer and can store data. For example, the computer-readable recording medium may be a ROM, a RAM, a CD-ROM, a magnetic tape, a floppy disk, an optical disk, a hard disk drive, or the like. In addition, the computer-readable code or program stored in the computer-readable recording medium may be transmitted through a network connected between the computers.

In addition, although the preferred embodiment of the present invention has been shown and described above, the present invention is not limited to the specific embodiments described above, but the technical field to which the invention belongs without departing from the spirit of the invention claimed in the claims. Of course, various modifications can be made by those skilled in the art, and these modifications should not be individually understood from the technical spirit or the prospect of the present invention.

Claims

Displaying a data sheet in a row x column format;

Selecting one of the columns constituting the data sheet; And

And automatically displaying a graphical user interface (GUI) for searching for data in the selected column if there is a column selection in the selecting step.
The method of claim 1,

The display step is

A method for providing a data retrieval GUI, which is performed even if there is no additional operation for a data retrieval command from a user after the selection step.
The method of claim 1,

The selection step is

A method for providing a GUI for data retrieval, characterized in that a column is selected in such a manner that one of the headers of the columns constituting the data sheet is selected.
The method of claim 3,

The display step is

A method for providing a GUI for data retrieval, characterized by displaying a retrieval GUI between a 'row of listed headers' and a 'first row of a data area constituting a data sheet'.
The method of claim 4, wherein

The display step is

A method for providing a data retrieval GUI, comprising displaying the selected header and the retrieval GUI in the same color.
The method of claim 1,

Once inside the search GUI is selected by the user,

Thereafter, even if the pointer leaves the search GUI outside, the search GUI does not disappear.
The method of claim 6,

When the inside of the search GUI is selected by the user, a specific mark appears inside the search GUI,

If a specific mark is selected by the user, the search GUI disappears after the pointer is moved out of the search GUI.
The method of claim 1,

And automatically sorting data of the selected column according to a subsequent operation after the column selection operation.
The method of claim 8,

The sorting step is

A method for providing a GUI for data retrieval, characterized by automatically sorting data of a selected column in ascending or descending order according to the direction of subsequent operation.
Displaying a data sheet in a row x column format;

Selecting one of the rows constituting the data sheet; And

And automatically displaying a graphical user interface (GUI) for retrieving data within the selected row, if there is a row selection in the selection step.
A display on which data sheets in a row x column format are displayed; And

And a control unit for automatically displaying a graphical user interface (GUI) for searching for data within the selected column on the display when one of the columns constituting the data sheet is selected.
A display on which data sheets in a row x column format are displayed; And

And a controller for automatically displaying a graphical user interface (GUI) for searching for data within the selected row on the display when one of the rows constituting the data sheet is selected.