KR102507637B1 - Method for providing spreadsheet data processing service and electronic device thereof - Google Patents

Abstract

According to various embodiments of the present invention, disclosed are a method for providing spreadsheet data processing services and an electronic device thereof, wherein the method comprises the steps of: displaying a first window containing a display area for each category of a workbook, a sheet and a cell; connecting at least one workbook called through a spreadsheet program; when confirming a user input selecting a first cell through the spreadsheet program, displaying first cell information, containing a coordinate of the first cell and a value of the first cell, on a cell display area displaying information related to the cell of the first window; confirming a user input preliminarily selecting the first cell information in at least one row displayed in the cell display area; and confirming a coordinate and a value for at least one cell related to the coordinate of the first cell, and displaying a second window having the value of the first cell and the value of the at least one cell arranged by a row and a column.

Description

Method for providing spreadsheet data processing service and electronic device thereof

The present invention relates to a method for providing a spreadsheet data processing service and an electronic device thereof, and more particularly, to a method for effectively processing and managing data such as workbooks, sheets, cells, etc. called through an electronic device and the method thereof. It's about electronics.

In general, the time required for document creation in a task is a high portion of the time occupied in the entire task. Reduction of costs due to the time and manpower required to prepare these documents is an essential part in terms of corporate productivity. To this end, a system that manages and automates tasks in an integrated manner is being introduced.

A spreadsheet such as Excel is a representative software for processing data, and is widely used and can be handled more easily than other programs by users, and Excel is widely used as office software.

In particular, since Excel handles data as a table, functions are provided to handle data more intuitively, and therefore, a lot of data is often managed and processed in spreadsheets such as Excel.

Due to the convenience of Excel as described above, many techniques for converting database data into Excel or converting Excel data into database and storing them have been proposed and commercialized.

That is, the data in the database is converted into Excel, and the work is performed using Excel, which is easy to handle. Accordingly, the amount of data increases as the work is performed, and the work is performed using a plurality of sheets and a plurality of workbooks.

Although spreadsheet programs such as Excel provide various functions for the convenience of users who process vast amounts of data, they are not intuitive and interlocking functions are limited, so there is a limit to improving work efficiency.

According to various embodiments of the present disclosure, an object of the present invention is to provide a method and electronic device for effectively processing and managing cell information of spreadsheet data.

According to various embodiments of the present disclosure, it is an object of the present invention to provide a method and electronic device for recording cell processing history in spreadsheet data and effectively managing information related to previously processed cells.

The problems to be solved through various embodiments of the present invention are not limited to the mentioned problems, and other problems not mentioned will be clearly understood by those skilled in the art from the description below.

According to an embodiment of the present invention, displaying a first window including a display area for each category of workbook, sheet, and cell; connecting at least one workbook called through a spreadsheet program; When a user input for selecting the first cell is confirmed through the spreadsheet program, the first cell information including the coordinates of the first cell and the value of the first cell is converted to information related to the cell in the first window. displaying in the cell display area to be displayed; confirming a user input for pre-selecting the first cell information in at least one row displayed in the display area of the cell; and checking coordinates and values of at least one cell related to the coordinates of the first cell, and displaying a second window in which the value of the first cell and the value of the at least one cell are arranged in rows and columns. Disclosed is an operating method of an electronic device providing a spreadsheet data processing service, including a.

Here, in the workbook display area displaying information related to the workbook, each file name of the linked workbook is displayed in a row, and when a user input for selecting one row is confirmed in the workbook display area, the selected row is displayed. The workbook of is displayed on the display of the electronic device, and the sheet display area for displaying information related to the sheet includes the file name of the workbook and the sheet name of the sheet for each sheet included in the linked workbook. If a user input for selecting one row in the sheet display area is confirmed, the workbook and sheet in the selected row can be displayed on the display.

Here, the step of connecting at least one workbook called through the spreadsheet program may include a workbook in a state called through the spreadsheet program at the time of starting the spreadsheet data processing service, or at the time of refreshing. A step of connecting a workbook in a state called through the spreadsheet program may be included.

Here, the first cell information further includes a sheet name of a first sheet including the first cell, a file name of a workbook including the first sheet, and at least one information related to the coordinates of the first cell. Checking the coordinates and values of the cells of and displaying a second window in which the value of the first cell and the value of the at least one cell are arranged in rows and columns, the first cell and the first cell at least one second cell corresponding to at least one designated row located in an included column, at least one third cell corresponding to at least one designated column located in a row including the first cell, and the at least one designated row Coordinates and values of at least one fourth cell determined based on each row coordinate and the column coordinate of each of the at least one designated column may be checked.

Here, checking the coordinates and values of at least one cell related to the coordinates of the first cell, and displaying a second window in which the values of the first cell and the values of the at least one cell are arranged in rows and columns. When the speed of checking the coordinates and values of at least one cell related to the coordinates of the first cell exceeds the specified speed, at least one row and at least one column of the matrix configured to be displayed on the second window can be deleted.

Here, each row of the at least one designated row and the at least one designated column may be determined based on a print area set through the spreadsheet program.

