WO2017204368A1

WO2017204368A1 - Web-based spreadsheet service providing device and method

Info

Publication number: WO2017204368A1
Application number: PCT/KR2016/005419
Authority: WO
Inventors: 이연희
Original assignee: 주식회사 한글과컴퓨터
Priority date: 2016-05-23
Filing date: 2016-05-23
Publication date: 2017-11-30
Also published as: KR101797573B1

Abstract

Disclosed are a web-based spreadsheet service providing device and method. The present invention is intended to provide a web-based spreadsheet service providing device and method capable of providing support to enable a plurality of cells configuring a spreadsheet to be accurately rendered and displayed on a screen through a browser of a client terminal, and capable of supporting a function calculation, even when the function calculation is included in the spreadsheet.

Description

Apparatus and method for providing web-based spreadsheet service

The present invention relates to a web-based spreadsheet service providing apparatus and method for supporting viewing, creating, and editing of a spreadsheet to a client terminal based on the web.

Recently, as electronic terminal devices such as computers, smart phones, tablet PCs, and the like are widely used, various kinds of electronic document-related programs have been released, which allow users to view, create, and edit electronic documents using such electronic terminal devices.

These electronic document related programs include word processors that support the creation and editing of basic documents, data entry, arithmetic operations, spreadsheets to assist with data management, and presentation programs to assist presenters.

Conventionally, in order for a user to view, create, and edit an electronic document using an electronic terminal device, the user may install the aforementioned electronic document related programs directly on the electronic terminal device, and then operate the electronic document related programs to view or create the electronic document. I had to edit.

However, in recent years, as a high-speed Internet environment has been established, and a wireless Internet environment has been established to allow access to the Internet anytime, anywhere, by providing an electronic document related service to an electronic terminal device as a client terminal through a remote server, There is a web-based electronic document service that allows a user to view, create, and edit an electronic document anytime and anywhere even without installing a predetermined electronic document related program in the electronic terminal device.

The web-based electronic document service supports various client terminals accessing an electronic document service providing server and viewing and using a markup language-based electronic document through a browser to create and edit the electronic document. In addition, various client terminals are mainly used in corporations or organizations in that they support simultaneous collaboration on the electronic document in real time.

The web-based electronic document service can view, create, and edit electronic documents through a browser mounted on the client terminal as long as it can access the Internet without installing a predetermined electronic document writing program on the client terminal. Because it supports to ensure the mobility of users, individual users are also gradually increasing.

Among these web-based electronic document services, there is a spreadsheet service that enables a user to create a spreadsheet-related document on a web basis.

However, since a spreadsheet is composed of a plurality of cells with row and column addresses, and unlike general electronic documents in that they support function operations, the electronic document creation service associated with these spreadsheets is not available. Based on the technical method for supporting the user of the client terminal needs to be discussed.

The present invention supports a plurality of cells constituting a spreadsheet to be correctly rendered and displayed on a screen through a browser of a client terminal, and even if the spreadsheet includes a function operation, a web capable of supporting such a function operation is provided. An apparatus and method for providing a spreadsheet service are provided.

The web-based spreadsheet service providing apparatus according to an embodiment of the present invention is information on at least one cell in which data is inserted among a plurality of cells constituting the spreadsheet-the information on the at least one cell is the at least Includes data inserted into one cell and a column address assigned to each of the at least one cell, grouped in the same row unit based on the row address assigned to each of the at least one cell. The list includes information on each row address in which the information on the at least one cell is grouped. If the open command for the spreadsheet is received from the cell database and the client terminal, the list is stored from the cell database. Extracting data about the list to the client terminal A spreadsheet data transmission unit for transmitting data for a lock, wherein the client terminal receives a data of the list, and receives a row address for the at least one cell grouped on the list through a browser of the client terminal. And extracts the column address assigned to each of the at least one cell and the data inserted in each of the at least one cell from the information on the at least one cell included in the list. A plurality of cells constituting the spreadsheet are rendered and displayed on the screen based on the row address, the extracted column address, and the extracted data.

In addition, the web-based spreadsheet service providing method according to an embodiment of the present invention information on at least one cell in which data is inserted among a plurality of cells constituting the spreadsheet-the information on the at least one cell List the data inserted into the at least one cell and the column address assigned to each of the at least one cell, grouped in the same row unit based on the row address assigned to each of the at least one cell. The list includes information about each row address in which information about the at least one cell is grouped. Maintaining a cell database stored therein and receiving an open command for the spreadsheet from a client terminal. Extract the data for the list from the cell database And transmitting data for the list to a terminal, wherein the client terminal receives data for the list for the at least one cell grouped on the list through a browser of the client terminal. Identifying a row address, extracting a column address assigned to each of the at least one cell and data inserted in each of the at least one cell from information on the at least one cell included in the list; Based on the identified row address, the extracted column address, and the extracted data, a plurality of cells constituting the spreadsheet are rendered and displayed on the screen.

The present invention supports a plurality of cells constituting a spreadsheet to be correctly rendered and displayed on a screen through a browser of a client terminal, and even if the spreadsheet includes a function operation, a web capable of supporting such a function operation is provided. An apparatus and method for providing a spreadsheet service based on the same may be provided.

1 is a diagram showing the structure of a web-based spreadsheet service providing apparatus according to an embodiment of the present invention.

2 to 6 are views for explaining the operation of the web-based spreadsheet service providing apparatus according to an embodiment of the present invention.

