KR102014216B1 - Method and apparatus for displaying and inputting data - Google Patents

Abstract

The present invention provides a method for displaying data, including: displaying a modifier bar showing a basic area of a text box for displaying and inputting data, which can be coded in the form of a computer instruction set executable in a data display and input device based on a computer system; And displaying a newly created mathematical input box to indicate a basic extended area following the basic area according to a user input. According to the present invention, the user can designate the position of the expanded formula bar.

Description

METHOD AND APPARATUS FOR DISPLAYING AND INPUTTING DATA}

The present invention relates to a data display and input method and an apparatus using the same. More particularly, the present invention relates to a data display and input application module driven by a computer, and a method for displaying data and displaying the same, and a data display and input device using the same. will be.

Various applications accept content from a graphical user interface (GUI), manipulate it, and display it. Spreadsheets correspond to applications that display data in various formats in the GUI.

Spreadsheet application is a generic term for programs that perform calculation functions on numeric tables. Spreadsheet applications have been widely used as personal or business programs, from the time they were developed to provide a wide variety of practical uses.

Previously, there was a math program for large computers, but the world's first PC spreadsheet application was VisiCalc, developed for the Apple II.

Typical spreadsheet applications simulate realistic spreadsheets by capturing, displaying, and manipulating data arranged in rows and columns. The intersecting rows and columns produce many cells in the spreadsheet. Typically each cell contains data items and / or equations.

Generally, a spreadsheet includes formula input means other than cells, which display and input formulas and various data. The cell and / or the mathematical input means are interlocked so that the selected cell, that is, the active cell and the mathematical input means contain the same data. Such a formula input means is also called a formula bar or a formula input line. The mathematical input means may comprise an input box and other GUI in which the caret can be inputted. Alternatively, the input box may be treated in the same manner as the formula input means.

In the present invention, while the input box and the formula input means are distinguished, the input box may be represented by a text box and the formula input means may be represented by a formula bar. However, since the text box and the modifier bar are not distinguished and both may be treated as the same, the present invention includes both cases.

The modifier bar has a text box that can display data through one or several lines. The number of lines displayed here is not important, and the focus of the discussion is that the text box in the modifier bar cannot display the entire data contained by the cell.

 Therefore, the user has to take the hassle of navigating the entire data while moving the caret within a text box that provides more space than the active cell. This inconvenience becomes more apparent when the user edits a cell that contains formulas or large amounts of text. Because the user cannot see the entire formula or text data in the text box, the caret must be moved or mouse scrolled within the text box to verify that the formula or text is entered correctly.

Some spreadsheet applications also provide an expandable formula bar for displaying the entire data in the active cell. However, it is unsatisfactory that there is a part hidden on the display screen due to the expansion of the formula bar. According to the related art to solve this problem, in order to prevent the cells covered by the expansion when the formula bar is expanded, the cell area is moved by the region where the formula bar is extended so that the GUI can be displayed. This has been presented.

However, the above solution is only moved from the first row to the last row on the screen where the cell area to be hidden is not a good alternative when the user's cell of interest is located in the last row. The concept of the present invention has been considered in the solution to the problems of the prior art discussed above.

1 shows an execution screen of a spreadsheet application module according to the prior art executed on a personal computer.

1, there is shown a GUI according to the execution of an application module of a spreadsheet. Specifically, it corresponds to the active cell selected by the user, a formula bar for displaying the data contained in the active cell, a text box located therein, an input cancel button associated with them, an input confirmation button, a function wizard, and a GUI for other functions. A name box appears.

In Fig. 1, the modifier bar is in an expanded state. In addition, due to the expansion of the formula bar, the entire cell area is pushed down. Therefore, the cell area of 21 or less rows of the cell area is not displayed on the screen.

Although the formula bar expanded in FIG. 1 according to the related art does not cover the cell area of 1 to 3 rows among the cell areas according to the expanded area, the cell area of 21 rows or less, which is an area where the user will be interested in the next operation. Is not displayed. This shape is no different from the shape of the upper stone minus the bottom stone.

The problem according to the prior art is not only limited to this, but the position of the active cell and the modifier bar linked thereto is too far apart, so that the user may feel fatigue as the viewing angle is widened while working at the same time.

In order to improve the problem according to the prior art, the present invention proposes a new mechanism for the expansion of the formula input means, that is, the formula bar.