Here, the operating method of the electronic device providing the spreadsheet data processing service includes checking a user input for modifying the value of the first cell through the spreadsheet program; and displaying a row including the first cell copied from the matrix displayed on the second window in a designated area of the second window, and displaying the value of the first cell in the designated area as the modified value. can include more.

According to various embodiments of the present invention, a storage unit in which a spreadsheet program is installed; a display displaying the spreadsheet program; and displaying a first window of the spreadsheet data processing service including a display area for each category of workbook, sheet, and cell on the display, and at least one workpiece called through the spreadsheet program. When the book is connected and a user input for selecting the first cell is confirmed through the spreadsheet program, the first cell information including the coordinates of the first cell and the value of the first cell is displayed in the first window. Displaying information related to a cell in a cell display area, confirming a user input for pre-selecting the first cell information in at least one row displayed in the display area of the cell, and at least one related to the coordinates of the first cell Checking the coordinates and values of one cell, and displaying a second window in which the value of the first cell and the value of the at least one cell are arranged in rows and columns on the display; spreadsheet data including An electronic device for processing is disclosed.

According to various embodiments of the present invention, by providing a data processing program that works with a plurality of workbooks and intuitively providing information on selected and processed cells, the user's work convenience in processing a large amount of workbook data is improved. can improve

According to various embodiments of the present disclosure, a user's work efficiency can be improved by recording and providing information and history of a plurality of connected workbooks and selected and processed cells.

1 is a diagram showing the configuration of an electronic device providing a data processing service according to an embodiment of the present invention.
2 illustrates a service window and its components for providing a spreadsheet data processing service according to an embodiment of the present invention.
3 illustrates an operation of an electronic device providing a spreadsheet data processing service according to an embodiment of the present invention.
4 illustrates a cell picking information window of a data processing program displaying information related to a selected cell of a spreadsheet in an electronic device according to an embodiment of the present invention.
5 illustrates an operation of an electronic device providing a spreadsheet data processing service according to an embodiment of the present invention.
6 illustrates an operational flow of an electronic device providing a spreadsheet data processing service according to an embodiment of the present invention.

Hereinafter, embodiments will be described in detail with reference to the accompanying drawings. However, since various changes can be made to the embodiments, the scope of rights of the patent application is not limited or limited by these embodiments. It should be understood that all changes, equivalents or substitutes to the embodiments are included within the scope of rights.

Terms used in the examples are used for descriptive purposes only and should not be construed as limiting. Singular expressions include plural expressions unless the context clearly dictates otherwise. In this specification, terms such as "include" or "have" are intended to designate that there is a feature, number, step, operation, component, part, or combination thereof described in the specification, but one or more other features It should be understood that the presence or addition of numbers, steps, operations, components, parts, or combinations thereof is not precluded.

Unless defined otherwise, all terms used herein, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which the embodiment belongs. Terms such as those defined in commonly used dictionaries should be interpreted as having a meaning consistent with the meaning in the context of the related art, and unless explicitly defined in this application, it should not be interpreted in an ideal or excessively formal meaning. don't

In addition, in the description with reference to the accompanying drawings, the same components are given the same reference numerals regardless of reference numerals, and overlapping descriptions thereof will be omitted. In describing the embodiment, if it is determined that a detailed description of a related known technology may unnecessarily obscure the subject matter of the embodiment, the detailed description will be omitted.

In addition, in describing the components of the embodiment, terms such as first, second, A, B, (a), and (b) may be used. These terms are only used to distinguish the component from other components, and the nature, sequence, or order of the corresponding component is not limited by the term. When an element is described as being “connected”, “coupled” or “connected” to another element, the element may be directly connected or connected to the other element, but there may be another element between the elements. It should be understood that may be "connected", "coupled" or "connected".

Components included in one embodiment and components having common functions will be described using the same names in other embodiments. Unless stated to the contrary, descriptions described in one embodiment may be applied to other embodiments, and detailed descriptions will be omitted to the extent of overlap.

'Data' processed in an electronic device can be expressed in terms of 'information'. Here, information may be used as a concept including data.

The present invention describes a method for providing a service related to data processing using a spreadsheet (hereinafter referred to as a data processing service) and an electronic device thereof.

Spreadsheets are Microsoft's Excel, Google's Workspace, The Document Foundation's Calc, Hangul and Computer's Hancell, Apple's Numbers It may be a program provided through (Numbers), etc.

The data processing service interoperates with the spreadsheet and transmits information related to workbooks called through the spreadsheet, worksheets (or sheets), cells, cell values (or cell data), and changes in data based on user input. can be provided effectively.

Hereinafter, preferred embodiments of the present invention will be described with reference to FIGS. 1 to 6 .

The drawings attached to this specification illustrate a preferred embodiment of the present invention, and together with the detailed description of the invention serve to further understand the technical idea of the present invention, the present invention is limited only to those described in the drawings should not be interpreted.

1 is a diagram showing the configuration of an electronic device providing a data processing service according to an embodiment of the present invention.