7 is a flowchart illustrating a web-based spreadsheet service providing method according to an embodiment of the present invention.

As the invention allows for various changes and numerous embodiments, particular embodiments will be illustrated in the drawings and described in detail in the written description. However, this is not intended to limit the present invention to specific embodiments, it should be understood to include all modifications, equivalents, and substitutes included in the spirit and scope of the present invention. In describing the drawings, similar reference numerals are used for similar elements.

When a component is referred to as being "connected" or "connected" to another component, it may be directly connected to or connected to that other component, but it may be understood that other components may be present in between. Should be. On the other hand, when a component is said to be "directly connected" or "directly connected" to another component, it should be understood that there is no other component in between.

The terminology used herein is for the purpose of describing particular example embodiments only and is not intended to be limiting of the present invention. Singular expressions include plural expressions unless the context clearly indicates otherwise. In this application, the terms "comprise" or "have" are intended to indicate that there is a feature, number, step, operation, component, part, or combination thereof described in the specification, and one or more other features. It is to be understood that the present invention does not exclude the possibility of the presence or the addition of numbers, steps, operations, components, components, or a combination thereof.

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. 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 shall not be construed in ideal or excessively formal meanings unless expressly defined in this application. Do not.

Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

Referring to FIG. 1, the web-based spreadsheet service providing apparatus 110 according to an embodiment of the present invention includes a cell database 111 and a spreadsheet data transmitter 112.

The cell database 111 lists information about at least one cell in which data is inserted among the plurality of cells constituting the spreadsheet in the same row unit based on the row address assigned to each of the at least one cell. Save as.

In this case, the information on the at least one cell includes data inserted into the at least one cell and a column address assigned to each of the at least one cell, and the list includes information on the at least one cell. Contains information about each grouped row address.

In this regard, the cell database 111 may store a list as shown in FIG. 2.

For example, in the case where data is inserted into a plurality of cells constituting the spreadsheet as shown in FIG. 3, a cell into which data is inserted is inserted into the cell database 111 as shown in FIG. 2. A list of grouping information about cells including column addresses and data as information may be stored in the same row unit.

3, data "a" is inserted in "1 row, column A" of the plurality of cells constituting the spreadsheet, and data "1" in "1 row, column B". Is inserted, data "2" is inserted in "row 1, column C", and data "3" is inserted in "row 1, column D", and is stored in the cell database 111. In the list, as shown in FIG. 2, information about a cell called "data: a, column: A" 221 for a row address called "row: 1" 210, and "data: 1, column: Information about a cell called B "222, information about a cell called" data: 2, column: C "223, and information about a cell called" data: 3, column: D "224 It may be grouped into the same group.

In this case, the list may include information about the row addresses of each group such as "row: 1", "row: 2", "row: 3", and "row: 4", which are the row addresses shown in FIG. Can be.

The spreadsheet data transmitting unit 112 accesses the web-based spreadsheet service providing apparatus 110 through the Internet using the client terminal 130 and then authorizes an open command for the spreadsheet. When the open command for the spreadsheet is received from the terminal 130, the data about the list is extracted from the cell database 111 and the data about the list is transmitted to the client terminal 130.

In this case, when the data regarding the list is received from the web-based spreadsheet service providing apparatus 110, the client terminal 130 may access the at least one cell grouped on the list through a browser of the client terminal 130. Check a row address of the row address and extract a column address assigned to each of the at least one cell and data inserted into each of the at least one cell from information on the at least one cell included in the list, and A plurality of cells constituting the spreadsheet may be rendered and displayed on the screen based on the identified row address, the extracted column address, and the extracted data.

In relation to this, when the client terminal 130 receives data on the list as shown in FIG. 2 from the web-based spreadsheet service providing apparatus 110, the spread in the form shown in FIG. In order to render and display a plurality of cells constituting the sheet on the screen, a script for rendering a spreadsheet on a browser may be installed. For example, a browser of the client terminal 130 may be installed with JavaScript configured with instructions for rendering the spreadsheet.

In this case, when the client terminal 130 receives data on the list as shown in FIG. 2 from the web-based spreadsheet service providing apparatus 110, the client terminal 130 may download the spreadsheet of the form shown in FIG. 3 through a browser. A plurality of constituting cells can be rendered and displayed on a screen. More specifically, each command of a script installed in a browser is executed to check a row address of the at least one cell grouped on the list. And extracting a column address allocated to each of the at least one cell and data inserted into each of the at least one cell from information about the at least one cell included in the list, and then checking the identified row address. And the spread as shown in FIG. 3 based on the extracted column address and the extracted data. A plurality of cells constituting the chart may be rendered and displayed on the screen.

In this case, the client terminal 130 executes each command of the script installed in the browser to mark a plurality of cells constituting the spreadsheet with a markup language such as HTML (Hypertext Markup Language) or XML (eXtensible Markup Language). Markup Language) can be rendered and displayed on the screen.

That is, according to the present invention, the web-based spreadsheet service providing apparatus 110 includes at least one of a plurality of cells constituting the spreadsheet inserted therein as shown in FIG. 2 on the cell database 111. When the information about the cell is grouped and stored in a list based on the row address assigned to each of the at least one cell, and the open command for the spreadsheet is received from the client terminal 130, The data of the list is extracted from the cell database 111 and transmitted to the client terminal 130 and the client terminal 130 is included on the list through the browser based on the data for the list. A column address assigned to each of the at least one cell from information on a cell of the at least one cell, respectively Extract the inserted data, and then the client terminal 130 constructs the spreadsheet as shown in FIG. 3 based on the identified row address, the extracted column address, and the extracted data. By rendering a plurality of cells to be displayed on the screen, it is possible to support the user to view the spreadsheet through the client terminal 130 on the web.