The present invention has been made to solve the above problems, and an object of the present invention is to provide a data display and input method and a device using the user can specify the location of the expanded formula bar.

Another object of the present invention is to provide a data display and input method and an apparatus using the same, in which a position of an extended formula bar changes in association with a position of an active cell.

Another object of the present invention is to provide a data display and input method in which the number of lines displayed in the expanded formula bar is automatically adjusted according to the amount of data, and an apparatus using the same.

Another object of the present invention is to provide a data display and input method and an apparatus using the same, in which an extended modifier bar is moved to an area where a cell area is not invaded.

Another object of the present invention is to provide a data display and input method and an apparatus using the same, which allow internal data to be referred to with a small viewing angle through a modifier bar interlocked with an active cell located in close proximity to each other.

Data display and input method according to an embodiment of the present invention, the text for the display and input of data, which can be coded in the form of a computer instruction set executable on a data display and input device based on a computer system Displaying a formula bar on which a basic portion of a text box appears; And displaying a newly created formula input box to indicate the basically expanded portion after the basic region according to a user input.

The displaying of the formula bar on which the basic region appears may include displaying a formula bar corresponding to a user interface, and displaying a text box into which data is input in the formula bar. It is done.

The displaying of the formula input box may include setting a user environment related to the formula input box.

The displaying of the formula input box may further include generating the formula input box according to the setting of the user input environment.

The method may further include canceling the display of the formula input box according to a user input.

Here, the formula input box may be enlarged to the additionally expanded portion according to a user input.

Here, the formula input box may be enlarged to the accordingly expanded portion in a size suitable for displaying the entire data in the cell without user input.

Here, the formula input box may be arranged at a position changed according to a user input.

Here, the user input may include a keyboard input, data input in the text box, a button click by a user interface, a manipulation of a modifier bar by a user interface, and a drag and drop operation.

The method may further include displaying a scroll bar for searching the area when the area into which data is input in response to a user input is outside the area indicated by the text box and / or the formula input box. It is done.

Here, the caret position is switched between the text box area and the cell area of the spreadsheet according to the user input.

Here, the user input may include input by a combination of a function key and a keyboard direction key or a combination of two keyboard direction keys.

A data display and input device according to an embodiment of the present invention includes a display device for displaying a formula bar on which a basic portion of a text box for displaying and inputting data is displayed; An input device for performing a user interface input or data input in accordance with a user input; And a control unit for controlling a display device displaying a newly created mathematical input box to display the basically expanded portion after the basic region according to a user input.

The display device may display a formula bar corresponding to a user interface and display a text box in which data is input in the formula bar.

Here, the control unit, characterized in that it comprises a configuration module for setting a user environment (user environment) for the formula input box.

The control unit may further include a formula input box module for generating the formula input box according to the setting of the user input environment.

Here, the control unit, characterized in that for closing the formula input box in accordance with the user input.

Here, the formula input box may be enlarged to the additionally expanded portion according to a user input.

Here, the formula input box may be enlarged to the accordingly expanded portion in a size suitable for displaying the entire data in the cell without user input.

Here, the formula input box may be arranged at a position changed according to a user input.

Here, the user input may include keyboard input, data input in the text box, button click by a user interface, and manipulation of a modification bar by a user interface.

The box generating module may further include displaying a scroll bar for searching the area when the area into which data is input according to a user input is out of an area indicated by the text box and / or a formula input box. It is characterized by.

The control unit may control the input device such that the caret position is switched between the text box area and the cell area of the spreadsheet according to a user input.

Here, the user input may include input by a combination of a function key and a keyboard direction key or a combination of two keyboard direction keys.

According to the present invention, the user can specify the position of the expanded formula bar.

In addition, the position of the expanded modifier bar may change in association with the position of the active cell.

In addition, the number of lines displayed in the expanded formula bar may be automatically adjusted according to the amount of data.

In addition, the expanded modifier bar may be moved and disposed in an area where the cell area does not invade.

In addition, the user may refer to the internal data with a small viewing angle through a formula input box linked to an active cell located in an area adjacent to each other.