Referring to FIG. 1 , an electronic device 100 may include a processing unit 110 , a storage unit 120 , and a communication unit 130 . In addition, the electronic device 100 may further include at least one component of an input unit for inputting commands for control and an output unit for outputting processing procedures and results.

The operation of the electronic device 100 is performed based on data processing and control of the processing unit 110 .

The processing unit 110 processes data received through the communication unit 130 and/or an input unit (not shown) of the electronic device 100, stores at least some data in the storage unit 120, and stores the storage unit ( Data stored in the 120 may be called and processed, and may be transmitted to another device through the communication unit 130 .

The processing unit 110 may share data processing with a designated user device through a program (app, application, tool, plug-in, etc., hereinafter referred to as a data processing program) for processing spreadsheet data, and the processing unit 110 may use a data processing program. It is possible to set and/or control the operation of the electronic device 100 through.

Hereinafter, in various embodiments, processing of spreadsheet data by the electronic device 100 or providing a related service may be performed through at least one data processing program of the electronic device 100 or a service (or event) specified through a program related thereto. It can be understood as providing them.

Here, workplace monitoring is described as being provided through a data processing program installed in the electronic device 100, but is not limited thereto, and may be provided through other pre-installed programs or temporary installation programs.

According to an embodiment, spreadsheet data processing may be performed through at least a part of a database provided free of charge or paid for in an external device of the electronic device 100 .

For example, the data processing program for processing spreadsheet data may be a program such as Microsoft's Excel stored in the storage unit 120 of the electronic device 100, but a program provided online such as Google's Workspace. can be

The processing unit 110 may connect at least one workbook called through a spreadsheet through a data processing program and display data processed through the spreadsheet through the data processing program.

The processing unit 110 displays information related to a cell selected based on a user input in a workbook called through a spreadsheet through a data processing program, and based on preliminary selection and/or selection of information displayed through the data processing program Information on a designated cell around the selected cell may be displayed.

The storage unit 120 may store various data used by at least one component (eg, the processing unit 110 or the communication unit 130) of the electronic device 100. The data is, for example, spreadsheet data. It may include a program (or software) for processing, data such as a workbook file processed through a spreadsheet, various categories generated based on data, and input data or output data for commands related thereto. .

The storage unit 120 may include an artificial neural network algorithm for processing spreadsheet data, a blockchain algorithm, a deep learning algorithm, and an artificial intelligence algorithm including at least some of mechanisms, operators, language models, and big data related thereto. there is.

The storage unit 120 may include a cell selected from a workbook called through a spreadsheet, a cell value, a formula related to the cell, designated neighboring cells, and at least one algorithm for performing processing related thereto.

The storage unit 120 may include data for checking and processing specified control and operation through signals received through respective devices included in the input/output unit (not shown) of the electronic device 100 .

The operations described in the storage unit 120 are processed by the processing unit 110, and data for processing related operations, data being processed, and processed data may be stored in the storage unit 120 as a database.

Data stored in the storage unit 120 may be changed, corrected, deleted, or created through the processing unit 110 based on a manager input of the electronic device 100 or a user input of the user device.

The storage unit 120 may include volatile memory or non-volatile memory.

The communication unit 130 establishes a wired communication channel between the electronic device 100 and at least one other electronic device (eg, a manager device, a user device, or a server), establishes a wireless communication channel, and communicates through the established communication channel. can support implementation.

The communication unit 130 may include one or more communication processors that are operated independently or subordinately to the processing unit 110 and support wireless communication.

According to an embodiment, the communication unit 130 may be a wireless communication module (eg, a cellular communication module, a short-distance wireless communication module, or a global navigation satellite system (GNSS) communication module) or a wired communication module (eg, a local area network (LAN)) communication module or power line communication module).

The communication unit 130 is a local communication network and / or cellular network such as Bluetooth, Bluetooth Low Energy (BLE), WiFi, WiFi direct, infrared data association (IrDA), ZigBee, UWB, RF (Radio Frequency), the Internet, or a computer network (e.g., a telecommunications network such as a LAN or WAN) to communicate with an external electronic device.

Various types of communication modules constituting the communication unit 130 may be integrated as one component (eg, a single chip) or implemented as a plurality of separate components (eg, multiple chips).

The electronic device 100 may include an input/output unit (not shown) for inputting data and control commands and/or outputting data processing and results.

The input/output unit (not shown) may include at least a portion of an input unit (not shown) for inputting data such as a keyboard, mouse, stylus (pen), and microphone, and an output unit (not shown) for outputting data such as a display, speaker, and driving unit. can

According to various embodiments of the present invention, the electronic device 100 may include at least some of the functions of a range of information communication devices including mobile communication terminals, multimedia terminals, wired terminals, fixed terminals, and internet protocol (IP) terminals. can

The electronic device 100 is a device for processing spreadsheet data, and may include at least some functions of a workstation or a large-capacity database, or may be configured to be connected through communication.