According to an embodiment of the present invention, the web-based spreadsheet service providing apparatus 110 may further include an edit information receiver 113 and an updater 114.

The editing information receiving unit 113 corrects data inserted into the at least one cell among a plurality of cells constituting the spreadsheet displayed by the user on the client terminal 130, thereby allowing the user to modify the data. When the modification to the data inserted in the at least one cell occurs, the client terminal 130, the modification edit information including the row address and column address of the cell where the data modification occurred, and the changed data in the cell where the data modification occurred Receive

The updater 114 updates the information on the at least one cell included in the list stored in the cell database 111 based on the received correction edit information.

For example, as shown by reference numeral 410 of FIG. 4, in a situation where a plurality of cells constituting the spreadsheet is displayed on the client terminal 130 through the browser, a user keyboard or the like is connected to the client terminal 130. When the data " 2 " 411 inserted into " 1 row, column C " through the input device of " 4 " 421 is modified as shown at 420, the client terminal 130 returns data. Create a correction edit information including "row 1" of the row address of "1 row, column C", which is the cell where the correction occurred, "column C" of the column address, and "4" which is changed data in the cell where the data modification occurred. It may be transmitted to the web-based spreadsheet service providing apparatus 110.

In this case, the edit information receiver 113 may receive the correction edit information from the client terminal 130, and the update unit 114 is stored in the cell database 111 based on the received correction edit information. The information on the at least one cell included in the list may be updated.

That is, the update unit 114 is "data: 2, column: C" 223 which is information of a cell corresponding to column C in "row: 1" 210 grouped in one row on the list shown in FIG. By changing to "data: 4, column: C", it is possible to update the information on the at least one cell included in the list.

In this case, according to an embodiment of the present invention, the web-based spreadsheet service providing apparatus 110 may further include a function information database 115.