1 shows an execution screen of a spreadsheet application module according to the prior art executed on a personal computer.
2 is an exemplary diagram of a system environment including a data display and input device according to an exemplary embodiment.
3 is a block diagram of a data display and input device according to an embodiment of the present invention.
4 is a block diagram of the controller of FIG. 3.
5 is a block diagram of a data display and input device according to another embodiment of the present invention.
6 is a flowchart illustrating a data display and input method according to an exemplary embodiment.
7 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.
8 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.
9 is an exemplary view of a GUI screen of a data display and input device according to an embodiment of the present invention.
10 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.
11 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.
12 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.

Hereinafter, exemplary embodiments of a data display and input method and a data display and input device using the same will be described in detail with reference to the accompanying drawings. The present invention is not limited to a data display and input method and a data display and input method using the same, and are provided in the form of a viewer for viewing only, a viewing method used therefor, and a spreadsheet application that performs editing, display, and printing functions. It includes a data output method performed by a provided computer program and a data output device using the same.

 Like reference numerals in the drawings denote like elements. In addition, specific structural to functional descriptions of the embodiments of the present invention are only illustrated for the purpose of describing the embodiments according to the present invention, and unless otherwise defined, all terms used herein including technical or scientific terms These have the same meaning as commonly understood by one of ordinary skill in the art to which the present invention belongs. Terms such as those defined in the commonly used dictionaries should be construed as having meanings consistent with the meanings in the context of the related art, and are not construed in ideal or excessively formal meanings unless expressly defined herein. It is preferable not to.

Hereinafter, a data display and input device according to an exemplary embodiment will be described.

2 is an exemplary diagram of a system environment including a data display and input device according to an exemplary embodiment.

Referring to FIG. 2, the system environment includes a user terminal 100, a server 300, and a network 400 corresponding to the data display and input device 100.

The user terminal 100 is a device for displaying and inputting data, a document output device capable of creating and editing a document, for example, a spreadsheet, a document editor, a document editing device, an electric type writer or a document. A device capable of performing general purpose operations in addition to the creation and editing of a computer, includes a computer device for executing computer instructions contained in a spreadsheet application module, a terminal, and a wireless terminal.

Various embodiments of the wireless terminal include a cellular phone, a smart phone having a wireless communication function, a personal digital assistant (PDA) having a wireless communication function, a wireless modem, a portable computer having a wireless communication function, a digital camera having a wireless communication function, and the like. Portable units incorporating the same imaging device, gaming device with wireless communication capability, music storage and playback appliance with wireless communication capability, Internet appliance with wireless internet access and browsing, as well as combinations of such functions; Including but not limited to terminals.

The server 300 may include, but is not limited to, a file server, an update server, an FTP server, and a web server, and various files necessary for updating a spreadsheet application module stored in the user terminal 100, for example, a new server. Stores patches, extensions and service packs, and permits access of user terminals to provide application updates by downloading files.

The network 400 includes, but is not limited to, a local area wireless network, such as a LAN, a WAN, a wired network, WiFi, Bluetooth, and Zigbee, and various kinds of cellular wireless networks.

Data display and input device 100 according to an embodiment of the present invention corresponding to the user terminal 100 includes a computer command for configuring a data display and input method according to an embodiment of the present invention and in the form of a spreadsheet application module The corresponding data display and input application module is stored in the installed form.

The data display and input device 100 may read the media in which the data display and input application module, which is not installed, is stored, install the same, and install the media in the data display and input device 100. The media includes optical storage media such as CD-ROMs and DVD-ROMs. In addition, the data display and input application module may be provided in the form of a binary file downloaded from the server 300. The data display and input device 100 may download various files from the server 300 through the network 400 and update the application module. The data display and input device 100 will be described in detail.

3 is a block diagram of a data display and input device according to an embodiment of the present invention.

Referring to FIG. 3, the data display and input device 100 includes an input device 110, a display device 120, an output device 130, and a storage device. 140, a communication device 150, a power device 160, and a control unit 170.

The input device 110 includes, but is not limited to, a keyboard, a touch screen, a mouse, an electronic pen, and a voice input device, for example, a microphone, which inputs data required for document preparation and information for setting various parameters of a user working environment. It doesn't happen. Through substantially user input, input device 110 inputs text and objects into a document. Here, the character is a concept including a space, and the object includes various kinds of form objects such as icons, pictures, shapes, tables, and charts.

The display device 120 includes a cathode-ray tube (CRT), a liquid crystal display (LCD), a plasma display panel (PDP), and a light emitting device that perform frame output of an edit screen for document creation. Light emitting diode (LED) displays and organic light emitting diode (OLED) displays include, but are not limited to.