The electronic device 100 and/or a manager device and/or a user device connected to the electronic device 100 include a mobile phone, a personal computer (PC), a portable multimedia player (PMP), and a mobile internet device (MID). , MID), a smartphone, a tablet PC, a phablet PC, a notebook, and the like can be exemplified.

Here, the server is one entity existing on the network and serves as a web server, database server, and application server. According to a preferred embodiment, the server may provide various contents to the user device based on the processing of the electronic device 100 .

2 illustrates a service window and its components for providing a spreadsheet data processing service according to an embodiment of the present invention.

The service window 200 is a user interface (UI) displayed on the display of the electronic device 100, and the service window 200 may include main functions of a data processing program.

Referring to FIG. 2, the service window 200 includes a workbook display area (210) displaying a workbook (workbook name or file name) connected to a data processing program, and a worksheet (worksheet included in the workbook). sheet display area 220 displaying information related to name or sheet name), cell display area 230 displaying information related to a cell selected based on a user input in a worksheet (hereinafter, sheet), and data processing A log display area 240 displaying information related to the operation of the program may be included.

Workbook information displayed on the workbook display area 210 may include workbook information in a state called through at least one spreadsheet connected to a data processing program. As described above, a workbook connected to a data processing program may be expressed as a workbook called through a spreadsheet connected to the data processing program.

The workbook information displayed on the workbook display area 210 may display workbook information in a state called at the start of the data processing program or workbook information in a state called at the time of refreshing.

Referring to the workbook display area 210 of FIG. 2 , the workbook in the called state calls files stored in the storage unit 120, for example, General Account 1.xlsx and 01-A04.xlsx. It may be a workbook of, or a workbook such as workbook 1 in an unsaved state.

When the processor 110 confirms a user input for selecting one of the pieces of workbook information displayed on the workbook display area 210, the processor 110 can display the selected workbook on the display. At this time, the processing unit 110 may display the last selected sheet and the last selected cell in the last operation of the selected workbook on the display in a selected state.

Here, the workbook in the called state is processed through the processing unit 110 and may be defined as a workbook in a state residing in RAM. The invoked state can be described in terms of activated (or activated) state, executed state, processing state, and the like.

The sheet information displayed on the sheet display area 220 may include sheet names included in the workbooks for each workbook connected to the data processing program. Here, the sheet information may include a sheet name and a workbook name of a workbook including the sheet.

When a user input for selecting one of the sheet information displayed in the sheet display area 220 is confirmed, the processing unit 110 may display the selected workbook and sheet on the display. At this time, the processing unit 110 may display the selected cell on the display in a selected state in the last operation of the selected sheet.

The cell information displayed on the cell display area 230 may include information on a cell selected based on a user input among workbooks connected to a data processing program.

For example, the cell information may include an address (or coordinates) determined based on the row and column coordinates of the selected cell, a formula set in the selected cell, a memo set in the selected cell, and a format of the selected cell.

In addition, the cell information may further include a sheet name of a sheet including the selected cell and a workbook name of a workbook. In addition, the cell information may indicate a text format and cell format such as text color and/or cell color included in the selected cell.

When the next selected cell is a cell of another sheet or another workbook, the processing unit 110 compares the previously selected cell and displays the cell information displayed in the cell display area 231 by dividing it with a dotted line or the like.

The cell display area 230 may include an icon area 231 displaying characteristics of cell information as an icon at a designated location of each cell information. The icon area 231 may display a designated icon based on the type of the selected cell. For example, the processing unit 110 may display an icon designated for a specific cell, such as a merged cell or a cell including a formula.

When the processor 110 determines that the pointer (not shown) is positioned (preliminarily selected) on an icon of specific cell information based on user input, the processor 110 pops up a selected cell of the corresponding cell information and information related to the selected cell. up) window (eg, the pop-up window 321 of FIG. 3).

When a user input for selecting one of cell information displayed in the cell display area 230 is confirmed, the processing unit 110 may display the selected workbook and sheet on the display. At this time, the processing unit 110 may display the coordinates of the selected cell information on the display in a selected state.

In addition, the service window 200 provides function menus and settings such as going back, going forward, refreshing, deleting workbook information, arranging windows, opening workbooks, saving data processing information, saving workbooks, and printing in a designated area. A menu display area 209 including items can be displayed.

According to various embodiments of the present invention, the data processing program and/or at least some functions are described as being included in the service window 200 and provided, but are not limited thereto, and are provided as spreadsheet functions, and/or It may be included as part of the menu and provided. In addition, the data processing program may be provided in the form of a spreadsheet plug-in.

3 illustrates an operation of an electronic device providing a spreadsheet data processing service according to an embodiment of the present invention.

3 shows a service window 200 of a data processing program displayed on the display of the electronic device 100 and an Excel program 300 processing a workbook connected to the data processing program.

When the processing unit 110 calls (eg, starts) the data processing program 200 according to a user input, at least one spreadsheet and spreadsheet residing in the RAM of the electronic device 100 at the start of the data processing program You can check the called workbook through the sheet.