In the function information database 115, when a function is inserted in a first cell of the at least one cell, at least one first input cell referred to as information about the function and an input value in the function (wherein the at least One first input cell is a cell included in the at least one cell, and information about a row address and a column address are stored in correspondence with each other.

For example, as illustrated in 410 of FIG. 4, while data is input to a plurality of cells constituting the spreadsheet, data inserted into a cell corresponding to “4 rows and C columns” is a simple number. Data inserted in "1 row, column C", "row 2, column C," "row 3, column C", as in "SUM (C1, C2, C3)" rather than "14" (412). In the case where the function is designated to calculate the sum of the sums, the function information database 115 includes information about "SUM (C1, C2, C3)" which is a function inserted in the "four rows and the C columns" corresponding to the first cell. And information about addresses of at least one first input cell, "1 row, C column", "2 row, C column", "3 row, C column", which are referred to as input values in the function, are stored in correspondence with each other. There may be.

At this time, the data inserted into the cell corresponding to "4 rows, C columns" in 410 of Figure 4 is inserted into "1 row, C columns", "2 rows, C columns", "3 rows, C columns" The result is "14" (412) as it is the sum of the data.

In this case, the updater 114 may include an edit determiner 116, a function operation performer 117, and a data changer 118.

When the edited edit information is received from the client terminal 130, the edit determiner 116 refers to information on the row address and column address of the at least one first input cell stored in the function information database 115. It is determined whether modification of data according to the received correction edit information has occurred in the at least one first input cell.

If it is determined that the modification of the data according to the received correction edit information has occurred in the at least one first input cell, the function operation performing unit 117 may determine information about the function stored in the function information database 115. A first output value is generated by performing a function operation based on the change data of the at least one first input cell according to the received correction edit information.

The data changer 118 changes the data inserted in the first cell on the list into the first output value based on the first output value.

For example, as shown by reference numeral 410 of FIG. 4, in a situation where a plurality of cells constituting the spreadsheet is displayed on the client terminal 130 through the browser, a user keyboard or the like is connected to the client terminal 130. The data " 2 "411 inserted into " 1 row, column C " through the input device of " 1 " When the edit data is received by the web-based spreadsheet service providing apparatus 110 for changing the data of the cell corresponding to the "row, column C" from "2" 411 to "4" 421, the editing judgment is made. The unit 116 is provided with the addresses of the at least one first input cell stored in the function information database 115 in the " 1 row, C column ", " 2 row, C column " The correction of the data according to the received correction edit information with reference to the information on the at least Of the first input cell, "first rows, columns C", "the second row, column C", it can be determined whether or not generated in the "three-row, column C".

In addition, the function operation performing unit 117 may modify the data according to the received correction edit information such that the at least one first input cell is “1 row, C column”, “2 rows, C columns”, “3 rows, Column C "in the" Column 1, Column C ", and refers to the information on the function" SUM (C1, C2, C3) "stored in the function information database 115, The first output value "16" may be generated by performing a function operation based on the change data of the at least one first input cell.

Then, the data changing unit 118 has " SUM (C1, C2, C3) " inserted in the list as shown in Fig. 2 based on the first output value " 16 " "Data: 14, column: C" 225 which is information about the first cell corresponding to "row 4, column C" may be changed to "data: 16, column: C".

At this time, according to an embodiment of the present invention, the spreadsheet data transmitter 112 may further include an update data transmitter 119.

When the data inserted in the first cell is changed to the first output value, the update data transmitter 119 may transmit information about the row address and the column address of the first cell and the first output value to the client terminal. At the same time, the data update command for the first cell is transmitted to the client terminal 130.

In this case, when the client terminal 130 receives the information on the row address and the column address of the first cell, the first output value and the data update command for the first cell, the client terminal 130 receives a data update command for the first cell. According to the information on the row address and column address of the first cell, the data inserted in the first cell of the plurality of cells constituting the spreadsheet displayed on the screen through the browser Can be changed to the first output value.

In relation to this, the operation of the update data transmitter 119 will be described in more detail by using the example described above. In this case, the information “data: 14, column: C” 225 for the first cell is “data: 16”. , column: C ", the update data transmitter 119 transmits the information about the row address and the column address of the first cell to" four rows and columns C "and the first output value" 16 "to the client terminal. The data update command for the first cell may be transmitted to the client terminal 130 at the same time.

In this case, when the client terminal 130 receives the information on the row address and the column address of the first cell, the first output value and the data update command for the first cell, the client terminal 130 receives a data update command for the first cell. The spreadsheet is displayed on the screen through the browser on the diagram 410 of FIG. 4 with reference to "row 4, column C", which is information on the row address and column address of the first cell. Of the plurality of cells constituting the data, " 14 " 412, which is data inserted into the first cell, can be changed to the first output value " 16 " 422, as shown at 420 in FIG. .

As a result, the web-based spreadsheet service providing apparatus 110 according to the present invention includes a function information database that stores information about a function inserted into a specific cell of a spreadsheet and a cell address referenced by the function as an input value. By holding 115, when the editing edit occurs in which data of a predetermined cell is changed in the client terminal 130, the data change of the corresponding cell is reflected in a list stored in the cell database 111, and When the cell whose data has been changed is a cell referred to as an input value by a function stored in the function information database 115, a function operation is performed based on the changed data to generate an output value of the cell into which the function is inserted. Afterwards, the output value may be transmitted to the client terminal 130. In this case, the client terminal 130 may be connected to the client terminal 130. It can change the data of the cell in which the function is inserted on the screen that is being displayed through the distributors in the output value.

Through this, the present invention can normally provide a complicated function calculation function that was difficult to implement through a script installed in the browser of the client terminal 130 itself in the web-based spreadsheet service.

According to an embodiment of the present invention, the editing information receiving unit 113 of the plurality of cells constituting the spreadsheet displayed on the client terminal 130 through the browser, among the remaining cells except for the at least one cell When data insertion occurs in at least one additional cell, additional editing information including the row address and column address of the at least one additional cell and data inserted into the at least one additional cell is obtained from the client terminal 130. Can be received.

In this case, the updater 114 may include information on the at least one additional cell based on the additional edit information (wherein the information on the at least one additional cell is inserted into the at least one additional cell and the data). A column address assigned to each of the at least one additional cell) may be added to the list by grouping the same row unit based on the row address assigned to each of the at least one additional cell.

For example, as shown in FIG. 3, in a situation where a plurality of cells constituting the spreadsheet are displayed on the client terminal 130 through the browser, a user may input an input device such as a keyboard connected to the client terminal 130. As shown by reference numeral 510 of FIG. 5, when an additional cell corresponding to “row 2, column E” is generated and data “b” 511 is input, the client terminal 130 is the additional cell. Provides web-based spreadsheet services by generating additional edit information that includes "row 2", row address of "row 2, column E", column "e", and "b" added data to the cell. Transmit to device 110.

In this case, the edit information receiver 113 may receive the additional edit information from the client terminal 130, and the update unit 114 may display “data: b as shown in FIG. 6 based on the additional edit information. , column: E " 611 can be added to the list by grouping information on an additional cell, " row 2, " which is a row address assigned to the additional cell.

That is, as shown in FIG. 6, the updater 114 displays the data of the cell corresponding to the column E for "row: 2" grouped in two rows on the list as "data: b, column: E" 611. ) Can be added.

In this case, according to an embodiment of the present invention, when the data inserted into the first additional cell of the at least one additional cell is a function, the additional edit information includes information on the function inserted in the first additional cell; At least one second input cell referred to as an input value in the function inserted into the first additional cell, wherein the at least one second input cell is a cell included in the at least one cell and the at least one additional cell ) May contain information about row and column addresses.

In this case, the updater 114 confirms that the information on the function inserted into the first additional cell and the row address and column address of the at least one second input cell are included in the additional edit information. If the information on the function inserted into the first additional cell and the row address and column address of the at least one second input cell are corresponded to each other in the function information database 115 with reference to the additional edit information, It may further include a function information update unit 120 to store.

The function operation performing unit 117 may refer to the at least one second input by referring to the information about the function inserted into the first additional cell and the information about the row address and the column address of the at least one second input cell. By performing a function operation based on the data inserted in the cell, a second output value may be generated, and the data changer 118 may be configured to display the first additional cell on the list based on the second output value. Data to be inserted into may be included as the second output value.

In this case, according to an embodiment of the present invention, when the generation of the second output value is completed, the update data transmitter 119 completes information on the row address and column address of the first additional cell and the second output value. And a data update command for the first additional cell may be transmitted to the client terminal 130 at the same time.