The output device 130 includes, but is not limited to, a printer, a plotter, a beam projector, a text to sound (TTS) device, a speaker, and an earphone.

The storage device 140 is any type that can be detached from the data display and input device 100 and / or can be detached therefrom, such as magnetic tapes, magnetic drums, floppy disks, ZIP drives, and hard disk drives (HDDs). Storage and CD-ROM drives, DVD-ROM drives, blu-ray discs using flash memory such as storage devices, SD cards, USB memory and solid state drives (SSDs) Optical storage devices such as, but not limited to, drives.

The communication device 150 includes, but is not limited to, a communication module corresponding to various communication networks of the network 400, for example, a Bluetooth module, a WiFi module, an Ethernet interface card, a USB module, a cellular wireless communication module, a modem, and a wireless router. It doesn't happen.

The power supply 160 includes, but is not limited to, a secondary battery such as a power supply for converting AC into DC, an adapter, a SMPS and a lithium ion battery, a lead acid battery, a fuel cell, and a bioethanol battery, and a primary battery. . Hereinafter, the control unit 170 will be described in detail.

4 is a block diagram of the controller of FIG. 3.

Referring to FIG. 4, the controller 170 includes a central processing unit (CPU), a memory in which an operating system and a data display and input application module are loaded. In the memory area, the controller 170 may include a configuration module 171 and a formula input box module 172 among data display and input application modules including computer instructions for executing a data display and input method according to an embodiment of the present invention. It includes. The controller 170 controls each component in the data display and input device 100 so that the data display and input method according to an embodiment of the present invention is implemented.

In detail, the control unit 170 receives the user input through the data display and input device 100 through the input device 110, and then creates a document creation process, a created document, and a user interface according to the data display and input method according to an embodiment of the present invention. A process of outputting a screen frame through the display 120 indicating a process, a process of outputting a written document through the output device 130 on paper or a voice, a process of storing the created document in the storage device 140, and a process required for creation. The control unit 170 includes a process for receiving various data or transmitting a created document to the server 300 or an external terminal through the network 400 using the communication device 150, and a power supply process through the power supply device 160. Computing processor (CPU), operating system (OS) and data display and input method according to an embodiment of the present invention The data display and input application module containing the control instructions and using the load memory.

The data display and input device 100 according to the embodiment of the present invention corresponding to the computing device 500 may be described in more detail through other embodiments.

5 is a block diagram of a data display and input device according to another embodiment of the present invention.

Referring to FIG. 5, the data display and input device 100 corresponding to the computing device 500 may include an input interface device 510, an output interface device 520, a memory 531, a storage device 532, and a power supply device. 540, processor 550, network interface device 560, wireless communication device 570, and bus 580.

The input interface device 510 inputs a character or an object required for document writing according to a user's input. The input interface device 510 includes, but is not limited to, a keyboard, a touch screen, a mouse, a stylus pen, and a pen tablet.

The output interface device 520 includes a display for displaying a document and a printer for printing out a document. In addition, the output interface device 520 includes a speaker, a headphone, and a headset for outputting a text in a document as a speech using a text to speech (TTS) engine. do.

The processor 550 may execute computer instructions included in the data display and input application module related to the data display and input method according to an embodiment of the present invention stored in the memory 531 and / or the storage device 532. The processor 550 may refer to a central processing unit (CPU), a graphics processing unit (GPU), or a dedicated processor on which the methods according to the present invention are performed. The memory 531 and the storage device 532 may be configured of a volatile storage medium and / or a nonvolatile storage medium. For example, the memory 531 may be configured as read only memory (ROM) and / or random access memory (RAM).

The wireless communication device 570 includes a device for short range wireless communication, wireless data communication, and wireless voice communication.

Each component included in the data display and input device 500 is connected by a bus 580 to communicate with each other.

Hereinafter, a data display and input method according to an embodiment of the present invention in which the data display and input device 100 described above is executed by executing a computer command included in a data display and input application module is shown in FIGS. 3 and 6 to 12. This will be described with reference to.

6 is a flowchart illustrating a data display and input method according to an exemplary embodiment.

3 and 6, a data display and input method S100 according to an embodiment of the present invention includes steps S110 to S140.