The processing unit 110 connects the checked spreadsheet with a data processing program, and displays information about the checked workbook, for example, workbook information, sheet information, and information related to the connection of the spreadsheet and workbook to a service window ( 200) can be displayed in the workbook display area 210, the sheet display area 220, and the log display area 240, respectively.

The processing unit 110 may display cell information of a cell selected based on a user input in the workbook displayed through the spreadsheet on the cell display area 230 .

Thereafter, the processing unit 110 may confirm a user input for preliminary selection of any one cell information among cell information displayed on the cell display area 230 . According to an embodiment, the processing unit 100 may determine to pre-select corresponding cell information when confirming a user input for locating a pointer to one of the icons displayed in the icon display area 231. .

When the processing unit 110 confirms a user input for pre-selecting an icon 331 for one cell information among cell information displayed in the cell display area 230 in the service window 200 of FIG. 3, the processor 110 related to the cell Information can be identified and extracted (or picked).

For example, the processing unit 110 may check the coordinates ($G$13) of the selected cell from the cell information specified in the icon 311 and check cell information related to the selected cell. According to an embodiment, the cell picking information may be determined based on a specific column and row designated for each row and column of the selected cell identified in the preselected cell information.

For example, referring to the cell picking information window 321 of FIGS. 3 and 4 , the setting information may be configured to determine related cells based on columns A to E and rows 1 to 4. According to the setting information, the processing unit 110 checks the selected cell ($G$13) identified in the preselected cell information (eg, the cell information specified in the icon 311), and for rows 1 to 4 in column G. Values of 30 cells that are combined based on the values of cells (hereafter referred to as cells) corresponding to coordinates, cell values for columns A to E in row 13, and rows 1 to 4 and columns A to E can confirm.

That is, the processing unit 110 “$A$1, $A$2, $A$3, $A$4, $A$13, $B$1, $B$2, $B$3, $B$4, $B$13, $C $1, $C$2, $C$3, $C$4, $C$13, $D$1, $D$2, $D$3, $D$4, $D$13, $E$1, $E$2, $E$3, $E$4, $E$13, $G$1, $G$2, $G$3, $G$4, $G$13” You can check the cell values for 30 coordinates.

When the processing unit 110 checks the value of the designated cells, it can display a related phrase, for example, “Cell picking information has been read” (313) in the log display area 240 . In addition, the processing unit 110 may display a phrase, for example, “Excel response speed (590 ms)” 315 in the log display area 240 in relation to the time taken to verify the cell.

According to the foregoing description, the processing unit 110 identifies cells based on rows 1 to 4 and columns A to E and includes them in cell picking information to display them, but is not limited thereto, and setting information Cells (eg, rows and/or columns) included in cell picking information may be changed according to the setting of .

In addition, when the processor 110 confirms a user input for selecting one cell information from among the cell information displayed on the cell display area 230, the selected workbook and the spreadsheet in a state in which the cell is selected are displayed in the electronic device 100. can be shown on the display.

For example, as shown in FIG. 3 , the processing unit 110 confirms the user input of double-clicking the specific cell information 317 among the cell information displayed in the cell display area 230, the cell information 317 confirms that the selected cell is the “$G$13” cell of the “01-A04” workbook “Camera Inventory Ledger February” sheet, and the “01-A04” workbook with the “$G$13” cell (331) selected The spreadsheet 300 outputting the “Camera Inventory Management Ledger February” 330 sheet of the book may be displayed on the display of the electronic device 100 .

4 illustrates a cell picking information window of a data processing program displaying information related to a selected cell of a spreadsheet in an electronic device according to an embodiment of the present invention.

The cell picking information window 321 displays cell picking information generated based on the preliminary selection of the icon 311 in the embodiment of FIG. 3 . As described above, the processing unit 110 may display the designated cell and cell value 401 on the pre-selected icon 311 and display related cells and matrix information including the cell values in a pop-up window.

In displaying the cell picking information window 321, the processing unit 110 may display it in a designated area around the pre-selected icon 311, and when the pre-selection is released, for example, a pointer located on the icon 311 When confirming the user's input to move out of the icon 311, the display of the cell picking information window 321 can be canceled.

According to various embodiments, the processing unit 110 may modify (or change) rows and/or columns displayed through the cell picking information window. Taking the Excel program as an example, the processing unit 110 may determine rows and columns to be displayed in the cell picking information window based on the setting of the printing area.

According to an embodiment, the processor 110 preselects the icon 311 of cell information in which the cell “$G$13” is selected in a state where the print areas of “$B$2” and “$B$3” are set. When input is checked, the cell information of “$B$2”, “$B$3”, “$B$13”, “$G$2”, “$G$3”, and “$G$13” is checked, and the cell value is A cell picking information window can be displayed by arranging them in a matrix.

According to various embodiments of the present disclosure, when a print area is changed in a state in which cell picking information is generated by preliminary selection of the icon 311, the processing unit 110 confirms a user input for preliminary selection of the icon 311, the cell picking information can be recreated.

When generating cell picking information, the processing unit 110 may check the cell picking information by prioritizing the set printing area over the setting information.