In this case, when the client terminal 130 receives the information about the row address and the column address of the first additional cell, the second output value, and the data update command for the first additional cell, the client terminal 130 may receive information about the first additional cell. According to a data update command, the first additional cell of the plurality of cells constituting the spreadsheet displayed on the screen through the browser by referring to the information on the row address and the column address of the first additional cell. The second output value may be inserted.

Hereinafter, operations of the updater 114 and the update data transmitter 119 will be described in more detail with reference to FIG. 5.

As shown in FIG. 3, in a situation where a plurality of cells constituting the spreadsheet are displayed on the client terminal 130 through the browser, the user may access the client terminal through an input device such as a keyboard connected to the client terminal 130. As shown at 510 in FIG. 5, "Additional Cell 1" corresponding to "Line 2, Column E" is generated, and data called "b" 511 is input, and at the same time, "Line 1, Column E" Insert into "Additional Cell 2" corresponding to "Column 1, Row B, Column 1, Column C, Column 1, Column D" called "= SUM (B1, C1, D1)" (512) When inputting a function to calculate the sum of the data, the client terminal 130 adds the row address "row 2" of the "additional cell 1", the column address "column E" and the data added to the corresponding cell. For "b", the row address "row 1" of the "additional cell 2", the column address "column E", and the information inserted into the corresponding cell "= SUM (B1, C1, D1)" And the function Contains the row addresses and column addresses of the "1 row B column", "1 row C column", "1 row D column" which are input cells that "= SUM (B1, C1, D1)" refers to as input values The additional edit information may be generated and transmitted to the web-based spreadsheet service providing apparatus 110.

In this case, the edit information receiver 113 may receive the additional edit information from the client terminal 130, and the update unit 114 may display “data: b as shown in FIG. 6 based on the additional edit information. column: E: 611 can be added to the list by grouping information about the " additional cell 1 " into " 2 rows " which is a row address assigned to the " additional cell 1 " data 6, colunm: E " 612 " can be added to the list by grouping information on the " additional cell 2 " to " row 1 " which is a row address assigned to the " additional cell 2 ". . In this case, since the data value in the "additional cell 2" needs to be calculated based on a function inserted in the "additional cell 2", the data for "additional cell 2" is calculated and included in the list. To this end, the update unit 114 may further perform a process for calculating the data "6".

In relation to this, the function information updating unit 120 provides information on "= SUM (B1, C1, D1)" which is a function inserted into the "additional cell 2" on the additional editing information and "= SUM (" B1, C1, D1) "contains the information about the row address and column address of the input cells" row 1 column B "," row 1 column C "," row 1 column, D "that are referred to as input values. Information about a function inserted into the "additional cell 2" into the function information database 115 with reference to the additional edit information, and " 1 row B column ", " 1 row B column C, " Information about the row address and column address of the cell corresponding to "may be stored in correspondence with each other.

In addition, the function operation execution unit 117 is a cell corresponding to the information on the function inserted in the "additional cell 2" and "1 row B column", "1 row, C column", "1 row, D column". Performs a function operation based on the data inserted in the cell corresponding to "1 row B column", "1 row B column, C row", "1 row row D" by referring to the row address and column address of the By doing this, an output value of "6" can be generated.

In this case, the data changing unit 118 includes data to be inserted into the "additional cell 2" on the list as "6" based on the output value of "6", thereby finally displaying as shown in FIG. Information about "additional cell 2" called "data: 6, column: E" 612 may be added to the list by grouping the information in "row 1" which is a row address assigned to the "additional cell 2". .

At this time, when the operation of the data "6" to be inserted into the "additional cell 2" is completed, the update data transmission unit 119 is called "6" and information about the row address and the column address of the "additional cell 2". A data update command for the "additional cell 2" may be transmitted to the client terminal 130 at the same time as the output value is transmitted to the client terminal 130.

At this time, the client terminal 130 receives the information on the row address and column address of the "additional cell 2" and the data update command for the output value "6" and the "additional cell 2", the "additional cell" According to the data update command for "2", the information on the row address and the column address of the "additional cell 2" is displayed on the screen through the browser as shown by reference numeral 520 of FIG. An output value of “6” 521 may be inserted into “additional cell 2” among a plurality of cells constituting the spreadsheet.

As a result, the web-based spreadsheet service providing apparatus 110 according to the present invention adds data from the client terminal 130 when the user of the client terminal 130 adds data by creating a new cell on the spreadsheet. Receives the additional edit information associated with it and reflects it on the list stored in the cell database 111, and when the data added by the user is a predetermined function, a function operation is performed to reflect the calculated result value on the list. At the same time, by transmitting the result value to the client terminal 130, the client terminal 130 can support to display the output value corresponding to the function added by the user.

In operation S710, information on at least one cell in which data is inserted among the plurality of cells constituting the spreadsheet (wherein the information on the at least one cell includes data inserted in the at least one cell and the A list (including the column address assigned to each of the at least one cell) in the same row unit based on the row address assigned to each of the at least one cell, wherein the list is assigned to the at least one cell. Maintain a cell database that contains information about each row address grouped together).

In operation S720, when an open command for the spreadsheet is received from a client terminal, data about the list is extracted from the cell database, and data about the list is transmitted to the client terminal.