A data display and input method (S100) performed by a data display and input device according to the present invention includes a computer system including a display device 120 and at least one input device 110 having a graphical user interface. It is assumed that the data display and input apparatus 100 may be coded in the form of a computer instruction set executed in the input device 100.

First, the display device 120 displays a formula bar in which a basic portion of a text box for displaying and inputting data appears. Here, the default area refers to the number of lines displayed by the unexpanded test box 102. For example, the basic area may correspond to one line. In addition, the basic expanded portion and additionally expanded portion will be described in a part in which each term is introduced.

In detail, step S110 may include the following steps.

The display device 120 displays the equation bar 101 corresponding to the user interface (S111), and displays a text box 102 into which data is input in the equation bar 101 (S112).

7 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.

Referring to FIG. 7, the equation bar 101 and the text box 102 are displayed on the GUI screen. Here, the formula bar 101 may further include an input minimum button 103, an input confirmation button 104, a function wizard button 105, and a text box expansion button 106 in addition to the test box 102. The active cell 10 is displayed in the spreadsheet cell area, and the same data corresponding to the data contained in the active cell 10 is displayed through a line in the text box 102.

Next, the controller 170 controls the display device to display the newly generated mathematical input box 102 to display the basically expanded portion following the basic region according to the user input (S120). Here, the basic extension area means the number of lines that the expanded expression input box 102e can additionally display according to the basic extension line number option 24.

Specifically, step S120 includes the following steps.

The environment setting module 171 sets a user environment related to the equation input box (S121).

8 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.

8, a configuration dialog box 20 of a data display and input application module according to an embodiment of the present invention is displayed. In addition, the formula bar options are displayed in the formula tab, and the formula bar options include various options such as show formula bar (21), formula input box position (22), auto expand (23), and default number of expanded lines (24). ).

The modifier bar display 21 option enables / disables the display of the modifier bar 101 of FIG. The equation entry box location 22 option determines where the equation entry box 102e is generated. As a sub-menu, the options above the active cell, below the active cell, the top, stop, and bottom may be included in the formula bar position option.

9 and 10 are exemplary views of a GUI screen of a data display and input device according to an embodiment of the present invention.

7 to 9, the equation input box 102e in which the text box 102 expanded by the operation of the text box expansion button 106 is created on the cell area in the form of a new box is shown. The active cell 10 is displayed, and the formula input box 102e contains the same data as the data in the active cell 10. The equation input box 102e may further include a zoom out button 106e and a scroll bar 107.

In FIG. 9, the formula input box 102e is generated below the active cell 10 by an option below the active cell. Similarly, in FIG. 10, the formula input box 102e is generated on the active cell 10 by an option on the active cell. In addition to the two options, the equation input box 102e may be generated at the top, the stop, or the bottom of the cell area corresponding to the fixed area by the top, stop, and bottom options of FIG. 8.

The formula input box 102e may be enlarged to the accordingly expanded portion in a size suitable for displaying the entire data in the cell without user input.

That is, the automatic expansion option 23 automatically adjusts the line displayed by the formula input box 102e. The default extended line number option determines the number of lines to be displayed when the formula input box 102e refers to a cell that does not contain data. For example, when the user selects an empty cell and clicks the text box expand button 106 to generate the formula input box 102e, the default number of expanded lines of the formula input box 102e, for example, 3 The formula input box 102e of the line is displayed. When more than three lines of data are input according to a user input, if the automatic expansion option 23 is activated, the number of lines displayed by the formula input box 102e is increased to four or more lines. Alternatively, if the cell containing data in four or more lines becomes the active cell, if the auto-expand option 23 is activated, the formula input box 102e determines the number of lines occupied by the entire data contained in the cell and becomes active. Display all data in a cell.

Even though the position of the formula input box 102e is fixed by the top, stop, and bottom options, the formula input box 102e is the active cell 10 according to the correlation between the position of the active cell and the size of the formula input box 102e. ) Or above. This example is shown in FIGS. 9 and 10. For example, even if the formula input box position 22 option is fixed to any of the top, middle, and bottom, when the active cell 10 is located at the top (FIG. 9) or the bottom (FIG. 10), the formula input The location of the box 102e may be located at the bottom (FIG. 9) or the top (FIG. 10) of the active cell 10.

Next, the equation input box module 172 generates the equation input box 102e according to the setting of the user input environment (S122).

11 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.