According to various embodiments, the processing unit 110 may check the speed at which information related to designated cells is extracted in an operation of checking cell picking information. At this time, the processing unit 110 determines that the speed at which information related to cells is extracted exceeds the speed specified in the setting information (eg, 1000 ms), and/or the speed at which information related to cells is extracted is the speed specified in the setting information. If it is checked whether the number exceeding the specified number of times satisfies the specified number of times, processing may be performed to change the number of cells for constructing cell picking information.

For example, as shown in FIG. 4 , the processing unit 110 selects 30 cells (or “$G$13” cells) based on rows 1 to 4, columns A to E, and the selected “$G$13” cell. 29 cells except for) can be set to extract specified information including cell values.

And, if it is confirmed that the speed of extracting cell picking information exceeds 1000 ms, it may be set to exclude information extraction for two rows and two columns.

When the processing unit 110 confirms that the speed of extracting the cell picking information exceeds 1000 ms, 12 cells excluding rows 3, 4, columns D, and columns E among rows 1 to 4 and columns A to E are selected. (or 11 cells excluding the “$G$13” cell) may be extracted and cell picking information 321 based on values of the 12 cells may be displayed.

A criterion for changing the number of cells included in the cell picking information may be divided into a plurality of steps. For example, the standard extraction speed may be classified in stages such as 1000 ms, 1500 ms, and 2000 ms, and if each extraction rate is exceeded, the number of cells included in the cell picking information is also set in stages, or excluded. It is possible to set the rows and/or columns to be divided in stages.

The processing unit 110 may provide a user with a comfortable cell processing environment by controlling the amount of cell picking information to be extracted according to the cell picking information extraction rate.

5 illustrates an operation of an electronic device providing a spreadsheet data processing service according to an embodiment of the present invention.

The processing unit 110 may fix the display of the cell picking information window based on a user input for selecting an icon of cell information displayed in the cell display area. For example, the processing unit 110 may display the cell picking information window 521 on the display when a user input of clicking the icon 311 is confirmed.

According to an embodiment, the display of the cell picking information window 521 displayed based on the click of the icon 311 can be maintained even if the pointer moves out of the icon 311 without canceling the display of the cell picking information window 521. .

When confirming that cell data is changed while the cell picking information window 521 is displayed, the processing unit 110 displays the changed cell information through the corresponding cell and/or the cell picking information window generated based on the cell information. can

For example, referring to FIGS. 3 and 5 , the processing unit 110 displays a cell picking information window 521 for cell “$G$13” of the “01-A04” workbook “Camera Inventory Management Ledger February” sheet. In the displayed state, user input to modify the cell value to “820,000” can be confirmed.

The processing unit 110 moves the row 543 in which the cell value of “$G$13” is corrected in the row where the cell “$G$13” before modification is displayed in the cell picking information window 521 is located at the designated location in the cell picking information window 521. can be displayed on

6 illustrates an operational flow of an electronic device providing a spreadsheet data processing service according to an embodiment of the present invention.

In step 601, the processing unit 110 displays a first window including a display area for each category of workbook, sheet, and cell. For example, as described above, the first window area may be composed of a service window 200 for displaying a data processing program.

The service window 200 may include a workbook display area, a sheet display area, and a cell display area for displaying information related to a spreadsheet connected to a data processing program and/or a workbook called through the spreadsheet.

When displaying information related to a workbook in the workbook display area, the processing unit 110 displays each workbook name (or file name) of the connected workbook as a row, and displays one row (eg: Workbook information), the selected workbook may be displayed on the display of the electronic device 100 .

When displaying sheet-related information in the sheet display area, the processing unit 110 may display each sheet included in the linked workbook in a row including the file name of the workbook and the sheet name of the sheet.

When a user input for selecting one row (eg, sheet information) in the sheet display area is confirmed, the processing unit 110 may display the workbook and sheet on the display based on the selected sheet information.

In step 603, the processing unit 110 connects at least one workbook called through the spreadsheet program. For example, the processing unit 110 may start a data processing program, a user input selecting refresh of a data processing program, or a user input selecting a spreadsheet and/or workbook connection (or connection confirmation) based on At least one workbook loaded in the RAM of the electronic device 100 (or being processed in the RAM) may be checked.

Based on the confirmed workbook, the processing unit 110 may display the workbook name (or file name) of the workbook and the sheet names of sheets included in each workbook on the workbook display area and the sheet display area.

In step 605, if the user input for selecting the first cell is confirmed through the spreadsheet program, the processing unit 110 converts first cell information including the coordinates of the first cell and the value of the first cell to the cell of the first window. It is displayed in the cell display area displaying information related to .

The processing unit 110 displays first cell information including the coordinates of the first cell and the value of the first cell in the cell display area according to a user input for selecting the first cell of a specific sheet in the workbook connected to the data processing program. can be displayed

In displaying cell information in the cell display area, the processor 110 not only includes cell coordinates and cell values, but also the sheet name of the sheet including the cell, and the workbook of the workbook including the cell and sheet. It may further include at least one of a name, a formula set in a cell, a memo set in a cell, and a cell format.