In this case, when the data about the list is received, the client terminal confirms a row address of the at least one cell grouped on the list through a browser of the client terminal, and the at least one included in the list. Extracts the column address assigned to each of the at least one cell and the data inserted into each of the at least one cell from information about one cell, and then the identified row address, the extracted column address, and the extracted data. Based on the plurality of cells constituting the spreadsheet is rendered and displayed on the screen.

In this case, according to an embodiment of the present invention, the web-based spreadsheet service providing method is inserted into the at least one cell of the plurality of cells constituting the spreadsheet displayed on the client terminal through the browser Receiving modification data including the row address and column address of the cell in which the data modification has occurred and the changed data in the cell in which the data modification has occurred, when the modification to the existing data occurs, and the received correction. The method may further include updating information on the at least one cell included in the list stored in the cell database based on the edit information.

In this case, according to an embodiment of the present invention, in the web-based spreadsheet service providing method, when a function is inserted into a first cell of the at least one cell, information about the function and an input value from the function may be used. A function information database in which information about a row address and a column address of at least one first input cell referred to here, wherein the at least one first input cell is a cell included in the at least one cell, is stored in correspondence with each other It may further comprise the step of maintaining.

In this case, in the updating step, when the modified edit information is received from the client terminal, the received edited information is referred to by referring to the information about the row address and the column address of the at least one first input cell stored in the function information database. Determining whether modification of data according to correction editing information occurred in the at least one first input cell, determining that modification of data according to the received correction editing information occurs in the at least one first input cell And a first output value by performing a function operation based on the change data of the at least one first input cell according to the received modified edit information by referring to the information on the function stored in the function information database. Generating an on the list based on the first output value; And changing the data inserted into the first cell to the first output value.

In this case, according to an embodiment of the present invention, in the web-based spreadsheet service providing method, when the data inserted into the first cell is changed to the first output value, the row address and the column address of the first cell. The method may further include transmitting a data update command for the first cell to the client terminal while transmitting information about the first output value and the first output value to the client terminal.

In this case, when the client terminal receives the information about the row address and the column address of the first cell, the first output value and the data update command for the first cell, the client terminal according to the data update command for the first cell. The data inserted into the first cell among a plurality of cells constituting the spreadsheet displayed on the screen through the browser by referring to the information about the row address and the column address of the first cell. Can be changed to 1 output value.

In addition, according to an embodiment of the present invention, the web-based spreadsheet service providing method, except for the at least one cell of the plurality of cells constituting the spreadsheet that is displayed through the browser in the client terminal When data insertion occurs in at least one additional cell among the remaining cells, additional editing information including row and column addresses of the at least one additional cell and data inserted in the at least one additional cell, from the client terminal. Receiving information and information on the at least one additional cell based on the additional edit information, wherein the information on the at least one additional cell includes data inserted into the at least one additional cell and the at least one At least one column address assigned to each additional cell) By grouping the row address assigned to my additional cells, each of the same line by line on the basis of it may further comprise the step of adding to the said list.

In this case, according to an embodiment of the present invention, when the data inserted into the first additional cell of the at least one additional cell is a function, the additional edit information includes information on the function inserted in the first additional cell; At least one second input cell referred to as an input value in the function inserted into the first additional cell, wherein the at least one second input cell is a cell included in the at least one cell and the at least one additional cell ) May further include information about row and column addresses.

In this case, the adding on the list may include information on a function inserted into the first additional cell and information on row and column addresses of the at least one second input cell on the additional edit information. If it is determined that the information on the function inserted into the first additional cell and the row address and column address of the at least one second input cell are matched with each other in the function information database with reference to the additional edit information. Storing the data inserted into the at least one second input cell by referring to information about a function inserted into the first additional cell and information about a row address and a column address of the at least one second input cell. Generating a second output value and inserting the second output value into the first additional cell on the list based on the second output value. The data to be is possible to include the step of including a second output value.

In this case, according to an embodiment of the present invention, in the web-based spreadsheet service providing method, when generation of the second output value is completed, information about the row address and the column address of the first additional cell and the second The method may further include transmitting a data update command for the first additional cell to the client terminal while transmitting an output value to the client terminal.

In this case, when the client terminal receives information on a row address and a column address of the first additional cell, the second output value, and a data update command for the first additional cell, the client terminal updates data for the first additional cell. According to the command, the first additional cell of the plurality of cells constituting the spreadsheet displayed on the screen through the browser with reference to the information on the row address and column address of the first additional cell to the first additional cell; 2 Output values can be inserted.

In the above, the method for providing a web-based spreadsheet service according to an embodiment of the present invention has been described with reference to FIG. 7. Here, since the web-based spreadsheet service providing method according to an embodiment of the present invention may correspond to the configuration of the operation of the web-based spreadsheet service providing apparatus 110 described with reference to FIGS. 1 to 6, Detailed description thereof will be omitted.

Web-based spreadsheet service providing method according to an embodiment of the present invention may be implemented as a computer program stored in a storage medium for execution in combination with a computer.

In addition, the web-based spreadsheet service providing method according to an embodiment of the present invention can be implemented in the form of program instructions that can be executed by various computer means may be recorded on a computer readable medium. The computer readable medium may include program instructions, data files, data structures, etc. alone or in combination. Program instructions recorded on the media may be those specially designed and constructed for the purposes of the present invention, or they may be of the kind well-known and available to those having skill in the computer software arts. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tape, optical media such as CD-ROMs, DVDs, and magnetic disks, such as floppy disks. Magneto-optical media, and hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, flash memory, and the like. Examples of program instructions include not only machine code generated by a compiler, but also high-level language code that can be executed by a computer using an interpreter or the like. The hardware device described above may be configured to operate as one or more software modules to perform the operations of the present invention, and vice versa.