Referring to FIG. 11, the equation input box module 172 generates the equation input box 102e and displays it on the active cell 10 according to the setting of the user input environment. In addition, when the active cell 10 moves in accordance with the movement of the caret, it is shown that the formula input box 102e is also moved and displayed (40).

In addition, when the area in which the data is input according to the user's input in the active cell 10 is outside the area indicated by the text box 102 and / or the formula input box 102e, the formula input box module 172 may change the area. The scroll bar 107 may be displayed for navigation of the device (S130).

Referring again to FIG. 9, a scroll bar 107 is created and displayed in the area of the text box 102 and the formula input box 102e.

In addition, the controller 170 closes the equation input box 102e according to the user input (S140). The user can restore the expanded text box 102 to its original state after data entry or reference. That is, the user uses the reduction button 106e to reduce the text box 102 expanded using the expansion button 106 to its original state. The collapsed state of the text box 102 is shown in FIG. 7 and the expanded state is shown in FIG. 9.

Hereinafter, additional features of the present invention will be described in accordance with an embodiment of the present invention.

The equation input box 102e may be arranged at a position changed according to a user input.

12 is an exemplary diagram of a GUI screen of a data display and input device according to an embodiment of the present invention.

12, two desktop screens are displayed. In addition, the main window of the data display and input application module according to the embodiment of the present invention including the cell area is shown on the right side, and the formula input box 102e is shown on the right side. That is, the user may move and place the equation input clap 102e on an area where the cell area is not invaded, including the active cell, by using drag and drop of the input device 110, for example, a mouse.

The user input introduced in various embodiments of the present invention may be input to the input device 110, for example, keyboard input, data input in the text box 102, clicks of the buttons 106 and 106e by the user interface, and the user interface. Size manipulation of the modifier bar 101 may be included.

By inputting data in the text box 102, the text box 102 may be expanded into the formula input box 102e. The text box 102 is expanded to the formula input box 102e by the operation of the expand button 106, or vice versa, the formula input box 102e is reduced to the text box 102 by the operation of the collapse button 106e. Can be.

The equation input box 102e may be enlarged to the additionally expanded portion according to a user input. Herein, the additional extension area means the number of additional lines displayed in the lines displayed in the basic extension area. That is, the user may select a border line of the mathematical expression input box 102e by using a drag and drop of an input device, for example, a mouse, and reduce or increase the size of the box.

Referring back to FIG. 9, the number of lines for which data is displayed by the base area, the base extension area and the additional extension area is 15. FIG.

In addition, the controller 170 controls the input device so that the caret position is switched between the text box 102 and / or the formula input box 102e area and the cell area of the spreadsheet according to a user input. do. The user input may include a combination of a function key and a keyboard direction key or a combination of two keyboard direction keys.

Referring again to FIG. 11, arrow 30 indicates that the caret position is switched. When the input device 110, for example the enter key of the keyboard, is actuated while the caret is located in the text box 102 and the formula input box 102e, the caret moves into the active cell. On the contrary, the controller 170 may control the input device according to the user's input in order to move the caret back into the text box 102 or the formula input box 102e. For example, if the left and right arrow keys on the keyboard are active at the same time, or if any of the arrow keys and the function keys, for example Ctrl or Alt, are active at the same time, the caret in the active cell is either a text box 102 or a formula input box. May be moved into 102e. This feature helps the user to enter data using only the keyboard.

The methods according to the invention can be implemented in the form of program instructions that can be executed by various computer means and recorded on a computer readable medium. Computer-readable media may include, alone or in combination with the program instructions, data files, data structures, and the like. The program instructions recorded on the computer readable medium may be those specially designed and constructed for the present invention, or may be known and available to those skilled in computer software.

Examples of computer readable media include hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, flash memory, and the like. Examples of program instructions include machine language code, such as produced by a compiler, as well as high-level language code that can be executed by a computer using an interpreter or the like. The aforementioned data display and input device 100, which is a hardware device, may be configured to operate as at least one software application module coupled with the hardware to perform a data display and input method to perform the operations of the present invention. The reverse is also true.

As such, according to an embodiment of the present disclosure, the user may designate the location of the expanded formula bar by the data display and input device 100 and the data display and input method S100 using the same.

In addition, the position of the expanded modifier bar 101 may change in association with the position of the active cell 10.