In step 607, the processing unit 110 confirms a user input for preliminary selection of first cell information in at least one row displayed in the cell display area.

The processing unit 110 may confirm a user input for pre-selecting an icon designated for one row (eg, cell information of a first cell) among cell information displayed in the cell display area. Here, the preliminary selection may be positioning a pointer displayed on the display of an icon based on a user input.

In step 609, the processor 110 checks the coordinates and values of at least one cell related to the coordinates of the first cell, and arranges the values of the first cell and the at least one cell in rows and columns in a second window. display

The processing unit 110 may check and extract information about the designated cell related to the coordinates of the selected first cell, for example, coordinates and cell values.

In determining a cell related to the coordinates of the selected first cell, the processing unit 110 determines the selected first cell, at least one second cell corresponding to at least one designated row located in a column including the first cell, the first cell, and the first cell. At least one third cell corresponding to at least one designated column located in a row including 1 cell, and a row coordinate of each of the at least one designated row and a column coordinate of each of the at least one designated column. Coordinates and values of one fourth cell may be confirmed and extracted.

For example, as described with reference to FIG. 3 , the processing unit 110 performs a selected first cell (eg $G$13) and a designated row (eg, rows 1 to 4) and a designated column (eg A Columns to E columns) may be identified, and information (eg, cell value) of the identified cells may be extracted.

When the speed of checking the coordinates and values of at least one cell related to the coordinates of the selected first cell exceeds the designated speed, the processing unit 110 displays at least one row and at least one row of matrices configured to be displayed on the second window. column can be deleted.

For example, as described with reference to FIG. 3, to extract information of a total of 30 cells (or 29 cells excluding the selected first cell) related to rows 1 to 4 and columns to E of the selected first cell. In the set state, if it is confirmed that the extraction rate of cells exceeds the specified extraction rate (eg, 1000 ms), at least one row among rows and columns (eg, rows 1 to 4 and columns to E) designated to be extracted is confirmed. Information on cells configured (or combined) based on the remaining rows and columns except for the row and/or column may be extracted.

When the processing unit 110 confirms that the number of times the cell extraction rate exceeds the designated extraction rate satisfies the number set in the setting information during the cell extraction process, the processing unit 110 changes the number of cells to be extracted for the corresponding extraction, or It can be processed to be applied to the selected cell.

In addition, the processing unit 110 may restore rows and columns designated to be extracted based on setting information when it is confirmed that the cell extraction speed is less than a designated extraction speed (eg, 500 ms) during the cell extraction process.

In addition, if it is confirmed that the printing area for at least one cell is set based on the user input, the processing unit 110 may determine a cell to be extracted based on the row and column of the cell set as the printing area.

The processing unit 110 may arrange a second window in which cell values extracted from the checked cells are arranged in rows and columns. Here, the second window area may be composed of a cell picking information window as described with reference to FIGS. 3 and 4 .

The processing unit 110 may display the cell picking information window output on the display as a pop-up window based on the preliminary selection.

The processing unit 110 may end the operation of FIG. 6 by performing step 609 .

According to various embodiments of the present disclosure, the processing unit 110 checks a user input for modifying the value of the first cell through a spreadsheet program, and outputs a row including the first cell copied from the matrix displayed on the second window. 2 Can be displayed in the designated area of the window.

For example, the processing unit 110 selects (eg, clicks) the icon of the first cell in a state where a second window (eg, a cell picking information window) displaying cells designated for the first cell is displayed on the display. A user input for changing the value of the first cell may be confirmed.

The processing unit 110 may copy the row including the first cell from the cell picking information window and copy it to the designated area of the cell picking information window, and display the value of the first cell as a modified value in the row displayed in the designated area. there is.

According to various embodiments of the present invention, by providing a data processing program that works with a plurality of workbooks and intuitively providing information on selected and processed cells, the user's work convenience in processing a large amount of workbook data is improved. can improve

According to various embodiments of the present disclosure, a user's work efficiency can be improved by recording and providing information and history of a plurality of connected workbooks and selected and processed cells.

According to the detailed description of the present invention, the functions of various embodiments described as being performed by the processing unit 110 are operations processed through the processing unit 110 of the electronic device 100 and are organically related to the components of the electronic device 100. can be performed in connection with

As described above, although the embodiments have been described with reference to the limited drawings, those skilled in the art can apply various technical modifications and variations based on the above.

For example, the described techniques may be performed in an order different from the method described, and/or components of the described system, structure, device, circuit, etc. may be combined or combined in a different form than the method described, or other components may be used. Or even if it is replaced or substituted by equivalents, appropriate results can be achieved.

Therefore, it should be said that other implementations, other embodiments, and equivalents of the claims are within the scope of the following claims.

100: electronic device
110: processing unit
120: storage unit
130: communication department
200: service window
210: workbook display area
220: sheet display area
230: cell display area
240: log display area

Claims (8)