In the present invention as described above has been described by the specific embodiments, such as specific components and limited embodiments and drawings, but this is provided to help a more general understanding of the present invention, the present invention is not limited to the above embodiments. For those skilled in the art, various modifications and variations are possible from these descriptions.

Therefore, the spirit of the present invention should not be limited to the described embodiments, and all the things that are equivalent to or equivalent to the claims as well as the following claims will belong to the scope of the present invention. .

Claims

Information on at least one cell in which data is inserted among a plurality of cells constituting the spreadsheet-The information on the at least one cell is assigned to each of the data inserted in the at least one cell and the at least one cell. Includes a column address, which is grouped in the same row unit based on a row address assigned to each of the at least one cell, and the list is a row address in which information about the at least one cell is grouped. Contains information about the cell database being stored; And

When the open command for the spreadsheet is received from the client terminal, the spreadsheet data transmission unit for extracting the data for the list from the cell database and transmits the data for the list to the client terminal

Including,

The client terminal

When the data for the list is received, the row address of the at least one cell grouped on the list is checked through a browser of the client terminal, and the information on the at least one cell included in the list. Extract a column address assigned to each of the at least one cell and data inserted into each of the at least one cell from the spreadsheet based on the identified row address, the extracted column address, and the extracted data Web-based spreadsheet service providing device for rendering a plurality of cells constituting the display on the screen.
The method of claim 1,

A row of cells in which data modification has occurred, from the client terminal, when modification occurs on the data inserted in the at least one cell among a plurality of cells constituting the spreadsheet displayed through the browser at the client terminal; An edit information receiver configured to receive correction edit information including changed data in an address, a column address, and a cell in which data has been modified; And

An update unit for updating information on the at least one cell included in the list stored in the cell database based on the received modified edit information

Web-based spreadsheet service providing device further comprising.
The method of claim 2,

When a function is inserted in a first cell of the at least one cell, at least one first input cell referred to as information about the function and an input value in the function, wherein the at least one first input cell is the at least Cell included in one cell-Function information database that stores information about row and column addresses of

More,

The update unit

When the correction edit information is received from the client terminal, the data according to the received correction edit information is referred to by referring to the information about the row address and the column address of the at least one first input cell stored in the function information database. An editing determination unit that determines whether a modification occurred in the at least one first input cell;

If it is determined that the modification of the data according to the received correction edit information occurred in the at least one first input cell, the information according to the received correction edit information is referred to by referring to the information on the function stored in the function information database. A function operation performing unit configured to generate a first output value by performing a function operation based on the change data of the at least one first input cell; And

A data changer configured to change data inserted into the first cell on the list to the first output value based on the first output value

Web-based spreadsheet service providing device comprising a.
The method of claim 3,

The spreadsheet data transmission unit

When the data inserted into the first cell is changed to the first output value, the first and second output values and information about the row address and column address of the first cell are transmitted to the client terminal. Update data transmission unit for transmitting a data update command for the cell to the client terminal

Including,

The client terminal

When information about a row address and a column address of the first cell, the first output value, and a data update command for the first cell are received, according to a data update command for the first cell, The data inserted in the first cell of the plurality of cells constituting the spreadsheet displayed on the screen through the browser by referring to the information about the row address and the column address is changed to the first output value. Web-based spreadsheet service provider.
The method of claim 3,

The edit information receiving unit

When data insertion occurs in at least one additional cell among the cells excluding the at least one cell among the plurality of cells constituting the spreadsheet displayed in the client terminal through the browser, from the client terminal, Receive additional edit information including row and column addresses of the at least one additional cell and data inserted into the at least one additional cell,

The update unit

Information on the at least one additional cell based on the additional edit information, wherein the information on the at least one additional cell is assigned to each of the data inserted in the at least one additional cell and the at least one additional cell. And a column address-to add on the list by grouping the same row units based on a row address assigned to each of the at least one additional cell.
The method of claim 5,

The additional edit information

When data inserted into a first additional cell of the at least one additional cell is a function, at least information referred to as an input value in a function inserted in the first additional cell and a function inserted in the first additional cell Further includes information about a row address and a column address of one second input cell, wherein the at least one second input cell is a cell included in the at least one cell and the at least one additional cell,

The update unit

If it is determined that the additional edit information includes information on a function inserted into the first additional cell and information on row and column addresses of the at least one second input cell, the additional edit information is referred to. A function information updater for storing information about a function inserted in the first additional cell and information on row and column addresses of the at least one second input cell in the function information database

More,

The function operation execution unit

A function based on data inserted into the at least one second input cell with reference to information about the function inserted into the first additional cell and information about the row address and column address of the at least one second input cell. By performing the operation, generating a second output value,

The data change unit

And a data to be inserted into the first additional cell on the list based on the second output value as the second output value.
The method of claim 6,

The update data transmission unit

When the generation of the second output value is completed, the data update command for the first additional cell is transmitted while the information on the row address and the column address of the first additional cell and the second output value are transmitted to the client terminal. Transmits to the client terminal,