In addition, the number of lines displayed in the expanded formula bar 101 may be automatically adjusted according to the amount of data.

In addition, the expanded modifier bar 101 may be moved and disposed in an area where the cell area is not affected.

In addition, the user may refer to the internal data at a small viewing angle through the equation input box 102e interlocking with the active cell located in an area adjacent to each other.

Although the present invention has been described with reference to the embodiments illustrated in the drawings, this is merely exemplary, and various modifications and equivalent other embodiments are possible from those skilled in the art. I will understand the point. Therefore, the technical protection scope of the present invention will be determined by the claims below.

100: data display and input device 101: formula bar
102: Text box 102e: Formula input box
103: cancel input button 104: confirm input button
105: Function Wizard button 106, 106e: Text Box Expansion Button
107: scroll bar 110: input device
120: display device 130: output device
140: storage device 150: communication device
160: power supply unit 170: control unit
171: configuration module 172: formula input box module
300: server 400: network
500: data display and input device 510: input interface device
520: output interface device 531: memory
532: storage device 540: power supply
550: Processor 560: Network Interface Device
570: wireless communication device
580: bus

Claims (24)

Can be coded in the form of a computer instruction set executable on a data display and input device based on a computer system,
Displaying a formula bar on which a basic portion of a text box for displaying and inputting data appears; And
According to the user input, in order to represent the basically expanded portion (basically expanded portion) in accordance with the user input to place the newly created formula input box on the cell area in a separate box form at a position changed according to the user input And data display and input method. The method according to claim 1,
Displaying the formula bar in which the basic area appears,
Displaying a formula bar corresponding to a user interface: and
And displaying a text box in which data is input in the formula bar. The method according to claim 1,
Displaying the formula input box,
And setting a user environment for the formula input box. The method according to claim 3,
Displaying the formula input box,
According to the setting of the user environment, further comprising the step of generating the formula input box, data display and input method. The method according to claim 1,
The method,
And disabling the display of the formula input box according to a user input. The method according to claim 1,
The expression input box may be expanded to the additionally expanded portion according to a user input. The method according to claim 1,
And the formula input box can be expanded to the accordingly expanded portion to a size suitable for displaying the entire data in the cell without user input. delete The method according to any one of claims 1 and 5 to 7,
The user input is,
Keyboard input, data input in the text box, button clicks by a user interface, size manipulation of a formula bar by a user interface, and drag and drop operations. The method according to claim 1,
And displaying a scroll bar for searching the area when the area in which data is input according to a user's input is outside the area indicated by the text box and / or the formula input box. Input method. The method according to claim 1,
A caret position is switched between a text box area and a cell area of a spreadsheet according to a user input. The method according to claim 11,
The user input is,
And a combination of a function key and a keyboard direction key or a combination of two keyboard direction keys. A display device for displaying a formula bar on which a basic portion of a text box for displaying and inputting data appears;
An input device for performing a user interface input or data input in accordance with a user input; And
A display for arranging a newly created formula input box on a cell area in a separate box form at a position changed according to a user input to display a basically expanded portion following the basic area according to a user input. And a control unit for controlling the device. The method according to claim 13,
The display device,
And displaying a formula bar corresponding to a user interface, and displaying a text box into which data is input in the formula bar. The method according to claim 13,
The control unit,
And a configuration module for setting a user environment for a formula input box. The method according to claim 15,
The control unit,
And a formula input box module for generating the formula input box according to the setting of the user environment. The method according to claim 16,
The control unit,
And closing the formula input box according to a user input. The method according to claim 13,
And the formula input box can be expanded to the additionally expanded portion according to a user input. The method according to claim 13,
And the formula input box can be expanded to the accordingly expanded portion to a size suitable for displaying the entire data in the cell without user input. delete The method according to any one of claims 13 and 17 to 19,
The user input is,
And keyboard input, data input in the text box, button clicks by a user interface, and manipulation of a modifier bar by a user interface. The method according to claim 16,
The formula input box module,
And generating a scroll bar for searching the area when the area into which data is input according to a user's input is outside the area indicated by the text box and / or the formula input box. The method according to claim 13,
The control unit,
And control the input device such that the caret position is switched between the text box area and the cell area of the spreadsheet in accordance with user input. The method according to claim 23,
The user input is,
And a combination of a function key and a keyboard direction key or a combination of two keyboard direction keys.

Images