In the operating method of an electronic device providing a spreadsheet data processing service,
(a) displaying a first window including a workbook display area, a sheet display area, and a cell display area for each category of workbook, sheet, and cell;
(b) connecting at least one workbook called through a spreadsheet program;
(c) displaying cell information including the coordinates of the selected cell and the value of the selected cell in the cell display area of the first window when a user input for selecting a cell is confirmed through the spreadsheet program;
(d) confirming a user input for pre-selecting first cell information for a first cell in a plurality of rows displaying cell information for pre-selected cells in the cell display area; and
(e) for the preselected first cell, extracting coordinates and values of cells related to the preselected cell, and converting the value of the preselected cell and the values of the related cells to the coordinates of the preselected cell and the related cell Displaying a second window arranged in rows and columns based on the coordinates of the pop-up; includes,
When the electronic device confirms a user input for changing a value of the first cell through the spreadsheet program while maintaining the display of the second window based on a user input for selecting the first cell information,
The electronic device copies the row including the first cell from the rows and columns displayed on the second window and displays the copied row in the designated area of the second window, and sets the value of the first cell displayed in the designated area to the displayed as a changed value,
The electronic device, when the first cell information and the cell information displayed in the previous row of the first cell information in the plurality of rows displayed in the cell display area are cells of different sheets or different workbooks, the first cell information A method of operating an electronic device that provides a spreadsheet data processing service, distinguishing between and displaying cell information displayed in the previous row. According to claim 1,
The workbook display area displaying information related to the workbook displays each file name of the linked workbook in a row, and when a user input for selecting one row is confirmed in the workbook display area, the workbook of the selected row is displayed. displaying a book on the display of the electronic device, and
The sheet display area displaying information related to the sheet is displayed as a row including the file name of the workbook and the sheet name of the sheet for each sheet included in the linked workbook, and one row is displayed in the sheet display area. A method of operating an electronic device that provides a spreadsheet data processing service, characterized in that displaying the workbook and sheet of the selected row on the display when a user input for selecting is confirmed. According to claim 1,
In step (b),
Connecting the workbook in a state called through the spreadsheet program at the time of starting the spreadsheet data processing service, or the workbook in a state called through the spreadsheet program at the time of refreshing, An operating method of an electronic device providing a sheet data processing service. According to claim 1,
The electronic device,
Row coordinates of each of at least one second cell located in a column including the preselected cell, at least one third cell located in a row including the preselected cell, and the at least one second cell and the at least one Cells determined based on the column coordinates of each third cell are cells related to the preselected cell, and coordinates and values for the related cells are determined;
The electronic device checks the speed at which the coordinates and values for the related cells are extracted, and the checked speed is displayed in the log display area of the first window as the time required to extract the coordinates and values for the related cells. do,
When the electronic device confirms that the speed at which the coordinates and values for the related cells are extracted is greater than the first designated speed, the row and column for the coordinates and values for the related cells configured to be displayed on the second window. set to extract except for at least one row and at least one column of
The electronic device sets to extract the at least one row and at least one column without excluding the at least one row and the at least one column when confirming that the speed of extracting the coordinates and values for the related cells is smaller than the second designated speed after the setting, An operating method of an electronic device providing spreadsheet data processing service. delete According to claim 4,
The at least one third cell located in the column including the pre-selected cell and the at least one fourth cell located in the row including the pre-selected cell are determined based on a print area set through the spreadsheet program. Characterized in that, a method of operating an electronic device providing a spreadsheet data processing service. delete In an electronic device providing a spreadsheet data processing service,
a storage unit in which a spreadsheet program is installed;
a display displaying the spreadsheet program; and
A first window of the spreadsheet data processing service including a workbook display area, a sheet display area, and a cell display area for each category of workbook, sheet, and cell is displayed on the display, and the spreadsheet data processing service is displayed on the display. At least one workbook called through a sheet program is connected, and when a user input for selecting a cell is confirmed through the spreadsheet program, cell information including the coordinates of the selected cell and the value of the selected cell is displayed. It is displayed in the cell display area of the first window, and a user input for preliminary selection of first cell information for a first cell is checked in a plurality of rows displaying cell information for pre-selected cells in the cell display area. With respect to the selected first cell, coordinates and values of cells related to the preselected cell are extracted, and the value of the preselected cell and the values of the related cells are based on the coordinates of the preselected cell and the coordinates of the related cells. a processing unit that processes to display second windows arranged in rows and columns on the display as a pop-up;
When the processing unit confirms a user input for changing a value of the first cell through the spreadsheet program in a state in which the display of the second window is maintained based on a user input for selecting the first cell information,
The processing unit copies the row including the first cell from the row and column displayed on the second window and displays it in a designated area of the second window, and sets the value of the first cell displayed in the designated area to the changed displayed as a value,
The processing unit may, in the case where the first cell information and the cell information displayed in a previous row of the first cell information in the plurality of rows displayed in the cell display area are cells of different sheets or different workbooks, the first cell information and the cell information An electronic device that processes spreadsheet data by distinguishing and displaying cell information displayed in the previous row.

Images