The client terminal

When the data update command for the first additional cell and the information about the row address and the column address of the first additional cell are received, the first update is performed according to the data update command for the first additional cell. 1. The second output value is inserted into the first additional cell among a plurality of cells constituting the spreadsheet displayed on the screen through the browser by referring to the information about the row address and the column address of the additional cell. Web-based spreadsheet service provider.
Information on at least one cell in which data is inserted among a plurality of cells constituting the spreadsheet-The information on the at least one cell is assigned to each of the data inserted in the at least one cell and the at least one cell. Includes a column address, which is grouped in the same row unit based on the row address assigned to each of the at least one cell, and the list includes each row address where information about the at least one cell is grouped Maintain information about the cell database; And

If an open command for the spreadsheet is received from a client terminal, extracting data about the list from the cell database and transmitting data about the list to the client terminal.

Including,

The client terminal

When the data for the list is received, the row address of the at least one cell grouped on the list is checked through a browser of the client terminal, and the information on the at least one cell included in the list. Extract a column address assigned to each of the at least one cell and data inserted into each of the at least one cell from the spreadsheet based on the identified row address, the extracted column address, and the extracted data Web-based spreadsheet service providing method for rendering a plurality of cells constituting the display on the screen.
The method of claim 8,

A row of cells in which data modification has occurred, from the client terminal, when modification occurs on the data inserted in the at least one cell among a plurality of cells constituting the spreadsheet displayed through the browser at the client terminal; Receiving modification edit information including changed data in an address, a column address, and a cell in which data modification has occurred; And

Updating information on the at least one cell included in the list stored in the cell database based on the received modified edit information

Web-based spreadsheet service providing method comprising more.
The method of claim 9,

When a function is inserted in a first cell of the at least one cell, at least one first input cell referred to as information about the function and an input value in the function, wherein the at least one first input cell is the at least Maintaining a function information database in which information about row addresses and column addresses of a cell included in one cell are stored in correspondence with each other.

More,

The updating step

When the correction edit information is received from the client terminal, the data according to the received correction edit information is referred to by referring to the information about the row address and the column address of the at least one first input cell stored in the function information database. Determining whether a modification occurred in the at least one first input cell;

If it is determined that the modification of the data according to the received correction edit information occurred in the at least one first input cell, the information according to the received correction edit information is referred to by referring to the information on the function stored in the function information database. Generating a first output value by performing a function operation based on change data of the at least one first input cell; And

Changing the data inserted into the first cell on the list to the first output value based on the first output value

Web-based spreadsheet service providing method comprising a.
The method of claim 10,

When the data inserted into the first cell is changed to the first output value, the first and second output values and information about the row address and column address of the first cell are transmitted to the client terminal. Transmitting a data update command for a cell to the client terminal

More,

The client terminal

When information about a row address and a column address of the first cell, the first output value, and a data update command for the first cell are received, according to a data update command for the first cell, The data inserted in the first cell of the plurality of cells constituting the spreadsheet displayed on the screen through the browser by referring to the information about the row address and the column address is changed to the first output value. How to provide a web-based spreadsheet service.
The method of claim 10,

When data insertion occurs in at least one additional cell among the cells excluding the at least one cell among the plurality of cells constituting the spreadsheet displayed in the client terminal through the browser, from the client terminal, Receiving additional edit information including row and column addresses of the at least one additional cell and data inserted into the at least one additional cell; And

Information on the at least one additional cell based on the additional edit information, wherein the information on the at least one additional cell is assigned to each of the data inserted in the at least one additional cell and the at least one additional cell. Including column addresses-adding on the list by grouping them in the same row unit based on the row addresses assigned to each of the at least one additional cell

Web-based spreadsheet service providing method comprising more.
The method of claim 12,

The additional edit information

When data inserted into a first additional cell of the at least one additional cell is a function, at least information referred to as an input value in a function inserted in the first additional cell and a function inserted in the first additional cell Further includes information about a row address and a column address of one second input cell, wherein the at least one second input cell is a cell included in the at least one cell and the at least one additional cell,

Adding on the list

If it is determined that the additional edit information includes information on a function inserted into the first additional cell and information on row and column addresses of the at least one second input cell, the additional edit information is referred to. Storing information about a function inserted into the first additional cell and information about row addresses and column addresses of the at least one second input cell in the function information database;

A function based on data inserted into the at least one second input cell with reference to information about the function inserted into the first additional cell and information about the row address and column address of the at least one second input cell. Generating a second output value by performing an operation; And

Including data to be inserted into the first additional cell as the second output value on the list based on the second output value

Web-based spreadsheet service providing method comprising a.
The method of claim 13,

When the generation of the second output value is completed, the data update command for the first additional cell is transmitted while the information on the row address and the column address of the first additional cell and the second output value are transmitted to the client terminal. Transmitting to the client terminal

More,

The client terminal

When the data update command for the first additional cell and the information about the row address and the column address of the first additional cell are received, the first update is performed according to the data update command for the first additional cell. 1. The second output value is inserted into the first additional cell among a plurality of cells constituting the spreadsheet displayed on the screen through the browser by referring to the information about the row address and the column address of the additional cell. How to provide a web-based spreadsheet service.
A computer-readable recording medium having recorded thereon a program for performing the method of any one of claims 8-14.
A computer program stored in a storage medium for executing the method of any one of claims 8 to 14 in combination with a computer.